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