public async Task <QueryResult <File> > GetAll(UserParams userParams)
{
var query = _files.AsQueryable();
var result = await PagedList <File> .ApplyPaging(query, userParams.PageNumber, userParams.PageSize);
return(result);
}
public async Task <QueryResult <File> > GetBySubCategoryId(Guid Id, UserParams userParams)
{
var query = _files.
Where(s => s.SubCategoryId == Id).AsQueryable();
var result = await PagedList <File> .ApplyPaging(query, userParams.PageNumber, userParams.PageSize);
return(result);
}
public async Task <QueryResult <SubCategory> > GetAll(UserParams userParams)
{
var query = _context.SubCategories
.Include(s => s.Notes)
.Include(s => s.Todos).AsQueryable();
var result = await PagedList <SubCategory> .ApplyPaging(query, userParams.PageNumber, userParams.PageSize);
return(result);
}
public async Task <QueryResult <Category> > GetAll(UserParams userParams)
{
var query = _categories
.Include(c => c.SubCategories)
.AsQueryable();
var categories = _categories.Include(c => c.SubCategories);
var result = await PagedList <Category> .ApplyPaging(query, userParams.PageNumber, userParams.PageSize);
return(result);
}
public async Task <QueryResult <SubCategory> > GetByCategoryId(Guid Id, UserParams userParams)
{
var query = _subCategories.
Where(s => s.CategoryId == Id)
.Include(s => s.Notes)
.Include(s => s.Todos).AsQueryable();
var result = await PagedList <SubCategory> .ApplyPaging(query, userParams.PageNumber, userParams.PageSize);
return(result);
}