public static bool TransactionProcessing(MS_ACT_RCPT_CONFIRMATION_LOG log)
{
var db = new SibaModel();
using (var trans = db.Database.BeginTransaction())
{
try
{
var dbReceipt = db.MS_ACT_RECEIPTS_HEAD.Find(log.RCL_ARH_SYS_ID);
switch (log.RCL_ACTION)
{
case "Confirm":
if (dbReceipt != null)
{
db.MS_ACT_RECEIPTS_HEAD.Attach(dbReceipt);
dbReceipt.ARH_TRANS_STATUS = "C";
db.SaveChanges();
//take log of the change in the transacitonal status of the receipt
db.MS_ACT_RCPT_CONFIRMATION_LOG.Add(log);
db.SaveChanges();
}
else
{
return(false);
}
break;
case "Unconfirm":
if (dbReceipt != null)
{
db.MS_ACT_RECEIPTS_HEAD.Attach(dbReceipt);
dbReceipt.ARH_TRANS_STATUS = "P";
db.SaveChanges();
//take log of the change in the transacitonal status of the receipt
db.MS_ACT_RCPT_CONFIRMATION_LOG.Add(log);
db.SaveChanges();
}
else
{
return(false);
}
break;
}
trans.Commit();
return(true);
}
catch (Exception)
{
trans.Rollback();
throw;
}
}
}
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_cover(MS_UDW_COVERS are)
{
var db = new SibaModel();
if (are.CVR_STATUS == "A")
{
var db_cover = db.MS_UDW_COVERS.Find(are.CVR_CODE);
if (db_cover != null)
{
db.MS_UDW_COVERS.Attach(db_cover);
db_cover.Map(are);
}
}
else if (are.CVR_STATUS == "U")
{
are.CVR_STATUS = "A";
db.MS_UDW_COVERS.Add(are);
}
else if (are.CVR_STATUS == "D")
{
var db_cover = db.MS_UDW_COVERS.Find(are.CVR_CODE);
if (db_cover != null)
{
db.MS_UDW_COVERS.Attach(db_cover);
db_cover.CVR_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static bool save_premiumtariff(MS_UDW_PREM_TARRIFS are)
{
var db = new SibaModel();
if (are.TFF_STATUS == "A")
{
var db_premiumtariff = db.MS_UDW_PREM_TARRIFS.Find(are.TFF_CODE);
if (db_premiumtariff != null)
{
db.MS_UDW_PREM_TARRIFS.Attach(db_premiumtariff);
db_premiumtariff.Map(are);
}
}
else if (are.TFF_STATUS == "U")
{
are.TFF_STATUS = "A";
db.MS_UDW_PREM_TARRIFS.Add(are);
}
else if (are.TFF_STATUS == "D")
{
var db_premiumtariff = db.MS_UDW_PREM_TARRIFS.Find(are.TFF_CODE);
if (db_premiumtariff != null)
{
db.MS_UDW_PREM_TARRIFS.Attach(db_premiumtariff);
db_premiumtariff.TFF_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static bool save_country(MS_SYS_COUNTRY cty)
{
var db = new SibaModel();
if (cty.CNT_STATUS == "A")
{
var db_country = db.MS_SYS_COUNTRY.Find(cty.CNT_CODE);
if (db_country != null)
{
db.MS_SYS_COUNTRY.Attach(db_country);
db_country.Map(cty);
}
}
else if (cty.CNT_STATUS == "U")
{
cty.CNT_STATUS = "A";
db.MS_SYS_COUNTRY.Add(cty);
}
else if (cty.CNT_STATUS == "D")
{
var db_country = db.MS_SYS_COUNTRY.Find(cty.CNT_CODE);
if (db_country != null)
{
db.MS_SYS_COUNTRY.Attach(db_country);
db_country.CNT_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static bool save_class(MS_UDW_CLASS_OF_BUSINESS cty)
{
var db = new SibaModel();
if (cty.COB_STATUS == "A")
{
var db_company = db.MS_UDW_CLASS_OF_BUSINESS.Find(cty.COB_CODE);
if (db_company != null)
{
db.MS_UDW_CLASS_OF_BUSINESS.Attach(db_company);
db_company.Map(cty);
}
}
else if (cty.COB_STATUS == "U")
{
cty.COB_STATUS = "A";
db.MS_UDW_CLASS_OF_BUSINESS.Add(cty);
}
else if (cty.COB_STATUS == "D")
{
var db_company = db.MS_UDW_CLASS_OF_BUSINESS.Find(cty.COB_CODE);
if (db_company != null)
{
db.MS_UDW_CLASS_OF_BUSINESS.Attach(db_company);
db_company.COB_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static bool save_conditionclause(MS_SYS_CONDS_CLAUSES cty)
{
var db = new SibaModel();
if (cty.CCL_STATUS == "A")
{
var db_conditionclause = db.MS_SYS_CONDS_CLAUSES.Find(cty.CCL_CODE);
if (db_conditionclause != null)
{
db.MS_SYS_CONDS_CLAUSES.Attach(db_conditionclause);
db_conditionclause.Map(cty);
}
}
else if (cty.CCL_STATUS == "U")
{
cty.CCL_STATUS = "A";
db.MS_SYS_CONDS_CLAUSES.Add(cty);
}
else if (cty.CCL_STATUS == "D")
{
var db_conditionclause = db.MS_SYS_CONDS_CLAUSES.Find(cty.CCL_CODE);
if (db_conditionclause != null)
{
db.MS_SYS_CONDS_CLAUSES.Attach(db_conditionclause);
db_conditionclause.CCL_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static bool Save(MS_ACCT_DOC_ORIGIN origin)
{
var db = new SibaModel();
var dbOrigin = db.MS_ACCT_DOC_ORIGIN.Find(origin.DOC_ORIGN_CODE);
switch (origin.DOC_ORIGN_STATUS)
{
case "A":
if (dbOrigin != null)
{
db.MS_ACCT_DOC_ORIGIN.Attach(dbOrigin);
dbOrigin.Map(origin);
dbOrigin.DOC_ORIGN_MOD_DATE = DateTime.Now;
}
break;
case "U":
origin.DOC_ORIGN_STATUS = "A";
origin.DOC_ORIGN_CRTE_DATE = DateTime.Now;
db.MS_ACCT_DOC_ORIGIN.Add(origin);
break;
case "D":
if (dbOrigin != null)
{
db.MS_ACCT_DOC_ORIGIN.Attach(dbOrigin);
dbOrigin.DOC_ORIGN_STATUS = "A";
dbOrigin.DOC_ORIGN_MOD_DATE = DateTime.Now;
}
break;
}
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_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 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_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 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 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 SaveEndorsement(MS_ACCT_CATEGORY accCat)
{
var db = new SibaModel();
var dbAccCat = db.MS_ACCT_CATEGORY.Find(accCat.ACAT_CODE);
switch (accCat.ACAT_STATUS)
{
case "A":
if (dbAccCat != null)
{
db.MS_ACCT_CATEGORY.Attach(dbAccCat);
dbAccCat.Map(accCat);
}
break;
case "U":
accCat.ACAT_STATUS = "A";
accCat.ACAT_CRTE_DATE = DateTime.Now;
db.MS_ACCT_CATEGORY.Add(accCat);
break;
case "D":
if (dbAccCat != null)
{
db.MS_ACCT_CATEGORY.Attach(dbAccCat);
dbAccCat.ACAT_STATUS = "D";
}
break;
}
return(db.SaveChanges() > 0);
}
//
public static bool save_discountloading(MS_SYS_LOADINGS_DISCOUNTS are)
{
var db = new SibaModel();
if (are.LDI_STATUS == "A")
{
var db_discloading = db.MS_SYS_LOADINGS_DISCOUNTS.Find(are.LDI_CODE);
if (db_discloading != null)
{
db.MS_SYS_LOADINGS_DISCOUNTS.Attach(db_discloading);
db_discloading.Map(are);
}
}
else if (are.LDI_STATUS == "U")
{
are.LDI_STATUS = "A";
db.MS_SYS_LOADINGS_DISCOUNTS.Add(are);
}
else if (are.LDI_STATUS == "D")
{
var db_discloading = db.MS_SYS_LOADINGS_DISCOUNTS.Find(are.LDI_CODE);
if (db_discloading != null)
{
db.MS_SYS_LOADINGS_DISCOUNTS.Attach(db_discloading);
db_discloading.LDI_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
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 bool save_custcat(MS_CUSTOMER_CATEGORY are)
{
var db = new SibaModel();
switch (are.CUS_CAT_STATUS)
{
case "A":
{
var dbAgencycomm = db.MS_CUSTOMER_CATEGORY.Find(are.CUS_CAT_CODE);
if (dbAgencycomm != null)
{
db.MS_CUSTOMER_CATEGORY.Attach(dbAgencycomm);
dbAgencycomm.Map(are);
}
}
break;
case "U":
are.CUS_CAT_STATUS = "A";
db.MS_CUSTOMER_CATEGORY.Add(are);
break;
case "D":
{
var dbAgencycomm = db.MS_CUSTOMER_CATEGORY.Find(are.CUS_CAT_CODE);
if (dbAgencycomm != null)
{
db.MS_CUSTOMER_CATEGORY.Attach(dbAgencycomm);
dbAgencycomm.CUS_CAT_STATUS = "D";
}
}
break;
}
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 bool save_customertype(MS_SYS_CUST_TYPES are)
{
var db = new SibaModel();
if (are.CTP_STATUS == "A")
{
var db_currency = db.MS_SYS_CUST_TYPES.Find(are.CTP_CODE);
if (db_currency != null)
{
db.MS_SYS_CUST_TYPES.Attach(db_currency);
db_currency.Map(are);
}
}
else if (are.CTP_STATUS == "U")
{
are.CTP_STATUS = "A";
db.MS_SYS_CUST_TYPES.Add(are);
}
else if (are.CTP_STATUS == "D")
{
var db_currency = db.MS_SYS_CUST_TYPES.Find(are.CTP_CODE);
if (db_currency != null)
{
db.MS_SYS_CUST_TYPES.Attach(db_currency);
db_currency.CTP_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
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 bool Save(MS_SYS_PAYMNT_MODE mode)
{
var db = new SibaModel();
var dbMode = db.MS_SYS_PAYMNT_MODE.Find(mode.PM_CODE);
switch (mode.PM_STATUS)
{
case "A":
if (dbMode != null)
{
db.MS_SYS_PAYMNT_MODE.Attach(dbMode);
dbMode.Map(mode);
dbMode.PM_MOD_DATE = DateTime.Now;
}
break;
case "U":
mode.PM_STATUS = "A";
mode.PM_CRTE_DATE = DateTime.Now;
db.MS_SYS_PAYMNT_MODE.Add(mode);
break;
case "D":
if (dbMode != null)
{
db.MS_SYS_PAYMNT_MODE.Attach(dbMode);
dbMode.PM_STATUS = "D";
dbMode.PM_MOD_DATE = DateTime.Now;
}
break;
}
return(db.SaveChanges() > 0);
}
public static bool save_motorriskfee(MS_MOTOR_RISK_FEES are)
{
var db = new SibaModel();
if (are.MRF_STATUS == "A")
{
var db_motorriskfee = db.MS_MOTOR_RISK_FEES.Find(are.MRF_SYS_ID);
if (db_motorriskfee != null)
{
db.MS_MOTOR_RISK_FEES.Attach(db_motorriskfee);
db_motorriskfee.Map(are);
}
}
else if (are.MRF_STATUS == "U")
{
are.MRF_STATUS = "A";
db.MS_MOTOR_RISK_FEES.Add(are);
}
else if (are.MRF_STATUS == "D")
{
var db_motorriskfee = db.MS_MOTOR_RISK_FEES.Find(are.MRF_SYS_ID);
if (db_motorriskfee != null)
{
db.MS_MOTOR_RISK_FEES.Attach(db_motorriskfee);
db_motorriskfee.MRF_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static bool save_intermediary(MS_SYS_INTERMEDIARY are)
{
var db = new SibaModel();
if (are.INT_STATUS == "A")
{
var db_interm = db.MS_SYS_INTERMEDIARY.Find(are.INT_CODE);
if (db_interm != null)
{
db.MS_SYS_INTERMEDIARY.Attach(db_interm);
db_interm.Map(are);
}
}
else if (are.INT_STATUS == "U")
{
are.INT_STATUS = "A";
db.MS_SYS_INTERMEDIARY.Add(are);
}
else if (are.INT_STATUS == "D")
{
var db_interm = db.MS_SYS_INTERMEDIARY.Find(are.INT_CODE);
if (db_interm != null)
{
db.MS_SYS_INTERMEDIARY.Attach(db_interm);
db_interm.INT_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static bool SaveAcctIntegration(MS_ACCTS_INTEGRATION accInt)
{
var db = new SibaModel();
var dbAccInt = db.MS_ACCTS_INTEGRATION.Find(accInt.INT_SYS_ID);
switch (accInt.INT_STATUS)
{
case "A":
{
if (dbAccInt != null)
{
db.MS_ACCTS_INTEGRATION.Attach(dbAccInt);
dbAccInt.Map(accInt);
}
}
break;
case "U":
accInt.INT_STATUS = "A";
accInt.INT_CRTE_DATE = DateTime.Now;
db.MS_ACCTS_INTEGRATION.Add(accInt);
break;
case "D":
{
if (dbAccInt != null)
{
db.MS_ACCTS_INTEGRATION.Attach(dbAccInt);
dbAccInt.INT_STATUS = "D";
}
}
break;
}
return(db.SaveChanges() > 0);
}
public static bool save_catastrophy(MS_CLM_CAT_EVENT cat)
{
var db = new SibaModel();
if (cat.CLM_CAT_STATUS == "A")
{
var db_catastrophy = db.MS_CLM_CAT_EVENT.Find(cat.CLM_CAT_CODE);
if (db_catastrophy != null)
{
db.MS_CLM_CAT_EVENT.Attach(db_catastrophy);
db_catastrophy.Map(cat);
}
}
else if (cat.CLM_CAT_STATUS == "U")
{
cat.CLM_CAT_STATUS = "A";
db.MS_CLM_CAT_EVENT.Add(cat);
}
else if (cat.CLM_CAT_STATUS == "D")
{
var db_catastrophy = db.MS_CLM_CAT_EVENT.Find(cat.CLM_CAT_CODE);
if (db_catastrophy != null)
{
db.MS_CLM_CAT_EVENT.Attach(db_catastrophy);
db_catastrophy.CLM_CAT_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static bool save_intermcomm(MS_INTERMEDIARY_COMM are)
{
var db = new SibaModel();
if (are.COM_STATUS == "A")
{
var db_agencycomm = db.MS_INTERMEDIARY_COMM.Find(are.COM_SYS_ID);
if (db_agencycomm != null)
{
db.MS_INTERMEDIARY_COMM.Attach(db_agencycomm);
db_agencycomm.Map(are);
}
}
else if (are.COM_STATUS == "U")
{
are.COM_STATUS = "A";
db.MS_INTERMEDIARY_COMM.Add(are);
}
else if (are.COM_STATUS == "D")
{
var db_agencycomm = db.MS_INTERMEDIARY_COMM.Find(are.COM_SYS_ID);
if (db_agencycomm != null)
{
db.MS_INTERMEDIARY_COMM.Attach(db_agencycomm);
db_agencycomm.COM_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static bool save_sourcebusiness(MS_SYS_SOURCE_BUSINESS cty)
{
var db = new SibaModel();
if (cty.SRB_STATUS == "A")
{
var db_sourcebusiness = db.MS_SYS_SOURCE_BUSINESS.Find(cty.SRB_CODE);
if (db_sourcebusiness != null)
{
db.MS_SYS_SOURCE_BUSINESS.Attach(db_sourcebusiness);
db_sourcebusiness.Map(cty);
}
}
else if (cty.SRB_STATUS == "U")
{
cty.SRB_STATUS = "A";
db.MS_SYS_SOURCE_BUSINESS.Add(cty);
}
else if (cty.SRB_STATUS == "D")
{
var db_sourcebusiness = db.MS_SYS_SOURCE_BUSINESS.Find(cty.SRB_CODE);
if (db_sourcebusiness != null)
{
db.MS_SYS_SOURCE_BUSINESS.Attach(db_sourcebusiness);
db_sourcebusiness.SRB_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
public static bool save_loss(MS_CLM_CAUSE_LOSS loss)
{
var db = new SibaModel();
if (loss.CLM_CAUSE_STATUS == "A")
{
var db_loss = db.MS_CLM_CAUSE_LOSS.Find(loss.CLM_CAUSE_CODE);
if (db_loss != null)
{
db.MS_CLM_CAUSE_LOSS.Attach(db_loss);
db_loss.Map(loss);
}
}
else if (loss.CLM_CAUSE_STATUS == "U")
{
loss.CLM_CAUSE_STATUS = "A";
db.MS_CLM_CAUSE_LOSS.Add(loss);
}
else if (loss.CLM_CAUSE_STATUS == "D")
{
var db_loss = db.MS_CLM_CAUSE_LOSS.Find(loss.CLM_CAUSE_CODE);
if (db_loss != null)
{
db.MS_CLM_CAUSE_LOSS.Attach(db_loss);
db_loss.CLM_CAUSE_STATUS = "D";
}
}
return(db.SaveChanges() > 0);
}
