public ActionResult DeleteConfirmed(int id)
        {
            Reivew reivew = db.Reviews.Find(id);

            db.Reviews.Remove(reivew);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "ReivewId,Title,Comments,DateAdded,Marks,FilmId,UserId")] Reivew reivew)
 {
     if (ModelState.IsValid)
     {
         db.Entry(reivew).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.FilmId = new SelectList(db.Film, "FilmId", "FilmName", reivew.FilmId);
     ViewBag.UserId = new SelectList(db.user, "UserId", "UserName", reivew.UserId);
     return(View(reivew));
 }
        public ActionResult Create([Bind(Include = "ReivewId,Title,Comments,DateAdded,Marks,FilmId,UserId")] Reivew reivew)
        {
            if (ModelState.IsValid)
            {
                db.Reviews.Add(reivew);
                db.SaveChanges();
                return(RedirectToAction("FilmReviews", new { filmId = reivew.FilmId }));
            }

            ViewBag.FilmId = new SelectList(db.Film, "FilmId", "FilmName", reivew.FilmId);
            ViewBag.UserId = new SelectList(db.user, "UserId", "UserName", reivew.UserId);
            return(View(reivew));
        }
        // GET: Reivews/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Reivew reivew = db.Reviews.Find(id);

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

            if (reivew == null)
            {
                return(HttpNotFound());
            }
            ViewBag.FilmId = new SelectList(db.Film, "FilmId", "FilmName", reivew.FilmId);
            ViewBag.UserId = new SelectList(db.user, "UserId", "UserName", reivew.UserId);
            return(View(reivew));
        }