public static MS_ACCT_PAYMNT_ACNT_DTLS GetPaymntAcntDtls(int id)
{
var db = new SibaModel();
return
((from ad in db.MS_ACCT_PAYMNT_ACNT_DTLS where ad.PAD_SYS_ID == id select ad).ToList()
.Select(ad => new MS_ACCT_PAYMNT_ACNT_DTLS
{
PAD_SYS_ID = ad.PAD_SYS_ID,
PAD_ACCT_CODE = ad.PAD_ACCT_CODE,
PAD_ACTIVE = ad.PAD_ACTIVE,
PAD_AMNT_BC = ad.PAD_AMNT_BC,
PAD_AMNT_FC = ad.PAD_AMNT_FC,
PAD_APH_SYS_ID = ad.PAD_APH_SYS_ID,
PAD_CRTE_BY = ad.PAD_CRTE_BY,
PAD_CRTE_DATE = ad.PAD_CRTE_DATE,
PAD_DESC = ad.PAD_DESC,
PAD_DR_CR = ad.PAD_DR_CR,
PAD_MOD_BY = ad.PAD_MOD_BY,
PAD_MOD_DATE = ad.PAD_MOD_DATE,
PAD_STATUS = ad.PAD_STATUS,
PAD_SUB_ACCT_CODE = ad.PAD_SUB_ACCT_CODE,
MS_ACCT_SUB_ACCOUNT = SubAccountMdl.GetSubAccount(ad.PAD_SUB_ACCT_CODE),
MS_ACCT_MAIN_ACCOUNT = MainAccountMdl.GetMainAccount(ad.PAD_ACCT_CODE)
}).Single());
}
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());
}
}
// GET: api/SubAccont/5
public object Get(string id)
{
try
{
return(SubAccountMdl.GetSubAccount(id));
}
catch (Exception e)
{
return(new { state = false, message = "Server Error", exception = e });
}
}
public object CheckCode(string code)
{
try
{
var result = SubAccountMdl.GetSubAccount(code);
return(result != null ? (object)new { state = true, name = result.SUB_ACCT_NAME } : new { state = false });
}
catch (Exception e)
{
return(new { state = false, message = "Server Error", exception = e });
}
}