X-Git-Url: https://git.toastfreeware.priv.at/toast/confclerk.git/blobdiff_plain/07ae23af712746b964906f0f1e785bdb13201399..0bb39f584c6cf15956ec3f92d1d39bd4fd4fd80a:/src/mvc/conference.cpp

diff --git a/src/mvc/conference.cpp b/src/mvc/conference.cpp
index c2d7d90..17c4a90 100644
--- a/src/mvc/conference.cpp
+++ b/src/mvc/conference.cpp
@@ -10,7 +10,8 @@ QSqlRecord const Conference::sColumns = Conference::toRecord(QList<QSqlField>()
     << QSqlField("end", QVariant::DateTime)
     << QSqlField("days", QVariant::Int)
     << QSqlField("day_change", QVariant::Int)
-    << QSqlField("timeslot_duration", QVariant::Int));
+    << QSqlField("timeslot_duration", QVariant::Int)
+    << QSqlField("active", QVariant::Bool));
 
 QString const Conference::sTableName = QString("conference");
 
@@ -29,3 +30,18 @@ QList<Conference> Conference::getAll()
     return load(query);
 }
 
+int Conference::activeConference()
+{
+    QSqlQuery query("SELECT id FROM conference WHERE active = 1");
+    query.exec();
+
+    QList<int> activeConfs;
+    while(query.next())
+        activeConfs.append(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];
+}
+