public IList <Questions> GetQuestions(PagingAttributes pagingAttributes)
{
//// for browsing the full list of questions
using var db = new DatabaseContext();
//convert back from 1-based pages + check/fix page
int page = _sharedService.GetPagination(_sharedService.NumberOfQuestions(), pagingAttributes);
return(db.Questions
.OrderBy(u => u.Id)
.Skip(page * pagingAttributes.PageSize)
.Take(pagingAttributes.PageSize)
.ToList());
}
public (List <Searches>, int) GetSearchesList(int userId, PagingAttributes pagingAttributes)
{
using var db = new DatabaseContext();
var count = db.Searches
.Where(x => x.UserId == userId)
.OrderByDescending(x => x.Date)
.Count();
//try to convert back from 1-based pages
int page = _sharedService.GetPagination(count, pagingAttributes);
var list = db.Searches
.Where(x => x.UserId == userId)
.OrderByDescending(x => x.Date)
.Skip(page * pagingAttributes.PageSize)
.Take(pagingAttributes.PageSize)
.ToList();
return(list, count);
}
