BeWoPlaner/ReportImp/NahDran/SettlementReport.cs

using System;
using System.Collections.Generic;
using System.Text;
using BeWo.Data.Access;
using BeWo.Data.Entities;
using BeWo.Report;
using BeWo.Report.ReportObjects;
using BS.Shared.DataContracts;

namespace NahDran.Alt
{
    public partial class Spitzabrechnung : DevExpress.XtraReports.UI.XtraReport, IBeWoReport<SettlementRO>
    {
        public Spitzabrechnung()
        {
            InitializeComponent();
        }

        public void SetReportDataSource(SettlementRO pRO)
        {
            StringBuilder sb = new StringBuilder();

            if (!String.IsNullOrEmpty(pRO.RecipientOrganisation))
            {
                sb.AppendLine(pRO.RecipientOrganisation);
            }
            if (!String.IsNullOrEmpty(pRO.RecipientContactPerson))
            {
                sb.AppendLine(pRO.RecipientContactPerson);
            }
            if (!String.IsNullOrEmpty(pRO.RecipientDivision))
            {
                sb.AppendLine(pRO.RecipientDivision);
            }
            if (!String.IsNullOrEmpty(pRO.RecipientStreet))
            {
                sb.AppendLine(pRO.RecipientStreet);
            }
            if (!String.IsNullOrEmpty(pRO.RecipientPostCodeAndTown))
            {
                sb.AppendLine(pRO.RecipientPostCodeAndTown);
            }
            lblAdresse.Text = sb.ToString();

            bool isDefaultSpitzabrechnung = false;

			
	        if (pRO.InvoiceItems != null && pRO.InvoiceItems.Count == 1)
	        {
		        var ii = pRO.InvoiceItems[0];
				if ((ii.ItemDescription == "Spitzabrechung" || ii.ItemDescription == "Spitzabrechnung") && ii.GrossAmountTotal == null && ii.RateFactor == null)
		        {
			        isDefaultSpitzabrechnung = true;
		        }
	        }
	        if (!isDefaultSpitzabrechnung)
	        {
		        if (pRO.DifferentHourlyRateCount > 0 && pRO.HourlyRateNew.HasValue)
		        {
			        isDefaultSpitzabrechnung = true;
		        }
	        }

            decimal gesamtStunden = 0;

	        if (isDefaultSpitzabrechnung)
	        {
		        //UpdateAbrechnungsFelder(pRO);

		        pRO.InvoiceItems = CreateDefaultSpitzabrechnungInvoiceItems(pRO);

	            gesamtStunden = (pRO.GeleisteteFLSMitStundensatz3 ?? 0) + (pRO.GeleisteteFLSMitStundensatzAktuell ?? 0) +
	                            (pRO.GeleisteteFLSMitStundensatzAlt ?? 0);

	        }
	        else
	        {
				var id = GetCustomerId(pRO);
				if (id == "LWLNEU")
				{
					pRO.RateFactorText = null;
					pRO.RateFactorText2 = null;

					if (pRO.InvoiceItems != null)
					{
						foreach (var ii in pRO.InvoiceItems)
						{
							ii.ItemDescription = String.Format("{0:dd.MM.yyyy} bis {1:dd.MM.yyyy}",
								ii.ItemPeriodStart, ii.ItemPeriodEnd);
						}
					}
				}
				else
				{
					if (pRO.InvoiceItems != null)
					{
						foreach (var ii in pRO.InvoiceItems)
						{
							//ii.ItemDescription = String.Format("{0:dd.MM.yyyy} bis {1:dd.MM.yyyy}: {2:0.##} FLS {3}x {4:c}",
							//	ii.ItemPeriodStart, ii.ItemPeriodEnd,
							//	ii.UnitCount, ii.RateFactor == 0 ? "" : "x " + pRO.RateFactorText2 + " ",
							//	ii.AmountPerUnit);
						    ii.ItemDescription = String.Format("{0:dd.MM.yyyy} bis {1:dd.MM.yyyy}",
						        ii.ItemPeriodStart, ii.ItemPeriodEnd);
                        }
					}
				}

	            if (pRO.InvoiceItems != null)
	            {
                    foreach (var ii in pRO.InvoiceItems)
                    {
                        gesamtStunden += ii.UnitCount ?? 0;
                    }

                }
            }

            lblGesamtStunden.Text = String.Format("{0:0.00}", gesamtStunden);
	        this.bindingSource1.DataSource = pRO;
        }

