/// <summary>
        ///  Affichage des details du contrate selectionné
        /// </summary>
        /// <param name="id">id du contrat sélectionné</param>
        /// <returns>vue details</returns>
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tbl_607_order tbl_607_order = db.tbl_607_order.Find(id);

            if (tbl_607_order == null)
            {
                return(HttpNotFound());
            }
            return(View(tbl_607_order));
        }
        /// <summary>
        /// affiche la page d'édition d'un contrat
        /// </summary>
        /// <param name="id">id du contrat séléctionné</param>
        /// <returns>vue d'édition</returns>
        // GET: Contracts/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tbl_607_order tbl_607_order = db.tbl_607_order.Find(id);

            if (tbl_607_order == null)
            {
                return(HttpNotFound());
            }
            ViewBag.FK_ID_provider = new SelectList(db.tbl_607_provider, "ID", "provider_name", tbl_607_order.FK_ID_provider);
            return(View(tbl_607_order));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            tbl_607_order tbl_607_order = db.tbl_607_order.Find(id);

            db.tbl_607_order.Remove(tbl_607_order);
            try
            {
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }
            catch (DbEntityValidationException ex)
            {
                string s = ex.Message;
                return(RedirectToAction("../Ooops", new { message = s }));
            }
        }
 public ActionResult Edit([Bind(Include = "ID,start_date,end_date,order_number,shipping_request_active,item_reception_active,FK_ID_provider")] tbl_607_order tbl_607_order)
 {
     if (ModelState.IsValid)
     {
         db.Entry(tbl_607_order).State = EntityState.Modified;
         try
         {
             db.SaveChanges();
             return(RedirectToAction("Index"));
         }
         catch (DbEntityValidationException ex)
         {
             string s = ex.Message;
             return(RedirectToAction("../Ooops", new { message = s }));
         }
     }
     ViewBag.FK_ID_provider = new SelectList(db.tbl_607_provider, "ID", "provider_name", tbl_607_order.FK_ID_provider);
     return(View(tbl_607_order));
 }