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));
}
