public List <Team> GetDivision(Guid tournamentId, string division) { var contingents = Contingents.Where(x => x.TournamentId == tournamentId); var teams = Teams .Where(x => contingents.Any(c => c.Id == x.ContingentId) && x.Division == division) .ToList(); return(teams); }
public List <ReservationQueries.Participant> GetParticipants(string year, string province) { var contingents = Contingents.Where(x => x.Year == year); var participants = Participants .Where(x => contingents.Any(c => c.Id == x.ContingentId) && x.Province == province) .ToList(); return(participants); }
public List <Participant> GetParticipants(string year) { var contingents = Contingents.Where(x => x.Year == year); var participants = Participants .Where(x => contingents.Any(c => c.Id == x.ContingentId)) .ToList(); return(participants); }
public List <Participant> GetAlternates(string year) { var contingents = Contingents.Where(x => x.Year == year); var alternates = Participants .Where(x => x.IsAlternate) .Where(x => contingents.Any(c => c.Id == x.ContingentId)) .ToList(); return(alternates); }
public List <Participant> GetProfiles(int year) { if (!Tournaments.Any(x => x.Value == year.ToString())) { return(null); } var tournament = Tournaments.Single(x => x.Value == year.ToString()); var contingents = Contingents.Where(x => x.Value.TournamentId == tournament.Key); var participants = Participants.Where(x => x.IsSingle && contingents.Any(c => c.Key == x.ContingentId)) .ToList(); return(participants); }