/// <summary>
/// เรียกดูข้อมูลจากตาราง TQF1
/// </summary>
/// <returns>ข้อมูลจากตาราง TQF1</returns>
public List <TQF1> getTQF1()
{
List <TQF1> TQF1Data = new List <TQF1>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
oracleObj.SelectCommand = "Select * From TQF1 Order By YEAR";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
TQF1 TQF1Row = new TQF1();
TQF1Row.NumTQF1 = rowData["NUMTQF1"].ToString();
TQF1Row.Year = rowData["YEAR"].ToString();
TQF1Row.LevelCode = rowData["LEVELCODE"].ToString();
TQF1Row.TQF1Major = rowData["MAJORNAME"].ToString();
TQF1Row.FileName = rowData["FILENAME"].ToString();
TQF1Data.Add(TQF1Row);
}
return(TQF1Data);
}
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");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//lblDegree.Text = new TQF1().getTqf1Id();
if (file_Attachment.HasFile)
{
FileName = Path.GetFileName(file_Attachment.PostedFile.FileName);
Extension = Path.GetExtension(file_Attachment.PostedFile.FileName);
FolderPath = ConfigurationManager.AppSettings["TQF1UploadFolder"];
//หากต้องการเปลี่ยนชื่อไฟล์ที่ใช้ upload
//string newName = new TQF1().getTqf1Id();
//FileName = newName + Extension;
string FilePath = Server.MapPath(FolderPath + FileName);
if (Extension == ".pdf")
{
file_Attachment.SaveAs(FilePath);
}
else
{
Session["response"] = "add_TQF1: ไฟล์ upload ต้องเป็นไฟล์นามสกุล .pdf เท่านั้น";
Response.Redirect("../err_response.aspx");
}
}
TQF1 tqf1Data = new TQF1();
string id = new TQF.TQFUtility().getMaxID("NUMTQF1", "TQF1");
tqf1Data.NumTQF1 = id;
tqf1Data.Year = txtACADEMIC_YEAR.Text;
tqf1Data.LevelCode = ddlDegree.SelectedValue;
tqf1Data.TQF1Major = txtMajor.Text;
tqf1Data.FileName = FileName;
string resulte = new TQF1().insertTQF1(tqf1Data);
if (resulte == "Success")
{
Response.Redirect("edit_TQF1.aspx?token=" + id);
}
else
{
Session["response"] = "add_TQF1: ไม่สามารถดำเนินการได้ในขณะนี้ (1)";
Response.Redirect("../err_response.aspx");
}
}
/// <summary>
/// เพิ่มข้อมูลลงตาราง TQF1
/// </summary>
/// <param name="dataInsert"></param>
/// <returns></returns>
public string insertTQF1(TQF1 dataInsert)
{
string response = "";
int sleepTime = 5000;
string NumTQF1 = dataInsert.NumTQF1;
for (int i = 0; i < 10; i++)
{
if (getTQF1(NumTQF1).NumTQF1 != null)
{
Thread.Sleep(sleepTime);
NumTQF1 = new TQF.TQFUtility().getMaxID("NUMTQF1", "TQF1");
sleepTime += 5000;
}
else
{
dataInsert.NumTQF1 = NumTQF1;
break;
}
}
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
string sql = "Insert into TQF1 (NUMTQF1, YEAR, LEVELCODE, MAJORNAME, FILENAME) values ('" + dataInsert.NumTQF1 + "','" + dataInsert.Year + "','" + dataInsert.LevelCode + "','" + dataInsert.TQF1Major + "','" + dataInsert.FileName + "')";
oracleObj.InsertCommand = sql;
try
{
if (oracleObj.Insert() == 1)
{
response = "Success";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "insertTQF1: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
//protected void btnNEXT_Click(object sender, EventArgs e)
//{
// Response.RedirectPermanent("./addCURR_GEN_EDU2.aspx");
//}
protected void ddlDegree1_SelectedIndexChanged(object sender, EventArgs e)
{
string sql = "Select * From TQF1 Where LEVELCODE='" + ddlDegree1.SelectedValue + "'";
List <TQF1> tqf1 = new TQF1().getTQF1Manual(sql);
ddlTQF1.Items.Clear();
if (tqf1.Count == 0)
{
ddlTQF1.Items.Clear();
ddlTQF1.Items.Insert(ddlTQF1.Items.Count, new ListItem("ไม่มีมาตรฐานคุณวุฒิสาขา", "000"));
}
else
{
foreach (TQF1 row in tqf1)
{
ddlTQF1.Items.Insert(ddlTQF1.Items.Count, new ListItem(row.TQF1Major, row.NumTQF1));
}
}
}
/// <summary>
/// เรียกดูข้อมูลจากตาราง TQF1
/// </summary>
/// <param name="NumTQF1">รหัสมคอ.1</param>
/// <returns>ข้อมูลจากตาราง TQF1</returns>
public TQF1 getTQF1(string NumTQF1)
{
TQF1 TQF1Data = new TQF1();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
oracleObj.SelectCommand = "Select * From TQF1 Where NUMTQF1='" + NumTQF1 + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
TQF1Data.NumTQF1 = rowData["NUMTQF1"].ToString();
TQF1Data.Year = rowData["YEAR"].ToString();
TQF1Data.LevelCode = rowData["LEVELCODE"].ToString();
TQF1Data.TQF1Major = rowData["MAJORNAME"].ToString();
TQF1Data.FileName = rowData["FILENAME"].ToString();
}
return(TQF1Data);
}
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 Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.curriculum))
{
// ======== Process ===========
CurrCode = Request.QueryString["CurrCode"];
YearVersion = Request.QueryString["YearVersion"];
TQF.Curriculum curriculum = new TQF.Curriculum();
TQF.Curriculum curriculumData = curriculum.getCurriculum(CurrCode, YearVersion);
if (!Page.IsPostBack)
{
if (curriculumData.CurrStatus == "1")
{
//สถานะของหลักสูตร(1=ใหม่, 2=ปรับปรุง)
rBtnNEW_CURR.Checked = true;
}
else if (curriculumData.CurrStatus == "2")
{
//สถานะของหลักสูตร(1=ใหม่, 2=ปรับปรุง)
rBtnMINOR_MODI_CURR.Checked = true;
}
else
{
//สถานะของหลักสูตร(1=ใหม่, 2=ปรับปรุง)
rBtnNEW_CURR.Checked = true;
}
txtCURR_CODE.Text = curriculumData.CurrCode;
txtCURR_YEAR_VERSION.Text = curriculumData.YearVersion;
ddlCURR_SEMESTER.Items.FindByValue(curriculumData.BeginSemester).Selected = true;
txtCURR_YEAR.Text = curriculumData.BeginYear;
List <TQF.Levels> levels = new TQF.Levels().getLevels();
ddlDegree.Items.Clear();
ddlDegree1.Items.Clear();
foreach (TQF.Levels row in levels)
{
ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode));
ddlDegree1.Items.Insert(ddlDegree1.Items.Count, new ListItem(row.LevelName, row.LevelCode));
}
ddlDegree.Items.FindByValue(curriculumData.LevelCode).Selected = true;
ddlDegree1.Items.FindByValue(curriculumData.LevelCode).Selected = true;
txtCURR_THAINAME.Text = curriculumData.CurrThName;
txtCURR_ENGNAME.Text = curriculumData.CurrEnName;
List <FacultyData> faculty = new Faculty().getFaculty();
ddlCURR_FACULTY.Items.Clear();
//ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem("--- เลือกคณะ ---", "00"));
foreach (FacultyData row in faculty)
{
//FacultyCode == "99" -> ใช้ร่วมทุกคณะ
if (row.Faculty_Code == "99")
{
ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(row.Faculty_Thai, row.Faculty_Code));
}
}
ddlTQF1.Items.Clear();
List <TQF1> tqf1 = new TQF1().getTQF1();
ddlTQF1.Items.Clear();
foreach (TQF1 row in tqf1)
{
ddlTQF1.Items.Insert(ddlTQF1.Items.Count, new ListItem(row.TQF1Major, row.NumTQF1));
}
ddlTQF1.Items.FindByValue(curriculumData.NumTQF1).Selected = true;
}
//=============================
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
login_data = (UserLoginData)Session["login_data"];
if (!Page.IsPostBack)
{
//ล้าง session
Session.Remove("NumTQF1");
Session.Remove("addType1");
Session.Remove("addType2");
Session.Remove("addType3");
Session.Remove("addType4");
Session.Remove("addType5");
Session.Remove("addType6");
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));
}
ddlDegree.Items.FindByValue("02").Selected = true;
// Head Table
string[] ar = { "ระดับ", "สาขาวิชา", "ปี พ.ศ. ประกาศราชกิจจาฯ", "Download", "แก้ไข", "ลบ" };
tblTQF1.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblTQF1.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);
}
tblTQF1.Rows.Add(tRowHead);
// End Head Table
List <TQF1> tqf1Data = new TQF1().getTQF1();
foreach (TQF1 data in tqf1Data)
{
TableRow tRowBody = new TableRow();
tRowBody.TableSection = TableRowSection.TableBody;
TQF.Levels level = new TQF.Levels();
TableCell cellLevel = new TableCell();
cellLevel.Text = level.getLevels(data.LevelCode).LevelName;
tRowBody.Cells.Add(cellLevel);
TableCell cellMajor = new TableCell();
cellMajor.Text = data.TQF1Major;
tRowBody.Cells.Add(cellMajor);
TableCell cellYear = new TableCell();
cellYear.Text = data.Year;
tRowBody.Cells.Add(cellYear);
TableCell cellDownload = new TableCell();
string urlDownload = "../TQF1_Upload/" + data.FileName;
HyperLink hypDownload = new HyperLink();
hypDownload.Attributes.Add("target", "_blnk");
hypDownload.Text = "<h4><i class='fa fa-download'></i></h4>";
hypDownload.NavigateUrl = urlDownload;
hypDownload.ToolTip = "Download";
cellDownload.Controls.Add(hypDownload);
cellDownload.CssClass = "text-center";
tRowBody.Cells.Add(cellDownload);
if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty) || autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
TableCell cellEdit = new TableCell();
string urlEdit = "edit_TQF1.aspx?token=" + data.NumTQF1;
HyperLink hypEdit = new HyperLink();
//hypEdit.Attributes.Add("data-target", "#editDegree_Admission");
//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";
tRowBody.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
string urlDel = "delete_TQF1.aspx?token=" + data.NumTQF1;;
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);
cellDel.CssClass = "text-center";
tRowBody.Cells.Add(cellDel);
}
else
{
TableCell cellEdit = new TableCell();
string urlEdit = "#";
HyperLink hypEdit = new HyperLink();
//hypEdit.Attributes.Add("data-target", "#editDegree_Admission");
//hypEdit.Attributes.Add("data-toggle", "modal");
hypEdit.Text = "<h4><i class='fa fa-lock'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "Lock";
cellEdit.Controls.Add(hypEdit);
cellEdit.CssClass = "text-center";
tRowBody.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
string urlDel = "#";
HyperLink hypDel = new HyperLink();
hypDel.Text = "<h4><i class='fa fa-lock'></i></h4>";
hypDel.NavigateUrl = urlDel;
hypDel.ToolTip = "Lock";
cellDel.Controls.Add(hypDel);
cellDel.CssClass = "text-center";
tRowBody.Cells.Add(cellDel);
}
tblTQF1.Rows.Add(tRowBody);
}
}
}
protected void btnSEARCH_Click(object sender, EventArgs e)
{
// Head Table
string[] ar = { "ระดับ", "สาขาวิชา", "ปี พ.ศ. ประกาศราชกิจจาฯ", "Download", "แก้ไข", "ลบ" };
tblTQF1.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblTQF1.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);
}
tblTQF1.Rows.Add(tRowHead);
// End Head Table
string sql = "Select * From TQF1 Where LEVELCODE='" + ddlDegree.SelectedValue + "'";
List <TQF1> tqf1Data = new TQF1().getTQF1Manual(sql);
foreach (TQF1 data in tqf1Data)
{
TableRow tRowBody = new TableRow();
tRowBody.TableSection = TableRowSection.TableBody;
TQF.Levels level = new TQF.Levels();
TableCell cellLevel = new TableCell();
cellLevel.Text = level.getLevels(data.LevelCode).LevelName;
tRowBody.Cells.Add(cellLevel);
TableCell cellMajor = new TableCell();
cellMajor.Text = data.TQF1Major;
tRowBody.Cells.Add(cellMajor);
TableCell cellYear = new TableCell();
cellYear.Text = data.Year;
tRowBody.Cells.Add(cellYear);
//<a target="_blnk" title="Download" href="Files/engineer_m1.pdf">
// <h4><i class="fa fa-download"></i></h4>
TableCell cellDownload = new TableCell();
string urlDownload = "../TQF1_Upload/" + data.FileName;
HyperLink hypDownload = new HyperLink();
//hypEdit.Attributes.Add("data-target", "#editDegree_Admission");
hypDownload.Attributes.Add("target", "_blnk");
hypDownload.Text = "<h4><i class='fa fa-download'></i></h4>";
hypDownload.NavigateUrl = urlDownload;
hypDownload.ToolTip = "Download";
cellDownload.Controls.Add(hypDownload);
cellDownload.CssClass = "text-center";
tRowBody.Cells.Add(cellDownload);
TableCell cellEdit = new TableCell();
string urlEdit = "edit_Degree_Admission.aspx?token=";
HyperLink hypEdit = new HyperLink();
hypEdit.Attributes.Add("data-target", "#editDegree_Admission");
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";
tRowBody.Cells.Add(cellEdit);
TableCell cellDel = new TableCell();
string urlDel = "delete_Degree_Admission.aspx?token=";
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteDegree_Admission");
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";
tRowBody.Cells.Add(cellDel);
tblTQF1.Rows.Add(tRowBody);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty) || autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
// ======== Process ===========
bool editable = false;
CurrCode = Request.QueryString["CurrCode"];
YearVersion = Request.QueryString["YearVersion"];
TQF.Curriculum curriculum = new TQF.Curriculum();
TQF.Curriculum curriculumData = curriculum.getCurriculum(CurrCode, YearVersion);
//หลักสูตร
if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
{
editable = true;
}
// วิชาการคณะ
//else if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
//{
// List<string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty);
// foreach (string fac in faculty_authorized)
// {
// if (fac == curriculumData.FacultyCode)
// {
// editable = true;
// break;
// }
// }
//}
// วิชาการภาค
else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department);
foreach (string dep in department_authorized)
{
if (dep == curriculumData.DepartmentCode)
{
editable = true;
break;
}
}
}
if (!Page.IsPostBack)
{
if (editable == true)
{
if (curriculumData.CurrStatus == "1")
{
//สถานะของหลักสูตร(1=ใหม่, 2=ปรับปรุง)
rBtnNEW_CURR.Checked = true;
}
else if (curriculumData.CurrStatus == "2")
{
//สถานะของหลักสูตร(1=ใหม่, 2=ปรับปรุง)
rBtnMINOR_MODI_CURR.Checked = true;
}
else
{
//สถานะของหลักสูตร(1=ใหม่, 2=ปรับปรุง)
rBtnNEW_CURR.Checked = true;
}
txtCURR_CODE.Text = curriculumData.CurrCode;
txtCURR_YEAR_VERSION.Text = curriculumData.YearVersion;
try
{
ddlCURR_SEMESTER.Items.FindByValue(curriculumData.BeginSemester).Selected = true;
}
catch
{ }
txtCURR_YEAR.Text = curriculumData.BeginYear;
List <TQF.Levels> levels = new TQF.Levels().getLevels();
ddlDegree.Items.Clear();
ddlDegree1.Items.Clear();
foreach (TQF.Levels row in levels)
{
ddlDegree.Items.Insert(ddlDegree.Items.Count, new ListItem(row.LevelName, row.LevelCode));
ddlDegree1.Items.Insert(ddlDegree1.Items.Count, new ListItem(row.LevelName, row.LevelCode));
}
try
{
ddlDegree.Items.FindByValue(curriculumData.LevelCode).Selected = true;
ddlDegree1.Items.FindByValue(curriculumData.LevelCode).Selected = true;
}
catch
{ }
txtCURR_THAINAME.Text = curriculumData.CurrThName;
txtCURR_ENGNAME.Text = curriculumData.CurrEnName;
//txtCURR_SHORT_THAINAME.Text = curriculumData.CurrShortThName;
//txtCURR_SHORT_ENGNAME.Text = curriculumData.CurrShortEnName;
txtDIP_THAINAME.Text = new Diploma().getDiploma(curriculumData.DiplomaCode).DomainThName;
txtDIP_ENGNAME.Text = new Diploma().getDiploma(curriculumData.DiplomaCode).DomainEnName;
txtDIP_SHORT_THAINAME.Text = new Diploma().getDiploma(curriculumData.DiplomaCode).DomainThShortName;
txtDIP_SHORT_ENGNAME.Text = new Diploma().getDiploma(curriculumData.DiplomaCode).DomainEnShortName;
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));
}
try
{
ddlCURR_FACULTY.Items.FindByValue(curriculumData.FacultyCode).Selected = true;
}
catch
{ }
List <DepartmentData> department = new Department().getDepartment();
ddlCURR_DEPARTMENT.Items.Clear();
foreach (DepartmentData row in department)
{
ddlCURR_DEPARTMENT.Items.Insert(ddlCURR_DEPARTMENT.Items.Count, new ListItem(row.Department_Thai, row.Department_Code));
}
try
{
ddlCURR_DEPARTMENT.Items.FindByValue(curriculumData.DepartmentCode).Selected = true;
}
catch
{ }
string sqlDivision = "Select * From DIVISION Where DEPARTMENTCODE = " + curriculumData.DepartmentCode;
List <TQF.Division> division = new TQF.Division().getDivisionManual(sqlDivision);
ddlCURR_MAJOR.Items.Clear();
foreach (TQF.Division row in division)
{
ddlCURR_MAJOR.Items.Insert(ddlCURR_MAJOR.Items.Count, new ListItem(row.DivisionThName + " ( " + row.DivisionEnShortName + " )", row.DivisionCode));
}
string sqlDivisionExtension = "Select * From DIVISIONEXTENSION Where DIVISIONNO='" + curriculumData.DivisionCode + "'";
List <DivisionExtension> divisionExtension = new DivisionExtension().getDivisionExtensionManual(sqlDivisionExtension);
foreach (DivisionExtension row in divisionExtension)
{
try
{
ddlCURR_MAJOR.Items.FindByValue(row.DivisionCode).Selected = true;
}
catch
{ }
}
txtSTUDY_YEAR.Text = curriculumData.NumYear;
txtTOTAL_STUDY_YEAR.Text = curriculumData.MaxNumYear;
List <SysUser> sysUser = new SysUser().getSysUser();
ddlLECTURER.Items.Clear();
foreach (SysUser row in sysUser)
{
string sql = "Select * From ABOUTLECTURER Where LECTIDENTITY='" + row.IdCode + "'";
List <AboutLecturer> aboutLecturer = new AboutLecturer().getAboutLecturerManual(sql);
//เช็คว่าอาจารย์ประจำหลักสูตรไปแล้วหรือยัง
if (aboutLecturer.Count > 0)
{
string sql2 = "Select * From ABOUTLECTURER Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And LECTIDENTITY='" + row.IdCode + "' And LOADTYPECODE='1'";
List <AboutLecturer> aboutLecturer2 = new AboutLecturer().getAboutLecturerManual(sql2);
foreach (AboutLecturer li in aboutLecturer2)
{
if (li.LectIdentity == row.IdCode)
{
ddlLECTURER.Items.Insert(ddlLECTURER.Items.Count, new ListItem(row.ThName + " " + row.ThSurName + " (" + row.ShortName + ")", row.IdCode));
ddlLECTURER.Items.FindByValue(row.IdCode).Selected = true;
}
}
continue;
}
else
{
ddlLECTURER.Items.Insert(ddlLECTURER.Items.Count, new ListItem(row.ThName + " " + row.ThSurName + " (" + row.ShortName + ")", row.IdCode));
}
}
try
{
ddlMAJORSTATUS.Items.FindByValue(curriculumData.MajorStatus).Selected = true;
}
catch
{ }
List <TQF1> tqf1 = new TQF1().getTQF1();
ddlTQF1.Items.Clear();
foreach (TQF1 row in tqf1)
{
ddlTQF1.Items.Insert(ddlTQF1.Items.Count, new ListItem(row.TQF1Major, row.NumTQF1));
if (curriculumData.NumTQF1 == row.NumTQF1)
{
ddlTQF1.Items.FindByValue(curriculumData.NumTQF1).Selected = true;
}
}
//ddlTQF1.Items.FindByValue(curriculumData.NumTQF1).Selected = true;
txtDateApprove.Text = curriculumData.ApprovedDate;
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
//=========================
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
