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