private DataTable GetHomeSubItems(RR.HomeInsurancePolicyDetails homePolicyDetails, BLO.HomeInsurancePolicyDetails homeInsurance) { DataTable subitems = new DataTable(); subitems.Columns.Add("HOMEID", typeof(Int32)); subitems.Columns.Add("LINKID", typeof(string)); subitems.Columns.Add("DOCUMENTNO", typeof(string)); subitems.Columns.Add("ITEMSERIALNO", typeof(Int32)); subitems.Columns.Add("ITEMCODE", typeof(string)); subitems.Columns.Add("ITEMNAME", typeof(string)); subitems.Columns.Add("SUBITEMSERIALNO", typeof(Int32)); subitems.Columns.Add("SUBITEMCODE", typeof(string)); subitems.Columns.Add("SUBITEMNAME", typeof(string)); subitems.Columns.Add("DESCRIPTION", typeof(string)); subitems.Columns.Add("SUMINSURED", typeof(decimal)); subitems.Columns.Add("REMARKS", typeof(string)); subitems.Columns.Add("CREATEDBY", typeof(Int32)); subitems.Columns.Add("CREATEDDATE", typeof(DateTime)); subitems.Columns.Add("UPDATEDBY", typeof(Int32)); subitems.Columns.Add("UPDATEDDATE", typeof(DateTime)); foreach (var items in homePolicyDetails.HomeSubItemsList) { subitems.Rows.Add(0, "", "", 0, "", "", items.SubItemSerialNo, items.SubItemCode, items.SubItemName, items.Description, items.SumInsured, "", homeInsurance.HomeInsurancePolicy.CreatedBy, null, homeInsurance.HomeInsurancePolicy.CreatedBy, null); } return(subitems); }
private DataTable GetHomeDomesticHelps(RR.HomeInsurancePolicyDetails homePolicyDetails, BLO.HomeInsurancePolicyDetails homeInsurance) { DataTable domestichelp = new DataTable(); domestichelp.Columns.Add("HOMEID", typeof(Int32)); domestichelp.Columns.Add("LINKID", typeof(string)); domestichelp.Columns.Add("DOCUMENTNO", typeof(string)); domestichelp.Columns.Add("LINENO", typeof(Int32)); domestichelp.Columns.Add("SERIALNO", typeof(Int32)); domestichelp.Columns.Add("ITEMSERIALNO", typeof(Int32)); domestichelp.Columns.Add("ITEMCODE", typeof(string)); domestichelp.Columns.Add("ITEMNAME", typeof(string)); domestichelp.Columns.Add("MEMBERSERIALNO", typeof(Int32)); domestichelp.Columns.Add("NAME", typeof(string)); domestichelp.Columns.Add("CPRNUMBER", typeof(string)); domestichelp.Columns.Add("TITLE", typeof(string)); domestichelp.Columns.Add("SEX", typeof(char)); domestichelp.Columns.Add("AGE", typeof(Int32)); domestichelp.Columns.Add("DATEOFBIRTH", typeof(DateTime)); domestichelp.Columns.Add("SUMINSURED", typeof(decimal)); domestichelp.Columns.Add("PREMIUMAMOUNT", typeof(decimal)); domestichelp.Columns.Add("CREATEDBY", typeof(Int32)); domestichelp.Columns.Add("CREATEDDATE", typeof(DateTime)); domestichelp.Columns.Add("UPDATEDBY", typeof(Int32)); domestichelp.Columns.Add("UPDATEDDATE", typeof(DateTime)); domestichelp.Columns.Add("OCCUPATION", typeof(string)); domestichelp.Columns.Add("NATIONALITY", typeof(string)); foreach (var members in homePolicyDetails.HomeDomesticHelpList) { domestichelp.Rows.Add(0, "", "", 0, 0, 0, "", "", members.MemberSerialNo, members.Name, members.CPR, members.Title, members.Sex, members.Age, members.DOB, members.SumInsured, members.PremiumAmount, homeInsurance.HomeInsurancePolicy.CreatedBy, null, homeInsurance.HomeInsurancePolicy.CreatedBy, null, members.Occupation, members.Nationality); } return(domestichelp); }
public RR.HomeInsurancePolicyResponse PostPolicy(RR.HomeInsurancePolicyDetails homePolicyDetails) { try { if (ModelState.IsValid) { BLO.HomeInsurancePolicyDetails homeInsurance = new BLO.HomeInsurancePolicyDetails(); homeInsurance.HomeInsurancePolicy.HomeID = homePolicyDetails.HomeInsurancePolicy.HomeID; homeInsurance.HomeInsurancePolicy.InsuredCode = homePolicyDetails.HomeInsurancePolicy.InsuredCode; homeInsurance.HomeInsurancePolicy.InsuredName = homePolicyDetails.HomeInsurancePolicy.InsuredName; homeInsurance.HomeInsurancePolicy.CPR = homePolicyDetails.HomeInsurancePolicy.CPR; homeInsurance.HomeInsurancePolicy.Agency = homePolicyDetails.HomeInsurancePolicy.Agency; homeInsurance.HomeInsurancePolicy.AgentCode = homePolicyDetails.HomeInsurancePolicy.AgentCode; homeInsurance.HomeInsurancePolicy.AgentBranch = homePolicyDetails.HomeInsurancePolicy.AgentBranch; homeInsurance.HomeInsurancePolicy.MainClass = homePolicyDetails.HomeInsurancePolicy.MainClass; homeInsurance.HomeInsurancePolicy.SubClass = homePolicyDetails.HomeInsurancePolicy.SubClass; homeInsurance.HomeInsurancePolicy.PolicyStartDate = homePolicyDetails.HomeInsurancePolicy.PolicyStartDate; homeInsurance.HomeInsurancePolicy.BuildingValue = homePolicyDetails.HomeInsurancePolicy.BuildingValue; homeInsurance.HomeInsurancePolicy.ContentValue = homePolicyDetails.HomeInsurancePolicy.ContentValue; homeInsurance.HomeInsurancePolicy.JewelleryValue = homePolicyDetails.HomeInsurancePolicy.JewelleryValue; homeInsurance.HomeInsurancePolicy.PremiumAfterDiscount = homePolicyDetails.HomeInsurancePolicy.PremiumAfterDiscount; homeInsurance.HomeInsurancePolicy.PremiumBeforeDiscount = homePolicyDetails.HomeInsurancePolicy.PremiumBeforeDiscount; homeInsurance.HomeInsurancePolicy.BuildingAge = homePolicyDetails.HomeInsurancePolicy.BuildingAge; homeInsurance.HomeInsurancePolicy.IsPropertyMortgaged = homePolicyDetails.HomeInsurancePolicy.IsPropertyMortgaged; homeInsurance.HomeInsurancePolicy.FinancierCode = homePolicyDetails.HomeInsurancePolicy.FinancierCode; homeInsurance.HomeInsurancePolicy.IsSafePropertyInsured = homePolicyDetails.HomeInsurancePolicy.IsSafePropertyInsured; homeInsurance.HomeInsurancePolicy.JewelleryCover = homePolicyDetails.HomeInsurancePolicy.JewelleryCover; homeInsurance.HomeInsurancePolicy.IsRiotStrikeDamage = homePolicyDetails.HomeInsurancePolicy.IsRiotStrikeDamage; homeInsurance.HomeInsurancePolicy.IsJointOwnership = homePolicyDetails.HomeInsurancePolicy.IsJointOwnership; homeInsurance.HomeInsurancePolicy.JointOwnerName = homePolicyDetails.HomeInsurancePolicy.JointOwnerName; homeInsurance.HomeInsurancePolicy.IsPropertyInConnectionTrade = homePolicyDetails.HomeInsurancePolicy.IsPropertyInConnectionTrade; homeInsurance.HomeInsurancePolicy.IsPropertyCoveredOtherInsurance = homePolicyDetails.HomeInsurancePolicy.IsPropertyCoveredOtherInsurance; homeInsurance.HomeInsurancePolicy.NamePolicyReasonSeekingReasons = homePolicyDetails.HomeInsurancePolicy.NamePolicyReasonSeekingReasons; homeInsurance.HomeInsurancePolicy.IsPropertyInsuredSustainedAnyLoss = homePolicyDetails.HomeInsurancePolicy.IsPropertyInsuredSustainedAnyLoss; homeInsurance.HomeInsurancePolicy.IsPropertyUndergoingConstruction = homePolicyDetails.HomeInsurancePolicy.IsPropertyUndergoingConstruction; homeInsurance.HomeInsurancePolicy.IsSingleItemAboveContents = homePolicyDetails.HomeInsurancePolicy.IsSingleItemAboveContents; homeInsurance.HomeInsurancePolicy.BuildingNo = homePolicyDetails.HomeInsurancePolicy.BuildingNo; homeInsurance.HomeInsurancePolicy.FlatNo = homePolicyDetails.HomeInsurancePolicy.FlatNo; homeInsurance.HomeInsurancePolicy.RoadNo = homePolicyDetails.HomeInsurancePolicy.RoadNo; homeInsurance.HomeInsurancePolicy.Area = homePolicyDetails.HomeInsurancePolicy.Area; homeInsurance.HomeInsurancePolicy.BlockNo = homePolicyDetails.HomeInsurancePolicy.BlockNo; homeInsurance.HomeInsurancePolicy.HouseNo = homePolicyDetails.HomeInsurancePolicy.HouseNo; homeInsurance.HomeInsurancePolicy.BuildingType = homePolicyDetails.HomeInsurancePolicy.BuildingType; homeInsurance.HomeInsurancePolicy.NoOfFloors = homePolicyDetails.HomeInsurancePolicy.NoOfFloors; homeInsurance.HomeInsurancePolicy.FFPNumber = homePolicyDetails.HomeInsurancePolicy.FFPNumber; homeInsurance.HomeInsurancePolicy.IsRequireDomestic = homePolicyDetails.HomeInsurancePolicy.IsRequireDomestic; homeInsurance.HomeInsurancePolicy.NoOfDomesticWorker = homePolicyDetails.HomeInsurancePolicy.NoOfDomesticWorker; homeInsurance.HomeInsurancePolicy.CreatedBy = homePolicyDetails.HomeInsurancePolicy.CreatedBy; homeInsurance.HomeInsurancePolicy.AuthorizedBy = homePolicyDetails.HomeInsurancePolicy.IsActivePolicy ? homePolicyDetails.HomeInsurancePolicy.CreatedBy : 0; homeInsurance.HomeInsurancePolicy.Mobile = homePolicyDetails.HomeInsurancePolicy.Mobile; homeInsurance.HomeInsurancePolicy.AccountNumber = homePolicyDetails.HomeInsurancePolicy.AccountNumber; homeInsurance.HomeInsurancePolicy.PaymentType = homePolicyDetails.HomeInsurancePolicy.PaymentType; homeInsurance.HomeInsurancePolicy.Remarks = homePolicyDetails.HomeInsurancePolicy.Remarks; homeInsurance.HomeInsurancePolicy.IsSaved = homePolicyDetails.HomeInsurancePolicy.IsSaved; homeInsurance.HomeInsurancePolicy.IsActivePolicy = homePolicyDetails.HomeInsurancePolicy.IsActivePolicy; homeInsurance.HomeInsurancePolicy.UserChangedPremium = homePolicyDetails.HomeInsurancePolicy.UserChangedPremium; homeInsurance.HomeInsurancePolicy.PremiumAfterDiscount = homePolicyDetails.HomeInsurancePolicy.PremiumAfterDiscount; homeInsurance.HomeInsurancePolicy.CommissionAfterDiscount = homePolicyDetails.HomeInsurancePolicy.CommissionAfterDiscount; homeInsurance.HomeInsurancePolicy.RenewalCount = homePolicyDetails.HomeInsurancePolicy.RenewalCount; homeInsurance.HomeInsurancePolicy.DocumentNo = homePolicyDetails.HomeInsurancePolicy.DocumentNo; homeInsurance.HomeInsurancePolicy.IsRenewal = homePolicyDetails.HomeInsurancePolicy.IsRenewal; homeInsurance.HomeInsurancePolicy.OldDocumentNumber = homePolicyDetails.HomeInsurancePolicy.OldDocumentNumber; homeInsurance.HomeInsurancePolicy.RenewalDelayedDays = homePolicyDetails.HomeInsurancePolicy.RenewalDelayedDays; homeInsurance.HomeInsurancePolicy.ActualRenewalStartDate = homePolicyDetails.HomeInsurancePolicy.ActualRenewalStartDate; homeInsurance.HomeSubItemsdt = GetHomeSubItems(homePolicyDetails, homeInsurance); homeInsurance.HomeDomesticHelpdt = GetHomeDomesticHelps(homePolicyDetails, homeInsurance); BLO.HomeInsurancePolicyResponse res = _homeInsuranceRepository.PostHomeInsurancePolicy(homeInsurance); return(_mapper.Map <BLO.HomeInsurancePolicyResponse, RR.HomeInsurancePolicyResponse>(res)); } else { var message = string.Join(" | ", ModelState.Values.SelectMany(v => v.Errors).Select(e => e.ErrorMessage)); return(new RR.HomeInsurancePolicyResponse() { IsTransactionDone = false, TransactionErrorMessage = message }); } } catch (Exception ex) { return(new RR.HomeInsurancePolicyResponse() { IsTransactionDone = false, TransactionErrorMessage = ex.Message }); } }