Module.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 "Module.h"

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

int Module::uniqueNameSQL = 0;
int Module::uniqueNomenclatureSQL = 0;

int Module::errorSQL = 0;

void Module::PrepareSQL(sql * dbConn)
{
        if (dbConn != 0)
        {
                insertSQL = dbConn->prepare("basic.module_insert",5,*dbConn->useModuleConn());
                updateSQL = dbConn->prepare("basic.module_update",6,*dbConn->useModuleConn());
                deleteSQL = dbConn->prepare("basic.module_delete",1,*dbConn->useModuleConn());
                
                uniqueNameSQL         = dbConn->prepare("basic.is_module_name_unique"
                                                       ,2
                                                       ,*dbConn->useModuleConn());
                uniqueNomenclatureSQL = dbConn->prepare("basic.is_module_nomenclature_unique"
                                                       ,2
                                                       ,*dbConn->useModuleConn());
                
                errorSQL = dbConn->prepare("basic.module_error",1,*dbConn->useModuleConn());
        }
}

Module::Module()
:DataClass()
{
        name          = "";
        nomenclature  = "";
        duration      = 0;
        weeklyPeriods = 0;
        semester      = 0;
        p_rtti = MODULE_CLASS;
}

Module::Module(int pID
                                  ,Programme * pParent
                                  ,QString pName
                                  ,QString pNomenclature
                                  ,int pDuration
                                  ,int pWeeklyPeriods
                                  ,short pSemester)
:DataClass(pID)
{
        name          = pName;
        nomenclature  = pNomenclature;
        duration      = pDuration;
        weeklyPeriods = pWeeklyPeriods;
        semester      = pSemester;
        parent        = pParent;
        p_rtti        = MODULE_CLASS;
}

void Module::bindValues(int preparedSQL, int start)
{
        sql::Instance()->bind(start,name,preparedSQL);
        sql::Instance()->bind(++start,nomenclature);
        sql::Instance()->bind(++start,getProgID());
        sql::Instance()->bind(++start,duration);
        sql::Instance()->bind(++start,weeklyPeriods);
}

bool Module::uniqueName(QString name, int parentID)
{
        sql::Instance()->bind(0,name,uniqueNameSQL);
        sql::Instance()->bind(1,parentID);
        return unique(uniqueNameSQL);
}

bool Module::uniqueNomenclature(QString nomenclature, int parentID)
{
        sql::Instance()->bind(0,nomenclature,uniqueNomenclatureSQL);
        sql::Instance()->bind(1,parentID);
        return unique(uniqueNomenclatureSQL);
}

---