public static MS_CUSTOMER_CATEGORY get_custcat(string code)
{
var db = new SibaModel();
return((from mdl in db.MS_CUSTOMER_CATEGORY where mdl.CUS_CAT_CODE == code select mdl).ToList().Select(mdl => new MS_CUSTOMER_CATEGORY
{
CUS_CAT_CODE = mdl.CUS_CAT_CODE,
CUS_CAT_INTERM_YN = mdl.CUS_CAT_INTERM_YN,
CUS_CAT_NAME = mdl.CUS_CAT_NAME,
CUS_CAT_MAIN_ACCT = mdl.CUS_CAT_MAIN_ACCT,
CUS_CAT_SUB_ACCT = mdl.CUS_CAT_SUB_ACCT,
CUS_CAT_CRTE_DATE = mdl.CUS_CAT_CRTE_DATE,
CUS_CAT_CRTE_BY = mdl.CUS_CAT_CRTE_BY,
CUS_CAT_MOD_DATE = mdl.CUS_CAT_MOD_DATE,
CUS_CAT_MOD_BY = mdl.CUS_CAT_MOD_BY,
CUS_CAT_STATUS = mdl.CUS_CAT_STATUS,
MS_ACCT_MAIN_ACCOUNT = MainAccountMdl.GetMainAccount(mdl.CUS_CAT_MAIN_ACCT),
MS_ACCT_SUB_ACCOUNT = SubAccountMdl.GetSubAccount(mdl.CUS_CAT_SUB_ACCT)
}).Single());
}
public static MS_COMPULSORY_FEES get_CompFees(string code)
{
var db = new SibaModel();
return((from comfee in db.MS_COMPULSORY_FEES where comfee.FEE_CODE == code select comfee).ToList().Select(comfee => new MS_COMPULSORY_FEES
{
FEE_CODE = comfee.FEE_CODE,
FEE_NAME = comfee.FEE_NAME,
FEE_DESC = comfee.FEE_DESC,
FEE_CRTE_BY = comfee.FEE_CRTE_BY,
FEE_CRTE_DATE = comfee.FEE_CRTE_DATE,
FEE_FROM_DATE = comfee.FEE_FROM_DATE,
FEE_MOD_BY = comfee.FEE_MOD_BY,
FEE_MOD_DATE = comfee.FEE_MOD_DATE,
FEE_AMOUNT = comfee.FEE_AMOUNT,
FEE_MODIFY_YN = comfee.FEE_MODIFY_YN,
FEE_REFUND_YN = comfee.FEE_REFUND_YN,
FEE_STATUS = comfee.FEE_STATUS,
FEE_TO_DATE = comfee.FEE_TO_DATE,
MS_ACCT_MAIN_ACCOUNT = MainAccountMdl.GetMainAccount(comfee.FEE_MAIN_ACCOUNT),
MS_ACCT_SUB_ACCOUNT = SubAccountMdl.GetSubAccount(comfee.FEE_SUB_ACCOUNT)
}).Single());
}