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()); }