?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.Sql;
using System.Data.SqlClient;
using System.IO;

public partial class SubjectManage_Subject_W : System.Web.UI.Page
{
    public static bool res = true;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["USERSTYLE"] == "TEACHER")
        {

        }
        else
        {
            Dialog("對不起，你沒有權限訪問這個頁面！");
            Response.Redirect("~/SystemManage/Login.aspx");
        }
    }
    private void Dialog(String Str)
    {
        Response.Write(@"<script type='text/JavaScript'>");
        Response.Write(@"alert('" + Str + "');");
        //Response.Write(@"window.location='./list_logingroup.aspx';");
        Response.Write(@"</script>");
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        String tno = texTno.Text;
        String grade = ddlGrade.Text;
        String FileName = "第" + tno + "題.txt";
        String content = FileName;

        String qno = changeWord(texNo.Text);
        String a = changeWord(texA.Text); String b = changeWord(texB.Text); String c = changeWord(texC.Text); String d = changeWord(texD.Text);
        String key = ddlKey.Text;

        String[] InsertStr1 = { tno, content, grade };

        String[] InsertStr2 = { qno, a, b, c, d, key, tno }; 
        
        SqlData sql = new SqlData();
        bool f = true; ;
        if (res == true)
        {
            if (sql.CheckStringUnique("TAB_TESTFULL", "TFNO", tno) == 2)
            {
                sql.InsertRow("TAB_TESTFULL", InsertStr1, InsertStr1.Length);
                res = false;
                sql.SqlDataClose();

   
                String s = texContent.Text;
                String A = MapPath("Full");
                FileStream fs = new FileStream(A + "\\" + FileName, FileMode.OpenOrCreate);
                StreamWriter sw = new StreamWriter(fs);
                sw.WriteLine(s);
                sw.Close();
            }
            else
            {
                Label2.Text = "題號為" + tno + "已經存在！";
                f = false;
            }
        }
        if (f == true)
        {
            if (sql.InsertRow("TAB_TESTFULLKEY", InsertStr2, InsertStr2.Length) == true)
                Label2.Text = "操作成功！";
            else
                Label2.Text = "錄入失敗！";
            sql.SqlDataClose();
        }
    }
    protected void btnNext_Click(object sender, EventArgs e)
    {
        res = true;
        int i = 1;
        String s = i.ToString();
        SqlData sql = new SqlData();
        while (sql.CheckStringUnique("TAB_TESTFull", "TFNO", s) == 1)
        {
            i++;
            s = i.ToString();
        }
        texTno.Text = s;
        texNo.Text = "1";
        texContent.Text = "";
        texA.Text = ""; texB.Text = ""; texC.Text = ""; texD.Text = "";
        Label2.Text = "繼續錄入";
    }
    protected void btnNext_1_Click(object sender, EventArgs e)
    {
        String s = texNo.Text;
        int i = int.Parse(s);
        i++;
        texNo.Text = i.ToString();
        texA.Text = ""; texB.Text = ""; texC.Text = ""; texD.Text = "";
        Label2.Text = "繼續錄入問題";
        res = false;
    }
    protected void btnFind_Click(object sender, EventArgs e)
    {
        String str1 = texTno.Text;
        String str2 = texNo.Text;
        string ConnectionString =
        ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        SqlConnection myConnection = new SqlConnection(ConnectionString);

        String conString = "select * from TAB_TESTFULL where TFNO=" + str1;
        SqlDataAdapter myAdapter = new SqlDataAdapter(conString, myConnection);

        DataSet myDataSet = new DataSet();
        myAdapter.Fill(myDataSet, "info");
        DataTable Table = myDataSet.Tables[0];

        if (Table.Rows.Count == 0)
        {
            Label2.Text = "沒有此記錄！";
            texContent.Text = "";
        }
        else
        {
            DataRow row = Table.Rows[0];
            //texContent.Text = row["TFCONTENT"].ToString();

            String tno = texTno.Text;
            String FileName = "第" + tno + "題.txt";
            String A = MapPath("Full");
            FileStream fs = new FileStream(A + "\\" + FileName, FileMode.Open);
            StreamReader sr = new StreamReader(fs);
            String ss = sr.ReadToEnd();
            texContent.Text = ss;
            sr.Close();

            ddlGrade.Text = row["TFGRADE"].ToString();
            Label2.Text = "";

            if (str2 == "") { str2 = "1"; texNo.Text = str2; }
            String conString1 = "select * from TAB_TESTFULLKEY where TFNO=" + str1 + "and ANO=" + str2;
            SqlDataAdapter myAdapter1 = new SqlDataAdapter(conString1, myConnection);

            DataSet myDataSet1 = new DataSet();
            myAdapter1.Fill(myDataSet1, "info1");
            DataTable Table1 = myDataSet1.Tables[0];
            if (Table1.Rows.Count == 0)
            {
                Label2.Text = "沒有此問題！";
                texA.Text = ""; texB.Text = ""; texC.Text = ""; texD.Text = "";
            }
            else
            {
                DataRow row1 = Table1.Rows[0];           
                texA.Text = row1["A"].ToString();
                texB.Text = row1["B"].ToString();
                texC.Text = row1["C"].ToString();
                texD.Text = row1["D"].ToString();
                ddlKey.Text = row1["TFKEY"].ToString();
                Label2.Text = "";
            }
        }
    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        String tno = texTno.Text;
        String FileName = "第" + tno + "題.txt";
        String content = FileName;
        String grade = ddlGrade.Text;

        String qno = changeWord(texNo.Text);
        String a = changeWord(texA.Text); String b = changeWord(texB.Text); String c = changeWord(texC.Text); String d = changeWord(texD.Text);
        String key = ddlKey.Text;

        
        String[] InsertStr1 = { content, grade };       
        String[] InsertStr2 = { a, b, c, d, key}; 
               
        
        String[] UpdateCloumn1 ={ "TFCONTENT", "TFGRADE" };        
        String[] UpdateCloumn2 ={ "A", "B", "C", "D", "TFKEY"};

        String[] WhereCloumn ={"ANO","TFNO" };
        String[] WhereStr ={qno,tno };
        SqlData sql = new SqlData();
        if (sql.updateRow("TAB_TESTFULL", UpdateCloumn1, InsertStr1, InsertStr1.Length, "TFNO", tno) == true)
        {
            sql.SqlDataClose();

       
            String s = texContent.Text;
            String A = MapPath("Full");
            FileStream fs = new FileStream(A + "\\" + FileName, FileMode.Open);
            StreamWriter sw = new StreamWriter(fs);
            sw.WriteLine(s);
            sw.Close();

            if(sql.updateRow("TAB_TESTFULLKEY",UpdateCloumn2,InsertStr2,InsertStr2.Length,WhereCloumn,WhereStr)==true)
            {
                Label2.Text = "修改成功！";
            }
            sql.SqlDataClose();
        }
        else
        {
            Label2.Text = "修改失敗！";
            sql.SqlDataClose();
        } 
    }
    protected void btnDel_Click(object sender, EventArgs e)
    {
        String str1 = texTno.Text;

        SqlData sql = new SqlData();
        if (sql.CheckStringUnique("TAB_SAVETESTFULL", "TFNO", str1) == 1)
        {
            Label2.Text = "該題已經被選進試卷，不能被刪除！";
        }
        else
        {
            if (sql.DeleteRow("TAB_TESTFULLKEY", "TFNO", str1) == true)
            {
                sql.SqlDataClose();
                texNo.Text = "";
                texA.Text = ""; texB.Text = ""; texC.Text = ""; texD.Text = "";

                if (sql.DeleteRow("TAB_TESTFULL", "TFNO", str1) == true)
                {
                    String tno = texTno.Text;
                    String FileName = "第" + tno + "題.txt";
                    String A = MapPath("Full");
                    FileInfo fi = new FileInfo(A + "\\" + FileName);
                    fi.Delete();

                    Label2.Text = "刪除成功！";
                    sql.SqlDataClose();
                    texTno.Text = "";
                    texContent.Text = "";
                }
            }
        }

        
    }
    protected void BtnReturn_Click(object sender, EventArgs e)
    {
        Response.Redirect("~/SystemManage/TeacherMain.aspx");
    }
    public string changeWord(string str)
    {
        String[] sArray = str.Split('\'');
        String result = "";
        foreach (String head in sArray)
        {
            result += " " + head.ToString();
        }
        return result;
    }
}