/// <summary>
// Frontend Page: Report page(Branch Summary report)
/// Title: Display Branch Summary report
/// Designed: Piyumi Perera
/// User story:
/// Developed: Piyumi Perera
/// Date created:
/// </summary>
public void RenderReport(int branchId,string branchName, List<RptBranchSummary> branchSummary)
{
//check authentication session is null, if null return
if (Session["AuthenticatedUser"] == null) return;
User userData = (User)Session["AuthenticatedUser"];
//set reportviewr properties
rptViewerBranchSummary.ProcessingMode = ProcessingMode.Local;
rptViewerBranchSummary.Reset();
rptViewerBranchSummary.LocalReport.EnableExternalImages = true;
rptViewerBranchSummary.LocalReport.ReportPath = Server.MapPath("~/Reports/RptBranchSummary.rdlc");
rptViewerBranchSummary.ZoomMode = ZoomMode.PageWidth;
ReportAccess ra = new ReportAccess();
User usr = new User();
usr = (new UserAccess()).retreiveUserByUserId(userData.UserId);
List<LoanDetailsRpt> details = new List<LoanDetailsRpt>();
LoanDetailsRpt detail = new LoanDetailsRpt();
detail.CompanyName = userData.CompanyName;
if (userData.RoleId == 1)
{
detail.LenderBrnchName = branchName;
}
else
{
detail.LenderBrnchName = userData.BranchName;
}
detail.ReportDate = DateTime.Now.ToString("MM/dd/yyyy");
detail.CreaterName = usr.FirstName + " " + usr.LastName;
details.Add(detail);
rptViewerBranchSummary.LocalReport.DataSources.Add(new ReportDataSource("DataSet2", details));
foreach (var dates in details)
{
dates.ReportDate = DateTime.Now.ToString("MM/dd/yyyy");
}
rptViewerBranchSummary.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", branchSummary));
}
public List<LoanDetailsRpt> GetLoanDetailsRptforCompanySummary(int companyId, int userId)
{
List<LoanDetailsRpt> loanDetails = new List<LoanDetailsRpt>();
DataHandler dataHandler = new DataHandler();
List<object[]> paramertList = new List<object[]>();
paramertList.Add(new object[] { "@user_id", userId });
paramertList.Add(new object[] { "@company_id", companyId });
DataSet dataSet = dataHandler.GetDataSet("spGetLoanDetailsByLoanIdRpts_CompanySummary", paramertList);
if (dataSet != null && dataSet.Tables.Count != 0)
{
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
LoanDetailsRpt details = new LoanDetailsRpt();
details.CreaterName = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(dataRow["first_name"] + " " + dataRow["last_name"]);
details.CompanyName = dataRow["company_name"].ToString();
details.ReportDate = DateTime.Now.ToString("MM/dd/yyyy");
loanDetails.Add(details);
break;
}
}
return loanDetails;
}
public List<LoanDetailsRpt> GetLoanDetailsRpt(int loanId, int userId)
{
List<LoanDetailsRpt> loanDetails = new List<LoanDetailsRpt>();
DataHandler dataHandler = new DataHandler();
List<object[]> paramertList = new List<object[]>();
paramertList.Add(new object[] { "@user_id", userId });
paramertList.Add(new object[] { "@loan_id", loanId });
DataSet dataSet = dataHandler.GetDataSet("spGetLoanDetailsByLoanIdRpts", paramertList);
if (dataSet != null && dataSet.Tables.Count != 0)
{
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
LoanDetailsRpt details = new LoanDetailsRpt();
details.CreaterName = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(dataRow["first_name"] + " " + dataRow["last_name"]);
details.LenderBrnchName = dataRow["branch_name"].ToString();
details.DealerBrnchName = dataRow["nr_branch_name"].ToString();
details.LoanNumber = dataRow["loan_number"].ToString();
loanDetails.Add(details);
break;
}
}
return loanDetails;
}