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 void ReportGrid_Load(object sender, EventArgs e)
{
if (DataSet != null)
{
DataSet.DataSetName = TableName;
Stream rdlc = RdlcHelper.BuildRDLCStream(
DataSet, TableName, Resources.report);
reportView.LocalReport.LoadReportDefinition(rdlc);
reportView.LocalReport.DataSources.Clear();
reportView.LocalReport.DataSources.Add(
new ReportDataSource(DataSet.DataSetName, DataSet.Tables[0]));
reportView.RefreshReport();
}
}
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 void ReportGrid_Load(object sender, EventArgs e)
{
if (DataSet != null)
{
DataSet.DataSetName = TableName;
var rdlc = RdlcHelper.BuildRDLCStream(
DataSet, TableName, Resources.report);
//Fix for VS "15" permission issue
var permissionSet = new PermissionSet(PermissionState.Unrestricted);
var fIOPermission = new FileIOPermission(PermissionState.None);
fIOPermission.AllLocalFiles = FileIOPermissionAccess.Read;
permissionSet.AddPermission(fIOPermission);
permissionSet.AddPermission(new SecurityPermission(SecurityPermissionFlag.Execution));
reportView.LocalReport.SetBasePermissionsForSandboxAppDomain(permissionSet);
reportView.LocalReport.LoadReportDefinition(rdlc);
reportView.LocalReport.DataSources.Clear();
reportView.LocalReport.DataSources.Add(
new ReportDataSource(DataSet.DataSetName, DataSet.Tables[0]));
reportView.RefreshReport();
}
}
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;
}
}
