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 static void InitializeDBConnection()
{
if (Context == null)
{
Context = new MovieCollectionEntities();
}
}
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));
}
