public ActionResult DeleteConfirmed(int id)
        {
            PersonalCabinet personalCabinet = db.PersonalCabinets.Find(id);

            db.PersonalCabinets.Remove(personalCabinet);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "Id,Mark,EcolabelID,PersonID")] PersonalCabinet personalCabinet)
 {
     if (ModelState.IsValid)
     {
         db.Entry(personalCabinet).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.EcolabelID = new SelectList(db.Ecolabels, "Id", "Name", personalCabinet.EcolabelID);
     ViewBag.PersonID   = new SelectList(db.People, "Id", "Login", personalCabinet.PersonID);
     return(View(personalCabinet));
 }
        // GET: PersonalCabinets/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            PersonalCabinet personalCabinet = db.PersonalCabinets.Find(id);

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

            if (personalCabinet == null)
            {
                return(HttpNotFound());
            }
            ViewBag.EcolabelID = new SelectList(db.Ecolabels, "Id", "Name", personalCabinet.EcolabelID);
            ViewBag.PersonID   = new SelectList(db.People, "Id", "Login", personalCabinet.PersonID);
            return(View(personalCabinet));
        }
        public ActionResult MakeAMarkAuthUser(int Mark, int id)
        {
            if (ModelState.IsValid)
            {
                PersonalCabinet pc = new PersonalCabinet();
                pc.EcolabelID = id;
                pc.Mark       = Mark;
                var   user = User.Identity.Name;
                int[] ID   = new int[1];
                ID = (from p in db.People
                      where p.Login == user
                      select p.Id).ToArray();
                Person findUser = db.People.Find(ID[0]);

                List <int> delete = new List <int>();
                delete = (from perCab in db.PersonalCabinets
                          where perCab.EcolabelID == id
                          where perCab.PersonID == findUser.Id
                          select perCab.Id).ToList();
                foreach (int elem in delete)
                {
                    db.PersonalCabinets.Remove(db.PersonalCabinets.Find(elem));
                }

                pc.PersonID = findUser.Id;
                db.PersonalCabinets.Add(pc);
                db.SaveChanges();
                return(RedirectToAction("IndexAuthUser"));
            }
            List <int> marks = new List <int> {
                1, 2, 3, 4, 5, 6, 7, 8, 9, 10
            };

            ViewBag.Mark = new SelectList(marks);
            return(View());
        }