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, FormCollection coll)
{
using (OnlineQuizEntities oq = new OnlineQuizEntities())
{
ModelState.Clear();
}
return(RedirectToAction("AfterLogin"));
}
public ActionResult Create()
{
using (OnlineQuizEntities oq = new OnlineQuizEntities())
{
var questionsdata = oq.tbl_Questions.ToList();
ViewBag.Questions = questionsdata;
}
return(View());
}
// GET: Quiz
public ActionResult Index(tbl_Questions q, tbl_Quiz qq, QuizQuestions qqq, string QuizId)
{
QuizQuestions qqs = new QuizQuestions();
if (QuizId != null && QuizId != "")
{
//qqs = ViewBag.Quiz;
using (OnlineQuizEntities oq = new OnlineQuizEntities())
{
if (TempData["quizdrpdwn"] as QuizQuestions == null)
{
var quizdata = oq.tbl_Quiz.ToList();
foreach (var item in quizdata)
{
qqs.QuizList.Add(new SelectListItem {
Text = item.QuizName, Value = item.QuizId.ToString()
});
}
TempData["quizdrpdwn"] = qq;
}
else
{
qqs = TempData["quizdrpdwn"] as QuizQuestions;
}
var allqs = oq.tbl_Questions.ToList();
var allquizqu = oq.tbl_QuizQuestionRelation.ToList();
var quizqus = allquizqu.Where(a => a.QuizId == Convert.ToInt32(QuizId)).ToList();
List <tbl_Questions> actualqs = new List <tbl_Questions>();
allqs.Intersect <tbl_Questions>(allqs);
var resp = from a in allqs
join b in quizqus on a.QuestionId equals b.QuestionId
select a;
foreach (var item in resp)
{
actualqs.Add(item);
}
ViewBag.AllQuestions = actualqs;
}
return(View("Quiz", qqs));
}
return(View("Quiz", qqs));
}
public ActionResult Create(tbl_Questions q)
{
//if (ModelState.IsValid)
//{
using (OnlineQuizEntities oq = new OnlineQuizEntities())
{
q.IsMultipleChoise = true;
oq.tbl_Questions.Add(q);
oq.SaveChanges();
}
ModelState.Clear();
ViewBag.Message = "Question Added Successfully";
//}
return(View("Create"));
}
public ActionResult Edit(int quizid)
{
if (Session["LoggedUserID"] != null)
{
using (OnlineQuizEntities dc = new OnlineQuizEntities())
{
var quizdata = dc.tbl_Quiz.ToList();
var quiz = quizdata.Where(a => a.QuizId == quizid).ToList();
var quizrelation = dc.tbl_QuizQuestionRelation.ToList();
var qzrlz = quizrelation.Where(a => a.QuizId == quizid).ToList();
IList <tbl_Questions> questionsdata = dc.tbl_Questions.ToList();
//IList<tbl_Questions> qs = new List<tbl_Questions>();
//foreach (var item in qzrlz)
//{
// qs.Add(questionsdata.Where(a => a.QuestionId == item.QuestionId).FirstOrDefault());
//}
foreach (var item in questionsdata)
{
int count = qzrlz.Where(a => a.QuestionId == item.QuestionId).Count();
if (count > 0)
{
item.IsQuizQuestion = true;
}
else
{
item.IsQuizQuestion = false;
}
}
ViewBag.AllQuestions = questionsdata;
//var isq = qs.Where(a => a.QuestionId == 1).ToList().Count();
//ViewBag.Questions = qs;
ViewBag.QuizData = quiz;
ViewBag.AllQuiz = quizdata;
return(View());
}
}
else
{
return(RedirectToAction("Index"));
}
}
public ActionResult Login(tbl_Users u)
{
if (ModelState.IsValid)
{
using (OnlineQuizEntities dc = new OnlineQuizEntities())
{
var result = dc.tbl_Users.Where(a => a.UserName.Equals(u.UserName) && a.Password.Equals(u.Password)).FirstOrDefault();
if (result != null)
{
Session["LoggedUserID"] = result.UserId.ToString();
Session["LoggedUserName"] = result.UserName.ToString();
return(RedirectToAction("AfterLogin"));
}
}
}
return(View(u));
}
public ActionResult afterLogin()
{
if (Session["LoggedUserID"] != null)
{
using (OnlineQuizEntities dc = new OnlineQuizEntities())
{
var quizdata = dc.tbl_Quiz.ToList();
var questionsdata = dc.tbl_Questions.ToList();
ViewBag.Questions = questionsdata;
ViewBag.QuizData = quizdata;
return(View());
}
}
else
{
return(RedirectToAction("Index"));
}
}
public ActionResult Quiz()
{
using (OnlineQuizEntities oq = new OnlineQuizEntities())
{
var quiz = oq.tbl_Quiz.ToList();
var allquestions = oq.tbl_Questions.ToList();
QuizQuestions qq = new QuizQuestions();
foreach (var item in quiz)
{
qq.QuizList.Add(new SelectListItem {
Text = item.QuizName, Value = item.QuizId.ToString()
});
}
ViewBag.AllQuestions = allquestions;
ViewBag.Quiz = qq;
return(View(qq));
}
}
public ActionResult Create(tbl_Questions q)
{
if (ModelState.IsValid)
{
using (OnlineQuizEntities oq = new OnlineQuizEntities())
{
oq.tbl_Questions.Add(q);
oq.SaveChanges();
ModelState.Clear();
ViewBag.Message = "Question Added Successfully";
return(View("Create"));
}
}
else
{
ViewBag.Message = "Please provide all the values";
return(View(q));
}
}
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"));
}
