private void ChooseTournament_Load(object sender, EventArgs e)
{
List <TournamentListItem> list = MySQLTournament.getTournaments();
turns = new TournamentListItem[list.Count];
int c = 0;
foreach (TournamentListItem t in list)
{
turns[c++] = t;
listBox.Items.Add(t.Label);
}
}
private void bChoose_Click(object sender, EventArgs e)
{
if (listBox.SelectedIndex >= 0)
{
switch (turns[listBox.SelectedIndex].Type)
{
case Tournament.TYPE_PARY:
chosenTournament = new ParyTournament(turns[listBox.SelectedIndex].Name);
break;
case Tournament.TYPE_TEAMY:
chosenTournament = new TeamyTournament(turns[listBox.SelectedIndex].Name);
break;
}
Close();
}
}
public static List <TournamentListItem> getTournaments()
{
List <TournamentListItem> list = new List <TournamentListItem>();
MySQL c = new MySQL("");
data dbs = c.select("SELECT TABLE_SCHEMA, COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = 'admin' AND COLUMN_NAME IN ('dnazwa', 'teamcnt') ORDER BY TABLE_SCHEMA;");
while (dbs.Read())
{
TournamentListItem item = new TournamentListItem();
item.Name = dbs.GetString(0);
item.Type = "dnazwa".Equals(dbs.GetString(1)) ? Tournament.TYPE_PARY : Tournament.TYPE_TEAMY;
item.Label = MySQLTournament.getLabel(item.Name, item.Type);
list.Add(item);
}
dbs.Close();
return(list);
}
public override string ToString()
{
return(MySQLTournament.getLabel(this.name, this.type));
}
