public static void GetDirectorates()
{
OpenDB();
SqlCommand sqlQuery = new SqlCommand();
sqlQuery.Connection = dbConn;
sqlQuery.CommandText = "SELECT * FROM tbl_org_directorate";
using (DbDataReader reader = sqlQuery.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
int directorate_id = reader.GetByte(0);
string directorate_text = reader.GetString(1);
bool directorate_inactive = reader.GetBoolean(2);
Directorate dir = new Directorate(directorate_id, directorate_text, directorate_inactive);
Globals.trackerOptions.directorates.Add(dir);
}
reader.NextResult();
}
else
{
Debug.WriteLine("Error : Empty Table");
}
}
}
private void cmbDirectorates_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (cmbDirectorates.SelectedIndex >= 0)
{
Directorate dir = directorateList[cmbDirectorates.SelectedIndex];
PopulateRegions(dir);
WriteStatus(dir.directorate_text);
}
}
private void PopulateRegions(Directorate directorate)
{
cmbRegions.Items.Clear();
regionList = new List <Region>();
foreach (Region region in Globals.trackerOptions.regions)
{
if (region.directorate_id == directorate.directorate_id)
{
cmbRegions.Items.Add(region.region_text);
regionList.Add(region);
}
}
if (cmbRegions.Items.Count > 0)
{
cmbRegions.SelectedIndex = 0;
PopulateSites(regionList[0]);
}
}
