public void loadBookSongs(string code) { try { lstSongResults.Items.Clear(); lstSongids.Items.Clear(); sqlQuery = "SELECT songid, number, title FROM songs WHERE book='" + code + "';"; appDB = new AppDatabase(); dRowCol = appDB.GetList(sqlQuery); foreach (DataRow row in dRowCol) { lstSongResults.Items.Add(row["number"] + "# " + vsbf.textRender(row["title"].ToString())); lstSongids.Items.Add(row["songid"]); lstSongResults.SelectedIndex = 0; lstSongids.SelectedIndex = 0; } string[] valuestrings = { lstSongResults.Items.Count.ToString(), lstBookcodes.Text }; grpSongResults.Text = langs.As_Lang_Arr(langs.As_Lang(vsb_lang, "songs_found"), valuestrings); } catch (Exception ex) { loadFeedback(langs.As_Lang(vsb_lang, "error_songs_listing") + " " + ex.Message, false); } }
public void loadBookSongs(string code) { try { lstSongResults.Items.Clear(); songno = 0; sqlQuery = "SELECT songid, number, title FROM songs WHERE book='" + code + "';"; appDB = new AppDatabase(); dRowCol = appDB.GetList(sqlQuery); foreach (DataRow row in dRowCol) { songno = int.Parse(row["number"] + ""); lstSongResults.Items.Add(row["number"] + "# " + vsbf.textRender(row["title"].ToString())); lstSongResults.SelectedIndex = 0; } grpSongResults.Text = lstSongResults.Items.Count + " " + lstBookcodes.Text + " songs found"; txtNumber.Placeholder = (songno + 1).ToString(); txtNumber.Text = (songno + 1).ToString(); } catch (Exception ex) { LoadFeedback("Oops! Sorry song listing failed: " + ex.Message, false, true); } }
public void seachForSongs(string searchstr, bool criteria) { if (txtSearch.Text != langs.As_Lang(vsb_lang, "search_for_songs")) { try { lstSongResults.Items.Clear(); lstSongids.Items.Clear(); string searchcriteria = ""; if (!criteria) { searchcriteria = " AND book='" + lstBookcodes.Text + "'"; } if (searchstr.Length < 5) { sqlQuery = "SELECT songid, number, title FROM songs " + "WHERE number=" + int.Parse(searchstr) + searchcriteria + ";"; } else { sqlQuery = "SELECT songid, number, title FROM songs " + "WHERE title LIKE '%" + searchstr + "%' " + searchcriteria + "OR content LIKE '%" + searchstr + searchcriteria + "%';"; } appDB = new AppDatabase(); dRowCol = appDB.GetList(sqlQuery); foreach (DataRow row in dRowCol) { lstSongResults.Items.Add(row["number"] + "# " + row["title"]); lstSongids.Items.Add(row["songid"]); lstSongResults.SelectedIndex = 0; lstSongids.SelectedIndex = 0; } string[] valuestrings = { lstSongResults.Items.Count.ToString(), searchstr }; grpSongResults.Text = langs.As_Lang_Arr(langs.As_Lang(vsb_lang, "songs_found_with"), valuestrings); lstSongResults.SelectedIndex = 0; } catch (Exception ex) { loadFeedback(langs.As_Lang(vsb_lang, "error_song_searching") + ex.Message, false); } } }
public void loadBooks() { try { cmbBooks.Items.Clear(); lstBookcodes.Items.Clear(); sqlQuery = "SELECT * FROM books WHERE state=1;"; appDB = new AppDatabase(); dRowCol = appDB.GetList(sqlQuery); foreach (DataRow row in dRowCol) { cmbBooks.Items.Add(row["title"] + " (" + row["songs"] + ")"); lstBookcodes.Items.Add(row["code"]); cmbBooks.SelectedIndex = 0; lstBookcodes.SelectedIndex = 0; } } catch (Exception ex) { loadFeedback(langs.As_Lang(vsb_lang, "error_books_listing") + " " + ex.Message, false); } }
public void loadBooks() { try { cmbBooks.Items.Clear(); lstBookcodes.Items.Clear(); sqlQuery = "SELECT * FROM books WHERE state=1;"; appDB = new AppDatabase(); dRowCol = appDB.GetList(sqlQuery); foreach (DataRow row in dRowCol) { cmbBooks.Items.Add(row["title"] + " (" + row["songs"] + ")"); lstBookcodes.Items.Add(row["code"]); cmbBooks.SelectedIndex = 0; lstBookcodes.SelectedIndex = 0; } } catch (Exception ex) { LoadFeedback("Oops! Sorry books listing failed: " + ex.Message, false, true); } }
public void loadBooks() { try { lstBooks.Items.Clear(); lstBookids.Items.Clear(); sqlQuery = "SELECT * FROM books;"; appDB = new AppDatabase(); dRowCol = appDB.GetList(sqlQuery); foreach (DataRow row in dRowCol) { lstBooks.Items.Add(row["title"] + " (" + row["songs"] + ")"); lstBookids.Items.Add(row["bookid"]); lstBooks.SelectedIndex = 0; lstBookids.SelectedIndex = 0; } grpBookResults.Text = lstBooks.Items.Count + " books exist currently"; } catch (Exception ex) { LoadFeedback("Oops! Sorry, books listing failed: " + ex.Message, false); } }