private byte[] RunReportToPdf(List <LevyRollDataItem> data, List <SundryDataItem> sundries, DateTime dDate, string building) { string rdlcPath = "Astrodon.Reports.LevyRoll.LevyRollReport.rdlc"; byte[] report = null; Dictionary <string, IEnumerable> reportData = new Dictionary <string, IEnumerable>(); Dictionary <string, string> reportParams = new Dictionary <string, string>(); string period = dDate.ToString("MMM yyyy"); reportParams.Add("BuildingName", building); reportParams.Add("Period", period); reportData.Add("LevyRollMain", data); reportData.Add("dsLevySundries", sundries); if (sundries.Count > 0) { reportParams.Add("IncludeSundries", "true"); } else { reportParams.Add("IncludeSundries", "false"); } using (RdlcHelper rdlcHelper = new RdlcHelper(rdlcPath, reportData, reportParams)) { rdlcHelper.Report.EnableExternalImages = true; report = rdlcHelper.GetReportAsFile(); } return(report); }
private byte[] RunReportToPdf(DateTime dDate, string building, string agent, List <TOCDataItem> tocDataItems) { string rdlcPath = "Astrodon.Reports.ManagementReportCoverPage.ManagementReportCoverPageReport.rdlc"; byte[] report = null; Dictionary <string, IEnumerable> reportData = new Dictionary <string, IEnumerable>(); Dictionary <string, string> reportParams = new Dictionary <string, string>(); string period = dDate.ToString("MMM yyyy"); reportParams.Add("BuildingName", building); reportParams.Add("Period", period); reportParams.Add("AgentName", agent); reportParams.Add("Created", DateTime.Now.ToString("yyyy-MM-dd HH:mm")); reportData.Add("dsTocItems", tocDataItems); using (RdlcHelper rdlcHelper = new RdlcHelper(rdlcPath, reportData, reportParams)) { rdlcHelper.Report.EnableExternalImages = true; report = rdlcHelper.GetReportAsFile(); } return(report); }
private byte[] RunReportToPdf(List <SupplierReportDataItem> data, DateTime fromDate, DateTime toDate) { string rdlcPath = "Astrodon.Reports.SupplierReport.SupplierReport.rdlc"; byte[] report = null; Dictionary <string, IEnumerable> reportData = new Dictionary <string, IEnumerable>(); Dictionary <string, string> reportParams = new Dictionary <string, string>(); string period = fromDate.ToString("MMM yyyy") + " - " + toDate.ToString("MMM yyyy"); reportParams.Add("Period", period); reportData.Add("SupplierData", data); using (RdlcHelper rdlcHelper = new RdlcHelper(rdlcPath, reportData, reportParams)) { rdlcHelper.Report.EnableExternalImages = true; report = rdlcHelper.GetReportAsFile(); } return(report); }
private byte[] RunReportToPdf(List <MaintenanceReportDataItem> data, DateTime startDate, DateTime endDate, string buildingName, bool detailedReport) { string rdlcPath = "Astrodon.Reports.MaintenanceReport.MaintenanceReport.rdlc"; byte[] report = null; Dictionary <string, IEnumerable> reportData = new Dictionary <string, IEnumerable>(); Dictionary <string, string> reportParams = new Dictionary <string, string>(); string period = startDate.ToString("MMM yyyy") + " - " + endDate.ToString("MMM yyyy"); reportParams.Add("Period", period); reportParams.Add("BuildingName", buildingName); reportParams.Add("DetailedReport", detailedReport ? "true" : "false"); reportData.Add("MaintenanceReport", data); using (RdlcHelper rdlcHelper = new RdlcHelper(rdlcPath, reportData, reportParams)) { rdlcHelper.Report.EnableExternalImages = true; report = rdlcHelper.GetReportAsFile(); } return(report); }
public byte[] RunReport(int buildingId) { var building = _context.tblBuildings.Include(a => a.InsuranceBroker).Single(a => a.id == buildingId); var buildingUnits = _context.BuildingUnitSet.Where(a => a.BuildingId == buildingId && a.SquareMeters > 0).ToList(); var reportDataSet = buildingUnits.Select(a => new InsuranceScheduleDataItem() { Unit = a.UnitNo, PQPersentage = (a.PQRating * 100).ToString(), AdditionalCost = a.AdditionalInsurance.ToString(), UnitCost = (building.UnitReplacementCost * a.PQRating).ToString(), TotalCost = ((building.UnitReplacementCost * a.PQRating) + a.AdditionalInsurance).ToString(), Notes = a.Notes }); Dictionary <string, IEnumerable> reportData = new Dictionary <string, IEnumerable>(); Dictionary <string, string> reportParams = new Dictionary <string, string>(); reportParams.Add("Created", DateTime.Now.ToShortDateString()); reportParams.Add("BuildingName", building.Building); reportParams.Add("Address1", building.addy1); reportParams.Add("Address2", building.addy2); reportParams.Add("Address3", building.addy3); reportParams.Add("Address4", building.addy4); reportParams.Add("Address5", building.addy5); reportParams.Add("Trust", building.bank); reportParams.Add("Bank", building.bankName); reportParams.Add("AccountName", building.accName); reportParams.Add("AccountNumber", building.bankAccNumber); reportParams.Add("BranchCode", building.branch); reportParams.Add("ExcessStructures", building.ExcessStructures); reportParams.Add("BrokerAccountNumber", building.PolicyNumber); if (building.InsuranceBroker != null) { reportParams.Add("BrokerCompany", building.InsuranceBroker.CompanyName); reportParams.Add("BrokerName", building.InsuranceBroker.ContactPerson); reportParams.Add("BrokerTel", building.InsuranceBroker.ContactNumber); reportParams.Add("BrokerEmail", building.InsuranceBroker.EmailAddress); } reportParams.Add("CommonPropertyDimension", building.CommonPropertyDimensions.ToString()); if (building.CommonPropertyReplacementCost > 0 && !building.InsuranceReplacementValueIncludesCommonProperty) { reportParams.Add("CommonReplacementValue", building.CommonPropertyReplacementCost.ToString("#,##0.00")); } else { if (building.InsuranceReplacementValueIncludesCommonProperty) { reportParams.Add("CommonReplacementValue", "Included in Replacement Value"); } } reportParams.Add("UnitPropertyDimension", building.UnitPropertyDimensions.ToString()); string replacementString = building.UnitReplacementCost.ToString("#,##0.00"); reportParams.Add("UnitReplacementValue", replacementString); reportData.Add("dsInsuranceData", reportDataSet); string rdlcPath = "Astrodon.Reports.InsuranceSchedule.InsuranceScheduleReport.rdlc"; byte[] report = null; using (RdlcHelper rdlcHelper = new RdlcHelper(rdlcPath, reportData, reportParams)) { rdlcHelper.Report.EnableExternalImages = true; report = rdlcHelper.GetReportAsFile(); } return(report); }
public byte[] RunReport(int requisitionBatchId, string sqlConnectionString) { try { var batch = _context.RequisitionBatchSet.Include(a => a.Building).Single(a => a.id == requisitionBatchId); var building = batch.Building; var reportDataSet = (from r in _context.tblRequisitions.Include(a => a.Supplier) where r.RequisitionBatchId == batch.id select new RequisitionBatchReportDataItem() { Created = r.trnDate, Bank = r.BankName, BranchCode = r.BranchCode, AccountNumber = r.AccountNumber, SupplierName = r.Supplier != null ? r.Supplier.CompanyName : r.contractor, LedgerAccount = r.ledger, Amount = r.amount, SupplierReference = r.payreference, InvoiceNumber = r.InvoiceNumber, UseNedbankCSV = r.UseNedbankCSV == null ? false : r.UseNedbankCSV.Value }).ToList().OrderBy(a => a.CSVDescription).ThenBy(a => a.Created).ToList(); int x = 1; foreach (var r in reportDataSet) { r.Number = x; if (!String.IsNullOrWhiteSpace(building.AccNumber)) { if (building.AccNumber.Length > 4) { r.TrustAccount = "(" + building.AccNumber.Substring(0, 4) + ")"; } else { r.TrustAccount = "(" + building.AccNumber + ")"; } } else { r.TrustAccount = ""; } r.Abbr = building.Code; x++; } Dictionary <string, IEnumerable> reportData = new Dictionary <string, IEnumerable>(); Dictionary <string, string> reportParams = new Dictionary <string, string>(); reportParams.Add("BatchNumber", batch.Building.Code.ToString() + "-" + batch.BatchNumber.ToString().PadLeft(6, '0')); reportParams.Add("Created", batch.Created.ToString("yyyy/MM/dd", CultureInfo.InvariantCulture)); reportParams.Add("BuildingName", batch.Building.Building); reportParams.Add("Address1", batch.Building.addy1); reportParams.Add("Address2", batch.Building.addy2); reportParams.Add("Address3", batch.Building.addy3); reportParams.Add("Address4", batch.Building.addy4); reportParams.Add("Address5", batch.Building.addy5); reportParams.Add("Trust", batch.Building.bank); reportParams.Add("Bank", batch.Building.bankName); reportParams.Add("AccountName", batch.Building.accName); reportParams.Add("AccountNumber", batch.Building.bankAccNumber); reportParams.Add("BranchCode", batch.Building.branch); reportData.Add("dsReportData", reportDataSet); string rdlcPath = "Astrodon.Reports.RequisitionBatch.RequisitionReport.rdlc"; byte[] report = null; using (RdlcHelper rdlcHelper = new RdlcHelper(rdlcPath, reportData, reportParams)) { rdlcHelper.Report.EnableExternalImages = true; report = rdlcHelper.GetReportAsFile(); } return(report); } catch (Exception e) { using (var dc = new DataContext(sqlConnectionString)) { dc.SystemLogSet.Add(new Data.Log.SystemLog() { EventTime = DateTime.Now, Message = "RequisitionBatchReport: " + e.Message + e.InnerException != null ? " Inner: " + e.InnerException.Message : string.Empty, StackTrace = e.StackTrace + e.InnerException != null ? " Inner: " + e.InnerException.StackTrace : string.Empty }); dc.SaveChanges(); } throw e; } }