public void Add(QuizHasQuestionModel quizHasQuestionsModel)
{
try
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
string Sql = "insert into quiz_has_question(questionId,quizId) values (@questionId,@quizId)";
using (MySqlCommand command = new MySqlCommand(Sql, connection))
{
command.Parameters.AddWithValue("@questionId", quizHasQuestionsModel.QuestionId);
command.Parameters.AddWithValue("@QuizId", quizHasQuestionsModel.QuizId);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public bool Delete(QuizHasQuestionModel quizHasQuestionsModel)
{
try
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
string Sql = "delete from quiz_has_question where quizId = @quizId and questionId = @questionId";
using (MySqlCommand command = new MySqlCommand(Sql, connection))
{
command.Parameters.AddWithValue("@quizId", quizHasQuestionsModel.QuizId);
connection.Open();
command.ExecuteNonQuery();
return(true);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public QuizHasQuestionModel Get(QuizHasQuestionModel quizHasQuestionsModel)
{
try
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
string Sql = "select * from quiz_has_question where quizId = @quizId and questionId = @questionId";
using (MySqlCommand cmd = new MySqlCommand(Sql, connection))
{
cmd.Parameters.AddWithValue("quizId", quizHasQuestionsModel.QuizId);
connection.Open();
using (MySqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
QuizHasQuestionModel item = new QuizHasQuestionModel();
while (dr.Read())
{
item = new QuizHasQuestionModel();
item.QuizId = Convert.ToInt32(dr["quizId"]);
item.QuestionId = Convert.ToInt32(dr["questionId"]);
return(item);
}
}
}
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
return(null);
}
