Exemplo n.º 1
0
        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)
            }
        }
Exemplo n.º 2
0
        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();
                }
            }
        }
Exemplo n.º 3
0
        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();
                }
            }
        }
Exemplo n.º 4
0
        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)
            }
        }
Exemplo n.º 5
0
        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);
        }
Exemplo n.º 6
0
        /// <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);
        }
Exemplo n.º 7
0
        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();
                }
            }
        }
Exemplo n.º 8
0
        /// <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);
        }
Exemplo n.º 9
0
        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)

            }
        }
Exemplo n.º 10
0
        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();
                }
            }
        }
Exemplo n.º 11
0
        /// <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);
        }
Exemplo n.º 12
0
        /// <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;
        }
Exemplo n.º 13
0
        /// <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;
        }
Exemplo n.º 14
0
        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)
            }
        }
Exemplo n.º 15
0
        /// <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);
        }
Exemplo n.º 16
0
        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();
                }
            }
        }
Exemplo n.º 17
0
        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)
            }
        }
Exemplo n.º 18
0
        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)

            }
        }
Exemplo n.º 19
0
        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;
        }
Exemplo n.º 20
0
        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();
                }
            }
        }
Exemplo n.º 21
0
        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);
        }
Exemplo n.º 22
0
        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();
                }
            }
        }
Exemplo n.º 23
0
        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();
            }
        }
Exemplo n.º 24
0
        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;
            }
        }
Exemplo n.º 25
0
 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;
     }
 }
Exemplo n.º 26
0
 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;
     }
 }
Exemplo n.º 27
0
 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();
         }
     }
 }
Exemplo n.º 28
0
 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;
     }
 }
Exemplo n.º 29
0
        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);
        }
Exemplo n.º 30
0
        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;
            }
        }
Exemplo n.º 31
0
        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);
        }
Exemplo n.º 32
0
        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;
        }
Exemplo n.º 33
0
        /// <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);
        }
Exemplo n.º 34
0
        /// <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);
        }
Exemplo n.º 35
0
        /// <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);
        }
Exemplo n.º 36
0
        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();
                }
            }
        }
Exemplo n.º 37
0
        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();
                }
            }
        }
Exemplo n.º 38
0
        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();
                }
            }
        }
Exemplo n.º 39
0
        /// <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);
        }
Exemplo n.º 40
0
        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);
        }
Exemplo n.º 41
0
        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);
        }
Exemplo n.º 42
0
        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;
        }
Exemplo n.º 43
0
        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);
        }
Exemplo n.º 44
0
        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);
        }
Exemplo n.º 45
0
        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();
                }
            }
        }
Exemplo n.º 46
0
        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)
            }
        }
Exemplo n.º 47
0
 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();
     }
 }
Exemplo n.º 48
0
        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();
            }
        }
Exemplo n.º 49
0
 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;
     }
 }
Exemplo n.º 50
0
 public IList<Artist> SearchArtistByArtistNameExclusive(string artistName)
 {
     using (CDCatalogEntities context = new CDCatalogEntities())
     {
         return context.Artists.Where(a => a.ArtistName.ToLower() == artistName.ToLower()).ToList();
     }
 }
Exemplo n.º 51
0
 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;
     }
 }
Exemplo n.º 52
0
 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();
     }
 }
Exemplo n.º 53
0
        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();
            }
        }
Exemplo n.º 54
0
 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();
     }
 }
Exemplo n.º 55
0
 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();
     }
 }
Exemplo n.º 56
0
 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();
     }
 }
Exemplo n.º 57
0
 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();
     }
 }
Exemplo n.º 58
0
        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();
                }

            }
        }
Exemplo n.º 59
0
        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;
        }
Exemplo n.º 60
0
 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();
     }
 }