FinalProject/dialogaddclients.cpp at master · DmitriiKJ/FinalProject · 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
#include "dialogaddclients.h"
#include "ui_dialogaddclients.h"

DialogAddClients::DialogAddClients(QSqlDatabase &db, QWidget *parent) :
    QDialog(parent),
    ui(new Ui::DialogAddClients)
{
    ui->setupUi(this);
    query = new QSqlQuery(db);
}

DialogAddClients::~DialogAddClients()
{
    delete ui;
    delete query;
}

void DialogAddClients::on_pushButto_add_clicked()
{
    QString first = ui->lineEdit_first->text();
    QString middle = ui->lineEdit_middle->text();
    QString last = ui->lineEdit_last->text();
    QString number = ui->lineEdit_number->text();
    QString address = ui->lineEdit_address->text();

    query->prepare("EXEC addClient :f, :m, :l, :n, :a");
    query->bindValue(":f", first);
    query->bindValue(":m", middle);
    query->bindValue(":l", last);
    query->bindValue(":n", number);
    query->bindValue(":a", address);

    if (query->exec()) {
        qDebug() << "Клиент успешно добавлен.";
    }

    ui->lineEdit_first->setText("");
    ui->lineEdit_middle->setText("");
    ui->lineEdit_last->setText("");
    ui->lineEdit_number->setText("");
    ui->lineEdit_address->setText("");
    this->close();
}