using System;
using System.Collections;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.IO;
using com.unicafe.ui;
using com.unicafe.common;
using com.unicafe.security;
using System.Data.SqlClient;

namespace PLP.XT.LostPwd
{
	/// <summary>
	/// LostPwd 的摘要說明。
	/// </summary>
	public class LostPwd
	{
		public LostPwd()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//
		}
	}
}

namespace Com.Ascs.Plp.Xt
{
	/// <summary>
	///  對象Employee的定義
	///  根據表 Employees
	/// </summary>
	
	public class Employee
	{
		/// <summary>
		/// 對象Employee的構造函數
		/// </summary>
		public Employee()
		{
			m_EmplID = "";
			m_EmplNameL = "";
			m_EmplNameF = "";
			m_EmplSex = "";
			m_EmplBirth = DateTime.Now;
			m_EmplEmail = "";
			m_EmplTel1 = "";
			m_EmplTel2 = "";
			m_EmplFax = "";
			m_EmplMobile = "";
			m_EmplPager = "";
			m_EmplAddress = "";
			m_EmplCity = "";
			m_EmplProvince = "";
			m_EmplCountry = "";
			m_EmplZip = "";
			m_EmplAttend = "";
			m_EmplRetire = "";
			m_EducationLevel = "";
			m_EmplEnabled = 0;
			m_SecurityID = "";
		}
		
		private string m_EmplID;
		private string m_EmplNameL;
		private string m_EmplNameF;
		private string m_EmplSex;
		private DateTime m_EmplBirth;
		private string m_EmplEmail;
		private string m_EmplTel1;
		private string m_EmplTel2;
		private string m_EmplFax;
		private string m_EmplMobile;
		private string m_EmplPager;
		private string m_EmplAddress;
		private string m_EmplCity;
		private string m_EmplProvince;
		private string m_EmplCountry;
		private string m_EmplZip;
		private string m_EmplAttend;
		private string m_EmplRetire;
		private string m_EducationLevel;
		private int m_EmplEnabled;
		private string m_SecurityID;
		
		/// <summary>
		/// 屬性 EmplID
		/// </summary>
		public string EmplID
		{
			get
			{
				return m_EmplID;
			}
			set
			{
				m_EmplID = value;
			}
		}
		
		/// <summary>
		/// 屬性 EmplNameL
		/// </summary>
		public string EmplNameL
		{
			get
			{
				return m_EmplNameL;
			}
			set
			{
				m_EmplNameL = value;
			}
		}
		
		/// <summary>
		/// 屬性 EmplNameF
		/// </summary>
		public string EmplNameF
		{
			get
			{
				return m_EmplNameF;
			}
			set
			{
				m_EmplNameF = value;
			}
		}
		
		/// <summary>
		/// 屬性 EmplSex
		/// </summary>
		public string EmplSex
		{
			get
			{
				return m_EmplSex;
			}
			set
			{
				m_EmplSex = value;
			}
		}
		
		/// <summary>
		/// 屬性 EmplBirth
		/// </summary>
		public DateTime EmplBirth
		{
			get
			{
				return m_EmplBirth;
			}
			set
			{
				m_EmplBirth = value;
			}
		}
		
		/// <summary>
		/// 屬性 EmplEmail
		/// </summary>
		public string EmplEmail
		{
			get
			{
				return m_EmplEmail;
			}
			set
			{
				m_EmplEmail = value;
			}
		}
		
		/// <summary>
		/// 屬性 EmplTel1
		/// </summary>
		public string EmplTel1
		{
			get
			{
				return m_EmplTel1;
			}
			set
			{
				m_EmplTel1 = value;
			}
		}
		
		/// <summary>
		/// 屬性 EmplTel2
		/// </summary>
		public string EmplTel2
		{
			get
			{
				return m_EmplTel2;
			}
			set
			{
				m_EmplTel2 = value;
			}
		}
		
		/// <summary>
		/// 屬性 EmplFax
		/// </summary>
		public string EmplFax
		{
			get
			{
				return m_EmplFax;
			}
			set
			{
				m_EmplFax = value;
			}
		}
		
		/// <summary>
		/// 屬性 EmplMobile
		/// </summary>
		public string EmplMobile
		{
			get
			{
				return m_EmplMobile;
			}
			set
			{
				m_EmplMobile = value;
			}
		}
		
		/// <summary>
		/// 屬性 EmplPager
		/// </summary>
		public string EmplPager
		{
			get
			{
				return m_EmplPager;
			}
			set
			{
				m_EmplPager = value;
			}
		}
		
		/// <summary>
		/// 屬性 EmplAddress
		/// </summary>
		public string EmplAddress
		{
			get
			{
				return m_EmplAddress;
			}
			set
			{
				m_EmplAddress = value;
			}
		}
		
		/// <summary>
		/// 屬性 EmplCity
		/// </summary>
		public string EmplCity
		{
			get
			{
				return m_EmplCity;
			}
			set
			{
				m_EmplCity = value;
			}
		}
		
		/// <summary>
		/// 屬性 EmplProvince
		/// </summary>
		public string EmplProvince
		{
			get
			{
				return m_EmplProvince;
			}
			set
			{
				m_EmplProvince = value;
			}
		}
		
		/// <summary>
		/// 屬性 EmplCountry
		/// </summary>
		public string EmplCountry
		{
			get
			{
				return m_EmplCountry;
			}
			set
			{
				m_EmplCountry = value;
			}
		}
		
		/// <summary>
		/// 屬性 EmplZip
		/// </summary>
		public string EmplZip
		{
			get
			{
				return m_EmplZip;
			}
			set
			{
				m_EmplZip = value;
			}
		}
		
