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);
}
}
