private bool PopulateTeams()
{
MySqlConnection cnn = new MySqlConnection("SERVER=cis4250.cpnptclkba5c.ca-central-1.rds.amazonaws.com;DATABASE=fantasySportsApplication;UID=teamOgre;PWD=sportsApp123;Connection Timeout=5");
cnn.Open();
MySqlCommand cmdSql = new MySqlCommand("SELECT league_id, league_name, max_teams, private FROM league;", cnn);
MySqlDataReader rdr = cmdSql.ExecuteReader();
int LeagueID;
String LeagueName;
int MaxPlayers;
int Private;
int CurrentPlayers;
while (rdr.Read())
{
LeagueID = rdr.GetInt32(0);
LeagueName = rdr.GetString(1);
MaxPlayers = rdr.GetInt32(2);
Private = rdr.GetInt32(3);
dgvLeagues.Rows.Add("", LeagueName, Private, MaxPlayers, "", "Join Now", LeagueID);
}
rdr.Close();
foreach (DataGridViewRow row in dgvLeagues.Rows)
{
row.DefaultCellStyle.BackColor = Color.LightGreen;
cmdSql = new MySqlCommand(String.Format("SELECT COUNT(*) FROM league_roster WHERE league_id = {0};", row.Cells[6].Value.ToString()), cnn);
rdr = cmdSql.ExecuteReader();
rdr.Read();
CurrentPlayers = rdr.GetInt32(0);
if (CurrentPlayers.ToString() == row.Cells[3].Value.ToString())
{
row.DefaultCellStyle.BackColor = Color.LightPink;
}
row.Cells[3].Value = CurrentPlayers.ToString() + " / " + row.Cells[3].Value.ToString();
rdr.Close();
cmdSql = new MySqlCommand(String.Format("SELECT COUNT(*) FROM league_roster WHERE league_id = {0} AND participant_id = {1};", row.Cells[6].Value.ToString(), CurrentID), cnn);
rdr = cmdSql.ExecuteReader();
rdr.Read();
if (rdr.GetInt32(0) > 0)
{
row.Cells[4].Value = "Already Joined";
row.DefaultCellStyle.BackColor = Color.LightPink;
}
else
{
row.Cells[4].Value = "Not Yet Joined";
}
rdr.Close();
switch (row.Cells[2].Value.ToString())
{
case "0":
row.Cells[0].Value = "";
row.Cells[2].Value = "Public";
break;
case "1":
row.Cells[0].Value = "🔒";
row.Cells[2].Value = "Private";
break;
}
}
cnn.Close();
return(true);
}
