Campus-In-and-Out/database_handler.cpp at master · ghost1412/Campus-In-and-Out · 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
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
#include "database_handler.h"
#include "account_handler.h"
database_handler::database_handler():vehicleNo("Nan"),vehicle_color("Nan")
{

}
QString database_handler::getName(){
    return name;
}

void database_handler::setName(QString sname){
    name = sname;
}

void database_handler::setVehicleColor(QString scolor){
    vehicle_color = scolor[0];
}

QString database_handler::getVehicleColor(){
    return vehicle_color;
}

void database_handler::setDate(QString sdate){
    date = sdate;
}

QString database_handler::getDate(){
    return date;
}

void database_handler::setNoPeople(int snoPeople){
    noPeople = snoPeople;
}

int database_handler::getNoPeople(){
    return noPeople;
}

void database_handler::setTime(QString stime){
    time = stime;
}

QString database_handler::getTime(){
    return time;
}

int database_handler::getDueVehicle(){
    return dueVehicle;
}

void database_handler::setDueVehicle(int sdue){
    dueVehicle = sdue;
}

int database_handler::getGateNo(){
    return gateNo;
}

void database_handler::setGateNo(int sgateNo){
    gateNo = sgateNo;
}

void database_handler::setIdNo(QString sId){
    idNo = sId;
}

QString database_handler::getIdNo(){
    return idNo;
}

void database_handler::setInside(bool sinside){
    inside = sinside;
}

bool database_handler::getInside(){
    return inside;
}

void database_handler::saveEntries(database_handler database){
    account_handler userdb;
    QSqlQuery qry;
    userdb.isOpen();
    qry.prepare("INSERT INTO persondb (Name, Id, MobileNo, Date, Time, gateNo, purpose, inside, dueVehicle, noPeople, vehicleno, vehiclecolor) VALUES (:Name, :Id, :MobileNo, :Date, :Time, :gateNo, :purpose, :inside, :dueVehicle, :noPeople, :vehicleno, :vehiclecolor)");
    qry.bindValue(":Name", database.getName());
    qry.bindValue(":Id", database.getIdNo());
    qry.bindValue(":MobileNo", database.getMobileNo());
    qry.bindValue(":Date", database.getDate());
    qry.bindValue(":Time", database.getTime());
    qry.bindValue(":gateNo", database.gateNo);
    qry.bindValue(":purpose", database.getPurpose());
    qry.bindValue(":inside", database.getInside());
    qry.bindValue(":dueVehicle", database.getDueVehicle());
    qry.bindValue(":noPeople", database.getNoPeople());
    qry.bindValue(":vehicleno", database.getVehicleNo());
    qry.bindValue(":vehiclecolor", database.getVehicleColor());
    qry.exec();
    userdb.close();
}
void database_handler::deleteEntries(){}
QString database_handler::getPurpose(){
    return purpose;
}

void database_handler::setPurpose(QString sPurpose){
    purpose = sPurpose;
}

bool database_handler::isVehcileReg(QString vehicle_no){
    account_handler userdb;
    QSqlQuery qry;
    userdb.isOpen();
    if(qry.exec("SELECT vehicle_no FROM registeredVehicle where vehicle_no=\'"+ vehicle_no + "\'")){
        if(qry.next())
        {
            return true;
        }else{
            return false;
        }
    }
    userdb.close();
}
void database_handler::setVehicleNo(QString svehicleNo){
    vehicleNo = svehicleNo;
}

QString database_handler::getVehicleNo(){
    return vehicleNo;
}

void database_handler::setMobileNo(int smobileNo){
    mobileNo = smobileNo;
}

int database_handler::getMobileNo(){
    return mobileNo;
}