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);
}
