public int AddProduct(ProductRestricted product) //процедуры { using var connection = GetOpenedSqlConnection(); var command = connection.CreateCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "dbo.AddProduct"; command.Parameters.AddWithValue("@name", product.Name); command.Parameters.AddWithValue("@price", product.Price); int result = (int)(decimal)command.ExecuteScalar(); return(result); }
static void Main(string[] args) { var connectionStringBuilder = new SqlConnectionStringBuilder() { DataSource = @"WIN-HNJP61VLN18\SQLEXPRESS", InitialCatalog = "OnlineStore", IntegratedSecurity = true }; var repo = new OnlineStoreRepository(connectionStringBuilder.ConnectionString); int productCount = repo.GetProductCount(); Console.WriteLine($"Number of products = {productCount}"); var products = repo.GetProductList(); foreach (var product in products) { Console.WriteLine(product.ToString()); } int orderCount = repo.GetOrderCount(); Console.WriteLine($"Order counts = {productCount}"); var orderDiscounts = repo.GetOrderDiscountList(); foreach (var orderDiscount in orderDiscounts) { Console.WriteLine(orderDiscount.ToString()); } int newOrderId = repo.AddOrder(4, DateTimeOffset.Now, null, new List <Tuple <int, int> > { new Tuple <int, int> (20, 1), new Tuple <int, int> (7, 4), }); Console.WriteLine($"New order added with ID = {newOrderId}"); /*---------------------------------------------------------------------------------------*/ var newProduct = new ProductRestricted("Новые часы Apple IWatch", 9999.99m); int newProductId = repo.AddProduct(newProduct); Console.WriteLine($"New product added with ID = {newProductId}"); }