public MovieExtendModel AddMovie(MovieExtendModel movieModel) { //if (GlobalVariable.queryType == 0) //{ MOVy movie = new MOVy { userID = movieModel.userID, movieImdbID = movieModel.imdbID, movieTitle = movieModel.title, moviePoster = movieModel.poster, movieYear = movieModel.year }; MOVIEEXTEND movieExtend = new MOVIEEXTEND { movieImdbID = movieModel.imdbID, moviePlot = movieModel.plot, movieUrl = movieModel.website, movieRated = movieModel.rated, movieImdbRating = movieModel.imdbRating, movieSeen = movieModel.seen, userID = movieModel.userID }; //movieExtend.MOVy = movie; imdbFavoritesEntities.MOVIES.Add(movie); imdbFavoritesEntities.MOVIEEXTENDS.Add(movieExtend); imdbFavoritesEntities.SaveChanges(); return(GetById(movie.movieImdbID, movie.userID)); //} //else //{ // return imdbFavoritesEntities.AddExtendedMovie(movieModel.imdbID, movieModel.title, movieModel.poster, movieModel.year, movieModel.userId, movieModel.plot, movieModel.website, movieModel.rated, movieModel.imdbRating, movieModel.seen).Select(m => new MovieExtendModel // { // userId = m.userID, // title = m.movieTitle, // poster = m.moviePoster, // year = m.movieYear, // imdbID = m.movieImdbID, // plot = m.moviePlot, // website = m.movieUrl, // rated = m.movieRated, // imdbRating = m.movieImdbRating.Value, // seen = m.movieSeen.Value // }).SingleOrDefault(); //} }
public MovieExtendModel UpdateMovie(MovieExtendModel movieModel) { //if (GlobalVariable.queryType == 0) //{ MOVy movie = imdbFavoritesEntities.MOVIES.Where(m => m.movieImdbID.Equals(movieModel.imdbID)).SingleOrDefault(); MOVIEEXTEND movieExtend = imdbFavoritesEntities.MOVIEEXTENDS.Where(m => m.movieImdbID.Equals(movieModel.imdbID)).SingleOrDefault(); if (movie == null) { return(null); } movie.userID = movieModel.userID; movie.movieImdbID = movieModel.imdbID; movie.movieTitle = movieModel.title; movie.moviePoster = movieModel.poster; movie.movieYear = movieModel.year; movieExtend.movieImdbID = movieModel.imdbID; movieExtend.moviePlot = movieModel.plot; movieExtend.movieUrl = movieModel.website; movieExtend.movieRated = movieModel.rated; movieExtend.movieImdbRating = movieModel.imdbRating; movieExtend.movieSeen = movieModel.seen; movieExtend.userID = movieModel.userID; imdbFavoritesEntities.SaveChanges(); return(GetById(movie.movieImdbID, movie.userID)); //} //else //{ // return imdbFavoritesEntities.UpdateExtendedMovie(movieModel.imdbID, movieModel.title, movieModel.poster, movieModel.year, movieModel.userId, movieModel.plot, movieModel.website, movieModel.rated, movieModel.imdbRating, movieModel.seen).Select(m => new MovieExtendModel // { // userId = m.userID, // title = m.movieTitle, // poster = m.moviePoster, // year = m.movieYear, // imdbID = m.movieImdbID, // plot = m.moviePlot, // website = m.movieUrl, // rated = m.movieRated, // imdbRating = m.movieImdbRating.Value, // seen = m.movieSeen.Value // }).SingleOrDefault(); //} }
private int DeleteMovieQuery(string imdbID, string userID) { MOVy movie = imdbFavoritesEntities.MOVIES.Where(m => m.movieImdbID.Equals(imdbID) && m.userID.Equals(userID)).SingleOrDefault(); imdbFavoritesEntities.MOVIES.Attach(movie); if (movie == null) { return(0); } imdbFavoritesEntities.MOVIES.Remove(movie); try { imdbFavoritesEntities.SaveChanges(); } catch (ValidationException ex) { Debug.WriteLine(ex.Message); return(0); } return(1); }
public int DeleteMovie(string imdbID, string userID) { //if (GlobalVariable.queryType == 0) //{ MOVy movie = imdbFavoritesEntities.MOVIES.Where(m => m.movieImdbID.Equals(imdbID) && m.userID.Equals(userID)).SingleOrDefault(); MOVIEEXTEND movieExtend = imdbFavoritesEntities.MOVIEEXTENDS.Where(m => m.movieImdbID.Equals(imdbID) && m.MOVy.userID.Equals(userID)).SingleOrDefault(); imdbFavoritesEntities.MOVIES.Attach(movie); imdbFavoritesEntities.MOVIEEXTENDS.Attach(movieExtend); if (movie == null) { return(0); } imdbFavoritesEntities.MOVIEEXTENDS.Remove(movieExtend); imdbFavoritesEntities.MOVIES.Remove(movie); imdbFavoritesEntities.SaveChanges(); return(1); //} //else //{ // return imdbFavoritesEntities.DeleteExtendedMovie(imdbID, userID); //} }
private MovieModel AddMovieQuery(MovieModel movieModel) { MOVy movie = new MOVy { userID = movieModel.userID, movieImdbID = movieModel.imdbID, movieTitle = movieModel.title, moviePoster = movieModel.poster, movieYear = movieModel.year }; imdbFavoritesEntities.MOVIES.Add(movie); try { imdbFavoritesEntities.SaveChanges(); } catch (ValidationException ex) { Debug.WriteLine(ex.Message); return(null); } return(GetById(movie.movieImdbID, movie.userID)); }
private MovieModel UpdateMovieQuery(MovieModel movieModel) { MOVy movie = imdbFavoritesEntities.MOVIES.Where(m => m.movieImdbID.Equals(movieModel.imdbID)).SingleOrDefault(); if (movie == null) { return(null); } movie.userID = movieModel.userID; movie.movieImdbID = movieModel.imdbID; movie.movieTitle = movieModel.title; movie.moviePoster = movieModel.poster; movie.movieYear = movieModel.year; try { imdbFavoritesEntities.SaveChanges(); } catch (ValidationException ex) { Debug.WriteLine(ex.Message); return(null); } return(GetById(movie.movieImdbID, movie.userID)); }