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;
}
