public ProductsWindow()
        {
            InitializeComponent();
            DB.resetConnString();
            addDatagridColumninStockHistory();

            Search_Product SP = new Search_Product();

            SP.addDatagridColumninSalesHistory(salesHistoryDG, true); //show unit price

            productType.AddHandler(System.Windows.Controls.Primitives.TextBoxBase.TextChangedEvent,
                                   new TextChangedEventHandler(ProductType_ComboBox_TextChanged));
            productModel.AddHandler(System.Windows.Controls.Primitives.TextBoxBase.TextChangedEvent, new TextChangedEventHandler(ProductModel_ComboBox_TextChanged));

            productType.ItemsSource = ProductTableData.getAllProductTypes();
        }
        private void searchProduct_Click(object sender, RoutedEventArgs e)
        {
            Search_Product ss = new Search_Product();

            ss.ShowDialog();
        }