// GET: Customer/Delete/5 public ActionResult Delete(int id) { using (ProductDataBaseEntities db = new ProductDataBaseEntities()) { return(View(db.Products.Where(x => x.IdProduct == id).FirstOrDefault())); } }
// GET: Customer/Index public ActionResult Index() { using (ProductDataBaseEntities db = new ProductDataBaseEntities()) { return(View(db.Products.ToList())); } }
public ActionResult AddImage(MainPageModel mainModel, HttpPostedFileBase file) { //salvam imaginea in baza de date Stock stockmodel = new Stock(); User userModel = new User(); using (ProductDataBaseEntities db = new ProductDataBaseEntities()) { stockmodel.ProductCollection = db.Products.ToList <Product>(); } mainModel.stock = stockmodel; using (LoginDataBaseEntities db = new LoginDataBaseEntities()) { mainModel.user = db.Users.Where(x => x.UserID == mainModel.user.UserID).FirstOrDefault(); } mainModel.user.ConfirmPassword = mainModel.user.Password; string fileName = Path.GetFileNameWithoutExtension(file.FileName); string extension = Path.GetExtension(file.FileName); fileName = fileName + DateTime.Now.ToString("yymmssfff") + mainModel.user.UserName.ToString() + extension; mainModel.user.ImagePath = "~/Image/" + fileName; fileName = Path.Combine(Server.MapPath("~/Image/"), fileName); file.SaveAs(fileName); // pana aici se salveaza in fisier, mai trebuie modificat in baza de date using (LoginDataBaseEntities db = new LoginDataBaseEntities()) { db.Entry(mainModel.user).State = EntityState.Modified; db.SaveChanges(); } ModelState.Clear(); Session["ImagePath"] = mainModel.user.ImagePath; return(View("Index", mainModel)); }
public ActionResult Edit(int id, Product product) { try { using (ProductDataBaseEntities db = new ProductDataBaseEntities()) { db.Entry(product).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(Product product) { try { // TODO: Add insert logic here using (ProductDataBaseEntities db = new ProductDataBaseEntities()) { db.Products.Add(product); db.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }
// GET: Home public ActionResult Index() // Creeam un View pentru Homecontroller, click stanga pe Index() si AddView { MainPageModel mainModel = new MainPageModel(); Stock stockmodel = new Stock(); User userModel = new User(); using (ProductDataBaseEntities db = new ProductDataBaseEntities()) { stockmodel.ProductCollection = db.Products.ToList <Product>(); } mainModel.stock = stockmodel; mainModel.user = userModel; return(View(mainModel)); }
public ActionResult Delete(int id, FormCollection collection) { try { using (ProductDataBaseEntities db = new ProductDataBaseEntities()) { Product product = db.Products.Where(x => x.IdProduct == id).FirstOrDefault(); db.Products.Remove(product); db.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }