Exemplo n.º 1
0
        /// <summary>
        /// 
        /// </summary>
        /// <param name="theAnswer"></param>
        public void CreateAnswer(AnswerData theAnswer)
        {
            theAnswer.Id = NextId;

            if (DataReader != null)
                DataReader.Close();

            SQL = "INSERT INTO `answers` (`answer_id`, `text`, `is_correct`) VALUES (\"" +
                theAnswer.Id +
                "\", \"" +
                theAnswer.Text +
                "\", \"" +
                theAnswer.Correct +
                "\");";

            InitializeCommand();
            OpenConnection();

            int result = ExecuteStoredProcedure();

            CloseConnection();

            if (result == 0)
                throw new Exception("Could not add the answer to the database");
        }
Exemplo n.º 2
0
        public static void GetQuestions(QuizData quiz)
        {
            //TODO replace code to get questions from database

            quiz.questions.Clear();

            QuestionData newQuestion = new QuestionData(0);
            AnswerData correctAnswer = new AnswerData(0);
            AnswerData wrongAnswer = new AnswerData(0);
            correctAnswer.Correct = true;
            correctAnswer.Text = "This is the correct answer";
            wrongAnswer.Text = "This is a wrong answer";

            newQuestion.Text = "This is a question";

            newQuestion.answers.Add(correctAnswer);
            newQuestion.answers.Add(wrongAnswer);
            newQuestion.answers.Add(wrongAnswer);
            newQuestion.answers.Add(wrongAnswer);

            for (int i = 0; i < 10; i++)
            {
                quiz.questions.Add(newQuestion);
            }
        }
Exemplo n.º 3
0
 public void AddAnswer(AnswerData answerIn)
 {
     answers_internal.Add(answerIn);
 }
Exemplo n.º 4
0
 public void AddAnswer(AnswerData answerIn)
 {
     answers_internal.Add(answerIn);
 }
Exemplo n.º 5
0
        /// <summary>
        /// handles ok button click event.
        /// Updates external reference if question is valid
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnOK_Click(object sender, EventArgs e)
        {
            //validate question
            if (txtQuestion.Text == "")
            {
                MessageBox.Show("Question does not have text!", "Invalid Question");
            }
            //validate answers
            else if ( (txtAnswer1.Text == "") ||
                 (txtAnswer2.Text == "") ||
                 (txtAnswer3.Text == "") ||
                 (txtAnswer4.Text == "") )
            {
                MessageBox.Show("All answers must have text!", "Invalid Question");
            }
            else if ((rbtn1.Checked == false) &&
                      (rbtn2.Checked == false) &&
                      (rbtn3.Checked == false) &&
                      (rbtn4.Checked == false))
            {
                MessageBox.Show("No correct answer has been selected!", "Invalid Question");
            }
            else
            {
                //are we creating a new question or updating an old one?
                if (isNewQuestion) //new question
                {

                    externalQuestion.Text = txtQuestion.Text;
                    AnswerData answer;

                    answer = new AnswerData(0);
                    answer.Text = txtAnswer1.Text;
                    answer.Correct = rbtn1.Checked;
                    externalQuestion.AddAnswer(answer);

                    answer = new AnswerData(0);
                    answer.Text = txtAnswer2.Text;
                    answer.Correct = rbtn2.Checked;
                    externalQuestion.AddAnswer(answer);

                    answer = new AnswerData(0);
                    answer.Text = txtAnswer3.Text;
                    answer.Correct = rbtn3.Checked;
                    externalQuestion.AddAnswer(answer);

                    answer = new AnswerData(0);
                    answer.Text = txtAnswer4.Text;
                    answer.Correct = rbtn4.Checked;
                    externalQuestion.AddAnswer(answer);

                    this.Disposed -= frmQuestion_Disposed;
                    this.Dispose();
                }
                //change the old question
                else
                {
                    externalQuestion.Text = txtQuestion.Text;
                    externalQuestion.Answers[0].Text = txtAnswer1.Text;
                    externalQuestion.Answers[0].Correct = rbtn1.Checked;
                    externalQuestion.Answers[1].Text = txtAnswer2.Text;
                    externalQuestion.Answers[1].Correct = rbtn2.Checked;
                    externalQuestion.Answers[2].Text = txtAnswer3.Text;
                    externalQuestion.Answers[2].Correct = rbtn3.Checked;
                    externalQuestion.Answers[3].Text = txtAnswer4.Text;
                    externalQuestion.Answers[3].Correct = rbtn4.Checked;

                    this.Disposed -= frmQuestion_Disposed;
                    this.Dispose();
                }
            }
        }
