-
Notifications
You must be signed in to change notification settings - Fork 0
/
Employee.cpp
144 lines (117 loc) · 3.53 KB
/
Employee.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
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
137
138
139
140
141
#include "Employee.h"
Employee::Employee(int i, string first, string last, int a, int g, double h)
:Worker(i, first, last, a)
{
setGrade(g);
setHours(h);
}
void Employee::setGrade(int g){
switch(g){
case 1:
position = "Manager", tax = .15, pay_rate = 400;
break;
case 2:
position = "Team Leader", tax = .1, pay_rate = 250;
break;
case 3:
position = "Team Member", tax = .05, pay_rate = 150;
}
}
string Employee::getPosition()const{
return position;
}
double Employee::getTax()const{
return tax;
}
double Employee::getPayRate()const{
return pay_rate;
}
void Employee::setHours(double h){
hours = (h > 0 && h <= 160) ? h : 0;
}
double Employee::getHours()const{
return hours;
}
void Employee::setSalary(){
double gross_salary = ((this->getHours())*(this->getPayRate()));
this->salary = gross_salary - ((this->getTax())*gross_salary);
}
double Employee::getSalary()const{
return this->salary;
}
void Employee::createTable(sqlite3 *db, char *err, string table_name){
sqlite3_open("com.db", &db);
string s = "create table " + table_name + " (id int unique, FirstName varchar(20), LastName varchar(20), Age int, position varchar(20), hours double, salary double)";
sqlite3_exec(db, s.c_str(), NULL, 0, &err);
sqlite3_close(db);
}
string Employee::modifyAdd(string table_name){
//insert into employee values(id, fn, ln, pos, hour, sala)
string c = "," , c1 = "'";
string s = "insert into " + table_name + " values ("+ c1 + to_string(this->getId()) + c1 + c + c1 + this->getFirstName() + c1 + c +
c1 + this->getLastName()+ c1 + c + c1 + to_string(this->getAge())+ c1 + c + c1 + this->getPosition() + c1 + c + c1 + to_string(this->getHours())+ c1 + c
+ c1 + to_string(this->getSalary()) + c1 + ")";
return s;
}
void Employee::add(sqlite3 *db, string table_name, char *err){
sqlite3_open("com.db", &db);
int id = message("Please Enter thee id");
string first, last;
int g, a;
double h;
cout << "Please Enter first name, last name, age and the hours worked" << endl;
cin >> first >> last >> a >> h;
cout << "Please Enter your position" << endl
<< "1.Manager" << endl
<< "2.Team Leader" << endl
<< "3.Team Member" << endl;
cin >> g;
setId(id);
setFirstName(first);
setLastName(last);
setAge(a);
setGrade(g);
setHours(h);
setSalary();
string s = modifyAdd(table_name);
sqlite3_exec(db, s.c_str(), NULL, 0, &err);
if(err){
cerr << "#id " << id << " is already exist" << endl;
err = NULL;
exit(1);
}
sqlite3_close(db);
}
string Employee::modifyEdit(string table_name){
string c = ",";
string s = "update " + table_name + " set FirstName = "+ this->getFirstName() + c + " LastName = " + this->getLastName() + c + " Age = " + to_string(this->getAge()) + c + " position = "
+ this->getPosition() + c + " hours = " + to_string(this->getHours()) + c + " salary = " + to_string(this->getSalary());
return s;
}
void Employee::edit(sqlite3 *db, string table_name, char *err){
int id = message("Please Enter the id to update the data");
sqlite3_open("com.db", &db);
string first, last;
int g,a;
double h;
cout << "Please Enter the new data : first name, last name, age and the hours worked" << endl;
cin >> first >> last >> a >> h;
cout << "Please Enter your new position" << endl
<< "1.Manager" << endl
<< "2.Team Leader" << endl
<< "3.Team Member" << endl;
cin >> g;
setId(id);
setFirstName(first);
setLastName(last);
setGrade(g);
setHours(h);
setSalary();
string s = modifyEdit(table_name);
if(err){
cerr << "#id " << id << " is not exist" << endl;
err = NULL;
exit(1);
}
sqlite3_close(db);
}