list.CListView.Query();

#include <CtrlLib/CtrlLib.h>
#include <SqlCtrl/SqlCtrl.h>
#include <plugin/Sqlite3/Sqlite3.h>

#define LAYOUTFILE <EzellApp4/EzellApp4.lay>
#include <CtrlCore/lay.h>

class EzellApp4 : public WithEzellApp4Layout<TopWindow> {
	WithListLayout<ParentCtrl> list;
	WithDetailLayout<ParentCtrl> detail;
	// The SQLite session

	// For editing
	EditDate editDate;
	EditString editDesc;
	EditString editCost;
	
public:
	typedef EzellApp4 CLASSNAME;
	void SwitchView();
	void CrossUpdate(int);
	EzellApp4();
};

void EzellApp4::CrossUpdate(int i)
{
	// In progress
	PromptOK("Yea, OK");
	list.CListView.Refresh();
}

EzellApp4::EzellApp4()
{
	// Setup the layouts
	CtrlLayout(*this, "Bean Heat and Air- Customer Files");
	CtrlLayout(list);
	CtrlLayout(detail);
	
	Sizeable();
	Zoomable();
	
	// Tell tab control what slave ctrls to use
	tab.Add(list, "Customers");
	tab.Add(detail, "Details");
	
	// Kinda dumb that we have to do this
	// isn't there a better way?
	SqlId JOBID("JOBID");
	SqlId NAME("NAME");
	SqlId CUSTOMER_ID("CUSTOMER_ID");
	
	// Setup primary customer list
	list.CListView.SetTable("CUSTOMERS");
	list.CListView.AddColumn("ID", "Id");
	list.CListView.HeaderObject().HideTab(0);
	list.CListView.AddColumn("NAME","Name");
	list.CListView.AddColumn("ADDRESS","Address");
	list.CListView.AddColumn("CSZ","City, State Zip");
	list.CListView.AddColumn("PHONE1","Phone 1");

	list.CListView.AddCtrl("NAME",list.strName1);
	list.CListView.AddCtrl("NAME", detail.strName);
	list.CListView.AddCtrl("ADDRESS", detail.strAddress);
	list.CListView.AddCtrl("CSZ", detail.strCSZ);

	list.CListView.SetOrderBy(NAME);
	list.CListView.WhenLeftDouble = THISBACK(SwitchView);
	
	detail.detailList.SetTable("JOBS");
	detail.detailList.AddColumn("JOBID","Id");
	detail.detailList.HeaderObject().HideTab(0);
	detail.detailList.AddColumn("DONEDATE","Date").Edit(editDate);
	detail.detailList.AddColumn("DESCRIPTION","Description").Edit(editDesc);
	detail.detailList.AddColumn("COST","Cost").Edit(editCost);
	detail.detailList.SetOrderBy(JOBID);
	detail.detailList.Join(CUSTOMER_ID, list.CListView);
	detail.detailList.Removing().Appending();

	list.CListView.Query();
}

void EzellApp4::SwitchView()
{
	tab.Set(1);
}

GUI_APP_MAIN
{
	Sqlite3Session session;

	if(!session.Open(ConfigFile("simple2.db"))) {
		Exclamation("Error opening the database file");
		return;
	}

#ifdef _DEBUG
	session.SetTrace();
	session.LogErrors(true);
#endif

	SQL = session;

	EzellApp4().Run();
}