CODBCAccess: a CDatabase and CRecordset Wrapper

// NamePrompt.cpp : implementation file
//

#include "stdafx.h"
#include "ODBCExample.h"
#include "NamePrompt.h"

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

/////////////////////////////////////////////////////////////////////////////
// CNamePrompt dialog


CNamePrompt::CNamePrompt(CWnd* pParent /*=NULL*/)
	: CDialog(CNamePrompt::IDD, pParent)
{
	//{{AFX_DATA_INIT(CNamePrompt)
	m_strName = _T("");
	m_strSQL = _T("");
	//}}AFX_DATA_INIT
}


void CNamePrompt::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CNamePrompt)
	DDX_Control(pDX, IDC_TABLE, m_ctlTable);
	DDX_Text(pDX, IDC_NAME, m_strName);
	DDX_Text(pDX, IDC_SQL, m_strSQL);
	DDX_Control(pDX, IDC_USESQL, m_ctlRadioSQL);
	DDX_Control(pDX, IDC_USETABLE, m_ctlRadioTable);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CNamePrompt, CDialog)
	//{{AFX_MSG_MAP(CNamePrompt)
	ON_BN_CLICKED(IDC_USESQL, OnUsesql)
	ON_BN_CLICKED(IDC_USETABLE, OnUsetable)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CNamePrompt message handlers

void CNamePrompt::OnOK() 
{
	UpdateData(true);
	int useSQL = m_ctlRadioSQL.GetCheck();
	if(m_strName == _T(""))
	{
		MessageBox("You must enter a name to continue.", "No Name Entered", MB_ICONEXCLAMATION);
		return;
	}
	if(useSQL == 1 && m_strSQL == _T(""))
	{
		MessageBox("Please enter an SQL statement if you want to use one for the set results.",
			"No SQL Statement Entered", MB_ICONEXCLAMATION);
		return;
	}

	//Set table name if applies:
	if(useSQL == 0)
	{
		//BUG Fix: spotted by Yuval Detinis:
		//If m_ctlTable has no current selection, it will ASSERT -->

		if(m_ctlTable.GetCurSel() < 0)
		{
			//Alert the user and return:
			MessageBox("You must select a table to open!  Please select a table and then try again.", "No Table Selected", MB_ICONEXCLAMATION);
			return;
		}

		m_ctlTable.GetLBText(m_ctlTable.GetCurSel(), sTable);
	}
	m_bUseSQL = useSQL;

	//Finished validating:
	CDialog::OnOK();
}

void CNamePrompt::OnUsesql() 
{
	UpdateData(true);
	BOOL use = m_ctlRadioSQL.GetCheck();
	GetDlgItem(IDC_SQL)->EnableWindow(use);
	GetDlgItem(IDC_TABLE)->EnableWindow(!use);
}

void CNamePrompt::OnUsetable() 
{
	UpdateData(true);
	BOOL use = m_ctlRadioTable.GetCheck();
	GetDlgItem(IDC_SQL)->EnableWindow(!use);
	GetDlgItem(IDC_TABLE)->EnableWindow(use);
}

BOOL CNamePrompt::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	//Get the tables from the open database:
	db->QueryOpenTables();

	//Get pointer to it:
	CTables* table;
	db->GetTables(table);

	//Loop through to add them to the combo box:
	for(int h = 0; h < table->GetRecordCount(); h++)
	{
		//Add this one:
		m_ctlTable.AddString(table->m_strTableName);

		//Move to the next table name:
		table->MoveNext();
	}

	//The tables set is automatically closed when Disconnect is called OR it is closed
	//and reopened when QueryOpenTables is called again

	//Disable or enable the correct controls:
	m_ctlRadioSQL.SetCheck(1);
	m_ctlRadioTable.SetCheck(0);
	OnUsesql();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}