private void button_Click(object sender, RoutedEventArgs e)
        {
            if (tbCategory.Text != " ")
            {
                using (ShopAutoEntities db1 = new ShopAutoEntities())
                {
                    try
                    {
                        ProductCategorry ProCa = (new ProductCategorry()
                        {
                            CategoryExtra = tbCategory.Text
                        });
                        db1.ProductCategorry.Add(ProCa);
                        db1.SaveChanges();
                        ShowCategory();
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.ToString());
                    }
                }

                tbCategory.Text = " ";
            }
        }
        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            if (DataGridCategory.SelectedItem != null)
            {
                ProductCategorry CategoreProd = DataGridCategory.SelectedItem as ProductCategorry;


                // Используем LINQ to Entities для обновления базы данных
                ShopAutoEntities db = new ShopAutoEntities();

                ProductCategorry pro = db.ProductCategorry
                                       .Where(p => p.Id == CategoreProd.Id)
                                       .Single <ProductCategorry>();
                //обновление
                db.ProductCategorry.Remove(pro);
                db.SaveChanges();
                ShowCategory();
            }
        }