using System;
using System.Data ;
using System.Data .OleDb ;
using System.Collections ;
using System.Windows .Forms ;
namespace MailManageSystem.RegisterAccount
{
	/// <summary>
	/// AccountOperate 的摘要說明。
	/// </summary>
	public class AccountOperate
	{
		//定義一個連接數據庫的字符串
		string conn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Application.StartupPath+"\\Manage.mdb";

		public AccountOperate()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//
		}

		/// <summary>
		/// 向數據庫中插入數據
		/// </summary>
		/// <param name="insert"></param>

		public void AddDelAccount(string insert)
		{
			OleDbConnection myconn=new OleDbConnection (conn);
			myconn.Open ();
			OleDbCommand cmd=new OleDbCommand(insert,myconn);
			try
			{
				cmd.ExecuteNonQuery ();
			}
			catch(Exception ex)
			{
				MessageBox.Show (ex.ToString ());
			}
			finally
			{
				myconn.Close ();
			}
		}

		/// <summary>
		/// 選中的帳戶的相關信息
		/// </summary>
		/// <param name="sql">選擇的語句</param>
		/// <returns></returns>
		public string[] AccountFileInfo(string sql)
		{
			string []AccountInfo=new string [5];
			OleDbConnection myconn=new OleDbConnection (conn);
			myconn.Open ();
			try
			{
				OleDbCommand mycmd=new OleDbCommand(sql,myconn);
				OleDbDataReader myread=mycmd.ExecuteReader ();
				while(myread.Read ())
				{
					AccountInfo[0]=myread["UserName"].ToString ();
					AccountInfo[1]=myread["Passw"].ToString ();
					AccountInfo[2]=myread["MailAddress"].ToString ();
					AccountInfo[3]=myread["Smtp"].ToString ();
					AccountInfo[4]=myread["port"].ToString ();
				}
				
			}
			catch(Exception ex)
			{
				MessageBox.Show (ex.ToString ());
			}
			finally
			{
				myconn.Close ();
			}
			return AccountInfo;
		}

		/// <summary>
		/// 從數據庫中讀出需要的數據(主要用于顯示所有的帳戶)
		/// </summary>
		/// <param name="sql">執行的語句</param>
		/// <returns></returns>

		public ArrayList ReadFromDataBase(string sql,string parameter)
		{
			ArrayList array=new ArrayList ();
			OleDbConnection myconn=new OleDbConnection (conn);
			myconn.Open ();
			try
			{
				OleDbCommand mycmd=new OleDbCommand(sql,myconn);
				OleDbDataReader myread=mycmd.ExecuteReader ();
				while(myread.Read ())
				{
					array.Add (myread[parameter]);
				}
				
			}
			catch(Exception ex)
			{
				MessageBox.Show (ex.ToString ());
			}
			finally
			{
				myconn.Close ();
			}
			return array;
		}

		/// <summary>
		/// 此函數的作用是來判斷用戶名是否已經被使用，調用的方法是通過Sql語句，以及一個字符串變量
		/// </summary>
		/// <param name="sql"></param>
		/// <param name="username"></param>
		/// <returns></returns>
		
		public bool CheckAccount(string sql,string username)
		{
			// 設置標志位用來標識是否被使用
			
			
			bool state=false;
			OleDbConnection myconn=new OleDbConnection (conn);
			myconn.Open ();
			OleDbCommand cmd2=new OleDbCommand(sql,myconn);
			OleDbDataReader myread=cmd2.ExecuteReader ();
			
			if(username!="")
			{
				try
				{
					while(myread.Read ())
					{
						//讀取用戶名來和用戶輸入的注冊名匹配,如果匹配設置標志位為真
						if(myread.GetString (0).Trim()==username)
						{
							state=true;
							break;
						}
		
					}
				}
				catch(Exception E)
				{
					Console.WriteLine (E.ToString ());
				}
				finally
				{
					myread.Close ();
					myconn.Close ();
				}
			}	
			return state;
		}
	}
}