// MWLPage.cpp : implementation file
//

#include "stdafx.h"
#include "CLDMWLSCP.h"
#include "MWLPage.h"

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

/////////////////////////////////////////////////////////////////////////////
// MWLPage property page

IMPLEMENT_DYNCREATE(CMWLPage, CPropertyPage)

CMWLPage::CMWLPage() : CPropertyPage(CMWLPage::IDD)
{
	//{{AFX_DATA_INIT(CMWLPage)
	//}}AFX_DATA_INIT
}

CMWLPage::~CMWLPage()
{
}

void CMWLPage::DoDataExchange(CDataExchange* pDX)
{
	CPropertyPage::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CMWLPage)
	DDX_Control(pDX, IDC_ADODC1, m_ADOControl);
	DDX_Control(pDX, IDC_DATAGRID1, m_DataGridControl);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CMWLPage, CPropertyPage)
	//{{AFX_MSG_MAP(CMWLPage)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// MWLPage message handlers

BOOL CMWLPage::OnInitDialog() 
{
	CPropertyPage::OnInitDialog();

   CString sConnString;
   sConnString.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;Persist Security Info=False;",
                      ((CPropertySheetDlg*) GetParent())->m_sDBFileName);

   CString sSQLQuery;
   sSQLQuery = "SELECT "
               "MwlSCPTbl.TAG_ACCESSION_NUMBER as [Accession Number],"
               "MwlSCPTbl.TAG_MODALITY  as [Modality]," 
               "MwlSCPTbl.TAG_INSTITUTION_NAME as [Institution Name]," 
               "MwlSCPTbl.TAG_REFERRING_PHYSICIAN_NAME as [Referring Physician Name],"
               "MwlSCPTbl.TAG_PATIENT_NAME as [Patient Name],"
               "MwlSCPTbl.TAG_PATIENT_ID as [Patient ID],"
               "MwlSCPTbl.TAG_PATIENT_BIRTH_DATE as [Patient Birth Date],"
               "MwlSCPTbl.TAG_PATIENT_SEX as [Patient Sex],"
               "MwlSCPTbl.TAG_PATIENT_WEIGHT as [Patient Weight],"
               "MwlSCPTbl.TAG_STUDY_INSTANCE_UID AS [Study Instance UID],"
               "MwlSCPTbl.TAG_REQUESTING_PHYSICIAN AS [Requesting Physician],"
               "MwlSCPTbl.TAG_REQUESTED_PROCEDURE_DESCRIPTION AS [Requested Procedure Description],"
               "MwlSCPTbl.TAG_ADMISSION_ID AS [Admission ID],"
               "MwlSCPTbl.TAG_SCHEDULED_STATION_AE_TITLE AS [Scheduled Station AE Title],"
               "MwlSCPTbl.TAG_SCHEDULED_PROCEDURE_STEP_START_DATE AS [Scheduled Procedure Step Start Date],"
               "MwlSCPTbl.TAG_SCHEDULED_PROCEDURE_STEP_START_TIME AS [Scheduled Procedure Step Start Time],"
               "MwlSCPTbl.TAG_SCHEDULED_PERFORMING_PHYSICIAN_NAME AS [Scheduled Performing Physician Name],"
               "MwlSCPTbl.TAG_SCHEDULED_PROCEDURE_STEP_DESCRIPTION AS [Scheduled Procedure Step Description],"
               "MwlSCPTbl.TAG_SCHEDULED_PROCEDURE_STEP_ID AS [Scheduled Procedure Step ID],"
               "MwlSCPTbl.TAG_SCHEDULED_PROCEDURE_STEP_LOCATION AS [Scheduled Procedure Step Location],"
               "MwlSCPTbl.TAG_REQUESTED_PROCEDURE_ID AS [Requested Procedure ID],"
               "MwlSCPTbl.TAG_REASON_FOR_THE_REQUESTED_PROCEDURE AS [Reason for the Requested Procedure],"
               "MwlSCPTbl.TAG_REQUESTED_PROCEDURE_PRIORITY AS [Requested Procedure Priority]  "
               "FROM MwlSCPTbl ORDER BY MwlSCPTbl.Item_ID;";

   m_ADOControl.SetConnectionString(sConnString);
   m_ADOControl.SetCommandType(1);
   m_ADOControl.SetRecordSource(sSQLQuery);
   m_DataGridControl.SetRefDataSource(m_ADOControl.GetControlUnknown());

   return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}


BEGIN_EVENTSINK_MAP(CMWLPage, CPropertyPage)
    //{{AFX_EVENTSINK_MAP(CMWLPage)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

BOOL CMWLPage::PreTranslateMessage(MSG* pMsg)
{
   if (pMsg->message == WM_KEYDOWN)
   {
      switch (pMsg->wParam)
      {
      case VK_ESCAPE:
         return TRUE;

      case VK_DELETE:
         if (pMsg->hwnd == m_DataGridControl.m_hWnd)
         {
            return PreTranslateInput(pMsg);
         }
      }
   }

	return CPropertyPage::PreTranslateMessage(pMsg);
}