public async Task <IActionResult> Edit([Bind("SurveyNo,QtCode,QtType,QtText,QtBody,QtScript,UseQuotaBl,NextQuestion,EndCode,Exclude,Include,Detailorder")] TblQuestion tblQuestion)
        {
            if (tblQuestion.SurveyNo == 0)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(tblQuestion);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!TblQuestionExists(tblQuestion.SurveyNo))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index), new { surveyno = tblQuestion.SurveyNo }));
            }
            ViewData["SurveyNo"] = new SelectList(_context.TblSurvey, "SurveyNo", "SmsMessage", tblQuestion.SurveyNo);
            return(View(tblQuestion));
        }
        public IActionResult createExam(TeacherDetailModel teacherDetailModel)
        {
            TblExam tblExam = new TblExam();

            tblExam.ExamDate     = DateTime.Now.ToLongDateString();
            tblExam.ArticleId    = teacherDetailModel.tblArticle.Id;
            tblExam.ArticleTitle = teacherDetailModel.tblArticle.ArticleTitle;
            tblExam.Status       = true;

            db.TblExams.Add(tblExam);
            db.SaveChanges();

            var exam = db.TblExams.OrderByDescending(u => u.Id).FirstOrDefault();

            TblQuestion question = new TblQuestion();

            question.Status = true;
            question.ExamId = exam.Id;


            question.Question1Text  = teacherDetailModel.question.Question1Text;
            question.Option1A       = teacherDetailModel.question.Option1A;
            question.Option1B       = teacherDetailModel.question.Option1B;
            question.Option1C       = teacherDetailModel.question.Option1C;
            question.Option1D       = teacherDetailModel.question.Option1D;
            question.CorrectAnswer1 = teacherDetailModel.question.CorrectAnswer1;


            question.Question2Text  = teacherDetailModel.question.Question2Text;
            question.Option2A       = teacherDetailModel.question.Option2A;
            question.Option2B       = teacherDetailModel.question.Option2B;
            question.Option2C       = teacherDetailModel.question.Option2C;
            question.Option2D       = teacherDetailModel.question.Option2D;
            question.CorrectAnswer2 = teacherDetailModel.question.CorrectAnswer2;


            question.Question3Text  = teacherDetailModel.question.Question3Text;
            question.Option3A       = teacherDetailModel.question.Option3A;
            question.Option3B       = teacherDetailModel.question.Option3B;
            question.Option3C       = teacherDetailModel.question.Option3C;
            question.Option3D       = teacherDetailModel.question.Option3D;
            question.CorrectAnswer3 = teacherDetailModel.question.CorrectAnswer3;


            question.Question4Text  = teacherDetailModel.question.Question4Text;
            question.Option4A       = teacherDetailModel.question.Option4A;
            question.Option4B       = teacherDetailModel.question.Option4B;
            question.Option4C       = teacherDetailModel.question.Option4C;
            question.Option4D       = teacherDetailModel.question.Option4D;
            question.CorrectAnswer4 = teacherDetailModel.question.CorrectAnswer4;

            db.TblQuestions.Add(question);
            db.SaveChanges();

            return(RedirectToAction("detail"));
        }
        public async Task <IActionResult> Create([Bind("SurveyNo,QtCode,QtType,QtText,QtBody,QtScript,UseQuotaBl,NextQuestion,EndCode,Exclude,Include,Detailorder")] TblQuestion tblQuestion)
        {
            if (ModelState.IsValid)
            {
                _context.Add(tblQuestion);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            ViewData["SurveyNo"] = new SelectList(_context.TblSurvey, "SurveyNo", "SmsMessage", tblQuestion.SurveyNo);
            return(View(tblQuestion));
        }
        public int GetQuestionID(string questionText)
        {
            List <TblQuestion> questions = GetAllQuestions();

            TblQuestion selectedQuestion = new TblQuestion();

            foreach (TblQuestion question in questions)
            {
                if (question.FldQuestionText.Equals(questionText))
                {
                    selectedQuestion = question;
                    break;
                }
            }
            return(selectedQuestion.FldQuestionId);
        }
        public IActionResult creatQuestion(TblQuestion tblQuestion)
        {
            TblQuestion question = new TblQuestion();

            question.Status = true;

            question.Question1Text  = tblQuestion.Question1Text;
            question.Option1A       = tblQuestion.Option1A;
            question.Option1B       = tblQuestion.Option1B;
            question.Option1C       = tblQuestion.Option1C;
            question.Option1D       = tblQuestion.Option1D;
            question.CorrectAnswer1 = tblQuestion.CorrectAnswer1;


            question.Question2Text  = tblQuestion.Question2Text;
            question.Option2A       = tblQuestion.Option2A;
            question.Option2B       = tblQuestion.Option2B;
            question.Option2C       = tblQuestion.Option2C;
            question.Option2D       = tblQuestion.Option2D;
            question.CorrectAnswer2 = tblQuestion.CorrectAnswer2;


            question.Question3Text  = tblQuestion.Question3Text;
            question.Option3A       = tblQuestion.Option3A;
            question.Option3B       = tblQuestion.Option3B;
            question.Option3C       = tblQuestion.Option3C;
            question.Option3D       = tblQuestion.Option3D;
            question.CorrectAnswer3 = tblQuestion.CorrectAnswer3;


            question.Question4Text  = tblQuestion.Question4Text;
            question.Option4A       = tblQuestion.Option4A;
            question.Option4B       = tblQuestion.Option4B;
            question.Option4C       = tblQuestion.Option4C;
            question.Option4D       = tblQuestion.Option4D;
            question.CorrectAnswer4 = tblQuestion.CorrectAnswer4;

            db.TblQuestions.Add(tblQuestion);
            db.SaveChanges();

            return(RedirectToAction("detail"));
        }