public List <Models.BU.Teacher> GetTeacherList()
{
Models.Database db = new Models.Database();
string query = "SELECT * FROM UserAccount WHERE Role = '2' OR Role = '3'"; // Teacher en Examiner
List <Models.BU.Teacher> teacherList = db.GetTeacherList(query);
// Vul wishList van Teachers
foreach (Models.BU.Teacher teacher in teacherList)
{
query = "SELECT DISTINCT * FROM Wish WHERE UserId = '" + teacher.UserID + "'";
teacher.wishList = db.GetWishListOfTeacher(query);
}
return(teacherList);
}