private void SeedUserRoles(CampusDbContext context)
{
var userRoles = new[]
{
new UserRole {
UserId = 1, RoleId = 1
},
new UserRole {
UserId = 2, RoleId = 1
},
new UserRole {
UserId = 3, RoleId = 1
},
new UserRole {
UserId = 4, RoleId = 1
},
new UserRole {
UserId = 5, RoleId = 2
},
new UserRole {
UserId = 6, RoleId = 100
},
};
context.UserRoles.AddRange(userRoles);
context.SaveChanges();
}
private void SeedUsers(CampusDbContext context)
{
var users = new[]
{
new User {
Email = "*****@*****.**", PasswordHash = "password123", LastVisit = DateTime.Now
},
new User {
Email = "*****@*****.**", PasswordHash = "password123", LastVisit = DateTime.Now
},
new User {
Email = "*****@*****.**", PasswordHash = "password123", LastVisit = DateTime.Now
},
new User {
Email = "*****@*****.**", PasswordHash = "password123", LastVisit = DateTime.Now
},
new User {
Email = "*****@*****.**", PasswordHash = "password123", LastVisit = DateTime.Now
},
new User {
Email = "*****@*****.**", PasswordHash = "password123", LastVisit = DateTime.Now
},
};
context.Users.AddRange(users);
context.SaveChanges();
}
private void SeedLectors(CampusDbContext context)
{
var lectors = new[]
{
new Lector {
FirstName = "John", LastName = "Patron", Patronymic = "Michael",
AcademicDegreeId = 1, AcademicRankId = 2, UserId = 1,
Email = "*****@*****.**", PhoneNumber = "+380449212345"
},
new Lector {
FirstName = "Jack", LastName = "Johnes", Patronymic = "Donald",
AcademicDegreeId = 2, AcademicRankId = 3, UserId = 2,
Email = "*****@*****.**", PhoneNumber = "+380509212345"
},
new Lector {
FirstName = "Mark", LastName = "Clapton", Patronymic = "Steven",
AcademicDegreeId = 1, AcademicRankId = 1, UserId = 3,
Email = "*****@*****.**", PhoneNumber = "+38099921235"
},
new Lector {
FirstName = "Louie", LastName = "Vaughan", Patronymic = "Raynold",
AcademicDegreeId = 2, AcademicRankId = 1, UserId = 4,
Email = "*****@*****.**", PhoneNumber = "+380891231232"
}
};
context.Lectors.AddRange(lectors);
context.SaveChanges();
}
private void SeedWeatherTypes(CampusDbContext context)
{
var weatherTypes = new[]
{
new WeatherType {
Id = 1, Name = "Sunny"
},
new WeatherType {
Id = 2, Name = "Cloudy"
},
new WeatherType {
Id = 3, Name = "Overcast"
},
new WeatherType {
Id = 4, Name = "Thunder storm"
},
new WeatherType {
Id = 5, Name = "Snowy"
},
new WeatherType {
Id = 6, Name = "Rain"
}
};
context.WeatherTypes.AddRange(weatherTypes);
context.SaveChanges();
}
public void SeedEverything(CampusDbContext context)
{
context.Database.EnsureCreated();
if (context.Groups.Any())
{
return; // Db has been seeded
}
SeedRoles(context);
SeedUsers(context);
SeedUserRoles(context);
SeedAcademicDegrees(context);
SeedAcademicRanks(context);
SeedDayOfWeeks(context);
SeedEducationalDegrees(context);
SeedWeatherTypes(context);
SeedLessonTypes(context);
SeedSpecialities(context);
SeedSubjects(context);
SeedGroups(context);
SeedLectors(context);
SeedLectorSubjects(context);
SeedLessons(context);
SeedAttendances(context);
}
private void SeedGroups(CampusDbContext context)
{
var groups = new[]
{
new Group {
Name = "TB-61", SpecialityId = 1, StudentsCount = 24, EducationalDegreeId = 1, Year = 4
},
new Group {
Name = "TB-71", SpecialityId = 1, StudentsCount = 14, EducationalDegreeId = 1, Year = 3
},
new Group {
Name = "TP-81", SpecialityId = 2, StudentsCount = 20, EducationalDegreeId = 1, Year = 2
},
new Group {
Name = "TI-91M", SpecialityId = 1, StudentsCount = 10, EducationalDegreeId = 2, Year = 1
},
new Group {
Name = "TM-91", SpecialityId = 1, StudentsCount = 24, EducationalDegreeId = 1, Year = 1
},
new Group {
Name = "TI-81", SpecialityId = 2, StudentsCount = 28, EducationalDegreeId = 1, Year = 2
},
new Group {
Name = "TM-91M", SpecialityId = 2, StudentsCount = 8, EducationalDegreeId = 1, Year = 1
}
};
context.Groups.AddRange(groups);
context.SaveChanges();
}
private void SeedDayOfWeeks(CampusDbContext context)
{
var dayOfWeeks = new[]
{
new DayOfWeek {
Id = 1, Name = "Monday"
},
new DayOfWeek {
Id = 2, Name = "Tuesday"
},
new DayOfWeek {
Id = 3, Name = "Wednesday"
},
new DayOfWeek {
Id = 4, Name = "Thursday"
},
new DayOfWeek {
Id = 5, Name = "Friday"
},
new DayOfWeek {
Id = 6, Name = "Saturday"
},
new DayOfWeek {
Id = 7, Name = "Sunday"
}
};
context.DayOfWeeks.AddRange(dayOfWeeks);
context.SaveChanges();
}
private void SeedAttendances(CampusDbContext context)
{
/*var attendances = new[]
* {
* new Attendance{}
* };
*
* context.Attendances.AddRange(attendances);
*
* context.SaveChanges();*/
}
private void SeedEducationalDegrees(CampusDbContext context)
{
var educationalDegrees = new[]
{
new EducationalDegree {
Id = 1, Name = "Bachelor degree"
},
new EducationalDegree {
Id = 2, Name = "Master degree"
}
};
context.EducationalDegrees.AddRange(educationalDegrees);
context.SaveChanges();
}
private void SeedSpecialities(CampusDbContext context)
{
var specialities = new[]
{
new Speciality {
Name = "Software engineering", Code = 121
},
new Speciality {
Name = "Computer science", Code = 122
}
};
context.Specialities.AddRange(specialities);
context.SaveChanges();
}
private void SeedAcademicDegrees(CampusDbContext context)
{
var academicDegrees = new[]
{
new AcademicDegree {
Id = 1, Name = "Higher doctorate"
},
new AcademicDegree {
Id = 2, Name = "PhD"
}
};
context.AcademicDegrees.AddRange(academicDegrees);
context.SaveChanges();
}
private void SeedAcademicRanks(CampusDbContext context)
{
var academicRanks = new[]
{
new AcademicRank {
Id = 1, Name = "Research fellow"
},
new AcademicRank {
Id = 2, Name = "Associate professor"
},
new AcademicRank {
Id = 3, Name = "Professor"
}
};
context.AcademicRanks.AddRange(academicRanks);
context.SaveChanges();
}
private void SeedLessonTypes(CampusDbContext context)
{
var lessonTypes = new[]
{
new LessonType {
Id = 1, Name = "Lection"
},
new LessonType {
Id = 2, Name = "Lab"
},
new LessonType {
Id = 3, Name = "Seminar/Practice"
}
};
context.LessonTypes.AddRange(lessonTypes);
context.SaveChanges();
}
private void SeedRoles(CampusDbContext context)
{
var roles = new[]
{
new Role {
Id = 100, Name = "SuperAdmin"
},
new Role {
Id = 1, Name = "Lector"
},
new Role {
Id = 2, Name = "Admin"
}
};
context.Roles.AddRange(roles);
context.SaveChanges();
}
private void SeedSubjects(CampusDbContext context)
{
var subjects = new[]
{
new Subject {
Name = "Design and Analysis Of Algorithms"
},
new Subject {
Name = "Data Structures"
},
new Subject {
Name = "Object Oriented Programming"
},
new Subject {
Name = "Operating Systems"
},
new Subject {
Name = "Probability Statistics and Numerical Techniques"
},
new Subject {
Name = "Compiler Design"
},
new Subject {
Name = "System Software"
},
new Subject {
Name = "Artificial Intelligence"
},
new Subject {
Name = "Theory of Computation"
}
};
context.Subjects.AddRange(subjects);
context.SaveChanges();
}
public static void Initialize(CampusDbContext context)
{
var initializer = new CampusInitializer();
initializer.SeedEverything(context);
}
private void SeedLectorSubjects(CampusDbContext context)
{
var lectorSubjects = new[]
{
new LectorSubject {
LectorId = 1, SubjectId = 1, LessonTypeId = 1
},
new LectorSubject {
LectorId = 2, SubjectId = 1, LessonTypeId = 2
},
new LectorSubject {
LectorId = 1, SubjectId = 2, LessonTypeId = 3
},
new LectorSubject {
LectorId = 3, SubjectId = 3, LessonTypeId = 2
},
new LectorSubject {
LectorId = 4, SubjectId = 4, LessonTypeId = 1
},
new LectorSubject {
LectorId = 4, SubjectId = 5, LessonTypeId = 3
},
new LectorSubject {
LectorId = 1, SubjectId = 2, LessonTypeId = 1
},
new LectorSubject {
LectorId = 3, SubjectId = 3, LessonTypeId = 1
},
new LectorSubject {
LectorId = 4, SubjectId = 4, LessonTypeId = 2
},
new LectorSubject {
LectorId = 1, SubjectId = 5, LessonTypeId = 2
},
new LectorSubject {
LectorId = 4, SubjectId = 2, LessonTypeId = 2
},
new LectorSubject {
LectorId = 2, SubjectId = 1, LessonTypeId = 3
},
new LectorSubject {
LectorId = 3, SubjectId = 2, LessonTypeId = 1
},
new LectorSubject {
LectorId = 3, SubjectId = 4, LessonTypeId = 2
},
new LectorSubject {
LectorId = 4, SubjectId = 5, LessonTypeId = 3
},
new LectorSubject {
LectorId = 2, SubjectId = 6, LessonTypeId = 1
},
new LectorSubject {
LectorId = 1, SubjectId = 1, LessonTypeId = 2
}
};
context.LectorSubjects.AddRange(lectorSubjects);
context.SaveChanges();
}
private void SeedLessons(CampusDbContext context)
{
var lessons = new[]
{
new Lesson {
GroupId = 1, LectorSubjectId = 1
},
new Lesson {
GroupId = 1, LectorSubjectId = 2
},
new Lesson {
GroupId = 1, LectorSubjectId = 3
},
new Lesson {
GroupId = 1, LectorSubjectId = 4
},
new Lesson {
GroupId = 2, LectorSubjectId = 5
},
new Lesson {
GroupId = 2, LectorSubjectId = 6
},
new Lesson {
GroupId = 2, LectorSubjectId = 7
},
new Lesson {
GroupId = 2, LectorSubjectId = 9
},
new Lesson {
GroupId = 2, LectorSubjectId = 10
},
new Lesson {
GroupId = 2, LectorSubjectId = 11
},
new Lesson {
GroupId = 3, LectorSubjectId = 12
},
new Lesson {
GroupId = 3, LectorSubjectId = 13
},
new Lesson {
GroupId = 3, LectorSubjectId = 14
},
new Lesson {
GroupId = 3, LectorSubjectId = 15
},
new Lesson {
GroupId = 3, LectorSubjectId = 16
},
new Lesson {
GroupId = 4, LectorSubjectId = 17
},
new Lesson {
GroupId = 4, LectorSubjectId = 8
},
new Lesson {
GroupId = 5, LectorSubjectId = 13
},
new Lesson {
GroupId = 5, LectorSubjectId = 12
},
new Lesson {
GroupId = 5, LectorSubjectId = 11
},
new Lesson {
GroupId = 5, LectorSubjectId = 10
},
new Lesson {
GroupId = 5, LectorSubjectId = 9
},
new Lesson {
GroupId = 6, LectorSubjectId = 7
},
new Lesson {
GroupId = 6, LectorSubjectId = 6
},
new Lesson {
GroupId = 6, LectorSubjectId = 5
},
new Lesson {
GroupId = 7, LectorSubjectId = 4
},
new Lesson {
GroupId = 7, LectorSubjectId = 3
},
new Lesson {
GroupId = 7, LectorSubjectId = 2
},
new Lesson {
GroupId = 7, LectorSubjectId = 1
}
};
context.Lessons.AddRange(lessons);
context.SaveChanges();
}