public void AssociarQuestaoProva([FromBody] ProvaQuestao provaQuestao)
{
using (SqlConnection conn = SqlConn.Abrir())
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO tbProvaQuestao (Valor, IdProva, IdQuestao) VALUES (@Valor, @IdProva, @IdQuestao)", conn))
{
cmd.Parameters.AddWithValue("@Valor", provaQuestao.Valor);
cmd.Parameters.AddWithValue("@IdProva", provaQuestao.IdProva);
cmd.Parameters.AddWithValue("@IdQuestao", provaQuestao.IdQuestao);
cmd.ExecuteNonQuery();
}
}
}
public void DeletarQuestaoProva([FromBody] ProvaQuestao provaQuestao)
{
using (SqlConnection conn = new SqlConnection("Server=tcp:carolaine.database.windows.net,1433;" +
"Initial Catalog=carolaine;Persist Security Info=False;User ID=xxxx;Password=xxxx;" +
"MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("DELETE FROM tbProvaQuestao WHERE IdProvaQuestao = @idProvaQuestao", conn))
{
cmd.Parameters.AddWithValue("@idProvaQuestao", provaQuestao.IdProvaQuestao);
cmd.ExecuteNonQuery();
}
}
}
public void AssociarQuestaoProva([FromBody] ProvaQuestao provaQuestao)
{
using (SqlConnection conn = new SqlConnection("Server=tcp:carolaine.database.windows.net,1433;" +
"Initial Catalog=carolaine;Persist Security Info=False;User ID=xxxx;Password=xxxx;" +
"MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("INSERT INTO tbProvaQuestao (IdProva, IdQuestao, Valor) VALUES (@idProva, @idQuestao, @valor)", conn))
{
cmd.Parameters.AddWithValue("@idProva", provaQuestao.IdProva);
cmd.Parameters.AddWithValue("@idQuestao", provaQuestao.IdQuestao);
cmd.Parameters.AddWithValue("@valor", provaQuestao.Valor);
cmd.ExecuteNonQuery();
}
}
}
