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