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.Data.SqlClient;
using System.Web.UI.HtmlControls;

namespace AddQuestions
{
	/// <summary>
	/// WebForm1 的摘要說明。
	/// </summary>
	public class WebForm1 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.Label Label7;
		protected System.Web.UI.WebControls.Label Label8;
		protected System.Web.UI.WebControls.Label Label9;
		protected System.Web.UI.WebControls.TextBox txtTitle;
		protected System.Web.UI.WebControls.DropDownList ddlSemester;
		protected System.Web.UI.WebControls.DropDownList ddlCourseID;
		protected System.Web.UI.WebControls.TextBox txtA;
		protected System.Web.UI.WebControls.TextBox txtB;
		protected System.Web.UI.WebControls.TextBox txtC;
		protected System.Web.UI.WebControls.TextBox txtD;
		protected System.Web.UI.WebControls.DropDownList ddlAnswer;
		protected System.Web.UI.WebControls.Button btnAdd;
		protected System.Web.UI.WebControls.Label lblMessage;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator5;
		protected System.Web.UI.WebControls.Label Label1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!Page.IsPostBack)//回發
			{
				
			}// 在此處放置用戶代碼以初始化頁面
		}

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

		}
		#endregion

		private void btnAdd_Click(object sender, System.EventArgs e)
		{
			System.Data.SqlClient.SqlConnection con=new SqlConnection("server=.;uid=sa;pwd=sasa;database=T19_rhm");//數據庫連接
			string course=this.ddlSemester.SelectedValue;//等到文本框的值
			int courseid=Convert.ToInt32(course);//強制轉換為INT型
			string title=this.txtTitle.Text;
			string a=this.txtA.Text;
			string b=this.txtB.Text;
			string c=this.txtC.Text;
			string d=this.txtD.Text;
			string Answer=this.ddlAnswer.SelectedValue;
			try
			{
				con.Open();
				System.Data.SqlClient.SqlCommand com=new SqlCommand("insert into Question (CourseID,Title,OptionA,OptionB,OptionC,OptionD,Answer) values("+courseid+",'"+title+"','"+a+"','"+b+"','"+c+"','"+d+"','"+Answer+"')",
					con);//執行插入操作
				com.ExecuteNonQuery();
				this.txtA.Text="";//清空文本框
				this.txtB.Text="";
				this.txtC.Text="";
				this.txtD.Text="";
				this.txtTitle.Text="";
				this.lblMessage.Text="添加題目完畢";//顯示操作信息
				this.btnAdd.Text="繼續保存";
			}
			catch(Exception ex)
			{
				throw(ex);
			}
			finally{
				con.Close();//關閉數據庫
			}
			
		}
		public  void getCourse(int id){//獲取科目名稱
			System.Data.SqlClient.SqlConnection con=new SqlConnection("server=.;uid=sa;pwd=sasa;database=T19_rhm");
			try
			{
				con.Open();
				System.Data.SqlClient.SqlDataAdapter da=new SqlDataAdapter("select * from course where CourseID="+id+"",con);//根據學期的values
																															//值查詢出這條科目信息
				System.Data.DataSet ds=new DataSet();
				da.Fill(ds,"course");//填充DataSet
				this.ddlCourseID.DataTextField="courseName";//填充文本值是courseName
				this.ddlCourseID.DataValueField="courseID";//填充values值是courseName
				this.ddlCourseID.DataSource=ds.Tables[0].DefaultView;
				this.ddlCourseID.DataBind();//拌定到下拉框
			}
			catch(Exception ex)
			{
				throw(ex);
			}
			finally{
				con.Close();//關閉數據庫
			}
			
		}

		private void ddlSemester_SelectedIndexChanged(object sender, System.EventArgs e)//根據學期選擇 得到相應的科目
		{
			string var=this.ddlSemester.SelectedValue;//得到values值
			int id=Convert.ToInt32(var);//轉換為INT型
			this.getCourse(id);//調用帶參數的方法獲取科目名稱
		}


		

	}
}