private void BindDDL()
{
Company_Loan_Programs _bCompany_Loan_Programs = new Company_Loan_Programs();
DataSet ds = _bCompany_Loan_Programs.GetList("1>0");
ddlProgram.DataValueField = "LoanProgramID";
ddlProgram.DataTextField = "LoanProgram";
ddlProgram.DataSource = ds.Tables[0];
ddlProgram.DataBind();
}
private void BindDLL()
{
try
{
Company_Loan_Programs programs = new Company_Loan_Programs();
DataSet ds = programs.GetAllList();
if (ds == null || ds.Tables.Count < 1)
{
}
else
{
ddlLoanProgram.DataTextField = "LoanProgram";
ddlLoanProgram.DataValueField = "LoanProgram";
ddlLoanProgram.DataSource = ds;
ddlLoanProgram.DataBind();
}
ListItem item = new ListItem("—select—", "");
ddlLoanProgram.Items.Insert(0, item);
}
catch
{ }
if (iContactID == 0)
{
return;
}
try
{
DataSet ds = loan.GetProspectCopyFromLoans(iContactID);
if (ds == null || ds.Tables.Count < 1)
{
}
else
{
ddlCopyFrom.DataTextField = "Loan";
ddlCopyFrom.DataValueField = "FileId";
ddlCopyFrom.DataSource = ds;
ddlCopyFrom.DataBind();
}
}
catch
{ }
try
{
Users user = new Users();
DataSet ds = new DataSet();
string strWhere = "";
if (CurrUser.bIsCompanyExecutive)
{
ds = user.GetConditionLoanOfficers("");
}
else if (CurrUser.bIsRegionExecutive)
{
strWhere += " AND (t.UserId IN(SELECT UserId FROM GroupUsers WHERE GroupID IN(SELECT GroupId FROM Groups WHERE RegionID IN(SELECT RegionId FROM RegionExecutives WHERE ExecutiveId = " + CurrUser.iUserID.ToString() + ")))";
strWhere += string.Format(" OR t.UserId IN (SELECT ExecutiveId FROM RegionExecutives WHERE RegionId IN (SELECT RegionId FROM RegionExecutives WHERE ExecutiveId = {0}))", CurrUser.iUserID.ToString());
strWhere += string.Format(" OR t.UserId IN (SELECT ExecutiveId FROM DivisionExecutives WHERE DivisionId IN(SELECT DivisionId FROM Divisions WHERE RegionID IN (SELECT RegionId FROM RegionExecutives WHERE ExecutiveId = {0})))", CurrUser.iUserID.ToString());
strWhere += string.Format(" OR t.UserId IN (SELECT BranchMgrId FROM BranchManagers WHERE BranchId IN(SELECT BranchId FROM Branches WHERE RegionID IN (SELECT RegionId FROM RegionExecutives WHERE ExecutiveId = {0})))", CurrUser.iUserID.ToString());
strWhere += ")";
ds = user.GetConditionLoanOfficers(strWhere);
}
else if (CurrUser.bIsDivisionExecutive)
{
strWhere += " AND (t.UserId IN(SELECT UserId FROM GroupUsers WHERE GroupID IN(SELECT GroupId FROM Groups WHERE DivisionID IN(SELECT DivisionId FROM DivisionExecutives WHERE ExecutiveId = " + CurrUser.iUserID.ToString() + ")))";
strWhere += string.Format(" OR t.UserId IN (SELECT ExecutiveId FROM DivisionExecutives WHERE DivisionId IN (SELECT DivisionId FROM DivisionExecutives WHERE ExecutiveId ={0}))", CurrUser.iUserID.ToString());
strWhere += string.Format(" OR t.UserId IN (SELECT BranchMgrId FROM BranchManagers WHERE BranchId IN(SELECT BranchId FROM Branches WHERE DivisionID IN(SELECT DivisionId FROM DivisionExecutives WHERE ExecutiveId ={0})))", CurrUser.iUserID.ToString());
strWhere += ")";
ds = user.GetConditionLoanOfficers(strWhere);
}
else if (CurrUser.bIsBranchManager)
{
strWhere += " AND (t.UserId IN(SELECT UserId FROM GroupUsers WHERE GroupID IN(SELECT GroupId FROM Groups WHERE BranchID IN(SELECT BranchId FROM BranchManagers WHERE BranchMgrId = " + CurrUser.iUserID.ToString() + ")))";
strWhere += string.Format(" OR t.UserId IN (SELECT BranchMgrId FROM BranchManagers WHERE BranchId IN (SELECT BranchId FROM BranchManagers WHERE BranchMgrId ={0}))", CurrUser.iUserID.ToString());
strWhere += ")";
ds = user.GetConditionLoanOfficers(strWhere);
}
else
{
ds = user.GetProspectLoanOfficers(iContactID);
}
if (ds == null || ds.Tables.Count < 1)
{
}
else
{
ddlLoanOfficer.DataTextField = "FullName";
ddlLoanOfficer.DataValueField = "UserId";
ddlLoanOfficer.DataSource = ds;
ddlLoanOfficer.DataBind();
ddlLoanOfficer.Items.Insert(0, new ListItem()
{
Text = "-- select --", Value = "-1"
});
ddlLoanOfficer.SelectedValue = "-1";
}
}
catch
{ }
BindBorrower();
if (ddlLoanOfficer.Items.Count > 0)
{
ddlLoanOfficer_SelectedIndexChanged(null, null);
}
BindCoborrower();
#region bind Lead Source
string sqlLeadSource = "SELECT [LeadSourceID],[LeadSource] FROM [dbo].[Company_Lead_Sources] order by LeadSource ";
var dtLeadSource = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sqlLeadSource);
ddlLeadSource.DataSource = dtLeadSource;
ddlLeadSource.DataBind();
ddlLeadSource.Items.Insert(0, new ListItem()
{
Text = "--Select--", Value = ""
});
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
#region 检查必要参数
bool bIsValid = PageCommon.ValidateQueryString(this, "LoanID", QueryStringType.ID);
if (bIsValid == false)
{
PageCommon.WriteJsEnd(this, "Missing required query string.", "");
}
this.iLoanID = Convert.ToInt32(this.Request.QueryString["LoanID"]);
#endregion
#region 加载Loan Info
string sSql3 = "select l.*, pf.FolderId, pf.Name as FileName from Loans l inner join PointFiles pf on l.FileId=pf.FileId where l.FileId=" + this.iLoanID;
DataTable LoanInfo = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSql3);
if ((LoanInfo == null) || (LoanInfo.Rows.Count == 0))
{
PageCommon.WriteJsEnd(this, string.Format("No Loan Info found for LoanID {0}.", iLoanID), "");
}
int FolderId = 0;
string FileName = string.Empty;
FolderId = LoanInfo.Rows[0]["FolderId"] == DBNull.Value ? 0 : (int)LoanInfo.Rows[0]["FolderId"];
FileName = LoanInfo.Rows[0]["FileName"] == DBNull.Value ? string.Empty : (string)LoanInfo.Rows[0]["FileName"];
if (FolderId < 1 || string.IsNullOrEmpty(FileName))
{
lnkImport.Visible = false;
}
#endregion
#region 权限验证
//try
//{
// if (this.CurrUser.userRole.Prospect.ToString().IndexOf('B') == -1)
// {
// this.btnModify.Disabled = true;
// }
// if (this.CurrUser.userRole.Prospect.ToString().IndexOf('K') == -1)
// {
// this.btnSendEmail.Disabled = true;
// }
// if (this.CurrUser.userRole.Prospect.ToString().IndexOf('F') == -1)
// {
// this.btnDispose.Disabled = true;
// }
// if (this.CurrUser.userRole.Prospect.ToString().IndexOf('C') == -1)
// {
// btnDelete.Enabled = false;
// }
// if (this.CurrUser.userRole.Prospect.ToString().IndexOf('G') == -1)
// {
// btnSyncNow.Enabled = false;
// }
//}
//catch (Exception exception)
//{
// LPLog.LogMessage(exception.Message);
//}
if (this.CurrUser.userRole.ExportClients == true)
{
this.btnvCardExport.Enabled = true;
}
else
{
this.btnvCardExport.Enabled = false;
}
#endregion
this.GetPostBackEventReference(this.lnkExport);
if (this.IsPostBack == false)
{
#region 加载Lead Source列表
Company_Lead_Sources LeadSourceManager = new Company_Lead_Sources();
DataTable LeadSourceList = LeadSourceManager.GetList("1=1 order by LeadSource").Tables[0];
DataRow NewLeadSourceRow = LeadSourceList.NewRow();
NewLeadSourceRow["LeadSourceID"] = DBNull.Value;
NewLeadSourceRow["LeadSource"] = "-- select --";
LeadSourceList.Rows.InsertAt(NewLeadSourceRow, 0);
this.ddlLeadSource.DataSource = LeadSourceList;
this.ddlLeadSource.DataBind();
#endregion
#region 加载Program列表
Company_Loan_Programs ProgramMgr = new Company_Loan_Programs();
DataTable ProgramList = ProgramMgr.GetList("1=1 order by LoanProgram").Tables[0];
DataRow NewProgramRow = ProgramList.NewRow();
NewProgramRow["LoanProgramID"] = DBNull.Value;
NewProgramRow["LoanProgram"] = "-- select --";
ProgramList.Rows.InsertAt(NewProgramRow, 0);
this.ddlProgram.DataSource = ProgramList;
this.ddlProgram.DataBind();
#endregion
#region 加载Borrower Info
DataTable BorrowerInfo = this.GetBorrowerInfo(this.iLoanID);
#region 绑定Borrower信息
if (BorrowerInfo.Rows.Count > 0)
{
string sFirstName = BorrowerInfo.Rows[0]["FirstName"].ToString();
string sLastName = BorrowerInfo.Rows[0]["LastName"].ToString();
string sBorrowerName = sLastName + ", " + sFirstName;
this.hProspectName.InnerText = sBorrowerName;
this.txtFirstName.Text = sFirstName;
this.txtLastName.Text = sLastName;
this.txtEmail.Text = BorrowerInfo.Rows[0]["Email"].ToString();
this.txtCellPhone.Text = BorrowerInfo.Rows[0]["CellPhone"].ToString();
this.txtHomePhone.Text = BorrowerInfo.Rows[0]["HomePhone"].ToString();
this.txtWorkPhone.Text = BorrowerInfo.Rows[0]["BusinessPhone"].ToString();
this.txtBirthday.Text = BorrowerInfo.Rows[0]["DOB"].ToString() == "" ? "" : Convert.ToDateTime(BorrowerInfo.Rows[0]["DOB"]).ToString("MM/dd/yyyy");
this.lbFirstName.Text = BorrowerInfo.Rows[0]["FirstName"].ToString();
this.lbLastName.Text = BorrowerInfo.Rows[0]["LastName"].ToString();
this.lbEmail.Text = BorrowerInfo.Rows[0]["Email"].ToString();
this.lbCellPhone.Text = BorrowerInfo.Rows[0]["CellPhone"].ToString();
this.lbHomePhone.Text = BorrowerInfo.Rows[0]["HomePhone"].ToString();
this.lbWorkPhone.Text = BorrowerInfo.Rows[0]["BusinessPhone"].ToString();
this.lbBirthday.Text = BorrowerInfo.Rows[0]["DOB"].ToString() == "" ? "" : Convert.ToDateTime(BorrowerInfo.Rows[0]["DOB"]).ToString("MM/dd/yyyy");
}
#endregion
if (BorrowerInfo.Rows.Count > 0)
{
string sContactID = BorrowerInfo.Rows[0]["ContactId"].ToString();
#region 加载Prospect Info
string sSqlx0 = "select * from Prospect where ContactId=" + sContactID;
DataTable ProspectInfo = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSqlx0);
#region 绑定Prospect信息
if (ProspectInfo.Rows.Count > 0)
{
// Lead Source
if (ProspectInfo.Rows[0]["LeadSource"] != DBNull.Value)
{
this.ddlLeadSource.SelectedValue = ProspectInfo.Rows[0]["LeadSource"].ToString();
this.lbLeadSource.Text = ProspectInfo.Rows[0]["LeadSource"].ToString();
}
// Referral Source (Prospect.Referral)
if (ProspectInfo.Rows[0]["Referral"] != DBNull.Value)
{
int iReferralID = Convert.ToInt32(ProspectInfo.Rows[0]["Referral"]);
Contacts ContactManager = new Contacts();
this.txtReferralSource.Text = ContactManager.GetContactName(iReferralID);
this.hdnReferralID.Value = iReferralID.ToString();
this.lbReferralSource.Text = ContactManager.GetContactName(iReferralID);
}
}
#endregion
#endregion
}
#endregion
#region 绑定Lead信息
if (LoanInfo.Rows[0]["Purpose"] != DBNull.Value)
{
this.ddlPurpose.SelectedValue = LoanInfo.Rows[0]["Purpose"].ToString();
this.lbPurpose.Text = LoanInfo.Rows[0]["Purpose"].ToString();
}
if (LoanInfo.Rows[0]["LoanType"] != DBNull.Value)
{
this.ddlType.SelectedValue = LoanInfo.Rows[0]["LoanType"].ToString();
this.lbType.Text = LoanInfo.Rows[0]["LoanType"].ToString();
}
if (LoanInfo.Rows[0]["Program"] != DBNull.Value)
{
this.ddlProgram.SelectedValue = LoanInfo.Rows[0]["Program"].ToString();
this.lbProgram.Text = LoanInfo.Rows[0]["Program"].ToString();
}
this.txtAmount.Text = LoanInfo.Rows[0]["LoanAmount"].ToString() == "" ? "" : Convert.ToDecimal(LoanInfo.Rows[0]["LoanAmount"]).ToString("n0");
this.txtRate.Text = LoanInfo.Rows[0]["Rate"].ToString() == "" ? "" : Convert.ToDecimal(LoanInfo.Rows[0]["Rate"]).ToString("n3");
this.lbAmount.Text = LoanInfo.Rows[0]["LoanAmount"].ToString() == "" ? "" : Convert.ToDecimal(LoanInfo.Rows[0]["LoanAmount"]).ToString("n0");
this.lbRate.Text = LoanInfo.Rows[0]["Rate"].ToString() == "" ? "" : Convert.ToDecimal(LoanInfo.Rows[0]["Rate"]).ToString("n3") + "%";
#endregion
}
#region Codes for Stage Progress Bar
DataTable StageProgressData = this.GetStageProgressData(this.iLoanID);
this.rptStageProgressItems.DataSource = StageProgressData;
this.rptStageProgressItems.DataBind();
#endregion
#region 获取当前Point Folder的BranchID
string sSqlx = "select b.BranchId,b.name from PointFiles as a inner join PointFolders as b on a.FolderId = b.FolderId where a.FileId=" + this.iLoanID;
DataTable BranchIDInfo = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSqlx);
if (BranchIDInfo.Rows.Count > 0 && BranchIDInfo.Rows[0]["BranchId"].ToString() != "" && BranchIDInfo.Rows[0]["BranchId"].ToString() != "0")
{
this.hdnBranchID.Value = BranchIDInfo.Rows[0]["BranchId"].ToString();
}
else
{
sSqlx = "select BranchID from Loans where FileId=" + this.iLoanID;
DataTable dtLoan = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSqlx);
if (dtLoan.Rows.Count > 0 && dtLoan.Rows[0]["BranchID"].ToString() != "" && dtLoan.Rows[0]["BranchID"].ToString() != "0")
{
this.hdnBranchID.Value = dtLoan.Rows[0]["BranchID"].ToString();
}
else
{
sSqlx = "SELECT TOP 1 BranchID FROM Groups WHERE GroupId IN(SELECT GroupID FROM GroupUsers WHERE UserID IN(SELECT UserId FROM LoanTeam WHERE FileId = " + this.iLoanID + " AND RoleId =(SELECT RoleId FROM Roles WHERE [Name]='Loan Officer')))";
DataTable dtGroup = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSqlx);
if (dtGroup.Rows.Count > 0 && dtGroup.Rows[0]["BranchID"].ToString() != "" && dtGroup.Rows[0]["BranchID"].ToString() != "0")
{
this.hdnBranchID.Value = dtGroup.Rows[0]["BranchID"].ToString();
}
}
}
#endregion
#region 加载Point File Info
string sSql7 = "Select top 1 * from dbo.lpvw_GetPointFileInfo where FileId=" + this.iLoanID;
DataTable PointFileInfo = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSql7);
string sHasPointFile = "False";
if (PointFileInfo.Rows.Count > 0)
{
string sPointFilePath = PointFileInfo.Rows[0]["Path"].ToString();
string sFolderID = PointFileInfo.Rows[0]["FolderId"].ToString();
if (sPointFilePath != string.Empty || sFolderID != string.Empty)
{
sHasPointFile = "True";
}
}
this.hdnHasPointFile.Value = sHasPointFile;
#endregion
#region Context Menu
if (LoanInfo.Rows.Count > 0)
{
string sProspectLoanStatus = LoanInfo.Rows[0]["ProspectLoanStatus"].ToString();
//加载 ArchiveLeadStatus
ArchiveLeadStatus ArchiveLeadStatusMgr = new ArchiveLeadStatus();
DataSet ArchiveLeadStatusList = ArchiveLeadStatusMgr.GetList("isnull([Enabled],0)=1 order by LeadStatusName");
#region Build Sub Menu Item
StringBuilder sbSubMenuItems = new StringBuilder();
if (ArchiveLeadStatusList.Tables[0].Rows.Count > 0)
{
sbSubMenuItems.AppendLine("<ul>");
foreach (DataRow dr in ArchiveLeadStatusList.Tables[0].Rows)
{
string sLeadStatusName1 = dr["LeadStatusName"].ToString();
string sLeadStatusName2 = dr["LeadStatusName"].ToString().Replace("'", "\\'");
sbSubMenuItems.AppendLine("<li><a href=\"\" onclick=\"ChangeStatus('" + sLeadStatusName2 + "'); return false;\">" + sLeadStatusName1 + "</a></li>");
}
sbSubMenuItems.AppendLine("</ul>");
}
#endregion
StringBuilder sbMenuItems = new StringBuilder();
if (sProspectLoanStatus.ToLower() == "active")
{
sbMenuItems.AppendLine("<li><a href=\"\" onclick=\"return false;\">Archive</a>" + sbSubMenuItems + "</li>");
sbMenuItems.AppendLine("<li><a href=\"\" onclick=\"ChangeStatus('Convert'); return false;\">Convert to Loan</a></li>");
}
this.ltrChangeStatusMenuItems.Text = sbMenuItems.ToString();
}
#endregion
#region Actions
LoanTasks LoanTasksMgr = new LoanTasks();
DataTable LastTaskInfo = LoanTasksMgr.GetLoanTaskList(1, " and FileId=" + this.iLoanID + " and Completed is not null", " order by Completed desc");
DataTable NextTaskInfo = LoanTasksMgr.GetLoanTaskList(1, " and FileId=" + this.iLoanID + " and Completed is null", " order by LoanTaskId asc");
if (LastTaskInfo.Rows.Count == 0 && NextTaskInfo.Rows.Count == 0)
{
this.divActions.Visible = false;
}
else
{
if (LastTaskInfo.Rows.Count == 0)
{
this.trLastAction.Visible = false;
}
else
{
this.ltrLastTaskName.Text = LastTaskInfo.Rows[0]["Name"].ToString();
this.ltrLastDueDate.Text = LastTaskInfo.Rows[0]["Due"] == DBNull.Value ? string.Empty : Convert.ToDateTime(LastTaskInfo.Rows[0]["Due"].ToString()).ToLongDateString();
this.ltrLastDueTime.Text = LastTaskInfo.Rows[0]["DueTime"] == DBNull.Value ? string.Empty : TimeSpan.Parse(LastTaskInfo.Rows[0]["DueTime"].ToString()).ToString();
}
if (NextTaskInfo.Rows.Count == 0)
{
this.trNextAction.Visible = false;
}
else
{
this.ltrNextTaskName.Text = NextTaskInfo.Rows[0]["Name"].ToString();
this.ltrNextDueDate.Text = NextTaskInfo.Rows[0]["Due"] == DBNull.Value ? string.Empty : Convert.ToDateTime(NextTaskInfo.Rows[0]["Due"].ToString()).ToLongDateString();
this.ltrNextDueTime.Text = NextTaskInfo.Rows[0]["DueTime"] == DBNull.Value ? string.Empty : TimeSpan.Parse(NextTaskInfo.Rows[0]["DueTime"].ToString()).ToString();
// hidden fields
this.hdnNextTaskID.Value = NextTaskInfo.Rows[0]["LoanTaskId"].ToString();
this.hdnNextTaskOwnerID.Value = NextTaskInfo.Rows[0]["Owner"].ToString();
this.hdnLoginUserID.Value = this.CurrUser.iUserID.ToString();
this.hdnCompleteOtherTask.Value = this.CurrUser.userRole.MarkOtherTaskCompl == true ? "True" : "False";
this.hdnLoanStatus.Value = LoanInfo.Rows[0]["Status"].ToString();
}
}
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
#region 校验页面参数
#region LoanId
if (this.Request.QueryString["FileID"] != null) // edit lead
{
#region 校验LoanId
string sLoanId = this.Request.QueryString["FileID"];
bool bValid = PageCommon.IsID(sLoanId);
if (bValid == false)
{
PageCommon.WriteJsEnd(this, "Invalid loan id.", "window.location.href='LeadCreate.aspx'");
return;
}
#endregion
#region LoanId -> 加载CurrentLoanInfo
// 加载Prospect Loan Info
this.CurrentLoanInfo = this.GetProspectLoanInfo(sLoanId);
if (this.CurrentLoanInfo.Rows.Count == 0)
{
PageCommon.WriteJsEnd(this, "Invalid loan id.", "window.location.href='LeadCreate.aspx'");
return;
}
// LoanId
this.iLoanId = Convert.ToInt32(sLoanId);
#endregion
// 加载Borrower/Co-Boorwer Info
this.InitBorrowerCoBorrowerInfo(this.iLoanId);
this.sActionMode = "Edit_HasLoanId_NoContactId"; // 纯edit
}
else
{
PageCommon.WriteJsEnd(this, "Invalid query string arrange.", "window.location.href='LeadCreate.aspx'");
return;
}
#endregion
#endregion
if (this.IsPostBack == false)
{
#region 加载Program列表
Company_Loan_Programs ProgramMgr = new Company_Loan_Programs();
DataTable ProgramList = ProgramMgr.GetList("1=1 order by LoanProgram").Tables[0];
this.ddlProgram.Items.Add(new ListItem("-- select --", ""));
this.ddlProgramNewLoan.Items.Add(new ListItem("-- select --", ""));
foreach (DataRow ProgramRow in ProgramList.Rows)
{
string sLoanProgram = ProgramRow["LoanProgram"].ToString();
this.ddlProgram.Items.Add(sLoanProgram);
this.ddlProgramNewLoan.Items.Add(sLoanProgram);
}
#endregion
#region 加载Start Date→Year
this.ddlStartYear.Items.Add(new ListItem("year", ""));
this.ddlStartYearNewLoan.Items.Add(new ListItem("year", ""));
DateTime saveNow = DateTime.Now;
int iBeginYear = saveNow.Year;
for (int i = 0; i < 41; i++)
{
int iNextYear = iBeginYear - i;
this.ddlStartYear.Items.Add(iNextYear.ToString());
this.ddlStartYearNewLoan.Items.Add(iNextYear.ToString());
}
#endregion
#region Loan Info
this.BindingData_LoanInfo(this.CurrentLoanInfo);
#endregion
}
}
