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