/// <summary> /// เรียกดูข้อมูลจากตาราง STUDENT_PROCEEDING /// </summary> /// <param name="sql">SQL Command</param> /// <returns>ข้อมูลจากตาราง STUDENT_PROCEEDING</returns> public List <StudentProceedingData> getStudentProceedingManual(string sql) { List <StudentProceedingData> data = new List <StudentProceedingData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { StudentProceedingData row = new StudentProceedingData(); row.StudentProceedingId = rowData["STUDENT_PROCEEDING_ID"].ToString(); row.StudentId = rowData["STUDENT_ID"].ToString(); row.StudentProceedingTitle = rowData["STUDENT_PROCEEDING_TITLE"].ToString(); row.ProceedingName = rowData["PROCEEDING_NAME"].ToString(); row.ProceedingDbLevel = rowData["PROCEEDING_DB_LEVEL"].ToString(); row.ProceedingDate = rowData["PROCEEDING_DATE"].ToString(); data.Add(row); } return(data); }
/// <summary> /// แก้ไขข้อมูลจากตาราง STUDENT_PROCEEDING /// เฉพาะข้อมูล STUDENT_PROCEEDING_TITLE, PROCEEDING_NAME, PROCEEDING_DB_LEVEL, PROCEEDING_DATE /// </summary> /// <param name="updateData">StudentEnglishTest Object</param> /// <returns>OK</returns> public string updateStudentProceeding(StudentProceedingData updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Update STUDENT_PROCEEDING Set STUDENT_PROCEEDING_TITLE = '" + updateData.StudentProceedingTitle + "', PROCEEDING_NAME = '" + updateData.ProceedingName + "', PROCEEDING_DB_LEVEL = '" + updateData.ProceedingDbLevel + "', PROCEEDING_DATE = '" + updateData.ProceedingDate + "' Where STUDENT_PROCEEDING_ID = '" + updateData.StudentProceedingId + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "OK"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateStudentProceeding: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// เพิ่มข้อมูลลงตาราง STUDENT_PROCEEDING /// </summary> /// <param name="dataInsert">StudentEnglishTest Object</param> /// <returns>OK</returns> public string insertStudentProceeding(StudentProceedingData dataInsert) { string response = ""; int sleepTime = 5000; string StudentProceedingId = dataInsert.StudentProceedingId; for (int i = 0; i < 10; i++) { if (getStudentProceeding(StudentProceedingId).StudentProceedingId != null) { Thread.Sleep(sleepTime); StudentProceedingId = getMaxIdStudentProceeding(); sleepTime += 5000; } else { dataInsert.StudentProceedingId = StudentProceedingId; break; } } ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Insert into STUDENT_PROCEEDING (STUDENT_PROCEEDING_ID, STUDENT_ID, STUDENT_PROCEEDING_TITLE, PROCEEDING_NAME, PROCEEDING_DB_LEVEL, PROCEEDING_DATE) values ('" + dataInsert.StudentProceedingId + "','" + dataInsert.StudentId + "','" + dataInsert.StudentProceedingTitle + "','" + dataInsert.ProceedingName + "','" + dataInsert.ProceedingDbLevel + "','" + dataInsert.ProceedingDate + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "OK"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "insertStudentProceeding: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// เรียกดูข้อมูลจากตาราง STUDENT_PROCEEDING /// </summary> /// <param name="StudentProceedingId">ลำดับ</param> /// <returns>ข้อมูลจากตาราง STUDENT_PROCEEDING</returns> public StudentProceedingData getStudentProceeding(string StudentProceedingId) { StudentProceedingData data = new StudentProceedingData(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = "Select * From STUDENT_PROCEEDING Where STUDENT_PROCEEDING_ID ='" + StudentProceedingId + "'"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { data.StudentProceedingId = rowData["STUDENT_PROCEEDING_ID"].ToString(); data.StudentId = rowData["STUDENT_ID"].ToString(); data.StudentProceedingTitle = rowData["STUDENT_PROCEEDING_TITLE"].ToString(); data.ProceedingName = rowData["PROCEEDING_NAME"].ToString(); data.ProceedingDbLevel = rowData["PROCEEDING_DB_LEVEL"].ToString(); data.ProceedingDate = rowData["PROCEEDING_DATE"].ToString(); } return(data); }