?using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MyOnLineExam.BusinessLogicLayer;

public partial class Web_admin_SingleSelectAdd : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            InitDDLData();          //初始化考試科目下拉列表框          
            if (Request["ID"]!=null)//如果是修改題目，初始化數據
            {
                InitData();
            }
        }
    }
    //初始化考試科目
    protected void InitDDLData()
    {
        Course course = new Course();       //創建考試科目對象
        DataSet ds = course.QueryCourse();  //查詢考試科目信息
        ddlCourse.DataSource = ds;          //指名考試科目列表框數據源
        ddlCourse.DataTextField = "Name";   //DataTextField顯示Name字段值
        ddlCourse.DataValueField = "ID";    //DataValueField顯示ID字段值
        ddlCourse.DataBind();               //綁定數據
    }
    //初始化數據
    protected void InitData()
    {
        int SingleProblemID = int.Parse(Request["ID"].ToString());  //取出傳遞過來的試題編號
        SingleProblem singleproblem = new SingleProblem();          //創建單選題對象
        if (singleproblem.LoadData(SingleProblemID))                //如果取出題目信息，分別放在相應控件顯示
        {
            ddlCourse.SelectedValue = singleproblem.CourseID.ToString();
            txtTitle.Text = singleproblem.Title;
            txtAnswerA.Text = singleproblem.AnswerA;
            txtAnswerB.Text = singleproblem.AnswerB;
            txtAnswerC.Text = singleproblem.AnswerC;
            txtAnswerD.Text = singleproblem.AnswerD;
            ddlAnswer.SelectedItem.Text = singleproblem.Answer;
        }
        else                //查詢出錯，給出提示
        {
            lblMessage.Text = "加載數據出錯！";
        }        
    }

    //添加或修改事件
    protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
    {
        if (Page.IsValid)
        {
            SingleProblem singleproblem = new SingleProblem();          //創建單選題對象
            singleproblem.CourseID = int.Parse(ddlCourse.SelectedValue);//為單選題對象各屬性賦值
            singleproblem.Title = txtTitle.Text;
            singleproblem.AnswerA = txtAnswerA.Text;
            singleproblem.AnswerB = txtAnswerB.Text;
            singleproblem.AnswerC = txtAnswerC.Text;
            singleproblem.AnswerD = txtAnswerD.Text;
            singleproblem.Answer = ddlAnswer.SelectedItem.Text;
            if (Request["ID"] != null)                                  //如果是修改題目信息
            {
                singleproblem.ID = int.Parse(Request["ID"].ToString()); //取出試題主鍵
                if (singleproblem.UpdateByProc(int.Parse(Request["ID"].ToString())))//調用修改試題方法修改試題
                {
                    lblMessage.Text = "成功修改該單選題！";
                }
                else
                {
                    lblMessage.Text = "修改該單選題失敗！";
                }
            }
            else                                                        //如果是添加試題
            {
                if (singleproblem.InsertByProc())                       //調用添加試題方法添加試題
                {
                    lblMessage.Text = "成功添加該單選題！";
                }
                else
                {
                    lblMessage.Text = "添加該單選題失?。?quot;;
                }
            }                    
        }
    }
}