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