public bool BuildDictionaries()
{
// SCB TODO: Remove all this if not using.
try
{
MySqlDAL mySqlDAL = new MySqlDAL("");
Dictionaries dicts = new Dictionaries();
MySqlDataReader dr = mySqlDAL.ExecuteDataReader("SELECT id, name, description FROM ref_migration_item_type");
if (dr != null && dr.HasRows)
{
while (dr.Read())
{
dicts.AddToItemTypesDictionary(dr.GetInt32(0), dr[1].ToString());
}
}
mySqlDAL.Close();
dr = mySqlDAL.ExecuteDataReader("SELECT id, arrest_type FROM ref_migration_arrest_types");
if (dr != null && dr.HasRows)
{
while (dr.Read())
{
dicts.AddToArrestTypesDictionary(dr.GetInt32(0), dr[1].ToString());
}
}
mySqlDAL.Close();
logging.WriteEvent("BuildDictionaries completed.");
return(true);
}
catch (System.Exception ex)
{
logging.WriteEvent("Error in BuildDictionaries: " + ex.Message);
return(false);
}
}
