}
$businessEntityBase = new BaseBusinessEntity();
$sqlCommand = "BEGIN INSERT INTO [dbo].[BusinessEntity]\n ([Name]\n ,[BusinessEntityCode]\n ,[BusinessEntityDescription]\n ,[BusinessEntityParentId]\n ,[BusinessLevelId]\n ,[Active]\n ,[BusinessEntityShortName])\n VALUES\n ( '{$_POST['Name']}'\n ,'{$_POST['BranchCode']}'\n ,''\n ,{$_POST['Division']}\n ,3\n ,{$active} ,'') END";
$result = sqlsrv_query(Database::getConnection(), $sqlCommand);
if ($result) {
$sqlIdentity = "select @@identity as EntityId";
$resultIdentity = sqlsrv_query(Database::getConnection(), $sqlIdentity);
$rowIdentity = sqlsrv_fetch_array($resultIdentity);
$entityId = $rowIdentity["EntityId"];
} else {
echo printf('An error was received when the function sqlsrv_query was called.
The error message was: %s', dbGetErrorMsg());
die;
}
// Create a Branch record (add the entity id from above
$record = PopulateRecord($_POST, $recordTemplate);
$record['BusinessEntityId']['Value'] = $entityId;
$validateErrors = ValidateRecord($record);
if ($validateErrors) {
foreach ($validateErrors as $error) {
echo "<div class='error'><h3>{$error}</h3></div><br>";
}
die;
}
$updateErrors = $recordBase->insert($record);
if ($updateErrors) {
foreach ($updateErrors as $error) {
echo "<div class='error'><h3>{$error}</h3></div><br>";
}
die;
}
$sqlCommand = "BEGIN INSERT INTO [dbo].[BusinessEntity]\n ([Name]\n ,[BusinessEntityCode]\n ,[BusinessEntityDescription]\n ,[BusinessEntityParentId]\n ,[BusinessLevelId]\n ,[Active]\n ,[BusinessEntityShortName])\n VALUES\n ( '{$_POST['Name']}'\n ,'{$_POST['CompanyCode']}'\n ,''\n ,null\n ,1\n ,{$active} ,\n '{$_POST['ShortName']}') END";
$companyBase->dbTransactionBegin();
$result = sqlsrv_query(Database::getConnection(), $sqlCommand);
if ($result) {
$sqlIdentity = "select @@identity as EntityId";
$resultIdentity = sqlsrv_query(Database::getConnection(), $sqlIdentity);
$rowIdentity = sqlsrv_fetch_array($resultIdentity);
$entityId = $rowIdentity["EntityId"];
} else {
$companyBase->dbTransactionRollback();
echo printf('An error was received when the function sqlsrv_query was called.
The error message was: %s', dbGetErrorMsg());
die;
}
// Create the Company
$record = PopulateRecord($_POST, $companyTemplate);
$record['BusinessEntityId']['Value'] = $entityId;
$validateErrors = ValidateRecord($record);
$insertErrors = $companyBase->insert($record);
if ($validateErrors) {
foreach ($validateErrors as $error) {
echo "<div class='error'><h3>{$error}</h3></div><br>";
}
}
if ($insertErrors) {
foreach ($insertErrors as $error) {
echo "<div class='error'><h3>{$error}</h3></div><br>";
}
}
if ($validateErrors || $insertErrors) {
$companyBase->dbTransactionRollback();