/// <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;
}