public async Task <ActionResult> OnPostSearch(DataTable dt)
{
try
{
int pageSize = dt.pageSize ?? 10;
int pageIndex = dt.pageIndex;
//query data by page
Page <SalesOrder> page = await _salesOrderService
.LoadByPageAsync(pageIndex, pageSize, false, new object[] { CustomerID ?? 0, StartOrderDate, EndOrderDate });
SalesOrders = page.Items;
dt.recordsTotal = page.TotalItems;
dt.recordsFiltered = page.TotalItems;
dt.data = SalesOrders.ToList();
return(new JsonResult(JsonConvert.SerializeObject(dt)));
}
catch (Exception e)
{
return(GenJsonResult(-1, e.Message, 0));
}
}
