public MovieModel UpdateMovie(MovieModel movieModel)
{
if (GlobalVariable.queryType == 0)
{
MOVy movie = DB.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;
DB.SaveChanges();
return(GetById(movie.movieImdbID, movie.userID));
}
else
{
return(DB.AddMovie(movieModel.imdbID, movieModel.title, movieModel.poster, movieModel.year, movieModel.userID).Select(m => new MovieModel
{
userID = m.userID,
imdbID = m.movieImdbID,
title = m.movieTitle,
poster = m.moviePoster,
year = m.movieYear
}).SingleOrDefault());
}
}
// PUT: api/Movies/5
public IHttpActionResult PutMovie(int id, MOVy movie)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != movie.ID)
{
return(BadRequest());
}
db.Entry(movie).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (Exception)
{
if (!ModelState.IsValid)
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public MovieModel AddMovie(MovieModel movieModel)
{
if (GlobalVariable.queryType == 0)
{
MOVy movie = new MOVy
{
userID = movieModel.userID,
movieImdbID = movieModel.imdbID,
movieTitle = movieModel.title,
moviePoster = movieModel.poster,
movieYear = movieModel.year
};
DB.MOVIES.Add(movie);
DB.SaveChanges();
return(GetById(movie.movieImdbID, movie.userID));
}
else
{
return(DB.AddMovie(movieModel.imdbID, movieModel.title, movieModel.poster, movieModel.year, movieModel.userID).Select(m => new MovieModel
{
userID = m.userID,
imdbID = m.movieImdbID,
title = m.movieTitle,
poster = m.moviePoster,
year = m.movieYear
}).SingleOrDefault());
}
}
public IHttpActionResult GetMovie(int id)
{
MOVy movie = db.MOVIES.Find(id);
if (movie == null)
{
return(NotFound());
}
return(Ok(movie));
}
public IHttpActionResult PostMovie(MOVy movie)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.MOVIES.Add(movie);
db.SaveChanges();
return(CreatedAtRoute("defaultApi", new { id = movie.ID }, movie));
}
public IHttpActionResult DeleteMovie(int id)
{
MOVy movie = db.MOVIES.Find(id);
if (movie == null)
{
return(NotFound());
}
db.MOVIES.Remove(movie);
db.SaveChanges();
return(StatusCode(HttpStatusCode.NoContent));
}
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();
DB.MOVIES.Attach(movie);
if (movie == null)
{
return(0);
}
DB.MOVIES.Remove(movie);
DB.SaveChanges();
return(1);
}
else
{
return(DB.DeleteMovie(imdbID, userID));
}
}
