TimeSlot.cpp

/***************************************************************************
 *   Copyright (C) 2006 by Graeme Foster                                   *
 *   email    foster.graeme@gmail.com                                      *
 *                                                                         *
 *   This program is free software; you can redistribute it and/or modify  *
 *   it under the terms of the GNU General Public License as published by  *
 *   the Free Software Foundation; either version 2 of the License, or     *
 *   (at your option) any later version.                                   *
 *                                                                         *
 *   This program is distributed in the hope that it will be useful,       *
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of        *
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the         *
 *   GNU General Public License for more details.                          *
 *                                                                         *
 *   You should have received a copy of the GNU General Public License     *
 *   along with this program; if not, write to the                         *
 *   Free Software Foundation, Inc.,                                       *
 *   59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.             *
 ***************************************************************************/

#include "TimeSlot.h"

int TimeSlot::insertSQL = 0;
int TimeSlot::updateSQL = 0;
int TimeSlot::deleteSQL = 0;

int TimeSlot::errorSQL = 0;

void TimeSlot::PrepareSQL(sql * dbConn)
{
        if (dbConn != 0)
        {
                insertSQL = dbConn->prepare("basic.timeslot_insert",4,*dbConn->useModuleConn());
                deleteSQL = dbConn->prepare("basic.timeslot_delete",3,*dbConn->useModuleConn());
                
                errorSQL = dbConn->prepare("basic.timeslot_error",1,*dbConn->useModuleConn());
        }
}

TimeSlot::TimeSlot()
:DataClass()
{
        parent = 0;
        day = Invalid;
        duration =0;
        startTime = QTime();
        p_rtti = TIMESLOT_CLASS;
}

TimeSlot::TimeSlot(int onDB
                       ,Institute * inst
                       ,days theDay
                       ,int duration
                       ,QTime startTime)
:DataClass(onDB)
{
        parent = inst;
//      instObj = inst;
        day = theDay;
        this->duration = duration;
        this->startTime = startTime;
        p_rtti = TIMESLOT_CLASS;
}

void TimeSlot::bindValues(int preparedSQL, int start)
{
        sql::Instance()->bind(start,day,preparedSQL);
        sql::Instance()->bind(++start,startTime.toString("h:mm"));
        sql::Instance()->bind(++start,duration);
        sql::Instance()->bind(++start,getInstitute()->getID());
}

int TimeSlot::remove(int deleteSQL, int errorSQL)
{
        sql::Instance()->bind(0,day,deleteSQL);
        sql::Instance()->bind(1,startTime.toString("h:mm"));
        sql::Instance()->bind(2,getInstitute()->getID());
        try
        {
                sql::Instance()->query();
                id = sql::Instance()->getFirst(0).toInt();
                return id;
        }
        catch (sqlE &e)
        {
                return -1;
        }
}

QString TimeSlot::getDOW()const
{
        switch (day)
        {
                case Invalid:
                        return "Invalid";
                case Monday:
                        return "Monday";
                case Tuesday:
                        return "Tuesday";
                case Wednesday:
                        return "Wednesday";
                case Thursday:
                        return "Thursday";
                case Friday:
                        return "Friday";
                case Saturday:
                        return "Saturday";
                case Sunday:
                        return "Sunday";
        }
        return "Invalid";
}

TimeSlot::days TimeSlot::getDays(QString DOW)
{
        if (DOW == "Monday")
                return  Monday;
        if (DOW == "Tuesday")
                return Tuesday;
        if (DOW == "Wednesday")
                return Wednesday;
        if (DOW == "Thursday")
                return Thursday;
        if (DOW == "Friday")
                return Friday;
        if (DOW == "Saturday")
                return Saturday;
        if (DOW == "Sunday")
                return Sunday;
        return Invalid;
}

QString TimeSlot::getTimeRange()
{
        QTime finishTime = startTime.addSecs(duration*60);
        return startTime.toString("H:mm") + " - " + finishTime.toString("H:mm");
}

QString TimeSlot::getSortValue()
{
        return QString::number(getInstitute()->getID())
               + "~" 
               + QString::number(day) 
               + "~" 
               + startTime.toString("hh:mm");
}

---