public ActionResult DeleteConfirmed(int id) { AspNetTest aspNetTest = db.AspNetTests.Find(id); db.AspNetTests.Remove(aspNetTest); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,SubjectID,ClassID,Title,Description,Date,TotalMarks,Weightage,TeacherID")] AspNetTest aspNetTest) { if (ModelState.IsValid) { db.Entry(aspNetTest).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ClassID = new SelectList(db.AspNetClasses, "Id", "ClassName", aspNetTest.ClassID); ViewBag.SubjectID = new SelectList(db.AspNetSubjects.Where(s => s.TeacherID == TeacherID), "Id", "SubjectName", aspNetTest.SubjectID); ViewBag.TeacherID = new SelectList(db.AspNetUsers.Where(s => s.Id == TeacherID), "Id", "Name", aspNetTest.TeacherID); return(View(aspNetTest)); }
// GET: AspNetTest/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetTest aspNetTest = db.AspNetTests.Find(id); if (aspNetTest == null) { return(HttpNotFound()); } return(View(aspNetTest)); }
// GET: AspNetTest/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetTest aspNetTest = db.AspNetTests.Find(id); if (aspNetTest == null) { return(HttpNotFound()); } ViewBag.ClassID = new SelectList(db.AspNetClasses, "Id", "ClassName", aspNetTest.ClassID); ViewBag.SubjectID = new SelectList(db.AspNetSubjects.Where(s => s.TeacherID == TeacherID), "Id", "SubjectName", aspNetTest.SubjectID); ViewBag.TeacherID = new SelectList(db.AspNetUsers.Where(s => s.Id == TeacherID), "Id", "Name", aspNetTest.TeacherID); return(View(aspNetTest)); }
public ActionResult Create([Bind(Include = "Id,SubjectID,ClassID,Title,Description,Date,TotalMarks,Weightage,TeacherID")] AspNetTest aspNetTest) { IEnumerable <string> topics = Request.Form["TopicID"].Split(','); if (ModelState.IsValid) { var dbTransaction = db.Database.BeginTransaction(); try { db.AspNetTests.Add(aspNetTest); db.SaveChanges(); int testID = db.AspNetTests.Max(item => item.Id); List <string> StudentIDs = db.AspNetStudent_Subject.Where(s => s.SubjectID == aspNetTest.SubjectID).Select(s => s.StudentID).ToList(); foreach (var item in StudentIDs) { AspNetStudent_Test stu_test = new AspNetStudent_Test(); stu_test.StudentID = item; stu_test.TestID = testID; db.AspNetStudent_Test.Add(stu_test); db.SaveChanges(); } foreach (var item in topics) { AspNetTest_Topic test_topic = new AspNetTest_Topic(); test_topic.TopicID = Convert.ToInt32(item); test_topic.TestID = testID; db.AspNetTest_Topic.Add(test_topic); db.SaveChanges(); } return(RedirectToAction("Index")); dbTransaction.Commit(); } catch (Exception) { dbTransaction.Dispose(); } } 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(aspNetTest)); }