public object Save([FromBody] INS_RI_TTY_HEAD treaty)
{
try
{
TreatyArrangementMdl.save_treaty(treaty);
return(new { state = true, message = "Treaty successfully Saved" });
}
catch (Exception e)
{
return(new { state = false, message = e });
}
}
// Policy Confirmations
public object ForwardTransaction(INS_UWD_POLICY_HEAD polHead, List <INS_UDW_BONDS> bondrisk, INS_PREMIUM_REGISTER premRegister, MS_ACCTS_INTEGRATION acntInt, List <INS_UDW_POL_FEES> polFees, List <INS_UWD_INTERMEDIARY_COMM> commissions)
{
//obtain total amount of premium and police fees
var accountTotalBc = (premRegister.PR_BC_AMOUNT ?? 0) + (polFees == null ? 0 : polFees.Sum(x => x.POL_FEE_BC_AMOUNT));
var accountTotalFc = (premRegister.PR_FC_AMOUNT ?? 0) + (polFees == null ? 0 : polFees.Sum(x => x.POL_FEE_FC_AMOUNT));
var db = new SibaModel();
using (var trans = db.Database.BeginTransaction())
{
try
{
if (premRegister.PR_ACCT_YN == "Y" && accountTotalBc > 0 && accountTotalFc > 0)
{
var ledgerHead = new INSURANCE_LEDGER
{
IGL_ACCOUNT_CODE = polHead.MS_UDW_CUSTOMERS.MS_SYS_CUST_TYPES.MS_CUSTOMER_CATEGORY.MS_ACCT_MAIN_ACCOUNT.ACCT_CODE,
IGL_ACCT_DATE = acntInt.INT_CRTE_DATE ?? DateTime.Now,
IGL_ACCT_PERIOD_REF = "",
IGL_ACCT_REF = 0,
IGL_AMOUNT_BC = accountTotalBc,
IGL_AMOUNT_FC = accountTotalFc,
IGL_CRTE_BY = "System",
IGL_CRTE_DATE = DateTime.Now,
IGL_CURRENCY = premRegister.PR_CURRENCY,
IGL_CUST_CODE = polHead.POLH_CUST_CODE,
IGL_DOC_NUMBER = "",
IGL_DR_CR = "DR",
IGL_FX_RATE = premRegister.PR_FX_RATE,
IGL_NARRATION = "",
IGL_POL_END_NO = premRegister.PR_END_NO,
IGL_POL_NUMBER = polHead.POLH_DISPLAY_NO,
IGL_POL_SYS_ID = premRegister.PR_POL_SYS_ID,
IGL_POSTED_DATE = null,
IGL_TXN_DOC_TYPE = acntInt.INT_FWD_DEBIT_DOC_TYPE,
IGL_TXN_SOURCE = acntInt.INT_TXN_SOURCE,
IG_REF_DOC = polHead.POLH_DISPLAY_NO,
IGL_STATUS = "U"
};
//premium insurance ledger insertion
db.INSURANCE_LEDGER.Add(ledgerHead);
db.SaveChanges();
//premium total amount for customer account insurance sub ledger insertion
db.INSURANCE_SUB_LEDGER.Add(new INSURANCE_SUB_LEDGER
{
ISL_AMOUNT_BC = accountTotalBc,
ISL_ACCT_DATE = DateTime.Now,
ISL_ACCT_NUMBER = polHead.MS_UDW_CUSTOMERS.MS_SYS_CUST_TYPES.MS_CUSTOMER_CATEGORY.MS_ACCT_MAIN_ACCOUNT.ACCT_CODE,
ISL_AMOUNT_FC = accountTotalFc,
ISL_COB = premRegister.PR_COB,
ISL_CONTROL_ACT_YN = "",
ISL_CRTE_BY = "System",
ISL_CRTE_DATE = DateTime.Now,
ISL_CURRENCY = premRegister.PR_CURRENCY,
ISL_DR_CR = "DR",
ISL_FX_RATE = premRegister.PR_FX_RATE,
ISL_IGL_SYS_ID = ledgerHead.IGL_SYS_ID,
ISL_NARRATION = "",
ISL_OFFICE = polHead.POLH_OFF_CODE,
ISL_SUB_LEDGER = polHead.POLH_CUST_CODE //todo:convert to subledger sublevel2
});
//premium amount for premium account insurance sub ledger insertion
db.INSURANCE_SUB_LEDGER.Add(new INSURANCE_SUB_LEDGER
{
ISL_AMOUNT_BC = premRegister.PR_BC_AMOUNT,
ISL_ACCT_DATE = DateTime.Now,
ISL_ACCT_NUMBER = acntInt.INT_FWD_CREDIT_ACCT,
ISL_AMOUNT_FC = premRegister.PR_FC_AMOUNT,
ISL_COB = premRegister.PR_COB,
ISL_CONTROL_ACT_YN = "",
ISL_CRTE_BY = "System",
ISL_CRTE_DATE = DateTime.Now,
ISL_CURRENCY = premRegister.PR_CURRENCY,
ISL_DR_CR = "CR",
ISL_FX_RATE = premRegister.PR_FX_RATE,
ISL_IGL_SYS_ID = ledgerHead.IGL_SYS_ID,
ISL_NARRATION = "",
ISL_OFFICE = polHead.POLH_OFF_CODE,
ISL_SUB_LEDGER = premRegister.PR_COB //todo:convert to subledger level 2
});
//premium amount for policy fee account insurance sub ledger insertion
polFees.ForEach(x =>
{
var compFee = CompulsoryFeesMdl.get_CompFees(x.POL_FEE_CODE);
if (compFee != null)
{
db.INSURANCE_SUB_LEDGER.Add(new INSURANCE_SUB_LEDGER
{
ISL_AMOUNT_BC = x.POL_FEE_BC_AMOUNT,
ISL_ACCT_DATE = DateTime.Now,
ISL_ACCT_NUMBER = compFee.MS_ACCT_MAIN_ACCOUNT.ACCT_CODE,
ISL_AMOUNT_FC = x.POL_FEE_FC_AMOUNT,
ISL_COB = premRegister.PR_COB,
ISL_CONTROL_ACT_YN = "",
ISL_CRTE_BY = "System",
ISL_CRTE_DATE = DateTime.Now,
ISL_CURRENCY = premRegister.PR_CURRENCY,
ISL_DR_CR = "CR",
ISL_FX_RATE = premRegister.PR_FX_RATE,
ISL_IGL_SYS_ID = ledgerHead.IGL_SYS_ID,
ISL_NARRATION = "",
ISL_OFFICE = polHead.POLH_OFF_CODE,
ISL_SUB_LEDGER = compFee.MS_ACCT_SUB_ACCOUNT.SUB_ACCT_CODE
});
}
});
//RI Allocations for Vehecle risks
//obtain risks
bondrisk.ForEach(risk =>
{
if (risk != null)
{
//obtain the treaty group
var grpDtls = db.MS_RI_GROUP_DETL.FirstOrDefault(d => d.GD_SUB_CLASS == polHead.POLH_SUB_CLASS_CODE);
if (grpDtls != null)
{
var treatyGrpHead = grpDtls.MS_RI_GROUP_HEAD;
var tttyMsHead = treatyGrpHead.MS_RI_PTTY_HEAD.FirstOrDefault(t => t.TH_CURRENCY == polHead.POLH_CURRENCY && risk.BOND_UW_YEAR == t.TH_UWYR);
if (tttyMsHead != null)
{
var ttyhead = new INS_RI_TTY_HEAD
{
TTH_ACC_SI_BC = risk.BOND_RI_SI_BC,
TTH_ACC_SI_FC = risk.BOND_RI_SI_FC,
TTH_ADJ_YN = null,
TTH_CLASS_CODE = polHead.POLH_CLASS_CODE,
TTH_COMB_LOC_ID = null,
TTH_CRTE_BY = "System",
TTH_CRTE_DATE = DateTime.Now,
TTH_EML_PERC = grpDtls.GD_PML_PERC,
TTH_FROM_DATE = risk.BOND_START_DATE,
TTH_INS_SRCE = polHead.POLH_INS_SOURCE,
TTH_LOC_END_NO = (int?)polHead.POLH_END_NO,
TTH_LOC_SYS_ID = null,
TTH_MOD_BY = null,
TTH_MOD_DATE = null,
TTH_POLH_END_NO = (int?)polHead.POLH_END_NO,
TTH_POLH_SYS_ID = polHead.POLH_SYS_ID,
TTH_POLNUM = polHead.POLH_DISPLAY_NO,
//TTH_REF_ID = risk.BOND_SYS_ID,
TTH_RISK_END_NO = (int?)polHead.POLH_END_NO,
TTH_RISK_SYS_ID = risk.BOND_SYS_ID,
TTH_RI_ACC_YN = null,
TTH_RI_PREM_BC = risk.BOND_RI_PREM_BC,
TTH_RI_PREM_FC = risk.BOND_RI_PREM_FC,
TTH_RI_SI_BC = risk.BOND_RI_SI_BC,
TTH_RI_SI_FC = risk.BOND_RI_SI_FC,
TTH_SC_CODE = polHead.POLH_SUB_CLASS_CODE,
TTH_STATUS = "A",
TTH_TOTAL_PREM_BC = risk.BOND_TOT_PREM_BC,
TTH_TOTAL_PREM_FC = risk.BOND_TOT_PREM_FC,
TTH_TOTAL_SI_BC = risk.BOND_SI_BC,
TTH_TOTAL_SI_FC = risk.BOND_SI_FC,
TTH_TO_DATE = risk.BOND_END_DATE,
TTH_UW_YEAR = (short?)risk.BOND_UW_YEAR
};
db.INS_RI_TTY_HEAD.Add(ttyhead);
db.SaveChanges();
var excessSIFC = risk.BOND_SI_FC;
var excessSIBC = risk.BOND_SI_BC;
//Create FAC-Excess record
var exxAll = new INS_RI_TTY_ALLOCATION
{
TTA_CLOSE_FLAG = "N",
TTA_CRTE_BY = "System",
TTA_CRTE_DATE = DateTime.Now,
TTA_MOD_BY = null,
TTA_MOD_DATE = null,
TTA_POLH_END_NO = (int?)polHead.POLH_END_NO,
TTA_POLH_SYS_ID = polHead.POLH_SYS_ID,
TTA_SLIPNO = null,
TTA_STATUS = "A",
TTA_TTH_SYS_ID = ttyhead.TTH_SYS_ID,
TTA_TTY_CODE = "FAC-EXCESS",
TTA_TTY_TYPE = "FX",
TTA_TTY_COMM_BC = null,
TTA_TTY_COMM_FC = null,
TTA_TTY_LIMIT_FC = 0,
TTA_TTY_LIMIT_BC = 0,
TTA_UW_YEAR = (short?)risk.BOND_UW_YEAR
};
db.INS_RI_TTY_ALLOCATION.Add(exxAll);
db.SaveChanges();
//CREATE TREATY ALLOCATIONS AS PER TREATY SETUP
foreach (var detail in tttyMsHead.MS_RI_PTTY_DETL.OrderBy(d => d.TD_SEQ))
{
var allocation = new INS_RI_TTY_ALLOCATION
{
TTA_CLOSE_FLAG = "N",
TTA_CRTE_BY = "System",
TTA_CRTE_DATE = DateTime.Now,
TTA_MOD_BY = null,
TTA_MOD_DATE = null,
TTA_POLH_END_NO = (int?)polHead.POLH_END_NO,
TTA_POLH_SYS_ID = polHead.POLH_SYS_ID,
TTA_SEQ_NO = (byte?)detail.TD_SEQ,
TTA_SLIPNO = null,
TTA_STATUS = "A",
TTA_TTH_SYS_ID = ttyhead.TTH_SYS_ID,
TTA_TTY_CODE = tttyMsHead.TH_CODE,
TTA_TTY_COMM_BC = null,
TTA_TTY_COMM_FC = null,
TTA_UW_YEAR = (short?)risk.BOND_UW_YEAR,
TTA_TTY_TYPE = detail.TD_TTY_CODE,
};
if (detail.TD_TTY_LIMIT >= excessSIFC)
{
allocation.TTA_TTY_LIMIT_BC = detail.TD_TTY_LIMIT;
allocation.TTA_TTY_LIMIT_FC = detail.TD_TTY_LIMIT;
allocation.TTA_TTY_SI_BC = excessSIBC;
allocation.TTA_TTY_SI_FC = excessSIFC;
excessSIFC = 0;
excessSIBC = 0;
}
else
{
allocation.TTA_TTY_LIMIT_BC = detail.TD_TTY_LIMIT;
allocation.TTA_TTY_LIMIT_FC = detail.TD_TTY_LIMIT;
allocation.TTA_TTY_SI_BC = detail.TD_TTY_LIMIT;
allocation.TTA_TTY_SI_FC = detail.TD_TTY_LIMIT;
excessSIFC = (excessSIFC - detail.TD_TTY_LIMIT);
excessSIBC = (excessSIBC - detail.TD_TTY_LIMIT);
}
allocation.TTA_ALLOC_PERC = (allocation.TTA_TTY_SI_FC / risk.BOND_SI_FC) * 100;
allocation.TTA_TTY_PREM_BC = risk.BOND_TOT_PREM_BC * (allocation.TTA_ALLOC_PERC / 100);
allocation.TTA_TTY_PREM_FC = risk.BOND_TOT_PREM_FC * (allocation.TTA_ALLOC_PERC / 100);
//Update FAC Excess record
exxAll.TTA_TTY_SI_FC = excessSIFC;
exxAll.TTA_TTY_SI_BC = excessSIBC;
exxAll.TTA_ALLOC_PERC = (excessSIFC / risk.BOND_SI_FC) * 100;
exxAll.TTA_TTY_PREM_BC = risk.BOND_TOT_PREM_BC * (exxAll.TTA_ALLOC_PERC / 100);
exxAll.TTA_TTY_PREM_FC = risk.BOND_TOT_PREM_FC * (exxAll.TTA_ALLOC_PERC / 100);
exxAll.TTA_SEQ_NO = (byte)(detail.TD_SEQ + 1);
//add allocations
db.INS_RI_TTY_ALLOCATION.Add(allocation);
db.SaveChanges();
db.INS_RI_TTY_ALLOCATION.Attach(exxAll);
foreach (var company in detail.MS_RI_PTTY_COMPANY)
{
var share = new INS_RI_TTY_SHARE
{
TTS_CRTE_BY = "System",
TTS_CRTE_DATE = DateTime.Now,
TTS_MOD_BY = null,
TTS_MOD_DATE = null,
TTS_RI_COMM_BC = allocation.TTA_TTY_PREM_BC * (company.TCP_TTY_COMM / 100),
TTS_RI_COMM_FC = allocation.TTA_TTY_PREM_FC * (company.TCP_TTY_COMM / 100),
TTS_RI_COMM_PERC = company.TCP_TTY_COMM,
TTS_RI_COMP = company.TCP_COMP_CODE,
TTS_RI_TAX_PERC = company.TCP_TTY_TAX,
TTS_SHARE_PERC = company.TCP_TTY_SHARE,
TTS_SHARE_PREM_BC = allocation.TTA_TTY_PREM_BC * (company.TCP_TTY_SHARE / 100),
TTS_SHARE_PREM_FC = allocation.TTA_TTY_PREM_FC * (company.TCP_TTY_SHARE / 100),
TTS_SHARE_SI_BC = allocation.TTA_TTY_SI_BC * (company.TCP_TTY_SHARE / 100),
TTS_SHARE_SI_FC = allocation.TTA_TTY_SI_FC * (company.TCP_TTY_SHARE / 100),
TTS_STATUS = "A",
TTS_TAX_BC = (allocation.TTA_TTY_PREM_BC * (company.TCP_TTY_COMM / 100)) * (company.TCP_TTY_TAX / 100),
TTS_TAX_FC = (allocation.TTA_TTY_PREM_FC * (company.TCP_TTY_COMM / 100)) * (company.TCP_TTY_TAX / 100),
TTS_TTA_SEQ_NO = (byte)detail.TD_SEQ,
TTS_TTA_SYS_ID = allocation.TTA_SYS_ID,
TTS_TTY_TYPE = detail.TD_TTY_TYPE,
};
db.INS_RI_TTY_SHARE.Add(share);
db.SaveChanges();
}
}
}
}
}
});
commissions.ForEach(x =>
{
if (x != null)
{
var commLedger = new INSURANCE_LEDGER
{
IGL_ACCOUNT_CODE = acntInt.INT_FWD_CREDIT_ACCT,
IGL_ACCT_DATE = acntInt.INT_CRTE_DATE ?? DateTime.Now,
IGL_ACCT_PERIOD_REF = "",
IGL_ACCT_REF = 0,
IGL_AMOUNT_BC = x.CMM_COM_AMT_BC,
IGL_AMOUNT_FC = x.CMM_COM_AMT_FC,
IGL_CRTE_BY = "System",
IGL_CRTE_DATE = DateTime.Now,
IGL_CURRENCY = polHead.POLH_CURRENCY,
IGL_CUST_CODE = polHead.POLH_CUST_CODE,
IGL_DOC_NUMBER = "",
IGL_DR_CR = "CR",
IGL_FX_RATE = polHead.POLH_CURRENCY_RATE,
IGL_NARRATION = "",
IGL_POL_END_NO = x.CMM_END_NO,
IGL_POL_NUMBER = polHead.POLH_DISPLAY_NO,
IGL_POL_SYS_ID = x.CMM_POL_SYS_ID,
IGL_POSTED_DATE = null,
IGL_TXN_DOC_TYPE = acntInt.INT_FWD_CREDIT_DOC_TYPE,
IGL_TXN_SOURCE = acntInt.INT_TXN_SOURCE,
IG_REF_DOC = polHead.POLH_DISPLAY_NO,
IGL_STATUS = "U"
};
//premium insurance ledger insertion
db.INSURANCE_LEDGER.Add(commLedger);
db.SaveChanges();
//Total commission amount into insurance Commission Account (50)
db.INSURANCE_SUB_LEDGER.Add(new INSURANCE_SUB_LEDGER
{
ISL_AMOUNT_BC = x.CMM_COM_AMT_BC,
ISL_ACCT_DATE = DateTime.Now,
ISL_ACCT_NUMBER = acntInt.INT_FWD_CREDIT_ACCT,
ISL_AMOUNT_FC = x.CMM_COM_AMT_FC,
ISL_COB = x.CMM_COB_CODE,
ISL_CONTROL_ACT_YN = "",
ISL_CRTE_BY = "System",
ISL_CRTE_DATE = DateTime.Now,
ISL_CURRENCY = polHead.POLH_CURRENCY,
ISL_DR_CR = "CR",
ISL_FX_RATE = polHead.POLH_CURRENCY_RATE,
ISL_IGL_SYS_ID = commLedger.IGL_SYS_ID,
ISL_NARRATION = "",
ISL_OFFICE = polHead.POLH_OFF_CODE,
ISL_SUB_LEDGER = polHead.POLH_CUST_CODE
});
// Commission less Tax into Intermediary account (45)
//obtain tax data
var interm = IntermediaryMdl.get_intermediary(x.CMM_INT_CODE);
var custTypes = CustomerTypesMdl.get_customertype(interm.INT_CTP_CODE);
var custCategory = custTypes.MS_CUSTOMER_CATEGORY;
var tax = db.MS_ACCT_SERVICE_TAX.Where(t => t.TX_CUST_CAT_CODE == custCategory.CUS_CAT_CODE);
if (tax.Count() == 1)
{
var taxPerc = tax.Single().TX_TAX_PERC / 100;
// Math.Round((double)(() * (decimal)taxPerc), 2)
db.INSURANCE_SUB_LEDGER.Add(new INSURANCE_SUB_LEDGER
{
ISL_AMOUNT_BC = Math.Round((decimal)(x.CMM_COM_AMT_BC - (x.CMM_COM_AMT_BC * taxPerc)), 2),
ISL_ACCT_DATE = DateTime.Now,
ISL_ACCT_NUMBER = custCategory.MS_ACCT_MAIN_ACCOUNT.ACCT_CODE,
ISL_AMOUNT_FC = Math.Round((decimal)(x.CMM_COM_AMT_FC - (x.CMM_COM_AMT_FC * taxPerc)), 2),
ISL_COB = x.CMM_COB_CODE,
ISL_CONTROL_ACT_YN = "",
ISL_CRTE_BY = "System",
ISL_CRTE_DATE = DateTime.Now,
ISL_CURRENCY = polHead.POLH_CURRENCY,
ISL_DR_CR = "DR",
ISL_FX_RATE = polHead.POLH_CURRENCY_RATE,
ISL_IGL_SYS_ID = commLedger.IGL_SYS_ID,
ISL_NARRATION = "",
ISL_OFFICE = polHead.POLH_OFF_CODE,
ISL_SUB_LEDGER = custCategory.MS_ACCT_SUB_ACCOUNT.SUB_ACCT_CODE
});
//commission tax into Tax Account (5)
db.INSURANCE_SUB_LEDGER.Add(new INSURANCE_SUB_LEDGER
{
ISL_AMOUNT_BC = Math.Round((decimal)(x.CMM_COM_AMT_BC * taxPerc), 2),
ISL_ACCT_DATE = DateTime.Now,
ISL_ACCT_NUMBER = custCategory.MS_ACCT_MAIN_ACCOUNT.ACCT_CODE,
ISL_AMOUNT_FC = Math.Round((decimal)(x.CMM_COM_AMT_FC * taxPerc), 2),
ISL_COB = x.CMM_COB_CODE,
ISL_CONTROL_ACT_YN = "",
ISL_CRTE_BY = "System",
ISL_CRTE_DATE = DateTime.Now,
ISL_CURRENCY = polHead.POLH_CURRENCY,
ISL_DR_CR = "DR",
ISL_FX_RATE = polHead.POLH_CURRENCY_RATE,
ISL_IGL_SYS_ID = commLedger.IGL_SYS_ID,
ISL_NARRATION = "",
ISL_OFFICE = polHead.POLH_OFF_CODE,
ISL_SUB_LEDGER = custCategory.MS_ACCT_SUB_ACCOUNT.SUB_ACCT_CODE
});
}
}
});
//update Policy Transaction state after confirmation
var dbPolTxn = db.INS_UWD_POLICY_HEAD.Find(polHead.POLH_SYS_ID);
db.INS_UWD_POLICY_HEAD.Attach(dbPolTxn);
dbPolTxn.POLH_TXN_STATE = "C";
}
else
{
return(new { state = false, message = "Error inserting into Insurance Ledger" });
}
db.SaveChanges();
trans.Commit();
var polhed = db.INS_UWD_POLICY_HEAD.Find(polHead.POLH_SYS_ID);
var POLH_TXN_STATE = polhed.POLH_TXN_STATE;
return(new { state = true, message = "Successfully Inserted into the ledger", POLH_TXN_STATE });
}
catch (Exception e)
{
trans.Rollback();
throw;
}
}
}
public static bool save_treaty(INS_RI_TTY_HEAD viewTreaty)
{
var db = new SibaModel();
switch (viewTreaty.TTH_STATUS)
{
case "A":
{
var dbPolh = db.INS_RI_TTY_HEAD.Find(viewTreaty.TTH_SYS_ID);
if (dbPolh != null)
{
db.INS_RI_TTY_HEAD.Attach(dbPolh);
dbPolh.Map(viewTreaty);
dbPolh.TTH_MOD_DATE = DateTime.Now;
/*--------------------------------
* TREATY APPORTIONMENT
*-------------------------------*/
foreach (var apport in viewTreaty.INS_RI_TTY_ALLOCATION)
{
apport.TTA_TTH_SYS_ID = viewTreaty.TTH_SYS_ID;
switch (apport.TTA_STATUS)
{
case "A":
var dbveh = db.INS_RI_TTY_ALLOCATION.Find(apport.TTA_SYS_ID);
if (dbveh != null)
{
db.INS_RI_TTY_ALLOCATION.Attach(dbveh);
dbveh.Map(apport);
//TREATY SHARE UPDATE
foreach (var cover in apport.INS_RI_TTY_SHARE)
{
var dbCovers = db.INS_RI_TTY_SHARE.Find(cover.TTS_SYS_ID);
switch (cover.TTS_STATUS)
{
case "A":
if (dbCovers != null)
{
db.INS_RI_TTY_SHARE.Attach(dbCovers);
dbCovers.Map(cover);
dbCovers.TTS_MOD_DATE = DateTime.Now;
}
break;
case "U":
cover.TTS_STATUS = "A";
cover.TTS_CRTE_DATE = DateTime.Now;
cover.TTS_TTA_SYS_ID = apport.TTA_SYS_ID;
db.INS_RI_TTY_SHARE.Add(cover);
break;
case "D":
if (dbCovers != null)
{
db.INS_RI_TTY_SHARE.Attach(dbCovers);
dbCovers.TTS_STATUS = "D";
dbCovers.TTS_MOD_DATE = DateTime.Now;
db.INS_RI_TTY_SHARE.Remove(db.INS_RI_TTY_SHARE.Find(cover.TTS_SYS_ID));
}
break;
}
}
}
break;
case "U":
apport.TTA_TTH_SYS_ID = viewTreaty.TTH_SYS_ID;
apport.TTA_STATUS = "A";
db.INS_RI_TTY_ALLOCATION.Add(apport);
break;
case "D":
db.INS_RI_TTY_ALLOCATION.Remove(db.INS_RI_TTY_ALLOCATION.Find(apport.TTA_SYS_ID));
break;
}
}
}
}
break;
case "U":
viewTreaty.TTH_STATUS = "A";
viewTreaty.TTH_CRTE_DATE = DateTime.Now;
///*-----------------------------------------
// * updating the status of related tables
// *---------------------------------------*/
viewTreaty.INS_RI_TTY_ALLOCATION.ForEach(x => {
x.TTA_STATUS = "A";
x.INS_RI_TTY_SHARE.ForEach(c => c.TTS_STATUS = "A");
});
db.INS_RI_TTY_HEAD.Add(viewTreaty);
db.SaveChanges();
break;
case "D":
{
/*------------------------
* header before update
*----------------------*/
//
var dbPolh = db.INS_RI_TTY_HEAD.Find(viewTreaty.TTH_SYS_ID);
/*------------------------
* update of header details
*----------------------*/
//
if (dbPolh != null)
{
db.INS_RI_TTY_HEAD.Attach(dbPolh);
dbPolh.TTH_STATUS = "D";
}
}
break;
}
return(db.SaveChanges() > 0);
}
public static IEnumerable <object> Apportionment(int polId)
{
var db = new SibaModel();
//obtain the policy data
var policy = db.INS_UWD_POLICY_HEAD.Find(polId);
if (policy != null)
{
//obtain risks
policy.INS_UWD_VEHICLE_RISK.ForEach(risk =>
{
//obtain the treaty group
var grpDtls = db.MS_RI_GROUP_DETL.FirstOrDefault(d => d.GD_SUB_CLASS == policy.POLH_SUB_CLASS_CODE);
if (grpDtls != null)
{
var treatyGrpHead = grpDtls.MS_RI_GROUP_HEAD;
var treaty = treatyGrpHead.MS_RI_PTTY_HEAD.FirstOrDefault(t => t.TH_CURRENCY == policy.POLH_CURRENCY && risk.VEH_UW_YEAR == t.TH_UWYR);
if (treaty != null)
{
using (var trans = db.Database.BeginTransaction())
{
try
{
//insert treaty proportionment header
var head = new INS_RI_TTY_HEAD
{
TTH_ACC_SI_BC = risk.VEH_RI_SI_BC,
TTH_ACC_SI_FC = risk.VEH_RI_SI_FC,
TTH_ADJ_YN = null,
TTH_CLASS_CODE = policy.POLH_CLASS_CODE,
TTH_COMB_LOC_ID = null,
TTH_CRTE_BY = "System",
TTH_CRTE_DATE = DateTime.Now,
TTH_EML_PERC = grpDtls.GD_PML_PERC,
TTH_FROM_DATE = risk.VEH_START_DATE,
TTH_INS_SRCE = policy.POLH_INS_SOURCE,
TTH_LOC_END_NO = (int?)policy.POLH_END_NO,
TTH_LOC_SYS_ID = null,
TTH_MOD_BY = null,
TTH_MOD_DATE = null,
TTH_POLH_END_NO = (int?)policy.POLH_END_NO,
TTH_POLH_SYS_ID = policy.POLH_SYS_ID,
TTH_POLNUM = policy.POLH_DISPLAY_NO,
TTH_REF_ID = risk.VEH_VEH_REG_NO,
TTH_RISK_END_NO = (int?)policy.POLH_END_NO,
TTH_RISK_SYS_ID = risk.VEH_SYS_ID,
TTH_RI_ACC_YN = null,
TTH_RI_PREM_BC = risk.VEH_RI_PREM_BC,
TTH_RI_PREM_FC = risk.VEH_RISK_PREM_FC,
TTH_RI_SI_BC = risk.VEH_RI_SI_BC,
TTH_RI_SI_FC = risk.VEH_RI_SI_FC,
TTH_SC_CODE = policy.POLH_SUB_CLASS_CODE,
TTH_STATUS = "A",
TTH_TOTAL_PREM_BC = risk.VEH_TOT_PREM_BC,
TTH_TOTAL_PREM_FC = risk.VEH_TOT_PREM_FC,
TTH_TOTAL_SI_BC = risk.VEH_SI_BC,
TTH_TOTAL_SI_FC = risk.VEH_SI_FC,
TTH_TO_DATE = risk.VEH_END_DATE,
TTH_UW_YEAR = (short?)risk.VEH_UW_YEAR
};
db.INS_RI_TTY_HEAD.Add(head);
db.SaveChanges();
var excessSIFC = risk.VEH_SI_FC;
var excessSIBC = risk.VEH_SI_BC;
foreach (var detail in treaty.MS_RI_PTTY_DETL.OrderBy(d => d.TD_SEQ))
{
var allocation = new INS_RI_TTY_ALLOCATION
{
TTA_CLOSE_FLAG = "N",
TTA_CRTE_BY = "System",
TTA_CRTE_DATE = DateTime.Now,
TTA_MOD_BY = null,
TTA_MOD_DATE = null,
TTA_POLH_END_NO = (int?)policy.POLH_END_NO,
TTA_POLH_SYS_ID = policy.POLH_SYS_ID,
TTA_SEQ_NO = (byte?)detail.TD_SEQ,
TTA_SLIPNO = null,
TTA_STATUS = "A",
TTA_TTH_SYS_ID = head.TTH_SYS_ID,
TTA_TTY_CODE = treatyGrpHead.GP_CODE,
TTA_TTY_COMM_BC = null,
TTA_TTY_COMM_FC = null,
TTA_UW_YEAR = (short?)risk.VEH_UW_YEAR
};
if (detail.TD_TTY_LIMIT >= risk.VEH_SI_FC)
{
allocation.TTA_TTY_LIMIT_BC = detail.TD_TTY_LIMIT;
allocation.TTA_TTY_LIMIT_FC = detail.TD_TTY_LIMIT;
allocation.TTA_TTY_SI_BC = excessSIBC;
allocation.TTA_TTY_SI_FC = excessSIFC;
excessSIFC = 0;
excessSIBC = 0;
}
else
{
allocation.TTA_TTY_LIMIT_BC = detail.TD_TTY_LIMIT;
allocation.TTA_TTY_LIMIT_FC = detail.TD_TTY_LIMIT;
allocation.TTA_TTY_SI_BC = detail.TD_TTY_LIMIT;
allocation.TTA_TTY_SI_FC = detail.TD_TTY_LIMIT;
excessSIFC = (excessSIFC - detail.TD_TTY_LIMIT);
excessSIBC = (excessSIBC - detail.TD_TTY_LIMIT);
}
allocation.TTA_ALLOC_PERC = (allocation.TTA_TTY_SI_FC / risk.VEH_SI_FC) * 100;
allocation.TTA_TTY_PREM_BC = risk.VEH_TOT_PREM_BC * (allocation.TTA_ALLOC_PERC / 100);
allocation.TTA_TTY_PREM_FC = risk.VEH_TOT_PREM_FC * (allocation.TTA_ALLOC_PERC / 100);
//add allocations
db.INS_RI_TTY_ALLOCATION.Add(allocation);
//add Excess allocations
db.SaveChanges();
foreach (var company in detail.MS_RI_PTTY_COMPANY)
{
var share = new INS_RI_TTY_SHARE
{
TTS_CRTE_BY = "System",
TTS_CRTE_DATE = DateTime.Now,
TTS_MOD_BY = null,
TTS_MOD_DATE = null,
TTS_RI_COMM_BC = allocation.TTA_TTY_PREM_BC * (company.TCP_TTY_COMM / 100),
TTS_RI_COMM_FC = allocation.TTA_TTY_PREM_FC * (company.TCP_TTY_COMM / 100),
TTS_RI_COMM_PERC = company.TCP_TTY_COMM,
TTS_RI_COMP = company.TCP_COMP_CODE,
TTS_RI_TAX_PERC = company.TCP_TTY_TAX,
TTS_SHARE_PERC = company.TCP_TTY_SHARE,
TTS_SHARE_PREM_BC = allocation.TTA_TTY_PREM_BC * (company.TCP_TTY_SHARE / 100),
TTS_SHARE_PREM_FC = allocation.TTA_TTY_PREM_FC * (company.TCP_TTY_SHARE / 100),
TTS_SHARE_SI_BC = allocation.TTA_TTY_SI_BC * (company.TCP_TTY_SHARE / 100),
TTS_SHARE_SI_FC = allocation.TTA_TTY_SI_FC * (company.TCP_TTY_SHARE / 100),
TTS_STATUS = "A",
TTS_TAX_BC = (allocation.TTA_TTY_PREM_BC * (company.TCP_TTY_COMM / 100)) * (company.TCP_TTY_TAX / 100),
TTS_TAX_FC = (allocation.TTA_TTY_PREM_FC * (company.TCP_TTY_COMM / 100)) * (company.TCP_TTY_TAX / 100),
TTS_TTA_SEQ_NO = (byte)detail.TD_SEQ,
TTS_TTA_SYS_ID = allocation.TTA_SYS_ID,
TTS_TTY_TYPE = detail.TD_TTY_TYPE,
};
}
}
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
}
}
}
}
});
}
return(null);
}
