?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 System.Data.SqlClient;
using TQMS.BusinessLogicLayer;
using TQMS.DataAccessHelper;

public partial class Manager_MChapterAndSection : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["UserName"] == null)
        {
            Page.Response.Redirect("~/Default.aspx");
        }
        else
        {
            if (!IsPostBack)
            {
                Common.BindDdlCourse(this.ddlCourse);//綁定科目信息
                BindGvChapter();

            }
        }

    }
  
  
    protected void gvChapter_RowEditing(object sender, GridViewEditEventArgs e)
    {
        int index = e.NewEditIndex;
        int ChapterID = int.Parse(gvChapter.Rows[index].Cells[0].Text);
        Response.Redirect("MEditChapter.aspx?action=edit&id=" + ChapterID);
        
    }

    /*  *****************************************************
        作用： 刪除章的信息。
     　　注：　當刪除信息時，它將刪除該章的所有信息
        ****************************************************** */
    protected void gvChapter_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int chapterID = int.Parse(gvChapter.Rows[e.RowIndex].Cells[0].Text);
        Chapter chapter = new Chapter();
        chapter.LoadData(chapterID);

        if(chapter.Delete())
        {
            this.lblMessege.Text = "刪除成功!!";
            this.lblMessege.Style["Color"] = "green";
        }
        else
        {

            this.lblMessege.Text = "刪除失敗，請稍后再試!!" ;
            this.lblMessege.Style["Color"] = "red";
        }
        BindGvChapter();

    }

    /*  ***********************
    作用： 添加章的信息。
        *********************** */
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        if (ddlCourse.SelectedValue == "0")
        {
            Response.Write("<script language='javascript'>alert('科目必須選擇!!!');</script>");

            return;
        }
        else
        {
            if (tbxChapterName.Text.Trim() == "")
            {
                Response.Write("<script language='javascript'>alert('請輸入章名稱!!!');</script>");
                return;
            }
            else if(tbxChapterName.Text.Length >= 30)
            {
                Response.Write("<script language='javascript'>alert('名稱太長了，不能大于30個字符!!!');</script>");
                return;
            }
        }
        Hashtable ht = new Hashtable();
        ht.Add("TQ_ChapterName",SqlStringConstructor.GetQuotedString(this.tbxChapterName.Text.Trim()));
        ht.Add("TQ_CourseID", int.Parse(ddlCourse.SelectedValue));
        Chapter chapter = new Chapter();
        if(chapter.Add(ht))
        {
            this.lblMessege.Text = "添加成功!!";
            this.lblMessege.Style["Color"] = "green";
        }
        else
        {
            this.lblMessege.Text = "添加失敗，請稍后再試!!";
            this.lblMessege.Style["Color"] = "red";
        }
       
        BindGvChapter();
        this.ddlCourse.SelectedIndex = 0;
        this.tbxChapterName.Text = "";
    }




    /*  *****************************
        綁定章信息到表格
        ***************************** */
    protected void BindGvChapter()
    {
        DataTable dt = Chapter.QueryAllChapter();
        this.gvChapter.DataSource = dt;
        this.gvChapter.DataBind();

    }

    protected void gvChapter_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvChapter.PageIndex = e.NewPageIndex;
        BindGvChapter();
    }
}