Exemplo n.º 6
0
        /// <summary>
        /// 
        /// </summary>
        /// <param name="theAnswer"></param>
        public void DeleteAnswer(AnswerData theAnswer)
        {
            if (DataReader != null)
                DataReader.Close();

            SQL = "DELETE FROM `answers` WHERE `answer_id` = \"" + theAnswer.Id + "\";";

            InitializeCommand();
            OpenConnection();

            int result = ExecuteStoredProcedure();

            if (result == 0)
                throw new Exception("Could not delete the answer from the database");

            if( DataReader != null)
                DataReader.Close();

            SQL = "DELETE FROM `rel_questions_answers` WHERE `answer_id` = \"" + theAnswer.Id + "\";";

            InitializeCommand();

            result = ExecuteStoredProcedure();

            if (result == 0)
                throw new Exception("Could not delete the answer relation from the database");

            if (DataReader != null)
                DataReader.Close();

            SQL = "DELETE FROM `rel_answers_users` WHERE `answer_id` = \"" + theAnswer.Id + "\";";
            InitializeCommand();

            result = ExecuteStoredProcedure();

            CloseConnection();

            if (result == 0)
                throw new Exception("Could not clear the results for that answer");
        }
Exemplo n.º 7
0
        /// <summary>
        /// 
        /// </summary>
        /// <param name="theAnswer"></param>
        public void UpdateAnswer(AnswerData theAnswer)
        {
            if (DataReader != null)
                DataReader.Close();

            SQL = "UPDATE `answer` a SET a.`text` = \"" +
                theAnswer.Text +
                "\", a.`correct` = \"" +
                theAnswer.Correct +
                "\" WHERE a.`answer_id` = \"" +
                theAnswer.Id +
                "\";";

            InitializeCommand();
            OpenConnection();

            int result = ExecuteStoredProcedure();

            CloseConnection();

            if (result == 0)
                throw new Exception("The Answer Could Not Be Updated");
        }
Exemplo n.º 8
0
        /// <summary>
        /// Gets a list of Answers object associated with a question
        /// </summary>
        /// <param name="theQuestion">the question being queried</param>
        /// <returns>a list of Answer objects</returns>
        public List<AnswerData> ReadAnswers(QuestionData theQuestion)
        {
            List<AnswerData> return_data = new List<AnswerData>();

            if (DataReader != null)
                DataReader.Close();

            SQL = "SELECT * from `answers` a INNER JOIN `rel_questions_answers` r ON r.`answer_id` = a.`answer_id` WHERE r.`question_id` = \"" + theQuestion.id + "\";";

            InitializeCommand();
            OpenConnection();
            DataReader = Command.ExecuteReader();

            if (DataReader.HasRows) {
                while (DataReader.Read()) {
                    AnswerData temp = new AnswerData(DataReader.GetUInt16("answer_id"));
                    temp.Correct = DataReader.GetBoolean("is_correct");
                    temp.Text = DataReader.GetString("text");
                    return_data.Add(temp);
                }
            }
            CloseConnection();

            return return_data;
        }
Exemplo n.º 9
0
        /// <summary>
        /// Gets a single answer object from the database with the specified Text
        /// </summary>
        /// <param name="text">the text of the answer</param>
        /// <returns>an Answer object</returns>
        public AnswerData ReadAnswer(String text)
        {
            AnswerData return_value = null;

            if (DataReader != null)
                DataReader.Close();

            SQL = "SELECT * FROM `answers` a WHERE a.`text` = \"" + text + "\";";
            InitializeCommand();
            OpenConnection();

            DataReader = Command.ExecuteReader();

            if (DataReader.HasRows) {
                DataReader.Read();
                return_value = new AnswerData(DataReader.GetUInt16("answer_id"));
                return_value.Text = DataReader.GetString("text");
                return_value.Correct = DataReader.GetBoolean("is_correct");
            }

            CloseConnection();

            if (return_value == null)
                throw new Exception("The Answer did not exist on the database");

            return return_value;
        }
Exemplo n.º 10
0
 public static bool ValidateAnswer(AnswerData theAnswer)
 {
     return string.IsNullOrEmpty(theAnswer.Text);
 }