public async Task <ActionResult> Create([Bind(Include = "InvigilationId,UserId,ExamId")] Invigilation invigilation) { if (ModelState.IsValid) { //we do a check to avoid duplicates Invigilation compare = (from i in db.Invigilations where invigilation.ExamId == i.ExamId && invigilation.UserId == i.UserId select i).SingleOrDefault(); if (compare != null) { return(RedirectToAction("ExamManager", "Clerk")); } db.Invigilations.Add(invigilation); await db.SaveChangesAsync(); return(RedirectToAction("ExamManager", "Clerk")); } IEnumerable <ExamSession> exam = new List <ExamSession>(from e in db.ExamSessions where e.ExamId == invigilation.ExamId select e); List <ApplicationUser> invigilators = new List <ApplicationUser>(from u in db.Users where u.Role == "Invigilator" select u); ViewBag.UserId = new SelectList(invigilators, "Id", "FirstName", invigilation.UserId); ViewBag.ExamId = new SelectList(exam, "ExamId", "SubjectId"); return(View(invigilation)); }
public async Task <ActionResult> DeleteConfirmed(int id) { Invigilation invigilation = await db.Invigilations.FindAsync(id); db.Invigilations.Remove(invigilation); await db.SaveChangesAsync(); return(RedirectToAction("ExamManager", "Clerk")); }
public async Task <ActionResult> Edit([Bind(Include = "InvigilationId,UserId,ExamId")] Invigilation invigilation) { if (ModelState.IsValid) { db.Entry(invigilation).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.ExamId = new SelectList(db.ExamSessions, "ExamId", "SubjectId", invigilation.ExamId); ViewBag.UserId = new SelectList(db.Users, "Id", "FirstName", invigilation.UserId); return(View(invigilation)); }
public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Invigilation invigilation = await db.Invigilations.FindAsync(id); if (invigilation == null) { return(HttpNotFound()); } return(View(invigilation)); }
public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Invigilation invigilation = await db.Invigilations.FindAsync(id); if (invigilation == null) { return(HttpNotFound()); } ViewBag.ExamId = new SelectList(db.ExamSessions, "ExamId", "SubjectId", invigilation.ExamId); ViewBag.UserId = new SelectList(db.Users, "Id", "FirstName", invigilation.UserId); return(View(invigilation)); }