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