public IEnumerable <Game> findComingSoonGames(int?MemberId)
{
List <int?> ComingSoonGameID = db.FindComingSoonGames(MemberId).ToList();
List <Game> ListofGames = new List <Game>();;
foreach (int i in ComingSoonGameID)
{
Game game = db.Games.Find(i);
ListofGames.Add(game);
}
//IEnumerable<Game> comingSoonGames = db.Games.Include(x => x.ProductInGames).Where(x => (x.GameState.ToLower() == "prepare" || x.GameState.ToLower() == "released" || x.GameState.ToLower() == "active") && x.MemberInGames.Count(y => y.MemberID == MemberId) > 0);
return(ListofGames);
}
