/*public static void AddQuestionWithAnswersToDb(QuestionWithAnswers questionWithAnswers, long quizId)
{
AddQuestionToDb(questionWithAnswers.QuestionText, quizId);
var questionId = GetIdOfQuestionText(questionWithAnswers.QuestionText);
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
foreach (var answer in questionWithAnswers.Answers)
{
var answerCmd =
new SqlCommand(
"INSERT INTO Answer (Text, IsCorrect, QuestionId) VALUES (@Text, @IsCorrect, @QuestionId)",
connection);
answerCmd.Parameters.Add(@"Text", SqlDbType.VarChar, 250).Value = answer.answerText;
answerCmd.Parameters.Add(@"IsCorrect", SqlDbType.Bit).Value = answer.isCorrect;
answerCmd.Parameters.Add(@"QuestionId", SqlDbType.BigInt).Value = questionId;
answerCmd.Prepare();
answerCmd.ExecuteNonQuery();
}
}
}*/
public static void AddQuestionToDb(string questionText, long quizId)
{
var tableAdapter = new QuestionTableAdapter();
tableAdapter.Insert(questionText, quizId);
/*using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
var questionCmd = new SqlCommand("INSERT INTO Question (Text, QuizId) VALUES (@Text, @QuizId)",
connection);
questionCmd.Parameters.Add(@"Text", SqlDbType.VarChar, 250).Value = questionText;
questionCmd.Parameters.Add(@"QuizId", SqlDbType.BigInt).Value = quizId;
questionCmd.Prepare();
questionCmd.ExecuteNonQuery();
}*/
}
