public EnrollmentsController(UniversityAppContext context, IWebHostEnvironment hostEnvironment) { _context = context; webHostEnviroment = hostEnvironment; }
public CoursesController(UniversityAppContext context) { _context = context; }
public ProfessorsApiController(UniversityAppContext context) { _context = context; }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new UniversityAppContext( serviceProvider.GetRequiredService <DbContextOptions <UniversityAppContext> >())) { if (context.Student.Any() || context.Professor.Any() || context.Courses.Any() || context.Enrollment.Any()) { return; } context.Student.AddRange( new Student { StudentId = "25/2018", FirstName = "Stefan", LastName = "Simonovski", AcquiredCredits = 120, EducationLevel = "First Year", EnrollmentDate = DateTime.Parse("2018 - 9 - 3"), CurrentSemester = 3 }, new Student { StudentId = "56/2018", FirstName = "Mirko", LastName = "Mirkovski", AcquiredCredits = 100, EducationLevel = "First Year", EnrollmentDate = DateTime.Parse("2018 - 9 - 5"), CurrentSemester = 3 } ); context.SaveChanges(); context.Professor.AddRange( new Professor { FirstName = "Rob", LastName = "Bob", AcademicRank = "vonreden", Degree = "Magister", HireDate = DateTime.Parse("1961-11-19"), OfficeNumber = "12122" }, new Professor { FirstName = "Bobby", LastName = "Robert", AcademicRank = "vonreden", Degree = "Doktor na nauki", HireDate = DateTime.Parse("1970-11- 30"), OfficeNumber = "32323" } ); context.SaveChanges(); context.Courses.AddRange( new Course { Title = "Matematika", Credits = 5, Programme = "Programa", EducationLevel = "Dificult", Semester = 1, FirstProfessorId = context.Professor.Single(d => d.FirstName == "Rob" && d.LastName == "Bob").Id, SecondProfessorId = context.Professor.Single(d => d.FirstName == "Bobby" && d.LastName == "Robert").Id } ); context.SaveChanges(); context.Student.AddRange( new Student { StudentId = "25/2018", FirstName = "Stefan", LastName = "Simonovski", AcquiredCredits = 120, EducationLevel = "First Year", EnrollmentDate = DateTime.Parse("2018 - 9 - 3"), CurrentSemester = 3 }, new Student { StudentId = "56/2018", FirstName = "Mirko", LastName = "Mirkovski", AcquiredCredits = 100, EducationLevel = "First Year", EnrollmentDate = DateTime.Parse("2018 - 9 - 5"), CurrentSemester = 3 } ); context.SaveChanges(); context.Enrollment.AddRange( new Enrollment { CourseId = context.Courses.Single(c => c.Title == "Matematika").Id, StudentId = context.Student.Single(s => s.FirstName == "Stefan" && s.LastName == "Simonovski").Id, ExamPoints = 56, AdditionalPoint = 15, ProjectPoints = 23, SeminarPoints = 15, Year = 2020, Grade = 7, FinishDate = DateTime.Parse("2020 - 5 - 26") }, new Enrollment { CourseId = context.Courses.Single(c => c.Title == "Matematika").Id, StudentId = context.Student.Single(s => s.FirstName == "Mirko" && s.LastName == "Mirkovski").Id, ExamPoints = 70, AdditionalPoint = 15, ProjectPoints = 25, SeminarPoints = 15, Year = 2020, Grade = 8, FinishDate = DateTime.Parse("2020 - 5 - 26") } ); //context.Enrollment.AddRange( // new Enrollment { CourseId = 1, StudentId = 1, ExamPoints = 56, AdditionalPoint = 15, ProjectPoints = 23, SeminarPoints = 15, Year = 2020, Grade = 7, FinishDate = DateTime.Parse("2020 - 5 - 26") }, // new Enrollment { CourseId = 1, StudentId = 2, ExamPoints = 70, AdditionalPoint = 15, ProjectPoints = 25, SeminarPoints = 15, Year = 2020, Grade = 8, FinishDate = DateTime.Parse("2020 - 5 - 26") } // ); context.SaveChanges(); // var enrollments = new Enrollment[] //{ // new Enrollment{StudentId=1,CourseId=2, ExamPoints = 56, AdditionalPoint = 15, ProjectPoints = 23, SeminarPoints = 15, Year = 2020, Grade = 7, FinishDate = DateTime.Parse("2020 - 5 - 26")}, // new Enrollment{StudentId=2,CourseId=2,ExamPoints = 70, AdditionalPoint = 15, ProjectPoints = 25, SeminarPoints = 15, Year = 2020, Grade = 8, FinishDate = DateTime.Parse("2020 - 5 - 26") }, //}; // foreach (Enrollment e in enrollments) // { // context.Enrollment.Add(e); // } // context.SaveChanges(); } }
public StudentsController(UniversityAppContext context) { _context = context; }
public EnrollmentsApiController(UniversityAppContext context) { _context = context; }