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("Введите все значения"); } }