public static void loadTopicForCategory(Category category)
{
string sqlQuery = "SELECT topic_id, topic, verse_ref FROM bibletopics WHERE category_id = '"+category.category_id+"'";
MySqlConnection conn = DBManager.getConnection();
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand(sqlQuery, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
int topic_id = -1;
String topic_name = "";
String topic_verse_ref = "";
Topic topic = null;
while (rdr.Read())
{
topic_id = Int32.Parse((rdr[0]).ToString());
topic_name = (rdr[1]).ToString();
topic_verse_ref = (rdr[2]).ToString();
topic = new Topic(topic_id, topic_name, topic_verse_ref);
category.topics.Add(topic);
}
rdr.Close();
conn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
conn.Close();
}
finally
{
if (conn != null)
conn.Close();
}
}
static BibleTopicManager()
{
topic_categories = new Dictionary<int,Category>();
string sqlQuery = "SELECT id, category FROM bibletopiccategories";
MySqlConnection conn = DBManager.getConnection();
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand(sqlQuery, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
int cat_id = -1;
String category = "";
Category a_cat = null;
while (rdr.Read())
{
cat_id = Int32.Parse((rdr[0]).ToString());
category = (rdr[1]).ToString();
a_cat = new Category(cat_id, category);
topic_categories.Add(cat_id, a_cat);
loadTopicForCategory(a_cat);
}
rdr.Close();
conn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
conn.Close();
}
finally
{
if (conn != null)
conn.Close();
}
}