public static void InitializeDBConnection() { if (Context == null) { Context = new MovieCollectionEntities(); } }
public List <MovieResult> Search(string title, int year, Guid actorId, Guid directorId, Guid locationId) { var results = new List <MovieResult>(); using (var context = new MovieCollectionEntities()) { results.AddRange(context.MovieResults); if (!string.IsNullOrEmpty(title)) { results = results.Where(m => m.Title.ToUpper() .Contains(title.ToUpper())).ToList(); } if (year > 0) { results = results.Where(m => m.Year == year).ToList(); } if (actorId != Guid.Empty) { results = results.Where(m => m.ActorId == actorId).ToList(); } if (directorId != Guid.Empty) { results = results.Where(m => m.DirectorId == directorId).ToList(); } if (locationId != Guid.Empty) { results = results.Where(m => m.LocationId == locationId).ToList(); } } return(results); }
public void Add(Location location) { using (var context = new MovieCollectionEntities()) { context.Locations.Add(location); context.SaveChanges(); } }
public void Add(ActorDirector actorDirector) { using (var context = new MovieCollectionEntities()) { context.ActorDirectors.Add(actorDirector); context.SaveChanges(); } }
public void Add(Movie movie) { using (var context = new MovieCollectionEntities()) { context.Movies.Add(movie); context.SaveChanges(); } }
public static IList <Person> GetAllActors() { using (MovieCollectionEntities entity = new MovieCollectionEntities()) { return (entity.PersonFilmIndexes.Where(pfi => pfi.RoleID == FilmRole.ActorRole.RoleID).Select( pfi => pfi.Person).Distinct().ToList()); } }
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 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 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(); } }
private IEnumerable <ActorDirector> GetListOfTypeForCombo(string firstItemText, bool isForDirectors = false) { var dummyActor = new ActorDirector { Id = Guid.Empty, Name = firstItemText }; var results = new List <ActorDirector> { dummyActor }; using (MovieCollectionEntities context = new MovieCollectionEntities()) results.AddRange(context.ActorDirectors .Where(a => isForDirectors ? a.IsDirector : a.IsActor) .OrderBy(a => a.Name)); return(results); }
public static IList <Film> RunSearch( string paramActorLast = null, string paramActorFirst = null, string paramWriterLast = null, string paramWriterFirst = null, string paramDirectorLast = null, string paramDirectorFirst = null, List <string> paramGenres = null, List <string> paramRatings = null, int paramMax = 0, int paramMin = 0) { using (MovieCollectionEntities context = new MovieCollectionEntities()) { IQueryable <Film> mq = context.Films.Include("Rating") .Include("GenreFilmIndexes.Genre") .Include("PersonFilmIndexes.Person") .Select(o => o); if (paramRatings != null && paramRatings.Count > 0) { mq = mq.Where(o => paramRatings.Contains(o.Rating.MPAARating)); } if (paramMin > 0) { mq = mq.Where(o => o.Length >= paramMin); } if (paramMax > 0) { mq = mq.Where(o => o.Length <= paramMax); } if (paramGenres != null && paramGenres.Count > 0) { mq = mq.Where(o => paramGenres.Any(gn => (o.GenreFilmIndexes .Select(gfi => gfi.Genre.Name)).Contains(gn))); } mq = mq.SearchByPersonNameAndRole(paramActorFirst, FilmRole.ActorRole.RoleID, true); mq = mq.SearchByPersonNameAndRole(paramActorLast, FilmRole.ActorRole.RoleID); mq = mq.SearchByPersonNameAndRole(paramWriterFirst, FilmRole.ActorRole.RoleID, true); mq = mq.SearchByPersonNameAndRole(paramWriterLast, FilmRole.ActorRole.RoleID); mq = mq.SearchByPersonNameAndRole(paramDirectorFirst, FilmRole.DirectorRole.RoleID, true); mq = mq.SearchByPersonNameAndRole(paramDirectorLast, FilmRole.DirectorRole.RoleID); return(mq.Distinct().ToList()); } }
public IEnumerable<Location> GetList(bool showPleaseSelect = false) { var results = new List<Location>(); if (showPleaseSelect) { var dummyLocation = new Location { Id = Guid.Empty, Description = "<Please Select>" }; results.Add(dummyLocation); } using (var context = new MovieCollectionEntities()) results.AddRange(context.Locations.OrderBy(l => l.Description)); return results; }
public bool IsExistingByActorId(Guid actorId) { using (var context = new MovieCollectionEntities()) return(context.Movies.Any(m => m.ActorId == actorId)); }
public bool IsExistingByDescription(string description, Guid excludedId) { using (var context = new MovieCollectionEntities()) return context.Locations .Any(l => l.Description.ToUpper() == description.ToUpper() && l.Id != excludedId); }
public static void SaveAndRefreshDBConnection() { Context.SaveChanges(); Context = new MovieCollectionEntities(); }
public Movie GetById(Guid id) { using (var context = new MovieCollectionEntities()) return(context.Movies.FirstOrDefault(m => m.Id == id)); }
public IEnumerable <ActorDirector> GetList() { using (var context = new MovieCollectionEntities()) return(context.ActorDirectors.ToList()); }
public bool IsExistingByLocationId(Guid locationId) { using (var context = new MovieCollectionEntities()) return(context.Movies.Any(m => m.LocationId == locationId)); }
public bool IsExistingByName(string name, Guid id) { using (var context = new MovieCollectionEntities()) return(context.ActorDirectors .Any(ad => ad.Name.ToUpper() == name.ToUpper() && ad.Id != id)); }