private void PlaylistSelected(object sender, RoutedEventArgs e) { PlaylistWindow win = new PlaylistWindow(user, userid); win.Show(); this.Close(); }
private void RemovePlaylist(object sender, RoutedEventArgs e) { string value = PlaylistBox.SelectedItem as string; int id = 0; for (int i = 0; i < playlist_list.Count; i++) { if (playlist_list[i].nome == value) { id = playlist_list[i].id; break; } } if (!verifySGBDConnection()) { return; } SqlCommand cmd = new SqlCommand("SampleKeeper.remove_playlist", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@playlist_ID", id); cmd.Connection = cn; if (PlaylistBox.SelectedItem == null) { hidden.Content = "Please select a playlist!"; } try { cmd.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception("Failed to update contact in database. \n ERROR MESSAGE: \n" + ex.Message); } finally { cn.Close(); } PlaylistWindow pw = new PlaylistWindow(user, userid); pw.Show(); this.Close(); }