public static MS_ACCT_RECEIPTS_DTLS GetReceiptDtl(int id)
{
var db = new SibaModel();
return((from rd in db.MS_ACCT_RECEIPTS_DTLS where rd.ARD_SYS_ID == id select rd).ToList()
.Select(rd => new MS_ACCT_RECEIPTS_DTLS
{
ARD_SYS_ID = rd.ARD_SYS_ID,
ARD_ACNT_PERIOD = rd.ARD_ACNT_PERIOD,
ARD_ACTIVE = rd.ARD_ACTIVE,
ARD_ARH_SYS_ID = rd.ARD_ARH_SYS_ID,
ARD_CRTE_BY = rd.ARD_CRTE_BY,
ARD_CRTE_DATE = rd.ARD_CRTE_DATE,
ARD_DEP_OFF_CODE = rd.ARD_DEP_OFF_CODE,
ARD_DUE_DATE = rd.ARD_DUE_DATE,
ARD_MOD_BY = rd.ARD_MOD_BY,
ARD_MOD_DATE = rd.ARD_MOD_DATE,
ARD_PM_CODE = rd.ARD_PM_CODE,
ARD_RCPT_DESC = rd.ARD_RCPT_DESC,
ARD_RCVD_FROM = rd.ARD_RCVD_FROM,
ARD_STATUS = rd.ARD_STATUS,
ARD_TXN_DOC_NO = rd.ARD_TXN_DOC_NO,
ARD_TXN_OFF_CODE = rd.ARD_TXN_OFF_CODE,
MS_SYS_OFFICE = OfficeMdl.get_office(rd.ARD_TXN_OFF_CODE),
MS_SYS_OFFICE1 = OfficeMdl.get_office(rd.ARD_DEP_OFF_CODE),
MS_ACCT_RCPT_ACNT_DTLS = rd.MS_ACCT_RCPT_ACNT_DTLS != null? rd.MS_ACCT_RCPT_ACNT_DTLS.Select(a => AccountReceiptsAccountDetailsMdl.GetAcntDtl(a.RAD_SYS_ID)).ToList():null
}).Single());
}
public static MS_ACCT_PAYMNT_DTLS GetPaymntDtls(int id)
{
var db = new SibaModel();
return
((from pd in db.MS_ACCT_PAYMNT_DTLS where pd.APD_SYS_ID == id select pd).ToList()
.Select(pd => new MS_ACCT_PAYMNT_DTLS
{
APD_SYS_ID = pd.APD_SYS_ID,
APD_ACNT_PERIOD = pd.APD_ACNT_PERIOD,
APD_ACTIVE = pd.APD_ACTIVE,
APD_APH_SYS_ID = pd.APD_APH_SYS_ID,
APD_CRTE_BY = pd.APD_CRTE_BY,
APD_CRTE_DATE = pd.APD_CRTE_DATE,
APD_CUR_CODE = pd.APD_CUR_CODE,
APD_DEP_OFF_CODE = pd.APD_DEP_OFF_CODE,
APD_DUE_DATE = pd.APD_DUE_DATE,
APD_MOD_BY = pd.APD_MOD_BY,
APD_MOD_DATE = pd.APD_MOD_DATE,
APD_PM_CODE = pd.APD_PM_CODE,
APD_PAYMNT_DESC = pd.APD_PAYMNT_DESC,
APD_PAYMNT_TYPE = pd.APD_PAYMNT_TYPE,
APD_RCVD_FROM = pd.APD_RCVD_FROM,
APD_STATUS = pd.APD_STATUS,
APD_TXN_DOC_NO = pd.APD_TXN_DOC_NO,
APD_TXN_OFF_CODE = pd.APD_TXN_OFF_CODE,
MS_SYS_PAYMNT_MODE = PaymentModeMdl.GetPaymntMode(pd.APD_PM_CODE),
MS_SYS_OFFICE = OfficeMdl.get_office(pd.APD_TXN_OFF_CODE),
MS_SYS_OFFICE1 = OfficeMdl.get_office(pd.APD_DEP_OFF_CODE),
MS_INS_CURRENCY = CurrencyMdl.get_currency(pd.APD_CUR_CODE)
})
.Single());
}
public static MS_ACT_RECEIPTS_HEAD GetReceipt(int id)
{
var db = new SibaModel();
return((from r in db.MS_ACT_RECEIPTS_HEAD where r.ARH_SYS_ID == id select r).ToList()
.Select(r => new MS_ACT_RECEIPTS_HEAD
{
ARH_SYS_ID = r.ARH_SYS_ID,
ARH_ACTIVE = r.ARH_ACTIVE,
ARH_ATD_CODE = r.ARH_ATD_CODE,
ARH_BATCH_NO = r.ARH_BATCH_NO,
ARH_CRTE_BY = r.ARH_CRTE_BY,
ARH_CRTE_DATE = r.ARH_CRTE_DATE,
ARH_DESC = r.ARH_DESC,
ARH_RCPT_TYPE = r.ARH_RCPT_TYPE,
ARH_MOD_BY = r.ARH_MOD_BY,
ARH_MOD_DATE = r.ARH_MOD_DATE,
ARH_OFF_CODE = r.ARH_OFF_CODE,
ARH_STATUS = r.ARH_STATUS,
ARH_TXN_DATE = r.ARH_TXN_DATE,
ARH_TRANS_STATUS = r.ARH_TRANS_STATUS,
MS_ACCT_TXN_DOC = new MS_ACCT_TXN_DOC {
ATD_CODE = r.MS_ACCT_TXN_DOC.ATD_CODE, ATD_NAME = r.MS_ACCT_TXN_DOC.ATD_NAME
},
MS_SYS_OFFICE = OfficeMdl.get_office(r.ARH_OFF_CODE),
MS_ACCT_RECEIPTS_DTLS = r.MS_ACCT_RECEIPTS_DTLS != null ? r.MS_ACCT_RECEIPTS_DTLS.Select(rd => AccountReceiptDetailsMdl.GetReceiptDtl(rd.ARD_SYS_ID)).ToList():null,
}).SingleOrDefault());
}
public static MS_ACT_PAYMENTS_HEAD GetActPayment(int id)
{
var db = new SibaModel();
return((from ap in db.MS_ACT_PAYMENTS_HEAD where ap.APH_SYS_ID == id select ap).ToList().Select(p => new MS_ACT_PAYMENTS_HEAD
{
APH_SYS_ID = p.APH_SYS_ID,
APH_ACTIVE = p.APH_ACTIVE,
APH_ATD_CODE = p.APH_ATD_CODE,
APH_BATCH_NO = p.APH_BATCH_NO,
APH_CRTE_BY = p.APH_CRTE_BY,
APH_CRTE_DATE = p.APH_CRTE_DATE,
APH_DESC = p.APH_DESC,
APH_MOD_BY = p.APH_MOD_BY,
APH_MOD_DATE = p.APH_MOD_DATE,
APH_OFF_CODE = p.APH_OFF_CODE,
APH_STATUS = p.APH_STATUS,
APH_TXN_DATE = p.APH_TXN_DATE,
APH_TRANS_STATUS = p.APH_TRANS_STATUS,
MS_ACCT_TXN_DOC = new MS_ACCT_TXN_DOC {
ATD_CODE = p.MS_ACCT_TXN_DOC.ATD_CODE, ATD_NAME = p.MS_ACCT_TXN_DOC.ATD_NAME
},
MS_SYS_OFFICE = OfficeMdl.get_office(p.APH_OFF_CODE),
MS_ACCT_PAYMNT_DTLS = p.MS_ACCT_PAYMNT_DTLS != null?p.MS_ACCT_PAYMNT_DTLS.Select(pd => AccountPaymentDetailMdl.GetPaymntDtls(pd.APD_SYS_ID)).ToList():null,
MS_ACCT_PAYMNT_ACNT_DTLS = p.MS_ACCT_PAYMNT_ACNT_DTLS != null? p.MS_ACCT_PAYMNT_ACNT_DTLS.Select(d => AccountPaymentAccountDetailMdl.GetPaymntAcntDtls(d.PAD_SYS_ID)).ToList():null
}).Single());
}
// GET: api/Office/
public dynamic Get(string code)
{
try
{
return(OfficeMdl.get_office(code));
}
catch (Exception e)
{
return(new { state = false, message = "Server Error", exception = e });
}
}
public object Check(string code)
{
try
{
var result = OfficeMdl.get_office(code);
return(result != null ? (object)new { state = true, name = result.OFF_NAME } : new { state = false });
}
catch (Exception e)
{
return(new { state = false, message = "Server Error", exception = e });
}
}
public static CLM_EST_HEAD get_estimation(string code)
{
var db = new SibaModel();
try
{
return((from r in db.CLM_EST_HEAD where r.CLM_N0 == code select r).ToList().Select(r => new CLM_EST_HEAD
{
CLM_LOSS_CODE = r.CLM_LOSS_CODE,
CLM_SYS_ID = r.CLM_SYS_ID,
CLM_POLH_SYS_ID = r.CLM_POLH_SYS_ID,
CLM_CAT = r.CLM_CAT,
MS_SYS_OFFICE = OfficeMdl.get_office(r.CLM_OFF_CODE),
MS_CLM_CAT_EVENT = ClaimCatastropicEventMdl.get_catastrophy(r.CLM_CAT_EVNT_CODE),
MS_CLM_CAUSE_LOSS = ClaimCauseLossMdl.get_loss(r.CLM_LOSS_CODE),
CLM_CAT_EVNT_CODE = r.CLM_CAT_EVNT_CODE,
CLM_CLT_CODE = r.CLM_CLT_CODE,
CLM_CLT_NAME = r.CLM_CLT_NAME,
CLM_LOSS_DATE = r.CLM_LOSS_DATE,
CLM_LOSS_PLACE = r.CLM_LOSS_PLACE,
CLM_CRTE_BY = r.CLM_CRTE_BY,
CLM_CRTE_DATE = r.CLM_CRTE_DATE,
CLM_DISC_DATE = r.CLM_DISC_DATE,
CLM_MOD_BY = r.CLM_MOD_BY,
CLM_MOD_DATE = r.CLM_MOD_DATE,
CLM_OFF_CODE = r.CLM_OFF_CODE,
CLM_N0 = r.CLM_N0,
CLM_REMARKS = r.CLM_REMARKS,
CLM_REP_DATE = r.CLM_REP_DATE,
CLM_STATUS = r.CLM_STATUS,
CLM_RPDT = r.CLM_RPDT,
CLM_TIME_BRD = r.CLM_TIME_BRD,
CLM_TXN_DATE = r.CLM_TXN_DATE,
CLM_WART_BRCH = r.CLM_WART_BRCH,
CLM_EST_TRAVEL_RISK_DTLS = r.CLM_EST_TRAVEL_RISK_DTLS != null ? r.CLM_EST_TRAVEL_RISK_DTLS.Select(c => get_risk(c.CLM_RISK_SYS_ID)).ToList() : null,
CLM_EST_DTLS = r.CLM_EST_DTLS != null ? r.CLM_EST_DTLS.Select(c => get_estimate(c.CLM_EST_SYS_ID)).ToList() : null,
}).Single());
}
catch (Exception)
{
return(null);
}
}
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_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,
}).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());
}