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 int Create(Image entity)
{
using (MovieLibraryEntities context = new MovieLibraryEntities())
{
context.Image.Add(entity);
context.SaveChanges();
return(entity.Id_Image);
}
}
public void Delete(Image entity)
{
using (MovieLibraryEntities context = new MovieLibraryEntities())
{
context.Image.Attach(entity);
context.Image.Remove(entity);
context.SaveChanges();
}
}
public int Create(Actor entity)
{
using (MovieLibraryEntities context = new MovieLibraryEntities())
{
context.Actor.Add(entity);
context.SaveChanges();
return(entity.Id_actor);
}
}
public int Create(Comment entity)
{
using (MovieLibraryEntities context = new MovieLibraryEntities())
{
context.Comment.Add(entity);
context.SaveChanges();
return(entity.Id_comment);
}
}
public void Delete(Director entity)
{
using (MovieLibraryEntities context = new MovieLibraryEntities())
{
context.Director.Attach(entity);
context.Director.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();
}
}
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 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();
}
}
