11 |
|
|
12 |
class DatabaseLayer |
class DatabaseLayer |
13 |
{ |
{ |
|
private: |
|
|
CDatabase db; |
|
|
|
|
14 |
public: |
public: |
|
// virtual DatabaseLayer(void); |
|
15 |
virtual ~DatabaseLayer(void) {}; |
virtual ~DatabaseLayer(void) {}; |
16 |
|
|
17 |
virtual vector<Person> GetPersonAll(void) = 0; |
virtual vector<Person> GetPersonAll(void); |
18 |
virtual Person GetPerson(CString wantInits) = 0; |
virtual Person GetPerson(CString wantInits); |
19 |
|
|
20 |
virtual bool AddPerson(Person NewPerson) = 0; |
virtual bool AddPerson(Person NewPerson); |
21 |
virtual bool UpdatePerson(Person ChangePerson) = 0; |
virtual bool UpdatePerson(Person ChangePerson); |
22 |
virtual bool DeletePerson(Person RemovePerson) = 0; |
virtual bool DeletePerson(Person RemovePerson); |
23 |
virtual bool ReturnEquipment(CString barcode) = 0; |
virtual bool ReturnEquipment(CString barcode); |
24 |
virtual bool CheckoutEquipment(Person CheckPersID, Equipment CheckEquip, int Numdays) = 0; |
virtual bool CheckoutEquipment(Person CheckPersID, Equipment CheckEquip, int Numdays) ; |
25 |
virtual bool EquipmentReservation(CString barcode, Person CheckPerson) = 0; |
virtual bool EquipmentReservation(CString barcode, Person CheckPerson) ; |
26 |
virtual bool UpdateEquipment(Equipment CheckEquip) = 0; |
virtual bool UpdateEquipment(Equipment CheckEquip); |
27 |
virtual bool AddEquipment(Equipment AddEquip) = 0; |
virtual bool AddEquipment(Equipment AddEquip); |
28 |
virtual vector<Equipment> GetEquipmentAll(void) = 0; |
virtual vector<Equipment> GetEquipmentAll(void); |
29 |
virtual Equipment GetEquipment(CString wantBarcode) = 0; |
virtual Equipment GetEquipment(CString wantBarcode); |
30 |
virtual bool DeleteEquipment(Equipment DelEquip) = 0; |
virtual bool DeleteEquipment(Equipment DelEquip); |
31 |
virtual vector<Equipment> Search(CString barcode, CString name, CString inits, bool available, bool reserved, bool deposited) = 0; |
virtual vector<Equipment> Search(CString barcode, CString name, CString inits, bool available, bool reserved, bool deposited) = 0; |
|
virtual void checkReservations(CString barcode) = 0; |
|
|
virtual bool DeleteReservation(CString barcode, CString resid) = 0; |
|
32 |
|
|
33 |
private: |
|
34 |
virtual void FillEquipmentVector(vector<Equipment> &buffer, CRecordset &rs) = 0; |
virtual void checkReservations(CString barcode); |
35 |
|
virtual bool DeleteReservation(CString barcode, CString resid); |
36 |
|
|
37 |
|
protected: |
38 |
|
DatabaseLayer(void) {} //Avoid direct instantiation |
39 |
|
|
40 |
|
virtual void FillEquipmentVector(vector<Equipment> &buffer, CRecordset &rs); |
41 |
|
|
42 |
|
virtual CString GenerateQueryForLatestCheckouts(CString barcode) = 0; |
43 |
|
|
44 |
|
protected: |
45 |
|
CDatabase db; |
46 |
|
|
47 |
}; |
}; |