BasicAdmin - Personal Organizer

#include "stdafx.h"
#include "Account.h"

int CAccount::TreeImage(BOOL HasChildren, CppSQLite3Query* q)
{
	CBasicTables::eAccountType acctype = (CBasicTables::eAccountType)q->getIntField("ACCTYPE");
	if (HasChildren)
		return 10;
	else
	{
		switch(acctype)
		{
			case CBasicTables::TaccCash: return 30;
			case CBasicTables::TaccSalary: return 28;
			case CBasicTables::TaccBankAccount: return 26;
			case CBasicTables::TaccExpense: return 25;
			case CBasicTables::TaccStockAccount: return 38;
		}
	}
}
int CAccount::TreeImage(BOOL HasChildren, int acctype)
{
	if (HasChildren)
		return 10;
	else
	{
		switch(acctype)
		{
			case CBasicTables::TaccCash: return 30;
			case CBasicTables::TaccSalary: return 28;
			case CBasicTables::TaccBankAccount: return 26;
			case CBasicTables::TaccExpense: return 25;
			case CBasicTables::TaccStockAccount: return 38;
		}
	}
	return -1;
}
void CAccount::GetAccount(int ID,CUtils* ut, CppSQLite3Query* q1)
{
	CppSQLite3Query q;
	CString strid;
	strid.Format("%d", ID);
	if (q1 == 0)
	{
		q = dbAdmin.execQuery("SELECT * FROM ACCOUNTS WHERE ID = " + strid);
		q1 = &q;
	}
	this->ID = q1->getIntField("ID");
	AccountType = (CBasicTables::eAccountType)q1->getIntField("ACCTYPE");
	Description = q1->getStringField("DESCRIPTION");
	IdCurrency = q1->getIntField("ID_CUR");
	Observations = q1->getStringField("OBSERVATIONS");
	Parent = q1->getIntField("PARENT");
	Shortcut1 = q1->getIntField("SHORTCUT1");
	Shortcut2 = q1->getIntField("SHORTCUT2");
	this->Path = ut->AccGetArrDescription(this->ID,0);
}