// V1.0.0 public string updateConfig(StudentIDConfigData updateData) { string response = ""; string sql = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); try { // เพิ่มข้อมูลต้องมี Gen_Type แบบเดียวกัน oracleObj.SelectCommand = "Select * From STUDENT_ID_CONFIG Where ID=" + updateData.ID; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); if (allData.Count != 0) { sql = "Update STUDENT_ID_CONFIG Set NUM_OF_STUDENT = " + updateData.num_of_student + " Where FACULTY_CODE='" + updateData.Faculty_Code + "' And DEPARTMENT_CODE='" + updateData.Department_Code + "' And MAJOR_CODE='" + updateData.Major_Code + "' And DEGREE_ADMISSION='" + updateData.Degree_Admission + "' AND SEC_NO = '" + updateData.Sec_No + "'"; oracleObj.UpdateCommand = sql; if (oracleObj.Update() > 0) { response = "OK"; } } } catch { HttpContext.Current.Session["response"] = "Unit Test:StudentIDConfig:updateConfig" + " ไม่สามารถดำเนินการได้" + sql; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
// V1.0.0 public StudentIDConfigData getConfig(uint id) { StudentIDConfigData config_data = new StudentIDConfigData(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); try { oracleObj.SelectCommand = "Select * From STUDENT_ID_CONFIG Where ID=" + id; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { config_data.ID = Convert.ToInt32(rowData["ID"].ToString()); config_data.Faculty_Code = rowData["FACULTY_CODE"].ToString(); config_data.Department_Code = rowData["DEPARTMENT_CODE"].ToString(); config_data.Major_Code = rowData["MAJOR_CODE"].ToString(); config_data.Degree_Admission = rowData["DEGREE_ADMISSION"].ToString(); config_data.Admission_Type = rowData["ADMISSION_TYPE"].ToString(); config_data.Gen_Type = rowData["GEN_TYPE"].ToString(); config_data.Sec_No = rowData["SEC_NO"].ToString(); config_data.Project_Selected = rowData["PROJECT_SELECTED"].ToString(); config_data.Project_Code = rowData["PROJECT_CODE"].ToString(); config_data.Major_Student_ID = rowData["MAJOR_STUDENT_ID"].ToString(); config_data.num_of_student = Convert.ToUInt32(rowData["NUM_OF_STUDENT"].ToString()); } } catch { HttpContext.Current.Session["response"] = "Unit Test:StudentIDConfig:getConfig" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(config_data); }
// V1.0.0 public string insertConfig(StudentIDConfigData insertData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); try { // เพิ่มข้อมูลต้องมี Gen_Type แบบเดียวกัน oracleObj.SelectCommand = "Select * From STUDENT_ID_CONFIG Where FACULTY_CODE='" + insertData.Faculty_Code + "' And DEPARTMENT_CODE='" + insertData.Department_Code + "' And MAJOR_CODE='" + insertData.Major_Code + "' And DEGREE_ADMISSION='" + insertData.Degree_Admission + "'"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); if (allData.Count != 0) { if (allData[0]["Gen_Type"].ToString() != "0") { response = "รหัสนักศึกษาหลักที่ 10 ถูกกำหนดรูปแบบ (ไม่ใช้หมายเลข) ไว้ก่อนแล้ว"; } else if (insertData.Gen_Type != "0") { response = "รหัสนักศึกษาหลักที่ 10 ถูกกำหนดรูปแบบ (ใช้หมายเลข) ไว้ก่อนแล้ว"; } else { oracleObj.SelectCommand = "Select * From STUDENT_ID_CONFIG Where FACULTY_CODE='" + insertData.Faculty_Code + "' And DEPARTMENT_CODE='" + insertData.Department_Code + "' And MAJOR_CODE='" + insertData.Major_Code + "' And DEGREE_ADMISSION='" + insertData.Degree_Admission + "' And ADMISSION_TYPE='" + insertData.Admission_Type + "' AND SEC_NO='" + insertData.Sec_No + "' AND PROJECT_CODE='" + insertData.Project_Code + "'"; DataView allData2 = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); if (allData2.Count > 0) { response = "ไม่สามารถกำหนด หมายเลขห้อง โดยใช้โครงการซ้ำซ้อนได้"; } else { oracleObj.SelectCommand = "Select NUM_OF_STUDENT From STUDENT_ID_CONFIG Where FACULTY_CODE='" + insertData.Faculty_Code + "' And DEPARTMENT_CODE='" + insertData.Department_Code + "' And MAJOR_CODE='" + insertData.Major_Code + "' And DEGREE_ADMISSION='" + insertData.Degree_Admission + "' AND SEC_NO='" + insertData.Sec_No + "'"; DataView allData3 = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); if (allData3.Count > 0) { if (insertData.num_of_student != Convert.ToUInt32(allData3[0]["NUM_OF_STUDENT"].ToString())) { response = "จำนวนนักศึกษา ถูกกำหนดไว้แล้ว คือ " + allData3[0]["NUM_OF_STUDENT"].ToString() + " คน"; } else { oracleObj.SelectCommand = "SELECT CONFIG_STD_ID_SEQ.NEXTVAL FROM DUAL"; DataView seq = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); int nextval = Convert.ToInt32(seq[0]["NEXTVAL"]); oracleObj.InsertCommand = "Insert Into STUDENT_ID_CONFIG(ID,FACULTY_CODE, DEPARTMENT_CODE, MAJOR_CODE, DEGREE_ADMISSION, ADMISSION_TYPE, GEN_TYPE, SEC_NO, PROJECT_CODE,PROJECT_SELECTED,MAJOR_STUDENT_ID,NUM_OF_STUDENT) Values(" + seq[0]["NEXTVAL"].ToString() + ",'" + insertData.Faculty_Code + "','" + insertData.Department_Code + "','" + insertData.Major_Code + "','" + insertData.Degree_Admission + "','" + insertData.Admission_Type + "','" + insertData.Gen_Type + "','" + insertData.Sec_No + "','" + insertData.Project_Code + "','" + insertData.Project_Selected + "','" + insertData.Major_Student_ID + "'," + insertData.num_of_student + ")"; if (oracleObj.Insert() == 1) { response = "OK"; } } } else { oracleObj.SelectCommand = "SELECT CONFIG_STD_ID_SEQ.NEXTVAL FROM DUAL"; DataView seq = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); int nextval = Convert.ToInt32(seq[0]["NEXTVAL"]); oracleObj.InsertCommand = "Insert Into STUDENT_ID_CONFIG(ID,FACULTY_CODE, DEPARTMENT_CODE, MAJOR_CODE, DEGREE_ADMISSION, ADMISSION_TYPE, GEN_TYPE, SEC_NO, PROJECT_CODE,PROJECT_SELECTED,MAJOR_STUDENT_ID,NUM_OF_STUDENT) Values(" + seq[0]["NEXTVAL"].ToString() + ",'" + insertData.Faculty_Code + "','" + insertData.Department_Code + "','" + insertData.Major_Code + "','" + insertData.Degree_Admission + "','" + insertData.Admission_Type + "','" + insertData.Gen_Type + "','" + insertData.Sec_No + "','" + insertData.Project_Code + "','" + insertData.Project_Selected + "','" + insertData.Major_Student_ID + "'," + insertData.num_of_student + ")"; if (oracleObj.Insert() == 1) { response = "OK"; } } } } } else { oracleObj.SelectCommand = "Select * From STUDENT_ID_CONFIG Where FACULTY_CODE='" + insertData.Faculty_Code + "' And DEPARTMENT_CODE='" + insertData.Department_Code + "' And DEGREE_ADMISSION='" + insertData.Degree_Admission + "' AND MAJOR_STUDENT_ID='" + insertData.Major_Student_ID + "'"; DataView allData4 = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); if (allData4.Count != 0) { if (allData4[0]["Gen_Type"].ToString() != insertData.Gen_Type) { response = "สาขาวิชานี้ ไม่สามารถเปลี่ยนรูปแบบการแบ่งห้องเรียนได้อีก"; } else { oracleObj.SelectCommand = "Select NUM_OF_STUDENT From STUDENT_ID_CONFIG Where FACULTY_CODE='" + insertData.Faculty_Code + "' And DEPARTMENT_CODE='" + insertData.Department_Code + "' And DEGREE_ADMISSION='" + insertData.Degree_Admission + "' AND MAJOR_STUDENT_ID='" + insertData.Major_Student_ID + "' AND SEC_NO='" + insertData.Sec_No + "'"; DataView allData5 = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); if (allData5.Count > 0) { if (insertData.num_of_student != Convert.ToUInt32(allData5[0]["NUM_OF_STUDENT"].ToString())) { response = "จำนวนนักศึกษาของสาขาวิชานี้ ถูกกำหนดไว้แล้ว คือ " + allData5[0]["NUM_OF_STUDENT"].ToString() + " คน"; } else { oracleObj.SelectCommand = "SELECT CONFIG_STD_ID_SEQ.NEXTVAL FROM DUAL"; DataView seq = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); int nextval = Convert.ToInt32(seq[0]["NEXTVAL"]); oracleObj.InsertCommand = "Insert Into STUDENT_ID_CONFIG(ID,FACULTY_CODE, DEPARTMENT_CODE, MAJOR_CODE, DEGREE_ADMISSION, ADMISSION_TYPE, GEN_TYPE, SEC_NO, PROJECT_CODE,PROJECT_SELECTED,MAJOR_STUDENT_ID,NUM_OF_STUDENT) Values(" + seq[0]["NEXTVAL"].ToString() + ",'" + insertData.Faculty_Code + "','" + insertData.Department_Code + "','" + insertData.Major_Code + "','" + insertData.Degree_Admission + "','" + insertData.Admission_Type + "','" + insertData.Gen_Type + "','" + insertData.Sec_No + "','" + insertData.Project_Code + "','" + insertData.Project_Selected + "','" + insertData.Major_Student_ID + "'," + insertData.num_of_student + ")"; if (oracleObj.Insert() == 1) { response = "OK"; } } } else { oracleObj.SelectCommand = "SELECT CONFIG_STD_ID_SEQ.NEXTVAL FROM DUAL"; DataView seq = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); int nextval = Convert.ToInt32(seq[0]["NEXTVAL"]); oracleObj.InsertCommand = "Insert Into STUDENT_ID_CONFIG(ID,FACULTY_CODE, DEPARTMENT_CODE, MAJOR_CODE, DEGREE_ADMISSION, ADMISSION_TYPE, GEN_TYPE, SEC_NO, PROJECT_CODE,PROJECT_SELECTED,MAJOR_STUDENT_ID,NUM_OF_STUDENT) Values(" + seq[0]["NEXTVAL"].ToString() + ",'" + insertData.Faculty_Code + "','" + insertData.Department_Code + "','" + insertData.Major_Code + "','" + insertData.Degree_Admission + "','" + insertData.Admission_Type + "','" + insertData.Gen_Type + "','" + insertData.Sec_No + "','" + insertData.Project_Code + "','" + insertData.Project_Selected + "','" + insertData.Major_Student_ID + "'," + insertData.num_of_student + ")"; if (oracleObj.Insert() == 1) { response = "OK"; } } } } else { oracleObj.SelectCommand = "SELECT CONFIG_STD_ID_SEQ.NEXTVAL FROM DUAL"; DataView seq = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); int nextval = Convert.ToInt32(seq[0]["NEXTVAL"]); oracleObj.InsertCommand = "Insert Into STUDENT_ID_CONFIG(ID,FACULTY_CODE, DEPARTMENT_CODE, MAJOR_CODE, DEGREE_ADMISSION, ADMISSION_TYPE, GEN_TYPE, SEC_NO, PROJECT_CODE,PROJECT_SELECTED,MAJOR_STUDENT_ID,NUM_OF_STUDENT) Values(" + seq[0]["NEXTVAL"].ToString() + ",'" + insertData.Faculty_Code + "','" + insertData.Department_Code + "','" + insertData.Major_Code + "','" + insertData.Degree_Admission + "','" + insertData.Admission_Type + "','" + insertData.Gen_Type + "','" + insertData.Sec_No + "','" + insertData.Project_Code + "','" + insertData.Project_Selected + "','" + insertData.Major_Student_ID + "'," + insertData.num_of_student + ")"; if (oracleObj.Insert() == 1) { response = "OK"; } } } } catch (Exception err) { HttpContext.Current.Session["response"] = "Unit Test:StudentIDConfig:insertConfig" + " ไม่สามารถดำเนินการได้ "; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
// V1.0.0 public List <StudentIDConfigData> getConfigs(String faculty_code, string department_code, string major_code, string degree_admission, string admission_type) { List <StudentIDConfigData> config_data = new List <StudentIDConfigData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Select * From STUDENT_ID_CONFIG Where 1 = 1"; if (faculty_code != "0") { sql += " And FACULTY_CODE='" + faculty_code + "'"; } if (department_code != "0") { sql += " And DEPARTMENT_CODE='" + department_code + "'"; } if (major_code != "0") { sql += " And MAJOR_CODE='" + major_code + "'"; } if (degree_admission != "0") { sql += " And DEGREE_ADMISSION='" + degree_admission + "'"; } if (admission_type != "0") { sql += " And ADMISSION_TYPE='" + admission_type + "'"; } try { oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { StudentIDConfigData config = new StudentIDConfigData(); config.ID = Convert.ToInt32(rowData["ID"].ToString()); config.Faculty_Code = rowData["FACULTY_CODE"].ToString(); config.Department_Code = rowData["DEPARTMENT_CODE"].ToString(); config.Major_Code = rowData["MAJOR_CODE"].ToString(); config.Degree_Admission = rowData["DEGREE_ADMISSION"].ToString(); config.Admission_Type = rowData["ADMISSION_TYPE"].ToString(); config.Gen_Type = rowData["GEN_TYPE"].ToString(); config.Sec_No = rowData["SEC_NO"].ToString(); config.Project_Selected = rowData["PROJECT_SELECTED"].ToString(); config.Project_Code = rowData["PROJECT_CODE"].ToString(); config.Major_Student_ID = rowData["MAJOR_STUDENT_ID"].ToString(); config.num_of_student = Convert.ToUInt32(rowData["NUM_OF_STUDENT"].ToString()); config_data.Add(config); } } catch { HttpContext.Current.Session["response"] = "Unit Test:StudentIDConfig:getConfigs" + " ไม่สามารถดำเนินการได้ "; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(config_data); }