public static void Initialize(IServiceProvider serviceProvider) { using (var context = new UniversityContext( serviceProvider.GetRequiredService < DbContextOptions <UniversityContext> >())) { if (context.Student.Any() || context.Teacher.Any() || context.Course.Any()) { return; // DB has been seeded } context.Teacher.AddRange( new Teacher { /*Id=1, */ FirstName = "Pero", LastName = "Latkoski", Degree = "PhD", AcademicRank = "Professor" }, new Teacher { /*Id=2, */ FirstName = "Daniel", LastName = "Denkovski", Degree = "PhD", AcademicRank = "Asst. Prof" }, new Teacher { /*Id=3, */ FirstName = "Danijela", LastName = "Efnusheva", Degree = "PhD", AcademicRank = "Professor" }, new Teacher { /*Id=4, */ FirstName = "Ana", LastName = "Colakoska", Degree = "MSc", AcademicRank = "Assistant" }, new Teacher { /*Id=5, */ FirstName = "Marija", LastName = "Kalendar", Degree = "PhD", AcademicRank = "Professor" }, new Teacher { /*Id=6, */ FirstName = "Emilija", LastName = "Kizevska", Degree = "MSc", AcademicRank = "Assistant" } ); context.SaveChanges(); context.Student.AddRange( new Student { /*Id=3, */ StudentId = "193/2017", FirstName = "Martina", LastName = "Markovska", EnrollmentDate = DateTime.Parse("2017-09-15"), AcquiredCredits = 195, CurrentSemester = 8, EducationLevel = "Student" }, new Student { /*Id=2, */ StudentId = "184/2017", FirstName = "Elena", LastName = "Indovska", EnrollmentDate = DateTime.Parse("2017-09-15"), AcquiredCredits = 162, CurrentSemester = 8, EducationLevel = "Student" }, new Student { /*Id=1, */ StudentId = "171/2017", FirstName = "Darko", LastName = "Angelovski", EnrollmentDate = DateTime.Parse("2017-09-15"), AcquiredCredits = 50, CurrentSemester = 4, EducationLevel = "Student" } ); context.SaveChanges(); context.Course.AddRange( new Course { /*Id=3, */ Title = "Razvoj na serverski WEB aplikacii", Credits = 6, Semester = 6, Programme = "KTI/ TKII", EducationLevel = "Undergraduate", FirstTeacherId = context.Teacher.Single(t => t.FirstName == "Pero" && t.LastName == "Latkoski").Id, SecondTeacherId = context.Teacher.Single(t => t.FirstName == "Daniel" && t.LastName == "Denkovski").Id }, new Course { /*Id=2, */ Title = "Mrezni standardi i uredi", Credits = 6, Semester = 7, Programme = "KTI", EducationLevel = "Undergraduate", FirstTeacherId = context.Teacher.Single(t => t.FirstName == "Danijela" && t.LastName == "Efnusheva").Id, SecondTeacherId = context.Teacher.Single(t => t.FirstName == "Ana" && t.LastName == "Colakoska").Id }, new Course { /*Id=1, */ Title = "Distribuirani sistemi", Credits = 6, Semester = 8, Programme = "KTI", EducationLevel = "Undergraduate", FirstTeacherId = context.Teacher.Single(t => t.FirstName == "Marija" && t.LastName == "Kalendar").Id, SecondTeacherId = context.Teacher.Single(t => t.FirstName == "Emilija" && t.LastName == "Kizevska").Id } ); context.SaveChanges(); context.Enrollment.AddRange( new Enrollment { CourseId = 2, StudentId = 3, Semester = "Fall", Year = 2021 }, //MSU i Martina new Enrollment { CourseId = 1, StudentId = 3, Semester = "Spring", Year = 2021 }, //Ds i Martina new Enrollment { CourseId = 3, StudentId = 3, Semester = "Spring", Year = 2021 }, //RSWEB i Martina new Enrollment { CourseId = 1, StudentId = 2, Semester = "Spring", Year = 2021 }, //Ds i Elena new Enrollment { CourseId = 1, StudentId = 1, Semester = "Spring", Year = 2021 }, //Ds i Darko new Enrollment { CourseId = 3, StudentId = 2, Semester = "Spring", Year = 2021 } //RSWEB i Elena ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new UniversityContext(serviceProvider.GetRequiredService <DbContextOptions <UniversityContext> >())) { if (context.Course.Any() || context.Student.Any() || context.Teacher.Any()) { return; // DB has been seeded } context.Student.AddRange( new Student { /*Id = 1, */ FirstName = "Rob", LastName = "Reiner", EnrollmentDate = DateTime.Parse("1947-3-6"), AcquiredCredits = 60, CurrentSemester = 6, EducationLevel = "Dodiplomski" }, new Student { /*Id = 2, */ FirstName = "Andrej", LastName = "Popov", EnrollmentDate = DateTime.Parse("2017-9-1"), AcquiredCredits = 60, CurrentSemester = 6, EducationLevel = "Dodiplomski" }, new Student { /*Id = 3, */ FirstName = "Filip", LastName = "Pancevski", EnrollmentDate = DateTime.Parse("2017-9-1"), AcquiredCredits = 60, CurrentSemester = 6, EducationLevel = "Dodiplomski" }, new Student { /*Id = 4, */ FirstName = "David", LastName = "Petrusevski", EnrollmentDate = DateTime.Parse("2017-9-1"), AcquiredCredits = 60, CurrentSemester = 6, EducationLevel = "Dodiplomski" }, new Student { /*Id = 5, */ FirstName = "Angela", LastName = "Tasik", EnrollmentDate = DateTime.Parse("2017-9-1"), AcquiredCredits = 60, CurrentSemester = 6, EducationLevel = "Dodiplomski" }, new Student { /*Id = 6, */ FirstName = "Sara", LastName = "Stojanovska", EnrollmentDate = DateTime.Parse("2017-9-1"), AcquiredCredits = 60, CurrentSemester = 6, EducationLevel = "Dodiplomski" }, new Student { /*Id = 7, */ FirstName = "Rob", LastName = "Reiner", EnrollmentDate = DateTime.Parse("2017-9-1"), AcquiredCredits = 60, CurrentSemester = 6, EducationLevel = "Dodiplomski" } ); context.SaveChanges(); context.Teacher.AddRange( new Teacher {/*Id = 1, */ FirstName = "Rob", LastName = "Reiner", Degree = "neznam", AcademicRank = "neznam", OfficeNumber = "neznam", HireDate = DateTime.Parse("2017-9-1") }, new Teacher {/*Id = 2, */ FirstName = "Rop", LastName = "Reiner", Degree = "neznam", AcademicRank = "neznam", OfficeNumber = "neznam", HireDate = DateTime.Parse("2017-9-1") }, new Teacher {/*Id = 3, */ FirstName = "Ros", LastName = "Reiner", Degree = "neznam", AcademicRank = "neznam", OfficeNumber = "neznam", HireDate = DateTime.Parse("2017-9-1") }, new Teacher {/*Id = 4, */ FirstName = "Roq", LastName = "Reiner", Degree = "neznam", AcademicRank = "neznam", OfficeNumber = "neznam", HireDate = DateTime.Parse("2017-9-1") } ); context.SaveChanges(); context.Course.AddRange( new Course {/*Id = 1, */ Title = "RSWA", Credits = 6, Semester = 5, Programme = "blabla", EducationLevel = "nz", FirstTeacherId = context.Teacher.Single(d => d.FirstName == "Rob" && d.LastName == "Reiner").Id, SecondTeacherId = context.Teacher.Single(d => d.FirstName == "Roq" && d.LastName == "Reiner").Id }, new Course {/*Id = 2, */ Title = "MSWA", Credits = 6, Semester = 5, Programme = "blabla", EducationLevel = "nz", FirstTeacherId = context.Teacher.Single(d => d.FirstName == "Rob" && d.LastName == "Reiner").Id, SecondTeacherId = context.Teacher.Single(d => d.FirstName == "Roq" && d.LastName == "Reiner").Id }, new Course {/*Id = 3, */ Title = "Opticki Mrezi", Credits = 6, Semester = 5, Programme = "blabla", EducationLevel = "nz", FirstTeacherId = context.Teacher.Single(d => d.FirstName == "Rob" && d.LastName == "Reiner").Id, SecondTeacherId = context.Teacher.Single(d => d.FirstName == "Roq" && d.LastName == "Reiner").Id }, new Course {/*Id = 4, */ Title = "Matematika1", Credits = 6, Semester = 5, Programme = "blabla", EducationLevel = "nz", FirstTeacherId = context.Teacher.Single(d => d.FirstName == "Rob" && d.LastName == "Reiner").Id, SecondTeacherId = context.Teacher.Single(d => d.FirstName == "Roq" && d.LastName == "Reiner").Id } ); context.SaveChanges(); context.Enrollment.AddRange( new Enrollment { CourseId = 1, StudentId = 1 }, new Enrollment { CourseId = 2, StudentId = 4 }, new Enrollment { CourseId = 3, StudentId = 1 }, new Enrollment { CourseId = 4, StudentId = 6 }, new Enrollment { CourseId = 4, StudentId = 2 }, new Enrollment { CourseId = 4, StudentId = 7 }, new Enrollment { CourseId = 4, StudentId = 3 }, new Enrollment { CourseId = 4, StudentId = 3 } ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new UniversityContext( serviceProvider.GetRequiredService < DbContextOptions <UniversityContext> >())) { // Look for any movies. if (context.Course.Any() || context.Teacher.Any() || context.Student.Any()) { return; // DB has been seeded } context.Teacher.AddRange( new Teacher { /*Id = 1, */ firstName = "name1", lastName = "surname1" }, new Teacher { /*Id = 2, */ firstName = "name2", lastName = "surname2" }, new Teacher { /*Id = 3, */ firstName = "name3", lastName = "surname3" }, new Teacher { /*Id = 4, */ firstName = "name4", lastName = "surname4" } ); context.SaveChanges(); context.Student.AddRange( new Student { studentID = "17", firstName = "n1", lastName = "surname1", enrollmentDate = DateTime.Parse("2017-09-01") }, new Student { studentID = "12", firstName = "n2", lastName = "surname2", enrollmentDate = DateTime.Parse("2017-09-01") } ); context.SaveChanges(); context.Course.AddRange( new Course { ID = 1050, title = "Calculus", credits = 6, semester = 1, firstTeacherID = context.Teacher.Single(d => d.firstName == "n1" && d.lastName == "surname1").ID, secondTeacherID = context.Teacher.Single(d => d.firstName == "n1" && d.lastName == "surname1").ID }, new Course { ID = 1045, title = "Chemistry", credits = 6, semester = 1, firstTeacherID = context.Teacher.Single(d => d.firstName == "n1" && d.lastName == "surname1").ID, secondTeacherID = context.Teacher.Single(d => d.firstName == "n2" && d.lastName == "surname2").ID }, new Course { ID = 2042, title = "Literature", credits = 6, semester = 3, firstTeacherID = context.Teacher.Single(d => d.firstName == "n1" && d.lastName == "surname1").ID, secondTeacherID = context.Teacher.Single(d => d.firstName == "n2" && d.lastName == "surname2").ID } ); context.SaveChanges(); context.Enrollment.AddRange( new Enrollment { studentID = 1, courseID = 1045 }, new Enrollment { studentID = 4, courseID = 2042 } ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new UniversityContext( serviceProvider.GetRequiredService < DbContextOptions <UniversityContext> >())) { // Look for any movies. if (context.Course.Any() || context.Teacher.Any() || context.Student.Any()) { return; // DB has been seeded } context.Teacher.AddRange( new Teacher { /*Id = 1, */ firstName = "Kim", lastName = "Abercrombie" }, new Teacher { /*Id = 2, */ firstName = "Roger", lastName = "Hauri" }, new Teacher { /*Id = 3, */ firstName = "Candace", lastName = "Kapoor" }, new Teacher { /*Id = 4, */ firstName = "Roger", lastName = "Zheng" } ); context.SaveChanges(); context.Student.AddRange( new Student { studentID = "1982017", firstName = "Carson", lastName = "Alexander", enrollmentDate = DateTime.Parse("2017-09-01") }, new Student { studentID = "1222017", firstName = "Meredith", lastName = "Alonso", enrollmentDate = DateTime.Parse("2017-09-01") }, new Student { studentID = "1892017", firstName = "Arturo", lastName = "Anand", enrollmentDate = DateTime.Parse("2017-09-01") }, new Student { studentID = "802017", firstName = "Gytis", lastName = "Barzdukas", enrollmentDate = DateTime.Parse("2017-09-01") }, new Student { studentID = "182018", firstName = "Yan", lastName = "Li", enrollmentDate = DateTime.Parse("2018-09-01") }, new Student { studentID = "12018", firstName = "Peggy", lastName = "Justice", enrollmentDate = DateTime.Parse("2018-09-01") }, new Student { studentID = "1902019", firstName = "Laura", lastName = "Norman", enrollmentDate = DateTime.Parse("2019-09-01") }, new Student { studentID = "3042017", firstName = "Nino", lastName = "Olivetto", enrollmentDate = DateTime.Parse("2017-09-01") } ); context.SaveChanges(); context.Course.AddRange( new Course { ID = 1050, title = "Chemistry", credits = 6, semester = 1, firstTeacherID = context.Teacher.Single(d => d.firstName == "Kim" && d.lastName == "Abercrombie").ID, secondTeacherID = context.Teacher.Single(d => d.firstName == "Roger" && d.lastName == "Zheng").ID }, new Course { ID = 4022, title = "Microeconomics", credits = 3, semester = 5, firstTeacherID = context.Teacher.Single(d => d.firstName == "Kim" && d.lastName == "Abercrombie").ID, secondTeacherID = context.Teacher.Single(d => d.firstName == "Candace" && d.lastName == "Kapoor").ID }, new Course { ID = 4041, title = "Macroeconomics", credits = 3, semester = 5, firstTeacherID = context.Teacher.Single(d => d.firstName == "Roger" && d.lastName == "Zheng").ID, secondTeacherID = context.Teacher.Single(d => d.firstName == "Roger" && d.lastName == "Hauri").ID }, new Course { ID = 1045, title = "Calculus", credits = 6, semester = 1, firstTeacherID = context.Teacher.Single(d => d.firstName == "Kim" && d.lastName == "Abercrombie").ID, secondTeacherID = context.Teacher.Single(d => d.firstName == "Roger" && d.lastName == "Zheng").ID }, new Course { ID = 3141, title = "Trigonometry", credits = 3, semester = 2, firstTeacherID = context.Teacher.Single(d => d.firstName == "Kim" && d.lastName == "Abercrombie").ID, secondTeacherID = context.Teacher.Single(d => d.firstName == "Candace" && d.lastName == "Kapoor").ID }, new Course { ID = 2021, title = "Composition", credits = 6, semester = 4, firstTeacherID = context.Teacher.Single(d => d.firstName == "Candace" && d.lastName == "Kapoor").ID, secondTeacherID = context.Teacher.Single(d => d.firstName == "Roger" && d.lastName == "Zheng").ID }, new Course { ID = 2042, title = "Literature", credits = 6, semester = 3, firstTeacherID = context.Teacher.Single(d => d.firstName == "Kim" && d.lastName == "Abercrombie").ID, secondTeacherID = context.Teacher.Single(d => d.firstName == "Roger" && d.lastName == "Hauri").ID } ); context.SaveChanges(); context.Enrollment.AddRange( new Enrollment { studentID = 1, courseID = 1050 }, new Enrollment { studentID = 1, courseID = 4022 }, new Enrollment { studentID = 1, courseID = 4041 }, new Enrollment { studentID = 2, courseID = 1045 }, new Enrollment { studentID = 2, courseID = 3141 }, new Enrollment { studentID = 2, courseID = 2021 }, new Enrollment { studentID = 3, courseID = 1050 }, new Enrollment { studentID = 4, courseID = 1050 }, new Enrollment { studentID = 4, courseID = 4022 }, new Enrollment { studentID = 5, courseID = 4041 }, new Enrollment { studentID = 6, courseID = 1045 }, new Enrollment { studentID = 7, courseID = 3141 } ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new UniversityContext( serviceProvider.GetRequiredService < DbContextOptions <UniversityContext> >())) { // Look for any movies. if (context.Student.Any()) { return; // DB has been seeded } 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.Student.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.Instructor.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.Department.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.Course.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.OfficeAssignment.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.CourseAssignment.Add(ci); } context.SaveChanges(); var enrollments = new Enrollment[] { new Enrollment { StudentID = students.Single(s => s.LastName == "Alexander").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, Grade = Grade.A }, new Enrollment { StudentID = students.Single(s => s.LastName == "Alexander").ID, CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID, Grade = Grade.C }, new Enrollment { StudentID = students.Single(s => s.LastName == "Alexander").ID, CourseID = courses.Single(c => c.Title == "Macroeconomics").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Alonso").ID, CourseID = courses.Single(c => c.Title == "Calculus").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Alonso").ID, CourseID = courses.Single(c => c.Title == "Trigonometry").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Alonso").ID, CourseID = courses.Single(c => c.Title == "Composition").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Anand").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID }, new Enrollment { StudentID = students.Single(s => s.LastName == "Anand").ID, CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Barzdukas").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Li").ID, CourseID = courses.Single(c => c.Title == "Composition").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Justice").ID, CourseID = courses.Single(c => c.Title == "Literature").CourseID, Grade = Grade.B } }; foreach (Enrollment e in enrollments) { var enrollmentInDataBase = context.Enrollment.Where( s => s.Student.ID == e.StudentID && s.Course.CourseID == e.CourseID).SingleOrDefault(); if (enrollmentInDataBase == null) { context.Enrollment.Add(e); } } context.SaveChanges(); } }