public partial class Northwind {
partial void UpdateProduct(Product current) {
Product original = ((Product) (Products.GetOriginalEntityState(current)));

// sputn vloen procedury, aktualizujc hodnotu UnitsInStock 
if (original.UnitsInStock != current.UnitsInStock) {
int rowCount = this.ExecuteCommand(
"exec UpdateProductStock " +
"@id={0}, @originalUnits={1}, @decrement={2}",
original.ProductID,
original.UnitsInStock,
(original.UnitsInStock - current.UnitsInStock));
if (rowCount < 1) {
	throw new ChangeConflictException();
}
}
}
}
