private void InitializeDataSources() { db = new IsraelGeoDataCS(); SplashScreen.SetStatus("Loading Cities"); db.View_Cities.Load(); db.Cities.Load(); dataGridViewCities.DataSource = db.Cities.Local.ToBindingList(); SplashScreen.SetStatus("Loading Streets"); db.View_Streets.Load(); db.Streets.Load(); dataGridViewStreets.DataSource = db.Streets.Local.ToBindingList(); SplashScreen.SetStatus("Loading Regions"); db.Regions.Load(); dataGridViewRegions.DataSource = db.Regions.Local.ToBindingList(); SplashScreen.SetStatus("Loading Lishkot"); db.Lishkot.Load(); dataGridViewLishkot.DataSource = db.Lishkot.Local.ToBindingList(); SplashScreen.SetStatus("Loading Muacot"); db.Muacot.Load(); dataGridViewMuacot.DataSource = db.Muacot.Local.ToBindingList(); }
private void InitializeBoxes(IsraelGeoDataCS db) { //Regions var cities = db.Cities.OrderBy(item => item.city_name); comboBoxCity.DisplayMember = "Text"; comboBoxCity.ValueMember = "Value"; foreach (City c in cities) { comboBoxCity.Items.Add(new { Text = c.city_name, Value = c.city_code }); } comboBoxCity.SelectedIndex = comboBoxCity.FindStringExact("לא רשום"); //comboBoxCity.SelectedIndex = 0; textBoxNameStatus.Text = "official"; }
private void InitializeComboBoxes(IsraelGeoDataCS db) { //Regions db.Cities.OrderBy(item => item.city_name); var regions = db.Regions.OrderBy(item => item.region_name); comboBoxRegion.DisplayMember = "Text"; comboBoxRegion.ValueMember = "Value"; foreach (Region r in regions) { comboBoxRegion.Items.Add(new { Text = r.region_name, Value = r.region_code }); } comboBoxRegion.SelectedIndex = comboBoxRegion.FindStringExact("לא ידוע"); //comboBoxRegion.SelectedIndex = 0; //Lishkot var lishkot = db.Lishkot.OrderBy(item => item.lishka); comboBoxLishka.DisplayMember = "Text"; comboBoxLishka.ValueMember = "Value"; foreach (Lishka l in lishkot) { comboBoxLishka.Items.Add(new { Text = l.lishka, Value = l.lishkat_mana_code }); } comboBoxLishka.SelectedIndex = comboBoxLishka.FindStringExact(""); //comboBoxLishka.SelectedIndex = 0; //Muacot var muacot = db.Muacot.OrderBy(item => item.muaca_name); comboBoxMuaca.DisplayMember = "Text"; comboBoxMuaca.ValueMember = "Value"; foreach (Muaca m in muacot) { comboBoxMuaca.Items.Add(new { Text = m.muaca_name, Value = m.muaca_ezorit_code }); } comboBoxMuaca.SelectedIndex = comboBoxMuaca.FindStringExact(""); //comboBoxMuaca.SelectedIndex = 0; }
public FormCity(IsraelGeoDataCS db) { InitializeComponent(); InitializeComboBoxes(db); }
public FormStreet(IsraelGeoDataCS db) { InitializeComponent(); InitializeBoxes(db); }