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()); }