public bool UpdateQuizPost(int quizid, string hid_qids) { using (OnlineQuizEntities oq = new OnlineQuizEntities()) { if (hid_qids == null || hid_qids == "") { return(false); } var quizrel = oq.tbl_QuizQuestionRelation.ToList(); foreach (var item in quizrel) { if (item.QuizId == quizid) { oq.tbl_QuizQuestionRelation.Remove(item); oq.SaveChanges(); } } foreach (var qids in hid_qids.Split(',')) { tbl_QuizQuestionRelation qq = new tbl_QuizQuestionRelation(); qq.QuestionId = Convert.ToInt32(qids); qq.QuizId = quizid; oq.tbl_QuizQuestionRelation.Add(qq); oq.SaveChanges(); } ModelState.Clear(); } return(true); }
public ActionResult CreateQuiz(tbl_Quiz q, string hid_questions) { if (ModelState.IsValid) { using (OnlineQuizEntities oq = new OnlineQuizEntities()) { oq.tbl_Quiz.Add(q); oq.SaveChanges(); if (hid_questions != "") { foreach (string questionid in hid_questions.Split(',')) { tbl_QuizQuestionRelation qq = new tbl_QuizQuestionRelation(); qq.QuestionId = Convert.ToInt32(questionid); qq.QuizId = q.QuizId; oq.tbl_QuizQuestionRelation.Add(qq); oq.SaveChanges(); } } ModelState.Clear(); var questionsdata = oq.tbl_Questions.ToList(); ViewBag.Questions = questionsdata; ViewBag.Message = "Successfully created"; } return(View("Create")); } using (OnlineQuizEntities oq = new OnlineQuizEntities()) { ViewBag.Questions = oq.tbl_Questions.ToList(); } ViewBag.Message = "Please provide all the values"; return(View("Create")); }
public ActionResult UpdateQuiz(int quizid, tbl_Questions qs, string hid_qids) { using (OnlineQuizEntities oq = new OnlineQuizEntities()) { if (hid_qids == null) { hid_qids = "1,3"; } foreach (var qids in hid_qids.Split(',')) { tbl_QuizQuestionRelation qq = new tbl_QuizQuestionRelation(); qq.QuestionId = Convert.ToInt32(qids); qq.QuizId = quizid; oq.tbl_QuizQuestionRelation.Add(qq); oq.SaveChanges(); } ModelState.Clear(); } return(RedirectToAction("AfterLogin")); }
public ActionResult CreateQuiz(tbl_Quiz q, string hid_questions) { using (OnlineQuizEntities oq = new OnlineQuizEntities()) { oq.tbl_Quiz.Add(q); oq.SaveChanges(); foreach (string questionid in hid_questions.Split(',')) { tbl_QuizQuestionRelation qq = new tbl_QuizQuestionRelation(); qq.QuestionId = Convert.ToInt32(questionid); qq.QuizId = q.QuizId; oq.tbl_QuizQuestionRelation.Add(qq); oq.SaveChanges(); } ModelState.Clear(); var questionsdata = oq.tbl_Questions.ToList(); ViewBag.Questions = questionsdata; } return(View("Create")); }