public Product GetProductById(int productId)
{
OrdersManagementDataSet.ProductsRow productRow = repository.Products.FindByProductId(productId);
if (productRow == null)
{
return(null);
}
return(TranslateFromProductsRowToProductEntity(productRow));
}
public void ShouldGetProductBySku()
{
OrdersManagementDataSet _dataset = new OrdersManagementDataSet();
ProductService _service = new ProductService(_dataset);
OrdersManagementDataSet.ProductsRow _product = _dataset.Products.AddProductsRow("Product A", "1234-56789", "Description of Product A", 1.00m);
_dataset.Products.AddProductsRow("Product B", "2222-33333", "Description of Product B", 1.00m);
Product _foundProduct = _service.GetProductBySku("1234-56789");
Assert.AreEqual(_product.ProductId, _foundProduct.ProductId);
}
private static Product TranslateFromProductsRowToProductEntity(OrdersManagementDataSet.ProductsRow productsRow)
{
Product product = new Product();
product.ProductId = productsRow.ProductId;
product.ProductSku = productsRow.ProductSKU;
product.ProductName = productsRow.ProductName;
product.Description = productsRow.Description;
product.UnitPrice = productsRow.UnitPrice;
return(product);
}
public void GetProductBySkuWithQuotesSearchesCorrectlyAndPreventsInjection()
{
OrdersManagementDataSet _dataset = new OrdersManagementDataSet();
ProductService _service = new ProductService(_dataset);
OrdersManagementDataSet.ProductsRow _product = _dataset.Products.AddProductsRow("Product A", "1234-56'89", "Description of Product A", 1.00m);
_dataset.Products.AddProductsRow("Product B", "2222-33333", "Description of Product B", 1.00m);
Product _foundProduct = _service.GetProductBySku("1234-56'89");
Assert.AreEqual(_product.ProductId, _foundProduct.ProductId);
}
