private void deleteButton_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("Are you sure you want to delete this song?", "MiniPlayer",
MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
int songId = Convert.ToInt32(songIdComboBox.SelectedItem);
Console.WriteLine("Deleting song " + songId);
if (musicLib.DeleteSong(songId))
{
// Remove the song from the list box and select the next item
(songIdComboBox.ItemsSource as ObservableCollection <string>).Remove(
songIdComboBox.SelectedItem.ToString());
if (songIdComboBox.Items.Count > 0)
{
songIdComboBox.SelectedItem = songIdComboBox.Items[0];
}
else
{
// No more songs to display
deleteButton.IsEnabled = false;
titleTextBox.Text = "";
artistTextBox.Text = "";
albumTextBox.Text = "";
genreTextBox.Text = "";
lengthTextBox.Text = "";
filenameTextBox.Text = "";
}
}
else
{
Console.WriteLine("There was a problem deleting song with the id: " + songId);
}
}
}
private void DeleteCommand_Executed(object sender, ExecutedRoutedEventArgs e)
{
if (MessageBox.Show("Are you sure you want to delete this song?", "MiniPlayer",
MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
string songId = songIdComboBox.SelectedItem.ToString();
Console.WriteLine("Deleting song " + songId);
musicLib.DeleteSong(Convert.ToInt32(songId));
// Remove the song from the combo box and select the next item
songIds.Remove(songIdComboBox.SelectedItem.ToString());
if (songIdComboBox.Items.Count > 0)
{
songIdComboBox.SelectedItem = songIdComboBox.Items[0];
}
else
{
// No more songs to display
titleTextBox.Text = "";
artistTextBox.Text = "";
albumTextBox.Text = "";
genreTextBox.Text = "";
lengthTextBox.Text = "";
filenameTextBox.Text = "";
}
}
}
private void DeleteCommand_Executed(object sender, ExecutedRoutedEventArgs e)
{
if (MessageBox.Show("Are you sure you want to delete this song?", "MiniPlayer",
MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
string songId = songIdComboBox.SelectedItem.ToString();
Console.WriteLine("Deleting song " + songId);
//// Search the primary key for the selected song and delete it from
//// the song table
//DataTable table = musicDataSet.Tables["song"];
//table.Rows.Remove(table.Rows.Find(songId));
//// Remove from playlist_song every occurance of songId.
//// Add rows to a separate list before deleting because we'll get an exception
//// if we try to delete more than one row while looping through table.Rows
//List<DataRow> rows = new List<DataRow>();
//table = musicDataSet.Tables["playlist_song"];
//foreach (DataRow row in table.Rows)
// if (row["song_id"].ToString() == songId.ToString())
// rows.Add(row);
//foreach (DataRow row in rows)
// row.Delete();
int songIdint = System.Convert.ToInt32(songId);
musicLib.DeleteSong(songIdint);
// Remove the song from the combo box and select the next item
songIds.Remove(songIdComboBox.SelectedItem.ToString());
if (songIdComboBox.Items.Count > 0)
{
songIdComboBox.SelectedItem = songIdComboBox.Items[0];
}
else
{
// No more songs to display
titleTextBox.Text = "";
artistTextBox.Text = "";
albumTextBox.Text = "";
genreTextBox.Text = "";
lengthTextBox.Text = "";
filenameTextBox.Text = "";
}
}
}