public void getTournamentTeams(MySqlConnection conn, ref Tournament tourney, long tourn_id) { string q = string.Format("SELECT * FROM tournament_teams WHERE tournament_id = '{0}'", tourn_id); MySqlDataReader rdr = ExecuteQuery(conn, q); while (rdr.Read()) { long _uid = rdr.GetInt64(rdr.GetOrdinal("ID")); string _name = rdr.GetString(rdr.GetOrdinal("team_name")); long captain_id = rdr.GetInt64(rdr.GetOrdinal("captain")); Team team; switch (tourney.info.Type) { case TournamentType.SOLO: { team = new Team1s(); team.Name = _name; team.Captain = tourney.getPlayerByUID(captain_id); team.ID = tourney._teams.Count; team.UID = _uid; tourney._teams.Add(team); break; } case TournamentType.DOUBLES: { team = new Team2s(); team.Name = _name; team.Captain = tourney.getPlayerByUID(captain_id); team.ID = tourney._teams.Count; team.UID = _uid; tourney._teams.Add(team); break; } case TournamentType.TRIPLES: { team = new Team3s(); team.Name = _name; team.Captain = tourney.getPlayerByID(captain_id); team.ID = tourney._teams.Count; team.UID = _uid; tourney._teams.Add(team); break; } } } rdr.Close(); }
public void getTournamentPlayerAssignments(LiteDatabase db, ref Tournament tourney) { var player_collection = db.GetCollection <TeamPlayerAssoc>("tournament_team_players"); long tourn_id = tourney.info.UID; List <TeamPlayerAssoc> associations = player_collection.Find(x => x.TournamentID == tourn_id).ToList(); foreach (TeamPlayerAssoc assoc in associations) { Player p = tourney.getPlayerByUID(assoc.PlayerID); Team t = tourney.getTeamByUID(assoc.TeamID); switch (tourney.info.Type) { case TournamentType.SOLO: { ((Team1s)t).addPlayer(p); break; } case TournamentType.DOUBLES: { ((Team2s)t).addPlayer(p); break; } case TournamentType.TRIPLES: { ((Team3s)t).addPlayer(p); break; } } } }
public TeamInvitation getPlayerInvitation(MySqlConnection conn, Tournament t, ulong inv_id) { //Fetch invitation for player string q = string.Format("SELECT * from team_invitations WHERE ID='{0}'", inv_id); MySqlDataReader rdr = ExecuteQuery(conn, q); TeamInvitation inv = new TeamInvitation(); while (rdr.Read()) { long _uid = rdr.GetInt64(rdr.GetOrdinal("ID")); long _playerid = rdr.GetInt64(rdr.GetOrdinal("player_id")); bool _pending = rdr.GetBoolean(rdr.GetOrdinal("pending")); bool _accepted = rdr.GetBoolean(rdr.GetOrdinal("accepted")); long _teamid = rdr.GetInt64(rdr.GetOrdinal("team_id")); inv.UID = _uid; inv.team = t.getTeamByUID(_teamid); inv.player = t.getPlayerByUID(_playerid); inv.pending = _pending; inv.accepted = _accepted; } rdr.Close(); return(inv); }
public void getTournamentTeams(LiteDatabase db, ref Tournament tourney) { var collection = db.GetCollection <Team>("tournament_teams"); long tourn_id = tourney.info.UID; List <Team> teams = collection.Find(x => x.TournamentID == tourn_id).ToList(); foreach (Team t in teams) { Team team = null; switch (tourney.info.Type) { case TournamentType.SOLO: { team = new Team1s(); break; } case TournamentType.DOUBLES: { team = new Team2s(); break; } case TournamentType.TRIPLES: { team = new Team3s(); break; } } team.Name = t.Name; team.CaptainID = t.CaptainID; team.Captain = tourney.getPlayerByUID(t.CaptainID); team.ID = tourney._teams.Count; team.UID = t.UID; tourney._teams.Add(team); } }
public void getTournamentPLayerAssignments(MySqlConnection conn, ref Tournament tourney, long tourn_id) { string q = string.Format("SELECT * FROM tournament_team_players WHERE tournament_id = '{0}'", tourn_id); MySqlDataReader rdr = ExecuteQuery(conn, q); while (rdr.Read()) { long _teamuid = rdr.GetInt64(rdr.GetOrdinal("team_id")); long _playeruid = rdr.GetInt64(rdr.GetOrdinal("player_id")); Player p = tourney.getPlayerByUID(_playeruid); Team t = tourney.getTeamByUID(_teamuid); switch (tourney.info.Type) { case TournamentType.SOLO: { ((Team1s)t).addPlayer(p); break; } case TournamentType.DOUBLES: { ((Team2s)t).addPlayer(p); break; } case TournamentType.TRIPLES: { ((Team3s)t).addPlayer(p); break; } } } rdr.Close(); }