public ActionResult Team(int id)
{
var model = new TeamModel();
model.TeamId = id;
// Load scores
using (SqlConnection con = new SqlConnection(_connectionString))
{
con.Open();
try
{
using (SqlCommand command = new SqlCommand("select name from sturgeonteams where id = @team_id", con))
{
command.Parameters.Add(new SqlParameter("team_id", model.TeamId));
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
model.TeamName = reader.GetString(0);
}
}
reader.Close();
}
using (SqlCommand command = new SqlCommand("select slot, score from sturgeonscores where team_id = @team_id", con))
{
command.Parameters.Add(new SqlParameter("team_id", model.TeamId));
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
model.SetScore(reader.GetInt32(0), reader.GetInt32(1));
}
}
reader.Close();
}
}
catch (Exception ex)
{
throw ex;
}
}
return(View(model));
}