		/// <summary>
		/// 屬性 EmplAttend
		/// </summary>
		public string EmplAttend
		{
			get
			{
				return m_EmplAttend;
			}
			set
			{
				m_EmplAttend = value;
			}
		}
		
		/// <summary>
		/// 屬性 EmplRetire
		/// </summary>
		public string EmplRetire
		{
			get
			{
				return m_EmplRetire;
			}
			set
			{
				m_EmplRetire = value;
			}
		}
		
		/// <summary>
		/// 屬性 EducationLevel
		/// </summary>
		public string EducationLevel
		{
			get
			{
				return m_EducationLevel;
			}
			set
			{
				m_EducationLevel = value;
			}
		}
		
		/// <summary>
		/// 屬性 EmplEnabled
		/// </summary>
		public int EmplEnabled
		{
			get
			{
				return m_EmplEnabled;
			}
			set
			{
				m_EmplEnabled = value;
			}
		}
		
		/// <summary>
		/// 屬性 SecurityID
		/// </summary>
		public string SecurityID
		{
			get
			{
				return m_SecurityID;
			}
			set
			{
				m_SecurityID = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.Xt
{
	/// <summary>
	/// 實現對 Employee對象的管理
	/// </summary>
	
	class EmployeeMgr
	{

		/// <summary>
		///  根據主鍵標識獲得Employee對象
		/// </summary>
		/// <param name="EmplID">主鍵</param>
		
		public string GetUserMail(string user)
		{
			try
			{
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "SELECT Employees.EmplEmail AS EmplEmail "+ 
						"FROM Employees INNER JOIN  UserEmpl ON Employees.EmplID = UserEmpl.EmplID "+
						"WHERE UserEmpl.UserName =@user";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@user", user);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				dr.Read();
				
				string UserEmail = (string)dr["EmplEmail"];
				//dr.Close();
				cn.Close();
				return UserEmail;
			}
			catch(Exception e)
			{
				LogService.Write ("GetUserMail(string user)");
				LogService.Write (e.Message);
				return "";
			}
		}
		
	}
}
namespace Com.Ascs.Plp.Xt
{
	/// <summary>
	///  對象User的定義
	///  根據表 Users
	/// </summary>
	
	public class User
	{
		/// <summary>
		/// 對象User的構造函數
		/// </summary>
		public User()
		{
			m_UserName = "";
			m_UserPwd = "";
			m_UserCreateTime = DateTime.Now;
			m_UserLastLogon = DateTime.Now;
			m_UserLogonTimes = 0;
			m_UserTypeID = "";
		}
		
		private string m_UserName;
		private string m_UserPwd;
		private DateTime m_UserCreateTime;
		private DateTime m_UserLastLogon;
		private int m_UserLogonTimes;
		private string m_UserTypeID;
		
		/// <summary>
		/// 屬性 UserName
		/// </summary>
		public string UserName
		{
			get
			{
				return m_UserName;
			}
			set
			{
				m_UserName = value;
			}
		}
		
		/// <summary>
		/// 屬性 UserPwd
		/// </summary>
		public string UserPwd
		{
			get
			{
				return m_UserPwd;
			}
			set
			{
				m_UserPwd = value;
			}
		}
		
		/// <summary>
		/// 屬性 UserCreateTime
		/// </summary>
		public DateTime UserCreateTime
		{
			get
			{
				return m_UserCreateTime;
			}
			set
			{
				m_UserCreateTime = value;
			}
		}
		
		/// <summary>
		/// 屬性 UserLastLogon
		/// </summary>
		public DateTime UserLastLogon
		{
			get
			{
				return m_UserLastLogon;
			}
			set
			{
				m_UserLastLogon = value;
			}
		}
		
		/// <summary>
		/// 屬性 UserLogonTimes
		/// </summary>
		public int UserLogonTimes
		{
			get
			{
				return m_UserLogonTimes;
			}
			set
			{
				m_UserLogonTimes = value;
			}
		}
		
		/// <summary>
		/// 屬性 UserTypeID
		/// </summary>
		public string UserTypeID
		{
			get
			{
				return m_UserTypeID;
			}
			set
			{
				m_UserTypeID = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.Xt
{
	/// <summary>
	/// 實現對 User對象的管理
	/// </summary>
	
	class UserMgr
	{

		
		public User GetUser(string UserName)
		{
			try
			{
				User result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from Users where UserName=@UserName";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@UserName", UserName);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new User();
					if (dr["UserName"] != null)
						if (!System.DBNull.Equals(dr["UserName"], System.DBNull.Value))
							result.UserName = (string)dr["UserName"];
					if (dr["UserPwd"] != null)
						if (!System.DBNull.Equals(dr["UserPwd"], System.DBNull.Value))
							result.UserPwd = (string)dr["UserPwd"];
					if (dr["UserCreateTime"] != null)
						if (!System.DBNull.Equals(dr["UserCreateTime"], System.DBNull.Value))
							result.UserCreateTime = (DateTime)dr["UserCreateTime"];
					if (dr["UserLastLogon"] != null)
						if (!System.DBNull.Equals(dr["UserLastLogon"], System.DBNull.Value))
							result.UserLastLogon = (DateTime)dr["UserLastLogon"];
					if (dr["UserLogonTimes"] != null)
						if (!System.DBNull.Equals(dr["UserLogonTimes"], System.DBNull.Value))
							result.UserLogonTimes = (int)dr["UserLogonTimes"];
					if (dr["UserTypeID"] != null)
						if (!System.DBNull.Equals(dr["UserTypeID"], System.DBNull.Value))
							result.UserTypeID = (string)dr["UserTypeID"];
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("GetUser(string UserName)");
				LogService.Write (e.Message);
				return null;
			}
		}
	

	
	}
}