public void getTeachersFromDb() { List<Teacher> allTeachers; using (var tc = new TeacherContext()) { allTeachers = tc.GetAllTeachers(); } Assert.IsNotNull(allTeachers); }
/// <summary> /// add all teacher to the person list /// </summary> private void addTeachersToPersons() { using (TeacherContext tc = new TeacherContext()) { List<Teacher> allTeachers = tc.GetAllTeachers(); foreach (Teacher teacher in allTeachers) { if (Person.Persons.Any(p => p.Id == teacher.Id)) { if (SelectedPerson != null && SelectedPerson.Id == teacher.Id) { Person.Persons.Remove(SelectedPerson); } else { continue; } } ObservableCollection<Subject> teachersSubjects = new ObservableCollection<Subject>(); foreach (var item in teacher.Subjects) { teachersSubjects.Add(item); } ObservableCollection<Class> teachersClasses = new ObservableCollection<Class>(); foreach (var item in teacher.Classes) { teachersClasses.Add(item); } Person.Persons.Add(new TeacherListItemViewData() { Id = teacher.Id, FirstName = teacher.FirstName, LastName = teacher.LastName, Address = teacher.Address, City = teacher.City, SocialSecurityNumber = teacher.SocialSecurityNumber, ZipCode = teacher.ZipCode, Subjects = teachersSubjects, Classes = teachersClasses }); } } }