private void buttonDelete_Click(object sender, EventArgs e) { if (dataGridViewAnk.SelectedRows.Count == 0) { MessageBox.Show("Пожалуйста, выберите строку!"); return; } int rowIndex = dataGridViewAnk.SelectedRows[0].Index; using (LoveDataContext db = new LoveDataContext()) { Anketa anketa = db.Anketa.Find(Convert.ToInt32(dataGridViewAnk[0, rowIndex].Value)); DialogResult dialogResult = MessageBox.Show($"Вы увены, что хотите удалить анкету {anketa.FIO}?", "", MessageBoxButtons.OKCancel); if (dialogResult != DialogResult.OK) { return; } db.Anketa.Remove(anketa); db.SaveChanges(); } FillTable(); ShowAll(); }
private void buttonAdd_Click(object sender, EventArgs e) { using (LoveDataContext db = new LoveDataContext()) { BindingList <City> CitiesForNewAnketa = new BindingList <City>(); foreach (var c in Cities) { if (c.CityName != "Любой") { CitiesForNewAnketa.Add(c); } } AnketaDetails anketaDetails = new AnketaDetails(CitiesForNewAnketa); anketaDetails.comboBoxCity.DataSource = CitiesForNewAnketa; DialogResult dialogResult = anketaDetails.ShowDialog(); if (dialogResult != DialogResult.OK) { return; } string city = (anketaDetails.comboBoxCity.SelectedItem as City).CityName; Anketa anketa = new Anketa { FIO = anketaDetails.textBoxFIO.Text, Pol = anketaDetails.comboBoxPol.SelectedItem.ToString(), Uvlechenia = new Uvlechenia { Sport = anketaDetails.checkBoxSport.Checked, Travelling = anketaDetails.checkBoxTrav.Checked, TV = anketaDetails.checkBoxTV.Checked, Shopping = anketaDetails.checkBoxShop.Checked }, Phone = anketaDetails.maskedTextBoxPhone.Text.ToString(), City = db.City.Where(c => c.CityName == city).FirstOrDefault(), Age = (int)anketaDetails.numericUpDownAge.Value }; db.Anketa.Add(anketa); db.SaveChanges(); FillTable(); ShowAll(); } }
private void buttonAddCity_Click(object sender, EventArgs e) { CityAdding cityAdding = new CityAdding(); DialogResult dialogResult = cityAdding.ShowDialog(); if (dialogResult != DialogResult.OK) { return; } using (LoveDataContext db = new LoveDataContext()) { db.City.Add(new City { CityName = cityAdding.textBoxCity.Text }); db.SaveChanges(); cities = new BindingList <City>(db.City.ToList()); comboBoxCity.DataSource = cities; } }