Changeset d97bcab in confclerk_git for src/mvc

Timestamp:

04/15/10 14:49:59 (13 years ago)

Author:

kirilma <kirilma@…>

Branches:

master, qt5

Children:

04acaf9

Parents:

f5b68a4

Message:

implement deleting a conference

pass event about it to mainwindow to update select control
fix Conference::activeConference() to work when first conference is removed

Location:

src/mvc

Files:

• conference.cpp (modified) (2 diffs)
• conference.h (modified) (1 diff)

src/mvc/conference.cpp

@@ -18 +18 @@
  */
 #include "conference.h"
+#include "../sql/sqlengine.h"
 
 QSqlRecord const Conference::sColumns = Conference::toRecord(QList<QSqlField>()
@@ -52 +53 @@
 int Conference::activeConference()
 {
-    QSqlQuery query("SELECT id FROM conference WHERE active = 1");
-    query.exec();
+    {
+        QSqlQuery query("SELECT id FROM conference WHERE active = 1");
+        query.exec();
 
-    QList<int> activeConfs;
-    while(query.next())
-        activeConfs.append(query.record().value("id").toInt());
+        // TODO: change it so that it will select somw existing ID
 
-    qDebug() << __PRETTY_FUNCTION__
-        << "activeConfs.count()" << activeConfs.count()
-        ;
+        if (query.next()) {
+            return query.record().value("id").toInt();
+        }
+    }
 
-    if(activeConfs.count()==0) // no active DB
-        return 1;
-    else // even if there are more active confs, the first from the list is confidered active
-        return activeConfs[0];
+    QSqlQuery query2("SELECT id FROM conference ORDER BY id");
+    if (query2.next()) {
+        return query2.record().value("id").toInt();
+    }
+
+    return -1;
 }
 
+void Conference::deleteConference(int id)
+{
+    SqlEngine::deleteConference(id);
+}
+

src/mvc/conference.h

@@ -36 +36 @@
     static QList<Conference> getAll();
     static int activeConference();
+    static void deleteConference(int id);
 
 public: