/// <summary>
/// เรียกดูข้อมูลจากตาราง LECTUREREVIDENCE
/// </summary>
/// <param name="LectIdentity">บัตรประจำตัวประชาชน</param>
/// <returns>ข้อมูลจากตาราง LECTUREREVIDENCE</returns>
public LecturerEvidence getLecturerEvidence(string LectIdentity)
{
LecturerEvidence data = new LecturerEvidence();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
oracleObj.SelectCommand = "Select * From LECTUREREVIDENCE Where LECTIDENTITY='" + LectIdentity + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
data.LectIdentity = rowData["LECTIDENTITY"].ToString();
data.Evidence1 = rowData["EVIDENCE1"].ToString();
data.Evidence2 = rowData["EVIDENCE2"].ToString();
data.Evidence3 = rowData["EVIDENCE3"].ToString();
data.Evidence4 = rowData["EVIDENCE4"].ToString();
data.Evidence5 = rowData["EVIDENCE5"].ToString();
data.Evidence6 = rowData["EVIDENCE6"].ToString();
data.Evidence7 = rowData["EVIDENCE7"].ToString();
data.Evidence8 = rowData["EVIDENCE8"].ToString();
data.AttatchName = rowData["ATTATCHNAME"].ToString();
}
return(data);
}
/// <summary>
/// แก้ไขข้อมูลจากตาราง LECTUREREVIDENCE
/// </summary>
/// <param name="updateData">LecturerEvidence Object</param>
/// <returns>Success</returns>
public string updateLecturerEvidence(LecturerEvidence updateData)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
string sql = "Update LECTUREREVIDENCE Set EVIDENCE1 = '" + updateData.Evidence1 + "', EVIDENCE2 = '" + updateData.Evidence2 + "', EVIDENCE3 = '" + updateData.Evidence3 + "', EVIDENCE4 = '" + updateData.Evidence4 + "', EVIDENCE5 = '" + updateData.Evidence5 + "', EVIDENCE6 = '" + updateData.Evidence6 + "', EVIDENCE7 = '" + updateData.Evidence7 + "', EVIDENCE8 = '" + updateData.Evidence8 + "', ATTATCHNAME = '" + updateData.AttatchName + "' Where LECTIDENTITY = '" + updateData.LectIdentity + "'";
oracleObj.UpdateCommand = sql;
try
{
if (oracleObj.Update() == 1)
{
response = "Success";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "updateLecturerEvidence: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
/// <summary>
/// เพิ่มข้อมูลลงตาราง LECTUREREVIDENCE
/// </summary>
/// <param name="dataInsert">LecturerEvidence Object</param>
/// <returns>Success</returns>
public string insertLecturerEvidence(LecturerEvidence dataInsert)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
string sql = "Insert into LECTUREREVIDENCE (LECTIDENTITY, EVIDENCE1, EVIDENCE2, EVIDENCE3, EVIDENCE4, EVIDENCE5, EVIDENCE6, EVIDENCE7, EVIDENCE8, ATTATCHNAME) values ('" + dataInsert.LectIdentity + "','" + dataInsert.Evidence1 + "','" + dataInsert.Evidence2 + "','" + dataInsert.Evidence3 + "','" + dataInsert.Evidence4 + "','" + dataInsert.Evidence5 + "','" + dataInsert.Evidence6 + "','" + dataInsert.Evidence7 + "','" + dataInsert.Evidence8 + "','" + dataInsert.AttatchName + "')";
oracleObj.InsertCommand = sql;
try
{
if (oracleObj.Insert() == 1)
{
response = "Success";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "insertLecturerEvidence: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
/// <summary>
/// เรียกดูข้อมูลจากตาราง LECTUREREVIDENCE
/// </summary>
/// <param name="sql">SQL Command</param>
/// <returns>ข้อมูลจากตาราง LECTUREREVIDENCE</returns>
public List <LecturerEvidence> getLecturerEvidenceManual(string sql)
{
List <LecturerEvidence> data = new List <LecturerEvidence>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
LecturerEvidence row = new LecturerEvidence();
row.LectIdentity = rowData["LECTIDENTITY"].ToString();
row.Evidence1 = rowData["EVIDENCE1"].ToString();
row.Evidence2 = rowData["EVIDENCE2"].ToString();
row.Evidence3 = rowData["EVIDENCE3"].ToString();
row.Evidence4 = rowData["EVIDENCE4"].ToString();
row.Evidence5 = rowData["EVIDENCE5"].ToString();
row.Evidence6 = rowData["EVIDENCE6"].ToString();
row.Evidence7 = rowData["EVIDENCE7"].ToString();
row.Evidence8 = rowData["EVIDENCE8"].ToString();
row.AttatchName = rowData["ATTATCHNAME"].ToString();
data.Add(row);
}
return(data);
}
private void printLecturerForm(string lectuere_id, HttpResponse Response)
{
SysUser sysUserData = new SysUser().getSysUser(code);
Sysuser2 sysuserData2 = new Sysuser2().getSysuser2(code);
string prefix = new Prefix().getPrefix(sysUserData.TitleNameCode).Prefix_Thai;
string thai_name = sysUserData.ThName;
string thai_surname = sysUserData.ThSurName;
string academic_position = new AcademicPosition().getAcademicPosition(sysUserData.AcademicPositionCode).AcademicPositionThName;
string nationality = new Country().getCountry(sysUserData.Nationality).Country_ThaiName;
string ethnicity = new Country().getCountry(sysUserData.Ethnicity).Country_ThaiName;
string religion = new Religion().getReligion(sysuserData2.ReligionCode).Religion_ThaiName;
string birth_day = new TQF.TQFUtility().getThaiBirthDay(sysUserData.BirthDay);
string nation_id = sysUserData.IdCode;
string issue_by = sysuserData2.IdIssuePlace;
string issue_date = new TQF.TQFUtility().getThaiBirthDay(sysuserData2.IdDateIssue);
string expire_date = new TQF.TQFUtility().getThaiBirthDay(sysuserData2.IdIssueExpire);
string license_id = "";
string license_issue_by = "";
string license_issue_date = "";
string license_expire_date = "";
string home_address = sysUserData.HomeNumber;
string home_moo = sysUserData.HomeMoo;
string home_vilage_building = sysUserData.HomeBuilding + " " + sysUserData.HomeVillage;
string home_soi = sysUserData.HomeSoi;
string home_road = sysUserData.HomeRoad;
string home_tumbol = new SubDistrict().getSUBDistrict(sysUserData.HomeTumbol).SubDistrict_ThaiName;
string home_amphur = new District().getDistrict(sysUserData.HomeAmphur).District_ThaiName;
string home_provice = new Province().getProvince(sysUserData.HomeProvince).Province_ThaiName;
string home_phone = sysuserData2.Telephone;
string home_mobile = sysUserData.MobileNumber;
string work_address = sysUserData.OfficeNumber + " " + sysUserData.OfficeName + sysUserData.OfficeMoo + " " + sysUserData.OfficeVillage + " " + sysUserData.OfficeBuilding + " " + sysUserData.OfficeSoi + " " + sysUserData.OfficeRoad + " " + new SubDistrict().getSUBDistrict(sysUserData.OfficeTumbol).SubDistrict_ThaiName + " " + new District().getDistrict(sysUserData.OfficeAmphur).District_ThaiName + " " + new TQF.Province().getProvince(sysUserData.OfficeProvince).ProvinceThai;
string email = sysUserData.Email;
List <QualificationDetail> qualificationDetail = new List <QualificationDetail>();
string sql = "Select * From QUALIFICATIONDETAIL Where LECTIDENTITY='" + code + "' Order by YEAR";
qualificationDetail = new QualificationDetail().getQualificationDetailManual(sql);
List <LecturerSholarship> lecturerSholarship = new List <LecturerSholarship>();
string sql2 = "Select * From LECTURERSHOLARSHIP Where LECTIDENTITY='" + code + "' Order by SCHOLARYEAR";
lecturerSholarship = new LecturerSholarship().getLecturerSholarshipManual(sql2);
if (sysuserData2.LicenseId.Length > 0)
{
license_id = sysuserData2.LicenseId;
license_issue_by = sysuserData2.LicenseIssuePlace;
license_issue_date = new TQF.TQFUtility().getThaiBirthDay(sysuserData2.LicensDateIssue);
license_expire_date = new TQF.TQFUtility().getThaiBirthDay(sysuserData2.LicenseIssueExpire);
}
pdfReport objPdf = new pdfReport();
Document doc = new Document(PageSize.A4, 0, 0, 30, 0);
MemoryStream memoryStream = new MemoryStream();
PdfWriter writer = PdfWriter.GetInstance(doc, memoryStream);
doc.Open();
// =============== Page 1 ==========
PdfPTable tableH = new PdfPTable(3);
tableH.DefaultCell.Border = 0;
tableH.DefaultCell.HorizontalAlignment = 1;
float[] widthsHead = new float[] { 1f, 5f, 1f };
tableH.SetWidths(widthsHead);
iTextSharp.text.Image logo = iTextSharp.text.Image.GetInstance(System.Web.HttpContext.Current.Server.MapPath("../img/logo_lecturer_form.png"));
logo.ScaleAbsolute(80f, 90f);
PdfPCell cell_logo = new PdfPCell(logo);
cell_logo.Border = 0;
cell_logo.HorizontalAlignment = Element.ALIGN_LEFT;
cell_logo.VerticalAlignment = 1;
cell_logo.Rowspan = 3;
iTextSharp.text.Image picturer = iTextSharp.text.Image.GetInstance(System.Web.HttpContext.Current.Server.MapPath("../img/pic-1inch.png"));
picturer.ScaleAbsolute(80f, 90f);
PdfPCell cell_picturer = new PdfPCell(picturer);
cell_picturer.Border = 0;
cell_picturer.HorizontalAlignment = Element.ALIGN_RIGHT;
cell_picturer.VerticalAlignment = 1;
cell_picturer.Rowspan = 3;
tableH.AddCell(new PdfPCell(cell_logo));
tableH.AddCell(new Phrase("แบบฟอร์มข้อมูลอาจารย์พิเศษ", objPdf.bold_font));
tableH.AddCell(new PdfPCell(cell_picturer));
tableH.AddCell(new Phrase("คณะสถาปัตยกรรมและการออกแบบ", objPdf.bold_font));
tableH.AddCell(new Phrase("มหาวิทยาลัยเทคโนโลยีพระจอมเกล้าพระนครเหนือ", objPdf.bold_font));
doc.Add(tableH);
PdfPTable tableBlank = new PdfPTable(1);
tableBlank.DefaultCell.Border = 0;
tableBlank.AddCell(new Phrase(".", objPdf.white_font));
doc.Add(tableBlank);
PdfPTable tableProfile = new PdfPTable(2);
tableProfile.DefaultCell.Border = 0;
tableProfile.DefaultCell.HorizontalAlignment = Element.ALIGN_LEFT;
float[] widthsProfile = new float[] { 0.3f, 6.7f };
tableProfile.SetWidths(widthsProfile);
tableProfile.AddCell(new Phrase("1.", objPdf.small_font));
tableProfile.AddCell(new Phrase("ชื่อ " + prefix + thai_name + " นามสกุล " + thai_surname, objPdf.small_font));
tableProfile.AddCell(new Phrase(".", objPdf.white_font));
tableProfile.AddCell(new Phrase("ตำแหน่งทางวิชาการ " + academic_position, objPdf.small_font));
tableProfile.AddCell(new Phrase(".", objPdf.white_font));
PdfPTable tb1 = new PdfPTable(3);
tb1.DefaultCell.Border = 0;
tb1.SetWidths(new float[] { 1, 1, 1 });
tb1.AddCell(new Phrase("สัญชาติ " + nationality, objPdf.small_font));
tb1.AddCell(new Phrase("เชื้อชาติ " + ethnicity, objPdf.small_font));
tb1.AddCell(new Phrase("ศาสนา " + religion, objPdf.small_font));
tableProfile.AddCell(tb1);
// tableProfile.AddCell(new Phrase("สัญชาติ " + nationality + " เชื้อชาติ " + ethnicity + " ศาสนา " + religion, objPdf.small_font));
tableProfile.AddCell(new Phrase("2.", objPdf.small_font));
tableProfile.AddCell(new Phrase("เกิดวันที่ " + birth_day, objPdf.small_font));
tableProfile.AddCell(new Phrase("3.", objPdf.small_font));
tableProfile.AddCell(new Phrase("บัตรประจำตัวประชาชนเลขที่ " + nation_id, objPdf.small_font));
tableProfile.AddCell(new Phrase(".", objPdf.white_font));
PdfPTable tb2 = new PdfPTable(3);
tb2.DefaultCell.Border = 0;
tb2.SetWidths(new float[] { 1, 1, 1 });
tb2.AddCell(new Phrase("ออกโดย " + issue_by, objPdf.small_font));
tb2.AddCell(new Phrase("วันที่ออกบัตร " + issue_date, objPdf.small_font));
tb2.AddCell(new Phrase("วันที่หมดอายุ " + expire_date, objPdf.small_font));
tableProfile.AddCell(tb2);
//tableProfile.AddCell(new Phrase("ออกโดย " + issue_by + " วันที่ออกบัตร " + issue_date + " วันที่หมดอายุ " + expire_date, objPdf.small_font));
tableProfile.AddCell(new Phrase("4.", objPdf.small_font));
tableProfile.AddCell(new Phrase("ใบอนุญาตประกอบวิชาชีพเลขที่ (ถ้ามี) " + license_id, objPdf.small_font));
tableProfile.AddCell(new Phrase(".", objPdf.white_font));
PdfPTable tb3 = new PdfPTable(3);
tb3.DefaultCell.Border = 0;
tb3.SetWidths(new float[] { 1, 1, 1 });
tb3.AddCell(new Phrase("ออกโดย " + license_issue_by, objPdf.small_font));
tb3.AddCell(new Phrase("วันที่ออกบัตร " + license_issue_date, objPdf.small_font));
tb3.AddCell(new Phrase("วันที่หมดอายุ " + license_expire_date, objPdf.small_font));
tableProfile.AddCell(tb3);
//tableProfile.AddCell(new Phrase("ออกโดย " + license_issue_by + " วันที่ออกบัตร " + license_issue_date + " วันที่หมดอายุ " + license_expire_date, objPdf.small_font));
tableProfile.AddCell(new Phrase("5.", objPdf.small_font));
tableProfile.AddCell(new Phrase("ที่อยู่ปัจจุบันบ้านเลขที่ " + home_address + " หมู่ที่/หมู่บ้าน " + home_moo + " " + home_vilage_building + " ซอย " + home_soi, objPdf.small_font));
tableProfile.AddCell(new Phrase(".", objPdf.white_font));
PdfPTable tb4 = new PdfPTable(3);
tb4.DefaultCell.Border = 0;
tb4.SetWidths(new float[] { 1, 1, 1 });
tb4.AddCell(new Phrase("ถนน " + home_road, objPdf.small_font));
tb4.AddCell(new Phrase("ตำบล/แขวง " + home_tumbol, objPdf.small_font));
tb4.AddCell(new Phrase("อำเภอ/เขต " + home_amphur, objPdf.small_font));
tableProfile.AddCell(tb4);
//tableProfile.AddCell(new Phrase("ถนน " + home_road + " ตำบล/แขวง " + home_tumbol + " อำเภอ/เขต " + home_amphur, objPdf.small_font));
tableProfile.AddCell(new Phrase(".", objPdf.white_font));
PdfPTable tb5 = new PdfPTable(3);
tb5.DefaultCell.Border = 0;
tb5.SetWidths(new float[] { 1, 1, 1 });
tb5.AddCell(new Phrase("จังหวัด " + home_provice, objPdf.small_font));
tb5.AddCell(new Phrase("เบอร์โทรศัพท์ " + home_phone, objPdf.small_font));
tb5.AddCell(new Phrase("มือถือ " + home_mobile, objPdf.small_font));
tableProfile.AddCell(tb5);
//tableProfile.AddCell(new Phrase("จังหวัด " + home_provice + " เบอร์โทรศัพท์ " + home_phone + " มือถือ " + home_mobile, objPdf.small_font));
tableProfile.AddCell(new Phrase(".", objPdf.white_font));
tableProfile.AddCell(new Phrase("สถานที่ทำงาน " + work_address, objPdf.small_font));
tableProfile.AddCell(new Phrase("6.", objPdf.small_font));
tableProfile.AddCell(new Phrase("E-mail address " + email, objPdf.small_font));
doc.Add(tableProfile);
doc.Add(tableBlank);
PdfPTable tablePreHis = new PdfPTable(2);
tablePreHis.DefaultCell.Border = 0;
tablePreHis.DefaultCell.HorizontalAlignment = Element.ALIGN_LEFT;
tablePreHis.DefaultCell.PaddingBottom = 5;
float[] widthsPreHis = new float[] { 0.3f, 6.7f };
tablePreHis.SetWidths(widthsPreHis);
tablePreHis.AddCell(new Phrase("7.", objPdf.small_font));
tablePreHis.AddCell(new Phrase("ประวัติการศึกษา (ระดับมัธยมศึกษาตอนปลาย ถึง อุดมศึกษา)", objPdf.small_font));
doc.Add(tablePreHis);
PdfPTable tableHis = new PdfPTable(5);
tableHis.DefaultCell.Border = Rectangle.BOX;
tableHis.DefaultCell.HorizontalAlignment = Element.ALIGN_CENTER;
tableHis.DefaultCell.VerticalAlignment = Element.ALIGN_MIDDLE;
tableHis.DefaultCell.PaddingBottom = 5;
float[] widthHis = new float[] { 1f, 2.2f, 1.3f, 2f, 0.5f };
tableHis.SetWidths(widthHis);
tableHis.AddCell(new Phrase("ปี พ.ศ.", objPdf.small_bold_font));
tableHis.AddCell(new Phrase("ชื่อสถาบันที่ศึกษา", objPdf.small_bold_font));
tableHis.AddCell(new Phrase("จังหวัด/ประเทศ", objPdf.small_bold_font));
tableHis.AddCell(new Phrase("ชื่อประกาศนียบัตร/ปริญญา", objPdf.small_bold_font));
tableHis.AddCell(new Phrase("G.P.A.", objPdf.small_bold_font));
foreach (QualificationDetail item in qualificationDetail)
{
string province = "";
if (item.Province_Code == "00")
{
province = item.Province_Other + Environment.NewLine + new Country().getCountry(item.Country_Code).Country_ThaiName;
}
else
{
province = new Province().getProvince(item.Province_Code).Province_ThaiName + Environment.NewLine + new Country().getCountry(item.Country_Code).Country_ThaiName;
}
tableHis.AddCell(new Phrase(item.Year, objPdf.small_font));
tableHis.AddCell(new PdfPCell(new Phrase(item.Academy, objPdf.small_font))
{
HorizontalAlignment = Element.ALIGN_LEFT, VerticalAlignment = Element.ALIGN_MIDDLE, PaddingBottom = 5
});
tableHis.AddCell(new Phrase(province, objPdf.small_font));
tableHis.AddCell(new Phrase(item.QualificationDegree + Environment.NewLine + item.Division, objPdf.small_font));
tableHis.AddCell(new Phrase(item.gpa, objPdf.small_font));
}
doc.Add(tableHis);
doc.Add(tableBlank);
PdfPTable tablePreScholar = new PdfPTable(2);
tablePreScholar.DefaultCell.Border = 0;
tablePreScholar.DefaultCell.HorizontalAlignment = Element.ALIGN_LEFT;
tablePreScholar.DefaultCell.PaddingBottom = 5;
float[] widthsPreScholar = new float[] { 0.3f, 6.7f };
tablePreScholar.SetWidths(widthsPreScholar);
tablePreScholar.AddCell(new Phrase("8.", objPdf.small_font));
tablePreScholar.AddCell(new Phrase("เคยได้รับทุนการศึกษา", objPdf.small_font));
doc.Add(tablePreScholar);
PdfPTable tableScholar = new PdfPTable(3);
tableScholar.DefaultCell.Border = Rectangle.BOX;
tableScholar.DefaultCell.HorizontalAlignment = Element.ALIGN_CENTER;
tableScholar.DefaultCell.VerticalAlignment = Element.ALIGN_MIDDLE;
tableScholar.DefaultCell.PaddingBottom = 5;
float[] widthScholar = new float[] { 1f, 3.5f, 2.5f };
tableScholar.SetWidths(widthScholar);
tableScholar.AddCell(new Phrase("ปี พ.ศ.", objPdf.small_bold_font));
tableScholar.AddCell(new Phrase("ชื่อทุน", objPdf.small_bold_font));
tableScholar.AddCell(new Phrase("วัตถุประสงค์/กิจกรรม", objPdf.small_bold_font));
int row_sch = 3 - lecturerSholarship.Count;
foreach (LecturerSholarship item in lecturerSholarship)
{
tableScholar.AddCell(new Phrase(item.ScholarYear, objPdf.small_font));
tableScholar.AddCell(new PdfPCell(new Phrase(item.ScholarName, objPdf.small_font))
{
HorizontalAlignment = Element.ALIGN_LEFT, VerticalAlignment = Element.ALIGN_MIDDLE, PaddingBottom = 5
});
tableScholar.AddCell(new PdfPCell(new Phrase(item.ScholarPurpose, objPdf.small_font))
{
HorizontalAlignment = Element.ALIGN_LEFT, VerticalAlignment = Element.ALIGN_MIDDLE, PaddingBottom = 5
});
}
for (int i = 0; i < row_sch; i++)
{
tableScholar.AddCell(new Phrase(" ", objPdf.small_font));
tableScholar.AddCell(new Phrase(" ", objPdf.small_font));
tableScholar.AddCell(new Phrase(" ", objPdf.small_font));
}
doc.Add(tableScholar);
// =============== Page 2 ==========
doc.NewPage();
PdfPTable tablePreWork = new PdfPTable(2);
tablePreWork.DefaultCell.Border = 0;
tablePreWork.DefaultCell.HorizontalAlignment = Element.ALIGN_LEFT;
tablePreWork.DefaultCell.PaddingBottom = 5;
float[] widthsPreWork = new float[] { 0.3f, 6.7f };
tablePreWork.SetWidths(widthsPreWork);
tablePreWork.AddCell(new Phrase("9.", objPdf.small_font));
tablePreWork.AddCell(new Phrase("ประสบการณ์ทำงาน", objPdf.small_font));
doc.Add(tablePreWork);
PdfPTable tablePreWork1 = new PdfPTable(2);
tablePreWork1.DefaultCell.Border = 0;
tablePreWork1.DefaultCell.HorizontalAlignment = Element.ALIGN_LEFT;
tablePreWork1.DefaultCell.PaddingBottom = 5;
float[] widthsPreWork1 = new float[] { 0.7f, 6.3f };
tablePreWork1.SetWidths(widthsPreWork1);
tablePreWork1.AddCell(new PdfPCell(new Phrase("9.1", objPdf.small_font))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
tablePreWork1.AddCell(new Phrase("ประสบการณ์ในการทำงานหรือการสอน", objPdf.small_font));
doc.Add(tablePreWork1);
PdfPTable tableWork = new PdfPTable(4);
tableWork.DefaultCell.Border = Rectangle.BOX;
tableWork.DefaultCell.HorizontalAlignment = Element.ALIGN_CENTER;
tableWork.DefaultCell.VerticalAlignment = Element.ALIGN_MIDDLE;
tableWork.DefaultCell.PaddingBottom = 5;
float[] widthWork = new float[] { 2.5f, 1.5f, 1.5f, 1.5f };
tableWork.SetWidths(widthWork);
tableWork.AddCell(new Phrase("บริษัท/ชื่อวิชาที่สอน", objPdf.small_bold_font));
tableWork.AddCell(new Phrase("ลักษณะงาน (อ.ประจำ/อ.พิเศษ)", objPdf.small_bold_font));
tableWork.AddCell(new Phrase("ปีที่เริ่ม - สิ้นสุด", objPdf.small_bold_font));
tableWork.AddCell(new Phrase("สาเหตุที่ออก", objPdf.small_bold_font));
List <LecturerExprience> exprience_data = new List <LecturerExprience>();
string exprience_sql = "Select * From LECTUREREXPRIENCE Where LECTIDENTITY='" + code + "' Order by BEGINYEAR";
exprience_data = new LecturerExprience().getLecturerExprienceManual(exprience_sql);
int row_work = 3 - exprience_data.Count;
foreach (LecturerExprience item in exprience_data)
{
tableWork.AddCell(new PdfPCell(new Phrase(item.SubjectName, objPdf.small_font))
{
HorizontalAlignment = Element.ALIGN_LEFT, VerticalAlignment = Element.ALIGN_MIDDLE, PaddingBottom = 5
});
tableWork.AddCell(new PdfPCell(new Phrase(item.LecturerType, objPdf.small_font))
{
HorizontalAlignment = Element.ALIGN_LEFT, VerticalAlignment = Element.ALIGN_MIDDLE, PaddingBottom = 5
});
tableWork.AddCell(new Phrase(item.BeginYear + " - " + item.EndYear, objPdf.small_font));
tableWork.AddCell(new PdfPCell(new Phrase(item.QuitIssue, objPdf.small_font))
{
HorizontalAlignment = Element.ALIGN_LEFT, VerticalAlignment = Element.ALIGN_MIDDLE, PaddingBottom = 5
});
}
for (int i = 0; i < row_work; i++)
{
tableWork.AddCell(new Phrase(" ", objPdf.small_font));
tableWork.AddCell(new Phrase(" ", objPdf.small_font));
tableWork.AddCell(new Phrase(" ", objPdf.small_font));
tableWork.AddCell(new Phrase(" ", objPdf.small_font));
}
doc.Add(tableWork);
doc.Add(tableBlank);
PdfPTable tablePreResearch = new PdfPTable(2);
tablePreResearch.DefaultCell.Border = 0;
tablePreResearch.DefaultCell.HorizontalAlignment = Element.ALIGN_LEFT;
tablePreResearch.DefaultCell.PaddingBottom = 5;
float[] widthsResearch = new float[] { 0.7f, 6.3f };
tablePreResearch.SetWidths(widthsResearch);
tablePreResearch.AddCell(new PdfPCell(new Phrase("9.2", objPdf.small_font))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
tablePreResearch.AddCell(new Phrase("ประสบการณ์ในการวิจัย/บทความวิชาการ/งานสร้างสรรค์", objPdf.small_font));
doc.Add(tablePreResearch);
PdfPTable tableResearch = new PdfPTable(4);
tableResearch.DefaultCell.Border = Rectangle.BOX;
tableResearch.DefaultCell.HorizontalAlignment = Element.ALIGN_CENTER;
tableResearch.DefaultCell.VerticalAlignment = Element.ALIGN_MIDDLE;
tableResearch.DefaultCell.PaddingBottom = 5;
float[] widthResearch = new float[] { 1f, 3f, 1.5f, 1.5f };
tableResearch.SetWidths(widthResearch);
tableResearch.AddCell(new Phrase("ปี พ.ศ.", objPdf.small_bold_font));
tableResearch.AddCell(new Phrase("ชื่อผลงาน", objPdf.small_bold_font));
tableResearch.AddCell(new Phrase("ประเภท", objPdf.small_bold_font));
tableResearch.AddCell(new Phrase("ตีพิมพ์ในวารสาร", objPdf.small_bold_font));
List <LecturerPublication> research_data = new List <LecturerPublication>();
string research_sql = "Select * From LECTURERPUBLICATION Where LECTIDENTITY='" + code + "' Order by PUBLISHEDYEAR";
research_data = new LecturerPublication().getLecturerPublicationManual(research_sql);
int row_research = 3 - research_data.Count;
foreach (LecturerPublication item in research_data)
{
tableResearch.AddCell(new Phrase(item.PublishedYear, objPdf.small_font));
tableResearch.AddCell(new PdfPCell(new Phrase(item.PublicationName, objPdf.small_font))
{
HorizontalAlignment = Element.ALIGN_LEFT, VerticalAlignment = Element.ALIGN_MIDDLE, PaddingBottom = 5
});
tableResearch.AddCell(new Phrase(item.PublicationType, objPdf.small_font));
tableResearch.AddCell(new Phrase(item.Ppoceeding, objPdf.small_font));
}
for (int i = 0; i < row_research; i++)
{
tableResearch.AddCell(new Phrase(" ", objPdf.small_font));
tableResearch.AddCell(new Phrase(" ", objPdf.small_font));
tableResearch.AddCell(new Phrase(" ", objPdf.small_font));
tableResearch.AddCell(new Phrase(" ", objPdf.small_font));
}
doc.Add(tableResearch);
doc.Add(tableBlank);
PdfPTable tablePreBook = new PdfPTable(2);
tablePreBook.DefaultCell.Border = 0;
tablePreBook.DefaultCell.HorizontalAlignment = Element.ALIGN_LEFT;
tablePreBook.DefaultCell.PaddingBottom = 5;
float[] widthsBook = new float[] { 0.7f, 6.3f };
tablePreBook.SetWidths(widthsBook);
tablePreBook.AddCell(new PdfPCell(new Phrase("9.3", objPdf.small_font))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
tablePreBook.AddCell(new Phrase("เอกสารตำรา/หนังสือ", objPdf.small_font));
doc.Add(tablePreBook);
PdfPTable tableBook = new PdfPTable(3);
tableBook.DefaultCell.Border = Rectangle.BOX;
tableBook.DefaultCell.HorizontalAlignment = Element.ALIGN_CENTER;
tableBook.DefaultCell.VerticalAlignment = Element.ALIGN_MIDDLE;
tableBook.DefaultCell.PaddingBottom = 5;
float[] widthBook = new float[] { 4f, 1.5f, 1.5f };
tableBook.SetWidths(widthBook);
tableBook.AddCell(new Phrase("ชื่อตำรา/หนังสือ", objPdf.small_bold_font));
tableBook.AddCell(new Phrase("ปีที่ตีพิมพ์", objPdf.small_bold_font));
tableBook.AddCell(new Phrase("สำนักพิมพ์", objPdf.small_bold_font));
List <LecturerBook> book_data = new List <LecturerBook>();
string sql_book = "Select * From LECTURERBOOK Where LECTIDENTITY='" + code + "' Order by PUBLISHEDYEAR";
book_data = new LecturerBook().getLecturerBookManual(sql_book);
int row_book = 3 - book_data.Count;
foreach (LecturerBook item in book_data)
{
tableBook.AddCell(new PdfPCell(new Phrase(item.BookName, objPdf.small_font))
{
HorizontalAlignment = Element.ALIGN_LEFT, VerticalAlignment = Element.ALIGN_MIDDLE, PaddingBottom = 5
});
tableBook.AddCell(new Phrase(item.PublishedYear, objPdf.small_font));
tableBook.AddCell(new Phrase(item.Publisher, objPdf.small_font));
}
for (int i = 0; i < row_book; i++)
{
tableBook.AddCell(new Phrase(" ", objPdf.small_font));
tableBook.AddCell(new Phrase(" ", objPdf.small_font));
tableBook.AddCell(new Phrase(" ", objPdf.small_font));
}
doc.Add(tableBook);
// =============== Page 3 ==========
doc.NewPage();
string bank_account_name = sysuserData2.BankAccountName;
string bank_branch = sysuserData2.BankBranch;
string bank_account_num = sysuserData2.BankAccountNumber;
PdfPTable tablePreBankAcc = new PdfPTable(2);
tablePreBankAcc.DefaultCell.Border = 0;
tablePreBankAcc.DefaultCell.HorizontalAlignment = Element.ALIGN_LEFT;
tablePreBankAcc.DefaultCell.PaddingBottom = 5;
float[] widthsBankAcc = new float[] { 0.3f, 6.7f };
tablePreBankAcc.SetWidths(widthsBankAcc);
tablePreBankAcc.AddCell(new Phrase("10.", objPdf.small_font));
tablePreBankAcc.AddCell(new Phrase("ข้าพเจ้ายินดีที่จะปฏิบัติตามแนวทางที่คณะสถาปัตยากรรมและการออกแบบกำหนดไว้ดังต่อไปนี้", objPdf.small_font));
doc.Add(tablePreBankAcc);
PdfPTable tablePreBankAcc1 = new PdfPTable(2);
tablePreBankAcc1.DefaultCell.Border = 0;
tablePreBankAcc1.DefaultCell.HorizontalAlignment = Element.ALIGN_LEFT;
tablePreBankAcc1.DefaultCell.PaddingBottom = 5;
float[] widthsPreBankAcc1 = new float[] { 0.7f, 6.3f };
tablePreBankAcc1.SetWidths(widthsPreBankAcc1);
tablePreBankAcc1.AddCell(new PdfPCell(new Phrase("10.1)", objPdf.small_font))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
Phrase acc1 = new Phrase();
acc1.Add(new Phrase("เปิดบัญชีธนาคารกรุงเทพ จำกัด (มหาชน) เพื่อรับค่าสอนโดยโอนเงินเข้า ชื่อบัญชี ", objPdf.small_font));
acc1.Add(new Phrase(bank_account_name, objPdf.small_bold_font));
tablePreBankAcc1.AddCell(acc1);
doc.Add(tablePreBankAcc1);
PdfPTable tablePreBankAcc2 = new PdfPTable(2);
tablePreBankAcc2.DefaultCell.Border = 0;
tablePreBankAcc2.DefaultCell.HorizontalAlignment = Element.ALIGN_LEFT;
tablePreBankAcc2.DefaultCell.PaddingBottom = 5;
float[] widthsPreBankAcc2 = new float[] { 1f, 1f };
tablePreBankAcc2.SetWidths(widthsPreBankAcc2);
Phrase acc2 = new Phrase();
acc2.Add(new Phrase("สาขา ", objPdf.small_font));
acc2.Add(new Phrase(bank_branch, objPdf.small_bold_font));
tablePreBankAcc2.AddCell(acc2);
Phrase acc3 = new Phrase();
acc3.Add(new Phrase("เลขที่บัญชี ", objPdf.small_font));
acc3.Add(new Phrase(bank_account_num, objPdf.small_bold_font));
tablePreBankAcc2.AddCell(acc3);
doc.Add(tablePreBankAcc2);
PdfPTable tablePreBankAcc3 = new PdfPTable(2);
tablePreBankAcc3.DefaultCell.Border = 0;
tablePreBankAcc3.DefaultCell.HorizontalAlignment = Element.ALIGN_LEFT;
tablePreBankAcc3.DefaultCell.PaddingBottom = 5;
float[] widthsPreBankAcc3 = new float[] { 0.7f, 6.3f };
tablePreBankAcc3.SetWidths(widthsPreBankAcc3);
tablePreBankAcc3.AddCell(new PdfPCell(new Phrase("10.2)", objPdf.small_font))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
tablePreBankAcc3.AddCell(new Phrase("จัดส่ง มคอ.3 และ มคอ.5 ตามวันและเวลาที่งานวิชาการกำหนด เพื่อเป็นไปตามกฎเกณฑ์มาตราฐานการประกัน", objPdf.small_font));
doc.Add(tablePreBankAcc3);
PdfPTable tablePreBankAcc3_1 = new PdfPTable(1);
tablePreBankAcc3_1.DefaultCell.Border = 0;
tablePreBankAcc3_1.DefaultCell.HorizontalAlignment = Element.ALIGN_LEFT;
tablePreBankAcc3_1.DefaultCell.PaddingBottom = 5;
float[] widthsPreBankAcc3_1 = new float[] { 1f };
tablePreBankAcc3_1.SetWidths(widthsPreBankAcc3_1);
tablePreBankAcc3_1.AddCell(new Phrase("คุณภาพการศึกษาภายใน ตามที่สำนักงานคณะกรรมการการอุดมศึกษากำหนด", objPdf.small_font));
doc.Add(tablePreBankAcc3_1);
PdfPTable tablePreBankAcc4 = new PdfPTable(2);
tablePreBankAcc4.DefaultCell.Border = 0;
tablePreBankAcc4.DefaultCell.HorizontalAlignment = Element.ALIGN_LEFT;
tablePreBankAcc4.DefaultCell.PaddingBottom = 5;
float[] widthsPreBankAcc4 = new float[] { 0.7f, 6.3f };
tablePreBankAcc4.SetWidths(widthsPreBankAcc4);
tablePreBankAcc4.AddCell(new PdfPCell(new Phrase("10.3)", objPdf.small_font))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
tablePreBankAcc4.AddCell(new Phrase("จัดส่งคะแนนสอบกลางภาคและปลายภาคได้ตามวันและเวลาที่งานวิชาการกำหนด", objPdf.small_font));
doc.Add(tablePreBankAcc4);
PdfPTable tablePreBankAcc5 = new PdfPTable(2);
tablePreBankAcc5.DefaultCell.Border = 0;
tablePreBankAcc5.DefaultCell.HorizontalAlignment = Element.ALIGN_LEFT;
tablePreBankAcc5.DefaultCell.PaddingBottom = 5;
float[] widthsPreBankAcc5 = new float[] { 0.7f, 6.3f };
tablePreBankAcc5.SetWidths(widthsPreBankAcc5);
tablePreBankAcc5.AddCell(new PdfPCell(new Phrase("10.4)", objPdf.small_font))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
tablePreBankAcc5.AddCell(new Phrase("ร่วมเป็นคณะกรรมการคุมสอบในรายวิชาทฤษฎีและประลองทั้งกลางภาคและปลายภาค ในกรณีวิชาที่รับผิดชอบ", objPdf.small_font));
doc.Add(tablePreBankAcc5);
PdfPTable tablePreBankAcc5_1 = new PdfPTable(1);
tablePreBankAcc5_1.DefaultCell.Border = 0;
tablePreBankAcc5_1.DefaultCell.HorizontalAlignment = Element.ALIGN_LEFT;
tablePreBankAcc5_1.DefaultCell.PaddingBottom = 5;
float[] widthsPreBankAcc5_1 = new float[] { 1f };
tablePreBankAcc5_1.SetWidths(widthsPreBankAcc5_1);
tablePreBankAcc5_1.AddCell(new Phrase("มีการสอบ โดยงานวิชาการจะจัดให้คุมสอบตามวันเวลาที่ดำเนินการสอน ทั้งนี้สัปดาห์ที่สอบจะไม่มีการเรียนการสอน", objPdf.small_font));
doc.Add(tablePreBankAcc5_1);
doc.Add(tableBlank);
PdfPTable tablePreAttach = new PdfPTable(2);
tablePreAttach.DefaultCell.Border = 0;
tablePreAttach.DefaultCell.HorizontalAlignment = Element.ALIGN_LEFT;
tablePreAttach.DefaultCell.PaddingBottom = 5;
float[] widthsAttach = new float[] { 0.3f, 6.7f };
tablePreAttach.SetWidths(widthsAttach);
var uncheck_box = new Chunk("o", objPdf.wingding_font16);
char ch = (char)254;
var check_box = new Chunk(ch, objPdf.wingding_font16);
tablePreAttach.AddCell(new Phrase("11.", objPdf.small_font));
tablePreAttach.AddCell(new Phrase("ข้าพเจ้าได้แนบหลักฐาน/เอกสารที่เกี่ยวข้องดังรายการต่อไปนี้", objPdf.small_font));
doc.Add(tablePreAttach);
PdfPTable tableAttach1 = new PdfPTable(2);
tableAttach1.DefaultCell.Border = 0;
tableAttach1.DefaultCell.HorizontalAlignment = Element.ALIGN_LEFT;
tableAttach1.DefaultCell.PaddingBottom = 5;
float[] widthsAttach1 = new float[] { 0.7f, 6.3f };
tableAttach1.SetWidths(widthsAttach1);
LecturerEvidence attach = new LecturerEvidence().getLecturerEvidence(sysUserData.IdCode);
if (attach.Evidence1 == "Y")
{
tableAttach1.AddCell(new PdfPCell(new Phrase(check_box))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
}
else
{
tableAttach1.AddCell(new PdfPCell(new Phrase(uncheck_box))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
}
tableAttach1.AddCell(new Phrase("สำเนาใบปริญญาบัตร 1 ฉบับ (ของทุกระดับที่สำเร็จการศึกษา)", objPdf.small_font));
if (attach.Evidence2 == "Y")
{
tableAttach1.AddCell(new PdfPCell(new Phrase(check_box))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
}
else
{
tableAttach1.AddCell(new PdfPCell(new Phrase(uncheck_box))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
}
tableAttach1.AddCell(new Phrase("สำเนา Transcript 1 ฉบับ (ของทุกระดับที่สำเร็จการศึกษา)", objPdf.small_font));
if (attach.Evidence3 == "Y")
{
tableAttach1.AddCell(new PdfPCell(new Phrase(check_box))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
}
else
{
tableAttach1.AddCell(new PdfPCell(new Phrase(uncheck_box))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
}
tableAttach1.AddCell(new Phrase("รูปถ่ายหน้าตรง 1 นิ้ว ไม่สวมหมวก ไม่ใส่แว่นตาดำ ถ่ายมาแล้วไม่เกิน 1 ปี (ติดที่แบบฟอร์ม)", objPdf.small_font));
if (attach.Evidence4 == "Y")
{
tableAttach1.AddCell(new PdfPCell(new Phrase(check_box))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
}
else
{
tableAttach1.AddCell(new PdfPCell(new Phrase(uncheck_box))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
}
tableAttach1.AddCell(new Phrase("สำเนาบัตรประจำตัวประชาชน หรือสำเนาบัตรประจำตัวข้าราชการ/พนักงานมหาวิทยาลัย 1 ฉบับ", objPdf.small_font));
if (attach.Evidence5 == "Y")
{
tableAttach1.AddCell(new PdfPCell(new Phrase(check_box))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
}
else
{
tableAttach1.AddCell(new PdfPCell(new Phrase(uncheck_box))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
}
tableAttach1.AddCell(new Phrase("สำเนาทะเบียนบ้าน 1 ฉบับ", objPdf.small_font));
if (attach.Evidence6 == "Y")
{
tableAttach1.AddCell(new PdfPCell(new Phrase(check_box))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
}
else
{
tableAttach1.AddCell(new PdfPCell(new Phrase(uncheck_box))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
}
tableAttach1.AddCell(new Phrase("สำเนาสมุดบัญชี (เฉพาะหน้าแรก) ธนาคารกรุงเทพ 1 ฉบับ", objPdf.small_font));
if (attach.Evidence7 == "Y")
{
tableAttach1.AddCell(new PdfPCell(new Phrase(check_box))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
}
else
{
tableAttach1.AddCell(new PdfPCell(new Phrase(uncheck_box))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
}
tableAttach1.AddCell(new Phrase("สำเนาใบประกอบวิชาชีพ 1 ฉบับ (ถ้ามี)", objPdf.small_font));
if (attach.Evidence8 == "Y")
{
tableAttach1.AddCell(new PdfPCell(new Phrase(check_box))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
}
else
{
tableAttach1.AddCell(new PdfPCell(new Phrase(uncheck_box))
{
HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, PaddingBottom = 5
});
}
tableAttach1.AddCell(new Phrase("อื่น ๆ (กรณีมีเอกสารเพิ่มเติมจากที่กล่าวมา โปรดระบุ)...........................................................................................", objPdf.small_font));
doc.Add(tableAttach1);
doc.Add(tableBlank);
PdfPTable tableSign = new PdfPTable(1);
tableSign.DefaultCell.Border = 0;
tableSign.DefaultCell.HorizontalAlignment = Element.ALIGN_RIGHT;
tableSign.DefaultCell.PaddingBottom = 5;
float[] widthsSign = new float[] { 1f };
tableSign.SetWidths(widthsSign);
tableSign.AddCell(new Phrase("ขอรับรองว่าข้อความดังกล่าวข้างต้นเป็นความจริงทุกประการ", objPdf.small_font));
tableSign.AddCell(new Phrase(".", objPdf.white_font));
tableSign.AddCell(new Phrase(".", objPdf.white_font));
tableSign.AddCell(new Phrase("ลงชื่อผู้สมัคร...........................................................................", objPdf.small_font));
tableSign.AddCell(new Phrase("(.........................................................................)", objPdf.small_font));
tableSign.AddCell(new Phrase("วันที่....................../........................./.........................", objPdf.small_font));
doc.Add(tableSign);
// =================================
writer.CloseStream = false;
doc.Close();
memoryStream.Position = 0;
string pdfFile = "";
pdfFile = lectuere_id + "_" + DateTime.Now.ToString().Replace(" ", "_") + ".pdf";
objPdf.ExportPDF(Response, memoryStream, pdfFile);
}
protected void btnSHOW_Click(object sender, EventArgs e)
{
// Head Table
string[] ar = { "ชื่อ-นามสกุล", "ภาควิชา", "คณะ", "ดูรายละเอียด", "แก้ไข", "พิมพ์", "เอกสารแนบ" };
tblLecturer.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblLecturer.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);
}
tblLecturer.Rows.Add(tRowHead);
List <SysUser> lecturer = new List <SysUser>();
string sql = "Select * From SYSUSER Where FACULTYCODE='" + ddlCURR_FACULTY.SelectedValue + "' And DEPARTMENTCODE ='" + ddlCURR_DEPARTMENT.SelectedValue + "'";
lecturer = new SysUser().getSysUserManual(sql);
foreach (SysUser data in lecturer)
{
TableRow tRowBody = new TableRow();
tRowBody.TableSection = TableRowSection.TableBody;
PrefixData prefix = new Prefix().getPrefix(data.TitleNameCode);
TableCell cellName = new TableCell();
cellName.Text = prefix.Prefix_Thai + data.ThName + " " + data.ThSurName;
tRowBody.Cells.Add(cellName);
TableCell cellDivision = new TableCell();
cellDivision.Text = new Department().getDepartment(data.DepartmentCode).Department_Thai;
tRowBody.Cells.Add(cellDivision);
TableCell cellFaculty = new TableCell();
cellFaculty.Text = new Faculty().getFaculty(data.FacultyCode).Faculty_Thai;
tRowBody.Cells.Add(cellFaculty);
TableCell cellDetails = new TableCell();
//string urlDel = "#";
string urlDel = "detail_Lecturer.aspx?token=" + data.IdCode;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#detail_Lecturer");
hypDel.Attributes.Add("data-toggle", "modal");
hypDel.Text = "<h4><i class='fa fa-search'></i></h4>";
hypDel.NavigateUrl = urlDel;
hypDel.ToolTip = "Delete";
cellDetails.Controls.Add(hypDel);
cellDetails.CssClass = "text-center";
tRowBody.Cells.Add(cellDetails);
TableCell cellEdit = new TableCell();
// วิชาการคณะ
if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
{
bool editable = false;
List <string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty);
foreach (string fac in faculty_authorized)
{
if (fac == data.FacultyCode)
{
editable = true;
break;
}
}
if (editable == true)
{
string urlEdit = "editLecturer.aspx?token=" + data.IdCode;
HyperLink hypEdit = new HyperLink();
hypEdit.Text = "<h4><i class='fa fa-edit'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "Edit";
cellEdit.Controls.Add(hypEdit);
}
else
{
string urlEdit = "#";
HyperLink hypEdit = new HyperLink();
hypEdit.Text = "<h4><i class='fa fa-lock'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "ไม่สามารถแก้ไขได้";
cellEdit.Controls.Add(hypEdit);
}
}
// วิชาการภาค
else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
bool editable = false;
List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department);
foreach (string dep in department_authorized)
{
if (dep == data.DepartmentCode)
{
editable = true;
break;
}
}
if (editable == true)
{
string urlEdit = "editLecturer.aspx?token=" + data.IdCode;
HyperLink hypEdit = new HyperLink();
hypEdit.Text = "<h4><i class='fa fa-edit'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "Edit";
cellEdit.Controls.Add(hypEdit);
}
else
{
string urlEdit = "#";
HyperLink hypEdit = new HyperLink();
hypEdit.Text = "<h4><i class='fa fa-lock'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "ไม่สามารถแก้ไขได้";
cellEdit.Controls.Add(hypEdit);
}
}
else
{
string urlEdit = "#";
HyperLink hypEdit = new HyperLink();
hypEdit.Text = "<h4><i class='fa fa-lock'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "ไม่สามารถแก้ไขได้";
cellEdit.Controls.Add(hypEdit);
}
cellEdit.CssClass = "text-center";
tRowBody.Cells.Add(cellEdit);
TableCell cellPrint = new TableCell();
cellPrint.Text = "<a href=\"report_Lecturer.aspx?token=" + data.IdCode + "\" title=\"Save PDF\" target=\"_blank\"><img src=\"../img/icon_pdf.png\" style=\"padding-bottom:5px\"></a>";
//cellPrint.Text = "<a href=\"javascript:w=window.open('report_Lecturer.aspx'); w.print();\"><img src=\"../img/icon_pdf.png\" style=\"padding-bottom:5px\"></a>";
cellPrint.CssClass = "text-center";
tRowBody.Cells.Add(cellPrint);
string file = new LecturerEvidence().getLecturerEvidence(data.IdCode).AttatchName;
TableCell cellDocuments = new TableCell();
if (file == null)
{
string urlDoc = "#";
HyperLink hypDoc = new HyperLink();
hypDoc.Text = "<h4><i class='fa fa-lock'></i></h4>";
hypDoc.NavigateUrl = urlDoc;
hypDoc.ToolTip = "ไม่พบเอกสารแนบ";
cellDocuments.Controls.Add(hypDoc);
}
else
{
cellDocuments.Text = "<a href=\"./LecturerEvidenceUploadFolder/" + file + "\" title=\"Download\" target=\"_blank\"><img src=\"../img/Download_File.png\" style=\"height: 38px; width: 32px; padding-bottom:5px\"></a>";
}
cellDocuments.CssClass = "text-center";
tRowBody.Cells.Add(cellDocuments);
tblLecturer.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) || autro_obj.CheckGroupUser(login_data, group_var.lecturer))
{
// ======== Process ===========
if (!Page.IsPostBack)
{
//ลบ session ที่ใช้ในหน้า addLecturer.aspx.cs
Session.Remove("addQualification");
Session.Remove("SysUser");
//ลบ session ที่ใช้ในหน้า add_Qualification_Data.aspx.cs
Session.Remove("IdCode");
// Head Table
string[] ar = { "ชื่อ-นามสกุล", "ภาควิชา", "คณะ", "ดูรายละเอียด", "แก้ไข", "พิมพ์", "เอกสารแนบ" };
tblLecturer.Attributes.Add("class", "table table-bordered table-striped table-hover");
tblLecturer.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);
}
tblLecturer.Rows.Add(tRowHead);
List <SysUser> lecturer = new List <SysUser>();
//lecturer = new SysUser().getSysUser();
string sql = "Select * From SYSUSER Where FACULTYCODE = '11'";
lecturer = new SysUser().getSysUserManual(sql);
foreach (SysUser data in lecturer)
{
TableRow tRowBody = new TableRow();
tRowBody.TableSection = TableRowSection.TableBody;
PrefixData prefix = new Prefix().getPrefix(data.TitleNameCode);
TableCell cellName = new TableCell();
cellName.Text = prefix.Prefix_Thai + data.ThName + " " + data.ThSurName;
tRowBody.Cells.Add(cellName);
TableCell cellDivision = new TableCell();
cellDivision.Text = new Department().getDepartment(data.DepartmentCode).Department_Thai;
tRowBody.Cells.Add(cellDivision);
TableCell cellFaculty = new TableCell();
cellFaculty.Text = new Faculty().getFaculty(data.FacultyCode).Faculty_Thai;
tRowBody.Cells.Add(cellFaculty);
TableCell cellDetails = new TableCell();
//string urlDel = "#";
string urlDel = "detail_Lecturer.aspx?token=" + data.IdCode;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#detail_Lecturer");
hypDel.Attributes.Add("data-toggle", "modal");
hypDel.Text = "<h4><i class='fa fa-search'></i></h4>";
hypDel.NavigateUrl = urlDel;
hypDel.ToolTip = "Delete";
cellDetails.Controls.Add(hypDel);
cellDetails.CssClass = "text-center";
tRowBody.Cells.Add(cellDetails);
TableCell cellEdit = new TableCell();
TableCell cellPrint = new TableCell();
TableCell cellDocuments = new TableCell();
// อาจารย์
if (autro_obj.CheckGroupUser(login_data, group_var.lecturer))
{
bool editable = false;
if (login_data.Nation_ID == data.IdCode)
{
editable = true;
}
if (editable == true)
{
string urlEdit = "editLecturer.aspx?token=" + data.IdCode;
HyperLink hypEdit = new HyperLink();
hypEdit.Text = "<h4><i class='fa fa-edit'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "Edit";
cellEdit.Controls.Add(hypEdit);
cellPrint.Text = "<a href=\"report_Lecturer.aspx?token=" + data.IdCode + "\" title=\"Save PDF\" target=\"_blank\"><img src=\"../img/icon_pdf.png\" style=\"padding-bottom:5px\"></a>";
string file = new LecturerEvidence().getLecturerEvidence(data.IdCode).AttatchName;
long fileSizeInBytes = 0;
try
{
FileInfo fi = new FileInfo(Server.MapPath("./LecturerEvidenceUploadFolder/" + file));
fileSizeInBytes = fi.Length;
}
catch
{
fileSizeInBytes = 0;
}
if (fileSizeInBytes <= 0)
{
cellDocuments.Text = "-";
}
else
{
cellDocuments.Text = "<a href=\"./LecturerEvidenceUploadFolder/" + file + "\" title=\"Download\" target=\"_blank\"><img src=\"../img/Download_File.png\" style=\"height: 38px; width: 32px; padding-bottom:5px\"></a>";
}
}
else
{
string urlEdit = "#";
HyperLink hypEdit = new HyperLink();
hypEdit.Text = "<h4><i class='fa fa-lock'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "ไม่สามารถแก้ไขได้";
cellEdit.Controls.Add(hypEdit);
cellPrint.Text = "-";
cellDocuments.Text = "-";
}
}
// วิชาการคณะ
else if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
{
bool editable = false;
List <string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty);
foreach (string fac in faculty_authorized)
{
if (fac == data.FacultyCode)
{
editable = true;
break;
}
}
if (editable == true)
{
string urlEdit = "editLecturer.aspx?token=" + data.IdCode;
HyperLink hypEdit = new HyperLink();
hypEdit.Text = "<h4><i class='fa fa-edit'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "Edit";
cellEdit.Controls.Add(hypEdit);
cellPrint.Text = "<a href=\"report_Lecturer.aspx?token=" + data.IdCode + "\" title=\"Save PDF\" target=\"_blank\"><img src=\"../img/icon_pdf.png\" style=\"padding-bottom:5px\"></a>";
string file = new LecturerEvidence().getLecturerEvidence(data.IdCode).AttatchName;
long fileSizeInBytes = 0;
try
{
FileInfo fi = new FileInfo(Server.MapPath("./LecturerEvidenceUploadFolder/" + file));
fileSizeInBytes = fi.Length;
}
catch
{
fileSizeInBytes = 0;
}
if (fileSizeInBytes <= 0)
{
cellDocuments.Text = "-";
}
else
{
cellDocuments.Text = "<a href=\"./LecturerEvidenceUploadFolder/" + file + "\" title=\"Download\" target=\"_blank\"><img src=\"../img/Download_File.png\" style=\"height: 38px; width: 32px; padding-bottom:5px\"></a>";
}
}
else
{
string urlEdit = "#";
HyperLink hypEdit = new HyperLink();
hypEdit.Text = "<h4><i class='fa fa-lock'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "ไม่สามารถแก้ไขได้";
cellEdit.Controls.Add(hypEdit);
cellPrint.Text = "-";
cellDocuments.Text = "-";
}
}
// วิชาการภาค
else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
bool editable = false;
List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department);
foreach (string dep in department_authorized)
{
if (dep == data.DepartmentCode)
{
editable = true;
break;
}
}
if (editable == true)
{
string urlEdit = "editLecturer.aspx?token=" + data.IdCode;
HyperLink hypEdit = new HyperLink();
hypEdit.Text = "<h4><i class='fa fa-edit'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "Edit";
cellEdit.Controls.Add(hypEdit);
cellPrint.Text = "<a href=\"report_Lecturer.aspx?token=" + data.IdCode + "\" title=\"Save PDF\" target=\"_blank\"><img src=\"../img/icon_pdf.png\" style=\"padding-bottom:5px\"></a>";
string file = new LecturerEvidence().getLecturerEvidence(data.IdCode).AttatchName;
long fileSizeInBytes = 0;
try
{
FileInfo fi = new FileInfo(Server.MapPath("./LecturerEvidenceUploadFolder/" + file));
fileSizeInBytes = fi.Length;
}
catch
{
fileSizeInBytes = 0;
}
if (fileSizeInBytes <= 0)
{
cellDocuments.Text = "-";
}
else
{
cellDocuments.Text = "<a href=\"./LecturerEvidenceUploadFolder/" + file + "\" title=\"Download\" target=\"_blank\"><img src=\"../img/Download_File.png\" style=\"height: 38px; width: 32px; padding-bottom:5px\"></a>";
}
}
else
{
string urlEdit = "#";
HyperLink hypEdit = new HyperLink();
hypEdit.Text = "<h4><i class='fa fa-lock'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "ไม่สามารถแก้ไขได้";
cellEdit.Controls.Add(hypEdit);
cellPrint.Text = "-";
cellDocuments.Text = "-";
}
}
else
{
string urlEdit = "#";
HyperLink hypEdit = new HyperLink();
hypEdit.Text = "<h4><i class='fa fa-lock'></i></h4>";
hypEdit.NavigateUrl = urlEdit;
hypEdit.ToolTip = "ไม่สามารถแก้ไขได้";
cellEdit.Controls.Add(hypEdit);
cellPrint.Text = "-";
cellDocuments.Text = "-";
}
cellEdit.CssClass = "text-center";
tRowBody.Cells.Add(cellEdit);
cellPrint.CssClass = "text-center";
tRowBody.Cells.Add(cellPrint);
cellDocuments.CssClass = "text-center";
tRowBody.Cells.Add(cellDocuments);
tblLecturer.Rows.Add(tRowBody);
}
// คณะ
facultyData = new Faculty().getFaculty();
foreach (FacultyData data in facultyData)
{
ddlCURR_FACULTY.Items.Insert(ddlCURR_FACULTY.Items.Count, new ListItem(data.Faculty_Thai, data.Faculty_Code));
if (data.Faculty_Code == "11")
{
ddlCURR_FACULTY.Items.FindByValue("11").Selected = true;
}
}
departmentData = new Department().getDepartmentWithFaculty(ddlCURR_FACULTY.SelectedValue);
ddlCURR_DEPARTMENT.Items.Clear();
foreach (DepartmentData data in departmentData)
{
ddlCURR_DEPARTMENT.Items.Insert(ddlCURR_DEPARTMENT.Items.Count, new ListItem(data.Department_Thai, data.Department_Code));
}
} //End if (!Page.IsPostBack)
//=============================
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
}
}
protected void btnSAVE_Click(object sender, EventArgs e)
{
SysUser dataSysUser = new SysUser();
dataSysUser.IdCode = txtNATIONAL_ID.Text;
dataSysUser.FacultyCode = ddlFACULTY.SelectedValue;
dataSysUser.TitleNameCode = ddlTITLE_THAINAME.SelectedValue;
dataSysUser.DepartmentCode = ddlDEPARTMENT.SelectedValue;
dataSysUser.UserTypeCode = ddlLECTURER_CAT.SelectedValue;
dataSysUser.ThName = txtTHNAME.Text;
dataSysUser.EnName = txtENNAME.Text;
dataSysUser.ThSurName = txtTHSURNAME.Text;
dataSysUser.EnSurName = txtENSURNAME.Text;
dataSysUser.UserName = "";
dataSysUser.Password = "";
dataSysUser.Position = ddlLectuerePosition.SelectedValue;
dataSysUser.Address = "";
dataSysUser.Tel = "";
dataSysUser.Email = txtEmail.Text;
dataSysUser.OpenStatus = "";
dataSysUser.PassportCode = txtPASSPORT_ID.Text;
if (rBtnGENDER1.Checked == true)
{
dataSysUser.Sex = "M";
}
if (rBtnGENDER2.Checked == true)
{
dataSysUser.Sex = "F";
}
dataSysUser.AcademicPositionCode = ddlACADEMIC_POSITION.SelectedValue;
dataSysUser.DivisionCode = ddlDIVISION.SelectedValue;
dataSysUser.BirthDay = txtBirthday.Text;
dataSysUser.BirthProvince = ddlBirthProvince.SelectedValue;
dataSysUser.BirthPlace = txtBirthPlace.Text;
dataSysUser.Country = ddlCountry.SelectedValue;
dataSysUser.Nationality = ddlNationality.SelectedValue;
dataSysUser.Ethnicity = ddlEthnicity.SelectedValue;
if (txtHeight.Text == "")
{
dataSysUser.Height = 0.0f;
}
else
{
dataSysUser.Height = float.Parse(txtHeight.Text);
}
if (txtWeight.Text == "")
{
dataSysUser.Weight = 0.0f;
}
else
{
dataSysUser.Weight = float.Parse(txtWeight.Text);
}
dataSysUser.Marital = ddlMarital.SelectedValue;
dataSysUser.Occupation = ddlOccupation.SelectedValue;
dataSysUser.MobileNumber = txtMobileNumber.Text;
dataSysUser.Talent = txtTalent.Text;
dataSysUser.HomeNumber = txtHomeNumber.Text;
dataSysUser.HomeBuilding = txtHomeBuilding.Text;
dataSysUser.HomeVillage = txtHomeVillage.Text;
dataSysUser.HomeMoo = txtHomeMoo.Text;
dataSysUser.HomeSoi = txtHomeSoi.Text;
dataSysUser.HomeRoad = txtHomeRoad.Text;
dataSysUser.HomeTumbol = ddlHomeTumbol.SelectedValue;
dataSysUser.HomeAmphur = ddlHomeAmphur.SelectedValue;
dataSysUser.HomeProvince = ddlHomeProvince.SelectedValue;
dataSysUser.HomePostCode = txtHomePostcode.Text;
dataSysUser.OfficeName = txtOfficeName.Text;
dataSysUser.OfficeNumber = txtOfficeNumber.Text;
dataSysUser.OfficeBuilding = txtOfficeBuilding.Text;
dataSysUser.OfficeVillage = txtOfficeVillage.Text;
dataSysUser.OfficeMoo = txtOfficeMoo.Text;
dataSysUser.OfficeSoi = txtOfficeSoi.Text;
dataSysUser.OfficeRoad = txtOfficeRoad.Text;
dataSysUser.OfficeTumbol = ddlOfficeTumbol.SelectedValue;
dataSysUser.OfficeAmphur = ddlOfficeAmphur.SelectedValue;
dataSysUser.OfficeProvince = ddlOfficeProvince.SelectedValue;
dataSysUser.OfficePostCode = txtOfficePostcode.Text;
dataSysUser.Affiliation = txtAFFILIATION.Text;
dataSysUser.GradLecturer = ddlGRAD_LECTURER.SelectedValue;
dataSysUser.ShortName = txtSHORT_NAME.Text;
///
Sysuser2 dataSysUser2 = new Sysuser2();
dataSysUser2.IdCode = txtNATIONAL_ID.Text;
dataSysUser2.IdIssuePlace = txtIdIsuePlace.Text;
dataSysUser2.IdDateIssue = txtDate_of_issue.Text;
dataSysUser2.IdIssueExpire = txtDate_of_expire.Text;
dataSysUser2.LicenseId = txtProfession.Text;
dataSysUser2.LicenseIssuePlace = txtProfessionIssuePlace.Text;
dataSysUser2.LicensDateIssue = txtDate_of_issue2.Text;
dataSysUser2.LicenseIssueExpire = txtDate_of_expire2.Text;
dataSysUser2.Telephone = txtTelephone.Text;
dataSysUser2.BankName = ddlBank.SelectedValue;
dataSysUser2.BankBranch = txtBankBranch.Text;
dataSysUser2.BankAccountName = txtBankAccountName.Text;
dataSysUser2.BankAccountNumber = txtBankAccountNumber.Text;
dataSysUser2.ReligionCode = ddlReligion.SelectedValue;
dataSysUser2.Lecturer_Type = ddlLectuereType.SelectedValue;
///
///
LecturerEvidence evidence = new LecturerEvidence();
evidence.LectIdentity = txtNATIONAL_ID.Text;
if (chkEvidence1.Checked)
{
evidence.Evidence1 = "Y";
}
else
{
evidence.Evidence1 = "N";
}
if (chkEvidence2.Checked)
{
evidence.Evidence2 = "Y";
}
else
{
evidence.Evidence2 = "N";
}
if (chkEvidence3.Checked)
{
evidence.Evidence3 = "Y";
}
else
{
evidence.Evidence3 = "N";
}
if (chkEvidence4.Checked)
{
evidence.Evidence4 = "Y";
}
else
{
evidence.Evidence4 = "N";
}
if (chkEvidence5.Checked)
{
evidence.Evidence5 = "Y";
}
else
{
evidence.Evidence5 = "N";
}
if (chkEvidence6.Checked)
{
evidence.Evidence6 = "Y";
}
else
{
evidence.Evidence6 = "N";
}
if (chkEvidence7.Checked)
{
evidence.Evidence7 = "Y";
}
else
{
evidence.Evidence7 = "N";
}
if (chkEvidence8.Checked)
{
evidence.Evidence8 = "Y";
}
else
{
evidence.Evidence8 = "N";
}
if (file_Attachment.HasFile)
{
string FileName;
string Extension;
string FolderPath;
FileName = Path.GetFileName(file_Attachment.PostedFile.FileName);
Extension = Path.GetExtension(file_Attachment.PostedFile.FileName);
FolderPath = ConfigurationManager.AppSettings["LecturerEvidenceUploadFolder"];
string newName = DateTime.Now.ToString("yyyyMMddHHmmss");
FileName = newName + Extension;
string FilePath = Server.MapPath(FolderPath + FileName);
if (Extension == ".rar" || Extension == ".zip")
{
try
{
file_Attachment.SaveAs(FilePath);
evidence.AttatchName = FileName;
}
catch
{
Session["response"] = "ไฟล์ upload ขนาดต้องไม่เกิน 2 MB";
Response.Redirect("../err_response.aspx");
}
}
else
{
Session["response"] = "ไฟล์ upload ต้องเป็นไฟล์นามสกุล .rar หรือ .zip เท่านั้น";
Response.Redirect("../err_response.aspx");
}
}
else
{
evidence.AttatchName = "";
}
new LecturerEvidence().insertLecturerEvidence(evidence);
///
string insertSysUser = new SysUser().insertSysUser(dataSysUser);
string insertSysUser2 = new Sysuser2().insertSysuser2(dataSysUser2);
if (insertSysUser == "Success" && insertSysUser2 == "Success")
{
//สร้าง session ไว้ใช้กับหน้า add_Qualification_Data, delete_Qualification, edit_Qualification
Session["IdCode"] = dataSysUser.IdCode;
Response.Redirect("add_Qualification_Data.aspx?token=" + dataSysUser.IdCode);
}
else
{
try
{
new LecturerExprience().deleteLecturerExprience(txtNATIONAL_ID.Text);
new LecturerSholarship().deleteLecturerSholarship(txtNATIONAL_ID.Text);
new LecturerPublication().deleteLecturerPublication(txtNATIONAL_ID.Text);
new LecturerBook().deleteLecturerBook(txtNATIONAL_ID.Text);
new LecturerEvidence().deleteLecturerEvidence(txtNATIONAL_ID.Text);
new SysUser().deleteSysUser(txtNATIONAL_ID.Text);
new Sysuser2().deleteSysuser2(txtNATIONAL_ID.Text);
}
catch {
Session["response"] = "ข้อมูลผิดพลาด ไม่สามารถทำงานได้ในขณะนี้";
Response.Redirect("../err_response.aspx");
}
//divError.Visible = true;
}
}
