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 object search(string query) { try { return(CustomerCategoryMdl.search_custcats(query)); } catch (Exception e) { return(new { state = false, message = "Server Error", exception = e }); } }
public object lov() { try { return(CustomerCategoryMdl.get_lov_custcat()); } catch (Exception e) { return(new { state = false, message = "Server Error", exception = e }); } }
// GET: api/Intermediary/5 public dynamic Get(string code) { try { return(CustomerCategoryMdl.get_custcat(code)); } catch (Exception e) { return(new { state = false, message = "Server Error", exception = e }); } }
public object Check(string code) { try { var result = CustomerCategoryMdl.get_custcat(code); return(result != null ? (object)new { state = true, name = result.CUS_CAT_NAME } : new { state = false }); } catch (Exception e) { return(new { state = false, message = "Server Error", exception = e }); } }
public object save([FromBody] List <MS_CUSTOMER_CATEGORY> custcat) { try { foreach (var are in custcat) { CustomerCategoryMdl.save_custcat(are); } return(new { state = true, message = "Customer Category Successfully Created" }); } catch (Exception e) { return(new { state = false, message = "Server Error", exception = e }); } }