public static void AddNewProduct(SqlConnection connection)
{
Product product = new Product();
Console.WriteLine("Please, enter the product details: ");
Console.Write("Name: ");
product.Name = Console.ReadLine();
Console.Write("UnitMeasure: ");
product.UnitMeasure = Console.ReadLine();
Console.Write("UnitPrice: ");
product.UnitPrice = ConsoleInput.InputDouble();
Console.Write("Quantity: ");
product.Quantity = ConsoleInput.InputInt();
ProductQuery productQuery = new ProductQuery(connection);
int result = productQuery.AddNewRecord(product);
Console.WriteLine($"Affected rows: {result}");
}
