public void AddActors(Movie entity, List <Actor> actors) { using (MovieLibraryEntities context = new MovieLibraryEntities()) { context.Movie.Attach(entity); foreach (Actor actor in actors) { context.Actor.Attach(actor); context.Entry(actor).State = System.Data.Entity.EntityState.Unchanged; entity.Actor.Add(actor); } context.Entry(entity).State = System.Data.Entity.EntityState.Unchanged; context.SaveChanges(); } }
public void Modify(Image entity) { using (MovieLibraryEntities context = new MovieLibraryEntities()) { context.Image.Attach(entity); context.Entry(entity).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void Delete(Movie entity) { using (MovieLibraryEntities context = new MovieLibraryEntities()) { context.Movie.Attach(entity); context.Entry(entity).Collection("Comment").Load(); context.Entry(entity).Collection("Actor").Load(); List <Comment> comments = entity.Comment.ToList(); List <Actor> actors = entity.Actor.ToList(); foreach (Comment comment in comments) { context.Comment.Remove(comment); } foreach (Actor actor in actors) { entity.Actor.Remove(actor); } context.Movie.Remove(entity); context.SaveChanges(); } }
public void DeleteActors(Movie entity, List <int> Id_actors) { using (MovieLibraryEntities context = new MovieLibraryEntities()) { context.Movie.Attach(entity); context.Entry(entity).Collection("Actor").Load(); foreach (int Id_actor in Id_actors) { entity.Actor.Remove(entity.Actor.FirstOrDefault(s => s.Id_actor == Id_actor)); } context.SaveChanges(); } }
public void Delete(Actor entity) { using (MovieLibraryEntities context = new MovieLibraryEntities()) { context.Actor.Attach(entity); context.Entry(entity).Collection("Movie").Load(); List <Movie> movies = entity.Movie.ToList(); foreach (Movie movie in movies) { entity.Movie.Remove(movie); } context.Actor.Remove(entity); context.SaveChanges(); } }