public ActionResult Create([Bind(Include = "StudentID,FirstName,SecondName")] Student student)
{
if (ModelState.IsValid)
{
db.Students.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student));
}
public ActionResult Create([Bind(Include = "SubjectID,SubjectName")] Subject subject)
{
if (ModelState.IsValid)
{
db.Subjects.Add(subject);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(subject));
}
public ActionResult Create([Bind(Include = "LecturerID,LecturerName")] Lecturer lecturer)
{
if (ModelState.IsValid)
{
db.Lecturers.Add(lecturer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(lecturer));
}
public ActionResult Create([Bind(Include = "AttendanceID,AttendanceDate,SubjectID,StudentID,Present")] Attendance attendance)
{
if (ModelState.IsValid)
{
db.Attendances.Add(attendance);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.StudentID = new SelectList(db.Students, "StudentID", "FirstName", attendance.StudentID);
ViewBag.SubjectID = new SelectList(db.Subjects, "SubjectID", "SubjectName", attendance.SubjectID);
return(View(attendance));
}
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();
}
}
