-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdialogbuy.cpp
More file actions
123 lines (95 loc) · 3.7 KB
/
Copy pathdialogbuy.cpp
File metadata and controls
123 lines (95 loc) · 3.7 KB
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
113
114
115
116
117
118
119
120
121
122
#include "dialogbuy.h"
#include "ui_dialogbuy.h"
DialogBuy::DialogBuy(QSqlDatabase &db, QWidget *parent) :
QDialog(parent),
ui(new Ui::DialogBuy)
{
ui->setupUi(this);
query = new QSqlQuery(db);
addBuy = new DialogAddBuy(db);
ui->tableWidget_buy->setColumnWidth(0, 200);
ui->tableWidget_buy->setColumnWidth(1, 200);
ui->tableWidget_buy->setColumnWidth(2, 200);
}
DialogBuy::~DialogBuy()
{
delete ui;
delete query;
delete addBuy;
}
void DialogBuy::showBuy() const
{
query->exec("SELECT c.First_name + ' ' + c.Middle_name + ' ' + c.Last_name, cr.Model + ' ' + Cast(cr.Year_ as nvarchar(10)), b.Date_buy FROM Buy b JOIN Client c ON c.ID = b.Client_ID JOIN Car cr ON cr.ID = b.Car_ID");
int i = 0;
while(query->next())
{
QString name = query->value(0).toString();
QString model_year = query->value(1).toString();
QDate date = query->value(2).toDate();
ui->tableWidget_buy->setRowCount(i + 1);
QTableWidgetItem* Name = new QTableWidgetItem();
QTableWidgetItem* Model_year = new QTableWidgetItem();
QTableWidgetItem* Date = new QTableWidgetItem();
Name->setText(name);
Model_year->setText(model_year);
Date->setText(date.toString());
ui->tableWidget_buy->setItem(i, 0, Name);
ui->tableWidget_buy->setItem(i, 1, Model_year);
ui->tableWidget_buy->setItem(i, 2, Date);
i++;
}
}
void DialogBuy::on_pushButton_add_clicked()
{
addBuy->show();
this->close();
}
void DialogBuy::on_pushButton_sort_clicked()
{
ui->tableWidget_buy->setRowCount(0);
query->exec("SELECT c.First_name + ' ' + c.Middle_name + ' ' + c.Last_name, cr.Model + ' ' + Cast(cr.Year_ as nvarchar(10)), b.Date_buy FROM Buy b JOIN Client c ON c.ID = b.Client_ID JOIN Car cr ON cr.ID = b.Car_ID ORDER BY b.Date_buy DESC");
int i = 0;
while(query->next())
{
QString name = query->value(0).toString();
QString model_year = query->value(1).toString();
QDate date = query->value(2).toDate();
ui->tableWidget_buy->setRowCount(i + 1);
QTableWidgetItem* Name = new QTableWidgetItem();
QTableWidgetItem* Model_year = new QTableWidgetItem();
QTableWidgetItem* Date = new QTableWidgetItem();
Name->setText(name);
Model_year->setText(model_year);
Date->setText(date.toString());
ui->tableWidget_buy->setItem(i, 0, Name);
ui->tableWidget_buy->setItem(i, 1, Model_year);
ui->tableWidget_buy->setItem(i, 2, Date);
i++;
}
}
void DialogBuy::on_pushButton_search_clicked()
{
ui->tableWidget_buy->setRowCount(0);
QString l = ui->lineEdit_last->text();
query->prepare("SELECT c.First_name + ' ' + c.Middle_name + ' ' + c.Last_name, cr.Model + ' ' + Cast(cr.Year_ as nvarchar(10)), b.Date_buy FROM Buy b JOIN Client c ON c.ID = b.Client_ID JOIN Car cr ON cr.ID = b.Car_ID WHERE UPPER(c.Last_name) like :l");
query->bindValue(":l", "%" + l.toUpper() + "%");
query->exec();
int i = 0;
while(query->next())
{
QString name = query->value(0).toString();
QString model_year = query->value(1).toString();
QDate date = query->value(2).toDate();
ui->tableWidget_buy->setRowCount(i + 1);
QTableWidgetItem* Name = new QTableWidgetItem();
QTableWidgetItem* Model_year = new QTableWidgetItem();
QTableWidgetItem* Date = new QTableWidgetItem();
Name->setText(name);
Model_year->setText(model_year);
Date->setText(date.toString());
ui->tableWidget_buy->setItem(i, 0, Name);
ui->tableWidget_buy->setItem(i, 1, Model_year);
ui->tableWidget_buy->setItem(i, 2, Date);
i++;
}
}