public async Task <IActionResult> CoreItemsNotOrdered(DataSourceRequest command, CoreNotOrderedListModel model) { var(coreItemsModel, totalCount) = await _selectItemsServices.PrepareCoreItemNotOrderListModel(model, command.Page, command.PageSize); var gridModel = new DataSourceResult { Data = coreItemsModel, Total = totalCount }; return(Json(gridModel)); }
public async Task <(IEnumerable <DustyShelfCore> coreItemsModel, int totalCount)> PrepareCoreItemNotOrderListModel(CoreNotOrderedListModel model, int pageIndex, int pageSize) { ///Add from store procedure response to model var corelistmodel = new List <DustyShelfCore>(); int totalCount = 0; try { SqlParameter[] pr = new SqlParameter[] { new SqlParameter("@intClientID", (int)_workContext.CurrentCustomer.ClientId), new SqlParameter("@DateStart", Convert.ToDateTime(model.DateStart)), new SqlParameter("@DateEnd", Convert.ToDateTime(model.DateEnd)), new SqlParameter("@intSort", model.intSort) }; var cores = await _dbContext.Set <DustyShelfCore>().FromSqlRaw("exec DustyShelfCore @intClientID,@DateStart,@DateEnd,@intSort", pr).ToListAsync(); totalCount = cores.Count; int pageOffSet = (Convert.ToInt32(pageIndex) - 1) * 10; cores = cores.Skip(pageOffSet).Take(Convert.ToInt32(pageSize)).ToList(); foreach (var p in cores) { corelistmodel.Add(new DustyShelfCore { Category = p.Category, ClientID = p.ClientID, CoreID = p.CoreID, SellingPrice = p.SellingPrice, VDescription = p.VDescription, VItem = p.VItem, VItemID = p.VItemID, VName = p.VName }); } } catch (Exception ex) { } return(corelistmodel, totalCount); }