ownSoft/BeWoPlaner
1
1
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
master
BeWoPlaner/ReportImp/AutismusLeben/SettlementReport.cs

325 lines
15 KiB
C#
Raw Permalink Blame History

using System;
using System.Collections.Generic;
using System.Drawing;
using System.Linq;
using BeWo.Data.Access;
using BeWo.Data.Entities;
using BeWo.Report;
using BeWo.Report.ReportObjects;
using BeWo.Service.ServiceImplementations;
using BS.Shared.Core;
using BS.Shared.DataContracts;
using DevExpress.XtraReports.UI;
namespace AutismusLeben.Alt
{
public partial class Spitzabrechnung : DevExpress.XtraReports.UI.XtraReport, IBeWoReport<SettlementRO>
{
public Spitzabrechnung()
{
InitializeComponent();
}
public void SetReportDataSource(SettlementRO pRO)
{
bool isDefaultSpitzabrechnung = false;
if (String.IsNullOrEmpty(pRO.Notice))
{
//lblNotice.Visible = false;
}
if (pRO.InvoiceNumber.Length > 2)
pRO.InvoiceNumber = String.Format("3{0:MM}{0:yy}0{1}", pRO.AccountingEndDate, pRO.InvoiceNumber);
else
pRO.InvoiceNumber = String.Format("3{0:MM}{0:yy}00{1}", pRO.AccountingEndDate, pRO.InvoiceNumber);
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;
}
}
if (isDefaultSpitzabrechnung)
{
//UpdateAbrechnungsFelder(pRO);
pRO.InvoiceItems = CreateDefaultSpitzabrechnungInvoiceItems(pRO);
}
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}: {2:0.##} FLS x {3:c}",
ii.ItemPeriodStart, ii.ItemPeriodEnd, ii.UnitCount, ii.AmountPerUnit);
}
}
}
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);
}
}
}
}
var os = new OperationsServiceImp();
var span = new DateTimeSpan(pRO.AccountingStartDate, pRO.InvoiceDateTime.Value);
var abschlagszahlungen = os.GetAccountingTransactions(span, null, pRO.CostBearer2SupportConceptOid);
Dictionary<string, decimal> gruppierteAbschlagszahlungen = GruppiereAbschlagszahlungen(pRO, abschlagszahlungen);
var rowCounter = 0;
while (rowCounter < gruppierteAbschlagszahlungen.Count)
{
if (rowCounter == 0)
{
table_Abschlagszahlungen.Rows.RemoveAt(0);
var row = new XRTableRow();
row.HeightF = 25.33f;
var baseCell0 = new XRTableCell() { Padding = 2, TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft, BorderColor = Color.Black, Borders = DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom, WidthF = 51.75f, HeightF = 25.33f };
var baseCell1 = new XRTableCell() { Padding = 2, TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft, BorderColor = Color.Black, Borders = DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom, WidthF = 537.5f, HeightF = 25.33f };
var baseCell2 = new XRTableCell() { Padding = 2, TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight, BorderColor = Color.Black, Borders = DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom, WidthF = 99.17f, HeightF = 25.33f };
baseCell0.Text = (rowCounter + 1).ToString();
baseCell1.Text = gruppierteAbschlagszahlungen.ElementAt(0).Key;
baseCell2.Text = string.Format("{0:c}", gruppierteAbschlagszahlungen.ElementAt(0).Value);
row.Cells.Add(baseCell0);
row.Cells.Add(baseCell1);
row.Cells.Add(baseCell2);
table_Abschlagszahlungen.Rows.Add(row);
rowCounter++;
}
else
{
for (rowCounter = rowCounter; rowCounter < gruppierteAbschlagszahlungen.Count; rowCounter++)
{
var row = new XRTableRow();
var baseCell0 = new XRTableCell() { Padding = 2, TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft, BorderColor = Color.Black, Borders = DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom, WidthF = 51.75f, HeightF = 25.33f };
var baseCell1 = new XRTableCell() { Padding = 2, TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft, BorderColor = Color.Black, Borders = DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom, WidthF = 537.5f, HeightF = 25.33f };
var baseCell2 = new XRTableCell() { Padding = 2, TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight, BorderColor = Color.Black, Borders = DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom, WidthF = 97.75f, HeightF = 25.33f };
baseCell0.Text = (rowCounter + 1).ToString();
baseCell1.Text = gruppierteAbschlagszahlungen.ElementAt(rowCounter).Key;
baseCell2.Text = string.Format("{0:c}", gruppierteAbschlagszahlungen.ElementAt(rowCounter).Value);
row.Cells.Add(baseCell0);
row.Cells.Add(baseCell1);
row.Cells.Add(baseCell2);
table_Abschlagszahlungen.Rows.Add(row);
}
}
}
var claimAsDecimal = pRO.Claim.Split(' ');
if (Convert.ToDecimal(claimAsDecimal[0]) >= 0)
tc_RueckzahlungOderRestbetrag.Text = "Restbetrag";
else
tc_RueckzahlungOderRestbetrag.Text = "Rückzahlung";
lblSchlusssatz.Text = string.Format("Zahlbar bis {0:dd.MM.yyyy} ohne Abzug.\nUmsatzsteuerfrei gemäß §4 Nr. 18 UStG.", pRO.InvoiceDateTime.Value.AddDays(14));
this.bindingSource1.DataSource = pRO;
}
private Dictionary<string, decimal> GruppiereAbschlagszahlungen(SettlementRO pRO, List<AccountingTransactionDC> abschlagszahlungen)
{
var invoiceItems = pRO.InvoiceItems;
var accountingStartDate = pRO.AccountingStartDate;
var accountingEndDate = pRO.AccountingEndDate;
DateTime? letztesEnde = null;
Dictionary<string, decimal> gruppierteAbschlagszahlungen = new Dictionary<string, decimal>();
if (pRO.HourlyRate3 != 0)
{
var zahlungenBisErstemStundensatzWechsel = abschlagszahlungen.Where(a => a.BookingDate <= pRO.HourlyRateEndDate3).ToList();
decimal summe = 0.0m;
foreach (var zahlung in zahlungenBisErstemStundensatzWechsel)
summe += zahlung.Amount;
var zeitraum = string.Format("Abschlagszahlung bis {0:dd.MM.yyyy} ", pRO.HourlyRateEndDate3);
gruppierteAbschlagszahlungen.Add(zeitraum, summe);
}
if (pRO.HourlyRateOld != 0)
{
List<AccountingTransactionDC> zahlungen = new List<AccountingTransactionDC>();
if (pRO.HourlyRate3 == 0)
zahlungen = abschlagszahlungen.Where(a => a.BookingDate <= pRO.HourlyRateOldEndDate).ToList();
else
zahlungen = abschlagszahlungen.Where(a => a.BookingDate > pRO.HourlyRateEndDate3 && a.BookingDate <= pRO.HourlyRateOldEndDate).ToList();
decimal summe = 0.0m;
foreach (var zahlung in zahlungen)
summe += zahlung.Amount;
var zeitraum = pRO.HourlyRate3 == 0 ? string.Format("Abschlagszahlung bis {0:dd.MM.yyyy} ", pRO.HourlyRateOldEndDate) : string.Format("Abschlagszahlung {0:dd.MM.yyyy} - {1:dd.MM.yyyy}", pRO.HourlyRateEndDate3.Value.AddDays(1), pRO.HourlyRateOldEndDate);
gruppierteAbschlagszahlungen.Add(zeitraum, summe);
}
if (pRO.HourlyRateNew != 0)
{
List<AccountingTransactionDC> zahlungen = new List<AccountingTransactionDC>();
if (pRO.HourlyRateOld == 0)
zahlungen = abschlagszahlungen;
else
zahlungen = abschlagszahlungen.Where(a => a.BookingDate > pRO.HourlyRateOldEndDate).ToList();
decimal summe = 0.0m;
foreach (var zahlung in zahlungen)
summe += zahlung.Amount;
var zeitraum = pRO.HourlyRateOld == 0 ? string.Format("Abschlagszahlung ab {0:dd.MM.yyyy} ", pRO.AccountingStartDate) : string.Format("Abschlagszahlung ab {0:dd.MM.yyyy}", pRO.HourlyRateOldEndDate.Value.AddDays(1));
gruppierteAbschlagszahlungen.Add(zeitraum, summe);
}
return gruppierteAbschlagszahlungen;
}
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()
{
UnitCount = pRO.GeleisteteFLSMitStundensatz3,
ItemDescription = "Fachleistungsstunden x " + string.Format("{0:0.00}", pRO.RateFactor) + " (" + pRO.HourlyRate3StartDateString + " - " + pRO.HourlyRate3EndDateString + ")",
AmountPerUnit = pRO.HourlyRate3,
GrossAmountTotal = pRO.GeleisteteFLSMitStundensatz3 * pRO.RateFactor * pRO.HourlyRate3
});
itemList.Add(new InvoiceItemDC()
{
UnitCount = pRO.GeleisteteFLSMitStundensatzAlt,
ItemDescription = "Fachleistungsstunden x " + string.Format("{0:0.00}", pRO.RateFactor) + " (" + pRO.HourlyRateOldStartDateString + " - " + pRO.HourlyRateOldEndDateString + ")",
AmountPerUnit = pRO.HourlyRateOld,
GrossAmountTotal = pRO.GeleisteteFLSMitStundensatzAlt * pRO.RateFactor * pRO.HourlyRateOld
});
itemList.Add(new InvoiceItemDC()
{
UnitCount = pRO.GeleisteteFLSMitStundensatzAktuell,
ItemDescription = "Fachleistungsstunden x " + string.Format("{0:0.00}", pRO.RateFactor) + " (ab " + pRO.HourlyRateNewStartDateString + ")",
AmountPerUnit = pRO.HourlyRateNew,
GrossAmountTotal = pRO.GeleisteteFLSMitStundensatzAktuell * pRO.RateFactor * pRO.HourlyRateNew
});
}
else if (pRO.DifferentHourlyRateCount == 2)
{
itemList.Add(new InvoiceItemDC()
{
UnitCount = pRO.GeleisteteFLSMitStundensatzAlt,
ItemDescription = "Fachleistungsstunden x " + string.Format("{0:0.00}", pRO.RateFactor) + " (bis " + pRO.HourlyRateOldEndDateString + ")",
AmountPerUnit = pRO.HourlyRateOld,
GrossAmountTotal = pRO.GeleisteteFLSMitStundensatzAlt * (decimal)pRO.RateFactor * pRO.HourlyRateOld
});
itemList.Add(new InvoiceItemDC()
{
UnitCount = pRO.GeleisteteFLSMitStundensatzAktuell,
ItemDescription = "Fachleistungsstunden x " + string.Format("{0:0.00}", pRO.RateFactor) + " (ab " + pRO.HourlyRateNewStartDateString + ")",
AmountPerUnit = pRO.HourlyRateNew,
GrossAmountTotal = pRO.GeleisteteFLSMitStundensatzAktuell * pRO.RateFactor * pRO.HourlyRateNew
});
}
else
{
itemList.Add(new InvoiceItemDC()
{
UnitCount = pRO.GeleisteteFLSMitStundensatzAktuell,
ItemDescription = "Fachleistungsstunden x " + string.Format("{0:0.00}", pRO.RateFactor) + " (ab " + pRO.HourlyRateNewStartDateString + ")",
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] à [HourlyRateOldString] €
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] € =";
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);
}
}
}
}
Reference in New Issue View Git Blame Copy Permalink