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