public async Task <IActionResult> ServiceRequests(DataSourceRequest command, ServiceRequestListModel model) { var(ServiceRequestList, totalCount) = await _workorderService.PrepareServiceRequestListModel(model, command.Page, command.PageSize); var gridModel = new DataSourceResult { Data = ServiceRequestList, Total = totalCount }; return(Json(gridModel)); }
public async Task <(IEnumerable <SOPreview> ServiceRequestList, int totalCount)> PrepareServiceRequestListModel(ServiceRequestListModel model, int pageIndex, int pageSize) { try { SqlParameter[] pr = new SqlParameter[] { new SqlParameter("@intClientID", (int)_workContext.CurrentCustomer.ClientId), new SqlParameter("@intSort", model.intSort) }; var serviceRequestListModel = await _dbContext.Set <SOPreview>().FromSqlRaw("exec SOPreview @intClientID,@intSort", pr).ToListAsync(); int totalCount = serviceRequestListModel.Count; int pageOffSet = (Convert.ToInt32(pageIndex) - 1) * 10; serviceRequestListModel = serviceRequestListModel.Skip(pageOffSet).Take(Convert.ToInt32(pageSize)).ToList(); return(serviceRequestListModel, totalCount); } catch (Exception ex) { } return(null, 0); }