/// <summary>
/// Table GRAD_INSTITUTE
/// </summary>
/// <returns></returns>
public List <PreInstituteData> getPreInstitute()
{
List <PreInstituteData> data = new List <PreInstituteData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From GRAD_INSTITUTE Order By INSTITUTE_CODE";
//oracleObj.SelectCommand = "SELECT * FROM GRAD_INSTITUTE WHERE ROWNUM <=100";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
PreInstituteData users = new PreInstituteData();
users.Institute_Code = rowData["INSTITUTE_CODE"].ToString();
users.Institute_Thainame = rowData["INSTITUTE_THAINAME"].ToString();
users.Institute_Engname = rowData["INSTITUTE_ENGNAME"].ToString();
users.Institute_Province_Code = rowData["INSTITUTE_PROVINCE_CODE"].ToString();
data.Add(users);
}
return(data);
}
protected void btnSAVE_Click(object sender, EventArgs e)
{
PreInstituteData preInstituteSave = new PreInstituteData();
preInstituteSave.Institute_Code = txtINSTITUTE_CODE.Text;
preInstituteSave.Institute_Thainame = txtINSTITUTE_THAINAME.Text;
preInstituteSave.Institute_Engname = txtINSTITUTE_ENGNAME.Text;
preInstituteSave.Institute_Province_Code = ddlINSTITUTE_PROVINCE.SelectedValue;
String result = new PreInstitute().updatePreInstitute(preInstituteSave);
Response.Redirect("list_Grad_Institute.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))
{
/*=============================*/
Institute_Code = Request.QueryString["Institute_Code"];
if (!Page.IsPostBack)
{
preInstituteData = preInstituteObj.getPreInstitute(Institute_Code);
txtINSTITUTE_CODE.Text = preInstituteData.Institute_Code;
txtINSTITUTE_THAINAME.Text = preInstituteData.Institute_Thainame;
txtINSTITUTE_ENGNAME.Text = preInstituteData.Institute_Engname;
provinceData = provinceObj.getProvince();
foreach (ProvinceData data in provinceData)
{
ddlINSTITUTE_PROVINCE.Items.Insert(ddlINSTITUTE_PROVINCE.Items.Count, new ListItem(data.Province_ThaiName, data.Province_Code));
}
if (preInstituteData.Institute_Province_Code != "")
{
ddlINSTITUTE_PROVINCE.Items.FindByValue(preInstituteData.Institute_Province_Code).Selected = true;
}
}
/*=============================*/
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
/// <summary>
/// Table GRAD_INSTITUTE
/// </summary>
/// <param name="Institute_Code"></param>
/// <returns></returns>
public PreInstituteData getPreInstitute(string Institute_Code)
{
PreInstituteData data = new PreInstituteData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From GRAD_INSTITUTE Where INSTITUTE_CODE='" + Institute_Code + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
data.Institute_Code = rowData["INSTITUTE_CODE"].ToString();
data.Institute_Thainame = rowData["INSTITUTE_THAINAME"].ToString();
data.Institute_Engname = rowData["INSTITUTE_ENGNAME"].ToString();
data.Institute_Province_Code = rowData["INSTITUTE_PROVINCE_CODE"].ToString();
}
return(data);
}
/// <summary>
/// Table GRAD_INSTITUTE
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public List <PreInstituteData> getPreInstituteManual(string sql)
{
List <PreInstituteData> data = new List <PreInstituteData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
PreInstituteData users = new PreInstituteData();
users.Institute_Code = rowData["INSTITUTE_CODE"].ToString();
users.Institute_Thainame = rowData["INSTITUTE_THAINAME"].ToString();
users.Institute_Engname = rowData["INSTITUTE_ENGNAME"].ToString();
users.Institute_Province_Code = rowData["INSTITUTE_PROVINCE_CODE"].ToString();
data.Add(users);
}
return(data);
}
/// <summary>
/// Table GRAD_INSTITUTE
/// </summary>
/// <param name="updateData"></param>
/// <returns></returns>
public string updatePreInstitute(PreInstituteData updateData)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "UPDATE GRAD_INSTITUTE SET INSTITUTE_THAINAME = '" + updateData.Institute_Thainame + "', INSTITUTE_ENGNAME = '" + updateData.Institute_Engname + "', INSTITUTE_PROVINCE_CODE = '" + updateData.Institute_Province_Code + "' WHERE INSTITUTE_CODE = '" + updateData.Institute_Code + "'";
oracleObj.UpdateCommand = sql;
try
{
if (oracleObj.Update() == 1)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString() + " ";
}
return(response);
}
/// <summary>
/// Table GRAD_INSTITUTE
/// </summary>
/// <param name="dataInsert"></param>
/// <returns></returns>
public string insertPreInstitute(PreInstituteData dataInsert)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Insert Into GRAD_INSTITUTE (INSTITUTE_CODE, INSTITUTE_THAINAME, INSTITUTE_ENGNAME, INSTITUTE_PROVINCE_CODE) Values ('" + dataInsert.Institute_Code + "','" + dataInsert.Institute_Thainame + "','" + dataInsert.Institute_Engname + "','" + dataInsert.Institute_Province_Code + "')";
oracleObj.InsertCommand = sql;
try
{
if (oracleObj.Insert() == 1)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString();
}
return(response);
}
