private void AddOrderBtn_Click(object sender, RoutedEventArgs e) { DateTime date = DateTime.Now.ToLocalTime(); order_ingredients oItem = new order_ingredients() { order_time = date, execute_time = date.AddDays(2), provider_id = pr_id, status_id = 4 }; db.order_ingredients.Add(oItem); db.SaveChanges(); content_order_ingredients item = new content_order_ingredients() { count = Convert.ToInt32(countTextBox.Text), ingredient_id = ing_id, unit_of_measurement_id = unit_id, price = Convert.ToInt32(priceTextBox.Text), order_ingredients_id = (from m in db.order_ingredients select m.id).ToList().Last() }; db.content_order_ingredients.Add(item); db.SaveChanges(); this.Hide(); }
//orderIngredients update private void updateOrderIngredientsBtn_Click(object sender, RoutedEventArgs e) { OrderIngredientTable item = (ordIngrGrid.SelectedItem as OrderIngredientTable); order_ingredients item1 = _db.order_ingredients.First(c => c.id == item.id); item1.provider_id = _db.providers.First(c => c.name == item.provid_name).id; item1.status_id = _db.statuses.First(c => c.name == item.status).id; item1.order_time = item.d1; item1.execute_time = item.d2; content_order_ingredients item2 = _db.content_order_ingredients.First(c => c.order_ingredients_id == item.id); item2.ingredient_id = _db.ingredients.First(c => c.name == item.ingr_name).id; _db.content_order_ingredients.First(c => c.ingredient_id == item2.ingredient_id).count = item.count; item2.unit_of_measurement_id = _db.units_of_measurement.First(c => c.name == item.units).id; item2.price = item.price; _db.SaveChanges(); ordIngrGrid.ItemsSource = GetOrderIngredients(); MessageBox.Show("Зміни успішно збережено"); }