	    private String GetCustomerId(SettlementRO pRO)
	    {
		    var cb2sc = DAOFactory.GenericDAO.LoadByID<CostBearer2SupportConcept>(pRO.CostBearer2SupportConceptOid);
		    return cb2sc.CostBearer.ID;
	    }

		private IList<InvoiceItemDC> CreateDefaultSpitzabrechnungInvoiceItems(SettlementRO pRO)
		{
			IList<InvoiceItemDC> itemList = new List<InvoiceItemDC>();
			if (pRO.DifferentHourlyRateCount == 3)
			{
				itemList.Add(new InvoiceItemDC
				{
					ItemDescription = String.Format("{0} bis {1}", 
						pRO.AccountingStartDateString, pRO.HourlyRate3EndDateString),
                    UnitCount = pRO.GeleisteteFLSMitStundensatz3,
                    RateFactor = pRO.RateFactor,
                    AmountPerUnit = pRO.HourlyRate3,
                    GrossAmountTotal = pRO.GeleisteteFLSMitStundensatz3 * pRO.RateFactor * pRO.HourlyRate3
				});

				itemList.Add(new InvoiceItemDC
				{
					ItemDescription = String.Format("{0} bis {1}",
						pRO.HourlyRateOldStartDateString, pRO.HourlyRateOldEndDateString),
				    UnitCount = pRO.GeleisteteFLSMitStundensatzAlt,
				    RateFactor = pRO.RateFactor,
				    AmountPerUnit = pRO.HourlyRateOld,
                    GrossAmountTotal = pRO.GeleisteteFLSMitStundensatzAlt * pRO.RateFactor * pRO.HourlyRateOld
				});

				itemList.Add(new InvoiceItemDC
				{
					ItemDescription = String.Format("{0} bis {1}",
						pRO.HourlyRateNewStartDateString, pRO.AccountingEndDateString),
				    UnitCount = pRO.GeleisteteFLSMitStundensatzAktuell,
				    RateFactor = pRO.RateFactor,
				    AmountPerUnit = pRO.HourlyRateNew,
                    GrossAmountTotal = pRO.GeleisteteFLSMitStundensatzAktuell * pRO.RateFactor * pRO.HourlyRateNew
				});

			}
			else if (pRO.DifferentHourlyRateCount == 2)
			{
				itemList.Add(new InvoiceItemDC
				{
					ItemDescription = String.Format("{0} bis {1}",
						pRO.AccountingStartDateString, pRO.HourlyRateOldEndDateString),
				    UnitCount = pRO.GeleisteteFLSMitStundensatzAlt,
				    RateFactor = pRO.RateFactor,
				    AmountPerUnit = pRO.HourlyRateOld,
                    GrossAmountTotal = pRO.GeleisteteFLSMitStundensatzAlt * (decimal)pRO.RateFactor * pRO.HourlyRateOld
				});

				itemList.Add(new InvoiceItemDC
				{
					ItemDescription = String.Format("{0} bis {1}",
						pRO.HourlyRateNewStartDateString, pRO.AccountingEndDateString),
				    UnitCount = pRO.GeleisteteFLSMitStundensatzAktuell,
				    RateFactor = pRO.RateFactor,
				    AmountPerUnit = pRO.HourlyRateNew,
                    GrossAmountTotal = pRO.GeleisteteFLSMitStundensatzAktuell * pRO.RateFactor * pRO.HourlyRateNew
				});

			}
			else
			{
				itemList.Add(new InvoiceItemDC
				{
					ItemDescription = String.Format("{0} bis {1}",
						pRO.AccountingStartDateString, pRO.AccountingEndDateString),
				    UnitCount = pRO.GeleisteteFLSMitStundensatzAktuell,
				    RateFactor = pRO.RateFactor,
				    AmountPerUnit = pRO.HourlyRateNew,
                    GrossAmountTotal = pRO.GeleisteteFLSMitStundensatzAktuell * pRO.RateFactor * pRO.HourlyRateNew
				});

			}

			return itemList;
		}

