public PaginationComment ListPage(Pagination pagination, IOrderedQueryable <comment> comments)
{
int page = pagination.Page;
int size = pagination.Size;
if (page < 1)
{
page = 1;
}
int skip = (page - 1) * size;
int sizePage = comments.Count();
if (sizePage % size > 0)
{
sizePage = sizePage / size + 1;
}
else
{
sizePage = sizePage / size;
}
var sql = comments.Skip(skip).Take(size).ToList();
PaginationComment paginationComment = new PaginationComment(sizePage, page, sql);
return(paginationComment);
}
public PaginationComment ListHide(Pagination pagination)
{
var list = WcDbContext.comments.Where(comment => comment.StatusCommentId == 2)
.OrderByDescending(comment => comment.CommentTime);
PaginationComment paginationComment = ListPage(pagination, list);
return(paginationComment);
}
public PaginationComment List(Pagination pagination, int chapterId)
{
var list = WcDbContext.comments
.Where(comment => comment.StatusCommentId == 1 && comment.ChapterId == chapterId &&
comment.user.StatusUserId == 1)
.OrderByDescending(comment => comment.CommentTime);
PaginationComment paginationComment = ListPage(pagination, list);
return(paginationComment);
}
