/// <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);
}
