public bool AddProduct (string productName, int?supplierID, int?categoryID, string quantityPerUnit, decimal?unitPrice, short?unitsInStock, short?unitsOnOrder, short?reorderLevel, bool discontinued) { // Create a new ProductRow instance NorthwindWithSprocs.ProductsDataTable products = new NorthwindWithSprocs.ProductsDataTable(); NorthwindWithSprocs.ProductsRow product = products.NewProductsRow(); product.ProductName = productName; if (supplierID == null) { product.SetSupplierIDNull(); } else { product.SupplierID = supplierID.Value; } if (categoryID == null) { product.SetCategoryIDNull(); } else { product.CategoryID = categoryID.Value; } if (quantityPerUnit == null) { product.SetQuantityPerUnitNull(); } else { product.QuantityPerUnit = quantityPerUnit; } if (unitPrice == null) { product.SetUnitPriceNull(); } else { product.UnitPrice = unitPrice.Value; } if (unitsInStock == null) { product.SetUnitsInStockNull(); } else { product.UnitsInStock = unitsInStock.Value; } if (unitsOnOrder == null) { product.SetUnitsOnOrderNull(); } else { product.UnitsOnOrder = unitsOnOrder.Value; } if (reorderLevel == null) { product.SetReorderLevelNull(); } else { product.ReorderLevel = reorderLevel.Value; } product.Discontinued = discontinued; // Add the new product products.AddProductsRow(product); int rowsAffected = Adapter.Update(products); // Return true if precisely one row was inserted, otherwise false return(rowsAffected == 1); }
public bool UpdateProduct (string productName, int?supplierID, int?categoryID, string quantityPerUnit, decimal?unitPrice, short?unitsInStock, short?unitsOnOrder, short?reorderLevel, bool discontinued, int productID) { NorthwindWithSprocs.ProductsDataTable products = Adapter.GetProductByProductID(productID); if (products.Count == 0) { // no matching record found, return false return(false); } NorthwindWithSprocs.ProductsRow product = products[0]; product.ProductName = productName; if (supplierID == null) { product.SetSupplierIDNull(); } else { product.SupplierID = supplierID.Value; } if (categoryID == null) { product.SetCategoryIDNull(); } else { product.CategoryID = categoryID.Value; } if (quantityPerUnit == null) { product.SetQuantityPerUnitNull(); } else { product.QuantityPerUnit = quantityPerUnit; } if (unitPrice == null) { product.SetUnitPriceNull(); } else { product.UnitPrice = unitPrice.Value; } if (unitsInStock == null) { product.SetUnitsInStockNull(); } else { product.UnitsInStock = unitsInStock.Value; } if (unitsOnOrder == null) { product.SetUnitsOnOrderNull(); } else { product.UnitsOnOrder = unitsOnOrder.Value; } if (reorderLevel == null) { product.SetReorderLevelNull(); } else { product.ReorderLevel = reorderLevel.Value; } product.Discontinued = discontinued; // Update the product record int rowsAffected = Adapter.Update(product); // Return true if precisely one row was updated, otherwise false return(rowsAffected == 1); }