public IActionResult Delete(long id)
{
List <Beneficio> beneficios = this.GetAll().Value;
var beneficio = beneficios.FirstOrDefault(l => l.NOMBRE == id.ToString());
if (beneficio == null)
{
return(NotFound());
}
using (OracleConnection conn = new OracleConnection(connectionString: "User Id=sinuois;Password=SINUOIS;Data Source=localhost:1521;"))
{
using (OracleCommand cmd = conn.CreateCommand())
{
try
{
for (int i = 0; i < beneficios.Count; i++)
{
var l = beneficios[i];
_context.Beneficios.Add(l);
}
conn.Open();
cmd.CommandText = "DELETE FROM BENEFICIOS WHERE CODIGO = '" + beneficio.CODIGO + "AND NOMBRE = '" + beneficio.NOMBRE + "'";
cmd.ExecuteNonQuery();
_context.Beneficios.Remove(beneficio);
_context.SaveChanges();
}
catch (Exception)
{
return(NotFound());
}
}
}
return(NoContent());
}
public void Add(T entity)
{
_beneficioContext.Set <T>().Add(entity);
_beneficioContext.SaveChanges();
}
