public IHttpActionResult GetInvo_itemsList(Invoice_itemsSearch search) { AuthDetails authdet = LoginUserDetails(); var filters = new List <MySqlParameter> { datatableService.CreateSqlParameter("@pUserId", authdet.UserId, MySqlDbType.Int32) }; var result = service.GetInvo_itemsList(search, filters); return(Ok(result)); }
public DataTable <Invoice_itemsDatatable> GetInvo_itemsList(Invoice_itemsSearch search, List <MySqlParameter> filters) { try { using (var ctx = new AppDb()) { var result = datatableService.GetDataTableResult <Invoice_itemsDatatable>("invoice_items_sp", search, filters); return(result); } } catch (Exception ex) { throw ex; } }