public function excluirAcao(Acao $acao) { try { $this->getDb()->beginTransaction(); $sql = 'DELETE FROM acao_tipo_usuario_vin WHERE fk_acao=:fk_acao'; $prepare = $this->getDb()->prepare($sql); $prepare->bindParam(':fk_acao', $acao->get_pk_acao(), PDO::PARAM_INT); $prepare->execute(); $sql = 'DELETE FROM acao WHERE pk_acao=:pk_acao'; $prepare = $this->getDb()->prepare($sql); $prepare->bindParam(':pk_acao', $acao->get_pk_acao(), PDO::PARAM_INT); $prepare->execute(); $this->getDb()->commit(); } catch (Exception $e) { $this->getDb()->rollBack(); throw new Exception($e->getMessage()); } }