/*
Frontend page: Report Page
Title: Load details to report and show on browser
Designed: Kanishka SHM
User story:
Developed: Kanishka SHM
Date created:
*/
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int loanId = 0;
if (Request.QueryString["loanId"] != "")
loanId = Convert.ToInt32(Request.QueryString["loanId"]);
if (string.IsNullOrEmpty(Request.QueryString["startDate"])) return;
var startDate = DateTime.ParseExact(Request.QueryString["startDate"], "MM/dd/yyyy", new CultureInfo("en-US"));
if (string.IsNullOrEmpty(Request.QueryString["endDate"])) return;
var endDate = DateTime.ParseExact(Request.QueryString["endDate"], "MM/dd/yyyy", new CultureInfo("en-US"));
ReportAccess ra = new ReportAccess();
//get unit payoff details
List<ReportPayOff> payOffUnits = ra.GetPayOffDetailsByLoanId(loanId, startDate, endDate);
if(payOffUnits.Count>0)
{
RenderReport(loanId, startDate, endDate, payOffUnits);
Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowFrame", "ShowDive();", true);
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "HideFrame", "HideDive();", true);
}
}
}
/*
Frontend page: Report Page
Title: Load details to report and show on browser
Designed: Kanishka SHM
User story:
Developed: Kanishka SHM
Date created:
*/
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"];
//set report viewr property dynamically
ReportViewer rptViewerPayOffPrint = new ReportViewer();
rptViewerPayOffPrint.ProcessingMode = ProcessingMode.Local;
rptViewerPayOffPrint.Reset();
rptViewerPayOffPrint.LocalReport.EnableExternalImages = true;
rptViewerPayOffPrint.LocalReport.ReportPath = Server.MapPath("~/Reports/RptPayOff.rdlc");
//get report header details
ReportAccess ra = new ReportAccess();
List<LoanDetailsRpt> details = ra.TopHeaderDetails(loanId, userData.UserId);
//add dates, date range and current date
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");
}
//get unit payoff details
List<ReportPayOff> curtailments = ra.GetPayOffDetailsByLoanId(loanId, startDate, endDate);
//set data source to report viwer
rptViewerPayOffPrint.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", details));
rptViewerPayOffPrint.LocalReport.DataSources.Add(new ReportDataSource("DataSet2", curtailments));
//return report viwer
return rptViewerPayOffPrint;
}