public function alterar(Ministerio $obj)
{
$idAreaMinisterial = "(NULL)";
if ($obj->getObjAreaMinisterial()->getId() > 0) {
$idAreaMinisterial = $obj->getObjAreaMinisterial()->getId();
}
$strSQL = "UPDATE ADM_MIN_MINISTERIOS SET ";
$strSQL .= "MIN_Descricao = '" . $obj->getDescricao() . "', ";
$strSQL .= "MIN_Observacao = '" . $obj->getObservacao() . "', ";
$strSQL .= "MIN_EnderecoCep = '" . $obj->getEndereco()->getCep() . "', ";
$strSQL .= "MIN_EnderecoLogradouro = '" . $obj->getEndereco()->getLogradouro() . "', ";
$strSQL .= "MIN_EnderecoNumero = '" . $obj->getEndereco()->getNumero() . "', ";
$strSQL .= "MIN_EnderecoComplemento = '" . $obj->getEndereco()->getComplemento() . "', ";
$strSQL .= "MIN_EnderecoPontoReferencia = '" . $obj->getEndereco()->getPontoReferencia() . "', ";
$strSQL .= "MIN_EnderecoBairro = '" . $obj->getEndereco()->getBairro() . "', ";
$strSQL .= "MIN_EnderecoCidade = '" . $obj->getEndereco()->getCidade() . "', ";
$strSQL .= "MIN_EnderecoUf = '" . $obj->getEndereco()->getUf() . "', ";
$strSQL .= "MIN_Status = '" . $obj->getStatus() . "', ";
$strSQL .= "AMI_ID = " . $idAreaMinisterial . " ";
$strSQL .= "WHERE MIN_ID = " . $obj->getId();
if (Db::getInstance()->executar($strSQL)) {
$strSQL = "DELETE FROM ADM_MDR_MINISTERIOS_DIAS_REUNIAO WHERE MIN_ID = " . $obj->getId();
if (Db::getInstance()->executar($strSQL)) {
$arrObjReunioes = $obj->getReunioes();
for ($intI = 0; $intI < count($arrObjReunioes); $intI++) {
$strSQL = "INSERT INTO ADM_MDR_MINISTERIOS_DIAS_REUNIAO(";
$strSQL .= "MIN_ID, ";
$strSQL .= "DIA_ID, ";
$strSQL .= "MDR_Horario";
$strSQL .= ")VALUES(";
$strSQL .= $obj->getId() . ", ";
$strSQL .= $arrObjReunioes[$intI]->getDiaSemana()->getId() . ", ";
$strSQL .= "'" . $arrObjReunioes[$intI]->getHorario() . "' ";
$strSQL .= ")";
Db::getInstance()->executar($strSQL);
}
return true;
}
}
}
