public ActionResult Create(Product p)
        {
            EFDBFirstdatabaseEntities db = new EFDBFirstdatabaseEntities();

            db.Products.Add(p);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public ActionResult Delete(long id, Product p)
        {
            EFDBFirstdatabaseEntities db = new EFDBFirstdatabaseEntities();
            Product existingProduct      = db.Products.Where(temp => temp.ProductId == id).FirstOrDefault();

            db.Products.Remove(existingProduct);
            db.SaveChanges();
            return(RedirectToAction("index", "Products"));
        }
        public ActionResult Edit(Product p)
        {
            EFDBFirstdatabaseEntities db = new EFDBFirstdatabaseEntities();
            Product existingProduct      = db.Products.Where(temp => temp.ProductId == p.ProductId).FirstOrDefault();

            existingProduct.ProductName        = p.ProductName;
            existingProduct.Price              = p.Price;
            existingProduct.DateOfPurchase     = p.DateOfPurchase;
            existingProduct.AvailabilityStatus = p.AvailabilityStatus;
            existingProduct.CategoryId         = p.CategoryId;
            existingProduct.BrandId            = p.BrandId;
            existingProduct.Active             = p.Active;
            db.SaveChanges();
            return(RedirectToAction("Index", "Products"));
        }