public string insertLearningCenter(LearningCenterData dataInsert) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = ""; sql = "Insert Into LEARNING_CENTER(LEARNING_CEN_CODE, LEARNING_CEN_THAINAME, LEARNING_CEN_ENGNAME, LEARNING_CEN_STATUS) Values('" + dataInsert.LearningCenter_Code + "','" + dataInsert.LearningCenter_Thai + "','" + dataInsert.LearningCenter_Eng + "','" + dataInsert.LearningCenter_Status + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:System Config: " + response; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
public LearningCenterData getLearningCenter(string LearningCenter_Code) { string response = ""; LearningCenterData LearningCenter_data = new LearningCenterData(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); try { oracleObj.SelectCommand = "Select * From LEARNING_CENTER Where LEARNING_CEN_CODE='" + LearningCenter_Code + "'"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { LearningCenter_data.LearningCenter_Code = rowData["LEARNING_CEN_CODE"].ToString(); LearningCenter_data.LearningCenter_Thai = rowData["LEARNING_CEN_THAINAME"].ToString(); LearningCenter_data.LearningCenter_Eng = rowData["LEARNING_CEN_ENGNAME"].ToString(); LearningCenter_data.LearningCenter_Status = rowData["LEARNING_CEN_STATUS"].ToString(); } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:System Config: " + response; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(LearningCenter_data); }
public string updateLearningCenter(LearningCenterData updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Update LEARNING_CENTER Set LEARNING_CEN_THAINAME = '" + updateData.LearningCenter_Thai + "', LEARNING_CEN_ENGNAME='" + updateData.LearningCenter_Eng + "', LEARNING_CEN_STATUS='" + updateData.LearningCenter_Status + "' Where LEARNING_CEN_CODE='" + updateData.LearningCenter_Code + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:System Config: " + response; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
protected void btnSAVE_Click(object sender, EventArgs e) { string sql = "Select * From LEARNING_CENTER Where LEARNING_CEN_CODE='" + txtLEARNING_CEN_CODE.Text + "'"; List <CampusData> chkDup = new Campus().getCampusManual(sql); if (chkDup.Count > 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowBox", "alert('รหัสศูนย์การเรียนรู้ซ้ำ!');", true); } else { LearningCenterData data = new LearningCenterData(); data.LearningCenter_Code = txtLEARNING_CEN_CODE.Text; data.LearningCenter_Thai = txtLEARNING_CEN_THAINAME.Text; data.LearningCenter_Eng = txtLEARNING_CEN_ENGNAME.Text; data.LearningCenter_Status = ddlLEARNING_CEN_STATUS.SelectedValue; string result = ""; result = new LearningCenter().insertLearningCenter(data); if (result == "OK") { Response.Redirect("list_Learning_Center.aspx"); } } }
protected void btnSAVE_Click(object sender, EventArgs e) { LearningCenterData data = new LearningCenterData(); data.LearningCenter_Code = txtLEARNING_CEN_CODE.Text; data.LearningCenter_Thai = txtLEARNING_CEN_THAINAME.Text; data.LearningCenter_Eng = txtLEARNING_CEN_ENGNAME.Text; data.LearningCenter_Status = ddlLEARNING_CEN_STATUS.SelectedValue; string result = ""; result = new LearningCenter().updateLearningCenter(data); if (result == "OK") { Response.Redirect("list_Learning_Center.aspx"); } }
//Pongsarun 26/2/2016: use for config system public List <LearningCenterData> getLearningCenterManual(string sql) { List <LearningCenterData> LearningCenter_data = new List <LearningCenterData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { LearningCenterData LearningCenter = new LearningCenterData(); LearningCenter.LearningCenter_Code = rowData["LEARNING_CEN_CODE"].ToString(); LearningCenter.LearningCenter_Thai = rowData["LEARNING_CEN_THAINAME"].ToString(); LearningCenter.LearningCenter_Eng = rowData["LEARNING_CEN_ENGNAME"].ToString(); LearningCenter.LearningCenter_Status = rowData["LEARNING_CEN_STATUS"].ToString(); LearningCenter_data.Add(LearningCenter); } return(LearningCenter_data); }