private static void TestMethod1(OnlineStoreRepository repository) { int newId = repository.AddProduct("Суперчасы", (decimal)45245.212); Console.WriteLine($"New product with id = {newId} added"); int productCount = repository.GetProductCount(); Console.WriteLine($"Number of products: {productCount}"); var products = repository.GetProductList(); foreach (string s in products) { Console.WriteLine(s); } int orderCount = repository.GetOrdersCount(); var orders = repository.GetOrderList(); foreach (string s in orders) { Console.WriteLine(s); } }
private static void TestAddOrders(OnlineStoreRepository repository) { int customerId = 5; DateTimeOffset orderDate = DateTimeOffset.Now; float discount = 0; List <Tuple <int, int> > productIdCountList = new List <Tuple <int, int> > { new Tuple <int, int>(1, 1), new Tuple <int, int>(3, 2), new Tuple <int, int>(2, 4), new Tuple <int, int>(4, 2), }; repository.AddOrder(customerId, orderDate, discount, productIdCountList); }
static void Main(string[] args) { const string connectionStringTemplate = "Data Source={0};" + "Initial Catalog={1};" + "Integrated Security=true"; string connectionString = string.Format( connectionStringTemplate, @"localhost\SQLEXPRESS", "OnlineStore"); var repository = new OnlineStoreRepository(connectionString); //TestMethod1(repository); TestAddOrders(repository); }