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