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