private void Confirm_Click(object sender, RoutedEventArgs e) { try { if (Name.Text.Length > 0 && Description.Text.Length > 0 && Price.Text.Length > 0 && Year.Text.Length > 0 && Types.SelectedItem != null && Oils.SelectedItem != null && Brands.SelectedItem != null && Privods.SelectedItem != null && Bodies.SelectedItem != null && KPP.SelectedItem != null) { int type_id = GetId(Types.SelectedItem.ToString(), "AutoTypes"); int oil_id = GetId(Oils.SelectedItem.ToString(), "AutoOils"); int brand_id = GetId(Brands.SelectedItem.ToString(), "AutoBrands"); int privod_id = GetId(Privods.SelectedItem.ToString(), "AutoPrivods"); int body_id = GetId(Bodies.SelectedItem.ToString(), "TypeBodies"); int kpp_id = GetId(KPP.SelectedItem.ToString(), "KPPTypes"); using (SqlConnection connection = new SqlConnection(mw.connectionString)) { connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandText = $"insert into Articles values({mw.GetUserId()},{type_id},{oil_id},{brand_id},{privod_id},{kpp_id},{body_id},{Convert.ToInt32(Year.Text)}, '{Name.Text}','{Description.Text}', {ChangeComa(Price.Text)})"; command.ExecuteNonQuery(); MessageBox.Show("Успешно добавлено"); } } else { MessageBox.Show("Введите все данные"); } } catch (Exception error) { MessageBox.Show(error.Message); } }
private void Order_Click(object sender, RoutedEventArgs e) { Order order = new Order(); order.IDArticle = Id; order.UserID = mainWindow.GetUserId(); order.Show(); }
private void Button_Click(object sender, RoutedEventArgs e) { CartAddWindow cartAdd = new CartAddWindow(); cartAdd.Name.Content += (Items.SelectedItem as Product).Name; cartAdd.Price.Content += (Items.SelectedItem as Product).Price; cartAdd.Id = mainWindow.GetUserId(); try { cartAdd.Show(); } catch (Exception error) { MessageBox.Show("Выбирете продукт"); } }