private void AddWater_Click(object sender, RoutedEventArgs e) { if (SqlDB.Command("Update Dayily_Stats set water += 100;")) { ; } }
private void Button_Click(object sender, RoutedEventArgs e) { if (RegexAdmin(LoginBox.Text)) { AdminWindow admin = new AdminWindow(); admin.Show(); Close(); } else if (RegexLogin(LoginBox.Text)) { DataTable find = SqlDB.Select($"select * from [Users] where login='******'"); if (find.Rows.Count > 0) { SqlDB.GetUserId(LoginBox.Text); MainWindow mw = new MainWindow(); mw.Show(); Close(); MessageBox.Show("Пользователь авторизовался"); } else { SqlDB.Command($"insert into [Users] values ('{LoginBox.Text}')"); MainWindow mw = new MainWindow(); find = SqlDB.Select($"select * from [Users] where login='******'"); SqlDB.GetUserId(LoginBox.Text); mw.Show(); Close(); } } else { MessageBox.Show("Введите E-mail"); } }
private void Delete_Click(object sender, RoutedEventArgs e) { if (SqlDB.Command($"delete from Ingredients where [name] = '{Content.Text}'")) { SetIngredients(); } }
private void Confirm_Click(object sender, RoutedEventArgs e) { if (SqlDB.Command($"insert into Categories values ('{Content.Text}')")) { SetIngredients(); } }
private void AddInStatistics_Click(object sender, RoutedEventArgs e) { Dish dish = (Dish)Ingredients.SelectedItem; if (SqlDB.Command($"insert into Users_Dishes values ({SqlDB.UserID}, {dish.ID}, (SELECT getdate()))")) { ; } }
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 Confirm_Click(object sender, RoutedEventArgs e) { double weight = Convert.ToDouble(Weight.Text); double proteins = Convert.ToDouble(Proteins.Text); double fats = Convert.ToDouble(Fats.Text); double carbohydrates = Convert.ToDouble(Carbohydrates.Text); if (SqlDB.Command($"insert into Ingredients values ('{Content.Text}', {weight}, {CaloriesCalculate(proteins, fats, carbohydrates)}, {proteins}, {fats}, {carbohydrates})")) { SetIngredients(); } }
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("Введите все значения"); } }