projectdatabase.h

#ifndef PROJECTDATABASE_H
#define PROJECTDATABASE_H
#include "database/database.h"

#include "exceptions/dbexception.h"

#include "models/project.h"

#include "utils/string.h"
#include "utils/log.h"
#include "gui/widgets/widgetsmodels/projectstablemodel.h"

using namespace Utils;
using namespace Exceptions;
using namespace Gui::Widgets;

namespace Databases {

class ProjectDatabase : public Database
{

public:
    static ProjectDatabase*  instance() throw (DbException*);

    Models::Project* getProject(const int pId);

    Models::Project* getProject(QSqlQuery& q);

    int addProject(const Models::Project&);

    void updateProject(const Models::Project&);

    void removeProject(const int pId);

    int getNbProjects();

    int getNbProjects(const int customerId);

    QMap<int, Models::Project> getProjectsOfCustomer(
            QSharedPointer<Models::Customer> c, const bool projectLocked=true);

    QList<Models::Project> getProjects(const int customerId);

    WdgModels::ProjectsTableModel* getProjectsTable(const int pId)
        throw(DbException*);

    QSharedPointer<Project> updateProject(QSqlQuery &q);

    QList<Project*> getAllProjects();

    double getCostProjects(QList<Project*> projects);

private:
    static ProjectDatabase* _instance;

    ProjectDatabase() throw (DbException*);

};
}
#endif // PROJECTDATABASE_H