// ChangePswd.cpp : implementation file
//

#include "stdafx.h"
#include "MPhoneQuery.h"
#include "ChangePswd.h"

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

/////////////////////////////////////////////////////////////////////////////
// CChangePswd dialog


CChangePswd::CChangePswd(CWnd* pParent /*=NULL*/)
	: CDialog(CChangePswd::IDD, pParent)
{
	//{{AFX_DATA_INIT(CChangePswd)
	m_strAdminName = _T("");
	m_strNewPswd = _T("");
	m_strOldPswd = _T("");
	//}}AFX_DATA_INIT
}


void CChangePswd::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CChangePswd)
	DDX_Text(pDX, IDC_CHANGE_NAME, m_strAdminName);
	DDX_Text(pDX, IDC_CHANGE_NEWPSWD, m_strNewPswd);
	DDX_Text(pDX, IDC_CHANGE_OLDPSWD, m_strOldPswd);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CChangePswd, CDialog)
	//{{AFX_MSG_MAP(CChangePswd)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CChangePswd message handlers

void CChangePswd::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);

	// Update the password of the current user;
	_variant_t strQuery, Holder;
	CString strOldPswd;

	strQuery = "select * from staff where staff_name ='"+m_strAdminName+"'";
	theApp.ADOExecute(theApp.m_pADOSet,strQuery);
	Holder = theApp.m_pADOSet->GetCollect("staff_password");
	strOldPswd = Holder.bstrVal;

	if( strOldPswd.Compare(m_strOldPswd) == 0 )
	{
		strQuery = "Update staff set staff_password ='"+m_strNewPswd+"'\
					where staff_name ='"+m_strAdminName+"'";
		if(theApp.ADOExecute(theApp.m_pADOSet,strQuery))
		{
			AfxMessageBox("修改密碼成功！",MB_ICONINFORMATION);
		}
		else
		{
			AfxMessageBox("修改密碼失敗！",MB_ICONEXCLAMATION);
			return;
		}
	}
	else
	{
			AfxMessageBox("修改密碼失敗，請檢查原密碼！",MB_ICONEXCLAMATION);
			return;
	}

	
	CDialog::OnOK();
}

BOOL CChangePswd::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_strAdminName = theApp.m_strCurAdminName;

	((CEdit*)GetDlgItem(IDC_CHANGE_OLDPSWD))->SetLimitText(10);
    ((CEdit*)GetDlgItem(IDC_CHANGE_NEWPSWD))->SetLimitText(10);

	((CEdit*)GetDlgItem(IDC_CHANGE_OLDPSWD))->SetFocus();
	
	UpdateData(FALSE);

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