public IQueryable <Article> GetArticles(ArticlesSortBy articlesSortBy) { var query = from it in blogDbContext.Set <Article>() select it; switch (articlesSortBy) { case ArticlesSortBy.MostLikes: //query = query.OrderByDescending(it => it.LikeCount); break; case ArticlesSortBy.MostRecents: query = query.OrderByDescending(it => it.PublishDate); break; } return(query); }
public IQueryable <ArticleStatResponse> GetArticlesWithStatQuery(ArticlesSortBy articlesSortBy) { var query = GetArticlesWithStatQuery(); switch (articlesSortBy) { case ArticlesSortBy.MostLikes: query = query.OrderByDescending(it => it.LikeCount); break; case ArticlesSortBy.MostRecents: query = query.OrderByDescending(it => it.PublishDate); break; } return(query); }
public virtual IQueryable <ArticleStatResponse> GetMyArticlesWithStatQuery(string username, ArticlesSortBy articlesSortBy) { var query = GetArticlesWithStatQuery().Where(it => it.Author == username); switch (articlesSortBy) { case ArticlesSortBy.MostLikes: query = query.OrderByDescending(it => it.LikeCount); break; case ArticlesSortBy.MostRecents: query = query.OrderByDescending(it => it.PublishDate); break; } return(query); }