namespace DigitalLibrary
{
	using System;
	using System.Configuration;
	using System.Data;
	using System.Data.SqlClient;
	using System.Drawing;
	using System.Web;
	using System.Web.UI.WebControls;
	using System.Web.UI.HtmlControls;

	/// <summary>
	///		Summary description for PostComments.
	/// </summary>
	public class PostComments : System.Web.UI.UserControl
	{
		protected System.Web.UI.WebControls.TextBox txtComments;
		protected System.Web.UI.WebControls.Label lblMessage;
		protected System.Web.UI.WebControls.Button btnPost;

		private void Page_Load(object sender, System.EventArgs e)
		{
			// Put user code to initialize the page here
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		///		Required method for Designer support - do not modify
		///		the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{
			this.btnPost.Click += new System.EventHandler(this.btnPost_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void btnPost_Click(object sender, System.EventArgs e)
		{
			try
			{
				SqlConnection objConnection = new SqlConnection(ConfigurationSettings.AppSettings["DatabaseConnection"]);
				SqlCommand objCommand = new SqlCommand("INSERT INTO Comments VALUES ("+Request.QueryString.Get("ArticleID")+",'"+Request.QueryString.Get("LoginID")+"','"+this.txtComments.Text+"')",objConnection);
				objConnection.Open();
				objCommand.ExecuteNonQuery();
				objConnection.Close();
				Response.Redirect(ConfigurationSettings.AppSettings["ApplicationRoot"]+"Comments.aspx?ArticleID="+Request.QueryString.Get("ArticleID")+"&LoginID="+Request.QueryString.Get("LoginID"));
			}
			catch (Exception excep)
			{
				this.lblMessage.Text="記錄評論時(shí)出現(xiàn)錯(cuò)誤！！請重新嘗試";
				this.lblMessage.Visible = true;
			}
		}
	
		public String Comments 
		{
			get 
			{
				return txtComments.Text;
			}
			set 
			{
				txtComments.Text = value;
			}
		}



	}
}