Changeset 395d6d3 for src/mvc/event.cpp

Timestamp:

01/19/10 20:44:23 (12 years ago)

Author:

pavelpa <pavelpa@…>

Branches:

master, qt5

Children:

9208bdb

Parents:

c53a3f4

Message:

event-dialog - displayed persons/presenters names

• implemented Event::persons() method to get persons names associated with the given event ID

File:

• src/mvc/event.cpp (modified) (2 diffs)

src/mvc/event.cpp

@@ -73 +73 @@
 {
     QSqlQuery query;
+    // TODO: conference ID isn't used here
     query.prepare("SELECT name FROM room WHERE id = (SELECT xid_room FROM event_room WHERE xid_event = :id)");
     query.bindValue(":id", id());
@@ -84 +85 @@
 }
 
+QStringList Event::persons() const
+{
+    QSqlQuery query;
+    // TODO: conference ID isn't used here
+    query.prepare("SELECT person.name FROM person INNER JOIN event_person ON person.id = event_person.xid_person AND event_person.xid_event = :id");
+    query.bindValue(":id", id());
+    query.exec();
+    // TODO: handle qeury error
+    //qDebug() << query.lastError();
+
+    QStringList persons;
+    while(query.next())
+        persons.append(query.record().value("name").toString());
+
+    return persons;
+}
+
 void Event::setRoom(const QString &room)
 {
+    Q_UNUSED(room);
+
     qWarning("WARINING: setRoom() is NOT IMPLEMENTED YET");
     // TODO: implement
 }
 
+void Event::setPersons(const QStringList &persons)
+{
+    Q_UNUSED(persons);
+
+    qWarning("WARINING: setPersons() is NOT IMPLEMENTED YET");
+    // TODO: implement
+}
+