/// <summary> /// There are no comments for OfficeAssignment in the schema. /// </summary> public void AddToOfficeAssignment(OfficeAssignment officeAssignment) { base.AddObject("OfficeAssignment", officeAssignment); }
public static void Initialize(SchoolContext context) { // Look for any students. if (context.Students.Any()) { return; // DB has been seeded } var alexander = new Student { FirstMidName = "Carson", LastName = "Alexander", EnrollmentDate = DateTime.Parse("2016-09-01") }; var alonso = new Student { FirstMidName = "Meredith", LastName = "Alonso", EnrollmentDate = DateTime.Parse("2018-09-01") }; var anand = new Student { FirstMidName = "Arturo", LastName = "Anand", EnrollmentDate = DateTime.Parse("2019-09-01") }; var barzdukas = new Student { FirstMidName = "Gytis", LastName = "Barzdukas", EnrollmentDate = DateTime.Parse("2018-09-01") }; var li = new Student { FirstMidName = "Yan", LastName = "Li", EnrollmentDate = DateTime.Parse("2018-09-01") }; var justice = new Student { FirstMidName = "Peggy", LastName = "Justice", EnrollmentDate = DateTime.Parse("2017-09-01") }; var norman = new Student { FirstMidName = "Laura", LastName = "Norman", EnrollmentDate = DateTime.Parse("2019-09-01") }; var olivetto = new Student { FirstMidName = "Nino", LastName = "Olivetto", EnrollmentDate = DateTime.Parse("2011-09-01") }; var abercrombie = new Instructor { FirstMidName = "Kim", LastName = "Abercrombie", HireDate = DateTime.Parse("1995-03-11") }; var fakhouri = new Instructor { FirstMidName = "Fadi", LastName = "Fakhouri", HireDate = DateTime.Parse("2002-07-06") }; var harui = new Instructor { FirstMidName = "Roger", LastName = "Harui", HireDate = DateTime.Parse("1998-07-01") }; var kapoor = new Instructor { FirstMidName = "Candace", LastName = "Kapoor", HireDate = DateTime.Parse("2001-01-15") }; var zheng = new Instructor { FirstMidName = "Roger", LastName = "Zheng", HireDate = DateTime.Parse("2004-02-12") }; var officeAssignments = new OfficeAssignment[] { new OfficeAssignment { Instructor = fakhouri, Location = "Smith 17" }, new OfficeAssignment { Instructor = harui, Location = "Gowan 27" }, new OfficeAssignment { Instructor = kapoor, Location = "Thompson 304" }, }; context.AddRange(officeAssignments); var english = new Department { Name = "English", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), Administrator = abercrombie, ConcurrencyToken = Guid.NewGuid() }; var mathematics = new Department { Name = "Mathematics", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), Administrator = fakhouri, ConcurrencyToken = Guid.NewGuid() }; var engineering = new Department { Name = "Engineering", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), Administrator = harui, ConcurrencyToken = Guid.NewGuid() }; var economics = new Department { Name = "Economics", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), Administrator = kapoor, ConcurrencyToken = Guid.NewGuid() }; var chemistry = new Course { CourseID = 1050, Title = "Chemistry", Credits = 3, Department = engineering, Instructors = new List <Instructor> { kapoor, harui } }; var microeconomics = new Course { CourseID = 4022, Title = "Microeconomics", Credits = 3, Department = economics, Instructors = new List <Instructor> { zheng } }; var macroeconmics = new Course { CourseID = 4041, Title = "Macroeconomics", Credits = 3, Department = economics, Instructors = new List <Instructor> { zheng } }; var calculus = new Course { CourseID = 1045, Title = "Calculus", Credits = 4, Department = mathematics, Instructors = new List <Instructor> { fakhouri } }; var trigonometry = new Course { CourseID = 3141, Title = "Trigonometry", Credits = 4, Department = mathematics, Instructors = new List <Instructor> { harui } }; var composition = new Course { CourseID = 2021, Title = "Composition", Credits = 3, Department = english, Instructors = new List <Instructor> { abercrombie } }; var literature = new Course { CourseID = 2042, Title = "Literature", Credits = 4, Department = english, Instructors = new List <Instructor> { abercrombie } }; var enrollments = new Enrollment[] { new Enrollment { Student = alexander, Course = chemistry, Grade = Grade.A }, new Enrollment { Student = alexander, Course = microeconomics, Grade = Grade.C }, new Enrollment { Student = alexander, Course = macroeconmics, Grade = Grade.B }, new Enrollment { Student = alonso, Course = calculus, Grade = Grade.B }, new Enrollment { Student = alonso, Course = trigonometry, Grade = Grade.B }, new Enrollment { Student = alonso, Course = composition, Grade = Grade.B }, new Enrollment { Student = anand, Course = chemistry, }, new Enrollment { Student = anand, Course = microeconomics, Grade = Grade.B }, new Enrollment { Student = barzdukas, Course = chemistry, Grade = Grade.B }, new Enrollment { Student = li, Course = composition, Grade = Grade.B }, new Enrollment { Student = justice, Course = literature, Grade = Grade.B } }; context.AddRange(enrollments); context.SaveChanges(); }
public static void Initialize(SchoolContext context) { //context.Database.EnsureCreated(); // Look for any students. if (context.Students.Any()) { return; // DB has been seeded } var students = new Student[] { new Student { FirstMidName = "Carson", LastName = "Alexander", Email = "*****@*****.**", SurveyDate = DateTime.Parse("2010-09-01") }, new Student { FirstMidName = "Meredith", LastName = "Alonso", Email = "*****@*****.**", SurveyDate = DateTime.Parse("2012-09-01") }, new Student { FirstMidName = "Arturo", LastName = "Anand", Email = "*****@*****.**", SurveyDate = DateTime.Parse("2013-09-01") }, new Student { FirstMidName = "Gytis", LastName = "Barzdukas", Email = "*****@*****.**", SurveyDate = DateTime.Parse("2012-09-01") }, new Student { FirstMidName = "Yan", LastName = "Li", Email = "*****@*****.**", SurveyDate = DateTime.Parse("2012-09-01") }, new Student { FirstMidName = "Peggy", LastName = "Justice", Email = "*****@*****.**", SurveyDate = DateTime.Parse("2011-09-01") }, new Student { FirstMidName = "Laura", LastName = "Norman", Email = "*****@*****.**", SurveyDate = DateTime.Parse("2013-09-01") }, new Student { FirstMidName = "Nino", LastName = "Olivetto", Email = "*****@*****.**", SurveyDate = DateTime.Parse("2005-09-01") } }; foreach (Student u in students) { context.Students.Add(u); } context.SaveChanges(); var instructors = new Instructor[] { new Instructor { FirstMidName = "Kim", LastName = "Abercrombie", Email = "*****@*****.**", HireDate = DateTime.Parse("1995-03-11") }, new Instructor { FirstMidName = "Fadi", LastName = "Fakhouri", Email = "*****@*****.**", HireDate = DateTime.Parse("2002-07-06") }, new Instructor { FirstMidName = "Roger", LastName = "Harui", Email = "*****@*****.**", HireDate = DateTime.Parse("1998-07-01") }, new Instructor { FirstMidName = "Candace", LastName = "Kapoor", Email = "*****@*****.**", HireDate = DateTime.Parse("2001-01-15") }, new Instructor { FirstMidName = "Roger", LastName = "Zheng", Email = "*****@*****.**", 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", StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Abercrombie").ID }, new Department { Name = "Mathematics", StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Fakhouri").ID }, new Department { Name = "Engineering", StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Harui").ID }, new Department { Name = "Economics", 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(u => u.Name == "Engineering").DepartmentID }, new Course { CourseID = 4022, Title = "Microeconomics", Credits = 3, DepartmentID = departments.Single(u => u.Name == "Economics").DepartmentID }, new Course { CourseID = 4041, Title = "Macroeconomics", Credits = 3, DepartmentID = departments.Single(u => u.Name == "Economics").DepartmentID }, new Course { CourseID = 1045, Title = "Calculus", Credits = 4, DepartmentID = departments.Single(u => u.Name == "Mathematics").DepartmentID }, new Course { CourseID = 3141, Title = "Trigonometry", Credits = 4, DepartmentID = departments.Single(u => u.Name == "Mathematics").DepartmentID }, new Course { CourseID = 2021, Title = "Composition", Credits = 3, DepartmentID = departments.Single(u => u.Name == "English").DepartmentID }, new Course { CourseID = 2042, Title = "Literature", Credits = 4, DepartmentID = departments.Single(u => u.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 surveys = new Survey[] { new Survey { StudentID = students.Single(u => u.LastName == "Alexander").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, }, new Survey { StudentID = students.Single(u => u.LastName == "Alexander").ID, CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID, }, new Survey { StudentID = students.Single(u => u.LastName == "Alexander").ID, CourseID = courses.Single(c => c.Title == "Macroeconomics").CourseID, }, new Survey { StudentID = students.Single(u => u.LastName == "Alonso").ID, CourseID = courses.Single(c => c.Title == "Calculus").CourseID, }, new Survey { StudentID = students.Single(u => u.LastName == "Alonso").ID, CourseID = courses.Single(c => c.Title == "Trigonometry").CourseID, }, new Survey { StudentID = students.Single(u => u.LastName == "Alonso").ID, CourseID = courses.Single(c => c.Title == "Composition").CourseID, }, new Survey { StudentID = students.Single(u => u.LastName == "Anand").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID }, new Survey { StudentID = students.Single(u => u.LastName == "Anand").ID, CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID, }, new Survey { StudentID = students.Single(u => u.LastName == "Barzdukas").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, }, new Survey { StudentID = students.Single(u => u.LastName == "Li").ID, CourseID = courses.Single(c => c.Title == "Composition").CourseID, }, new Survey { StudentID = students.Single(u => u.LastName == "Justice").ID, CourseID = courses.Single(c => c.Title == "Literature").CourseID, } }; foreach (Survey s in surveys) { var SurveyInDataBase = context.Surveys.Where( u => u.Student.ID == s.StudentID && u.Course.CourseID == s.CourseID).SingleOrDefault(); if (SurveyInDataBase == null) { context.Surveys.Add(s); } } context.SaveChanges(); }
public void DeleteOfficeAssignment(OfficeAssignment officeAssignment) { context.OfficeAssignments.Attach(officeAssignment); context.OfficeAssignments.DeleteObject(officeAssignment); context.SaveChanges(); }
public ActionResult Edit(int id, string lastName, string firstMidName, DateTime hireDate, OfficeAssignment officeAssignment, string[] selectedCourses) { instructorRepository.Update(id, lastName, firstMidName, hireDate, officeAssignment.Location, selectedCourses?.Select(int.Parse).ToArray()); return(RedirectToAction("Index")); }
private Task <int> Persist(OfficeAssignment officeAssignment) => _officeAssignmentRepository.Create(officeAssignment);
public async Task <ActionResult <OfficeAssignment> > PostOfficeAssignmentAsync(OfficeAssignment officeAssignment) { await _context.OfficeAssignment.AddAsync(officeAssignment); try { await _context.SaveChangesAsync(); } catch (DbUpdateException) { if (OfficeAssignmentExists(officeAssignment.InstructorId)) { return(Conflict()); } else { throw; } } return(CreatedAtAction("GetOfficeAssignment", new { id = officeAssignment.InstructorId }, officeAssignment)); }
public void DeleteOfficeAssignment(OfficeAssignment officeAssignment) { context.OfficeAssignments.Remove(officeAssignment); context.SaveChanges(); }
public async Task<IActionResult> PostOfficeAssignmentAsync(OfficeAssignment assignment) { await db.OfficeAssignment.AddAsync(assignment); await db.SaveChangesAsync(); return Created($"/api/officeassignments/{assignment.InstructorId}", assignment); }
public static void Initialize(SchoolContext context) { //context.Database.EnsureCreated(); // Look for any students. if (context.Student.Any()) { return; // DB has been seeded } var students = new Student[] { new Student { FirstMidName = "Chase", LastName = "Greenwood", EnrollmentDate = DateTime.Parse("2016-09-01") }, new Student { FirstMidName = "Spencer", LastName = "Harston", EnrollmentDate = DateTime.Parse("2017-09-01") }, new Student { FirstMidName = "Mark", LastName = "Haslam", EnrollmentDate = DateTime.Parse("2015-09-01") }, new Student { FirstMidName = "Dongmin", LastName = "Kim", EnrollmentDate = DateTime.Parse("2015-09-01") }, new Student { FirstMidName = "Dewey", LastName = "Lakey", EnrollmentDate = DateTime.Parse("2016-09-01") }, new Student { FirstMidName = "Nicholas", LastName = "Lambert", EnrollmentDate = DateTime.Parse("2015-09-01") }, new Student { FirstMidName = "Amy", LastName = "Lea", EnrollmentDate = DateTime.Parse("2015-09-01") }, new Student { FirstMidName = "Andrew", LastName = "Merrell", EnrollmentDate = DateTime.Parse("2015-09-01") }, new Student { FirstMidName = "Belete", LastName = "Nigusie", EnrollmentDate = DateTime.Parse("2015-09-01") }, new Student { FirstMidName = "Johnathan", LastName = "Warnes", EnrollmentDate = DateTime.Parse("2016-09-01") } }; foreach (Student s in students) { context.Student.Add(s); } context.SaveChanges(); var instructors = new Instructor[] { new Instructor { FirstMidName = "Richard", LastName = "Fry", HireDate = DateTime.Parse("2001-03-11") }, new Instructor { FirstMidName = "Brian", LastName = "Rague", HireDate = DateTime.Parse("2002-07-06") }, new Instructor { FirstMidName = "Spencer", LastName = "Hilton", HireDate = DateTime.Parse("2008-07-01") }, new Instructor { FirstMidName = "Drew", LastName = "Weidman", HireDate = DateTime.Parse("2011-01-15") }, new Instructor { FirstMidName = "Linda", LastName = "DuHadaway", HireDate = DateTime.Parse("2014-02-12") } }; foreach (Instructor i in instructors) { context.Instructor.Add(i); } context.SaveChanges(); var departments = new Department[] { new Department { Name = "Computer Science", Budget = 350000, StartDate = DateTime.Parse("2017-09-01"), InstructorID = instructors.Single(i => i.LastName == "Fry").ID }, new Department { Name = "Web UX", Budget = 100000, StartDate = DateTime.Parse("2017-09-01"), InstructorID = instructors.Single(i => i.LastName == "Hilton").ID }, new Department { Name = "Engineering", Budget = 350000, StartDate = DateTime.Parse("2017-09-01"), InstructorID = instructors.Single(i => i.LastName == "Rague").ID }, new Department { Name = "Networking", Budget = 100000, StartDate = DateTime.Parse("2017-09-01"), InstructorID = instructors.Single(i => i.LastName == "DuHadaway").ID } }; foreach (Department d in departments) { context.Department.Add(d); } context.SaveChanges(); var courses = new Course[] { new Course { CourseID = 1030, Title = "Intro to Engineering", Credits = 3, DepartmentID = departments.Single(s => s.Name == "Engineering").DepartmentID }, new Course { CourseID = 4200, Title = "Wireless Security", Credits = 3, DepartmentID = departments.Single(s => s.Name == "Networking").DepartmentID }, new Course { CourseID = 4800, Title = "Independent Project", Credits = 4, DepartmentID = departments.Single(s => s.Name == "Computer Science").DepartmentID }, new Course { CourseID = 2500, Title = "The User Experience", Credits = 4, DepartmentID = departments.Single(s => s.Name == "Web UX").DepartmentID }, new Course { CourseID = 3100, Title = "Operating Systems", Credits = 4, DepartmentID = departments.Single(s => s.Name == "Computer Science").DepartmentID }, new Course { CourseID = 2705, Title = "Local Area Networks", Credits = 3, DepartmentID = departments.Single(s => s.Name == "Networking").DepartmentID }, new Course { CourseID = 1430, Title = "JavaScript", Credits = 4, DepartmentID = departments.Single(s => s.Name == "Web UX").DepartmentID }, }; foreach (Course c in courses) { context.Course.Add(c); } context.SaveChanges(); var officeAssignments = new OfficeAssignment[] { new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "Fry").ID, Location = "EH 383" }, new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "Hilton").ID, Location = "TE 273" }, new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "DuHadaway").ID, Location = "TE 304" }, }; foreach (OfficeAssignment o in officeAssignments) { context.OfficeAssignment.Add(o); } context.SaveChanges(); var courseInstructors = new CourseAssignment[] { new CourseAssignment { CourseID = courses.Single(c => c.Title == "JavaScript").CourseID, InstructorID = instructors.Single(i => i.LastName == "Fry").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "JavaScript").CourseID, InstructorID = instructors.Single(i => i.LastName == "Hilton").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Local Area Networks").CourseID, InstructorID = instructors.Single(i => i.LastName == "Rague").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "The User Experience").CourseID, InstructorID = instructors.Single(i => i.LastName == "DuHadaway").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Operating Systems").CourseID, InstructorID = instructors.Single(i => i.LastName == "Fry").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Intro to Engineering").CourseID, InstructorID = instructors.Single(i => i.LastName == "Hilton").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Wireless Security").CourseID, InstructorID = instructors.Single(i => i.LastName == "Weidman").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Intro to Engineering").CourseID, InstructorID = instructors.Single(i => i.LastName == "Rague").ID }, }; foreach (CourseAssignment ci in courseInstructors) { context.CourseAssignment.Add(ci); } context.SaveChanges(); var enrollments = new Enrollment[] { new Enrollment { StudentID = students.Single(s => s.LastName == "Greenwood").ID, CourseID = courses.Single(c => c.Title == "Intro to Engineering").CourseID, Grade = GradeLetter.A }, new Enrollment { StudentID = students.Single(s => s.LastName == "Warnes").ID, CourseID = courses.Single(c => c.Title == "Operating Systems").CourseID, Grade = GradeLetter.C }, new Enrollment { StudentID = students.Single(s => s.LastName == "Lakey").ID, CourseID = courses.Single(c => c.Title == "The User Experience").CourseID, Grade = GradeLetter.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Lea").ID, CourseID = courses.Single(c => c.Title == "The User Experience").CourseID, Grade = GradeLetter.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Kim").ID, CourseID = courses.Single(c => c.Title == "Wireless Security").CourseID, Grade = GradeLetter.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Harston").ID, CourseID = courses.Single(c => c.Title == "Operating Systems").CourseID, Grade = GradeLetter.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Merrell").ID, CourseID = courses.Single(c => c.Title == "Independent Project").CourseID }, new Enrollment { StudentID = students.Single(s => s.LastName == "Lambert").ID, CourseID = courses.Single(c => c.Title == "JavaScript").CourseID, Grade = GradeLetter.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Haslam").ID, CourseID = courses.Single(c => c.Title == "Local Area Networks").CourseID, Grade = GradeLetter.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Lea").ID, CourseID = courses.Single(c => c.Title == "JavaScript").CourseID, Grade = GradeLetter.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Greenwood").ID, CourseID = courses.Single(c => c.Title == "Independent Project").CourseID, Grade = GradeLetter.B } }; foreach (Enrollment e in enrollments) { var enrollmentInDataBase = context.Enrollment.Where( s => s.Student.ID == e.StudentID && s.Course.CourseID == e.CourseID).SingleOrDefault(); if (enrollmentInDataBase == null) { context.Enrollment.Add(e); } } context.SaveChanges(); }
public static void Initialize(SchoolContext context) { context.Database.EnsureCreated(); if (context.Students.Any()) { return; } var students = new Student[] { new Student { FirstMidName = "Carson", LastName = "Alexander", EnrollmentDate = DateTime.Parse("2005-09-01") }, new Student { FirstMidName = "Meredith", LastName = "Alonso", EnrollmentDate = DateTime.Parse("2002-09-01") }, new Student { FirstMidName = "Arturo", LastName = "Anand", EnrollmentDate = DateTime.Parse("2003-09-01") }, new Student { FirstMidName = "Gytis", LastName = "Barzdukas", EnrollmentDate = DateTime.Parse("2002-09-01") }, new Student { FirstMidName = "Yan", LastName = "Li", EnrollmentDate = DateTime.Parse("2002-09-01") }, new Student { FirstMidName = "Peggy", LastName = "Justice", EnrollmentDate = DateTime.Parse("2001-09-01") }, new Student { FirstMidName = "Laura", LastName = "Norman", EnrollmentDate = DateTime.Parse("2003-09-01") }, new Student { FirstMidName = "Nino", LastName = "Olivetto", EnrollmentDate = DateTime.Parse("2005-09-01") } }; foreach (Student s in students) { context.Students.Add(s); } context.SaveChanges(); var instructors = new 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") } }; 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 }, new Course { CourseID = 4022, Title = "Microeconomics", Credits = 3 }, new Course { CourseID = 4041, Title = "Macroeconomics", Credits = 3 }, new Course { CourseID = 1045, Title = "Calculus", Credits = 4 }, new Course { CourseID = 3141, Title = "Trigonometry", Credits = 4 }, new Course { CourseID = 2021, Title = "Composition", Credits = 3 }, new Course { CourseID = 2042, Title = "Literature", Credits = 4 } }; 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" }, }; var courseInstrucotrs = 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 ca in courseInstrucotrs) { context.CourseAssignments.Add(ca); } context.SaveChanges(); var enrollments = new Enrollment[] { new Enrollment { StudentID = 1, CourseID = 1050, Grade = Grade.A }, new Enrollment { StudentID = 1, CourseID = 4022, Grade = Grade.C }, new Enrollment { StudentID = 1, CourseID = 4041, Grade = Grade.B }, new Enrollment { StudentID = 2, CourseID = 1045, Grade = Grade.B }, new Enrollment { StudentID = 2, CourseID = 3141, Grade = Grade.F }, new Enrollment { StudentID = 2, CourseID = 2021, Grade = Grade.F }, new Enrollment { StudentID = 3, CourseID = 1050 }, new Enrollment { StudentID = 4, CourseID = 1050 }, new Enrollment { StudentID = 4, CourseID = 4022, Grade = Grade.F }, new Enrollment { StudentID = 5, CourseID = 4041, Grade = Grade.C }, new Enrollment { StudentID = 6, CourseID = 1045 }, new Enrollment { StudentID = 7, CourseID = 3141, Grade = Grade.A }, }; foreach (Enrollment e in enrollments) { context.Enrollments.Add(e); } context.SaveChanges(); }
protected override void Seed(ExpensesAPI.Data.AppDbContext context) { // This method will be called after migrating to the latest version. // You can use the DbSet<T>.AddOrUpdate() helper extension method // to avoid creating duplicate seed data. context.Entries.Add( new Models.Entry() { Description = "test", IsExpense = false, Value = 3 }); var summerfields = new SummerField[] { new SummerField { Block = "Kim", Lot = "Abercrombie", StartDate = DateTime.Parse("1995-03-11") }, new SummerField { Block = "Fadi", Lot = "Fakhouri", StartDate = DateTime.Parse("2002-07-06") }, new SummerField { Block = "Roger", Lot = "Harui", StartDate = DateTime.Parse("1998-07-01") }, new SummerField { Block = "Candace", Lot = "Kapoor", StartDate = DateTime.Parse("2001-01-15") }, new SummerField { Block = "Roger", Lot = "Zheng", StartDate = DateTime.Parse("2004-02-12") } }; try { foreach (SummerField i in summerfields) { context.SummerField.Add(i); } context.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Value: \"{1}\", Error: \"{2}\"", ve.PropertyName, eve.Entry.CurrentValues.GetValue <object>(ve.PropertyName), ve.ErrorMessage); } } throw; } var officeAssignments = new OfficeAssignment[] { new OfficeAssignment { OfficeAssignmentId = summerfields.Single(i => i.Lot == "Abercrombie").Id, Location = "Abercrombie 17" }, new OfficeAssignment { OfficeAssignmentId = summerfields.Single(i => i.Lot == "Fakhouri").Id, Location = "Smith 17" }, new OfficeAssignment { OfficeAssignmentId = summerfields.Single(i => i.Lot == "Harui").Id, Location = "Gowan 27" }, new OfficeAssignment { OfficeAssignmentId = summerfields.Single(i => i.Lot == "Kapoor").Id, Location = "Thompson 304" }, new OfficeAssignment { OfficeAssignmentId = summerfields.Single(i => i.Lot == "Zheng").Id, Location = "Zheng House" } }; try { foreach (OfficeAssignment o in officeAssignments) { context.OfficeAssignments.Add(o); } context.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Value: \"{1}\", Error: \"{2}\"", ve.PropertyName, eve.Entry.CurrentValues.GetValue <object>(ve.PropertyName), ve.ErrorMessage); } } throw; } // var students = new Student[] { // new Student { Name = "MArian" }, // new Student { Name = "Jerome" }, //}; // foreach (Student ia in students) // { // context.Students.Add(ia); // } // context.SaveChanges(); }
public static void Initialize(SchoolContext context) { //================================================== STUDENTS ============================================// // Look for any students. if (context.Students.Any()) { return; // DB has been seeded } var students = new Student[] { new Student { FirstName = "Carson", LastName = "Alexander", Email = "*****@*****.**", EnrollmentDate = DateTime.Parse("2016-09-01"), Address = "4 Flanders Court", City = "Moncton", Province = "NB", PostalCode = "E1C 0K6" }, new Student { FirstName = "Meredith", LastName = "Alonso", Email = "*****@*****.**", EnrollmentDate = DateTime.Parse("2016-09-01"), Address = "25 Garden Hill Ave.", City = "Moncton", Province = "NB", PostalCode = "E1C 3E2" }, new Student { FirstName = "Arturo", LastName = "Anand", Email = "*****@*****.**", EnrollmentDate = DateTime.Parse("2016-09-01"), Address = "205 Argyle Street", City = "Moncton", Province = "NB", PostalCode = "E1C 8V2" }, new Student { FirstName = "Gytis", LastName = "Barzdukas", Email = "*****@*****.**", EnrollmentDate = DateTime.Parse("2016-09-01"), Address = "16-33 MacAleese Lane", City = "Moncton", Province = "NB", PostalCode = "E1H 3M1" }, new Student { FirstName = "Yan", LastName = "Li", Email = "*****@*****.**", EnrollmentDate = DateTime.Parse("2016-09-01"), Address = "88 Holland", City = "Moncton", Province = "NB", PostalCode = "E1G 0X1" }, new Student { FirstName = "Peggy", LastName = "Justice", Email = "*****@*****.**", EnrollmentDate = DateTime.Parse("2016-09-01"), Address = "49 Tanya Crescent", City = "Moncton", Province = "NB", PostalCode = "E1E 4V3" }, new Student { FirstName = "Laura", LastName = "Norman", Email = "*****@*****.**", EnrollmentDate = DateTime.Parse("2016-09-01"), Address = "42 Railway Avenue", City = "Moncton", Province = "NB", PostalCode = "E1C 2E1" }, new Student { FirstName = "Nino", LastName = "Olivetto", Email = "*****@*****.**", EnrollmentDate = DateTime.Parse("2016-09-01"), Address = "419 Evergreen Drive", City = "Moncton", Province = "NB", PostalCode = "E1G 5G7" } }; foreach (Student s in students) { context.Students.Add(s); } context.SaveChanges(); //================================================== INSTRUCTORS ============================================// var instructors = new Instructor[] { new Instructor { FirstName = "Marc", LastName = "Williams", HireDate = DateTime.Parse("1996-01-31"), Email = "*****@*****.**", Address = "819 Front Mountain Road", City = "Moncton", Province = "NB", PostalCode = "E1G 3H2" }, new Instructor { FirstName = "Frank", LastName = "Bekkering", HireDate = DateTime.Parse("1997-08-30"), Email = "*****@*****.**", Address = "22 Millstone Court", City = "Ammon", Province = "NB", PostalCode = "E1G 0W5" }, new Instructor { FirstName = "Kim", LastName = "Abercrombie", HireDate = DateTime.Parse("1995-03-11"), Email = "*****@*****.**", Address = "83 Birch Hill", City = "Ammon", Province = "NB", PostalCode = "E1G 4R2" }, new Instructor { FirstName = "Fadi", LastName = "Fakhouri", HireDate = DateTime.Parse("2002-07-06"), Email = "*****@*****.**", Address = "89 Thorncastle Street", City = "Moncton", Province = "NB", PostalCode = "E1G 0S6" }, new Instructor { FirstName = "Roger", LastName = "Harui", HireDate = DateTime.Parse("1998-07-01"), Email = "*****@*****.**", Address = "8 Silence Circle", City = "Moncton", Province = "NB", PostalCode = "E1A 0A3" }, new Instructor { FirstName = "Candace", LastName = "Kapoor", HireDate = DateTime.Parse("2001-01-15"), Email = "*****@*****.**", Address = "2392 Route 106", City = "Boundary Creek", Province = "NB", PostalCode = "E1G 4L6" }, new Instructor { FirstName = "Roger", LastName = "Zheng", HireDate = DateTime.Parse("2004-02-12"), Email = "*****@*****.**", Address = "4 Flanders Court", City = "Moncton", Province = "NB", PostalCode = "E1C 0K6" } }; foreach (Instructor i in instructors) { context.Instructors.Add(i); } context.SaveChanges(); //================================================== DEPARTMENTS ============================================// var departments = new Department[] { new Department { Name = "English", Budget = 350000, CreatedDate = DateTime.Parse("2017-09-01"), InstructorID = instructors.Single(i => i.LastName == "Abercrombie").ID }, new Department { Name = "Mathematics", Budget = 100000, CreatedDate = DateTime.Parse("2017-09-01"), InstructorID = instructors.Single(i => i.LastName == "Fakhouri").ID }, new Department { Name = "Engineering", Budget = 350000, CreatedDate = DateTime.Parse("2017-09-01"), InstructorID = instructors.Single(i => i.LastName == "Harui").ID }, new Department { Name = "Economics", Budget = 100000, CreatedDate = DateTime.Parse("2017-09-01"), InstructorID = instructors.Single(i => i.LastName == "Kapoor").ID } }; foreach (Department d in departments) { context.Departments.Add(d); } context.SaveChanges(); //================================================== COURSES ==============================================// 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(); //================================================== OFFICE ASSIGNMENTS ==============================================// 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(); //================================================== COURSE ASSIGNMENTS ==============================================// 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(); //================================================== ENROLLMENT ==============================================// 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(); }
public static void Initialize(FootballContext context) { context.Database.EnsureCreated(); // Look for any students. if (context.Players.Any()) { return; // DB has been seeded } var students = new Player[] { new Player { FirstMidName = "Carson", LastName = "Alexander", SigningDate = DateTime.Parse("2005-09-01") }, new Player { FirstMidName = "Meredith", LastName = "Alonso", SigningDate = DateTime.Parse("2002-09-01") }, new Player { FirstMidName = "Arturo", LastName = "Anand", SigningDate = DateTime.Parse("2003-09-01") }, new Player { FirstMidName = "Gytis", LastName = "Barzdukas", SigningDate = DateTime.Parse("2002-09-01") }, new Player { FirstMidName = "Yan", LastName = "Li", SigningDate = DateTime.Parse("2002-09-01") }, new Player { FirstMidName = "Peggy", LastName = "Justice", SigningDate = DateTime.Parse("2001-09-01") }, new Player { FirstMidName = "Laura", LastName = "Norman", SigningDate = DateTime.Parse("2003-09-01") }, new Player { FirstMidName = "Nino", LastName = "Olivetto", SigningDate = DateTime.Parse("2005-09-01") } }; foreach (Player s in students) { context.Players.Add(s); } context.SaveChanges(); var staffs = new Staff[] { new Staff { FirstMidName = "Kim", LastName = "Abercrombie", HireDate = DateTime.Parse("1995-03-11") }, new Staff { FirstMidName = "Fadi", LastName = "Fakhouri", HireDate = DateTime.Parse("2002-07-06") }, new Staff { FirstMidName = "Roger", LastName = "Harui", HireDate = DateTime.Parse("1998-07-01") }, new Staff { FirstMidName = "Candace", LastName = "Kapoor", HireDate = DateTime.Parse("2001-01-15") }, new Staff { FirstMidName = "Roger", LastName = "Zheng", HireDate = DateTime.Parse("2004-02-12") } }; foreach (Staff i in staffs) { context.Staffs.Add(i); } context.SaveChanges(); var departments = new Department[] { new Department { Name = "Grass Training Pitch", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), StaffID = staffs.Single(i => i.LastName == "Abercrombie").ID }, new Department { Name = "Artifical Grass Training Pitch", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), StaffID = staffs.Single(i => i.LastName == "Fakhouri").ID }, new Department { Name = "Gym", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), StaffID = staffs.Single(i => i.LastName == "Harui").ID }, new Department { Name = "Stadion", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), StaffID = staffs.Single(i => i.LastName == "Kapoor").ID }, new Department { Name = "Tactics Class", Budget = 200000, StartDate = DateTime.Parse("2009-07-12"), StaffID = staffs.Single(i => i.LastName == "Zheng").ID } }; foreach (Department d in departments) { context.Departments.Add(d); } context.SaveChanges(); var trainings = new Training[] { new Training { TrainingID = 1050, Title = "Field practice", Credits = 3, DepartmentID = departments.Single(s => s.Name == "Grass Training Pitch").DepartmentID }, new Training { TrainingID = 4022, Title = "Field practice", Credits = 3, DepartmentID = departments.Single(s => s.Name == "Artifical Grass Training Pitch").DepartmentID }, new Training { TrainingID = 4041, Title = "Gym", Credits = 3, DepartmentID = departments.Single(s => s.Name == "Gym").DepartmentID }, new Training { TrainingID = 1045, Title = "Stamina", Credits = 4, DepartmentID = departments.Single(s => s.Name == "Stadion").DepartmentID }, new Training { TrainingID = 3141, Title = "Sprints", Credits = 4, DepartmentID = departments.Single(s => s.Name == "Stadion").DepartmentID }, new Training { TrainingID = 2021, Title = "Tactics", Credits = 3, DepartmentID = departments.Single(s => s.Name == "Tactics Class").DepartmentID }, new Training { TrainingID = 2042, Title = "Gym", Credits = 4, DepartmentID = departments.Single(s => s.Name == "Gym").DepartmentID } }; foreach (Training c in trainings) { context.Trainings.Add(c); } context.SaveChanges(); var officeAssignments = new OfficeAssignment[] { new OfficeAssignment { StaffID = staffs.Single(i => i.LastName == "Fakhouri").ID, Location = "Smith 17" }, new OfficeAssignment { StaffID = staffs.Single(i => i.LastName == "Harui").ID, Location = "Gowan 27" }, new OfficeAssignment { StaffID = staffs.Single(i => i.LastName == "Kapoor").ID, Location = "Thompson 304" }, }; foreach (OfficeAssignment o in officeAssignments) { context.OfficeAssignments.Add(o); } context.SaveChanges(); var trainingStaffs = new TrainingAssignment[] { new TrainingAssignment { TrainingID = trainings.Single(c => c.Title == "Stamina" && c.DepartmentID == departments.Single(s => s.Name == "Stadion").DepartmentID).TrainingID, StaffID = staffs.Single(i => i.LastName == "Kapoor").ID }, new TrainingAssignment { TrainingID = trainings.Single(c => c.Title == "Gym" && c.DepartmentID == departments.Single(s => s.Name == "Gym").DepartmentID&& c.Credits == 3).TrainingID, StaffID = staffs.Single(i => i.LastName == "Harui").ID }, new TrainingAssignment { TrainingID = trainings.Single(c => c.Title == "Tactics" && c.DepartmentID == departments.Single(s => s.Name == "Tactics Class").DepartmentID).TrainingID, StaffID = staffs.Single(i => i.LastName == "Zheng").ID }, new TrainingAssignment { TrainingID = trainings.Single(c => c.Title == "Tactics" && c.DepartmentID == departments.Single(s => s.Name == "Tactics Class").DepartmentID).TrainingID, StaffID = staffs.Single(i => i.LastName == "Kapoor").ID }, new TrainingAssignment { TrainingID = trainings.Single(c => c.Title == "Field practice" && c.DepartmentID == departments.Single(s => s.Name == "Grass Training Pitch").DepartmentID).TrainingID, StaffID = staffs.Single(i => i.LastName == "Fakhouri").ID }, new TrainingAssignment { TrainingID = trainings.Single(c => c.Title == "Gym" && c.DepartmentID == departments.Single(s => s.Name == "Gym").DepartmentID&& c.Credits == 4).TrainingID, StaffID = staffs.Single(i => i.LastName == "Harui").ID }, new TrainingAssignment { TrainingID = trainings.Single(c => c.Title == "Field practice" && c.DepartmentID == departments.Single(s => s.Name == "Grass Training Pitch").DepartmentID).TrainingID, StaffID = staffs.Single(i => i.LastName == "Abercrombie").ID }, new TrainingAssignment { TrainingID = trainings.Single(c => c.Title == "Field practice" && c.DepartmentID == departments.Single(s => s.Name == "Artifical Grass Training Pitch").DepartmentID).TrainingID, StaffID = staffs.Single(i => i.LastName == "Abercrombie").ID } }; foreach (TrainingAssignment ci in trainingStaffs) { context.TrainingAssignments.Add(ci); } context.SaveChanges(); var signings = new Signing[] { new Signing { PlayerID = students.Single(s => s.LastName == "Alexander").ID, TrainingID = trainings.Single(c => c.Title == "Field practice" && c.DepartmentID == departments.Single(s => s.Name == "Grass Training Pitch").DepartmentID).TrainingID, Form = Form.A }, new Signing { PlayerID = students.Single(s => s.LastName == "Alexander").ID, TrainingID = trainings.Single(c => c.Title == "Tactics" && c.DepartmentID == departments.Single(s => s.Name == "Tactics Class").DepartmentID).TrainingID, Form = Form.C }, new Signing { PlayerID = students.Single(s => s.LastName == "Alexander").ID, TrainingID = trainings.Single(c => c.Title == "Field practice" && c.DepartmentID == departments.Single(s => s.Name == "Artifical Grass Training Pitch").DepartmentID).TrainingID, Form = Form.B }, new Signing { PlayerID = students.Single(s => s.LastName == "Alonso").ID, TrainingID = trainings.Single(c => c.Title == "Field practice" && c.DepartmentID == departments.Single(s => s.Name == "Grass Training Pitch").DepartmentID).TrainingID, Form = Form.B }, new Signing { PlayerID = students.Single(s => s.LastName == "Alonso").ID, TrainingID = trainings.Single(c => c.Title == "Tactics" && c.DepartmentID == departments.Single(s => s.Name == "Tactics Class").DepartmentID).TrainingID, Form = Form.B }, new Signing { PlayerID = students.Single(s => s.LastName == "Alonso").ID, TrainingID = trainings.Single(c => c.Title == "Gym" && c.DepartmentID == departments.Single(s => s.Name == "Gym").DepartmentID&& c.Credits == 4).TrainingID, Form = Form.B }, new Signing { PlayerID = students.Single(s => s.LastName == "Anand").ID, TrainingID = trainings.Single(c => c.Title == "Gym" && c.DepartmentID == departments.Single(s => s.Name == "Gym").DepartmentID&& c.Credits == 3).TrainingID }, new Signing { PlayerID = students.Single(s => s.LastName == "Anand").ID, TrainingID = trainings.Single(c => c.Title == "Field practice" && c.DepartmentID == departments.Single(s => s.Name == "Artifical Grass Training Pitch").DepartmentID).TrainingID, Form = Form.B }, new Signing { PlayerID = students.Single(s => s.LastName == "Barzdukas").ID, TrainingID = trainings.Single(c => c.Title == "Tactics" && c.DepartmentID == departments.Single(s => s.Name == "Tactics Class").DepartmentID).TrainingID, Form = Form.B }, new Signing { PlayerID = students.Single(s => s.LastName == "Li").ID, TrainingID = trainings.Single(c => c.Title == "Gym" && c.DepartmentID == departments.Single(s => s.Name == "Gym").DepartmentID&& c.Credits == 4).TrainingID, Form = Form.B }, new Signing { PlayerID = students.Single(s => s.LastName == "Justice").ID, TrainingID = trainings.Single(c => c.Title == "Gym" && c.DepartmentID == departments.Single(s => s.Name == "Gym").DepartmentID&& c.Credits == 3).TrainingID, Form = Form.B } }; foreach (Signing e in signings) { var signingInDataBase = context.Signings.Where( s => s.Player.ID == e.PlayerID && s.Training.TrainingID == e.TrainingID).SingleOrDefault(); if (signingInDataBase == null) { context.Signings.Add(e); } } context.SaveChanges(); }
public static void Initialize(SchoolContext context) { context.Database.EnsureCreated(); // Look For any students. if (context.Students.Any()) { return; // DB has been seeded } // adding data to students var students = new Student[] { new Student { FirstMidName = "Viqi", LastName = "Firdaus", EnrollmentDate = DateTime.Parse("2005-09-01") }, new Student { FirstMidName = "Fuad", LastName = "Abdullah", EnrollmentDate = DateTime.Parse("2002-09-01") }, new Student { FirstMidName = "Irfan", LastName = "Khoirul", EnrollmentDate = DateTime.Parse("2003-09-01") }, new Student { FirstMidName = "Samsul", LastName = "Maarif", EnrollmentDate = DateTime.Parse("2002-09-01") }, new Student { FirstMidName = "Rafi", LastName = "li", EnrollmentDate = DateTime.Parse("2002-09-01") }, new Student { FirstMidName = "Agung", LastName = "Imamu", EnrollmentDate = DateTime.Parse("2001-09-01") }, new Student { FirstMidName = "Dila", LastName = "Nur", EnrollmentDate = DateTime.Parse("2003-09-01") }, new Student { FirstMidName = "Rima", LastName = "Wanti", EnrollmentDate = DateTime.Parse("2005-09-01") } }; foreach (Student s in students) { context.Students.Add(s); } context.SaveChanges(); // adding data to instructors var instructors = new Instructor[] { new Instructor { FirstMidName = "Nana", LastName = "Ramadijanti", HireDate = DateTime.Parse("1995-03-11") }, new Instructor { FirstMidName = "Udin", LastName = "Harun", HireDate = DateTime.Parse("2002-07-06") }, new Instructor { FirstMidName = "Achmad", LastName = "Harui", HireDate = DateTime.Parse("1998-07-01") }, new Instructor { FirstMidName = "Muarifin", LastName = "Aja", HireDate = DateTime.Parse("2001-01-15") }, new Instructor { FirstMidName = "Achmad", LastName = "Basuki", HireDate = DateTime.Parse("2004-02-12") } }; foreach (Instructor i in instructors) { context.Instructors.Add(i); } context.SaveChanges(); // adding data to departemnts var departments = new Department[] { new Department { Name = "English", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Ramadijanti").ID }, new Department { Name = "Mathematics", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Harun").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 == "Aja").ID } }; foreach (Department d in departments) { context.Departments.Add(d); } context.SaveChanges(); // adding data to coursers 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(); // adding data to Enrollment var enrollments = new Enrollment[] { new Enrollment { StudentID = students.Single(s => s.LastName == "Firdaus").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, Grade = Grade.A }, new Enrollment { StudentID = students.Single(s => s.LastName == "Firdaus").ID, CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID, Grade = Grade.C }, new Enrollment { StudentID = students.Single(s => s.LastName == "Firdaus").ID, CourseID = courses.Single(c => c.Title == "Macroeconomics").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Abdullah").ID, CourseID = courses.Single(c => c.Title == "Calculus").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Abdullah").ID, CourseID = courses.Single(c => c.Title == "Trigonometry").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Abdullah").ID, CourseID = courses.Single(c => c.Title == "Composition").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Khoirul").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID }, new Enrollment { StudentID = students.Single(s => s.LastName == "Khoirul").ID, CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Maarif").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 == "Imamu").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(); //adding data to OfficeAssignment var officeAssignments = new OfficeAssignment[] { new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "Harun").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 == "Aja").ID, Location = "Thompson 304" }, }; foreach (OfficeAssignment o in officeAssignments) { context.OfficeAssignments.Add(o); } context.SaveChanges(); // adding data to CourseAssignment var courseInstructors = new CourseAssignment[] { new CourseAssignment { CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, InstructorID = instructors.Single(i => i.LastName == "Aja").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 == "Basuki").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Macroeconomics").CourseID, InstructorID = instructors.Single(i => i.LastName == "Basuki").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Calculus").CourseID, InstructorID = instructors.Single(i => i.LastName == "Harun").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 == "Ramadijanti").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "literature").CourseID, InstructorID = instructors.Single(i => i.LastName == "Ramadijanti").ID }, }; foreach (CourseAssignment ci in courseInstructors) { context.CourseAssignments.Add(ci); } context.SaveChanges(); }
public async Task PutOfficeAssignmentAsync(int id, OfficeAssignment assignment) { assignment.InstructorId = id; db.OfficeAssignment.Update(assignment); await db.SaveChangesAsync(); }
public void Handle(Delete.Command message) => OfficeAssignment = null;
public void InsertOfficeAssignment(OfficeAssignment officeAssignment) { officeAssignments.Add(officeAssignment); }
public static void Initialize(SchoolContext context) { context.Database.EnsureCreated(); // Look for any students. if (context.Students.Any()) { return; // DB has been seeded } var students = new Student[] { new Student { FirstMidName = "Haldja", LastName = "Tooming", EnrollmentDate = DateTime.Parse("2007-09-01") }, new Student { FirstMidName = "Leedu", LastName = "Antero", EnrollmentDate = DateTime.Parse("2006-09-01") }, new Student { FirstMidName = "Artur", LastName = "Anni", EnrollmentDate = DateTime.Parse("2006-09-01") }, new Student { FirstMidName = "Frode", LastName = "Ester", EnrollmentDate = DateTime.Parse("2007-09-01") }, new Student { FirstMidName = "Jan", LastName = "Parve", EnrollmentDate = DateTime.Parse("2005-09-01") }, new Student { FirstMidName = "Jaak", LastName = "Valge", EnrollmentDate = DateTime.Parse("2006-09-01") }, new Student { FirstMidName = "Laura", LastName = "Oja", EnrollmentDate = DateTime.Parse("2005-09-01") }, new Student { FirstMidName = "Brenda", LastName = "Jaup", EnrollmentDate = DateTime.Parse("2006-09-01") } }; foreach (Student s in students) { context.Students.Add(s); } context.SaveChanges(); var instructors = new Instructor[] { new Instructor { FirstMidName = "Sirje", LastName = "Tekko", HireDate = DateTime.Parse("1999-03-11") }, new Instructor { FirstMidName = "Merike", LastName = "Saar", HireDate = DateTime.Parse("2004-07-06") }, new Instructor { FirstMidName = "Kerli", LastName = "Jarve", HireDate = DateTime.Parse("1990-07-01") }, new Instructor { FirstMidName = "Anne", LastName = "Kuusmaa", HireDate = DateTime.Parse("2003-01-15") }, new Instructor { FirstMidName = "Bruno", LastName = "Nopponen", HireDate = DateTime.Parse("2004-03-12") } }; foreach (Instructor i in instructors) { context.Instructors.Add(i); } context.SaveChanges(); var departments = new Department[] { new Department { Name = "Languages", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Saar").ID }, new Department { Name = "Mathematics", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Kuusmaa").ID }, new Department { Name = "Sciences", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Tekko").ID }, new Department { Name = "Sports", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Nopponen").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 == "Sciences").DepartmentID }, new Course { CourseID = 4022, Title = "Biology", Credits = 3, DepartmentID = departments.Single(s => s.Name == "Sciences").DepartmentID }, new Course { CourseID = 4041, Title = "Swimming", Credits = 3, DepartmentID = departments.Single(s => s.Name == "Sports").DepartmentID }, new Course { CourseID = 1045, Title = "Athletics", Credits = 4, DepartmentID = departments.Single(s => s.Name == "Sports").DepartmentID }, new Course { CourseID = 3141, Title = "Math", Credits = 4, DepartmentID = departments.Single(s => s.Name == "Mathematics").DepartmentID }, new Course { CourseID = 2021, Title = "English", Credits = 3, DepartmentID = departments.Single(s => s.Name == "Languages").DepartmentID }, new Course { CourseID = 2042, Title = "Estonian", Credits = 4, DepartmentID = departments.Single(s => s.Name == "Languages").DepartmentID } }; foreach (Course c in courses) { context.Courses.Add(c); } context.SaveChanges(); var officeAssignments = new OfficeAssignment[] { new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "Tekko").ID, Location = "Sarapuu 17" }, new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "Jarve").ID, Location = "Pihlaka 27" }, new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "Kuusmaa").ID, Location = "Toomepuu 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 == "Tekko").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Biology").CourseID, InstructorID = instructors.Single(i => i.LastName == "Tekko").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Swimming").CourseID, InstructorID = instructors.Single(i => i.LastName == "Nopponen").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Estonian").CourseID, InstructorID = instructors.Single(i => i.LastName == "Saar").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "English").CourseID, InstructorID = instructors.Single(i => i.LastName == "Saar").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Math").CourseID, InstructorID = instructors.Single(i => i.LastName == "Kuusmaa").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Athletics").CourseID, InstructorID = instructors.Single(i => i.LastName == "Nopponen").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Athletics").CourseID, InstructorID = instructors.Single(i => i.LastName == "Jarve").ID }, }; foreach (CourseAssignment ci in courseInstructors) { context.CourseAssignments.Add(ci); } context.SaveChanges(); var enrollments = new Enrollment[] { new Enrollment { StudentID = students.Single(s => s.LastName == "Tooming").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Tooming").ID, CourseID = courses.Single(c => c.Title == "Swimming").CourseID, Grade = Grade.A }, new Enrollment { StudentID = students.Single(s => s.LastName == "Tooming").ID, CourseID = courses.Single(c => c.Title == "English").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Parve").ID, CourseID = courses.Single(c => c.Title == "Estonian").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Parve").ID, CourseID = courses.Single(c => c.Title == "Athletics").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Parve").ID, CourseID = courses.Single(c => c.Title == "Biology").CourseID, Grade = Grade.C }, new Enrollment { StudentID = students.Single(s => s.LastName == "Oja").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID }, new Enrollment { StudentID = students.Single(s => s.LastName == "Oja").ID, CourseID = courses.Single(c => c.Title == "Swimming").CourseID, Grade = Grade.A }, new Enrollment { StudentID = students.Single(s => s.LastName == "Jaup").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Valge").ID, CourseID = courses.Single(c => c.Title == "English").CourseID, Grade = Grade.C }, new Enrollment { StudentID = students.Single(s => s.LastName == "Valge").ID, CourseID = courses.Single(c => c.Title == "Estonian").CourseID, Grade = Grade.A } }; 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(); }
public void DeleteOfficeAssignment(OfficeAssignment officeAssignment) { officeAssignments.Remove(officeAssignment); }
public void InsertOfficeAssignment(OfficeAssignment officeAssignment) { context.OfficeAssignments.AddObject(officeAssignment); context.SaveChanges(); }
public void UpdateOfficeAssignment(OfficeAssignment officeAssignment, OfficeAssignment origOfficeAssignment) { officeAssignments.Remove(origOfficeAssignment); officeAssignments.Add(officeAssignment); }
public void UpdateOfficeAssignment(OfficeAssignment officeAssignment, OfficeAssignment origOfficeAssignment) { context.OfficeAssignments.Attach(origOfficeAssignment); context.ApplyCurrentValues("OfficeAssignments", officeAssignment); SaveChanges(); }
public static void Initialize(SchoolContext context) { // context.Database.EnsureCreated(); //this looks for any students if (context.Students.Any()) { return; } var students = new Student[] { new Student { FirstName = "Shuhratjan", LastName = "Nizamov", EnrollmentDate = DateTime.Parse("2005-09-01") }, new Student { FirstName = "Nurtileu", LastName = "Aliyas", EnrollmentDate = DateTime.Parse("2002-09-01") }, new Student { FirstName = "Moldir", LastName = "Kaliyas", EnrollmentDate = DateTime.Parse("2003-09-01") }, new Student { FirstName = "Nazym", LastName = "Soltumuratova", EnrollmentDate = DateTime.Parse("2002-09-01") }, new Student { FirstName = "Asanali", LastName = "Kereshov", EnrollmentDate = DateTime.Parse("2002-09-01") }, new Student { FirstName = "Muhamed", LastName = "Tolemis", EnrollmentDate = DateTime.Parse("2001-09-01") }, new Student { FirstName = "Saken", LastName = "Baymukhamed", EnrollmentDate = DateTime.Parse("2003-09-01") }, new Student { FirstName = "Asylzhan", LastName = "Erzhanov", EnrollmentDate = DateTime.Parse("2005-09-01") } }; foreach (Student student in students) { context.Students.Add(student); } context.SaveChanges(); var instructors = new Instructor[] { new Instructor { FirstMidName = "Almas", LastName = "Byrleskenovich", HireDate = DateTime.Parse("2018-03-11") }, new Instructor { FirstMidName = "Gulbanu", LastName = "Khasenova", HireDate = DateTime.Parse("2002-07-06") }, new Instructor { FirstMidName = "Aizhan", LastName = "Doskozhanova", HireDate = DateTime.Parse("1998-07-01") }, new Instructor { FirstMidName = "Ilyas", LastName = "Zhuanishev", HireDate = DateTime.Parse("2001-01-15") }, new Instructor { FirstMidName = "Azamat", LastName = "Tolegenov", 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 == "Doskozhanova").ID }, new Department { Name = "Mathematics", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Khasenova").ID }, new Department { Name = "Engineering", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Byrleskenovich").ID }, new Department { Name = "Economics", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Tolegenov").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 == "Byrleskenovich").ID, Location = "Almaty 17" }, new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "Khasenova").ID, Location = "Astana 27" }, new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "Tolegenov").ID, Location = "Shymkent 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 == "Tolegenov").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, InstructorID = instructors.Single(i => i.LastName == "Khasenova").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID, InstructorID = instructors.Single(i => i.LastName == "Byrleskenovich").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Macroeconomics").CourseID, InstructorID = instructors.Single(i => i.LastName == "Byrleskenovich").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Calculus").CourseID, InstructorID = instructors.Single(i => i.LastName == "Zhuanishev").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Trigonometry").CourseID, InstructorID = instructors.Single(i => i.LastName == "Khasenova").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Composition").CourseID, InstructorID = instructors.Single(i => i.LastName == "Doskozhanova").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Literature").CourseID, InstructorID = instructors.Single(i => i.LastName == "Doskozhanova").ID }, }; foreach (CourseAssignment ci in courseInstructors) { context.CourseAssignments.Add(ci); } context.SaveChanges(); var enrollments = new Enrollment[] { new Enrollment { StudentID = students.Single(s => s.LastName == "Nizamov").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, Grade = Grade.A }, new Enrollment { StudentID = students.Single(s => s.LastName == "Aliyas").ID, CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID, Grade = Grade.C }, new Enrollment { StudentID = students.Single(s => s.LastName == "Kaliyas").ID, CourseID = courses.Single(c => c.Title == "Macroeconomics").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Soltumuratova").ID, CourseID = courses.Single(c => c.Title == "Calculus").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Tolemis").ID, CourseID = courses.Single(c => c.Title == "Trigonometry").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Nizamov").ID, CourseID = courses.Single(c => c.Title == "Composition").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Aliyas").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID }, new Enrollment { StudentID = students.Single(s => s.LastName == "Kaliyas").ID, CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Soltumuratova").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Erzhanov").ID, CourseID = courses.Single(c => c.Title == "Composition").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Baymukhamed").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(); }
public static void Initialize(CollegeContext context) { //context.Database.EnsureCreated(); // Look for any students. if (context.Students.Any()) { return; // DB has been seeded } var students = new Student[] { new Student { FirstMidName = "Carson", LastName = "Alexander", EnrollmentDate = DateTime.Parse("2010-09-01"), DOB = DateTime.Parse("1995-09-18") }, new Student { FirstMidName = "Meredith", LastName = "Alonso", EnrollmentDate = DateTime.Parse("2012-09-01"), DOB = DateTime.Parse("1997-10-08") }, new Student { FirstMidName = "Arturo", LastName = "Anand", EnrollmentDate = DateTime.Parse("2013-09-01"), DOB = DateTime.Parse("1996-02-10") }, new Student { FirstMidName = "Gytis", LastName = "Barzdukas", EnrollmentDate = DateTime.Parse("2012-09-01"), DOB = DateTime.Parse("1995-07-01") }, new Student { FirstMidName = "Yan", LastName = "Li", EnrollmentDate = DateTime.Parse("2012-09-01"), DOB = DateTime.Parse("1995-03-30") }, new Student { FirstMidName = "Peggy", LastName = "Justice", EnrollmentDate = DateTime.Parse("2011-09-01"), DOB = DateTime.Parse("1994-06-26") }, new Student { FirstMidName = "Laura", LastName = "Norman", EnrollmentDate = DateTime.Parse("2013-09-01"), DOB = DateTime.Parse("1995-03-14") }, new Student { FirstMidName = "Nino", LastName = "Olivetto", EnrollmentDate = DateTime.Parse("2005-09-01"), DOB = DateTime.Parse("1997-05-10") } }; foreach (Student s in students) { context.Students.Add(s); } context.SaveChanges(); var instructors = new Lecturer[] { new Lecturer { FirstMidName = "Kim", LastName = "Ridge", HireDate = DateTime.Parse("1995-03-11"), EmailAddress = "*****@*****.**" }, new Lecturer { FirstMidName = "Fadi", LastName = "Fally", HireDate = DateTime.Parse("2002-07-06"), EmailAddress = "*****@*****.**" }, new Lecturer { FirstMidName = "Roger", LastName = "Harui", HireDate = DateTime.Parse("1998-07-01"), EmailAddress = "*****@*****.**" }, new Lecturer { FirstMidName = "Candace", LastName = "Kapoor", HireDate = DateTime.Parse("2001-01-15"), EmailAddress = "*****@*****.**" }, new Lecturer { FirstMidName = "Roger", LastName = "Zheng", HireDate = DateTime.Parse("2004-02-12"), EmailAddress = "*****@*****.**" } }; /* * if (context.Lecturers.Any()) * { * return; // DB has been seeded * } */ foreach (Lecturer i in instructors) { context.Lecturers.Add(i); } context.SaveChanges(); if (context.Departments.Any()) { return; // DB has been seeded } var departments = new Department[] { new Department { Name = "English", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), LecturerID = instructors.Single(i => i.LastName == "Abercrombie").ID }, new Department { Name = "Mathematics", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), LecturerID = instructors.Single(i => i.LastName == "Fakhouri").ID }, new Department { Name = "Engineering", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), LecturerID = instructors.Single(i => i.LastName == "Harui").ID }, new Department { Name = "Economics", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), LecturerID = instructors.Single(i => i.LastName == "Kapoor").ID } }; foreach (Department d in departments) { context.Departments.Add(d); } context.SaveChanges(); // if (context.Courses.Any()) //{ // return; // DB has been seeded //} 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(); //if (context.OfficeAssignments.Any()) //{ // return; // DB has been seeded //} var officeAssignments = new OfficeAssignment[] { new OfficeAssignment { LecturerID = instructors.Single(i => i.LastName == "Fakhouri").ID, Location = "Smith 17" }, new OfficeAssignment { LecturerID = instructors.Single(i => i.LastName == "Harui").ID, Location = "Gowan 27" }, new OfficeAssignment { LecturerID = instructors.Single(i => i.LastName == "Kapoor").ID, Location = "Thompson 304" }, }; foreach (OfficeAssignment o in officeAssignments) { context.OfficeAssignments.Add(o); } context.SaveChanges(); if (context.CourseAssignments.Any()) { return; // DB has been seeded } var courseInstructors = new CourseAssignment[] { new CourseAssignment { CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, LecturerID = instructors.Single(i => i.LastName == "Kapoor").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, LecturerID = instructors.Single(i => i.LastName == "Harui").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID, LecturerID = instructors.Single(i => i.LastName == "Zheng").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Macroeconomics").CourseID, LecturerID = instructors.Single(i => i.LastName == "Zheng").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Calculus").CourseID, LecturerID = instructors.Single(i => i.LastName == "Fakhouri").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Trigonometry").CourseID, LecturerID = instructors.Single(i => i.LastName == "Harui").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Composition").CourseID, LecturerID = instructors.Single(i => i.LastName == "Abercrombie").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Literature").CourseID, LecturerID = instructors.Single(i => i.LastName == "Abercrombie").ID }, }; foreach (CourseAssignment ci in courseInstructors) { context.CourseAssignments.Add(ci); } context.SaveChanges(); // if (context.Enrollments.Any()) //{ // return; // DB has been seeded //} 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(); }
public ActionResult <OfficeAssignment> PostOfficeAssignment(OfficeAssignment model) { db.OfficeAssignment.Add(model); db.SaveChanges(); return(Created("/api/OfficeAssignment/" + model.InstructorId, model)); }
public static void Initialize(SchoolContext context) { context.Database.EnsureCreated(); // Look for any students. if (context.Students.Any()) { return; // DB has been seeded } var students = new Student[] { new Student { FirstMidName = "Joe", LastName = "Banana", EnrollmentDate = DateTime.Parse("2010-01-01") }, new Student { FirstMidName = "Sofia", LastName = "Berlin", EnrollmentDate = DateTime.Parse("2012-01-01") }, new Student { FirstMidName = "Silistra", LastName = "Busters", EnrollmentDate = DateTime.Parse("2013-01-01") }, new Student { FirstMidName = "Ivan", LastName = "B.", EnrollmentDate = DateTime.Parse("2012-01-01") }, new Student { FirstMidName = "Mina", LastName = "Batman", EnrollmentDate = DateTime.Parse("2011-01-01") }, new Student { FirstMidName = "Pesho", LastName = "Zorro", EnrollmentDate = DateTime.Parse("2013-01-01") }, new Student { FirstMidName = "Hristomir", LastName = "Hristov", EnrollmentDate = DateTime.Parse("2005-01-01") } }; foreach (Student s in students) { context.Students.Add(s); } context.SaveChanges(); var instructors = new Instructor[] { new Instructor { FirstMidName = "Krachun", LastName = "Malchov", HireDate = DateTime.Parse("1995-03-11") }, new Instructor { FirstMidName = "Safadi", LastName = "Yordanov", HireDate = DateTime.Parse("2002-07-06") }, new Instructor { FirstMidName = "Hristo", LastName = "Stoichkov", HireDate = DateTime.Parse("1998-07-01") }, new Instructor { FirstMidName = "Yordan", LastName = "Lechkov", HireDate = DateTime.Parse("2001-01-15") }, new Instructor { FirstMidName = "Hristo", LastName = "Zhabov", HireDate = DateTime.Parse("2004-02-12") } }; foreach (Instructor i in instructors) { context.Instructors.Add(i); } context.SaveChanges(); var departments = new Department[] { new Department { Name = "Advanced Design", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), InstructorId = instructors.Single(i => i.LastName == "Malchov").Id }, new Department { Name = "Design", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), InstructorId = instructors.Single(i => i.LastName == "Yordanov").Id }, new Department { Name = "Advanced Structures", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), InstructorId = instructors.Single(i => i.LastName == "Stoichkov").Id }, new Department { Name = "Advanced Programming", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), InstructorId = instructors.Single(i => i.LastName == "Lechkov").Id } }; foreach (Department d in departments) { context.Departments.Add(d); } context.SaveChanges(); var courses = new Course[] { new Course { CourseId = 1050, Title = "General Programming", Credits = 3, DepartmentId = departments.Single(s => s.Name == "Advanced Structures").DepartmentId }, new Course { CourseId = 4022, Title = "Programming 101", Credits = 3, DepartmentId = departments.Single(s => s.Name == "Advanced Programming").DepartmentId }, new Course { CourseId = 4041, Title = "Programming 201", Credits = 3, DepartmentId = departments.Single(s => s.Name == "Advanced Programming").DepartmentId }, new Course { CourseId = 1045, Title = "Algorithms", Credits = 4, DepartmentId = departments.Single(s => s.Name == "Design").DepartmentId }, new Course { CourseId = 3141, Title = "Front End", Credits = 4, DepartmentId = departments.Single(s => s.Name == "Design").DepartmentId }, new Course { CourseId = 2021, Title = "Back End", Credits = 3, DepartmentId = departments.Single(s => s.Name == "Advanced Design").DepartmentId }, new Course { CourseId = 2042, Title = "CSS", Credits = 4, DepartmentId = departments.Single(s => s.Name == "Advanced Design").DepartmentId }, }; foreach (Course c in courses) { context.Courses.Add(c); } context.SaveChanges(); var officeAssignments = new OfficeAssignment[] { new OfficeAssignment { InstructorId = instructors.Single(i => i.LastName == "Yordanov").Id, Location = "Nuremberg" }, new OfficeAssignment { InstructorId = instructors.Single(i => i.LastName == "Stoichkov").Id, Location = "Sofia" }, new OfficeAssignment { InstructorId = instructors.Single(i => i.LastName == "Lechkov").Id, Location = "Silistra" }, }; foreach (OfficeAssignment o in officeAssignments) { context.OfficeAssignments.Add(o); } context.SaveChanges(); var courseInstructors = new CourseAssignment[] { new CourseAssignment { CourseId = courses.Single(c => c.Title == "General Programming").CourseId, InstructorId = instructors.Single(i => i.LastName == "Lechkov").Id }, new CourseAssignment { CourseId = courses.Single(c => c.Title == "General Programming").CourseId, InstructorId = instructors.Single(i => i.LastName == "Stoichkov").Id }, new CourseAssignment { CourseId = courses.Single(c => c.Title == "Programming 101").CourseId, InstructorId = instructors.Single(i => i.LastName == "Zhabov").Id }, new CourseAssignment { CourseId = courses.Single(c => c.Title == "Programming 201").CourseId, InstructorId = instructors.Single(i => i.LastName == "Zhabov").Id }, new CourseAssignment { CourseId = courses.Single(c => c.Title == "Algorithms").CourseId, InstructorId = instructors.Single(i => i.LastName == "Yordanov").Id }, new CourseAssignment { CourseId = courses.Single(c => c.Title == "Front End").CourseId, InstructorId = instructors.Single(i => i.LastName == "Stoichkov").Id }, new CourseAssignment { CourseId = courses.Single(c => c.Title == "Back End").CourseId, InstructorId = instructors.Single(i => i.LastName == "Malchov").Id }, new CourseAssignment { CourseId = courses.Single(c => c.Title == "CSS").CourseId, InstructorId = instructors.Single(i => i.LastName == "Malchov").Id }, }; foreach (CourseAssignment ci in courseInstructors) { context.CourseAssignments.Add(ci); } context.SaveChanges(); var enrollments = new Enrollment[] { new Enrollment { StudentId = students.Single(s => s.LastName == "Banana").Id, CourseId = courses.Single(c => c.Title == "General Programming").CourseId, Grade = Grade.A }, new Enrollment { StudentId = students.Single(s => s.LastName == "Banana").Id, CourseId = courses.Single(c => c.Title == "Programming 101").CourseId, Grade = Grade.C }, new Enrollment { StudentId = students.Single(s => s.LastName == "Banana").Id, CourseId = courses.Single(c => c.Title == "Programming 201").CourseId, Grade = Grade.B }, new Enrollment { StudentId = students.Single(s => s.LastName == "Berlin").Id, CourseId = courses.Single(c => c.Title == "Algorithms").CourseId, Grade = Grade.B }, new Enrollment { StudentId = students.Single(s => s.LastName == "Berlin").Id, CourseId = courses.Single(c => c.Title == "Front End").CourseId, Grade = Grade.B }, new Enrollment { StudentId = students.Single(s => s.LastName == "Berlin").Id, CourseId = courses.Single(c => c.Title == "Back End").CourseId, Grade = Grade.B }, new Enrollment { StudentId = students.Single(s => s.LastName == "Busters").Id, CourseId = courses.Single(c => c.Title == "General Programming").CourseId }, new Enrollment { StudentId = students.Single(s => s.LastName == "Busters").Id, CourseId = courses.Single(c => c.Title == "Programming 101").CourseId, Grade = Grade.B }, new Enrollment { StudentId = students.Single(s => s.LastName == "B.").Id, CourseId = courses.Single(c => c.Title == "General Programming").CourseId, Grade = Grade.B }, new Enrollment { StudentId = students.Single(s => s.LastName == "Batman").Id, CourseId = courses.Single(c => c.Title == "CSS").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(); }
public static void Initialize(SchoolContext context) { context.Database.EnsureCreated(); // Look for any students. if (context.Students.Any()) { return; // DB has been seeded } // sample data for Student var students = new Student[] { new Student { FirstName = "Carson", LastName = "Alexander", EmailAddress = "*****@*****.**", YearRank = "Junior", AverageGrade = 3.4f, EnrollmentDate = DateTime.Parse("2005-09-01") }, new Student { FirstName = "Meredith", LastName = "Alonso", EmailAddress = "*****@*****.**", YearRank = "Junior", AverageGrade = 2.9f, EnrollmentDate = DateTime.Parse("2002-09-01") }, new Student { FirstName = "Arturo", LastName = "Anand", EmailAddress = "*****@*****.**", YearRank = "Sophomore", AverageGrade = 3.9f, EnrollmentDate = DateTime.Parse("2003-09-01") }, new Student { FirstName = "Gytis", LastName = "Barzdukas", EmailAddress = "*****@*****.**", YearRank = "Freshmen", AverageGrade = 3.5f, EnrollmentDate = DateTime.Parse("2002-09-01") }, new Student { FirstName = "Yan", LastName = "Li", EmailAddress = "*****@*****.**", YearRank = "Senior", AverageGrade = 2.3f, EnrollmentDate = DateTime.Parse("2002-09-01") }, new Student { FirstName = "Peggy", LastName = "Justice", EmailAddress = "*****@*****.**", YearRank = "Junior", AverageGrade = 3.2f, EnrollmentDate = DateTime.Parse("2001-09-01") }, new Student { FirstName = "Laura", LastName = "Norman", EmailAddress = "*****@*****.**", YearRank = "Freshmen", AverageGrade = 3.1f, EnrollmentDate = DateTime.Parse("2003-09-01") }, new Student { FirstName = "Nino", LastName = "Olivetto", EmailAddress = "*****@*****.**", YearRank = "Senior", AverageGrade = 4.0f, EnrollmentDate = DateTime.Parse("2005-09-01") } }; foreach (Student s in students) { context.Students.Add(s); } context.SaveChanges(); // sample data for Instructor 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") }, new Instructor { FirstName = "John", LastName = "David", HireDate = DateTime.Parse("2004-03-10") } }; foreach (Instructor i in instructors) { context.Instructors.Add(i); } context.SaveChanges(); // sample data for Department 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 }, new Department { Name = "Information Technology", Budget = 200000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "David").ID } }; foreach (Department d in departments) { context.Departments.Add(d); } context.SaveChanges(); // sample data for Course var courses = new Course[] { new Course { CourseID = 1050, Title = "Chemistry", Credits = 3, RoomNum = "BHS 409", DepartmentID = departments.Single(s => s.Name == "Engineering").DepartmentID }, new Course { CourseID = 4022, Title = "Microeconomics", Credits = 3, RoomNum = "CP 503", DepartmentID = departments.Single(s => s.Name == "Economics").DepartmentID }, new Course { CourseID = 4041, Title = "Macroeconomics", Credits = 3, RoomNum = "WG 689", DepartmentID = departments.Single(s => s.Name == "Economics").DepartmentID }, new Course { CourseID = 1045, Title = "Calculus", Credits = 4, RoomNum = "GWP 110", DepartmentID = departments.Single(s => s.Name == "Mathematics").DepartmentID }, new Course { CourseID = 3141, Title = "Trigonometry", Credits = 4, RoomNum = "MAT 941", DepartmentID = departments.Single(s => s.Name == "Mathematics").DepartmentID }, new Course { CourseID = 2021, Title = "Composition", Credits = 3, RoomNum = "WCG 001", DepartmentID = departments.Single(s => s.Name == "English").DepartmentID }, new Course { CourseID = 2042, Title = "Literature", Credits = 4, RoomNum = "BB 276", DepartmentID = departments.Single(s => s.Name == "English").DepartmentID }, new Course { CourseID = 2078, Title = "ASP.NET MVC Web App", Credits = 4, RoomNum = "BB 276", DepartmentID = departments.Single(s => s.Name == "English").DepartmentID } }; foreach (Course c in courses) { context.Courses.Add(c); } context.SaveChanges(); // sample data for Enrollment 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 }, new Enrollment { StudentID = students.Single(s => s.LastName == "Olivetto").ID, CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID, Grade = Grade.A } }; 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(); // sample data for Office Assignment 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" }, new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "David").ID, Location = "MAT 304" }, }; foreach (OfficeAssignment o in officeAssignments) { context.OfficeAssignments.Add(o); } context.SaveChanges(); // sample data for Course Assignment 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(); }
public static void Initialize(SchoolContext context) { //context.Database.EnsureCreated(); // Look for any students. if (context.Students.Any()) { return; // DB has been seeded } var students = new 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") } }; context.Students.AddRange(students); context.SaveChanges(); var instructors = new 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") } }; context.Instructors.AddRange(instructors); 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 } }; context.Departments.AddRange(departments); 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" }, }; context.OfficeAssignments.AddRange(officeAssignments); 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 }, }; context.CourseAssignments.AddRange(courseInstructors); 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(); }
public static void Initialize(SchoolContext context) { // Look for any students if (context.Students.Any()) { Console.WriteLine("Found one"); // DB has data or has been seeded return; } Console.WriteLine("None found"); // students var studentPM = new Student { FirstMidName = "Peter", LastName = "Mayaga", EnrollmentDate = DateTime.Parse("2015-05-03") }; var studentJK = new Student { FirstMidName = "John", LastName = "Kampulunguse", EnrollmentDate = DateTime.Parse("2018-12-30") }; var studentWS = new Student { FirstMidName = "Were", LastName = "Simon", EnrollmentDate = DateTime.Parse("2020-10-21") }; var studentCJ = new Student { FirstMidName = "Collins", LastName = "Jackson", EnrollmentDate = DateTime.Parse("2009-01-02") }; var studentMS = new Student { FirstMidName = "Matthew", LastName = "Sekitoleko", EnrollmentDate = DateTime.Parse("2021-3-23") }; // instructors var instructor1 = new Instructor { FirstMidName = "John", LastName = "Ung", HireDate = DateTime.Parse("2001-04-14") }; var instructor2 = new Instructor { FirstMidName = "Kabenge", LastName = "Moses", HireDate = DateTime.Parse("2005-01-29") }; var instructor3 = new Instructor { FirstMidName = "Ssenoga", LastName = "Abram", HireDate = DateTime.Parse("2001-11-02") }; var instructor4 = new Instructor { FirstMidName = "Wandegeya", LastName = "Kulekana", HireDate = DateTime.Parse("2015-10-30") }; // OfficeAssignments var officeAssignments = new OfficeAssignment[] { new OfficeAssignment { Instructor = instructor1, Location = "LLT-1A" }, new OfficeAssignment { Instructor = instructor3, Location = "LLT-2B" }, new OfficeAssignment { Instructor = instructor4, Location = "Big lab A" } }; context.AddRange(officeAssignments); // departments var english = new Department { Name = "English", Budget = 300000, StartDate = DateTime.Parse("1990-02-15"), Administrator = instructor1 }; var mathematics = new Department { Name = "Mathematics", Budget = 250000, StartDate = DateTime.Parse("1960-10-25"), Administrator = instructor2 }; var cs = new Department { Name = "Computer Science", Budget = 500000, StartDate = DateTime.Parse("1990-09-22"), Administrator = instructor3 }; // courses var chemistry = new Course { CourseID = 1050, Title = "Chemistry", Credits = 3, Department = mathematics, Instructors = new List <Instructor> { instructor1, instructor2 } }; var SE = new Course { CourseID = 5060, Title = "Software Engineering", Credits = 4, Department = cs, Instructors = new List <Instructor> { instructor2, instructor3 } }; var discreteMaths = new Course { CourseID = 5090, Title = "Discrete Mathematics", Credits = 5, Department = cs, Instructors = new List <Instructor> { instructor2, instructor3, instructor4 } }; // Enrollments var enrollments = new Enrollment[] { new Enrollment { Student = studentCJ, Course = chemistry, Grade = Grade.D }, new Enrollment { Student = studentJK, Course = discreteMaths }, new Enrollment { Student = studentPM, Course = SE, Grade = Grade.A }, new Enrollment { Student = studentJK, Course = SE, Grade = Grade.B }, new Enrollment { Student = studentMS, Course = chemistry } // studentWS not used }; context.AddRange(enrollments); // Save changes context.SaveChanges(); }
/// <summary> /// Create a new OfficeAssignment object. /// </summary> /// <param name="instructorID">Initial value of InstructorID.</param> /// <param name="location">Initial value of Location.</param> /// <param name="timestamp">Initial value of Timestamp.</param> public static OfficeAssignment CreateOfficeAssignment(int instructorID, string location, byte[] timestamp) { OfficeAssignment officeAssignment = new OfficeAssignment(); officeAssignment.InstructorID = instructorID; officeAssignment.Location = location; officeAssignment.Timestamp = timestamp; return officeAssignment; }
public static void Initialize(SchoolContext context) { context.Database.EnsureCreated(); if (context.students.Any()) { return; } var students = new Student[] { new Student { firstName = "Carson", lastName = "Alexander", dateEnrollment = DateTime.Parse("2005-09-01") }, new Student { firstName = "Meredith", lastName = "Alonso", dateEnrollment = DateTime.Parse("2002-09-01") }, new Student { firstName = "Arturo", lastName = "Anand", dateEnrollment = DateTime.Parse("2003-09-01") }, new Student { firstName = "Gytis", lastName = "Barzdukas", dateEnrollment = DateTime.Parse("2002-09-01") }, new Student { firstName = "Yan", lastName = "Li", dateEnrollment = DateTime.Parse("2002-09-01") }, new Student { firstName = "Peggy", lastName = "Justice", dateEnrollment = DateTime.Parse("2001-09-01") }, new Student { firstName = "Laura", lastName = "Norman", dateEnrollment = DateTime.Parse("2003-09-01") }, new Student { firstName = "Nino", lastName = "Olivetto", dateEnrollment = 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 { departName = "English", budget = 350000, departStartDate = DateTime.Parse("2007-09-01"), instructorId = instructors.Single(i => i.lastName == "Abercrombie").id }, new Department { departName = "Mathematics", budget = 100000, departStartDate = DateTime.Parse("2007-09-01"), instructorId = instructors.Single(i => i.lastName == "Fakhouri").id }, new Department { departName = "Engineering", budget = 350000, departStartDate = DateTime.Parse("2007-09-01"), instructorId = instructors.Single(i => i.lastName == "Harui").id }, new Department { departName = "Economics", budget = 100000, departStartDate = 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, courseTitle = "Chemistry", credit = 3, departmentId = departments.Single(s => s.departName == "Engineering").departmentId }, new Course { courseId = 4022, courseTitle = "Microeconomics", credit = 3, departmentId = departments.Single(s => s.departName == "Economics").departmentId }, new Course { courseId = 4041, courseTitle = "Macroeconomics", credit = 3, departmentId = departments.Single(s => s.departName == "Economics").departmentId }, new Course { courseId = 1045, courseTitle = "Calculus", credit = 4, departmentId = departments.Single(s => s.departName == "Mathematics").departmentId }, new Course { courseId = 3141, courseTitle = "Trigonometry", credit = 4, departmentId = departments.Single(s => s.departName == "Mathematics").departmentId }, new Course { courseId = 2021, courseTitle = "Composition", credit = 3, departmentId = departments.Single(s => s.departName == "English").departmentId }, new Course { courseId = 2042, courseTitle = "Literature", credit = 4, departmentId = departments.Single(s => s.departName == "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.courseTitle == "Chemistry").courseId, instructorId = instructors.Single(i => i.lastName == "Kapoor").id }, new CourseAssignment { courseId = courses.Single(c => c.courseTitle == "Chemistry").courseId, instructorId = instructors.Single(i => i.lastName == "Harui").id }, new CourseAssignment { courseId = courses.Single(c => c.courseTitle == "Microeconomics").courseId, instructorId = instructors.Single(i => i.lastName == "Zheng").id }, new CourseAssignment { courseId = courses.Single(c => c.courseTitle == "Macroeconomics").courseId, instructorId = instructors.Single(i => i.lastName == "Zheng").id }, new CourseAssignment { courseId = courses.Single(c => c.courseTitle == "Calculus").courseId, instructorId = instructors.Single(i => i.lastName == "Fakhouri").id }, new CourseAssignment { courseId = courses.Single(c => c.courseTitle == "Trigonometry").courseId, instructorId = instructors.Single(i => i.lastName == "Harui").id }, new CourseAssignment { courseId = courses.Single(c => c.courseTitle == "Composition").courseId, instructorId = instructors.Single(i => i.lastName == "Abercrombie").id }, new CourseAssignment { courseId = courses.Single(c => c.courseTitle == "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.courseTitle == "Chemistry").courseId, grade = Enrollment.Grade.A }, new Enrollment { studentId = students.Single(s => s.lastName == "Alexander").id, courseId = courses.Single(c => c.courseTitle == "Microeconomics").courseId, grade = Enrollment.Grade.C }, new Enrollment { studentId = students.Single(s => s.lastName == "Alexander").id, courseId = courses.Single(c => c.courseTitle == "Macroeconomics").courseId, grade = Enrollment.Grade.B }, new Enrollment { studentId = students.Single(s => s.lastName == "Alonso").id, courseId = courses.Single(c => c.courseTitle == "Calculus").courseId, grade = Enrollment.Grade.B }, new Enrollment { studentId = students.Single(s => s.lastName == "Alonso").id, courseId = courses.Single(c => c.courseTitle == "Trigonometry").courseId, grade = Enrollment.Grade.B }, new Enrollment { studentId = students.Single(s => s.lastName == "Alonso").id, courseId = courses.Single(c => c.courseTitle == "Composition").courseId, grade = Enrollment.Grade.B }, new Enrollment { studentId = students.Single(s => s.lastName == "Anand").id, courseId = courses.Single(c => c.courseTitle == "Chemistry").courseId, grade = Enrollment.Grade.D }, new Enrollment { studentId = students.Single(s => s.lastName == "Anand").id, courseId = courses.Single(c => c.courseTitle == "Microeconomics").courseId, grade = Enrollment.Grade.D }, new Enrollment { studentId = students.Single(s => s.lastName == "Barzdukas").id, courseId = courses.Single(c => c.courseTitle == "Chemistry").courseId, grade = Enrollment.Grade.B }, new Enrollment { studentId = students.Single(s => s.lastName == "Li").id, courseId = courses.Single(c => c.courseTitle == "Composition").courseId, grade = Enrollment.Grade.F }, new Enrollment { studentId = students.Single(s => s.lastName == "Justice").id, courseId = courses.Single(c => c.courseTitle == "Literature").courseId, grade = Enrollment.Grade.B } }; foreach (Enrollment e in enrollments) { var enrollmentDb = context.enrollments.Where( s => s.student.id == e.studentId && s.course.courseId == e.courseId ).SingleOrDefault(); if (enrollmentDb == null) { context.enrollments.Add(e); } } context.SaveChanges(); } //End of class