?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;

public partial class teacherShowDuoXuan : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["teacherId"] == null)
        {
            Response.Redirect("Default.aspx");
        }
        else
            if (!Page.IsPostBack)
            {
                string teacherId = Convert.ToString(Session["teacherId"]);
                string courseId = (new projClass()).getTeacherCourseId(teacherId);
                Session["courseId"] = courseId;
                string courseName = (new projClass()).getCourseNameAsCourseId(courseId);
                lbl_courseName.Text = courseName;

                bool isTest;
                isTest = (new projClass()).getIsTestAsCourseId(courseId);
                if (isTest)
                    cbx_isTest.Checked = true;
                else cbx_isTest.Checked = false;
                BindGrid();
            }
    }
    void BindGrid()
    {
        string teacherId = Convert.ToString(Session["teacherId"]);
        string courseId = (new projClass()).getTeacherCourseId(teacherId);
        DataSet ds = new DataSet();
        ds = (new projClass()).getTestDuoXuanShow(courseId);
        DataTable dt = ds.Tables["testInfo"];
        DataView dv = new DataView(dt);
        if (rbtn_showall.Checked)
        {
            if (tbx_query1.Text.Trim() != "")
                dv.RowFilter = "testContent like '%" + tbx_query1.Text.Trim() + "%'";
        }
        else if (rbtn_showpub.Checked)
            dv.RowFilter = "pub like '是' and testContent like '%" + tbx_query1.Text.Trim() + "%' ";
        else if (rbtn_shownopub.Checked)
            dv.RowFilter = "pub like '否' and testContent like '%" + tbx_query1.Text.Trim() + "%'";
        this.GridView1.DataSource = dv;
        //lbl_count.Text = dv.Count.ToString();
        if (dv.Count == 0)
        {
            lbl_noResult.Visible = true;
            this.GridView1.Visible = false;
        }
        else
        {
            lbl_noResult.Visible = false;
            this.GridView1.Visible = true;
        }
        this.GridView1.DataBind();
    }
    
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string testId = GridView1.DataKeys[e.RowIndex].Value.ToString();
        int deletTest = (new projClass()).deleteTestDuoXuanInfo(testId);
        BindGrid();
    }
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Detail")
        {
            int index = Convert.ToInt32(e.CommandArgument);
            DataKey key = GridView1.DataKeys[index];
            string testId = key.Value.ToString();
            Session["testID"] = testId;
            Response.Redirect("testDuoXuanUpdateByTeacher.aspx");
        }
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.GridView1.PageIndex = e.NewPageIndex;
        BindGrid();
    }

    //保存事件
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        string courseId = Convert.ToString(Session["courseId"]);
        string courseName = lbl_courseName.Text;
        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>");
    }

    //新增事件
    protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
    {
        string courseId = Convert.ToString(Session["courseId"]);
        string teacherId = Convert.ToString(Session["teacherId"]);
        if (!(Session["courseId"] == null))
            Response.Redirect("DuoXuanAddByTeacher.aspx?courseId=" + courseId + "&teacherId=" + teacherId);
        else Response.Write("<script>alert(\"沒有獲取到科目ID!\");</script>");
    }

    //查詢事件
    protected void ImageButton3_Click(object sender, ImageClickEventArgs e)
    {
        if (Session["courseId"] == null)
            Response.Write("<script>alert(\"沒有獲取到科目ID！\");</script>");
        ViewState.Clear();
        this.GridView1.PageIndex = 0;
        BindGrid();
    }
}