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(); } }