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)); }