001.<%@ Import Namespace="System.Data"%>
002.<%@ Import Namespace="System.Data.SqlClient"%>
003.<%@ Import Namespace="System.Web.UI.HtmlControls"%>
004.<%@ Import Namespace="System.Web.UI.WebControls"%>
005.<%@ Import Namespace="System.Web.UI.WebControls.WebParts"%>
006.<%@ Import Namespace="System"%>
007.<%@ Import Namespace="System.Collections"%>
008.<%@ Import Namespace="System.Configuration"%>
009.<%@ Import Namespace="System.Web.UI.WebControls.WebParts"%>
010.<%@ Import Namespace="System.Linq"%>
011.<%@ Import Namespace="System.Web"%>
012.<%@ Import Namespace="System.Web.Security"%>
013.<%@ Page Language="C#" Debug="true" %>
014.
015.<script runat="server">
016.
017. SqlConnection objConn = new SqlConnection();
018. SqlCommand objCmd = new SqlCommand();
019. String strConnString;
020. string term1, term_year1;
021. DataSet ds = new DataSet();
022.
023. public void Page_Load(object sender, EventArgs e)
024. {
025. String strConnString;
026. strConnString = "Server=MONOJA-PC\\SQLEXPRESS;UID=sa;PASSWORD=1234;database=mydatabases;Max Pool Size=400;Connect Timeout=600;";
027. objConn = new SqlConnection(strConnString);
028. objConn.Open();
029.
030. this.Button2.Enabled = false;
031. BindData();
032.
033. }
034.
035. void BindData()
036. {
037. String sql_ct, sql_course, sql_teacher, sql_termyear, sql_term,sql_dc,sql_ct1;
038. SqlDataReader dtReader, dtReader1,dtReader2;
039. int intNumRows;
040. sql_ct = "SELECT count(*) FROM course_teach where id_teacher='" + Session["id_teacher"] + "'";
041. objCmd = new SqlCommand(sql_ct, objConn);
042. intNumRows = Convert.ToInt32(objCmd.ExecuteScalar());
043.
044. if (intNumRows > 0)
045. {
046. sql_term = "SELECT term, term_year FROM course order by term_year desc, term desc";
047. objCmd = new SqlCommand(sql_term, objConn);
048. dtReader = objCmd.ExecuteReader();
049. dtReader.Read();
050. string term = dtReader["term"].ToString();
051. string termyear = dtReader["term_year"].ToString();
052. this.lblTerm.Text = term;
053. this.lblTerm_year.Text = termyear;
054. dtReader.Close();
055. dtReader = null;
056.
057. SqlConnection cnn = new SqlConnection("Server=MONOJA-PC\\SQLEXPRESS;UID=sa;PASSWORD=1234;database=mydatabases;Max Pool Size=400;Connect Timeout=600;");
058. SqlDataAdapter cmd1 = new SqlDataAdapter("select distinct id_course,name_course,term,term_year from course where term='" + term + "' and term_year='" + termyear + "' order by term_year desc,term desc", cnn);
059.
060.
061. cmd1.Fill(ds, "course");
062.
063. SqlDataAdapter cmd2 = new SqlDataAdapter("SELECT * FROM course_teach,course WHERE course.code_course=course_teach.code_course and course_teach.id_teacher = '" + Session["id_teacher"] + "'and course.term_year = '" + termyear + "' and course.term ='" + term + "' order by section", cnn);
064. cmd2.Fill(ds, "course1");
065.
066. SqlDataAdapter cmd3 = new SqlDataAdapter("select * FROM style_test", cnn);
067. cmd3.Fill(ds, "course2");
068.
069.
070. ds.Relations.Add("myrelation",
071. ds.Tables["course"].Columns["id_course"],
072. ds.Tables["course1"].Columns["id_course"]);
073.
074. ds.Relations.Add("myrelation1",
075. ds.Tables["course1"].Columns["code_course"],
076. ds.Tables["course2"].Columns["code_course"]);
077.
078. parentRepeater.DataSource = ds.Tables["course"];
079. Page.DataBind();
080. cnn.Close();
081.
082. }
083. else
084. {
085. Response.Write("<script type=\"text/javascript\">" + "alert('คุณยังไม่มีรายวิชา<br>กรุณาเพิ่มรายวิชา');" +
086. "window.location = 'Create_course.aspx?id_teacher=" + Session["id_teacher"] + "';" + "</" + "script>");
087.
088. }
089. }
090.
091. void Page_UnLoad()
092. {
093. objConn.Close();
094. objConn = null;
095. }
096.
097. void add_course(Object sender, EventArgs e)
098. {
099. Session["term"] = this.lblTerm.Text;
100. Session["term_year"] = this.lblTerm_year.Text;
101. Response.Redirect("Create_course1.aspx?id_teacher=" + Session["id_teacher"] + "&term=" + Session["term"] + "&term_year=" + Session["term_year"] + "");
102. }
103.
104. protected void myRepeater_ItemDataBound(Object sender, RepeaterItemEventArgs e)
105. {
106.
107.
108.
109.
110.
111.
112. HyperLink hplEdit = (HyperLink)(e.Item.FindControl("hplEdit"));
113. if (hplEdit != null)
114. {
115. hplEdit.Text = "แก้ไข";
116. hplEdit.NavigateUrl = "Edit_course.aspx?code_course=" + DataBinder.Eval(e.Item.DataItem, "[\"code_course\"]") + "&id_course=" + DataBinder.Eval(e.Item.DataItem, "[\"id_course\"]") + "§ion=" + DataBinder.Eval(e.Item.DataItem, "[\"section\"]") + "&term=" + DataBinder.Eval(e.Item.DataItem, "[\"term\"]") + "&term_year=" + DataBinder.Eval(e.Item.DataItem, "[\"term_year\"]");
117. }
118.
119. HyperLink hplExam = (HyperLink)(e.Item.FindControl("hplExam"));
120. if (hplExam != null)
121. {
122. hplExam.Text = "จัดการสอบ";
123. hplExam.NavigateUrl = "WebForm1.aspx?id_course=" + DataBinder.Eval(e.Item.DataItem, "[\"id_course\"]") + "§ion=" + DataBinder.Eval(e.Item.DataItem, "[\"section\"]") + "&term=" + DataBinder.Eval(e.Item.DataItem, "[\"term\"]") + "&term_year=" + DataBinder.Eval(e.Item.DataItem, "[\"term_year\"]");
124. }
125. }
126.
127. void Back_course(Object sender, EventArgs e)
128. {
129. string id_teacher = Session["id_teacher"].ToString();
130. Session["id_teacher"] = id_teacher;
131. Session["term"] = this.lblTerm.Text;
132. Session["term_year"] = this.lblTerm_year.Text;
133. Response.Redirect("Back_course.aspx");
134. }
135.
136. void Edit(Object sender, EventArgs e)
137. {
138. Response.Redirect("WebForm1.aspx?id_course=");
139. }
140.</script>
141.
142.<html>
143.<head id="Head1" runat="server">
144. <title>Untitled Page</title>
145.</head>
146.<body>
147.
148. <form id="form1" runat="server">
149.
150. <center>
151. <asp:Label ID="lblDetial" runat="server" Text="รายวิชา" Font-Size="Larger" Font-Bold="true" />
152.<br />
153. <asp:Button ID="Button1" runat="server" Text="Back" OnClick = "Back_course" />
154. ภาคเรียนที่ <asp:Label ID="lblTerm" runat="server" /> / <asp:Label ID="lblTerm_year" runat="server" />
155. <asp:Button ID="Button2" runat="server" Text="Next" />
156. </center><dd /><dd /><dd /><dd /><dd /><dd /><dd /><dd /><dd /><dd /><dd /><dd /><dd /><dd /><dd /><dd /><dd /><dd />
157. <asp:Button ID="btAdd_course" Text="เพิ่มรายวิชา" runat="server" OnClick="add_course"/> <br />
158.
159. <asp:repeater id="parentRepeater" runat="server">
160. <HeaderTemplate><table border="1" align="center" width="30%"></HeaderTemplate>
161. <itemtemplate>
162. <tr><td>
163. <b>รหัสวิชา <asp:Label ID="lblID_course" runat="server" ><%# DataBinder.Eval(Container.DataItem,"id_course") %></asp:Label>
164. วิชา <%# DataBinder.Eval(Container.DataItem,"name_course") %>
165. </b><br>
166.
167. <asp:repeater id="childRepeater" datasource='<%# ((DataRowView)Container.DataItem).Row.GetChildRows("myrelation") %>' OnItemDataBound="myRepeater_ItemDataBound" runat="server">
168. <itemtemplate>
169. <dd /> Section. <%# DataBinder.Eval(Container.DataItem, "[\"section\"]")%>
170. <asp:repeater id="childRepeater1" datasource='<%# ((DataRowView)Container.DataItem).Row.GetChildRows("myrelation1") %>' runat="server">
171. <itemtemplate>
172. สอบทั้งหมด <%# DataBinder.Eval(Container.DataItem, "id_st")%> ครั้ง
173.
174. </itemtemplate>
175. </asp:repeater>
176. <asp:HyperLink ID="hplEdit" runat="server" />
177. <asp:HyperLink ID="hplExam" runat="server" />
178.
179. <br>
180.
181. </itemtemplate>
182. </asp:repeater>
183. <br />
184. </td></tr>
185. </itemtemplate>
186.</asp:repeater>
187. <asp:Label ID="lb" runat="server" />
188. </form>
189.</body>
190.</html>
