#pragma once

#include "Containers.h"
#include <vector>

using namespace std;

class DatabaseLayer
{
private:
	CDatabase db;

public:
	DatabaseLayer(void);
	~DatabaseLayer(void);

	vector<Person> GetPersonAll(void);
	Person GetPerson(CString wantInits);

	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(Person CheckPersID, Equipment CheckEquip, int Numdays);
	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 FillEquipmentVector(vector<Equipment> &buffer, CRecordset &rs);
};