public async Task OneOrder_ReturnOneRow() { CategoriesTemplate category = await TestRunner.InsertTemplateAsync(new CategoriesTemplate() .WithCategoryName("Category1")); ProductsTemplate product = await TestRunner.InsertTemplateAsync(new ProductsTemplate() .WithProductName("Product1") .WithCategoryID(category.Identity)); await TestRunner.InsertTemplateAsync(new OrdersTemplate() .WithOrderID(1001) .WithOrderDate(DateTime.Parse("05-Mar-1998"))); await TestRunner.InsertTemplateAsync(new Order_DetailsTemplate() .WithOrderID(1001) .WithProductID(product.Identity) .WithUnitPrice(10) .WithQuantity(5) .WithDiscount(0)); QueryResult data = await TestRunner.ExecuteStoredProcedureQueryAsync("dbo.[SalesByCategory]", new SqlQueryParameter("CategoryName", "Category1"), new SqlQueryParameter("OrdYear", "1998") ); data .AssertRowCount(1) .AssertRowValues(0, new DataSetRow { { "ProductName", "Product1" }, { "TotalPurchase", 50m } }); }
public async Task OneOrderForDifferentYear_NoRows() { CategoriesTemplate category = await TestRunner.InsertTemplateAsync(new CategoriesTemplate() .WithCategoryName("Category1")); ProductsTemplate product = await TestRunner.InsertTemplateAsync(new ProductsTemplate() .WithProductName("Product1") .WithCategoryID(category.Identity)); await TestRunner.InsertTemplateAsync(new OrdersTemplate() .WithOrderID(1001) .WithOrderDate(DateTime.Parse("05-Mar-1997"))); await TestRunner.InsertTemplateAsync(new Order_DetailsTemplate() .WithOrderID(1001) .WithProductID(product.Identity) .WithUnitPrice(10) .WithQuantity(5) .WithDiscount(0)); QueryResult data = await TestRunner.ExecuteStoredProcedureQueryAsync("dbo.[SalesByCategory]", new SqlQueryParameter("CategoryName", "Category2"), new SqlQueryParameter("OrdYear", "1998") ); data .AssertRowCount(0); }
public async Task OneOrderFor1998Year_ValidValue(int year, int expectedTotal) { CategoriesTemplate category = await TestRunner.InsertTemplateAsync(new CategoriesTemplate() .WithCategoryName("Category1")); ProductsTemplate product = await TestRunner.InsertTemplateAsync(new ProductsTemplate() .WithProductName("Product1") .WithCategoryID(category.Identity)); await TestRunner.InsertTemplateAsync(new OrdersTemplate() .WithOrderID(1001) .WithOrderDate(DateTime.Parse($"05-Mar-1996"))); await TestRunner.InsertTemplateAsync(new OrdersTemplate() .WithOrderID(1002) .WithOrderDate(DateTime.Parse($"05-Mar-1997"))); await TestRunner.InsertTemplateAsync(new OrdersTemplate() .WithOrderID(1003) .WithOrderDate(DateTime.Parse($"05-Mar-1998"))); await TestRunner.InsertTemplateAsync(new Order_DetailsTemplate() .WithOrderID(1001) .WithProductID(product.Identity) .WithUnitPrice(10) .WithQuantity(10) .WithDiscount(0)); await TestRunner.InsertTemplateAsync(new Order_DetailsTemplate() .WithOrderID(1002) .WithProductID(product.Identity) .WithUnitPrice(10) .WithQuantity(5) .WithDiscount(0)); await TestRunner.InsertTemplateAsync(new Order_DetailsTemplate() .WithOrderID(1003) .WithProductID(product.Identity) .WithUnitPrice(10) .WithQuantity(8) .WithDiscount(0)); QueryResult data = await TestRunner.ExecuteStoredProcedureQueryAsync("dbo.[SalesByCategory]", new SqlQueryParameter("CategoryName", "Category1"), new SqlQueryParameter("OrdYear", year) ); data .AssertRowCount(1) .AssertValue(0, "TotalPurchase", Convert.ToDecimal(expectedTotal)); }