partial void Deletestore_product(store_product instance);
partial void Updatestore_product(store_product instance);
partial void Insertstore_product(store_product instance);
private void detach_store_products(store_product entity) { this.SendPropertyChanging(); entity.product = null; }
private void attach_store_products(store_product entity) { this.SendPropertyChanging(); entity.product = this; }
public ActionResult EditStore(int id) { if (Request.Form["name"] != null) { var sto = (from store in db.stores where store.store_id == id select store).SingleOrDefault(); sto.name = Request.Form["name"].ToString(); try { db.SubmitChanges(); } catch (Exception e) { Console.WriteLine(e); // Make some adjustments. // ... // Try again. db.SubmitChanges(); } int i = 1; while (Request.Form["item" + i] != null) { var s_p = (from store_product in db.store_products where store_product.store_id == id && store_product.product_id == Convert.ToInt32(Request.Form["item" + i].ToString()) select store_product).SingleOrDefault(); if (s_p == null) { store_product sto_pro = new store_product { product_id = Convert.ToInt32(Request.Form["item" + i].ToString()), quantity = Convert.ToInt32(Request.Form["itemvalue" + i].ToString()), store_id = id }; db.store_products.InsertOnSubmit(sto_pro); try { db.SubmitChanges(); } catch (Exception e) { Console.WriteLine(e); // Make some adjustments. // ... // Try again. db.SubmitChanges(); } } else { s_p.quantity = Convert.ToInt32(Request.Form["itemvalue" + i].ToString()); try { db.SubmitChanges(); } catch (Exception e) { Console.WriteLine(e); // Make some adjustments. // ... // Try again. db.SubmitChanges(); } } i++; } return RedirectToAction("Index", "Stores"); } else { var pro = from store_product in db.store_products where store_product.store_id == id select store_product; ViewData["store_products"] = pro; var sto = (from store in db.stores where store.store_id == id select store).SingleOrDefault(); ViewBag.Store = sto; List<product> model = new List<product>(); model = db.products.ToList(); return View(model); } }