public StudentsController(AngularContosoContext db)
{
this.db = db;
}
public InstructorsController(AngularContosoContext db)
{
this.db = db;
}
public DepartmentsController(AngularContosoContext db)
{
this.db = db;
}
public CoursesController(AngularContosoContext db)
{
this.db = db;
}
public static void Initialize(AngularContosoContext context)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.Students.Any())
{
return; // DB has been seeded
}
var students = new Student[]
{
new Student {
FirstName = "Carson", LastName = "Alexander", DateEnrolled = DateTime.Parse("2010-09-01")
},
new Student {
FirstName = "Meredith", LastName = "Alonso", DateEnrolled = DateTime.Parse("2012-09-01")
},
new Student {
FirstName = "Arturo", LastName = "Anand", DateEnrolled = DateTime.Parse("2013-09-01")
},
new Student {
FirstName = "Gytis", LastName = "Barzdukas", DateEnrolled = DateTime.Parse("2012-09-01")
},
new Student {
FirstName = "Yan", LastName = "Li", DateEnrolled = DateTime.Parse("2012-09-01")
},
new Student {
FirstName = "Peggy", LastName = "Justice", DateEnrolled = DateTime.Parse("2011-09-01")
},
new Student {
FirstName = "Laura", LastName = "Norman", DateEnrolled = DateTime.Parse("2013-09-01")
},
new Student {
FirstName = "Nino", LastName = "Olivetto", DateEnrolled = DateTime.Parse("2005-09-01")
}
};
foreach (Student s in students)
{
context.Students.Add(s);
}
context.SaveChanges();
var instructors = new Instructor[]
{
new Instructor {
FirstName = "Kim", LastName = "Abercrombie", HireDate = DateTime.Parse("1995-03-11")
},
new Instructor {
FirstName = "Fadi", LastName = "Fakhouri", HireDate = DateTime.Parse("2002-07-06")
},
new Instructor {
FirstName = "Roger", LastName = "Harui", HireDate = DateTime.Parse("1998-07-01")
},
new Instructor {
FirstName = "Candace", LastName = "Kapoor", HireDate = DateTime.Parse("2001-01-15")
},
new Instructor {
FirstName = "Roger", LastName = "Zheng", HireDate = DateTime.Parse("2004-02-12")
}
};
foreach (Instructor i in instructors)
{
context.Instructors.Add(i);
}
context.SaveChanges();
var departments = new 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
}
};
foreach (Department d in departments)
{
context.Departments.Add(d);
}
context.SaveChanges();
var courses = new Course[]
{
new Course {
CourseId = 1050, Title = "Chemistry", Credits = 3,
DepartmentId = departments.Single(s => s.Name == "Engineering").DepartmentId
},
new Course {
CourseId = 4022, Title = "Microeconomics", Credits = 3,
DepartmentId = departments.Single(s => s.Name == "Economics").DepartmentId
},
new Course {
CourseId = 4041, Title = "Macroeconomics", Credits = 3,
DepartmentId = departments.Single(s => s.Name == "Economics").DepartmentId
},
new Course {
CourseId = 1045, Title = "Calculus", Credits = 4,
DepartmentId = departments.Single(s => s.Name == "Mathematics").DepartmentId
},
new Course {
CourseId = 3141, Title = "Trigonometry", Credits = 4,
DepartmentId = departments.Single(s => s.Name == "Mathematics").DepartmentId
},
new Course {
CourseId = 2021, Title = "Composition", Credits = 3,
DepartmentId = departments.Single(s => s.Name == "English").DepartmentId
},
new Course {
CourseId = 2042, Title = "Literature", Credits = 4,
DepartmentId = departments.Single(s => s.Name == "English").DepartmentId
},
};
foreach (Course c in courses)
{
context.Courses.Add(c);
}
context.SaveChanges();
var officeAssignments = new 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"
},
};
foreach (OfficeAssignment o in officeAssignments)
{
context.OfficeAssignments.Add(o);
}
context.SaveChanges();
var courseInstructors = new CourseAssignment[]
{
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "Chemistry").CourseId,
InstructorId = instructors.Single(i => i.LastName == "Kapoor").Id
},
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "Chemistry").CourseId,
InstructorId = instructors.Single(i => i.LastName == "Harui").Id
},
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "Microeconomics").CourseId,
InstructorId = instructors.Single(i => i.LastName == "Zheng").Id
},
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "Macroeconomics").CourseId,
InstructorId = instructors.Single(i => i.LastName == "Zheng").Id
},
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "Calculus").CourseId,
InstructorId = instructors.Single(i => i.LastName == "Fakhouri").Id
},
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "Trigonometry").CourseId,
InstructorId = instructors.Single(i => i.LastName == "Harui").Id
},
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "Composition").CourseId,
InstructorId = instructors.Single(i => i.LastName == "Abercrombie").Id
},
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "Literature").CourseId,
InstructorId = instructors.Single(i => i.LastName == "Abercrombie").Id
},
};
foreach (CourseAssignment ci in courseInstructors)
{
context.CourseAssignments.Add(ci);
}
context.SaveChanges();
var enrollments = new Enrollment[]
{
new Enrollment {
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.Student.Id == e.StudentId &&
s.Course.CourseId == e.CourseId).SingleOrDefault();
if (enrollmentInDataBase == null)
{
context.Enrollments.Add(e);
}
}
context.SaveChanges();
}
