public static ArticleModel GetArticleBySlug(string slug) { var article = StoredProcs.Articles_GetArticleBySlug(slug).Execute(); if (article == null) { return(null); } return(ArticleModel.FromTable(article)); }
public static ArticleModel GetArticleByLegacyPost(int postId) { var article = StoredProcs.Articles_GetArticleByLegacyPost(postId).Execute(); if (article == null) { return(null); } return(ArticleModel.FromTable(article)); }
public static ArticleModel GetArticleByLegacyPost(int postId) { var article = DB.Articles_GetArticleByLegacyPost(postId); if (article == null) { return(null); } return(ArticleModel.FromTable(article)); }
public static ArticleModel GetArticleById(int id) { var article = StoredProcs.Articles_GetArticleById(id).Execute(); if (article == null) { return(null); } return(ArticleModel.FromTable(article)); }
public static ArticleModel GetArticleBySlug(string slug) { var article = DB.Articles_GetArticleBySlug(slug); if (article == null) { return(null); } return(ArticleModel.FromTable(article)); }
public static ArticleModel GetArticleById(int id) { var article = DB.Articles_GetArticleById(id); if (article == null) { return(null); } return(ArticleModel.FromTable(article)); }
public static IEnumerable <ArticleModel> GetSeriesArticlesByMonth(string series, DateTime month) { var monthStart = new DateTime(month.Year, month.Month, 1); var articles = StoredProcs.Articles_GetArticles( series, Domains.PublishedStatus.Published, monthStart, monthStart.AddMonths(1).AddSeconds(-1.0) ).Execute(); return(articles.Select(a => ArticleModel.FromTable(a))); }
private static IEnumerable <ArticleModel> GetArticlesByMonth(DateTime month, string series = null, string author = null) { var monthStart = new DateTime(month.Year, month.Month, 1); var articles = StoredProcs.Articles_GetArticles( Series_Slug: series, PublishedStatus_Name: Domains.PublishedStatus.Published, RangeStart_Date: monthStart, RangeEnd_Date: monthStart.AddMonths(1).AddSeconds(-1.0), Author_Slug: author ).Execute(); return(articles.Select(a => ArticleModel.FromTable(a))); }
public static ArticleModel GetRandomArticle() { var article = StoredProcs.Articles_GetRandomArticle().Execute(); return(ArticleModel.FromTable(article)); }
public static IEnumerable <ArticleModel> GetUnpublishedArticles() { var articles = StoredProcs.Articles_GetUnpublishedArticles().Execute(); return(articles.Select(a => ArticleModel.FromTable(a))); }
public static IEnumerable <ArticleModel> GetRecentArticlesByAuthor(string slug) { var articles = StoredProcs.Articles_GetRecentArticles(Domains.PublishedStatus.Published, Author_Slug: slug, Article_Count: 8).Execute(); return(articles.Select(a => ArticleModel.FromTable(a))); }
public static IEnumerable <ArticleModel> GetRecentArticles(int count) { var articles = StoredProcs.Articles_GetRecentArticles(Domains.PublishedStatus.Published, Article_Count: count).Execute(); return(articles.Select(a => ArticleModel.FromTable(a))); }
public static IEnumerable <ArticleModel> GetAllArticlesBySeries(string series) { var articles = StoredProcs.Articles_GetArticles(series, Domains.PublishedStatus.Published, null, null).Execute(); return(articles.Select(a => ArticleModel.FromTable(a))); }
public static IEnumerable <ArticleModel> GetRecentArticlesBySeries(string slug, int?articleCount = 8) { var articles = StoredProcs.Articles_GetRecentArticles(Domains.PublishedStatus.Published, Series_Slug: slug, Article_Count: articleCount).Execute(); return(articles.Select(a => ArticleModel.FromTable(a))); }
public static IEnumerable <ArticleModel> GetUnpublishedArticles(string authorSlug = null) { var articles = DB.Articles_GetUnpublishedArticles(authorSlug); return(articles.Select(a => ArticleModel.FromTable(a))); }
public static IEnumerable <ArticleModel> GetRecentArticlesByAuthor(string slug, int?articleCount = 8) { var articles = DB.Articles_GetRecentArticles(Domains.PublishedStatus.Published, Author_Slug: slug, Article_Count: articleCount); return(articles.Select(a => ArticleModel.FromTable(a))); }