private void Button_Click(object sender, RoutedEventArgs e) { try { int disc = Convert.ToInt32(discount.Text); int amnt_prs = Convert.ToInt32(amount_purshases.Text); if (disc == 3 && amnt_prs < 50000 || disc == 5 && amnt_prs >= 50000 && amnt_prs < 150000 || disc == 10 && amnt_prs >= 150000) { using (ADOmodel db = new ADOmodel(conString)) { var NewCard = new Loyality_card() { Loyality_discount = disc, Amount_purshases = amnt_prs }; db.Loyality_card.Add(NewCard); db.SaveChanges(); MessageBox.Show("Карта успешно создана!\nid новой карты: " + db.Loyality_card.Max(lc => lc.id_Loyality_card).ToString(), "Создание карты", MessageBoxButton.OK, MessageBoxImage.Information); this.Close(); } } else { MessageBox.Show("Некорректные данные!\nРазмер скидки и сумма покупок должны соответстоввать бизнес-правилам!", "Предупреждение", MessageBoxButton.OK, MessageBoxImage.Warning); } } catch (Exception) { MessageBox.Show("Корректно заполните поля!", "Предупреждение", MessageBoxButton.OK, MessageBoxImage.Warning); } }
private void Button_Click(object sender, RoutedEventArgs e) { string name = Name.Text; string surname = Surname.Text; string patronymic = Patronymic.Text; string phone = Phone.Text; string country = Country.Text; string city = City.Text; string street = Street.Text; string building = Building.Text; string flat = Flat.Text; if (name.Length != 0 && surname.Length != 0 && phone.Length == 11 && country.Length != 0 && city.Length != 0 && street.Length != 0 && building.Length != 0) { using (ADOmodel db = new ADOmodel(conString)) { Client_address new_address = new Client_address() { Country = country, City = city, Street = street, Building = building, Flat = flat }; // Добавление адреса db.Client_address.Add(new_address); db.SaveChanges(); var new_adr_id = db.Client_address.Select(p => p.id_Address).ToList().Last(); Loyality_card new_card = null; Client new_client = null; if (New_card.IsChecked == true) { new_card = new Loyality_card() { Loyality_discount = 3, Amount_purshases = 1 }; // Добавление новой карты db.Loyality_card.Add(new_card); db.SaveChanges(); } var new_card_id = db.Loyality_card.Select(p => p.id_Loyality_card).ToList().Last(); if (new_card != null) // Добавление нового клиента { new_client = new Client() { id_Address = new_adr_id, Name = name, Surname = surname, Patronymic = patronymic, Phone = phone, id_Loyality_card = new_card_id }; } else { new_client = new Client() { id_Address = new_adr_id, Name = name, Surname = surname, Patronymic = patronymic, Phone = phone }; } db.Clients.Add(new_client); db.SaveChanges(); MessageBox.Show("Новый клиент добавлен!", "Добавление", MessageBoxButton.OK, MessageBoxImage.Information); this.Close(); } } else { MessageBox.Show("Корректно заполните обязательные поля!", "Предупреждение", MessageBoxButton.OK, MessageBoxImage.Warning); } }