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