2 * Copyright (C) 2010 Ixonos Plc.
4 * This file is part of ConfClerk.
6 * ConfClerk is free software: you can redistribute it and/or modify it
7 * under the terms of the GNU General Public License as published by the Free
8 * Software Foundation, either version 2 of the License, or (at your option)
11 * ConfClerk is distributed in the hope that it will be useful, but
12 * WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
13 * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
16 * You should have received a copy of the GNU General Public License along with
17 * ConfClerk. If not, see <http://www.gnu.org/licenses/>.
24 #include <QStringList>
26 #include <ormrecord.h>
28 class Conference : public OrmRecord<Conference>
31 static QSqlRecord const sColumns;
32 static QString const sTableName;
35 static Conference getById(int id);
36 static QList<Conference> getAll();
37 static int activeConference();
38 static void deleteConference(int id);
41 int id() const { return value("id").toInt(); }
42 QString title() const { return value("title").toString(); }
43 QString subtitle() const { return value("subtitle").toString(); }
44 QString venue() const { return value("venue").toString(); }
45 QString city() const { return value("city").toString(); }
46 QDate start() const { return value("start").toDate(); }
47 QDate end() const { return value("end").toDate(); }
48 int days() const { return value("days").toInt(); }
49 int dayChange() const { return value("day_change").toInt(); } // in seconds from 00:00
50 int timeslotDuration() const { return value("timeslot_duration").toInt(); } // in seconds
51 bool isActive() const { return value("active").toBool(); }
52 QString url() const { return stringFromNullable(value("url")); }
53 QString map() const { return stringFromNullable(value("map")); }
56 void setId(int id) { setValue("id", id); }
57 void setTitle(const QString& title) { setValue("title", title); }
58 void setSubtitle(const QString& subtitle) { setValue("subtitle", subtitle); }
59 void setVenue(const QString& venue) { setValue("venue", venue); }
60 void setCity(const QString& city) { setValue("city", city); }
61 void setStart(const QDate& start) { setValue("start", start); }
62 void setEnd(const QDate& end) { setValue("end", end); }
63 void setDays(int days) { setValue("days", days); }
64 void setDayChange(int dayChange) { setValue("day_change", dayChange); }
65 void setTimeslotDuration(int timeslotDuration) { setValue("timeslot_duration", timeslotDuration); }
66 void setActive(bool active) { setValue("active", (int)((active))); }
68 void setUrl(const QString& url)
70 setValue("url", url.isNull() ? QVariant() : url);
75 static QString stringFromNullable(const QVariant& v)
85 #endif /* CONFERENCE_H */