/// <summary>
/// FIll a list of classes with all of the leagues that a team plays in
/// </summary>
/// <param name="TeamID">The team who's leagues are being searched.</param>
/// <returns>A list of all of the leagues that the team plays in</returns>
public static List <Classes.League> FillFromTeam(int TeamID)
{
List <Classes.League> LeagueList = new List <Classes.League>();
try
{
OleDbCommand command = new OleDbCommand("SELECT League.LeagueID, League.LeagueName, League.Capacity, League.Sponsor FROM League INNER JOIN TeamLeague ON League.LeagueID = TeamLeague.LeagueID WHERE(((TeamLeague.TeamID) = 1)); ", Database.DatabaseConnection.DBConnection);
command.Parameters.Add(new OleDbParameter("@varteam", TeamID));
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Classes.League League = new Classes.League();
League.LeagueId = Int32.Parse(reader[0].ToString());
League.LeagueName = reader[1].ToString();
League.Capacity = Int32.Parse(reader[2].ToString());
League.Sponsor = reader[3].ToString();
LeagueList.Add(League);
}
}
catch (OleDbException exception)
{
MessageBox.Show(exception.Message, "OleDb Exception");
}
return(LeagueList);
}
/// <summary>
/// FIll a list of classes with all of the leagues
/// </summary>
/// <returns>A list of all of the leagues</returns>
public static List <Classes.League> Fill()
{
List <Classes.League> LeagueList = new List <Classes.League>();
try
{
OleDbCommand command = new OleDbCommand("Select * from League;", Database.DatabaseConnection.DBConnection);
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Classes.League League = new Classes.League();
League.LeagueId = Int32.Parse(reader[0].ToString());
League.LeagueName = reader[1].ToString();
League.Capacity = Int32.Parse(reader[2].ToString());
League.Sponsor = reader[3].ToString();
LeagueList.Add(League);
}
}
catch (OleDbException exception)
{
MessageBox.Show(exception.Message, "OleDb Exception");
}
return(LeagueList);
}
