public void bindReport()
{
try
{
string name = "";
try
{
usersTableAdapters.GetUserNameTableAdapter user = new usersTableAdapters.GetUserNameTableAdapter();
users.GetUserNameDataTable tblUser = user.GetUserName(MySessionManager.CurrentUser.UserID);
name = tblUser[0].name.ToString();
}
catch (Exception ex) { }
this.rvLargestExposure.Visible = true;
this.ObjectDataSource1.SelectParameters["category"].DefaultValue = ddlCategory.SelectedValue;
this.ObjectDataSource1.SelectParameters["CMID"].DefaultValue = ddlct.SelectedValue;
this.ObjectDataSource1.SelectParameters["BranchID"].DefaultValue = ddlBranch.SelectedValue;
this.ObjectDataSource1.SelectParameters["Type"].DefaultValue = ddlPerformance.SelectedValue;
this.ObjectDataSource1.SelectParameters["top"].DefaultValue = txtTop.Text;
ReportParameter rp1 = new ReportParameter("Report_Date", DateTime.Now.ToString("dd-MM-yyyy"));
ReportParameter rp3 = new ReportParameter("Report_top", txtTop.Text);
ReportParameter rp2 = new ReportParameter("Report_Generator", name);
rvLargestExposure.LocalReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3 });
this.rvLargestExposure.DataBind();
this.rvLargestExposure.LocalReport.Refresh();
}
catch (Exception ex) { }
}
public void bindReport()
{
try
{
string name = "";
try
{
usersTableAdapters.GetUserNameTableAdapter user = new usersTableAdapters.GetUserNameTableAdapter();
users.GetUserNameDataTable tblUser = user.GetUserName(MySessionManager.CurrentUser.UserID);
name = tblUser[0].name.ToString();
}
catch (Exception ex) { }
this.rvScheduledPayment.Visible = true;
// fetch the en-GB culture
CultureInfo ukCulture = new CultureInfo("en-GB");
// pass the DateTimeFormat information to DateTime.Parse
DateTime FromDT = DateTime.Parse(txtFromDT.Text, ukCulture.DateTimeFormat);
DateTime ToDT = DateTime.Parse(txtToDT.Text, ukCulture.DateTimeFormat);
this.ObjectDataSource1.SelectParameters["BranchID"].DefaultValue = ddlBranch.SelectedValue;
this.ObjectDataSource1.SelectParameters["CMID"].DefaultValue = ddlct.SelectedValue;
this.ObjectDataSource1.SelectParameters["startDate"].DefaultValue = FromDT.ToShortDateString();
this.ObjectDataSource1.SelectParameters["endDate"].DefaultValue = ToDT.ToShortDateString();
ReportParameter rp1 = new ReportParameter("Report_Date", DateTime.Now.ToString("dd-MM-yyyy"));
ReportParameter rp3 = new ReportParameter("fromDate", txtFromDT.Text);
ReportParameter rp4 = new ReportParameter("toDate", txtToDT.Text);
ReportParameter rp2 = new ReportParameter("Report_Generator", name);
rvScheduledPayment.LocalReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3, rp4 });
rvScheduledPayment.DataBind();
rvScheduledPayment.LocalReport.Refresh();
}
catch (Exception ex) { }
}
public void bindReport()
{
try
{
string name = "";
try
{
usersTableAdapters.GetUserNameTableAdapter user = new usersTableAdapters.GetUserNameTableAdapter();
users.GetUserNameDataTable tblUser = user.GetUserName(MySessionManager.CurrentUser.UserID);
name = tblUser[0].name.ToString();
}
catch (Exception ex) { }
this.rvLargestExposure.Visible = true;
this.ObjectDataSource1.SelectParameters["category"].DefaultValue = ddlCategory.SelectedValue;
this.ObjectDataSource1.SelectParameters["CMID"].DefaultValue = ddlct.SelectedValue;
this.ObjectDataSource1.SelectParameters["BranchID"].DefaultValue = ddlBranch.SelectedValue;
this.ObjectDataSource1.SelectParameters["Type"].DefaultValue = ddlPerformance.SelectedValue;
this.ObjectDataSource1.SelectParameters["top"].DefaultValue = txtTop.Text;
ReportParameter rp1 = new ReportParameter("Report_Date", DateTime.Now.ToString("dd-MM-yyyy"));
ReportParameter rp3 = new ReportParameter("Report_top", txtTop.Text);
ReportParameter rp2 = new ReportParameter("Report_Generator", name);
rvLargestExposure.LocalReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3});
this.rvLargestExposure.DataBind();
this.rvLargestExposure.LocalReport.Refresh();
}
catch (Exception ex) { }
}
public void loadAdvise()
{
usersTableAdapters.GetUserNameTableAdapter user = new usersTableAdapters.GetUserNameTableAdapter();
InvestmentDSTableAdapters.GetAdviseTableAdapter advise = new InvestmentDSTableAdapters.GetAdviseTableAdapter();
InvestmentDS.GetAdviseDataTable tblAdvise = advise.GetAdvise(MySessionManager.InvAppID, MySessionManager.ClientID);
if (tblAdvise.Rows.Count > 0)
{
foreach (InvestmentDS.GetAdviseRow r in tblAdvise)
{
//txtDescription.Value = tblAdvise[0].datDescription.ToString();
HtmlGenericControl myp = new HtmlGenericControl("p");
HtmlGenericControl mypMessage = new HtmlGenericControl("blockquote");
HtmlGenericControl myDiv = new HtmlGenericControl("div");
myDiv.Attributes["class"] = " col-md-12 alert alert-info";
myDiv.Style["padding"] = "4px";
myp.InnerHtml = "<h5><span> Stage:" + r.datStage.ToString() + "</span><br/><i> <b> " + user.Getuser(r.userID).ToString() + "</b>'s comment on " + r.modifiedDate.ToLongDateString() + "</i></h5>"
+ "<hr style='margin:3px'/>";
mypMessage.Attributes["class"] = "text-justify";
mypMessage.InnerHtml = "<p>" + r.datDescription.ToString() + "</p>";
Literal myLine = new Literal();
myLine.Text = "<hr style='margin:3px'/><br/>";
myDiv.Controls.Add(myp);
myDiv.Controls.Add(myLine);
myDiv.Controls.Add(mypMessage);
myDiv.Controls.Add(myLine);
this.Comments.Controls.Add(myDiv);
}
}
}
public void bindReport()
{
try
{
this.rvAging.Visible = true;
// fetch the en-GB culture
CultureInfo ukCulture = new CultureInfo("en-GB");
// pass the DateTimeFormat information to DateTime.Parse
DateTime fromDT = DateTime.Parse(txtDate.Text, ukCulture.DateTimeFormat);
string dt = fromDT.ToShortDateString();
// ShowMessageBox(dt);
string name = "";
try
{
usersTableAdapters.GetUserNameTableAdapter user = new usersTableAdapters.GetUserNameTableAdapter();
users.GetUserNameDataTable tblUser = user.GetUserName(MySessionManager.CurrentUser.UserID);
name = tblUser[0].name.ToString();
}
catch (Exception ex) { }
this.ObjectDataSource1.SelectParameters["date"].DefaultValue = dt;
this.ObjectDataSource1.SelectParameters["category"].DefaultValue = ddlCategory.SelectedValue.ToString();
this.ObjectDataSource1.SelectParameters["Type"].DefaultValue = ddlPerformance.SelectedValue.ToString();
this.ObjectDataSource1.SelectParameters["BranchID"].DefaultValue = ddlBranch.SelectedValue.ToString();
this.ObjectDataSource1.SelectParameters["CMID"].DefaultValue = ddlct.SelectedValue.ToString();
ReportParameter rp1 = new ReportParameter("Report_Date", DateTime.Now.ToString("dd-MM-yyyy"));
ReportParameter rp3 = new ReportParameter("date", txtDate.Text);
ReportParameter rp2 = new ReportParameter("Report_Generator", name);
rvAging.LocalReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3 });
rvAging.DataBind();
this.rvAging.LocalReport.Refresh();
}
catch (Exception ex) { }
}
private void bindReport()
{
try
{
string name = "";
try
{
usersTableAdapters.GetUserNameTableAdapter user = new usersTableAdapters.GetUserNameTableAdapter();
users.GetUserNameDataTable tblUser = user.GetUserName(MySessionManager.CurrentUser.UserID);
name = tblUser[0].name.ToString();
}
catch (Exception ex) { }
this.rvPortfolioSummary.Visible = true;
// fetch the en-GB culture
CultureInfo ukCulture = new CultureInfo("en-GB");
// pass the DateTimeFormat information to DateTime.Parse
DateTime dt = DateTime.Parse(txtDate.Text, ukCulture.DateTimeFormat);
this.ObjectDataSource1.SelectParameters["BranchID"].DefaultValue = ddlBranch.SelectedValue;
this.ObjectDataSource1.SelectParameters["CMID"].DefaultValue = ddlct.SelectedValue;
this.ObjectDataSource1.SelectParameters["date"].DefaultValue = dt.ToShortDateString();
ReportParameter rp1 = new ReportParameter("Report_Date", DateTime.Now.ToString("dd-MM-yyyy"));
ReportParameter rp3 = new ReportParameter("date", txtDate.Text);
ReportParameter rp2 = new ReportParameter("Report_Generator", name);
rvPortfolioSummary.LocalReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3 });
this.rvPortfolioSummary.DataBind();
this.rvPortfolioSummary.LocalReport.Refresh();
}
catch (Exception ex) { }
//throw new NotImplementedException();
}
public void loadAdvise()
{
usersTableAdapters.GetUserNameTableAdapter user = new usersTableAdapters.GetUserNameTableAdapter();
InvestmentDSTableAdapters.GetAdviseTableAdapter advise = new InvestmentDSTableAdapters.GetAdviseTableAdapter();
InvestmentDS.GetAdviseDataTable tblAdvise =advise.GetAdvise(MySessionManager.InvAppID, MySessionManager.ClientID);
if (tblAdvise.Rows.Count > 0)
{
foreach (InvestmentDS.GetAdviseRow r in tblAdvise)
{
//txtDescription.Value = tblAdvise[0].datDescription.ToString();
HtmlGenericControl myp = new HtmlGenericControl("p");
HtmlGenericControl mypMessage = new HtmlGenericControl("blockquote");
HtmlGenericControl myDiv = new HtmlGenericControl("div");
myDiv.Attributes["class"] = " col-md-12 alert alert-info";
myDiv.Style["padding"] = "4px";
myp.InnerHtml = "<h5><span> Stage:" + r.datStage.ToString() + "</span><br/><i> <b> " + user.Getuser(r.userID).ToString() +"</b>'s comment on " + r.modifiedDate.ToLongDateString() + "</i></h5>"
+ "<hr style='margin:3px'/>";
mypMessage.Attributes["class"] = "text-justify";
mypMessage.InnerHtml = "<p>" + r.datDescription.ToString() + "</p>";
Literal myLine = new Literal();
myLine.Text = "<hr style='margin:3px'/><br/>";
myDiv.Controls.Add(myp);
myDiv.Controls.Add(myLine);
myDiv.Controls.Add(mypMessage);
myDiv.Controls.Add(myLine);
this.Comments.Controls.Add(myDiv);
}
}
}
protected void btnViewReport_Click(object sender, EventArgs e)
{
try
{
this.rvClientMovement.Visible = true;
// fetch the en-GB culture
CultureInfo ukCulture = new CultureInfo("en-GB");
// pass the DateTimeFormat information to DateTime.Parse
DateTime fromDT = DateTime.Parse(txtFromDT.Text, ukCulture.DateTimeFormat);
DateTime toDT = DateTime.Parse(txtToDT.Text, ukCulture.DateTimeFormat);
string name = "";
try
{
usersTableAdapters.GetUserNameTableAdapter user = new usersTableAdapters.GetUserNameTableAdapter();
users.GetUserNameDataTable tblUser = user.GetUserName(MySessionManager.CurrentUser.UserID);
name = tblUser[0].name.ToString();
}
catch (Exception ex) { }
this.ObjectDataSource1.SelectParameters["FromDT"].DefaultValue = fromDT.ToShortDateString();
this.ObjectDataSource1.SelectParameters["ToDT"].DefaultValue = toDT.ToShortDateString();
this.ObjectDataSource1.SelectParameters["BranchID"].DefaultValue = ddlBranch.SelectedValue.ToString();
this.ObjectDataSource1.SelectParameters["CMID"].DefaultValue = ddlct.SelectedValue.ToString();
ReportParameter rp1 = new ReportParameter("Report_Date", DateTime.Now.ToString("dd-MM-yyyy"));
ReportParameter rp2 = new ReportParameter("Report_Generator", name);
rvClientMovement.LocalReport.SetParameters(new ReportParameter[] { rp1, rp2 });
rvClientMovement.DataBind();
this.rvClientMovement.LocalReport.Refresh();
}
catch (Exception ex) { }
}
protected void btnViewReport_Click(object sender, EventArgs e)
{
try
{
this.rvClientMovement.Visible = true;
// fetch the en-GB culture
CultureInfo ukCulture = new CultureInfo("en-GB");
// pass the DateTimeFormat information to DateTime.Parse
DateTime fromDT = DateTime.Parse(txtFromDT.Text, ukCulture.DateTimeFormat);
DateTime toDT = DateTime.Parse(txtToDT.Text, ukCulture.DateTimeFormat);
string name = "";
try
{
usersTableAdapters.GetUserNameTableAdapter user = new usersTableAdapters.GetUserNameTableAdapter();
users.GetUserNameDataTable tblUser = user.GetUserName(MySessionManager.CurrentUser.UserID);
name = tblUser[0].name.ToString();
}
catch (Exception ex) { }
this.ObjectDataSource1.SelectParameters["FromDT"].DefaultValue = fromDT.ToShortDateString();
this.ObjectDataSource1.SelectParameters["ToDT"].DefaultValue = toDT.ToShortDateString();
this.ObjectDataSource1.SelectParameters["BranchID"].DefaultValue = ddlBranch.SelectedValue.ToString();
this.ObjectDataSource1.SelectParameters["CMID"].DefaultValue = ddlct.SelectedValue.ToString();
ReportParameter rp1 = new ReportParameter("Report_Date", DateTime.Now.ToString("dd-MM-yyyy"));
ReportParameter rp2 = new ReportParameter("Report_Generator", name);
rvClientMovement.LocalReport.SetParameters(new ReportParameter[] { rp1, rp2 });
rvClientMovement.DataBind();
this.rvClientMovement.LocalReport.Refresh();
}
catch (Exception ex) { }
}
public void bindReport()
{
try
{
string name = "";
try
{
usersTableAdapters.GetUserNameTableAdapter user = new usersTableAdapters.GetUserNameTableAdapter();
users.GetUserNameDataTable tblUser = user.GetUserName(MySessionManager.CurrentUser.UserID);
name = tblUser[0].name.ToString();
}
catch (Exception ex) { }
this.rvPII.Visible = true;
// fetch the en-GB culture
CultureInfo ukCulture = new CultureInfo("en-GB");
// pass the DateTimeFormat information to DateTime.Parse
DateTime fromDT = DateTime.Parse(txtFromDT.Text, ukCulture.DateTimeFormat);
DateTime toDT = DateTime.Parse(txtToDT.Text, ukCulture.DateTimeFormat);
this.ObjectDataSource1.SelectParameters["FromDT"].DefaultValue = fromDT.ToShortDateString();
this.ObjectDataSource1.SelectParameters["ToDT"].DefaultValue = toDT.ToShortDateString();
this.ObjectDataSource1.SelectParameters["BranchID"].DefaultValue = ddlBranch.SelectedValue;
this.ObjectDataSource1.SelectParameters["category"].DefaultValue = ddlCategory.SelectedValue;
this.ObjectDataSource1.SelectParameters["CMID"].DefaultValue = ddlct.SelectedValue;
this.ObjectDataSource1.SelectParameters["Type"].DefaultValue = ddlPerformance.SelectedValue;
ReportParameter rp1 = new ReportParameter("Report_Date", DateTime.Now.ToString("dd-MM-yyyy"));
ReportParameter rp3 = new ReportParameter("fromDate", txtFromDT.Text);
ReportParameter rp4 = new ReportParameter("toDate", txtToDT.Text);
ReportParameter rp2 = new ReportParameter("Report_Generator", name);
rvPII.LocalReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3, rp4 });
this.rvPII.DataBind();
this.rvPII.LocalReport.Refresh();
}
catch (Exception ex) { }
}
private void bindReport()
{
try
{
string name = "";
try
{
usersTableAdapters.GetUserNameTableAdapter user = new usersTableAdapters.GetUserNameTableAdapter();
users.GetUserNameDataTable tblUser = user.GetUserName(MySessionManager.CurrentUser.UserID);
name = tblUser[0].name.ToString();
}
catch (Exception ex) { }
this.rvPortfolioSummary.Visible = true;
// fetch the en-GB culture
CultureInfo ukCulture = new CultureInfo("en-GB");
// pass the DateTimeFormat information to DateTime.Parse
DateTime dt = DateTime.Parse(txtDate.Text, ukCulture.DateTimeFormat);
this.ObjectDataSource1.SelectParameters["BranchID"].DefaultValue = ddlBranch.SelectedValue;
this.ObjectDataSource1.SelectParameters["CMID"].DefaultValue = ddlct.SelectedValue;
this.ObjectDataSource1.SelectParameters["date"].DefaultValue =dt.ToShortDateString();
ReportParameter rp1 = new ReportParameter("Report_Date", DateTime.Now.ToString("dd-MM-yyyy"));
ReportParameter rp3 = new ReportParameter("date", txtDate.Text);
ReportParameter rp2 = new ReportParameter("Report_Generator", name);
rvPortfolioSummary.LocalReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3 });
this.rvPortfolioSummary.DataBind();
this.rvPortfolioSummary.LocalReport.Refresh();
}
catch (Exception ex) { }
//throw new NotImplementedException();
}
protected void Page_Load(object sender, EventArgs e)
{
if (MySessionManager.AppID == 0)
{
}
else
{
LoanDSTableAdapters.LoanMonitoringTableAdapter monAdd = new LoanDSTableAdapters.LoanMonitoringTableAdapter();
LoanDS.LoanMonitoringDataTable statLog = monAdd.getLoanAppMonInfo(MySessionManager.AppID);
if (statLog.Count > 0)
{
LoanDS.LoanMonitoringRow sl = statLog[0];
usersTableAdapters.GetUserNameTableAdapter un = new usersTableAdapters.GetUserNameTableAdapter();
string html = "<p>";
DateTime txt;
try
{
txt = sl.datStatusChangedDate1;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate1.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy1))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex)
{ }
try
{
txt = sl.datStatusChangedDate2;
html += "<h5>Registered For Interview</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate2.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy2))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate3;
html += "<h5>Moved For Pre Approval</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate3.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy3))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate4;
html += "<h5>Moved For Appraisal</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate4.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy4))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate5;
html += "<h5>Moved for Risk Accessment</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate5.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy5))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate6;
html += "<h5>Moved to Legal Accessment</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate6.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy6))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate7;
html += "<h5>Moved for Approval</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate7.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy7))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate8;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate8.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy8))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate9;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate9.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy9))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate10;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate10.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy10))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate11;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate11.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy11))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate12;
html += "<h5>Moved to Approved Loans</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate12.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy12))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate13;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate13.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy13))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate14;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate14.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy14))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate15;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate15.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy15))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate16;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate16.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy16))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate17;
html += "<h5>Application Declined</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate17.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy17))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate18;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate18.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy18))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate19;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate19.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy19))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate20;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate20.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy20))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
html += "</p>";
logPanel.InnerHtml = html;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (MySessionManager.AppID == 0)
{
}
else
{
LoanDSTableAdapters.LoanMonitoringTableAdapter monAdd = new LoanDSTableAdapters.LoanMonitoringTableAdapter();
LoanDS.LoanMonitoringDataTable statLog = monAdd.getLoanAppMonInfo(MySessionManager.AppID);
if (statLog.Count > 0)
{
LoanDS.LoanMonitoringRow sl = statLog[0];
usersTableAdapters.GetUserNameTableAdapter un = new usersTableAdapters.GetUserNameTableAdapter();
string html = "<p>";
DateTime txt;
try
{
txt = sl.datStatusChangedDate1;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate1.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy1))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex)
{ }
try
{
txt = sl.datStatusChangedDate2;
html += "<h5>Registered For Interview</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate2.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy2))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate3;
html += "<h5>Moved For Pre Approval</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate3.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy3))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate4;
html += "<h5>Moved For Appraisal</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate4.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy4))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate5;
html += "<h5>Moved for Risk Accessment</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate5.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy5))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate6;
html += "<h5>Moved to Legal Accessment</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate6.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy6))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate7;
html += "<h5>Moved for Approval</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate7.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy7))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate8;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate8.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy8))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate9;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate9.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy9))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate10;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate10.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy10))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate11;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate11.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy11))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate12;
html += "<h5>Moved to Approved Loans</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate12.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy12))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate13;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate13.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy13))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate14;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate14.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy14))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate15;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate15.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy15))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate16;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate16.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy16))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate17;
html += "<h5>Application Declined</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate17.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy17))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate18;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate18.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy18))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate19;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate19.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy19))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
try
{
txt = sl.datStatusChangedDate20;
html += "<h5>Appraisal Time</h5>";
html += "<span>Time : </span><span>" + sl.datStatusChangedDate20.ToString() + "</span><br/>";
html += "<span>By : </span>";
try
{
html += "<span>" + un.GetUserName(Convert.ToInt32(sl.datStatusChangedBy20))[0].name + "</span>";
}
catch (Exception ex)
{
}
html += "<br/><br/>";
}
catch (Exception ex) { }
html += "</p>";
logPanel.InnerHtml = html;
}
}
}