public void UpdateTeacherSubjects(SchoolContext context,
string[] selectedSubjects, Teacher teacherToUpdate = null)
{
if (selectedSubjects == null)
{
teacherToUpdate.TeacherSubjectAssignments = new List <TeacherSubjectAssignment>();
return;
}
var selectedSubjectsHS = new HashSet <string>(selectedSubjects);
var teacherSubjects = new HashSet <int>();
if (teacherToUpdate.TeacherSubjectAssignments != null)
{
teacherSubjects = new HashSet <int>
(teacherToUpdate.TeacherSubjectAssignments.Select(c => c.Subject.Id));
}
foreach (var subject in context.Subjects)
{
if (selectedSubjectsHS.Contains(subject.Id.ToString()))
{
if (!teacherSubjects.Contains(subject.Id))
{
teacherToUpdate.TeacherSubjectAssignments.Add(
new TeacherSubjectAssignment
{
TeacherId = teacherToUpdate.Id,
SubjectId = subject.Id
});
}
}
else
{
if (teacherSubjects.Contains(subject.Id))
{
TeacherSubjectAssignment SubjectToRemove
= teacherToUpdate
.TeacherSubjectAssignments
.SingleOrDefault(i => i.SubjectId == subject.Id);
context.Remove(SubjectToRemove);
}
}
}
}
public static void Initialize(SchoolContext context)
{
if (context.Students.Any())
{
return; // DB has been seeded
}
var kabinets = new Kabinet[]
{
new Kabinet {
Name = "101"
},
new Kabinet {
Name = "102"
},
new Kabinet {
Name = "103"
},
new Kabinet {
Name = "104"
},
new Kabinet {
Name = "105"
},
new Kabinet {
Name = "106"
},
};
context.Kabinets.AddRange(kabinets);
context.SaveChanges();
var teachers = new Teacher[]
{
new Teacher {
FirstMidName = "Kim", LastName = "Abercrombie",
HireDate = DateTime.Parse("1995-03-11")
},
new Teacher {
FirstMidName = "Pavel", LastName = "Maksimov",
HireDate = DateTime.Parse("1995-03-11")
}
};
context.Teachers.AddRange(teachers);
context.SaveChanges();
var classes = new SchoolClass[]
{
new SchoolClass {
Name = "1A"
},
new SchoolClass {
Name = "2A"
},
new SchoolClass {
Name = "3A"
}
};
context.SchoolClasses.AddRange(classes);
context.SaveChanges();
var students = new Student[]
{
new Student {
FirstMidName = "Carson", LastName = "Alexander", IDCode = "12243"
},
new Student {
FirstMidName = "Ilya", LastName = "Filimonau", IDCode = "12244"
},
new Student {
FirstMidName = "Veronica", LastName = "Vanadzins", IDCode = "12245"
},
new Student {
FirstMidName = "Nikita", LastName = "Shamlov", IDCode = "12246"
}
};
context.Students.AddRange(students);
context.SaveChanges();
var subjects = new Subject[]
{
new Subject {
Name = "Mathematics", Description = "This is mathematics"
},
new Subject {
Name = "Chemistry", Description = "This is chemisrty"
},
new Subject {
Name = "Art", Description = "This is art"
},
new Subject {
Name = "Music", Description = "This is music"
},
new Subject {
Name = "English", Description = "This is english"
},
new Subject {
Name = "Literature", Description = "This is literature"
},
new Subject {
Name = "Physics", Description = "This is physics"
},
new Subject {
Name = "Biology", Description = "This is biology"
}
};
context.Subjects.AddRange(subjects);
context.SaveChanges();
var optsubjects = new OptSubject[]
{
new OptSubject {
Name = "Programming", Description = "This is programming"
},
new OptSubject {
Name = "Robotics", Description = "This is robotics"
},
new OptSubject {
Name = "Cinema", Description = "This is cinema"
},
new OptSubject {
Name = "Drawing circle", Description = "This is Drawing circle"
}
};
context.OptSubjects.AddRange(optsubjects);
context.SaveChanges();
var optsubjectenrollments = new StudentOptSubjectEnrollment[]
{
new StudentOptSubjectEnrollment {
OptSubjectId = 1, StudentId = 1
},
new StudentOptSubjectEnrollment {
OptSubjectId = 2, StudentId = 2
},
new StudentOptSubjectEnrollment {
OptSubjectId = 2, StudentId = 1
}
};
context.OptSubjectEnrollments.AddRange(optsubjectenrollments);
context.SaveChanges();
var teacheroptsubjectassignments = new TeacherOptSubjectAssignment[]
{
new TeacherOptSubjectAssignment {
OptSubjectId = 1, TeacherId = 1
},
new TeacherOptSubjectAssignment {
OptSubjectId = 2, TeacherId = 2
}
};
context.TeacherOptSubjectAssignments.AddRange(teacheroptsubjectassignments);
context.SaveChanges();
var subjectassignments = new SchoolClassSubjectAssignment[]
{
new SchoolClassSubjectAssignment {
SubjectId = 1, SchoolClassId = 1
},
new SchoolClassSubjectAssignment {
SubjectId = 2, SchoolClassId = 1
},
new SchoolClassSubjectAssignment {
SubjectId = 3, SchoolClassId = 1
},
new SchoolClassSubjectAssignment {
SubjectId = 4, SchoolClassId = 1
},
new SchoolClassSubjectAssignment {
SubjectId = 2, SchoolClassId = 2
}
};
context.SubjectAssignments.AddRange(subjectassignments);
context.SaveChanges();
var subjectteacherassignments = new TeacherSubjectAssignment[]
{
new TeacherSubjectAssignment {
SubjectId = 1, TeacherId = 1
},
new TeacherSubjectAssignment {
SubjectId = 2, TeacherId = 2
}
};
context.SubjectTeacherAssignments.AddRange(subjectteacherassignments);
context.SaveChanges();
var studentschoolclassenrollments = new StudentSchoolClassEnrollment[]
{
new StudentSchoolClassEnrollment {
StudentId = 1, SchoolClassId = 1
},
new StudentSchoolClassEnrollment {
StudentId = 3, SchoolClassId = 2
},
new StudentSchoolClassEnrollment {
StudentId = 4, SchoolClassId = 3
},
new StudentSchoolClassEnrollment {
StudentId = 2, SchoolClassId = 1
}
};
context.StudentSchoolClassEnrollments.AddRange(studentschoolclassenrollments);
context.SaveChanges();
var teacherschoolclassassignments = new TeacherSchoolClassAssignment[]
{
new TeacherSchoolClassAssignment {
TeacherId = 1, SchoolClassId = 1
},
new TeacherSchoolClassAssignment {
TeacherId = 2, SchoolClassId = 2
}
};
context.TeacherSchoolClassAssignments.AddRange(teacherschoolclassassignments);
context.SaveChanges();
var schoolclasskabinetassignments = new SchoolClassKabinetAssignment[]
{
new SchoolClassKabinetAssignment {
SchoolClassId = 1, KabinetId = 1
},
new SchoolClassKabinetAssignment {
SchoolClassId = 2, KabinetId = 3
},
new SchoolClassKabinetAssignment {
SchoolClassId = 3, KabinetId = 4
}
};
context.SchoolClassKabinetAssignments.AddRange(schoolclasskabinetassignments);
context.SaveChanges();
var teacherkabinetassignments = new TeacherKabinetAssignment[]
{
new TeacherKabinetAssignment {
TeacherId = 1, KabinetId = 1
},
new TeacherKabinetAssignment {
TeacherId = 2, KabinetId = 5
}
};
context.TeacherKabinetAssignments.AddRange(teacherkabinetassignments);
context.SaveChanges();
var grades = new Grades[]
{
new Grades {
StudentId = 1, SubjectId = 1, Grade = Grade.A
},
new Grades {
StudentId = 1, SubjectId = 4, Grade = Grade.B
},
new Grades {
StudentId = 1, SubjectId = 5, Grade = Grade.F
},
new Grades {
StudentId = 1, SubjectId = 2, Grade = Grade.A
},
new Grades {
StudentId = 2, SubjectId = 5, Grade = Grade.B
}
};
context.Gradess.AddRange(grades);
context.SaveChanges();
}
