public string insertLearningCenter(LearningCenterData dataInsert)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
sql = "Insert Into LEARNING_CENTER(LEARNING_CEN_CODE, LEARNING_CEN_THAINAME, LEARNING_CEN_ENGNAME, LEARNING_CEN_STATUS) Values('" + dataInsert.LearningCenter_Code + "','" + dataInsert.LearningCenter_Thai + "','" + dataInsert.LearningCenter_Eng + "','" + dataInsert.LearningCenter_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 LearningCenterData getLearningCenter(string LearningCenter_Code)
{
string response = "";
LearningCenterData LearningCenter_data = new LearningCenterData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
try
{
oracleObj.SelectCommand = "Select * From LEARNING_CENTER Where LEARNING_CEN_CODE='" + LearningCenter_Code + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
LearningCenter_data.LearningCenter_Code = rowData["LEARNING_CEN_CODE"].ToString();
LearningCenter_data.LearningCenter_Thai = rowData["LEARNING_CEN_THAINAME"].ToString();
LearningCenter_data.LearningCenter_Eng = rowData["LEARNING_CEN_ENGNAME"].ToString();
LearningCenter_data.LearningCenter_Status = rowData["LEARNING_CEN_STATUS"].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(LearningCenter_data);
}
public string updateLearningCenter(LearningCenterData updateData)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Update LEARNING_CENTER Set LEARNING_CEN_THAINAME = '" + updateData.LearningCenter_Thai + "', LEARNING_CEN_ENGNAME='" + updateData.LearningCenter_Eng + "', LEARNING_CEN_STATUS='" + updateData.LearningCenter_Status + "' Where LEARNING_CEN_CODE='" + updateData.LearningCenter_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);
}
protected void btnSAVE_Click(object sender, EventArgs e)
{
string sql = "Select * From LEARNING_CENTER Where LEARNING_CEN_CODE='" + txtLEARNING_CEN_CODE.Text + "'";
List <CampusData> chkDup = new Campus().getCampusManual(sql);
if (chkDup.Count > 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowBox", "alert('รหัสศูนย์การเรียนรู้ซ้ำ!');", true);
}
else
{
LearningCenterData data = new LearningCenterData();
data.LearningCenter_Code = txtLEARNING_CEN_CODE.Text;
data.LearningCenter_Thai = txtLEARNING_CEN_THAINAME.Text;
data.LearningCenter_Eng = txtLEARNING_CEN_ENGNAME.Text;
data.LearningCenter_Status = ddlLEARNING_CEN_STATUS.SelectedValue;
string result = "";
result = new LearningCenter().insertLearningCenter(data);
if (result == "OK")
{
Response.Redirect("list_Learning_Center.aspx");
}
}
}
protected void btnSAVE_Click(object sender, EventArgs e)
{
LearningCenterData data = new LearningCenterData();
data.LearningCenter_Code = txtLEARNING_CEN_CODE.Text;
data.LearningCenter_Thai = txtLEARNING_CEN_THAINAME.Text;
data.LearningCenter_Eng = txtLEARNING_CEN_ENGNAME.Text;
data.LearningCenter_Status = ddlLEARNING_CEN_STATUS.SelectedValue;
string result = "";
result = new LearningCenter().updateLearningCenter(data);
if (result == "OK")
{
Response.Redirect("list_Learning_Center.aspx");
}
}
//Pongsarun 26/2/2016: use for config system
public List <LearningCenterData> getLearningCenterManual(string sql)
{
List <LearningCenterData> LearningCenter_data = new List <LearningCenterData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
LearningCenterData LearningCenter = new LearningCenterData();
LearningCenter.LearningCenter_Code = rowData["LEARNING_CEN_CODE"].ToString();
LearningCenter.LearningCenter_Thai = rowData["LEARNING_CEN_THAINAME"].ToString();
LearningCenter.LearningCenter_Eng = rowData["LEARNING_CEN_ENGNAME"].ToString();
LearningCenter.LearningCenter_Status = rowData["LEARNING_CEN_STATUS"].ToString();
LearningCenter_data.Add(LearningCenter);
}
return(LearningCenter_data);
}