// DlgChangePwd.cpp : implementation file
//

#include "stdafx.h"
#include "Project.h"
#include "DlgChangePwd.h"
#include "DlgLogin.h"


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

/////////////////////////////////////////////////////////////////////////////
// CDlgChangePwd dialog


CDlgChangePwd::CDlgChangePwd(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgChangePwd::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDlgChangePwd)
	m_Account = _T("");
	m_InitPwd = _T("");
	m_NewPwd = _T("");
	m_ConfirmPwd = _T("");
	//}}AFX_DATA_INIT
}


void CDlgChangePwd::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgChangePwd)
	DDX_Text(pDX, IDC_USER,    m_Account);
	DDX_Text(pDX, IDC_INITPSW, m_InitPwd);
	DDX_Text(pDX, IDC_NEWPSW,  m_NewPwd);
	DDX_Text(pDX, IDC_CONPSW,  m_ConfirmPwd);
	//}}AFX_DATA_MAP
}

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

/////////////////////////////////////////////////////////////////////////////

void CDlgChangePwd::OnOK() 
{
	CDlgLogin dlgLogin;
	try
	{   //連接數據源
		_bstr_t Conn = "DSN="+_bstr_t(dlgLogin.m_LoginDSN)+";";   //使用在DlgLogin中獲取的DSN名
		pConn.CreateInstance(__uuidof(Connection));
		HRESULT hr=pConn->Open(Conn,_bstr_t(""),_bstr_t(""),adModeUnknown); 
	}
	catch(_com_error& ex)
	{
		AfxMessageBox(ex.Description());
	}	

	UpdateData(TRUE);
	try
	{
		CString sql;
		sql.Format("SELECT AccountNo FROM TableAccount WHERE AccountNo='%s' AND Pswd='%s'",
			         m_Account, m_InitPwd);   //選取當前帳戶和密碼的記錄
		_RecordsetPtr pRst;
		pRst = pConn->Execute(_bstr_t(sql), NULL, adCmdText);
		if (pRst->End)                        //若沒有查到記錄
		{
			AfxMessageBox("用戶名或密碼錯誤!");
			m_Account = m_InitPwd = m_NewPwd =m_ConfirmPwd = "";
			this->UpdateData(false);
		}
		else
		{
			if(m_NewPwd== m_ConfirmPwd)
			{
				sql.Format("UPDATE TableAccount SET Pswd=\'%s\' WHERE AccountNo=\'%s\'",m_NewPwd,m_Account);		
				pConn->Execute(_bstr_t(sql), NULL, adCmdText);
				AfxMessageBox("密碼修改成功，重新登陸!");
				CDialog::OnOK();
			}
			else
				AfxMessageBox("兩次輸入密碼不一致!");
		}
		pRst.Release();
		pConn.Release();    //釋放連接
	} 
	catch(_com_error& e)
	{
		AfxMessageBox(e.ErrorMessage());
	}
}