/// <summary> /// Frontend Page: Report Page(Advance Unit Report) /// Title: Display Advance Units /// Designed: Kanishka SHM /// User story: /// Developed: Kanishka SHM /// Date created: /// </summary> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int loanId = 0; //if session is not null and assign it. 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", CultureInfo.InvariantCulture); if (string.IsNullOrEmpty(Request.QueryString["endDate"])) return; var endDate = DateTime.ParseExact(Request.QueryString["endDate"], "MM/dd/yyyy", CultureInfo.InvariantCulture); //Get all advance units during time period ReportAccess ra = new ReportAccess(); List<ReportFullInventoryUnit> units = ra.GetAdvanceUnitByLoanId(loanId, startDate, endDate); //if units count is greater then zero show report, otherwise give a message if (units.Count > 0) { //call RenderReport function to show report on report viwer RenderReport(loanId, startDate, endDate, units); Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowFrame", "ShowDive();", true); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "HideFrame", "HideDive();", true); } } }
/// <summary> /// Frontend Page: Report Page(Advance Unit Report) /// Title: Display Advance Units print page /// Designed: Kanishka SHM /// User story: /// Developed: Kanishka SHM /// Date created: /// </summary> public ReportViewer PrintPage(int loanId, DateTime startDate, DateTime endDate) { //Check authentication session is null then return if (Session["AuthenticatedUser"] == null) return null; User userData = (User)Session["AuthenticatedUser"]; //create reportviwer & set reportviewr properties ReportViewer rptViewerAdvanceUnitRptPrint = new ReportViewer(); rptViewerAdvanceUnitRptPrint.ProcessingMode = ProcessingMode.Local; rptViewerAdvanceUnitRptPrint.Reset(); rptViewerAdvanceUnitRptPrint.LocalReport.EnableExternalImages = true; rptViewerAdvanceUnitRptPrint.LocalReport.ReportPath = Server.MapPath("~/Reports/RptAdvanceReport.rdlc"); rptViewerAdvanceUnitRptPrint.ZoomMode = ZoomMode.PageWidth; //Get account details ReportAccess ra = new ReportAccess(); List<LoanDetailsRpt> details = ra.TopHeaderDetails(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 set to report rptViewerAdvanceUnitRptPrint.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", details)); List<ReportFullInventoryUnit> units = ra.GetAdvanceUnitByLoanId(loanId, startDate, endDate); rptViewerAdvanceUnitRptPrint.LocalReport.DataSources.Add(new ReportDataSource("DataSet2", units)); //return reportviwer return rptViewerAdvanceUnitRptPrint; }