public bool saveMovie(Movie_Master newMovie)
{
db.MovieMaster.Add(newMovie.movie);
db.SaveChanges();
long newid = newMovie.movie.MovieId;
foreach (var item in newMovie.actors)
{
db.CastingDetails.Add(new CastingDetails
{
ActorId = item.ActorId,
MovieId = newid
});
}
db.SaveChanges();
return(true);;
}
public List <Movie_Master> GetMovieList()
{
List <MovieMaster> movieList = db.MovieMaster.ToList();
foreach (var movie in movieList)
{
var movie_info = new Movie_Master();
movie_info.movie = movie;
List <ActorMaster> actorList = new List <ActorMaster>();
List <CastingDetails> movieActors = db.CastingDetails.Where(it => it.MovieId == movie.MovieId).ToList();
movie_info.producer = db.ProducerMaster.Where(it => it.ProdId == movie.ProdId).FirstOrDefault();
foreach (var actor in movieActors)
{
var actorObj = db.ActorMaster.Where(it => it.ActorId == actor.ActorId).FirstOrDefault();
actorList.Add(actorObj);
}
movie_info.actors = actorList;
movies.Add(movie_info);
}
return(movies);
}
public bool updateMovie(Movie_Master newMovie)
{
var movieId = newMovie.movie.MovieId;
var movie = db.MovieMaster.Where(it => it.MovieId == movieId).FirstOrDefault();
if (movie != null)
{
movie.MovieName = newMovie.movie.MovieName;
movie.Plot = newMovie.movie.Plot;
movie.ProdId = newMovie.movie.ProdId;
movie.ReleaseYear = newMovie.movie.ReleaseYear;
movie.Thumbnail = newMovie.movie.Thumbnail;
db.SaveChanges();
db.CastingDetails.RemoveRange(db.CastingDetails.Where(x => x.MovieId == movieId));
foreach (var item in newMovie.actors)
{
db.CastingDetails.Add(new CastingDetails
{
ActorId = item.ActorId,
MovieId = movieId
});
}
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}