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