public IActionResult Delete(long id)
{
List <Aviso> avisos = this.GetAll().Value;
var aviso = avisos.FirstOrDefault(l => l.CODIGO_CURSO == id.ToString());
if (aviso == 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 < avisos.Count; i++)
{
var l = avisos[i];
_context.Avisos.Add(l);
}
conn.Open();
cmd.CommandText = "DELETE FROM AVISOS WHERE CODIGO_CURSO = '" + aviso.CODIGO_CURSO + "'";
cmd.ExecuteNonQuery();
_context.Avisos.Remove(aviso);
_context.SaveChanges();
}
catch (Exception)
{
return(NotFound());
}
}
}
return(NoContent());
}
//QUANDO EU FOR FAZER UM POST VERIFICO SE É VALIDO
public IActionResult OnPost()
{
if (!ModelState.IsValid)//SE O MODELO NÃO É VALIDO
{
return(Page());
}
Item.Id = 0;
_context.Avisos.Add(Item); //ARMAZENDO NO BANCO AS INFORMACOS DO AVISO ITEM CONTEM AS INFORMACIONES
_context.SaveChanges();
return(RedirectToPage("Index"));
}
public IActionResult OnPost()
{
if (!ModelState.IsValid)
{
return(Page());
}
Item.Id = 0;
_context.Avisos.Add(Item);
_context.SaveChanges();
return(RedirectToPage("Index"));
}