// DepartmentCommand.cpp: implementation of the CDepartmentCommand class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "ERSDemo.h"
#include "DepartmentCommand.h"

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

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

CDepartmentCommand::CDepartmentCommand()
{

}

CDepartmentCommand::~CDepartmentCommand()
{

}

void CDepartmentCommand::InsertDepartment(CString DepartmentName)
{
	CString SQL;
	SQL = "Insert Into Department(Name) Values(\"" + DepartmentName + "\")";
	ExecuteSQL(SQL);
}

void CDepartmentCommand::RenameDepartment(CString NewName, int ID)
{
	CString SQL;
	SQL.Format("Update Department Set Name = \"" + NewName + "\" Where ID = %d", ID);
	ExecuteSQL(SQL);	
}