using System;
using System.Configuration;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
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.Web.Security;

namespace DigitalLibrary
{
	/// <summary>
	/// Summary description for WebForm1.
	/// </summary>
	public class Home : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label lblTitle;
		protected System.Web.UI.HtmlControls.HtmlGenericControl DIV1;
		protected System.Web.UI.WebControls.HyperLink hlUser;
		protected System.Web.UI.WebControls.HyperLink hlMember;
		protected System.Web.UI.WebControls.Image imgImage1;
		protected System.Web.UI.WebControls.Button btnUsers;
		protected System.Web.UI.WebControls.TextBox txtLoginID;
		protected System.Web.UI.WebControls.Button btnMembers;
		protected System.Web.UI.WebControls.Label lblTime;
		protected System.Web.UI.HtmlControls.HtmlInputText txtPassword;
		protected System.Web.UI.WebControls.RequiredFieldValidator rfvLogin;
		protected System.Web.UI.WebControls.RequiredFieldValidator rfvPassword;
		protected System.Web.UI.WebControls.Panel Panel1;
		protected System.Web.UI.WebControls.Label lblMessage;
		protected System.Web.UI.WebControls.Panel LoginPanel;
			
		#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.btnUsers.Click += new System.EventHandler(this.btnUsers_Click);
			this.btnMembers.Click += new System.EventHandler(this.btnMembers_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

//		<asp:RequiredFieldValidator id="rfvLogin" runat="server" Display="Dynamic" ControlToValidate="txtLoginID" ErrorMessage="Enter Login "></asp:RequiredFieldValidator>
//		<asp:RequiredFieldValidator id="rfvPassword" runat="server" Display="Dynamic" ControlToValidate="txtPassword"
//		ErrorMessage="Enter password"></asp:RequiredFieldValidator></P>


		private void btnUsers_Click(object sender, System.EventArgs e)
		{
					
			if ((this.txtLoginID.Text == "Admin") && (this.txtPassword.Value == "admin")) 
			{
				Session["Login"] = this.txtLoginID.Text;
				FormsAuthentication.RedirectFromLoginPage(this.txtLoginID.Text,false);
			}
			else 
			{
				SqlConnection objConnection = new SqlConnection(ConfigurationSettings.AppSettings["DatabaseConnection"]);
				SqlDataAdapter objAdapter = new SqlDataAdapter("SELECT * FROM Users WHERE LoginID = '" + txtLoginID.Text + "' AND Password = '" + txtPassword.Value  + "'",objConnection);
				DataSet objDataSet = new DataSet();
				objAdapter.Fill(objDataSet,"UserCheck");
				if (objDataSet.Tables["UserCheck"].Rows.Count == 0)
				{
					this.lblMessage.Text = "ID 不存在或密碼錯誤!!! 請輸入正確的 ID 和密碼!";
					this.lblMessage.Visible=true;
				}
				else
				{
					Session["Login"] = this.txtLoginID.Text;
					FormsAuthentication.RedirectFromLoginPage(this.txtLoginID.Text,true);
				}
			}
		}

		protected String GetStyle(String key) 
		{
			return Session[key].ToString();       
		}

		private void btnMembers_Click(object sender, System.EventArgs e)
		{
		
			if ((this.txtLoginID.Text == "Admin") && 
				(this.txtPassword.Value == "admin")) 
			{
				Session["Login"] = this.txtLoginID.Text;
				FormsAuthentication.RedirectFromLoginPage
					(this.txtLoginID.Text,false);
			}
			else 
			{
				
				SqlConnection objConnection = new SqlConnection(ConfigurationSettings.AppSettings["DatabaseConnection"]);
				SqlDataAdapter objAdapter = new SqlDataAdapter("SELECT * FROM Members WHERE MemberID = '" + this.txtLoginID.Text + "' AND Password = '" + this.txtPassword.Value + "'",objConnection);
				DataSet objDataSet = new DataSet();
				objAdapter.Fill(objDataSet,"MemberCheck");
				if (objDataSet.Tables["MemberCheck"].Rows.Count == 0)
				{
					this.lblMessage.Text = "ID Does not exist or Password is wrong!!! Please enter the correct ID and Password.!";
					this.lblMessage.Visible=true;
					this.txtLoginID.Text="";
					this.txtPassword.Value="";
				}
				else
				{
					Session["Login"] = this.txtLoginID.Text;
					FormsAuthentication.RedirectFromLoginPage(this.txtLoginID.Text,false);
				}
			}
		}

		private void Page_Load(object sender, System.EventArgs e)
		{
			
			if (Convert.ToBoolean(Session["IEorNot"])==false)
				this.Page.Visible = false;

			Server.Execute("Visitor.aspx");
			this.lblTime.Text=DateTime.Now.TimeOfDay.ToString();
			

		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("Sample.aspx");
		}

	}
}