protected void ddlCURR_DEPARTMENT_SelectedIndexChanged(object sender, EventArgs e)
{
string sql = "Select * From DIVISION Where DEPARTMENTCODE='" + ddlCURR_DEPARTMENT.SelectedValue + "'";
List <TQF.Division> division = new TQF.Division().getDivisionManual(sql);
ddlCURR_MAJOR.Items.Clear();
//ddlCURR_MAJOR.Items.Insert(ddlCURR_MAJOR.Items.Count, new ListItem("--- เลือกสาขาวิชา ---", "00"));
if (division.Count == 0)
{
ddlCURR_MAJOR.Items.Clear();
ddlCURR_MAJOR.Items.Insert(ddlCURR_MAJOR.Items.Count, new ListItem("ไม่มีสาขาวิชา", "00"));
}
else
{
foreach (TQF.Division row in division)
{
ddlCURR_MAJOR.Items.Insert(ddlCURR_MAJOR.Items.Count, new ListItem(row.DivisionThName + " ( " + row.DivisionEnShortName + " )", row.DivisionCode));
}
}
}
protected void ddlCURR_DEPARTMENT_SelectedIndexChanged(object sender, EventArgs e)
{
// วิชาการภาค
if (autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
// คณะ
FacultyData faculty_data = new Faculty().getFaculty(ddlCURR_DEPARTMENT.SelectedValue.Substring(0, 2));
ddlCURR_FACULTY.Items.Clear();
if (faculty_data.Faculty_Code != null)
{
ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(faculty_data.Faculty_Thai, faculty_data.Faculty_Code));
}
else
{
ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem("--- เลือกคณะ ---", "00"));
}
}
string sql = "Select * From DIVISION Where DEPARTMENTCODE='" + ddlCURR_DEPARTMENT.SelectedValue + "'";
List <TQF.Division> division = new TQF.Division().getDivisionManual(sql);
ddlCURR_MAJOR.Items.Clear();
//ddlCURR_MAJOR.Items.Insert(ddlCURR_MAJOR.Items.Count, new ListItem("--- เลือกสาขาวิชา ---", "00"));
if (division.Count == 0)
{
ddlCURR_MAJOR.Items.Clear();
ddlCURR_MAJOR.Items.Insert(ddlCURR_MAJOR.Items.Count, new ListItem("ไม่มีสาขาวิชา", "00"));
}
else
{
foreach (TQF.Division row in division)
{
ddlCURR_MAJOR.Items.Insert(ddlCURR_MAJOR.Items.Count, new ListItem(row.DivisionThName + " ( " + row.DivisionEnShortName + " )", row.DivisionCode));
}
}
}
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");
}
}
}