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);
}
