public string insertAdmissionType(AdmissionTypeData dataInsert)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
sql = "Insert Into ADMISSION_TYPE(ADMISSIONTYPE_CODE, ADMISSIONTYPE_THAI, ADMISSIONTYPE_ENG) Values('" + dataInsert.AdmissionType_Code + "','" + dataInsert.AdmissionType_Thai + "','" + dataInsert.AdmissionType_Eng + "')";
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 string updateAdmissionType(AdmissionTypeData updateData)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Update ADMISSION_TYPE Set ADMISSIONTYPE_THAI = '" + updateData.AdmissionType_Thai + "', ADMISSIONTYPE_ENG='" + updateData.AdmissionType_Eng + "' Where ADMISSIONTYPE_CODE='" + updateData.AdmissionType_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 AdmissionTypeData getAdmissionType(string admissiontype_code)
{
AdmissionTypeData admissiontype = new AdmissionTypeData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string response = "";
try
{
oracleObj.SelectCommand = "Select * From ADMISSION_TYPE Where ADMISSIONTYPE_CODE='" + admissiontype_code + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
admissiontype.AdmissionType_Code = rowData["ADMISSIONTYPE_CODE"].ToString();
admissiontype.AdmissionType_Thai = rowData["ADMISSIONTYPE_THAI"].ToString();
admissiontype.AdmissionType_Eng = rowData["ADMISSIONTYPE_ENG"].ToString();
}
}
catch (Exception e)
{
response = e.Message.ToString();
HttpContext.Current.Session["response"] = "Unit Test:System Config: " + response;
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(admissiontype);
}
protected void btnSAVE_Click(object sender, EventArgs e)
{
AdmissionTypeData data = new AdmissionTypeData();
data.AdmissionType_Code = txtADMISSIONTYPE_CODE.Text;
data.AdmissionType_Thai = txtADMISSIONTYPE_THAI.Text;
data.AdmissionType_Eng = txtADMISSIONTYPE_ENG.Text;
string result = "";
try
{
result = new AdmissionType().updateAdmissionType(data);
if (result == "OK")
{
Response.Redirect("list_Admission_Type.aspx");
}
else
{
Response.Redirect("list_Admission_Type.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 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))
{
/*=============================*/
code = Request.QueryString["token"];
if (!Page.IsPostBack)
{
data = obj.getAdmissionType(code);
txtADMISSIONTYPE_CODE.Text = data.AdmissionType_Code;
txtADMISSIONTYPE_THAI.Text = data.AdmissionType_Thai;
txtADMISSIONTYPE_ENG.Text = data.AdmissionType_Eng;
}
/*=============================*/
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
protected void btnSAVE_Click(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))
{
/*=============================*/
string sql = "Select * From ADMISSION_TYPE Where ADMISSIONTYPE_CODE='" + txtADMISSIONTYPE_CODE.Text + "'";
List <AdmissionTypeData> chkDup = new AdmissionType().getAdmissionTypeManual(sql);
if (chkDup.Count > 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowBox", "alert('รหัสวิธีการรับเข้าซ้ำ!');", true);
}
else
{
AdmissionTypeData data = new AdmissionTypeData();
data.AdmissionType_Code = txtADMISSIONTYPE_CODE.Text;
data.AdmissionType_Thai = txtADMISSIONTYPE_THAI.Text;
data.AdmissionType_Eng = txtADMISSIONTYPE_ENG.Text;
string result = "";
result = new AdmissionType().insertAdmissionType(data);
if (result == "OK")
{
Response.Redirect("list_Admission_Type.aspx");
}
}
/*=============================*/
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
public List <AdmissionTypeData> getAdmissionType()
{
List <AdmissionTypeData> admissiontype_data = new List <AdmissionTypeData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From ADMISSION_TYPE Order By ADMISSIONTYPE_CODE";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
AdmissionTypeData admissiontype = new AdmissionTypeData();
admissiontype.AdmissionType_Code = rowData["ADMISSIONTYPE_CODE"].ToString();
admissiontype.AdmissionType_Thai = rowData["ADMISSIONTYPE_THAI"].ToString();
admissiontype.AdmissionType_Eng = rowData["ADMISSIONTYPE_ENG"].ToString();
admissiontype_data.Add(admissiontype);
}
return(admissiontype_data);
}
