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();
//}
}
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);
//}
}
