// DepartmentDataSet.cpp: implementation of the CDepartmentDataSet class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "ERSDemo.h"
#include "DepartmentDataSet.h"

#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

CDepartmentDataSet::CDepartmentDataSet()
{

}

CDepartmentDataSet::~CDepartmentDataSet()
{

}

BOOL CDepartmentDataSet::LoadData()
{
	return Open("Select * From Department");
}

BOOL CDepartmentDataSet::LocateByName(CString Name)
{
	CString SQL = "Select * From Department Where Name = \"" + Name + "\"";
	return Open(SQL);
}

CString CDepartmentDataSet::GetDescription()
{
	return GetAsString("Description");
}

CString CDepartmentDataSet::GetName()
{
	return GetAsString("Name");
}

int CDepartmentDataSet::GetID()
{
	return atoi(GetAsString("ID"));
}