public void InsertProductInventory(ProductModel product, InventoryModel inventory)
{
try
{
_sql.StartTransaction("TulipData");
int newProductId = _sql.CreateProductTransaction("dbo.spProduct_Insert", product);
inventory.ProductId = newProductId;
_sql.SaveDataInTransaction("dbo.spInventory_Insert", inventory);
_sql.CommitTransaction();
}
catch
{
_sql.RollbackTransaction();
throw;
}
}
public void InsertProductInventory(ProductModel product, InventoryModel inventory)
{
//using (SqlDataAccess sql = new SqlDataAccess())
//{
try
{
_sqlDataAccess.StartTransaction("TulipData");
int newProductId = _sqlDataAccess.CreateProductTransaction("dbo.spProduct_Insert", product);
inventory.ProductId = newProductId;
_sqlDataAccess.SaveDataInTransaction("dbo.spInventory_Insert", inventory);
_sqlDataAccess.CommitTransaction();
}
catch
{
_sqlDataAccess.RollbackTransaction();
throw;
}
//}
}