contributorydatabase.h

#ifndef CONTRIBUTORYDATABASE_H
#define CONTRIBUTORYDATABASE_H

#include "database.h"
#include "database/projectdatabase.h"

#include "models/contributory.h"
#include "models/contributorieslist.h"

#include "utils/log.h"
#include "utils/string.h"

using namespace Exceptions;
using namespace Utils;

namespace Databases {

class ContributoryDatabase : public Database
{
public:
    static ContributoryDatabase* instance()throw(DbException*);

    Models::Contributory *getContributory(const int idContributory);

    Models::ContributoriesList getContributoriesByBilling(const int billingId);

    int addContributory(const Models::Contributory&);

    void updateContributory(const Models::Contributory&);

    void removeContributory(const int pId);

    Models::Contributory *getContributory(QSqlQuery &q);

    Models::ContributoriesList getContributoriesByBillingAndProject(
            const int billingId, const int projectId);


private:
    static ContributoryDatabase* _instance;

    ContributoryDatabase() throw(DbException*) ;

};
}
#endif // CONTRIBUTORYDATABASE_H