2/Windows/EditProductWindow.xaml.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Shapes;
using sql_pagining.models;
using Dapper;
using MySqlConnector;
using System.ComponentModel;
using Microsoft.Win32;

namespace sql_pagining.Windows
{
    public partial class EditProductWindow : Window, INotifyPropertyChanged
    {
        public event PropertyChangedEventHandler PropertyChanged;
        private void Invalidate(string name = "currentProduct")
        {
            if (PropertyChanged != null)
                PropertyChanged(this, new PropertyChangedEventArgs(name));
        }

        public Visibility DeleteProductVisibly
        {
            get
            {
                if (currentProduct != null)
                {
                    return currentProduct.ID == 0 ? Visibility.Collapsed : Visibility.Visible;
                }
                else
                {
                    return Visibility.Collapsed;
                }
            }
        }

        public Product currentProduct { get; set; }
        public List<ProductType> productTypeList { get; set; }
        public int selectedProductIndex { get; set; } = -1;

        public void saveProduct(Product product)
        {
            using (MySqlConnection db = new MySqlConnection(connectionString))
            {
                if (product.ID == 0)
                {
                    using (MySqlCommand cmd = new MySqlCommand("INSERT INTO Product (ProductTypeID, Title, ArticleNumber, Description, Image, ProductionPersonCount, ProductionWorkshopNumber, MinCostForAgent) " +
                        "VALUES (@ProductTypeID, @Title, @ArticleNumber, @Description, @Image, @ProductionPersonCount, @ProductionWorkshopNumber, @MinCostForAgent)", db))
                    {
                        cmd.Parameters.AddWithValue("@ProductTypeID", product.ProductTypeID);
                        cmd.Parameters.AddWithValue("@Title", product.Title);
                        cmd.Parameters.AddWithValue("@ArticleNumber", product.ArticleNumber);
                        cmd.Parameters.AddWithValue("@Description", product.Description);
                        cmd.Parameters.AddWithValue("@Image", product.Image);
                        cmd.Parameters.AddWithValue("@ProductionPersonCount", product.ProductionPersonCount);
                        cmd.Parameters.AddWithValue("@ProductionWorkshopNumber", product.ProductionWorkshopNumber);
                        cmd.Parameters.AddWithValue("@MinCostForAgent", product.MinCostForAgent);

                        db.Open();
                        cmd.ExecuteNonQuery();
                        product.ID = (int)cmd.LastInsertedId;
                        db.Close();
                    }
                }
                else
                {
                    db.Execute("UPDATE Product SET Title=@Title, ProductTypeID=@ProductTypeID, " +
                        "ArticleNumber=@ArticleNumber, Description=@Description, " +
                        "Image=@Image, ProductionPersonCount=@ProductionPersonCount, " +
                        "ProductionWorkshopNumber=@ProductionWorkshopNumber, " +
                        "MinCostForAgent=@MinCostForAgent " +
                        "WHERE ID=@ID", product);
                }
            }
        }
        public EditProductWindow(Product editProduct)
        {
            InitializeComponent();
            DataContext = this;
            currentProduct = editProduct;
            if (currentProduct != null)
            {
                root.Title = currentProduct.ID == 0 ? "Новый продукт" : "Редактирование продукта";
                productTypeList = Globals.dataProvider.getProductTypes().ToList();
                if (currentProduct.ID > 0)
                {
                    selectedProductIndex = productTypeList.FindIndex(pt => pt.ID == currentProduct.ProductTypeID);
                }
            }
            else
            {
                MessageBox.Show("Продукт не был передан.");
            }
        }

        public EditProductWindow(ProductMaterial selectedMaterial)
        {
            this.selectedMaterial = selectedMaterial;
        }

        public static class DBDataProvider
        {
            public static string connectionString = "Server=kolei.ru; User ID=kaliev; Password=070806; Database=kaliev";
        }
        public IEnumerable<ProductMaterial> productMaterialList
        {
            get
            {
                return Globals.dataProvider.getProductMaterials(currentProduct.ID);
            }
        }

