public ActionResult AddMasterProduct(FormCollection form) { var db = new FashionDb(); var master = new MasterProduct() { MasterId = form["masterId"], Label = form["label"], Supplier = form["supplier"], Name = form["name"], Type = form["productType"], MarkUp = Double.Parse(form["markUp"]), Season = form["season"], Cost = Double.Parse(form["Price"]), }; var dateAdded = DateTime.Now; var productsList = new List<Product>(); for (int i = Int32.Parse(form["fromSize"]); i <= Int32.Parse(form["toSize"]); i += 2) { productsList.Add(new Product() { Color = form["color"], Currency = form["currency"], DateAdded = dateAdded, MasterId = master.MasterId, Size = i, Quantity = Int32.Parse(form["quantity"]), CodeName = String.Format("{0}-{1}-{2}", master.MasterId, i>=10?i.ToString():String.Format("0{0}",i), form["color"]), SellPrice = master.Cost*(master.MarkUp/100) }); } master.Products = productsList; db.MasterProducts.Add(master); db.SaveChanges(); return PartialView("_ProductsList",db.MasterProducts.Include("Products").Where(m=>m.MasterId==master.MasterId)); }
public ActionResult SaveMasterChanges(FormCollection form) { var db = new FashionDb(); var label = form["label"]; var type = form["productType"]; var name = form["name"]; var masterId = GetMasterId(form["masterId"]); var master = db.MasterProducts.Where(m => m.MasterId == masterId).Single(); master.Label = label; master.Type = type; master.Name = name; db.SaveChanges(); return PartialView("_ProductsList",db.MasterProducts.Include("Products")); }
public ActionResult Search(string searchFor) { if(!String.IsNullOrEmpty(searchFor)) { var db = new FashionDb(); //ViewBag.Images = GetImages(); GetIndexPageData(); return View("Index", db.MasterProducts.Include("Products").Where(m => m.Name.Contains(searchFor) || m.Label.Contains(searchFor))); } return RedirectToAction("Index"); }
public void SaveChildChanges(FormCollection collection) { var db = new FashionDb(); var id = Int32.Parse(collection["hdnChildId"]); var price = Double.Parse(collection["txtEditPrice"]); var q = Int32.Parse(collection["txtEditQuantity"]); var prod = db.Products.Where(p => p.ProductId == id).Single(); prod.SellPrice = price; prod.Quantity = q; db.SaveChanges(); return; }
public ActionResult Index() { var db = new FashionDb(); GetIndexPageData(); ViewBag.Images = GetImages(); return View(db.MasterProducts.Include("Products").OrderBy(m=>m.MasterId)); }
public JsonResult GetProductById(int id) { var db = new FashionDb(); var prod = db.Products.Where(p => p.ProductId == id).Single(); var master = db.MasterProducts.Where(m => m.MasterId == prod.MasterId).Single(); return Json(new { prod.ProductId, prod.SellPrice, prod.MasterId, prod.Currency, prod.Color, prod.Quantity, prod.CodeName, prod.MasterProduct.Name, prod.MasterProduct.Label, prod.MasterProduct.Supplier, prod.MasterProduct.Type }, JsonRequestBehavior.AllowGet); }
public void DeleteProduct(int id) { var db = new FashionDb(); var prod=db.Products.Where(p => p.ProductId == id).Single(); var masterId = prod.MasterId; db.Products.Remove(prod); db.SaveChanges(); if(db.Products.Where(p=>p.MasterId==masterId).Count()==0) { var master = db.MasterProducts.Where(m => m.MasterId == masterId).Single(); db.MasterProducts.Remove(master); } db.SaveChanges(); }
public ActionResult DeleteMaster(FormCollection collection) { var db = new FashionDb(); var masterId = GetMasterId(collection["masterIdDel"]); var master = db.MasterProducts.Where(m => m.MasterId == masterId).Single(); db.MasterProducts.Remove(master); db.SaveChanges(); return PartialView("_ProductsList", db.MasterProducts.Include("Products")); }