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