        private void ChangeImage_Click(object sender, RoutedEventArgs e)
        {
            OpenFileDialog GetImageDialog = new OpenFileDialog();


            GetImageDialog.Filter = "Файлы изображений: (*.png, *.jpg)|*.png;*.jpg";


            GetImageDialog.InitialDirectory = Environment.CurrentDirectory;
            if (GetImageDialog.ShowDialog() == true)
            {

                currentProduct.Image = GetImageDialog.FileName.Substring(Environment.CurrentDirectory.Length);


                Invalidate();
            }
        }
        private string connectionString;
        private ProductMaterial selectedMaterial;

        private void SaveButton_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                if (ProductTypeComboBox.SelectedItem != null)
                {
                    currentProduct.ProductTypeID = ((ProductType)ProductTypeComboBox.SelectedItem).ID;
                }
                else
                {
                    throw new Exception("Не выбран тип продукта");
                }

                if (!ValidatePrice(currentProduct.Price))
                {
                    throw new Exception("Некорректная стоимость продукта. Допустимо не более двух знаков после запятой и положительное число.");
                }

                if (!ValidateArticle(currentProduct.ArticleNumber, currentProduct.ID))
                {
                    throw new Exception("Артикул уже существует.");
                }

                Globals.dataProvider.saveProduct(currentProduct);
                DialogResult = true;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private bool ValidatePrice(decimal price)
        {
            return price >= 0 && Math.Round(price, 2) == price;
        }

        private bool ValidateArticle(string article, int productId)
        {
            return Globals.dataProvider.GetProductByArticle(article)?.ID != productId;
        }

        private void ProductListView_MouseDoubleClick(object sender, MouseButtonEventArgs e)
        {
            var product = (sender as ListBox).SelectedItem as Product;

            var newEditWindow = new EditProductWindow(product);
            if ((bool)newEditWindow.ShowDialog())
            {
                Invalidate();
            }
        }
        private void AddMaterialButton_Click(object sender, RoutedEventArgs e)
        {
            var newProductMaterial = new ProductMaterial
            {
                ProductID = currentProduct.ID,
                MaterialID = 0,
                Count = 0
            };
            var addMaterialWindow = new AddMaterial(newProductMaterial);

            if (addMaterialWindow.ShowDialog() == true)
            {
                Invalidate("productMaterialList");
            }
        }
        private void DeleteMaterialTextBlock_MouseDown(object sender, MouseButtonEventArgs e)
        {

            var productMaterial = (sender as TextBlock).Tag as ProductMaterial;
            if (productMaterial != null)
            {

                Globals.dataProvider.deleteProductMaterial(productMaterial);
                Invalidate("productMaterialList");
                var textBlock = sender as TextBlock;
                if (textBlock != null)
                {
                    textBlock.Visibility = Visibility.Collapsed;
                }
            }
        }

        private void DeleteProductButton_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                var saleCount = Globals.dataProvider.saleCount(currentProduct.ID);
                if (saleCount > 0)
                {
                    throw new Exception("Нельзя удалять продукт с продажами.");
                }

                Globals.dataProvider.removeProductMaterial(currentProduct.ID);

                Globals.dataProvider.removePriceHistory(currentProduct.ID);

                Globals.dataProvider.removeProduct(currentProduct.ID);
                DialogResult = true;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        private void ProductTypeComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            if (ProductTypeComboBox.SelectedItem != null)
            {
                currentProduct.ProductTypeID = ((ProductType)ProductTypeComboBox.SelectedItem).ID;
            }
        }
        private void ListView_MouseDoubleClick(object sender, MouseButtonEventArgs e)
        {
            var listView = sender as ListView;
            var selectedMaterial = listView.SelectedItem as ProductMaterial;

            if (selectedMaterial != null)
            {
                var editMaterialWindow = new EditProductWindow(selectedMaterial);

                if (editMaterialWindow.ShowDialog() == true)
                {
                    Invalidate("productMaterialList");
                }

            }

        }
        private void SearchTextBox_TextChanged(object sender, TextChangedEventArgs e)
        {
            var searchText = SearchTextBox.Text.ToLower();

            var filteredMaterials = productMaterialList.Where(pm =>
                pm.MaterialTitle.ToLower().Contains(searchText)
            ).ToList();

            ProductMaterialsListView.ItemsSource = filteredMaterials;
        }
    }
}