public ActionResult DeleteConfirmed(int id) { ExamAttendance examattendance = db.ExamAttendances.Find(id); db.ExamAttendances.Remove(examattendance); db.SaveChanges(); return RedirectToAction("Index"); }
public ActionResult Edit(ExamAttendance examattendance) { try { if (ModelState.IsValid) { ExamAttendance update = db.ExamAttendances.Where(t => t.Id == examattendance.Id).SingleOrDefault(); update.Present = examattendance.Present; db.Entry(update).State = EntityState.Modified; db.SaveChanges(); TempData["ok"] = "ok"; TempData["message"] = "<span class=\"color-green\">Successfully Saved!</span>"; return RedirectToAction("Index"); } return View(examattendance); } catch (Exception ex) { TempData["message"] = "<span class=\"color-red\">" + ex.Message + "</span>"; return RedirectToAction("Index"); } }
// GET: /ExamAttendence/Delete/5 public ActionResult Delete(int? id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } ExamAttendance examattendance = db.ExamAttendances.Find(id); if (examattendance == null) { return HttpNotFound(); } return View(examattendance); }
//public ActionResult Create(ExamAttendance examattendance) //{ // if (ModelState.IsValid) // { // examattendance.EntryBy = User.Identity.Name; // examattendance.EntryDate = DateTime.Now; // db.ExamAttendances.Add(examattendance); // db.SaveChanges(); // return RedirectToAction("Index"); // } // return View(examattendance); //} // GET: /ExamAttendence/Edit/5 public ActionResult Edit(int? id) { try{ ExamAttendance examattendance = db.ExamAttendances.Find(id); examattendance.StudentName = db.StudentInfoes.Find(examattendance.StudentId).StudentName; ViewBag.Class_Id = new SelectList(db.ClassInfoes.ToList(), "Id", "ClassName",examattendance.ClassId); ViewBag.Faculty_Id = new SelectList(db.FacultyInfoes.ToList(), "Id", "FacultyName",examattendance.FacultyId); ViewBag.Status = new SelectList(EditList(), "Id", "Text", examattendance.Present); return View(examattendance); } catch (Exception ex) { TempData["message"] = "<span class=\"color-red\">" + ex.Message + "</span>"; return RedirectToAction("Index"); } }
public ActionResult Create(View_Attendence model, string SubjectId) { //if isCheck On that mean its check try { if (model.ClassId > 0 && model.FacultyId > 0 && model.SubjectId > 0 && model.StuList.Count > 0) { foreach (var item in model.StuList) { ExamAttendance newObj = new ExamAttendance(); if (item.IsCheck == "on") { newObj.Present = "Y"; } else { newObj.Present = "N"; } newObj.ClassId = model.ClassId; newObj.EntryBy = User.Identity.Name; newObj.EntryDate = DateTime.Now; newObj.FacultyId = model.FacultyId; newObj.SubjectId = model.SubjectId; newObj.StudentId = item.StudentId; //first try to get duplicate if found the update else save ExamAttendance prvObj = db.ExamAttendances.Where(t => t.ClassId == model.ClassId && t.FacultyId == model.FacultyId && t.SubjectId == model.SubjectId && t.StudentId == item.StudentId).SingleOrDefault(); if (prvObj != null) { prvObj.Present = newObj.Present; db.Entry(prvObj).State = EntityState.Modified; } else { db.ExamAttendances.Add(newObj); } } db.SaveChanges(); TempData["ok"] = "ok"; TempData["message"] = "<span class=\"color-green\">Successfully Saved!</span>"; } else { TempData["ok"] = ""; ViewBag.Message = "<span class=\"color-red\">One more validation Error.</span>"; } } catch (Exception ex) { TempData["message"] = "<span class=\"color-red\">" + ex.InnerException.Message+ "</span>"; } return RedirectToAction("Index"); }