public void AddActor(Actor actor)
{
using (WatchDb db = new WatchDb())
{
db.Actors.Add(actor);
db.SaveChanges();
}
}
public void AddDirector(Director director)
{
using (WatchDb db = new WatchDb())
{
db.Directors.Add(director);
db.SaveChanges();
}
}
public void AddCategory(Category category)
{
using (WatchDb db = new WatchDb())
{
db.Categories.Add(category);
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 UpdateActor2(Actor actor)
{
using (WatchDb db = new WatchDb())
{
db.Actors.Attach(actor);
db.Entry(actor).State = EntityState.Modified;
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 DeleteCategory(string name)
{
using (WatchDb db = new WatchDb())
{
Category category = db.Categories.Find(name);
db.Categories.Remove(category);
db.SaveChanges();
}
}
public Movie GetMovieFull(int id)
{
Movie result;
using (WatchDb db = new WatchDb())
{
result = db.Movies.Include("Category").Include("Director").Include("Actors").Where(x => x.Id == id).FirstOrDefault();
}
return(result);
}
public Movie GetMovie(int id)
{
Movie result;
using (WatchDb db = new WatchDb())
{
result = db.Movies.Find(id);
}
return(result);
}
public ICollection <Movie> GetMovies()
{
ICollection <Movie> result;
using (WatchDb db = new WatchDb())
{
result = db.Movies.Include("Category").Include("Director").Include("Actors").ToList();
}
return(result);
}
public Category GetCategory(string name)
{
Category result;
using (WatchDb db = new WatchDb())
{
result = db.Categories.Find(name);
}
return(result);
}
// categories
public ICollection <Category> GetCategories()
{
ICollection <Category> result;
using (WatchDb db = new WatchDb())
{
result = db.Categories.ToList();
}
return(result);
}
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 Actor GetActor(int id)
{
Actor result;
using (WatchDb db = new WatchDb())
{
result = db.Actors.Find(id);
}
return(result);
}
public Director GetDirector(int id)
{
Director result;
using (WatchDb db = new WatchDb())
{
result = db.Directors.Find(id);
}
return(result);
}
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();
}
}
//director
public ICollection <Director> GetDirectors()
{
ICollection <Director> result;
using (WatchDb db = new WatchDb())
{
result = db.Directors.ToList();
}
return(result);
}
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();
}
}
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 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();
}
}