SQL/Windows/CostWindow.xaml.cs

using Microsoft.Win32;
using mysql_connector2.res;
using MySqlConnector;
using System;
using System.Collections.Generic;
using System.ComponentModel;
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 Dapper;

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

            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 CostWindow(Product costWindow)
            {
                InitializeComponent();
                DataContext = this;
                currentProduct = costWindow;
                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 static class DBDataProvider
            {
                public static string connectionString = "Server=kolei.ru; User ID=akapralov; Password=300806; Database=akapralov";
            }
            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 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 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;
                }
            }
        }
    }