public DegreeNameData getDegreeName(string degree_name_code)
{
DegreeNameData DegreeName_data = new DegreeNameData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From DEGREE_NAME Where DEGREE_NAME_CODE='" + degree_name_code + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
DegreeName_data.DegreeName_Code = rowData["DEGREE_NAME_CODE"].ToString();
DegreeName_data.DegreeName_Thai = rowData["DEGREE_NAME_THAI"].ToString();
DegreeName_data.DegreeName_Eng = rowData["DEGREE_NAME_ENG"].ToString();
DegreeName_data.DegreeName_ShortThai = rowData["DEGREE_NAME_SHORTTHAI"].ToString();
DegreeName_data.DegreeName_ShortEng = rowData["DEGREE_NAME_SHORTENG"].ToString();
}
return(DegreeName_data);
}
public List <DegreeNameData> getDegreeName()
{
List <DegreeNameData> DegreeName_data = new List <DegreeNameData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From DEGREE_NAME Order By DEGREE_NAME_CODE";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
DegreeNameData DegreeName = new DegreeNameData();
DegreeName.DegreeName_Code = rowData["DEGREE_NAME_CODE"].ToString();
DegreeName.DegreeName_Thai = rowData["DEGREE_NAME_THAI"].ToString();
DegreeName.DegreeName_Eng = rowData["DEGREE_NAME_ENG"].ToString();
DegreeName.DegreeName_ShortThai = rowData["DEGREE_NAME_SHORTTHAI"].ToString();
DegreeName.DegreeName_ShortEng = rowData["DEGREE_NAME_SHORTENG"].ToString();
DegreeName_data.Add(DegreeName);
}
return(DegreeName_data);
}
