예제 #1
0
        public void AddPlaylistToTable(string playlist_name, string playlistId)
        {
            SpotifyAPIGetData p        = new SpotifyAPIGetData();
            spotifyPlaylist   playlist = p.GetPlaylist(playlistId);

            string     d   = "DELETE FROM dbo.Playlists WHERE Playlist = '" + playlist_name + "'";
            SqlCommand del = new SqlCommand(d, connection);

            try
            {
                del.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                MessageBox.Show("Something Went Wrong, Please Try Again Later ://");
            }

            foreach (songInfo song in playlist.items)
            {
                spotifyTrack t = song.track;

                string        title   = t.name.Replace("'", "''");
                List <string> artists = new List <string>();
                foreach (artistInfo a in t.artists)
                {
                    artists.Add(a.name);
                }
                string   artistString = String.Join(", ", artists).Replace("'", "''");
                string   album        = t.album.name.Replace("'", "''");
                int      @explicit    = (t.@explicit) ? 1 : 0;
                TimeSpan duration     = TimeSpan.FromMilliseconds(t.duration_ms);
                int      popularity   = t.popularity;
                string   trackId      = t.id.Replace("'", "''");
                string   release_date = t.album.release_date;

                string     c       = String.Format("EXEC dbo.insertPlaylistData @Playlist = '{0}', @Title = '{1}', @Artist = '{2}', @Album = '{3}', @Explicit = {4}, @Duration = '{5}', @Popularity = {6}, @Release_Date = '{7}', @ID = '{8}'", playlist_name, title, artistString, album, @explicit, duration, popularity, release_date, trackId);
                SqlCommand command = new SqlCommand(c, connection);
                try
                {
                    command.ExecuteNonQuery();
                }
                catch (Exception e)
                {
                    MessageBox.Show("Something Went Wrong, Please Try Again Later ://");
                }
            }
        }
        private void start()
        {
            server = new SQLServer();
            server.openConnection();

            spotify = new SpotifyAPIGetData();

            artistTracks = server.GetAllArtistSongs();

            AddPlaylistGrid.Visibility     = Visibility.Collapsed;
            Add_PlaylistID_TextBox.Text    = "";
            Add_PlaylistName_Label.Content = "";

            UpdatePlaylistGrid.Visibility = Visibility.Collapsed;
            PlaylistNameID = server.GetPlaylistNameID();

            GetPlaylistGrid.Visibility = Visibility.Collapsed;
        }
 public TrackInfo()
 {
     InitializeComponent();
     spotify = new SpotifyAPIGetData();
 }