public void searchSongs() { System.Windows.Data.CollectionViewSource pianoSongViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("pianoSongViewSource"))); bool displayAll = false; if (prvtSongFilter == -1 && prvtArtistFilter == -1 && prvtBookFilter == -1) { displayAll = true; } else if (prvtSongText.Trim() == "" && prvtArtistText.Trim() == "" && prvtBookText.Trim() == "") { displayAll = true; } if (displayAll) { bindingTable = PianoSongDatabase.getAllData(); } else { bindingTable = PianoSongDatabase.searchData(prvtSongFilter, prvtArtistFilter, prvtBookFilter, prvtSongText.Trim(), prvtArtistText.Trim(), prvtBookText.Trim()); } bindingTable.AcceptChanges(); pianoSongViewSource.Source = bindingTable; lblCount.Content = "Count: " + bindingTable.Rows.Count.ToString(); }
public DataTable getAllData() { if (m_PianoSongs == null) { m_PianoSongs = PianoSongDatabase.getAllData(); } return(m_PianoSongs); }
public DataTable getBooks() { if (m_Books == null) { m_Books = PianoSongDatabase.getAllBooks(); } return(m_Books); }
public DataTable getArtists() { if (m_Artists == null) { m_Artists = PianoSongDatabase.getAllArtists(); } return(m_Artists); }
private void btnDelete_Click(object sender, RoutedEventArgs e) { try { if (MessageBox.Show("Are you sure you want to delete all of the songs shown?", "Delete Songs?", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { int count = 0; if (bindingTable.Rows.Count == 0) { MessageBox.Show("No Songs to Delete."); return; } foreach (System.Data.DataRow pianoSong in bindingTable.Rows) { MyPianoSong song = new MyPianoSong(); song.songID = Convert.ToInt32(pianoSong["PianoSongID", System.Data.DataRowVersion.Current].ToString().Trim()); PianoSongDatabase.deleteSongEntry(song); count++; } bindingTable.AcceptChanges(); searchSongs(); if (count == 0) { MessageBox.Show("No songs were deleted."); } else { MessageBox.Show(String.Format("Successfully deleted {0} songs!", count)); } } } catch (Exception ex) { #if (DEBUG) Logger.LogError(ex, showDialog: true); #else Logger.LogError(ex); #endif } }
private void btnSaveEntries_Click(object sender, RoutedEventArgs e) { MyPianoSong ps; int count = 0; string artist; string book; string song; if (tbSongs.Text.Trim() == String.Empty) { MessageBox.Show("No songs entered."); return; } if (tbArtist.Text.Trim() == string.Empty) { MessageBox.Show("You must enter an artist..."); artist = ""; return; } else { artist = tbArtist.Text; } if (tbArtist.Text.Trim() == string.Empty) { MessageBox.Show("No book entered, using NONE for book name"); book = "NONE"; } else { book = tbBook.Text; } WaitDialog.Show("Saving songs, please wait..."); for (int i = 0; i < tbSongs.LineCount; i++) { try { ps = new MyPianoSong(); ps.SongArtist = artist; ps.SongBook = book; song = tbSongs.GetLineText(i); if (song != string.Empty) { string pageNum = ""; if (song.Contains("~")) { int index = song.IndexOf("~"); if (song.Substring(index + 1).Trim() != string.Empty) { pageNum = song.Substring(index + 1).Trim(); } ps.SongTitle = song.Substring(0, index).Trim(); if (IsNumeric(pageNum)) { ps.PageNum = int.Parse(pageNum); } } else { ps.SongTitle = song.Trim(); ps.PageNum = -1; } PianoSongDatabase.addSongEntry(ps); count++; } } catch (Exception ex) { Logger.LogError(ex); } } WaitDialog.Hide(); MessageBox.Show("Successfully saved " + count + " songs!"); cache.ClearAllCache(); tbBook.Text = ""; tbArtist.Text = ""; tbSongs.Text = ""; tbArtist.SetSource(cache.getArtists(), "artist"); tbBook.SetSource(cache.getBooks(), "book"); return; }
private void btnSaveChanges_Click(object sender, RoutedEventArgs e) { try { int count = 0; foreach (System.Data.DataRow pianoSong in bindingTable.Rows) { if (pianoSong.RowState == System.Data.DataRowState.Added) { if (pianoSong["Title"].ToString().Trim() == "" && pianoSong["Artist"].ToString().Trim() == "" && pianoSong["Book"].ToString().Trim() == "" && pianoSong["PageNumber"].ToString().Trim() == "") { continue; } MyPianoSong song = new MyPianoSong(); count++; try { song.SongTitle = pianoSong["Title"].ToString().Trim(); song.SongArtist = pianoSong["Artist"].ToString().Trim(); song.SongBook = pianoSong["Book"].ToString().Trim(); if (pianoSong["PageNumber"].ToString().Trim() == "") { song.PageNum = -1; } else { song.PageNum = Convert.ToInt32(pianoSong["PageNumber"].ToString().Trim()); } } catch (Exception exc) { Logger.LogMessage("Song title, artist, or book is not valid, unable to save.", level: Logger.logLevel.Error, showDialog: true); return; } string valid = song.songValidMessage(); if (valid.Trim() != "") { throw new Exception(valid); } PianoSongDatabase.addSongEntry(song); } else if (pianoSong.RowState == System.Data.DataRowState.Deleted) { count++; MyPianoSong song = new MyPianoSong(); song.songID = Convert.ToInt32(pianoSong["PianoSongID", System.Data.DataRowVersion.Original].ToString().Trim()); PianoSongDatabase.deleteSongEntry(song); } else if (pianoSong.RowState == System.Data.DataRowState.Modified) { count++; MyPianoSong song = new MyPianoSong(); try { song.songID = Convert.ToInt32(pianoSong["PianoSongID"].ToString().Trim()); song.SongTitle = pianoSong["Title"].ToString().Trim(); song.SongArtist = pianoSong["Artist"].ToString().Trim(); song.SongBook = pianoSong["Book"].ToString().Trim(); if (pianoSong["PageNumber"].ToString().Trim() == "") { song.PageNum = -1; } else { song.PageNum = Convert.ToInt32(pianoSong["PageNumber"].ToString().Trim()); } } catch (Exception exc) { Logger.LogMessage("Song title, artist, or book is not valid, unable to save.", level: Logger.logLevel.Error, showDialog: true); return; } string valid = song.songValidMessage(); if (valid.Trim() != "") { throw new Exception(valid); } PianoSongDatabase.updateSongEntry(song); } } bindingTable.AcceptChanges(); searchSongs(); if (count == 0) { MessageBox.Show("No changes were made"); } else { MessageBox.Show(String.Format("Successfully saved {0} changes!", count)); } } catch (Exception ex) { #if (DEBUG) Logger.LogError(ex, showDialog: true); #else Logger.LogError(ex); #endif } }