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())
{
txtNumber.Text = reader["number"].ToString();
txtSongKey.Text = reader["key"].ToString();
txtSongTitle.Text = vsbf.songRender(reader["title"].ToString());
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 bookid)
{
try
{
txtNotes.Clear();
sqlQuery = "SELECT * FROM books WHERE bookid=" + bookid + ";";
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);
}
}
public void loadSingleSong(int songid)
{
try
{
txtSongContent.Clear();
sqlQuery = "SELECT *, books.title AS songbook FROM songs LEFT JOIN books ON songs.book = books.code WHERE songid=" + songid + ";";
appDB = new AppDatabase();
reader = appDB.GetSingle(sqlQuery);
while (reader.Read())
{
txtSongTitle.Text = reader["number"].ToString() + "# " + vsbf.textRender(reader["title"].ToString()) +
" | " + reader["songbook"].ToString();
txtSongContent.Text = vsbf.songRender(reader["content"].ToString());
txtSongDetails.Text = "Key: " + reader["key"].ToString() + " © " + reader["author"].ToString() + "\r\n" +
reader["notes"].ToString() + "\r\nLast Updated: " + reader["updated"].ToString();
}
appDB.SQLClose();
}
catch (Exception ex)
{
loadFeedback(langs.As_Lang(vsb_lang, "error_songs_viewing") + " " + ex.Message, false, true);
}
}
public void LoadSingleSong(int songid)
{
try
{
string temptext = "", tempverse = "", tempcount = "";
cur_stz = 0;
sqlQuery = "SELECT *, books.title AS songbook FROM songs LEFT JOIN books ON songs.book = books.code WHERE songid=" + songid + ";";
appDB = new AppDatabase();
reader = appDB.GetSingle(sqlQuery);
while (reader.Read())
{
lblSongno.Text = "#" + reader["number"].ToString();
lblSongTitle.Text = reader["number"].ToString() + "# " + vsbf.textRender(reader["title"].ToString()) + " " + reader["key"].ToString().Replace("-", "");
lblDetails.Text = reader["songbook"].ToString();
songtext = reader["content"].ToString();
}
appDB.SQLClose();
if (Regex.Matches(songtext, "CHORUS").Count == 1)
{
songtemps = songtext.Split('|');
int tempscount = songtemps.Length - 1;
string chorustr = songtemps[1].Replace("CHORUS$", "");
temptext = songtemps[0] + "#" + chorustr;
tempverse = "VERSE#CHORUS";
tempcount = "1 of " + tempscount + "# ";
for (int i = 2; i < tempscount + 1; i++)
{
temptext = temptext + "#" + songtemps[i] + "#" + chorustr;
tempverse = tempverse + "#VERSE#CHORUS";
tempcount = tempcount + "#" + i + " of " + tempscount + "# ";
}
songstanzas = temptext.Split('#');
hasChorus = true;
}
else
{
songstanzas = songtext.Split('|');
tempverse = "VERSE";
tempcount = "1 of " + songstanzas.Length;
for (int i = 2; i < songstanzas.Length; i++)
{
tempverse = tempverse + "#VERSE";
tempcount = tempcount + "#" + (i - 1) + " of " + songstanzas.Length;
}
hasChorus = false;
}
versechorus = tempverse.Split('#');
versecounts = tempcount.Split('#');
stanzas = songstanzas.Length;
pbxDown.Visible = true;
lblSongText.Text = vsbf.songRender(songstanzas[cur_stz]);
lblItem.Text = versechorus[cur_stz];
lblVerses.Text = versecounts[cur_stz];
//lblDetails.Text = stanzas.ToString();
}
catch (Exception ex)
{
lblSongTitle.Text = "Song projection failed";
lblSongText.Text = "Oops! Song projection failed due to: " + ex.Message;
}
}
