public IActionResult Edit(Models.Carreras model)
{
int result = 0;
string response = "";
try
{
using (var db = new MySqlConnection(_connection))
{
var sql = "UPDATE Carreras SET Nombre=@Nombre WHERE IdCarrera=@IdCarrera;";
result = db.Execute(sql, model);
}
if (result == 1)
{
response = "Se actualizo correctamente la carrera";
}
else
{
response = "No se actualizo la carrera";
}
}
catch (Exception e)
{
response = e.Message;
}
return(Ok(response));
}
public IActionResult Set(Models.Carreras model)
{
int result = 0;
string response = "";
try
{
using (var db = new MySqlConnection(_connection))
{
var sql = "INSERT INTO Carreras(Nombre) VALUES(@Nombre)";
result = db.Execute(sql, model);
}
if (result == 1)
{
response = "Se inserto correctamente la carrera";
}
else
{
response = "No se inserto la carrera";
}
}
catch (Exception e)
{
response = e.Message;
}
return(Ok(response));
}
public IActionResult Delete(Models.Carreras model)
{
int result = 0;
string response = "";
try
{
using (var db = new MySqlConnection(_connection))
{
var sql = "DELETE FROM Carreras WHERE IdCarrera=@IdCarrera;";
result = db.Execute(sql, model);
}
if (result == 1)
{
response = "Se elimino correctamente la carrera";
}
else
{
response = "No se elimino la carrera";
}
}
catch (Exception e)
{
response = e.Message;
}
return(Ok(response));
}
public IActionResult GetById(Models.Carreras model)
{
IEnumerable <Models.Carreras> lst = null;
using (var db = new MySqlConnection(_connection))
{
var sql = "SELECT * FROM Carreras WHERE IdCarrera=@IdCarrera";
lst = db.Query <Models.Carreras>(sql, model);
}
return(Ok(lst));
}
