예제 #1
0
파일: FormMain.cs 프로젝트: han6man/EF6
        private void toolStripButtonCityAdd_Click(object sender, EventArgs e)
        {
            FormCity     formCity = new FormCity(db);
            DialogResult result   = formCity.ShowDialog(this);

            if (result == DialogResult.Cancel)
            {
                return;
            }

            City city = new City();
            int  city_code;
            bool converted = Int32.TryParse(formCity.textBoxCityCode.Text, out city_code);

            if (converted == false)
            {
                return;
            }
            city.City_Code             = city_code;
            city.City_Name             = formCity.textBoxCityName.Text;
            city.City_Name_En          = formCity.textBoxCityNameForeign.Text;
            city.Country_Region_Code   = (formCity.comboBoxRegion.SelectedItem as dynamic).Value;
            city.Lishkat_Mana_Code     = (formCity.comboBoxLishka.SelectedItem as dynamic).Value;
            city.Regional_Council_Code = (formCity.comboBoxMuaca.SelectedItem as dynamic).Value;

            db.Cities.Add(city);
            db.SaveChanges();

            MessageBox.Show("New object added");
        }
예제 #2
0
파일: FormMain.cs 프로젝트: han6man/EF6
        private void toolStripButtonCityEdit_Click(object sender, EventArgs e)
        {
            if (dataGridViewCities.SelectedRows.Count > 0)
            {
                int  index = dataGridViewCities.SelectedRows[0].Index;
                int  city_code;
                bool converted = Int32.TryParse(dataGridViewCities[0, index].Value.ToString(), out city_code);
                if (converted == false)
                {
                    return;
                }

                City city = db.Cities.Find(city_code);

                FormCity formCity = new FormCity(db);
                formCity.textBoxCityCode.Text         = city.City_Code.ToString();
                formCity.textBoxCityName.Text         = city.City_Name;
                formCity.textBoxCityNameForeign.Text  = city.City_Name_En;
                formCity.comboBoxRegion.SelectedIndex = formCity.comboBoxRegion.FindStringExact(city.Country_Region.Country_Region_Name);
                formCity.comboBoxLishka.SelectedIndex = formCity.comboBoxLishka.FindStringExact(city.Lishkat_Mana.Lishkat_Mana_Name);
                formCity.comboBoxMuaca.SelectedIndex  = formCity.comboBoxMuaca.FindStringExact(city.Regional_Council.Regional_Council_Name);

                formCity.textBoxCityCode.Enabled = false;

                DialogResult result = formCity.ShowDialog(this);

                if (result == DialogResult.Cancel)
                {
                    return;
                }

                city.City_Name             = formCity.textBoxCityName.Text;
                city.City_Name_En          = formCity.textBoxCityNameForeign.Text;
                city.Country_Region_Code   = (formCity.comboBoxRegion.SelectedItem as dynamic).Value;
                city.Lishkat_Mana_Code     = (formCity.comboBoxLishka.SelectedItem as dynamic).Value;
                city.Regional_Council_Code = (formCity.comboBoxMuaca.SelectedItem as dynamic).Value;

                db.SaveChanges();

                dataGridViewCities.Refresh(); // обновляем грид

                MessageBox.Show("Object updated");
            }
        }