/**
* Deletes an associated StewardshipPost
* @param StewardshipPost $objStewardshipPost
* @return void
*/
public function DeleteAssociatedStewardshipPost(StewardshipPost $objStewardshipPost)
{
if (is_null($this->intId)) {
throw new QUndefinedPrimaryKeyException('Unable to call UnassociateStewardshipPost on this unsaved StewardshipBatch.');
}
if (is_null($objStewardshipPost->Id)) {
throw new QUndefinedPrimaryKeyException('Unable to call UnassociateStewardshipPost on this StewardshipBatch with an unsaved StewardshipPost.');
}
// Get the Database Object for this Class
$objDatabase = StewardshipBatch::GetDatabase();
// Perform the SQL Query
$objDatabase->NonQuery('
DELETE FROM
`stewardship_post`
WHERE
`id` = ' . $objDatabase->SqlVariable($objStewardshipPost->Id) . ' AND
`stewardship_batch_id` = ' . $objDatabase->SqlVariable($this->intId) . '
');
// Journaling
if ($objDatabase->JournalingDatabase) {
$objStewardshipPost->Journal('DELETE');
}
}
