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"] + "# " + row["title"]);
lstSongids.Items.Add(row["songid"]);
lstSongResults.SelectedIndex = 0;
lstSongids.SelectedIndex = 0;
}
grpSongResults.Text = lstSongResults.Items.Count + " " + lstBookcodes.Text + " songs found";
}
catch (Exception ex)
{
loadFeedback("Oops! Sorry, songs listing failed: " + ex.Message, false);
}
}
public void seachForSongs(string searchstr, bool criteria)
{
if (txtSearch.Text != "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;
}
grpSongResults.Text = lstSongResults.Items.Count + " songs found with '" + searchstr + "'";
}
catch (Exception ex)
{
loadFeedback("Oops! Sorry, songs searching has failed due to the error: " + ex.Message, false);
}
}
}
public void loadNewTestament()
{
try
{
lstNewtt.Items.Clear();
lstNewTestament.Items.Clear();
sqlQuery = "SELECT * FROM books WHERE testament=2;";
appDB = new AppDatabase();
dRowCol = appDB.getList(sqlQuery);
foreach (DataRow row in dRowCol)
{
lstNewtt.Items.Add(row["title"] + " (" + row["code"] + ")");
lstNewTestament.Items.Add(row["title"]);
lstNewtt.SelectedIndex = 0;
lstNewTestament.SelectedIndex = 0;
}
}
catch (Exception ex)
{
loadFeedback("Oops! Sorry, books listing failed: " + 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);
}
}
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);
}
}