protected void btnSAVE_Click(object sender, EventArgs e) { SpecialFieldData dataSave = new SpecialFieldData(); dataSave.SpecialField_Code = txtSPEC_FIELD_CODE.Text; dataSave.SpecialField_Eng = txtSPEC_FIELD_ENGNAME.Text; dataSave.SpecialField_FacultyCode = ddlFACULTY.SelectedValue; dataSave.SpecialField_ShortName = txtSPEC_FIELD_SHORTNAME.Text; dataSave.SpecialField_Status = ddlSPEC_FIELD_STATUS.SelectedValue; dataSave.SpecialField_Thai = txtSPEC_FIELD_THAINAME.Text; string result = ""; try { result = new SpecialField().updateSpecialField(dataSave); if (result == "OK") { Response.Redirect("list_Special_Field.aspx"); } else { Response.Redirect("list_Special_Field.aspx"); } } catch (Exception E) { //string response = E.Message.ToString(); //HttpContext.Current.Session["response"] = "Unit Test: " + response; //HttpContext.Current.Response.Redirect("err_response.aspx"); } }
protected void btnSAVE_Click(object sender, EventArgs e) { string sql = "Select * From SPECIAL_FIELD Where SPEC_FIELD_CODE='" + txtSPEC_FIELD_CODE.Text + "'"; List <SpecialFieldData> chkDup = new SpecialField().getSpecialFieldManual(sql); if (chkDup.Count > 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowBox", "alert('รหัสแขนงวิชาซ้ำ!');", true); } else { SpecialFieldData data = new SpecialFieldData(); data.SpecialField_Code = txtSPEC_FIELD_CODE.Text; data.SpecialField_Eng = txtSPEC_FIELD_ENGNAME.Text; data.SpecialField_FacultyCode = ddlFACULTY.SelectedValue; data.SpecialField_ShortName = txtSPEC_FIELD_SHORTNAME.Text; data.SpecialField_Status = ddlSPEC_FIELD_STATUS.SelectedValue; data.SpecialField_Thai = txtSPEC_FIELD_THAINAME.Text; string result = ""; result = new SpecialField().insertSpecialField(data); if (result == "OK") { Response.Redirect("list_Special_Field.aspx"); } } }
public List <SpecialFieldData> getSpecialFieldWithFaculty(String Faculty_Code) { List <SpecialFieldData> SpecialFielData = new List <SpecialFieldData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string response = ""; try { oracleObj.SelectCommand = "Select * From SPECIAL_FIELD Where FACULTY_CODE='" + Faculty_Code + "' And SPEC_FIELD_STATUS='0001'"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { SpecialFieldData SpecialField_data = new SpecialFieldData(); SpecialField_data.SpecialField_Code = rowData["SPEC_FIELD_CODE"].ToString(); SpecialField_data.SpecialField_Thai = rowData["SPEC_FIELD_THAINAME"].ToString(); SpecialField_data.SpecialField_Eng = rowData["SPEC_FIELD_ENGNAME"].ToString(); SpecialField_data.SpecialField_ShortName = rowData["SPEC_FIELD_SHORTNAME"].ToString(); SpecialField_data.SpecialField_FacultyCode = rowData["FACULTY_CODE"].ToString(); SpecialField_data.SpecialField_Status = rowData["SPEC_FIELD_STATUS"].ToString(); SpecialFielData.Add(SpecialField_data); } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:System Config: " + response; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(SpecialFielData); }
public string updateSpecialField(SpecialFieldData updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Update SPECIAL_FIELD Set SPEC_FIELD_THAINAME = '" + updateData.SpecialField_Thai + "', SPEC_FIELD_ENGNAME='" + updateData.SpecialField_Eng + "', SPEC_FIELD_SHORTNAME='" + updateData.SpecialField_ShortName + "', FACULTY_CODE='" + updateData.SpecialField_FacultyCode + "', SPEC_FIELD_STATUS='" + updateData.SpecialField_Status + "' Where SPEC_FIELD_CODE='" + updateData.SpecialField_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); }
public string insertSpecialField(SpecialFieldData dataInsert) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = ""; sql = "Insert Into SPECIAL_FIELD(SPEC_FIELD_CODE, SPEC_FIELD_THAINAME, SPEC_FIELD_ENGNAME, SPEC_FIELD_SHORTNAME, FACULTY_CODE, SPEC_FIELD_STATUS) Values('" + dataInsert.SpecialField_Code + "','" + dataInsert.SpecialField_Thai + "','" + dataInsert.SpecialField_Eng + "','" + dataInsert.SpecialField_ShortName + "','" + dataInsert.SpecialField_FacultyCode + "','" + dataInsert.SpecialField_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 List <SpecialFieldData> getCurriculumMajor(string Curriculum_Code, string curr_format, string curr_plan) { string curr_year = Curriculum_Code.Substring(0, 4); string curr_code = Curriculum_Code.Substring(4); List <SpecialFieldData> CurrMajor_Data = new List <SpecialFieldData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = "Select MAJORCODE From STRUCTUREPLAN Where CURRCODE='" + curr_code + "' AND CURRTYPECODE = '" + curr_plan + "' AND YEARVERSION='" + curr_year + "' AND CURRFORMATCODE='" + curr_format + "' Group By MAJORCODE Order By MAJORCODE"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { string major_code = rowData["MAJORCODE"].ToString(); SpecialFieldData currmajor_data = new SpecialFieldData(); currmajor_data = new SpecialField().getSpecialField(major_code); CurrMajor_Data.Add(currmajor_data); } return(CurrMajor_Data); }
//Pongsarun 26/2/2016: use for config system public List <SpecialFieldData> getSpecialFieldManual(string sql) { List <SpecialFieldData> SpecialFielData = new List <SpecialFieldData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { SpecialFieldData SpecialField_data = new SpecialFieldData(); SpecialField_data.SpecialField_Code = rowData["SPEC_FIELD_CODE"].ToString(); SpecialField_data.SpecialField_Thai = rowData["SPEC_FIELD_THAINAME"].ToString(); SpecialField_data.SpecialField_Eng = rowData["SPEC_FIELD_ENGNAME"].ToString(); SpecialField_data.SpecialField_ShortName = rowData["SPEC_FIELD_SHORTNAME"].ToString(); SpecialField_data.SpecialField_FacultyCode = rowData["FACULTY_CODE"].ToString(); SpecialField_data.SpecialField_Status = rowData["SPEC_FIELD_STATUS"].ToString(); SpecialFielData.Add(SpecialField_data); } return(SpecialFielData); }