public ActionResult DeleteConfirmed(int id)
        {
            ITEMS_PURCHASE iTEMS_PURCHASE = db.ITEMS_PURCHASE.Find(id);

            db.ITEMS_PURCHASE.Remove(iTEMS_PURCHASE);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "PURCHASE_ID,PURCHASE_NUMBER,ITEM_ID,PRICE,QUANTITY,PURCHASE_DATE,STOCK_ID,SUPPLIER_ID")] ITEMS_PURCHASE iTEMS_PURCHASE)
 {
     if (ModelState.IsValid)
     {
         db.Entry(iTEMS_PURCHASE).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.ITEM_ID     = new SelectList(db.ITEMS, "ITEM_ID", "ITEM_DESRIPTION", iTEMS_PURCHASE.ITEM_ID);
     ViewBag.STOCK_ID    = new SelectList(db.STOCKS, "STOCK_ID", "ADDRESS", iTEMS_PURCHASE.STOCK_ID);
     ViewBag.SUPPLIER_ID = new SelectList(db.SUPPLIERS, "SUPPLIER_ID", "SUPPLIERS_NAME", iTEMS_PURCHASE.SUPPLIER_ID);
     return(View(iTEMS_PURCHASE));
 }
        // GET: ITEMS_PURCHASE/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ITEMS_PURCHASE iTEMS_PURCHASE = db.ITEMS_PURCHASE.Find(id);

            if (iTEMS_PURCHASE == null)
            {
                return(HttpNotFound());
            }
            return(View(iTEMS_PURCHASE));
        }
        // GET: ITEMS_PURCHASE/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ITEMS_PURCHASE iTEMS_PURCHASE = db.ITEMS_PURCHASE.Find(id);

            if (iTEMS_PURCHASE == null)
            {
                return(HttpNotFound());
            }
            ViewBag.ITEM_ID     = new SelectList(db.ITEMS, "ITEM_ID", "ITEM_DESRIPTION", iTEMS_PURCHASE.ITEM_ID);
            ViewBag.STOCK_ID    = new SelectList(db.STOCKS, "STOCK_ID", "ADDRESS", iTEMS_PURCHASE.STOCK_ID);
            ViewBag.SUPPLIER_ID = new SelectList(db.SUPPLIERS, "SUPPLIER_ID", "SUPPLIERS_NAME", iTEMS_PURCHASE.SUPPLIER_ID);
            return(View(iTEMS_PURCHASE));
        }