public async Task <List <GetActiveTournamentsForUserDto> > GetActiveTournamentsForUsers(GetActiveTournamentsForUserDto activeTournaments) { var tournaments = await(from tu in _context.TournamentUsers join t in _context.Tournaments on tu.TournamentID equals t.TournamentId join u in _context.Users on t.CreatorOfTournament equals u.UserId where tu.UserID == activeTournaments.UserId && t.Active == 1 select new GetActiveTournamentsForUserDto { UserId = u.UserId, CreatorUsername = u.Username, tournamentId = t.TournamentId, startTime = t.StartTime, endTime = t.EndTime, tournamentName = t.TournamentName, gameType = t.GameType, creatorOfTournament = t.CreatorOfTournament, active = t.Active, playerCount = t.PlayerCount }).ToListAsync(); return(tournaments); }
public async Task <IActionResult> GetActiveTournamentsForUsers(GetActiveTournamentsForUserDto activeTournaments) { var tournaments = await _repo.GetActiveTournamentsForUsers(activeTournaments); return(Ok(tournaments)); }