public int AddNew(ProductDo product)
{
return(_storedProcWrapper.ExecuteOne <int>(new StoredProcedureParameters()
{
StoredProcName = SpProducts.Name,
Params = new
{
Action = SpProducts.ActionAddNew,
product.ProductName,
product.SupplierID,
product.CategoryID,
product.QuantityPerUnit,
product.UnitPrice,
product.UnitsInStock,
product.UnitsOnOrder,
product.ReorderLevel,
product.Discontinued,
}
}));
}
public void Update(ProductDo product)
{
_storedProcWrapper.ExecuteNonQuery(new StoredProcedureParameters()
{
StoredProcName = SpProducts.Name,
Params = new
{
Action = SpProducts.ActionUpdate,
product.ProductID,
product.ProductName,
product.SupplierID,
product.CategoryID,
product.QuantityPerUnit,
product.UnitPrice,
product.UnitsInStock,
product.UnitsOnOrder,
product.ReorderLevel,
product.Discontinued,
}
});
}
