/// <summary> /// แก้ไขข้อมูลจากตาราง ENGLISH_DB /// </summary> /// <param name="updateData">EnglishDb Object</param> /// <returns>OK</returns> public string updateEnglishDb(EnglishDbData updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Update ENGLISH_DB Set ENGLSIH_DB_NAME = '" + updateData.EnglishDbName + "' Where ENGLISH_DB_ID = '" + updateData.EnglishDbId + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "OK"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateEnglishDb: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// เพิ่มข้อมูลลงตาราง ENGLISH_DB /// </summary> /// <param name="dataInsert">EnglishDb Object</param> /// <returns>OK</returns> public string insertEnglishDb(EnglishDbData dataInsert) { string response = ""; int sleepTime = 5000; string EnglishDbId = dataInsert.EnglishDbId; for (int i = 0; i < 10; i++) { if (getEnglishDb(EnglishDbId).EnglishDbId != null) { Thread.Sleep(sleepTime); EnglishDbId = getMaxIdEnglishDb(); sleepTime += 5000; } else { dataInsert.EnglishDbId = EnglishDbId; break; } } ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Insert into ENGLISH_DB (ENGLISH_DB_ID, ENGLSIH_DB_NAME) values ('" + dataInsert.EnglishDbId + "','" + dataInsert.EnglishDbName + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "OK"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "insertEnglishDb: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// เรียกดูข้อมูลจากตาราง ENGLISH_DB /// </summary> /// <param name="EnglishDbId">ลำดับ</param> /// <returns>ข้อมูลจากตาราง ENGLISH_DB</returns> public EnglishDbData getEnglishDb(string EnglishDbId) { EnglishDbData data = new EnglishDbData(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = "Select * From ENGLISH_DB Where ENGLISH_DB_ID='" + EnglishDbId + "'"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { data.EnglishDbId = rowData["ENGLISH_DB_ID"].ToString(); data.EnglishDbName = rowData["ENGLSIH_DB_NAME"].ToString(); } return(data); }
/// <summary> /// เรียกดูข้อมูลจากตาราง ENGLISH_DB /// </summary> /// <returns>ข้อมูลจากตาราง ENGLISH_DB</returns> public List <EnglishDbData> getEnglishDb() { List <EnglishDbData> data = new List <EnglishDbData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = "Select * From ENGLISH_DB Order By ENGLISH_DB_ID"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { EnglishDbData row = new EnglishDbData(); row.EnglishDbId = rowData["ENGLISH_DB_ID"].ToString(); row.EnglishDbName = rowData["ENGLSIH_DB_NAME"].ToString(); data.Add(row); } return(data); }