public CustomerEntityValidator SaveMinorProfile(MinorProfile minorProfile, string minorId, string parsedName) { var saveTrackOrder = new CustomerEntityValidator(); var minorApplicant = new customer() { ctype = "IL", fbobkind = "IL", fbonumbr = minorId, appldate = DateTime.Now, firstname = minorProfile.CustomersFirstname, middlename = minorProfile.CustomersMiddlename, lastname = minorProfile.CustomersLastname, fbobname = ($"{minorProfile.CustomersFirstname} {minorProfile.CustomersMiddlename} {minorProfile.CustomersLastname}"), sex = Convert.ToDecimal(minorProfile.CustomersSex),//is a string in the system typeofid = minorProfile.CustomersIdtype, idnumber = minorProfile.CustomersIdnumber, mailingcountry = minorProfile.CustomersCountry, town = minorProfile.CustomersCity, fbobadr1 = minorProfile.CustomersArea, nationality = minorProfile.CustomersCountry, relationshipkin = minorProfile.CustomersRelationborrower, emailname = minorProfile.CustomersEmail, homephone = minorProfile.CustomersHomephone, birthdate = DateTime.Parse(minorProfile.CustomersBirthdate), }; //Database insert operations using (var dpac = new DPACEntities()) { try { dpac.customers.Add(minorApplicant); if (dpac.SaveChanges() > 0) { saveTrackOrder.Customer = true; saveTrackOrder.CustomerId = minorId; dpac.updateCustCode(parsedName); //dpac.FMS_InsertIntoFxrefbor(minorId, "S", DateTime.Now, "AN2019-00120"); } } catch (DbEntityValidationException e) { saveTrackOrder.Customer = false; saveTrackOrder.CustomerErrMessage = e.Message; } } return(saveTrackOrder); }
public CustomerEntityValidator SaveGuarantor(Guarantor guarantor, string guarantorId, string parsedName) { //declarations ---------- List <individual_financials> assetList = new List <individual_financials>(); List <individual_financials> liabilityList = new List <individual_financials>(); var grossFamilyIncome = new customers_financial(); var saveOrderTrack = new CustomerEntityValidator(); //------------ Definitions var guarantorRec = new customer() { ctype = "IL", fbobkind = "IL", fbonumbr = guarantorId, appldate = DateTime.Now, firstname = guarantor.GuarantorPersonal.CustomersFirstname, middlename = guarantor.GuarantorPersonal.CustomersMiddlename, lastname = guarantor.GuarantorPersonal.CustomersLastname, fbobname = $"{guarantor.GuarantorPersonal.CustomersFirstname} {guarantor.GuarantorPersonal.CustomersMiddlename} {guarantor.GuarantorPersonal.CustomersLastname}", sex = Convert.ToDecimal(guarantor.GuarantorPersonal.CustomersSex),//is a string in the system mailing_address1 = guarantor.GuarantorPersonal.CustomersMailingAddress1, typeofid = guarantor.GuarantorPersonal.CustomersTypeofid, mailing_address2 = guarantor.GuarantorPersonal.CustomersMailingAddress2, mailingcountry = guarantor.GuarantorPersonal.CustomersMailingcountry, idnumber = guarantor.GuarantorPersonal.CustomersIdnumber, nationality = guarantor.GuarantorPersonal.CustomersMailingcountry, birthdate = DateTime.Parse(guarantor.GuarantorPersonal.CustomersBirthdate), next_kin = guarantor.GuarantorPersonal.CustomersNextKin, relationshipkin = guarantor.GuarantorPersonal.CustomersRelationshipkin, emailname = guarantor.GuarantorPersonal.CustomersEmailname, homephone = guarantor.GuarantorPersonal.CustomersHomephone, otherphone = guarantor.GuarantorPersonal.CustomersOtherphone, workphone = guarantor.GuarantorPersonal.CustomersWorkphone, mobilphone = guarantor.GuarantorPersonal.CustomersMobilphone, spousename = "", //Customer Financial indusgrp = "", depends = Convert.ToDecimal(guarantor.GuarantorFinancial.CustomersDepends), empstatus = Convert.ToDecimal(guarantor.GuarantorFinancial.CustomersEmpstatus), home_status = guarantor.GuarantorFinancial.CustomersHomeStatus,//Live Rent free num_inhouse = Convert.ToDecimal(guarantor.GuarantorFinancial.CustomersNumInhouse), yearsaddr = Convert.ToDecimal(guarantor.GuarantorFinancial.CustomersYearsaddr) }; if (guarantor.GuarantorFinancial.Asset != null) { foreach (var asset in guarantor.GuarantorFinancial.Asset) { assetList.Add(new individual_financials() { fbonumbr = guarantorId, code = asset.IndividualFinancialsCode, amount = Convert.ToDecimal(asset.IndividualFinancialsAmount), description = asset.IndividualFinancialsDescription }); } } if (guarantor.GuarantorFinancial.Liabilities != null) { foreach (var liability in guarantor.GuarantorFinancial.Liabilities) { liabilityList.Add(new individual_financials() { fbonumbr = guarantorId, code = liability.IndividualFinancialsCode, amount = Convert.ToDecimal(liability.IndividualFinancialsAmount), description = liability.IndividualFinancialsDescription }); } } if (guarantor.GuarantorFinancial.GrossAnnualFamilyIncome != null) { var g = guarantor.GuarantorFinancial.GrossAnnualFamilyIncome.FirstOrDefault(); grossFamilyIncome = new customers_financial() { fbonumbr = guarantorId, income2 = Convert.ToDecimal(g.CustomersFinancialIncome2), income4 = Convert.ToDecimal(g.CustomersFinancialIncome4) }; } //Database insert operations using (var dpac = new DPACEntities()) { try { dpac.customers.Add(guarantorRec); if (dpac.SaveChanges() > 0) { saveOrderTrack.Customer = true; saveOrderTrack.CustomerId = guarantorId; dpac.updateCustCode(parsedName); } } catch (DbEntityValidationException e) { saveOrderTrack.Customer = false; saveOrderTrack.CustomerErrMessage = e.Message; } //---- asset try { if (guarantor.GuarantorFinancial.Asset != null && saveOrderTrack.Customer) { foreach (var g in assetList) { dpac.individual_financials.Add(g); } } if (dpac.SaveChanges() > 0) { saveOrderTrack.Asset = true; } } catch (DbEntityValidationException e) { saveOrderTrack.Asset = false; saveOrderTrack.AssetErrMessage = e.Message; } //--- liabilites try { if (guarantor.GuarantorFinancial.Liabilities != null && saveOrderTrack.Customer) { foreach (var l in liabilityList) { dpac.individual_financials.Add(l); } } if (dpac.SaveChanges() > 0) { saveOrderTrack.Liability = true; } } catch (DbEntityValidationException e) { saveOrderTrack.Liability = false; saveOrderTrack.LiabilityErrMessage = e.Message; } // ----- gross family income try { if (guarantor.GuarantorFinancial.GrossAnnualFamilyIncome != null && saveOrderTrack.Customer) { dpac.customers_financial.Add(grossFamilyIncome); } if (dpac.SaveChanges() > 0) { saveOrderTrack.GrossFamilyIncome = true; } } catch (DbEntityValidationException e) { saveOrderTrack.GrossFamilyIncome = false; saveOrderTrack.GrossFamilyErrMessage = e.Message; } } return(saveOrderTrack); }
public CustomerEntityValidator SaveLoanApplicant(LoanApplicantProfile applicant, string applicantId, string parsedName) { //declarations List <individual_financials> assetList = new List <individual_financials>(); List <individual_financials> liabilityList = new List <individual_financials>(); customers_financial grossFamilyIncome = new customers_financial(); var saveOrderTrack = new CustomerEntityValidator(); //definitions var loanApplicant = new customer() { ctype = "IL", //default val fbobkind = "IL", //default val prefix = (Convert.ToDecimal(applicant.CustomersSex) == 1) ? "Mr" : "Ms", fbonumbr = applicantId, appldate = DateTime.Now, firstname = applicant.CustomersFirstname, middlename = applicant.CustomersMiddlename, lastname = applicant.CustomersLastname, fbobname = ($"{applicant.CustomersFirstname} {applicant.CustomersMiddlename} {applicant.CustomersLastname}"), sex = Convert.ToDecimal(applicant.CustomersSex), mailing_address1 = applicant.CustomersMailingAddress1, fbobadr1 = applicant.CustomersMailingAddress1, fbobadr2 = applicant.CustomersMailingAddress2, mailing_address2 = applicant.CustomersMailingAddress2, mailingcountry = applicant.CustomersMailingcountry, typeofid = applicant.CustomersTypeofid, idnumber = applicant.CustomersIdnumber, nationality = applicant.CustomersNationality, businessplace = applicant.CustomersBusinessplace, employfrom = (DateTime.TryParse(applicant.CustomersEmployfrom, out DateTime date)) ? date: (DateTime?)null, //Format: 1/07/2019 ---(string.IsNullOrWhiteSpace(applicant.CustomersEmployfrom))? null: applicant.CustomersEmployfrom occupation = applicant.CustomersOccupation, //customer_financial.income1 depends = Convert.ToDecimal(applicant.CustomersDepends), empstatus = Convert.ToDecimal(applicant.CustomersEmpstatus), home_status = applicant.CustomersHomeStatus,//mortgage num_inhouse = Convert.ToDecimal(applicant.CustomersNumInhouse), yearsaddr = Convert.ToDecimal(applicant.CustomersYearsaddr), next_kin = applicant.CustomersNextKin, relationshipkin = applicant.CustomersRelationshipkin, emailname = applicant.CustomersEmailname, homephone = applicant.CustomersHomephone, otherphone = applicant.CustomersOtherphone, workphone = applicant.CustomersWorkphone, mobilphone = applicant.CustomersMobilphone, spousename = "", }; //prepping assets in a list if (applicant.Asset != null) { foreach (var asset in applicant.Asset) { assetList.Add(new individual_financials() { fbonumbr = applicantId, code = asset.IndividualFinancialsCode, amount = Convert.ToDecimal(asset.IndividualFinancialsAmount), description = asset.IndividualFinancialsDescription }); } } //prepping liabilities if (applicant.Liabilities != null) { foreach (var liability in applicant.Liabilities) { liabilityList.Add(new individual_financials() { fbonumbr = applicantId, code = liability.IndividualFinancialsCode, amount = Convert.ToDecimal(liability.IndividualFinancialsAmount), description = liability.IndividualFinancialsDescription }); } } //gross family income if (applicant.GrossAnnualFamilyIncome != null) { var g = applicant.GrossAnnualFamilyIncome.FirstOrDefault(); grossFamilyIncome = new customers_financial() { fbonumbr = applicantId, income2 = Convert.ToDecimal(g.CustomersFinancialIncome2), income4 = Convert.ToDecimal(g.CustomersFinancialIncome4) }; } //database operations which will save the above entities into, you guessed it, the database using (var ctx = new DPACEntities()) { try { ctx.customers.Add(loanApplicant); if (ctx.SaveChanges() > 0) { ctx.SaveChanges(); ctx.updateCustCode(parsedName); saveOrderTrack.Customer = true; saveOrderTrack.CustomerId = applicantId; } } catch (DbEntityValidationException e) { saveOrderTrack.Customer = false; saveOrderTrack.CustomerErrMessage = e.Message; } //saving assets try { if (assetList.Any() && saveOrderTrack.Customer) { foreach (var asset in assetList) { ctx.individual_financials.Add(asset); } if (ctx.SaveChanges() > 0) { saveOrderTrack.Asset = true; } } } catch (DbEntityValidationException e) { saveOrderTrack.Asset = false; saveOrderTrack.AssetErrMessage = e.Message; } //saving liabilities try { if (liabilityList.Any() && saveOrderTrack.Customer) { foreach (var liabilities in liabilityList) { ctx.individual_financials.Add(liabilities); } } if (ctx.SaveChanges() > 0) { saveOrderTrack.Liability = true; } } catch (DbEntityValidationException e) { saveOrderTrack.Liability = false; saveOrderTrack.LiabilityErrMessage = e.Message; } //saving gross family income try { if (!grossFamilyIncome.fbonumbr.IsNullOrWhiteSpace() && saveOrderTrack.Customer) { ctx.customers_financial.Add(grossFamilyIncome); } if (ctx.SaveChanges() > 0) { saveOrderTrack.GrossFamilyIncome = true; } } catch (DbEntityValidationException e) { saveOrderTrack.GrossFamilyIncome = false; saveOrderTrack.GrossFamilyErrMessage = e.Message; } } return(saveOrderTrack); }