public ActionResult Edit(Stock stock)
{
using (var db = new TupperwareContext())
{
var StockToEdit = db.Stock.Find(stock.StockId);
stock.StockId = stock.StockId;
var product = db.Products.Find(stock.ProductId);
stock.ProductId = stock.Product.ProductId;
var category = db.Categories.Find(stock.CategorieId);
stock.CategorieId = stock.Categorie.CategorieId;
var line = db.Lines.Find(stock.LineId);
stock.LineId = stock.Line.LineId;
var stockstatus = db.StockStatuses.Find(stock.StockStatusId);
stock.StockStatusId = stock.StockStatus.StockStatusId;
var capacity = db.Capacities.Find(stock.Capacity.CapacityId);
stock.CapacityId = stock.Capacity.CapacityId;
var color = db.Colors.Find(stock.ColorId);
stock.ColorId = stock.Color.ColorId;
var origin = db.Origins.Find(stock.OriginId);
stock.OriginId = stock.Origin.OriginId;
db.Entry(StockToEdit).CurrentValues.SetValues(stock);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Create(Stock stock)
{
using (var db = new TupperwareContext())
{
db.Stock.Add(stock);
db.SaveChanges();
}
Session["Message"] = "El stock fue guardado exitosamente";
return(RedirectToAction("Index"));
}
public ActionResult Create(Sale sale)
{
using (var db = new TupperwareContext())
{
db.Sales.Add(sale);
db.SaveChanges();
}
Session["Message"] = "La venta fue guardado exitosamente";
return(RedirectToAction("Index"));
}
public ActionResult Edit(Client client)
{
using (var db = new TupperwareContext())
{
var ClientToEdit = db.Clients.Find(client.ClientId);
db.Entry(ClientToEdit).CurrentValues.SetValues(client);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Create(Client client)
{
using (var db = new TupperwareContext())
{
db.Clients.Add(client);
db.SaveChanges();
}
Session["Message"] = "El cliente fue guardado exitosamente";
return(RedirectToAction("Index"));
}
public ActionResult Create(Discount discounts)
{
using (var db = new TupperwareContext())
{
db.Discounts.Add(discounts);
db.SaveChanges();
}
Session["Message"] = "El porcentage de descuento fue guardado exitosamente";
return(RedirectToAction("Index"));
}
public ActionResult Edit(Categorie Categorie)
{
using (var db = new TupperwareContext())
{
var CategorieToEdit = db.Categories.Find(Categorie.CategorieId);
db.Entry(CategorieToEdit).CurrentValues.SetValues(Categorie);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Create(Categorie Categorie)
{
using (var db = new TupperwareContext())
{
db.Categories.Add(Categorie);
db.SaveChanges();
}
Session["Message"] = "La categoria fue guardada exitosamente";
return(RedirectToAction("Index"));
}
public ActionResult Edit(Discount Discounts)
{
using (var db = new TupperwareContext())
{
var discountToEdit = db.Discounts.Find(Discounts.DiscountId);
db.Entry(discountToEdit).CurrentValues.SetValues(Discounts);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(Origin origin)
{
using (var db = new TupperwareContext())
{
var originToEdit = db.Origins.Find(origin.OriginId);
db.Entry(originToEdit).CurrentValues.SetValues(origin);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(Stock stock)
{
using (var db = new TupperwareContext())
{
var StockToEdit = db.Stock.Find(stock.Id);
db.Entry(StockToEdit).CurrentValues.SetValues(stock);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Create(Origin origin)
{
using (var db = new TupperwareContext())
{
db.Origins.Add(origin);
db.SaveChanges();
}
Session["Message"] = "El nuevo origen fue guardado exitosamente";
return(RedirectToAction("Index"));
}
public ActionResult Create(StockStatus StockStatuses)
{
using (var db = new TupperwareContext())
{
db.StockStatuses.Add(StockStatuses);
db.SaveChanges();
}
Session["Message"] = "El estado de publicación fue guardado exitosamente";
return(RedirectToAction("Index"));
}
public ActionResult Create(User user)
{
using (var db = new TupperwareContext())
{
db.Users.Add(user);
db.SaveChanges();
}
Session["Message"] = "El usuario fue guardado exitosamente";
return(RedirectToAction("Index"));
}
public ActionResult Edit(User user)
{
using (var db = new TupperwareContext())
{
var UserToEdit = db.Users.Find(user.UserId);
db.Entry(UserToEdit).CurrentValues.SetValues(user);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Create(Line line)
{
using (var db = new TupperwareContext())
{
db.Lines.Add(line);
db.SaveChanges();
}
Session["Message"] = "La nueva linea fue agregada";
return(RedirectToAction("Index"));
}
public ActionResult Edit(Line line)
{
using (var db = new TupperwareContext())
{
var LineToEdit = db.Lines.Find(line.LineId);
db.Entry(LineToEdit).CurrentValues.SetValues(line);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(StockStatus StockStatuses)
{
using (var db = new TupperwareContext())
{
var PublicationStatusToEdit = db.StockStatuses.Find(StockStatuses.StockStatusId);
db.Entry(PublicationStatusToEdit).CurrentValues.SetValues(StockStatuses);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Create(Dispatch dispatch)
{
using (var db = new TupperwareContext())
{
db.Dispatches.Add(dispatch);
db.SaveChanges();
}
Session["Message"] = "El nuevo tipo de entrega fue guardado exitosamente";
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmation(int id)
{
using (var db = new TupperwareContext())
{
var StockToRemove = db.Stock.Find(id);
db.Stock.Remove(StockToRemove);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(Capacity Capacity)
{
using (var db = new TupperwareContext())
{
var capacityToEdit = db.Capacities.Find(Capacity.CapacityId);
db.Entry(capacityToEdit).CurrentValues.SetValues(Capacity);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(Color color)
{
using (var db = new TupperwareContext())
{
var colorToEdit = db.Colors.Find(color.ColorId);
db.Entry(colorToEdit).CurrentValues.SetValues(color);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(Product product)
{
using (var db = new TupperwareContext())
{
var productToEdit = db.Products.Find(product.Id);
db.Entry(productToEdit).CurrentValues.SetValues(product);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(Description description)
{
using (var db = new TupperwareContext())
{
var descriptionToEdit = db.Descriptions.Find(description.DescriptionId);
db.Entry(descriptionToEdit).CurrentValues.SetValues(description);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Create(ShoppingCart ShoppingCart)
{
using (var db = new TupperwareContext())
{
//var stock = db.Stock.Find(ShoppingCart.Stock.);
//stock.Product = product;
var dispatch = db.Dispatches.Find(ShoppingCart.Dispatch.DispatchId);
ShoppingCart.Dispatch = dispatch;
var client = db.Clients.Find(ShoppingCart.Client.ClientId);
ShoppingCart.Client = client;
db.ShoppingCarts.Add(ShoppingCart);
db.SaveChanges();
}
Session["Message"] = "El carrito de ventas fue guardado exitosamente";
return(RedirectToAction("Index"));
}
public ActionResult Create(Capacity Capacity)
{
using (var db = new TupperwareContext())
{
if (db.Capacities.Any(p => p.CapacityDescription == Capacity.CapacityDescription))
{
throw new Exception("Ya se agrego esa capacidad");
}
db.Capacities.Add(Capacity);
db.SaveChanges();
}
Session["Message"] = "La capacidad fue guardada exitosamente";
return(RedirectToAction("Index"));
}
public ActionResult Create(Product product)
{
using (var db = new TupperwareContext())
{
if (db.Products.Any(p => p.Name == product.Name))
{
throw new Exception("Ya se agrego un producto con ese nombre");
}
db.Products.Add(product);
db.SaveChanges();
}
Session["Message"] = "El producto fue guardado exitosamente";
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmation(int id)
{
using (var db = new TupperwareContext())
{
var descriptionToRemove = db.Descriptions.Find(id);
try
{
db.Descriptions.Remove(descriptionToRemove);
db.SaveChanges();
}
catch (Exception ex)
{
Session["Message"] = "No se puede eliminar";
}
}
return(RedirectToAction("Index"));
}
public ActionResult Create(Description description)
{
using (var db = new TupperwareContext())
{
if (db.Descriptions.Any(p => p.DescriptionText == description.DescriptionText))
{
throw new Exception("Ya se agrego una descripcion");
}
db.Descriptions.Add(description);
db.SaveChanges();
}
Session["Message"] = "La descripcion fue guardada exitosamente";
return(RedirectToAction("Index"));
}
public ActionResult Create(Color Color)
{
using (var db = new TupperwareContext())
{
if (db.Colors.Any(p => p.ColorDescription == Color.ColorDescription))
{
throw new Exception("Ya se agrego ese color");
}
db.Colors.Add(Color);
db.SaveChanges();
}
Session["Message"] = "El nuevo color fue guardado exitosamente";
return(RedirectToAction("Index"));
}
