protected void btnSAVE_Click(object sender, EventArgs e)
{
StdGroupData data = new StdGroupData();
data.StdGroup_Code = txtGROUP_CODE.Text;
data.StdGroup_Thai = txtGROUP_THAINAME.Text;
data.StdGroup_Eng = txtGROUP_ENGNAME.Text;
string result = "";
try
{
result = new StdGroup().updateSection(data);
if (result == "OK")
{
Response.Redirect("list_Student_Group.aspx");
}
else
{
Response.Redirect("list_Student_Group.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 STUDENT_GROUP Where GROUP_CODE='" + txtGROUP_CODE.Text + "'";
List <StdGroupData> chkDup = new StdGroup().getStdGroupManual(sql);
if (chkDup.Count > 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowBox", "alert('รหัสกลุ่มผู้เรียนซ้ำ!');", true);
}
else
{
StdGroupData data = new StdGroupData();
data.StdGroup_Code = txtGROUP_CODE.Text;
data.StdGroup_Thai = txtGROUP_THAINAME.Text;
data.StdGroup_Eng = txtGROUP_ENGNAME.Text;
string result = "";
result = new StdGroup().insertSection(data);
if (result == "OK")
{
Response.Redirect("list_Student_Group.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.getStdGroup(code);
txtGROUP_CODE.Text = data.StdGroup_Code;
txtGROUP_THAINAME.Text = data.StdGroup_Thai;
txtGROUP_ENGNAME.Text = data.StdGroup_Eng;
}
/*=============================*/
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
public string insertSection(StdGroupData dataInsert)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
sql = "Insert Into STUDENT_GROUP(GROUP_CODE, GROUP_THAINAME, GROUP_ENGNAME) Values('" + dataInsert.StdGroup_Code + "','" + dataInsert.StdGroup_Thai + "','" + dataInsert.StdGroup_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 StdGroupData getStdGroup(string stdcategory_code)
{
StdGroupData StdGroup_data = new StdGroupData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string response = "";
try
{
oracleObj.SelectCommand = "Select * From STUDENT_GROUP Where GROUP_CODE='" + stdcategory_code + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
StdGroup_data.StdGroup_Code = rowData["GROUP_CODE"].ToString();
StdGroup_data.StdGroup_Thai = rowData["GROUP_THAINAME"].ToString();
StdGroup_data.StdGroup_Eng = rowData["GROUP_ENGNAME"].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(StdGroup_data);
}
public string updateSection(StdGroupData updateData)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Update STUDENT_GROUP Set GROUP_THAINAME = '" + updateData.StdGroup_Thai + "', GROUP_ENGNAME='" + updateData.StdGroup_Eng + "' Where GROUP_CODE='" + updateData.StdGroup_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);
}
//Pongsarun 26/2/2016: use for config system
public List <StdGroupData> getStdGroupManual(string sql)
{
List <StdGroupData> StdGroup_data = new List <StdGroupData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
StdGroupData StdGroup = new StdGroupData();
StdGroup.StdGroup_Code = rowData["GROUP_CODE"].ToString();
StdGroup.StdGroup_Thai = rowData["GROUP_THAINAME"].ToString();
StdGroup.StdGroup_Eng = rowData["GROUP_ENGNAME"].ToString();
StdGroup_data.Add(StdGroup);
}
return(StdGroup_data);
}
