public IEnumerable <Game> findGlobalGames(int?MemberId) { if (MemberId == null || MemberId == 0) { return(db.Games.Where(g => g.Global == true && (g.GameState.ToLower() == "prepare" || g.GameState.ToLower() == "released" || g.GameState.ToLower() == "active"))); // MAtt - Put back membershipID match TODO refactor membersubtype checking } else { Member member = db.Members.Where(m => m.MemberID == MemberId).First(); List <int?> GameIDs = db.GetMissingGames(member.MemberID).ToList(); return(db.Games.Where(g => GameIDs.Contains(g.GameID))); } }