public void loadSingleSong(int songid)
{
try
{
cur_stz = 0;
sqlQuery = "SELECT * FROM songs WHERE songid=" + songid + ";";
appDB = new AppDatabase();
reader = appDB.getSingle(sqlQuery);
while (reader.Read())
{
lblSongno.Text = "#" + reader["number"].ToString();
lblSongTitle.Text = vsbf.textRender(reader["title"].ToString());
songtext = reader["content"].ToString();
}
appDB.sqlClose();
songstanzas = songtext.Split('`');
stanzas = songstanzas.Length;
lblSongText.Text = vsbf.songRender(songstanzas[cur_stz]);
}
catch (Exception ex)
{
lblSongTitle.Text = "Song projection failed";
lblSongText.Text = "Oops! Song projection failed due to: " + ex.Message;
}
}
public void loadSingleSong(int songid)
{
try
{
txtSongContent.Clear();
sqlQuery = "SELECT * FROM songs WHERE songid=" + songid + ";";
appDB = new AppDatabase();
reader = appDB.getSingle(sqlQuery);
while (reader.Read())
{
txtSongContent.Text = vsbf.songRender(reader["content"].ToString());
}
appDB.sqlClose();
}
catch (Exception ex)
{
loadFeedback("Oops! Sorry song viewing failed: " + ex.Message, false, true);
}
}
public void loadBookDetails(string songid)
{
try
{
txtNotes.Clear();
sqlQuery = "SELECT * FROM books WHERE bookid=" + songid + ";";
appDB = new AppDatabase();
reader = appDB.getSingle(sqlQuery);
while (reader.Read())
{
txtBookTitle.Text = reader["title"].ToString();
txtBookCode.Text = reader["code"].ToString();
txtNotes.Text = reader["notes"].ToString();
lblInfo.Text = reader["songs"].ToString() + " songs";
}
appDB.sqlClose();
}
catch (Exception ex)
{
loadFeedback("Oops! Sorry book viewing failed: " + ex.Message, false, true);
}
}