/// <summary> /// แก้ไขข้อมูลจากตาราง QUALIFICATIONDETAIL /// รายละเอียดเพิ่มเติมของคณะสถาปัตย์ /// COUNTRY_CODE, PROVINCE_CODE, PROVINCE_OTHER, GPA /// </summary> /// <param name="updateData">QualificationDetail Object</param> /// <returns>Success</returns> public string updateQualificationDetail2(QualificationDetail updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Update QUALIFICATIONDETAIL Set QUALIFICATIONDEGREE = '" + updateData.QualificationDegree + "', YEAR = '" + updateData.Year + "', ACADEMY = '" + updateData.Academy + "', DIVISION = '" + updateData.Division + "', COUNTRY_CODE = '" + updateData.Country_Code + "', PROVINCE_CODE = '" + updateData.Province_Code + "', PROVINCE_OTHER = '" + updateData.Province_Other + "', GPA = '" + updateData.gpa + "' Where UUIDNUMBER = '" + updateData.UUIDNumber + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateQualificationDetail: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
protected void btnSAVE_Click(object sender, EventArgs e) { QualificationDetail data = new QualificationDetail(); data.LectIdentity = token; data.QualificationDegree = txtQualificationName.Text; data.Year = txtYear.Text; data.Academy = txtAcademy.Text; data.Division = txtDivision.Text; data.UUIDNumber = code; data.Country_Code = ddlCountry.SelectedValue; data.Province_Code = ddlProvince.SelectedValue; data.Province_Other = txtProvinceOther.Text; data.gpa = txtGPA.Text; string update = new QualificationDetail().updateQualificationDetail2(data); if (update == "Success") { Response.Redirect("add_Qualification_Data.aspx?token=" + token); } else { HttpContext.Current.Session["response"] = "ไม่สามารถแก้ไขข้อมูลนี้ได้ กรุณาตรวจสอบอีกครั้ง"; HttpContext.Current.Response.Redirect("../err_response.aspx"); } }
/// <summary> /// เพิ่มข้อมูลลงตาราง QUALIFICATIONDETAIL /// รายละเอียดเพิ่มเติมของคณะสถาปัตย์ /// COUNTRY_CODE, PROVINCE_CODE, PROVINCE_OTHER, GPA /// </summary> /// <param name="dataInsert">QualificationDetail Object</param> /// <returns>Success</returns> public string insertQualificationDetail2(QualificationDetail dataInsert) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Insert into QUALIFICATIONDETAIL (LECTIDENTITY, QUALIFICATIONDEGREE, YEAR, ACADEMY, DIVISION, UUIDNUMBER, COUNTRY_CODE, PROVINCE_CODE, PROVINCE_OTHER, GPA) values ('" + dataInsert.LectIdentity + "','" + dataInsert.QualificationDegree + "','" + dataInsert.Year + "','" + dataInsert.Academy + "','" + dataInsert.Division + "','" + dataInsert.UUIDNumber + "','" + dataInsert.Country_Code + "','" + dataInsert.Province_Code + "','" + dataInsert.Province_Other + "','" + dataInsert.gpa + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "insertQualificationDetail: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// เรียกดูข้อมูลจากตาราง QUALIFICATIONDETAIL /// </summary> /// <param name="sql">SQL Command</param> /// <returns>ข้อมูลจากตาราง QUALIFICATIONDETAIL</returns> public List <QualificationDetail> getQualificationDetailManual(string sql) { List <QualificationDetail> data = new List <QualificationDetail>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { QualificationDetail row = new QualificationDetail(); row.LectIdentity = rowData["LECTIDENTITY"].ToString(); row.QualificationDegree = rowData["QUALIFICATIONDEGREE"].ToString(); row.Year = rowData["YEAR"].ToString(); row.Academy = rowData["ACADEMY"].ToString(); row.Division = rowData["DIVISION"].ToString(); row.UUIDNumber = rowData["UUIDNUMBER"].ToString(); //คณะสถาปัตย์ row.Country_Code = rowData["COUNTRY_CODE"].ToString(); row.Province_Code = rowData["PROVINCE_CODE"].ToString(); row.Province_Other = rowData["PROVINCE_OTHER"].ToString(); row.gpa = rowData["GPA"].ToString(); // data.Add(row); } return(data); }
/// <summary> /// เรียกดูข้อมูลจากตาราง QUALIFICATIONDETAIL /// </summary> /// <param name="LectIdentity">เลขประจำตัวประชาชน(SysUser)</param> /// <returns>ข้อมูลจากตาราง QUALIFICATIONDETAIL</returns> public QualificationDetail getQualificationDetail(string LectIdentity) { QualificationDetail data = new QualificationDetail(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = "Select * From QUALIFICATIONDETAIL Where LECTIDENTITY='" + LectIdentity + "'"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { data.LectIdentity = rowData["LECTIDENTITY"].ToString(); data.QualificationDegree = rowData["QUALIFICATIONDEGREE"].ToString(); data.Year = rowData["YEAR"].ToString(); data.Academy = rowData["ACADEMY"].ToString(); data.Division = rowData["DIVISION"].ToString(); data.UUIDNumber = rowData["UUIDNUMBER"].ToString(); //คณะสถาปัตย์ data.Country_Code = rowData["COUNTRY_CODE"].ToString(); data.Province_Code = rowData["PROVINCE_CODE"].ToString(); data.Province_Other = rowData["PROVINCE_OTHER"].ToString(); data.gpa = rowData["GPA"].ToString(); // } return(data); }
protected void tblEducationHead() { // Head Table string[] ar = { "คุณวุฒิ", "สาขาวิชา", "สถาบันที่สำเร็จการศึกษา", "ปี พ.ศ. ที่สำเร็จการศึกษา" }; tblEducation.Attributes.Add("class", "table table-bordered table-striped table-hover"); tblEducation.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]; if (cellCtr > 4) { cellHead.Width = 50; } tRowHead.Cells.Add(cellHead); } tblEducation.Rows.Add(tRowHead); List <QualificationDetail> qualificationDetail = new List <QualificationDetail>(); string sql = "Select * From QUALIFICATIONDETAIL Where LECTIDENTITY='" + code + "' Order by YEAR"; qualificationDetail = new QualificationDetail().getQualificationDetailManual(sql); foreach (QualificationDetail item in qualificationDetail) { TableRow row = new TableRow(); TableCell cellQualificationName = new TableCell(); cellQualificationName.Text = item.QualificationDegree; row.Cells.Add(cellQualificationName); TableCell cellDivision = new TableCell(); cellDivision.Text = item.Division; row.Cells.Add(cellDivision); TableCell cellAcademy = new TableCell(); cellAcademy.Text = item.Academy; row.Cells.Add(cellAcademy); TableCell cellYear = new TableCell(); cellYear.Text = item.Year; row.Cells.Add(cellYear); //แสดงข้อมูลจากฐานข้อมูล tblEducation.Rows.Add(row); } }
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 =========== token = Request.QueryString["token"]; code = Request.QueryString["code"]; country = new Country().getCountry(); foreach (CountryData row in country) { ddlCountry.Items.Insert(ddlCountry.Items.Count, new ListItem(row.Country_ThaiName, row.Country_Code)); } province = new Province().getProvince(); foreach (ProvinceData row in province) { ddlProvince.Items.Insert(ddlProvince.Items.Count, new ListItem(row.Province_ThaiName, row.Province_Code)); } if (!Page.IsPostBack) { string sql = "Select * From QUALIFICATIONDETAIL Where UUIDNUMBER ='" + code + "'"; List <QualificationDetail> data = new QualificationDetail().getQualificationDetailManual(sql); txtQualificationName.Text = data[0].QualificationDegree; txtDivision.Text = data[0].Division; txtAcademy.Text = data[0].Academy; txtYear.Text = data[0].Year; try { ddlCountry.Items.FindByValue(data[0].Country_Code).Selected = true; } catch { } try { ddlProvince.Items.FindByValue(data[0].Province_Code).Selected = true; } catch { } txtProvinceOther.Text = data[0].Province_Other; txtGPA.Text = data[0].gpa; } //============================= } else { HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน"; HttpContext.Current.Response.Redirect("../err_response.aspx"); } } }
protected void btnOK_Click(object sender, EventArgs e) { string remove = new QualificationDetail().deleteQualificationDetail(code); if (remove == "Success") { Response.Redirect("add_Qualification_Data.aspx?token=" + token); } else { HttpContext.Current.Session["response"] = "ไม่สามารถลบข้อมูลนี้ได้ กรุณาตรวจสอบอีกครั้ง"; HttpContext.Current.Response.Redirect("../err_response.aspx"); } }
protected void btnSAVE_Click(object sender, EventArgs e) { gid = System.Guid.NewGuid(); QualificationDetail data = new QualificationDetail(); data.LectIdentity = code; data.QualificationDegree = txtQualificationName.Text; data.Year = txtYear.Text; data.Academy = txtAcademy.Text; data.Division = txtDivision.Text; data.UUIDNumber = gid.ToString(); data.Country_Code = ddlCountry.SelectedValue; data.Province_Code = ddlProvince.SelectedValue; data.Province_Other = txtProvinceOther.Text; data.gpa = txtGPA.Text; string save = new QualificationDetail().insertQualificationDetail2(data); Response.Redirect("add_Qualification_Data.aspx?token=" + code); }
public async Task <IActionResult> OnPost(Employee_UV_Dto employee, IList <PhysicalID_UV_Dto> physicalIDs, IList <BasicSalaryRDTO> basicSalaries, IList <AllowanceRDTO> allowances, IList <BanksRDTO> banks, Contact primaryContact, NationalAddress nationalAddress, IList <Contact> secondaryContacts, IList <Qualification> qualifications, IList <Dependant> dependants, IList <PhysicalId <int> > dependantsIds, IList <WorkShiftRDto> workShifts) { try { for (int i = 0; i < physicalIDs.Count; i++) { //physicalIDs[i].SetId(GuidGenerator.Create()); physicalIDs[i].IDTypeId = physicalIDs[i].IDType.Id; physicalIDs[i].IDType = null; physicalIDs[i].IssuedFromId = physicalIDs[i].IssuedFrom.Id; physicalIDs[i].IssuedFrom = null; } var empIds = new List <PhysicalID_UV_Dto>(); empIds.AddRange(physicalIDs); //employee.PhysicalIDs = empIds; employee.WorkShiftId = workShifts.Last().WorkShiftId; //Employee_UV_Dto employeeObj = JsonSerializer.Deserialize<Employee_UV_Dto>(employee); FinancialDetails financialDetails = new FinancialDetails(basicSalaries, allowances, banks); ContactInformation contactInformation = new ContactInformation(primaryContact, nationalAddress, secondaryContacts); QualificationDetail qualificationDetail = new QualificationDetail(qualifications); DependantsDetail dependantsDetail = new DependantsDetail(dependants, dependantsIds); WorkShiftDetail workShiftDetail = new WorkShiftDetail(workShifts); employee.ExtraProperties.Add("financialDetails", financialDetails); employee.ExtraProperties.Add("contactInformation", contactInformation); employee.ExtraProperties.Add("qualificationDetail", qualificationDetail); employee.ExtraProperties.Add("dependantsDetail", dependantsDetail); employee.ExtraProperties.Add("workShiftDetail", workShiftDetail); //Employee_Dto empAdded = await employeeAppService.CreateEmployee(employee); } catch (Exception ex) { } return(Page()); }
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 tblEducationHead() { // Head Table string[] ar = { "คุณวุฒิ", "สาขาวิชา", "สถาบันที่สำเร็จการศึกษา", "ปี พ.ศ. ที่สำเร็จการศึกษา", "แก้ไข", "ลบ" }; tblEducation.Attributes.Add("class", "table table-bordered table-striped table-hover"); tblEducation.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]; if (cellCtr > 4) { cellHead.Width = 50; } tRowHead.Cells.Add(cellHead); } tblEducation.Rows.Add(tRowHead); List <QualificationDetail> qualificationDetail = new List <QualificationDetail>(); string sql = "Select * From QUALIFICATIONDETAIL Where LECTIDENTITY='" + code + "' Order by YEAR"; qualificationDetail = new QualificationDetail().getQualificationDetailManual(sql); foreach (QualificationDetail item in qualificationDetail) { TableRow row = new TableRow(); TableCell cellQualificationName = new TableCell(); cellQualificationName.Text = item.QualificationDegree; row.Cells.Add(cellQualificationName); TableCell cellDivision = new TableCell(); cellDivision.Text = item.Division; row.Cells.Add(cellDivision); TableCell cellAcademy = new TableCell(); cellAcademy.Text = item.Academy; row.Cells.Add(cellAcademy); TableCell cellYear = new TableCell(); cellYear.Text = item.Year; row.Cells.Add(cellYear); TableCell cellEdit = new TableCell(); string urlEdit = "edit_Qualification.aspx?token=" + item.LectIdentity + "&code=" + item.UUIDNumber; HyperLink hypEdit = new HyperLink(); hypEdit.Attributes.Add("data-target", "#edit_Qualification"); 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_Qualification.aspx?token=" + item.LectIdentity + "&code=" + item.UUIDNumber; HyperLink hypDel = new HyperLink(); hypDel.Attributes.Add("data-target", "#delete_Qualification"); 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); //แสดงข้อมูลจากฐานข้อมูล tblEducation.Rows.Add(row); } }