public void GetAllTrainersPerCourses(School school)
{
SqlCommand cmdTrainerPerCourse = new SqlCommand("SELECT * FROM TrainerPerCourse", sqlConnection);
SqlDataReader readerTrainerPerCourses = cmdTrainerPerCourse.ExecuteReader();
while (readerTrainerPerCourses.Read())
{
Trainer trainer = school.Trainers.SingleOrDefault(t => t.ID == readerTrainerPerCourses.GetInt32(0));
Course course = school.Courses.SingleOrDefault(c => c.ID == readerTrainerPerCourses.GetInt32(1));
var newTrainerPerCourse = new TrainerPerCourse(trainer, course);
trainer.Courses.Add(newTrainerPerCourse);
course.Trainers.Add((newTrainerPerCourse));
school.TrainersPerCourses.Add(newTrainerPerCourse);
}
readerTrainerPerCourses.Close();
}
public void AddTrainerPerCOurse(TrainerPerCourse trainerPerCourse)
{
TrainersPerCourses.Add(trainerPerCourse);
}