public ActionResult Reserver(int id)
        {
            if (Session["UserID"] != null && Session["role"].ToString() == "client")
            {
                int id_user = int.Parse((Session["UserID"].ToString()));
                var exist   = db.Effectuers.Where(a => a.id_abonnement == id && a.id_client == id_user).FirstOrDefault();
                if (exist != null)
                {
                    string msg = "Abonnement already exist !"; return(RedirectToAction("index", "effectuers", new { id = id_user, message = msg }));
                }
                Abonnement ab    = db.Abonnements.Find(id);
                var        annee = ab.date_fin.Year - ab.date_debut.Year;

                var date = ab.date_fin.Subtract(System.DateTime.Now).Days;

                Effectuer res = new Effectuer {
                    id_client = id_user, id_abonnement = id, duree = date
                };
                db.Effectuers.Add(res);
                db.SaveChanges();
                return(RedirectToAction("Index", "Effectuers", new { id = Session["UserID"] }));
            }
            else
            {
                return(RedirectToAction("Login", "Home"));
            }
        }
 public ActionResult DeleteConfirmed(int id1, int id2)
 {
     if (Session["UserID"] != null && Session["role"].ToString() == "client")
     {
         Effectuer effectuer = db.Effectuers.Find(id1, id2);
         db.Effectuers.Remove(effectuer);
         db.SaveChanges();
         return(RedirectToAction("Index", new { id = id1 }));
     }
     return(RedirectToAction("login", "home"));
 }
        // GET: Effectuers/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Effectuer effectuer = db.Effectuers.Find(id);

            if (effectuer == null)
            {
                return(HttpNotFound());
            }
            return(View(effectuer));
        }
 public ActionResult Edit([Bind(Include = "id_client,id_abonnement,duree")] Effectuer effectuer)
 {
     if (Session["UserID"] != null && Session["role"].ToString() == "client")
     {
         if (ModelState.IsValid)
         {
             db.Entry(effectuer).State = EntityState.Modified;
             db.SaveChanges();
             return(RedirectToAction("Index"));
         }
         ViewBag.id_abonnement = new SelectList(db.Abonnements, "id_abonnement", "id_abonnement", effectuer.id_abonnement);
         ViewBag.id_client     = new SelectList(db.Clients, "id_utilisateur", "id_utilisateur", effectuer.id_client);
         return(View(effectuer));
     }
     return(RedirectToAction("login", "home"));
 }
 // GET: Effectuers/Delete/5
 public ActionResult Delete(int?id1, int?id2)
 {
     if (Session["UserID"] != null && Session["role"].ToString() == "client")
     {
         if (id1 == null || id2 == null)
         {
             return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
         }
         Effectuer effectuer = db.Effectuers.Find(id1, id2);
         if (effectuer == null)
         {
             return(HttpNotFound());
         }
         return(View(effectuer));
     }
     return(RedirectToAction("login", "home"));
 }
 // GET: Effectuers/Edit/5
 public ActionResult Edit(int?id)
 {
     if (Session["UserID"] != null && Session["role"].ToString() == "client")
     {
         if (id == null)
         {
             return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
         }
         Effectuer effectuer = db.Effectuers.Find(id);
         if (effectuer == null)
         {
             return(HttpNotFound());
         }
         ViewBag.id_abonnement = new SelectList(db.Abonnements, "id_abonnement", "id_abonnement", effectuer.id_abonnement);
         ViewBag.id_client     = new SelectList(db.Clients, "id_utilisateur", "id_utilisateur", effectuer.id_client);
         return(View(effectuer));
     }
     return(RedirectToAction("login", "home"));
 }