public JsonResult DeleteArticulo(int id) { if (id.ToString() != null) { var contextOptions = new DbContextOptionsBuilder <ApplicationDbContext>() .UseMySql("Server=magentadatabase.c9ua8oprngoj.sa-east-1.rds.amazonaws.com;Database=magentasportwear;User=root;Password=11251073", new MySqlServerVersion(new Version(8, 0, 25))) .Options; var context = new ApplicationDbContext(contextOptions); using var db = context; var Articulo = new ApplicationDbContext.Articulo { Id = id }; db.AspNetArticulos.Remove(Articulo); db.SaveChanges(); } else { return(Json(Response.StatusCode)); } return(Json("Articulo eliminado")); }
public JsonResult AddArticulo(string nombre, int precioxs, int precios, int preciom, int preciol, int precioxl, int stockxs, int stocks, int stockm, int stockl, int stockxl) { if (nombre != null) { var contextOptions = new DbContextOptionsBuilder <ApplicationDbContext>() .UseMySql("Server=magentadatabase.c9ua8oprngoj.sa-east-1.rds.amazonaws.com;Database=magentasportwear;User=root;Password=11251073", new MySqlServerVersion(new Version(8, 0, 25))) .Options; var context = new ApplicationDbContext(contextOptions); using var db = context; var Articulo = new ApplicationDbContext.Articulo { Nombre = nombre, PrecioXS = precioxs, PrecioS = precios, PrecioM = preciom, PrecioL = preciol, PrecioXL = precioxl, StockXS = stockxs, StockS = stocks, StockM = stockm, StockL = stockl, StockXL = stockxl }; db.AspNetArticulos.Add(Articulo); db.SaveChanges(); } else { return(Json(Response.StatusCode)); } return(Json(nombre)); }