public List <WebsiteModel> GetActiveWebsites() { var websites = new List <WebsiteModel>(); using (ESportsNewsContext context = new ESportsNewsContext()) { websites = (from w in context.Websites join g in context.Games on w.GameID equals g.GameID where w.Active select new WebsiteModel() { WebsiteId = w.WebsiteID, Title = w.Title, URL = w.URL, Active = w.Active, CreatedDate = w.CreatedDate, Game = new GameModel() { GameId = g.GameID, Name = g.Name, CssClass = g.CssClass } }).ToList(); } return(websites); }
public List <SubredditModel> GetActiveSubreddits() { var subreddits = new List <SubredditModel>(); using (ESportsNewsContext context = new ESportsNewsContext()) { subreddits = (from s in context.Subreddits where s.Active select new SubredditModel() { SubredditId = s.SubredditID, Name = s.Name, Shortcut = s.Shortcut, Active = s.Active, CreatedDate = s.CreatedDate, }).ToList(); } return(subreddits); }