public TeachersController(UpravuvanjeContext context)
{
_context = context;
}
public EnrollmentsController(UpravuvanjeContext context)
{
_context = context;
}
public ProfesorController(UpravuvanjeContext context)
{
_context = context;
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new UpravuvanjeContext(
serviceProvider.GetRequiredService <
DbContextOptions <UpravuvanjeContext> >()))
{
CreateUserRoles(serviceProvider).Wait();
//CreateUserRoles(serviceProvider).Wait();
// Look for any movies.
if (context.Course.Any() || context.Teacher.Any() || context.Student.Any())
{
return; // DB has been seeded
}
context.Teacher.AddRange(
new Teacher {
FirstName = "Даниел", LastName = "Денковски", Degree = "Професор", AcademicRank = "Доцент", OfficeNumber = "01234", HireDate = DateTime.Parse("2020-2-3"), Course1 = new List <Course>(), Course2 = new List <Course>()
},
new Teacher {
FirstName = "Перо", LastName = "Латковски", Degree = "Професор", AcademicRank = "Доктор", OfficeNumber = "01234", HireDate = DateTime.Parse("2020-2-3"), Course1 = new List <Course>(), Course2 = new List <Course>()
},
new Teacher {
FirstName = "Марија", LastName = "Календар", Degree = "Професор", AcademicRank = "Доктор", OfficeNumber = "01234", HireDate = DateTime.Parse("2020-2-3"), Course1 = new List <Course>(), Course2 = new List <Course>()
},
new Teacher {
FirstName = "Ана", LastName = "Чолаковска", Degree = "Магистар", AcademicRank = "Магистар", OfficeNumber = "01234", HireDate = DateTime.Parse("2020-2-3"), Course1 = new List <Course>(), Course2 = new List <Course>()
},
new Teacher {
FirstName = "Горан", LastName = "Јакимовски", Degree = "Професор", AcademicRank = "Доцент", OfficeNumber = "01234", HireDate = DateTime.Parse("2020-2-3"), Course1 = new List <Course>(), Course2 = new List <Course>()
},
new Teacher {
FirstName = "Марко", LastName = "Порјазовски", Degree = "Професор", AcademicRank = "Доцент", OfficeNumber = "01234", HireDate = DateTime.Parse("2020-2-3"), Course1 = new List <Course>(), Course2 = new List <Course>()
},
new Teacher {
FirstName = "Владимир", LastName = "Атанасовски", Degree = "Професор", AcademicRank = "Доцент", OfficeNumber = "01234", HireDate = DateTime.Parse("2020-2-3"), Course1 = new List <Course>(), Course2 = new List <Course>()
},
new Teacher {
FirstName = "Валентин", LastName = "Раковиќ", Degree = "Професор", AcademicRank = "Доцент", OfficeNumber = "01234", HireDate = DateTime.Parse("2020-2-3"), Course1 = new List <Course>(), Course2 = new List <Course>()
}
);
context.SaveChanges();
context.Course.AddRange(
new Course
{
Title = "Развој на серверски веб апликации",
Credits = 6,
Semestar = 6,
Programme = "КТИ",
EducationLevel = "Дипломски",
FirstTeacherId = context.Teacher.Single(d => d.FirstName == "Даниел" && d.LastName == "Денковски").Id,
SecondTeacherId = context.Teacher.Single(d => d.FirstName == "Перо" && d.LastName == "Латковски").Id
},
new Course
{
Title = "Микропроцесорски системи",
Credits = 6,
Semestar = 2,
Programme = "КТИ",
EducationLevel = "Дипломски",
FirstTeacherId = context.Teacher.Single(d => d.FirstName == "Марија" && d.LastName == "Календар").Id,
SecondTeacherId = context.Teacher.Single(d => d.FirstName == "Ана" && d.LastName == "Чолаковска").Id
},
new Course
{
Title = "Веб апликации",
Credits = 6,
Semestar = 3,
Programme = "КХИЕ",
EducationLevel = "Дипломски",
FirstTeacherId = context.Teacher.Single(d => d.FirstName == "Горан" && d.LastName == "Јакимовски").Id,
SecondTeacherId = context.Teacher.Single(d => d.FirstName == "Марко" && d.LastName == "Порјазовски").Id
},
new Course
{
Title = "Основи на веб Програмирање",
Credits = 6,
Semestar = 4,
Programme = "ТКИИ",
EducationLevel = "Дипломски",
FirstTeacherId = context.Teacher.Single(d => d.FirstName == "Владимир" && d.LastName == "Атанасовски").Id,
SecondTeacherId = context.Teacher.Single(d => d.FirstName == "Валентин" && d.LastName == "Раковиќ").Id
}
);
context.SaveChanges();
context.Student.AddRange(
new Student {
FirstName = "Стефан", LastName = "Станковиќ", Indeks = "179/2018", EnrollmentDate = DateTime.Parse("2018-6-6"), AcquireCredits = 240, CurrentSemestar = 6, EducationLevel = "Дипломски"
},
new Student {
FirstName = "Марко", LastName = "Марковски", Indeks = "200/2018", EnrollmentDate = DateTime.Parse("2018-6-6"), AcquireCredits = 240, CurrentSemestar = 6, EducationLevel = "Дипломски"
},
new Student {
FirstName = "Петко", LastName = "Петковски", Indeks = "231/2018", EnrollmentDate = DateTime.Parse("2018-6-6"), AcquireCredits = 120, CurrentSemestar = 6, EducationLevel = "Дипломски"
},
new Student {
FirstName = "Марија", LastName = "Станковска", Indeks = "100/2018", EnrollmentDate = DateTime.Parse("2018-6-6"), AcquireCredits = 95, CurrentSemestar = 4, EducationLevel = "Дипломски"
},
new Student {
FirstName = "Ивона", LastName = "Станковска", Indeks = "19/2018", EnrollmentDate = DateTime.Parse("2018-6-6"), AcquireCredits = 100, CurrentSemestar = 3, EducationLevel = "Дипломски"
},
new Student {
FirstName = "Немања", LastName = "Станковиќ", Indeks = "9/2018", EnrollmentDate = DateTime.Parse("2018-6-6"), AcquireCredits = 50, CurrentSemestar = 3, EducationLevel = "Дипломски"
},
new Student {
FirstName = "Виктор", LastName = "Викторовски", Indeks = "17/2018", EnrollmentDate = DateTime.Parse("2018-6-6"), AcquireCredits = 240, CurrentSemestar = 6, EducationLevel = "Дипломски"
}
);
context.SaveChanges();
context.Enrollment.AddRange(
new Enrollment {
StudentId = 1, CourseId = 1, Year = 2021
},
new Enrollment {
StudentId = 2, CourseId = 1, Year = 2020
},
new Enrollment {
StudentId = 3, CourseId = 1, Year = 2021
},
new Enrollment {
StudentId = 4, CourseId = 2, Year = 2019
},
new Enrollment {
StudentId = 5, CourseId = 2, Year = 2020
},
new Enrollment {
StudentId = 6, CourseId = 2, Year = 2021
},
new Enrollment {
StudentId = 7, CourseId = 3, Year = 2021
},
new Enrollment {
StudentId = 3, CourseId = 3, Year = 2019
},
new Enrollment {
StudentId = 5, CourseId = 4, Year = 2020
},
new Enrollment {
StudentId = 1, CourseId = 4, Year = 2021
}
);
context.SaveChanges();
}
}
public StudentsController(UpravuvanjeContext context)
{
_context = context;
}
public CoursesController(UpravuvanjeContext context)
{
_context = context;
}
