// GET: AlcoholProducts/Details/5
        public async Task <ActionResult> Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            AlcoholProduct alcoholProduct = await db.AlcoholProduct.FindAsync(id);

            if (alcoholProduct == null)
            {
                return(RedirectToAction("Index"));
            }
            return(View(alcoholProduct));
        }
        public async Task <ActionResult> DeleteConfirmed(int id)
        {
            AlcoholProduct alcoholProduct = await db.AlcoholProduct.FindAsync(id);

            Product product = await db.Product.FindAsync(id);

            db.AlcoholProduct.Remove(alcoholProduct);
            await db.SaveChangesAsync();

            db.Product.Remove(product);
            await db.SaveChangesAsync();

            return(RedirectToAction("Index"));
        }
        public async Task <ActionResult> Edit(AlcoholProduct alcoholProduct)
        {
            if (ModelState.IsValid)
            {
                alcoholProduct.Product.productID       = alcoholProduct.productID;
                db.Entry(alcoholProduct).State         = EntityState.Modified;
                db.Entry(alcoholProduct.Product).State = EntityState.Modified;
                await db.SaveChangesAsync();

                return(RedirectToAction("Index"));
            }
            ViewBag.categoryID = new SelectList(db.AlcoholCategory, "id", "categoryName", alcoholProduct.categoryID);
            ViewBag.origin     = new SelectList(db.Country, "countryName", "countryName", alcoholProduct.origin);
            ViewBag.productID  = new SelectList(db.Product, "productID", "productName", alcoholProduct.productID);
            return(View(alcoholProduct));
        }
        // GET: AlcoholProducts/Edit/5
        public async Task <ActionResult> Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            AlcoholProduct alcoholProduct = await db.AlcoholProduct.FindAsync(id);

            if (alcoholProduct == null)
            {
                return(RedirectToAction("Index"));
            }
            ViewBag.categoryID = new SelectList(db.AlcoholCategory, "id", "categoryName", alcoholProduct.categoryID);
            ViewBag.origin     = new SelectList(db.Country, "countryName", "countryName", alcoholProduct.origin);
            ViewBag.productID  = new SelectList(db.Product, "productID", "productName", alcoholProduct.productID);
            return(View(alcoholProduct));
        }
        public async Task <ActionResult> Create(AlcoholProduct alcoholProduct)
        {
            if (ModelState.IsValid)
            {
                Product newProdct = new Product();
                //newProdct.productName
                db.AlcoholProduct.Add(alcoholProduct);
                await db.SaveChangesAsync();

                return(RedirectToAction("Index"));
            }

            ViewBag.categoryID = new SelectList(db.AlcoholCategory, "id", "categoryName", alcoholProduct.categoryID);
            ViewBag.origin     = new SelectList(db.Country, "countryName", "countryName", alcoholProduct.origin);
            ViewBag.productID  = new SelectList(db.Product, "productID", "productName", alcoholProduct.productID);
            return(View(alcoholProduct));
        }