jeux.2d/client.cpp at master · ghazi2278/jeux.2d · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
#include "client.h"
#include <QDebug>
#include "connexion.h"

client::client()
{


}
client::client(QString id,QString nom,QString prenom,QString adresse,QString tel,QString email)
{
  this->id=id;
  this->nom=nom;
  this->prenom=prenom;
  this->adresse=adresse;
  this->tel=tel;
  this->email=email;


}
QString client::get_id(){return  id;}
QString client::get_nom(){return nom;}
QString client::get_prenom(){return prenom;}
QString client::get_adresse(){return  adresse;}
QString client::get_tel(){return tel;}
QString client::get_email(){return email;}

void client::setid(QString id){ this->id=id;}
void client::setnom(QString nom){ this->nom=nom;}
void client::setprenom(QString prenom){ this->prenom=prenom;}
void client::setadresse(QString adresse){ this->prenom=adresse;}
void client::settel(QString tel){ this->tel=tel;}
void client::setemail(QString email){ this->email=email;}

bool client::ajouter()
{
QSqlQuery query;

query.prepare("INSERT INTO client (ID, NOM, PRENOM, ADRESSE, TEL, EMAIL) "
                    "VALUES (:id, :nom, :prenom, :adresse, :tel, :email)");
query.bindValue(":id", id);
query.bindValue(":nom", nom);
query.bindValue(":prenom", prenom);
query.bindValue(":adresse", adresse);
query.bindValue(":tel", tel);
query.bindValue(":email", email);

return    query.exec();
}


QSqlQueryModel * client::afficher()
{QSqlQueryModel * model= new QSqlQueryModel();
model->setQuery("select * from client");
model->setHeaderData(0, Qt::Horizontal, QObject::tr("id"));
model->setHeaderData(1, Qt::Horizontal, QObject::tr("nom"));
model->setHeaderData(2, Qt::Horizontal, QObject::tr("prenom"));
model->setHeaderData(3, Qt::Horizontal, QObject::tr("adresse"));
model->setHeaderData(4, Qt::Horizontal, QObject::tr("tel"));
model->setHeaderData(5, Qt::Horizontal, QObject::tr("email"));

    return model;
}


bool client::supprimer(QString id)
{
QSqlQuery query;

query.prepare("Delete from client where id = :id");
query.bindValue(":id", id);
return    query.exec();
}


bool client::modifier(QString id,QString nom ,QString prenom ,QString adresse ,QString tel ,QString email)
{
    QSqlQuery query;
    query.prepare("UPDATE client SET id:=id, nom:=nom, prenom:=prenom, adresse:=adresse, tel:=tel, email:=email");
    query.bindValue(":id",id);
    query.bindValue(":nom",nom);
    query.bindValue(":prenom",prenom);
    query.bindValue(":adresse",adresse);
    query.bindValue(":tel",tel);
    query.bindValue(":email",email);
    return query.exec();
    }

QSqlQueryModel *client::rechercher(QString rech)
{
    QSqlQueryModel * model= new QSqlQueryModel();
    model->setQuery("select * from client where nom LIKE '"+rech+"%' or prenom LIKE '"+rech+"%'");
    return model;
}

QSqlQueryModel * client::tri()
{
    QSqlQueryModel * model= new QSqlQueryModel();

    model->setQuery("select * from client ORDER BY nom ");
    model->setHeaderData(0, Qt::Horizontal, QObject::tr("id"));
    model->setHeaderData(1, Qt::Horizontal, QObject::tr("nom"));
    model->setHeaderData(2, Qt::Horizontal, QObject::tr("prenom"));
    model->setHeaderData(3, Qt::Horizontal, QObject::tr("adresse"));
    model->setHeaderData(4, Qt::Horizontal, QObject::tr("tel"));
    model->setHeaderData(5, Qt::Horizontal, QObject::tr("email"));


        return model;
}