public static bool RemoveMovieFomCollection(this string title)
{
try
{
Film retrievedMovie = (from movie in Context.Films where movie.Title == title select movie).FirstOrDefault();
if (retrievedMovie != null && retrievedMovie.Title == title)
{
List <PersonFilmIndex> pfis =
(from pfi in Context.PersonFilmIndexes where pfi.FilmID == retrievedMovie.FilmID select pfi).
ToList();
pfis.ForEach(pfi => Context.PersonFilmIndexes.DeleteObject(pfi));
List <GenreFilmIndex> gfis =
(from gfi in Context.GenreFilmIndexes where gfi.FilmID == retrievedMovie.FilmID select gfi).
ToList();
gfis.ForEach(gfi => Context.GenreFilmIndexes.DeleteObject(gfi));
Context.Films.DeleteObject(retrievedMovie);
Context.SaveChanges();
return(true);
}
return(false);
}
catch (Exception ex)
{
Log.Error(ex);
ex.ThrowFormattedException();
throw;
}
}
public void Add(ActorDirector actorDirector)
{
using (var context = new MovieCollectionEntities())
{
context.ActorDirectors.Add(actorDirector);
context.SaveChanges();
}
}
public void Add(Location location)
{
using (var context = new MovieCollectionEntities())
{
context.Locations.Add(location);
context.SaveChanges();
}
}
public void Add(Movie movie)
{
using (var context = new MovieCollectionEntities())
{
context.Movies.Add(movie);
context.SaveChanges();
}
}
public void DeleteById(Guid id)
{
using (var context = new MovieCollectionEntities())
{
var existing = context.Locations.FirstOrDefault(l => l.Id == id);
context.Locations.Remove(existing);
context.SaveChanges();
}
}
public void DeleteById(Guid id)
{
using (var context = new MovieCollectionEntities())
{
var existing = context.Movies.Where(m => m.Id == id).FirstOrDefault();
context.Movies.Remove(existing);
context.SaveChanges();
}
}
public void Update(Location location)
{
using (var context = new MovieCollectionEntities())
{
var existingLocation = context.Locations.Where(l => l.Id == location.Id)
.FirstOrDefault();
existingLocation.Description = location.Description;
existingLocation.IsUrlRequired = location.IsUrlRequired;
context.SaveChanges();
}
}
public void Update(ActorDirector actorDirector)
{
using (var context = new MovieCollectionEntities())
{
var existingActorDirector = context.ActorDirectors.Where(ad => ad.Id == actorDirector.Id)
.FirstOrDefault();
existingActorDirector.Name = actorDirector.Name;
existingActorDirector.IsActor = actorDirector.IsActor;
existingActorDirector.IsDirector = actorDirector.IsDirector;
context.SaveChanges();
}
}
public void Update(Movie movie)
{
using (var context = new MovieCollectionEntities())
{
var existingMovie = context.Movies.Where(m => m.Id == movie.Id)
.FirstOrDefault();
existingMovie.Title = movie.Title;
existingMovie.Year = movie.Year;
existingMovie.ActorId = movie.ActorId;
existingMovie.DirectorId = movie.DirectorId;
existingMovie.LocationId = movie.LocationId;
existingMovie.LocationUrl = movie.LocationUrl;
context.SaveChanges();
}
}
