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