public CreateModel(TheSurvivorsOfCsharp.Data.TheSurvivorsOfCsharpContext context)
{
_context = context;
}
public static void Initialize(TheSurvivorsOfCsharpContext context)
{
context.Database.EnsureCreated();
if (context.Course.Any())
{
return;
}
var universities = new University[]
{
new University {
Name = "Vilnius University"
},
new University {
Name = "Kaunas University of Technology"
},
new University {
Name = "Klaipėda University"
},
new University {
Name = "Šiauliai University"
}
};
foreach (University u in universities)
{
context.University.Add(u);
}
context.SaveChanges();
var majors = new Major[]
{
new Major {
Name = "Computer Sience"
},
new Major {
Name = "Medicine"
},
new Major {
Name = "Biology"
},
new Major {
Name = "Business administration"
},
new Major {
Name = "Economy"
},
new Major {
Name = "Chemistry"
},
new Major {
Name = "Physics"
},
new Major {
Name = "Teaching"
},
new Major {
Name = "Mathematics"
}
};
foreach (Major m in majors)
{
context.Major.Add(m);
}
context.SaveChanges();
var majorUniversities = new MajorUniversity[]
{
new MajorUniversity {
UniversityID = 1, MajorID = 1
},
new MajorUniversity {
UniversityID = 1, MajorID = 2
},
new MajorUniversity {
UniversityID = 1, MajorID = 4
},
new MajorUniversity {
UniversityID = 1, MajorID = 7
},
new MajorUniversity {
UniversityID = 1, MajorID = 9
},
new MajorUniversity {
UniversityID = 2, MajorID = 1
},
new MajorUniversity {
UniversityID = 2, MajorID = 2
},
new MajorUniversity {
UniversityID = 2, MajorID = 3
},
new MajorUniversity {
UniversityID = 2, MajorID = 4
},
new MajorUniversity {
UniversityID = 3, MajorID = 6
},
new MajorUniversity {
UniversityID = 3, MajorID = 7
},
new MajorUniversity {
UniversityID = 3, MajorID = 8
},
new MajorUniversity {
UniversityID = 1, MajorID = 4
},
new MajorUniversity {
UniversityID = 1, MajorID = 5
},
new MajorUniversity {
UniversityID = 1, MajorID = 6
}
};
foreach (MajorUniversity mU in majorUniversities)
{
context.MajorUniversity.Add(mU);
}
context.SaveChanges();
var lecturers = new Lecturer[]
{
new Lecturer {
TitleAndName = "Birutė Vilčiauskaitė", UniversityID = 1
},
new Lecturer {
TitleAndName = "prof.dr. Rasa Subačienė", UniversityID = 1
},
new Lecturer {
TitleAndName = "Dr. Agnė Brilingaitė", UniversityID = 1
},
new Lecturer {
TitleAndName = "Dr. Linas Bukauskas", UniversityID = 1
},
new Lecturer {
TitleAndName = "Eduardas Kutka", UniversityID = 1
},
new Lecturer {
TitleAndName = "Vytautas Ašeris", UniversityID = 1
},
new Lecturer {
TitleAndName = "Donatas Kimutis", UniversityID = 1
}
};
foreach (Lecturer l in lecturers)
{
context.Lecturer.Add(l);
}
context.SaveChanges();
var courses = new Course[]
{
new Course {
Name = "Management", UniversityID = 1, Since = Semester.WS1415
},
new Course {
Name = "Accounting", UniversityID = 1, Since = Semester.SS13
},
new Course {
Name = "Database Management Systems", UniversityID = 1, Since = Semester.SS13
},
new Course {
Name = "Computer Networks", UniversityID = 1, Since = Semester.SS19
},
new Course {
Name = "Applied object-oriented programming", UniversityID = 1, Since = Semester.WS1718
}
};
foreach (Course c in courses)
{
context.Course.Add(c);
}
context.SaveChanges();
var courselecturers = new CourseLecturer[]
{
new CourseLecturer {
CoursID = 1, LecturerID = 1
},
new CourseLecturer {
CoursID = 1, LecturerID = 2
},
new CourseLecturer {
CoursID = 2, LecturerID = 3
},
new CourseLecturer {
CoursID = 3, LecturerID = 4
},
new CourseLecturer {
CoursID = 3, LecturerID = 5
},
new CourseLecturer {
CoursID = 4, LecturerID = 6
},
new CourseLecturer {
CoursID = 5, LecturerID = 7
}
};
foreach (CourseLecturer cL in courselecturers)
{
context.CourseLecturer.Add(cL);
}
context.SaveChanges();
var courseMajors = new CourseMajor[]
{
new CourseMajor {
CoursID = 1, MajorID = 4
},
new CourseMajor {
CoursID = 2, MajorID = 4
},
new CourseMajor {
CoursID = 3, MajorID = 4
},
new CourseMajor {
CoursID = 4, MajorID = 1
},
new CourseMajor {
CoursID = 5, MajorID = 1
}
};
foreach (CourseMajor cM in courseMajors)
{
context.CourseMajor.Add(cM);
}
context.SaveChanges();
var students = new Student[]
{
new Student {
UserName = "******", UniversityID = 1,
AreaOfStudies = "Mathematics and computer sciences", Email = "*****@*****.**",
Password = "******"
},
new Student {
UserName = "******", UniversityID = 2,
AreaOfStudies = "Mathematics and computer sciences", Email = "*****@*****.**",
Password = "******"
},
new Student {
UserName = "******", UniversityID = 1,
AreaOfStudies = "Mathematics and computer sciences", Email = "*****@*****.**",
Password = "******"
}
};
foreach (Student s in students)
{
context.Student.Add(s);
}
context.SaveChanges();
var ratings = new Rating[]
{
new Rating {
StudentID = 1, CourseID = 1, OverallRating = 5, Interesting = 5, Learned = 5, Organized = 4,
Presentation = 3, ContactHours = 4, SelfStudyHours = 10, Semester = Semester.WS1920, Comment = "Good course",
Grade = 8, PassedFirstTime = false, Date = DateTime.Now
},
new Rating {
StudentID = 2, CourseID = 1, OverallRating = 5, Interesting = 4, Learned = 5, Organized = 4,
Presentation = 4, ContactHours = 3, SelfStudyHours = 8, Semester = Semester.WS1819, Comment = "Nice course",
Grade = 9, PassedFirstTime = true, Date = DateTime.Now
},
new Rating {
StudentID = 3, CourseID = 1, OverallRating = 3, Interesting = 5, Learned = 5, Organized = 2,
Presentation = 4, ContactHours = 4, SelfStudyHours = 11, Semester = Semester.WS1920, Comment = "A nice course",
Grade = 3, PassedFirstTime = false, Date = DateTime.Now
}
};
foreach (Rating r in ratings)
{
context.Rating.Add(r);
}
context.SaveChanges();
}
