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(); } }