viewvc/H6/MicrosoftDBLayer.h

/*
 * 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);
};
1	/*
2	* Primary developers: Hedin & Kevin
3	*/
4
5	#pragma once
6
7	#include "DatabaseLayer.h"
8	#include "Containers.h"
9	#include "ConfigFile.h"
10	#include <vector>
11
12
13	using namespace std;
14
15	class MicrosoftDBLayer : public DatabaseLayer
16	{
17	private:
18	CDatabase db;
19
20	public:
21	MicrosoftDBLayer(ConfigFile &config);
22	~MicrosoftDBLayer(void);
23
24	vector<Person> GetPersonAll(void);
25	Person GetPerson(CString wantInits);
26
27	bool AddPerson(Person NewPerson);
28	bool UpdatePerson(Person ChangePerson);
29	bool DeletePerson(Person RemovePerson);
30	bool ReturnEquipment(CString barcode);
31	bool CheckoutEquipment(Person CheckPersID, Equipment CheckEquip, int Numdays);
32	bool EquipmentReservation(CString barcode, Person CheckPerson);
33	bool UpdateEquipment(Equipment CheckEquip);
34	bool AddEquipment(Equipment AddEquip);
35	vector<Equipment> GetEquipmentAll(void);
36	Equipment GetEquipment(CString wantBarcode);
37	bool DeleteEquipment(Equipment DelEquip);
38	vector<Equipment> Search(CString barcode, CString name, CString inits, bool available, bool reserved, bool deposited);
39	void checkReservations(CString barcode);
40	bool DeleteReservation(CString barcode, CString resid);
41
42	private:
43	void FillEquipmentVector(vector<Equipment> &buffer, CRecordset &rs);
44	};