Exemple #1
0
        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();
        }
Exemple #2
0
 public DataTable getAllData()
 {
     if (m_PianoSongs == null)
     {
         m_PianoSongs = PianoSongDatabase.getAllData();
     }
     return(m_PianoSongs);
 }