public ConfigStudentRegData getConfigStudentReg(string academic_year, string semester, string degree_char, string faculty_code, string student_academic_year)
{
ConfigStudentRegData config_data = new ConfigStudentRegData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
try
{
sql = "Select * From CONFIG_STD_REG Where ACADEMIC='" + academic_year + "' AND SEMESTER='" + semester + "' AND DEGREE_CHAR='" + degree_char + "' AND FACULTY_CODE='" + faculty_code + "' AND STUDENT_ACADEMIC_YEAR='" + student_academic_year + "' ";
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
config_data.academic_year = rowData["ACADEMIC"].ToString();
config_data.semester = rowData["SEMESTER"].ToString();
config_data.degree_char = rowData["DEGREE_CHAR"].ToString();;
config_data.faculty_code = rowData["FACULTY_CODE"].ToString();
config_data.student_academic_year = rowData["STUDENT_ACADEMIC_YEAR"].ToString();
config_data.start_date = rowData["START_DATE"].ToString();
config_data.end_date = rowData["STOP_DATE"].ToString();
config_data.due_date = rowData["DUE_DATE"].ToString();
}
}
catch
{
HttpContext.Current.Session["response"] = "Unit Test:ConfigStudentReg:getConfigStudentReg" + " ไม่สามารถดำเนินการได้" + sql;
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(config_data);
}
// V1.0.0
public string updateConfigStudentReg(ConfigStudentRegData dataUpdate)
{
string response = "";
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 = "Update ConfigStudentRegistration with: " + dataUpdate.start_date + "," + dataUpdate.end_date + "," + dataUpdate.due_date + "," + dataUpdate.academic_year + "," + dataUpdate.semester + "," + dataUpdate.degree_char + "," + dataUpdate.faculty_code + "," + dataUpdate.student_academic_year;
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
sql = "Update CONFIG_STD_REG SET START_DATE='" + dataUpdate.start_date + "',STOP_DATE = '" + dataUpdate.end_date + "',DUE_DATE = '" + dataUpdate.due_date + "' Where ACADEMIC='" + dataUpdate.academic_year + "' And SEMESTER='" + dataUpdate.semester + "' And DEGREE_CHAR='" + dataUpdate.degree_char + "' And FACULTY_CODE='" + dataUpdate.faculty_code + "' And STUDENT_ACADEMIC_YEAR='" + dataUpdate.student_academic_year + "' ";
try
{
oracleObj.UpdateCommand = sql;
if (oracleObj.Update() == 1)
{
log_data.StatusCode = log_data.LogStatus_SUCCESS;
response = "OK";
}
else
{
log_data.StatusCode = log_data.LogStatus_FAILED;
}
}
catch (Exception e)
{
log_data.StatusCode = log_data.LogStatus_ERROR;
log_data.Message += " [" + e.ToString() + "]";
HttpContext.Current.Session["response"] = "Unit Test:ConfigStudentReg:updateConfigStudentReg" + " ไม่สามารถดำเนินการได้ ";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
new Log().WriteLog(log_data);
return(response);
}
