/// <summary> /// แก้ไขข้อมูลจากตาราง COURSESUBJECTTYPE /// </summary> /// <param name="updateData">CourseSubjectType Object</param> /// <returns>Success</returns> public string updateCourseSubjectType(CourseSubjectType updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Update COURSESUBJECTTYPE Set COURSETYPETHAINAME = '" + updateData.CourseTypeThaiName + "', COURSETYPEENGNAME = '" + updateData.CourseTypeEngName + "' Where COURSETYPECODE = '" + updateData.CourseTypeCode + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateCourseSubjectType: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// เพิ่มข้อมูลลงตาราง COURSESUBJECTTYPE /// </summary> /// <param name="dataInsert">CourseSubjectType Object</param> /// <returns>Success</returns> public string insertCourseSubjectType(CourseSubjectType dataInsert) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Insert into COURSESUBJECTTYPE (COURSETYPECODE, COURSETYPETHAINAME, COURSETYPEENGNAME) values ('" + dataInsert.CourseTypeCode + "','" + dataInsert.CourseTypeThaiName + "','" + dataInsert.CourseTypeEngName + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "insertCourseSubjectType: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// เรียกดูข้อมูลจากตาราง COURSESUBJECTTYPE /// </summary> /// <param name="CourseTypeCode">รหัสข้อมูลกลุ่มวิชา</param> /// <returns>ข้อมูลจากตาราง COURSESUBJECTTYPE</returns> public CourseSubjectType getCourseSubjectType(string CourseTypeCode) { CourseSubjectType CourseSubjectTypeData = new CourseSubjectType(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = "Select * From COURSESUBJECTTYPE Where COURSETYPECODE='" + CourseTypeCode + "'"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { CourseSubjectTypeData.CourseTypeCode = rowData["COURSETYPECODE"].ToString(); CourseSubjectTypeData.CourseTypeThaiName = rowData["COURSETYPETHAINAME"].ToString(); CourseSubjectTypeData.CourseTypeEngName = rowData["COURSETYPEENGNAME"].ToString(); } return(CourseSubjectTypeData); }
protected void Page_Load(object sender, EventArgs e) { CurrCode = Request.QueryString["CurrCode"]; YearVersion = Request.QueryString["YearVersion"]; CurrFormatCode = Request.QueryString["CurrFormatCode"]; CurrTypeCode = Request.QueryString["CurrTypeCode"]; MajorCode = Request.QueryString["MajorCode"]; CategoryCode = Request.QueryString["CategoryCode"]; CourseGroupCode = Request.QueryString["CourseGroupCode"]; if (!Page.IsPostBack) { lblTitle.Text = new CourseGroup().getCourseGroup(CourseGroupCode).CourseGroupThName; List <CourseSubjectType> courseSubjectType = new CourseSubjectType().getCourseSubjectType(); ddlCOURSE_TYPE.Items.Clear(); foreach (CourseSubjectType row in courseSubjectType) { ddlCOURSE_TYPE.Items.Insert(ddlCOURSE_TYPE.Items.Count, new ListItem(row.CourseTypeThaiName, row.CourseTypeCode)); } } }
/// <summary> /// เรียกดูข้อมูลจากตาราง COURSESUBJECTTYPE /// </summary> /// <returns>ข้อมูลจากตาราง COURSESUBJECTTYPE</returns> public List <CourseSubjectType> getCourseSubjectType() { List <CourseSubjectType> CourseSubjectTypeData = new List <CourseSubjectType>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = "Select * From COURSESUBJECTTYPE Order By COURSETYPECODE"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { CourseSubjectType CourseSubjectTypeRow = new CourseSubjectType(); CourseSubjectTypeRow.CourseTypeCode = rowData["COURSETYPECODE"].ToString(); CourseSubjectTypeRow.CourseTypeThaiName = rowData["COURSETYPETHAINAME"].ToString(); CourseSubjectTypeRow.CourseTypeEngName = rowData["COURSETYPEENGNAME"].ToString(); CourseSubjectTypeData.Add(CourseSubjectTypeRow); } return(CourseSubjectTypeData); }