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;

namespace TestOnline
{
	/// <summary>
	/// testResult 的摘要說明。
	/// </summary>
	public class testResult : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.ImageButton ImageButton1;
		protected System.Web.UI.WebControls.Label lbl_count;
		protected System.Web.UI.WebControls.DropDownList ddl_stu;
		protected System.Web.UI.WebControls.DropDownList ddl_course;
		protected System.Web.UI.WebControls.TextBox tbx_stu;
		protected System.Web.UI.WebControls.Label lbl_noResult;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此處放置用戶代碼以初始化頁面
			if(Session["adminId"]==null)
			{
			Response.Redirect("login.aspx");
			}else
			if(!Page.IsPostBack)
			{
				
				ddl_course.Items.Add("所有科目");
				DataSet ds=new DataSet();
				ds=(new projClass()).getCourses();
				foreach(DataRow row in ds.Tables[0].Rows)
				{
					ddl_course.Items.Add(row["courseName"].ToString());
				}
				BindGrid();
			}
		}

		#region Web 窗體設計器生成的代碼
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 該調用是 ASP.NET Web 窗體設計器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.ImageButton1.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton1_Click);
			this.DataGrid1.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemCreated);
			this.DataGrid1.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_CancelCommand);
			this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_EditCommand);
			this.DataGrid1.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_UpdateCommand);
			this.DataGrid1.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_DeleteCommand);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
		void BindGrid() 
		{   
			DataSet ds=new DataSet();
			ds=(new projClass()).getScoreAsStuIdAndCourseId();
			DataTable dt=ds.Tables["scoreInfo"];
			DataView dv=new DataView(dt);
			
			if(!(ddl_course.SelectedItem.Text=="所有科目"))
			{
				if(ddl_stu.SelectedItem.Text=="學號") 
					dv.RowFilter="courseName like '%"+ddl_course.SelectedItem.Text+"%' and stuId like '%"+tbx_stu.Text.Trim()+"%'";
				else dv.RowFilter="courseName like '%"+ddl_course.SelectedItem.Text+"%' and stuName like '%"+tbx_stu.Text.Trim()+"%'";
			} 
			else
			{
					if(ddl_stu.SelectedItem.Text=="學號") 
					dv.RowFilter="stuId like '%"+tbx_stu.Text.Trim()+"%'";
				else dv.RowFilter="stuName like '%"+tbx_stu.Text.Trim()+"%'";
			}
			DataGrid1.DataSource=dv;
			lbl_count.Text=dv.Count.ToString();
			if(dv.Count==0)
			{
				lbl_noResult.Visible=true;
				DataGrid1.Visible=false;
			}
			else
			{
				lbl_noResult.Visible=false;
				DataGrid1.Visible=true;
			}
			DataGrid1.DataBind();
		}

		private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			
			BindGrid();
		}

		private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			DataGrid1.CurrentPageIndex=e.NewPageIndex;
			BindGrid();
		}

		private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string stuId=e.Item.Cells[0].Text;
			string courseName=e.Item.Cells[2].Text;
			string courseId=(new projClass()).getCourseIdAsCourseName(courseName);
			int count=(new projClass()).deleteScoreInfo(stuId,courseId);
			if(count==0)
				Response.Write("<script>alert(\"刪除失?。");</script>");
			else Response.Write("<script>alert(\"刪除成功！\");</script>");
			BindGrid();

		}

		private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
		  DataGrid1.EditItemIndex=-1;
			BindGrid();
		}

		private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			DataGrid1.EditItemIndex=e.Item.ItemIndex;
			BindGrid();
		}

		private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
		 
			TextBox tbx_score = (TextBox)e.Item.Cells[3].Controls[0];
			string stuId=e.Item.Cells[0].Text.Trim();
			string score=tbx_score.Text.Trim();
			bool isnum=IsNum(score);
			if(isnum)
			{
				int stuScore=Convert.ToInt32(score);
				string courseName=e.Item.Cells[2].Text;
				string courseId=(new projClass()).getCourseIdAsCourseName(courseName);
				int count=(new projClass()).updateScore(stuId,courseId,1,stuScore);
				if(count==0)
					Response.Write("<script>alert(\"更新失??！\");</script>");
				DataGrid1.EditItemIndex=-1;
				BindGrid();
			}else Response.Write("<script>alert('您輸入的不是數字!請重新輸入');</script>");

		}
		public static bool IsNum(string str)
		{
			for(int i=0;i<str.Length;i++)
			{
				if(str[i]<'0' || str[i]>'9')
					return false;
			}
			return true;
		}



		private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

		private void DataGrid1_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			switch(e.Item.ItemType)
			{
				case ListItemType.Item:
				case ListItemType.AlternatingItem:
				case ListItemType.EditItem:
				{

					LinkButton btnDelete=(LinkButton)e.Item.FindControl("btn_del");

					btnDelete.Attributes.Add("onclick", "return confirm('你是否確定刪除?');");
					break;
				}
			}

		}

		

		
	}
}