public void UpdateQuestion(QuestionData theQuestion) { AnswerEntity temp = new AnswerEntity(); for (int i = 0; i < theQuestion.Answers.Count; i++) { temp.UpdateAnswer(theQuestion.Answers[i]); } temp.Dispose(); if (DataReader != null) { DataReader.Close(); } SQL = "UPDATE `questions` q SET q.`question` = \"" + theQuestion.Text + "\" WHERE q.`question_id` = \"" + theQuestion.Id + "\";"; OpenConnection(); InitializeCommand(); int result = ExecuteStoredProcedure(); CloseConnection(); if (result == 0) { throw new Exception("Unable to edit the question on database"); } }
public void CreateQuestion(QuestionData theQuestion) { theQuestion.id = NextId; AnswerEntity temp; temp = new AnswerEntity(); for (int i = 0; i < theQuestion.answers.Count; i++) { temp.CreateAnswer(theQuestion.answers[i]); } temp.Dispose(); if (DataReader != null) { DataReader.Close(); } SQL = "INSERT INTO `questions` (`question_id`, `question`) VALUES (\"" + theQuestion.id + "\", \"" + theQuestion.Text + "\");"; InitializeCommand(); OpenConnection(); int result = ExecuteStoredProcedure(); if (DataReader != null) { DataReader.Close(); } if (result == 0) { throw new Exception("Cannot add the selected question to the database"); } for (int i = 0; i < theQuestion.answers.Count; i++) { if (DataReader != null) { DataReader.Close(); } SQL = "INSERT INTO `rel_questions_answers` (`question_id`, `answer_id`) VALUES (\"" + theQuestion.id + "\", \"" + theQuestion.answers[i].Id + "\");"; InitializeCommand(); OpenConnection(); result = ExecuteStoredProcedure(); if (result == 0) { throw new Exception("One or more of the answers could not be added to the database"); } } CloseConnection(); }
public void CreateQuestion(QuestionData theQuestion) { theQuestion.Id = NextId; AnswerEntity temp; temp = new AnswerEntity(); for (int i = 0; i < theQuestion.Answers.Count; i++) { temp.CreateAnswer(theQuestion.Answers[i]); } temp.Dispose(); if (DataReader != null) DataReader.Close(); SQL = "INSERT INTO `questions` (`question_id`, `question`) VALUES (\"" + theQuestion.Id + "\", \"" + theQuestion.Text + "\");"; OpenConnection(); InitializeCommand(); int result = ExecuteStoredProcedure(); if (DataReader != null) DataReader.Close(); if (result == 0) throw new Exception("Cannot add the selected question to the database"); for (int i = 0; i < theQuestion.Answers.Count; i++) { if (DataReader != null) DataReader.Close(); SQL = "INSERT INTO `rel_questions_answers` (`question_id`, `answer_id`) VALUES (\"" + theQuestion.Id + "\", \"" + theQuestion.Answers[i].Id + "\");"; InitializeCommand(); result = ExecuteStoredProcedure(); if (result == 0) throw new Exception("One or more of the answers could not be added to the database"); } CloseConnection(); }
public QuestionData ReadQuestion(int id) { QuestionData return_data = null; if (DataReader != null) { DataReader.Close(); } SQL = "SELECT * FROM `questions` q WHERE q.`question_id` = \"" + id + "\";"; InitializeCommand(); OpenConnection(); DataReader = Command.ExecuteReader(); if (DataReader.HasRows) { DataReader.Read(); return_data = new QuestionData(DataReader.GetUInt16("question_id")); return_data.Text = DataReader.GetString("question"); DataReader.Close(); } if (return_data != null) { AnswerEntity temp = new AnswerEntity(); List <AnswerData> temp1 = temp.ReadAnswers(return_data); for (int i = 0; i < temp1.Count; i++) { return_data.AddAnswer(temp1[i]); } temp.Dispose(); } CloseConnection(); return(return_data); }
public void UpdateQuestion(QuestionData theQuestion) { AnswerEntity temp = new AnswerEntity(); for (int i = 0; i < theQuestion.Answers.Count; i++) temp.UpdateAnswer(theQuestion.Answers[i]); temp.Dispose(); if (DataReader != null) DataReader.Close(); SQL = "UPDATE `questions` q SET q.`question` = \"" + theQuestion.Text + "\" WHERE q.`question_id` = \"" + theQuestion.Id + "\";"; OpenConnection(); InitializeCommand(); int result = ExecuteStoredProcedure(); CloseConnection(); if (result == 0) throw new Exception("Unable to edit the question on database"); }
public QuestionData ReadQuestion(int id) { QuestionData return_data = null; if (DataReader != null) DataReader.Close(); SQL = "SELECT * FROM `questions` q WHERE q.`question_id` = \"" + id + "\";"; InitializeCommand(); OpenConnection(); DataReader = Command.ExecuteReader(); if (DataReader.HasRows) { DataReader.Read(); return_data = new QuestionData(DataReader.GetUInt16("question_id")); return_data.Text = DataReader.GetString("question"); DataReader.Close(); } if (return_data != null) { AnswerEntity temp = new AnswerEntity(); List<AnswerData> temp1 = temp.ReadAnswers(return_data); for (int i = 0; i < temp1.Count; i++) return_data.AddAnswer(temp1[i]); temp.Dispose(); } CloseConnection(); return return_data; }