/// <summary>
/// Object hash code
/// </summary>
/// <returns></returns>
public override int GetHashCode()
{
unchecked
{
var hashCode = Name != null?Name.GetHashCode() : 0;
hashCode = (hashCode * 397) ^ (ContactRoles != null ? ContactRoles.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (SubSamples != null ? SubSamples.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (CVParams != null ? CVParams.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (UserParams != null ? UserParams.GetHashCode() : 0);
return(hashCode);
}
}
private void BindDDL()
{
try
{
ServiceTypes type = new ServiceTypes();
DataSet ds = type.GetList(" Enabled=1 ORDER BY ServiceType ASC");
ddlServiceTypes.DataTextField = "ServiceType";
ddlServiceTypes.DataValueField = "ServiceType";
ddlServiceTypes.DataSource = ds;
ddlServiceTypes.DataBind();
ddlServiceTypes.Items.Insert(0, new ListItem("All", "0"));
}
catch
{ }
try
{
ContactRoles roles = new ContactRoles();
DataSet ds = roles.GetList(" Name <> 'Borrower' AND Name <> 'CoBorrower' ORDER BY [Name] ASC");
ddlContactRole.DataValueField = "ContactRoleID";
ddlContactRole.DataTextField = "Name";
ddlContactRole.DataSource = ds;
ddlContactRole.DataBind();
}
catch
{ }
try
{
LPWeb.Model.Loans model = new LPWeb.Model.Loans();
Loans loans = new Loans();
model = loans.GetModel(CurrentFileId);
if (model == null)
{
return;
}
//lbPointFile.Text
lbProperty.Text = model.PropertyAddr + " " + model.PropertyCity + " " + model.PropertyState + " " + model.PropertyZip;
}
catch
{
}
}
private int Save_LoanDetail()
{
ReassignProspect();
#region gdc crm33
int iContactCoBoId = string.IsNullOrEmpty(hdnCoBorrowerID.Value) ? 0 : Convert.ToInt32(hdnCoBorrowerID.Value);
string CBname = txtCBFirstname.Text + txtCBMiddlename.Text + txtCBLastname.Text;
if ((CBname != hdnCoBorrowerName.Value.Trim() || iContactCoBoId == 0) && !string.IsNullOrEmpty(CBname))
{
LPWeb.Model.Contacts contactRecCoBo = new LPWeb.Model.Contacts();
Contacts contactsbll = new Contacts();//gdc crm33
contactRecCoBo.ContactId = 0;
contactRecCoBo.FirstName = txtCBFirstname.Text.Trim();
contactRecCoBo.MiddleName = txtCBMiddlename.Text.Trim();
contactRecCoBo.LastName = txtCBLastname.Text.Trim();
iContactCoBoId = contactsbll.AddClient(contactRecCoBo);//gdc crm33
#region CoBo to loanContacts gdc crm33
LPWeb.BLL.LoanContacts loanContactsBll = new LoanContacts();
LPWeb.BLL.ContactRoles contactRolesbll = new ContactRoles();
int contactRoleID = 0;
var contactRoleList = contactRolesbll.GetModelList(" Name = 'CoBorrower' ");
if (contactRoleList != null && contactRoleList.Count > 0 && contactRoleList.FirstOrDefault() != null)
{
contactRoleID = contactRoleList.FirstOrDefault().ContactRoleId;
}
if (contactRoleID != 0)
{
LPWeb.Model.LoanContacts loanContactModel = new LPWeb.Model.LoanContacts();
loanContactModel.FileId = iFileID;
loanContactModel.ContactRoleId = contactRoleID;
loanContactModel.ContactId = iContactCoBoId;
loanContactsBll.Add(loanContactModel);
}
#endregion
}
#endregion
LPWeb.Model.LoanDetails model = new LPWeb.Model.LoanDetails();
model.FileId = iFileID;
if (ddlBorrower.Items.Count < 1)
{
model.BoID = 0;
}
else
{
model.BoID = int.Parse(ddlBorrower.SelectedValue);
}
//if (ddlCoBorrower.Items.Count < 1)
//{
// model.CoBoID = 0;
//}
//else
//{
// model.CoBoID = int.Parse(ddlCoBorrower.SelectedValue);
//}
if (iContactCoBoId != 0)
{
model.CoBoID = iContactCoBoId;
}
model.Created = DateTime.Now;
model.CreatedBy = loginUser.iUserID;
model.Modifed = DateTime.Now;
model.ModifiedBy = loginUser.iUserID;
if (txbAmount.Text.Trim().Length < 1)
{
model.LoanAmount = 0;
}
else
{
model.LoanAmount = decimal.Parse(txbAmount.Text.Trim());
}
if (txbEstimatedDate.Text.Trim().Length > 5)
{
model.EstCloseDate = DateTime.Parse(txbEstimatedDate.Text.Trim());
}
else
{
model.EstCloseDate = DateTime.Parse("1900-1-1");
}
if (ddlRanking.SelectedIndex >= 0)
{
model.Ranking = ddlRanking.SelectedValue;
}
model.UserId = CurrUser.iUserID;
if (ddlLoanOfficer.Items.Count < 1)
{
model.LoanOfficerId = 0;
}
else
{
model.LoanOfficerId = int.Parse(ddlLoanOfficer.SelectedValue);
}
if (txbInterestRate.Text.Trim().Length < 1)
{
model.Rate = 0;
}
else
{
model.Rate = decimal.Parse(txbInterestRate.Text.Trim());
}
if (ddlLoanProgram.SelectedIndex == 0)
{
model.Program = "";
}
else
{
model.Program = ddlLoanProgram.SelectedItem.Text;
}
if (ddlPurpose.SelectedIndex == 0)
{
model.Purpose = "";
}
else
{
model.Purpose = ddlPurpose.SelectedItem.Text.Trim();
}
model.Lien = ddlLienPosition.SelectedItem.Value.Trim();
model.PropertyAddr = txbPropertyAddress.Text.Trim();
model.PropertyCity = txbCity.Text.Trim();
model.PropertyState = ddlState.SelectedValue;
model.PropertyZip = txbZip.Text.Trim();
if (ddlPointFolder.Items.Count < 1)
{
model.FolderId = 0;
}
else
{
model.FolderId = int.Parse(ddlPointFolder.SelectedValue);
}
model.FileName = txbPointFileName.Text.Trim();
model.Status = "Prospect";
model.ProspectLoanStatus = "Active";
model.PropertyType = txbPropetyType.Text.Trim();
model.HousingStatus = txbHousingStatus.Text.Trim();
model.IncludeEscrows = cbIncludeEscrows.Checked;
model.InterestOnly = cbInterestOnly.Checked;
model.RentAmount = string.IsNullOrEmpty(txbRentAmount.Text.Trim()) ? 0 : Convert.ToDecimal(txbRentAmount.Text.Trim());
model.CoborrowerType = txbCoborrowerType.Text.Trim();
iFileID = loan.LoanDetailSaveFileId(model);
#region Referral
LPWeb.Model.Prospect modelProspect = new LPWeb.Model.Prospect();
LPWeb.BLL.Prospect bllProspect = new Prospect();
modelProspect = bllProspect.GetModel(iContactID);
modelProspect.LeadSource = ddlLeadSource.SelectedValue; //gdc CR40
int referralIDNew = string.IsNullOrEmpty(hdnReferralID.Value.Trim()) ? 0 : Convert.ToInt32(hdnReferralID.Value.Trim());
if (referralIDNew > 0 && referralIDNew.ToString() != modelProspect.Referral.ToString())
{
int referralIDOld = modelProspect.Referral == null ? 0 : Convert.ToInt32(modelProspect.Referral);
modelProspect.Referral = referralIDNew;
#region Referral to loanContacts gdc crm33
LPWeb.BLL.LoanContacts loanContactsBll = new LoanContacts();
LPWeb.BLL.ContactRoles contactRolesbll = new ContactRoles();
int refrralRoleID = 0;
var referralRoleList = contactRolesbll.GetModelList(" Name = 'Referral' ");
if (referralRoleList != null && referralRoleList.Count > 0 && referralRoleList.FirstOrDefault() != null)
{
refrralRoleID = referralRoleList.FirstOrDefault().ContactRoleId;
}
if (refrralRoleID != 0)
{
LPWeb.Model.LoanContacts loanContactModel = new LPWeb.Model.LoanContacts();
loanContactModel.FileId = iFileID;
loanContactModel.ContactRoleId = refrralRoleID;
loanContactModel.ContactId = referralIDNew;
loanContactsBll.Add(loanContactModel);
}
#endregion
#region Del Old loanContacts
try
{
if (referralIDOld > 0)
{
loanContactsBll.Delete(iFileID, refrralRoleID, referralIDOld);
}
}
catch { }
#endregion
}
bllProspect.Update(modelProspect); //gdc CR40
#endregion
return(iFileID);
}
protected void btnImport_OnClick(object sender, EventArgs e)
{
dtErrorInfo.Columns.Add("RowNo");
dtErrorInfo.Columns.Add("BorrowerName");
dtErrorInfo.Columns.Add("ColumnsInfo");
this.BranchId = ddlBranch.SelectedValue.ToString();
this.iLoanOfficer = ddlLoanOfficer.SelectedValue.ToString();
if (ddlLeadSource.SelectedValue != "-1")
{
this.sLeadSource = ddlLeadSource.SelectedItem.Text;
}
this.sReferenceCode = tbRefCode.Text;
ContactRoles bContactRoles = new ContactRoles();
Roles bRoles = new Roles();
DataSet ds = bContactRoles.GetList("Name = 'Borrower'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
iBrrowerRoleID = Convert.ToInt32(ds.Tables[0].Rows[0]["ContactRoleId"]);
}
ds = bContactRoles.GetList("Name = 'CoBorrower'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
iCoBrrowerRoleID = Convert.ToInt32(ds.Tables[0].Rows[0]["ContactRoleId"]);
}
string FilePath = this.FileUpload.FileName;
string strUploadUrl = Server.MapPath("./");//此"."可以换成项目文件里的其它文件夹名称
strUploadUrl = strUploadUrl.Replace("Pipeline\\", "");
#region 文件到临时文件夹
string strUploadFolder = @"\UploadFiles\\Temp\\";
// 临时文件夹
string sTempUploadFold = strUploadUrl + strUploadFolder; // this.MapPath("~/UploadFiles/Temp/");
string sFileExt1 = Path.GetExtension(this.FileUpload.FileName).ToLower();
string sTempFileName1 = Guid.NewGuid().ToString() + sFileExt1;
// 临时文件路径
string sTempFilePath1 = Path.Combine(sTempUploadFold, sTempFileName1); // "D:\\Test\\" + FilePath;//
try
{
// 文件上传到临时文件夹
this.FileUpload.SaveAs(sTempFilePath1);
}
catch (Exception ex)
{
ClientScriptManager clientScriptManager = Page.ClientScript;
clientScriptManager.RegisterStartupScript(this.GetType(), "1", "<script language='javascript'>");
clientScriptManager.RegisterStartupScript(this.GetType(), "2", "alert('Failed to upload the file due to insufficient privilege. Please contact your system administrator.');");
clientScriptManager.RegisterStartupScript(this.GetType(), "3", "</script>");
return;
}
#endregion
try
{
PageCommon commonMgr = new PageCommon();
if (sTempFilePath1.Substring(sTempFilePath1.LastIndexOf(".")).ToLower() == ".xlsx")
{
dtExcelData = commonMgr.GetTableFromXlsx(sTempFilePath1);
}
else if (sTempFilePath1.Substring(sTempFilePath1.LastIndexOf(".")).ToLower() == ".xls")
{
dtExcelData = commonMgr.GetTableFromXls(sTempFilePath1);
}
else if (sTempFilePath1.Substring(sTempFilePath1.LastIndexOf(".")).ToLower() == ".csv")
{
dtExcelData = commonMgr.GetTableFromCsv(sTempFilePath1);
}
int iRow = 2;
foreach (DataRow dr in dtExcelData.Rows)
{
ImportOneRecord(dr, iRow);
iRow++;
}
}
catch (Exception ex)
{
ClientScriptManager clientScriptManager = Page.ClientScript;
clientScriptManager.RegisterStartupScript(this.GetType(), "1", "<script language='javascript'>");
clientScriptManager.RegisterStartupScript(this.GetType(), "2", "alert('Import Error. Please make sure row 1 of the file has data.');");
clientScriptManager.RegisterStartupScript(this.GetType(), "3", "</script>");
}
finally
{
if (File.Exists(sTempFilePath1))
{
File.Delete(sTempFilePath1);
}
}
if (dtErrorInfo.Rows.Count > 0)
{
//show Error Info
this.aspnetForm.Visible = false;
this.divError.Visible = true;
gvErrorView.DataSource = dtErrorInfo;
gvErrorView.DataBind();
}
else
{
ClientScriptManager clientScriptManager = Page.ClientScript;
clientScriptManager.RegisterStartupScript(this.GetType(), "1", "<script language='javascript'>");
clientScriptManager.RegisterStartupScript(this.GetType(), "2", "alert('Import success！');");
clientScriptManager.RegisterStartupScript(this.GetType(), "3", "</script>");
}
}
private void InitRecipientList()
{
DataTable ToList = new DataTable();
DataTable CCList = new DataTable();
#region Add Columns
ToList.Columns.Add("Type", typeof(string));
ToList.Columns.Add("Email", typeof(string));
ToList.Columns.Add("RoleID", typeof(int));
ToList.Columns.Add("RoleName", typeof(string));
CCList.Columns.Add("Type", typeof(string));
CCList.Columns.Add("Email", typeof(string));
CCList.Columns.Add("RoleID", typeof(int));
CCList.Columns.Add("RoleName", typeof(string));
#endregion
// 加载recipient信息
DataTable RecipientList = this.EmailTemplateManager.GetRecipientList(this.iEmailTemplateID);
// 加载UserRoles
DataTable UserRoles = this.RoleManager.GetRoleList(string.Empty);
// 加载ContactRoles
ContactRoles ContactRoleManager = new ContactRoles();
DataTable ContactRoles = ContactRoleManager.GetContactRoleList(string.Empty);
#region To
this.hdnToTaskOwnerChecked.Text = "False";
DataRow[] ToRecipient = RecipientList.Select("RecipientType='To'");
if (ToRecipient.Length > 0)
{
foreach (DataRow ToRecipientRow in ToRecipient)
{
string sEmailList_To = ToRecipientRow["EmailAddr"].ToString();
string sContactList_To = ToRecipientRow["ContactRoles"].ToString();
string sUserRoleList_To = ToRecipientRow["UserRoles"].ToString();
string sTaskOwnerChecked_To = ToRecipientRow["TaskOwner"].ToString();
// TaskOwner=True
if (sEmailList_To == string.Empty &&
sContactList_To == string.Empty &&
sUserRoleList_To == string.Empty &&
sTaskOwnerChecked_To == "True")
{
DataRow NewToListRow = ToList.NewRow();
NewToListRow["Type"] = "User";
NewToListRow["Email"] = DBNull.Value;
NewToListRow["RoleID"] = 0;
NewToListRow["RoleName"] = "Task Owner";
ToList.Rows.Add(NewToListRow);
// Task Owner Checked
this.hdnToTaskOwnerChecked.Text = "True";
}
else
{
#region Email
if (sEmailList_To != string.Empty)
{
// set hidden
this.hdnToEmailList.Text = sEmailList_To;
string[] EmailArray_To = sEmailList_To.Split(';');
foreach (string sEmailTo in EmailArray_To)
{
DataRow NewEmailRowTo = ToList.NewRow();
NewEmailRowTo["Type"] = "Email";
NewEmailRowTo["Email"] = sEmailTo;
NewEmailRowTo["RoleID"] = DBNull.Value;
NewEmailRowTo["RoleName"] = DBNull.Value;
ToList.Rows.Add(NewEmailRowTo);
}
}
#endregion
#region Contact Role
if (sContactList_To != string.Empty)
{
StringBuilder sbContactListTo = new StringBuilder();
string[] ContactArray_To = sContactList_To.Split(';');
foreach (string sContactIDTo in ContactArray_To)
{
DataRow NewEmailRowTo = ToList.NewRow();
NewEmailRowTo["Type"] = "Contact";
NewEmailRowTo["Email"] = DBNull.Value;
NewEmailRowTo["RoleID"] = Convert.ToInt32(sContactIDTo);
DataRow[] ContactRoleRows = ContactRoles.Select("ContactRoleId=" + sContactIDTo);
NewEmailRowTo["RoleName"] = ContactRoleRows[0]["Name"];
ToList.Rows.Add(NewEmailRowTo);
#region build string for hidden
if (sbContactListTo.Length == 0)
{
sbContactListTo.Append(sContactIDTo + ":" + ContactRoleRows[0]["Name"].ToString());
}
else
{
sbContactListTo.Append(";" + sContactIDTo + ":" + ContactRoleRows[0]["Name"].ToString());
}
#endregion
}
// set hidden
this.hdnToContactList.Text = sbContactListTo.ToString();
}
#endregion
#region User Role
if (sUserRoleList_To != string.Empty)
{
StringBuilder sbUserRoleListTo = new StringBuilder();
string[] UserRoleArray_To = sUserRoleList_To.Split(';');
foreach (string sUserRoleIDTo in UserRoleArray_To)
{
DataRow NewEmailRowTo = ToList.NewRow();
NewEmailRowTo["Type"] = "User";
NewEmailRowTo["Email"] = DBNull.Value;
NewEmailRowTo["RoleID"] = Convert.ToInt32(sUserRoleIDTo);
DataRow[] UserRoleRoleRows = UserRoles.Select("RoleId=" + sUserRoleIDTo);
NewEmailRowTo["RoleName"] = UserRoleRoleRows[0]["Name"];
ToList.Rows.Add(NewEmailRowTo);
#region build string for hidden
if (sbUserRoleListTo.Length == 0)
{
sbUserRoleListTo.Append(sUserRoleIDTo + ":" + UserRoleRoleRows[0]["Name"].ToString());
}
else
{
sbUserRoleListTo.Append(";" + sUserRoleIDTo + ":" + UserRoleRoleRows[0]["Name"].ToString());
}
#endregion
}
// set hidden
this.hdnToUserRoleList.Text = sbUserRoleListTo.ToString();
}
#endregion
}
}
}
#endregion
#region CC
this.hdnCCTaskOwnerChecked.Text = "False";
DataRow[] CCRecipient = RecipientList.Select("RecipientType='CC'");
if (CCRecipient.Length > 0)
{
foreach (DataRow CCRecipientRow in CCRecipient)
{
string sEmailList_CC = CCRecipientRow["EmailAddr"].ToString();
string sContactList_CC = CCRecipientRow["ContactRoles"].ToString();
string sUserRoleList_CC = CCRecipientRow["UserRoles"].ToString();
string sTaskOwnerChecked_CC = CCRecipientRow["TaskOwner"].ToString();
// TaskOwner=True
if (sEmailList_CC == string.Empty &&
sContactList_CC == string.Empty &&
sUserRoleList_CC == string.Empty &&
sTaskOwnerChecked_CC == "True")
{
DataRow NewCCListRow = CCList.NewRow();
NewCCListRow["Type"] = "User";
NewCCListRow["Email"] = DBNull.Value;
NewCCListRow["RoleID"] = 0;
NewCCListRow["RoleName"] = "Task Owner";
CCList.Rows.Add(NewCCListRow);
this.hdnCCTaskOwnerChecked.Text = "True";
}
else
{
#region Email
if (sEmailList_CC != string.Empty)
{
// set hidden
this.hdnCCEmailList.Text = sEmailList_CC;
string[] EmailArray_CC = sEmailList_CC.Split(';');
foreach (string sEmailCC in EmailArray_CC)
{
DataRow NewEmailRowCC = CCList.NewRow();
NewEmailRowCC["Type"] = "Email";
NewEmailRowCC["Email"] = sEmailCC;
NewEmailRowCC["RoleID"] = DBNull.Value;
NewEmailRowCC["RoleName"] = DBNull.Value;
CCList.Rows.Add(NewEmailRowCC);
}
}
#endregion
#region Contact Role
if (sContactList_CC != string.Empty)
{
StringBuilder sbContactListCC = new StringBuilder();
string[] ContactArray_CC = sContactList_CC.Split(';');
foreach (string sContactIDCC in ContactArray_CC)
{
DataRow NewEmailRowCC = CCList.NewRow();
NewEmailRowCC["Type"] = "Contact";
NewEmailRowCC["Email"] = DBNull.Value;
NewEmailRowCC["RoleID"] = Convert.ToInt32(sContactIDCC);
DataRow[] ContactRoleRows = ContactRoles.Select("ContactRoleId=" + sContactIDCC);
NewEmailRowCC["RoleName"] = ContactRoleRows[0]["Name"];
CCList.Rows.Add(NewEmailRowCC);
#region build string for hidden
if (sbContactListCC.Length == 0)
{
sbContactListCC.Append(sContactIDCC + ":" + ContactRoleRows[0]["Name"].ToString());
}
else
{
sbContactListCC.Append(";" + sContactIDCC + ":" + ContactRoleRows[0]["Name"].ToString());
}
#endregion
}
// set hidden
this.hdnCCContactList.Text = sbContactListCC.ToString();
}
#endregion
#region User Role
if (sUserRoleList_CC != string.Empty)
{
StringBuilder sbUserRoleListCC = new StringBuilder();
string[] UserRoleArray_CC = sUserRoleList_CC.Split(';');
foreach (string sUserRoleIDCC in UserRoleArray_CC)
{
DataRow NewEmailRowCC = CCList.NewRow();
NewEmailRowCC["Type"] = "User";
NewEmailRowCC["Email"] = DBNull.Value;
NewEmailRowCC["RoleID"] = Convert.ToInt32(sUserRoleIDCC);
DataRow[] UserRoleRoleRows = UserRoles.Select("RoleId=" + sUserRoleIDCC);
NewEmailRowCC["RoleName"] = UserRoleRoleRows[0]["Name"];
CCList.Rows.Add(NewEmailRowCC);
#region build string for hidden
if (sbUserRoleListCC.Length == 0)
{
sbUserRoleListCC.Append(sUserRoleIDCC + ":" + UserRoleRoleRows[0]["Name"].ToString());
}
else
{
sbUserRoleListCC.Append(";" + sUserRoleIDCC + ":" + UserRoleRoleRows[0]["Name"].ToString());
}
#endregion
}
// set hidden
this.hdnCCUserRoleList.Text = sbUserRoleListCC.ToString();
}
#endregion
}
}
}
#endregion
#region bind data
this.gridToList.DataSource = ToList;
this.gridToList.DataBind();
this.gridCCList.DataSource = CCList;
this.gridCCList.DataBind();
#endregion
}
