protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.officer_department) || autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
{
// ======== Process ===========
if (!Page.IsPostBack)
{
List <TQF.Levels> level = new TQF.Levels().getLevels();
foreach (TQF.Levels row in level)
{
ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode));
}
//02 = ปริญญาตรี
ddlDegree.Items.FindByValue("02").Selected = true;
}
//=============================
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.curriculum))
{
// ======== Process ===========
if (!Page.IsPostBack)
{
txtCURR_CODE.Text = "999999999";
List <TQF.Levels> levels = new TQF.Levels().getLevels();
ddlDegree.Items.Clear();
ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem("--- เลือกระดับการศึกษา ---", "00"));
ddlDegree1.Items.Clear();
ddlDegree1.Items.Insert(ddlDegree1.Items.Count, new ListItem("--- เลือกระดับการศึกษา ---", "00"));
foreach (TQF.Levels row in levels)
{
ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode));
ddlDegree1.Items.Insert(ddlDegree1.Items.Count, new ListItem(row.LevelName, row.LevelCode));
}
List <FacultyData> faculty = new Faculty().getFaculty();
ddlCURR_FACULTY.Items.Clear();
//ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem("--- เลือกคณะ ---", "00"));
foreach (FacultyData row in faculty)
{
//FacultyCode == "99" -> ใช้ร่วมทุกคณะ
if (row.Faculty_Code == "99")
{
ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(row.Faculty_Thai, row.Faculty_Code));
}
}
ddlTQF1.Items.Clear();
ddlTQF1.Items.Insert(ddlTQF1.Items.Count, new ListItem("--- เลือกมาตรฐานคุณวุฒิสาขา ---", "000"));
}
//=============================
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
/// <summary>
/// เรียกข้อมูลจากตาราง LEVELS
/// </summary>
/// <param name="sql">SQL command</param>
/// <returns></returns>
public List <Levels> getLevelsrManual(string sql)
{
List <Levels> LevelsData = new List <Levels>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
Levels LevelsRow = new Levels();
LevelsRow.LevelCode = rowData["LEVELCODE"].ToString();
LevelsRow.LevelName = rowData["LEVELNAME"].ToString();
LevelsData.Add(LevelsRow);
}
return(LevelsData);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.curriculum) || autro_obj.CheckGroupUser(login_data, group_var.officer_faculty) || autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
// ======== Process ===========
bool editable = false;
code = Request.QueryString["token"];
TQF.Course course = new TQF.Course().getCourse(code);
//หลักสูตร
if (autro_obj.CheckGroupUser(login_data, group_var.curriculum))
{
editable = true;
}
// วิชาการคณะ
else if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
{
List <string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty);
foreach (string fac in faculty_authorized)
{
if (fac == course.FacultyCode)
{
editable = true;
break;
}
}
}
// วิชาการภาค
else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department);
foreach (string dep in department_authorized)
{
if (dep.Substring(0, 2) == course.FacultyCode)
{
editable = true;
break;
}
}
}
if (editable == true)
{
if (!Page.IsPostBack)
{
rBtnOpen.Checked = true;
List <TQF.Levels> levels = new TQF.Levels().getLevels();
foreach (TQF.Levels row in levels)
{
ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode));
}
ddlDegree.Items.FindByValue(course.LevelCode).Selected = true;
List <CourseFlag> courseFlag = new CourseFlag().getCourseFlag();
foreach (CourseFlag row in courseFlag)
{
ddlCOURSE_Flag.Items.Insert(ddlCOURSE_Flag.Items.Count, new ListItem(row.CourseFlagName, row.CourseFlagCode));
}
ddlCOURSE_Flag.Items.FindByValue(course.CourseFlagCode).Selected = true;
List <TQF.CourseType> courseType = new TQF.CourseType().getCourseType();
foreach (TQF.CourseType row in courseType)
{
ddlCOURSE_TYPE.Items.Insert(ddlCOURSE_TYPE.Items.Count, new ListItem(row.CourseTypeThaiName, row.CourseTypeCode));
}
ddlCOURSE_TYPE.Items.FindByValue(course.CourseTypeCode).Selected = true;
List <SuFlage> suFlage = new SuFlage().getSuFlage();
foreach (SuFlage row in suFlage)
{
ddlSU_Flag.Items.Insert(ddlSU_Flag.Items.Count, new ListItem(row.SuFlageName, row.SuFlagCode));
}
ddlSU_Flag.Items.FindByValue(course.SuFlage).Selected = true;
List <ServiceStatus> serviceStatus = new ServiceStatus().getServiceStatus();
foreach (ServiceStatus row in serviceStatus)
{
ddl_SERVICESTATUS.Items.Insert(ddl_SERVICESTATUS.Items.Count, new ListItem(row.ServiceStatusName, row.ServiceStatusValue));
}
ddl_SERVICESTATUS.Items.FindByValue(course.ServiceStatus).Selected = true;
//หลักสูตร
if (autro_obj.CheckGroupUser(login_data, group_var.curriculum))
{
List <FacultyData> faculty = new Faculty().getFaculty();
foreach (FacultyData row in faculty)
{
ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(row.Faculty_Thai, row.Faculty_Code));
}
}
// วิชาการคณะ
else if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
{
List <string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty);
List <FacultyData> facultyData = new List <FacultyData>();
// คณะ
facultyData = new Faculty().getFaculty(faculty_authorized);
foreach (FacultyData data in facultyData)
{
ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(data.Faculty_Thai, data.Faculty_Code));
}
}
// วิชาการภาค
else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
List <DepartmentData> departmentData = new List <DepartmentData>();
List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department);
// คณะ
departmentData = new Department().getDepartment(department_authorized);
foreach (DepartmentData data in departmentData)
{
FacultyData faculty_data = new Faculty().getFaculty(data.Department_Code.Substring(0, 2));
ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(faculty_data.Faculty_Thai, faculty_data.Faculty_Code));
}
}
ddlCURR_FACULTY.Items.FindByValue(course.FacultyCode).Selected = true;
txtCOURSE_CODE.Text = course.CourseCode;
txtSHORT_COURSENAME.Text = course.CourseEnShortName;
txtCOURSE_THAINAME.Text = course.CourseThName;
txtCOURSE_ENGNAME.Text = course.CourseEnName;
txtCOURSE_CREDIT.Text = course.Credit;
txtTHEORY.Text = course.TheoryHour;
txtPRACTICE.Text = course.PracticeHour;
txtSELF_STUDY.Text = course.SelfStudyHour;
txtCOURSE_DESC_TH.Text = course.CourseThDesc;
txtCOURSE_DESC_EN.Text = course.CourseEnDesc;
MIN_CREDITS.Text = course.MinCredits;
txtdate.Text = course.DateApprove;
if (course.CourseStatus == "Y")
{
rBtnOpen.Checked = true;
}
if (course.CourseStatus == "N")
{
rBtnClose.Checked = true;
}
COURSE_COMMENT.Text = course.Comments;
}
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
//=============================
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty) || autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
// ======== Process ===========
if (!Page.IsPostBack)
{
rBtnOpen.Checked = true;
List <TQF.Levels> levels = new TQF.Levels().getLevels();
foreach (TQF.Levels row in levels)
{
ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode));
}
List <CourseFlag> courseFlag = new CourseFlag().getCourseFlag();
foreach (CourseFlag row in courseFlag)
{
ddlCOURSE_Flag.Items.Insert(ddlCOURSE_Flag.Items.Count, new ListItem(row.CourseFlagName, row.CourseFlagCode));
}
List <TQF.CourseType> courseType = new TQF.CourseType().getCourseType();
foreach (TQF.CourseType row in courseType)
{
ddlCOURSE_TYPE.Items.Insert(ddlCOURSE_TYPE.Items.Count, new ListItem(row.CourseTypeThaiName, row.CourseTypeCode));
}
List <SuFlage> suFlage = new SuFlage().getSuFlage();
foreach (SuFlage row in suFlage)
{
ddlSU_Flag.Items.Insert(ddlSU_Flag.Items.Count, new ListItem(row.SuFlageName, row.SuFlagCode));
}
List <ServiceStatus> serviceStatus = new ServiceStatus().getServiceStatus();
foreach (ServiceStatus row in serviceStatus)
{
ddl_SERVICESTATUS.Items.Insert(ddl_SERVICESTATUS.Items.Count, new ListItem(row.ServiceStatusName, row.ServiceStatusValue));
}
//หลักสูตร
if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
{
List <FacultyData> faculty = new Faculty().getAllFaculty();
foreach (FacultyData row in faculty)
{
ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(row.Faculty_Thai, row.Faculty_Code));
if (row.Faculty_Code == "11")
{
ddlCURR_FACULTY.Items.FindByValue(row.Faculty_Code).Selected = true;
}
}
}
// วิชาการคณะ
//else if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
//{
// List<string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty);
// List<FacultyData> facultyData = new List<FacultyData>();
// // คณะ
// facultyData = new Faculty().getFaculty(faculty_authorized);
// foreach (FacultyData data in facultyData)
// {
// ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(data.Faculty_Thai, data.Faculty_Code));
// }
//}
// วิชาการภาค
else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
List <DepartmentData> departmentData = new List <DepartmentData>();
List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department);
// คณะ
departmentData = new Department().getDepartment(department_authorized);
foreach (DepartmentData data in departmentData)
{
FacultyData faculty_data = new Faculty().getFaculty(data.Department_Code.Substring(0, 2));
ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(faculty_data.Faculty_Thai, faculty_data.Faculty_Code));
}
}
}
//=============================
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
NumTQF1 = Request.QueryString["token"];
Session["NumTQF1"] = Request.QueryString["token"];
this.DataBind();
if (!Page.IsPostBack)
{
try
{
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));
}
TQF1 tqf1Data = new TQF1().getTQF1(NumTQF1);
ddlDegree.Items.FindByValue(tqf1Data.LevelCode).Selected = true;
txtMajor.Text = tqf1Data.TQF1Major;
txtACADEMIC_YEAR.Text = tqf1Data.Year;
}
catch
{
Session["response"] = "ข้อมูลผิดพลาด ไม่สามารถใช้งานได้ในขณะนี้";
Response.Redirect("../err_response.aspx");
}
}
////// tblType1 //////
// Head Table
//string[] ar = { "ข้อที่", "รายละเอียด", "แก้ไข", "ลบ" };
tblType1.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblType1.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead = new TableHeaderRow();
tRowHead.TableSection = TableRowSection.TableHeader;
// Create a new cell and add it to the row.
TableHeaderCell cellHead1 = new TableHeaderCell();
cellHead1.Text = "ข้อที่";
cellHead1.Attributes.Add("class", "text-center");
cellHead1.Width = 50;
tRowHead.Cells.Add(cellHead1);
TableHeaderCell cellHead2 = new TableHeaderCell();
cellHead2.Text = "รายละเอียด";
tRowHead.Cells.Add(cellHead2);
TableHeaderCell cellHead3 = new TableHeaderCell();
cellHead3.Text = "แก้ไข";
cellHead3.Attributes.Add("class", "text-center");
cellHead3.Width = 50;
tRowHead.Cells.Add(cellHead3);
TableHeaderCell cellHead4 = new TableHeaderCell();
cellHead4.Text = "ลบ";
cellHead4.Attributes.Add("class", "text-center");
cellHead4.Width = 50;
tRowHead.Cells.Add(cellHead4);
tRowHead.Cells[0].Visible = false; //Hidden Cells[0] for UUID..
tblType1.Rows.Add(tRowHead);
//End Head Table
if (Session["addType1"] != null)
{
listTableRow1 = new List <TableRow>();
listTableRow1 = (List <TableRow>)Session["addType1"];
int i;
foreach (TableRow item in listTableRow1)
{
tblType1.Rows.Add(item);
i = tblType1.Rows.GetRowIndex(item);
tblType1.Rows[i].Cells[0].Visible = false;
}
}
else
{
//เรียกข้อมูลจากฐานข้อมูลเวลาที่คลิกแก้ไข จากหน้า list_TQF1.aspx
//สร้าง session เอาไว้เก็บแถว
List <TableRow> dummyRow = new List <TableRow>();
Session["addType1"] = (List <TableRow>)dummyRow;
//1. ด้านคุณธรรม จริยธรรม
string sql = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "' And DOMAINTYPECODE='1'";
List <TQF1Leaning> tqf1LearningData = new TQF1Leaning().getTQF1LeaningManual(sql);
int i;
int numOfrow = 0;
foreach (TQF1Leaning data in tqf1LearningData)
{
TableRow row = new TableRow();
TableCell cellNumber = new TableCell();
cellNumber.Text = data.UUIDNumber;
row.Cells.Add(cellNumber);
numOfrow++;
TableCell cellDetail = new TableCell();
//cellDetail.Text = "(" + numOfrow + ")\t" + data.Detailtype;
cellDetail.Text = data.Detailtype;
row.Cells.Add(cellDetail);
TableCell cellEdit = new TableCell();
string urlEdit = "edit_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypEdit = new HyperLink();
hypEdit.Attributes.Add("data-target", "#editLEARNING_OUT");
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";
row.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
string urlDel = "delete_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteLEARNING_OUT");
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";
row.Cells.Add(cellDel);
tblType1.Rows.Add(row);
//เก็บแถวลง session
dummyRow = (List <TableRow>)Session["addType1"];
dummyRow.Add(row);
Session["addType1"] = (List <TableRow>)dummyRow;
//ซ่อน คอลัมน์ที่ 0
i = tblType1.Rows.GetRowIndex(row);
tblType1.Rows[i].Cells[0].Visible = false;
}
}
////// end tblType1 //////
////// tblType2 //////
// Head Table
//string[] ar = { "ข้อที่", "รายละเอียด", "แก้ไข", "ลบ" };
tblType2.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblType2.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead2 = new TableHeaderRow();
tRowHead2.TableSection = TableRowSection.TableHeader;
// Create a new cell and add it to the row.
TableHeaderCell cellHead12 = new TableHeaderCell();
cellHead12.Text = "ข้อที่";
cellHead12.Attributes.Add("class", "text-center");
cellHead12.Width = 50;
tRowHead2.Cells.Add(cellHead12);
TableHeaderCell cellHead22 = new TableHeaderCell();
cellHead22.Text = "รายละเอียด";
tRowHead2.Cells.Add(cellHead22);
TableHeaderCell cellHead32 = new TableHeaderCell();
cellHead32.Text = "แก้ไข";
cellHead32.Attributes.Add("class", "text-center");
cellHead32.Width = 50;
tRowHead2.Cells.Add(cellHead32);
TableHeaderCell cellHead42 = new TableHeaderCell();
cellHead42.Text = "ลบ";
cellHead42.Attributes.Add("class", "text-center");
cellHead42.Width = 50;
tRowHead2.Cells.Add(cellHead42);
tRowHead2.Cells[0].Visible = false; //Hidden Cells[0] for UUID..
tblType2.Rows.Add(tRowHead2);
//End Head Table
if (Session["addType2"] != null)
{
listTableRow2 = new List <TableRow>();
listTableRow2 = (List <TableRow>)Session["addType2"];
int i;
foreach (TableRow item in listTableRow2)
{
tblType2.Rows.Add(item);
i = tblType2.Rows.GetRowIndex(item);
tblType2.Rows[i].Cells[0].Visible = false;
}
}
else
{
//เรียกข้อมูลจากฐานข้อมูลเวลาที่คลิกแก้ไข จากหน้า list_TQF1.aspx
//สร้าง session เอาไว้เก็บแถว
List <TableRow> dummyRow = new List <TableRow>();
Session["addType2"] = (List <TableRow>)dummyRow;
//2. ด้านความรู้
string sql = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "' And DOMAINTYPECODE='2'";
List <TQF1Leaning> tqf1LearningData = new TQF1Leaning().getTQF1LeaningManual(sql);
int i;
int numOfrow = 0;
foreach (TQF1Leaning data in tqf1LearningData)
{
TableRow row = new TableRow();
TableCell cellNumber = new TableCell();
cellNumber.Text = data.UUIDNumber;
row.Cells.Add(cellNumber);
numOfrow++;
TableCell cellDetail = new TableCell();
//cellDetail.Text = "(" + numOfrow + ")\t" + data.Detailtype;
cellDetail.Text = data.Detailtype;
row.Cells.Add(cellDetail);
TableCell cellEdit = new TableCell();
string urlEdit = "edit_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypEdit = new HyperLink();
hypEdit.Attributes.Add("data-target", "#editLEARNING_OUT");
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";
row.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
string urlDel = "delete_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteLEARNING_OUT");
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";
row.Cells.Add(cellDel);
tblType2.Rows.Add(row);
//เก็บแถวลง session
dummyRow = (List <TableRow>)Session["addType2"];
dummyRow.Add(row);
Session["addType2"] = (List <TableRow>)dummyRow;
//ซ่อน คอลัมน์ที่ 0
i = tblType2.Rows.GetRowIndex(row);
tblType2.Rows[i].Cells[0].Visible = false;
}
}
////// end tblType2 //////
////// tblType3 //////
// Head Table
//string[] ar = { "ข้อที่", "รายละเอียด", "แก้ไข", "ลบ" };
tblType3.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblType3.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead3 = new TableHeaderRow();
tRowHead3.TableSection = TableRowSection.TableHeader;
// Create a new cell and add it to the row.
TableHeaderCell cellHead13 = new TableHeaderCell();
cellHead13.Text = "ข้อที่";
cellHead13.Attributes.Add("class", "text-center");
cellHead13.Width = 50;
tRowHead3.Cells.Add(cellHead13);
TableHeaderCell cellHead23 = new TableHeaderCell();
cellHead23.Text = "รายละเอียด";
tRowHead3.Cells.Add(cellHead23);
TableHeaderCell cellHead33 = new TableHeaderCell();
cellHead33.Text = "แก้ไข";
cellHead33.Attributes.Add("class", "text-center");
cellHead33.Width = 50;
tRowHead3.Cells.Add(cellHead33);
TableHeaderCell cellHead43 = new TableHeaderCell();
cellHead43.Text = "ลบ";
cellHead43.Attributes.Add("class", "text-center");
cellHead43.Width = 50;
tRowHead3.Cells.Add(cellHead43);
tRowHead3.Cells[0].Visible = false; //Hidden Cells[0] for UUID..
tblType3.Rows.Add(tRowHead3);
//End Head Table
if (Session["addType3"] != null)
{
listTableRow3 = new List <TableRow>();
listTableRow3 = (List <TableRow>)Session["addType3"];
int i;
foreach (TableRow item in listTableRow3)
{
tblType3.Rows.Add(item);
i = tblType3.Rows.GetRowIndex(item);
tblType3.Rows[i].Cells[0].Visible = false;
}
}
else
{
//เรียกข้อมูลจากฐานข้อมูลเวลาที่คลิกแก้ไข จากหน้า list_TQF1.aspx
//สร้าง session เอาไว้เก็บแถว
List <TableRow> dummyRow = new List <TableRow>();
Session["addType3"] = (List <TableRow>)dummyRow;
//3. ด้านทักษะทางปัญญา
string sql = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "' And DOMAINTYPECODE='3'";
List <TQF1Leaning> tqf1LearningData = new TQF1Leaning().getTQF1LeaningManual(sql);
int i;
int numOfrow = 0;
foreach (TQF1Leaning data in tqf1LearningData)
{
TableRow row = new TableRow();
TableCell cellNumber = new TableCell();
cellNumber.Text = data.UUIDNumber;
row.Cells.Add(cellNumber);
numOfrow++;
TableCell cellDetail = new TableCell();
//cellDetail.Text = "(" + numOfrow + ")\t" + data.Detailtype;
cellDetail.Text = data.Detailtype;
row.Cells.Add(cellDetail);
TableCell cellEdit = new TableCell();
string urlEdit = "edit_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypEdit = new HyperLink();
hypEdit.Attributes.Add("data-target", "#editLEARNING_OUT");
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";
row.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
string urlDel = "delete_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteLEARNING_OUT");
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";
row.Cells.Add(cellDel);
tblType3.Rows.Add(row);
//เก็บแถวลง session
dummyRow = (List <TableRow>)Session["addType3"];
dummyRow.Add(row);
Session["addType3"] = (List <TableRow>)dummyRow;
//ซ่อน คอลัมน์ที่ 0
i = tblType3.Rows.GetRowIndex(row);
tblType3.Rows[i].Cells[0].Visible = false;
}
}
////// end tblType3 //////
////// tblType4 //////
// Head Table
//string[] ar = { "ข้อที่", "รายละเอียด", "แก้ไข", "ลบ" };
tblType4.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblType4.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead4 = new TableHeaderRow();
tRowHead4.TableSection = TableRowSection.TableHeader;
// Create a new cell and add it to the row.
TableHeaderCell cellHead14 = new TableHeaderCell();
cellHead14.Text = "ข้อที่";
cellHead14.Attributes.Add("class", "text-center");
cellHead14.Width = 50;
tRowHead4.Cells.Add(cellHead14);
TableHeaderCell cellHead24 = new TableHeaderCell();
cellHead24.Text = "รายละเอียด";
tRowHead4.Cells.Add(cellHead24);
TableHeaderCell cellHead34 = new TableHeaderCell();
cellHead34.Text = "แก้ไข";
cellHead34.Attributes.Add("class", "text-center");
cellHead34.Width = 50;
tRowHead4.Cells.Add(cellHead34);
TableHeaderCell cellHead44 = new TableHeaderCell();
cellHead44.Text = "ลบ";
cellHead44.Attributes.Add("class", "text-center");
cellHead44.Width = 50;
tRowHead4.Cells.Add(cellHead44);
tRowHead4.Cells[0].Visible = false; //Hidden Cells[0] for UUID..
tblType4.Rows.Add(tRowHead4);
//End Head Table
if (Session["addType4"] != null)
{
listTableRow4 = new List <TableRow>();
listTableRow4 = (List <TableRow>)Session["addType4"];
int i;
foreach (TableRow item in listTableRow4)
{
tblType4.Rows.Add(item);
i = tblType4.Rows.GetRowIndex(item);
tblType4.Rows[i].Cells[0].Visible = false;
}
}
else
{
//เรียกข้อมูลจากฐานข้อมูลเวลาที่คลิกแก้ไข จากหน้า list_TQF1.aspx
//สร้าง session เอาไว้เก็บแถว
List <TableRow> dummyRow = new List <TableRow>();
Session["addType4"] = (List <TableRow>)dummyRow;
//4. ด้านทักษะความสัมพันธ์ระหว่างบุคคล และความรับผิดชอบ
string sql = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "' And DOMAINTYPECODE='4'";
List <TQF1Leaning> tqf1LearningData = new TQF1Leaning().getTQF1LeaningManual(sql);
int i;
int numOfrow = 0;
foreach (TQF1Leaning data in tqf1LearningData)
{
TableRow row = new TableRow();
TableCell cellNumber = new TableCell();
cellNumber.Text = data.UUIDNumber;
row.Cells.Add(cellNumber);
numOfrow++;
TableCell cellDetail = new TableCell();
//cellDetail.Text = "(" + numOfrow + ")\t" + data.Detailtype;
cellDetail.Text = data.Detailtype;
row.Cells.Add(cellDetail);
TableCell cellEdit = new TableCell();
string urlEdit = "edit_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypEdit = new HyperLink();
hypEdit.Attributes.Add("data-target", "#editLEARNING_OUT");
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";
row.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
string urlDel = "delete_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteLEARNING_OUT");
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";
row.Cells.Add(cellDel);
tblType4.Rows.Add(row);
//เก็บแถวลง session
dummyRow = (List <TableRow>)Session["addType4"];
dummyRow.Add(row);
Session["addType4"] = (List <TableRow>)dummyRow;
//ซ่อน คอลัมน์ที่ 0
i = tblType4.Rows.GetRowIndex(row);
tblType4.Rows[i].Cells[0].Visible = false;
}
}
////// end tblType4 //////
////// tblType5 //////
// Head Table
//string[] ar = { "ข้อที่", "รายละเอียด", "แก้ไข", "ลบ" };
tblType5.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblType5.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead5 = new TableHeaderRow();
tRowHead5.TableSection = TableRowSection.TableHeader;
// Create a new cell and add it to the row.
TableHeaderCell cellHead15 = new TableHeaderCell();
cellHead15.Text = "ข้อที่";
cellHead15.Attributes.Add("class", "text-center");
cellHead15.Width = 50;
tRowHead5.Cells.Add(cellHead15);
TableHeaderCell cellHead25 = new TableHeaderCell();
cellHead25.Text = "รายละเอียด";
tRowHead5.Cells.Add(cellHead25);
TableHeaderCell cellHead35 = new TableHeaderCell();
cellHead35.Text = "แก้ไข";
cellHead35.Attributes.Add("class", "text-center");
cellHead35.Width = 50;
tRowHead5.Cells.Add(cellHead35);
TableHeaderCell cellHead45 = new TableHeaderCell();
cellHead45.Text = "ลบ";
cellHead45.Attributes.Add("class", "text-center");
cellHead45.Width = 50;
tRowHead5.Cells.Add(cellHead45);
tRowHead5.Cells[0].Visible = false; //Hidden Cells[0] for UUID..
tblType5.Rows.Add(tRowHead5);
//End Head Table
if (Session["addType5"] != null)
{
listTableRow5 = new List <TableRow>();
listTableRow5 = (List <TableRow>)Session["addType5"];
int i;
foreach (TableRow item in listTableRow5)
{
tblType5.Rows.Add(item);
i = tblType5.Rows.GetRowIndex(item);
tblType5.Rows[i].Cells[0].Visible = false;
}
}
else
{
//เรียกข้อมูลจากฐานข้อมูลเวลาที่คลิกแก้ไข จากหน้า list_TQF1.aspx
//สร้าง session เอาไว้เก็บแถว
List <TableRow> dummyRow = new List <TableRow>();
Session["addType5"] = (List <TableRow>)dummyRow;
//5. ด้านทักษะการวิเคราะห์เชิงตัวเลข การสื่อสาร และการใช้เทคโนโลยีสารสนเทศ
string sql = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "' And DOMAINTYPECODE='5'";
List <TQF1Leaning> tqf1LearningData = new TQF1Leaning().getTQF1LeaningManual(sql);
int i;
int numOfrow = 0;
foreach (TQF1Leaning data in tqf1LearningData)
{
TableRow row = new TableRow();
TableCell cellNumber = new TableCell();
cellNumber.Text = data.UUIDNumber;
row.Cells.Add(cellNumber);
numOfrow++;
TableCell cellDetail = new TableCell();
//cellDetail.Text = "(" + numOfrow + ")\t" + data.Detailtype;
cellDetail.Text = data.Detailtype;
row.Cells.Add(cellDetail);
TableCell cellEdit = new TableCell();
string urlEdit = "edit_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypEdit = new HyperLink();
hypEdit.Attributes.Add("data-target", "#editLEARNING_OUT");
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";
row.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
string urlDel = "delete_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteLEARNING_OUT");
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";
row.Cells.Add(cellDel);
tblType5.Rows.Add(row);
//เก็บแถวลง session
dummyRow = (List <TableRow>)Session["addType5"];
dummyRow.Add(row);
Session["addType5"] = (List <TableRow>)dummyRow;
//ซ่อน คอลัมน์ที่ 0
i = tblType5.Rows.GetRowIndex(row);
tblType5.Rows[i].Cells[0].Visible = false;
}
}
////// end tblType5 //////
////// tblType6 //////
// Head Table
//string[] ar = { "ข้อที่", "รายละเอียด", "แก้ไข", "ลบ" };
tblType6.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblType6.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead6 = new TableHeaderRow();
tRowHead6.TableSection = TableRowSection.TableHeader;
// Create a new cell and add it to the row.
TableHeaderCell cellHead16 = new TableHeaderCell();
cellHead16.Text = "ข้อที่";
cellHead16.Attributes.Add("class", "text-center");
cellHead16.Width = 50;
tRowHead6.Cells.Add(cellHead16);
TableHeaderCell cellHead26 = new TableHeaderCell();
cellHead26.Text = "รายละเอียด";
tRowHead6.Cells.Add(cellHead26);
TableHeaderCell cellHead36 = new TableHeaderCell();
cellHead36.Text = "แก้ไข";
cellHead36.Attributes.Add("class", "text-center");
cellHead36.Width = 50;
tRowHead6.Cells.Add(cellHead36);
TableHeaderCell cellHead46 = new TableHeaderCell();
cellHead46.Text = "ลบ";
cellHead46.Attributes.Add("class", "text-center");
cellHead46.Width = 50;
tRowHead6.Cells.Add(cellHead46);
tRowHead6.Cells[0].Visible = false; //Hidden Cells[0] for UUID..
tblType6.Rows.Add(tRowHead6);
//End Head Table
if (Session["addType6"] != null)
{
listTableRow6 = new List <TableRow>();
listTableRow6 = (List <TableRow>)Session["addType6"];
int i;
foreach (TableRow item in listTableRow6)
{
tblType6.Rows.Add(item);
i = tblType6.Rows.GetRowIndex(item);
tblType6.Rows[i].Cells[0].Visible = false;
}
}
else
{
//เรียกข้อมูลจากฐานข้อมูลเวลาที่คลิกแก้ไข จากหน้า list_TQF1.aspx
//สร้าง session เอาไว้เก็บแถว
List <TableRow> dummyRow = new List <TableRow>();
Session["addType6"] = (List <TableRow>)dummyRow;
//6. ด้านทักษะพิสัย
string sql = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "' And DOMAINTYPECODE='6'";
List <TQF1Leaning> tqf1LearningData = new TQF1Leaning().getTQF1LeaningManual(sql);
int i;
int numOfrow = 0;
foreach (TQF1Leaning data in tqf1LearningData)
{
TableRow row = new TableRow();
TableCell cellNumber = new TableCell();
cellNumber.Text = data.UUIDNumber;
row.Cells.Add(cellNumber);
numOfrow++;
TableCell cellDetail = new TableCell();
//cellDetail.Text = "(" + numOfrow + ")\t" + data.Detailtype;
cellDetail.Text = data.Detailtype;
row.Cells.Add(cellDetail);
TableCell cellEdit = new TableCell();
string urlEdit = "edit_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypEdit = new HyperLink();
hypEdit.Attributes.Add("data-target", "#editLEARNING_OUT");
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";
row.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
string urlDel = "delete_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteLEARNING_OUT");
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";
row.Cells.Add(cellDel);
tblType6.Rows.Add(row);
//เก็บแถวลง session
dummyRow = (List <TableRow>)Session["addType6"];
dummyRow.Add(row);
Session["addType6"] = (List <TableRow>)dummyRow;
//ซ่อน คอลัมน์ที่ 0
i = tblType6.Rows.GetRowIndex(row);
tblType6.Rows[i].Cells[0].Visible = false;
}
}
////// end tblType6 //////
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.curriculum))
{
// ======== Process ===========
CurrCode = Request.QueryString["CurrCode"];
YearVersion = Request.QueryString["YearVersion"];
TQF.Curriculum curriculum = new TQF.Curriculum();
TQF.Curriculum curriculumData = curriculum.getCurriculum(CurrCode, YearVersion);
if (!Page.IsPostBack)
{
if (curriculumData.CurrStatus == "1")
{
//สถานะของหลักสูตร(1=ใหม่, 2=ปรับปรุง)
rBtnNEW_CURR.Checked = true;
}
else if (curriculumData.CurrStatus == "2")
{
//สถานะของหลักสูตร(1=ใหม่, 2=ปรับปรุง)
rBtnMINOR_MODI_CURR.Checked = true;
}
else
{
//สถานะของหลักสูตร(1=ใหม่, 2=ปรับปรุง)
rBtnNEW_CURR.Checked = true;
}
txtCURR_CODE.Text = curriculumData.CurrCode;
txtCURR_YEAR_VERSION.Text = curriculumData.YearVersion;
ddlCURR_SEMESTER.Items.FindByValue(curriculumData.BeginSemester).Selected = true;
txtCURR_YEAR.Text = curriculumData.BeginYear;
List <TQF.Levels> levels = new TQF.Levels().getLevels();
ddlDegree.Items.Clear();
ddlDegree1.Items.Clear();
foreach (TQF.Levels row in levels)
{
ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode));
ddlDegree1.Items.Insert(ddlDegree1.Items.Count, new ListItem(row.LevelName, row.LevelCode));
}
ddlDegree.Items.FindByValue(curriculumData.LevelCode).Selected = true;
ddlDegree1.Items.FindByValue(curriculumData.LevelCode).Selected = true;
txtCURR_THAINAME.Text = curriculumData.CurrThName;
txtCURR_ENGNAME.Text = curriculumData.CurrEnName;
List <FacultyData> faculty = new Faculty().getFaculty();
ddlCURR_FACULTY.Items.Clear();
//ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem("--- เลือกคณะ ---", "00"));
foreach (FacultyData row in faculty)
{
//FacultyCode == "99" -> ใช้ร่วมทุกคณะ
if (row.Faculty_Code == "99")
{
ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(row.Faculty_Thai, row.Faculty_Code));
}
}
ddlTQF1.Items.Clear();
List <TQF1> tqf1 = new TQF1().getTQF1();
ddlTQF1.Items.Clear();
foreach (TQF1 row in tqf1)
{
ddlTQF1.Items.Insert(ddlTQF1.Items.Count, new ListItem(row.TQF1Major, row.NumTQF1));
}
ddlTQF1.Items.FindByValue(curriculumData.NumTQF1).Selected = true;
}
//=============================
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
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);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty) || autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
// ======== Process ===========
if (!Page.IsPostBack)
{
//หลักสูตร
if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
{
List <FacultyData> faculty = new Faculty().getFaculty();
ddlCURR_FACULTY.Items.Clear();
ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem("--- เลือกคณะ ---", "00"));
foreach (FacultyData row in faculty)
{
ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(row.Faculty_Thai, row.Faculty_Code));
}
ddlCURR_DEPARTMENT.Items.Clear();
ddlCURR_DEPARTMENT.Items.Insert(ddlCURR_DEPARTMENT.Items.Count, new ListItem("--- เลือกภาควิชา ---", "00"));
}
// วิชาการคณะ
//else if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
//{
// List<string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty);
// List<FacultyData> facultyData = new List<FacultyData>();
// // คณะ
// facultyData = new Faculty().getFaculty(faculty_authorized);
// ddlCURR_FACULTY.Items.Clear();
// ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem("--- เลือกคณะ ---", "00"));
// foreach (FacultyData data in facultyData)
// {
// ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(data.Faculty_Thai, data.Faculty_Code));
// }
// ddlCURR_DEPARTMENT.Items.Clear();
// ddlCURR_DEPARTMENT.Items.Insert(ddlCURR_DEPARTMENT.Items.Count, new ListItem("--- เลือกภาควิชา ---", "00"));
//}
// วิชาการภาค
else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
ddlCURR_FACULTY.Enabled = false;
ddlCURR_FACULTY.BackColor = System.Drawing.ColorTranslator.FromHtml("#CCCCCC");
ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem("--- เลือกคณะ ---", "00"));
List <DepartmentData> departmentData = new List <DepartmentData>();
List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department);
// ภาควิชา
departmentData = new Department().getDepartment(department_authorized);
ddlCURR_DEPARTMENT.Items.Clear();
ddlCURR_DEPARTMENT.Items.Insert(ddlCURR_DEPARTMENT.Items.Count, new ListItem("--- เลือกภาควิชา ---", "00"));
foreach (DepartmentData data in departmentData)
{
ddlCURR_DEPARTMENT.Items.Insert(ddlCURR_DEPARTMENT.Items.Count, new ListItem(data.Department_Thai, data.Department_Code));
}
// คณะ
//FacultyData faculty_data = new Faculty().getFaculty(ddlCURR_DEPARTMENT.SelectedValue.Substring(0, 2));
//ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(faculty_data.Faculty_Thai, faculty_data.Faculty_Code));
}
List <TQF.Levels> levels = new TQF.Levels().getLevels();
ddlDegree.Items.Clear();
ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem("--- เลือกระดับการศึกษา ---", "00"));
ddlDegree1.Items.Clear();
ddlDegree1.Items.Insert(ddlDegree1.Items.Count, new ListItem("--- เลือกระดับการศึกษา ---", "00"));
foreach (TQF.Levels row in levels)
{
ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode));
ddlDegree1.Items.Insert(ddlDegree1.Items.Count, new ListItem(row.LevelName, row.LevelCode));
}
ddlCURR_MAJOR.Items.Clear();
//ddlCURR_MAJOR.Items.Insert(ddlCURR_MAJOR.Items.Count, new ListItem("--- เลือกสาขาวิชา ---", "00"));
List <SysUser> sysUser = new SysUser().getSysUser();
ddlLECTURER.Items.Clear();
foreach (SysUser row in sysUser)
{
string sql = "Select * From ABOUTLECTURER Where LECTIDENTITY='" + row.IdCode + "'";
List <AboutLecturer> aboutLecturer = new AboutLecturer().getAboutLecturerManual(sql);
//เช็คว่าอาจารย์ประจำหลักสูตรไปแล้วหรือยัง
if (aboutLecturer.Count > 0)
{
continue;
}
else
{
ddlLECTURER.Items.Insert(ddlLECTURER.Items.Count, new ListItem(row.ThName + " " + row.ThSurName + " (" + row.ShortName + ")", row.IdCode));
}
}
ddlTQF1.Items.Clear();
ddlTQF1.Items.Insert(ddlTQF1.Items.Count, new ListItem("--- เลือกมาตรฐานคุณวุฒิสาขา ---", "000"));
}
//=============================
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty) || autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
// ======== Process ===========
bool editable = false;
CurrCode = Request.QueryString["CurrCode"];
YearVersion = Request.QueryString["YearVersion"];
TQF.Curriculum curriculum = new TQF.Curriculum();
TQF.Curriculum curriculumData = curriculum.getCurriculum(CurrCode, YearVersion);
//หลักสูตร
if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
{
editable = true;
}
// วิชาการคณะ
//else if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
//{
// List<string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty);
// foreach (string fac in faculty_authorized)
// {
// if (fac == curriculumData.FacultyCode)
// {
// editable = true;
// break;
// }
// }
//}
// วิชาการภาค
else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department);
foreach (string dep in department_authorized)
{
if (dep == curriculumData.DepartmentCode)
{
editable = true;
break;
}
}
}
if (!Page.IsPostBack)
{
if (editable == true)
{
if (curriculumData.CurrStatus == "1")
{
//สถานะของหลักสูตร(1=ใหม่, 2=ปรับปรุง)
rBtnNEW_CURR.Checked = true;
}
else if (curriculumData.CurrStatus == "2")
{
//สถานะของหลักสูตร(1=ใหม่, 2=ปรับปรุง)
rBtnMINOR_MODI_CURR.Checked = true;
}
else
{
//สถานะของหลักสูตร(1=ใหม่, 2=ปรับปรุง)
rBtnNEW_CURR.Checked = true;
}
txtCURR_CODE.Text = curriculumData.CurrCode;
txtCURR_YEAR_VERSION.Text = curriculumData.YearVersion;
try
{
ddlCURR_SEMESTER.Items.FindByValue(curriculumData.BeginSemester).Selected = true;
}
catch
{ }
txtCURR_YEAR.Text = curriculumData.BeginYear;
List <TQF.Levels> levels = new TQF.Levels().getLevels();
ddlDegree.Items.Clear();
ddlDegree1.Items.Clear();
foreach (TQF.Levels row in levels)
{
ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode));
ddlDegree1.Items.Insert(ddlDegree1.Items.Count, new ListItem(row.LevelName, row.LevelCode));
}
try
{
ddlDegree.Items.FindByValue(curriculumData.LevelCode).Selected = true;
ddlDegree1.Items.FindByValue(curriculumData.LevelCode).Selected = true;
}
catch
{ }
txtCURR_THAINAME.Text = curriculumData.CurrThName;
txtCURR_ENGNAME.Text = curriculumData.CurrEnName;
//txtCURR_SHORT_THAINAME.Text = curriculumData.CurrShortThName;
//txtCURR_SHORT_ENGNAME.Text = curriculumData.CurrShortEnName;
txtDIP_THAINAME.Text = new Diploma().getDiploma(curriculumData.DiplomaCode).DomainThName;
txtDIP_ENGNAME.Text = new Diploma().getDiploma(curriculumData.DiplomaCode).DomainEnName;
txtDIP_SHORT_THAINAME.Text = new Diploma().getDiploma(curriculumData.DiplomaCode).DomainThShortName;
txtDIP_SHORT_ENGNAME.Text = new Diploma().getDiploma(curriculumData.DiplomaCode).DomainEnShortName;
List <FacultyData> faculty = new Faculty().getFaculty();
ddlCURR_FACULTY.Items.Clear();
foreach (FacultyData row in faculty)
{
ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(row.Faculty_Thai, row.Faculty_Code));
}
try
{
ddlCURR_FACULTY.Items.FindByValue(curriculumData.FacultyCode).Selected = true;
}
catch
{ }
List <DepartmentData> department = new Department().getDepartment();
ddlCURR_DEPARTMENT.Items.Clear();
foreach (DepartmentData row in department)
{
ddlCURR_DEPARTMENT.Items.Insert(ddlCURR_DEPARTMENT.Items.Count, new ListItem(row.Department_Thai, row.Department_Code));
}
try
{
ddlCURR_DEPARTMENT.Items.FindByValue(curriculumData.DepartmentCode).Selected = true;
}
catch
{ }
string sqlDivision = "Select * From DIVISION Where DEPARTMENTCODE = " + curriculumData.DepartmentCode;
List <TQF.Division> division = new TQF.Division().getDivisionManual(sqlDivision);
ddlCURR_MAJOR.Items.Clear();
foreach (TQF.Division row in division)
{
ddlCURR_MAJOR.Items.Insert(ddlCURR_MAJOR.Items.Count, new ListItem(row.DivisionThName + " ( " + row.DivisionEnShortName + " )", row.DivisionCode));
}
string sqlDivisionExtension = "Select * From DIVISIONEXTENSION Where DIVISIONNO='" + curriculumData.DivisionCode + "'";
List <DivisionExtension> divisionExtension = new DivisionExtension().getDivisionExtensionManual(sqlDivisionExtension);
foreach (DivisionExtension row in divisionExtension)
{
try
{
ddlCURR_MAJOR.Items.FindByValue(row.DivisionCode).Selected = true;
}
catch
{ }
}
txtSTUDY_YEAR.Text = curriculumData.NumYear;
txtTOTAL_STUDY_YEAR.Text = curriculumData.MaxNumYear;
List <SysUser> sysUser = new SysUser().getSysUser();
ddlLECTURER.Items.Clear();
foreach (SysUser row in sysUser)
{
string sql = "Select * From ABOUTLECTURER Where LECTIDENTITY='" + row.IdCode + "'";
List <AboutLecturer> aboutLecturer = new AboutLecturer().getAboutLecturerManual(sql);
//เช็คว่าอาจารย์ประจำหลักสูตรไปแล้วหรือยัง
if (aboutLecturer.Count > 0)
{
string sql2 = "Select * From ABOUTLECTURER Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And LECTIDENTITY='" + row.IdCode + "' And LOADTYPECODE='1'";
List <AboutLecturer> aboutLecturer2 = new AboutLecturer().getAboutLecturerManual(sql2);
foreach (AboutLecturer li in aboutLecturer2)
{
if (li.LectIdentity == row.IdCode)
{
ddlLECTURER.Items.Insert(ddlLECTURER.Items.Count, new ListItem(row.ThName + " " + row.ThSurName + " (" + row.ShortName + ")", row.IdCode));
ddlLECTURER.Items.FindByValue(row.IdCode).Selected = true;
}
}
continue;
}
else
{
ddlLECTURER.Items.Insert(ddlLECTURER.Items.Count, new ListItem(row.ThName + " " + row.ThSurName + " (" + row.ShortName + ")", row.IdCode));
}
}
try
{
ddlMAJORSTATUS.Items.FindByValue(curriculumData.MajorStatus).Selected = true;
}
catch
{ }
List <TQF1> tqf1 = new TQF1().getTQF1();
ddlTQF1.Items.Clear();
foreach (TQF1 row in tqf1)
{
ddlTQF1.Items.Insert(ddlTQF1.Items.Count, new ListItem(row.TQF1Major, row.NumTQF1));
if (curriculumData.NumTQF1 == row.NumTQF1)
{
ddlTQF1.Items.FindByValue(curriculumData.NumTQF1).Selected = true;
}
}
//ddlTQF1.Items.FindByValue(curriculumData.NumTQF1).Selected = true;
txtDateApprove.Text = curriculumData.ApprovedDate;
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
//=========================
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
