customerdatabase.h

#ifndef BDDCUSTOMER_H
#define BDDCUSTOMER_H

#include <QPixmap>
#include <QBuffer>
#include "database/database.h"
#include "database/billingdatabase.h"
#include "exceptions/dbexception.h"
#include "models/customer.h"
#include "models/billing.h"
#include "utils/log.h"
#include "utils/string.h"
#include "gui/utils/image.h"
#include "gui/widgets/widgetsmodels/customerstablemodel.h"

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

namespace Databases {
class CustomerDatabase : public Database
{

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

    WdgModels::CustomersTableModel* getCustomersTable(QString filter="")
        throw(DbException*);


    QStandardItemModel *getTree(QString filter="") throw(DbException*);

    QSharedPointer<Models::Customer> getCustomer(const int pId);

    int addCustomer(const Models::Customer &);

    void updateCustomer(Customer &);

    void removeCustomer(const int pId);

    int getNbCustomers();

    QStandardItem *getItemRoot();

    QStandardItem *getItemCustomer(QSqlQuery q1);
    QStandardItem *getItemProject(QSqlQuery q2);

    QSharedPointer<Models::Customer> getCustomer(QSqlQuery &q);

    void updateCustomer(QSqlQuery &q, Customer &pCustomer);

    QPixmap getCustomerImage(const int pId);

    void setCustomerImage(Customer &pCustomer);

    QList<Customer> getCustomers();

private:
    static CustomerDatabase* _instance;

    CustomerDatabase() throw(DbException*) ;
};
}
#endif // BDDCUSTOMER_H