public ActionResult DeleteConfirmed(int id)
        {
            Reatiler reatiler = db.retailer.Find(id);

            db.retailer.Remove(reatiler);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        // GET: Reatilers/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Reatiler reatiler = db.retailer.Find(id);

            if (reatiler == null)
            {
                return(HttpNotFound());
            }
            return(View(reatiler));
        }
 public ActionResult Edit([Bind(Include = "ID,Name,Weight,UnitPrice,PhoneNumber,Total,date,OrderID")] Reatiler reatiler)
 {
     if (ModelState.IsValid)
     {
         //updating remaining weight value of current order
         var order = db.order.Find(reatiler.OrderID);
         order.TotalWeightLeft   -= reatiler.Weight;
         reatiler.Total           = reatiler.Weight * reatiler.UnitPrice;
         db.Entry(reatiler).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.OrderID = new SelectList(db.order, "OrderID", "OrderNumber", reatiler.OrderID);
     return(View(reatiler));
 }
        // GET: Reatilers/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Reatiler reatiler = db.retailer.Find(id);

            if (reatiler == null)
            {
                return(HttpNotFound());
            }
            ViewBag.OrderID = new SelectList(db.order.Where(o => o.TotalWeightLeft > 0), "OrderID", "OrderNumber", reatiler.OrderID);
            return(View(reatiler));
        }