using System;
using System.Collections;
using System.ComponentModel;
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.Data.SqlClient ;
using System.Configuration;
namespace WebNews.admin
{
	/// <summary>
	/// admin_userAdd 的摘要說明。
	/// </summary>
	public class admin_userAdd : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label myLabel;
		protected System.Web.UI.WebControls.TextBox Username;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator;
		protected System.Web.UI.WebControls.TextBox Password;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
		protected System.Web.UI.WebControls.TextBox Password1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
		protected System.Web.UI.WebControls.CompareValidator CompareValidator1;
		protected System.Web.UI.WebControls.DropDownList UserClass;
		protected System.Web.UI.WebControls.TextBox Remarks;
		protected System.Web.UI.WebControls.Button Submit;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此處放置用戶代碼以初始化頁面
			if(! Page.IsPostBack)
			{
				string userclass;
				userclass=(string)Session["userclass"];
				if(userclass.Trim()!="系統(tǒng)管理員")
				{
					   Page.Visible=false;
				}
				
			}
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：該調(diào)用是 ASP.NET Web 窗體設計器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內(nèi)容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Submit.Click += new System.EventHandler(this.Submit_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Submit_Click(object sender, System.EventArgs e)
		{
			if(Page.IsValid )
			{
				addAdminUser();
			}
		}
		private void addAdminUser()
		{
			string con=ConfigurationSettings.AppSettings["dsn"];	//取得DSN字符
			
			SqlConnection myConnection = new SqlConnection(con);//連接字符串
			myConnection.Open();									 //連接數(shù)據(jù)庫
		　　	
			SqlCommand selAdmin=new SqlCommand("sp_addAdminValidate",myConnection);	 //驗證是否已有此管理員名
			selAdmin.CommandType=CommandType.StoredProcedure;
			
			SqlParameter sel=selAdmin.Parameters.Add("@username",SqlDbType.Char,40);
			sel.Value=Username.Text.Trim() ;
			
			SqlDataReader  readAdmin=selAdmin.ExecuteReader();
			
			if(readAdmin.Read()==true)
			{
				myLabel.Text="已有此管理員，請重新輸入姓名！！" ;
				readAdmin.Close();
				myConnection.Close();//關(guān)閉連接
			
				
			}
			else 
			{
				try
				{
					readAdmin.Close();　
					SqlCommand cd=new SqlCommand("sp_addAdmin",myConnection);	//設置SQL命令
					cd.CommandType=CommandType.StoredProcedure;	　　//調(diào)用存儲過程

					SqlParameter username= cd.Parameters.Add("@username", SqlDbType.Char,40);		  //設置存儲過程參數(shù)
					SqlParameter password=cd.Parameters.Add("@password",SqlDbType.Char,40);
					SqlParameter userclass=cd.Parameters.Add("@userclass",SqlDbType.Char,20);
					SqlParameter remark=cd.Parameters.Add("@remark",SqlDbType.NChar,200);

					username.Value=Username.Text.Trim();
					password.Value=Password.Text.Trim();
					userclass.Value=UserClass.SelectedItem.Text.Trim(); 
					remark.Value=Remarks.Text.Trim();
					int se=cd.ExecuteNonQuery() ;				   //增加一個新管理員
				 
					//驗證
					
					myLabel.Text="添加管理員成功！";
					myConnection.Close();//關(guān)閉連接
				}
				catch(SqlException e)
				{
					Console.WriteLine("Exception in Main: " + e.Message);	//出錯處理
				}
			}

		}

	

	}
}