protected void btnAdd_Click(object sender, EventArgs e)
{
string result = "";
if (ddlCURRICULUM.SelectedItem.Value == "0")
{
lblAddError.Text = "กรุณาเลือก หลักสูตร";
}
else
{
ApproveAdvisorData add_approve = new ApproveAdvisorData();
add_approve.Faculty_Code = ddlFACULTY.SelectedItem.Value;
// add_approve.Department_Code = ddlDEPARTMENT.SelectedItem.Value;
add_approve.Curri_Code = ddlCURRICULUM.SelectedItem.Value;
result = new ApproveAdvisor().setApproveSecAdvisor(add_approve);
if (result == "OK")
{
lblAddPass.Text = "เพิ่มข้อมูลสำเร็จ";
LoadTable();
}
else
{
lblAddError.Text = result;
}
}
btnAdd.Focus();
}
protected void btnSetApprove1_Click(object sender, EventArgs e)
{
ApproveAdvisorData set_approve_data = new ApproveAdvisorData();
if (chkApproveSec.Checked == true)
{
set_approve_data.SecAdvisor = "y";
rowFind.Visible = false;
rowListApprove.Visible = false;
}
else
{
set_approve_data.SecAdvisor = "n";
rowFind.Visible = true;
rowListApprove.Visible = true;
}
string result = new ApproveAdvisor().setApproveAdvisor(set_approve_data);
if (result == "OK")
{
lblSavePass.Text = "บันทึกข้อมูลสำเร็จ";
}
else
{
lblSaveError.Text = result;
}
}
public string setApproveAdvisor(ApproveAdvisorData setData)
{
string response = "";
UserLoginData loginData = new UserLoginData();
loginData = (UserLoginData)HttpContext.Current.Session["login_data"];
LogData log_data = new LogData();
log_data.ModuleCode = new LogData().Module_Advisor;
log_data.Username = loginData.User_ID;
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Update ADVISOR_ALL_APPROVE";
if (setData.SecAdvisor != "")
{
sql += " Set SEC_ADVISOR='" + setData.SecAdvisor + "' ";
log_data.Message = "Set sec_advisor approve registration with:" + setData.SecAdvisor;
}
else if (setData.GradAdvisor != "")
{
sql += " Set GRAD_ADVISOR='" + setData.GradAdvisor + "' ";
log_data.Message = "Set grad_advisor approve registration with:" + setData.GradAdvisor;
}
oracleObj.UpdateCommand = sql;
try
{
if (oracleObj.Update() == 1)
{
response = "OK";
log_data.StatusCode = log_data.LogStatus_SUCCESS;
}
else
{
log_data.StatusCode = log_data.LogStatus_FAILED;
}
}
catch (Exception e)
{
response = e.Message.ToString();
log_data.StatusCode = log_data.LogStatus_ERROR;
log_data.Message += " [" + e.ToString() + "]";
}
new Log().WriteLog(log_data);
return(response);
}
public ApproveAdvisorData gePrereq_Curri(string curr_code)
{
ApproveAdvisorData approve_data = new ApproveAdvisorData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From PRE_REQ_APPROVE Where CURRI_CODE='" + curr_code + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
approve_data.Faculty_Code = rowData["FACULTY_CODE"].ToString();
approve_data.Curri_Code = rowData["CURRI_CODE"].ToString();
}
return(approve_data);
}
public ApproveAdvisorData getPrereqr()
{
ApproveAdvisorData req_data = new ApproveAdvisorData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From ADVISOR_ALL_APPROVE";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
req_data.Pre_Req = rowData["PRE_REQ"].ToString();
}
return(req_data);
}
public List <ApproveAdvisorData> getApproveSecAdvisor()
{
List <ApproveAdvisorData> approveData = new List <ApproveAdvisorData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From ADVISOR_SEC_APPROVE";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
ApproveAdvisorData approve_data = new ApproveAdvisorData();
approve_data.Faculty_Code = rowData["FACULTY_CODE"].ToString();
approve_data.Curri_Code = rowData["CURRI_CODE"].ToString();
approveData.Add(approve_data);
}
return(approveData);
}
public string setPrereq_Curri(ApproveAdvisorData insertData)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql1 = "Insert Into PRE_REQ_APPROVE(FACULTY_CODE,CURRI_CODE) Values('" + insertData.Faculty_Code + "','" + insertData.Curri_Code + "')";
UserLoginData loginData = new UserLoginData();
loginData = (UserLoginData)HttpContext.Current.Session["login_data"];
LogData log_data = new LogData();
log_data.ModuleCode = new LogData().Module_Registration;
log_data.Username = loginData.User_ID;
log_data.Message = "Add pre_req with:" + insertData.Faculty_Code + "," + insertData.Curri_Code;
oracleObj.InsertCommand = sql1;
try
{
if (oracleObj.Insert() == 1)
{
response = "OK";
log_data.StatusCode = log_data.LogStatus_SUCCESS;
}
else
{
log_data.StatusCode = log_data.LogStatus_FAILED;
}
}
catch (Exception e)
{
response = e.Message.ToString();
log_data.StatusCode = log_data.LogStatus_ERROR;
log_data.Message += " [" + e.ToString() + "]";
}
new Log().WriteLog(log_data);
return(response);
}
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.board_reg_sta) || autro_obj.CheckGroupUser(login_data, group_var.officer_reg_sta))
{
// ======== Process ===========
lblSavePass.Text = "";
lblSaveError.Text = "";
lblAddError.Text = "";
lblAddPass.Text = "";
lblDelError.Text = "";
lblDelPass.Text = "";
if (!Page.IsPostBack)
{
approve_data = new ApproveAdvisor().getApproveAdvisor();
if (approve_data.SecAdvisor == "y")
{
chkApproveSec.Checked = true;
rowFind.Visible = false;
rowListApprove.Visible = false;
}
else
{
chkApproveSec.Checked = false;
rowFind.Visible = true;
rowListApprove.Visible = true;
}
// ระดับการศึกษา
degreeLevel = new Degree().getDegreeChar();
foreach (DegreeData data in degreeLevel)
{
ddlDEGREE.Items.Insert(ddlDEGREE.Items.Count, new ListItem(data.Degree_Thai, data.Degree_Char));
}
// คณะ
facultyData = new Faculty().getFaculty();
ddlFACULTY.Items.Clear();
foreach (FacultyData data in facultyData)
{
ddlFACULTY.Items.Insert(ddlFACULTY.Items.Count, new ListItem(data.Faculty_Thai, data.Faculty_Code));
}
string Curr_LevelCode = "";
if (ddlDEGREE.SelectedValue == "U")
{
Curr_LevelCode = "01";
}
else if (ddlDEGREE.SelectedValue == "B")
{
Curr_LevelCode = "02";
}
else if (ddlDEGREE.SelectedValue == "M")
{
Curr_LevelCode = "03";
}
else if (ddlDEGREE.SelectedValue == "D")
{
Curr_LevelCode = "04";
}
else if (ddlDEGREE.SelectedValue == "P")
{
Curr_LevelCode = "05";
}
//หลักสูตร
string curr_sql = "Select * From CURRICULUM Where FACULTYCODE='" + ddlFACULTY.SelectedValue + "' AND LEVELCODE='" + Curr_LevelCode + "'";
curriData = new Curriculum().getManualCurriculum(curr_sql);
ddlCURRICULUM.Items.Clear();
if (curriData.Count == 0)
{
ddlCURRICULUM.Items.Insert(ddlCURRICULUM.Items.Count, new ListItem("--- เลือกหลักสูตร ---", "0"));
}
else
{
foreach (CurriculumGeneralData data in curriData)
{
ddlCURRICULUM.Items.Insert(ddlCURRICULUM.Items.Count, new ListItem(data.Curr_Code + " " + data.Curr_ThaiName, data.Curr_Year + data.Curr_Code));
}
}
}
LoadTable();
//=============================
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
