viewvc/H6/DatabaseLayer.cpp

#include "StdAfx.h"
#include ".\databaselayer.h"

DatabaseLayer::DatabaseLayer(void)
{
        Person p1;
        p1.id="0";
        p1.inits="MaPe";
        p1.isadmin = 0;
        p1.name="Mads Pedersen";
        persons.push_back(p1);

        Person p2;
        p2.id="1";
        p2.inits = "thn";
        p2.isadmin = 1;
        p2.name = "Torben Nielsen";
        p2.pass = "thn";
        persons.push_back(p2);

        Person p3;
        p3.id = "2";
        p3.inits = "FiKa";
        p3.isadmin = 0;
        p3.name = "Finn Karlsen";
        persons.push_back(p3);

        Equipment e1;
        e1.barcode = "1234567890123";
        e1.name = "1 ks. øl";
        e1.description = "30 Stk. Hancock Høker";
        e1.placement = "i kælderen";
        e1.status = "Drukket";
        equipments.push_back(e1);

}

vector<Person> DatabaseLayer::GetPersonAll(void)
{
        return persons;
}

Person DatabaseLayer::GetPerson(CString wantInits)
{
        for (int i=0; i<persons.size(); i++) {
                if (persons[i].inits == wantInits)
                        return persons[i];
        }
        Person p;
        return p;
}

Equipment DatabaseLayer::GetEquipment(CString wantBarcode)
{
        for (int i=0; i<equipments.size(); i++) {
                if (equipments[i].barcode == wantBarcode) {
                        return equipments[i];
                }
        }
}

bool DatabaseLayer::UpdatePerson(Person ChangePerson)
{
        for (int i=0; i<persons.size(); i++) {
                if (persons[i].inits == ChangePerson.inits) {
                        persons[i] = ChangePerson;
                        break;
                }
        }

        return true;
}


bool DatabaseLayer::UpdateEquipment(Equipment ChangeEquipment)
{
        for (int i=0; i<equipments.size(); i++) {
                if (equipments[i].barcode == ChangeEquipment.barcode) {
                        equipments[i] = ChangeEquipment;
                        break;
                }
        }

        return true;

}

bool DatabaseLayer::AddPerson(Person NewPerson)
{
        persons.push_back(NewPerson);
        return true;
}


vector<Equipment> DatabaseLayer::GetEquipmentAll()
{
        return equipments;
}

bool DatabaseLayer::AddEquipment(Equipment e)
{
        equipments.push_back(e);
        return true;
}

bool DatabaseLayer::DeletePerson(Person RemovePerson)
{
        //vector kan ikke slette fra midten, så de der ikke slettes kopieres til ny vector
        //og  gl.vector overskrivets

        vector<Person> newvector;
        for (int i = 0; i != persons.size(); i++) {
                if ( persons[i].inits != RemovePerson.inits) {
                        newvector.push_back( persons[i] );
                }
        }
        persons = newvector;
        return true;
}