		private void UpdateAbrechnungsFelder(SettlementRO pRO)
		{
			if (pRO.DifferentHourlyRateCount == 3)
			{
				//Erbrachte Leistungen (FLS) - bis [HourlyRateOldEndDateString] <20> [HourlyRateOldString] <20>

				pRO.Abrechnungstext1 = String.Format("{0} bis {1}",
					pRO.AccountingStartDateString, pRO.HourlyRate3EndDateString);

				pRO.Abrechnungstext1 += String.Format(": {0:0.##} FLS {1}x {2:c}",
					pRO.GeleisteteFLSMitStundensatz3, pRO.RateFactor == 1 ? "" : "x " + pRO.RateFactorText2 + " ", pRO.HourlyRate3);

				//[AccountingStartDateString] - [HourlyRate3EndDateString] sind [RecordedFLSWithHourlyRate3String] Std. x [HourlyRate3String] <20> =";

				pRO.Betrag1 = String.Format("{0:c}", pRO.GeleisteteFLSMitStundensatz3 * (decimal)pRO.RateFactor * pRO.HourlyRate3);


				pRO.Abrechnungstext2 = String.Format("{0} bis {1}",
					pRO.HourlyRateOldStartDateString, pRO.HourlyRateOldEndDateString);
				pRO.Abrechnungstext2 += String.Format(": {0:0.##} FLS {1}x {2:c}",
					pRO.GeleisteteFLSMitStundensatzAlt, pRO.RateFactor == 1 ? "" : "x " + pRO.RateFactorText2 + " ", pRO.HourlyRateOld);

				pRO.Betrag2 = String.Format("{0:c}", pRO.GeleisteteFLSMitStundensatzAlt * (decimal)pRO.RateFactor * pRO.HourlyRateOld);


				pRO.Abrechnungstext3 = String.Format("{0} bis {1}",
					pRO.HourlyRateNewStartDateString, pRO.AccountingEndDateString);
				pRO.Abrechnungstext3 += String.Format(": {0:0.##} FLS {1}x {2:c}",
					pRO.GeleisteteFLSMitStundensatzAktuell, pRO.RateFactor == 1 ? "" : "x " + pRO.RateFactorText2 + " ", pRO.HourlyRateNew);

				pRO.Betrag3 = String.Format("{0:c}", pRO.GeleisteteFLSMitStundensatzAktuell * (decimal)pRO.RateFactor * pRO.HourlyRateNew);
			}
			else if (pRO.DifferentHourlyRateCount == 2)
			{

				pRO.Abrechnungstext2 = String.Format("{0} bis {1}",
					pRO.AccountingStartDateString, pRO.HourlyRateOldEndDateString);
				pRO.Abrechnungstext2 += String.Format(": {0:0.##} FLS {1}x {2:c}",
					pRO.GeleisteteFLSMitStundensatzAlt, pRO.RateFactor == 1 ? "" : "x " + pRO.RateFactorText2 + " ", pRO.HourlyRateOld);

				pRO.Betrag2 = String.Format("{0:c}", pRO.GeleisteteFLSMitStundensatzAlt * (decimal)pRO.RateFactor * pRO.HourlyRateOld);


				pRO.Abrechnungstext3 = String.Format("{0} bis {1}",
					pRO.HourlyRateNewStartDateString, pRO.AccountingEndDateString);
				pRO.Abrechnungstext3 += String.Format(": {0:0.##} FLS {1}x {2:c}",
					pRO.GeleisteteFLSMitStundensatzAktuell, pRO.RateFactor == 1 ? "" : "x " + pRO.RateFactorText2 + " ", pRO.HourlyRateNew);

				pRO.Betrag3 = String.Format("{0:c}", pRO.GeleisteteFLSMitStundensatzAktuell * (decimal)pRO.RateFactor * pRO.HourlyRateNew);
			}
			else
			{
				pRO.Abrechnungstext3 = String.Format("{0} bis {1}",
					pRO.AccountingStartDateString, pRO.AccountingEndDateString);
				pRO.Abrechnungstext3 += String.Format(": {0:0.##} FLS {1}x {2:c}",
					pRO.GeleisteteFLSMitStundensatzAktuell, pRO.RateFactor == 1 ? "" : "x " + pRO.RateFactorText2 + " ", pRO.HourlyRateNew);

				pRO.Betrag3 = String.Format("{0:c}", pRO.GeleisteteFLSMitStundensatzAktuell * (decimal)pRO.RateFactor * pRO.HourlyRateNew);
			}
		}
    }
}