private static void AddProduct(Product product)
{
string columns = "ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued";
string values = "@productName, @supplierID, @categoryID, @quantityPerUnit, @unitPrice, @unitsInStock, @unitsOnOrder, @reorderLevel, @discontinued";
string commandText = "INSERT INTO Products (" + columns + ") VALUES (" + values + ")";
SqlCommand addProductCommand = new SqlCommand(commandText, dbCon);
addProductCommand.Parameters.AddWithValue("@productName", product.Name);
addProductCommand.Parameters.AddWithValue("@supplierID", product.SupplierID);
addProductCommand.Parameters.AddWithValue("@categoryID", product.CategoryID);
addProductCommand.Parameters.AddWithValue("@quantityPerUnit", product.QuantityPerUnit);
addProductCommand.Parameters.AddWithValue("@unitPrice", product.Price);
addProductCommand.Parameters.AddWithValue("@unitsInStock", product.UnitsInStock);
addProductCommand.Parameters.AddWithValue("@unitsOnOrder", product.UnitsOnOrder);
addProductCommand.Parameters.AddWithValue("@reorderLevel", product.ReorderLevel);
addProductCommand.Parameters.AddWithValue("@discontinued", product.Discontinued);
addProductCommand.ExecuteNonQuery();
}
public static void Main()
{
try
{
ConnectToDB();
Product product = new Product("Smood", 2, 1, "10 - 1l bottles", 20.00m, 100, 0, 10, 0);
try
{
AddProduct(product);
Console.WriteLine("Product {0} added!", product.Name);
}
catch(SqlException e)
{
Console.WriteLine(e.Message);
}
}
finally
{
DisconnectFromDB();
}
}
