public object Get()
{
try
{
return(PolicyBondMdl.get_policys_est());
}
catch (Exception e)
{
return(new { state = false, message = "Server Error", exception = e });
}
}
public object Searchest(string q)
{
try
{
return(PolicyBondMdl.search_policys_est(q));
}
catch (Exception e)
{
return(new { state = false, message = "Server Error", exception = e });
}
}
public dynamic Get(int code)
{
try
{
return(PolicyBondMdl.get_policy(code));
}
catch (Exception e)
{
return(new { state = false, message = "Server Error", exception = e });
}
}
public object ConfirmBond(int polId)
{
var db = new SibaModel();
try
{
var polHead = PolicyBondMdl.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 bondrisk = (from u in db.INS_UDW_BONDS where u.BOND_POLH_SYS_ID == polId select u).ToList();
var acntMod = new PolicyBondApprovalMdl();
var result = acntMod.ForwardTransaction(polHead, bondrisk, 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 object Save([FromBody] INS_UWD_POLICY_HEAD policy)
{
try
{
var result = PolicyBondMdl.save_policy(policy);
return(new { state = true, message = "Bond 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 = e });
}
}
public object EndDeletionData(int polSysId, int endNo)
{
try
{
var risk = PolicyHistoryMdl.GetHPolicyHead(polSysId, endNo);
risk.POLH_TXN_STATE = "P";
var result = PolicyBondMdl.SaveEndsmntCancl(risk);
return(new
{
state = true,
message = "Endorsement Successfully canceled",
//data = motor
});
}
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_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 = PolicyBondMdl.get_estimate_risk(riskJson.CLM_EST_RISK).ToList();
return(riskLst);
}
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),
MS_SYS_EXCHANGE_RATES = ExchangerateMdl.get_exchangerate(polh.POLH_CURRENCY),
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_INTERMEDIARY_COMM = polh.INS_UWD_INTERMEDIARY_COMM != null ? polh.INS_UWD_INTERMEDIARY_COMM.Select(r => IntermediaryCommissionMdl.get_Insintermcomm(r.CMM_SYS_ID)).ToList() : null,
}).Single());
}
