public ActionResult UpdateMyProduct(int id)
        {
            ProductManipulationViewModel model = new ProductManipulationViewModel
            {
                Product    = _db.Products.Find(id),
                Categories = _db.Categories.ToList(),
                Suppliers  = _db.Suppliers.ToList(),
                ButtonText = "Update Product"
            };

            return(View(model));
        }
        public ActionResult AddMyProduct()
        {
            ProductManipulationViewModel model = new ProductManipulationViewModel
            {
                Product    = new Product(),
                Categories = _db.Categories.ToList(),
                Suppliers  = _db.Suppliers.ToList(),
                ButtonText = "Add Product"
            };

            return(View(model));
        }
        public ActionResult UpdateMyProduct(Product product)
        {
            if (!ModelState.IsValid)
            {
                ProductManipulationViewModel model = new ProductManipulationViewModel
                {
                    Product    = _db.Products.Find(product.ProductID),
                    Categories = _db.Categories.ToList(),
                    Suppliers  = _db.Suppliers.ToList(),
                    ButtonText = "Update Product"
                };

                return(View(model));
            }

            _db.Entry <Product>(product).State = System.Data.Entity.EntityState.Modified;
            _db.SaveChanges();

            return(RedirectToAction("ListMyProducts"));
        }