public int Create(Models.Genre genre)
{
Data.Genre newGenre = new Data.Genre {
Description = genre.Description
};
db.Genres.Add(newGenre);
db.SaveChanges();
return(newGenre.Id);
}
public static GenreList FromDataGenre(Data.Genre genre, Image genreThumbnail, int?artistCount, int?releaseCount)
{
return(new GenreList
{
Id = genre.RoadieId,
Genre = new DataToken
{
Text = genre.Name,
Value = genre.RoadieId.ToString()
},
SortName = genre.SortName,
CreatedDate = genre.CreatedDate,
LastUpdated = genre.LastUpdated,
ArtistCount = artistCount,
ReleaseCount = releaseCount,
Thumbnail = genreThumbnail
});
}
public IEnumerable <Album> FindAllAlbumsByGenre(Data.Genre genre)
{
var sql = _baseAlbumQuery + " WHERE genre.Name=@genre";
var results = _database.Query(sql, new { genre = genre.GenreName });
return(results.Select(res => new Album()
{
AlbumName = res.AlbumName,
ReleaseYear = res.ReleaseYear,
Genre = new Genre {
GenreName = res.GenreName
},
Artist = new Artist {
ArtistName = res.ArtistName
},
Tracks = GetTracksForAlbum(res.Id)
}));
}
public void AddGenres(int movieId, List <int> genreIds)
{
var existing = db.Movies.Include("Genres").FirstOrDefault(x => x.Id == movieId);
if (existing != null)
{
var genresToRemove = existing.Genres.ToList();
foreach (var g in genresToRemove)
{
existing.Genres.Remove(g);
}
db.SaveChanges();
}
foreach (var id in genreIds)
{
Data.Genre genre = db.Genres.SingleOrDefault(x => x.Id == id);
existing.Genres.Add(genre ?? throw new ArgumentException("The associated genre does not exist."));
}
db.SaveChanges();
}
