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