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);
}
}
