/// <summary>
/// แก้ไขข้อมูลจากตาราง TQF1LEANING
/// </summary>
/// <param name="updateData">TQF1Leaning Object</param>
/// <returns>Success</returns>
public string updateTQF1Leaning(TQF1Leaning updateData)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
string sql = "Update TQF1LEANING Set NUMTQF1LEANING = '" + updateData.NUMTQF1Leaning + "', DOMAINTYPECODE = '" + updateData.DomainTypeCode + "', NUMTQF1 = '" + updateData.NUMTQF1 + "', DETAILTYPE = '" + updateData.Detailtype + "' Where UUIDNUMBER = '" + updateData.UUIDNumber + "'";
oracleObj.UpdateCommand = sql;
try
{
if (oracleObj.Update() == 1)
{
response = "Success";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "updateTQF1Leaning: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
/// <summary>
/// เพิ่มข้อมูลลงตาราง TQF1LEANING
/// </summary>
/// <param name="dataInsert"></param>
/// <returns></returns>
public string insertTQF1Leaning(TQF1Leaning dataInsert)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
string sql = "Insert into TQF1LEANING (NUMTQF1LEANING, DOMAINTYPECODE, NUMTQF1, DETAILTYPE, UUIDNUMBER) values ('" + dataInsert.NUMTQF1Leaning + "','" + dataInsert.DomainTypeCode + "','" + dataInsert.NUMTQF1 + "','" + dataInsert.Detailtype + "','" + dataInsert.UUIDNumber + "')";
oracleObj.InsertCommand = sql;
try
{
if (oracleObj.Insert() == 1)
{
response = "Success";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "insertTQF1Leaning: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
/// <summary>
/// เรียกดูข้อมูลจากตาราง TQF1LEANING
/// </summary>
/// <param name="sql">SQL Command</param>
/// <returns>ข้อมูลจากตาราง TQF1LEANING</returns>
public List <TQF1Leaning> getTQF1LeaningManual(string sql)
{
List <TQF1Leaning> TQF1LeaningData = new List <TQF1Leaning>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
TQF1Leaning TQF1LeaningRow = new TQF1Leaning();
TQF1LeaningRow.NUMTQF1Leaning = rowData["NUMTQF1LEANING"].ToString();
TQF1LeaningRow.DomainTypeCode = rowData["DOMAINTYPECODE"].ToString();
TQF1LeaningRow.NUMTQF1 = rowData["NUMTQF1"].ToString();
TQF1LeaningRow.Detailtype = rowData["DETAILTYPE"].ToString();
TQF1LeaningRow.UUIDNumber = rowData["UUIDNUMBER"].ToString();
TQF1LeaningData.Add(TQF1LeaningRow);
}
return(TQF1LeaningData);
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
//ลบข้อมูล Learning Outcome ออกจากตาราง TQF1LEANING
string sql = "Delete From TQF1LEANING Where NUMTQF1 ='" + NumTQF1 + "'";
string deleteTQF1LEANING = new TQF1Leaning().deleteTQF1LeaningManual(sql);
//เช็คค่่าก่อนลบข้อมูลจากตาราง
string sql2 = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "'";
List <TQF1Leaning> getNum = new TQF1Leaning().getTQF1LeaningManual(sql2);
if (deleteTQF1LEANING == "Success" || getNum.Count == 0)
{
//ลบไฟล์ มคอ.1 ออกจาก server
string FileName = new TQF1().getTQF1(NumTQF1).FileName;
string FolderPath = ConfigurationManager.AppSettings["TQF1UploadFolder"];
string FilePath = Server.MapPath(FolderPath + FileName);
string fileName = FilePath;
if (fileName != null || fileName != string.Empty)
{
if ((System.IO.File.Exists(FolderPath + fileName)))
{
System.IO.File.Delete(FolderPath + fileName);
}
}
//ลบข้อมูล ออกจากตาราง TQF1
string result = new TQF1().deleteTQF1(NumTQF1);
if (result == "Success")
{
Response.Redirect("list_TQF1.aspx?path=" + fileName);
}
else
{
Response.Redirect("list_TQF1.aspx?path=" + fileName);
}
}
else
{
Response.Redirect("list_TQF1.aspx");
}
}
catch
{
Response.Redirect("list_TQF1.aspx");
}
}
/// <summary>
/// เรียกดูข้อมูลจากตาราง TQF1LEANING
/// </summary>
/// <param name="NUMTQF1Leaning">เลข Primary key ของตาราง</param>
/// <returns>ข้อมูลจากตาราง TQF1LEANING</returns>
public TQF1Leaning getTQF1Leaning(string NUMTQF1Leaning)
{
TQF1Leaning TQF1LeaningData = new TQF1Leaning();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
oracleObj.SelectCommand = "Select * From TQF1LEANING Where NUMTQF1LEANING='" + NUMTQF1Leaning + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
TQF1LeaningData.NUMTQF1Leaning = rowData["NUMTQF1LEANING"].ToString();
TQF1LeaningData.DomainTypeCode = rowData["DOMAINTYPECODE"].ToString();
TQF1LeaningData.NUMTQF1 = rowData["NUMTQF1"].ToString();
TQF1LeaningData.Detailtype = rowData["DETAILTYPE"].ToString();
TQF1LeaningData.UUIDNumber = rowData["UUIDNUMBER"].ToString();
}
return(TQF1LeaningData);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (tblType1.Rows.Count > 1)
{
int tblType1Rows;
foreach (TableRow item in tblType1.Rows)
{
tblType1Rows = tblType1.Rows.GetRowIndex(item);
if (tblType1Rows >= 1)
{
TQF1Leaning dataInsert = new TQF1Leaning();
dataInsert.NUMTQF1Leaning = new TQF.TQFUtility().getMaxID("NUMTQF1LEANING", "TQF1LEANING");
dataInsert.DomainTypeCode = int.Parse("1").ToString();
dataInsert.NUMTQF1 = NumTQF1;
dataInsert.Detailtype = tblType1.Rows[tblType1Rows].Cells[1].Text;
dataInsert.UUIDNumber = tblType1.Rows[tblType1Rows].Cells[0].Text;
//เช็คค่่าก่อนเก็บข้อมูลลงตาราง ถ้าเป็น 0 Insert ถ้าไม่ใช่ 0 ให้ Update
string sql = "Select * From TQF1LEANING Where UUIDNUMBER='" + tblType1.Rows[tblType1Rows].Cells[0].Text + "'";
List <TQF1Leaning> getNum = new TQF1Leaning().getTQF1LeaningManual(sql);
if (getNum.Count == 0)
{
string dataSave = new TQF1Leaning().insertTQF1Leaning(dataInsert);
}
else
{
string dataUpdate = new TQF1Leaning().updateTQF1Leaning(dataInsert);
}
}
else
{
continue;
}
}
}
if (tblType2.Rows.Count > 1)
{
int tblType2Rows;
foreach (TableRow item in tblType2.Rows)
{
tblType2Rows = tblType2.Rows.GetRowIndex(item);
if (tblType2Rows >= 1)
{
TQF1Leaning dataInsert = new TQF1Leaning();
dataInsert.NUMTQF1Leaning = new TQF.TQFUtility().getMaxID("NUMTQF1LEANING", "TQF1LEANING");
dataInsert.DomainTypeCode = int.Parse("2").ToString();
dataInsert.NUMTQF1 = NumTQF1;
dataInsert.Detailtype = tblType2.Rows[tblType2Rows].Cells[1].Text;
dataInsert.UUIDNumber = tblType2.Rows[tblType2Rows].Cells[0].Text;
//เช็คค่่าก่อนเก็บข้อมูลลงตาราง ถ้าเป็น 0 Insert ถ้าไม่ใช่ 0 ให้ Update
string sql = "Select * From TQF1LEANING Where UUIDNUMBER='" + tblType2.Rows[tblType2Rows].Cells[0].Text + "'";
List <TQF1Leaning> getNum = new TQF1Leaning().getTQF1LeaningManual(sql);
if (getNum.Count == 0)
{
string dataSave = new TQF1Leaning().insertTQF1Leaning(dataInsert);
}
else
{
string dataUpdate = new TQF1Leaning().updateTQF1Leaning(dataInsert);
}
}
else
{
continue;
}
}
}
if (tblType3.Rows.Count > 1)
{
int tblType3Rows;
foreach (TableRow item in tblType3.Rows)
{
tblType3Rows = tblType3.Rows.GetRowIndex(item);
if (tblType3Rows >= 1)
{
TQF1Leaning dataInsert = new TQF1Leaning();
dataInsert.NUMTQF1Leaning = new TQF.TQFUtility().getMaxID("NUMTQF1LEANING", "TQF1LEANING");
dataInsert.DomainTypeCode = int.Parse("3").ToString();
dataInsert.NUMTQF1 = NumTQF1;
dataInsert.Detailtype = tblType3.Rows[tblType3Rows].Cells[1].Text;
dataInsert.UUIDNumber = tblType3.Rows[tblType3Rows].Cells[0].Text;
//เช็คค่่าก่อนเก็บข้อมูลลงตาราง ถ้าเป็น 0 Insert ถ้าไม่ใช่ 0 ให้ Update
string sql = "Select * From TQF1LEANING Where UUIDNUMBER='" + tblType3.Rows[tblType3Rows].Cells[0].Text + "'";
List <TQF1Leaning> getNum = new TQF1Leaning().getTQF1LeaningManual(sql);
if (getNum.Count == 0)
{
string dataSave = new TQF1Leaning().insertTQF1Leaning(dataInsert);
}
else
{
string dataUpdate = new TQF1Leaning().updateTQF1Leaning(dataInsert);
}
}
else
{
continue;
}
}
}
if (tblType4.Rows.Count > 1)
{
int tblType4Rows;
foreach (TableRow item in tblType4.Rows)
{
tblType4Rows = tblType4.Rows.GetRowIndex(item);
if (tblType4Rows >= 1)
{
TQF1Leaning dataInsert = new TQF1Leaning();
dataInsert.NUMTQF1Leaning = new TQF.TQFUtility().getMaxID("NUMTQF1LEANING", "TQF1LEANING");
dataInsert.DomainTypeCode = int.Parse("4").ToString();
dataInsert.NUMTQF1 = NumTQF1;
dataInsert.Detailtype = tblType4.Rows[tblType4Rows].Cells[1].Text;
dataInsert.UUIDNumber = tblType4.Rows[tblType4Rows].Cells[0].Text;
//เช็คค่่าก่อนเก็บข้อมูลลงตาราง ถ้าเป็น 0 Insert ถ้าไม่ใช่ 0 ให้ Update
string sql = "Select * From TQF1LEANING Where UUIDNUMBER='" + tblType4.Rows[tblType4Rows].Cells[0].Text + "'";
List <TQF1Leaning> getNum = new TQF1Leaning().getTQF1LeaningManual(sql);
if (getNum.Count == 0)
{
string dataSave = new TQF1Leaning().insertTQF1Leaning(dataInsert);
}
else
{
string dataUpdate = new TQF1Leaning().updateTQF1Leaning(dataInsert);
}
}
else
{
continue;
}
}
}
if (tblType5.Rows.Count > 1)
{
int tblType5Rows;
foreach (TableRow item in tblType5.Rows)
{
tblType5Rows = tblType5.Rows.GetRowIndex(item);
if (tblType5Rows >= 1)
{
TQF1Leaning dataInsert = new TQF1Leaning();
dataInsert.NUMTQF1Leaning = new TQF.TQFUtility().getMaxID("NUMTQF1LEANING", "TQF1LEANING");
dataInsert.DomainTypeCode = int.Parse("5").ToString();
dataInsert.NUMTQF1 = NumTQF1;
dataInsert.Detailtype = tblType5.Rows[tblType5Rows].Cells[1].Text;
dataInsert.UUIDNumber = tblType5.Rows[tblType5Rows].Cells[0].Text;
//เช็คค่่าก่อนเก็บข้อมูลลงตาราง ถ้าเป็น 0 Insert ถ้าไม่ใช่ 0 ให้ Update
string sql = "Select * From TQF1LEANING Where UUIDNUMBER='" + tblType5.Rows[tblType5Rows].Cells[0].Text + "'";
List <TQF1Leaning> getNum = new TQF1Leaning().getTQF1LeaningManual(sql);
if (getNum.Count == 0)
{
string dataSave = new TQF1Leaning().insertTQF1Leaning(dataInsert);
}
else
{
string dataUpdate = new TQF1Leaning().updateTQF1Leaning(dataInsert);
}
}
else
{
continue;
}
}
}
if (tblType6.Rows.Count > 1)
{
int tblType6Rows;
foreach (TableRow item in tblType6.Rows)
{
tblType6Rows = tblType6.Rows.GetRowIndex(item);
if (tblType6Rows >= 1)
{
TQF1Leaning dataInsert = new TQF1Leaning();
dataInsert.NUMTQF1Leaning = new TQF.TQFUtility().getMaxID("NUMTQF1LEANING", "TQF1LEANING");
dataInsert.DomainTypeCode = int.Parse("6").ToString();
dataInsert.NUMTQF1 = NumTQF1;
dataInsert.Detailtype = tblType6.Rows[tblType6Rows].Cells[1].Text;
dataInsert.UUIDNumber = tblType6.Rows[tblType6Rows].Cells[0].Text;
//เช็คค่่าก่อนเก็บข้อมูลลงตาราง ถ้าเป็น 0 Insert ถ้าไม่ใช่ 0 ให้ Update
string sql = "Select * From TQF1LEANING Where UUIDNUMBER='" + tblType6.Rows[tblType6Rows].Cells[0].Text + "'";
List <TQF1Leaning> getNum = new TQF1Leaning().getTQF1LeaningManual(sql);
if (getNum.Count == 0)
{
string dataSave = new TQF1Leaning().insertTQF1Leaning(dataInsert);
}
else
{
string dataUpdate = new TQF1Leaning().updateTQF1Leaning(dataInsert);
}
}
else
{
continue;
}
}
}
//ล้าง session แล้วกลับไปหน้าค้นหา มคอ.1
Session.Remove("NumTQF1");
Session.Remove("addType1");
Session.Remove("addType2");
Session.Remove("addType3");
Session.Remove("addType4");
Session.Remove("addType5");
Session.Remove("addType6");
Response.Redirect("list_TQF1.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
NumTQF1 = Request.QueryString["token"];
Session["NumTQF1"] = Request.QueryString["token"];
this.DataBind();
if (!Page.IsPostBack)
{
try
{
List <TQF.Levels> levelData = new TQF.Levels().getLevels();
ddlDegree.Items.Clear();
foreach (TQF.Levels row in levelData)
{
ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode));
}
TQF1 tqf1Data = new TQF1().getTQF1(NumTQF1);
ddlDegree.Items.FindByValue(tqf1Data.LevelCode).Selected = true;
txtMajor.Text = tqf1Data.TQF1Major;
txtACADEMIC_YEAR.Text = tqf1Data.Year;
}
catch
{
Session["response"] = "ข้อมูลผิดพลาด ไม่สามารถใช้งานได้ในขณะนี้";
Response.Redirect("../err_response.aspx");
}
}
////// tblType1 //////
// Head Table
//string[] ar = { "ข้อที่", "รายละเอียด", "แก้ไข", "ลบ" };
tblType1.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblType1.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead = new TableHeaderRow();
tRowHead.TableSection = TableRowSection.TableHeader;
// Create a new cell and add it to the row.
TableHeaderCell cellHead1 = new TableHeaderCell();
cellHead1.Text = "ข้อที่";
cellHead1.Attributes.Add("class", "text-center");
cellHead1.Width = 50;
tRowHead.Cells.Add(cellHead1);
TableHeaderCell cellHead2 = new TableHeaderCell();
cellHead2.Text = "รายละเอียด";
tRowHead.Cells.Add(cellHead2);
TableHeaderCell cellHead3 = new TableHeaderCell();
cellHead3.Text = "แก้ไข";
cellHead3.Attributes.Add("class", "text-center");
cellHead3.Width = 50;
tRowHead.Cells.Add(cellHead3);
TableHeaderCell cellHead4 = new TableHeaderCell();
cellHead4.Text = "ลบ";
cellHead4.Attributes.Add("class", "text-center");
cellHead4.Width = 50;
tRowHead.Cells.Add(cellHead4);
tRowHead.Cells[0].Visible = false; //Hidden Cells[0] for UUID..
tblType1.Rows.Add(tRowHead);
//End Head Table
if (Session["addType1"] != null)
{
listTableRow1 = new List <TableRow>();
listTableRow1 = (List <TableRow>)Session["addType1"];
int i;
foreach (TableRow item in listTableRow1)
{
tblType1.Rows.Add(item);
i = tblType1.Rows.GetRowIndex(item);
tblType1.Rows[i].Cells[0].Visible = false;
}
}
else
{
//เรียกข้อมูลจากฐานข้อมูลเวลาที่คลิกแก้ไข จากหน้า list_TQF1.aspx
//สร้าง session เอาไว้เก็บแถว
List <TableRow> dummyRow = new List <TableRow>();
Session["addType1"] = (List <TableRow>)dummyRow;
//1. ด้านคุณธรรม จริยธรรม
string sql = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "' And DOMAINTYPECODE='1'";
List <TQF1Leaning> tqf1LearningData = new TQF1Leaning().getTQF1LeaningManual(sql);
int i;
int numOfrow = 0;
foreach (TQF1Leaning data in tqf1LearningData)
{
TableRow row = new TableRow();
TableCell cellNumber = new TableCell();
cellNumber.Text = data.UUIDNumber;
row.Cells.Add(cellNumber);
numOfrow++;
TableCell cellDetail = new TableCell();
//cellDetail.Text = "(" + numOfrow + ")\t" + data.Detailtype;
cellDetail.Text = data.Detailtype;
row.Cells.Add(cellDetail);
TableCell cellEdit = new TableCell();
string urlEdit = "edit_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypEdit = new HyperLink();
hypEdit.Attributes.Add("data-target", "#editLEARNING_OUT");
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);
cellEdit.CssClass = "text-center";
row.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
string urlDel = "delete_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteLEARNING_OUT");
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";
row.Cells.Add(cellDel);
tblType1.Rows.Add(row);
//เก็บแถวลง session
dummyRow = (List <TableRow>)Session["addType1"];
dummyRow.Add(row);
Session["addType1"] = (List <TableRow>)dummyRow;
//ซ่อน คอลัมน์ที่ 0
i = tblType1.Rows.GetRowIndex(row);
tblType1.Rows[i].Cells[0].Visible = false;
}
}
////// end tblType1 //////
////// tblType2 //////
// Head Table
//string[] ar = { "ข้อที่", "รายละเอียด", "แก้ไข", "ลบ" };
tblType2.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblType2.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead2 = new TableHeaderRow();
tRowHead2.TableSection = TableRowSection.TableHeader;
// Create a new cell and add it to the row.
TableHeaderCell cellHead12 = new TableHeaderCell();
cellHead12.Text = "ข้อที่";
cellHead12.Attributes.Add("class", "text-center");
cellHead12.Width = 50;
tRowHead2.Cells.Add(cellHead12);
TableHeaderCell cellHead22 = new TableHeaderCell();
cellHead22.Text = "รายละเอียด";
tRowHead2.Cells.Add(cellHead22);
TableHeaderCell cellHead32 = new TableHeaderCell();
cellHead32.Text = "แก้ไข";
cellHead32.Attributes.Add("class", "text-center");
cellHead32.Width = 50;
tRowHead2.Cells.Add(cellHead32);
TableHeaderCell cellHead42 = new TableHeaderCell();
cellHead42.Text = "ลบ";
cellHead42.Attributes.Add("class", "text-center");
cellHead42.Width = 50;
tRowHead2.Cells.Add(cellHead42);
tRowHead2.Cells[0].Visible = false; //Hidden Cells[0] for UUID..
tblType2.Rows.Add(tRowHead2);
//End Head Table
if (Session["addType2"] != null)
{
listTableRow2 = new List <TableRow>();
listTableRow2 = (List <TableRow>)Session["addType2"];
int i;
foreach (TableRow item in listTableRow2)
{
tblType2.Rows.Add(item);
i = tblType2.Rows.GetRowIndex(item);
tblType2.Rows[i].Cells[0].Visible = false;
}
}
else
{
//เรียกข้อมูลจากฐานข้อมูลเวลาที่คลิกแก้ไข จากหน้า list_TQF1.aspx
//สร้าง session เอาไว้เก็บแถว
List <TableRow> dummyRow = new List <TableRow>();
Session["addType2"] = (List <TableRow>)dummyRow;
//2. ด้านความรู้
string sql = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "' And DOMAINTYPECODE='2'";
List <TQF1Leaning> tqf1LearningData = new TQF1Leaning().getTQF1LeaningManual(sql);
int i;
int numOfrow = 0;
foreach (TQF1Leaning data in tqf1LearningData)
{
TableRow row = new TableRow();
TableCell cellNumber = new TableCell();
cellNumber.Text = data.UUIDNumber;
row.Cells.Add(cellNumber);
numOfrow++;
TableCell cellDetail = new TableCell();
//cellDetail.Text = "(" + numOfrow + ")\t" + data.Detailtype;
cellDetail.Text = data.Detailtype;
row.Cells.Add(cellDetail);
TableCell cellEdit = new TableCell();
string urlEdit = "edit_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypEdit = new HyperLink();
hypEdit.Attributes.Add("data-target", "#editLEARNING_OUT");
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);
cellEdit.CssClass = "text-center";
row.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
string urlDel = "delete_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteLEARNING_OUT");
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";
row.Cells.Add(cellDel);
tblType2.Rows.Add(row);
//เก็บแถวลง session
dummyRow = (List <TableRow>)Session["addType2"];
dummyRow.Add(row);
Session["addType2"] = (List <TableRow>)dummyRow;
//ซ่อน คอลัมน์ที่ 0
i = tblType2.Rows.GetRowIndex(row);
tblType2.Rows[i].Cells[0].Visible = false;
}
}
////// end tblType2 //////
////// tblType3 //////
// Head Table
//string[] ar = { "ข้อที่", "รายละเอียด", "แก้ไข", "ลบ" };
tblType3.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblType3.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead3 = new TableHeaderRow();
tRowHead3.TableSection = TableRowSection.TableHeader;
// Create a new cell and add it to the row.
TableHeaderCell cellHead13 = new TableHeaderCell();
cellHead13.Text = "ข้อที่";
cellHead13.Attributes.Add("class", "text-center");
cellHead13.Width = 50;
tRowHead3.Cells.Add(cellHead13);
TableHeaderCell cellHead23 = new TableHeaderCell();
cellHead23.Text = "รายละเอียด";
tRowHead3.Cells.Add(cellHead23);
TableHeaderCell cellHead33 = new TableHeaderCell();
cellHead33.Text = "แก้ไข";
cellHead33.Attributes.Add("class", "text-center");
cellHead33.Width = 50;
tRowHead3.Cells.Add(cellHead33);
TableHeaderCell cellHead43 = new TableHeaderCell();
cellHead43.Text = "ลบ";
cellHead43.Attributes.Add("class", "text-center");
cellHead43.Width = 50;
tRowHead3.Cells.Add(cellHead43);
tRowHead3.Cells[0].Visible = false; //Hidden Cells[0] for UUID..
tblType3.Rows.Add(tRowHead3);
//End Head Table
if (Session["addType3"] != null)
{
listTableRow3 = new List <TableRow>();
listTableRow3 = (List <TableRow>)Session["addType3"];
int i;
foreach (TableRow item in listTableRow3)
{
tblType3.Rows.Add(item);
i = tblType3.Rows.GetRowIndex(item);
tblType3.Rows[i].Cells[0].Visible = false;
}
}
else
{
//เรียกข้อมูลจากฐานข้อมูลเวลาที่คลิกแก้ไข จากหน้า list_TQF1.aspx
//สร้าง session เอาไว้เก็บแถว
List <TableRow> dummyRow = new List <TableRow>();
Session["addType3"] = (List <TableRow>)dummyRow;
//3. ด้านทักษะทางปัญญา
string sql = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "' And DOMAINTYPECODE='3'";
List <TQF1Leaning> tqf1LearningData = new TQF1Leaning().getTQF1LeaningManual(sql);
int i;
int numOfrow = 0;
foreach (TQF1Leaning data in tqf1LearningData)
{
TableRow row = new TableRow();
TableCell cellNumber = new TableCell();
cellNumber.Text = data.UUIDNumber;
row.Cells.Add(cellNumber);
numOfrow++;
TableCell cellDetail = new TableCell();
//cellDetail.Text = "(" + numOfrow + ")\t" + data.Detailtype;
cellDetail.Text = data.Detailtype;
row.Cells.Add(cellDetail);
TableCell cellEdit = new TableCell();
string urlEdit = "edit_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypEdit = new HyperLink();
hypEdit.Attributes.Add("data-target", "#editLEARNING_OUT");
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);
cellEdit.CssClass = "text-center";
row.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
string urlDel = "delete_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteLEARNING_OUT");
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";
row.Cells.Add(cellDel);
tblType3.Rows.Add(row);
//เก็บแถวลง session
dummyRow = (List <TableRow>)Session["addType3"];
dummyRow.Add(row);
Session["addType3"] = (List <TableRow>)dummyRow;
//ซ่อน คอลัมน์ที่ 0
i = tblType3.Rows.GetRowIndex(row);
tblType3.Rows[i].Cells[0].Visible = false;
}
}
////// end tblType3 //////
////// tblType4 //////
// Head Table
//string[] ar = { "ข้อที่", "รายละเอียด", "แก้ไข", "ลบ" };
tblType4.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblType4.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead4 = new TableHeaderRow();
tRowHead4.TableSection = TableRowSection.TableHeader;
// Create a new cell and add it to the row.
TableHeaderCell cellHead14 = new TableHeaderCell();
cellHead14.Text = "ข้อที่";
cellHead14.Attributes.Add("class", "text-center");
cellHead14.Width = 50;
tRowHead4.Cells.Add(cellHead14);
TableHeaderCell cellHead24 = new TableHeaderCell();
cellHead24.Text = "รายละเอียด";
tRowHead4.Cells.Add(cellHead24);
TableHeaderCell cellHead34 = new TableHeaderCell();
cellHead34.Text = "แก้ไข";
cellHead34.Attributes.Add("class", "text-center");
cellHead34.Width = 50;
tRowHead4.Cells.Add(cellHead34);
TableHeaderCell cellHead44 = new TableHeaderCell();
cellHead44.Text = "ลบ";
cellHead44.Attributes.Add("class", "text-center");
cellHead44.Width = 50;
tRowHead4.Cells.Add(cellHead44);
tRowHead4.Cells[0].Visible = false; //Hidden Cells[0] for UUID..
tblType4.Rows.Add(tRowHead4);
//End Head Table
if (Session["addType4"] != null)
{
listTableRow4 = new List <TableRow>();
listTableRow4 = (List <TableRow>)Session["addType4"];
int i;
foreach (TableRow item in listTableRow4)
{
tblType4.Rows.Add(item);
i = tblType4.Rows.GetRowIndex(item);
tblType4.Rows[i].Cells[0].Visible = false;
}
}
else
{
//เรียกข้อมูลจากฐานข้อมูลเวลาที่คลิกแก้ไข จากหน้า list_TQF1.aspx
//สร้าง session เอาไว้เก็บแถว
List <TableRow> dummyRow = new List <TableRow>();
Session["addType4"] = (List <TableRow>)dummyRow;
//4. ด้านทักษะความสัมพันธ์ระหว่างบุคคล และความรับผิดชอบ
string sql = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "' And DOMAINTYPECODE='4'";
List <TQF1Leaning> tqf1LearningData = new TQF1Leaning().getTQF1LeaningManual(sql);
int i;
int numOfrow = 0;
foreach (TQF1Leaning data in tqf1LearningData)
{
TableRow row = new TableRow();
TableCell cellNumber = new TableCell();
cellNumber.Text = data.UUIDNumber;
row.Cells.Add(cellNumber);
numOfrow++;
TableCell cellDetail = new TableCell();
//cellDetail.Text = "(" + numOfrow + ")\t" + data.Detailtype;
cellDetail.Text = data.Detailtype;
row.Cells.Add(cellDetail);
TableCell cellEdit = new TableCell();
string urlEdit = "edit_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypEdit = new HyperLink();
hypEdit.Attributes.Add("data-target", "#editLEARNING_OUT");
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);
cellEdit.CssClass = "text-center";
row.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
string urlDel = "delete_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteLEARNING_OUT");
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";
row.Cells.Add(cellDel);
tblType4.Rows.Add(row);
//เก็บแถวลง session
dummyRow = (List <TableRow>)Session["addType4"];
dummyRow.Add(row);
Session["addType4"] = (List <TableRow>)dummyRow;
//ซ่อน คอลัมน์ที่ 0
i = tblType4.Rows.GetRowIndex(row);
tblType4.Rows[i].Cells[0].Visible = false;
}
}
////// end tblType4 //////
////// tblType5 //////
// Head Table
//string[] ar = { "ข้อที่", "รายละเอียด", "แก้ไข", "ลบ" };
tblType5.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblType5.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead5 = new TableHeaderRow();
tRowHead5.TableSection = TableRowSection.TableHeader;
// Create a new cell and add it to the row.
TableHeaderCell cellHead15 = new TableHeaderCell();
cellHead15.Text = "ข้อที่";
cellHead15.Attributes.Add("class", "text-center");
cellHead15.Width = 50;
tRowHead5.Cells.Add(cellHead15);
TableHeaderCell cellHead25 = new TableHeaderCell();
cellHead25.Text = "รายละเอียด";
tRowHead5.Cells.Add(cellHead25);
TableHeaderCell cellHead35 = new TableHeaderCell();
cellHead35.Text = "แก้ไข";
cellHead35.Attributes.Add("class", "text-center");
cellHead35.Width = 50;
tRowHead5.Cells.Add(cellHead35);
TableHeaderCell cellHead45 = new TableHeaderCell();
cellHead45.Text = "ลบ";
cellHead45.Attributes.Add("class", "text-center");
cellHead45.Width = 50;
tRowHead5.Cells.Add(cellHead45);
tRowHead5.Cells[0].Visible = false; //Hidden Cells[0] for UUID..
tblType5.Rows.Add(tRowHead5);
//End Head Table
if (Session["addType5"] != null)
{
listTableRow5 = new List <TableRow>();
listTableRow5 = (List <TableRow>)Session["addType5"];
int i;
foreach (TableRow item in listTableRow5)
{
tblType5.Rows.Add(item);
i = tblType5.Rows.GetRowIndex(item);
tblType5.Rows[i].Cells[0].Visible = false;
}
}
else
{
//เรียกข้อมูลจากฐานข้อมูลเวลาที่คลิกแก้ไข จากหน้า list_TQF1.aspx
//สร้าง session เอาไว้เก็บแถว
List <TableRow> dummyRow = new List <TableRow>();
Session["addType5"] = (List <TableRow>)dummyRow;
//5. ด้านทักษะการวิเคราะห์เชิงตัวเลข การสื่อสาร และการใช้เทคโนโลยีสารสนเทศ
string sql = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "' And DOMAINTYPECODE='5'";
List <TQF1Leaning> tqf1LearningData = new TQF1Leaning().getTQF1LeaningManual(sql);
int i;
int numOfrow = 0;
foreach (TQF1Leaning data in tqf1LearningData)
{
TableRow row = new TableRow();
TableCell cellNumber = new TableCell();
cellNumber.Text = data.UUIDNumber;
row.Cells.Add(cellNumber);
numOfrow++;
TableCell cellDetail = new TableCell();
//cellDetail.Text = "(" + numOfrow + ")\t" + data.Detailtype;
cellDetail.Text = data.Detailtype;
row.Cells.Add(cellDetail);
TableCell cellEdit = new TableCell();
string urlEdit = "edit_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypEdit = new HyperLink();
hypEdit.Attributes.Add("data-target", "#editLEARNING_OUT");
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);
cellEdit.CssClass = "text-center";
row.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
string urlDel = "delete_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteLEARNING_OUT");
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";
row.Cells.Add(cellDel);
tblType5.Rows.Add(row);
//เก็บแถวลง session
dummyRow = (List <TableRow>)Session["addType5"];
dummyRow.Add(row);
Session["addType5"] = (List <TableRow>)dummyRow;
//ซ่อน คอลัมน์ที่ 0
i = tblType5.Rows.GetRowIndex(row);
tblType5.Rows[i].Cells[0].Visible = false;
}
}
////// end tblType5 //////
////// tblType6 //////
// Head Table
//string[] ar = { "ข้อที่", "รายละเอียด", "แก้ไข", "ลบ" };
tblType6.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblType6.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead6 = new TableHeaderRow();
tRowHead6.TableSection = TableRowSection.TableHeader;
// Create a new cell and add it to the row.
TableHeaderCell cellHead16 = new TableHeaderCell();
cellHead16.Text = "ข้อที่";
cellHead16.Attributes.Add("class", "text-center");
cellHead16.Width = 50;
tRowHead6.Cells.Add(cellHead16);
TableHeaderCell cellHead26 = new TableHeaderCell();
cellHead26.Text = "รายละเอียด";
tRowHead6.Cells.Add(cellHead26);
TableHeaderCell cellHead36 = new TableHeaderCell();
cellHead36.Text = "แก้ไข";
cellHead36.Attributes.Add("class", "text-center");
cellHead36.Width = 50;
tRowHead6.Cells.Add(cellHead36);
TableHeaderCell cellHead46 = new TableHeaderCell();
cellHead46.Text = "ลบ";
cellHead46.Attributes.Add("class", "text-center");
cellHead46.Width = 50;
tRowHead6.Cells.Add(cellHead46);
tRowHead6.Cells[0].Visible = false; //Hidden Cells[0] for UUID..
tblType6.Rows.Add(tRowHead6);
//End Head Table
if (Session["addType6"] != null)
{
listTableRow6 = new List <TableRow>();
listTableRow6 = (List <TableRow>)Session["addType6"];
int i;
foreach (TableRow item in listTableRow6)
{
tblType6.Rows.Add(item);
i = tblType6.Rows.GetRowIndex(item);
tblType6.Rows[i].Cells[0].Visible = false;
}
}
else
{
//เรียกข้อมูลจากฐานข้อมูลเวลาที่คลิกแก้ไข จากหน้า list_TQF1.aspx
//สร้าง session เอาไว้เก็บแถว
List <TableRow> dummyRow = new List <TableRow>();
Session["addType6"] = (List <TableRow>)dummyRow;
//6. ด้านทักษะพิสัย
string sql = "Select * From TQF1LEANING Where NUMTQF1='" + NumTQF1 + "' And DOMAINTYPECODE='6'";
List <TQF1Leaning> tqf1LearningData = new TQF1Leaning().getTQF1LeaningManual(sql);
int i;
int numOfrow = 0;
foreach (TQF1Leaning data in tqf1LearningData)
{
TableRow row = new TableRow();
TableCell cellNumber = new TableCell();
cellNumber.Text = data.UUIDNumber;
row.Cells.Add(cellNumber);
numOfrow++;
TableCell cellDetail = new TableCell();
//cellDetail.Text = "(" + numOfrow + ")\t" + data.Detailtype;
cellDetail.Text = data.Detailtype;
row.Cells.Add(cellDetail);
TableCell cellEdit = new TableCell();
string urlEdit = "edit_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypEdit = new HyperLink();
hypEdit.Attributes.Add("data-target", "#editLEARNING_OUT");
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);
cellEdit.CssClass = "text-center";
row.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
string urlDel = "delete_LEARNING_OUT.aspx?token=" + data.UUIDNumber + "&LearningOutcomesType=" + data.DomainTypeCode;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteLEARNING_OUT");
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";
row.Cells.Add(cellDel);
tblType6.Rows.Add(row);
//เก็บแถวลง session
dummyRow = (List <TableRow>)Session["addType6"];
dummyRow.Add(row);
Session["addType6"] = (List <TableRow>)dummyRow;
//ซ่อน คอลัมน์ที่ 0
i = tblType6.Rows.GetRowIndex(row);
tblType6.Rows[i].Cells[0].Visible = false;
}
}
////// end tblType6 //////
}
protected void btnDELETE_Click(object sender, EventArgs e)
{
int i;
Table dummyTable = new Table();
List <TableRow> listTableRow1 = new List <TableRow>();
listTableRow1 = (List <TableRow>)Session["addType1"];
List <TableRow> listTableRow2 = new List <TableRow>();
listTableRow2 = (List <TableRow>)Session["addType2"];
List <TableRow> listTableRow3 = new List <TableRow>();
listTableRow3 = (List <TableRow>)Session["addType3"];
List <TableRow> listTableRow4 = new List <TableRow>();
listTableRow4 = (List <TableRow>)Session["addType4"];
List <TableRow> listTableRow5 = new List <TableRow>();
listTableRow5 = (List <TableRow>)Session["addType5"];
List <TableRow> listTableRow6 = new List <TableRow>();
listTableRow6 = (List <TableRow>)Session["addType6"];
switch (int.Parse(LearningOutcomesType))
{
case 1:
List <TableRow> dummyRow1 = new List <TableRow>();
foreach (TableRow item in listTableRow1)
{
dummyTable.Rows.Add(item);
i = dummyTable.Rows.GetRowIndex(item);
if (dummyTable.Rows[i].Cells[0].Text == code)
{
dummyTable.Rows.RemoveAt(i); //remove row
//ลบข้อมูลแถวนี้ออกจากฐานข้อมูล
string dataDelete = new TQF1Leaning().deleteTQF1Leaning(code);
}
}
foreach (TableRow item in dummyTable.Rows)
{
dummyRow1.Add(item);
}
Session["addType1"] = (List <TableRow>)dummyRow1;
break;
case 2:
List <TableRow> dummyRow2 = new List <TableRow>();
foreach (TableRow item in listTableRow2)
{
dummyTable.Rows.Add(item);
i = dummyTable.Rows.GetRowIndex(item);
if (dummyTable.Rows[i].Cells[0].Text == code)
{
dummyTable.Rows.RemoveAt(i); //remove row
//ลบข้อมูลแถวนี้ออกจากฐานข้อมูล
string dataDelete = new TQF1Leaning().deleteTQF1Leaning(code);
}
}
foreach (TableRow item in dummyTable.Rows)
{
dummyRow2.Add(item);
}
Session["addType2"] = (List <TableRow>)dummyRow2;
break;
case 3:
List <TableRow> dummyRow3 = new List <TableRow>();
foreach (TableRow item in listTableRow3)
{
dummyTable.Rows.Add(item);
i = dummyTable.Rows.GetRowIndex(item);
if (dummyTable.Rows[i].Cells[0].Text == code)
{
dummyTable.Rows.RemoveAt(i); //remove row
//ลบข้อมูลแถวนี้ออกจากฐานข้อมูล
string dataDelete = new TQF1Leaning().deleteTQF1Leaning(code);
}
}
foreach (TableRow item in dummyTable.Rows)
{
dummyRow3.Add(item);
}
Session["addType3"] = (List <TableRow>)dummyRow3;
break;
case 4:
List <TableRow> dummyRow4 = new List <TableRow>();
foreach (TableRow item in listTableRow4)
{
dummyTable.Rows.Add(item);
i = dummyTable.Rows.GetRowIndex(item);
if (dummyTable.Rows[i].Cells[0].Text == code)
{
dummyTable.Rows.RemoveAt(i); //remove row
//ลบข้อมูลแถวนี้ออกจากฐานข้อมูล
string dataDelete = new TQF1Leaning().deleteTQF1Leaning(code);
}
}
foreach (TableRow item in dummyTable.Rows)
{
dummyRow4.Add(item);
}
Session["addType4"] = (List <TableRow>)dummyRow4;
break;
case 5:
List <TableRow> dummyRow5 = new List <TableRow>();
foreach (TableRow item in listTableRow5)
{
dummyTable.Rows.Add(item);
i = dummyTable.Rows.GetRowIndex(item);
if (dummyTable.Rows[i].Cells[0].Text == code)
{
dummyTable.Rows.RemoveAt(i); //remove row
//ลบข้อมูลแถวนี้ออกจากฐานข้อมูล
string dataDelete = new TQF1Leaning().deleteTQF1Leaning(code);
}
}
foreach (TableRow item in dummyTable.Rows)
{
dummyRow5.Add(item);
}
Session["addType5"] = (List <TableRow>)dummyRow5;
break;
case 6:
List <TableRow> dummyRow6 = new List <TableRow>();
foreach (TableRow item in listTableRow6)
{
dummyTable.Rows.Add(item);
i = dummyTable.Rows.GetRowIndex(item);
if (dummyTable.Rows[i].Cells[0].Text == code)
{
dummyTable.Rows.RemoveAt(i); //remove row
//ลบข้อมูลแถวนี้ออกจากฐานข้อมูล
string dataDelete = new TQF1Leaning().deleteTQF1Leaning(code);
}
}
foreach (TableRow item in dummyTable.Rows)
{
dummyRow6.Add(item);
}
Session["addType6"] = (List <TableRow>)dummyRow6;
break;
default:
Response.Redirect("edit_TQF1.aspx?token=" + Session["NumTQF1"].ToString());
break;
}
Response.Redirect("edit_TQF1.aspx?token=" + Session["NumTQF1"].ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
domain = Request.QueryString["domain"];
detailType = Request.QueryString["detailType"];
CurrCode = Session["CurrCode"].ToString();
YearVersion = Session["YearVersion"].ToString();
//รับ session มาจากหน้า Faculty_add_CURR1.aspx
if (Session["NumTQF1"] != null)
{
NumTQF1 = Session["NumTQF1"].ToString();
}
else
{
Response.Redirect("Faculty_add_CURR2.aspx");
}
if (!Page.IsPostBack)
{
switch (domain)
{
case "1":
lblDomainType.Text = "ด้านคุณธรรม จริยธรรม";
break;
case "2":
lblDomainType.Text = "ด้านความรู้";
break;
case "3":
lblDomainType.Text = "ด้านทักษะทางปัญญา";
break;
case "4":
lblDomainType.Text = "ด้านทักษะความสัมพันธ์ระหว่างบุคคล และความรับผิดชอบ";
break;
case "5":
lblDomainType.Text = "ด้านทักษะการวิเคราะห์เชิงตัวเลข การสื่อสาร และการใช้เทคโนโลยีสารสนเทศ";
break;
case "6":
lblDomainType.Text = "ด้านทักษะพิสัย";
break;
}
}
// Head Table
string[] ar = { "เลือก", "รายละเอียด" };
tblLearningOutcomes.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblLearningOutcomes.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead = new TableHeaderRow();
tRowHead.TableSection = TableRowSection.TableHeader;
for (int cellCtr = 1; cellCtr <= ar.Length; cellCtr++)
{
TableHeaderCell cellHead = new TableHeaderCell();
cellHead.Text = ar[cellCtr - 1];
tRowHead.Cells.Add(cellHead);
}
tblLearningOutcomes.Rows.Add(tRowHead);
string sql = "Select * From TQF1LEANING Where DOMAINTYPECODE='" + domain + "' And NUMTQF1='" + NumTQF1 + "'";
List <TQF1Leaning> tqf1Learning = new TQF1Leaning().getTQF1LeaningManual(sql);
foreach (TQF1Leaning data in tqf1Learning)
{
TableRow tRowBody = new TableRow();
tRowBody.TableSection = TableRowSection.TableBody;
//Cell [0]
TableCell cellCheck = new TableCell();
CheckBox chk = new CheckBox();
chk.ID = data.NUMTQF1Leaning;
cellCheck.Controls.Add(chk);
cellCheck.CssClass = "text-center";
cellCheck.Width = 50;
tRowBody.Cells.Add(cellCheck);
//Cell [1]
TableCell cellDomain = new TableCell();
cellDomain.Text = data.Detailtype;
tRowBody.Cells.Add(cellDomain);
tblLearningOutcomes.Rows.Add(tRowBody);
}
TableRow tRowTextBox = new TableRow();
tRowTextBox.TableSection = TableRowSection.TableBody;
//Cell [0]
TableCell cellCheckText = new TableCell();
CheckBox chkText = new CheckBox();
chkText.ID = "chk" + NumTQF1;
cellCheckText.Controls.Add(chkText);
cellCheckText.CssClass = "text-center";
cellCheckText.Width = 50;
tRowTextBox.Cells.Add(cellCheckText);
//Cell [1]
TableCell cellTextBox = new TableCell();
TextBox tbox = new TextBox();
tbox.ID = "txt" + NumTQF1;
tbox.TextMode = TextBoxMode.MultiLine;
tbox.Rows = 5;
tbox.Width = 600;
cellTextBox.Controls.Add(tbox);
tRowTextBox.Cells.Add(cellTextBox);
tblLearningOutcomes.Rows.Add(tRowTextBox);
}
