public StudentsApiController(EduMVCContext context)
{
_context = context;
}
public CoursesApiController(EduMVCContext context)
{
_context = context;
}
public TeachersController(EduMVCContext context)
{
_context = context;
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new EduMVCContext(
serviceProvider.GetRequiredService <
DbContextOptions <EduMVCContext> >()))
{
// Look for
if (context.Course.Any() || context.Teacher.Any() || context.Student.Any())
{
return; // DB has been seeded
}
context.Course.AddRange(
new Course { /*Id = 1,*/
Title = "Math 1", Credits = 7, Semester = 1, Programme = "ALL", EducationLevel = "8", FirstTeacherId = 1, SecondTeacherId = 2
},
new Course { /*Id = 2,*/
Title = "Physics 1", Credits = 7, Semester = 1, Programme = "All", EducationLevel = "7", FirstTeacherId = 3, SecondTeacherId = 4
},
new Course { /*Id = 3,*/
Title = "Java Dev", Credits = 5, Semester = 2, Programme = "Computer Science", EducationLevel = "9", FirstTeacherId = 5, SecondTeacherId = 7
},
new Course { /*Id = 4,*/
Title = "C# Course", Credits = 5, Semester = 3, Programme = "Computer Science", EducationLevel = "8", FirstTeacherId = 7, SecondTeacherId = 5
},
new Course { /*Id = 5,*/
Title = "Electronics 1", Credits = 7, Semester = 4, Programme = "Hardware", EducationLevel = "2", FirstTeacherId = 8, SecondTeacherId = 4
},
new Course { /*Id = 6,*/
Title = "Ethical Hacking", Credits = 6, Semester = 7, Programme = "All", EducationLevel = "2", FirstTeacherId = 1, SecondTeacherId = 2
}
);
context.SaveChanges();
context.Teacher.AddRange(
new Teacher { /*Id = 1,*/
FirstName = "Aneta", LastName = "Buchkovska", AcademicRank = "Professor", Degree = "PhD", HireDate = DateTime.Parse("2017-1-1"), OfficeNumber = "1001"
},
new Teacher { /*Id = 2,*/
FirstName = "Sanja", LastName = "Atanasovska", AcademicRank = "Alumni", Degree = "PhD", HireDate = DateTime.Parse("2017-1-2"), OfficeNumber = "1002"
},
new Teacher { /*Id = 3,*/
FirstName = "Margarita", LastName = "Ginovska", AcademicRank = "Professor", Degree = "PhD", HireDate = DateTime.Parse("2017-1-3"), OfficeNumber = "1003"
},
new Teacher { /*Id = 4,*/
FirstName = "Lihnida", LastName = "Stojanovska", AcademicRank = "Professor", Degree = "PhD", HireDate = DateTime.Parse("2017-1-4"), OfficeNumber = "1004"
},
new Teacher { /*Id = 5,*/
FirstName = "Daniel", LastName = "Denkovski", AcademicRank = "Professor", Degree = "PhD", HireDate = DateTime.Parse("2017-1-5"), OfficeNumber = "1005"
},
new Teacher { /*Id = 6,*/
FirstName = "X", LastName = "Y", AcademicRank = "?", Degree = "?", HireDate = DateTime.Parse("2017-1-6"), OfficeNumber = "1006"
},
new Teacher { /*Id = 7,*/
FirstName = "Bojana", LastName = "Neznam", AcademicRank = "Alumni", Degree = "MS", HireDate = DateTime.Parse("2017-1-7"), OfficeNumber = "1007"
},
new Teacher { /*Id = 8,*/
FirstName = "Tomislav", LastName = "Kartalov", AcademicRank = "Gospod", Degree = "BOG", HireDate = DateTime.Parse("2017-1-8"), OfficeNumber = "1008"
}
);
context.SaveChanges();
context.Student.AddRange(
new Student { /*Id = 1,*/
StudentId = "101", FirstName = "Vladimir", LastName = "Krstikj", EnrollmentDate = DateTime.Parse("2017-2-1"), AcquiredCredits = 200, CurrentSemestar = 6, EducationLevel = "Diploma"
},
new Student { /*Id = 2,*/
StudentId = "102", FirstName = "Stojan", LastName = "Nebiten", EnrollmentDate = DateTime.Parse("2017-2-2"), AcquiredCredits = 105, CurrentSemestar = 4, EducationLevel = "Diploma"
},
new Student { /*Id = 3,*/
StudentId = "103", FirstName = "Blabla", LastName = "Yeye", EnrollmentDate = DateTime.Parse("2017-2-3"), AcquiredCredits = 140, CurrentSemestar = 2, EducationLevel = "Diploma"
},
new Student { /*Id = 1,*/
StudentId = "104", FirstName = "Marko", LastName = "Chovekot", EnrollmentDate = DateTime.Parse("2017-2-4"), AcquiredCredits = 50, CurrentSemestar = 2, EducationLevel = "Diploma"
},
new Student { /*Id = 1,*/
StudentId = "105", FirstName = "Student5", LastName = "Okey", EnrollmentDate = DateTime.Parse("2017-2-5"), AcquiredCredits = 75, CurrentSemestar = 4, EducationLevel = "Diploma"
}
);
context.SaveChanges();
context.Enrollment.AddRange(
new Enrollment { /*Id = 1,*/
CourseId = 1, StudentId = 101, Semester = "1", Year = 2017, Grade = 5, SeminalUrl = "www.google.com", ProjectUrl = "www.google.com", ExamPoints = 40, SeminalPoints = 20, ProjectPoints = 10, AdditionalPoints = 5, FinishDate = DateTime.Parse("2017-3-1")
},
new Enrollment { /*Id = 2,*/
CourseId = 2, StudentId = 102, Semester = "2", Year = 2017, Grade = 4, SeminalUrl = "www.google.com", ProjectUrl = "www.google.com", ExamPoints = 50, SeminalPoints = 10, ProjectPoints = 15, AdditionalPoints = 2, FinishDate = DateTime.Parse("2017-3-2")
},
new Enrollment { /*Id = 3,*/
CourseId = 3, StudentId = 103, Semester = "3", Year = 2017, Grade = 4, SeminalUrl = "www.google.com", ProjectUrl = "www.google.com", ExamPoints = 30, SeminalPoints = 20, ProjectPoints = 15, AdditionalPoints = 3, FinishDate = DateTime.Parse("2017-3-3")
}
);
context.SaveChanges();
}
}
public EnrollmentsController(EduMVCContext context)
{
_context = context;
}
