public ActionResult Edit([Bind(Include = "Price,Quantity,StorehouseId,StorehouseItemId,ConsignmentId")] StorehouseItem storehouseItem)
 {
     if (ModelState.IsValid)
     {
         db.Entry(storehouseItem).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.ConsignmentId = new SelectList(db.Consignments, "ConsignmentId", "ConsignmentId", storehouseItem.ConsignmentId);
     ViewBag.StorehouseId  = new SelectList(db.Storehouses, "StorehouseId", "StorehouseId", storehouseItem.StorehouseId);
     return(View(storehouseItem));
 }
        // GET: Sale/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            StorehouseItem storehouseItem = db.StorehouseItems.Find(id);

            if (storehouseItem == null)
            {
                return(HttpNotFound());
            }
            return(View(storehouseItem));
        }
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            StorehouseItem storehouseItem = db.StorehouseItems.Find(id);

            if (storehouseItem == null)
            {
                return(HttpNotFound());
            }
            ViewBag.ConsignmentId = new SelectList(db.Consignments, "ConsignmentId", "ConsignmentId", storehouseItem.ConsignmentId);
            ViewBag.StorehouseId  = new SelectList(db.Storehouses, "StorehouseId", "StorehouseId", storehouseItem.StorehouseId);
            return(View(storehouseItem));
        }
        public void CreateRequest([Bind(Include = "Price,Quantity,StorehouseId,StorehouseItemId,ConsignmentId")] StorehouseItem storehouseItem, int quantities)
        {
            var st = db.StorehouseItems.FirstOrDefault(x => x.StorehouseItemId == storehouseItem.StorehouseItemId);

            if (st.Storehouse.IsShop == true)
            {
                //var st = db.StorehouseItems.Where(x => x.Consignment.ItemId == storehouseItem.Consignment.ItemId)
                //    .Where(x => x.Storehouse.IsShop == false);
                //var max = st.Max(x => x.Quantity);

                //if (max >= quantities)
                //{
                //}


                st.Quantity += quantities;
                db.StorehouseItems.AddOrUpdate(st);
                db.SaveChanges();
            }

            RedirectToAction("Index", "Home");
        }