/// <summary>
/// Frontend Page: Report(lot inspection fee invoice)
/// Title:load details of lot inspection fee invoice
/// Deigned:Piyumi Perera
/// User story:
/// Developed:Piyumi Perera
/// Date created:
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int loanId = 0;
//assign fee type
string feeType = "lotInspectionFee";
//check selected loan id is not empty and assign to variable
if (Request.QueryString["loanId"] != "")
loanId = Convert.ToInt32(Request.QueryString["loanId"]);
//check selected start date is not empty and assign to variable
if (string.IsNullOrEmpty(Request.QueryString["startDate"])) return;
var startDate = DateTime.ParseExact(Request.QueryString["startDate"], "MM/dd/yyyy", CultureInfo.InvariantCulture);
//check selected end date is not empty and assign to variable
if (string.IsNullOrEmpty(Request.QueryString["endDate"])) return;
var endDate = DateTime.ParseExact(Request.QueryString["endDate"], "MM/dd/yyyy", CultureInfo.InvariantCulture);
ReportAccess ra = new ReportAccess();
//get all lot inspection details which match with the given date range
List<RptFee> lotInspectionFeeInvoice = ra.GetFeeInvoiceByDateRange(loanId, feeType, startDate, endDate);
//check list count is>0
if(lotInspectionFeeInvoice.Count>0)
{
//load report
RenderReport(loanId, startDate, endDate, feeType, lotInspectionFeeInvoice);
Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowFrame", "ShowDive();", true);
}
else
{
//show no data found message
Page.ClientScript.RegisterStartupScript(this.GetType(), "HideFrame", "HideDive();", true);
}
}
}
/// <summary>
/// Frontend Page: Report page(Advance Fee invoice Report)
/// Title: Display Advance Fee invoice
/// Designed: Kasun Samarawickrama
/// User story:
/// Developed: Kasun Samarawickrama
/// Date created:
/// </summary>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int loanId = 0;
string feeType = "advanceFee"; //Report type
//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 Advance Fee invoice details during time period
ReportAccess ra = new ReportAccess();
List<RptFee> advanceFeeInvoice = ra.GetFeeInvoiceByDateRange(loanId, feeType, startDate, endDate);
//if result count is greater then zero show report, otherwise give a message
if (advanceFeeInvoice.Count > 0)
{
//call RenderReport function to show report on report viwer
RenderReport(loanId, startDate, endDate,feeType, advanceFeeInvoice);
Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowFrame", "ShowDive();", true);
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "HideFrame", "HideDive();", true);
}
}
}
/// <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 page(Advance Fee invoice Report)
/// Title: Display Advance Fee invoice
/// Designed: Kasun Samarawickrama
/// User story:
/// Developed: Kasun Samarawickrama
/// 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"];
ReportViewer rptViewerAdvanceFeeInvoicePrint = new ReportViewer();
rptViewerAdvanceFeeInvoicePrint.ProcessingMode = ProcessingMode.Local;
rptViewerAdvanceFeeInvoicePrint.Reset();
rptViewerAdvanceFeeInvoicePrint.LocalReport.EnableExternalImages = true;
rptViewerAdvanceFeeInvoicePrint.LocalReport.ReportPath = Server.MapPath("~/Reports/RptAdvanceFeeInvoice.rdlc");
//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");
}
//Get Advance Fee invoice details during time period
List<RptFee> advanceFeeInvoice = ra.GetFeeInvoiceByDateRange(loanId, "advanceFee", startDate, endDate);
//Set data set to report
rptViewerAdvanceFeeInvoicePrint.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", details));
rptViewerAdvanceFeeInvoicePrint.LocalReport.DataSources.Add(new ReportDataSource("DataSet2", advanceFeeInvoice));
//return reportviwer
return rptViewerAdvanceFeeInvoicePrint;
}
