public function delete($id) { $pdo = PDOBuilder::getPdo(); $newTransaction = !$pdo->inTransaction(); if ($newTransaction) { $pdo->beginTransaction(); } // Delete rules $stmt = $pdo->prepare("DELETE FROM PAYMENTMODES_RETURNS " . "WHERE PAYMENTMODE_ID = :id;"); $stmt->bindValue(":id", $id); if ($stmt->execute() === false) { if ($newTransaction) { $pdo->rollback(); } return false; } // Delete values $stmtVal = $pdo->prepare("DELETE FROM PAYMENTMODES_VALUES " . "WHERE PAYMENTMODE_ID = :id;"); $stmtVal->bindValue(":id", $id); if ($stmtVal->execute() === false) { if ($newTransaction) { $pdo->rollback(); } return false; } // Delete mode $del = parent::delete($id); if ($del === false) { if ($newTransaction) { $pdo->rollback(); } return false; } else { if ($newTransaction) { $pdo->commit(); } return $del; } }
public function delete($areaId) { $pdo = PDOBuilder::getPDO(); $del = $pdo->prepare("DELETE FROM TARIFFAREAS_PROD " . "WHERE TARIFFID = :id"); $del->bindParam(":id", $areaId); $del->execute(); return parent::delete($areaId); }