public static bool save_accountperiod(MS_SYS_ACCOUNT_PERIODS are)
{
var db = new SibaModel();
if (are.ACP_STATUS == "A")
{
var db_accountperiod = db.MS_SYS_ACCOUNT_PERIODS.Find(are.ACP_YEAR_CODE);
if (db_accountperiod != null)
{
db.MS_SYS_ACCOUNT_PERIODS.Attach(db_accountperiod);
db_accountperiod.Map(are);
}
}
else if (are.ACP_STATUS == "U")
{
are.ACP_STATUS = "A";
db.MS_SYS_ACCOUNT_PERIODS.Add(are);
}
else if (are.ACP_STATUS == "D")
{
var db_accountperiod = db.MS_SYS_ACCOUNT_PERIODS.Find(are.ACP_YEAR_CODE);
if (db_accountperiod != null)
{
db.MS_SYS_ACCOUNT_PERIODS.Attach(db_accountperiod);
db_accountperiod.ACP_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static bool save_risk(MS_SYS_EQZONE cty)
{
var db = new SibaModel();
if (cty.EQZ_STATUS == "A")
{
var db_eqzone = db.MS_SYS_EQZONE.Find(cty.EQZ_CODE);
if (db_eqzone != null)
{
db.MS_SYS_EQZONE.Attach(db_eqzone);
db_eqzone.Map(cty);
}
}
else if (cty.EQZ_STATUS == "U")
{
cty.EQZ_STATUS = "A";
db.MS_SYS_EQZONE.Add(cty);
}
else if (cty.EQZ_STATUS == "D")
{
var db_eqzone = db.MS_SYS_EQZONE.Find(cty.EQZ_CODE);
if (db_eqzone != null)
{
db.MS_SYS_EQZONE.Attach(db_eqzone);
db_eqzone.EQZ_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static bool save_compulsoryfee(MS_COMPULSORY_FEES are)
{
var db = new SibaModel();
if (are.FEE_STATUS == "A")
{
var db_currency = db.MS_COMPULSORY_FEES.Find(are.FEE_CODE);
if (db_currency != null)
{
db.MS_COMPULSORY_FEES.Attach(db_currency);
db_currency.Map(are);
}
}
else if (are.FEE_STATUS == "U")
{
are.FEE_STATUS = "A";
db.MS_COMPULSORY_FEES.Add(are);
}
else if (are.FEE_STATUS == "D")
{
var db_currency = db.MS_COMPULSORY_FEES.Find(are.FEE_CODE);
if (db_currency != null)
{
db.MS_COMPULSORY_FEES.Attach(db_currency);
db_currency.FEE_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static IEnumerable <MST_UWD_PRODUCT_COVERS> GetAdditionalProductCovers(string prodCode, string coverCode)
{
var db = new SibaModel();
try
{
return((from cov in db.MST_UWD_PRODUCT_COVERS where cov.PCV_PDT_CODE == prodCode && cov.PCV_COV_CODE == coverCode select cov).ToList()
.Select(cv => new MST_UWD_PRODUCT_COVERS
{
PCV_STATUS = cv.PCV_STATUS,
PCV_SI = cv.PCV_SI,
PCV_PDT_CODE = cv.PCV_PDT_CODE,
PCV_DFT = cv.PCV_DFT,
PCV_COV_CODE = cv.PCV_COV_CODE,
PCV_DISC = cv.PCV_DISC,
PCV_LOAD = cv.PCV_LOAD,
PCV_DEF_RATE = cv.PCV_DEF_RATE,
PCV_CRTE_BY = cv.PCV_CRTE_BY,
PCV_CRTE_DATE = cv.PCV_CRTE_DATE,
PCV_MOD_BY = cv.PCV_MOD_BY,
PCV_MOD_DATE = cv.PCV_MOD_DATE,
PCV_SYS_ID = cv.PCV_SYS_ID,
PCV_DEF_PREM = cv.PCV_DEF_PREM
}));
}
catch (Exception)
{
return(null);
}
}
public static bool save_exchangerate(MS_SYS_EXCHANGE_RATES are)
{
var db = new SibaModel();
if (are.EXR_STATUS == "A")
{
var db_currency = db.MS_SYS_EXCHANGE_RATES.Find(are.EXR_CODE);
if (db_currency != null)
{
db.MS_SYS_EXCHANGE_RATES.Attach(db_currency);
db_currency.Map(are);
}
}
else if (are.EXR_STATUS == "U")
{
are.EXR_STATUS = "A";
db.MS_SYS_EXCHANGE_RATES.Add(are);
}
else if (are.EXR_STATUS == "D")
{
var db_currency = db.MS_SYS_EXCHANGE_RATES.Find(are.EXR_CODE);
if (db_currency != null)
{
db.MS_SYS_EXCHANGE_RATES.Attach(db_currency);
db_currency.EXR_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static bool save_claim_settlement(INS_CLM_PAYMENT_HEAD cty)
{
var db = new SibaModel();
if (cty.CLPMT_STATUS == "A")
{
var db_country = db.INS_CLM_PAYMENT_HEAD.Find(cty.CLPMT_SYS_ID);
if (db_country != null)
{
db.INS_CLM_PAYMENT_HEAD.Attach(db_country);
db_country.Map(cty);
}
}
else if (cty.CLPMT_STATUS == "U")
{
cty.CLPMT_STATUS = "A";
db.INS_CLM_PAYMENT_HEAD.Add(cty);
}
else if (cty.CLPMT_STATUS == "D")
{
var db_country = db.INS_CLM_PAYMENT_HEAD.Find(cty.CLPMT_SYS_ID);
if (db_country != null)
{
db.INS_CLM_PAYMENT_HEAD.Attach(db_country);
db_country.CLPMT_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static MS_ACCT_SERVICE_TAX GetServiceTax(string code)
{
var _db = new SibaModel();
using (_db)
{
return
((from st in _db.MS_ACCT_SERVICE_TAX where st.TX_TAX_CODE == code select st).ToList()
.Select(s => new MS_ACCT_SERVICE_TAX
{
TX_TAX_CODE = s.TX_TAX_CODE,
TX_SUB_ACCT_CODE = s.TX_SUB_ACCT_CODE,
TX_MAIN_ACCT_CODE = s.TX_MAIN_ACCT_CODE,
TX_CRTE_BY = s.TX_CRTE_BY,
TX_CRTE_DATE = s.TX_CRTE_DATE,
TX_CUST_CAT_CODE = s.TX_CUST_CAT_CODE,
TX_FROM_DATE = s.TX_FROM_DATE,
TX_MIN_TAX_APP = s.TX_MIN_TAX_APP,
TX_MOD_BY = s.TX_MOD_BY,
TX_MOD_DATE = s.TX_MOD_DATE,
TX_STATUS = s.TX_STATUS,
TX_SYS_ID = s.TX_SYS_ID,
TX_TAX_NAME = s.TX_TAX_NAME,
TX_TAX_PERC = s.TX_TAX_PERC,
TX_TO_DATE = s.TX_TO_DATE,
MS_ACCT_MAIN_ACCOUNT = MainAccountMdl.GetMainAccount(s.TX_MAIN_ACCT_CODE),
MS_ACCT_SUB_ACCOUNT = SubAccountMdl.GetSubAccount(s.TX_SUB_ACCT_CODE),
MS_CUSTOMER_CATEGORY = CustomerCategoryMdl.get_custcat(s.TX_CUST_CAT_CODE)
}).SingleOrDefault());
}
}
public static MS_SYS_COMPANY get_company(string code)
{
var db = new SibaModel();
try
{
return((from company in db.MS_SYS_COMPANY where company.CMP_CODE == code select company).ToList().Select(company => new MS_SYS_COMPANY
{
CMP_CODE = company.CMP_CODE,
CMP_NAME = company.CMP_NAME,
CMP_PHONE = company.CMP_PHONE,
CMP_EMAIL = company.CMP_EMAIL,
CMP_WEBSITE = company.CMP_WEBSITE,
CMP_HEAD_OFFICE_ADD = company.CMP_HEAD_OFFICE_ADD,
CMP_CNT_CODE = company.CMP_CNT_CODE,
CMP_CRTE_BY = company.CMP_CRTE_BY,
CMP_CRTE_DATE = company.CMP_CRTE_DATE,
CMP_STATUS = company.CMP_STATUS
}).Single());
}
catch (Exception e)
{
var exception = e;
return(null);
}
}
public static bool save_company(MS_SYS_COMPANY cty)
{
var db = new SibaModel();
if (cty.CMP_STATUS == "A")
{
var db_company = db.MS_SYS_COMPANY.Find(cty.CMP_CODE);
if (db_company != null)
{
db.MS_SYS_COMPANY.Attach(db_company);
db_company.Map(cty);
}
}
else if (cty.CMP_STATUS == "U")
{
cty.CMP_STATUS = "A";
db.MS_SYS_COMPANY.Add(cty);
}
else if (cty.CMP_STATUS == "D")
{
var db_company = db.MS_SYS_COMPANY.Find(cty.CMP_CODE);
if (db_company != null)
{
db.MS_SYS_COMPANY.Attach(db_company);
db_company.CMP_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
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 IEnumerable <object> get_estimate_risk(int ProdCode)
{
var db = new SibaModel();
try
{
return(from risk in db.INS_UWD_VEHICLE_RISK
where risk.VEH_POLH_SYS_ID == ProdCode && risk.VEH_STATUS == "A"
select new
{
CLM_RISK_STATUS = risk.VEH_STATUS,
CLM_RISK_VEH_REG_NO = risk.VEH_VEH_REG_NO,
CLM_RISK_CHASIS_NO = risk.VEH_CHASSIS_NO,
CLM_RISK_VEH_NO = risk.VEH_RISK_NO,
CLM_RISK_VEH_TYPE = risk.VEH_BODY_TYPE,
CLM_RISK_MAKE_MODEL = risk.VEH_MODEL,
CLM_EST_CRTE_BY = risk.VEH_CRTE_BY,
CLM_EST_CRTE_DATE = risk.VEH_CRTE_DATE
});
}
catch (Exception)
{
return(null);
}
}
public static bool save_estimation(MS_CLM_EST_TYPE estimation)
{
var db = new SibaModel();
if (estimation.CLM_EST_TYPE_STATUS == "A")
{
var db_estimation = db.MS_CLM_EST_TYPE.Find(estimation.CLM_EST_TYPE_CODE);
if (db_estimation != null)
{
db.MS_CLM_EST_TYPE.Attach(db_estimation);
db_estimation.Map(estimation);
}
}
else if (estimation.CLM_EST_TYPE_STATUS == "U")
{
estimation.CLM_EST_TYPE_STATUS = "A";
db.MS_CLM_EST_TYPE.Add(estimation);
}
else if (estimation.CLM_EST_TYPE_STATUS == "D")
{
var db_estimation = db.MS_CLM_EST_TYPE.Find(estimation.CLM_EST_TYPE_CODE);
if (db_estimation != null)
{
db.MS_CLM_EST_TYPE.Attach(db_estimation);
db_estimation.CLM_EST_TYPE_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static bool save_acceptancetype(MS_SYS_ACCEPTANCE_TYPES are)
{
var db = new SibaModel();
if (are.ATY_STATUS == "A")
{
var db_mdl = db.MS_SYS_ACCEPTANCE_TYPES.Find(are.ATY_CODE);
if (db_mdl != null)
{
db.MS_SYS_ACCEPTANCE_TYPES.Attach(db_mdl);
db_mdl.Map(are);
}
}
else if (are.ATY_STATUS == "U")
{
are.ATY_STATUS = "A";
db.MS_SYS_ACCEPTANCE_TYPES.Add(are);
}
else if (are.ATY_STATUS == "D")
{
var db_mdl = db.MS_SYS_ACCEPTANCE_TYPES.Find(are.ATY_CODE);
if (db_mdl != null)
{
db.MS_SYS_ACCEPTANCE_TYPES.Attach(db_mdl);
db_mdl.ATY_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static bool save_insAcctTxnType(MS_ACCT_INS_TXN_TYPE txntype)
{
var db = new SibaModel();
var dbTxntype = db.MS_ACCT_INS_TXN_TYPE.Find(txntype.TXN_CODE);
switch (txntype.TXN_STATUS)
{
case "A":
{
if (dbTxntype != null)
{
db.MS_ACCT_INS_TXN_TYPE.Attach(dbTxntype);
dbTxntype.Map(txntype);
}
}
break;
case "U":
txntype.TXN_STATUS = "A";
txntype.TXN_CRTE_DATE = DateTime.Now;
db.MS_ACCT_INS_TXN_TYPE.Add(txntype);
break;
case "D":
{
if (dbTxntype != null)
{
db.MS_ACCT_INS_TXN_TYPE.Attach(dbTxntype);
dbTxntype.TXN_STATUS = "D";
}
}
break;
}
return(db.SaveChanges() > 0);
}
public static IEnumerable <MS_SYS_SECTION> search_sections(string q)
{
var db = new SibaModel();
return((from cty in db.MS_SYS_SECTION where (cty.SEC_CODE.ToLower().Contains(q.ToLower()) || cty.SEC_NAME.ToLower().Contains(q.ToLower())) &&
cty.SEC_STATUS == "A" select cty).ToList());
}
public static CLM_EST_BONDS_RISK_DTLS get_risk(int code)
{
var db = new SibaModel();
try
{
return((from r in db.CLM_EST_BONDS_RISK_DTLS where r.CLM_RISK_SYS_ID == code select r).ToList().Select(r => new CLM_EST_BONDS_RISK_DTLS
{
CLM_RISK_SYS_ID = r.CLM_RISK_SYS_ID,
CLM_RISK_DESCRIPTION = r.CLM_RISK_DESCRIPTION,
CLM_RISK_CLM_SYS_ID = r.CLM_RISK_CLM_SYS_ID,
CLM_RISK_PRINCIPAL = r.CLM_RISK_PRINCIPAL,
CLM_RISK_SI = r.CLM_RISK_SI,
CLM_RISK_PRM = r.CLM_RISK_PRM,
CLM_RISK_STATUS = r.CLM_RISK_STATUS,
CLM_RISK_CRTE_BY = r.CLM_RISK_CRTE_BY,
CLM_RISK_CRTE_DATE = r.CLM_RISK_CRTE_DATE,
CLM_RISK_MOD_BY = r.CLM_RISK_MOD_BY,
CLM_RISK_MOD_DATE = r.CLM_RISK_MOD_DATE
}).Single());
}
catch (Exception)
{
return(null);
}
}
public static bool save_currency(MS_INS_CURRENCY are)
{
var db = new SibaModel();
if (are.CUR_STATUS == "A")
{
var db_currency = db.MS_INS_CURRENCY.Find(are.CUR_CODE);
if (db_currency != null)
{
db.MS_INS_CURRENCY.Attach(db_currency);
db_currency.Map(are);
}
}
else if (are.CUR_STATUS == "U")
{
are.CUR_STATUS = "A";
db.MS_INS_CURRENCY.Add(are);
}
else if (are.CUR_STATUS == "D")
{
var db_currency = db.MS_INS_CURRENCY.Find(are.CUR_CODE);
if (db_currency != null)
{
db.MS_INS_CURRENCY.Attach(db_currency);
db_currency.CUR_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static bool save_occupancy(MS_SYS_OCCUPANCY cty)
{
var db = new SibaModel();
if (cty.MSO_STATUS == "A")
{
var db_country = db.MS_SYS_COUNTRY.Find(cty.MSO_CODE);
if (db_country != null)
{
db.MS_SYS_COUNTRY.Attach(db_country);
db_country.Map(cty);
}
}
else if (cty.MSO_STATUS == "U")
{
cty.MSO_STATUS = "A";
db.MS_SYS_OCCUPANCY.Add(cty);
}
else if (cty.MSO_STATUS == "D")
{
var db_country = db.MS_SYS_COUNTRY.Find(cty.MSO_CODE);
if (db_country != null)
{
db.MS_SYS_COUNTRY.Attach(db_country);
db_country.CNT_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static IEnumerable <MS_SYS_COUNTRY> search_countries(string q)
{
var db = new SibaModel();
return((from cty in db.MS_SYS_COUNTRY where (cty.CNT_CODE.ToLower().Contains(q.ToLower()) || cty.CNT_NAME.ToLower().Contains(q.ToLower())) &&
cty.CNT_STATUS == "A" select cty).ToList());
}
public static IEnumerable <MS_SYS_OFFICE> get_offices()
{
var db = new SibaModel();
return((from office in db.MS_SYS_OFFICE where office.OFF_STATUS == "A" select office).ToList().Select(office => new MS_SYS_OFFICE
{
OFF_CODE = office.OFF_CODE,
OFF_NAME = office.OFF_NAME,
OFF_DESC = office.OFF_DESC,
OFF_CHANEL = office.OFF_CHANEL,
OFF_ADDRESS1 = office.OFF_ADDRESS1,
OFF_PHYSICAL_LOCAT = office.OFF_PHYSICAL_LOCAT,
OFF_PHONE = office.OFF_PHONE,
OFF_MOBILE = office.OFF_MOBILE,
OFF_FAX = office.OFF_FAX,
OFF_EMAIL = office.OFF_EMAIL,
OFF_MANAGER = office.OFF_MANAGER,
OFF_CMP_CODE = office.OFF_CMP_CODE,
OFF_CRTE_BY = office.OFF_CRTE_BY,
OFF_CRTE_DATE = office.OFF_CRTE_DATE,
OFF_MOD_BY = office.OFF_MOD_BY,
OFF_MOD_DATE = office.OFF_MOD_DATE,
OFF_STATUS = office.OFF_STATUS
}));
}
public static INS_UDW_POL_FEES get_fees(int code)
{
var db = new SibaModel();
try
{
return((from r in db.INS_UDW_POL_FEES where r.POL_FEE_SYS_ID == code select r).ToList().Select(r => new INS_UDW_POL_FEES
{
POL_FEE_SYS_ID = r.POL_FEE_SYS_ID,
POL_FEE_CODE = r.POL_FEE_CODE,
POL_FEE_BC_AMOUNT = r.POL_FEE_BC_AMOUNT,
POL_FEE_FC_AMOUNT = r.POL_FEE_FC_AMOUNT,
POL_FEE_FEE_END_NO = r.POL_FEE_FEE_END_NO,
POL_FEE_POL_SYS_ID = r.POL_FEE_POL_SYS_ID,
POL_FEE_CRTE_BY = r.POL_FEE_CRTE_BY,
POL_FEE_CRTE_DATE = r.POL_FEE_CRTE_DATE,
POL_FEE_MOD_BY = r.POL_FEE_MOD_BY,
POL_FEE_MOD_DATE = r.POL_FEE_MOD_DATE,
POL_FEE_STATUS = r.POL_FEE_STATUS,
}).Single());
}
catch (Exception)
{
return(null);
}
}
public static bool save_office(MS_SYS_OFFICE office)
{
var db = new SibaModel();
switch (office.OFF_STATUS)
{
case "A":
{
var db_office = db.MS_SYS_OFFICE.Find(office.OFF_CODE);
if (db_office != null)
{
db.MS_SYS_OFFICE.Attach(db_office);
db_office.Map(office);
}
}
break;
case "U":
office.OFF_STATUS = "A";
db.MS_SYS_OFFICE.Add(office);
break;
case "D":
{
var db_office = db.MS_SYS_OFFICE.Find(office.OFF_CODE);
if (db_office != null)
{
db.MS_SYS_OFFICE.Attach(db_office);
db_office.OFF_STATUS = "D";
}
}
break;
}
return(db.SaveChanges() > 0);
}
public static MS_ACCT_RCPT_ACNT_DTLS GetAcntDtl(int id)
{
var db = new SibaModel();
return((from ad in db.MS_ACCT_RCPT_ACNT_DTLS where ad.RAD_SYS_ID == id select ad).ToList()
.Select(ad => new MS_ACCT_RCPT_ACNT_DTLS
{
RAD_SYS_ID = ad.RAD_SYS_ID,
RAD_ACCT_CODE = ad.RAD_ACCT_CODE,
RAD_ACTIVE = ad.RAD_ACTIVE,
RAD_AMNT_BC = ad.RAD_AMNT_BC,
RAD_AMNT_FC = ad.RAD_AMNT_FC,
RAD_CUR_CODE = ad.RAD_CUR_CODE,
RAD_ARD_SYS_ID = ad.RAD_ARD_SYS_ID,
RAD_CRTE_BY = ad.RAD_CRTE_BY,
RAD_CRTE_DATE = ad.RAD_CRTE_DATE,
RAD_DESC = ad.RAD_DESC,
RAD_DR_CR = ad.RAD_DR_CR,
RAD_MOD_BY = ad.RAD_MOD_BY,
RAD_MOD_DATE = ad.RAD_MOD_DATE,
RAD_STATUS = ad.RAD_STATUS,
RAD_SUB_ACCT_CODE = ad.RAD_SUB_ACCT_CODE,
MS_ACCT_MAIN_ACCOUNT = MainAccountMdl.GetMainAccount(ad.RAD_ACCT_CODE),
MS_ACCT_SUB_ACCOUNT = SubAccountMdl.GetSubAccount(ad.RAD_SUB_ACCT_CODE)
}).Single());
}
public static CLM_EST_EXPENSE get_expense(int code)
{
var db = new SibaModel();
try
{
return((from r in db.CLM_EST_EXPENSE where r.CLM_EXP_SYS_ID == code select r).ToList().Select(r => new CLM_EST_EXPENSE
{
CLM_EXP_SYS_ID = r.CLM_EXP_SYS_ID,
CLM_EXP_CODE = r.CLM_EXP_CODE,
CLM_EXP_COST = r.CLM_EXP_COST,
CLM_EXP_CLM_EST_SYS_ID = r.CLM_EXP_CLM_EST_SYS_ID,
CLM_EXP_CLM_EST_TYPE = r.CLM_EXP_CLM_EST_TYPE,
CLM_EXP_CRTE_BY = r.CLM_EXP_CRTE_BY,
CLM_EXP_CRTE_DATE = r.CLM_EXP_CRTE_DATE,
CLM_EXP_MOD_BY = r.CLM_EXP_MOD_BY,
CLM_EXP_MOD_DATE = r.CLM_EXP_MOD_DATE,
CLM_EXP_STATUS = r.CLM_EXP_STATUS
}).Single());
}
catch (Exception)
{
return(null);
}
}
public static IEnumerable <MS_MOTOR_RISK_COVER> GetMotorRiskCovers(int rskCode)
{
var db = new SibaModel();
try
{
return((from cov in db.MS_MOTOR_RISK_COVER where cov.MRC_MPR_SYS_ID == rskCode select cov).ToList()
.Select(cv => new MS_MOTOR_RISK_COVER
{
MRC_AGE_LOAD = cv.MRC_AGE_LOAD,
MRC_CRTE_BY = cv.MRC_CRTE_BY,
MRC_CRTE_DATE = cv.MRC_CRTE_DATE,
MRC_CVR_CODE = cv.MRC_CVR_CODE,
MRC_DFT_PREM = cv.MRC_DFT_PREM,
MRC_DFT_RATE = cv.MRC_DFT_RATE,
MRC_DFT_YN = cv.MRC_DFT_YN,
MRC_EXCESS_LOAD = cv.MRC_EXCESS_LOAD,
MRC_MAX_RATE = cv.MRC_MAX_RATE,
MRC_MIN_AGE = cv.MRC_MIN_AGE,
MRC_MIN_RATE = cv.MRC_MIN_RATE,
MRC_MIN_SEATS = cv.MRC_MIN_SEATS,
MRC_MOD_BY = cv.MRC_MOD_BY,
MRC_MOD_DATE = cv.MRC_MOD_DATE,
MRC_MPR_SYS_ID = cv.MRC_MPR_SYS_ID,
MRC_SEAT_LOAD = cv.MRC_SEAT_LOAD,
MRC_STATUS = cv.MRC_STATUS,
// cv.MS_MOTOR_PROD_RISK =
}));
}
catch (Exception)
{
return(null);
}
}
public static CLM_EST_TRAVEL_RISK_DTLS get_risk(int code)
{
var db = new SibaModel();
try
{
return((from r in db.CLM_EST_TRAVEL_RISK_DTLS where r.CLM_RISK_SYS_ID == code select r).ToList().Select(r => new CLM_EST_TRAVEL_RISK_DTLS
{
CLM_RISK_SYS_ID = r.CLM_RISK_SYS_ID,
CLM_RISK_CLT_NAME = r.CLM_RISK_CLT_NAME,
CLM_RISK_CLM_SYS_ID = r.CLM_RISK_CLM_SYS_ID,
CLM_RISK_NAT = r.CLM_RISK_NAT,
CLM_RISK_NAT_ID = r.CLM_RISK_NAT_ID,
CLM_RISK_PASSPORT_NO = r.CLM_RISK_PASSPORT_NO,
CLM_RISK_COUNTRY_VISITED = r.CLM_RISK_COUNTRY_VISITED,
CLM_RISK_DESTIN_ADDRSS = r.CLM_RISK_DESTIN_ADDRSS,
CLM_RISK_PHONE_NO = r.CLM_RISK_PHONE_NO,
CLM_RISK_STATUS = r.CLM_RISK_STATUS,
CLM_RISK_CRTE_BY = r.CLM_RISK_CRTE_BY,
CLM_RISK_CRTE_DATE = r.CLM_RISK_CRTE_DATE,
CLM_RISK_MOD_BY = r.CLM_RISK_MOD_BY,
CLM_RISK_MOD_DATE = r.CLM_RISK_MOD_DATE
}).Single());
}
catch (Exception)
{
return(null);
}
}
public static bool save_location(MS_SYS_LOCATION cty)
{
var db = new SibaModel();
if (cty.LOC_STATUS == "A")
{
var db_location = db.MS_SYS_LOCATION.Find(cty.LOC_CODE);
if (db_location != null)
{
db.MS_SYS_LOCATION.Attach(db_location);
db_location.Map(cty);
}
}
else if (cty.LOC_STATUS == "U")
{
cty.LOC_STATUS = "A";
db.MS_SYS_LOCATION.Add(cty);
}
else if (cty.LOC_STATUS == "D")
{
var db_location = db.MS_SYS_LOCATION.Find(cty.LOC_CODE);
if (db_location != null)
{
db.MS_SYS_LOCATION.Attach(db_location);
db_location.LOC_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static CLM_EST_DTLS get_estimate(int code)
{
var db = new SibaModel();
try
{
return((from r in db.CLM_EST_DTLS where r.CLM_EST_SYS_ID == code select r).ToList().Select(r => new CLM_EST_DTLS
{
CLM_EST_SYS_ID = r.CLM_EST_SYS_ID,
CLM_EST_AMT = r.CLM_EST_AMT,
CLM_EST_CLM_SYS_ID = r.CLM_EST_CLM_SYS_ID,
CLM_EST_NAME = r.CLM_EST_NAME,
CLM_EST_OS_AMT = r.CLM_EST_OS_AMT,
CLM_EST_CRTE_BY = r.CLM_EST_CRTE_BY,
CLM_EST_CRTE_DATE = r.CLM_EST_CRTE_DATE,
CLM_EST_MOD_BY = r.CLM_EST_MOD_BY,
CLM_EST_MOD_DATE = r.CLM_EST_MOD_DATE,
CLM_EST_RISK_SYS_ID = r.CLM_EST_RISK_SYS_ID,
CLM_EST_TYPE = r.CLM_EST_TYPE,
CLM_EST_EXPENSE = r.CLM_EST_EXPENSE != null ? r.CLM_EST_EXPENSE.Select(c => get_expense(c.CLM_EXP_SYS_ID)).ToList() : null,
}).Single());
}
catch (Exception)
{
return(null);
}
}
public static bool save_prodriskfee(MS_PRODUCT_RISK_FEES cty)
{
var db = new SibaModel();
if (cty.PRF_STATUS == "A")
{
var db_motorriskfee = db.MS_PRODUCT_RISK_FEES.Find(cty.PRF_SYS_ID);
if (db_motorriskfee != null)
{
db.MS_PRODUCT_RISK_FEES.Attach(db_motorriskfee);
db_motorriskfee.Map(cty);
}
}
else if (cty.PRF_STATUS == "U")
{
cty.PRF_STATUS = "A";
db.MS_PRODUCT_RISK_FEES.Add(cty);
}
else if (cty.PRF_STATUS == "D")
{
var db_motorriskfee = db.MS_PRODUCT_RISK_FEES.Find(cty.PRF_SYS_ID);
if (db_motorriskfee != null)
{
db.MS_PRODUCT_RISK_FEES.Attach(db_motorriskfee);
db_motorriskfee.PRF_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static INS_UDW_HOME_OWNERS_DETAILS get_homeowners_details(int code)
{
var db = new SibaModel();
try
{
return((from c in db.INS_UDW_HOME_OWNERS_DETAILS where c.HODT_SYS_ID == code select c).ToList().Select(c => new INS_UDW_HOME_OWNERS_DETAILS
{
HODT_SYS_ID = c.HODT_SYS_ID,
HODT_HOP_SYS_ID = c.HODT_HOP_SYS_ID,
HODT_DESC = c.HODT_DESC,
HODT_ITEM_NAME = c.HODT_ITEM_NAME,
HODT_QTY = c.HODT_QTY,
HODT_SUM_INSURED = c.HODT_SUM_INSURED,
HODT_CRTE_BY = c.HODT_CRTE_BY,
HODT_CRTE_DATE = c.HODT_CRTE_DATE,
HODT_MOD_BY = c.HODT_MOD_BY,
HODT_MOD_DATE = c.HODT_MOD_DATE,
HODT_STATUS = c.HODT_STATUS
}).Single());
}
catch (Exception)
{
return(null);
}
}
