public Response()
{
League = new League();
Leagues = new List<League>();
Team = new Team();
Teams = new List<Team>();
Position = new Position();
Positions = new List<Position>();
Player = new Player();
Players = new List<Player>();
}
private League PopulateLeagueInfoFromReader(SqlDataReader dr)
{
League league = new League();
league.LeagueID = (int)dr["leagueID"];
league.LeagueName = dr["leagueName"].ToString();
return league;
}
public League GetTeamsByLeagueID(int leagueID)
{
League league = new League();
Teams = new List<Team>();
using (SqlConnection cn = new SqlConnection(Settings.ConnectionString))
{
var cmd = new SqlCommand();
cmd.CommandText = "GetTeamsByLeagueID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = cn;
cmd.Parameters.AddWithValue("@LeagueID", leagueID);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
league = PopulateLeagueInfoFromReader(dr);
Team team = new Team();
team.TeamID = (int)dr["TeamID"];
team.League.LeagueID = (int)dr["leagueID"];
team.League.LeagueName = dr["leagueName"].ToString();
team.Manager = dr["Manager"].ToString();
team.TeamName = dr["TeamName"].ToString();
Teams.Add(team);
league.Teams = Teams;
}
}
}
return league;
}
public League GetLeagueByID(int leagueID)
{
var league = new League();
using (SqlConnection cn = new SqlConnection(Settings.ConnectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "GetLeagueByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = cn;
cmd.Parameters.AddWithValue("@LeagueID", leagueID);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
league = PopulateLeagueInfoFromReader(dr);
}
}
}
return league;
}
public Team()
{
League = new League();
Players = new List<Player>();
}