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); }