public AttendanceController(StudyAdministrationContext context)
{
_context = context;
}
public StudentsController(StudyAdministrationContext context)
{
_context = context;
}
public static void Initialise(IServiceProvider serviceProvider)
{
// Grab the database context to add data to
using (var context = new StudyAdministrationContext(
serviceProvider.GetRequiredService <DbContextOptions <StudyAdministrationContext> >()))
{
// If there aren't any students add them
if (!context.Student.Any())
{
context.Student.AddRange(
new Student
{
OasisID = 123456,
Firstname = "Bobby",
Lastname = "Bob",
FinishYear = 2019
},
new Student
{
OasisID = 123457,
Firstname = "Jillian",
Lastname = "Jill",
FinishYear = 2019
},
new Student
{
OasisID = 123458,
Firstname = "Dong",
Lastname = "Wong",
FinishYear = 2019
},
new Student
{
OasisID = 123459,
Firstname = "Peter",
Lastname = "Pastor",
FinishYear = 2020
},
new Student
{
OasisID = 123461,
Firstname = "Broken",
Lastname = "Brian",
FinishYear = 2020
},
new Student
{
OasisID = 123462,
Firstname = "Nancy",
Lastname = "Thorn",
FinishYear = 2020
}
);
context.SaveChanges();
}
// If there aren't any subjects add them
if (!context.Subject.Any())
{
context.Subject.AddRange(
new Subject
{
Position = 1,
Name = "English"
},
new Subject
{
Position = 2,
Name = "Maths"
},
new Subject
{
Position = 3,
Name = "Science"
},
new Subject
{
Position = 4,
Name = "HSIE"
},
new Subject
{
Position = 5,
Name = "PDHPE"
},
new Subject
{
Position = 6,
Name = "CAPA"
},
new Subject
{
Position = 7,
Name = "TAS"
},
new Subject
{
Position = 8,
Name = "Computing"
}
);
context.SaveChanges();
}
// If there isn't any attendance data, add it in
if (!context.Attendance.Any())
{
context.Attendance.AddRange(
new Attendance
{
StudentID = 1,
SubjectID = 1,
DateTime = new DateTime(2018, 8, 24, 9, 40, 0, 0)
},
new Attendance
{
StudentID = 2,
SubjectID = 1,
DateTime = new DateTime(2018, 8, 24, 9, 40, 30, 0)
},
new Attendance
{
StudentID = 3,
SubjectID = 1,
DateTime = new DateTime(2018, 8, 24, 9, 41, 0, 0)
},
new Attendance
{
StudentID = 4,
SubjectID = 1,
DateTime = new DateTime(2018, 8, 24, 9, 42, 0, 0)
},
new Attendance
{
StudentID = 1,
SubjectID = 2,
DateTime = new DateTime(2018, 8, 23, 12, 10, 0, 0)
},
new Attendance
{
StudentID = 2,
SubjectID = 3,
DateTime = new DateTime(2018, 8, 23, 12, 12, 0, 0)
},
new Attendance
{
StudentID = 3,
SubjectID = 4,
DateTime = new DateTime(2018, 8, 23, 12, 20, 0, 0)
}
);
}
context.SaveChanges();
}
}
