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("Зміни успішно збережено");
}
