private void deleteProduct_Click(object sender, RoutedEventArgs e)
        {
            if (productsDG.Items.Count == 0)
            {
                return;
            }
            MessageBoxResult res = Xceed.Wpf.Toolkit.MessageBox.Show("Are you sure?. Press 'Yes' to Confirm.", "Confirmation", MessageBoxButton.YesNo, MessageBoxImage.Error, MessageBoxResult.No);

            if (res != MessageBoxResult.Yes)
            {
                return;
            }

            try
            {
                if (ProductTableData.deleteProduct(product.ID) == true)
                {
                    Xceed.Wpf.Toolkit.MessageBox.Show("Product deleted form database");
                    productType.ItemsSource    = ProductTableData.getAllProductTypes();
                    productModel.SelectedIndex = -1;
                    productType.SelectedIndex  = -1;
                }
            }
            catch (Exception ex)
            {
                Xceed.Wpf.Toolkit.MessageBox.Show(ex.Message);
            }
        }