public string insertScholarshipType(ScholarshipTypeData dataInsert)
{
string response = "";
UserLoginData loginData = new UserLoginData();
loginData = (UserLoginData)HttpContext.Current.Session["login_data"];
LogData log_data = new LogData();
log_data.ModuleCode = new LogData().Module_Scholarship;
log_data.Username = loginData.User_ID;
log_data.Message = "Insert ScholarshipType with: " + dataInsert.Type_Code;
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
sql = "Insert Into SCHOLARSHIP_TYPE(TYPE_CODE,TYPE_THAINAME,TYPE_ENGNAME,TYPE_CATALOG) Values('" + dataInsert.Type_Code + "','" + dataInsert.Type_Thai + "','" + dataInsert.Type_Eng + "','" + dataInsert.Type_Catalog + "')";
oracleObj.InsertCommand = sql;
try
{
if (oracleObj.Insert() == 1)
{
response = "OK";
log_data.StatusCode = log_data.LogStatus_SUCCESS;
}
else
{
log_data.StatusCode = log_data.LogStatus_FAILED;
}
}
catch (Exception e)
{
response = e.Message.ToString() + " ";
log_data.StatusCode = log_data.LogStatus_ERROR;
log_data.Message += " [" + e.ToString() + "]";
}
new Log().WriteLog(log_data);
return(response);
}
public ScholarshipTypeData getScholarshipType(string scholarshiptype_code)
{
ScholarshipTypeData scholarship_data = new ScholarshipTypeData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From SCHOLARSHIP_TYPE Where TYPE_CODE='" + scholarshiptype_code + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
scholarship_data.Type_Code = rowData["TYPE_CODE"].ToString();
scholarship_data.Type_Thai = rowData["TYPE_THAINAME"].ToString();
scholarship_data.Type_Eng = rowData["TYPE_ENGNAME"].ToString();
scholarship_data.Type_Catalog = rowData["TYPE_CATALOG"].ToString();
}
return(scholarship_data);
}
public List <ScholarshipTypeData> getScholarshipType()
{
List <ScholarshipTypeData> scholarshipData = new List <ScholarshipTypeData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From SCHOLARSHIP_TYPE Order By TYPE_CODE";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
ScholarshipTypeData scholarship_data = new ScholarshipTypeData();
scholarship_data.Type_Code = rowData["TYPE_CODE"].ToString();
scholarship_data.Type_Thai = rowData["TYPE_THAINAME"].ToString();
scholarship_data.Type_Eng = rowData["TYPE_ENGNAME"].ToString();
scholarship_data.Type_Catalog = rowData["TYPE_CATALOG"].ToString();
scholarshipData.Add(scholarship_data);
}
return(scholarshipData);
}
