public List <ScholarshipStudentHistory> getScholarshipHistoryByNationId(string nationId) { List <ScholarshipStudentHistory> scholarshipData = new List <ScholarshipStudentHistory>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = "SELECT * FROM SCHOLARSHIP_HISTORY WHERE NATION_ID = '" + nationId + "' Order by SCHOLARSHIP_STARTDATE"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { ScholarshipStudentHistory scholarship_data = new ScholarshipStudentHistory(); scholarship_data.SCHOLARSHIP_HISTORY_RECORD_DATE = rowData["RECORD_DATE"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_ACADEMIC_YEAR = rowData["ACADEMIC_YEAR"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_SEMESTER = rowData["SEMESTER"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_SCHOLARSHIP_CODE = rowData["SCHOLARSHIP_CODE"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_STUDENT_ID = rowData["STUDENT_ID"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_NATION_ID = rowData["NATION_ID"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_PASSPORT_ID = rowData["PASSPORT_ID"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_SCHOLARSHIP_STARTDATE = rowData["SCHOLARSHIP_STARTDATE"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_SCHOLARSHIP_ENDDATE = rowData["SCHOLARSHIP_ENDDATE"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_SCHOLARSHIP_PERIOD = rowData["SCHOLARSHIP_PERIOD"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_SCHOLARSHIP_AMOUNT = rowData["SCHOLARSHIP_AMOUNT"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_SCHOLARSHIP_IN_OUT = rowData["SCHOLARSHIP_IN_OUT"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_SCHOLARSHIP_TYPE = rowData["SCHOLARSHIP_TYPE"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_SCHOLARSHIP_SOURCE = rowData["SCHOLARSHIP_SOURCE"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_NEW_REGIS_FEE = rowData["NEW_REGIS_FEE"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_PROPERTIES_FEE = rowData["PROPERTIES_FEE"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_STUDY_FACILITY_FEE = rowData["STUDY_FACILITY_FEE"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_IT_FEE = rowData["IT_FEE"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_LIBRARY_FEE = rowData["LIBRARY_FEE"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_HEALTH_FEE = rowData["HEALTH_FEE"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_ACTIVITY_FEE = rowData["ACTIVITY_FEE"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_CREDIT_3000 = rowData["CREDIT_3000"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_ACCIDENT_FEE = rowData["ACCIDENT_FEE"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_BACHELOR_ACADEMIC_FEE = rowData["BACHELOR_ACADEMIC_FEE"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_MASTER_ACADEMIC_FEE = rowData["MASTER_ACADEMIC_FEE"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_SPECIAL_PROJECT_FEE = rowData["SPECIAL_PROJECT_FEE"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_SCHOLAR_FEE_COMMENT = rowData["SCHOLAR_FEE_COMMENT"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_MULTIPLE_SCHOLARSHIP = rowData["MULTIPLE_SCHOLARSHIP"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_SCHOLARSHIP_STATUS = rowData["SCHOLARSHIP_STATUS"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_FINE_FEE = rowData["FINE_FEE"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_HISTORY_STATUS = rowData["HISTORY_STATUS"].ToString(); scholarship_data.SCHOLARSHIP_HISTORY_RECORD_TIME = rowData["RECORD_TIME"].ToString(); scholarshipData.Add(scholarship_data); } return(scholarshipData); }
public string insertEditScholarshipHistory(ScholarshipStudentHistory 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 ScholarshipStudentHistory with: " + dataInsert.SCHOLARSHIP_HISTORY_STUDENT_ID + ", " + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_CODE; // 41 = เพิ่มใหม่ // 42 = แก้ไข string historyStatus = "42"; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = ""; sql = "Insert Into SCHOLARSHIP_HISTORY(RECORD_DATE, ACADEMIC_YEAR, SEMESTER, SCHOLARSHIP_CODE, STUDENT_ID, NATION_ID, PASSPORT_ID, SCHOLARSHIP_STARTDATE, SCHOLARSHIP_ENDDATE, SCHOLARSHIP_PERIOD, SCHOLARSHIP_AMOUNT, SCHOLARSHIP_IN_OUT, SCHOLARSHIP_TYPE, SCHOLARSHIP_SOURCE, NEW_REGIS_FEE, PROPERTIES_FEE, STUDY_FACILITY_FEE, IT_FEE, LIBRARY_FEE, HEALTH_FEE, ACTIVITY_FEE, CREDIT_3000, ACCIDENT_FEE, BACHELOR_ACADEMIC_FEE, MASTER_ACADEMIC_FEE, SPECIAL_PROJECT_FEE, SCHOLAR_FEE_COMMENT, MULTIPLE_SCHOLARSHIP, SCHOLARSHIP_STATUS, FINE_FEE, HISTORY_STATUS, RECORD_TIME) Values('" + dataInsert.SCHOLARSHIP_HISTORY_RECORD_DATE + "','" + dataInsert.SCHOLARSHIP_HISTORY_ACADEMIC_YEAR + "','" + dataInsert.SCHOLARSHIP_HISTORY_SEMESTER + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_CODE + "','" + dataInsert.SCHOLARSHIP_HISTORY_STUDENT_ID + "','" + dataInsert.SCHOLARSHIP_HISTORY_NATION_ID + "','" + dataInsert.SCHOLARSHIP_HISTORY_PASSPORT_ID + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_STARTDATE + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_ENDDATE + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_PERIOD + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_AMOUNT + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_IN_OUT + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_TYPE + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_SOURCE + "','" + dataInsert.SCHOLARSHIP_HISTORY_NEW_REGIS_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_PROPERTIES_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_STUDY_FACILITY_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_IT_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_LIBRARY_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_HEALTH_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_ACTIVITY_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_CREDIT_3000 + "','" + dataInsert.SCHOLARSHIP_HISTORY_ACCIDENT_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_BACHELOR_ACADEMIC_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_MASTER_ACADEMIC_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_SPECIAL_PROJECT_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLAR_FEE_COMMENT + "','" + dataInsert.SCHOLARSHIP_HISTORY_MULTIPLE_SCHOLARSHIP + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_STATUS + "','" + dataInsert.SCHOLARSHIP_HISTORY_FINE_FEE + "','" + historyStatus + "','" + dataInsert.SCHOLARSHIP_HISTORY_RECORD_TIME + "')"; 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); }