/// <summary>
/// Frontend Page: Report(lot inspection fee receipt)
/// Title:load details of paid lot inspection fee
/// Deigned:Piyumi Perera
/// User story:
/// Developed:Piyumi Perera
/// Date created:
/// </summary>
/// <param name="loanId"></param>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <param name="lotInspectionFee"></param>
public void RenderReport(int loanId, DateTime startDate, DateTime endDate, List<RptFee> lotInspectionFee)
{
//check authentication session is null, if null return
if (Session["AuthenticatedUser"] == null) return;
User userData = (User)Session["AuthenticatedUser"];
rptViewerLotInspectionFeeReceipt.ProcessingMode = ProcessingMode.Local;
rptViewerLotInspectionFeeReceipt.Reset();
rptViewerLotInspectionFeeReceipt.LocalReport.EnableExternalImages = true;
rptViewerLotInspectionFeeReceipt.LocalReport.ReportPath = Server.MapPath("~/Reports/RptLotInspectionFeeReceipt.rdlc");
rptViewerLotInspectionFeeReceipt.ZoomMode = ZoomMode.PageWidth;
ReportAccess ra = new ReportAccess();
//get loan details of selected loan
List<LoanDetailsRpt> details = ra.GetLoanDetailsRpt(loanId, userData.UserId);
foreach (var dates in details)
{
//assign date fields values
dates.StartRange = startDate.ToString("MM/dd/yyyy");
dates.EndRange = endDate.ToString("MM/dd/yyyy");
dates.ReportDate = DateTime.Now.ToString("MM/dd/yyyy");
}
//add data sources
rptViewerLotInspectionFeeReceipt.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", details));
rptViewerLotInspectionFeeReceipt.LocalReport.DataSources.Add(new ReportDataSource("DataSet2", lotInspectionFee));
}
/// <summary>
/// Frontend Page: Report Page(Loan Summary Report)
/// Title: Display Loan Summary Report
/// Designed: Kasun Samarawickrama
/// User story:
/// Developed: Kasun Samarawickrama
/// Date created:
/// </summary>
public void RenderReport(int loanId, DateTime startDate, DateTime endDate, List<RptLoanSummary> loanSummaryList)
{
//check authentication session is null, if null return
if (Session["AuthenticatedUser"] == null) return;
User userData = (User)Session["AuthenticatedUser"];
//set report viewr property dynamically
rptViewerLoanSummary.ProcessingMode = ProcessingMode.Local;
rptViewerLoanSummary.Reset();
rptViewerLoanSummary.LocalReport.EnableExternalImages = true;
rptViewerLoanSummary.LocalReport.ReportPath = Server.MapPath("~/Reports/RptLoanSummary.rdlc");
rptViewerLoanSummary.ZoomMode = ZoomMode.PageWidth;
//Get account details
ReportAccess ra = new ReportAccess();
List<LoanDetailsRpt> details = ra.GetLoanDetailsRpt(loanId, userData.UserId);
foreach (var dates in details)
{
dates.StartRange = startDate.ToString("MM/dd/yyyy");
dates.EndRange = endDate.ToString("MM/dd/yyyy");
dates.ReportDate = DateTime.Now.ToString("MM/dd/yyyy");
}
//set data source to report viwer
rptViewerLoanSummary.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", details));
rptViewerLoanSummary.LocalReport.DataSources.Add(new ReportDataSource("DataSet2", loanSummaryList));
}
/// <summary>
/// Frontend Page: Report(lot inspection fee invoice)
/// Title:print lot inspection fee invoice report
/// Deigned:Piyumi Perera
/// User story:
/// Developed:Piyumi Perera
/// Date created:
/// </summary>
/// <param name="loanId"></param>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <returns></returns>
public ReportViewer PrintPage(int loanId, DateTime startDate, DateTime endDate)
{
//check authentication session is null, if null return
if (Session["AuthenticatedUser"] == null) return null;
User userData = (User)Session["AuthenticatedUser"];
ReportViewer rptViewerLotInspectionFeeInvoicePrint = new ReportViewer();
rptViewerLotInspectionFeeInvoicePrint.ProcessingMode = ProcessingMode.Local;
rptViewerLotInspectionFeeInvoicePrint.Reset();
rptViewerLotInspectionFeeInvoicePrint.LocalReport.EnableExternalImages = true;
rptViewerLotInspectionFeeInvoicePrint.LocalReport.ReportPath = Server.MapPath("~/Reports/RptLotInspectionFeeInvoice.rdlc");
ReportAccess ra = new ReportAccess();
//get loan details of selected loan
List<LoanDetailsRpt> details = ra.GetLoanDetailsRpt(loanId, userData.UserId);
foreach (var dates in details)
{
//assign date fields
dates.StartRange = startDate.ToString("MM/dd/yyyy");
dates.EndRange = endDate.ToString("MM/dd/yyyy");
dates.ReportDate = DateTime.Now.ToString("MM/dd/yyyy");
}
//get lot inspection fee details which match with the given date range
List<RptFee> lotInspectionFeeInvoice = ra.GetFeeInvoiceByDateRange(loanId, "lotInspectionFee", startDate, endDate);
//add data sources
rptViewerLotInspectionFeeInvoicePrint.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", details));
rptViewerLotInspectionFeeInvoicePrint.LocalReport.DataSources.Add(new ReportDataSource("DataSet2", lotInspectionFeeInvoice));
return rptViewerLotInspectionFeeInvoicePrint;
}
/// <summary>
/// Frontend Page: Report(monthly loan fee receipt)
/// Title:print monthly loan fee receipt report
/// Deigned:Piyumi Perera
/// User story:
/// Developed:Piyumi Perera
/// Date created:
/// </summary>
/// <param name="loanId"></param>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <returns></returns>
public ReportViewer PrintPage(int loanId, DateTime startDate, DateTime endDate)
{
//check authentication session is null, if null return
if (Session["AuthenticatedUser"] == null) return null;
User userData = (User)Session["AuthenticatedUser"];
ReportViewer rptViewerMonthlyLoanFeeReceiptPrint = new ReportViewer();
rptViewerMonthlyLoanFeeReceiptPrint.ProcessingMode = ProcessingMode.Local;
rptViewerMonthlyLoanFeeReceiptPrint.Reset();
rptViewerMonthlyLoanFeeReceiptPrint.LocalReport.EnableExternalImages = true;
rptViewerMonthlyLoanFeeReceiptPrint.LocalReport.ReportPath = Server.MapPath("~/Reports/RptMonthlyLoanFeeReceipt.rdlc");
ReportAccess ra = new ReportAccess();
//get loan details of selected loan
List<LoanDetailsRpt> details = ra.GetLoanDetailsRpt(loanId, userData.UserId);
foreach (var dates in details)
{
//assign date fields values
dates.StartRange = startDate.ToString("MM/dd/yyyy");
dates.EndRange = endDate.ToString("MM/dd/yyyy");
dates.ReportDate = DateTime.Now.ToString("MM/dd/yyyy");
}
//get details of paid monthly loan fees
List<RptFee> curtailments = ra.GetFeeReceiptByDateRange(loanId, "monthlyLoanFee", startDate, endDate);
//add data sources
rptViewerMonthlyLoanFeeReceiptPrint.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", details));
rptViewerMonthlyLoanFeeReceiptPrint.LocalReport.DataSources.Add(new ReportDataSource("DataSet2", curtailments));
return rptViewerMonthlyLoanFeeReceiptPrint;
}