private void SeedAttendance(AttendDbContext context)
{
List <Student> selectedStudents = new List <Student>();
selectedStudents = GetStudents(context);
List <Subject> selectedSubjects = new List <Subject>();
selectedSubjects = GetSubjects(context);
foreach (var s in selectedStudents)
{
context.Attendances.AddOrUpdate(a => a.StudentID,
new Attendance
{
AttendanceDate = DateTime.Now,
Present = true,
StudentID = s.StudentID,
student = s,
subject = selectedSubjects.FirstOrDefault(),
SubjectID = selectedSubjects.FirstOrDefault().SubjectID
}
);
context.SaveChanges();
}
}
private List <Subject> GetSubjects(AttendDbContext context)
{
var randomSetSubject = context.Subjects.Select(s => new { s.SubjectID, r = Guid.NewGuid() });
List <string> subset = randomSetSubject.OrderBy(s => s.r)
.Select(s => s.SubjectID.ToString()).Take(2).ToList();
return(context.Subjects.Where(s => subset.Contains(s.SubjectID.ToString())).ToList());
}
private void SeedStudents(AttendDbContext c)
{
c.Students.AddOrUpdate(s => s.StudentID,
new Student {
StudentID = "S001", FirstName = "John", LastName = "Smith"
},
new Student {
StudentID = "S002", FirstName = "Mary", LastName = "Bloggs"
}
);
}
private void SeedSubjects(AttendDbContext c)
{
c.Subjects.AddOrUpdate(
p => p.SubjectID,
new Subject {
SubjectName = "Software Development"
},
new Subject {
SubjectName = "Maths"
},
new Subject {
SubjectName = "Databases"
}
);
}
private void SeedStudentSubjects(AttendDbContext c)
{
c.StudentSubjects.AddOrUpdate(
new StudentSubject {
StudentID = "S001", SubjectID = 1
},
new StudentSubject {
StudentID = "S001", SubjectID = 2
},
new StudentSubject {
StudentID = "S002", SubjectID = 1
},
new StudentSubject {
StudentID = "S002", SubjectID = 2
}
);
}
private void SeedAttendances(AttendDbContext c)
{
c.Attendances.AddOrUpdate(a => a.AttendanceID,
new Attendance {
StudentID = "S001", SubjectID = 1, Present = true, AttendanceDate = DateTime.Now
},
new Attendance {
StudentID = "S001", SubjectID = 2, Present = false, AttendanceDate = DateTime.Now
},
new Attendance {
StudentID = "S002", SubjectID = 1, Present = true, AttendanceDate = DateTime.Now
},
new Attendance {
StudentID = "S002", SubjectID = 2, Present = true, AttendanceDate = DateTime.Now
}
);
}
private void SeedAttendance(AttendDbContext context)
{
//private List<Student>
context.Attendances.AddOrUpdate(a => a.AttendanceID,
new Attendance
{
AttendanceDate = DateTime.Now,
Present = true,
StudentID = 1,
SubjectID = 1,
});
context.Attendances.AddOrUpdate(a => a.AttendanceID,
new Attendance
{
AttendanceDate = DateTime.Now,
Present = true,
StudentID = 2,
SubjectID = 2,
});
}
private void SeedLecturers(AttendDbContext c)
{
c.Lecturers.AddOrUpdate(l => l.LecturerID,
new Lecturer {
LecturerName = "Patrick"
},
new Lecturer {
LecturerName = "Jimmy"
}
);
c.LecturerSubjects.AddOrUpdate(
new LecturerSubject {
LecturerID = 1, SubjectID = 1
},
new LecturerSubject {
LecturerID = 2, SubjectID = 2
}
);
}
private void SeedSubjects(AttendDbContext context)
{
context.Subjects.AddOrUpdate(s => s.SubjectID,
new Subject
{
SubjectName = "Calculus",
students = new List <Student> {
new Student {
FirstName = "Mary", SecondName = "Jane"
},
new Student {
FirstName = "Boby", SecondName = "Bobberson"
},
},
lecturers = new List <Lecturer>
{
new Lecturer {
LecturerName = "Professor X"
}
}
}
);
context.Subjects.AddOrUpdate(s => s.SubjectID,
new Subject
{
SubjectName = "Algebra",
students = new List <Student> {
new Student {
FirstName = "Catherine", SecondName = "Janeway"
},
new Student {
FirstName = "Jean-Luc", SecondName = "Picard"
},
},
lecturers = new List <Lecturer> {
new Lecturer {
LecturerName = "Professor Snake"
}
}
}
);
context.Subjects.AddOrUpdate(s => s.SubjectID,
new Subject
{
SubjectName = "Trigonometry",
students = new List <Student> {
new Student {
FirstName = "Axl", SecondName = "Rose"
}
}
}
);
context.Subjects.AddOrUpdate(s => s.SubjectID,
new Subject
{
SubjectName = "Calculus"
}
);
}
