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);
}
}
