public List <MovieWatchlist> GetMovieWatchlist() { string str = (string)Session["username"].ToString(); var db = new MovieTimeEntities6(); List <MovieWatchlist> x = db.MovieWatchlists.Where(m => m.UserID.Equals(str)).ToList().DistinctBy(m => m.WatchlistName).ToList(); return(x); }
public ActionResult RemoveMovieFromYourList(string id, string title, string watchlistname, string release_date) { var db = new MovieTimeEntities6(); string str = (string)Session["username"].ToString(); MovieWatchlist MovieWatchlist = db.MovieWatchlists.Where(movie => movie.Title.Equals(title) && movie.UserID.Equals(str) && movie.Release_date.Equals(release_date) && movie.WatchlistName.Equals(watchlistname)).FirstOrDefault(); db.Entry(MovieWatchlist).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); return(Redirect($"~/Movie/ShowMovieWatchlist/{watchlistname}")); }
public ActionResult AddToMovieWatchlist(string id, string title, string watchlistname, string release_date) { MovieWatchlist MovieWatchlist = new MovieWatchlist(); var db = new MovieTimeEntities6(); string UserID = (string)Session["username"].ToString(); var listofMovies = db.MovieWatchlists.Where(x => x.WatchlistName.Equals(watchlistname)).ToList(); if (listofMovies.Count == 0) { return(RedirectToAction("Index", "Movie")); } Random rnd = new Random(); MovieWatchlist.ID = rnd.Next(1, 10000000).ToString(); List <MovieWatchlist> check = db.MovieWatchlists.Where(m => m.ID.Equals(MovieWatchlist.ID) && m.UserID.Equals(UserID)).ToList(); while (check.Count != 0) { MovieWatchlist.ID = rnd.Next(1, 10000000).ToString(); check = db.MovieWatchlists.Where(m => m.ID.Equals(MovieWatchlist.ID) && m.UserID.Equals(UserID)).ToList(); } foreach (var movie in Movies.Movies) { if (movie.Title.Equals(title) && movie.Release_date.Equals(release_date)) { MovieWatchlist.UserID = UserID; MovieWatchlist.WatchlistName = watchlistname; MovieWatchlist.Overview = movie.Overview; MovieWatchlist.Popularity = movie.Popularity.ToString(); MovieWatchlist.Release_date = movie.Release_date; MovieWatchlist.Poster_path = movie.Poster_path; MovieWatchlist.Title = movie.Title; MovieWatchlist.MovieID = movie.Id; break; } } db.Entry(MovieWatchlist).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); Movies.Search = null; MoviesModel temp = new MoviesModel(); temp = Movies; temp.Watchlist = GetMovieWatchlist(); return(View(temp)); }
public ActionResult ShowMovieWatchlist(string id) { string str = Session["username"].ToString(); var db = new MovieTimeEntities6(); List <MovieWatchlist> UniqueNames = GetMovieWatchlist(); List <MovieWatchlist> x = db.MovieWatchlists.Where(m => m.UserID.Equals(str) && m.WatchlistName.Equals(id)).ToList(); Movies.Watchlist = x; if (x == null) { return(RedirectToAction("Index", "Movie")); } ViewBag.Message = "Logged"; return(View(x)); }
public ActionResult CreateMovieWatchlist(MovieWatchlist model) { Random rnd = new Random(); string str = (string)Session["username"].ToString(); var db = new MovieTimeEntities6(); // int count = db.MovieWatchlists.Count(); if (str == null) { return(View()); } MovieWatchlist MovieWatchlist = new MovieWatchlist(); MovieWatchlist.ID = rnd.Next(1, 10000000).ToString(); List <MovieWatchlist> check = db.MovieWatchlists.Where(m => m.ID.Equals(MovieWatchlist.ID)).ToList(); while (check.Count != 0) { MovieWatchlist.ID = rnd.Next(1, 10000000).ToString(); check = db.MovieWatchlists.Where(m => m.ID.Equals(MovieWatchlist.ID)).ToList(); } MovieWatchlist.UserID = str; check = db.MovieWatchlists.Where(m => m.WatchlistName.Equals(model.WatchlistName) && m.UserID.Equals(str)).ToList(); if (check.Count == 0) { MovieWatchlist.WatchlistName = model.WatchlistName; db.Entry(MovieWatchlist).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); } else { ViewBag.Message = "MovieWatchlist Name Exitst Already!"; return(View(new MovieWatchlist())); } return(RedirectToAction("index", "Movie")); }