public IActionResult UpdatePregunta(Models.Preguntas model)
{
int result = 0;
string response = "";
try
{
using (var db = new MySqlConnection(_connection))
{
var sql = "UPDATE Preguntas SET IdMateria=@IdMateria,Pregunta=@Pregunta WHERE IdPregunta=@IdPregunta;";
result = db.Execute(sql, model);
}
if (result == 1)
{
response = "Se actualizo correctamente la pregunta";
}
else
{
response = "No se actualizo la pregunta";
}
}
catch (Exception e)
{
response = e.Message;
}
return(Ok(response));
}
public IActionResult DeletePregunta(Models.Preguntas model)
{
int result = 0;
string response = "";
try
{
using (var db = new MySqlConnection(_connection))
{
var sql = "DELETE FROM Preguntas WHERE IdPregunta=@IdPregunta;";
result = db.Execute(sql, model);
}
if (result == 1)
{
response = "Se elimino correctamente la pregunta";
}
else
{
response = "No se elimino la pregunta";
}
}
catch (Exception e)
{
response = e.Message;
}
return(Ok(response));
}
public IActionResult SetPregunta(Models.Preguntas model)
{
int result = 0;
string response = "";
try
{
using (var db = new MySqlConnection(_connection))
{
var sql = "INSERT INTO Preguntas(IdMateria,Pregunta) VALUES(@idMateria,@pregunta);";
result = db.Execute(sql, model);
}
if (result == 1)
{
response = "Se inserto correctamente la pregunta";
}
else
{
response = "No se inserto la pregunta";
}
}
catch (Exception e)
{
response = e.Message;
}
return(Ok(response));
}
