public UserService(IOptions <AppSettings> appSettings, MVCEduContext context)
{
_appSettings = appSettings.Value;
//prevzemanje na podatocite od DB
_context = context;
}
public CoursesAPIController(MVCEduContext context)
{
_context = context;
}
public TeachersAPIController(MVCEduContext context)
{
_context = context;
}
public StudentsController(MVCEduContext context, IWebHostEnvironment hostEnvironment)
{
_context = context;
webHostEnvironment = hostEnvironment;
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new MVCEduContext(serviceProvider.GetRequiredService <DbContextOptions <MVCEduContext> >()))
{
if (context.Course.Any() || context.Student.Any() || context.Teacher.Any())
{
return;
}
context.Student.AddRange(
new Student { /*Id = 1,*/
StudentId = "89", FirstName = "Филип", LastName = "Панчевски", EnrollmentDate = DateTime.Parse("2017-8-1"), AcquiredCredits = 200, CurrentSemester = 6, EducationLevel = "Додипломски", ProfilePicture = ""
},
new Student { /*Id = 2,*/
StudentId = "00", FirstName = "Венко", LastName = "Филипче", EnrollmentDate = DateTime.Parse("2017-2-1"), AcquiredCredits = 105, CurrentSemester = 4, EducationLevel = "Додипломски", ProfilePicture = ""
},
new Student { /*Id = 3,*/
StudentId = "42", FirstName = "Вилијам", LastName = "Шејкспир", EnrollmentDate = DateTime.Parse("1590-12-9"), AcquiredCredits = 365, CurrentSemester = 22, EducationLevel = "Доктор на книги", ProfilePicture = ""
},
new Student { /*Id = 1,*/
StudentId = "247", FirstName = "Милан", LastName = "Јуве", EnrollmentDate = DateTime.Parse("2007-2-4"), AcquiredCredits = 63, CurrentSemester = 5, EducationLevel = "Серија А", ProfilePicture = ""
},
new Student { /*Id = 1,*/
StudentId = "222", FirstName = "Сунчица", LastName = "Кала", EnrollmentDate = DateTime.Parse("2017-2-5"), AcquiredCredits = 75, CurrentSemester = 4, EducationLevel = "Додипломски", ProfilePicture = ""
},
new Student { /*Id = 1,*/
StudentId = "333", FirstName = "Андреј", LastName = "Попоф", EnrollmentDate = DateTime.Parse("2019-8-11"), AcquiredCredits = 199, CurrentSemester = 6, EducationLevel = "Додипломски", ProfilePicture = ""
},
new Student { /*Id = 1,*/
StudentId = "444", FirstName = "Хотел?", LastName = "Триваго", EnrollmentDate = DateTime.Parse("2000-1-1"), AcquiredCredits = 0, CurrentSemester = 7, EducationLevel = "Почетник", ProfilePicture = ""
}
);
context.SaveChanges();
context.Teacher.AddRange(
new Teacher { /*Id = 1,*/
FirstName = "Анета", LastName = "Бучковска", AcademicRank = "Професор", Degree = "PhD", HireDate = DateTime.Parse("2015-1-1"), OfficeNumber = "1001", ProfilePicture = "aneta.jpeg"
},
new Teacher { /*Id = 2,*/
FirstName = "Биба", LastName = "Начевска", AcademicRank = "Професор", Degree = "PhD", HireDate = DateTime.Parse("2015-11-2"), OfficeNumber = "1002"
},
new Teacher { /*Id = 3,*/
FirstName = "Сања", LastName = "Атанасовска", AcademicRank = "Професор", Degree = "PhD", HireDate = DateTime.Parse("2015-1-23"), OfficeNumber = "1003"
},
new Teacher { /*Id = 4,*/
FirstName = "Ивана", LastName = "Сандева", AcademicRank = "Професор", Degree = "PhD", HireDate = DateTime.Parse("2015-1-24"), OfficeNumber = "1004"
},
new Teacher { /*Id = 5,*/
FirstName = "Маргарита", LastName = "Гиновска", AcademicRank = "Професор", Degree = "PhD", HireDate = DateTime.Parse("2015-2-5"), OfficeNumber = "1005"
},
new Teacher { /*Id = 6,*/
FirstName = "Перо", LastName = "Латкоски", AcademicRank = "Професор", Degree = "PhD", HireDate = DateTime.Parse("2015-1-6"), OfficeNumber = "1006"
},
new Teacher { /*Id = 7,*/
FirstName = "Даниел", LastName = "Денковски", AcademicRank = "Професор", Degree = "PhD", HireDate = DateTime.Parse("2015-8-7"), OfficeNumber = "1007"
},
new Teacher { /*Id = 8,*/
FirstName = "Борислав", LastName = "Поповски", AcademicRank = "Професор", Degree = "PhD", HireDate = DateTime.Parse("2017-3-8"), OfficeNumber = "1008", ProfilePicture = ""
},
new Teacher { /*Id = 9,*/
FirstName = "Владимир", LastName = "Атанасовски", AcademicRank = "Професор", Degree = "PhD", HireDate = DateTime.Parse("2017-3-8"), OfficeNumber = "1009", ProfilePicture = "vladimir.jpg"
},
new Teacher { /*Id = 10,*/
FirstName = "Соња", LastName = "Зајкова", AcademicRank = "Професор", Degree = "PhD", HireDate = DateTime.Parse("2017-3-8"), OfficeNumber = "1010", ProfilePicture = "zajkova.jpg"
}
);
context.SaveChanges();
context.Course.AddRange(
new Course { /*Id = 1,*/
Title = "Математика 1", Credits = 7, Semester = 1, Programme = "Сите", EducationLevel = "8", FirstTeacherId = context.Teacher.Single(d => d.FirstName == "Анета" && d.LastName == "Бучковска").Id, SecondTeacherId = context.Teacher.Single(d => d.FirstName == "Сања" && d.LastName == "Атанасовска").Id
},
new Course { /*Id = 2,*/
Title = "Физика 1", Credits = 7, Semester = 1, Programme = "Сите", EducationLevel = "7", FirstTeacherId = context.Teacher.Single(d => d.FirstName == "Маргарита" && d.LastName == "Гиновска").Id, SecondTeacherId = context.Teacher.Single(d => d.FirstName == "Ивана" && d.LastName == "Сандева").Id
},
new Course { /*Id = 3,*/
Title = "Програмирање и Алгоритми", Credits = 5, Semester = 2, Programme = "КТИ", EducationLevel = "9", FirstTeacherId = context.Teacher.Single(d => d.FirstName == "Даниел" && d.LastName == "Денковски").Id, SecondTeacherId = context.Teacher.Single(d => d.FirstName == "Владимир" && d.LastName == "Атанасовски").Id
},
new Course { /*Id = 4,*/
Title = "Математика 3", Credits = 5, Semester = 3, Programme = "КТИ", EducationLevel = "8", FirstTeacherId = context.Teacher.Single(d => d.FirstName == "Биба" && d.LastName == "Начевска").Id, SecondTeacherId = context.Teacher.Single(d => d.FirstName == "Биба" && d.LastName == "Начевска").Id
},
new Course { /*Id = 5,*/
Title = "Оптички мрежи", Credits = 7, Semester = 4, Programme = "ТКИИ", EducationLevel = "2", FirstTeacherId = context.Teacher.Single(d => d.FirstName == "Борислав" && d.LastName == "Поповски").Id, SecondTeacherId = context.Teacher.Single(d => d.FirstName == "Перо" && d.LastName == "Латкоски").Id
}
);
context.SaveChanges();
context.Enrollment.AddRange(
new Enrollment { /*Id = 1,*/
StudentId = context.Student.Single(d => d.StudentId == "89").Id,
CourseId = context.Course.Single(d => d.Title == "Математика 1").Id,
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("2020-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();
context.User.AddRange(
new User
{
/*Id = 1,*/
Username = "******",
Password = "******",
Role = Role.Admin
},
new User
{
/*Id = 2,*/
Username = "******",
Password = "******",
Role = Role.Teacher,
TeacherId = context.Teacher.Single(d => d.FirstName == "Перо" && d.LastName == "Латкоски").Id
},
new User
{
/*Id = 3,*/
Username = "******",
Password = "******",
Role = Role.Student,
StudentId = context.Student.Single(d => d.FirstName == "Филип" && d.LastName == "Панчевски").Id
}
);
context.SaveChanges();
}
}
public StudentsAPIController(MVCEduContext context)
{
_context = context;
}
public EnrollmentsController(MVCEduContext context)
{
_context = context;
}
