// GET: ExerciseL/Details/5
public ActionResult Details(int id)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @" Select e.Id, e.Name, e.Language from ExercisesL e";
cmd.Parameters.Add(new SqlParameter("@id", id));
SqlDataReader reader = cmd.ExecuteReader();
ExercisesL exercises = null;
if (reader.Read())
{
exercises = new ExercisesL
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Name = reader.GetString(reader.GetOrdinal("Name")),
Language = reader.GetString(reader.GetOrdinal("Language"))
};
reader.Close();
return(View(exercises));
}
else
{
return(new StatusCodeResult(StatusCodes.Status404NotFound));
}
}
}
}
// GET: ExercisesL
public ActionResult Index()
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @" Select e.Id, e.Name, e.Language from ExercisesL e";
SqlDataReader reader = cmd.ExecuteReader();
List <ExercisesL> exercises = new List <ExercisesL>();
while (reader.Read())
{
ExercisesL exercisesL = new ExercisesL
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Name = reader.GetString(reader.GetOrdinal("Name")),
Language = reader.GetString(reader.GetOrdinal("Language"))
};
exercises.Add(exercisesL);
}
reader.Close();
return(View(exercises));
}
}
}
