public ActionResult Edit(AspnetQuiz aspnetQuiz) { if (ModelState.IsValid) { AspnetQuiz quiz = db.AspnetQuizs.Where(x => x.Id == aspnetQuiz.Id).FirstOrDefault(); quiz.Name = aspnetQuiz.Name; quiz.Description = aspnetQuiz.Description; quiz.Start_Date = aspnetQuiz.Start_Date; quiz.Due_Date = aspnetQuiz.Due_Date; db.SaveChanges(); if (Request.Form["QuestionID"] != null) { string[] QuestionIDs = Request.Form["QuestionID"].Split(','); List <Quiz_Topic_Questions> QuizTopicQuestionsToRemove = db.Quiz_Topic_Questions.Where(x => x.QuizId == aspnetQuiz.Id).ToList(); db.Quiz_Topic_Questions.RemoveRange(QuizTopicQuestionsToRemove); db.SaveChanges(); foreach (var a in QuestionIDs) { int Questionid = Convert.ToInt32(a); int SubjectTopicId = db.AspnetQuestions.Where(x => x.Id == Questionid).Select(x => x.AspnetLesson).Select(x => x.AspnetSubjectTopic.Id).FirstOrDefault(); Quiz_Topic_Questions QuizTopicQuestions = new Quiz_Topic_Questions(); QuizTopicQuestions.QuestionId = Questionid; QuizTopicQuestions.QuizId = aspnetQuiz.Id; QuizTopicQuestions.TopicId = SubjectTopicId; db.Quiz_Topic_Questions.Add(QuizTopicQuestions); db.SaveChanges(); } } } return(RedirectToAction("ViewQuestionAndQuiz", "AspnetQuestions")); }
public ActionResult Create(AspnetQuiz aspnetQuiz) { var id = User.Identity.GetUserId(); var username = db.AspNetUsers.Where(x => x.Id == id).Select(x => x.Name).FirstOrDefault(); aspnetQuiz.CreationDate = DateTime.Now; aspnetQuiz.Created_By = username; db.AspnetQuizs.Add(aspnetQuiz); db.SaveChanges(); string[] QuestionIDs = Request.Form["QuestionID"].Split(','); foreach (var a in QuestionIDs) { int Questionid = Convert.ToInt32(a); int SubjectTopicId = db.AspnetQuestions.Where(x => x.Id == Questionid).Select(x => x.AspnetLesson).Select(x => x.AspnetSubjectTopic.Id).FirstOrDefault(); Quiz_Topic_Questions QuizTopicQuestions = new Quiz_Topic_Questions(); QuizTopicQuestions.QuestionId = Questionid; QuizTopicQuestions.QuizId = aspnetQuiz.Id; QuizTopicQuestions.TopicId = SubjectTopicId; db.Quiz_Topic_Questions.Add(QuizTopicQuestions); db.SaveChanges(); } return(RedirectToAction("ViewQuestionAndQuiz", "AspnetQuestions")); }