/*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(); }*/ }