public ActionResult DeleteConfirmed(string id)
        {
            FavouriteFilm favouriteFilm = db.FavouriteFilms.Find(id);

            db.FavouriteFilms.Remove(favouriteFilm);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "userId,filmId,film_name,favouriteFilmId")] FavouriteFilm favouriteFilm)
 {
     if (ModelState.IsValid)
     {
         db.Entry(favouriteFilm).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.filmId = new SelectList(db.Films, "id", "name", favouriteFilm.filmId);
     return(View(favouriteFilm));
 }
        // GET: FavouriteFilms/Details/5
        public ActionResult Details(string id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            FavouriteFilm favouriteFilm = db.FavouriteFilms.Find(id);

            if (favouriteFilm == null)
            {
                return(HttpNotFound());
            }
            return(View(favouriteFilm));
        }
        // GET: FavouriteFilms/Edit/5
        public ActionResult Edit(string id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            FavouriteFilm favouriteFilm = db.FavouriteFilms.Find(id);

            if (favouriteFilm == null)
            {
                return(HttpNotFound());
            }
            ViewBag.filmId = new SelectList(db.Films, "id", "name", favouriteFilm.filmId);
            return(View(favouriteFilm));
        }
        public ActionResult Create([Bind(Include = "userId,filmId,film_name,favouriteFilmId")] FavouriteFilm favouriteFilm)
        {
            string userId = User.Identity.GetUserId();

            favouriteFilm.userId    = userId;
            favouriteFilm.film_name = "new Film";
            if (ModelState.IsValid)
            {
                db.FavouriteFilms.Add(favouriteFilm);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.filmId = new SelectList(db.Films, "id", "name", favouriteFilm.filmId);
            return(View(favouriteFilm));
        }