Ejemplo n.º 1
0
    /// <summary>
    /// เรียกดูข้อมูลจากตาราง LECTURERBOOK
    /// </summary>
    /// <returns>ข้อมูลจากตาราง LECTURERBOOK</returns>
    public List <LecturerBook> getLecturerBook()
    {
        List <LecturerBook> data = new List <LecturerBook>();

        ConnectDB     db        = new ConnectDB();
        SqlDataSource oracleObj = db.ConnectionOracle_tqf2();

        oracleObj.SelectCommand = "Select * From LECTURERBOOK Order By LECTIDENTITY";
        DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);

        foreach (DataRowView rowData in allData)
        {
            LecturerBook row = new LecturerBook();

            row.LectIdentity  = rowData["LECTIDENTITY"].ToString();
            row.BookName      = rowData["BOOKNAME"].ToString();
            row.Publisher     = rowData["PUBLISHER"].ToString();
            row.PublishedYear = rowData["PUBLISHEDYEAR"].ToString();
            row.BookId        = rowData["BOOKID"].ToString();

            data.Add(row);
        }

        return(data);
    }
Ejemplo n.º 2
0
    /// <summary>
    /// แก้ไขข้อมูลจากตาราง LECTURERBOOK
    /// </summary>
    /// <param name="updateData">LecturerBook Object</param>
    /// <returns>Success</returns>
    public string updateLecturerBook(LecturerBook updateData)
    {
        string        response  = "";
        ConnectDB     db        = new ConnectDB();
        SqlDataSource oracleObj = db.ConnectionOracle_tqf2();

        string sql = "Update LECTURERBOOK Set BOOKNAME = '" + updateData.BookName + "', PUBLISHER = '" + updateData.Publisher + "', PUBLISHEDYEAR = '" + updateData.PublishedYear + "' Where BOOKID = '" + updateData.BookId + "'";

        oracleObj.UpdateCommand = sql;

        try
        {
            if (oracleObj.Update() == 1)
            {
                response = "Success";
            }
        }
        catch (Exception e)
        {
            string exception = e.Message;
            HttpContext.Current.Session["response"] = "updateLecturerBook: " + exception;
            HttpContext.Current.Response.Redirect("../err_response.aspx");
        }

        return(response);
    }
Ejemplo n.º 3
0
    /// <summary>
    /// เพิ่มข้อมูลลงตาราง LECTURERBOOK
    /// </summary>
    /// <param name="dataInsert">LecturerBook Object</param>
    /// <returns>Success</returns>
    public string insertLecturerBook(LecturerBook dataInsert)
    {
        string response = "";

        ConnectDB     db        = new ConnectDB();
        SqlDataSource oracleObj = db.ConnectionOracle_tqf2();

        string sql = "Insert into LECTURERBOOK (LECTIDENTITY, BOOKNAME, PUBLISHER, PUBLISHEDYEAR, BOOKID) values ('" + dataInsert.LectIdentity + "','" + dataInsert.BookName + "','" + dataInsert.Publisher + "','" + dataInsert.PublishedYear + "','" + dataInsert.BookId + "')";

        oracleObj.InsertCommand = sql;

        try
        {
            if (oracleObj.Insert() == 1)
            {
                response = "Success";
            }
        }
        catch (Exception e)
        {
            string exception = e.Message;
            HttpContext.Current.Session["response"] = "insertLecturerBook: " + exception;
            HttpContext.Current.Response.Redirect("../err_response.aspx");
        }

        return(response);
    }
Ejemplo n.º 4
0
    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"];

                if (!Page.IsPostBack)
                {
                    string sql = "Select * From LECTURERBOOK Where BOOKID='" + code + "'";
                    List <LecturerBook> data = new LecturerBook().getLecturerBookManual(sql);

                    txtBookName.Text      = data[0].BookName;
                    txtPublisher.Text     = data[0].Publisher;
                    txtPublishedYear.Text = data[0].PublishedYear;
                }
                //=============================
            }
            else
            {
                HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
                HttpContext.Current.Response.Redirect("../err_response.aspx");
            }
        }
    }
Ejemplo n.º 5
0
    protected void btnSAVE_Click(object sender, EventArgs e)
    {
        LecturerBook data = new LecturerBook();

        data.LectIdentity  = code;
        data.BookName      = txtBookName.Text;
        data.Publisher     = txtPublisher.Text;
        data.PublishedYear = txtPublishedYear.Text;
        data.BookId        = new TQF.TQFUtility().getMaxID("BOOKID", "LECTURERBOOK");

        string save = new LecturerBook().insertLecturerBook(data);

        Response.Redirect("add_Qualification_Data.aspx?token=" + code);
    }
