public async Task <SubCategoriesTableViewModel> GetDataTable(int take, int pageNumber, int categoryId, string search)
{
int skip = (pageNumber - 1) * take;
int totalItemCount = _context.SubCategories.Where(s => s.CategoryId == categoryId && s.Title.ToLower().Contains(search.ToLower())).Count();
var subCategories = await _context.SubCategories.Include(s => s.Category).Where(s => s.CategoryId == categoryId && s.Title.ToLower().Contains(search.ToLower())).Skip(skip).Take(take).ToListAsync();
var pageItemCount = subCategories.Count();
var pagination = Pagination.CreatePaginationData(take, pageNumber, totalItemCount, pageItemCount);
var subCategoriesTable = new SubCategoriesTableViewModel();
subCategoriesTable.SubCategories = subCategories;
subCategoriesTable.Pagination = pagination;
return(subCategoriesTable);
}
public async Task <SubCategoriesTableViewModel> GetDataTable(int take, int pageNumber)
{
int skip = (pageNumber - 1) * take;
int totalItemCount = _context.SubCategories.Count();
var subCategories = await _context.SubCategories.Include(s => s.Category).Skip(skip).Take(take).ToListAsync();
var pageItemCount = subCategories.Count();
var pagination = Pagination.CreatePaginationData(take, pageNumber, totalItemCount, pageItemCount);
var subCategoriesTable = new SubCategoriesTableViewModel();
subCategoriesTable.SubCategories = subCategories;
subCategoriesTable.Pagination = pagination;
return(subCategoriesTable);
}
