public void Buy(User user, Product product)
{
double price = product.GetDiscountPrice(user);
user.ReduceBalance(price);
Console.WriteLine("user " + user.Name + " bought " + product.Name + " price " + price + " hryvnia");
}
public void Buy(User user, Product product)
{
pr.connectionProp.Open();
double price = product.GetDiscountPrice(user);
user.ReduceBalance(price);
Console.WriteLine($"{user.Name} купил {product.Name} за {price}.Заказ отправлен на склад");
string sql1 = string.Format($"Insert into ShopUsersOrder (UserOrderId,OrderDate,Goods)" +
$" values ({user.Id}, GETDATE(),'{product.Name}');");
using (SqlCommand cmd = new SqlCommand(sql1, pr.connectionProp))
{
cmd.ExecuteNonQuery();
}
string sql2 = string.Format($"update ShopUsers set UserBalance = {user.Balance}, UserSpent = {user.Spent} where UserName = '******';");
using (SqlCommand cmd = new SqlCommand(sql2, pr.connectionProp))
{
cmd.ExecuteNonQuery();
}
pr.connectionProp.Close();
}
