//public object Search([FromUri] string query) => PolicyMotorMdl.search_policys(query); public object Search(string q) { try { return(PolicyMotorMdl.search_policys(q)); } catch (Exception e) { return(new { state = false, message = "Server Error", exception = e }); } }
// GET: api/PolicyMotor/ public dynamic Get(int id) { try { return(PolicyMotorMdl.get_policy(id)); } catch (Exception e) { return(new { state = false, message = "Server Error", exception = e }); } }
// GET: api/Product public object Get() { try { return(PolicyMotorMdl.get_policys_est()); } catch (Exception e) { return(new { state = false, message = "Server Error", exception = e }); } }
public object Save([FromBody] INS_UWD_POLICY_HEAD motor) { try { var result = PolicyMotorMdl.save_motor(motor); return(new { state = true, message = "Motor Policy Successfully Saved", result = new { result.POLH_SYS_ID, result.POLH_END_NO, result.POLH_STATUS, result.POLH_TXN_STATE, result.POLH_POL_STATE, result.POLH_DISPLAY_NO, result.POLH_QUT_SER_NO, } }); } catch (Exception e) { return(new { state = false, message = "Server Error", exception = e }); } }
public object EndDeletionData(int polSysId, int endNo) { try { var motor = PolicyHistoryMdl.GetHPolicyHead(polSysId, endNo); motor.POLH_TXN_STATE = "P"; var result = PolicyMotorMdl.SaveEndsmntCancl(motor); return(new { state = true, message = "Endorsement Successfully canceled", //data = motor }); } catch (Exception e) { return(new { state = false, message = "Server Error", exception = e }); } }
public object Confirm(int polId) { var db = new SibaModel(); try { var polHead = PolicyMotorMdl.get_policy(polId); var premRegs = (from pr in db.INS_PREMIUM_REGISTER where pr.PR_POL_SYS_ID == polId select pr); if (premRegs.Any()) { var premReg = premRegs.Single(); var acntInts = (from a in db.MS_ACCTS_INTEGRATION where a.INT_PRODUCT == premReg.PR_COB && a.INT_TXN_SOURCE == premReg.PR_TXN_REF select a); if (acntInts.Any()) { var acntInt = acntInts.SingleOrDefault(); var polFees = (from f in db.INS_UDW_POL_FEES where f.POL_FEE_POL_SYS_ID == polId select f).ToList(); var commissions = (from c in db.INS_UWD_INTERMEDIARY_COMM where c.CMM_POL_SYS_ID == polId select c).ToList(); var vehrisk = (from u in db.INS_UWD_VEHICLE_RISK where u.VEH_POLH_SYS_ID == polId select u).ToList(); var acntMod = new PolicyApprovalMdl(); var result = acntMod.ForwardTransaction(polHead, vehrisk, premReg, acntInt, polFees, commissions); return(result); } else { return new { state = false, message = "The Account is not properly setup" } }; } else { return new { state = false, message = "No record found in the premium register" } }; } catch (Exception e) { return(new { state = false, message = "Server Error", exception = e }); } }
public static INS_UWD_POLICY_HEAD GetPolicyHeader(int id) { var db = new SibaModel(); return((from polh in db.INS_UWD_POLICY_HEAD where polh.POLH_SYS_ID == id select polh).ToList() .Select(polh => new INS_UWD_POLICY_HEAD { POLH_SYS_ID = polh.POLH_SYS_ID, POLH_DOC_NO = polh.POLH_DOC_NO, POLH_END_NO = polh.POLH_END_NO, POLH_QUT_SER_NO = polh.POLH_QUT_SER_NO, POLH_POL_SER_NO = polh.POLH_POL_SER_NO, MS_SYS_COMPANY = CompanyMdl.get_company(polh.POLH_CMP_CODE), MS_SYS_OFFICE = OfficeMdl.get_office(polh.POLH_OFF_CODE), MS_UDW_CUSTOMERS = CustomerMdl.get_customer(polh.POLH_CUST_CODE), MS_SYS_SOURCE_BUSINESS = SourceBusinessMdl.get_sourcebusiness(polh.POLH_BIZ_SOURCE), MS_SYS_INTERMEDIARY = IntermediaryMdl.get_intermediary(polh.POLH_INTERMIDIARY), MST_UWD_PRODUCT = ProductMdl.get_product(polh.POLH_SUB_CLASS_CODE), MS_UDW_CLASS_OF_BUSINESS = ClassBusinessMdl.get_class(polh.POLH_CLASS_CODE), MS_SYS_CHANNEL = ChannelMdl.get_channel(polh.POLH_CHANNEL_CODE), MS_SYS_EXCHANGE_RATES = ExchangerateMdl.get_exchangerate(polh.POLH_CURRENCY), INS_UDW_INSUR_SOURCE = InsuranceSourceMdl.get_insource(polh.POLH_INS_SOURCE), POLH_CLASS_CODE = polh.POLH_CLASS_CODE, POLH_SUB_CLASS_CODE = polh.POLH_SUB_CLASS_CODE, POLH_CHANNEL_CODE = polh.POLH_CHANNEL_CODE, POLH_CMP_CODE = polh.POLH_CMP_CODE, POLH_OFF_CODE = polh.POLH_OFF_CODE, POLH_CUST_CODE = polh.POLH_CUST_CODE, POLH_INS_SOURCE = polh.POLH_INS_SOURCE, POLH_BIZ_SOURCE = polh.POLH_BIZ_SOURCE, POLH_INTERMIDIARY = polh.POLH_INTERMIDIARY, POLH_POL_START_DATE = polh.POLH_POL_START_DATE, POLH_POL_END_DATE = polh.POLH_POL_END_DATE, POLH_POL_DAYS = polh.POLH_POL_DAYS, POLH_POL_UW_YEAR = polh.POLH_POL_UW_YEAR, POLH_POL_SI_FC = polh.POLH_POL_SI_FC, POLH_POL_SI_BC = polh.POLH_POL_SI_BC, POLH_POL_PREM_FC = polh.POLH_POL_PREM_FC, POLH_POL_PREM_BC = polh.POLH_POL_PREM_BC, POLH_POL_COMM_FC = polh.POLH_POL_COMM_FC, POLH_POL_COMM_BC = polh.POLH_POL_COMM_BC, POLH_POL_DISC_FC = polh.POLH_POL_DISC_FC, POLH_POL_DISC_BC = polh.POLH_POL_DISC_BC, POLH_POL_LOAD_FC = polh.POLH_POL_LOAD_FC, POLH_POL_LOAD_BC = polh.POLH_POL_LOAD_BC, POLH_COINS_SI_FC = polh.POLH_COINS_SI_FC, POLH_COINS_SI_BC = polh.POLH_COINS_SI_BC, POLH_COINS_PREM_FC = polh.POLH_COINS_PREM_FC, POLH_COINS_PREM_BC = polh.POLH_COINS_PREM_BC, POLH_NET_SI_FC = polh.POLH_NET_SI_FC, POLH_NET_SI_BC = polh.POLH_NET_SI_BC, POLH_NET_PREM_FC = polh.POLH_NET_PREM_FC, POLH_NET_PREM_BC = polh.POLH_NET_PREM_BC, POLH_FEE_FC = polh.POLH_FEE_FC, POLH_FEE_BC = polh.POLH_FEE_BC, POLH_RENEW_SER_NO = polh.POLH_RENEW_SER_NO, POLH_TXN_STATE = polh.POLH_TXN_STATE, POLH_POL_STATE = polh.POLH_POL_STATE, POLH_END_TYPE = polh.POLH_END_TYPE, POLH_APPROVE_DATE = polh.POLH_APPROVE_DATE, POLH_ACCT_DATE = polh.POLH_ACCT_DATE, POLH_DISPLAY_NO = polh.POLH_DISPLAY_NO, POLH_CRTE_BY = polh.POLH_CRTE_BY, POLH_CRTE_DATE = polh.POLH_CRTE_DATE, POLH_MOD_BY = polh.POLH_MOD_BY, POLH_MOD_DATE = polh.POLH_MOD_DATE, POLH_STATUS = polh.POLH_STATUS, POLH_CURRENCY = polh.POLH_CURRENCY, POLH_CURRENCY_RATE = polh.POLH_CURRENCY_RATE, INS_UWD_VEHICLE_RISK = polh.INS_UWD_VEHICLE_RISK != null ? polh.INS_UWD_VEHICLE_RISK.Select(r => PolicyMotorMdl.get_motor(r.VEH_SYS_ID)).ToList() : null, INS_UWD_INTERMEDIARY_COMM = polh.INS_UWD_INTERMEDIARY_COMM != null ? polh.INS_UWD_INTERMEDIARY_COMM.Select(r => IntermediaryCommissionMdl.get_Insintermcomm(r.CMM_SYS_ID)).ToList() : null, INS_UDW_POL_FEES = polh.INS_UDW_POL_FEES != null ? polh.INS_UDW_POL_FEES.Select(r => PolicyFeesMdl.get_fees(r.POL_FEE_SYS_ID)).ToList() : null, }).Single()); }
public static INS_UWD_POLICY_HEAD GetPolicyHeader(int id) { var db = new SibaModel(); return((from polh in db.INS_UWD_POLICY_HEAD where polh.POLH_SYS_ID == id select polh).ToList() .Select(polh => new INS_UWD_POLICY_HEAD { POLH_SYS_ID = polh.POLH_SYS_ID, POLH_DOC_NO = polh.POLH_DOC_NO, POLH_END_NO = polh.POLH_END_NO, POLH_QUT_SER_NO = polh.POLH_QUT_SER_NO, POLH_POL_SER_NO = polh.POLH_POL_SER_NO, MS_SYS_COMPANY = CompanyMdl.get_company(polh.POLH_CMP_CODE), MS_SYS_OFFICE = OfficeMdl.get_office(polh.POLH_OFF_CODE), MS_UDW_CUSTOMERS = CustomerMdl.get_customer(polh.POLH_CUST_CODE), MS_SYS_SOURCE_BUSINESS = SourceBusinessMdl.get_sourcebusiness(polh.POLH_INS_SOURCE), MS_SYS_INTERMEDIARY = IntermediaryMdl.get_intermediary(polh.POLH_INTERMIDIARY), MST_UWD_PRODUCT = ProductMdl.get_product(polh.POLH_SUB_CLASS_CODE), MS_UDW_CLASS_OF_BUSINESS = ClassBusinessMdl.get_class(polh.POLH_CLASS_CODE), MS_SYS_CHANNEL = ChannelMdl.get_channel(polh.POLH_CHANNEL_CODE), POLH_CLASS_CODE = polh.POLH_CLASS_CODE, POLH_SUB_CLASS_CODE = polh.POLH_SUB_CLASS_CODE, POLH_CHANNEL_CODE = polh.POLH_CHANNEL_CODE, POLH_CMP_CODE = polh.POLH_CMP_CODE, POLH_OFF_CODE = polh.POLH_OFF_CODE, POLH_CUST_CODE = polh.POLH_CUST_CODE, POLH_INS_SOURCE = polh.POLH_INS_SOURCE, POLH_BIZ_SOURCE = polh.POLH_BIZ_SOURCE, POLH_INTERMIDIARY = polh.POLH_INTERMIDIARY, POLH_POL_START_DATE = polh.POLH_POL_START_DATE, POLH_POL_END_DATE = polh.POLH_POL_END_DATE, POLH_POL_DAYS = polh.POLH_POL_DAYS, POLH_POL_UW_YEAR = polh.POLH_POL_UW_YEAR, POLH_POL_SI_FC = polh.POLH_POL_SI_FC, POLH_POL_SI_BC = polh.POLH_POL_SI_BC, POLH_POL_PREM_FC = polh.POLH_POL_PREM_FC, POLH_POL_PREM_BC = polh.POLH_POL_PREM_BC, POLH_POL_COMM_FC = polh.POLH_POL_COMM_FC, POLH_POL_COMM_BC = polh.POLH_POL_COMM_BC, POLH_POL_DISC_FC = polh.POLH_POL_DISC_FC, POLH_POL_DISC_BC = polh.POLH_POL_DISC_BC, POLH_POL_LOAD_FC = polh.POLH_POL_LOAD_FC, POLH_POL_LOAD_BC = polh.POLH_POL_LOAD_BC, POLH_COINS_SI_FC = polh.POLH_COINS_SI_FC, POLH_COINS_SI_BC = polh.POLH_COINS_SI_BC, POLH_COINS_PREM_FC = polh.POLH_COINS_PREM_FC, POLH_COINS_PREM_BC = polh.POLH_COINS_PREM_BC, POLH_NET_SI_FC = polh.POLH_NET_SI_FC, POLH_NET_SI_BC = polh.POLH_NET_SI_BC, POLH_NET_PREM_FC = polh.POLH_NET_PREM_FC, POLH_NET_PREM_BC = polh.POLH_NET_PREM_BC, POLH_FEE_FC = polh.POLH_FEE_FC, POLH_FEE_BC = polh.POLH_FEE_BC, POLH_RENEW_SER_NO = polh.POLH_RENEW_SER_NO, POLH_TXN_STATE = polh.POLH_TXN_STATE, POLH_POL_STATE = polh.POLH_POL_STATE, POLH_END_TYPE = polh.POLH_END_TYPE, POLH_APPROVE_DATE = polh.POLH_APPROVE_DATE, POLH_ACCT_DATE = polh.POLH_ACCT_DATE, POLH_DISPLAY_NO = polh.POLH_DISPLAY_NO, POLH_CRTE_BY = polh.POLH_CRTE_BY, POLH_CRTE_DATE = polh.POLH_CRTE_DATE, POLH_MOD_BY = polh.POLH_MOD_BY, POLH_MOD_DATE = polh.POLH_MOD_DATE, POLH_STATUS = polh.POLH_STATUS, POLH_CURRENCY = polh.POLH_CURRENCY, POLH_CURRENCY_RATE = polh.POLH_CURRENCY_RATE, INS_UDW_BONDS = polh.INS_UDW_BONDS != null ? polh.INS_UDW_BONDS.Select(r => PolicyBondMdl.get_bond(r.BOND_SYS_ID)).ToList() : null, INS_UWD_VEHICLE_RISK = polh.INS_UWD_VEHICLE_RISK != null ? polh.INS_UWD_VEHICLE_RISK.Select(r => PolicyMotorMdl.get_motor(r.VEH_SYS_ID)).ToList() : null, INS_UDW_TRAVEL_RISK_HEAD = polh.INS_UDW_TRAVEL_RISK_HEAD != null ? polh.INS_UDW_TRAVEL_RISK_HEAD.Select(r => PolicyTravelMdl.get_travel_head(r.TRAH_SYS_ID)).ToList() : null, INS_UDW_TRAVEL_RISK = polh.INS_UDW_TRAVEL_RISK != null ? polh.INS_UDW_TRAVEL_RISK.Select(r => PolicyTravelMdl.get_traveller(r.TRA_SYS_ID)).ToList() : null, INS_UWD_FIRE_LOCRISK = polh.INS_UWD_FIRE_LOCRISK != null ? polh.INS_UWD_FIRE_LOCRISK.Select(r => PolicyFireMdl.get_fire_locrisk(r.PLOC_SYS_ID)).ToList() : null, INS_UWD_FIRE_LOCINT = polh.INS_UWD_FIRE_LOCINT != null ? polh.INS_UWD_FIRE_LOCINT.Select(r => PolicyFireMdl.get_fire_locint(r.LINT_SYS_ID)).ToList() : null, INS_UDW_GENERAL_ACCIDENT = polh.INS_UDW_GENERAL_ACCIDENT != null ? polh.INS_UDW_GENERAL_ACCIDENT.Select(r => PolicyGAMdl.get_ga_header(r.GA_SYS_ID)).ToList() : null, INS_UWD_RISK_COVERS = polh.INS_UWD_RISK_COVERS != null ? polh.INS_UWD_RISK_COVERS.Select(r => PolicyRiskCovers.get_riskcovers(r.RCOV_SYS_ID)).ToList() : null, INS_UWD_INTERMEDIARY_COMM = polh.INS_UWD_INTERMEDIARY_COMM != null ? polh.INS_UWD_INTERMEDIARY_COMM.Select(r => IntermediaryCommissionMdl.get_Insintermcomm(r.CMM_SYS_ID)).ToList() : null, INS_UDW_POL_FEES = polh.INS_UDW_POL_FEES != null ? polh.INS_UDW_POL_FEES.Select(r => PolicyFeesMdl.get_fees(r.POL_FEE_SYS_ID)).ToList() : null, //INSURANCE_LEDGER = polh.INSURANCE_LEDGER != null ? polh.INSURANCE_LEDGER.Select(c => InsuranceLedger.get_ledger(c.IGL_SYS_ID)).ToList() : null, }).Single()); }
public IEnumerable <object> get_estimate_risk(ProductsRisksCoversJSON riskJson) { var riskLst = PolicyMotorMdl.get_estimate_risk(riskJson.CLM_EST_RISK).ToList(); return(riskLst); }