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()); }
// GET: Teacher/Edit/5 public ActionResult Edit(int?session_sessionID, string student_StudentID) { if (student_StudentID == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } studentsession studentsession = db.studentsessions.Find(session_sessionID, student_StudentID); if (studentsession == null) { return(HttpNotFound()); } 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)); }
// GET: Teacher/Details/5 public ActionResult Details(int?session_sessionID, string student_StudentID) { if (student_StudentID == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } studentsession studentsession = db.studentsessions.Find(session_sessionID, student_StudentID); if (studentsession == null) { return(HttpNotFound()); } //studentsession data = db.studentsessions.Find(session_sessionID,student_StudentID); //if (data == null) //{ // return HttpNotFound(); //} //var groupedData = db.studentsessions.Where(s => s.student_StudentID == data.student_StudentID).ToList(); //return View(groupedData); //String connectionString = "Data Source=LAPTOP-I9V7HD8J\SQLEXPRESS01;Initial Catalog=TafeDB;Integrated Security=True;MultipleActiveResultSets=True;Application Name=EntityFramework"; //String sql = "SELECT * FROM students"; //System.Data.SqlClient.SqlCommand cmd = new SqlCommand(sql, connectionString); //using (System.Data.SqlClient.SqlConnection connectionString = new System.Data.SqlClient.SqlConnection(connectionString)) //{ // connectionString.Open(); // System.Data.SqlClient.SqlDataReader rdr = cmd.ExecuteReader(); //} //ViewData.Add("students", rdr); // String sql = "SELECT * FROM studentssession"; //ViewBag.session_sessionID = new SelectList(db.sessions, "sessionID", "Date"); //ViewBag.student_StudentID = new SelectList(db.students, "StudentID", "GivenName"); //return View(); ViewBag.Message = student_StudentID; var studentsessions = db.studentsessions.Include(s => s.session).Include(s => s.student); return(View(studentsessions)); }