13 |
|
|
14 |
class PostgresLayer : public DatabaseLayer |
class PostgresLayer : public DatabaseLayer |
15 |
{ |
{ |
|
private: |
|
|
CDatabase db; |
|
|
|
|
16 |
public: |
public: |
17 |
PostgresLayer(ConfigFile &config); |
PostgresLayer(ConfigFile &config); |
18 |
~PostgresLayer(void); |
virtual ~PostgresLayer(void); |
|
|
|
|
vector<Person> GetPersonAll(void); |
|
|
Person GetPerson(CString wantInits); |
|
19 |
|
|
|
bool AddPerson(Person NewPerson); |
|
|
bool UpdatePerson(Person ChangePerson); |
|
|
bool DeletePerson(Person RemovePerson); |
|
|
bool ReturnEquipment(CString barcode); |
|
|
bool CheckoutEquipment(Person CheckPersID, Equipment CheckEquip, int Numdays); |
|
|
bool EquipmentReservation(CString barcode, Person CheckPerson); |
|
|
bool UpdateEquipment(Equipment CheckEquip); |
|
|
bool AddEquipment(Equipment AddEquip); |
|
|
vector<Equipment> GetEquipmentAll(void); |
|
|
Equipment GetEquipment(CString wantBarcode); |
|
|
bool DeleteEquipment(Equipment DelEquip); |
|
|
vector<Equipment> Search(CString barcode, CString name, CString inits, bool available, bool reserved, bool deposited); |
|
|
void checkReservations(CString barcode); |
|
|
bool DeleteReservation(CString barcode, CString resid); |
|
20 |
|
|
21 |
private: |
virtual vector<Equipment> Search(CString barcode, CString name, CString inits, bool available, bool reserved, bool deposited); |
22 |
void FillEquipmentVector(vector<Equipment> &buffer, CRecordset &rs); |
protected: |
23 |
|
virtual CString GenerateQueryForLatestCheckouts(CString barcode); |
24 |
}; |
}; |