1 |
|
|
2 |
|
|
3 |
#include "StdAfx.h" |
#include "StdAfx.h" |
4 |
#include ".\databaselayer.h" |
#include ".\databaselayer.h" |
5 |
|
|
6 |
|
|
7 |
DatabaseLayer::DatabaseLayer(void) |
DatabaseLayer::DatabaseLayer(void) |
8 |
{ |
{ |
9 |
db.OpenEx("ODBC; Description=; DRIVER=SQL Server; SERVER=TK-Teacher; UID=GroupTwo; PWD=toog30"); |
db.OpenEx("ODBC; Description=; DRIVER=SQL Server; SERVER=TK-Teacher; UID=GroupTwo; PWD=toog30", CDatabase::noOdbcDialog); |
10 |
db.ExecuteSQL("USE GroupTwo"); |
db.ExecuteSQL("USE GroupTwo"); |
11 |
} |
} |
12 |
|
|
279 |
for (int i=0; i<buffer.size(); i++) { |
for (int i=0; i<buffer.size(); i++) { |
280 |
//fill Equipment::checkouts |
//fill Equipment::checkouts |
281 |
|
|
282 |
SQL = "SELECT Udlån.StartDato, Udlån.Afleveringsdato,Udlån.Antaldage, Person.Initialer\ |
SQL = "SELECT TOP 10 Udlån.StartDato, Udlån.Afleveringsdato,Udlån.Antaldage, Person.Initialer\ |
283 |
FROM Udlån\ |
FROM Udlån\ |
284 |
INNER JOIN Person ON Udlån.PersonID = Person.PersonID "; |
INNER JOIN Person ON Udlån.PersonID = Person.PersonID "; |
285 |
SQL += "WHERE Udlån.Stregkode = " + buffer[i].barcode + " ORDER BY STARTDATO ASC"; |
SQL += "WHERE Udlån.Stregkode = " + buffer[i].barcode + " ORDER BY STARTDATO DESC"; |
286 |
CRecordset rs(&db); |
CRecordset rs(&db); |
287 |
rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL); |
rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL); |
288 |
if (rs.GetRecordCount()>0) { |
if (rs.GetRecordCount()>0) { |
301 |
rs.Close(); |
rs.Close(); |
302 |
|
|
303 |
// fill Equipment::reservations |
// fill Equipment::reservations |
304 |
SQL = "SELECT Resevation.StartDato, Resevation.Antaldage, Person.Initialer\ |
SQL = "SELECT Resevation.ResevationID, Resevation.StartDato, Resevation.Antaldage, Person.Initialer\ |
305 |
FROM Resevation\ |
FROM Resevation\ |
306 |
INNER JOIN Person ON Resevation.PersonID = Person.PersonID "; |
INNER JOIN Person ON Resevation.PersonID = Person.PersonID "; |
307 |
SQL += "WHERE Resevation.Stregkode = " + buffer[i].barcode + " ORDER BY STARTDATO ASC"; |
SQL += "WHERE Resevation.Stregkode = " + buffer[i].barcode + " ORDER BY STARTDATO ASC"; |
311 |
rs.MoveFirst(); |
rs.MoveFirst(); |
312 |
while ( !rs.IsEOF() ) { |
while ( !rs.IsEOF() ) { |
313 |
Reservation res; |
Reservation res; |
314 |
rs.GetFieldValue((short)0, res.startdate); |
rs.GetFieldValue((short)0, res.reservationID); |
315 |
rs.GetFieldValue(1, res.numdays); |
rs.GetFieldValue(1, res.startdate); |
316 |
rs.GetFieldValue(2, res.inits); |
rs.GetFieldValue(2, res.numdays); |
317 |
|
rs.GetFieldValue(3, res.inits); |
318 |
|
|
319 |
buffer[i].reservations.push_back(res); |
buffer[i].reservations.push_back(res); |
320 |
rs.MoveNext(); |
rs.MoveNext(); |