public static void AddQuestionWithAnswers(QuestionWithAnswers questionWithAnswers, long quizId)
{
DataAccessMachine.AddQuestionToDb(questionWithAnswers.QuestionText,quizId);
foreach ( var answer in questionWithAnswers.Answers)
{
DataAccessMachine.AddAnswerToDb(answer);
}
}
protected void FillInQuestionAndAnswers(QuestionWithAnswers questionWithAnswers)
{
Question.Text = questionWithAnswers.QuestionText;
var answer1 = questionWithAnswers.Answers.ElementAt(0);
Answer1.Text = answer1.answerText;
Answer1.CommandArgument = answer1.ID.ToString();
var answer2 = questionWithAnswers.Answers.ElementAt(1);
Answer2.Text = answer2.answerText;
Answer2.CommandArgument = answer2.ID.ToString(CultureInfo.InvariantCulture);
var answer3 = questionWithAnswers.Answers.ElementAt(2);
Answer3.Text = answer3.answerText;
Answer3.CommandArgument = answer3.ID.ToString(CultureInfo.InvariantCulture);
var answer4 = questionWithAnswers.Answers.ElementAt(3);
Answer4.Text = answer4.answerText;
Answer4.CommandArgument = answer4.ID.ToString(CultureInfo.InvariantCulture);
}
public static List<QuestionWithAnswers> GetQuestions(long quizId)
{
var tableAdapter = new QuestionTableAdapter();
var dataTable = tableAdapter.GetQuestions(quizId);
var questions = new List<QuestionWithAnswers>();
foreach (var row in dataTable)
{
var question = new QuestionWithAnswers
{
Id = row.QuestionId,
QuestionText = row.Text,
QuizId = row.QuizId
};
questions.Add(question);
}
return questions;
}
public static QuestionWithAnswers GetNextQuestion(long quizId, long previousQuestionId)
{
var tableAdapter = new QuestionTableAdapter();
var dataTable = tableAdapter.GetNextQuestion(previousQuestionId, quizId);
foreach (var row in dataTable) {
var questionWithAnswers = new QuestionWithAnswers
{
Id = row.QuestionId,
QuestionText = row.Text,
QuizId = quizId
};
return questionWithAnswers;
}
return null;
/*using (var connection = new SqlConnection(ConnectionString))
{
var questionWithAnswers = new QuestionWithAnswers();
connection.Open();
var questionCmd =
new SqlCommand("SELECT * FROM Question WHERE QuestionId > @QuestionId AND QuizId = @QuizId",
connection);
questionCmd.Parameters.Add(@"QuestionId", SqlDbType.BigInt).Value = previousQuestionId;
questionCmd.Parameters.Add(@"QuizId", SqlDbType.BigInt).Value = quizId;
questionCmd.Prepare();
var reader = questionCmd.ExecuteReader();
while (reader.Read())
{
questionWithAnswers.Id = (long) reader["QuestionId"];
questionWithAnswers.QuestionText = (string) reader["Text"];
questionWithAnswers.QuizId = (long) reader["QuizId"];
return questionWithAnswers;
}
}
return null;*/
}
protected void SubmitQuestionWithAnswers(object sender, EventArgs e)
{
var questionWithAnswers = new QuestionWithAnswers
{
QuestionText = QuestionTextBox.Text,
Answers = new List<Answer>
{
new Answer
{
answerText = CorrectTextBox.Text,
isCorrect = true
},
new Answer
{
answerText = WrongTextBox1.Text,
isCorrect = false
},
new Answer
{
answerText = WrongTextBox2.Text,
isCorrect = false
},
new Answer
{
answerText = WrongTextBox3.Text,
isCorrect = false
}
}
};
long quizId = long.Parse(Request.QueryString["quizId"]);
GameMaster.AddQuestionWithAnswers(questionWithAnswers, quizId);
Server.Transfer("EditQuizForm.aspx?quizId=" + quizId);
}