Ejemplo n.º 6
0
    protected void tblBookHead()
    {
        // Head Table
        string[] ar = { "ชื่อตำรา/หนังสือ", "ปีที่ตีพิมพ์", "สำนักพิมพ์" };
        tblBook.Attributes.Add("class", "table table-bordered table-striped table-hover");
        tblBook.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.tblExperience
            TableHeaderCell cellHead = new TableHeaderCell();
            cellHead.Text = ar[cellCtr - 1];

            if (cellCtr > 3)
            {
                cellHead.Width = 50;
            }

            tRowHead.Cells.Add(cellHead);
        }
        tblBook.Rows.Add(tRowHead);

        List <LecturerBook> data = new List <LecturerBook>();

        string sql = "Select * From LECTURERBOOK Where LECTIDENTITY='" + code + "' Order by PUBLISHEDYEAR";

        data = new LecturerBook().getLecturerBookManual(sql);

        foreach (LecturerBook item in data)
        {
            TableRow row = new TableRow();

            TableCell cellBookName = new TableCell();
            cellBookName.Text = item.BookName;
            row.Cells.Add(cellBookName);

            TableCell cellPublishedYear = new TableCell();
            cellPublishedYear.Text = item.PublishedYear;
            row.Cells.Add(cellPublishedYear);

            TableCell cellPublisher = new TableCell();
            cellPublisher.Text = item.Publisher;
            row.Cells.Add(cellPublisher);

            //แสดงข้อมูลจากฐานข้อมูล
            tblBook.Rows.Add(row);
        }
    }
Ejemplo n.º 7
0
    protected void btnOK_Click(object sender, EventArgs e)
    {
        string sql    = "Delete From LECTURERBOOK Where BOOKID ='" + code + "'";
        string remove = new LecturerBook().deleteLecturerBookManual(sql);

        if (remove == "Success")
        {
            Response.Redirect("add_Qualification_Data.aspx?token=" + token);
        }
        else
        {
            HttpContext.Current.Session["response"] = "ไม่สามารถลบข้อมูลนี้ได้ กรุณาตรวจสอบอีกครั้ง";
            HttpContext.Current.Response.Redirect("../err_response.aspx");
        }
    }
Ejemplo n.º 8
0
    /// <summary>
    /// เรียกดูข้อมูลจากตาราง LECTURERBOOK
    /// </summary>
    /// <param name="LectIdentity">บัตรประจำตัวประชาชน</param>
    /// <returns>ข้อมูลจากตาราง LECTURERBOOK</returns>
    public LecturerBook getLecturerBook(string LectIdentity)
    {
        LecturerBook data = new LecturerBook();

        ConnectDB     db        = new ConnectDB();
        SqlDataSource oracleObj = db.ConnectionOracle_tqf2();

        oracleObj.SelectCommand = "Select * From LECTURERBOOK Where LECTIDENTITY='" + LectIdentity + "'";
        DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);

        foreach (DataRowView rowData in allData)
        {
            data.LectIdentity  = rowData["LECTIDENTITY"].ToString();
            data.BookName      = rowData["BOOKNAME"].ToString();
            data.Publisher     = rowData["PUBLISHER"].ToString();
            data.PublishedYear = rowData["PUBLISHEDYEAR"].ToString();
            data.BookId        = rowData["BOOKID"].ToString();
        }

        return(data);
    }
Ejemplo n.º 9
0
    protected void btnSAVE_Click(object sender, EventArgs e)
    {
        LecturerBook data = new LecturerBook();

        data.LectIdentity  = token;
        data.BookName      = txtBookName.Text;
        data.Publisher     = txtPublisher.Text;
        data.PublishedYear = txtPublishedYear.Text;
        data.BookId        = code;

        string update = new LecturerBook().updateLecturerBook(data);

        if (update == "Success")
        {
            Response.Redirect("add_Qualification_Data.aspx?token=" + token);
        }
        else
        {
            HttpContext.Current.Session["response"] = "ไม่สามารถแก้ไขข้อมูลนี้ได้ กรุณาตรวจสอบอีกครั้ง";
            HttpContext.Current.Response.Redirect("../err_response.aspx");
        }
    }
Ejemplo n.º 10
0
    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);
    }
Ejemplo n.º 11
0
    protected void tblBookHead()
    {
        // Head Table
        string[] ar = { "ชื่อตำรา/หนังสือ", "ปีที่ตีพิมพ์", "สำนักพิมพ์", "แก้ไข", "ลบ" };
        tblBook.Attributes.Add("class", "table table-bordered table-striped table-hover");
        tblBook.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.tblExperience
            TableHeaderCell cellHead = new TableHeaderCell();
            cellHead.Text = ar[cellCtr - 1];

            if (cellCtr > 3)
            {
                cellHead.Width = 50;
            }

            tRowHead.Cells.Add(cellHead);
        }
        tblBook.Rows.Add(tRowHead);

        List <LecturerBook> data = new List <LecturerBook>();

        string sql = "Select * From LECTURERBOOK Where LECTIDENTITY='" + code + "' Order by PUBLISHEDYEAR";

        data = new LecturerBook().getLecturerBookManual(sql);

        foreach (LecturerBook item in data)
        {
            TableRow row = new TableRow();

            TableCell cellBookName = new TableCell();
            cellBookName.Text = item.BookName;
            row.Cells.Add(cellBookName);

            TableCell cellPublishedYear = new TableCell();
            cellPublishedYear.Text = item.PublishedYear;
            row.Cells.Add(cellPublishedYear);

            TableCell cellPublisher = new TableCell();
            cellPublisher.Text = item.Publisher;
            row.Cells.Add(cellPublisher);

            TableCell cellEdit = new TableCell();
            string    urlEdit  = "edit_Book.aspx?token=" + item.LectIdentity + "&code=" + item.BookId;
            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_Book.aspx?token=" + item.LectIdentity + "&code=" + item.BookId;
            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);

            //แสดงข้อมูลจากฐานข้อมูล
            tblBook.Rows.Add(row);
        }
    }