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);
}
