private void Confirm_Click(object sender, RoutedEventArgs e)
{
string category = Categories.SelectedItem.ToString();
int category_id = SqlDB.GetId($"select id from Categories where [name]='{category}'");
if (SqlDB.Command($"insert into Dishes values ({category_id}, '{Content.Text}', {0}, {0}, {0}, {0})"))
{
SetDishes();
}
}
private void Delete_Click(object sender, RoutedEventArgs e)
{
string ingredient = Ingredients.SelectedItem.ToString();
string dish = Dishes.SelectedItem.ToString();
int ingredient_id = SqlDB.GetId($"select id from Ingredients where [name]='{ingredient}'");
int dish_id = SqlDB.GetId($"select id from Dishes where [name]='{dish}'");
if (SqlDB.Command($"delete from Dishes_Ingredients where id_ingredient = {ingredient_id} and id_dish = {dish_id}"))
{
SetDishes();
}
}
private void Confirm_Click(object sender, RoutedEventArgs e)
{
string ingredient = Ingredients.SelectedItem.ToString();
string dish = Dishes.SelectedItem.ToString();
int ingredient_id = SqlDB.GetId($"select id from Ingredients where [name]='{ingredient}'");
int dish_id = SqlDB.GetId($"select id from Dishes where [name]='{dish}'");
if (SqlDB.Command($"insert into Dishes_Ingredients values ({ingredient_id}, {dish_id})"))
{
SetDishes();
}
}
private void Update_Click(object sender, RoutedEventArgs e)
{
int status_id = SqlDB.GetId($"select * from Statuses where name='{Status.SelectedItem}'");
if (status_id > 0 && Weight.Text.Length > 0 && Age.Text.Length > 0 && Height.Text.Length > 0)
{
if (SqlDB.Command($"update Users_Setting set status_id={status_id}, weight={Weight.Text}, height={Height.Text}, age={Age.Text}"))
{
MessageBox.Show("Параметры обновлены");
}
}
else
{
MessageBox.Show("Введите все значения");
}
}
