public JsonResult Deactivate(int?id)
{
var status = false;
Product prod = new Product();
prod = db.Products.Find(id);
prod.ProductState = !prod.ProductState;
db.Entry(prod).State = EntityState.Modified;
db.SaveChanges();
status = true;
return(Json(status, JsonRequestBehavior.AllowGet));
}
//[HttpPost]
//public JsonResult Pay(Customer cus)
//{
// //CustomerName contiene el id del cliente
// bool status = false;
// Sale sale = new Sale();
// Customer ncus = db.Customers.Find(cus.IdCustomer);
// ncus.Comments = "";
// db.Entry(ncus).State = EntityState.Modified;
// db.SaveChanges();
// foreach (var s in cus.Sales)
// {
// s.SaleState = SaleState.CuentaFin;
// db.Entry(s).State = EntityState.Modified;
// db.SaveChanges();
// }
// status = true;
// return new JsonResult { Data = new { status = status } };
//}
public ActionResult Pay(int id)
{
Customer ncus = db.Customers.Find(id);
ncus.Comments = "";
db.Entry(ncus).State = EntityState.Modified;
db.SaveChanges();
foreach (var s in ncus.Sales.ToList().FindAll(s => s.SaleState == SaleState.Cuenta))
{
s.SaleState = SaleState.CuentaFin;
db.Entry(s).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Unpaid"));
}
public ActionResult Edit([Bind(Include = "IdTrademark,TrademarkName,TrademarkDescription")] Trademark trademark)
{
if (ModelState.IsValid)
{
db.Entry(trademark).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(trademark));
}
public ActionResult Edit([Bind(Include = "IdProvider,ProviderName,CuitCuil,ProviderAddress,ProviderPhone,ProviderEmail")] Provider provider)
{
if (ModelState.IsValid)
{
db.Entry(provider).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(provider));
}
public ActionResult Edit([Bind(Include = "IdCategory,CategoryName,CategoryDescription")] Category category)
{
if (ModelState.IsValid)
{
db.Entry(category).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
public ActionResult Edit([Bind(Include = "IdPurchase,PurchaseDate,Comments,PurchaseTotal,IdProvider")] Purchase purchase)
{
if (ModelState.IsValid)
{
db.Entry(purchase).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IdProvider = new SelectList(db.Providers, "IdProvider", "ProviderName", purchase.IdProvider);
return(View(purchase));
}
public JsonResult NewSale(SaleVM O)
{
//CustomerName contiene el id del cliente
bool status = false;
Sale sale = new Sale();
if (ModelState.IsValid)
{
if (O.SaleState == "0")
{
sale.SaleState = SaleState.Efectivo;
}
if (O.SaleState == "1")
{
sale.SaleState = SaleState.Tarjeta;
}
if (O.SaleState == "2")
{
sale.SaleState = SaleState.Cuenta;
}
sale.SaleDate = O.SaleDate;
sale.Comments = O.Comments;
sale.SaleTotal = O.SaleTotal;
if (O.SaleState == "2")
{
sale.IdCustomer = Int32.Parse(O.CustomerName);
}
db.Sales.Add(sale);
db.SaveChanges();
foreach (var i in O.SaleLines)
{
SaleLine saleline = new SaleLine();
saleline.IdProduct = i.IdProduct;
saleline.LinePrice = i.LinePrice;
saleline.LineQuantity = i.LineQuantity;
saleline.LineTotal = i.LineTotal;
saleline.IdSale = sale.IdSale;
db.SaleLines.Add(saleline);
db.SaveChanges();
Product prod = new Product();
prod = db.Products.Find(i.IdProduct);
prod.Stock = prod.Stock - i.LineQuantity;
db.Entry(prod).State = EntityState.Modified;
db.SaveChanges();
}
status = true;
}
else
{
status = false;
}
return(new JsonResult {
Data = new { status = status }
});
}