/// <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 }