BeWoPlaner/ReportImp/ChristopherusHaus/CustomReportCreator.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using BeWo.Data.Access;
using BeWo.Data.Entities;
using BeWo.Report;
using BeWo.Report.DefaultReports;
using BeWo.Report.ReportObjects;
using BeWo.Service.DCEntityMapper;
using BS.Shared.Core;
using BS.Shared.DataContracts;
using DevExpress.XtraReports.Design;
using DevExpress.XtraReports.UI;

namespace ChristopherusHaus
{
    public class CustomReportCreator : DefaultReportCreator
    {

        public override XtraReport CreateQueryReport(long queryOid, string queryReportId)
        {
            if (queryOid == 500)
            {
                return CreateLwlPruefliste(CreateQueryRO(queryOid, queryReportId));
            }
            return base.CreateQueryReport(queryOid, queryReportId);
        }

        private LwlPruefliste CreateLwlPruefliste(QueryRO queryRo)
        {
            var liste = new LwlPruefliste();

            if (queryRo.Rows.Count > 0)
            {
                DateTime start = DateTime.MaxValue;
                DateTime end = DateTime.MinValue;

                if (queryRo.Rows[0].Field1 != null)
                {
                    DateTime.TryParse(queryRo.Rows[0].Field1.ToString(), out start);
                }
                if (queryRo.Rows[0].Field2 != null)
                {
                    DateTime.TryParse(queryRo.Rows[0].Field2.ToString(), out end);
                }
                long? customerOid = null;
                string zad = "";
                if (queryRo.Rows[0].Field3.ToString() == "0")
                {
                    var masterReport = new LwlPruefliste();
                    var customerList = DAOFactory.GenericDAO.GetAllActive<Customer>();
                    var customerListOrd = customerList.OrderBy(c => c.Person.LastNameFirstName).ToList();
                    foreach (var c in customerListOrd)
                    {
                        zad = GetCustomerTeam(c);
                        var ro = LwlPrueflisteRO.Create(start, end, zad, c.Oid, "LWL");
                        if (ro.ServiceRecords != null && ro.ServiceRecords.Count > 0)
                        {
                            try
                            {
                                liste = new LwlPruefliste();
                                liste.SetReportDataSource(ro);
                                liste.CreateDocument();
                                masterReport.Pages.AddRange(liste.Pages);
                            }
                            catch
                            {
                                // ignore - z.B. kein Hilfeplan
                            }
                        }
                    }
                    return (LwlPruefliste)masterReport;
                }

                if (queryRo.Rows[0].Field3 != null)
                {
                    if (Int64.TryParse(queryRo.Rows[0].Field3.ToString(), out var oidOut))
                    {
                        customerOid = oidOut;
                    }
                    var c = DAOFactory.GenericDAO.LoadByID<Customer>(customerOid.Value);
                    zad = GetCustomerTeam(c);
                    var ro = LwlPrueflisteRO.Create(start, end, zad, c.Oid, "LWL");
                    liste.SetReportDataSource(ro);
                    return liste;
                }
            }
            return liste;
        }

        private string GetCustomerTeam(Customer c)
        {
            string zad = "";
            var team = c.Team2CustomerList.FirstOrDefault();
            if (team.Team.Name.ToLower().Contains("bochum"))
            {
                zad = "60-9011096.1";
            }
            else if (team.Team.Name.ToLower().Contains("dortmund") || team.Team.Name.ToLower().Contains("königsmühle"))
            {
                zad = "60-9011063.1";
            }
            else if (team.Team.Name.ToLower().Contains("witten"))
            {
                zad = "60-9011071.1";
            }
            return zad;
        }

        public override XtraReport CreateSettlementReport(string dcId, long? invoiceBaseOid)
        {
            long result;
            Settlement2DC lSettlementDC;
            string cbName;
            if (invoiceBaseOid.HasValue && invoiceBaseOid.Value > 0)
            {
                long invoiceOid = invoiceBaseOid.Value;
                var ib = DAOFactory.GenericDAO.LoadByID<InvoiceBase>(invoiceOid);
                cbName = ib.CostBearer2SupportConcept.CostBearer.Organisation.Name;
            }

            else
            {
                Int64.TryParse(dcId, out result);
                lSettlementDC = MapperFactory.SettlementDC_SettlementInvoice.MapToNewDC(DAOFactory.GenericDAO.LoadByID<SettlementInvoice>(result));
                cbName = lSettlementDC.RecipientOrganisation;
            }

            if (cbName.Contains("Landschaftsverband Westfalen-Lippe") || cbName.Contains("LWL"))
                return CreateSettlementReport(dcId, invoiceBaseOid, true);

            return base.CreateSettlementReport(dcId, invoiceBaseOid, false);
        }

        public override XtraReport CreateSettlementReport(String dcId, long? invoiceBaseOid, bool createAnhang)
        {
            XtraReport report = null;
            String reportId = null;
            var lSettlementDC = GetSettlementDC(dcId, invoiceBaseOid);

            if (lSettlementDC.CostBearer2SupportConceptOid.HasValue)
            {
                CostBearer2SupportConcept c2s = DAOFactory.GenericDAO.LoadByID<CostBearer2SupportConcept>(lSettlementDC.CostBearer2SupportConceptOid.Value);
                reportId = c2s.CostBearer.ID;
            }

            if (lSettlementDC.DifferentHourlyRateCount > 0)
            {
                IBeWoReport<SettlementRO> lSettlementReport = FindReportImp<SettlementRO>(reportId);
                var ro = SettlementRO.Create(lSettlementDC);
                lSettlementReport.SetReportDataSource(ro);

                report = lSettlementReport as XtraReport;
            }
            else
            {
                IBeWoReport<Settlement2RO> lSettlementReport = FindReportImp<Settlement2RO>(reportId);
                lSettlementReport.SetReportDataSource(Settlement2RO.Create(lSettlementDC));
                report = lSettlementReport as XtraReport;
            }

            if (createAnhang)
            {
                if (report != null)
                {
                    report.CreateDocument();
                    if (reportId != null && reportId == "LWLDigga" && lSettlementDC.AccountingPeriodEnd.HasValue && lSettlementDC.AccountingPeriodEnd > new DateTime(2025, 09, 30))
                    {
                        var anhang = CreateBudgetnachweisDiggiAnhang(lSettlementDC);
                        if (anhang != null)
                        {
                            anhang.CreateDocument();
                            report.Pages.AddRange(anhang.Pages);
                        }
                    }
                    else
                    {
                        var anhang = CreateBudgetnachweisAnhang(lSettlementDC);
                        if (anhang != null)
                        {
                            anhang.CreateDocument();
                            report.Pages.AddRange(anhang.Pages);
                        }
                    }
                }
            }
            return report;
        }
    }
}