/*
DatabaseLayer::DatabaseLayer(void)
{
        db.OpenEx("ODBC; Description=; DRIVER=SQL Server; SERVER=TK-Teacher; UID=GroupTwo; PWD=toog30");
        db.ExecuteSQL("USE GroupTwo");
}

DatabaseLayer::~DatabaseLayer(void)
{
}

vector<Person> DatabaseLayer::GetPersonAll(void)
{
        vector<Person> buffer;
        CString id, inits, name, isadmin, pass;

                CRecordset rs(&db);
                rs.Open(AFX_DB_USE_DEFAULT_TYPE, "SELECT PersonID, Initialer, Navn, Admin, Pass FROM Person");
                while(!rs.IsEOF())
                {
                        rs.GetFieldValue((short)0,id);
                        rs.GetFieldValue(1,inits);
                        rs.GetFieldValue(2,name);
                        rs.GetFieldValue(3,isadmin);
                        rs.GetFieldValue(4,pass);
                        
                        Person p;
                        p.id            = id;
                        p.inits         = inits;
                        p.name          = name;
                        p.isadmin       = (isadmin == 1);
                        p.pass          = pass;

                        buffer.push_back(p);

                        rs.MoveNext();
                }
                rs.Close();
        return buffer;
}

Person DatabaseLayer::GetPerson(CString wantInits)
{

        CString id, inits, name, isadmin, pass;
        CString SQL;

        Person p;
        //FIX SQL INJECTION
        SQL = "SELECT PersonID, Initialer, Navn, Admin, Pass FROM Person WHERE (Initialer = '" + wantInits + "')";
        CRecordset rs(&db);
        rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL);

        if(!rs.IsEOF() )
        {
                        rs.GetFieldValue((short)0,id);
                        rs.GetFieldValue(1,inits);
                        rs.GetFieldValue(2,name);
                        rs.GetFieldValue(3,isadmin);
                        rs.GetFieldValue(4,pass);
                        
                        p.id            = id;
                        p.inits         = inits;
                        p.name          = name;
                        p.isadmin       = (isadmin == "1");
                        p.pass          = pass;
        }
        return p;
}

bool DatabaseLayer::AddPerson(Person NewPerson)
{
        CString SQL;
        SQL.Format("INSERT into Person(Initialer, Navn, Admin, Pass) VALUES('%s', '%s', '%d', '%s')",NewPerson.inits, NewPerson.name, NewPerson.isadmin, NewPerson.pass);
        db.ExecuteSQL(SQL);
        return true;
}

bool DatabaseLayer::UpdatePerson(Person ChangePerson)
{
        CString SQL;
        SQL.Format("UPDATE Person SET Initialer = '%s', Navn = '%s', Pass = '%s', Admin = '%d' WHERE PersonID = '%s'", ChangePerson.inits, ChangePerson.name, ChangePerson.pass, ChangePerson.isadmin, ChangePerson.id);
        db.ExecuteSQL(SQL);
        return true;
}

bool DatabaseLayer::DeletePerson(Person RemovePerson)
{
        CString SQL;
        SQL.Format("DELETE FROM Person WHERE PersonID = '%s'", RemovePerson.id);
        db.ExecuteSQL(SQL);
        return true;
}

*/
1	#include "StdAfx.h"
2	#include ".\databaselayer.h"
3
4	DatabaseLayer::DatabaseLayer(void)
5	{
6	Person p1;
7	p1.id="0";
8	p1.inits="MaPe";
9	p1.isadmin = 0;
10	p1.name="Mads Pedersen";
11	persons.push_back(p1);
12
13	Person p2;
14	p2.id="1";
15	p2.inits = "thn";
16	p2.isadmin = 1;
17	p2.name = "Torben Nielsen";
18	p2.pass = "thn";
19	persons.push_back(p2);
20
21	Person p3;
22	p3.id = "2";
23	p3.inits = "FiKa";
24	p3.isadmin = 0;
25	p3.name = "Finn Karlsen";
26	persons.push_back(p3);
27
28	Equipment e1;
29	e1.barcode = "1234567890123";
30	e1.name = "1 ks. øl";
31	e1.description = "30 Stk. Hancock Høker";
32	e1.placement = "i kælderen";
33	e1.status = "Drukket";
34	equipments.push_back(e1);
35
36	}
37
38	vector<Person> DatabaseLayer::GetPersonAll(void)
39	{
40	return persons;
41	}
42
43	Person DatabaseLayer::GetPerson(CString wantInits)
44	{
45	for (int i=0; i<persons.size(); i++) {
46	if (persons[i].inits == wantInits)
47	return persons[i];
48	}
49	Person p;
50	return p;
51	}
52
53	Equipment DatabaseLayer::GetEquipment(CString wantBarcode)
54	{
55	for (int i=0; i<equipments.size(); i++) {
56	if (equipments[i].barcode == wantBarcode) {
57	return equipments[i];
58	}
59	}
60	}
61
62	bool DatabaseLayer::UpdatePerson(Person ChangePerson)
63	{
64	for (int i=0; i<persons.size(); i++) {
65	if (persons[i].inits == ChangePerson.inits) {
66	persons[i] = ChangePerson;
67	break;
68	}
69	}
70
71	return true;
72	}
73
74
75	bool DatabaseLayer::UpdateEquipment(Equipment ChangeEquipment)
76	{
77	for (int i=0; i<equipments.size(); i++) {
78	if (equipments[i].barcode == ChangeEquipment.barcode) {
79	equipments[i] = ChangeEquipment;
80	break;
81	}
82	}
83
84	return true;
85
86	}
87
88	bool DatabaseLayer::AddPerson(Person NewPerson)
89	{
90	persons.push_back(NewPerson);
91	return true;
92	}
93
94
95	vector<Equipment> DatabaseLayer::GetEquipmentAll()
96	{
97	return equipments;
98	}
99
100	bool DatabaseLayer::AddEquipment(Equipment e)
101	{
102	equipments.push_back(e);
103	return true;
104	}
105
106	bool DatabaseLayer::DeletePerson(Person RemovePerson)
107	{
108	//vector kan ikke slette fra midten, så de der ikke slettes kopieres til ny vector
109	//og gl.vector overskrivets
110
111	vector<Person> newvector;
112	for (int i = 0; i != persons.size(); i++) {
113	if ( persons[i].inits != RemovePerson.inits) {
114	newvector.push_back( persons[i] );
115	}
116	}
117	persons = newvector;
118	return true;
119	}
120
121	/*
122	DatabaseLayer::DatabaseLayer(void)
123	{
124	db.OpenEx("ODBC; Description=; DRIVER=SQL Server; SERVER=TK-Teacher; UID=GroupTwo; PWD=toog30");
125	db.ExecuteSQL("USE GroupTwo");
126	}
127
128	DatabaseLayer::~DatabaseLayer(void)
129	{
130	}
131
132	vector<Person> DatabaseLayer::GetPersonAll(void)
133	{
134	vector<Person> buffer;
135	CString id, inits, name, isadmin, pass;
136
137	CRecordset rs(&db);
138	rs.Open(AFX_DB_USE_DEFAULT_TYPE, "SELECT PersonID, Initialer, Navn, Admin, Pass FROM Person");
139	while(!rs.IsEOF())
140	{
141	rs.GetFieldValue((short)0,id);
142	rs.GetFieldValue(1,inits);
143	rs.GetFieldValue(2,name);
144	rs.GetFieldValue(3,isadmin);
145	rs.GetFieldValue(4,pass);
146
147	Person p;
148	p.id = id;
149	p.inits = inits;
150	p.name = name;
151	p.isadmin = (isadmin == 1);
152	p.pass = pass;
153
154	buffer.push_back(p);
155
156	rs.MoveNext();
157	}
158	rs.Close();
159	return buffer;
160	}
161
162	Person DatabaseLayer::GetPerson(CString wantInits)
163	{
164
165	CString id, inits, name, isadmin, pass;
166	CString SQL;
167
168	Person p;
169	//FIX SQL INJECTION
170	SQL = "SELECT PersonID, Initialer, Navn, Admin, Pass FROM Person WHERE (Initialer = '" + wantInits + "')";
171	CRecordset rs(&db);
172	rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL);
173
174	if(!rs.IsEOF() )
175	{
176	rs.GetFieldValue((short)0,id);
177	rs.GetFieldValue(1,inits);
178	rs.GetFieldValue(2,name);
179	rs.GetFieldValue(3,isadmin);
180	rs.GetFieldValue(4,pass);
181
182	p.id = id;
183	p.inits = inits;
184	p.name = name;
185	p.isadmin = (isadmin == "1");
186	p.pass = pass;
187	}
188	return p;
189	}
190
191	bool DatabaseLayer::AddPerson(Person NewPerson)
192	{
193	CString SQL;
194	SQL.Format("INSERT into Person(Initialer, Navn, Admin, Pass) VALUES('%s', '%s', '%d', '%s')",NewPerson.inits, NewPerson.name, NewPerson.isadmin, NewPerson.pass);
195	db.ExecuteSQL(SQL);
196	return true;
197	}
198
199	bool DatabaseLayer::UpdatePerson(Person ChangePerson)
200	{
201	CString SQL;
202	SQL.Format("UPDATE Person SET Initialer = '%s', Navn = '%s', Pass = '%s', Admin = '%d' WHERE PersonID = '%s'", ChangePerson.inits, ChangePerson.name, ChangePerson.pass, ChangePerson.isadmin, ChangePerson.id);
203	db.ExecuteSQL(SQL);
204	return true;
205	}
206
207	bool DatabaseLayer::DeletePerson(Person RemovePerson)
208	{
209	CString SQL;
210	SQL.Format("DELETE FROM Person WHERE PersonID = '%s'", RemovePerson.id);
211	db.ExecuteSQL(SQL);
212	return true;
213	}
214
215	*/