public void AddDirector(Director director) { using (WatchDb db = new WatchDb()) { db.Directors.Add(director); db.SaveChanges(); } }
public void AddActor(Actor actor) { using (WatchDb db = new WatchDb()) { db.Actors.Add(actor); db.SaveChanges(); } }
public void AddMovie(Movie movie, List <int> actorsIds) { using (WatchDb db = new WatchDb()) { db.Movies.Add(movie); db.SaveChanges(); foreach (var id in actorsIds) { Actor actor = db.Actors.Find(id); if (actor != null) { movie.Actors.Add(actor); } } db.SaveChanges(); } }
public void AddCategory(Category category) { using (WatchDb db = new WatchDb()) { db.Categories.Add(category); db.SaveChanges(); } }
public void UpdateActor2(Actor actor) { using (WatchDb db = new WatchDb()) { db.Actors.Attach(actor); db.Entry(actor).State = EntityState.Modified; db.SaveChanges(); } }
public void DeleteMovie(int id) { using (WatchDb db = new WatchDb()) { Movie movie = db.Movies.Find(id); db.Movies.Remove(movie); db.SaveChanges(); } }
public void DeleteCategory(string name) { using (WatchDb db = new WatchDb()) { Category category = db.Categories.Find(name); db.Categories.Remove(category); db.SaveChanges(); } }
public void DeleteDirector(int id) { using (WatchDb db = new WatchDb()) { Director director = db.Directors.Find(id); db.Directors.Remove(director); db.SaveChanges(); } }
public void UpdateActor(Actor actor) { using (WatchDb db = new WatchDb()) { Actor db_actor = db.Actors.Find(actor.Id); db_actor.Name = actor.Name; db_actor.Age = actor.Age; db.SaveChanges(); } }
public void UpdateDirector(Director director) { using (WatchDb db = new WatchDb()) { Director db_director = db.Directors.Find(director.Id); db_director.Name = director.Name; db_director.Age = director.Age; db.SaveChanges(); } }
public void UpdateMovie(Movie movie, List <int> actorsIds) { using (WatchDb db = new WatchDb()) { db.Movies.Attach(movie); db.Entry(movie).Collection("Actors").Load(); movie.Actors.Clear(); db.SaveChanges(); foreach (int id in actorsIds) { Actor actor = db.Actors.Find(id); if (actor != null) { movie.Actors.Add(actor); } } db.Entry(movie).State = EntityState.Modified; db.SaveChanges(); } }
public void DeleteActor(int id) { using (WatchDb db = new WatchDb()) { Actor actor = db.Actors.Find(id); //1st way db.Actors.Remove(actor); //2nd way // db.Entry(actor).State = Entity.Deleted; db.SaveChanges(); } }