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;

namespace vote
{
	/// <summary>
	/// _default 的摘要說明。
	/// </summary>
	public class savevote : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Button Button2;
		protected System.Web.UI.WebControls.RadioButtonList votetype;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.TextBox vote;
		public string vote_1;
		protected System.Web.UI.WebControls.RequiredFieldValidator IsnullTextbox;
		public string votenum;
		private void Page_Load(object sender, System.EventArgs e)
		{

		 }
			// 在此處放置用戶代碼以初始化頁面
			private void Button1_Click(object sender, System.EventArgs e)
			{
				string vote_num,votetype,votename;
				vote_num="10";
				votetype=Request.Form["votetype"];
				votename=Request.Form["vote"];
				votename=votename.Replace("'","");
				int i;
				int k;
				string [] vote = System.Text.RegularExpressions.Regex.Split (votename,"\r\n");
				int j=0;
				for( i = 0; i< vote.Length-1;i++)
				{

					if (!(vote[i]=="" || vote[i]==" "))
					{
						vote_1=""+vote_1+""+vote[i]+"|";
						j=j+1;
					}
					if (i>Convert.ToInt32(vote_num)-1)
					{
						break;
					}

				}
				for( k=0;k<j;k++)
				{
					votenum=""+votenum+"0|";
				}
				int votelen=vote_1.Length;
				int votenumlen=votenum.Length;
				votenum=votenum.Substring(0,votenumlen-1);
				votename=vote_1.Substring(0,votelen-1);
				string strconn="provider=Microsoft.jet.OLEDB.4.0;data Source="+Server.MapPath("vote.Mdb")+";";
				string strsql="insert into vote(vote,votenum,votetype) values('"+votename+"','"+votenum+"',"+Convert.ToInt32(votetype)+")";
				OleDbConnection myConnection = new OleDbConnection(strconn);
				OleDbCommand myCommand = new OleDbCommand(strsql, myConnection);
				myConnection.Open();
				myCommand.ExecuteNonQuery();
				myCommand.Dispose();
				myConnection.Close();
				Label1.Visible=true;
				Button2.Visible =true;
			}
	
		private void Button2_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("vote.aspx");

		}

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

		}
		#endregion
	}

}