public string insertScholarshipSource(ScholarshipSourceData 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 ScholarshipSource with: " + dataInsert.Source_Code;
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
sql = "Insert Into SCHOLARSHIP_SOURCE(SOURCE_CODE,SOURCE_THAINAME,SOURCE_ENGNAME) Values('" + dataInsert.Source_Code + "','" + dataInsert.Source_Thai + "','" + dataInsert.Source_Eng + "')";
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 ScholarshipSourceData getScholarshipSource(string scholarshipSource_code)
{
ScholarshipSourceData scholarship_data = new ScholarshipSourceData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From SCHOLARSHIP_SOURCE Where SOURCE_CODE='" + scholarshipSource_code + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
scholarship_data.Source_Code = rowData["SOURCE_CODE"].ToString();
scholarship_data.Source_Thai = rowData["SOURCE_THAINAME"].ToString();
scholarship_data.Source_Eng = rowData["SOURCE_ENGNAME"].ToString();
}
return(scholarship_data);
}
public List <ScholarshipSourceData> getScholarshipSource()
{
List <ScholarshipSourceData> scholarshipData = new List <ScholarshipSourceData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From SCHOLARSHIP_SOURCE Order By SOURCE_CODE";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
ScholarshipSourceData scholarship_data = new ScholarshipSourceData();
scholarship_data.Source_Code = rowData["SOURCE_CODE"].ToString();
scholarship_data.Source_Thai = rowData["SOURCE_THAINAME"].ToString();
scholarship_data.Source_Eng = rowData["SOURCE_ENGNAME"].ToString();
scholarshipData.Add(scholarship_data);
}
return(scholarshipData);
}
