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