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