-
Notifications
You must be signed in to change notification settings - Fork 0
/
ticket.cpp
52 lines (49 loc) · 1.69 KB
/
ticket.cpp
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
#include "ticket.h"
#include <QObject>
#include <QSql>
#include <QSqlQuery>
#include <QSqlError>
#include <QSqlDatabase>
#include <QDebug>
#include <QMessageBox>
ticket::ticket(QObject* parent):QObject(parent) {
ticket_id = 0;
set_details();
}
ticket::ticket(int t, QObject* parent) : QObject(parent), ticket_id(t)
{
set_details();
}
void ticket::set_details() {
QSqlQuery query;
QString cmd = "SELECT passenger,train_number,Class,Source,Destination,Seat,date,train_name FROM `train_schema`.`tickets` WHERE `idticket` = :tickid;";
query.prepare(cmd);
query.bindValue(":tickid", this->ticket_id);
if(query.exec()) {
if(query.next() != NULL) {
this->passenger = query.value(0).toString();
qInfo()<<this->passenger;
this->train_number = query.value(1).toInt();
qInfo()<<this->train_number;
this->Class = query.value(2).toString();
qInfo()<<this->Class;
this->Source = query.value(3).toString();
qInfo()<<this->Source;
this->Destination = query.value(4).toString();
this->Seat = query.value(5).toInt();
qInfo()<<this->Seat;
this->date = query.value(6).toString();
this->train_name = query.value(7).toString();
}
else {
qInfo() << query.executedQuery();
QMessageBox wrong_ticket_id;
wrong_ticket_id.setWindowTitle("wrong id");
wrong_ticket_id.setWindowTitle("PLEASE CHECK THE TICKET NUMBER YOU HAVE ENTERED!!!");
wrong_ticket_id.open();
}
}
else {
qInfo() << "Query failed";
}
}