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);
}
