public List <TEntityDTO> GetAllEntities()
{
using (var dbContext = new ProjectManhattanEntities())
{
return(dbContext.Set <TEntity>().ToList().Select(m => Mapper.Map <TEntityDTO>(m)).ToList());
}
}
public TEntityDTO GetEntity(int id)
{
using (var dbContext = new ProjectManhattanEntities())
{
var entity = dbContext.Set <TEntity>().Find(id);
return(entity != null?Mapper.Map <TEntityDTO>(entity) : null);
}
}
public void DeleteEntity(int id)
{
using (var dbContext = new ProjectManhattanEntities())
{
var entity = dbContext.Set <TEntity>().Find(id);
if (entity != null)
{
dbContext.Set <TEntity>().Remove(entity);
dbContext.SaveChanges();
}
}
}
public List <MovieSummaryDTO> GetMovies(string searchString = "")
{
using (var dbContext = new ProjectManhattanEntities())
{
var movieSummaries = dbContext.Movies.Where(r => r.Name.Contains(searchString))
.Include(m => m.CriticMovieRatings)
.Include(m => m.UserMovieRatings)
.Include(m => m.MovieArtists)
.Include(m => m.MovieArtists.Select(ma => ma.Artist))
.ToList();
return(movieSummaries.Select(Mapper.Map <MovieSummaryDTO>).ToList());
}
}
public List <MovieTrailerDTO> GetMovieTrailers()
{
List <MovieTrailerDTO> movieTrailerDtos;
using (var dbContext = new ProjectManhattanEntities())
{
var movieTrailers = dbContext.MovieTrailers
.Take(100)
.Include(m => m.Movie).ToList();
movieTrailerDtos = movieTrailers.Select(Mapper.Map <MovieTrailerDTO>).ToList();
}
return(movieTrailerDtos);
}
public MovieDetailDTO GetMovieInfo(int movieId)
{
using (var dbContext = new ProjectManhattanEntities())
{
var movie = dbContext.Movies.Where(m => m.MovieId == movieId)
.Include(m => m.CriticMovieRatings)
.Include(m => m.CriticMovieRatings.Select(cm => cm.Critic))
.Include(m => m.UserMovieRatings)
.Include(m => m.MovieArtists)
.Include(m => m.MovieArtists.Select(ma => ma.Artist))
.Include(m => m.MovieDistributors)
.Include(m => m.MovieDistributors.Select(md => md.Distributor))
.FirstOrDefault();
return(movie == null ? null : Mapper.Map <MovieDetailDTO>(movie));
}
}
public MovieTrailerDTO GetMovieTrailer(int id)
{
using (var dbContext = new ProjectManhattanEntities())
{
MovieTrailer movieTrailer = dbContext.MovieTrailers
.Where(m => m.MovieTrailerId == id)
.Include(m => m.Movie)
.FirstOrDefault();
if (movieTrailer != null)
{
var movieTrailerDTO = Mapper.Map <MovieTrailerDTO>(movieTrailer);
return(movieTrailerDTO);
}
return(null);
}
}
public List <MoviePhotoDTO> GetMoviePhotos()
{
List <MoviePhotoDTO> moviePhotoDtos;
using (var dbContext = new ProjectManhattanEntities())
{
var moviePhotos = dbContext.MoviePhotoes
.Take(100)
.Include(m => m.Movie)
.Include(m => m.MoviePhotoArtists)
.Include(m => m.MoviePhotoArtists.Select(mpa => mpa.Artist)).ToList();
moviePhotoDtos = moviePhotos.Select(Mapper.Map <MoviePhotoDTO>).ToList();
}
return(moviePhotoDtos);
}
public MoviePhotoDTO GetMoviePhoto(int id)
{
using (var dbContext = new ProjectManhattanEntities())
{
MoviePhoto moviePhoto = dbContext.MoviePhotoes
.Where(m => m.MoviePhotoId == id)
.Include(m => m.Movie)
.Include(m => m.MoviePhotoArtists)
.Include(m => m.MoviePhotoArtists.Select(mpa => mpa.Artist))
.FirstOrDefault();
if (moviePhoto != null)
{
var moviePhotoDTO = Mapper.Map <MoviePhotoDTO>(moviePhoto);
return(moviePhotoDTO);
}
return(null);
}
}
public void InsertOrUpdateEntity(int id, TEntityDTO entityDTO)
{
using (var dbContext = new ProjectManhattanEntities())
{
var entity = dbContext.Set <TEntity>().Find(id);
if (entity != null)
{
Mapper.Map(entityDTO, entity);
dbContext.SaveChanges();
}
else
{
var newEntity = Mapper.Map <TEntity>(entityDTO);
dbContext.Set <TEntity>().Add(newEntity);
dbContext.SaveChanges();
Mapper.Map(newEntity, entityDTO);
}
}
}
public int InsertOrUpdateUser(UserDTO entityDTO)
{
using (var dbContext = new ProjectManhattanEntities())
{
var entity = dbContext.Set <User>().Find(entityDTO.UserId);
if (entity != null)
{
Mapper.Map(entityDTO, entity);
dbContext.SaveChanges();
return(entity.UserId);
}
else
{
var newEntity = Mapper.Map <User>(entityDTO);
dbContext.Set <User>().Add(newEntity);
dbContext.SaveChanges();
return(newEntity.UserId);
}
}
}
