protected void Page_Load(object sender, EventArgs e) { login_data = (UserLoginData)Session["login_data"]; if (!Page.IsPostBack) { //ล้าง session Session.Remove("NumTQF1"); Session.Remove("addType1"); Session.Remove("addType2"); Session.Remove("addType3"); Session.Remove("addType4"); Session.Remove("addType5"); Session.Remove("addType6"); List <TQF.Levels> levelData = new TQF.Levels().getLevels(); ddlDegree.Items.Clear(); foreach (TQF.Levels row in levelData) { ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode)); } ddlDegree.Items.FindByValue("02").Selected = true; // Head Table string[] ar = { "ระดับ", "สาขาวิชา", "ปี พ.ศ. ประกาศราชกิจจาฯ", "Download", "แก้ไข", "ลบ" }; tblTQF1.Attributes.Add("class", "table table-bordered table-striped table-hover"); tblTQF1.Attributes.Add("id", "dt_basic"); TableHeaderRow tRowHead = new TableHeaderRow(); tRowHead.TableSection = TableRowSection.TableHeader; for (int cellCtr = 1; cellCtr <= ar.Length; cellCtr++) { // Create a new cell and add it to the row. TableHeaderCell cellHead = new TableHeaderCell(); cellHead.Text = ar[cellCtr - 1]; tRowHead.Cells.Add(cellHead); } tblTQF1.Rows.Add(tRowHead); // End Head Table List <TQF1> tqf1Data = new TQF1().getTQF1(); foreach (TQF1 data in tqf1Data) { TableRow tRowBody = new TableRow(); tRowBody.TableSection = TableRowSection.TableBody; TQF.Levels level = new TQF.Levels(); TableCell cellLevel = new TableCell(); cellLevel.Text = level.getLevels(data.LevelCode).LevelName; tRowBody.Cells.Add(cellLevel); TableCell cellMajor = new TableCell(); cellMajor.Text = data.TQF1Major; tRowBody.Cells.Add(cellMajor); TableCell cellYear = new TableCell(); cellYear.Text = data.Year; tRowBody.Cells.Add(cellYear); TableCell cellDownload = new TableCell(); string urlDownload = "../TQF1_Upload/" + data.FileName; HyperLink hypDownload = new HyperLink(); hypDownload.Attributes.Add("target", "_blnk"); hypDownload.Text = "<h4><i class='fa fa-download'></i></h4>"; hypDownload.NavigateUrl = urlDownload; hypDownload.ToolTip = "Download"; cellDownload.Controls.Add(hypDownload); cellDownload.CssClass = "text-center"; tRowBody.Cells.Add(cellDownload); if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty) || autro_obj.CheckGroupUser(login_data, group_var.officer_department)) { TableCell cellEdit = new TableCell(); string urlEdit = "edit_TQF1.aspx?token=" + data.NumTQF1; HyperLink hypEdit = new HyperLink(); //hypEdit.Attributes.Add("data-target", "#editDegree_Admission"); //hypEdit.Attributes.Add("data-toggle", "modal"); hypEdit.Text = "<h4><i class='fa fa-edit'></i></h4>"; hypEdit.NavigateUrl = urlEdit; hypEdit.ToolTip = "Edit"; cellEdit.Controls.Add(hypEdit); cellEdit.CssClass = "text-center"; tRowBody.Cells.Add(cellEdit); TableCell cellDel = new TableCell(); string urlDel = "delete_TQF1.aspx?token=" + data.NumTQF1;; HyperLink hypDel = new HyperLink(); hypDel.Attributes.Add("data-target", "#deleteModal"); hypDel.Attributes.Add("data-toggle", "modal"); hypDel.Text = "<h4><i class='fa fa-trash-o'></i></h4>"; hypDel.NavigateUrl = urlDel; hypDel.ToolTip = "Delete"; cellDel.Controls.Add(hypDel); cellDel.CssClass = "text-center"; tRowBody.Cells.Add(cellDel); } else { TableCell cellEdit = new TableCell(); string urlEdit = "#"; HyperLink hypEdit = new HyperLink(); //hypEdit.Attributes.Add("data-target", "#editDegree_Admission"); //hypEdit.Attributes.Add("data-toggle", "modal"); hypEdit.Text = "<h4><i class='fa fa-lock'></i></h4>"; hypEdit.NavigateUrl = urlEdit; hypEdit.ToolTip = "Lock"; cellEdit.Controls.Add(hypEdit); cellEdit.CssClass = "text-center"; tRowBody.Cells.Add(cellEdit); TableCell cellDel = new TableCell(); string urlDel = "#"; HyperLink hypDel = new HyperLink(); hypDel.Text = "<h4><i class='fa fa-lock'></i></h4>"; hypDel.NavigateUrl = urlDel; hypDel.ToolTip = "Lock"; cellDel.Controls.Add(hypDel); cellDel.CssClass = "text-center"; tRowBody.Cells.Add(cellDel); } tblTQF1.Rows.Add(tRowBody); } } }
protected void btnSEARCH_Click(object sender, EventArgs e) { // Head Table string[] ar = { "ระดับ", "สาขาวิชา", "ปี พ.ศ. ประกาศราชกิจจาฯ", "Download", "แก้ไข", "ลบ" }; tblTQF1.Attributes.Add("class", "table table-bordered table-striped table-hover"); tblTQF1.Attributes.Add("id", "dt_basic"); TableHeaderRow tRowHead = new TableHeaderRow(); tRowHead.TableSection = TableRowSection.TableHeader; for (int cellCtr = 1; cellCtr <= ar.Length; cellCtr++) { // Create a new cell and add it to the row. TableHeaderCell cellHead = new TableHeaderCell(); cellHead.Text = ar[cellCtr - 1]; tRowHead.Cells.Add(cellHead); } tblTQF1.Rows.Add(tRowHead); // End Head Table string sql = "Select * From TQF1 Where LEVELCODE='" + ddlDegree.SelectedValue + "'"; List <TQF1> tqf1Data = new TQF1().getTQF1Manual(sql); foreach (TQF1 data in tqf1Data) { TableRow tRowBody = new TableRow(); tRowBody.TableSection = TableRowSection.TableBody; TQF.Levels level = new TQF.Levels(); TableCell cellLevel = new TableCell(); cellLevel.Text = level.getLevels(data.LevelCode).LevelName; tRowBody.Cells.Add(cellLevel); TableCell cellMajor = new TableCell(); cellMajor.Text = data.TQF1Major; tRowBody.Cells.Add(cellMajor); TableCell cellYear = new TableCell(); cellYear.Text = data.Year; tRowBody.Cells.Add(cellYear); //<a target="_blnk" title="Download" href="Files/engineer_m1.pdf"> // <h4><i class="fa fa-download"></i></h4> TableCell cellDownload = new TableCell(); string urlDownload = "../TQF1_Upload/" + data.FileName; HyperLink hypDownload = new HyperLink(); //hypEdit.Attributes.Add("data-target", "#editDegree_Admission"); hypDownload.Attributes.Add("target", "_blnk"); hypDownload.Text = "<h4><i class='fa fa-download'></i></h4>"; hypDownload.NavigateUrl = urlDownload; hypDownload.ToolTip = "Download"; cellDownload.Controls.Add(hypDownload); cellDownload.CssClass = "text-center"; tRowBody.Cells.Add(cellDownload); TableCell cellEdit = new TableCell(); string urlEdit = "edit_Degree_Admission.aspx?token="; HyperLink hypEdit = new HyperLink(); hypEdit.Attributes.Add("data-target", "#editDegree_Admission"); hypEdit.Attributes.Add("data-toggle", "modal"); hypEdit.Text = "<h4><i class='fa fa-edit'></i></h4>"; hypEdit.NavigateUrl = urlEdit; hypEdit.ToolTip = "Edit"; cellEdit.Controls.Add(hypEdit); cellEdit.CssClass = "text-center"; tRowBody.Cells.Add(cellEdit); TableCell cellDel = new TableCell(); string urlDel = "delete_Degree_Admission.aspx?token="; HyperLink hypDel = new HyperLink(); hypDel.Attributes.Add("data-target", "#deleteDegree_Admission"); hypDel.Attributes.Add("data-toggle", "modal"); hypDel.Text = "<h4><i class='fa fa-trash-o'></i></h4>"; hypDel.NavigateUrl = urlDel; hypDel.ToolTip = "Delete"; cellDel.Controls.Add(hypDel); cellDel.CssClass = "text-center"; tRowBody.Cells.Add(cellDel); tblTQF1.Rows.Add(tRowBody); } }