/// <summary> /// /// </summary> /// <param name="albumYear"></param> /// <param name="artistId"></param> /// <param name="albumTitle"></param> /// <param name="albumRating"></param> /// <param name="genreId"></param> /// <returns></returns> public static int AddAlbum(int albumYear, int artistId, string albumTitle, int albumRating, int genreId) { var album = new CDCatalogEF.Album(); try { album.AlbumYear = albumYear; album.ArtistID = artistId; album.AlbumTitle = albumTitle; album.AlbumRating = albumRating; album.GenreID = genreId; using (var db = new CDCatalogEntities()) { db.Albums.Add(album); var resultCount = db.SaveChanges(); } } catch (Exception ex) { // Define a new top-level error message. string str = "Adding the Album failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } var songId = album.ArtistID; // The song.ArtistID gets updated in the context as its saved return(artistId); }
/// <summary> /// /// </summary> /// <param name="albumId"></param> /// <param name="albumYear"></param> /// <param name="artistId"></param> /// <param name="albumTitle"></param> /// <param name="albumRating"></param> /// <param name="genreId"></param> /// <returns></returns> public static bool ChangeAlbum(int albumId, int albumYear, int artistId, string albumTitle, int albumRating, int genreId) { var album = new CDCatalogEF.Album(); try { album.AlbumID = albumId; album.AlbumYear = albumYear; album.ArtistID = artistId; album.AlbumTitle = albumTitle; album.AlbumRating = albumRating; album.GenreID = genreId; using (var db = new CDCatalogEntities()) { db.Albums.First(i => i.AlbumID == albumId); int resultCount = db.SaveChanges(); return true; // if there is an exception, this won't run } } catch (Exception ex) { // Define a new top-level error message. string str = "Changing the Album failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } var songId = album.ArtistID; // The song.ArtistID gets updated in the context as its saved return true; }
/// <summary> /// /// </summary> /// <param name="albumId"></param> /// <param name="albumYear"></param> /// <param name="artistId"></param> /// <param name="albumTitle"></param> /// <param name="albumRating"></param> /// <param name="genreId"></param> /// <returns></returns> public static bool ChangeAlbum(int albumId, int albumYear, int artistId, string albumTitle, int albumRating, int genreId) { var album = new CDCatalogEF.Album(); try { album.AlbumID = albumId; album.AlbumYear = albumYear; album.ArtistID = artistId; album.AlbumTitle = albumTitle; album.AlbumRating = albumRating; album.GenreID = genreId; using (var db = new CDCatalogEntities()) { db.Albums.First(i => i.AlbumID == albumId); int resultCount = db.SaveChanges(); return(true); // if there is an exception, this won't run } } catch (Exception ex) { // Define a new top-level error message. string str = "Changing the Album failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } var songId = album.ArtistID; // The song.ArtistID gets updated in the context as its saved return(true); }
/// <summary> /// /// </summary> /// <param name="albumYear"></param> /// <param name="artistId"></param> /// <param name="albumTitle"></param> /// <param name="albumRating"></param> /// <param name="genreId"></param> /// <returns></returns> public static int AddAlbum(int albumYear, int artistId, string albumTitle, int albumRating, int genreId) { var album = new CDCatalogEF.Album(); try { album.AlbumYear = albumYear; album.ArtistID = artistId; album.AlbumTitle = albumTitle; album.AlbumRating = albumRating; album.GenreID = genreId; using (var db = new CDCatalogEntities()) { db.Albums.Add(album); var resultCount = db.SaveChanges(); } } catch (Exception ex) { // Define a new top-level error message. string str = "Adding the Album failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } var songId = album.ArtistID; // The song.ArtistID gets updated in the context as its saved return artistId; }