private void Button_accept_Click(object sender, RoutedEventArgs e)
{
if (TextBox_color_code.Text != "" && TextBox_description.Text != "" &&
TextBox_color_code.Text.Length == 6)
{
bool success = true;
switch (mode)
{
case QueryMode.add:
success = Shortcuts.add("colors", new string[] { "color_code", "description" },
new string[] { TextBox_color_code.Text, TextBox_description.Text },
connection);
break;
case QueryMode.change:
success = Shortcuts.change("colors", new string[] { "color_code", "description" },
new string[] { TextBox_color_code.Text, TextBox_description.Text },
primary_key_value,
connection);
break;
}
if (success)
{
parent.Focus();
parent.fill_table();
Close();
}
}
else
{
MessageBox.Show("Заполните все пустые поля!", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void Button_accept_Click(object sender, RoutedEventArgs e)
{
int dot_count1 = TextBox_product_amount.Text.Split('.').Length - 1;
int dot_count2 = TextBox_average_purchase_price.Text.Split('.').Length - 1;
if (ComboBox_product_name.Text != "" && TextBox_product_amount.Text != "" &&
ComboBox_supplier.Text != "" && TextBox_average_purchase_price.Text != "" &&
dot_count1 <= 1 && dot_count2 <= 1)
{
string count = Shortcuts.get_one_string_data_from($"SELECT count(*) FROM " +
$"`storage` WHERE `product_name` = '{ComboBox_product_name.Text}' AND " +
$"`supplier` = '{ComboBox_supplier.Text}';", connection);
if (int.Parse(count) >= 1 && mode == QueryMode.add)
{
MessageBox.Show("Уже существует запись с такой краской и поставщиком!", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
bool success = true;
string measurement = Shortcuts.get_one_string_data_from($"SELECT `measurement` FROM `products` where `name` = '{ComboBox_product_name.Text}';", connection);
switch (mode)
{
case QueryMode.add:
success = Shortcuts.execute_command($"INSERT INTO `storage` (`id`, `product_name`, `product_amount`, `measurement`, `supplier`, `average_purchase_price`) " +
$"VALUES (DEFAULT, '{ComboBox_product_name.Text}', {TextBox_product_amount.Text}, '{measurement}', " +
$"'{ComboBox_supplier.Text}', {TextBox_average_purchase_price.Text});", connection);
break;
case QueryMode.change:
success = Shortcuts.change("storage", new string[] { "id", "product_name", "product_amount", "measurement", "supplier", "average_purchase_price" },
new string[] { primary_key_value, ComboBox_product_name.Text, TextBox_product_amount.Text, measurement,
ComboBox_supplier.Text, TextBox_average_purchase_price.Text },
primary_key_value,
connection);
break;
}
if (success)
{
parent.Focus();
if (parent is MainWindow)
{
((MainWindow)parent).fill_table();
}
if (parent is SupplyManagerWindow)
{
((SupplyManagerWindow)parent).fill_table();
}
Close();
}
}
else
{
MessageBox.Show("Заполните корректно все числовые поля и поля с выбором!", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void Button_accept_Click(object sender, RoutedEventArgs e)
{
if (TextBox_vin.Text != "" && TextBox_number.Text != "" && ComboBox_owner_mail.Text != "" && TextBox_color.Text != "" && TextBox_model.Text != "")
{
bool success = true;
switch (mode)
{
case QueryMode.add:
success = Shortcuts.add("cars", new string[] { "vin", "number", "owner_mail", "color", "model" },
new string[] { TextBox_vin.Text.ToUpper(),
TextBox_number.Text,
ComboBox_owner_mail.Text,
TextBox_color.Text,
TextBox_model.Text },
connection);
break;
case QueryMode.change:
success = Shortcuts.change("cars", new string[] { "vin", "number", "owner_mail", "color", "model" },
new string[] { TextBox_vin.Text.ToUpper(),
TextBox_number.Text,
ComboBox_owner_mail.Text,
TextBox_color.Text,
TextBox_model.Text },
primary_key_value, connection);
break;
}
if (success)
{
parent.Focus();
if (parent is MainWindow)
{
((MainWindow)parent).fill_table();
}
if (parent is RequestManagerWindow)
{
((RequestManagerWindow)parent).fill_table();
}
Close();
}
}
else
{
MessageBox.Show("Заполните все пустые поля!", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void Button_accept_Click(object sender, RoutedEventArgs e)
{
if (TextBox_surface_size.Text != "" && TextBox_cost.Text != "")
{
if (Shortcuts.change("car_parts", new string[] { "id", "name", "surface_size", "cost" },
new string[] { primary_key_value, Label_name.Content.ToString(), TextBox_surface_size.Text, TextBox_cost.Text },
primary_key_value, connection))
{
parent.Focus();
parent.fill_table();
Close();
}
}
else
{
MessageBox.Show("Введите правильные значения и не оставляйте пустых полей!", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void Button_accept_Click(object sender, RoutedEventArgs e)
{
if (TextBox_name.Text != "" && ComboBox_city.Text != "" && TextBox_address.Text != "" && TextBox_phone.Text != "")
{
bool success = true;
switch (mode)
{
case QueryMode.add:
success = Shortcuts.add("suppliers", new string[] { "name", "city", "address", "phone" },
new string[] { TextBox_name.Text,
ComboBox_city.Text,
TextBox_address.Text,
TextBox_phone.Text },
connection);
break;
case QueryMode.change:
success = Shortcuts.change("suppliers", new string[] { "name", "city", "address", "phone" },
new string[] { TextBox_name.Text,
ComboBox_city.Text,
TextBox_address.Text,
TextBox_phone.Text },
primary_key_value, connection);
break;
}
if (success)
{
parent.Focus();
if (parent is MainWindow)
{
((MainWindow)parent).fill_table();
}
if (parent is SupplyManagerWindow)
{
((SupplyManagerWindow)parent).fill_table();
}
Close();
}
}
else
{
MessageBox.Show("Заполните все пустые поля!", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void Button_action_Click(object sender, RoutedEventArgs e)
{
bool success = true;
if (mode == QueryMode.change)
{
success = Shortcuts.change(table_name, new string[] { field_name },
new string[] { Textbox_item_value.Text },
old_value,
connection);
}
else
{
success = Shortcuts.add(table_name, new string[] { field_name }, new string[] { Textbox_item_value.Text }, connection);
}
if (success)
{
Close();
parent_window.fill_table();
parent_window.Focus();
}
}
private void Button_accept_Click(object sender, RoutedEventArgs e)
{
if (TextBox_name.Text != "" && ComboBox_paint_type.Text != "" &&
ComboBox_color_code.SelectedIndex != -1)
{
bool success = true;
switch (mode)
{
case QueryMode.add:
success = Shortcuts.add("products", new string[] { "name", "paint_type", "color_code", "measurement" },
new string[] { TextBox_name.Text, ComboBox_paint_type.Text,
(string)(ComboBox_color_code.Items[ComboBox_color_code.SelectedIndex] as ComboBoxItem).Tag,
(ComboBox_paint_type.Text == "Плёнка")? "рулон": "литр" },
connection);
break;
case QueryMode.change:
success = Shortcuts.change("products", new string[] { "name", "paint_type", "color_code", "measurement" },
new string[] { TextBox_name.Text, ComboBox_paint_type.Text,
(string)(ComboBox_color_code.Items[ComboBox_color_code.SelectedIndex] as ComboBoxItem).Tag,
(ComboBox_paint_type.Text == "Плёнка")? "рулон": "литр" },
primary_key_value,
connection);
break;
}
if (success)
{
parent.Focus();
parent.fill_table();
Close();
}
}
else
{
MessageBox.Show("Заполните все пустые поля!", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void Button_accept_Click(object sender, RoutedEventArgs e)
{
if (TextBox_mail.Text != "" && TextBox_phone.Text != "" &&
TextBox_surname.Text != "" && TextBox_first_name.Text != "" &&
TextBox_second_name.Text != "" && ComboBox_gender.Text != "")
{
string m = TextBox_mail.Text.ToLower();
if (m.Split('@').Length != 2)
{
MessageBox.Show("Неправильный ввод почты!");
return;
}
if (!(m.Contains('.') && m.Split('@')[1].Split('.')[1].Length >= 2 &&
m.Split('@')[1].Split('.')[1].Length <= 4))
{
MessageBox.Show("Неправильный ввод почты!");
return;
}
if (m.LastIndexOf('.') - m.IndexOf('@') <= 1)
{
MessageBox.Show("Неправильный ввод почты!");
return;
}
if (m.IndexOf('@') == 0)
{
MessageBox.Show("Неправильный ввод почты!");
return;
}
/*Regex reg = new Regex("^[A-Za-z0-9._-]+@[A-Za-z0-9.-]+.[A-Za-z]{2,4}$");
* if (!reg.IsMatch(TextBox_mail.Text.ToLower()))
* {
* MessageBox.Show("Неправильный ввод почты!");
* return;
* }*/
bool success = true;
switch (mode)
{
case QueryMode.add:
success = Shortcuts.add("clients", new string[] { "mail", "phone", "surname", "first_name", "second_name", "gender" },
new string[] { TextBox_mail.Text.ToLower(), TextBox_phone.Text,
TextBox_surname.Text, TextBox_first_name.Text,
TextBox_second_name.Text, ComboBox_gender.Text },
connection);
break;
case QueryMode.change:
success = Shortcuts.change("clients", new string[] { "mail", "phone", "surname", "first_name", "second_name", "gender" },
new string[] { TextBox_mail.Text.ToLower(), TextBox_phone.Text,
TextBox_surname.Text, TextBox_first_name.Text,
TextBox_second_name.Text, ComboBox_gender.Text },
primary_key_value,
connection);
break;
}
if (success)
{
parent.Focus();
if (parent is MainWindow)
{
((MainWindow)parent).fill_table();
}
if (parent is RequestManagerWindow)
{
((RequestManagerWindow)parent).fill_table();
}
Close();
}
}
else
{
MessageBox.Show("Заполните все пустые поля!", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
