public void Get_staff_returns_staff() { using (var context = new FIFContext(ContextOptions)) { var repository = new StaffRepository(context); var result = repository.All().Result; result.Count.ShouldBe(2); result.ShouldSatisfyAllConditions( () => result.ElementAt(0).StaffKey.ShouldBe(1), () => result.ElementAt(0).PersonalTitlePrefix.ShouldBe("Sr."), () => result.ElementAt(0).FirstName.ShouldBe("Joe"), () => result.ElementAt(0).MiddleName.ShouldBe("J."), () => result.ElementAt(0).LastSurname.ShouldBe("Doe"), () => result.ElementAt(0).StaffUniqueId.ShouldBe("1")); result.ShouldSatisfyAllConditions( () => result.ElementAt(1).StaffKey.ShouldBe(2), () => result.ElementAt(1).PersonalTitlePrefix.ShouldBe("Sr."), () => result.ElementAt(1).FirstName.ShouldBe("Cody"), () => result.ElementAt(1).MiddleName.ShouldBe("C."), () => result.ElementAt(1).LastSurname.ShouldBe("Smith"), () => result.ElementAt(1).StaffUniqueId.ShouldBe("2")); } }
public void Get_staff_returns_staff() { using (var context = new FIFContext(ContextOptions)) { var repository = new SectionRepository(context); var result = repository.All().Result; result.Count.ShouldBe(3); result.ShouldSatisfyAllConditions( () => result.ElementAt(0).SectionKey.ShouldBe("1"), () => result.ElementAt(0).SchoolKey.ShouldBe("1"), () => result.ElementAt(0).LocalCourseCode.ShouldBe("ACER08"), () => result.ElementAt(0).SessionName.ShouldBe("Traditional"), () => result.ElementAt(0).SectionIdentifier.ShouldBe("21855"), () => result.ElementAt(0).SchoolYear.ShouldBe <Int16>(2012)); result.ShouldSatisfyAllConditions( () => result.ElementAt(1).SectionKey.ShouldBe("2"), () => result.ElementAt(1).SchoolKey.ShouldBe("1"), () => result.ElementAt(1).LocalCourseCode.ShouldBe("ACER08"), () => result.ElementAt(1).SessionName.ShouldBe("Traditional-Spring Semester"), () => result.ElementAt(1).SectionIdentifier.ShouldBe("21856"), () => result.ElementAt(1).SchoolYear.ShouldBe <Int16>(2012)); result.ShouldSatisfyAllConditions( () => result.ElementAt(2).SectionKey.ShouldBe("3"), () => result.ElementAt(2).SchoolKey.ShouldBe("2"), () => result.ElementAt(2).LocalCourseCode.ShouldBe("ACER09"), () => result.ElementAt(2).SessionName.ShouldBe("Traditional"), () => result.ElementAt(2).SectionIdentifier.ShouldBe("21857"), () => result.ElementAt(2).SchoolYear.ShouldBe <Int16>(2012)); } }
public void Get_staffSectionAssociation_returns_staffSectionAssociation() { using (var context = new FIFContext(ContextOptions)) { var repository = new StaffSectionAssociationRepository(context); var result = repository.All().Result; result.Count.ShouldBe(4); result.ShouldSatisfyAllConditions( () => result.ElementAt(0).SectionKey.ShouldBe("1"), () => result.ElementAt(0).StaffKey.ShouldBe(1), () => result.ElementAt(0).BeginDate.ShouldBe(new DateTime(2012, 01, 01)), () => result.ElementAt(0).EndDate.ShouldBeNull()); result.ShouldSatisfyAllConditions( () => result.ElementAt(1).SectionKey.ShouldBe("2"), () => result.ElementAt(1).StaffKey.ShouldBe(1), () => result.ElementAt(1).BeginDate.ShouldBe(new DateTime(2012, 01, 01)), () => result.ElementAt(1).EndDate.ShouldBeNull()); result.ShouldSatisfyAllConditions( () => result.ElementAt(2).SectionKey.ShouldBe("2"), () => result.ElementAt(2).StaffKey.ShouldBe(2), () => result.ElementAt(2).BeginDate.ShouldBe(new DateTime(2012, 01, 01)), () => result.ElementAt(2).EndDate.ShouldBeNull()); result.ShouldSatisfyAllConditions( () => result.ElementAt(3).SectionKey.ShouldBe("3"), () => result.ElementAt(3).StaffKey.ShouldBe(2), () => result.ElementAt(3).BeginDate.ShouldBe(new DateTime(2012, 01, 01)), () => result.ElementAt(3).EndDate.ShouldNotBeNull()); } }
public void Get_studentSections_by_student_returns_existing_studentSections() { using (var context = new FIFContext(ContextOptions)) { var repository = new StudentSectionRepository(context); var result = repository.GetByStudent("2-1").Result; result.Count.ShouldBe(2); result.ShouldSatisfyAllConditions( () => result.ElementAt(0).StudentSectionKey.ShouldBe("2-1"), () => result.ElementAt(0).SchoolKey.ShouldBe("1"), () => result.ElementAt(0).SectionKey.ShouldBe("1"), () => result.ElementAt(0).StudentSchoolKey.ShouldBe("2-1"), () => result.ElementAt(0).StudentKey.ShouldBe("2"), () => result.ElementAt(0).LocalCourseCode.ShouldBe("ACER08"), () => result.ElementAt(0).Subject.ShouldBe("Fine and Performing Arts"), () => result.ElementAt(0).CourseTitle.ShouldBe("Art, Grade 8"), () => result.ElementAt(0).TeacherName.ShouldBe("Joe Doe"), () => result.ElementAt(0).SchoolYear.ShouldBe("2012")); result.ShouldSatisfyAllConditions( () => result.ElementAt(1).StudentSectionKey.ShouldBe("2-2"), () => result.ElementAt(1).SchoolKey.ShouldBe("1"), () => result.ElementAt(1).SectionKey.ShouldBe("2"), () => result.ElementAt(1).StudentSchoolKey.ShouldBe("2-1"), () => result.ElementAt(1).StudentKey.ShouldBe("2"), () => result.ElementAt(1).LocalCourseCode.ShouldBe("ACER31"), () => result.ElementAt(1).Subject.ShouldBe("Fine and Performing Arts"), () => result.ElementAt(1).CourseTitle.ShouldBe("Art Iii Ceramics (1 Unit)"), () => result.ElementAt(1).TeacherName.ShouldBe("Cody Smith"), () => result.ElementAt(1).SchoolYear.ShouldBe("2012")); } }
public void Get_staff_by_key_returns_null_when_it_does_not_exist() { using (var context = new FIFContext(ContextOptions)) { var repository = new SectionRepository(context); var result = repository.Get("999").Result; result.ShouldBeNull(); } }
public void Get_StudentSchool_by_studentSchoolKey_returns_null_when_it_does_not_exist() { using (var context = new FIFContext(ContextOptions)) { var repository = new StudentSchoolRepository(context); var result = repository.Get("1-999").Result; result.ShouldBeNull(); } }
public void Get_staff_by_key_returns_staff_when_it_exists() { using (var context = new FIFContext(ContextOptions)) { var repository = new SectionRepository(context); var result = repository.Get("1").Result; result.ShouldSatisfyAllConditions( () => result.SectionKey.ShouldBe("1"), () => result.SchoolKey.ShouldBe("1"), () => result.LocalCourseCode.ShouldBe("ACER08"), () => result.SessionName.ShouldBe("Traditional"), () => result.SectionIdentifier.ShouldBe("21855"), () => result.SchoolYear.ShouldBe <Int16>(2012)); } }
public void Get_staff_by_key_returns_staff_when_it_exists() { using (var context = new FIFContext(ContextOptions)) { var repository = new StaffRepository(context); var result = repository.Get(1).Result; result.ShouldSatisfyAllConditions( () => result.StaffKey.ShouldBe(1), () => result.PersonalTitlePrefix.ShouldBe("Sr."), () => result.FirstName.ShouldBe("Joe"), () => result.MiddleName.ShouldBe("J."), () => result.LastSurname.ShouldBe("Doe"), () => result.StaffUniqueId.ShouldBe("1")); } }
public void Get_studentSections_returns_existing_studentSections() { using (var context = new FIFContext(ContextOptions)) { var repository = new StudentSectionRepository(context); var result = repository.Get("1-1").Result; result.ShouldSatisfyAllConditions( () => result.StudentSectionKey.ShouldBe("1-1"), () => result.SchoolKey.ShouldBe("1"), () => result.SectionKey.ShouldBe("1"), () => result.StudentSchoolKey.ShouldBe("1-1"), () => result.StudentKey.ShouldBe("1"), () => result.LocalCourseCode.ShouldBe("ACER08"), () => result.Subject.ShouldBe("Fine and Performing Arts"), () => result.CourseTitle.ShouldBe("Art, Grade 8"), () => result.TeacherName.ShouldBe("Joe Doe"), () => result.SchoolYear.ShouldBe("2012")); } }
public void Get_all_studentschools_returns_studentschools() { using (var context = new FIFContext(ContextOptions)) { var repository = new StudentSchoolRepository(context); var result = repository.All().Result; result.Count.ShouldBe(2); result.ShouldSatisfyAllConditions( () => result.ElementAt(0).StudentSchoolKey.ShouldBe("1-1"), () => result.ElementAt(0).StudentKey.ShouldBe("1"), () => result.ElementAt(0).SchoolKey.ShouldBe("1"), () => result.ElementAt(0).SchoolYear.ShouldBe("2012"), () => result.ElementAt(0).StudentFirstName.ShouldBe("Tommas"), () => result.ElementAt(0).StudentMiddleName.ShouldBeNull(), () => result.ElementAt(0).StudentLastName.ShouldBe("McCarthy"), () => result.ElementAt(0).EnrollmentDateKey.ShouldBe("20120101"), () => result.ElementAt(0).GradeLevel.ShouldBe("Ninth grade"), () => result.ElementAt(0).PictureURL.ShouldBe("Some url for the picture"), () => result.ElementAt(0).LimitedEnglishProficiency.ShouldBeNull(), () => result.ElementAt(0).IsHispanic.ShouldBe(false), () => result.ElementAt(0).Sex.ShouldBeNull()); result.ShouldSatisfyAllConditions( () => result.ElementAt(1).StudentSchoolKey.ShouldBe("2-1"), () => result.ElementAt(1).StudentKey.ShouldBe("2"), () => result.ElementAt(1).SchoolKey.ShouldBe("1"), () => result.ElementAt(1).SchoolYear.ShouldBe("2012"), () => result.ElementAt(1).StudentFirstName.ShouldBe("Matthew"), () => result.ElementAt(1).StudentMiddleName.ShouldBeNull(), () => result.ElementAt(1).StudentLastName.ShouldBe("Simpson"), () => result.ElementAt(1).EnrollmentDateKey.ShouldBe("20120101"), () => result.ElementAt(1).GradeLevel.ShouldBe("Eighth grade"), () => result.ElementAt(1).LimitedEnglishProficiency.ShouldBeNull(), () => result.ElementAt(1).IsHispanic.ShouldBe(true), () => result.ElementAt(1).Sex.ShouldBe("Male")); } }
public void Get_StudentSchool_by_studentSchoolKey_returns_StudentSchool() { using (var context = new FIFContext(ContextOptions)) { var repository = new StudentSchoolRepository(context); var result = repository.Get("1-1").Result; result.ShouldSatisfyAllConditions( () => result.StudentSchoolKey.ShouldBe("1-1"), () => result.StudentKey.ShouldBe("1"), () => result.SchoolKey.ShouldBe("1"), () => result.SchoolYear.ShouldBe("2012"), () => result.StudentFirstName.ShouldBe("Tommas"), () => result.StudentMiddleName.ShouldBeNull(), () => result.StudentLastName.ShouldBe("McCarthy"), () => result.EnrollmentDateKey.ShouldBe("20120101"), () => result.GradeLevel.ShouldBe("Ninth grade"), () => result.LimitedEnglishProficiency.ShouldBeNull(), () => result.IsHispanic.ShouldBe(false), () => result.Sex.ShouldBeNull(), () => result.PictureURL.ShouldBe("Some url for the picture")); } }
public StudentSchoolRepository(FIFContext db) { _db = db; }
public ContactPersonRepository(FIFContext db) { _db = db; }
public StaffRepository(FIFContext db) { _db = db; }
public StaffSectionAssociationRepository(FIFContext db) { _db = db; }
public StudentContactRepository(FIFContext db) { _db = db; }
private void Seed() { using (var context = new FIFContext(ContextOptions)) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); var studentSchools = new List <StudentSchool>() { new StudentSchool() { StudentSchoolKey = "1-1", SchoolKey = "1", SchoolYear = "2012", StudentKey = "1", StudentFirstName = "Tommas", StudentLastName = "McCarthy", EnrollmentDateKey = "20120101", GradeLevel = "Ninth grade", PictureURL = "Some url for the picture" }, new StudentSchool() { StudentSchoolKey = "2-1", SchoolKey = "1", SchoolYear = "2012", StudentKey = "2", StudentFirstName = "Matthew", StudentLastName = "Simpson", EnrollmentDateKey = "20120101", GradeLevel = "Eighth grade", IsHispanic = true, Sex = "Male" } }; var staff = new List <Staff>() { new Staff() { StaffKey = 1, StaffUniqueId = "1", PersonalTitlePrefix = "Sr.", FirstName = "Joe", LastSurname = "Doe", MiddleName = "J." }, new Staff() { StaffKey = 2, StaffUniqueId = "2", PersonalTitlePrefix = "Sr.", FirstName = "Cody", LastSurname = "Smith", MiddleName = "C." } }; var sections = new List <Section>() { new Section() { SectionKey = "1", SchoolKey = "1", SchoolYear = 2012, SessionName = "Traditional", SectionIdentifier = "21855", LocalCourseCode = "ACER08" }, new Section() { SectionKey = "2", SchoolKey = "1", SchoolYear = 2012, SessionName = "Traditional-Spring Semester", SectionIdentifier = "21856", LocalCourseCode = "ACER08" }, new Section() { SectionKey = "3", SchoolKey = "2", SchoolYear = 2012, SessionName = "Traditional", SectionIdentifier = "21857", LocalCourseCode = "ACER09" } }; var staffSectionAssociation = new List <StaffSectionAssociation>() { new StaffSectionAssociation() { StaffKey = 1, SectionKey = "1", BeginDate = new DateTime(2012, 01, 01) }, new StaffSectionAssociation() { StaffKey = 1, SectionKey = "2", BeginDate = new DateTime(2012, 01, 01) }, new StaffSectionAssociation() { StaffKey = 2, SectionKey = "2", BeginDate = new DateTime(2012, 01, 01) }, new StaffSectionAssociation() { StaffKey = 2, SectionKey = "3", BeginDate = new DateTime(2012, 01, 01), EndDate = DateTime.Now.AddDays(1) } }; var studentSections = new List <StudentSection>() { new StudentSection() { StudentSectionKey = "1-1", SchoolKey = "1", SectionKey = "1", StudentSchoolKey = "1-1", StudentKey = "1", LocalCourseCode = "ACER08", Subject = "Fine and Performing Arts", CourseTitle = "Art, Grade 8", TeacherName = "Joe Doe", SchoolYear = "2012" }, new StudentSection() { StudentSectionKey = "2-1", SchoolKey = "1", SectionKey = "1", StudentSchoolKey = "2-1", StudentKey = "2", LocalCourseCode = "ACER08", Subject = "Fine and Performing Arts", CourseTitle = "Art, Grade 8", TeacherName = "Joe Doe", SchoolYear = "2012" }, new StudentSection() { StudentSectionKey = "2-2", SchoolKey = "1", SectionKey = "2", StudentSchoolKey = "2-1", StudentKey = "2", LocalCourseCode = "ACER31", Subject = "Fine and Performing Arts", CourseTitle = "Art Iii Ceramics (1 Unit)", TeacherName = "Cody Smith", SchoolYear = "2012" } }; context.AddRange(studentSchools); context.AddRange(sections); context.AddRange(staff); context.AddRange(staffSectionAssociation); context.AddRange(studentSections); context.SaveChanges(); } }
public SectionRepository(FIFContext db) { _db = db; }