public void AddMovie(Movie movie, List <int> actorIds) { using (WatchDb db = new WatchDb()) { db.Movies.Add(movie); db.SaveChanges(); foreach (int id in actorIds) { Actor actor = db.Actors.Find(id); if (actor != null) { movie.Actors.Add(actor); } } db.SaveChanges(); } }
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 AddCategory(Category category) { using (WatchDb db = new WatchDb()) { db.Categories.Add(category); db.SaveChanges(); } }
public void DeleteActor(int id) { using (WatchDb db = new WatchDb()) { Actor actor = db.Actors.Find(id); db.Actors.Remove(actor); 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 UpdateDirector(Director director) { using (WatchDb db = new WatchDb()) { //kanonikos tropos db.Directors.Attach(director); //kane mou attach ton actor sto db set db.Entry(director).State = EntityState.Modified; //dld allakse tou to entity framework state. edw to entity ksekinaei na parakolouthei th metavlhth kai tou lew ti allagh egine db.SaveChanges(); } }
public void UpdateMovie(Movie movie, List <int> actorIds) { using (WatchDb db = new WatchDb()) { db.Movies.Attach(movie); db.Entry(movie).Collection("Actors").Load(); movie.Actors.Clear(); db.SaveChanges(); foreach (int id in actorIds) { Actor actor = db.Actors.Find(id); if (actor != null) { movie.Actors.Add(actor); } } db.Entry(movie).State = EntityState.Modified; db.SaveChanges(); } }
public void UpdateActor(Actor actor) { using (WatchDb db = new WatchDb()) { #region First way example, not used ////aploikos tropos skepshs kai mh fysiologikos/apodotikos //Actor db_actor = db.Actors.Find(actor.Id); // vres mou apo th vash ton actor me to id pou psaxnw (to entity framework to kanei track afou proilthe apo th vash //db_actor.Name = actor.Name; // update first property //db_actor.Age = actor.Age; // update second property //db.SaveChanges(); #endregion //kanonikos tropos db.Actors.Attach(actor); //kane mou attach ton actor sto db set db.Entry(actor).State = EntityState.Modified; //dld allakse tou to entity framework state. edw to entity ksekinaei na parakolouthei th metavlhth kai tou lew ti allagh egine db.SaveChanges(); } }