/*
 * Primary developers: Hedin & Kevin
 */

#pragma once

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


using namespace std;

class MicrosoftDBLayer : public DatabaseLayer
{
private:
	CDatabase db;

public:
	MicrosoftDBLayer(ConfigFile &config);
	~MicrosoftDBLayer(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(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);

private:
	void FillEquipmentVector(vector<Equipment> &buffer, CRecordset &rs);
};