Student PopulateStudentWithEnrollment(int student, DbConnection connection)
{
Student newStudent = new Student(student);
var command = factory.CreateCommand();
command.Connection = connection;
command.CommandText = string.Format("SELECT * FROM ENROLLMENT WHERE STUDENTID = {0}", student);
using (DbDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
var enrollment = new SubjectEnrollment(
dataReader["CourseCode"].ToString(),
Convert.ToInt32(dataReader["Year"]),
Convert.ToInt32(dataReader[""])
);
newStudent.AddSubjectEnrollment(enrollment);
}
}
return(newStudent);
}
public void AddSubjectEnrollment(SubjectEnrollment subjectEnrollment)
{
SubjectEnrollments.Add(subjectEnrollment);
}
