public ActionResult Create([Bind(Include = "Id,SubjectID,ClassID,Title,Description,Date,TotalMarks,Weightage,TeacherID")] AspNetExam aspNetExam) { var dbTransection = db.Database.BeginTransaction(); try { if (ModelState.IsValid) { db.AspNetExams.Add(aspNetExam); db.SaveChanges(); int examID = db.AspNetExams.Max(item => item.Id); List <string> StudentIDs = db.AspNetStudent_Subject.Where(s => s.SubjectID == aspNetExam.SubjectID).Select(s => s.StudentID).ToList(); foreach (var item in StudentIDs) { AspNetStudent_Exam stu_exams = new AspNetStudent_Exam(); stu_exams.StudentID = item; stu_exams.ExamID = examID; db.AspNetStudent_Exam.Add(stu_exams); db.SaveChanges(); } } dbTransection.Commit(); } catch (Exception) { dbTransection.Dispose(); } return(RedirectToAction("Index")); ViewBag.ClassID = new SelectList(db.AspNetClasses, "Id", "ClassName"); ViewBag.SubjectID = new SelectList(db.AspNetSubjects.Where(s => s.TeacherID == TeacherID), "Id", "SubjectName"); ViewBag.TeacherID = new SelectList(db.AspNetUsers.Where(s => s.Id == TeacherID), "Id", "Name"); return(View(aspNetExam)); }
public ActionResult DeleteConfirmed(int id) { AspNetExam aspNetExam = db.AspNetExams.Find(id); db.AspNetExams.Remove(aspNetExam); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: AspNetExam/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetExam aspNetExam = db.AspNetExams.Find(id); if (aspNetExam == null) { return(HttpNotFound()); } return(View(aspNetExam)); }
public ActionResult Edit([Bind(Include = "Id,SubjectID,ClassID,Title,Description,Date,TotalMarks,Weightage,TeacherID")] AspNetExam aspNetExam) { if (ModelState.IsValid) { db.Entry(aspNetExam).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ClassID = new SelectList(db.AspNetClasses, "Id", "ClassName", aspNetExam.ClassID); ViewBag.SubjectID = new SelectList(db.AspNetSubjects.Where(s => s.TeacherID == TeacherID), "Id", "SubjectName", aspNetExam.SubjectID); ViewBag.TeacherID = new SelectList(db.AspNetUsers.Where(s => s.Id == TeacherID), "Id", "Name", aspNetExam.TeacherID); return(View(aspNetExam)); }
// GET: AspNetExam/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetExam aspNetExam = db.AspNetExams.Find(id); if (aspNetExam == null) { return(HttpNotFound()); } ViewBag.ClassID = new SelectList(db.AspNetClasses, "Id", "ClassName", aspNetExam.ClassID); ViewBag.SubjectID = new SelectList(db.AspNetSubjects.Where(s => s.TeacherID == TeacherID), "Id", "SubjectName", aspNetExam.SubjectID); ViewBag.TeacherID = new SelectList(db.AspNetUsers.Where(s => s.Id == TeacherID), "Id", "Name", aspNetExam.TeacherID); return(View(aspNetExam)); }