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