/// <summary> /// create contact and prospect without checking duplicated /// neo 2012-10-24 /// </summary> /// <param name="contactInfo"></param> /// <param name="prospectInfo"></param> /// <returns></returns> public int CreateContactAndProspectNoCheck(LPWeb.Model.Contacts contactInfo, LPWeb.Model.Prospect prospectInfo) { int iContactId = -1; if (contactInfo == null || (prospectInfo == null)) { throw new Exception("CreateProspect, ContactInfo and ProspectInfo cannot be empty."); } if (string.IsNullOrEmpty(contactInfo.LastName) || string.IsNullOrEmpty(contactInfo.FirstName)) { throw new Exception("CreateProspect, First Name and Last Name cannot be blank."); } if (string.IsNullOrEmpty(contactInfo.Email) && string.IsNullOrEmpty(contactInfo.HomePhone) && string.IsNullOrEmpty(contactInfo.CellPhone) && string.IsNullOrEmpty(contactInfo.BusinessPhone)) { throw new Exception("CreateProspect, must at least specified Email, Home Phone, Cell Phone or Business Phone."); } Contacts contactMgr = new Contacts(); iContactId = contactMgr.AddClientNoCheck(contactInfo); if (iContactId > 0) { Prospect prospectMgr = new Prospect(); prospectInfo.Contactid = iContactId; prospectMgr.Add(prospectInfo); } return(iContactId); }
/// <summary> /// /// </summary> /// <returns></returns> private LPWeb.Model.Contacts FillModel() { LPWeb.Model.Contacts model = new LPWeb.Model.Contacts(); model.ContactId = int.Parse(hdnContactID.Value); model.FirstName = this.txbFirstName.Text.Trim(); model.LastName = this.txbLastName.Text.Trim(); model.ContactEnable = this.ckEnable.Enabled; //this.ckEnable.Checked = model. //model.ContactCompanyId = //ddlServiceTypes.SelectedValue = ///??? model.Fax = this.txbFax.Text.Trim(); model.BusinessPhone = this.txbBPhone.Text.Trim(); model.CellPhone = this.txbCPhone.Text.Trim(); model.Email = this.txbEmail.Text.Trim(); model.MailingState = ddlState.SelectedValue; model.MailingZip = txbZip.Text.Trim(); model.MailingAddr = txbAddress.Text.Trim(); model.MailingCity = txbCity.Text.Trim(); if (ddlCompany.SelectedIndex == 0) { model.ContactCompanyId = 0; } else { model.ContactCompanyId = int.Parse(ddlCompany.SelectedItem.Value); } model.Enabled = ckEnable.Checked; return(model); }
/// <summary> /// Load contact details info /// </summary> private void BindControls() { if (ContactId == 0) { this.imgPhoto.ImageUrl = string.Format("~/_layouts/LPWeb/Settings/GetContactPicture.aspx?t={0}", DateTime.Now.Ticks); return; } try { LPWeb.Model.Contacts model = new LPWeb.Model.Contacts(); model = this.contactMgr.GetModel(ContactId); if (model == null) { return; } this.ddlBranch.SelectedValue = model.ContactBranchId.ToString(); this.txtFirstName.Text = model.FirstName.Trim(); this.txtLastName.Text = model.LastName.Trim(); this.chkEnabled.Checked = model.Enabled; this.txtAddress.Text = model.MailingAddr.Trim(); this.ddlStates.SelectedValue = model.MailingState; this.txtCity.Text = model.MailingCity.Trim(); this.txtZip.Text = model.MailingZip.Trim(); this.txtBizPhone.Text = model.BusinessPhone.Trim(); this.txtCellPhone.Text = model.CellPhone.Trim(); this.txtEmail.Text = model.Email.Trim(); this.txtFax.Text = model.Fax.Trim(); this.txtSignature.Text = model.Signature; if (model.Picture == null) { this.imgPhoto.ImageUrl = string.Format("~/_layouts/LPWeb/Settings/GetContactPicture.aspx?t={0}", DateTime.Now.Ticks); } else { this.imgPhoto.ImageUrl = string.Format("~/_layouts/LPWeb/Settings/GetContactPicture.aspx?cid={0}&t={1}", ContactId, DateTime.Now.Ticks); } } catch (Exception ex) { throw ex; } }
/// <summary> /// /// </summary> private void BindContact() { try { LPWeb.Model.Contacts model = contacts.GetModel(iContactID); if (model == null) { return; } //this.lblContactId.Text = model.ContactId.ToString(); this.txbFirstName.Text = model.FirstName; this.txbLastName.Text = model.LastName; ckEnable.Checked = model.ContactEnable; //ddlServiceTypes.SelectedValue = ///??? this.txbFax.Text = model.Fax; this.txbBPhone.Text = model.BusinessPhone; this.txbCPhone.Text = model.CellPhone; this.txbEmail.Text = model.Email; ddlState.SelectedValue = model.MailingState; txbCity.Text = model.MailingCity; txbAddress.Text = model.MailingAddr; txbZip.Text = model.MailingZip; if (model.ContactCompanyId.HasValue) { BindContactCompany(model.ContactCompanyId.Value); this.ddlCompany.SelectedValue = model.ContactCompanyId.ToString(); BindContactBranch(); } else if (model.ContactBranchId.HasValue) { BindContactBranch(model.ContactBranchId.Value); this.ddlBranch.SelectedValue = model.ContactBranchId.ToString(); } else { BindContactCompany(); } } catch { } }
/// <summary> /// load data /// </summary> /// <param name="contactId"></param> /// <param name="noteId"></param> private void BindPage(int contactId, int noteId) { ContactNotes bllContactNotes = new ContactNotes(); Contacts bllContact = new Contacts(); LPWeb.Model.Contacts modelContact = bllContact.GetModel(contactId); if (modelContact != null) { lblProperty.Text = modelContact.MailingAddr + " " + modelContact.MailingCity + " " + modelContact.MailingState + " " + modelContact.MailingZip; } var curUser = new LoginUser(); lblSender.Text = curUser.sFirstName + " " + curUser.sLastName; lblBorrower.Text = modelContact.LastName + ", " + modelContact.FirstName + " " + modelContact.MiddleName; if (noteId > 0) { tbxNote.Text = bllContactNotes.GetModel(noteId).Note; } }
protected void Page_Load(object sender, EventArgs e) { try { CurrentUser = new LoginUser(); //loginUser.ValidatePageVisitPermission("LoanSetup"); //权限验证 if (!CurrentUser.userRole.AssignLoan) { Response.Redirect("../Unauthorize.aspx"); return; } } catch (Exception exception) { LPLog.LogMessage(exception.Message); } if (Request.QueryString["prospectID"] != null) // 如果有prospectID { string sProspectID = Request.QueryString["prospectID"]; CurrentProspectId = Convert.ToInt32(sProspectID); } if (Request.QueryString["UserID"] != null) // 如果有UserID { oldUserID = Convert.ToInt32(Request.QueryString["UserID"]); } if (!IsPostBack) { Contacts contact = new Contacts(); LPWeb.Model.Contacts cs = (LPWeb.Model.Contacts)contact.GetModel(CurrentProspectId); lbClient.Text = cs.LastName + "," + cs.FirstName + " " + cs.MiddleName; BindUsers(); } }
protected void btnCopyAddress_Click(object sender, EventArgs e) { if (ddlBorrower.SelectedIndex < 0) { return; } try { int ContactID = int.Parse(ddlBorrower.SelectedItem.Value); LPWeb.Model.Contacts model = new LPWeb.Model.Contacts(); Contacts ct = new Contacts(); model = ct.GetModel(ContactID); // Loan.Status+”Loan “+Loans.LienPosition+” – “+Loans.PropertyAddr txbPropertyAddress.Text = model.MailingAddr; txbCity.Text = model.MailingCity; txbZip.Text = model.MailingZip; ddlState.SelectedValue = model.MailingState; } catch (Exception ex) { LPLog.LogMessage(ex.Message); } }
/// <summary> /// Save contact /// </summary> private void SaveContact() { try { LPWeb.Model.Contacts contactModel = this.FillModel(); if (contactModel == null) { this.ContactId = 0; return; } if (this.ContactId == 0) { DataSet dsContact = this.contactMgr.GetList(" LastName='" + contactModel.LastName.Replace("'", "''") + "' AND FirstName='" + contactModel.FirstName.Replace("'", "''") + "' AND Email = '" + contactModel.Email.Replace("'", "''") + "' AND ContactBranchId = " + contactModel.ContactBranchId.Value.ToString()); if (dsContact.Tables.Count > 0 && dsContact.Tables[0].Rows.Count > 0) { this.ContactId = int.Parse(dsContact.Tables[0].Rows[0]["ContactId"].ToString()); } } if (this.ContactId == 0) { contactModel.Created = DateTime.Now; contactModel.CreatedBy = CurrUser.iUserID; this.ContactId = this.contactMgr.Add(contactModel); } else { this.contactMgr.Update(contactModel); } this.hdnContactID.Value = this.ContactId.ToString(); } catch (Exception ex) { throw ex; } }
public void ADDContact(LPWeb.Model.Contacts model) { dal.ADDContact(model); }
protected void btnSave_Click(object sender, EventArgs e) { if (this.CurrentFileId == 0) { return; } int ContactID = 0; LPWeb.Model.Contacts model = new LPWeb.Model.Contacts(); try { ContactID = int.Parse(hfdContactID.Value); Contacts contact = new Contacts(); model = contact.GetModel(ContactID); } catch { } ServiceManager sm = new ServiceManager(); using (LP2ServiceClient service = sm.StartServiceClient()) { ReassignContactRequest req = new ReassignContactRequest(); req.hdr = new ReqHdr(); req.hdr.SecurityToken = "SecurityToken"; //todo:check dummy data req.hdr.UserId = CurrentUser.iUserID; ReassignContactInfo cInfo = new ReassignContactInfo(); List <ReassignContactInfo> cList = new List <ReassignContactInfo>(); cInfo.FileId = this.CurrentFileId;//todo:check dummy data cInfo.ContactRoleId = int.Parse(ddlContactRole.SelectedValue); cInfo.NewContactId = ContactID; cList.Add(cInfo); req.reassignContacts = cList.ToArray(); ReassignContactResponse respone = null; try { respone = service.ReassignContact(req); if (respone.hdr.Successful) { LPWeb.Model.LoanContacts lcModel = new LPWeb.Model.LoanContacts(); lcModel.FileId = CurrentFileId; lcModel.ContactRoleId = cInfo.ContactRoleId; lcModel.ContactId = ContactID; LPWeb.Model.LoanContacts oldlcModel = new LPWeb.Model.LoanContacts(); oldlcModel.FileId = CurrentFileId; oldlcModel.ContactRoleId = oldRoleID; oldlcModel.ContactId = oldContactID; LPWeb.BLL.LoanContacts lc = new LoanContacts(); lc.Reassign(oldlcModel, lcModel, req.hdr.UserId); try { PageCommon.WriteJsEnd(this, "Reassigned contact successfully", PageCommon.Js_RefreshParent); } catch { } } else { try { PageCommon.WriteJsEnd(this, String.Format("Failed to reassign contact: reason: {0}.", respone.hdr.StatusInfo), PageCommon.Js_RefreshSelf); } catch { } } } catch (System.ServiceModel.EndpointNotFoundException ex) { LPLog.LogMessage(ex.Message); PageCommon.WriteJsEnd(this, "Failed to reassign contact: reason, Point Manager is not running. ", PageCommon.Js_RefreshSelf); } catch (Exception exception) { LPLog.LogMessage(exception.Message); PageCommon.WriteJsEnd(this, String.Format("Failed to reassign contact, reason: {0}", exception.Message), PageCommon.Js_RefreshSelf); } } }
private void FillLabels() { if (iContactID == 0) { return; } try { LPWeb.BLL.Contacts contact = new LPWeb.BLL.Contacts(); LPWeb.Model.Contacts cModel = contact.GetModel(iContactID); lbClient.Text = cModel.LastName + ", " + cModel.FirstName + " " + cModel.MiddleName; lbNikeName.Text = cModel.NickName; if (cModel.DOB.HasValue) { lbDOB.Text = cModel.DOB.Value.ToShortDateString(); } else { lbDOB.Text = string.Empty; } lbGenCode.Text = cModel.GenerationCode; lbSSN.Text = cModel.SSN; lbTitle.Text = cModel.Title; if (cModel.Experian.HasValue) { lbExperScore.Text = cModel.Experian.Value.ToString(); } if (cModel.TransUnion.HasValue) { lbTranScore.Text = cModel.TransUnion.Value.ToString(); } if (cModel.Equifax.HasValue) { lbEquifax.Text = cModel.Equifax.Value.ToString(); } lbHomePhone.Text = cModel.HomePhone; lbCellPhone.Text = cModel.CellPhone; lbBusinessPhone.Text = cModel.BusinessPhone; lbFax.Text = cModel.Fax; lbEmail.Text = cModel.Email; lbAddress.Text = cModel.MailingAddr; lbAddress1.Text = cModel.MailingCity + ", " + cModel.MailingState + " " + cModel.MailingZip; } catch { } try { LPWeb.BLL.Prospect prospect = new LPWeb.BLL.Prospect(); LPWeb.Model.Prospect pModel = prospect.GetModel(iContactID); lbStatus.Text = pModel.Status; lbLeadSource.Text = pModel.LeadSource;//Get referral contact name if (pModel.Loanofficer.HasValue) { lbLoanOfficer.Text = GetUserName(pModel.Loanofficer.Value); } if (pModel.Created.HasValue) { lbCreatedOn.Text = pModel.Created.Value.ToShortDateString(); } if (pModel.CreatedBy.HasValue) { lbCreatedBy.Text = GetUserName(pModel.CreatedBy.Value); } if (pModel.Modifed.HasValue) { lbLastModified.Text = pModel.Modifed.Value.ToShortDateString(); } if (pModel.ModifiedBy.HasValue) { lbModifiedBy.Text = GetUserName(pModel.ModifiedBy.Value); } int iReferralId = 0; if (pModel.Referral != null) { iReferralId = (int)pModel.Referral; LPWeb.BLL.Contacts contact = new LPWeb.BLL.Contacts(); lbReferral.Text = contact.GetContactName(iReferralId); } this.lbPreferredContact.Text = pModel.PreferredContact; this.lbCreditRanking.Text = pModel.CreditRanking; } 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); }
private void BindLables() { if (iContactID == 0) { return; } int iContactBranchID = 0; int iCompanyID = 0; string raw_data = ""; string processed_data = " "; try { Contacts bllContact = new Contacts(); LPWeb.Model.Contacts mContact = new LPWeb.Model.Contacts(); mContact = bllContact.GetModel(iContactID); lbName.Text = mContact.LastName + ", " + mContact.FirstName; lbEnabled.Text = mContact.Enabled?"Yes":"No"; if (mContact.CellPhone != null) { raw_data = mContact.CellPhone.Trim(); raw_data = System.Text.RegularExpressions.Regex.Replace(raw_data, @"[-() ]", String.Empty); if (raw_data.Length > 10) { raw_data = raw_data.Substring(0, 10); } if (raw_data.Length == 10) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 4); } else if (raw_data.Length == 9) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 3); } else if (raw_data.Length == 8) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 2); } else if (raw_data.Length == 7) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 1); } else if (raw_data.Length == 6) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-"; } else if (raw_data.Length == 5) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 2) + " -"; } else if (raw_data.Length == 4) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 1) + " -"; } else if (raw_data.Length == 3) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + " -"; } else if (raw_data.Length == 2) { processed_data = "(" + raw_data.Substring(0, 2) + " ) " + " -"; } else if (raw_data.Length == 1) { processed_data = "(" + raw_data.Substring(0, 1) + " ) " + " -"; } else { processed_data = "( ) - "; } } else { processed_data = "( ) - "; } lbCellPhone.Text = processed_data; if (mContact.BusinessPhone != null) { raw_data = mContact.BusinessPhone.Trim(); raw_data = System.Text.RegularExpressions.Regex.Replace(raw_data, @"[-() ]", String.Empty); if (raw_data.Length > 10) { raw_data = raw_data.Substring(0, 10); } if (raw_data.Length == 10) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 4); } else if (raw_data.Length == 9) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 3); } else if (raw_data.Length == 8) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 2); } else if (raw_data.Length == 7) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 1); } else if (raw_data.Length == 6) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-"; } else if (raw_data.Length == 5) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 2) + " -"; } else if (raw_data.Length == 4) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 1) + " -"; } else if (raw_data.Length == 3) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + " -"; } else if (raw_data.Length == 2) { processed_data = "(" + raw_data.Substring(0, 2) + " ) " + " -"; } else if (raw_data.Length == 1) { processed_data = "(" + raw_data.Substring(0, 1) + " ) " + " -"; } else { processed_data = "( ) - "; } } else { processed_data = "( ) - "; } lbBussinessPhone.Text = processed_data; raw_data = mContact.Fax; if (mContact.Fax != null) { raw_data = mContact.Fax.Trim(); raw_data = System.Text.RegularExpressions.Regex.Replace(raw_data, @"[-() ]", String.Empty); if (raw_data.Length > 10) { raw_data = raw_data.Substring(0, 10); } if (raw_data.Length == 10) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 4); } else if (raw_data.Length == 9) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 3); } else if (raw_data.Length == 8) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 2); } else if (raw_data.Length == 7) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 1); } else if (raw_data.Length == 6) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-"; } else if (raw_data.Length == 5) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 2) + " -"; } else if (raw_data.Length == 4) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 1) + " -"; } else if (raw_data.Length == 3) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + " -"; } else if (raw_data.Length == 2) { processed_data = "(" + raw_data.Substring(0, 2) + " ) " + " -"; } else if (raw_data.Length == 1) { processed_data = "(" + raw_data.Substring(0, 1) + " ) " + " -"; } else { processed_data = "( ) - "; } } else { processed_data = "( ) - "; } lbFax.Text = processed_data; lbEmail.Text = mContact.Email; if (mContact.ContactCompanyId.HasValue) { iCompanyID = mContact.ContactCompanyId.Value; } if (mContact.ContactBranchId.HasValue) { iContactBranchID = mContact.ContactBranchId.Value; } } catch (Exception ex) { } try { ContactBranches bllCB = new ContactBranches(); LPWeb.Model.ContactBranches mCB = new LPWeb.Model.ContactBranches(); mCB = bllCB.GetModel(iContactBranchID); lbBranch.Text = mCB.Name; if (mCB.Phone != null) { raw_data = mCB.Phone.Trim(); raw_data = System.Text.RegularExpressions.Regex.Replace(raw_data, @"[-() ]", String.Empty); if (raw_data.Length > 10) { raw_data = raw_data.Substring(0, 10); } if (raw_data.Length == 10) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 4); } else if (raw_data.Length == 9) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 3); } else if (raw_data.Length == 8) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 2); } else if (raw_data.Length == 7) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 1); } else if (raw_data.Length == 6) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-"; } else if (raw_data.Length == 5) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 2) + " -"; } else if (raw_data.Length == 4) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 1) + " -"; } else if (raw_data.Length == 3) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + " -"; } else if (raw_data.Length == 2) { processed_data = "(" + raw_data.Substring(0, 2) + " ) " + " -"; } else if (raw_data.Length == 1) { processed_data = "(" + raw_data.Substring(0, 1) + " ) " + " -"; } else { processed_data = "( ) - "; } } else { processed_data = "( ) - "; } lbPhone.Text = processed_data; if (mCB.Fax != null) { raw_data = mCB.Fax.Trim(); raw_data = System.Text.RegularExpressions.Regex.Replace(raw_data, @"[-() ]", String.Empty); if (raw_data.Length > 10) { raw_data = raw_data.Substring(0, 10); } if (raw_data.Length == 10) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 4); } else if (raw_data.Length == 9) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 3); } else if (raw_data.Length == 8) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 2); } else if (raw_data.Length == 7) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 1); } else if (raw_data.Length == 6) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-"; } else if (raw_data.Length == 5) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 2) + " -"; } else if (raw_data.Length == 4) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 1) + " -"; } else if (raw_data.Length == 3) { processed_data = "(" + raw_data.Substring(0, 3) + ") " + " -"; } else if (raw_data.Length == 2) { processed_data = "(" + raw_data.Substring(0, 2) + " ) " + " -"; } else if (raw_data.Length == 1) { processed_data = "(" + raw_data.Substring(0, 1) + " ) " + " -"; } else { processed_data = "( ) - "; } } else { processed_data = "( ) - "; } lbFax1.Text = processed_data; lbAddress.Text = mCB.Address; lbCity.Text = mCB.City + " " + mCB.State + " " + mCB.Zip; if (mCB.ContactCompanyId.HasValue && iCompanyID == 0) { iCompanyID = mCB.ContactCompanyId.Value; } } catch (Exception ex) { } int iServiceTypeID = 0; try { ContactCompanies bllCC = new ContactCompanies(); LPWeb.Model.ContactCompanies mCC = new LPWeb.Model.ContactCompanies(); mCC = bllCC.GetModel(iCompanyID); //lbServiceType.Text = mCC.ServiceTypes; lbCompany.Text = mCC.Name; iServiceTypeID = mCC.ServiceTypeId; } catch { } try { ServiceTypes blST = new ServiceTypes(); LPWeb.Model.ServiceTypes mST = new LPWeb.Model.ServiceTypes(); mST = blST.GetModel(iServiceTypeID); lbServiceType.Text = mST.Name; } catch { } #region Referral Amount/Referral Funded/Wind Ratio string sSql = "select dbo.lpfn_GetTotalReferral(" + this.iContactID + ", " + this.CurrUser.iUserID + ") as TotalReferral, " + "dbo.lpfn_GetTotalReferralFunded(" + this.iContactID + ", " + this.CurrUser.iUserID + ") as TotalReferralFunded, " + "dbo.lpfn_GetTotalReferral_FileIDs(" + this.iContactID + ", " + this.CurrUser.iUserID + ") as TotalReferralFileIDs, " + "isnull(dbo.lpfn_GetTotalReferralFunded(" + this.iContactID + ", " + this.CurrUser.iUserID + "),0)/dbo.lpfn_GetTotalReferral(" + this.iContactID + ", " + this.CurrUser.iUserID + ") as WinRatio"; DataTable ReferralAmountInfo = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSql); if (ReferralAmountInfo.Rows.Count > 0) { if (ReferralAmountInfo.Rows[0]["TotalReferral"] == DBNull.Value) { this.aTotalReferral.InnerText = string.Empty; this.aTotalReferral.HRef = string.Empty; } else { this.aTotalReferral.InnerText = Convert.ToDecimal(ReferralAmountInfo.Rows[0]["TotalReferral"]).ToString("c0"); this.aTotalReferral.HRef = "javascript:window.parent.SetTab('PartnerContactDetailReferralstab.aspx',3);"; } if (ReferralAmountInfo.Rows[0]["TotalReferralFunded"] == DBNull.Value) { this.lbTotalReferralFunded.Text = string.Empty; } else { this.lbTotalReferralFunded.Text = Convert.ToDecimal(ReferralAmountInfo.Rows[0]["TotalReferralFunded"]).ToString("c0"); } if (ReferralAmountInfo.Rows[0]["WinRatio"] == DBNull.Value) { this.lbWinRatio.Text = string.Empty; } else { this.lbWinRatio.Text = Convert.ToDecimal(ReferralAmountInfo.Rows[0]["WinRatio"]).ToString("p0"); } } #endregion }
/// <summary> /// 获得数据列表 /// </summary> public List <LPWeb.Model.Contacts> DataTableToList(DataTable dt) { List <LPWeb.Model.Contacts> modelList = new List <LPWeb.Model.Contacts>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { LPWeb.Model.Contacts model; for (int n = 0; n < rowsCount; n++) { model = new LPWeb.Model.Contacts(); if (dt.Rows[n]["ContactId"].ToString() != "") { model.ContactId = int.Parse(dt.Rows[n]["ContactId"].ToString()); } model.FirstName = dt.Rows[n]["FirstName"].ToString(); model.MiddleName = dt.Rows[n]["MiddleName"].ToString(); model.LastName = dt.Rows[n]["LastName"].ToString(); model.NickName = dt.Rows[n]["NickName"].ToString(); model.Title = dt.Rows[n]["Title"].ToString(); model.GenerationCode = dt.Rows[n]["GenerationCode"].ToString(); model.SSN = dt.Rows[n]["SSN"].ToString(); model.HomePhone = dt.Rows[n]["HomePhone"].ToString(); model.CellPhone = dt.Rows[n]["CellPhone"].ToString(); model.BusinessPhone = dt.Rows[n]["BusinessPhone"].ToString(); model.Fax = dt.Rows[n]["Fax"].ToString(); model.Email = dt.Rows[n]["Email"].ToString(); if (dt.Rows[n]["DOB"].ToString() != "") { model.DOB = DateTime.Parse(dt.Rows[n]["DOB"].ToString()); } if (dt.Rows[n]["Experian"].ToString() != "") { model.Experian = int.Parse(dt.Rows[n]["Experian"].ToString()); } if (dt.Rows[n]["TransUnion"].ToString() != "") { model.TransUnion = int.Parse(dt.Rows[n]["TransUnion"].ToString()); } if (dt.Rows[n]["Equifax"].ToString() != "") { model.Equifax = int.Parse(dt.Rows[n]["Equifax"].ToString()); } model.MailingAddr = dt.Rows[n]["MailingAddr"].ToString(); model.MailingCity = dt.Rows[n]["MailingCity"].ToString(); model.MailingState = dt.Rows[n]["MailingState"].ToString(); model.MailingZip = dt.Rows[n]["MailingZip"].ToString(); if (dt.Rows[n]["ContactCompanyId"].ToString() != "") { model.ContactCompanyId = int.Parse(dt.Rows[n]["ContactCompanyId"].ToString()); } if (dt.Rows[n]["WebAccountId"].ToString() != "") { model.WebAccountId = int.Parse(dt.Rows[n]["WebAccountId"].ToString()); } if (dt.Rows[n]["ContactEnable"].ToString() != "") { if ((dt.Rows[n]["ContactEnable"].ToString() == "1") || (dt.Rows[n]["ContactEnable"].ToString().ToLower() == "true")) { model.ContactEnable = true; } else { model.ContactEnable = false; } } modelList.Add(model); } } return(modelList); }
/// <summary> /// create contact and prospect without checking duplicated /// neo 2012-10-24 /// </summary> /// <param name="contactInfo"></param> /// <param name="prospectInfo"></param> /// <returns></returns> public int CreateContactAndProspectNoCheck(LPWeb.Model.Contacts contactInfo, LPWeb.Model.Prospect prospectInfo) { return(dal.CreateContactAndProspectNoCheck(contactInfo, prospectInfo)); }
protected int CreateContactAndProspect(string sFirstName, string sLastName, string sEmail, string sCellPhone, string sHomePhone, string sWorkPhone, string sDOB, string sSSN, string sDependants, string sCreditRanking, string sFICO, string sMailingStreetAddress1, string sMailingStreetAddress2, string sMailingCity, string sMailingState, string sMailingZip, string sLeadSource, string sReferralID) { #region create new contact LPWeb.Model.Contacts ContactsModel = new LPWeb.Model.Contacts(); ContactsModel.ContactId = 0; ContactsModel.FirstName = sFirstName; ContactsModel.LastName = sLastName; ContactsModel.Email = sEmail; ContactsModel.CellPhone = sCellPhone; ContactsModel.HomePhone = sHomePhone; ContactsModel.BusinessPhone = sWorkPhone; if (sDOB == string.Empty) { ContactsModel.DOB = null; } else { ContactsModel.DOB = Convert.ToDateTime(sDOB); } ContactsModel.SSN = sSSN; if (sFICO == string.Empty) { ContactsModel.Experian = null; } else { ContactsModel.Experian = Convert.ToInt32(sFICO); } ContactsModel.MailingAddr = (sMailingStreetAddress1 + " " + sMailingStreetAddress2).Trim(); ContactsModel.MailingCity = sMailingCity; ContactsModel.MailingState = sMailingState; ContactsModel.MailingZip = sMailingZip; ContactsModel.Created = DateTime.Now; ContactsModel.CreatedBy = this.CurrUser.iUserID; ContactsModel.MiddleName = string.Empty; ContactsModel.NickName = sFirstName; ContactsModel.Title = string.Empty; ContactsModel.GenerationCode = string.Empty; ContactsModel.Fax = string.Empty; #endregion #region create new prospect LPWeb.Model.Prospect ProspectModel = new LPWeb.Model.Prospect(); ProspectModel.Contactid = 0; ProspectModel.LeadSource = sLeadSource; if (sReferralID == string.Empty) { ProspectModel.Referral = null; } else { ProspectModel.Referral = Convert.ToInt32(sReferralID); } ProspectModel.CreditRanking = sCreditRanking; ProspectModel.Created = DateTime.Now; ProspectModel.CreatedBy = this.CurrUser.iUserID; ProspectModel.Status = "Active"; if (sDependants == "Yes") { ProspectModel.Dependents = true; } else { ProspectModel.Dependents = false; } ProspectModel.Modifed = null; ProspectModel.ModifiedBy = null; ProspectModel.Loanofficer = null; ProspectModel.ReferenceCode = null; ProspectModel.PreferredContact = null; #endregion int iContactId = this.ProspectMgr.CreateContactAndProspect(ContactsModel, ProspectModel); return(iContactId); }
/// <summary> /// create contact without check duplicated /// neo 2012-10-24 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddClientNoCheck(LPWeb.Model.Contacts model) { return(this.AddClientNoCheck(model)); }
public int AddClient(LPWeb.Model.Contacts model) { return(dal.AddClient(model)); }
/// <summary> /// Fill contact model /// </summary> /// <returns></returns> public LPWeb.Model.Contacts FillModel() { LPWeb.Model.Contacts model = new LPWeb.Model.Contacts(); model.ContactId = this.ContactId; if (this.ddlBranch.SelectedIndex > 0) { model.ContactBranchId = int.Parse(this.ddlBranch.SelectedValue); LPWeb.BLL.ContactBranches contactBranch = new ContactBranches(); LPWeb.Model.ContactBranches branchModel = contactBranch.GetModel(model.ContactBranchId.Value); if (branchModel != null) { model.ContactCompanyId = branchModel.ContactCompanyId; } } model.FirstName = this.txtFirstName.Text.Trim(); model.LastName = this.txtLastName.Text.Trim(); model.Enabled = this.chkEnabled.Checked; model.ContactEnable = this.chkEnabled.Enabled; model.MailingAddr = this.txtAddress.Text.Trim(); model.MailingCity = this.txtCity.Text.Trim(); if (this.ddlStates.SelectedIndex >= 1) { model.MailingState = this.ddlStates.SelectedValue; } model.MailingZip = this.txtZip.Text.Trim(); model.CellPhone = this.txtCellPhone.Text.Trim().Replace("(", "").Replace(")", "").Replace("-", ""); string CellPhone = model.CellPhone; if ((CellPhone != null) && (CellPhone != string.Empty)) { CellPhone = System.Text.RegularExpressions.Regex.Replace(CellPhone, @"[-() ]", String.Empty); if ((CellPhone.Length != 10) && (CellPhone.Length > 0)) { PageCommon.WriteJsEnd(this, "Cell phone number must be 10 digits.", PageCommon.Js_RefreshSelf); return(null); } } model.BusinessPhone = this.txtBizPhone.Text.Trim().Replace("(", "").Replace(")", "").Replace("-", ""); string BusinessPhone = model.BusinessPhone; if ((BusinessPhone != null) && (BusinessPhone != string.Empty)) { BusinessPhone = System.Text.RegularExpressions.Regex.Replace(BusinessPhone, @"[-() ]", String.Empty); if ((BusinessPhone.Length != 10) && (BusinessPhone.Length > 0)) { PageCommon.WriteJsEnd(this, "Business phone number must be 10 digits.", PageCommon.Js_RefreshSelf); return(null); } } model.Email = this.txtEmail.Text.Trim(); model.Fax = this.txtFax.Text.Trim().Replace("(", "").Replace(")", "").Replace("-", ""); string Fax = model.Fax; if ((Fax != null) && (Fax != string.Empty)) { Fax = System.Text.RegularExpressions.Regex.Replace(Fax, @"[-() ]", String.Empty); if ((Fax.Length != 10) && (Fax.Length > 0)) { PageCommon.WriteJsEnd(this, "Fax number must be 10 digits.", PageCommon.Js_RefreshSelf); return(null); } } if (this.FileUpload1.PostedFile.ContentLength > 0) { byte[] ImageData = new byte[this.FileUpload1.PostedFile.ContentLength]; this.FileUpload1.PostedFile.InputStream.Read(ImageData, 0, this.FileUpload1.PostedFile.ContentLength); model.Picture = ImageData; } string sMySignature = this.txtSignature.Text.Trim(); model.Signature = sMySignature; return(model); }
protected int CreateContactAndProspect(string sFirstName, string sLastName, string sEmail, string sType, string sPhone, string sDOB, string sSSN, int iUserID, string Purpose) { #region create new contact LPWeb.Model.Contacts ContactsModel = new LPWeb.Model.Contacts(); ContactsModel.ContactId = 0; ContactsModel.FirstName = sFirstName; ContactsModel.LastName = sLastName; ContactsModel.Email = sEmail; if (sType == "Cell Phone") { ContactsModel.CellPhone = sPhone; ContactsModel.HomePhone = string.Empty; ContactsModel.BusinessPhone = string.Empty; } else if (sType == "Home Phone") { ContactsModel.CellPhone = string.Empty; ContactsModel.HomePhone = sPhone; ContactsModel.BusinessPhone = string.Empty; } else if (sType == "Work Phone") { ContactsModel.CellPhone = string.Empty; ContactsModel.HomePhone = string.Empty; ContactsModel.BusinessPhone = sPhone; } if (sDOB == string.Empty) { ContactsModel.DOB = null; } else { ContactsModel.DOB = Convert.ToDateTime(sDOB); } ContactsModel.SSN = sSSN; ContactsModel.MiddleName = string.Empty; ContactsModel.NickName = txtFirstName.Text.Trim(); ContactsModel.Title = string.Empty; ContactsModel.GenerationCode = string.Empty; ContactsModel.Fax = string.Empty; ContactsModel.MailingAddr = string.Empty; ContactsModel.MailingCity = string.Empty; ContactsModel.MailingState = string.Empty; ContactsModel.MailingZip = string.Empty; #endregion #region create new prospect LPWeb.Model.Prospect ProspectModel = new LPWeb.Model.Prospect(); ProspectModel.PreferredContact = sType; ProspectModel.Contactid = 0; ProspectModel.Created = DateTime.Now; ProspectModel.CreatedBy = iUserID; ProspectModel.LeadSource = ddlLeadSource.SelectedValue.ToString() == "0" ? "" : this.ddlLeadSource.SelectedItem.Text; string sLoanOfficerID = ddlLoanOfficer.SelectedValue; iLoanOfficerID = 0; if (sLoanOfficerID == "-1" || sLoanOfficerID == "-2") { //Nobody } else if (sLoanOfficerID == "0") { //Lead Routing Engine try { ServiceManager sm = new ServiceManager(); using (LP2ServiceClient client = sm.StartServiceClient()) { //invoke the WCF API GetNextLoanOfficer LR_GetNextLoanOfficerReq req = new LR_GetNextLoanOfficerReq(); req.LeadSource = ddlLeadSource.SelectedItem.Text; req.Purpose = Purpose; req.ReqHdr = new ReqHdr(); req.ReqHdr.UserId = CurrUser.iUserID; req.ReqHdr.SecurityToken = "SecurityToken"; LR_GetNextLoanOfficerResp response = client.LeadRouting_GetNextLoanofficer(req); if (response.RespHdr.Successful) { iLoanOfficerID = response.NextLoanOfficerID; } else { Company_Lead_Sources LeadSourceMgr = new Company_Lead_Sources(); DataTable SelLeadSourceList = LeadSourceMgr.GetList("LeadSourceID='" + ddlLeadSource.SelectedValue + "'").Tables[0]; if (SelLeadSourceList != null && SelLeadSourceList.Rows.Count > 0) { iLoanOfficerID = SelLeadSourceList.Rows[0]["DefaultUserId"] == DBNull.Value ? 0 : Convert.ToInt32(SelLeadSourceList.Rows[0]["DefaultUserId"]); } } } } catch (Exception ex) { Company_Lead_Sources LeadSourceMgr = new Company_Lead_Sources(); DataTable SelLeadSourceList = LeadSourceMgr.GetList("LeadSourceID='" + ddlLeadSource.SelectedValue + "'").Tables[0]; if (SelLeadSourceList != null && SelLeadSourceList.Rows.Count > 0) { iLoanOfficerID = SelLeadSourceList.Rows[0]["DefaultUserId"] == DBNull.Value ? 0 : Convert.ToInt32(SelLeadSourceList.Rows[0]["DefaultUserId"]); } } } else { iLoanOfficerID = Convert.ToInt32(sLoanOfficerID); } ProspectModel.Loanofficer = iLoanOfficerID; ProspectModel.ReferenceCode = string.Empty; ProspectModel.Status = "Active"; ProspectModel.CreditRanking = string.Empty; ProspectModel.Referral = null; Prospect ProspectManager = new Prospect(); int iContactId = ProspectManager.CreateContactAndProspect(ContactsModel, ProspectModel); #endregion return(iContactId); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(LPWeb.Model.Contacts model) { dal.Update(model); }