BasicAdmin - Personal Organizer

#pragma once
#include <vector>

using namespace std;

enum TFieldType
{
	TFTypeText = 0,
	TFTypeNumeric = 1,
	TFTypeInteger = 2,
	TFTypeFloat = 3
};
class CField
{
	public:
		CString Name;
		TFieldType ftype;
		BOOL PK;
		CString getFieldDesc(TFieldType f)
		{
			switch (f)
			{
				case TFTypeText:	return "TEXT";
				case TFTypeNumeric: return "NUMERIC";
				case TFTypeInteger: return "INTEGER";
				case TFTypeFloat:	return "FLOAT";
			}
		}
		CString GetFieldCreate()
		{
			CString strres = "";
			strres.Append(Name);
			strres.Append(" ");
			strres.Append(getFieldDesc(ftype));
			if (PK)
				strres.Append(" PRIMARY KEY");
			return strres;
		}
};
class CTable
{
	public:
		CString Name;
		vector<CField> arrFields;
		CString GetCreate()
		{
			CString strres, strf="";
			strres.Format("CREATE TABLE %s", Name);
			vector<CField>::iterator itf;
			for(itf = arrFields.begin(); itf != arrFields.end(); ++itf)
			{
				strf.Append((*itf).GetFieldCreate());
				strf.Append(",");
			}
			strf = strf.Left(strf.GetLength() - 1);
			strres.AppendFormat("(%s)", strf);
			return strres;
		}
};
class CDataStructure
{
public:
	BOOL fieldexists(CString Tabla, CString Campo);
	void AddIfNotExists(CString Tabla, CString Campo, CString Tipo);
	void OpenCreateDB(CString NombreBase);
	void CreateAccounts();
	void CreateCurrencies();
	void CreateDailyInput();
	void CreateContactsCat();
	void CreateContacts();
	void CreateNotes();
	void CreateTaskData();
	/*CString encript(CString cad);
	CString decript(CString cad);*/
	vector<CTable> arrTables;
	void ProcessDB();
	void ProcessTable(CTable& t);
};