/// <summary> /// แก้ไขข้อมูลจากตาราง TQF2Sec4CurriculumMapping /// </summary> /// <param name="updateData">TQF2Sec4CurriculumMappingCategory Object</param> /// <returns>Success</returns> public string updateTQF2Sec4CurriculumMapping(TQF2Sec4CurriculumMapping updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Update TQF2SEC4CURRICULUMMAPPING Set RESPONSESTATUS = '" + updateData.ResponseStatus + "'Where CURRCODE = '" + updateData.CurrCode + "' And COURSECODE = '" + updateData.CourseCode + "' And DOMAINTYPECODE = '" + updateData.DomainTypeCode + "' And T2S4SUB1NO = '" + updateData.T2S4Sub1No + "' And YEARVERSION = '" + updateData.YearVersion + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateTQF2Sec4CurriculumMapping: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// เพิ่มข้อมูลลงตาราง TQF2SEC4CURRICULUMMAPPING /// </summary> /// <param name="dataInsert">TQF2Sec4CurriculumMapping Object</param> /// <returns>Success</returns> public string insertTQF2Sec4CurriculumMapping(TQF2Sec4CurriculumMapping dataInsert) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Insert into TQF2SEC4CURRICULUMMAPPING (CURRCODE,COURSECODE,DOMAINTYPECODE,T2S4SUB1NO,RESPONSESTATUS,YEARVERSION) values ('" + dataInsert.CurrCode + "','" + dataInsert.CourseCode + "','" + dataInsert.DomainTypeCode + "','" + dataInsert.T2S4Sub1No + "','" + dataInsert.ResponseStatus + "','" + dataInsert.YearVersion + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "insertTQF2Sec4CurriculumMapping: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// เรียกดูข้อมูลจากตาราง TQF2SEC4CURRICULUMMAPPING /// </summary> /// <param name="sql">SQL Command</param> /// <returns>ข้อมูลจากตาราง TQF2SEC4CURRICULUMMAPPING</returns> public List <TQF2Sec4CurriculumMapping> getTQF2Sec4CurriculumMappingManual(string sql) { List <TQF2Sec4CurriculumMapping> TQF2Sec4CurriculumMappingData = new List <TQF2Sec4CurriculumMapping>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { TQF2Sec4CurriculumMapping TQF2Sec4CurriculumMappingRow = new TQF2Sec4CurriculumMapping(); TQF2Sec4CurriculumMappingRow.CurrCode = rowData["CURRCODE"].ToString(); TQF2Sec4CurriculumMappingRow.CourseCode = rowData["COURSECODE"].ToString(); TQF2Sec4CurriculumMappingRow.DomainTypeCode = rowData["DOMAINTYPECODE"].ToString(); TQF2Sec4CurriculumMappingRow.T2S4Sub1No = rowData["T2S4SUB1NO"].ToString(); TQF2Sec4CurriculumMappingRow.ResponseStatus = rowData["RESPONSESTATUS"].ToString(); TQF2Sec4CurriculumMappingRow.YearVersion = rowData["YEARVERSION"].ToString(); TQF2Sec4CurriculumMappingData.Add(TQF2Sec4CurriculumMappingRow); } return(TQF2Sec4CurriculumMappingData); }
/// <summary> /// เรียกดูข้อมูลจากตาราง TQF2SEC4CURRICULUMMAPPING /// </summary> /// <param name="CurrCode">รหัสหลักสูตร(Curriculum)</param> /// <param name="CourseCode">รหัสวิชา(Course)</param> /// <param name="YearVersion">รหัสเวอร์ชั่นหลักสูตร(Curriculum)</param> /// <returns></returns> public List <TQF2Sec4CurriculumMapping> getTQF2Sec4CurriculumMapping(string CurrCode, string CourseCode, string DomainTypeCode, string YearVersion) { List <TQF2Sec4CurriculumMapping> TQF2Sec4CurriculumMappingData = new List <TQF2Sec4CurriculumMapping>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = "Select * From TQF2SEC4CURRICULUMMAPPING Where CURRCODE='" + CurrCode + "' And COURSECODE='" + CourseCode + "' And DOMAINTYPECODE='" + DomainTypeCode + "' And YEARVERSION='" + YearVersion + "'"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { TQF2Sec4CurriculumMapping TQF2Sec4CurriculumMappingRow = new TQF2Sec4CurriculumMapping(); TQF2Sec4CurriculumMappingRow.CurrCode = rowData["CURRCODE"].ToString(); TQF2Sec4CurriculumMappingRow.CourseCode = rowData["COURSECODE"].ToString(); TQF2Sec4CurriculumMappingRow.DomainTypeCode = rowData["DOMAINTYPECODE"].ToString(); TQF2Sec4CurriculumMappingRow.T2S4Sub1No = rowData["T2S4SUB1NO"].ToString(); TQF2Sec4CurriculumMappingRow.ResponseStatus = rowData["RESPONSESTATUS"].ToString(); TQF2Sec4CurriculumMappingRow.YearVersion = rowData["YEARVERSION"].ToString(); TQF2Sec4CurriculumMappingData.Add(TQF2Sec4CurriculumMappingRow); } return(TQF2Sec4CurriculumMappingData); }
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 tableBody(Table tblName, string CurrCode, string DomainTypeCode) { tblName.Attributes.Add("class", "table table-striped"); //DETAILTYPE (1 = ผลการเรียน, 2 = กลยุทธ์การสอน, 3 = กลยุทธ์การประเมิน) string sql = "Select * From TQF2SEC4SUB1 Where CURRCODE='" + CurrCode + "' And DOMAINTYPECODE='" + DomainTypeCode + "' And DETAILTYPE='1' And YEARVERSION='" + YearVersion + "'"; List <TQF2Sec4Sub1> tqf2Sec4Sub1 = new TQF2Sec4Sub1().getTQF2Sec4Sub1Manual(sql); int No = 1; foreach (TQF2Sec4Sub1 row in tqf2Sec4Sub1) { TableRow tRowDetail = new TableRow(); tRowDetail.TableSection = TableRowSection.TableBody; TableCell cellDetail = new TableCell(); cellDetail.Text = No.ToString() + ". " + row.Detail; cellDetail.ColumnSpan = 4; tRowDetail.Cells.Add(cellDetail); tblName.Rows.Add(tRowDetail); TableRow tRowRadio = new TableRow(); tRowRadio.TableSection = TableRowSection.TableBody; TQF2Sec4CurriculumMapping chk = new TQF2Sec4CurriculumMapping().getTQF2Sec4CurriculumMapping(CurrCode, CourseCode, DomainTypeCode, row.T2S4Sub1No, YearVersion); //Cell [0-2] for (int j = 0; j < 3; j++) { TableCell cellChoice = new TableCell(); RadioButton radio = new RadioButton(); radio.ID = row.T2S4Sub1No + j.ToString(); radio.GroupName = DomainTypeCode + No; if (j == 1) { radio.Text = "<span><i class=\"fa fa-fw fa-circle\"></i>ความรับผิดชอบหลัก</span>"; } if (j == 2) { radio.Text = "<span><i class=\"fa fa-fw fa-circle-o\"></i>ความรับผิดชอบรอง</span>"; } if (j == 0) { radio.Text = "<span class=\"txt-red\"><i class=\"fa fa-fw fa-times\"></i></span>ไม่มี"; } if (chk.ResponseStatus == j.ToString()) { radio.Checked = true; } cellChoice.Controls.Add(radio); tRowRadio.Cells.Add(cellChoice); } //Cell [3] //เก็บ Id ไปใช้ในตาราง TQF2SEC4CURRICULUMMAPPING TableCell cellT2S4Sub1No = new TableCell(); cellT2S4Sub1No.Text = row.T2S4Sub1No; cellT2S4Sub1No.Visible = false; tRowRadio.Cells.Add(cellT2S4Sub1No); tblName.Rows.Add(tRowRadio); No++; } }
protected void btnSAVE_Click(object sender, EventArgs e) { int totalRow = 0; int checkRow = 0; foreach (TableRow row in tblDomain.Rows) { int rowIndex = tblDomain.Rows.GetRowIndex(row); if (rowIndex % 2 == 1) { totalRow++; int cellNo = row.Cells.Count; for (int i = 0; i < cellNo - 1; i++) { var cell = row.Cells[i]; foreach (Control control in cell.Controls) { var radioBox = control as RadioButton; if (radioBox != null) { if (radioBox.Checked) { checkRow++; TQF2Sec4CurriculumMapping tqf2Sec4CurriculumMappingData = new TQF2Sec4CurriculumMapping(); tqf2Sec4CurriculumMappingData.CurrCode = CurrCode; tqf2Sec4CurriculumMappingData.CourseCode = CourseCode; tqf2Sec4CurriculumMappingData.DomainTypeCode = DomainTypeCode; tqf2Sec4CurriculumMappingData.ResponseStatus = i.ToString(); tqf2Sec4CurriculumMappingData.YearVersion = YearVersion; tqf2Sec4CurriculumMappingData.T2S4Sub1No = row.Cells[3].Text; //ตรวจสอบว่ามีการบันทึกแล้วหรือยัง string sql = "Select * From TQF2SEC4CURRICULUMMAPPING Where CURRCODE='" + CurrCode + "' And COURSECODE='" + CourseCode + "' And DOMAINTYPECODE='" + DomainTypeCode + "' And YEARVERSION='" + YearVersion + "' And T2S4SUB1NO='" + row.Cells[3].Text + "'"; List <TQF2Sec4CurriculumMapping> chk = new TQF2Sec4CurriculumMapping().getTQF2Sec4CurriculumMappingManual(sql); int numRow = chk.Count; if (numRow > 0) { //Update string updateData = new TQF2Sec4CurriculumMapping().updateTQF2Sec4CurriculumMapping(tqf2Sec4CurriculumMappingData); } else { //Insert string insertDate = new TQF2Sec4CurriculumMapping().insertTQF2Sec4CurriculumMapping(tqf2Sec4CurriculumMappingData); } } } } } } } if (totalRow != checkRow) { Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowBox", "alert('เลือกข้อมูลไม่ครบ!');", true); } else { //สร้าง session ส่งคืนกลับไปหน้า Faculty_add_CURR7.aspx Session["CurrCode"] = CurrCode; Session["YearVersion"] = YearVersion; //Session["MajorCode"] = MajorCode; Response.Redirect("Faculty_add_CURR7.aspx"); } }
//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 tableBody(Table tblName) { List <TQF2Sec3PlanDetail> tqf2Sec3PlanDetail = new TQF2Sec3PlanDetail().getDistinctCourseCodeTQF2Sec3PlanDetail(CurrCode, YearVersion); foreach (TQF2Sec3PlanDetail row in tqf2Sec3PlanDetail) { TQF.Course course = new TQF.Course().getCourse(row.CourseCode); CourseElective courseElective = new CourseElective().getCourseElectiveId(row.CourseCode); TQF2Sec3PlanDetail rowCourseCode = new TQF2Sec3PlanDetail().getTQF2Sec3PlanDetailCourseCode(row.CourseCode); string sql = "Select * From TQF2SEC3PLANDETAIL Where CURRCODE='999999999' And COURSECODE='" + row.CourseCode + "'"; List <TQF2Sec3PlanDetail> tqf2Sec3PlanDetail2 = new TQF2Sec3PlanDetail().getTQF2Sec3PlanDetailManual(sql); //ถ้าเป็นรายวิชาในหลักสูตรบริการให้ข้าม if (tqf2Sec3PlanDetail2.Count > 0 && rowCourseCode.CurrCode != "999999999") { continue; } //ถ้าเป็นรายวิชาเลือก (วิชา xxx) ให้ข้าม else if (row.CourseCode == courseElective.Id) { continue; } else { TableRow tRowBody = new TableRow(); tRowBody.TableSection = TableRowSection.TableBody; //Cell [0] TableCell cellCourseCode = new TableCell(); //string urlShow = "showCOURSE.aspx?token=" + course.CourseCode; string urlShow = "showCOURSE.aspx?token=" + course.CourseCode + "&CurrCode=" + CurrCode + "&YearVersion=" + YearVersion; HyperLink hypShow = new HyperLink(); hypShow.Attributes.Add("data-target", "#showModal"); hypShow.Attributes.Add("data-toggle", "modal"); hypShow.Text = course.CourseCode + " " + course.CourseThName + "<BR>" + course.CourseEnName; hypShow.Text = course.CourseThName + courseElective.CourseElectiveThName + "<BR>"; hypShow.Text += course.CourseEnName + courseElective.CourseElectiveEnName; hypShow.NavigateUrl = urlShow; hypShow.ToolTip = "Course details"; cellCourseCode.Controls.Add(hypShow); //cellCourseCode.CssClass = "text-center"; cellCourseCode.Width = 200; tRowBody.Cells.Add(cellCourseCode); TableCell cellDomain1 = new TableCell(); string urlDomain1 = "edit_Curri_Mapping.aspx?CurrCode=" + rowCourseCode.CurrCode + "&CourseCode=" + row.CourseCode + "&DomainTypeCode=1&YearVersion=" + rowCourseCode.YearVersion + ""; HyperLink hypDomain1 = new HyperLink(); hypDomain1.Attributes.Add("data-target", "#editDomain_Modal"); hypDomain1.Attributes.Add("data-toggle", "modal"); List <TQF2Sec4CurriculumMapping> chk1 = new TQF2Sec4CurriculumMapping().getTQF2Sec4CurriculumMapping(rowCourseCode.CurrCode, row.CourseCode, "1", rowCourseCode.YearVersion); if (chk1.Count == 0) { hypDomain1.Text = "<div class=\"btn btn-primary padding-5\"><i class=\"fa fa-edit\"></i> Edit</div> "; } else { hypDomain1.Text = "<div class=\"btn btn-success padding-5\"><i class=\"fa fa-check-square-o\"></i> Edited</div> "; } hypDomain1.NavigateUrl = urlDomain1; hypDomain1.ToolTip = "Click to edit"; cellDomain1.Controls.Add(hypDomain1); cellDomain1.CssClass = "text-center"; cellDomain1.Width = 100; tRowBody.Cells.Add(cellDomain1); //Cell [1] TableCell cellDomain2 = new TableCell(); string urlDomain2 = "edit_Curri_Mapping.aspx?CurrCode=" + rowCourseCode.CurrCode + "&CourseCode=" + row.CourseCode + "&DomainTypeCode=2&YearVersion=" + rowCourseCode.YearVersion + ""; HyperLink hypDomain2 = new HyperLink(); hypDomain2.Attributes.Add("data-target", "#editDomain_Modal"); hypDomain2.Attributes.Add("data-toggle", "modal"); List <TQF2Sec4CurriculumMapping> chk2 = new TQF2Sec4CurriculumMapping().getTQF2Sec4CurriculumMapping(rowCourseCode.CurrCode, row.CourseCode, "2", rowCourseCode.YearVersion); if (chk2.Count == 0) { hypDomain2.Text = "<div class=\"btn btn-primary padding-5\"><i class=\"fa fa-edit\"></i> Edit</div> "; } else { hypDomain2.Text = "<div class=\"btn btn-success padding-5\"><i class=\"fa fa-check-square-o\"></i> Edited</div> "; } hypDomain2.NavigateUrl = urlDomain2; hypDomain2.ToolTip = "Click to edit"; cellDomain2.Controls.Add(hypDomain2); cellDomain2.CssClass = "text-center"; cellDomain2.Width = 100; tRowBody.Cells.Add(cellDomain2); //Cell [2] TableCell cellDomain3 = new TableCell(); string urlDomain3 = "edit_Curri_Mapping.aspx?CurrCode=" + rowCourseCode.CurrCode + "&CourseCode=" + row.CourseCode + "&DomainTypeCode=3&YearVersion=" + rowCourseCode.YearVersion + ""; HyperLink hypDomain3 = new HyperLink(); hypDomain3.Attributes.Add("data-target", "#editDomain_Modal"); hypDomain3.Attributes.Add("data-toggle", "modal"); List <TQF2Sec4CurriculumMapping> chk3 = new TQF2Sec4CurriculumMapping().getTQF2Sec4CurriculumMapping(rowCourseCode.CurrCode, row.CourseCode, "3", rowCourseCode.YearVersion); if (chk3.Count == 0) { hypDomain3.Text = "<div class=\"btn btn-primary padding-5\"><i class=\"fa fa-edit\"></i> Edit</div> "; } else { hypDomain3.Text = "<div class=\"btn btn-success padding-5\"><i class=\"fa fa-check-square-o\"></i> Edited</div> "; } hypDomain3.NavigateUrl = urlDomain3; hypDomain3.ToolTip = "Click to edit"; cellDomain3.Controls.Add(hypDomain3); cellDomain3.CssClass = "text-center"; cellDomain3.Width = 100; tRowBody.Cells.Add(cellDomain3); //Cell [3] TableCell cellDomain4 = new TableCell(); string urlDomain4 = "edit_Curri_Mapping.aspx?CurrCode=" + rowCourseCode.CurrCode + "&CourseCode=" + rowCourseCode.CourseCode + "&DomainTypeCode=4&YearVersion=" + rowCourseCode.YearVersion + ""; HyperLink hypDomain4 = new HyperLink(); hypDomain4.Attributes.Add("data-target", "#editDomain_Modal"); hypDomain4.Attributes.Add("data-toggle", "modal"); List <TQF2Sec4CurriculumMapping> chk4 = new TQF2Sec4CurriculumMapping().getTQF2Sec4CurriculumMapping(rowCourseCode.CurrCode, row.CourseCode, "4", rowCourseCode.YearVersion); if (chk4.Count == 0) { hypDomain4.Text = "<div class=\"btn btn-primary padding-5\"><i class=\"fa fa-edit\"></i> Edit</div> "; } else { hypDomain4.Text = "<div class=\"btn btn-success padding-5\"><i class=\"fa fa-check-square-o\"></i> Edited</div> "; } hypDomain4.NavigateUrl = urlDomain4; hypDomain4.ToolTip = "Click to edit"; cellDomain4.Controls.Add(hypDomain4); cellDomain4.CssClass = "text-center"; cellDomain4.Width = 100; tRowBody.Cells.Add(cellDomain4); //Cell [4] TableCell cellDomain5 = new TableCell(); string urlDomain5 = "edit_Curri_Mapping.aspx?CurrCode=" + rowCourseCode.CurrCode + "&CourseCode=" + row.CourseCode + "&DomainTypeCode=5&YearVersion=" + rowCourseCode.YearVersion + ""; HyperLink hypDomain5 = new HyperLink(); hypDomain5.Attributes.Add("data-target", "#editDomain_Modal"); hypDomain5.Attributes.Add("data-toggle", "modal"); List <TQF2Sec4CurriculumMapping> chk5 = new TQF2Sec4CurriculumMapping().getTQF2Sec4CurriculumMapping(rowCourseCode.CurrCode, row.CourseCode, "5", rowCourseCode.YearVersion); if (chk5.Count == 0) { hypDomain5.Text = "<div class=\"btn btn-primary padding-5\"><i class=\"fa fa-edit\"></i> Edit</div> "; } else { hypDomain5.Text = "<div class=\"btn btn-success padding-5\"><i class=\"fa fa-check-square-o\"></i> Edited</div> "; } hypDomain5.NavigateUrl = urlDomain5; hypDomain5.ToolTip = "Click to edit"; cellDomain5.Controls.Add(hypDomain5); cellDomain5.CssClass = "text-center"; cellDomain5.Width = 100; tRowBody.Cells.Add(cellDomain5); //Cell [5] TableCell cellDomain6 = new TableCell(); string urlDomain6 = "edit_Curri_Mapping.aspx?CurrCode=" + rowCourseCode.CurrCode + "&CourseCode=" + row.CourseCode + "&DomainTypeCode=6&YearVersion=" + rowCourseCode.YearVersion + ""; HyperLink hypDomain6 = new HyperLink(); hypDomain6.Attributes.Add("data-target", "#editDomain_Modal"); hypDomain6.Attributes.Add("data-toggle", "modal"); List <TQF2Sec4CurriculumMapping> chk6 = new TQF2Sec4CurriculumMapping().getTQF2Sec4CurriculumMapping(rowCourseCode.CurrCode, row.CourseCode, "6", rowCourseCode.YearVersion); if (chk6.Count == 0) { hypDomain6.Text = "<div class=\"btn btn-primary padding-5\"><i class=\"fa fa-edit\"></i> Edit</div> "; } else { hypDomain6.Text = "<div class=\"btn btn-success padding-5\"><i class=\"fa fa-check-square-o\"></i> Edited</div> "; } hypDomain6.NavigateUrl = urlDomain6; hypDomain6.ToolTip = "Click to edit"; cellDomain6.Controls.Add(hypDomain6); cellDomain6.CssClass = "text-center"; cellDomain6.Width = 100; tRowBody.Cells.Add(cellDomain6); tblName.Rows.Add(tRowBody); } } }