private void EditBuilder(int idPart, string nameCategory, string manufdcturer, string model, int count, int price) { WH part = adoDB.WHs.Where(p => p.ID_Pard == idPart).First(); part.Manufacturer = manufdcturer; part.Model = model; part.Count = count; part.Price = price; part.Categories.Add(adoDB.Categories.Where(c => c.NameCategory == nameCategory).First()); adoDB.Entry(part).State = EntityState.Modified; Dispatcher.Invoke(() => adoDB.SaveChanges()); }
protected void Delete() { try { selectItem = MainGrid.SelectedItem as AllResullt; if (selectItem != null && selectItem.CategoryName != null) { WH delPart = adoDB.WHs.Where(o => o.Model == selectItem.Model).First(); Category delcat = adoDB.Categories.Where(c => c.NameCategory == selectItem.CategoryName).First(); delcat.WHs.Remove(delPart); adoDB.Entry(delcat).State = EntityState.Modified; adoDB.WHs.Remove(delPart); adoDB.SaveChanges(); Connect(); } } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message); } }