public void Configure(IVSReportingConfiguration configuration)
{
var db = new SchoolContext("Data Source=(LocalDb)\\v11.0;Initial Catalog=ContosoUniversity2;Integrated Security=SSPI;");
//register dynamic sample data as an action loading data from local db
configuration.RegisterSampleData("departments", db.QueryDepartmentsForReport);
configuration.RegisterSampleData("students", db.QueryStudentsReport);
}
protected override void Seed(ContosoUniversity.DAL.SchoolContext context) // Seed the Db with test data
{
var students = new List <Student>
{
new Student {
FirstMidName = "Carson", LastName = "Alexander", EnrollmentDate = DateTime.Parse("2010-09-01")
},
new Student {
FirstMidName = "Meredith", LastName = "Alonso", EnrollmentDate = DateTime.Parse("2012-09-01")
},
new Student {
FirstMidName = "Arturo", LastName = "Anand", EnrollmentDate = DateTime.Parse("2013-09-01")
},
new Student {
FirstMidName = "Gytis", LastName = "Barzdukas", EnrollmentDate = DateTime.Parse("2012-09-01")
},
new Student {
FirstMidName = "Yan", LastName = "Li", EnrollmentDate = DateTime.Parse("2012-09-01")
},
new Student {
FirstMidName = "Peggy", LastName = "Justice", EnrollmentDate = DateTime.Parse("2011-09-01")
},
new Student {
FirstMidName = "Laura", LastName = "Norman", EnrollmentDate = DateTime.Parse("2013-09-01")
},
new Student {
FirstMidName = "Nino", LastName = "Olivetto", EnrollmentDate = DateTime.Parse("2005-09-01")
}
};
//Uses last names since all last names are unique. Would have ot be changed if students shared the same last name.
students.ForEach(s => context.Students.AddOrUpdate(p => p.LastName, s)); //AddOrUpdate is an upsert operation; It inserts data if the data doesn't exist, or it updates the data if it does exists and there are changes. If there is no change, then it does nothing.
context.SaveChanges();
var instructors = new List <Instructor>
{
new Instructor {
FirstMidName = "Kim", LastName = "Abercrombie", HireDate = DateTime.Parse("1995-03-11")
},
new Instructor {
FirstMidName = "Fadi", LastName = "Fakhouri", HireDate = DateTime.Parse("2002-07-06")
},
new Instructor {
FirstMidName = "Roger", LastName = "Harui", HireDate = DateTime.Parse("1998-07-01")
},
new Instructor {
FirstMidName = "Candace", LastName = "Kapoor", HireDate = DateTime.Parse("2001-01-15")
},
new Instructor {
FirstMidName = "Roger", LastName = "Zheng", HireDate = DateTime.Parse("2004-02-12")
}
};
instructors.ForEach(i => context.Instructors.AddOrUpdate(p => p.LastName, i));
context.SaveChanges();
var departments = new List <Department>
{
new Department {
Name = "English", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Abercrombie").ID
},
new Department {
Name = "Mathematics", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Fakhouri").ID
},
new Department {
Name = "Engineering", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Harui").ID
},
new Department {
Name = "Economics", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Kapoor").ID
}
};
departments.ForEach(d => context.Departments.AddOrUpdate(p => p.Name, d));
context.SaveChanges();
var courses = new List <Course>
{
new Course {
CourseID = 1050, Title = "Chemistry", Credits = 3,
DepartmentID = departments.Single(s => s.Name == "Engineering").DepartmentID,
Instructors = new List <Instructor>()
},
new Course {
CourseID = 4022, Title = "Microeconomics", Credits = 3,
DepartmentID = departments.Single(s => s.Name == "Economics").DepartmentID,
Instructors = new List <Instructor>()
},
new Course {
CourseID = 4041, Title = "Macroeconomics", Credits = 3,
DepartmentID = departments.Single(s => s.Name == "Economics").DepartmentID,
Instructors = new List <Instructor>()
},
new Course {
CourseID = 1045, Title = "Calculus", Credits = 4,
DepartmentID = departments.Single(s => s.Name == "Mathematics").DepartmentID,
Instructors = new List <Instructor>()
},
new Course {
CourseID = 3141, Title = "Trigonometry", Credits = 4,
DepartmentID = departments.Single(s => s.Name == "Mathematics").DepartmentID,
Instructors = new List <Instructor>()
},
new Course {
CourseID = 2021, Title = "Composition", Credits = 3,
DepartmentID = departments.Single(s => s.Name == "English").DepartmentID,
Instructors = new List <Instructor>()
},
new Course {
CourseID = 2042, Title = "Literature", Credits = 4,
DepartmentID = departments.Single(s => s.Name == "English").DepartmentID,
Instructors = new List <Instructor>()
}
};
courses.ForEach(s => context.Courses.AddOrUpdate(p => p.CourseID, s));
context.SaveChanges();
var officeAssignments = new List <OfficeAssignment>
{
new OfficeAssignment
{
InstructorID = instructors.Single(i => i.LastName == "Fakhouri").ID,
Location = "Smith 17"
},
new OfficeAssignment
{
InstructorID = instructors.Single(i => i.LastName == "Harui").ID,
Location = "Gowan 27"
},
new OfficeAssignment
{
InstructorID = instructors.Single(i => i.LastName == "Kapoor").ID,
Location = "Thompson 304"
}
};
officeAssignments.ForEach(s => context.OfficeAssignments.AddOrUpdate(p => p.InstructorID, s));
context.SaveChanges();
AddOrUpdateInstructor(context, "Chemistry", "Kapoor");
AddOrUpdateInstructor(context, "Chemistry", "Harui");
AddOrUpdateInstructor(context, "Microeconomics", "Zheng");
AddOrUpdateInstructor(context, "Macroeconomics", "Zheng");
AddOrUpdateInstructor(context, "Calculus", "Fakhouri");
AddOrUpdateInstructor(context, "Trigonometry", "Harui");
AddOrUpdateInstructor(context, "Composition", "Abercrombie");
AddOrUpdateInstructor(context, "Literature", "Abercrombie");
context.SaveChanges();
var enrollments = new List <Enrollment>
{
new Enrollment
{
// Although ID wasn't set when creating student data above, after calling context.SaveChanges(), each student was assigned PK ID.
StudentID = students.Single(s => s.LastName == "Alexander").ID,
CourseID = courses.Single(c => c.Title == "Chemistry").CourseID,
Grade = Grade.A
},
new Enrollment
{
StudentID = students.Single(s => s.LastName == "Alexander").ID,
CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID,
Grade = Grade.C
},
new Enrollment
{
StudentID = students.Single(s => s.LastName == "Alexander").ID,
CourseID = courses.Single(c => c.Title == "Macroeconomics").CourseID,
Grade = Grade.B
},
new Enrollment
{
StudentID = students.Single(s => s.LastName == "Alonso").ID,
CourseID = courses.Single(c => c.Title == "Calculus").CourseID,
Grade = Grade.B
},
new Enrollment
{
StudentID = students.Single(s => s.LastName == "Alonso").ID,
CourseID = courses.Single(c => c.Title == "Trigonometry").CourseID,
Grade = Grade.B
},
new Enrollment
{
StudentID = students.Single(s => s.LastName == "Alonso").ID,
CourseID = courses.Single(c => c.Title == "Composition").CourseID,
Grade = Grade.B
},
new Enrollment
{
StudentID = students.Single(s => s.LastName == "Anand").ID,
CourseID = courses.Single(c => c.Title == "Chemistry").CourseID
},
new Enrollment
{
StudentID = students.Single(s => s.LastName == "Anand").ID,
CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID,
Grade = Grade.B
},
new Enrollment
{
StudentID = students.Single(s => s.LastName == "Barzdukas").ID,
CourseID = courses.Single(c => c.Title == "Chemistry").CourseID,
Grade = Grade.B
},
new Enrollment
{
StudentID = students.Single(s => s.LastName == "Li").ID,
CourseID = courses.Single(c => c.Title == "Composition").CourseID,
Grade = Grade.B
},
new Enrollment
{
StudentID = students.Single(s => s.LastName == "Justice").ID,
CourseID = courses.Single(c => c.Title == "Literature").CourseID,
Grade = Grade.B
}
};
foreach (Enrollment e in enrollments)
{
var enrollmentInDataBase = context.Enrollments.Where(
s => s.StudentID == e.StudentID &&
s.Course.CourseID == e.CourseID).SingleOrDefault();
if (enrollmentInDataBase == null)
{
context.Enrollments.Add(e);
}
}
context.SaveChanges();
}
public GenericRepository(SchoolContext context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}
