private void Button_Click(object sender, RoutedEventArgs e) { using (var db = new groceryContext()) { db.Dictionary.Remove(Dictionary); db.SaveChanges(); } deleteDictionary?.Invoke(); this.Close(); }
private void Button_Click(object sender, RoutedEventArgs e) { using (var db = new groceryContext()) { db.Provider.Remove(Provider); db.SaveChanges(); } deleteProvider?.Invoke(); this.Close(); }
private void Add_Click(object sender, RoutedEventArgs e) { using (var db = new groceryContext()) { var oldDictionary = db.Dictionary.FirstOrDefault(domain => domain.IdDictionary == Item); oldDictionary.NameDictionary = nameDictioanary.Text; db.SaveChanges(); } this.Close(); }
private void Add_Click(object sender, RoutedEventArgs e) { using (var db = new groceryContext()) { db.Dictionary.Add(new DictionaryDomain { NameDictionary = nameDictioanary.Text }); db.SaveChanges(); } addDictionary?.Invoke(); this.Close(); }
private void Denomintation_LostFocus(object sender, RoutedEventArgs e) { var textBox = (TextBox)sender; var selected = (ProviderModel)database.SelectedItem; using (var db = new groceryContext()) { var provider = db.Provider.FirstOrDefault(domain => selected.IdProvider == domain.IdProvider); switch (textBox.Name) { case "denomintation": provider.DenomintaionProvider = textBox.Text; break; case "name": provider.NameProvider = textBox.Text; break; case "surname": provider.SurnameProvider = textBox.Text; break; case "patronymic": provider.PatronymicProvider = textBox.Text; break; case "phone": provider.PhoneProvider = textBox.Text; break; case "fax": provider.FaxProvider = textBox.Text; break; case "city": provider.CityProvider = textBox.Text; break; } db.SaveChanges(); } }
private void Button_Click(object sender, RoutedEventArgs e) { using (var db = new groceryContext()) { db.Provider.Add(new ProviderDomain { PatronymicProvider = patronymic.Text, DenomintaionProvider = denomintation.Text, CityProvider = city.Text, FaxProvider = fax.Text, NameProvider = name.Text, PhoneProvider = phone.Text, SurnameProvider = surname.Text }); db.SaveChanges(); } addProvider?.Invoke(); this.Close(); }
private void Button_Click(object sender, RoutedEventArgs e) { using (var db = new groceryContext()) { var product = (from DictionaryModel productsSelectedItem in products.SelectedItems select new ProductDomain { IdDictionary = productsSelectedItem.IdDictionary, RestProduct = int.Parse(count.Text), CountProduct = int.Parse(count.Text), ShelfLifeProduct = DateTime.Parse(date.Text), IdDictionaryNavigation = db.Dictionary.FirstOrDefault(domain => domain.IdDictionary == productsSelectedItem.IdDictionary), Price = decimal.Parse(price.Text) }).ToList(); db.Product.AddRange(product); var waybill = new WaybillDomain { IdData = DateTime.Now, IdProvider = int.Parse(providers.SelectedValue.ToString()), IdProviderNavigation = db.Provider.FirstOrDefault(domain => domain.IdProvider == int.Parse(providers.SelectedValue.ToString())), Product = product }; db.Waybill.Add(waybill); foreach (var productDomain in product) { productDomain.IdWaybillNavigation = waybill; } db.SaveChanges(); addWaybill?.Invoke(); this.Close(); } }
private void Button_Click(object sender, RoutedEventArgs e) { using (var db = new groceryContext()) { var sell = new SaleDomain { IdProductNavigation = db.Product.FirstOrDefault(domain => domain.IdProduct == int.Parse(products.SelectedValue.ToString())), IdProduct = int.Parse(products.SelectedValue.ToString()), DataSale = DateTime.Now, CountSale = int.Parse(count.Text) }; var product = db.Product.FirstOrDefault(domain => domain.IdProduct == int.Parse(products.SelectedValue.ToString())); product.RestProduct -= int.Parse(count.Text); db.Sale.Add(sell); db.SaveChanges(); sellProduct?.Invoke(); this.Close(); } }