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