public ActionResult Create([Bind(Include = "IdTrademark,TrademarkName,TrademarkDescription")] Trademark trademark) { if (ModelState.IsValid) { db.Trademarks.Add(trademark); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(trademark)); }
public ActionResult Create([Bind(Include = "IdProvider,ProviderName,CuitCuil,ProviderAddress,ProviderPhone,ProviderEmail")] Provider provider) { if (ModelState.IsValid) { db.Providers.Add(provider); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(provider)); }
public ActionResult Create([Bind(Include = "IdCategory,CategoryName,CategoryDescription")] Category category) { if (ModelState.IsValid) { db.Categories.Add(category); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(category)); }
public ActionResult Create([Bind(Include = "IdPurchase,PurchaseDate,Comments,PurchaseTotal,IdProvider")] Purchase purchase) { if (ModelState.IsValid) { db.Purchases.Add(purchase); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.IdProvider = new SelectList(db.Providers, "IdProvider", "ProviderName", purchase.IdProvider); return(View(purchase)); }
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")); }
protected void Application_Start() { TereContext dc = new TereContext(); if (dc.Customers == null | dc.Customers.Count() == 0) { Customer t1 = new Customer(); Customer t2 = new Customer(); Customer t3 = new Customer(); Customer t4 = new Customer(); Customer t5 = new Customer(); t1.CustomerName = "Cliente 1"; t2.CustomerName = "Cliente 2"; t3.CustomerName = "Cliente 3"; t4.CustomerName = "Cliente 4"; t5.CustomerName = "Cliente 5"; dc.Customers.Add(t1); dc.Customers.Add(t2); dc.Customers.Add(t3); dc.Customers.Add(t4); dc.Customers.Add(t5); dc.SaveChanges(); } if (dc.Trademarks == null | dc.Trademarks.Count() == 0) { Trademark t1 = new Trademark(); Trademark t2 = new Trademark(); Trademark t3 = new Trademark(); Trademark t4 = new Trademark(); Trademark t5 = new Trademark(); t1.TrademarkName = "Arcor"; t2.TrademarkName = "Ala"; t3.TrademarkName = "Kingston"; t4.TrademarkName = "Coca Coca"; t5.TrademarkName = "Okuma"; dc.Trademarks.Add(t1); dc.Trademarks.Add(t2); dc.Trademarks.Add(t3); dc.Trademarks.Add(t4); dc.Trademarks.Add(t5); dc.SaveChanges(); } if (dc.Categories == null | dc.Categories.Count() == 0) { Category t1 = new Category(); Category t2 = new Category(); Category t3 = new Category(); Category t4 = new Category(); Category t5 = new Category(); Category t6 = new Category(); t1.CategoryName = "Pesca"; t2.CategoryName = "Bebidas"; t3.CategoryName = "Tecnología"; t4.CategoryName = "Comestibles"; t5.CategoryName = "Limpieza"; t6.CategoryName = "Varios"; dc.Categories.Add(t1); dc.Categories.Add(t2); dc.Categories.Add(t3); dc.Categories.Add(t4); dc.Categories.Add(t5); dc.Categories.Add(t6); dc.SaveChanges(); } if (dc.Products == null | dc.Products.Count() == 0) { Product t1 = new Product(); Product t2 = new Product(); Product t3 = new Product(); Product t4 = new Product(); Product t5 = new Product(); t1.ProductDescription = "Caña 1.20m"; t1.Barcode = "1112223334445"; t1.Cost = 100; t1.PublicPrice = 150; t1.Stock = 10; t1.Minimum = 1; t1.ProductState = true; t1.idCategory = 1; t1.IdTrademark = 5; t2.ProductDescription = "Coca 3L"; t2.Barcode = "4442225556668"; t2.Cost = 35; t2.PublicPrice = 50; t2.Stock = 50; t2.Minimum = 5; t2.ProductState = true; t2.idCategory = 2; t2.IdTrademark = 4; t3.ProductDescription = "Pendrive 16gb"; t3.Barcode = "7774448889996"; t3.Cost = 120; t3.PublicPrice = 190; t3.Stock = 15; t3.Minimum = 5; t3.ProductState = true; t3.idCategory = 3; t3.IdTrademark = 3; t4.ProductDescription = "Serranas"; t4.Barcode = "8882224443337"; t4.Cost = 16; t4.PublicPrice = 25; t4.Stock = 30; t4.Minimum = 5; t4.ProductState = true; t4.idCategory = 4; t4.IdTrademark = 1; t5.ProductDescription = "Detergente"; t5.Barcode = "4443339991116"; t5.Cost = 19; t5.PublicPrice = 37; t5.Stock = 20; t5.Minimum = 5; t5.ProductState = true; t5.idCategory = 5; t5.IdTrademark = 2; dc.Products.Add(t1); dc.Products.Add(t2); dc.Products.Add(t3); dc.Products.Add(t4); dc.Products.Add(t5); dc.SaveChanges(); } AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); }
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 } }); }