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;

namespace OLTest
{
	/// <summary>
	/// Post 的摘要說明。
	/// </summary>
	public class Post : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Button Button2;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Web.UI.WebControls.Label Label1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此處放置用戶代碼以初始化頁面
			HyperLink1.Visible=false;
			
		}

		#region Web 窗體設計器生成的代碼
		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

		private void Button1_Click(object sender, System.EventArgs e)
		{
			int Score=0;
			
			string cn="server=.;uid=sa;database=nTest";
			SqlDataAdapter da=new SqlDataAdapter("Select * from Stu where StuNo='"+Session["StuNo"].ToString().TrimEnd()+"'",cn);
			DataSet ds=new DataSet();
			da.Fill(ds);
			DataRow dr=ds.Tables[0].Rows[0];
			
			string cn1="server=.;uid=sa;database=nTest";
			SqlDataAdapter da1=new SqlDataAdapter("Select * from Question",cn1);
			DataSet ds1=new DataSet();
			da1.Fill(ds1);

			string[] temp=Session["Num"].ToString().Split(',');
			string[] Answer=Session["uAnswer"].ToString().TrimEnd(',').Split(',');
			
//			Label1.Text=Answer[0];
//			Label2.Text=ds1.Tables[0].Rows[Convert.ToInt32(temp[0])-1]["Answer"].ToString();

			for (int i=0;i<10;i++)
			{
			  DataRow dr1=ds1.Tables[0].Rows[Convert.ToInt32(temp[i])-1];
			
				if(Answer[i]==dr1["Answer"].ToString().TrimEnd())
				{
					Score=Score+10;
					
				}
				else
				{}
			}
			
			try 
			{
				SqlCommandBuilder scb=new SqlCommandBuilder(da);
				dr.BeginEdit();
				dr["QuestNum"]=Session["Num"].ToString();
				dr["Answer"]=Session["uAnswer"].ToString().TrimEnd(',');
				dr["Score"]=Score;
				dr.EndEdit();
				da.Update(ds);
				ds.AcceptChanges();

				this.Response.Redirect("Finish.aspx");
			}
			catch
			{
				ds.RejectChanges();
				HyperLink1.Visible=true;
			 Label2.Text="試卷提交失敗!請點擊下面的連接重新提交!";
			}
			
		}

		private void Button2_Click(object sender, System.EventArgs e)
		{
			this.Response.Redirect("OverLook.aspx");
		}

		
	}
}