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;
DB.MOVIES.Add(movie);
DB.MOVIEEXTENDS.Add(movieExtend);
DB.SaveChanges();
return(GetById(movie.movieImdbID, movie.userID));
}
else
{
return(DB.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 = DB.MOVIES.Where(m => m.movieImdbID.Equals(movieModel.imdbID)).SingleOrDefault();
MOVIEEXTEND movieExtend = DB.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;
DB.SaveChanges();
return(GetById(movie.movieImdbID, movie.userID));
}
else
{
return(DB.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 = DB.MOVIES.Where(m => m.movieImdbID.Equals(imdbID) && m.userID.Equals(userID)).SingleOrDefault();
MOVIEEXTEND movieExtend = DB.MOVIEEXTENDS.Where(m => m.movieImdbID.Equals(imdbID) && m.MOVy.userID.Equals(userID)).SingleOrDefault();
DB.MOVIES.Attach(movie);
DB.MOVIEEXTENDS.Attach(movieExtend);
if (movie == null)
{
return(0);
}
DB.MOVIEEXTENDS.Remove(movieExtend);
DB.MOVIES.Remove(movie);
DB.SaveChanges();
return(1);
}
else
{
return(DB.DeleteExtendedMovie(imdbID, userID));
}
}
