Faculty.h

/***************************************************************************
 *   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.             *
 ***************************************************************************/

#ifndef __FACULTY_H
#define __FACULTY_H

#include "DataClass.h"
#include "Institute.h"

class Faculty : public DataClass
{
private:
        QString name;
        QString abbrev;
        
protected: // Properties
        friend class FacItem;
        static int selectSQL;
        static int insertSQL;
        static int updateSQL;
        static int deleteSQL;
        static int uniqueNameSQL;
        static int uniqueAbbrevSQL;
        static int errorSQL;

public: // Constructor
        Faculty();
        Faculty(int pID, QString name, QString abbrev, Institute * parent);
        static void PrepareSQL(sql * dbConn);
        
        // Get Methods
        inline QString getDescription()const{return getName();}
        inline QString getName()const{return name;}
        inline QString getAbbrev()const{return abbrev;}
        inline Institute * getInstitute()const {return static_cast<Institute *>(parent);}
        inline QString getInstName()const;
        inline int getInstID(){return getParentID();}
        // Set Methods
        inline bool setName(QString pName){name = pName; return true;}
        inline bool setAbbrev(QString pAbbrev){abbrev = pAbbrev; return true;}
        // Methods to determine if a field is unique
        static bool uniqueName(QString name, int id);
        static bool uniqueAbbrev(QString abbrev, int id);
protected:
        void bindValues(int preparedSQL, int start);
};

inline QString Faculty::getInstName()const
{
        if (parent!= 0)
                return getInstitute()->getName();
        else
                return QString();
}

#endif

---