private List<Student> GetStudentsFromCommand(SqlCommand command)
{
List<Student> studentList = new List<Student>();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Student student = new Student()
{
ID = (int)reader["PersonID"],
LastName = (string)reader["LastName"],
FirstName = (string)reader["FirstName"],
EnrollmentDate = (DateTime)reader["EnrollmentDate"]
};
studentList.Add(student);
}
}
return studentList;
}
public void AddStudent(Student student)
{
throw new NotImplementedException();
}
public void UpdateStudent(Student student)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
string commandText =
@"exec UpdateStudent @PersonID, @LastName, @FirstName, @EnrollmentDate";
SqlCommand command = new SqlCommand(commandText, connection);
command.Parameters.Add(
new SqlParameter()
{
ParameterName = "@PersonID",
DbType = DbType.Int32,
Value = student.ID
}
);
command.Parameters.Add(
new SqlParameter()
{
ParameterName = "@LastName",
DbType = DbType.String,
Value = student.LastName
}
);
command.Parameters.Add(
new SqlParameter()
{
ParameterName = "@FirstName",
DbType = DbType.String,
Value = student.FirstName
}
);
command.Parameters.Add(
new SqlParameter()
{
ParameterName = "@EnrollmentDate",
DbType = DbType.DateTime,
Value = student.EnrollmentDate
}
);
connection.Open();
command.ExecuteNonQuery();
}
}