/// <summary>
/// แก้ไขข้อมูลจากตาราง TQF2SEC3SEMESTERPLAN
/// </summary>
/// <param name="updateData">TQF2Sec3SemesterPlan Object</param>
/// <returns>Success</returns>
public string updateTQF2Sec3SemesterPlan(TQF2Sec3SemesterPlan updateData)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
string sql = "Update TQF2SEC3SEMESTERPLAN Set EDUCATIONYEAR = '" + updateData.EducationYear +
"', EDUCATIONSEMESTER = '" + updateData.EducationSemester +
"' Where CURRCODE = '" + updateData.CurrCode +
"' And YEARVERSION = '" + updateData.YearVersion +
"' And CURRFORMATCODE = '" + updateData.CurrFormatCode +
"' And CURRTYPECODE = '" + updateData.CurrTypeCode +
"' And MAJORCODE = '" + updateData.MajorCode +
"' And COURSECODE = '" + updateData.CourseCode + "'";
oracleObj.UpdateCommand = sql;
try
{
if (oracleObj.Update() == 1)
{
response = "Success";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "updateTQF2Sec3SemesterPlan: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
/// <summary>
/// เพิ่มข้อมูลลงตาราง TQF2SEC3SEMESTERPLAN
/// </summary>
/// <param name="dataInsert">TQF2Sec3SemesterPlan Object</param>
/// <returns>Success</returns>
public string insertTQF2Sec3SemesterPlan(TQF2Sec3SemesterPlan dataInsert)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
string sql = "Insert into TQF2SEC3SEMESTERPLAN (CURRCODE, YEARVERSION, CURRFORMATCODE, CURRTYPECODE, MAJORCODE, COURSECODE, EDUCATIONYEAR, EDUCATIONSEMESTER) values ('" + dataInsert.CurrCode + "','" + dataInsert.YearVersion + "','" + dataInsert.CurrFormatCode + "','" + dataInsert.CurrTypeCode + "','" + dataInsert.MajorCode + "','" + dataInsert.CourseCode + "','" + dataInsert.EducationYear + "','" + dataInsert.EducationSemester + "')";
oracleObj.InsertCommand = sql;
try
{
if (oracleObj.Insert() == 1)
{
response = "Success";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "insertTQF2Sec3SemesterPlan: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
/// <summary>
/// เรียกดูข้อมูลจากตาราง TQF2SEC3SEMESTERPLAN
/// </summary>
/// <param name="sql">SQL Command</param>
/// <returns>ข้อมูลจากตาราง TQF2SEC3SEMESTERPLAN</returns>
public List <TQF2Sec3SemesterPlan> getTQF2Sec3SemesterPlanManual(string sql)
{
List <TQF2Sec3SemesterPlan> TQF2Sec3SemesterPlanData = new List <TQF2Sec3SemesterPlan>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
TQF2Sec3SemesterPlan TQF2Sec3SemesterPlanRow = new TQF2Sec3SemesterPlan();
TQF2Sec3SemesterPlanRow.CurrCode = rowData["CURRCODE"].ToString();
TQF2Sec3SemesterPlanRow.YearVersion = rowData["YEARVERSION"].ToString();
TQF2Sec3SemesterPlanRow.CurrFormatCode = rowData["CURRFORMATCODE"].ToString();
TQF2Sec3SemesterPlanRow.CurrTypeCode = rowData["CURRTYPECODE"].ToString();
TQF2Sec3SemesterPlanRow.MajorCode = rowData["MAJORCODE"].ToString();
TQF2Sec3SemesterPlanRow.CourseCode = rowData["COURSECODE"].ToString();
TQF2Sec3SemesterPlanRow.EducationYear = rowData["EDUCATIONYEAR"].ToString();
TQF2Sec3SemesterPlanRow.EducationSemester = rowData["EDUCATIONSEMESTER"].ToString();
TQF2Sec3SemesterPlanData.Add(TQF2Sec3SemesterPlanRow);
}
return(TQF2Sec3SemesterPlanData);
}
protected void btnOK_Click(object sender, EventArgs e)
{
string sql = "Select * From TQF2SEC3STRUCTUREGROUP Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And CATEGORYCODE='" + CategoryCode + "' And COURSEGROUPCODE='" + CourseGroupCode + "'";
List <TQF2Sec3StructureGroup> tqf2Sec3StructureGroup;
tqf2Sec3StructureGroup = new TQF2Sec3StructureGroup().getTQF2Sec3StructureGroupManual(sql);
if (tqf2Sec3StructureGroup.Count > 0)
{
//[Step 8] ลบข้อมูลในตาราง TQF2SEC3SEMESTERPLAN
string sql8 = "Delete From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "'";
string deleteTQF2SemesterPlan = new TQF2Sec3SemesterPlan().deleteTQF2Sec3SemesterPlanManual(sql8);
//[Step 7] ลบข้อมูลในตาราง TQF2SEC4CURRICULUMMAPPING
string sql7 = "Select * From TQF2SEC3PLANDETAIL Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "'";
List <TQF2Sec3PlanDetail> TQF2Sec3PlanDetailData = new TQF2Sec3PlanDetail().getTQF2Sec3PlanDetailManual(sql7);
foreach (TQF2Sec3PlanDetail row in TQF2Sec3PlanDetailData)
{
string sql7_1 = "Delete From TQF2SEC4CURRICULUMMAPPING Where CURRCODE ='" + row.CurrCode + "'";
string deleteTQF2Sec4CurriculumMapping = new TQF2Sec4CurriculumMapping().deleteTQF2Sec4CurriculumMappingManual(sql7_1);
}
//[Step 6-1] ลบข้อมูลในตาราง PREREQUISITE
string sql6 = "Delete From PREREQUISITE Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And CATEGORYCODE='" + CategoryCode + "' And COURSEGROUPCODE='" + CourseGroupCode + "'";
string deletePreRequisite = new PreRequisite().deletePreRequisiteManual(sql6);
//[Step 6] ลบข้อมูลในตาราง TQF2SEC3PLANDETAIL
string sql5 = "Delete From TQF2SEC3PLANDETAIL Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And CATEGORYCODE='" + CategoryCode + "' And COURSEGROUPCODE='" + CourseGroupCode + "'";
string deleteTQF2Sec3PlanDetail = new TQF2Sec3PlanDetail().deleteTQF2Sec3PlanDetailManual(sql5);
//[Step 5_1] ลบข้อมูลในตาราง TQF2SEC3STRUCTURETYPE
string sql4 = "Delete From TQF2SEC3STRUCTURETYPE Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And CATEGORYCODE='" + CategoryCode + "' And COURSEGROUPCODE='" + CourseGroupCode + "'";
string deleteTqf2Sec3StructureType = new Tqf2Sec3StructureType().deleteTqf2Sec3StructureTypeManual(sql4);
//[Step 5] ลบข้อมูลในตาราง TQF2SEC3STRUCTUREGROUP
string sql3 = "Delete From TQF2SEC3STRUCTUREGROUP Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And CATEGORYCODE='" + CategoryCode + "' And COURSEGROUPCODE='" + CourseGroupCode + "'";
string deleteTQF2Sec3StructureGroup = new TQF2Sec3StructureGroup().deleteTQF2Sec3StructureGroupManual(sql3);
//สร้าง session ส่งคืนกลับไปหน้า Faculty_add_CURR5.aspx
Session["CurrCode"] = CurrCode;
Session["YearVersion"] = YearVersion;
//Session["MajorCode"] = MajorCode;
Response.Redirect("Faculty_add_CURR5.aspx");
}
else
{
//สร้าง session ส่งคืนกลับไปหน้า Faculty_add_CURR5.aspx
Session["CurrCode"] = CurrCode;
Session["YearVersion"] = YearVersion;
//Session["MajorCode"] = MajorCode;
Response.Redirect("Faculty_add_CURR5.aspx");
}
}
protected void btnSAVE_Click(object sender, EventArgs e)
{
foreach (TableRow row in tblCourse.Rows)
{
var cell = row.Cells[0];
foreach (Control control in cell.Controls)
{
var checkBox = control as CheckBox;
if (checkBox != null)
{
if (checkBox.Checked == true)
{
string sql = "Select * From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And COURSECODE='" + row.Cells[1].Text + "' And EDUCATIONYEAR='" + ddlEDUCATIONYEAR.SelectedValue + "' And EDUCATIONSEMESTER='" + ddlEDUCATIONSEMESTER.SelectedValue + "'";
List <TQF2Sec3SemesterPlan> chkTQF2Sec3SemesterPlan = new TQF2Sec3SemesterPlan().getTQF2Sec3SemesterPlanManual(sql);
if (chkTQF2Sec3SemesterPlan.Count > 0)
{
continue;
}
else
{
TQF2Sec3SemesterPlan dataInsert = new TQF2Sec3SemesterPlan();
dataInsert.CurrCode = CurrCode;
dataInsert.YearVersion = YearVersion;
dataInsert.CurrFormatCode = CurrFormatCode;
dataInsert.CurrTypeCode = CurrTypeCode;
dataInsert.MajorCode = MajorCode;
if (row.Cells[4].Text == "null")
{
dataInsert.CourseCode = row.Cells[1].Text;
}
else
{
dataInsert.CourseCode = row.Cells[4].Text;
}
dataInsert.EducationYear = ddlEDUCATIONYEAR.SelectedValue;
dataInsert.EducationSemester = ddlEDUCATIONSEMESTER.SelectedValue;
string insertTQF2Sec3SemesterPlan = new TQF2Sec3SemesterPlan().insertTQF2Sec3SemesterPlan(dataInsert);
}
}
}
}
}
//สร้าง session ส่งคืนกลับไปหน้า Faculty_add_CURR8.aspx
Session["CurrCode"] = CurrCode;
Session["YearVersion"] = YearVersion;
//Session["MajorCode"] = MajorCode;
Response.Redirect("Faculty_add_CURR8.aspx");
}
protected void btnOK_Click(object sender, EventArgs e)
{
//เช็คว่ามีข้อมูลอยู่จริงหรือไม่
string sql = "Select * From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And COURSECODE='" + CourseCode + "' And EDUCATIONYEAR='" + Year + "' And EDUCATIONSEMESTER='" + Semester + "'";
List <TQF2Sec3SemesterPlan> tqf2Sec3SemesterPlan = new TQF2Sec3SemesterPlan().getTQF2Sec3SemesterPlanManual(sql);
if (tqf2Sec3SemesterPlan.Count > 0)
{
//ลบข้อมูลในตาราง TQF2SEC3PLANDETAIL
string sql2 = "Delete From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And COURSECODE='" + CourseCode + "' And EDUCATIONYEAR='" + Year + "' And EDUCATIONSEMESTER='" + Semester + "'";
string deleteTQF2Sec3PlanDetail = new TQF2Sec3SemesterPlan().deleteTQF2Sec3SemesterPlanManual(sql2);
if (deleteTQF2Sec3PlanDetail == "Success")
{
//สร้าง session ส่งคืนกลับไปหน้า Faculty_add_CURR8.aspx
Session["CurrCode"] = CurrCode;
Session["YearVersion"] = YearVersion;
//Session["MajorCode"] = MajorCode;
Response.Redirect("Faculty_add_CURR8.aspx");
}
//else
//{
// //สร้าง session ส่งคืนกลับไปหน้า Faculty_add_CURR6.aspx
// Session["CurrCode"] = CurrCode;
// Session["YearVersion"] = YearVersion;
// //Session["MajorCode"] = MajorCode;
// Response.Redirect("Faculty_add_CURR8.aspx");
//}
}
else
{
//สร้าง session ส่งคืนกลับไปหน้า Faculty_add_CURR8.aspx
Session["CurrCode"] = CurrCode;
Session["YearVersion"] = YearVersion;
//Session["MajorCode"] = MajorCode;
Response.Redirect("Faculty_add_CURR8.aspx");
}
}
/// <summary>
/// เรียกดูข้อมูลจากตาราง TQF2SEC3SEMESTERPLAN
/// </summary>
/// <param name="sql">คำสั่ง Sql มีตัวอย่างให้ดูใน Class</param>
/// <returns>ข้อมูลจากตาราง TQF2SEC3SEMESTERPLAN</returns>
public TQF2Sec3SemesterPlan getCountCreditTQF2Sec3SemesterPlanManual(string sql)
{
TQF2Sec3SemesterPlan TQF2Sec3SemesterPlanData = new TQF2Sec3SemesterPlan();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
//ตัวอย่าง Command
//Select COUNT(COURSECODE) As CREDITCOUNT From TQF2SEC3SEMESTERPLAN Where CURRCODE='707012555' And YEARVERSION='2555' And CURRFORMATCODE='008' And CURRTYPECODE='004' And MAJORCODE='0701' And COURSECODE='070115800';
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
TQF2Sec3SemesterPlanData.CreditCount = rowData["CREDITCOUNT"].ToString();
}
return(TQF2Sec3SemesterPlanData);
}
/// <summary>
/// เพิ่มข้อมูลลงตาราง TQF2SEC3SEMESTERPLAN
/// </summary>
/// <param name="sql">SQL Command</param>
/// <returns>EDUCATIONSEMESTER</returns>
public List <TQF2Sec3SemesterPlan> getSemester(string sql)
{
List <TQF2Sec3SemesterPlan> TQF2Sec3SemesterPlanData = new List <TQF2Sec3SemesterPlan>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
TQF2Sec3SemesterPlan TQF2Sec3SemesterPlanRow = new TQF2Sec3SemesterPlan();
TQF2Sec3SemesterPlanRow.EducationSemester = rowData["EDUCATIONSEMESTER"].ToString();
TQF2Sec3SemesterPlanData.Add(TQF2Sec3SemesterPlanRow);
}
return(TQF2Sec3SemesterPlanData);
}
/// <summary>
/// เรียกดูข้อมูลจากตาราง TQF2SEC3SEMESTERPLAN
/// </summary>
/// <param name="CourseCode">รหัสวิชา(Course)</param>
/// <returns>ข้อมูลจากตาราง TQF2SEC3SEMESTERPLAN</returns>
public TQF2Sec3SemesterPlan getTQF2Sec3SemesterPlan(string CourseCode)
{
TQF2Sec3SemesterPlan TQF2Sec3SemesterPlanData = new TQF2Sec3SemesterPlan();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
oracleObj.SelectCommand = "Select * From TQF2SEC3SEMESTERPLAN Where COURSECODE='" + CourseCode + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
TQF2Sec3SemesterPlanData.CurrCode = rowData["CURRCODE"].ToString();
TQF2Sec3SemesterPlanData.YearVersion = rowData["YEARVERSION"].ToString();
TQF2Sec3SemesterPlanData.CurrFormatCode = rowData["CURRFORMATCODE"].ToString();
TQF2Sec3SemesterPlanData.CurrTypeCode = rowData["CURRTYPECODE"].ToString();
TQF2Sec3SemesterPlanData.MajorCode = rowData["MAJORCODE"].ToString();
TQF2Sec3SemesterPlanData.CourseCode = rowData["COURSECODE"].ToString();
TQF2Sec3SemesterPlanData.EducationYear = rowData["EDUCATIONYEAR"].ToString();
TQF2Sec3SemesterPlanData.EducationSemester = rowData["EDUCATIONSEMESTER"].ToString();
}
return(TQF2Sec3SemesterPlanData);
}
protected void htmlGenerate(string MajorCode, string CurrFormatCode, string TotalCredits, string YearVersion, string CurrTypeCode)
{
string html = "";
html += "<section>";
html += " <div class=\"title-data-newStd\"><i class=\"fa fa-file-text-o\"></i> " + new CurrType().getCurrType(CurrTypeCode).CurrTypeName + ": " + new CurrFormat().getCurrFormat(CurrFormatCode).CurrFormatName + " (แขนงวิชา " + new TQF.Major().getMajor(MajorCode).MajorThName + ")" + "</div>";
html += "</section>";
html += "<section>";
html += "<div id=\"accordion1\" class=\"panel-group smart-accordion-default\">";
html += "<div class=\"panel panel-redLight\">";
html += "<div class=\"panel-heading\">";
Label label0 = new Label();
label0.Text = CurrCode + CurrFormatCode + CurrTypeCode + MajorCode;
html += "<h4 class=\"panel-title\"><a class=\"\" href=\"#" + label0.Text + "\" data-parent=\"#accordion1\" data-toggle=\"collapse\"><i class=\"fa fa-lg fa-angle-down pull-right\"></i><i class=\"fa fa-lg fa-angle-up pull-right\"></i>แผนการศึกษา</a></h4>";
html += "</div>";
html += "<div class=\"panel-collapse collapse in\" id=\"" + label0.Text + "\" style=\"height: auto;\">";
html += "<div class=\"panel-body padding-10 well\">";
//แสดงปุ่ม Add 1
html += "<div class=\"row\">";
html += "<section class=\"col col-3 pull-right\">";
html += " <a href=\"addEDU_PLAN.aspx?CurrCode=" + CurrCode + "&YearVersion=" + YearVersion + "&CurrFormatCode=" + CurrFormatCode + "&CurrTypeCode=" + CurrTypeCode + "&MajorCode=" + MajorCode + "&Year=1&Semester=1\" data-target=\"#addEDU_PLAN\" data-toggle=\"modal\" class=\"pull-right\" title=\"เพิ่มข้อมูล\" id=\"HyperLink2\">";
html += "<img src=\"../img/button_add.png\" id=\"ContentPlaceHolder1_Image1\"></a>";
html += "</section>";
html += "</div>";
/////
string sqlYear = "Select Distinct EDUCATIONYEAR From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' Order By EDUCATIONYEAR";
List <TQF2Sec3SemesterPlan> tqf2Sec3SemesterPlan_Year = new TQF2Sec3SemesterPlan().getYear(sqlYear);
foreach (TQF2Sec3SemesterPlan rowYear in tqf2Sec3SemesterPlan_Year)
{
string sqlSemester = "Select Distinct EDUCATIONSEMESTER From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And EDUCATIONYEAR='" + rowYear.EducationYear + "' Order By EDUCATIONYEAR";
List <TQF2Sec3SemesterPlan> tqf2Sec3SemesterPlan_Semester = new TQF2Sec3SemesterPlan().getSemester(sqlSemester);
foreach (TQF2Sec3SemesterPlan rowSemester in tqf2Sec3SemesterPlan_Semester)
{
html += "<div>";
html += "<div class=\"row\">";
html += "<section class=\"col col-9\">";
html += "<h3 class=\"text-success\">ปีที่ " + rowYear.EducationYear + " ภาคการศึกษาที่ " + rowSemester.EducationSemester + "</h3>";
html += "</section>";
html += "<section class=\"col col-3 text-align-right\">";
html += "<a href=\"delete_CURR8_1.aspx?CurrCode=" + CurrCode + "&YearVersion=" + YearVersion + "&CurrFormatCode=" + CurrFormatCode + "&CurrTypeCode=" + CurrTypeCode + "&MajorCode=" + MajorCode + "&Year=" + rowYear.EducationYear + "&Semester=" + rowSemester.EducationSemester + "\" data-target=\"#deleteSemester\" data-toggle=\"modal\" title=\"ลบภาคการศึกษา\" id=\"HyperLink8\">";
html += "<h3><i class=\"fa fa-trash-o\"></i> ลบภาคการศึกษา</h3>";
html += "</a>";
html += "</section>";
html += "</div>";
//แสดงปุ่ม Add 2
html += "<div class=\"row\">";
html += "<section class=\"col col-3 pull-right\">";
html += " <a href=\"addEDU_PLAN.aspx?CurrCode=" + CurrCode + "&YearVersion=" + YearVersion + "&CurrFormatCode=" + CurrFormatCode + "&CurrTypeCode=" + CurrTypeCode + "&MajorCode=" + MajorCode + "&Year=" + rowYear.EducationYear + "&Semester=" + rowSemester.EducationSemester + "\" data-target=\"#addEDU_PLAN\" data-toggle=\"modal\" class=\"pull-right\" title=\"เพิ่มข้อมูล\" id=\"HyperLink2\">";
html += "<img src=\"../img/button_add.png\" id=\"" + rowYear + rowSemester + "\"></a>";
html += "</section>";
html += "</div>";
/////
html += "<section>";
Table tblGroupCategory = new Table();
htmlWriter(tblGroupCategory, "header", CurrFormatCode, CurrTypeCode, MajorCode, "0", "0");
html += htmlTableHeader;
string sqlCourse = "Select * From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And EDUCATIONYEAR='" + rowYear.EducationYear + "' And EDUCATIONSEMESTER='" + rowSemester.EducationSemester + "' Order By EDUCATIONYEAR";
List <TQF2Sec3SemesterPlan> tqf2Sec3SemesterPlan_Course = new TQF2Sec3SemesterPlan().getTQF2Sec3SemesterPlanManual(sqlCourse);
foreach (TQF2Sec3SemesterPlan rowCourse in tqf2Sec3SemesterPlan_Course)
{
htmlWriter(tblGroupCategory, "body", CurrFormatCode, CurrTypeCode, MajorCode, rowCourse.EducationYear, rowCourse.EducationSemester);
}
html += htmlTableBody;
html += "</section>";
}
html += "</div>";
}
html += "</div>";
html += "</div>";
html += "</div>";
html += "</div>";
html += "</section>";
Label la = new Label();
la.Text = html;
placeHTML.Controls.Add(la);
}
protected void tableBody(Table tblName, string CurrFormatCode, string CurrTypeCode, string MajorCode, string EducationYear, string EducationSemester)
{
string sql = "Select * From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And EDUCATIONYEAR='" + EducationYear + "' And EDUCATIONSEMESTER='" + EducationSemester + "' Order By COURSECODE";
List <TQF2Sec3SemesterPlan> tqf2Sec3SemesterPlan = new TQF2Sec3SemesterPlan().getTQF2Sec3SemesterPlanManual(sql);
foreach (TQF2Sec3SemesterPlan row in tqf2Sec3SemesterPlan)
{
TQF.Course course = new TQF.Course().getCourse(row.CourseCode);
CourseElective courseElective = new CourseElective().getCourseElectiveId(row.CourseCode);
TableRow tRowBody = new TableRow();
tRowBody.TableSection = TableRowSection.TableBody;
TableCell cellCourseCode = new TableCell();
//string urlShow = "showCOURSE.aspx?token=" + row.CourseCode;
string urlShow = "showCOURSE.aspx?token=" + row.CourseCode + "&CurrCode=" + CurrCode + "&YearVersion=" + YearVersion;
HyperLink hypShow = new HyperLink();
hypShow.Attributes.Add("data-target", "#showModal");
hypShow.Attributes.Add("data-toggle", "modal");
//แสดงรหัสวิชาระหว่างตาราง COURSE กับ COURSEELECTIVE
hypShow.Text = course.CourseCode + courseElective.CourseElectiveCode;
hypShow.NavigateUrl = urlShow;
hypShow.ToolTip = "Course details";
cellCourseCode.Controls.Add(hypShow);
cellCourseCode.CssClass = "text-center";
cellCourseCode.Width = 80;
tRowBody.Cells.Add(cellCourseCode);
TableCell cellNCourseThName = new TableCell();
cellNCourseThName.Text = course.CourseThName + courseElective.CourseElectiveThName + "<BR>";
cellNCourseThName.Text += course.CourseEnName + courseElective.CourseElectiveEnName;
tRowBody.Cells.Add(cellNCourseThName);
//TableCell cellNumCredit = new TableCell();
//cellNumCredit.Text = course.Credit + courseElective.Credit + " (" + course.TheoryHour + "-" + course.PracticeHour + "-" + course.SelfStudyHour + ")";
//cellNumCredit.Width = 100;
//tRowBody.Cells.Add(cellNumCredit);
TableCell cellNumCredit = new TableCell();
//หาจำนวนวิชาวิทยานิพนธ์ทั้งหมด
string creditCount = "";
int creDit = 0;
//ค่าที่เช็คเงื่อนไขว่าเป็นวิชาวิทยานิพนธ์ มาจากตาราง COURSETYPE
//7 วิทยานิพนธ์ (ป.เอก) Dissertation
//4 วิทยานิพนธ์ Thesis
//5 สารนิพนธ์ Master Project
if (course.CourseTypeCode == "4" || course.CourseTypeCode == "5" || course.CourseTypeCode == "7")
{
string sqlCreditCount = "Select COUNT(COURSECODE) As CREDITCOUNT From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And COURSECODE='" + row.CourseCode + "'";
//คำนวนหน่วยกิตโดยการหารด้วยจำนวนเทอมที่เรียน
creditCount = new TQF2Sec3SemesterPlan().getCountCreditTQF2Sec3SemesterPlanManual(sqlCreditCount).CreditCount;
try
{
creDit = int.Parse(course.Credit) / int.Parse(creditCount);
}
catch
{
creDit = 0;
}
//แสดงผลลงในตาราง
cellNumCredit.Text = creDit.ToString() + courseElective.Credit + " (" + course.TheoryHour + "-" + course.PracticeHour + "-" + course.SelfStudyHour + ")";
cellNumCredit.Width = 100;
tRowBody.Cells.Add(cellNumCredit);
}
else
{
//แสดงผลลงในตาราง
cellNumCredit.Text = course.Credit + courseElective.Credit + " (" + course.TheoryHour + "-" + course.PracticeHour + "-" + course.SelfStudyHour + ")";
cellNumCredit.Width = 100;
tRowBody.Cells.Add(cellNumCredit);
}
//&CourseCode=" + course.CourseCode + courseElective.CourseElectiveCode --> รหัสวิชา หรือ รหัสวิชาเลือก(xxx)
TableCell cellDel = new TableCell();
string urlDel = "delete_CURR8_2.aspx?CurrCode=" + CurrCode + "&YearVersion=" + YearVersion + "&CurrFormatCode=" + CurrFormatCode + "&CurrTypeCode=" + CurrTypeCode + "&MajorCode=" + MajorCode + "&Year=" + row.EducationYear + "&Semester=" + row.EducationSemester + "&CourseCode=" + course.CourseCode + courseElective.Id + "";
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteCourse");
hypDel.Attributes.Add("data-toggle", "modal");
hypDel.Text = "<h4><i class='fa fa-trash-o'></i></h4>";
hypDel.NavigateUrl = urlDel;
hypDel.ToolTip = "Delete";
cellDel.Controls.Add(hypDel);
cellDel.CssClass = "text-center";
cellDel.Width = 60;
tRowBody.Cells.Add(cellDel);
tblName.Rows.Add(tRowBody);
}
}
protected void htmlGenerateTab4(string MajorCode, string CurrFormatCode, string TotalCredits, string YearVersion, string CurrTypeCode)
{
//string sqlCreditCount = "Select COUNT(COURSECODE) As CREDITCOUNT From TQF2SEC3SEMESTERPLAN Where CURRCODE='707012555' And YEARVERSION='2555' And CURRFORMATCODE='008' And CURRTYPECODE='004' And MAJORCODE='0701' And COURSECODE='070115800'";
string html = "";
html += "<div class=\"row\" style=\"margin: 0 10px\">";
html += " <div class=\"col col-10\">";
html += " <h3 class=\"txt-title-blue\">";
html += " <i class=\"fa fa-file-text-o\"></i> ";
Label lblPlanTitle = new Label();
lblPlanTitle.Font.Bold = true;
lblPlanTitle.Text = new CurrType().getCurrType(CurrTypeCode).CurrTypeName + " (แขนงวิชา " + new TQF.Major().getMajor(MajorCode).MajorThName + ")";
html += lblPlanTitle.Text;
html += " </h3>";
html += " </div>";
html += "</div>";
string sqlYear = "Select Distinct EDUCATIONYEAR From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' Order By EDUCATIONYEAR";
List <TQF2Sec3SemesterPlan> tqf2Sec3SemesterPlan_Year = new TQF2Sec3SemesterPlan().getYear(sqlYear);
foreach (TQF2Sec3SemesterPlan rowYear in tqf2Sec3SemesterPlan_Year)
{
string sqlSemester = "Select Distinct EDUCATIONSEMESTER From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And EDUCATIONYEAR='" + rowYear.EducationYear + "' Order By EDUCATIONYEAR";
List <TQF2Sec3SemesterPlan> tqf2Sec3SemesterPlan_Semester = new TQF2Sec3SemesterPlan().getSemester(sqlSemester);
foreach (TQF2Sec3SemesterPlan rowSemester in tqf2Sec3SemesterPlan_Semester)
{
html += "<div class=\"row\" style=\"margin: 0 10px\">";
html += " <div class=\"col col-10\">";
html += " <p class=\"text-center\">";
Label label0 = new Label();
label0.Text = "ปีที่ " + rowYear.EducationYear + " ภาคการศึกษาที่ " + rowSemester.EducationSemester;
html += "<span id=\"Label11\" class=\"label bg-color-teal\" style=\"font-weight: bold; font-size: 16px\">" + label0.Text + "</span>";
html += " </p>";
html += " </div>";
html += "</div>";
html += "<div class=\"row\" style=\"margin: 0 10px; padding-bottom: 20px\">";
html += " <div class=\"col col-10\">";
Table tblGroupCategory = new Table();
// Head Table
string[] ar = { "รหัสวิชา", "ชื่อวิชา", "หน่วยกิต" };
tblGroupCategory.Attributes.Add("class", "table table-striped tb-curr-plan");
TableHeaderRow tRowHead = new TableHeaderRow();
tRowHead.CssClass = "danger";
tRowHead.TableSection = TableRowSection.TableHeader;
for (int cellCtr = 1; cellCtr <= ar.Length; cellCtr++)
{
TableHeaderCell cellHead = new TableHeaderCell();
cellHead.Text = ar[cellCtr - 1];
if (cellCtr == 1 || cellCtr == 3)
{
cellHead.Width = 100;
}
tRowHead.Cells.Add(cellHead);
}
tblGroupCategory.Rows.Add(tRowHead);
//Body Table
string sqlCourse = "Select * From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And EDUCATIONYEAR='" + rowYear.EducationYear + "' And EDUCATIONSEMESTER='" + rowSemester.EducationSemester + "' Order By COURSECODE";
List <TQF2Sec3SemesterPlan> tqf2Sec3SemesterPlan_Course = new TQF2Sec3SemesterPlan().getTQF2Sec3SemesterPlanManual(sqlCourse);
foreach (TQF2Sec3SemesterPlan row in tqf2Sec3SemesterPlan_Course)
{
TQF.Course course = new TQF.Course().getCourse(row.CourseCode);
CourseElective courseElective = new CourseElective().getCourseElectiveId(row.CourseCode);
TableRow tRowBody = new TableRow();
tRowBody.TableSection = TableRowSection.TableBody;
TableCell cellCourseCode = new TableCell();
string urlShow = "showCOURSE.aspx?token=" + row.CourseCode;
HyperLink hypShow = new HyperLink();
hypShow.Attributes.Add("data-target", "#course_desModal");
hypShow.Attributes.Add("data-toggle", "modal");
hypShow.Text = course.CourseCode + courseElective.CourseElectiveCode;
hypShow.NavigateUrl = urlShow;
hypShow.ToolTip = "Course details";
cellCourseCode.Controls.Add(hypShow);
cellCourseCode.CssClass = "text-center";
cellCourseCode.Width = 80;
tRowBody.Cells.Add(cellCourseCode);
TableCell cellNCourseThName = new TableCell();
cellNCourseThName.Text = course.CourseThName + courseElective.CourseElectiveThName + "<BR>";
cellNCourseThName.Text += course.CourseEnName + courseElective.CourseElectiveEnName;
tRowBody.Cells.Add(cellNCourseThName);
TableCell cellNumCredit = new TableCell();
//หาจำนวนวิชาวิทยานิพนธ์ทั้งหมด
string creditCount = "";
int creDit = 0;
//ค่าที่เช็คเงื่อนไขว่าเป็นวิชาวิทยานิพนธ์ มาจากตาราง COURSETYPE
//7 วิทยานิพนธ์ (ป.เอก) Dissertation
//4 วิทยานิพนธ์ Thesis
//5 สารนิพนธ์ Master Project
if (course.CourseTypeCode == "4" || course.CourseTypeCode == "5" || course.CourseTypeCode == "7")
{
string sqlCreditCount = "Select COUNT(COURSECODE) As CREDITCOUNT From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And COURSECODE='" + row.CourseCode + "'";
//คำนวนหน่วยกิตโดยการหารด้วยจำนวนเทอมที่เรียน
creditCount = new TQF2Sec3SemesterPlan().getCountCreditTQF2Sec3SemesterPlanManual(sqlCreditCount).CreditCount;
try
{
creDit = int.Parse(course.Credit) / int.Parse(creditCount);
}
catch
{
creDit = 0;
}
//แสดงผลลงในตาราง
cellNumCredit.Text = creDit.ToString() + courseElective.Credit + " (" + course.TheoryHour + "-" + course.PracticeHour + "-" + course.SelfStudyHour + ")";
cellNumCredit.Width = 100;
tRowBody.Cells.Add(cellNumCredit);
}
else
{
//แสดงผลลงในตาราง
cellNumCredit.Text = course.Credit + courseElective.Credit + " (" + course.TheoryHour + "-" + course.PracticeHour + "-" + course.SelfStudyHour + ")";
cellNumCredit.Width = 100;
tRowBody.Cells.Add(cellNumCredit);
}
tblGroupCategory.Rows.Add(tRowBody);
}
StringWriter htmlString = new StringWriter();
tblGroupCategory.RenderControl(new HtmlTextWriter(htmlString));
string htmlTableBody = htmlString.ToString();
html += htmlTableBody;
html += " </div>";
html += "</div>";
}
}
Label lblHTML4 = new Label();
lblHTML4.Text = html;
placeHTML4.Controls.Add(lblHTML4);
}
protected void btnSEARCH_Click(object sender, EventArgs e)
{
// Head Table
string[] ar = { "รหัสวิชา", "ชื่อวิชา", "หน่วยกิต", "คณะ", "สถานะเปิด/ปิด", "แก้ไข", "ลบ" };
tblCourse.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblCourse.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead = new TableHeaderRow();
tRowHead.TableSection = TableRowSection.TableHeader;
for (int cellCtr = 1; cellCtr <= ar.Length; cellCtr++)
{
// Create a new cell and add it to the row.
TableHeaderCell cellHead = new TableHeaderCell();
cellHead.Text = ar[cellCtr - 1];
tRowHead.Cells.Add(cellHead);
switch (cellCtr)
{
case 1:
cellHead.Width = 80;
break;
case 2:
break;
case 3:
cellHead.Width = 80;
break;
case 4:
break;
case 5:
cellHead.Width = 80;
break;
case 6:
cellHead.Width = 50;
break;
case 7:
cellHead.Width = 50;
break;
}
}
tblCourse.Rows.Add(tRowHead);
List <TQF.Course> course = new List <TQF.Course>();
if (ddlCURR_FACULTY.SelectedValue == "00")
{
course = new TQF.Course().getCourse();
}
else
{
string sql = "Select * From COURSE Where FACULTYCODE='" + ddlCURR_FACULTY.SelectedValue + "'";
course = new TQF.Course().getCourseManual(sql);
}
foreach (TQF.Course data in course)
{
TableRow tRowBody = new TableRow();
tRowBody.TableSection = TableRowSection.TableBody;
TableCell cellCourseCode = new TableCell();
string urlShow = "showCOURSE.aspx?token=" + data.CourseCode;
HyperLink hypShow = new HyperLink();
hypShow.Attributes.Add("data-target", "#showModal");
hypShow.Attributes.Add("data-toggle", "modal");
hypShow.Text = data.CourseCode;
hypShow.NavigateUrl = urlShow;
hypShow.ToolTip = "Course details";
cellCourseCode.Controls.Add(hypShow);
cellCourseCode.CssClass = "text-center";
cellCourseCode.Width = 80;
tRowBody.Cells.Add(cellCourseCode);
TableCell cellCourseEnName = new TableCell();
cellCourseEnName.Text = data.CourseThName + "<br>" + data.CourseEnName;
tRowBody.Cells.Add(cellCourseEnName);
TableCell cellCredit = new TableCell();
cellCredit.Text = data.Credit + "(" + data.TheoryHour + "-" + data.PracticeHour + "-" + data.SelfStudyHour + ")";
tRowBody.Cells.Add(cellCredit);
TableCell cellFacultyCode = new TableCell();
cellFacultyCode.Text = new Faculty().getFaculty(data.FacultyCode).Faculty_Thai;
cellFacultyCode.Width = 200;
tRowBody.Cells.Add(cellFacultyCode);
TableCell cellCourseStatus = new TableCell();
if (data.CourseStatus == "Y")
{
cellCourseStatus.Text = "<h4 class='txt-color-green'><i class='fa fa-check'></i></h4>"; // +data.CourseStatus;
}
if (data.CourseStatus == "N")
{
cellCourseStatus.Text = "<h4 class='txt-color-red'><i class='fa fa-times'></i></h4>"; // +data.CourseStatus;
}
cellCourseStatus.Width = 50;
cellCourseStatus.CssClass = "text-center";
tRowBody.Cells.Add(cellCourseStatus);
TableCell cellEdit = new TableCell();
// งานหลักสูตร
if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
{
string urlEdit = "editCOURSE.aspx?token=" + data.CourseCode;
HyperLink hypEdit = new HyperLink();
//hypEdit.Attributes.Add("data-target", "#editModal");
//hypEdit.Attributes.Add("data-toggle", "modal");
hypEdit.Text = "<h4><i class='fa fa-edit'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "Edit";
cellEdit.Controls.Add(hypEdit);
}
// วิชาการคณะ
//else if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
//{
// bool editable = false;
// List<string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty);
// foreach (string fac in faculty_authorized)
// {
// if (fac == data.FacultyCode)
// {
// editable = true;
// break;
// }
// }
// if (editable == true)
// {
// string urlEdit = "editCOURSE.aspx?token=" + data.CourseCode;
// HyperLink hypEdit = new HyperLink();
// //hypEdit.Attributes.Add("data-target", "#editModal");
// //hypEdit.Attributes.Add("data-toggle", "modal");
// hypEdit.Text = "<h4><i class='fa fa-edit'></i></h4>";
// hypEdit.NavigateUrl = urlEdit;
// hypEdit.ToolTip = "Edit";
// cellEdit.Controls.Add(hypEdit);
// }
// else
// {
// string urlEdit = "#";
// HyperLink hypEdit = new HyperLink();
// hypEdit.Text = "<h4><i class='fa fa-lock'></i></h4>";
// hypEdit.NavigateUrl = urlEdit;
// hypEdit.ToolTip = "ไม่สามารถแก้ไขได้";
// cellEdit.Controls.Add(hypEdit);
// }
//}
// วิชาการภาค
else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
bool editable = false;
List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department);
foreach (string dep in department_authorized)
{
if (dep.Substring(0, 2) == data.FacultyCode)
{
editable = true;
break;
}
}
if (editable == true)
{
string urlEdit = "editCOURSE.aspx?token=" + data.CourseCode;
HyperLink hypEdit = new HyperLink();
//hypEdit.Attributes.Add("data-target", "#editModal");
//hypEdit.Attributes.Add("data-toggle", "modal");
hypEdit.Text = "<h4><i class='fa fa-edit'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "Edit";
cellEdit.Controls.Add(hypEdit);
}
else
{
string urlEdit = "#";
HyperLink hypEdit = new HyperLink();
hypEdit.Text = "<h4><i class='fa fa-lock'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "ไม่สามารถแก้ไขได้";
cellEdit.Controls.Add(hypEdit);
}
}
// ทุกกลุ่มผู้ใช้
else
{
string urlEdit = "#";
HyperLink hypEdit = new HyperLink();
hypEdit.Text = "<h4><i class='fa fa-lock'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "ไม่สามารถแก้ไขได้";
cellEdit.Controls.Add(hypEdit);
}
cellEdit.CssClass = "text-center";
cellEdit.Width = 50;
tRowBody.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
//เช็คว่ารายวิชามีการนำไปใช้แล้วหรือยัง ถ้ามีแล้วจะไม่สามารถลบข้อมูลได้
bool chkExistCourse = new TQF2Sec3SemesterPlan().existCourse(data.CourseCode);
// งานหลักสูตร
if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty) && chkExistCourse == false)
{
string urlDel = "deleteCOURSE.aspx?token=" + data.CourseCode;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteModal");
hypDel.Attributes.Add("data-toggle", "modal");
hypDel.Text = "<h4><i class='fa fa-trash-o'></i></h4>";
hypDel.NavigateUrl = urlDel;
hypDel.ToolTip = "Delete";
cellDel.Controls.Add(hypDel);
}
// วิชาการคณะ
//else if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
//{
// bool editable = false;
// List<string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty);
// foreach (string fac in faculty_authorized)
// {
// if (fac == data.FacultyCode)
// {
// editable = true;
// break;
// }
// }
// if (editable == true && chkExistCourse == false)
// {
// string urlDel = "deleteCOURSE.aspx?token=" + data.CourseCode;
// HyperLink hypDel = new HyperLink();
// hypDel.Attributes.Add("data-target", "#deleteModal");
// hypDel.Attributes.Add("data-toggle", "modal");
// hypDel.Text = "<h4><i class='fa fa-trash-o'></i></h4>";
// hypDel.NavigateUrl = urlDel;
// hypDel.ToolTip = "Delete";
// cellDel.Controls.Add(hypDel);
// }
// else
// {
// string urlDel = "#";
// HyperLink hypDel = new HyperLink();
// hypDel.Text = "<h4><i class='fa fa-lock'></i></h4>";
// hypDel.NavigateUrl = urlDel;
// hypDel.ToolTip = "ไม่สามารถลบได้";
// cellDel.Controls.Add(hypDel);
// }
//}
// วิชาการภาค
else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
bool editable = false;
List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department);
foreach (string dep in department_authorized)
{
if (dep.Substring(0, 2) == data.FacultyCode)
{
editable = true;
break;
}
}
if (editable == true && chkExistCourse == false)
{
string urlDel = "deleteCOURSE.aspx?token=" + data.CourseCode;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteModal");
hypDel.Attributes.Add("data-toggle", "modal");
hypDel.Text = "<h4><i class='fa fa-trash-o'></i></h4>";
hypDel.NavigateUrl = urlDel;
hypDel.ToolTip = "Delete";
cellDel.Controls.Add(hypDel);
}
else
{
string urlDel = "#";
HyperLink hypDel = new HyperLink();
hypDel.Text = "<h4><i class='fa fa-lock'></i></h4>";
hypDel.NavigateUrl = urlDel;
hypDel.ToolTip = "ไม่สามารถลบได้";
cellDel.Controls.Add(hypDel);
}
}
// ทุกกลุ่มผู้ใช้
else
{
string urlDel = "#";
HyperLink hypDel = new HyperLink();
hypDel.Text = "<h4><i class='fa fa-lock'></i></h4>";
hypDel.NavigateUrl = urlDel;
hypDel.ToolTip = "ไม่สามารถลบได้";
cellDel.Controls.Add(hypDel);
}
cellDel.CssClass = "text-center";
cellDel.Width = 50;
tRowBody.Cells.Add(cellDel);
tblCourse.Rows.Add(tRowBody);
}
}
//protected void btnNEXT_Click(object sender, EventArgs e)
//{
// Response.RedirectPermanent("./addCURR_GEN_EDU1.aspx");
//}
protected void btnNext_Click(object sender, EventArgs e)
{
if (rBtnNEW_CURR.Checked)
{
Response.Redirect("addCURR_GEN_EDU1.aspx");
}
if (rBtnMINOR_MODI_CURR.Checked || rBtnMAJOR_MODI_CURR.Checked)
{
string sql = "Select * From CURRICULUM Where CURRCODE='" + txtCURR_CODE.Text + "' And YEARVERSION='" + txtCURR_YEAR_VERSION.Text + "'";
List <TQF.Curriculum> curriculum = new TQF.Curriculum().getCurriculumManual(sql);
//เช็คหลักสูตรซ้ำ
if (curriculum.Count > 0)
{
btnNext.Visible = false;
divError.Visible = true;
}
else
{
/////***STEP 1***/////
string sqlCurriculumInsert = "Insert into CURRICULUM (CURRCODE,YEARVERSION) Values (" + txtCURR_CODE.Text + "," + txtCURR_YEAR_VERSION.Text + ")";
string insertCurriculum = new TQF.Curriculum().insertCurriculumManual(sqlCurriculumInsert);
string sqlCurriculumUpdate = "Update CURRICULUM Set (LEVELCODE,FACULTYCODE,DEPARTMENTCODE,DIVISIONNO,CURRTHNAME,CURRENNAME,CURRSTATUS,APPROVESTATUS,BEGINYEAR,BEGINSEMESTER,DIPLOMACODE,NUMYEAR,MAXNUMYEAR,MAJORSTATUS,NUMTQF1,CURRSHORTTHNAME,CURRSHORTENNAME) = (Select LEVELCODE,FACULTYCODE,DEPARTMENTCODE,DIVISIONNO,CURRTHNAME,CURRENNAME,CURRSTATUS,APPROVESTATUS,BEGINYEAR,BEGINSEMESTER,DIPLOMACODE,NUMYEAR,MAXNUMYEAR,MAJORSTATUS,NUMTQF1,CURRSHORTTHNAME,CURRSHORTENNAME From CURRICULUM Where CURRCODE='" + ddlCOPY_CURR_CODE.SelectedValue + "' And YEARVERSION='" + ddlCOPY_YEAR_VERSION.SelectedValue + "') Where CURRCODE='" + txtCURR_CODE.Text + "' And YEARVERSION='" + txtCURR_YEAR_VERSION.Text + "'";
string updateCurriculum = new TQF.Curriculum().updateCurriculumManual(sqlCurriculumUpdate);
TQF.Curriculum curriculumData = new TQF.Curriculum().getCurriculum(txtCURR_CODE.Text, txtCURR_YEAR_VERSION.Text);
/////---> ชื่อหลักสูตร, ชื่อย่อหลักสูตร, ชื่อเต็มปริญญา, ชื่อย่อปริญญา
Diploma diploma = new Diploma().getDiploma(curriculumData.DiplomaCode);
Diploma diplomaData = new Diploma();
diplomaData.YearVersion = txtCURR_YEAR_VERSION.Text;
diplomaData.DiplomaCode = new TQF.TQFUtility().getMaxID("DIPLOMACODE", "DIPLOMA");
diplomaData.CurrCode = txtCURR_CODE.Text;
diplomaData.DomainThName = diploma.DomainThName;
diplomaData.DomainEnName = diploma.DomainEnName;
diplomaData.DomainThShortName = diploma.DomainThShortName;
diplomaData.DomainEnShortName = diploma.DomainEnShortName;
string insertDiploma = new Diploma().insertDiploma(diplomaData);
/////<---
/////---> สาขาวิชา
//เรียกดูค่า DivisionNo ก่อน Insert ลงตาราง CURRICULUM
string sqlDivisionExtension = "Select * From DIVISIONEXTENSION Where CURRCODE='" + ddlCOPY_CURR_CODE.SelectedValue + "' And YEARVERSION='" + ddlCOPY_YEAR_VERSION.SelectedValue + "'";
List <DivisionExtension> DivisionNoList = new DivisionExtension().getDivisionExtensionManual(sqlDivisionExtension);
int DivisionNo = int.Parse(new TQF.TQFUtility().getMaxID("DIVISIONNO", "DIVISIONEXTENSION"));
foreach (DivisionExtension li in DivisionNoList)
{
DivisionExtension row = new DivisionExtension();
row.CurrCode = txtCURR_CODE.Text;
row.YearVersion = txtCURR_YEAR_VERSION.Text;
row.DivisionNo = DivisionNo.ToString();;
row.DivisionCode = li.DivisionCode;
string insertDivisionExtension = new DivisionExtension().insertDivisionExtension(row);
if (insertDivisionExtension == "Success")
{
continue;
}
else
{
string sql2 = "Delete From DIVISIONEXTENSION Where CURRCODE ='" + txtCURR_CODE.Text + "' And YEARVERSION='" + txtCURR_YEAR_VERSION.Text + "'";
string deleteDivisionExtension = new DivisionExtension().deleteDivisionExtensionMaual(sql2);
Response.Redirect("Faculty_add_CURR0.aspx");
}
}
/////<---
/////---> อาจารย์ประจำหลักสูตร
string sqlAboutLecturer = "Select * From ABOUTLECTURER Where CURRCODE='" + ddlCOPY_CURR_CODE.SelectedValue + "' And YEARVERSION='" + ddlCOPY_YEAR_VERSION.SelectedValue + "'";
List <AboutLecturer> aboutLecturer2 = new AboutLecturer().getAboutLecturerManual(sqlAboutLecturer);
foreach (AboutLecturer li in aboutLecturer2)
{
int sequence = int.Parse(new TQF.TQFUtility().getMaxID("SEQUENCE", "ABOUTLECTURER"));
AboutLecturer aboutlecturer = new AboutLecturer();
aboutlecturer.CurrCode = txtCURR_CODE.Text;
aboutlecturer.YearVersion = txtCURR_YEAR_VERSION.Text;
aboutlecturer.LectIdentity = li.LectIdentity;
aboutlecturer.LoadTypeCode = li.LoadTypeCode; //1 = อาจารย์ประจำหลักสูตร (ข้อมูลจากตาราง LoadType)
aboutlecturer.Sequence = sequence.ToString();
aboutlecturer.MajorCode = li.MajorCode;
string insertAboutlecturer = new AboutLecturer().insertAboutLecturer(aboutlecturer);
if (insertAboutlecturer == "Success")
{
continue;
}
else
{
string sqlDeleteAboutLecturer = "Delete From ABOUTLECTURER Where CURRCODE ='" + txtCURR_CODE.Text + "' And YEARVERSION='" + txtCURR_YEAR_VERSION.Text + "'";
string deleteAboutLecturer = new AboutLecturer().deleteAboutLecturerManual(sqlDeleteAboutLecturer);
Response.Redirect("Faculty_add_CURR0.aspx");
}
}
/////<---
//Update สุดท้าย
string sqlCurriculumUpdate2 = "Update CURRICULUM Set DIVISIONNO='" + DivisionNo.ToString() + "', APPROVESTATUS='N', BEGINYEAR='" + txtCURR_YEAR_VERSION.Text + "',DIPLOMACODE='" + diplomaData.DiplomaCode + "' Where CURRCODE='" + txtCURR_CODE.Text + "' And YEARVERSION='" + txtCURR_YEAR_VERSION.Text + "'";
string updateCurriculum2 = new TQF.Curriculum().updateCurriculumManual(sqlCurriculumUpdate2);
/////***STEP 1_1***/////
/////---> แขนงวิชา
string sqlMajor = "Select * From MAJOR Where CURRCODE='" + ddlCOPY_CURR_CODE.SelectedValue + "' And YEARVERSION='" + ddlCOPY_YEAR_VERSION.SelectedValue + "'";
List <TQF.Major> majorList = new TQF.Major().getMajorManual(sqlMajor);
foreach (TQF.Major rowMajor in majorList)
{
//เก็บข้อมูลแขนงวิชาลงตาราง Major
TQF.Major major = new TQF.Major();
major.MajorCode = rowMajor.MajorCode;
major.MajorThName = rowMajor.MajorThName;
major.MajorEnName = rowMajor.MajorEnName;
major.CurrCode = txtCURR_CODE.Text;
major.YearVersion = txtCURR_YEAR_VERSION.Text;
string insertMajor = new TQF.Major().insertMajor(major);
if (insertMajor == "Success")
{
continue;
}
else
{
string sqlDeleteMajor = "Delete From MAJOR Where CURRCODE ='" + txtCURR_CODE.Text + "' And YEARVERSION='" + txtCURR_YEAR_VERSION.Text + "'";
string deleteMajor = new TQF.Major().deleteMajorManual(sqlDeleteMajor);
Response.Redirect("Faculty_add_CURR0.aspx");
}
}
/////<---
/////***STEP 2***/////
/////---> มาตรฐานผลการเรียนรู้
string sqlTQF2Sec4Sub1 = "Select * From TQF2SEC4SUB1 Where CURRCODE='" + ddlCOPY_CURR_CODE.SelectedValue + "' And YEARVERSION='" + ddlCOPY_YEAR_VERSION.SelectedValue + "'";
List <TQF2Sec4Sub1> tqf2Sec4Sub1 = new TQF2Sec4Sub1().getTQF2Sec4Sub1Manual(sqlTQF2Sec4Sub1);
foreach (TQF2Sec4Sub1 rowTQF2Sec4Sub1 in tqf2Sec4Sub1)
{
TQF2Sec4Sub1 data = new TQF2Sec4Sub1();
data.T2S4Sub1No = new TQF.TQFUtility().getMaxID("T2S4SUB1NO", "TQF2SEC4SUB1");
data.CurrCode = txtCURR_CODE.Text;
data.DomainTypeCode = rowTQF2Sec4Sub1.DomainTypeCode;
data.DetailType = rowTQF2Sec4Sub1.DetailType;
data.Detail = rowTQF2Sec4Sub1.Detail;
data.YearVersion = txtCURR_YEAR_VERSION.Text;
string insertTQF2Sec4Sub1 = new TQF2Sec4Sub1().insertTQF2Sec4Sub1(data);
if (insertTQF2Sec4Sub1 == "Success")
{
continue;
}
else
{
string sqlDeleteTQF2Sec4Sub1 = "Delete From TQF2SEC4SUB1 Where CURRCODE ='" + txtCURR_CODE.Text + "' And YEARVERSION='" + txtCURR_YEAR_VERSION.Text + "'";
string deleteTQF2Sec4Sub1 = new TQF2Sec4Sub1().deleteTQF2Sec4Sub1Manual(sqlDeleteTQF2Sec4Sub1);
Response.Redirect("Faculty_add_CURR0.aspx");
}
}
/////<---
/////***STEP 3***/////
/////---> โครงสร้างหลักสูตร
string sqlStructurePlan = "Select * From STRUCTUREPLAN Where CURRCODE='" + ddlCOPY_CURR_CODE.SelectedValue + "' And YEARVERSION='" + ddlCOPY_YEAR_VERSION.SelectedValue + "'";
List <StructurePlan> dataStructurePlan = new StructurePlan().getStructurePlanManual(sqlStructurePlan);
if (dataStructurePlan.Count > 0)
{
foreach (StructurePlan data in dataStructurePlan)
{
StructurePlan structurePlanData = new StructurePlan();
structurePlanData.CurrCode = txtCURR_CODE.Text;
structurePlanData.YearVersion = txtCURR_YEAR_VERSION.Text;
structurePlanData.CurrFormatCode = data.CurrFormatCode;
structurePlanData.CurrTypeCode = data.CurrTypeCode;
structurePlanData.MajorCode = data.MajorCode;
structurePlanData.StructureType = data.StructureType;
structurePlanData.TotalCredits = data.TotalCredits;
string insertStructurePlan = new StructurePlan().insertStructurePlan(structurePlanData);
if (insertStructurePlan == "Success")
{
continue;
}
else
{
string sqlDeleteStructurePlan = "Delete From TQF2SEC4SUB1 Where CURRCODE ='" + txtCURR_CODE.Text + "' And YEARVERSION='" + txtCURR_YEAR_VERSION.Text + "'";
string deleteStructurePlan = new StructurePlan().deleteStructurePlanManual(sqlDeleteStructurePlan);
Response.Redirect("Faculty_add_CURR0.aspx");
}
}
}
/////<---
/////***STEP 4***/////
/////---> หมวดวิชา
string sqlTQF2Sec3StructureCategory = "Select * From TQF2SEC3STRUCTURECATEGORY Where CURRCODE='" + ddlCOPY_CURR_CODE.SelectedValue + "' And YEARVERSION='" + ddlCOPY_YEAR_VERSION.SelectedValue + "'";
List <TQF2Sec3StructureCategory> tqf2s3StructureCategory = new TQF2Sec3StructureCategory().getTQF2Sec3StructureCategoryManual(sqlTQF2Sec3StructureCategory);
foreach (TQF2Sec3StructureCategory row in tqf2s3StructureCategory)
{
TQF2Sec3StructureCategory summaryData = new TQF2Sec3StructureCategory();
summaryData.CurrCode = txtCURR_CODE.Text;
summaryData.YearVersion = txtCURR_YEAR_VERSION.Text;
summaryData.CurrFormatCode = row.CurrFormatCode;
summaryData.CurrTypeCode = row.CurrTypeCode;
summaryData.MajorCode = row.MajorCode;
summaryData.CategoryCode = row.CategoryCode;
summaryData.CategoryCredits = row.CategoryCredits;
string insertTQF2Sec3StructureCategory = new TQF2Sec3StructureCategory().insertTQF2Sec3StructureCategory(summaryData);
if (insertTQF2Sec3StructureCategory == "Success")
{
continue;
}
else
{
string sqlDeleteStructureCategory = "Delete From TQF2SEC3STRUCTURECATEGORY Where CURRCODE ='" + txtCURR_CODE.Text + "' And YEARVERSION='" + txtCURR_YEAR_VERSION.Text + "'";
string deleteTQF2Sec3StructureCategory = new TQF2Sec3StructureCategory().deleteTQF2Sec3StructureCategoryManual(sqlDeleteStructureCategory);
Response.Redirect("Faculty_add_CURR0.aspx");
}
}
/////<---
/////***STEP 5***/////
/////---> กลุ่มวิชา
string sqlTQF2Sec3StructureGroup = "Select * From TQF2SEC3STRUCTUREGROUP Where CURRCODE='" + ddlCOPY_CURR_CODE.SelectedValue + "' And YEARVERSION='" + ddlCOPY_YEAR_VERSION.SelectedValue + "'";
List <TQF2Sec3StructureGroup> tqf2Sec3StructureGroup = new TQF2Sec3StructureGroup().getTQF2Sec3StructureGroupManual(sqlTQF2Sec3StructureGroup);
foreach (TQF2Sec3StructureGroup row in tqf2Sec3StructureGroup)
{
TQF2Sec3StructureGroup dataInsert = new TQF2Sec3StructureGroup();
dataInsert.CurrCode = txtCURR_CODE.Text;;
dataInsert.YearVersion = txtCURR_YEAR_VERSION.Text;
dataInsert.CurrFormatCode = row.CurrFormatCode;
dataInsert.CurrTypeCode = row.CurrTypeCode;
dataInsert.MajorCode = row.MajorCode;
dataInsert.CategoryCode = row.CategoryCode;
dataInsert.CourseGroupCode = row.CourseGroupCode;
dataInsert.GroupCredits = row.GroupCredits;
dataInsert.CourseGroupFlag = row.CourseGroupFlag;
string insertTQF2Sec3StructureGroup = new TQF2Sec3StructureGroup().insertTQF2Sec3StructureGroup(dataInsert);
if (insertTQF2Sec3StructureGroup == "Success")
{
continue;
}
else
{
string sqlDeleteStructureGroup = "Delete From TQF2SEC3STRUCTUREGROUP Where CURRCODE ='" + txtCURR_CODE.Text + "' And YEARVERSION='" + txtCURR_YEAR_VERSION.Text + "'";
string deleteTQF2Sec3StructureGroup = new TQF2Sec3StructureGroup().deleteTQF2Sec3StructureGroupManual(sqlDeleteStructureGroup);
Response.Redirect("Faculty_add_CURR0.aspx");
}
}
/////<---
/////***STEP 5_1***/////
/////---> กลุ่มวิชา
string sqlTqf2Sec3StructureType = "Select * From TQF2SEC3STRUCTURETYPE Where CURRCODE='" + ddlCOPY_CURR_CODE.SelectedValue + "' And YEARVERSION='" + ddlCOPY_YEAR_VERSION.SelectedValue + "'";
List <Tqf2Sec3StructureType> tqf2Sec3StructureType = new Tqf2Sec3StructureType().getTqf2Sec3StructureTypeManual(sqlTqf2Sec3StructureType);
foreach (Tqf2Sec3StructureType row in tqf2Sec3StructureType)
{
Tqf2Sec3StructureType dataInsert = new Tqf2Sec3StructureType();
dataInsert.CurrCode = txtCURR_CODE.Text;
dataInsert.YearVersion = txtCURR_YEAR_VERSION.Text;
dataInsert.CurrFormatCode = row.CurrFormatCode;
dataInsert.CurrTypeCode = row.CurrTypeCode;
dataInsert.MajorCode = row.MajorCode;
dataInsert.CategoryCode = row.CategoryCode;
dataInsert.CourseGroupCode = row.CourseGroupCode;
dataInsert.CourseTypeCode = row.CourseTypeCode;
dataInsert.TypeCredits = row.TypeCredits;
string insertTqf2Sec3StructureType = new Tqf2Sec3StructureType().insertTqf2Sec3StructureType(dataInsert);
if (insertTqf2Sec3StructureType == "Success")
{
continue;
}
else
{
string sqlDeleteStructureType = "Delete From TQF2SEC3STRUCTURETYPE Where CURRCODE ='" + txtCURR_CODE.Text + "' And YEARVERSION='" + txtCURR_YEAR_VERSION.Text + "'";
string deleteTqf2Sec3StructureType = new Tqf2Sec3StructureType().deleteTqf2Sec3StructureTypeManual(sqlDeleteStructureType);
Response.Redirect("Faculty_add_CURR0.aspx");
}
}
/////<---
/////***STEP 6***/////
/////---> รายวิชา
string sqlTQF2Sec3PlanDetail = "Select * From TQF2SEC3PLANDETAIL Where CURRCODE='" + ddlCOPY_CURR_CODE.SelectedValue + "' And YEARVERSION='" + ddlCOPY_YEAR_VERSION.SelectedValue + "'";
List <TQF2Sec3PlanDetail> tqf2Sec3PlanDetail = new TQF2Sec3PlanDetail().getTQF2Sec3PlanDetailManual(sqlTQF2Sec3PlanDetail);
foreach (TQF2Sec3PlanDetail row in tqf2Sec3PlanDetail)
{
TQF2Sec3PlanDetail dataInsert = new TQF2Sec3PlanDetail();
dataInsert.T2S3No = new TQF.TQFUtility().getMaxID("T2S3NO", "TQF2SEC3PLANDETAIL");
dataInsert.CurrCode = txtCURR_CODE.Text;
dataInsert.YearVersion = txtCURR_YEAR_VERSION.Text;
dataInsert.CurrFormatCode = row.CurrFormatCode;
dataInsert.CurrTypeCode = row.CurrTypeCode;
dataInsert.MajorCode = row.MajorCode;
dataInsert.CourseGroupCode = row.CourseGroupCode;
dataInsert.CategoryCode = row.CategoryCode;
dataInsert.CourseTypeCode = row.CourseTypeCode;
dataInsert.CourseCode = row.CourseCode;
dataInsert.EducationYear = row.EducationYear;
dataInsert.EducationSemester = row.EducationSemester;
string insertTQF2Sec3PlanDetail = new TQF2Sec3PlanDetail().insertTQF2Sec3PlanDetail(dataInsert);
if (insertTQF2Sec3PlanDetail == "Success")
{
continue;
}
else
{
string sqlDeletePlanDetail = "Delete From TQF2SEC3PLANDETAIL Where CURRCODE ='" + txtCURR_CODE.Text + "' And YEARVERSION='" + txtCURR_YEAR_VERSION.Text + "'";
string deleteTQF2Sec3PlanDetail = new TQF2Sec3PlanDetail().deleteTQF2Sec3PlanDetailManual(sqlDeletePlanDetail);
Response.Redirect("Faculty_add_CURR0.aspx");
}
}
/////<---
/////***STEP 7***/////
/////---> กำหนด Curriculum Mapping
string sqlTQF2Sec4CurriculumMapping = "Select * From TQF2SEC4CURRICULUMMAPPING Where CURRCODE='" + ddlCOPY_CURR_CODE.SelectedValue + "' And YEARVERSION='" + ddlCOPY_YEAR_VERSION.SelectedValue + "'";
List <TQF2Sec4CurriculumMapping> tqf2Sec4CurriculumMapping = new TQF2Sec4CurriculumMapping().getTQF2Sec4CurriculumMappingManual(sqlTQF2Sec4CurriculumMapping);
foreach (TQF2Sec4CurriculumMapping row in tqf2Sec4CurriculumMapping)
{
TQF2Sec4CurriculumMapping tqf2Sec4CurriculumMappingData = new TQF2Sec4CurriculumMapping();
tqf2Sec4CurriculumMappingData.CurrCode = txtCURR_CODE.Text;
tqf2Sec4CurriculumMappingData.CourseCode = row.CourseCode;
tqf2Sec4CurriculumMappingData.DomainTypeCode = row.DomainTypeCode;
tqf2Sec4CurriculumMappingData.ResponseStatus = row.ResponseStatus;
tqf2Sec4CurriculumMappingData.YearVersion = txtCURR_YEAR_VERSION.Text;
tqf2Sec4CurriculumMappingData.T2S4Sub1No = row.T2S4Sub1No;
string insertCurriculumMapping = new TQF2Sec4CurriculumMapping().insertTQF2Sec4CurriculumMapping(tqf2Sec4CurriculumMappingData);
if (insertCurriculumMapping == "Success")
{
continue;
}
else
{
string sqlDeleteCurriculumMapping = "Delete From TQF2SEC4CURRICULUMMAPPING Where CURRCODE ='" + txtCURR_CODE.Text + "' And YEARVERSION='" + txtCURR_YEAR_VERSION.Text + "'";
string deleteTQF2Sec4CurriculumMapping = new TQF2Sec4CurriculumMapping().deleteTQF2Sec4CurriculumMappingManual(sqlDeleteCurriculumMapping);
Response.Redirect("Faculty_add_CURR0.aspx");
}
}
/////<---
/////***STEP 8***/////
/////---> กำหนดแผนการศึกษา
string sqlTQF2Sec3SemesterPlan = "Select * From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + ddlCOPY_CURR_CODE.SelectedValue + "' And YEARVERSION='" + ddlCOPY_YEAR_VERSION.SelectedValue + "'";
List <TQF2Sec3SemesterPlan> tqf2Sec3SemesterPlan = new TQF2Sec3SemesterPlan().getTQF2Sec3SemesterPlanManual(sqlTQF2Sec3SemesterPlan);
foreach (TQF2Sec3SemesterPlan row in tqf2Sec3SemesterPlan)
{
TQF2Sec3SemesterPlan dataInsert = new TQF2Sec3SemesterPlan();
dataInsert.CurrCode = txtCURR_CODE.Text;
dataInsert.YearVersion = txtCURR_YEAR_VERSION.Text;
dataInsert.CurrFormatCode = row.CurrFormatCode;
dataInsert.CurrTypeCode = row.CurrTypeCode;
dataInsert.MajorCode = row.MajorCode;
dataInsert.CourseCode = row.CourseCode;
dataInsert.EducationYear = row.EducationYear;
dataInsert.EducationSemester = row.EducationSemester;
string insertTQF2Sec3SemesterPlan = new TQF2Sec3SemesterPlan().insertTQF2Sec3SemesterPlan(dataInsert);
if (insertTQF2Sec3SemesterPlan == "Success")
{
continue;
}
else
{
string sqlDeleteTQF2Sec3SemesterPlan = "Delete From TQF2SEC3SEMESTERPLAN Where CURRCODE ='" + txtCURR_CODE.Text + "' And YEARVERSION='" + txtCURR_YEAR_VERSION.Text + "'";
string deleteTQF2Sec3SemesterPlan = new TQF2Sec3SemesterPlan().deleteTQF2Sec3SemesterPlanManual(sqlDeleteTQF2Sec3SemesterPlan);
Response.Redirect("Faculty_add_CURR0.aspx");
}
}
/////<---
//สร้าง session CurrCode ไว้ใช้สำหรับทุกหน้าในการสร้างหลักสูตร
Session["CurrCode"] = curriculumData.CurrCode;
Session["YearVersion"] = curriculumData.YearVersion;
Session["NumTQF1"] = curriculumData.NumTQF1;
Response.Redirect("Faculty_edit_CURR.aspx?CurrCode=" + curriculumData.CurrCode + "&YearVersion=" + curriculumData.YearVersion);
}
}
}
protected void htmlGenerateTab4(string MajorCode, string CurrFormatCode, string TotalCredits, string YearVersion, string CurrTypeCode)
{
string html = "";
html += "<div class=\"box-group-data\">";
html += "<p class=\"text-center\">";
html += "<span class=\"report-bold\">";
Label lblPlanTitle = new Label();
lblPlanTitle.Text = new CurrType().getCurrType(CurrTypeCode).CurrTypeName;
html += lblPlanTitle.Text;
html += "</span>";
html += "<br />";
html += "<span class=\"report-bold\">";
Label lblPlanTitle2 = new Label();
lblPlanTitle2.Text = " แขนงวิชา" + new TQF.Major().getMajor(MajorCode).MajorThName;
html += lblPlanTitle2.Text;
html += "</span>";
html += "</p>";
string sqlYear = "Select Distinct EDUCATIONYEAR From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' Order By EDUCATIONYEAR";
List <TQF2Sec3SemesterPlan> tqf2Sec3SemesterPlan_Year = new TQF2Sec3SemesterPlan().getYear(sqlYear);
foreach (TQF2Sec3SemesterPlan rowYear in tqf2Sec3SemesterPlan_Year)
{
string sqlSemester = "Select Distinct EDUCATIONSEMESTER From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And EDUCATIONYEAR='" + rowYear.EducationYear + "' Order By EDUCATIONYEAR";
List <TQF2Sec3SemesterPlan> tqf2Sec3SemesterPlan_Semester = new TQF2Sec3SemesterPlan().getSemester(sqlSemester);
foreach (TQF2Sec3SemesterPlan rowSemester in tqf2Sec3SemesterPlan_Semester)
{
html += "<p class=\"text-center\">";
Label label0 = new Label();
label0.Text = "ปีที่ " + rowYear.EducationYear + " ภาคการศึกษาที่ " + rowSemester.EducationSemester;
html += "<span class=\"report-bold\">" + label0.Text + "</span>";
html += "</p>";
html += "<table class=\"table-course\">";
//Body Table
string sqlCourse = "Select * From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And EDUCATIONYEAR='" + rowYear.EducationYear + "' And EDUCATIONSEMESTER='" + rowSemester.EducationSemester + "' Order By COURSECODE";
List <TQF2Sec3SemesterPlan> tqf2Sec3SemesterPlan_Course = new TQF2Sec3SemesterPlan().getTQF2Sec3SemesterPlanManual(sqlCourse);
foreach (TQF2Sec3SemesterPlan row in tqf2Sec3SemesterPlan_Course)
{
TQF.Course course = new TQF.Course().getCourse(row.CourseCode);
CourseElective courseElective = new CourseElective().getCourseElectiveId(row.CourseCode);
html += "<tr>";
html += "<td>" + course.CourseCode + courseElective.CourseElectiveCode + "</td>";
html += "<td>";
html += course.CourseThName + courseElective.CourseElectiveThName + "<BR>";
html += course.CourseEnName + courseElective.CourseElectiveEnName;
html += "</td>";
//หาจำนวนวิชาวิทยานิพนธ์ทั้งหมด
string creditCount = "";
int creDit = 0;
//ค่าที่เช็คเงื่อนไขว่าเป็นวิชาวิทยานิพนธ์ มาจากตาราง COURSETYPE
//7 วิทยานิพนธ์ (ป.เอก) Dissertation
//4 วิทยานิพนธ์ Thesis
//5 สารนิพนธ์ Master Project
if (course.CourseTypeCode == "4" || course.CourseTypeCode == "5" || course.CourseTypeCode == "7")
{
string sqlCreditCount = "Select COUNT(COURSECODE) As CREDITCOUNT From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And COURSECODE='" + row.CourseCode + "'";
//คำนวนหน่วยกิตโดยการหารด้วยจำนวนเทอมที่เรียน
creditCount = new TQF2Sec3SemesterPlan().getCountCreditTQF2Sec3SemesterPlanManual(sqlCreditCount).CreditCount;
try
{
creDit = int.Parse(course.Credit) / int.Parse(creditCount);
}
catch
{
creDit = 0;
}
//แสดงผลลงในตาราง
html += "<td>";
html += creDit.ToString() + courseElective.Credit + " (" + course.TheoryHour + "-" + course.PracticeHour + "-" + course.SelfStudyHour + ")";
html += "</td>";
}
else
{
//แสดงผลลงในตาราง
html += "<td>";
html += course.Credit + courseElective.Credit + " (" + course.TheoryHour + "-" + course.PracticeHour + "-" + course.SelfStudyHour + ")";
html += "</td>";
}
html += "</tr>";
}
html += "</table>";
}
}
html += "</div>";
Label lblHTML4 = new Label();
lblHTML4.Text = html;
placeHTML4.Controls.Add(lblHTML4);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
// ======== Process ===========
if (!Page.IsPostBack)
{
List <FacultyData> faculty = new Faculty().getFaculty();
ddlCURR_FACULTY.Items.Clear();
foreach (FacultyData row in faculty)
{
ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(row.Faculty_Thai, row.Faculty_Code));
//if(row.Faculty_Code == "11")
// {
// ddlCURR_FACULTY.Items.FindByValue(row.Faculty_Code).Selected = true;
// }
}
ddlCURR_FACULTY.Items.Insert(0, new ListItem("-- ทุกคณะ --", "00"));
// Head Table
string[] ar = { "รหัสวิชา", "ชื่อวิชา", "หน่วยกิต", "คณะ", "แก้ไข", "ลบ" };
tblElective.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblElective.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead = new TableHeaderRow();
tRowHead.TableSection = TableRowSection.TableHeader;
for (int cellCtr = 1; cellCtr <= ar.Length; cellCtr++)
{
// Create a new cell and add it to the row.
TableHeaderCell cellHead = new TableHeaderCell();
cellHead.Text = ar[cellCtr - 1];
tRowHead.Cells.Add(cellHead);
}
tblElective.Rows.Add(tRowHead);
List <CourseElective> electiveCourse = new List <CourseElective>();
electiveCourse = new CourseElective().getCourseElective();
foreach (CourseElective data in electiveCourse)
{
TableRow tRowBody = new TableRow();
tRowBody.TableSection = TableRowSection.TableBody;
TableCell cellCourseCode = new TableCell();
cellCourseCode.Text = data.CourseElectiveCode;
cellCourseCode.Width = 100;
tRowBody.Cells.Add(cellCourseCode);
//string urlShow = "showElective_COURSE.aspx?token=" + data.CourseElectiveCode + "&facId=" + data.FacultyCode;
//HyperLink hypShow = new HyperLink();
//hypShow.Attributes.Add("data-target", "#showModal");
//hypShow.Attributes.Add("data-toggle", "modal");
//hypShow.Text = data.CourseElectiveCode;
//hypShow.NavigateUrl = urlShow;
//hypShow.ToolTip = "Course details";
//cellCourseCode.Controls.Add(hypShow);
//cellCourseCode.CssClass = "text-center";
//cellCourseCode.Width = 100;
//tRowBody.Cells.Add(cellCourseCode);
TableCell cellCourseEnName = new TableCell();
cellCourseEnName.Text = data.CourseElectiveThName + "<br>" + data.CourseElectiveEnName;
tRowBody.Cells.Add(cellCourseEnName);
TableCell cellCredit = new TableCell();
cellCredit.Text = data.Credit;
cellCredit.Width = 80;
tRowBody.Cells.Add(cellCredit);
TableCell cellFacultyCode = new TableCell();
cellFacultyCode.Text = new Faculty().getFaculty(data.FacultyCode).Faculty_Thai;
cellFacultyCode.Width = 200;
tRowBody.Cells.Add(cellFacultyCode);
TableCell cellEdit = new TableCell();
// งานหลักสูตร
if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
{
//string urlEdit = "editElective_COURSE.aspx?token=" + data.CourseElectiveCode + "&facultyId=" + data.FacultyCode + "&FacultyCreated=" + data.FacultyCode;
string urlEdit = "editElective_COURSE.aspx?token=" + data.Id;
HyperLink hypEdit = new HyperLink();
hypEdit.Attributes.Add("data-target", "#editModal");
hypEdit.Attributes.Add("data-toggle", "modal");
hypEdit.Text = "<h4><i class='fa fa-edit'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "Edit";
cellEdit.Controls.Add(hypEdit);
}
// วิชาการคณะ
//else if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
//{
// bool editable = false;
// List<string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty);
// foreach (string fac in faculty_authorized)
// {
// if (fac == data.FacultyCode)
// {
// editable = true;
// break;
// }
// }
// if (editable == true)
// {
// string urlEdit = "editElective_COURSE.aspx?token=" + data.Id;
// HyperLink hypEdit = new HyperLink();
// hypEdit.Attributes.Add("data-target", "#editModal");
// hypEdit.Attributes.Add("data-toggle", "modal");
// hypEdit.Text = "<h4><i class='fa fa-edit'></i></h4>";
// hypEdit.NavigateUrl = urlEdit;
// hypEdit.ToolTip = "Edit";
// cellEdit.Controls.Add(hypEdit);
// }
// else
// {
// string urlEdit = "#";
// HyperLink hypEdit = new HyperLink();
// hypEdit.Text = "<h4><i class='fa fa-lock'></i></h4>";
// hypEdit.NavigateUrl = urlEdit;
// hypEdit.ToolTip = "ไม่สามารถแก้ไขได้";
// cellEdit.Controls.Add(hypEdit);
// }
//}
// วิชาการภาค
else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
bool editable = false;
List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department);
foreach (string dep in department_authorized)
{
if (dep.Substring(0, 2) == data.FacultyCode)
{
editable = true;
break;
}
}
if (editable == true)
{
string urlEdit = "editElective_COURSE.aspx?token=" + data.Id;
HyperLink hypEdit = new HyperLink();
hypEdit.Attributes.Add("data-target", "#editModal");
hypEdit.Attributes.Add("data-toggle", "modal");
hypEdit.Text = "<h4><i class='fa fa-edit'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "Edit";
cellEdit.Controls.Add(hypEdit);
}
else
{
string urlEdit = "#";
HyperLink hypEdit = new HyperLink();
hypEdit.Text = "<h4><i class='fa fa-lock'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "ไม่สามารถแก้ไขได้";
cellEdit.Controls.Add(hypEdit);
}
}
// ทุกกลุ่มผู้ใช้
else
{
string urlEdit = "#";
HyperLink hypEdit = new HyperLink();
hypEdit.Text = "<h4><i class='fa fa-lock'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "ไม่สามารถแก้ไขได้";
cellEdit.Controls.Add(hypEdit);
}
cellEdit.CssClass = "text-center";
cellEdit.Width = 50;
tRowBody.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
//เช็คว่ารายวิชามีการนำไปใช้แล้วหรือยัง ถ้ามีแล้วจะไม่สามารถลบข้อมูลได้
bool chkExistCourse = new TQF2Sec3SemesterPlan().existCourse(data.Id);
// งานหลักสูตร
if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty) && chkExistCourse == false)
{
//string urlDel = "deleteElective_COURSE.aspx?token=" + data.CourseElectiveCode + "&facultyId=" + data.FacultyCode;
string urlDel = "deleteElective_COURSE.aspx?token=" + data.Id;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteModal");
hypDel.Attributes.Add("data-toggle", "modal");
hypDel.Text = "<h4><i class='fa fa-trash-o'></i></h4>";
hypDel.NavigateUrl = urlDel;
hypDel.ToolTip = "Delete";
cellDel.Controls.Add(hypDel);
}
// วิชาการคณะ
//else if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
//{
// bool editable = false;
// List<string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty);
// foreach (string fac in faculty_authorized)
// {
// if (fac == data.FacultyCode)
// {
// editable = true;
// break;
// }
// }
// if (editable == true && chkExistCourse == false)
// {
// string urlDel = "deleteElective_COURSE.aspx?token=" + data.Id;
// HyperLink hypDel = new HyperLink();
// hypDel.Attributes.Add("data-target", "#deleteModal");
// hypDel.Attributes.Add("data-toggle", "modal");
// hypDel.Text = "<h4><i class='fa fa-trash-o'></i></h4>";
// hypDel.NavigateUrl = urlDel;
// hypDel.ToolTip = "Delete";
// cellDel.Controls.Add(hypDel);
// }
// else
// {
// string urlDel = "#";
// HyperLink hypDel = new HyperLink();
// hypDel.Text = "<h4><i class='fa fa-lock'></i></h4>";
// hypDel.NavigateUrl = urlDel;
// hypDel.ToolTip = "ไม่สามารถลบได้";
// cellDel.Controls.Add(hypDel);
// }
//}
// วิชาการภาค
else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
bool editable = false;
List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department);
foreach (string dep in department_authorized)
{
if (dep.Substring(0, 2) == data.FacultyCode)
{
editable = true;
break;
}
}
if (editable == true && chkExistCourse == false)
{
string urlDel = "deleteElective_COURSE.aspx?token=" + data.Id;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteModal");
hypDel.Attributes.Add("data-toggle", "modal");
hypDel.Text = "<h4><i class='fa fa-trash-o'></i></h4>";
hypDel.NavigateUrl = urlDel;
hypDel.ToolTip = "Delete";
cellDel.Controls.Add(hypDel);
}
else
{
string urlDel = "#";
HyperLink hypDel = new HyperLink();
hypDel.Text = "<h4><i class='fa fa-lock'></i></h4>";
hypDel.NavigateUrl = urlDel;
hypDel.ToolTip = "ไม่สามารถลบได้";
cellDel.Controls.Add(hypDel);
}
}
// ทุกกลุ่มผู้ใช้
else
{
string urlDel = "#";
HyperLink hypDel = new HyperLink();
hypDel.Text = "<h4><i class='fa fa-lock'></i></h4>";
hypDel.NavigateUrl = urlDel;
hypDel.ToolTip = "ไม่สามารถลบได้";
cellDel.Controls.Add(hypDel);
}
cellDel.CssClass = "text-center";
cellDel.Width = 50;
tRowBody.Cells.Add(cellDel);
tblElective.Rows.Add(tRowBody);
}
}
//=============================
}
}
