/// <summary> /// Table GRAD_INSTITUTE /// </summary> /// <returns></returns> public List <PreInstituteData> getPreInstitute() { List <PreInstituteData> data = new List <PreInstituteData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = "Select * From GRAD_INSTITUTE Order By INSTITUTE_CODE"; //oracleObj.SelectCommand = "SELECT * FROM GRAD_INSTITUTE WHERE ROWNUM <=100"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { PreInstituteData users = new PreInstituteData(); users.Institute_Code = rowData["INSTITUTE_CODE"].ToString(); users.Institute_Thainame = rowData["INSTITUTE_THAINAME"].ToString(); users.Institute_Engname = rowData["INSTITUTE_ENGNAME"].ToString(); users.Institute_Province_Code = rowData["INSTITUTE_PROVINCE_CODE"].ToString(); data.Add(users); } return(data); }
protected void btnSAVE_Click(object sender, EventArgs e) { PreInstituteData preInstituteSave = new PreInstituteData(); preInstituteSave.Institute_Code = txtINSTITUTE_CODE.Text; preInstituteSave.Institute_Thainame = txtINSTITUTE_THAINAME.Text; preInstituteSave.Institute_Engname = txtINSTITUTE_ENGNAME.Text; preInstituteSave.Institute_Province_Code = ddlINSTITUTE_PROVINCE.SelectedValue; String result = new PreInstitute().updatePreInstitute(preInstituteSave); Response.Redirect("list_Grad_Institute.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (Session["login_data"] == null) { Response.Redirect("../index.aspx"); } else { //ตรวจสอบสิทธิ์ login_data = (UserLoginData)Session["login_data"]; if (autro_obj.CheckGroupUser(login_data, group_var.admin_university) || autro_obj.CheckGroupUser(login_data, group_var.admin_faculty)) { /*=============================*/ Institute_Code = Request.QueryString["Institute_Code"]; if (!Page.IsPostBack) { preInstituteData = preInstituteObj.getPreInstitute(Institute_Code); txtINSTITUTE_CODE.Text = preInstituteData.Institute_Code; txtINSTITUTE_THAINAME.Text = preInstituteData.Institute_Thainame; txtINSTITUTE_ENGNAME.Text = preInstituteData.Institute_Engname; provinceData = provinceObj.getProvince(); foreach (ProvinceData data in provinceData) { ddlINSTITUTE_PROVINCE.Items.Insert(ddlINSTITUTE_PROVINCE.Items.Count, new ListItem(data.Province_ThaiName, data.Province_Code)); } if (preInstituteData.Institute_Province_Code != "") { ddlINSTITUTE_PROVINCE.Items.FindByValue(preInstituteData.Institute_Province_Code).Selected = true; } } /*=============================*/ } else { HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน"; HttpContext.Current.Response.Redirect("err_response.aspx"); } } }
/// <summary> /// Table GRAD_INSTITUTE /// </summary> /// <param name="Institute_Code"></param> /// <returns></returns> public PreInstituteData getPreInstitute(string Institute_Code) { PreInstituteData data = new PreInstituteData(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = "Select * From GRAD_INSTITUTE Where INSTITUTE_CODE='" + Institute_Code + "'"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { data.Institute_Code = rowData["INSTITUTE_CODE"].ToString(); data.Institute_Thainame = rowData["INSTITUTE_THAINAME"].ToString(); data.Institute_Engname = rowData["INSTITUTE_ENGNAME"].ToString(); data.Institute_Province_Code = rowData["INSTITUTE_PROVINCE_CODE"].ToString(); } return(data); }
/// <summary> /// Table GRAD_INSTITUTE /// </summary> /// <param name="sql"></param> /// <returns></returns> public List <PreInstituteData> getPreInstituteManual(string sql) { List <PreInstituteData> data = new List <PreInstituteData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { PreInstituteData users = new PreInstituteData(); users.Institute_Code = rowData["INSTITUTE_CODE"].ToString(); users.Institute_Thainame = rowData["INSTITUTE_THAINAME"].ToString(); users.Institute_Engname = rowData["INSTITUTE_ENGNAME"].ToString(); users.Institute_Province_Code = rowData["INSTITUTE_PROVINCE_CODE"].ToString(); data.Add(users); } return(data); }
/// <summary> /// Table GRAD_INSTITUTE /// </summary> /// <param name="updateData"></param> /// <returns></returns> public string updatePreInstitute(PreInstituteData updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "UPDATE GRAD_INSTITUTE SET INSTITUTE_THAINAME = '" + updateData.Institute_Thainame + "', INSTITUTE_ENGNAME = '" + updateData.Institute_Engname + "', INSTITUTE_PROVINCE_CODE = '" + updateData.Institute_Province_Code + "' WHERE INSTITUTE_CODE = '" + updateData.Institute_Code + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString() + " "; } return(response); }
/// <summary> /// Table GRAD_INSTITUTE /// </summary> /// <param name="dataInsert"></param> /// <returns></returns> public string insertPreInstitute(PreInstituteData dataInsert) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Insert Into GRAD_INSTITUTE (INSTITUTE_CODE, INSTITUTE_THAINAME, INSTITUTE_ENGNAME, INSTITUTE_PROVINCE_CODE) Values ('" + dataInsert.Institute_Code + "','" + dataInsert.Institute_Thainame + "','" + dataInsert.Institute_Engname + "','" + dataInsert.Institute_Province_Code + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); } return(response); }