// V1.0.0
public string updateConfig(StudentIDConfigData updateData)
{
string response = "";
string sql = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
try
{
// เพิ่มข้อมูลต้องมี Gen_Type แบบเดียวกัน
oracleObj.SelectCommand = "Select * From STUDENT_ID_CONFIG Where ID=" + updateData.ID;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
if (allData.Count != 0)
{
sql = "Update STUDENT_ID_CONFIG Set NUM_OF_STUDENT = " + updateData.num_of_student + " Where FACULTY_CODE='" + updateData.Faculty_Code + "' And DEPARTMENT_CODE='" + updateData.Department_Code + "' And MAJOR_CODE='" + updateData.Major_Code + "' And DEGREE_ADMISSION='" + updateData.Degree_Admission + "' AND SEC_NO = '" + updateData.Sec_No + "'";
oracleObj.UpdateCommand = sql;
if (oracleObj.Update() > 0)
{
response = "OK";
}
}
}
catch
{
HttpContext.Current.Session["response"] = "Unit Test:StudentIDConfig:updateConfig" + " ไม่สามารถดำเนินการได้" + sql;
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
// V1.0.0
public StudentIDConfigData getConfig(uint id)
{
StudentIDConfigData config_data = new StudentIDConfigData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
try
{
oracleObj.SelectCommand = "Select * From STUDENT_ID_CONFIG Where ID=" + id;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
config_data.ID = Convert.ToInt32(rowData["ID"].ToString());
config_data.Faculty_Code = rowData["FACULTY_CODE"].ToString();
config_data.Department_Code = rowData["DEPARTMENT_CODE"].ToString();
config_data.Major_Code = rowData["MAJOR_CODE"].ToString();
config_data.Degree_Admission = rowData["DEGREE_ADMISSION"].ToString();
config_data.Admission_Type = rowData["ADMISSION_TYPE"].ToString();
config_data.Gen_Type = rowData["GEN_TYPE"].ToString();
config_data.Sec_No = rowData["SEC_NO"].ToString();
config_data.Project_Selected = rowData["PROJECT_SELECTED"].ToString();
config_data.Project_Code = rowData["PROJECT_CODE"].ToString();
config_data.Major_Student_ID = rowData["MAJOR_STUDENT_ID"].ToString();
config_data.num_of_student = Convert.ToUInt32(rowData["NUM_OF_STUDENT"].ToString());
}
}
catch
{
HttpContext.Current.Session["response"] = "Unit Test:StudentIDConfig:getConfig" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(config_data);
}
// V1.0.0
public string insertConfig(StudentIDConfigData insertData)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
try
{
// เพิ่มข้อมูลต้องมี Gen_Type แบบเดียวกัน
oracleObj.SelectCommand = "Select * From STUDENT_ID_CONFIG Where FACULTY_CODE='" + insertData.Faculty_Code + "' And DEPARTMENT_CODE='" + insertData.Department_Code + "' And MAJOR_CODE='" + insertData.Major_Code + "' And DEGREE_ADMISSION='" + insertData.Degree_Admission + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
if (allData.Count != 0)
{
if (allData[0]["Gen_Type"].ToString() != "0")
{
response = "รหัสนักศึกษาหลักที่ 10 ถูกกำหนดรูปแบบ (ไม่ใช้หมายเลข) ไว้ก่อนแล้ว";
}
else if (insertData.Gen_Type != "0")
{
response = "รหัสนักศึกษาหลักที่ 10 ถูกกำหนดรูปแบบ (ใช้หมายเลข) ไว้ก่อนแล้ว";
}
else
{
oracleObj.SelectCommand = "Select * From STUDENT_ID_CONFIG Where FACULTY_CODE='" + insertData.Faculty_Code + "' And DEPARTMENT_CODE='" + insertData.Department_Code + "' And MAJOR_CODE='" + insertData.Major_Code + "' And DEGREE_ADMISSION='" + insertData.Degree_Admission + "' And ADMISSION_TYPE='" + insertData.Admission_Type + "' AND SEC_NO='" + insertData.Sec_No + "' AND PROJECT_CODE='" + insertData.Project_Code + "'";
DataView allData2 = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
if (allData2.Count > 0)
{
response = "ไม่สามารถกำหนด หมายเลขห้อง โดยใช้โครงการซ้ำซ้อนได้";
}
else
{
oracleObj.SelectCommand = "Select NUM_OF_STUDENT From STUDENT_ID_CONFIG Where FACULTY_CODE='" + insertData.Faculty_Code + "' And DEPARTMENT_CODE='" + insertData.Department_Code + "' And MAJOR_CODE='" + insertData.Major_Code + "' And DEGREE_ADMISSION='" + insertData.Degree_Admission + "' AND SEC_NO='" + insertData.Sec_No + "'";
DataView allData3 = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
if (allData3.Count > 0)
{
if (insertData.num_of_student != Convert.ToUInt32(allData3[0]["NUM_OF_STUDENT"].ToString()))
{
response = "จำนวนนักศึกษา ถูกกำหนดไว้แล้ว คือ " + allData3[0]["NUM_OF_STUDENT"].ToString() + " คน";
}
else
{
oracleObj.SelectCommand = "SELECT CONFIG_STD_ID_SEQ.NEXTVAL FROM DUAL";
DataView seq = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
int nextval = Convert.ToInt32(seq[0]["NEXTVAL"]);
oracleObj.InsertCommand = "Insert Into STUDENT_ID_CONFIG(ID,FACULTY_CODE, DEPARTMENT_CODE, MAJOR_CODE, DEGREE_ADMISSION, ADMISSION_TYPE, GEN_TYPE, SEC_NO, PROJECT_CODE,PROJECT_SELECTED,MAJOR_STUDENT_ID,NUM_OF_STUDENT) Values(" + seq[0]["NEXTVAL"].ToString() + ",'" + insertData.Faculty_Code + "','" + insertData.Department_Code + "','" + insertData.Major_Code + "','" + insertData.Degree_Admission + "','" + insertData.Admission_Type + "','" + insertData.Gen_Type + "','" + insertData.Sec_No + "','" + insertData.Project_Code + "','" + insertData.Project_Selected + "','" + insertData.Major_Student_ID + "'," + insertData.num_of_student + ")";
if (oracleObj.Insert() == 1)
{
response = "OK";
}
}
}
else
{
oracleObj.SelectCommand = "SELECT CONFIG_STD_ID_SEQ.NEXTVAL FROM DUAL";
DataView seq = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
int nextval = Convert.ToInt32(seq[0]["NEXTVAL"]);
oracleObj.InsertCommand = "Insert Into STUDENT_ID_CONFIG(ID,FACULTY_CODE, DEPARTMENT_CODE, MAJOR_CODE, DEGREE_ADMISSION, ADMISSION_TYPE, GEN_TYPE, SEC_NO, PROJECT_CODE,PROJECT_SELECTED,MAJOR_STUDENT_ID,NUM_OF_STUDENT) Values(" + seq[0]["NEXTVAL"].ToString() + ",'" + insertData.Faculty_Code + "','" + insertData.Department_Code + "','" + insertData.Major_Code + "','" + insertData.Degree_Admission + "','" + insertData.Admission_Type + "','" + insertData.Gen_Type + "','" + insertData.Sec_No + "','" + insertData.Project_Code + "','" + insertData.Project_Selected + "','" + insertData.Major_Student_ID + "'," + insertData.num_of_student + ")";
if (oracleObj.Insert() == 1)
{
response = "OK";
}
}
}
}
}
else
{
oracleObj.SelectCommand = "Select * From STUDENT_ID_CONFIG Where FACULTY_CODE='" + insertData.Faculty_Code + "' And DEPARTMENT_CODE='" + insertData.Department_Code + "' And DEGREE_ADMISSION='" + insertData.Degree_Admission + "' AND MAJOR_STUDENT_ID='" + insertData.Major_Student_ID + "'";
DataView allData4 = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
if (allData4.Count != 0)
{
if (allData4[0]["Gen_Type"].ToString() != insertData.Gen_Type)
{
response = "สาขาวิชานี้ ไม่สามารถเปลี่ยนรูปแบบการแบ่งห้องเรียนได้อีก";
}
else
{
oracleObj.SelectCommand = "Select NUM_OF_STUDENT From STUDENT_ID_CONFIG Where FACULTY_CODE='" + insertData.Faculty_Code + "' And DEPARTMENT_CODE='" + insertData.Department_Code + "' And DEGREE_ADMISSION='" + insertData.Degree_Admission + "' AND MAJOR_STUDENT_ID='" + insertData.Major_Student_ID + "' AND SEC_NO='" + insertData.Sec_No + "'";
DataView allData5 = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
if (allData5.Count > 0)
{
if (insertData.num_of_student != Convert.ToUInt32(allData5[0]["NUM_OF_STUDENT"].ToString()))
{
response = "จำนวนนักศึกษาของสาขาวิชานี้ ถูกกำหนดไว้แล้ว คือ " + allData5[0]["NUM_OF_STUDENT"].ToString() + " คน";
}
else
{
oracleObj.SelectCommand = "SELECT CONFIG_STD_ID_SEQ.NEXTVAL FROM DUAL";
DataView seq = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
int nextval = Convert.ToInt32(seq[0]["NEXTVAL"]);
oracleObj.InsertCommand = "Insert Into STUDENT_ID_CONFIG(ID,FACULTY_CODE, DEPARTMENT_CODE, MAJOR_CODE, DEGREE_ADMISSION, ADMISSION_TYPE, GEN_TYPE, SEC_NO, PROJECT_CODE,PROJECT_SELECTED,MAJOR_STUDENT_ID,NUM_OF_STUDENT) Values(" + seq[0]["NEXTVAL"].ToString() + ",'" + insertData.Faculty_Code + "','" + insertData.Department_Code + "','" + insertData.Major_Code + "','" + insertData.Degree_Admission + "','" + insertData.Admission_Type + "','" + insertData.Gen_Type + "','" + insertData.Sec_No + "','" + insertData.Project_Code + "','" + insertData.Project_Selected + "','" + insertData.Major_Student_ID + "'," + insertData.num_of_student + ")";
if (oracleObj.Insert() == 1)
{
response = "OK";
}
}
}
else
{
oracleObj.SelectCommand = "SELECT CONFIG_STD_ID_SEQ.NEXTVAL FROM DUAL";
DataView seq = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
int nextval = Convert.ToInt32(seq[0]["NEXTVAL"]);
oracleObj.InsertCommand = "Insert Into STUDENT_ID_CONFIG(ID,FACULTY_CODE, DEPARTMENT_CODE, MAJOR_CODE, DEGREE_ADMISSION, ADMISSION_TYPE, GEN_TYPE, SEC_NO, PROJECT_CODE,PROJECT_SELECTED,MAJOR_STUDENT_ID,NUM_OF_STUDENT) Values(" + seq[0]["NEXTVAL"].ToString() + ",'" + insertData.Faculty_Code + "','" + insertData.Department_Code + "','" + insertData.Major_Code + "','" + insertData.Degree_Admission + "','" + insertData.Admission_Type + "','" + insertData.Gen_Type + "','" + insertData.Sec_No + "','" + insertData.Project_Code + "','" + insertData.Project_Selected + "','" + insertData.Major_Student_ID + "'," + insertData.num_of_student + ")";
if (oracleObj.Insert() == 1)
{
response = "OK";
}
}
}
}
else
{
oracleObj.SelectCommand = "SELECT CONFIG_STD_ID_SEQ.NEXTVAL FROM DUAL";
DataView seq = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
int nextval = Convert.ToInt32(seq[0]["NEXTVAL"]);
oracleObj.InsertCommand = "Insert Into STUDENT_ID_CONFIG(ID,FACULTY_CODE, DEPARTMENT_CODE, MAJOR_CODE, DEGREE_ADMISSION, ADMISSION_TYPE, GEN_TYPE, SEC_NO, PROJECT_CODE,PROJECT_SELECTED,MAJOR_STUDENT_ID,NUM_OF_STUDENT) Values(" + seq[0]["NEXTVAL"].ToString() + ",'" + insertData.Faculty_Code + "','" + insertData.Department_Code + "','" + insertData.Major_Code + "','" + insertData.Degree_Admission + "','" + insertData.Admission_Type + "','" + insertData.Gen_Type + "','" + insertData.Sec_No + "','" + insertData.Project_Code + "','" + insertData.Project_Selected + "','" + insertData.Major_Student_ID + "'," + insertData.num_of_student + ")";
if (oracleObj.Insert() == 1)
{
response = "OK";
}
}
}
}
catch (Exception err)
{
HttpContext.Current.Session["response"] = "Unit Test:StudentIDConfig:insertConfig" + " ไม่สามารถดำเนินการได้ ";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
// V1.0.0
public List <StudentIDConfigData> getConfigs(String faculty_code, string department_code, string major_code, string degree_admission, string admission_type)
{
List <StudentIDConfigData> config_data = new List <StudentIDConfigData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Select * From STUDENT_ID_CONFIG Where 1 = 1";
if (faculty_code != "0")
{
sql += " And FACULTY_CODE='" + faculty_code + "'";
}
if (department_code != "0")
{
sql += " And DEPARTMENT_CODE='" + department_code + "'";
}
if (major_code != "0")
{
sql += " And MAJOR_CODE='" + major_code + "'";
}
if (degree_admission != "0")
{
sql += " And DEGREE_ADMISSION='" + degree_admission + "'";
}
if (admission_type != "0")
{
sql += " And ADMISSION_TYPE='" + admission_type + "'";
}
try
{
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
StudentIDConfigData config = new StudentIDConfigData();
config.ID = Convert.ToInt32(rowData["ID"].ToString());
config.Faculty_Code = rowData["FACULTY_CODE"].ToString();
config.Department_Code = rowData["DEPARTMENT_CODE"].ToString();
config.Major_Code = rowData["MAJOR_CODE"].ToString();
config.Degree_Admission = rowData["DEGREE_ADMISSION"].ToString();
config.Admission_Type = rowData["ADMISSION_TYPE"].ToString();
config.Gen_Type = rowData["GEN_TYPE"].ToString();
config.Sec_No = rowData["SEC_NO"].ToString();
config.Project_Selected = rowData["PROJECT_SELECTED"].ToString();
config.Project_Code = rowData["PROJECT_CODE"].ToString();
config.Major_Student_ID = rowData["MAJOR_STUDENT_ID"].ToString();
config.num_of_student = Convert.ToUInt32(rowData["NUM_OF_STUDENT"].ToString());
config_data.Add(config);
}
}
catch
{
HttpContext.Current.Session["response"] = "Unit Test:StudentIDConfig:getConfigs" + " ไม่สามารถดำเนินการได้ ";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(config_data);
}
