public ActionResult Edit([Bind(Include = "SignIn,SignOut,session_sessionID,student_StudentID")] studentsession studentsession)
{
if (ModelState.IsValid)
{
db.Entry(studentsession).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.session_sessionID = new SelectList(db.sessions, "sessionID", "Date", studentsession.session_sessionID);
ViewBag.student_StudentID = new SelectList(db.students, "StudentID", "GivenName", studentsession.student_StudentID);
return(View(studentsession));
}
public ActionResult Create(string code)
{
if (ModelState.IsValid)
{
string studentID = "100100100";
session result = null;
bool check = false;
studentsession old = null;
DateTime now = DateTime.Now;
foreach (var item in db.sessions)
{
if (item.Code.Equals(code))
{
result = item;
}
}
foreach (var ss in db.studentsessions)
{
if (ss.student_StudentID.Equals(studentID) && ss.session_sessionID.Equals(result.sessionID))
{
check = true;
old = ss;
}
}
if (check)
{
if (old.SignOut.Equals(null))
{
old.SignOut = now.TimeOfDay;
db.Entry(old).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
else
{
studentsession record = new studentsession(studentID, result.sessionID, signIn: now.TimeOfDay);
db.studentsessions.Add(record);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View());
}