public ActionResult DeleteConfirmed(int id)
{
CellarProduct cellarProduct = db.CellarProducts.Find(id);
db.CellarProducts.Remove(cellarProduct);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "CellarProductId,CellarId,ProductId,Stock,Minimum,Maximum,ReplacementDays,MinimumAmount,Location")] CellarProduct cellarProduct)
{
if (ModelState.IsValid)
{
db.Entry(cellarProduct).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CellarId = new SelectList(db.Cellars, "CellarId", "Description", cellarProduct.CellarId);
ViewBag.ProductId = new SelectList(db.Products, "ProductId", "Description", cellarProduct.ProductId);
return(View(cellarProduct));
}
// GET: CellarProducts/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CellarProduct cellarProduct = db.CellarProducts.Find(id);
if (cellarProduct == null)
{
return(HttpNotFound());
}
return(View(cellarProduct));
}
// GET: CellarProducts/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CellarProduct cellarProduct = db.CellarProducts.Find(id);
if (cellarProduct == null)
{
return(HttpNotFound());
}
ViewBag.CellarId = new SelectList(db.Cellars, "CellarId", "Description", cellarProduct.CellarId);
ViewBag.ProductId = new SelectList(db.Products, "ProductId", "Description", cellarProduct.ProductId);
return(View(cellarProduct));
}
public ActionResult Create(NewSaleView view)
{
if (ModelState.IsValid)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
AccountingDocument dn = (from x in db.AccountingDocuments orderby x.InitialNumber descending select x).FirstOrDefault();
var docnumber = dn.InitialNumber + 1;
var sale = new Sale
{
Datetime = view.Date,
CellarId = view.CellarId,
ClientId = view.ClientId,
AccountingDocumentId = view.AccountingDocumentId,
PaymentMethodId = view.PaymentMethodId,
DocumentNumber = docnumber,
};
db.Sales.Add(sale);
db.SaveChanges();
var details = db.SaleDetailBkps.Where(pdb => pdb.User == User.Identity.Name).ToList();
foreach (var detail in details)
{
var saleDetail = new SaleDetail
{
SaleId = sale.SaleId,
ProductId = detail.ProductId,
Description = detail.Description,
Price = detail.Price,
Quantity = detail.Quantity,
IVAPercentage = detail.IVAPercentage,
DiscountRate = detail.DiscountRate
};
db.SaleDetails.Add(saleDetail);
db.SaleDetailBkps.Remove(detail);
var status = true;
if (status == true)
{
CellarProduct c = (from x in db.CellarProducts
where x.ProductId == detail.ProductId
select x).First();
c.Stock = c.Stock - detail.Quantity;
db.SaveChanges();
}
}
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
ModelState.AddModelError(string.Empty, ex.Message);
}
}
return(RedirectToAction("Index"));
}
ViewBag.CellarId = new SelectList(db.Cellars, "CellarId", "Description", view.CellarId);
ViewBag.ClientId = new SelectList(db.Clients, "ClientId", "Cliente", view.ClientId);
ViewBag.AccountingDocumentId = new SelectList(db.AccountingDocuments, "AccountingDocumentId", "Tipo de Documento", view.AccountingDocumentId);
ViewBag.PaymentMethodId = new SelectList(db.PaymentMethods, "PaymentMethodId", "Metodo de Pago", view.PaymentMethodId);
view.Details = db.SaleDetailBkps.Where(pdb => pdb.User == User.Identity.Name).ToList();
return(View(view));
}
