public string getGenType(Qualified_Student student_data)
{
Qualified_Student qualifiedObj = new Qualified_Student();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string gen_type = "";
string studentid1_2 = student_data.Year_Admission.Substring(2, 2);
string studentid3_4 = student_data.Faculty_Code;
string studentid5_6 = student_data.Department_Code_StudentID;
string studentid7 = student_data.Major_Code_StudentID;
string studentid8 = student_data.Degree_Admission;
string studentid9 = student_data.Admission_Type;
string tmp_studentid = studentid1_2 + studentid3_4 + studentid5_6 + studentid7 + studentid8 + studentid9;
string table = qualifiedObj.getTableName(student_data.Degree_Char);
string sql = "Select GEN_GROUP From " + table + " Where STUDENT_ID Like '" + tmp_studentid + "%' group by GEN_GROUP";
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
gen_type = rowData["GEN_GROUP"].ToString();
}
return(gen_type);
}
//public List<string> getStudentID(string academic_year, string faculty_code, string department_code, string major_code, string degree_code, string admissiontype_code, string gen_type, string sec_number, int amount)
//{
// ConnectDB db = new ConnectDB();
// SqlDataSource oracleObj = db.ConnectionOracle();
// string sql = "";
// if (gen_type == "0") // ใช้ Sec
// {
// oracleObj.SelectCommand = "Select * From Run_Student_ID Where ACADEMIC_YEAR='" + academic_year + "' AND FACULTY_CODE='" + faculty_code + "' AND DEPARTMENT_CODE='" + department_code + "' AND MAJOR_CODE='" + major_code + "' AND DEGREE_CODE='" + degree_code + "' AND ADMISSION_TYPE='" + admissiontype_code + "' AND NUMBER1='" + sec_number + "' AND GEN_TYPE='" + gen_type + "'";
// DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
// string studentid1_2 = academic_year;
// string studentid3_4 = faculty_code;
// string studentid5_6 = department_code;
// string studentid7 = major_code;
// string studentid8 = degree_code;
// string studentid9 = admissiontype_code;
// string studentid10 = sec_number;
// if (allData.Count == 0)
// {
// for (int i = 1; i <= amount; i++)
// {
// string runNum = i.ToString("00");
// string studentid11 = runNum.Substring(0, 1);
// string studentid12 = runNum.Substring(1, 1);
// string tmp_studentid = studentid1_2 + studentid3_4 + studentid5_6 + studentid7 + studentid8 + studentid9 + studentid10 + studentid11 + studentid12;
// gen_student_id.Add(getCheckDigit(tmp_studentid));
// }
// }
// else
// {
// int start_num = 0;
// foreach (DataRowView rowData in allData)
// {
// int studentid11 = Convert.ToInt16(rowData["NUMBER2"]) * 10;
// int studentid12 = Convert.ToInt16(rowData["NUMBER3"]);
// start_num = studentid11 + studentid12;
// }
// for (int i = 1; i <= amount; i++)
// {
// int j = start_num + i;
// string runNum = j.ToString("00");
// string studentid11 = runNum.Substring(0, 1);
// string studentid12 = runNum.Substring(1, 1);
// string tmp_studentid = studentid1_2 + studentid3_4 + studentid5_6 + studentid7 + studentid8 + studentid9 + studentid10 + studentid11 + studentid12;
// gen_student_id.Add(getCheckDigit(tmp_studentid));
// }
// }
// }
// else if (gen_type == "1") // ไม่ใช้ Sec
// {
// oracleObj.SelectCommand = "Select * From Run_Student_ID Where ACADEMIC_YEAR='" + academic_year + "' AND FACULTY_CODE='" + faculty_code + "' AND DEPARTMENT_CODE='" + department_code + "' AND MAJOR_CODE='" + major_code + "' AND DEGREE_CODE='" + degree_code + "' AND ADMISSION_TYPE='" + admissiontype_code + "' AND GEN_TYPE='" + gen_type + "'";
// DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
// string studentid1_2 = academic_year;
// string studentid3_4 = faculty_code;
// string studentid5_6 = department_code;
// string studentid7 = major_code;
// string studentid8 = degree_code;
// string studentid9 = admissiontype_code;
// if (allData.Count == 0)
// {
// for (int i = 1; i <= amount; i++)
// {
// string runNum = i.ToString("000");
// string studentid10 = runNum.Substring(0, 1);
// string studentid11 = runNum.Substring(1, 1);
// string studentid12 = runNum.Substring(2, 1);
// string tmp_studentid = studentid1_2 + studentid3_4 + studentid5_6 + studentid7 + studentid8 + studentid9 + studentid10 + studentid11 + studentid12;
// gen_student_id.Add(getCheckDigit(tmp_studentid));
// }
// }
// else
// {
// int start_num = 0;
// foreach (DataRowView rowData in allData)
// {
// int studentid10 = Convert.ToInt16(rowData["NUMBER1"]) * 100;
// int studentid11 = Convert.ToInt16(rowData["NUMBER2"]) * 10;
// int studentid12 = Convert.ToInt16(rowData["NUMBER3"]);
// start_num = studentid10 + studentid11 + studentid12;
// }
// for (int i = 1; i <= amount; i++)
// {
// int j = start_num + i;
// string runNum = j.ToString("000");
// string studentid10 = runNum.Substring(0, 1);
// string studentid11 = runNum.Substring(1, 1);
// string studentid12 = runNum.Substring(2, 1);
// string tmp_studentid = studentid1_2 + studentid3_4 + studentid5_6 + studentid7 + studentid8 + studentid9 + studentid10 + studentid11 + studentid12;
// gen_student_id.Add(getCheckDigit(tmp_studentid));
// }
// }
// }
// //gen_student_id.Add(sql);
// return gen_student_id;
//}
//public string getStudentID(string academic_year, string faculty_code, string department_code, string major_code, string degree_code, string admissiontype_code, string gen_type, string sec_number, string project_code)
public string getStudentID(Qualified_Student student_data)
{
Qualified_Student qualifiedObj = new Qualified_Student();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string student_id = "";
if (student_data.Gen_Gruop == "y") // ใช้ Sec
{
string studentid1_2 = student_data.Year_Admission.Substring(2, 2);
string studentid3_4 = student_data.Faculty_Code;
string studentid5_6 = student_data.Department_Code_StudentID;
string studentid7 = student_data.Major_Code_StudentID;
string studentid8 = student_data.Degree_Admission;
string studentid9 = student_data.Admission_Type;
string studentid10 = "";
if (student_data.StudentGruop == "001")
{
studentid10 = "0";
}
else if (student_data.StudentGruop == "002")
{
studentid10 = "1";
}
else if (student_data.StudentGruop == "003")
{
studentid10 = "2";
}
else if (student_data.StudentGruop == "004")
{
studentid10 = "3";
}
else if (student_data.StudentGruop == "005")
{
studentid10 = "4";
}
else if (student_data.StudentGruop == "006")
{
studentid10 = "5";
}
else if (student_data.StudentGruop == "007")
{
studentid10 = "6";
}
else if (student_data.StudentGruop == "008")
{
studentid10 = "7";
}
else if (student_data.StudentGruop == "009")
{
studentid10 = "8";
}
else if (student_data.StudentGruop == "010")
{
studentid10 = "9";
}
else
{
studentid10 = "x";
}
string max_student_id = "";
string tmp_studentid = studentid1_2 + studentid3_4 + studentid5_6 + studentid7 + studentid8 + studentid9 + studentid10;
string table = qualifiedObj.getTableName(student_data.Degree_Char);
string sql = "Select Max(TO_NUMBER(student_id)) AS MAX_ID From " + table + " Where STUDENT_ID Like '" + tmp_studentid + "%'";
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
max_student_id = rowData["MAX_ID"].ToString();
}
if (max_student_id == "")
{
string studentid11 = "0";
string studentid12 = "1";
string tmp_studentid2 = tmp_studentid + studentid11 + studentid12;
student_id = getCheckDigit(tmp_studentid2);
}
else if (max_student_id.Length == 13)
{
int run_num = Convert.ToInt16(max_student_id.Substring(10, 2));
run_num++;
if (run_num <= 99)
{
string tmp_studentid2 = tmp_studentid + run_num.ToString("00");
student_id = getCheckDigit(tmp_studentid2);
}
else
{
student_id = "max";
}
}
else
{
student_id = "err";
}
}
else if (student_data.Gen_Gruop == "n") // ไม่ใช้ Sec
{
string studentid1_2 = student_data.Year_Admission.Substring(2, 2);
string studentid3_4 = student_data.Faculty_Code;
string studentid5_6 = student_data.Department_Code_StudentID;
string studentid7 = student_data.Major_Code_StudentID;
string studentid8 = student_data.Degree_Admission;
string studentid9 = student_data.Admission_Type;
string max_student_id = "";
string tmp_studentid = studentid1_2 + studentid3_4 + studentid5_6 + studentid7 + studentid8 + studentid9;
string table = qualifiedObj.getTableName(student_data.Degree_Char);
string sql = "Select Max(TO_NUMBER(student_id)) AS MAX_ID From " + table + " Where STUDENT_ID Like '" + tmp_studentid + "%'";
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
max_student_id = rowData["MAX_ID"].ToString();
}
if (max_student_id == "")
{
string studentid10 = "0";
string studentid11 = "0";
string studentid12 = "1";
string tmp_studentid2 = tmp_studentid + studentid10 + studentid11 + studentid12;
student_id = getCheckDigit(tmp_studentid2);
}
else if (max_student_id.Length == 13)
{
int run_num = Convert.ToInt16(max_student_id.Substring(9, 3));
run_num++;
if (run_num <= 999)
{
string tmp_studentid2 = tmp_studentid + run_num.ToString("000");
student_id = getCheckDigit(tmp_studentid2);
}
else
{
student_id = "max";
}
}
else
{
student_id = "err";
}
}
if (student_id.Length == 13)
{
return(student_id);
}
else
{
return("ID_Error" + student_id);
}
}