public void TestGenreDelete() { using (var ctx = new CDCatalogEntities()) { //Test init Genre g = new Genre(); g.GenreID = 0; // auto incremented and set by add g.GenreName = "Test Genre W6YderKT"; //add it to the context and save to database ctx.Genres.Add(g); ctx.SaveChanges(); //Find the list of "Test Genre" //in case duplicates were added in the previous tests, delete them all var list = ctx.Genres .Where(n => n.GenreName.ToLower().Equals("test genre w6yderkt")) .Where(n => n.GenreID > 1000); ctx.Genres.RemoveRange(list); int count = ctx.SaveChanges(); Assert.IsTrue(count > 0, "No Record Deleted"); //Test clean-up (none) } }
public void TestGenreAdd() { //create a new context using (var ctx = new CDCatalogEntities()) { //Test init //Create a test genre Genre g = new Genre(); g.GenreID = 0; // auto incremented and set by add g.GenreName = "Test Genre W6YderKT"; //add it to the context ctx.Genres.Add(g); //verify that records were changed int count = ctx.SaveChanges(); Assert.IsTrue(count > 0 && g.GenreID > 0, "No Records Changed"); //Test clean-up if (count > 0) { var list = ctx.Genres .Where(n => n.GenreName.ToLower().Equals("test genre w6yderkt")) .Where(n => n.GenreID > 0); ctx.Genres.RemoveRange(list); ctx.SaveChanges(); } } }
public void TestSongDelete() { using (var ctx = new CDCatalogEntities()) { //Test init //Get an artist we know exists -- Avicii Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("avicii")).FirstOrDefault(); //Get an album we know exists -- Album M = ctx.Albums.Where(n => n.AlbumTitle.ToLower().Equals("true")).FirstOrDefault(); //Get a genre we know exists -- Dance Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("dance")).FirstOrDefault(); Song s = new Song(); s.SongID = 0; // autogenerated on add s.SongTitle = "Test Song GMwRYZ"; s.ArtistID = A.ArtistID; s.AlbumID = M.AlbumID; s.GenreID = G.GenreID; s.SongTrackNumber = 15; s.SongTrackLength = 350; s.SongRating = 3; //add it to the database ctx.Songs.Add(s); //find the list of "Test Song GMwRYZ" //in case duplicates were added in the previous tests var list = ctx.Songs .Where(n => n.SongTitle.ToLower().Equals("test song gmwryz")); ctx.Songs.RemoveRange(list); int count = ctx.SaveChanges(); Assert.IsTrue(count > 0, "No Record Deleted"); //Test clean-up (none) } }
public static CDCatalogEF.Genre AddGenre(string genreName) { if (genreName == null) { // Define a new top-level error message. string str = "You did not enter a Genre Name. Cancel this operation?"; // Pop-up a messagebox with the message MessageBox.Show(str); return(null); } var genre = new CDCatalogEF.Genre(); try { genre.GenreName = genreName; using (var db = new CDCatalogEntities()) { db.Genres.Add(genre); var resultCount = db.SaveChanges(); } } catch (Exception ex) { // Define a new top-level error message. string str = "Adding the Genre by Name failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } return(genre); }
/// <summary> /// /// </summary> /// <param name="title"></param> /// <param name="artistId"></param> /// <param name="albumId"></param> /// <param name="trackNumber"></param> /// <param name="songRating"></param> /// <param name="trackLength"></param> /// <param name="genreId"></param> /// <returns></returns> public static int AddSong(string title, int artistId, int albumId, int trackNumber, int songRating, int trackLength, int genreId) { var song = new CDCatalogEF.Song(); try { song.SongTitle = title; song.ArtistID = artistId; song.AlbumID = albumId; song.SongTrackNumber = trackNumber; song.SongRating = songRating; song.SongTrackLength = trackLength; song.GenreID = genreId; using (var db = new CDCatalogEntities()) { db.Songs.Add(song); var resultCount = db.SaveChanges(); } } catch (Exception ex) { // Define a new top-level error message. string str = "Adding the Song failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } var songId = song.ArtistID; //The song.ArtistID gets updated in the context as its saved return(songId); }
public void TestArtistFetch() { using (var ctx = new CDCatalogEntities()) { //Test init Artist i = new Artist(); i.ArtistID = 0; // autogenerated on add i.ArtistName = "Testing Artist 7yJLirjI"; //add it to the context and make changes in the database ctx.Artists.Add(i); ctx.SaveChanges(); //Find the test artist in the database Artist a = ctx.Artists .Where(n => n.ArtistName.ToLower().Equals("testing artist 7yjlirji")) .FirstOrDefault(); Assert.IsTrue(a != null, "No Record Found"); //Test clean-up if (a != null) { var list = ctx.Artists .Where(n => n.ArtistName.ToLower().Equals("testing artist 7yjlirji")); ctx.Artists.RemoveRange(list); ctx.SaveChanges(); } } }
/// <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); }
public void TestAlbumAdd() { using (var ctx = new CDCatalogEntities()) { //Test init (none) //Get an artist we know exists -- Kaskade Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("kaskade")).FirstOrDefault(); //Get a genre we know exists -- Electronic Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("electronic")).FirstOrDefault(); //create a test album Album m = new Album(); m.AlbumID = 0; // autogenerated on add m.AlbumYear = 2014; m.ArtistID = A.ArtistID; m.AlbumTitle = "The KqxKAW Test Album"; m.AlbumRating = 5; m.GenreID = G.GenreID; //add it to the database ctx.Albums.Add(m); int count = ctx.SaveChanges(); Assert.IsTrue(count > 0 && m.AlbumID > 0, "No Record Added"); //Test clean-up if (count > 0) { var list = ctx.Albums .Where(n => n.AlbumTitle.ToLower().Equals("the kqxkaw test album")); ctx.Albums.RemoveRange(list); ctx.SaveChanges(); } } }
/// <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="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; }
public void TestAlbumDelete() { using (var ctx = new CDCatalogEntities()) { //Test init Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("kaskade")).FirstOrDefault(); //Get a genre we know exists -- Electronic Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("electronic")).FirstOrDefault(); //create a test album Album i = new Album(); i.AlbumID = 0; // autogenerated on add i.AlbumYear = 2014; i.ArtistID = A.ArtistID; i.AlbumTitle = "The KqxKAW Test Album"; i.AlbumRating = 5; i.GenreID = G.GenreID; //add it to the context, then database ctx.Albums.Add(i); ctx.SaveChanges(); //find the list of "Testing Artists" //in case duplicates were added in the previous tests, delete them all var list = ctx.Albums .Where(n => n.AlbumTitle.ToLower().Equals("the kqxkaw test album")); ctx.Albums.RemoveRange(list); int count = ctx.SaveChanges(); Assert.IsTrue(count > 0, "No Record Deleted"); //Test clean-up (none) } }
/// <summary> /// /// </summary> /// <param name="title"></param> /// <param name="artistId"></param> /// <param name="albumId"></param> /// <param name="trackNumber"></param> /// <param name="songRating"></param> /// <param name="trackLength"></param> /// <param name="genreId"></param> /// <returns></returns> public static bool UpdateSong(int songId, string title, int artistId, int albumId, int trackNumber, int songRating, int trackLength, int genreId) { var song = new CDCatalogEF.Song(); try { song.SongTitle = title; song.ArtistID = artistId; song.AlbumID = albumId; song.SongTrackNumber = trackNumber; song.SongRating = songRating; song.SongTrackLength = trackLength; song.GenreID = genreId; using (var db = new CDCatalogEntities()) { db.Songs.First(i => i.SongID == songId); int resultCount = db.SaveChanges(); return(true); // Executes only if no exception } } catch (Exception ex) { // Define a new top-level error message. string str = "Adding the Song failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } return(false); }
public void TestSongDelete() { using (var ctx = new CDCatalogEntities()) { //Test init //Get an artist we know exists -- Avicii Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("avicii")).FirstOrDefault(); //Get an album we know exists -- Album M = ctx.Albums.Where(n => n.AlbumTitle.ToLower().Equals("true")).FirstOrDefault(); //Get a genre we know exists -- Dance Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("dance")).FirstOrDefault(); Song s = new Song(); s.SongID = 0; // autogenerated on add s.SongTitle = "Test Song GMwRYZ"; s.ArtistID = A.ArtistID; s.AlbumID = M.AlbumID; s.GenreID = G.GenreID; s.SongTrackNumber = 15; s.SongTrackLength =350; s.SongRating = 3; //add it to the database ctx.Songs.Add(s); //find the list of "Test Song GMwRYZ" //in case duplicates were added in the previous tests var list = ctx.Songs .Where(n => n.SongTitle.ToLower().Equals("test song gmwryz")); ctx.Songs.RemoveRange(list); int count = ctx.SaveChanges(); Assert.IsTrue(count > 0, "No Record Deleted"); //Test clean-up (none) } }
public static int AddArtist(string artistName) { var artist = new CDCatalogEF.Artist(); try { artist.ArtistName = artistName; using (var db = new CDCatalogEntities()) { db.Artists.Add(artist); //faults here var resultCount = db.SaveChanges(); } } catch (Exception ex) { // Define a new top-level error message. string str = "Adding the Artist by Name failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } var artistId = artist.ArtistID; return artistId; }
public void TestGenreFetch() { using (var ctx = new CDCatalogEntities()) { //Test init Genre i = new Genre(); i.GenreID = 0; // auto incremented and set by add i.GenreName = "Test Genre W6YderKT"; //add it to the context and save to database ctx.Genres.Add(i); ctx.SaveChanges(); //Find the test genre in the database Genre g = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("test genre w6yderkt")).FirstOrDefault(); Assert.IsTrue(g != null, "No Record Found"); //Test clean-up if (g != null) { var list = ctx.Genres .Where(n => n.GenreName.ToLower().Equals("test genre w6yderkt")) .Where(n => n.GenreID > 0); ctx.Genres.RemoveRange(list); ctx.SaveChanges(); } } }
public static int AddArtist(string artistName) { var artist = new CDCatalogEF.Artist(); try { artist.ArtistName = artistName; using (var db = new CDCatalogEntities()) { db.Artists.Add(artist); //faults here var resultCount = db.SaveChanges(); } } catch (Exception ex) { // Define a new top-level error message. string str = "Adding the Artist by Name failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } var artistId = artist.ArtistID; return(artistId); }
public void TestArtistAdd() { using (var ctx = new CDCatalogEntities()) { //Test init (none) //Create a test artist Artist a = new Artist(); a.ArtistID = 0; // autogenerated on add a.ArtistName = "Testing Artist 7yJLirjI"; //add it to the context ctx.Artists.Add(a); //verify that .. records were changed int count = ctx.SaveChanges(); Assert.IsTrue(count > 0 && a.ArtistID > 0, "No Records Changed"); //Test clean-up if (count > 0) { var list = ctx.Artists .Where(n => n.ArtistName.ToLower().Equals("testing artist 7yjlirji")); ctx.Artists.RemoveRange(list); ctx.SaveChanges(); } } }
private void Form1_Load(object sender, EventArgs e) { using (CDCatalogEntities db = new CDCatalogEntities()) { albumList = db.Albums.OrderBy(a => a.AlbumTitle).ToList(); dataGridView1.DataSource = albumList; //List<Playlist> artistList = db.Playlists.OrderBy(a => a.PlaylistName).ToList(); //foreach (Playlist a in artistList) //{ // if (a.PlaylistName == "Test Playlist") // { // db.Playlists.Remove(a); // db.SaveChanges(); // } //} //// Create a Genre //Genre genre = new Genre(); //genre.GenreName = "Bluegrass"; //db.Genres.Add(genre); //db.SaveChanges(); ////Select genres //List<Genre> genres = db.Genres.OrderBy(g => g.GenreName).ToList(); //List<Artist> artists = db.Artists.OrderBy(a => a.ArtistName).ToList(); //listBox1.DataSource = artists; //foreach (Artist a in artists) //{ // if (a.ArtistName == "Updated Test Artist") // { // db.Artists.Remove(a); // db.SaveChanges(); // } //} //Artist artist = new Artist(); //artist.ArtistName = "Carl"; //db.Artists.Add(artist); //db.SaveChanges(); //Album album = new Album(); //album.AlbumTitle = "wfwf"; //album.ArtistID = artist.ArtistID; //album.Rating = 5; //album.Year = 2015; //db.Albums.Add(album); //db.SaveChanges(); //List<Artist> artistResultList = db.Artists.Where(a => a.ArtistName.Contains("Car")).ToList(); } }
public IList<SongView> GeneratePlaylist(int lengthMinutes) { using (CDCatalogEntities context = new CDCatalogEntities()) { //Pulls the accepted margin of tolarance in seconds from the app.config. If it cannot get the value, will default to 60 int marginInSeconds; if (!int.TryParse(ConfigurationManager.AppSettings["GeneratePlaylistMarginInSeconds"], out marginInSeconds)) marginInSeconds = 60; var targetLengthInSeconds = lengthMinutes * 60; //Load all songs into a list to work from var fullSongList = GetAllSongs(); //Create playlist that will have songs added to it var playlist = new List<SongView>(); //Create object to be used for random number generation var rand = new Random(); //variable to keep track of playlist length var playlistLengthInSeconds = 0; //variable to insure that infinate loop does not occur var numberOfIterations = 0; //Perform functions so long as playlist is under the desired length and there are songs that can still be added while (playlistLengthInSeconds < targetLengthInSeconds - marginInSeconds && fullSongList.Count != 0) { //generate index at random int index = rand.Next(fullSongList.Count); //add song at that index to playlist playlist.Add(fullSongList[index]); //update playlist length accordingly playlistLengthInSeconds += fullSongList[index].Track_Length_Seconds; //remove track from song list source fullSongList.RemoveAt(index); //will remove a random song from the playlist if it is too long while (playlistLengthInSeconds > targetLengthInSeconds + marginInSeconds) { //generate index at random index = rand.Next(playlist.Count); //add song back to list of songs to choose from fullSongList.Add(playlist[index]); //remove track length from playlist playlistLengthInSeconds -= playlist[index].Track_Length_Seconds; //remove song from playl playlist.RemoveAt(index); } numberOfIterations++; if (numberOfIterations > 999) break; } return playlist; } }
public Artist CreateArtist(string artistName) { using (CDCatalogEntities context = new CDCatalogEntities()) { var artist = new Artist(); artist.ArtistName = artistName; context.Artists.Add(artist); context.SaveChanges(); return artist; } }
public Genre CreateGenre(string name) { using (CDCatalogEntities context = new CDCatalogEntities()) { var genre = new Genre(); genre.GenreName = name; context.Genres.Add(genre); context.SaveChanges(); return genre; } }
private void button3_Click(object sender, EventArgs e) { using (CDCatalogEntities db = new CDCatalogEntities()) { List <Song> songList = db.Songs.OrderBy(s => s.SongTitle).ToList(); foreach (Song s in songList) { s.TrackLength -= 300; db.SaveChanges(); } } }
public Album CreateAlbum(string albumTitle, Artist albumArtist, int albumYear, int albumRating) { using (CDCatalogEntities context = new CDCatalogEntities()) { var album = new Album(); album.Title = albumTitle; album.Year = albumYear; album.Rating = albumRating; album.ArtistId = albumArtist.ArtistId; context.Albums.Add(album); context.SaveChanges(); return album; } }
public static string FetchArtist(int artistID) { Artist artist = new Artist(); try { using (CDCatalogEntities db = new CDCatalogEntities()) { artist = db.Artists.Where(n => n.Equals(artistID)).FirstOrDefault(); } } catch (Exception ex) { string s = ex.Message; } return(artist.ArtistName); }
public Song CreateSong(string songTitle, Artist artist, Genre genre, int songLengthSeconds, int songRating, Album album = null, int albumTrackNumber = 0) { using (CDCatalogEntities context = new CDCatalogEntities()) { var song = new Song(); song.Title = songTitle; song.ArtistId = artist.ArtistId; song.GenreId = genre.GenreId; song.TrackLengthSeconds = songLengthSeconds; song.Rating = songRating; song.AlbumId = album?.AlbumId; song.TrackNumber = albumTrackNumber; context.Songs.Add(song); context.SaveChanges(); return song; } }
public static bool DeleteAtrist(int artistID) { Artist artist = new Artist(); try { using (CDCatalogEntities db = new CDCatalogEntities()) { artist = db.Artists.Where(n => n.Equals(artistID)).Single(); db.Artists.Remove(artist); } } catch (Exception ex) { string s = ex.Message; } return(false); }
public static List<CDCatalogEF.Artist> GetAllArtists() { using (var db = new CDCatalogEntities()) { try { return db.Artists.OrderBy(o => o.ArtistName).ToList(); } catch (Exception ex) { // Define a new top-level error message. string str = "Listing the Artists failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } } return null; }
/// <summary> /// /// </summary> /// <returns></returns> public static List <CDCatalogEF.Song> GetAllSongs() { using (CDCatalogEntities db = new CDCatalogEntities()) { try { return(db.Songs.OrderBy(o => o.SongTitle).ToList()); } catch (Exception ex) { // Define a new top-level error message. string str = "Listing the Songs failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } } return(null); }
/// <summary> /// /// </summary> /// <returns></returns> public static List <CDCatalogEF.Album> GetAllAlbums() { using (CDCatalogEntities db = new CDCatalogEntities()) { try { return(db.Albums.ToList()); } catch (Exception ex) { // Define a new top-level error message. string str = "Listing the Albums failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } } return(null); }
/// <summary> /// /// </summary> /// <param name="title"></param> /// <returns></returns> public static List <CDCatalogEF.Song> GetSongsByTitle(string title) { using (var db = new CDCatalogEntities()) { try { return(db.Songs.Where(o => o.SongTitle.ToUpper().Contains(title.ToUpper())).ToList()); } catch (Exception ex) { // Define a new top-level error message. string str = "Listing the Songs by name failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } } return(null); }
public void TestSongAdd() { //Test init (none) //Add a song to the database using (var ctx = new CDCatalogEntities()) { //Get an artist we know exists -- Avicii Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("avicii")).FirstOrDefault(); //Get an album we know exists -- Album M = ctx.Albums.Where(n => n.AlbumTitle.ToLower().Equals("true")).FirstOrDefault(); //Get a genre we know exists -- Dance Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("dance")).FirstOrDefault(); //Creat a new song and add it to the context Song s = new Song(); s.SongID = 0; // autogenerated on add s.SongTitle = "Test Song GMwRYZ"; s.ArtistID = A.ArtistID; s.AlbumID = M.AlbumID; s.GenreID = G.GenreID; s.SongTrackNumber = 15; s.SongTrackLength = 350; s.SongRating = 3; //add it to the database ctx.Songs.Add(s); //verify that only one record was changed int count = ctx.SaveChanges(); Assert.IsTrue(count > 0 && s.SongID > 0, "No Records Added"); //Test clean-up if (count > 0) { //find all the test songs var list = ctx.Songs .Where(n => n.SongTitle.ToLower().Equals("test song gmwryz")); //Remove the songs from the context and database ctx.Songs.RemoveRange(list); ctx.SaveChanges(); } } }
public void TestSongFetch() { using (var ctx = new CDCatalogEntities()) { //Test init //Get an artist we know exists -- Avicii Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("avicii")).FirstOrDefault(); //Get an album we know exists -- Album M = ctx.Albums.Where(n => n.AlbumTitle.ToLower().Equals("true")).FirstOrDefault(); //Get a genre we know exists -- Dance Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("dance")).FirstOrDefault(); //Build a context Song i = new Song(); i.SongID = 0; // autogenerated on add i.SongTitle = "Test Song GMwRYZ"; i.ArtistID = A.ArtistID; i.AlbumID = M.AlbumID; i.GenreID = G.GenreID; i.SongTrackNumber = 15; i.SongTrackLength = 300; i.SongRating = 3; //add it to the database ctx.Songs.Add(i); //find a the test song in the database Song s = ctx.Songs.Where(n => n.SongTitle.ToLower().Equals("test song gmwryz")).FirstOrDefault(); Assert.IsTrue(s != null, "No Record Deleted"); //Test clean-up if (s != null) { //find all the test songs in the context var list = ctx.Songs .Where(n => n.SongTitle.ToLower().Equals("test song gmwryz")); //delete them from the context and database ctx.Songs.RemoveRange(list); ctx.SaveChanges(); } } }
/// <summary> /// /// </summary> /// <param name="songId"></param> /// <returns></returns> public static bool DeleteSongById(int songId) { try { using (var db = new CDCatalogEntities()) { CDCatalogEF.Song song = db.Songs.Where(n => n.Equals(songId)).Single(); db.Songs.Remove(song); return(true); //if there is an exception, this won't run } } catch (Exception ex) { // Define a new top-level error message. string str = "Deleting the Song failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } return(false); }
public static CDCatalogEF.Artist GetArtistById(int artistId) { var artist = new CDCatalogEF.Artist(); try { using (var db = new CDCatalogEntities()) { artist = db.Artists.Where(a => a.ArtistID == artistId).FirstOrDefault(); } } catch (Exception ex) { // Define a new top-level error message. string str = "Getting the Artist failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } return(artist); }
public static CDCatalogEF.Genre GetGenreById(int genreId) { var genre = new CDCatalogEF.Genre(); try { using (var db = new CDCatalogEntities()) { genre = db.Genres.Where(a => a.GenreID == genreId).FirstOrDefault(); } } catch (Exception ex) { // Define a new top-level error message. string str = "Getting the Genre failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } return(genre); }
public static bool DeleteAtristById(int artistId) { try { using (var db = new CDCatalogEntities()) { // Find one artist CDCatalogEF.Artist artist = db.Artists.Where(n => n.Equals(artistId)).Single(); db.Artists.Remove(artist); return true; //if there is an exception, this won't run } } catch (Exception ex) { // Define a new top-level error message. string str = "Deleting the Artist failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } return false; }
public static bool DeleteAtristById(int artistId) { try { using (var db = new CDCatalogEntities()) { // Find one artist CDCatalogEF.Artist artist = db.Artists.Where(n => n.Equals(artistId)).Single(); db.Artists.Remove(artist); return(true); //if there is an exception, this won't run } } catch (Exception ex) { // Define a new top-level error message. string str = "Deleting the Artist failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } return(false); }
public static int AddArtist(string artistName) { CDCatalogEF.Artist artist = new Artist(); try { artist.ArtistName = artistName; using (var db = new CDCatalogEntities()) { db.Artists.Add(artist); int resultCount = db.SaveChanges(); } } catch (Exception ex) { string s = ex.Message; } int artistId = artist.ArtistID; return(artistId); }
public void TestAlbumFetch() { using (var ctx = new CDCatalogEntities()) { //Test init //Get an artist we know exists -- Kaskade Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("kaskade")).FirstOrDefault(); //Get a genre we know exists -- Electronic Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("electronic")).FirstOrDefault(); //create a test album Album i = new Album(); i.AlbumID = 0; // autogenerated on add i.AlbumYear = 2014; i.ArtistID = A.ArtistID; i.AlbumTitle = "The KqxKAW Test Album"; i.AlbumRating = 5; i.GenreID = G.GenreID; //add it to the context, then database ctx.Albums.Add(i); ctx.SaveChanges(); //Find the test album in the database Album m = ctx.Albums .Where(n => n.AlbumTitle.ToLower().Equals("the kqxkaw test album")) .FirstOrDefault(); Assert.IsTrue(m != null, "No Record Found"); //Test clean-up if (m != null) { var list = ctx.Albums .Where(n => n.AlbumTitle.ToLower().Equals("the kqxkaw test album")); ctx.Albums.RemoveRange(list); int count = ctx.SaveChanges(); } } }
public void TestArtistDelete() { using (var ctx = new CDCatalogEntities()) { //Test init Artist i = new Artist(); i.ArtistID = 0; // autogenerated on add i.ArtistName = "Testing Artist 7yJLirjI"; //add it to the context and make changes in the database ctx.Artists.Add(i); ctx.SaveChanges(); //find the list of "Testing Artists" //in case duplicates were added in the previous tests var list = ctx.Artists .Where(n => n.ArtistName.ToLower().Equals("testing artist 7yjlirji")); ctx.Artists.RemoveRange(list); int count = ctx.SaveChanges(); Assert.IsTrue(count > 0, "No Record Deleted"); //Test clean-up (none) } }
public IList<SongView> SearchSongsByGenreName(string genreName) { using (CDCatalogEntities context = new CDCatalogEntities()) { return context.SongViews.Where(s => s.Genre.ToLower() == genreName.ToLower()).OrderByDescending(s => s.Rating).ToList(); } }
public void UpdateAlbumRating(string albumTitle, int albumRating, string artistName = null) { using (CDCatalogEntities context = new CDCatalogEntities()) { Album album; if (artistName == null) { album = GetAlbumByID(SearchAlbumsByAlbumTitle(albumTitle).First().AlbumId); } else { var albums = SearchAlbumsByAlbumTitle(albumTitle).ToList(); album = GetAlbumByID(albums.Where(a => a.Artist_Name == artistName).FirstOrDefault().AlbumId); } album.Rating = albumRating; context.Albums.Attach(album); var entry = context.Entry(album); entry.Property(e => e.Rating).IsModified = true; context.SaveChanges(); } }
public IList<SongView> SearchSongsByAlbumID(int albumId) { using (CDCatalogEntities context = new CDCatalogEntities()) { var songsInAlbum = context.Songs.Where(s => s.AlbumId == albumId).ToList(); var songViewInAlbum = new List<SongView>(); foreach (var song in songsInAlbum) { songViewInAlbum.Add(GetSongViewByID(song.SongID)); } songViewInAlbum = songViewInAlbum.OrderBy(s => s.Track).ToList(); return songViewInAlbum; } }
public IList<Artist> SearchArtistByArtistNameExclusive(string artistName) { using (CDCatalogEntities context = new CDCatalogEntities()) { return context.Artists.Where(a => a.ArtistName.ToLower() == artistName.ToLower()).ToList(); } }
public IList<AlbumView> SearchAlbumsByGenreName(string genre) { using (CDCatalogEntities context = new CDCatalogEntities()) { var results = new List<AlbumView>(); var matchingSongs = SearchSongsByGenreName(genre); foreach (var match in matchingSongs) { results.AddRange(context.AlbumViews.Where(a => a.Title == match.Album)); } results = results.Distinct().ToList(); return results; } }
public IList<AlbumView> SearchAlbumsByArtistName(string artistName) { using (CDCatalogEntities context = new CDCatalogEntities()) { return context.AlbumViews.Where(a => a.Artist_Name.ToLower() == artistName.ToLower()).OrderByDescending(a => a.Rating).ToList(); } }
public void UpdateSongRating(string songTitle, int songRating, Album album = null) { using (CDCatalogEntities context = new CDCatalogEntities()) { Song song; if (album == null) song = GetSongByID(SearchSongsBySongTitle(songTitle).First().SongID); else { var songs = SearchSongsBySongTitle(songTitle); song = GetSongByID((songs.Where(s => s.Album == album.Title).FirstOrDefault()).SongID); } song.Rating = songRating; context.Songs.Attach(song); var entry = context.Entry(song); entry.Property(e => e.Rating).IsModified = true; context.SaveChanges(); } }
public IList<Genre> SearchGenreByGenreName(string genreName) { using (CDCatalogEntities context = new CDCatalogEntities()) { return context.Genres.Where(g => g.GenreName.Contains(genreName.ToLower())).OrderBy(g => g.GenreName).ToList(); } }
public IList<AlbumView> SearchAlbumsByAlbumTitle(string albumTitle) { using (CDCatalogEntities context = new CDCatalogEntities()) { if (string.IsNullOrEmpty(albumTitle)) return context.Set<AlbumView>().ToList(); ; return context.AlbumViews.Where(a => a.Title.ToLower().Contains(albumTitle.ToLower())).OrderByDescending(a => a.Rating).ToList(); } }
public IList<Album> SearchAlbumsByAlbumTitleExclusive(string albumTitle) { using (CDCatalogEntities context = new CDCatalogEntities()) { return context.Albums.Where(a => a.Title.ToLower() == albumTitle.ToLower()).OrderByDescending(a => a.Rating).ToList(); } }
public IList<SongView> SearchSongsBySongTitle(string songTitle) { using (CDCatalogEntities context = new CDCatalogEntities()) { //if nothing is passed in, all songs will be returned if (string.IsNullOrEmpty(songTitle)) return GetAllSongs(); return context.SongViews.Where(s => s.Title.ToLower().Contains(songTitle.ToLower())).OrderByDescending(s => s.Rating).ToList(); } }
public static CDCatalogEF.Artist GetArtistById(int artistId) { var artist = new CDCatalogEF.Artist(); try { using (var db = new CDCatalogEntities()) { artist = db.Artists.Where(a => a.ArtistID == artistId).FirstOrDefault(); } } catch (Exception ex) { // Define a new top-level error message. string str = "Getting the Artist failed. " + ex.Message; // Pop-up a messagebox with the message MessageBox.Show(str); } return artist; }
public IList<SongView> SearchSongsBySongTitleExclusive(string songTitle) { using (CDCatalogEntities context = new CDCatalogEntities()) { return context.SongViews.Where(s => s.Title.ToLower() == songTitle.ToLower()).OrderByDescending(s => s.Rating).ToList(); } }