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));
}
