public IHttpActionResult Puttbl_Questions(long id, tbl_Questions tbl_Questions)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != tbl_Questions.QuestionID)
            {
                return(BadRequest());
            }

            db.Entry(tbl_Questions).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!tbl_QuestionsExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
Esempio n. 2
0
 public ActionResult UpdateQuiz(int quizid, tbl_Questions qs, string hid_qids, FormCollection coll)
 {
     using (OnlineQuizEntities oq = new OnlineQuizEntities())
     {
         ModelState.Clear();
     }
     return(RedirectToAction("AfterLogin"));
 }
        public IHttpActionResult Gettbl_Questions(long id)
        {
            tbl_Questions tbl_Questions = db.tbl_Questions.Find(id);

            if (tbl_Questions == null)
            {
                return(NotFound());
            }

            return(Ok(tbl_Questions));
        }
        public IHttpActionResult Posttbl_Questions(tbl_Questions tbl_Questions)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.tbl_Questions.Add(tbl_Questions);
            db.SaveChanges();

            return(CreatedAtRoute("DefaultApi", new { id = tbl_Questions.QuestionID }, tbl_Questions));
        }
        public IHttpActionResult Deletetbl_Questions(long id)
        {
            tbl_Questions tbl_Questions = db.tbl_Questions.Find(id);

            if (tbl_Questions == null)
            {
                return(NotFound());
            }

            db.tbl_Questions.Remove(tbl_Questions);
            db.SaveChanges();

            return(Ok(tbl_Questions));
        }
Esempio n. 6
0
        // 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));
        }
Esempio n. 7
0
 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"));
 }
Esempio n. 8
0
 public void PostItemResource(ItemResource item)
 {
     using (var context = new SurveyEntities())
     {
         tbl_Questions que = new tbl_Questions
         {
             itemScript  = item.questionScript,
             createdBy   = "Ravi",
             createdDate = System.DateTime.Now,
             state       = 1,
             status      = "live"
         };
         context.tbl_Questions.Add(que);
         context.SaveChanges();
     }
 }
Esempio n. 9
0
        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));
            }
        }
Esempio n. 10
0
 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"));
 }