public void AddGenre(string genreToAdd)
{
using (CapstoneCDCatalogEntities db = new CapstoneCDCatalogEntities())
{
Genre genre = new Genre {GenreName = genreToAdd};
db.Genres.Add(genre);
db.SaveChanges();
}
}
public void AddAlbum(string albumTitle, int albumYear, int albumRating, string artistTitle)
{
var artistId = SongService.ArtistService.GetArtistId(artistTitle);
using (CapstoneCDCatalogEntities db = new CapstoneCDCatalogEntities())
{
Album album = new Album
{
AlbumTitle = albumTitle,
AlbumYear = albumYear,
AlbumRating = albumRating,
ArtistId = artistId
};
db.Albums.Add(album);
db.SaveChanges();
}
}
public void UpdateAlbumRating(string oldAlbum, int rating)
{
using (CapstoneCDCatalogEntities db = new CapstoneCDCatalogEntities())
{
var newAlbum = db.Albums.FirstOrDefault(x => x.AlbumTitle == oldAlbum);
newAlbum.AlbumRating = rating;
db.SaveChanges();
}
}
