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.OleDb;
using System.Configuration;

namespace MyBlog
{
	/// <summary>
	/// linkManage 的摘要說明。
	/// </summary>
	public partial class linkManage : System.Web.UI.Page
	{

		private void BindGrid(System.Web.UI.WebControls.DataGrid DataGrid, String strValue)
		{
			String strConn = ConfigurationSettings.AppSettings["webblog"] + Server.MapPath("WebBlog.mdb");
			OleDbConnection cn = new OleDbConnection();
			cn.ConnectionString = strConn;

			OleDbDataAdapter myCommand = new OleDbDataAdapter(strValue, cn);
			DataSet ds = new DataSet();
			myCommand.Fill(ds, "link");

			DataGrid.DataSource = ds.Tables["link"].DefaultView;
			DataGrid.DataBind();
			
		}
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此處放置用戶代碼以初始化頁面
			if(!IsPostBack)
			{
				if((bool)Session["pwd"] == false)
					Response.Redirect("codeReq.aspx");
				String strValue = "select * from link ";
				BindGrid(managerDataGrid, strValue);
			}
		}

		#region Web 窗體設計器生成的代碼
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 該調用是 ASP.NET Web 窗體設計器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.managerDataGrid.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.managerDataGrid_DeleteCommand);

		}
		#endregion


		protected void Add_Click(object sender, System.EventArgs e)
		{
			String insertCmd = "insert into link(linkName, linkUrl) values(@linkName, @linkUrl)";
			String strConn = ConfigurationSettings.AppSettings["webblog"] + Server.MapPath("WebBlog.mdb");
			OleDbConnection cn = new OleDbConnection();
			cn.ConnectionString = strConn;
			OleDbCommand myCommand = new OleDbCommand(insertCmd, cn);
			myCommand.Parameters.Add(new OleDbParameter("@linkName", OleDbType.VarChar, 23));
			myCommand.Parameters["@linkName"].Value = linkName.Text;
			myCommand.Parameters.Add(new OleDbParameter("@linkUrl", OleDbType.VarChar, 50));
			myCommand.Parameters["@linkUrl"].Value = linkUrl.Text;
			cn.Open();
			try
			{
				myCommand.ExecuteNonQuery();
				Message.Text = "添加成功";
			}
			catch(System.Data.OleDb.OleDbException)
			{
				Message.Text ="出錯了";
			}
			cn.Close();
			String strValue = "select * from link";
			BindGrid(managerDataGrid, strValue);
		}

		private void managerDataGrid_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			try
			{
				String deleteCmd = "delete from link where linkID = @linkID";
				String strConn = ConfigurationSettings.AppSettings["webblog"] + Server.MapPath("WebBlog.mdb");
				OleDbConnection cn = new OleDbConnection();
				cn.ConnectionString = strConn;
				OleDbCommand myCommand = new OleDbCommand(deleteCmd, cn);
				myCommand.Parameters.Add(new OleDbParameter("@linkID", OleDbType.VarChar, 38));
				myCommand.Parameters["@linkID"].Value = managerDataGrid.DataKeys[e.Item.ItemIndex].ToString();
				cn.Open();
				try
				{
					myCommand.ExecuteNonQuery();
					Message.Text = "刪除成功";
				}
				catch(System.Data.OleDb.OleDbException)
				{
					Message.Text ="出錯了";
				}
				cn.Close();
				String strValue = "select * from link ";
				BindGrid(managerDataGrid, strValue);
			}
			catch(System.Data.OleDb.OleDbException)
			{
				Message.Text ="出錯了";
			}
		}
	}
}