public BankCardData getStdBankCard(string student_id)
{
BankCardData bankcard_data = new BankCardData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From BANK_CARDSTUDENT Where STUDENT_ID='" + student_id + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
bankcard_data.StudentID = rowData["STUDENT_ID"].ToString();
bankcard_data.DegreeAdmissionCode = rowData["DEGREE_ADMISSION_CODE"].ToString();
bankcard_data.DegreeChar = rowData["DEGREE_CHAR"].ToString();
bankcard_data.FacultyCode = rowData["FACULTY_CODE"].ToString();
bankcard_data.SubmitDate = rowData["SUBMIT_DATE"].ToString();
bankcard_data.BankStaffCode = rowData["BANK_STAFF_CODE"].ToString();
}
return(bankcard_data);
}
public string insertBankCard(BankCardData insertData)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.InsertCommand = "Insert Into BANK_CARDSTUDENT(STUDENT_ID,DEGREE_ADMISSION_CODE,DEGREE_CHAR,FACULTY_CODE,SUBMIT_DATE,BANK_STAFF_CODE) Values('" + insertData.StudentID + "','" + insertData.DegreeAdmissionCode + "','" + insertData.DegreeChar + "','" + insertData.FacultyCode + "','" + insertData.SubmitDate + "','" + insertData.BankStaffCode + "')";
try
{
if (oracleObj.Insert() == 1)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString();
}
return(response);
}
public List <BankCardData> getBankCard(string startSubmitDate, string endSubmitDate)
{
List <BankCardData> bankcardData = new List <BankCardData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
DataView allStudent = new DataView();
oracleObj.SelectCommand = "Select * From BANK_CARDSTUDENT,GRAD_STUDENT,GRAD_STUDENT_INFORMATION Where BANK_CARDSTUDENT.SUBMIT_DATE BETWEEN '" + startSubmitDate + "' And '" + endSubmitDate + "' And GRAD_STUDENT.student_id=bank_cardstudent.student_id AND GRAD_STUDENT_INFORMATION.student_id = GRAD_STUDENT.student_id Order By BANK_CARDSTUDENT.SUBMIT_DATE DESC";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
BankCardData bankcard_data = new BankCardData();
bankcard_data.StudentID = rowData["STUDENT_ID"].ToString();
bankcard_data.Student_ID = rowData["STUDENT_ID"].ToString();
bankcard_data.Degree_Admission = rowData["DEGREE_ADMISSION_CODE"].ToString();
bankcard_data.Faculty_Code = rowData["FACULTY_CODE"].ToString();
bankcard_data.DegreeAdmissionCode = rowData["DEGREE_ADMISSION_CODE"].ToString();
bankcard_data.DegreeChar = rowData["DEGREE_CHAR"].ToString();
bankcard_data.FacultyCode = rowData["FACULTY_CODE"].ToString();
bankcard_data.SubmitDate = rowData["SUBMIT_DATE"].ToString();
bankcard_data.BankStaffCode = rowData["BANK_STAFF_CODE"].ToString();
bankcard_data.Curri_Code = rowData["CURRI_CODE"].ToString();
bankcard_data.Study_Year = rowData["STUDY_YEAR"].ToString();
bankcard_data.Plan_Code = rowData["PLAN_CODE"].ToString();
bankcard_data.Project_Code = rowData["PROJECT_CODE"].ToString();
bankcard_data.Campus_Code = rowData["CAMPUS_CODE"].ToString();
bankcard_data.Learning_Cen_Code = rowData["LEARNING_CEN_CODE"].ToString();
//bankcard_data.Faculty_Code = rowData["FACULTY_CODE"].ToString();
bankcard_data.Department_Code = rowData["DEPARTMENT_CODE"].ToString();
bankcard_data.Major_Code = rowData["MAJOR_CODE"].ToString();
bankcard_data.Spec_Field_Code = rowData["SPEC_FIELD_CODE"].ToString();
//bankcard_data.Segment_Code = rowData["SEGMENT_CODE"].ToString();
//bankcard_data.Advisor_ID = rowData["ADVISOR_ID"].ToString();
//bankcard_data.Section_Code = rowData["SECTION_CODE"].ToString();
bankcard_data.Date_Admission = rowData["DATE_ADMISSION"].ToString();
bankcard_data.Semester_Admission = rowData["SEMESTER_ADMISSION"].ToString();
bankcard_data.Year_Admission = rowData["YEAR_ADMISSION"].ToString();
//bankcard_data.Degree_Admission = rowData["DEGREE_ADMISSION_CODE"].ToString();
bankcard_data.preDegree_Code = rowData["PRE_DEGREE_CODE"].ToString();
bankcard_data.preInstitution = rowData["PRE_INSTITUTION"].ToString();
bankcard_data.preAcademicYear = rowData["PRE_ACADEMICYEAR"].ToString();
bankcard_data.preGPA = float.Parse(rowData["PRE_GPA"].ToString());
bankcard_data.preQualification_Code = rowData["PRE_QUALIFICATION_CODE"].ToString();
bankcard_data.preMojor_Code = rowData["PRE_MOJOR_CODE"].ToString();
bankcard_data.Std_Category_Code = rowData["STD_CATEGORY_CODE"].ToString();
bankcard_data.Std_Photo = rowData["STD_PHOTO"].ToString();
bankcard_data.Maintaining_Fee = Convert.ToInt32(rowData["MAINTAINING_FEE"].ToString());
bankcard_data.Cooperative = rowData["COOPERATIVE_STATUS"].ToString();
bankcard_data.Study_Status = rowData["STUDY_STATUS"].ToString();
bankcard_data.Student_Status = rowData["STUDENT_STATUS"].ToString();
bankcard_data.Term_Of_Status = rowData["TERM_OF_STATUS"].ToString();
bankcard_data.Scholarship_Status = rowData["SCHOLARSHIP_STATUS"].ToString();
bankcard_data.Nation_ID = rowData["NATION_ID"].ToString();
bankcard_data.NationCard_Expire = rowData["NATIONCARD_EXPIRE"].ToString();
bankcard_data.Passport_ID = rowData["PASSPORT_ID"].ToString();
bankcard_data.PassportCard_Expire = rowData["PASSPORTCARD_EXPIRE"].ToString();
bankcard_data.Country_Code = rowData["COUNTRY_CODE"].ToString();
bankcard_data.Gender = rowData["GENDER"].ToString();
bankcard_data.Prefix_Code = rowData["PREFIX_CODE"].ToString();
bankcard_data.Title_ThaiName = rowData["TITLE_THAINAME"].ToString();
bankcard_data.First_ThaiName = rowData["FIRST_THAINAME"].ToString();
bankcard_data.Family_ThaiName = rowData["FAMILY_THAINAME"].ToString();
bankcard_data.Title_EngName = rowData["TITLE_ENGNAME"].ToString();
bankcard_data.First_EngName = rowData["FIRST_ENGNAME"].ToString();
bankcard_data.Family_EngName = rowData["FAMILY_ENGNAME"].ToString();
bankcard_data.DateOfBirth = rowData["DATE_OF_BIRTH"].ToString();
bankcard_data.Province_BirthTH = rowData["PROVINCE_BIRTH_TH"].ToString();
bankcard_data.Province_BirthOther = rowData["PROVINCE_BIRTH_OTHER"].ToString();
bankcard_data.Nationality_Code = rowData["NATIONALITY_CODE"].ToString();
bankcard_data.Ethnicity_Code = rowData["ETHNICITY_CODE"].ToString();
bankcard_data.Religion_Code = rowData["RELIGION_CODE"].ToString();
bankcard_data.Blood_Code = rowData["BLOOD_CODE"].ToString();
bankcard_data.Height = float.Parse(rowData["HEIGHT"].ToString());
bankcard_data.Weight = float.Parse(rowData["WEIGHT"].ToString());
bankcard_data.Marital_Code = rowData["MARITAL_CODE"].ToString();
bankcard_data.Militaly_Code = rowData["MILITARY_CODE"].ToString();
bankcard_data.Disability = rowData["DISABILITY"].ToString();
bankcard_data.Home_Phone = rowData["HOME_PHONE"].ToString();
bankcard_data.Mobile_Number = rowData["MOBILE_NUMBER"].ToString();
bankcard_data.Email = rowData["EMAIL"].ToString();
bankcard_data.Talent = rowData["TALENT"].ToString();
bankcard_data.Home_Number = rowData["HOME_NUMBER"].ToString();
bankcard_data.Home_Village = rowData["HOME_VILLAGE"].ToString();
bankcard_data.Home_Moo = Convert.ToInt32(rowData["HOME_MOO"].ToString());
bankcard_data.Home_Soi = rowData["HOME_SOI"].ToString();
bankcard_data.Home_Road = rowData["HOME_ROAD"].ToString();
bankcard_data.Home_Tumbol = rowData["HOME_TUMBOL"].ToString();
bankcard_data.Home_Amphur = rowData["HOME_AMPHUR"].ToString();
bankcard_data.Home_Province = rowData["HOME_PROVINCE"].ToString();
bankcard_data.Home_PostCode = rowData["HOME_POSTCODE"].ToString();
bankcard_data.Home_Country = rowData["HOME_COUNTRY"].ToString();
bankcard_data.Home_AddressExt = rowData["HOME_ADDRESS_EXT"].ToString();
bankcardData.Add(bankcard_data);
}
oracleObj.SelectCommand = "Select * From BANK_CARDSTUDENT,STUDENT,STUDENT_INFORMATION Where BANK_CARDSTUDENT.SUBMIT_DATE BETWEEN '" + startSubmitDate + "' And '" + endSubmitDate + "' And STUDENT.student_id=bank_cardstudent.student_id AND STUDENT_INFORMATION.student_id = STUDENT.student_id Order By BANK_CARDSTUDENT.SUBMIT_DATE DESC";
DataView allData2 = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData2)
{
BankCardData bankcard_data = new BankCardData();
bankcard_data.StudentID = rowData["STUDENT_ID"].ToString();
bankcard_data.Student_ID = rowData["STUDENT_ID"].ToString();
bankcard_data.Degree_Admission = rowData["DEGREE_ADMISSION_CODE"].ToString();
bankcard_data.Faculty_Code = rowData["FACULTY_CODE"].ToString();
bankcard_data.DegreeAdmissionCode = rowData["DEGREE_ADMISSION_CODE"].ToString();
bankcard_data.DegreeChar = rowData["DEGREE_CHAR"].ToString();
bankcard_data.FacultyCode = rowData["FACULTY_CODE"].ToString();
bankcard_data.SubmitDate = rowData["SUBMIT_DATE"].ToString();
bankcard_data.BankStaffCode = rowData["BANK_STAFF_CODE"].ToString();
bankcard_data.Curri_Code = rowData["CURRI_CODE"].ToString();
bankcard_data.Study_Year = rowData["STUDY_YEAR"].ToString();
bankcard_data.Plan_Code = rowData["PLAN_CODE"].ToString();
bankcard_data.Project_Code = rowData["PROJECT_CODE"].ToString();
bankcard_data.Campus_Code = rowData["CAMPUS_CODE"].ToString();
bankcard_data.Learning_Cen_Code = rowData["LEARNING_CEN_CODE"].ToString();
//bankcard_data.Faculty_Code = rowData["FACULTY_CODE"].ToString();
bankcard_data.Department_Code = rowData["DEPARTMENT_CODE"].ToString();
bankcard_data.Major_Code = rowData["MAJOR_CODE"].ToString();
bankcard_data.Spec_Field_Code = rowData["SPEC_FIELD_CODE"].ToString();
//bankcard_data.Segment_Code = rowData["SEGMENT_CODE"].ToString();
//bankcard_data.Advisor_ID = rowData["ADVISOR_ID"].ToString();
//bankcard_data.Section_Code = rowData["SECTION_CODE"].ToString();
bankcard_data.Date_Admission = rowData["DATE_ADMISSION"].ToString();
bankcard_data.Semester_Admission = rowData["SEMESTER_ADMISSION"].ToString();
bankcard_data.Year_Admission = rowData["YEAR_ADMISSION"].ToString();
//bankcard_data.Degree_Admission = rowData["DEGREE_ADMISSION_CODE"].ToString();
bankcard_data.preDegree_Code = rowData["PRE_DEGREE_CODE"].ToString();
bankcard_data.preInstitution = rowData["PRE_INSTITUTION"].ToString();
bankcard_data.preAcademicYear = rowData["PRE_ACADEMICYEAR"].ToString();
bankcard_data.preGPA = float.Parse(rowData["PRE_GPA"].ToString());
bankcard_data.preQualification_Code = rowData["PRE_QUALIFICATION_CODE"].ToString();
bankcard_data.preMojor_Code = rowData["PRE_MOJOR_CODE"].ToString();
bankcard_data.Std_Category_Code = rowData["STD_CATEGORY_CODE"].ToString();
bankcard_data.Std_Photo = rowData["STD_PHOTO"].ToString();
bankcard_data.Maintaining_Fee = Convert.ToInt32(rowData["MAINTAINING_FEE"].ToString());
bankcard_data.Cooperative = rowData["COOPERATIVE_STATUS"].ToString();
bankcard_data.Study_Status = rowData["STUDY_STATUS"].ToString();
bankcard_data.Student_Status = rowData["STUDENT_STATUS"].ToString();
bankcard_data.Term_Of_Status = rowData["TERM_OF_STATUS"].ToString();
bankcard_data.Scholarship_Status = rowData["SCHOLARSHIP_STATUS"].ToString();
bankcard_data.Nation_ID = rowData["NATION_ID"].ToString();
bankcard_data.NationCard_Expire = rowData["NATIONCARD_EXPIRE"].ToString();
bankcard_data.Passport_ID = rowData["PASSPORT_ID"].ToString();
bankcard_data.PassportCard_Expire = rowData["PASSPORTCARD_EXPIRE"].ToString();
bankcard_data.Country_Code = rowData["COUNTRY_CODE"].ToString();
bankcard_data.Gender = rowData["GENDER"].ToString();
bankcard_data.Prefix_Code = rowData["PREFIX_CODE"].ToString();
bankcard_data.Title_ThaiName = rowData["TITLE_THAINAME"].ToString();
bankcard_data.First_ThaiName = rowData["FIRST_THAINAME"].ToString();
bankcard_data.Family_ThaiName = rowData["FAMILY_THAINAME"].ToString();
bankcard_data.Title_EngName = rowData["TITLE_ENGNAME"].ToString();
bankcard_data.First_EngName = rowData["FIRST_ENGNAME"].ToString();
bankcard_data.Family_EngName = rowData["FAMILY_ENGNAME"].ToString();
bankcard_data.DateOfBirth = rowData["DATE_OF_BIRTH"].ToString();
bankcard_data.Province_BirthTH = rowData["PROVINCE_BIRTH_TH"].ToString();
bankcard_data.Province_BirthOther = rowData["PROVINCE_BIRTH_OTHER"].ToString();
bankcard_data.Nationality_Code = rowData["NATIONALITY_CODE"].ToString();
bankcard_data.Ethnicity_Code = rowData["ETHNICITY_CODE"].ToString();
bankcard_data.Religion_Code = rowData["RELIGION_CODE"].ToString();
bankcard_data.Blood_Code = rowData["BLOOD_CODE"].ToString();
bankcard_data.Height = float.Parse(rowData["HEIGHT"].ToString());
bankcard_data.Weight = float.Parse(rowData["WEIGHT"].ToString());
bankcard_data.Marital_Code = rowData["MARITAL_CODE"].ToString();
bankcard_data.Militaly_Code = rowData["MILITARY_CODE"].ToString();
bankcard_data.Disability = rowData["DISABILITY"].ToString();
bankcard_data.Home_Phone = rowData["HOME_PHONE"].ToString();
bankcard_data.Mobile_Number = rowData["MOBILE_NUMBER"].ToString();
bankcard_data.Email = rowData["EMAIL"].ToString();
bankcard_data.Talent = rowData["TALENT"].ToString();
bankcard_data.Home_Number = rowData["HOME_NUMBER"].ToString();
bankcard_data.Home_Village = rowData["HOME_VILLAGE"].ToString();
bankcard_data.Home_Moo = Convert.ToInt32(rowData["HOME_MOO"].ToString());
bankcard_data.Home_Soi = rowData["HOME_SOI"].ToString();
bankcard_data.Home_Road = rowData["HOME_ROAD"].ToString();
bankcard_data.Home_Tumbol = rowData["HOME_TUMBOL"].ToString();
bankcard_data.Home_Amphur = rowData["HOME_AMPHUR"].ToString();
bankcard_data.Home_Province = rowData["HOME_PROVINCE"].ToString();
bankcard_data.Home_PostCode = rowData["HOME_POSTCODE"].ToString();
bankcard_data.Home_Country = rowData["HOME_COUNTRY"].ToString();
bankcard_data.Home_AddressExt = rowData["HOME_ADDRESS_EXT"].ToString();
bankcardData.Add(bankcard_data);
}
return(bankcardData);
}
