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