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>
	/// courseView 的摘要說明。
	/// </summary>
	public class courseView : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label lbl_courseId;
		protected System.Web.UI.WebControls.CheckBox cbx_isTest;
		protected System.Web.UI.WebControls.ImageButton Ibtn_ok;
		protected System.Web.UI.WebControls.ImageButton Ibtn_save;
		protected System.Web.UI.WebControls.TextBox tbx_courseName;
		protected System.Web.UI.WebControls.TextBox tbx_addCourseId;
		protected System.Web.UI.WebControls.TextBox tbx_addCourseName;
		protected System.Web.UI.WebControls.ImageButton Ibtn_delete;
		protected System.Web.UI.WebControls.Label lbl_teacherName;
		protected System.Web.UI.WebControls.ListBox ListBox1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此處放置用戶代碼以初始化頁面
			Ibtn_delete.Attributes.Add("OnClick","return confirm('你確定要刪除這門課程嗎？');");
			if(Session["adminId"]!=null)
			{
					if(!Page.IsPostBack)
			 {
				 DataSet ds=new DataSet();
				 ds=(new projClass()).getCourses();
				 foreach(DataRow row in ds.Tables[0].Rows)
				 {
						 ListBox1.Items.Add(row["courseName"].ToString());
				 }
			 }
				
			}else Response.Redirect("login.aspx");
		}

		#region Web 窗體設計器生成的代碼
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 該調用是 ASP.NET Web 窗體設計器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.ListBox1.SelectedIndexChanged += new System.EventHandler(this.ListBox1_SelectedIndexChanged);
			this.Ibtn_save.Click += new System.Web.UI.ImageClickEventHandler(this.Ibtn_save_Click);
			this.Ibtn_delete.Click += new System.Web.UI.ImageClickEventHandler(this.Ibtn_delete_Click);
			this.Ibtn_ok.Click += new System.Web.UI.ImageClickEventHandler(this.Ibtn_ok_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void ListBox1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			string courseId;
			string courseName=ListBox1.SelectedItem.Text;
			tbx_courseName.Text=courseName;
			courseId=(new projClass()).getCourseIdAsCourseName(courseName);
			lbl_courseId.Text=courseId;
            string teacherName=(new projClass()).getTeacherIdAsCourseId(courseId);
			lbl_teacherName.Text=teacherName;
			bool isTest;
			isTest=(new projClass()).getIsTestAsCourseId(courseId);
			if(isTest)
				cbx_isTest.Checked=true;
			else cbx_isTest.Checked=false;

		}

		private void Ibtn_save_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
        //  Response.Write("<script>alert(\"safddsfdsaf\");</script>");
			if(ListBox1.SelectedIndex==-1)
				Response.Write("<script>alert(\"請選擇一門科目!\");</script>");
			else
			{
				string courseId=lbl_courseId.Text.Trim();
				string courseName=tbx_courseName.Text.Trim();
				
					bool isTest=cbx_isTest.Checked;
					int count=(new projClass()).updateCourseInfo(courseId,courseName,isTest);
			
					if(count==1)
					{
					
						if(isTest)
							Response.Write("<script>alert(\"保存成功!這門課可以進入考試!\");</script>");
						else 
							Response.Write("<script>alert(\"保存成功!這門課將不能進入考試!\");</script>");
					}
					else 	Response.Write("<script>alert(\"保存失敗!\");</script>");
					Response.Redirect("courseView.aspx");
				}
			

		}

		private void Ibtn_ok_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			string courseId=tbx_addCourseId.Text.Trim();
			string courseName=tbx_addCourseName.Text.Trim();
			if(courseId==""||courseName=="")
				Response.Write("<script>alert(\"請輸入完整內容！\");</script>");
			else
			{
				int exist=(new projClass()).ifCourseExist(courseId,courseName);
				if(exist==1)
					Response.Write("<script>alert(\"請不要輸入重復的課程名稱或課程ID!\");</script>");
				else
				{
					int count=(new projClass()).insertCourseInfo(courseId,courseName,false);
					if(count==0)
						Response.Write("<script>alert(\"插入失??！\");</script>");
					Response.Redirect("courseView.aspx");
				}
			}
		}

		private void Ibtn_delete_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			if(ListBox1.SelectedIndex==-1)
				Response.Write("<script>alert(\"請選擇一門科目!\");</script>");
			else
			{
				string courseId=lbl_courseId.Text.Trim();
				int count=(new projClass()).deleteCourseInfo(courseId);
				if(count==0)
					Response.Write("<script>alert(\"刪除失??！\");</script>");
	
				Response.Redirect("courseView.aspx");
			}
		}

		
		
	}
}