public IActionResult Edit(Models.PesoMateria model)
{
int result = 0;
string response = "";
try
{
using (var db = new MySqlConnection(_connection))
{
var sql = "UPDATE PesoMateria SET IdCarrera=@IdCarrera, IdMateria=@IdMateria, Peso=@Peso WHERE IdCarreraMateria=@IdCarreraMateria;";
result = db.Execute(sql, model);
}
if (result == 1)
{
response = "El peso se actualizo correctamente";
}
else
{
response = "No se actualizo el peso";
}
}
catch (Exception e)
{
response = e.Message;
}
return(Ok(response));
}
public IActionResult Set(Models.PesoMateria model)
{
int result = 0;
string response = "";
try
{
using (var db = new MySqlConnection(_connection))
{
var sql = "INSERT INTO CarreraMaterias (IdCarrera, IdMateria, Peso) VALUES(@IdCarrera, @IdMateria, @Peso)";
result = db.Execute(sql, model);
}
if (result == 1)
{
response = "El peso se agregó correctamente";
}
else
{
response = "No se inserto el peso";
}
}
catch (Exception e)
{
response = e.Message;
}
return(Ok(response));
}
public IActionResult Delete(Models.PesoMateria model)
{
int result = 0;
string response = "";
try
{
using (var db = new MySqlConnection(_connection))
{
var sql = "DELETE FROM CarreraMaterias WHERE IdCarreraMateria=@IdCarreraMateria;";
result = db.Execute(sql, model);
}
if (result == 1)
{
response = "La pregunta se elimino correctamente";
}
else
{
response = "No se pudo eliminar";
}
}
catch (Exception e)
{
response = e.Message;
}
return(Ok(response));
}
