public function salvar(Ministerio $obj)
{
$idAreaMinisterial = "(NULL)";
if ($obj->getObjAreaMinisterial()->getId() > 0) {
$idAreaMinisterial = $obj->getObjAreaMinisterial()->getId();
}
$strSQL = "INSERT INTO ADM_MIN_MINISTERIOS (";
$strSQL .= "MIN_Descricao, ";
$strSQL .= "MIN_Observacao, ";
$strSQL .= "MIN_DataHoraCadastro, ";
$strSQL .= "MIN_EnderecoCep, ";
$strSQL .= "MIN_EnderecoLogradouro, ";
$strSQL .= "MIN_EnderecoNumero, ";
$strSQL .= "MIN_EnderecoComplemento, ";
$strSQL .= "MIN_EnderecoPontoReferencia, ";
$strSQL .= "MIN_EnderecoBairro, ";
$strSQL .= "MIN_EnderecoCidade, ";
$strSQL .= "MIN_EnderecoUf, ";
$strSQL .= "MIN_Status, ";
$strSQL .= "AMI_ID ";
$strSQL .= ")VALUES(";
$strSQL .= "'" . $obj->getDescricao() . "', ";
$strSQL .= "'" . $obj->getObservacao() . "', ";
$strSQL .= "'" . $obj->getDataHoraCadastro() . "', ";
$strSQL .= "'" . $obj->getEndereco()->getCep() . "', ";
$strSQL .= "'" . $obj->getEndereco()->getLogradouro() . "', ";
$strSQL .= "'" . $obj->getEndereco()->getNumero() . "', ";
$strSQL .= "'" . $obj->getEndereco()->getComplemento() . "', ";
$strSQL .= "'" . $obj->getEndereco()->getPontoReferencia() . "', ";
$strSQL .= "'" . $obj->getEndereco()->getBairro() . "', ";
$strSQL .= "'" . $obj->getEndereco()->getCidade() . "', ";
$strSQL .= "'" . $obj->getEndereco()->getUf() . "', ";
$strSQL .= "'" . $obj->getStatus() . "', ";
$strSQL .= " " . $idAreaMinisterial . " ";
$strSQL .= ")";
if (Db::getInstance()->executar($strSQL)) {
$arrObjReunioes = $obj->getReunioes();
$intID = Db::getInstance()->getLastId();
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 .= $intID . ", ";
$strSQL .= $arrObjReunioes[$intI]->getDiaSemana()->getId() . ", ";
$strSQL .= "'" . $arrObjReunioes[$intI]->getHorario() . "' ";
$strSQL .= ")";
Db::getInstance()->executar($strSQL);
}
return true;
}
}
