public ActionResult Addquestion(TBL_QUESTIONS q) { int sid = Convert.ToInt32(Session["ad_id"]); List <tbl_categroy> li = db.tbl_categroy.Where(x => x.cat_fk_adid == sid).ToList(); ViewBag.list = new SelectList(li, "cat_id", "cat_name"); TBL_QUESTIONS QA = new TBL_QUESTIONS(); QA.Q_TEXT = q.Q_TEXT; QA.OPA = q.OPA; QA.OPB = q.OPB; QA.OPC = q.OPC; QA.OPD = q.OPD; QA.COP = q.COP; QA.q_fk_catid = q.q_fk_catid; db.TBL_QUESTIONS.Add(QA); db.SaveChanges(); TempData["msg"] = "Question added successfully...."; TempData.Keep(); return(RedirectToAction("Addquestion")); }
public ActionResult AddQuestion(TBL_QUESTIONS queGet) { List <TBL_CATEGORY> list = db.TBL_CATEGORY.ToList(); ViewBag.List = new SelectList(list, "CAT_ID", "CAT_NAME"); TBL_QUESTIONS queVar = new TBL_QUESTIONS(); queVar.Q_TEXT = queGet.Q_TEXT; queVar.OPA = queGet.OPA; queVar.OPB = queGet.OPB; queVar.OPC = queGet.OPC; queVar.OPD = queGet.OPD; queVar.COP = queGet.COP; queVar.Q_FK_CATID = queGet.Q_FK_CATID; db.TBL_QUESTIONS.Add(queVar); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult QuizStart() { if (Session["std_id"] == null) { return(RedirectToAction("slogin")); } TBL_QUESTIONS q = null; if (TempData["questions"] != null) { Queue <TBL_QUESTIONS> qlist = (Queue <TBL_QUESTIONS>)TempData["questions"]; if (qlist.Count > 0) { q = qlist.Peek(); qlist.Dequeue(); TempData["questions"] = qlist; TempData.Keep(); } else { return(RedirectToAction("EndExam")); } } else { return(RedirectToAction("StudentExam")); } return(View()); }
public ActionResult Addquestion(TBL_QUESTIONS q) { try { int sid = Convert.ToInt32(Session["AD_ID"]); List <TBL_CATEGORY> li = db.TBL_CATEGORY.Where(x => x.CAT_FK_ADID == sid).ToList(); ViewBag.list = new SelectList(li, "CAT_ID", "CAT_NAME"); TBL_QUESTIONS QA = new TBL_QUESTIONS(); QA.Q_TEXT = q.Q_TEXT; QA.OPA = q.OPA; QA.OPB = q.OPB; QA.OPC = q.OPC; QA.OPD = q.OPD; QA.COP = q.COP; QA.Q_FK_CATID = q.Q_FK_CATID; db.TBL_QUESTIONS.Add(QA); db.SaveChanges(); TempData["msg"] = "Question has been added successfully!"; TempData.Keep(); return(RedirectToAction("Addquestion")); } catch (Exception) { return(RedirectToAction("Addquestion")); } }
public ActionResult AddQuestion(TBL_QUESTIONS questions) { try { int sid = Convert.ToInt32(Session["AD_ID"]); List <TBL_CATEGORY> li = db.TBL_CATEGORY.Where(x => x.CAT_FK_ADMIN_ID == sid).ToList(); ViewBag.list = new SelectList(li, "CAT_ID", "CAT_NAME"); TBL_QUESTIONS QA = new TBL_QUESTIONS(); QA.Q_TEXT = questions.Q_TEXT; QA.OPA = questions.OPA; QA.OPB = questions.OPB; QA.OPC = questions.OPC; QA.OPD = questions.OPD; QA.COP = questions.COP; QA.QUESTION_FK_CATID = questions.QUESTION_FK_CATID; db.TBL_QUESTIONS.Add(QA); db.SaveChanges(); TempData["msg"] = "Question Added Successfully....."; } catch (Exception) { TempData["msg"] = "You are entering same question again...please enter different question."; } return(RedirectToAction("AddQuestion")); }
public ActionResult EditQuestion(TBL_QUESTIONS qGet) { List <TBL_CATEGORY> list = db.TBL_CATEGORY.ToList(); ViewBag.List = new SelectList(list, "CAT_ID", "CAT_NAME"); var qList = db.TBL_QUESTIONS.Where(model => model.QUESTION_ID == qGet.QUESTION_ID).FirstOrDefault(); qList.Q_FK_CATID = qGet.Q_FK_CATID; qList.Q_TEXT = qGet.Q_TEXT; qList.OPA = qGet.OPA; qList.OPB = qGet.OPB; qList.OPC = qGet.OPC; qList.OPD = qGet.OPD; qList.COP = qGet.COP; db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult QuizStart(TBL_QUESTIONS q) { string correctans = null; if (q.OPA != null) { correctans = "A"; } else if (q.OPB != null) { correctans = "B"; } else if (q.OPC != null) { correctans = "C"; } else if (q.OPD != null) { correctans = "D"; } if (correctans.Equals(q.COP)) { TempData["score"] = Convert.ToInt32(TempData["score"]) + 1; } TempData.Keep(); return(RedirectToAction("QuizStart")); }
public ActionResult DeleteConfirmed(int?id) { TBL_QUESTIONS questions = db.TBL_QUESTIONS.Find(id); db.TBL_QUESTIONS.Remove(questions); db.SaveChanges(); return(RedirectToAction("ViewAllQuestions")); }
public ActionResult QuizStart() { if (Session["STD_ID"] == null) { return(RedirectToAction("slogin")); } TBL_QUESTIONS q = null; if (TempData["questions"] != null) { Queue <TBL_QUESTIONS> qlist = (Queue <TBL_QUESTIONS>)TempData["questions"]; if (qlist.Count > 0) { q = qlist.Peek(); qlist.Dequeue(); TempData["questions"] = qlist; TempData.Keep(); } else { return(RedirectToAction("EndExam")); } } else { return(RedirectToAction("StudentExam")); } return(View(q)); //if (Session["STD_ID"] == null) //{ // return RedirectToAction("slogin"); //} //try //{ // TBL_QUESTIONS q = null; // int examid = Convert.ToInt32(TempData["examid"].ToString()); // if (TempData["qid"] == null) // { // q = db.TBL_QUESTIONS.First(x => x.Q_FK_CATID == examid); // TempData["qid"] = ++q.QUESTION_ID; // } // else // { // int qid = Convert.ToInt32(TempData["qid"].ToString()); // q = db.TBL_QUESTIONS.Where(x => x.QUESTION_ID == qid && x.Q_FK_CATID == examid).SingleOrDefault(); // TempData["qid"] = ++q.QUESTION_ID; // } // TempData.Keep(); // return View(q); //} //catch (Exception) //{ // return RedirectToAction("EndExam"); //} }
public ActionResult DelQuestion(int id) { TBL_QUESTIONS _id = db.TBL_QUESTIONS.Find(id); db.TBL_QUESTIONS.Remove(_id); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Delete(int?id) { TBL_QUESTIONS getquestion = db.TBL_QUESTIONS.Find(id); if (getquestion == null) { return(HttpNotFound()); } return(View(getquestion)); }
public ActionResult Edit(int?id) { TBL_QUESTIONS questions = db.TBL_QUESTIONS.Find(id); if (questions == null) { return(HttpNotFound()); } return(View(questions)); }
public ActionResult Edit(TBL_QUESTIONS questions) { //int sid = Convert.ToInt32(Session["AD_ID"]); // List<TBL_CATEGORY> li = db.TBL_CATEGORY.Where(x => x.CAT_FK_ADMIN_ID == sid).ToList(); //ViewBag.list = new SelectList(li); if (ModelState.IsValid) { db.Entry(questions).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("ViewAllQuestions")); } return(View(questions)); }
//posting a question public IHttpActionResult PostQuestion(Questions tquestion) { TBL_QUESTIONS tbObj = new TBL_QUESTIONS(); if (ModelState.IsValid) { tbObj.QID = Guid.NewGuid(); tbObj.QUESTION = tquestion.QUESTION; tbObj.USERNAME = tquestion.USERNAME; tbObj.TIMESTAMP = DateTime.Now; dbObj.TBL_QUESTIONS.Add(tbObj); var user = dbObj.TBL_SIGNUP.ToList().Find(x => x.USERNAME == tquestion.USERNAME); user.POINTS += 2; dbObj.SaveChanges(); return(Ok()); } ModelState.Clear(); return(BadRequest()); }
public ActionResult QuizStart() { if (TempData["i"] == null) { TempData["i"] = 1; } if (Session["std_id"] == null) { return(RedirectToAction("slogin")); } try { TBL_QUESTIONS q = null; int examid = Convert.ToInt32(TempData["exampid"].ToString()); if (TempData["qid"] == null) { q = db.TBL_QUESTIONS.First(x => x.q_fk_catid == examid); var list = db.TBL_QUESTIONS.Skip(Convert.ToInt32(TempData["i"].ToString())); int qid = list.First().QUESTION_ID; TempData["qid"] = qid; } else { int qid = Convert.ToInt32(TempData["qid"].ToString()); q = db.TBL_QUESTIONS.Where(x => x.QUESTION_ID == qid && x.q_fk_catid == examid).SingleOrDefault(); var list = db.TBL_QUESTIONS.Skip(Convert.ToInt32(TempData["i"].ToString())); qid = list.First().QUESTION_ID; TempData["qid"] = qid; TempData["i"] = Convert.ToInt32(TempData["i"].ToString()) + 1; } TempData.Keep(); return(View(q)); } catch (Exception) { return(RedirectToAction("StudentExam")); } }
public ActionResult QuizStart(TBL_QUESTIONS q) { return(RedirectToAction("QuizStart")); }