// V 1.0.0
public string insert_HisAdvisor(HisUpdateAdvisorData dataInsert, string degree_char)
{
string tableName = getHisAdvisorTable(degree_char);
string response = "";
int i = 0;
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Insert Into " + tableName + "(DATE_TIME,ACADEMIC_YEAR,SEMESTER,OLD_ADVISOR_ID,ADVISOR_ID,STUDENT_ID,UPDATE_BY) Values('" + dataInsert.date_time + "','" + dataInsert.academic_year + "','" + dataInsert.semester + "','" + dataInsert.old_advisor_id + "','" + dataInsert.advisor_id + "','" + dataInsert.student_id + "','" + dataInsert.update_by + "')";
oracleObj.InsertCommand = sql;
try
{
if (oracleObj.Insert() == 1)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString();
}
i++;
return(response);
}
protected void btnSAVE_Click(object sender, EventArgs e)
{
List <UpdateAdvisorData> updateAdvisorData = new List <UpdateAdvisorData>();
lblResult.Text = "";
uint chknum;
int item_selected = 0;
foreach (ListItem item in Duallistbox.Items)
{
if (item.Selected)
{
item_selected++;
}
}
if (txtACADEMIC_YEAR.Text.Length != 4)
{
MsgValidate("กรุณาระบุ ปีการศึกษา เป็นตัวเลขจำนวน 4 ตัว");
}
else if (!uint.TryParse(txtACADEMIC_YEAR.Text, out chknum))
{
MsgValidate("กรุณาระบุ ปีการศึกษา เป็นตัวเลขเท่านั้น");
}
else if (ddlLecturer.SelectedValue == "00")
{
divShow.Visible = false;
MsgValidate("กรุณาระบุ อาจารย์ที่ปรึกษา");
}
else if (item_selected == 0)
{
divShow.Visible = false;
MsgValidate("กรุณาเลือก รายชื่อนักศึกษา");
}
else
{
HisUpdateAdvisorData HisAdvisor = new HisUpdateAdvisorData();
foreach (ListItem item in Duallistbox.Items)
{
if (item.Selected)
{
UpdateAdvisorData UpdateAdvisor_data = new UpdateAdvisorData();
UpdateAdvisor_data.Student_ID = item.Value;
UpdateAdvisor_data.Lecturer_ID = ddlLecturer.SelectedValue;
updateAdvisorData.Add(UpdateAdvisor_data);
HisAdvisor.date_time = DateTime.Now.ToString();
HisAdvisor.academic_year = AcademicYear;
HisAdvisor.semester = ddlSEMESTER.SelectedValue;
HisAdvisor.old_advisor_id = new Student().getAdvisor_ID(UpdateAdvisor_data.Student_ID, degree_char);
HisAdvisor.advisor_id = UpdateAdvisor_data.Lecturer_ID;
HisAdvisor.student_id = UpdateAdvisor_data.Student_ID;
HisAdvisor.update_by = login_data.First_Thainame + " " + login_data.Family_Thainame + " (" + login_data.User_ID + ")";
new HistoryUpdate().insert_HisAdvisor(HisAdvisor, degree_char);
}
}
string[] res = new Student().updateAdvisor(updateAdvisorData, degree_char);
int j = 0;
Student stdData = new Student();
foreach (ListItem item in Duallistbox.Items)
{
if (item.Selected)
{
stdData = new Student().getStudent(updateAdvisorData[j].Student_ID, degree_char);
if (res[j] == "OK")
{
item.Attributes.Add("class", "txt-green-bold");
}
else
{
item.Attributes.Add("class", "txt-red");
}
item.Text = updateAdvisorData[j].Student_ID + " " + stdData.First_ThaiName + " " + stdData.Family_ThaiName + " (" + new Lecturer().getLecturer(stdData.Advisor_ID).Lecturer_ShortName + ")";
j++;
}
}
}
}
