public static List <article> GetArticlesByTag(string tag, int numArticles = 15, Grouping groupBy = Grouping.ThisWeek) { using (var context = new SlackerNewsEntities()) { DateTime start = StartForGrouping(groupBy); DateTime end = EndForGrouping(groupBy); string tagStripped = tag.ToLower().Trim(); return(context.articles .Where(t => t.create_datetime > start && t.create_datetime < end && ( t.title.StartsWith(tagStripped + " ") || t.title.Contains(" " + tagStripped + " ") || t.title.EndsWith(" " + tagStripped))) .OrderByDescending(t => t.score) .Take(numArticles) .ToList()); } }
public static List <article> GetArticles(Constants.Section section, int numArticles = 15, Grouping groupBy = Grouping.ThisWeek) { using (var context = new SlackerNewsEntities()) { DateTime start = StartForGrouping(groupBy); DateTime end = EndForGrouping(groupBy); return(context.articles .Where(t => t.create_datetime > start && t.create_datetime < end && t.section_id == (int)section) .OrderByDescending(t => t.score) .Take(numArticles) // .OrderByDescending(t => t.create_datetime) .ToList()); } }