public function modificarGestion(GestionDto $gestionDto, PDO $cnn, $idGestion)
{
try {
$query = $cnn->prepare("CALL modificarGestion (?,?,?,?,?,?,?,?,?,?)");
$query->bindParam(1, $gestionDto->getIdUsuario());
$query->bindParam(2, $gestionDto->getIdCliente());
$query->bindParam(3, $gestionDto->getEstado());
$query->bindParam(4, $gestionDto->getTemaProducto());
$query->bindParam(5, $gestionDto->getAsistentes());
$query->bindParam(6, $gestionDto->getObservaciones());
$query->bindParam(7, $gestionDto->getLugar());
$query->bindParam(8, $gestionDto->getFechaVisita());
$query->bindParam(9, $gestionDto->getTipoVisita());
$query->bindParam(10, $idGestion);
$query->execute();
$this->mensaje = "Registro Actualizado";
} catch (Exception $ex) {
$this->mensaje = $ex->getMessage();
}
$cnn = null;
return $this->mensaje;
}
public function modificarGestion(GestionDto $gestionDto, PDO $cnn, $idGestion)
{
try {
$query = $cnn->prepare("UPDATE Gestiones SET IdUsuario=1022,IdEmpresa=?,Estado=?,Asunto=?,Asistentes=?,Observaciones=?,Lugar=?,FechaProgramada=?,Tipo=? where IdGestion=?");
//$query->bindParam(1, $gestionDto->getIdUsuario());
$query->bindParam(1, $gestionDto->getIdCliente());
$query->bindParam(2, $gestionDto->getEstado());
$query->bindParam(3, $gestionDto->getTemaProducto());
$query->bindParam(4, $gestionDto->getAsistentes());
$query->bindParam(5, $gestionDto->getObservaciones());
$query->bindParam(6, $gestionDto->getLugar());
$query->bindParam(7, $gestionDto->getFechaVisita());
$query->bindParam(8, $gestionDto->getTipoVisita());
$query->bindParam(9, $idGestion);
$query->execute();
$this->mensaje = "Registro Actualizado";
} catch (Exception $ex) {
$this->mensaje = $ex->getMessage();
}
$cnn = null;
return $this->mensaje;
}
