// V1.0.0 public List <ConfigNewStudentRegData> getConfigNewStudentReg(string degree_char) { List <ConfigNewStudentRegData> configData = new List <ConfigNewStudentRegData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = ""; sql = "Select * From CONFIG_NEWSTD_REG Where DEGREE_CHAR='" + degree_char + "' Order By ACADEMIC_YEAR DESC, SEMESTER DESC, FACULTY_CODE"; try { oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { ConfigNewStudentRegData config_data = new ConfigNewStudentRegData(); config_data.academic_year = rowData["ACADEMIC_YEAR"].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.start_date = rowData["START_DATE"].ToString(); config_data.end_date = rowData["END_DATE"].ToString(); configData.Add(config_data); } } catch { HttpContext.Current.Session["response"] = "Unit Test:ConfigNewStudentReg:getConfigNewStudentReg" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(configData); }
// V1.0.0 public string updateConfigNewStudentReg(ConfigNewStudentRegData dataInsert) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = ""; sql = "Update CONFIG_NEWSTD_REG Set START_DATE='" + dataInsert.start_date + "',END_DATE='" + dataInsert.end_date + "' Where ACADEMIC_YEAR='" + dataInsert.academic_year + "' And SEMESTER='" + dataInsert.semester + "' And FACULTY_CODE='" + dataInsert.faculty_code + "' AND DEGREE_CHAR='" + dataInsert.degree_char + "' "; try { oracleObj.UpdateCommand = sql; if (oracleObj.Update() == 1) { response = "OK"; } } catch { HttpContext.Current.Session["response"] = "Unit Test:ConfigNewStudentReg:updateConfigNewStudentReg" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }