private void Button_Click(object sender, RoutedEventArgs e) { try { using (ModelBD model = new ModelBD()) { Apartaments apartaments = new Apartaments { StreetName = STNameText.Text, HouseNumber = HousNumText.Text, ApartamentNumber = int.Parse(APNumText.Text), SquareApartament = double.Parse(SquareText.Text), AmountRoom = int.Parse(AmountRoomText.Text), Price = decimal.Parse(PriceText.Text) }; model.Apartaments.Add(apartaments); model.SaveChanges(); MessageBox.Show("Квартира успешно добавлена"); ClearTextBox(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void SaveAP(object sender, RoutedEventArgs e) { try { using (ModelBD model = new ModelBD()) { int? idAP = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]); Apartaments apartament = model.Apartaments.Where(p => p.ID == idAP).FirstOrDefault(); int? idComb = int.Parse(FIOComb.SelectedItem.ToString().Split(':')[1]); Realtors realtors = model.Realtors.Where(p => p.ID == idComb).FirstOrDefault(); apartament.StreetName = STNameText.Text; apartament.HouseNumber = HouseNumText.Text; apartament.ApartamentNumber = int.Parse(APNumText.Text); apartament.SquareApartament = double.Parse(SquareText.Text); apartament.AmountRoom = int.Parse(AmountRoomText.Text); apartament.Price = decimal.Parse(PriceText.Text); model.Entry(apartament).State = System.Data.Entity.EntityState.Modified; model.SaveChanges(); SetChangeComboBox(realtors, apartament); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void DeleteAP(object sender, RoutedEventArgs e) { try { using (ModelBD model = new ModelBD()) { int idAP = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]); Apartaments apartaments = model.Apartaments.Where(p => p.ID == idAP).FirstOrDefault(); model.Apartaments.Remove(apartaments); model.SaveChanges(); int? idComb = int.Parse(FIOComb.SelectedItem.ToString().Split(':')[1]); Realtors realtors = model.Realtors.Where(p => p.ID == idComb).FirstOrDefault(); int? idAPart = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]); Apartaments apartament = model.Apartaments.Where(p => p.ID == idAPart).FirstOrDefault(); SetChangeComboBox(realtors, apartament); ClearTextBoxAP(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void APComb_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { if (APComb.SelectedItem != null && FIOComb.SelectedItem != null) { using (ModelBD model = new ModelBD()) { int? idAP = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]); Apartaments apartament = model.Apartaments.Where(p => p.ID == idAP).FirstOrDefault(); STNameText.Text = apartament.StreetName; HouseNumText.Text = apartament.HouseNumber; APNumText.Text = apartament.ApartamentNumber.ToString(); SquareText.Text = apartament.SquareApartament.ToString(); AmountRoomText.Text = apartament.AmountRoom.ToString(); PriceText.Text = apartament.Price.ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void SaveAgent(object sender, RoutedEventArgs e) { try { using (ModelBD model = new ModelBD()) { int? idComb = int.Parse(FIOComb.SelectedItem.ToString().Split(':')[1]); Realtors realtors = model.Realtors.Where(p => p.ID == idComb).FirstOrDefault(); int? idAP = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]); Apartaments apartament = model.Apartaments.Where(p => p.ID == idAP).FirstOrDefault(); realtors.FIO = FIOText.Text; realtors.Percent = int.Parse(PercentText.Text); model.Entry(realtors).State = System.Data.Entity.EntityState.Modified; model.SaveChanges(); SetChangeComboBox(realtors, apartament); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void SetChangeComboBox(Realtors realtors, Apartaments apartament) { try { APComb.Items.Clear(); FIOComb.Items.Clear(); SetComboBox(); using (ModelBD model = new ModelBD()) { FIOComb.SelectedItem = realtors.FIO + " - ID: " + realtors.ID; APComb.SelectedItem = apartament.StreetName + " - ID: " + apartament.ID; } } catch (Exception ex) { } }