Ejemplo n.º 1
0
        private void Form1_Paint(object sender, PaintEventArgs e)
        {
            ++frames;

            var fx = e.Graphics;
            using ( var buffer = new Bitmap( ClientSize.Width, ClientSize.Height ) ) {
                using ( var clr = Graphics.FromImage(buffer) ) clr.Clear( Color.Transparent );
                var target = buffer.LockBits( ClientRectangle, System.Drawing.Imaging.ImageLockMode.ReadWrite, System.Drawing.Imaging.PixelFormat.Format32bppArgb );

                int y = 0;
                while ( y < ClientSize.Height ) {
            #if false
                    string text = "Hello, World!";
                    Font.RenderLineTo( target, text, new Rectangle(0,y,ClientSize.Width,ClientSize.Height-y), Industry.FX.HorizontalAlignment.Center, VerticalAlignment.Top );
                    y += Font.MeasureLine(text).Advance.Y;
            #else
                    Paragraph text = new Paragraph();
                    text.Add( new TextRun() { Font = RedFont , Text = "He" } );
                    text.Add( new TextRun() { Font = BlueFont, Text = "llo, W" } );
                    text.Add( new TextRun() { Font = RedFont , Text = "orld!" } );
                    var lines = text.ToLines(ClientSize.Width);
                    FX.Font.RenderLinesTo( target, lines, new Rectangle(0,y,ClientSize.Width,int.MaxValue), FX.HorizontalAlignment.Center, VerticalAlignment.Top );
                    y += FX.Font.MeasureLines(lines).Advance.Y;
            #endif
                }

                DateTime now = DateTime.Now;
                var span = now-prev;
                if ( span.TotalSeconds >= 1.0 ) {
                    prev = now;
                    framedisplay = frames;
                    frames = 0;
                }

                RedFont.RenderLineTo( target, "FPS: "+framedisplay, ClientRectangle, Industry.FX.HorizontalAlignment.Right, VerticalAlignment.Top );
                buffer.UnlockBits(target);
                fx.DrawImage(buffer,0,0);
            }
            Invalidate();
        }
        public static Text GetActivatedText(Text text)
        {
            var activeText = new Text();
            foreach(var paragraph in text)
            {
                var activeParagraph = new Paragraph();
                foreach(var sentence in paragraph)
                {
                    activeParagraph.Add(GetActivatedSentence(sentence));
                }
                activeText.Add(activeParagraph);
            }

            return activeText;
        }
Ejemplo n.º 3
0
    static void Main()
    {
        Document doc = new Document();
        doc.Title = "My First Document";
        doc.Author = "Nakov";
        doc.Add(new Paragraph("I am a paragraph"));
        doc.Add(new Hyperlink("http://dir.bg"));
        doc.Add(new Paragraph("I am another paragraph"));
        doc.Add(new Heading("Heading 1"));
        Paragraph paragraph = new Paragraph();
        paragraph.Add(new TextElement("Default Font", Font.DefaultFont));
        paragraph.Add(new TextElement(" "));
        paragraph.Add(new TextElement("Second Red", new Font(color: Color.Red)));
        paragraph.Add(new TextElement(" "));
        paragraph.Add(new TextElement("Green Italic", 
            new Font(color: Color.Green, style: FontStyle.Italic)));
        paragraph.Add(new Paragraph());
        paragraph.Add(
            new TextElement("Consolas Bold Blue Italic",
            new Font(
                color: Color.Blue, 
                style: FontStyle.BoldItalic, 
                name: "Consolas")));
        doc.Add(paragraph);
        
        doc.Add(new Heading("Heading 2<br>", 2));

        doc.Add(
            new Hyperlink("http://softuni.bg")
                .Add(Image.CreateFromFile("../../logo.png"))
                .Add(new TextElement("some text"))
        );
        doc.Add(paragraph);

        var htmlDoc = new HtmlDocument(doc);
        var writer = new StringWriter();
        htmlDoc.Render(writer);
        Console.WriteLine(writer.ToString());
        File.WriteAllText("document.html", writer.ToString());

        var txtDoc = new TxtDocument(doc);
        writer = new StringWriter();
        txtDoc.Render(writer);
        Console.WriteLine(writer.ToString());
        File.WriteAllText("document.txt", writer.ToString());
    }
        public OutputPdfGenerator Create(List <IntelItem> items, string subject)
        {
            try
            {
                using (var memoryStream = new MemoryStream())
                {
                    var pdfWriter   = new PdfWriter(memoryStream);
                    var pdfDocument = new PdfDocument(pdfWriter);
                    var document    = new Document(pdfDocument, PageSize.LETTER, true);
                    items.Sort(IntelItem.DateTimeCollectedComparer);
                    items.ForEach((i) =>
                    {
                        var p = new Paragraph();
                        p.Add(new Text(!String.IsNullOrEmpty(i.Description) ? i.Description : "").SetBold());
                        p.Add("\n");
                        p.Add(new Text(!String.IsNullOrEmpty(i?.DateTimeCollected.ToShortDateString()) ? i.DateTimeCollected.ToShortDateString() : "").SetBold());
                        p.Add("\n");
                        p.Add(new Text(!String.IsNullOrEmpty(i.Content) ? i.Content : ""));
                        p.Add("\n");
                        p.Add(new Text(!String.IsNullOrEmpty(i.Author) ? i.Author : ""));
                        p.Add("\n");
                        p.Add(new Text(!String.IsNullOrEmpty(i.CovertArea.ToString()) ? i.CovertArea.ToString() : ""));
                        p.Add("\n");
                        p.Add(new Text(!String.IsNullOrEmpty(i.Url) ? i.Url : ""));
                        p.Add("\n");
                        p.Add("\n");
                        document.Add(p);
                    });
                    document.Close();

                    _result = memoryStream.ToArray();
                }
                _outName = $"{subject}.pdf";
            }
            catch (Exception e)
            {
                _logger.LogError(e.Message);
            }


            return(this);
        }
Ejemplo n.º 5
0
        static void Main(string[] args)
        {
            TableStyle tableStyle1 = new TableStyle("TableStyle1");

            tableStyle1.Width      = new Size(6.3, Unit.Inch);
            tableStyle1.Alignment  = TableAlignment.Left;
            tableStyle1.LeftMargin = new Size(0, Unit.Inch);

            ColumnStyle columnStyle1 = new ColumnStyle("ColumnStyle1");

            columnStyle1.Width = new Size(1.2, Unit.Inch);

            ColumnStyle columnStyle2 = new ColumnStyle("ColumnStyle2");

            columnStyle2.Width = new Size(1.3, Unit.Inch);

            CellStyle cellStyle1 = new CellStyle("CellStyle1");

            cellStyle1.CellProperties.BackgroundColor = "#CCCCCC"; //gray
            cellStyle1.CellProperties.Border          = new Border(new Size(0.0069, Unit.Inch), BorderStyle.Solid, "#000000");

            CellStyle cellStyle2 = new CellStyle("CellStyle2");

            cellStyle2.CellProperties.Border = new Border(new Size(0.0069, Unit.Inch), BorderStyle.Solid, "#000000");

            TextDocument doc = new TextDocument();

            doc.AutomaticStyles.Styles.Add(tableStyle1);
            doc.AutomaticStyles.Styles.Add(columnStyle1);
            doc.AutomaticStyles.Styles.Add(columnStyle2);
            doc.AutomaticStyles.Styles.Add(cellStyle1);
            doc.AutomaticStyles.Styles.Add(cellStyle2);

            Column column1 = new Column();

            column1.Style = "ColumnStyle1";

            Column column2 = new Column();

            column2.Style = "ColumnStyle1";

            Column column3 = new Column();

            column3.Style = "ColumnStyle2";

            Column column4 = new Column();

            column4.Style = "ColumnStyle2";

            Column column5 = new Column();

            column5.Style = "ColumnStyle2";

            Table table1 = new Table();

            table1.Style = "TableStyle1";

            table1.Columns.Add(column1);
            table1.Columns.Add(column2);
            table1.Columns.Add(column3);
            table1.Columns.Add(column4);
            table1.Columns.Add(column5);

            Cell cell11 = new Cell("A");

            cell11.Style = "CellStyle1";

            Cell cell12 = new Cell("B");

            cell12.Style = "CellStyle1";

            Cell cell13 = new Cell("C");

            cell13.Style = "CellStyle1";

            Cell cell14 = new Cell("D");

            cell14.Style = "CellStyle1";

            Cell cell15 = new Cell("E");

            cell15.Style = "CellStyle1";

            Row row1 = new Row();

            row1.Cells.Add(cell11);
            row1.Cells.Add(cell12);
            row1.Cells.Add(cell13);
            row1.Cells.Add(cell14);
            row1.Cells.Add(cell15);

            Cell cell21 = new Cell("1");

            cell21.Style = "CellStyle2";

            Cell cell22 = new Cell("2");

            cell22.Style = "CellStyle2";

            Cell cell23 = new Cell("3");

            cell23.Style = "CellStyle2";

            Cell cell24 = new Cell("4");

            cell24.Style = "CellStyle2";

            Cell cell25 = new Cell("5");

            cell25.Style = "CellStyle2";

            Row row2 = new Row();

            row2.Cells.Add(cell21);
            row2.Cells.Add(cell22);
            row2.Cells.Add(cell23);
            row2.Cells.Add(cell24);
            row2.Cells.Add(cell25);

            table1.Rows.Add(row1);
            table1.Rows.Add(row2);
            table1.Rows.Add(row2);
            table1.Rows.Add(row2);

            Paragraph p1 = new Paragraph();

            p1.Add("Table with style");

            Paragraph p2 = new Paragraph();

            doc.Body.Add(p1);
            doc.Body.Add(p2);
            doc.Body.Add(table1);

            doc.Save("c:\\test\\output.odt", true);
        }
Ejemplo n.º 6
0
        //To export the dataGridView to pdf
        public void exportgridviewtopdf(DataGridView dgvAccounts, string filename)
        {
            ////Report Header
            BaseFont  head = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1250, BaseFont.NOT_EMBEDDED);
            Paragraph p    = new Paragraph();

            p.Alignment = Element.ALIGN_CENTER;
            p.Add(new Chunk("KERICHO COUNTY REFERRAL HOSPITAL"));
            p.Add(new Chunk("\nP.O BOX 11 -20200 KERICHO"));
            p.Add(new Chunk("\nDate: " + DateTime.Now.ToShortDateString()));

            //Line Separation
            Paragraph pra = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(1.0F, 100.0F, BaseColor.BLACK, Element.ALIGN_LEFT, 1)));

            p.Add(new Chunk("\n"));

            //Table Head
            Paragraph p2 = new Paragraph();

            p2.Alignment = Element.ALIGN_CENTER;
            p2.Add(new Chunk("Statement of Accounts"));

            //Table Data
            BaseFont  bf      = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1250, BaseFont.EMBEDDED);
            PdfPTable records = new PdfPTable(dgvAccounts.Columns.Count);

            records.DefaultCell.Padding = 1;
            records.WidthPercentage     = 100;
            PdfPCell cells = new PdfPCell();

            records.HorizontalAlignment     = Element.ALIGN_LEFT;
            records.DefaultCell.BorderWidth = 1;


            iTextSharp.text.Font text = new iTextSharp.text.Font(bf, 10, iTextSharp.text.Font.NORMAL);
            //For header
            foreach (DataGridViewColumn column in dgvAccounts.Columns)
            {
                PdfPCell cell = new PdfPCell(new Phrase(column.HeaderText, text));
                cell.BackgroundColor = new iTextSharp.text.BaseColor(240, 240, 240);
                records.AddCell(cell);
            }
            //Add datarow
            foreach (DataGridViewRow row in dgvAccounts.Rows)
            {
                foreach (DataGridViewCell cell in row.Cells)
                {
                    records.AddCell(new Phrase(cell.Value.ToString(), text));
                }
            }

            var savefiledialoge = new SaveFileDialog();

            savefiledialoge.FileName   = filename;
            savefiledialoge.DefaultExt = ".pdf";
            if (savefiledialoge.ShowDialog() == DialogResult.OK)
            {
                using (FileStream stream = new FileStream(savefiledialoge.FileName, FileMode.Create))
                {
                    Document pdfdoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
                    PdfWriter.GetInstance(pdfdoc, stream);
                    pdfdoc.Open();
                    pdfdoc.Add(p);
                    pdfdoc.Add(pra);
                    pdfdoc.Add(p2);
                    pdfdoc.Add(new Chunk("\n"));
                    pdfdoc.Add(records);
                    pdfdoc.Close();
                    stream.Close();
                }
            }
        }
Ejemplo n.º 7
0
        private void bgworker_DoWork(object sender, DoWorkEventArgs e)
        {
            pic_loading.Invoke(new Action(() =>
            {
                pic_loading.Visible = true;
                btn_submit.Enabled  = false;
            }));
            String query = "", empid = "", date_from = "", date_to = "", pay_code = "", table = "hr_dtr_sum_files", filename = "", code = "", col = "", val = "", date_in = "", employee_name = "", days_worked = "", absent_total = "", employee_id = "";

            Double legal_hol_ot = 0.00, special_hol_ot = 0.00, dayoff_ot_total = 0.00, late_total = 0.00, ut_total = 0.00, ot_total = 0.00;

            DataTable pay_period = null;

            query = "SELECT empid,firstname,lastname FROM rssys.hr_employee";
            cbo_employee.Invoke(new Action(() => {
                if (cbo_employee.SelectedIndex != -1)
                {
                    empid  = cbo_employee.SelectedValue.ToString();
                    query += " WHERE empid='" + empid + "'";
                }
            }));



            query += " ORDER BY empid ASC";
            DataTable employees = db.QueryBySQLCode(query);

            cbo_payollperiod.Invoke(new Action(() =>
            {
                pay_code = cbo_payollperiod.SelectedValue.ToString();
            }));


            pay_period = get_date(pay_code);

            if (pay_period.Rows.Count > 0)
            {
                date_from = DateTime.Parse(pay_period.Rows[0]["date_from"].ToString()).ToShortDateString();
                date_to   = DateTime.Parse(pay_period.Rows[0]["date_to"].ToString()).ToShortDateString();
            }


            filename  = RandomString(5) + "_" + DateTime.Now.ToString("yyyy-MM-dd");
            filename += ".pdf";



            System.IO.FileStream fs = new FileStream(fileloc_dtr + "/ViewController/RPT/TimeKeeping/dtr_summary_pdf/" + filename, FileMode.Create);



            Document document = new Document(PageSize.LEGAL.Rotate(), 25, 25, 30, 30);

            PdfWriter.GetInstance(document, fs);
            document.Open();

            BaseFont bf = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);

            iTextSharp.text.Font font = new iTextSharp.text.Font(bf, 9, iTextSharp.text.Font.NORMAL);

            Paragraph paragraph = new Paragraph();

            paragraph.Alignment = Element.ALIGN_CENTER;
            paragraph.Font      = FontFactory.GetFont("Arial", 12);
            paragraph.SetLeading(1, 1);
            paragraph.Add("DAILY TIME RECORD SUMMARY");



            Phrase line_break = new Phrase("\n");

            document.Add(paragraph);
            document.Add(line_break);

            Paragraph paragraph_2 = new Paragraph();

            paragraph_2.Alignment = Element.ALIGN_CENTER;
            paragraph_2.Font      = FontFactory.GetFont("Arial", 12);
            paragraph_2.SetLeading(1, 1);
            paragraph_2.Add("For the payroll period " + date_from + " to " + date_to);


            Phrase line_break_2 = new Phrase("\n");

            document.Add(paragraph_2);
            document.Add(line_break_2);


            PdfPTable t = new PdfPTable(9);

            float[] widths = new float[] { 10, 10, 10, 10, 10, 10, 10, 10, 10 };
            t.WidthPercentage = 100;
            t.SetWidths(widths);

            t.AddCell(new PdfPCell(new Phrase(new Chunk("Employee Name", font)))
            {
                HorizontalAlignment = Element.ALIGN_LEFT
            });
            t.AddCell(new PdfPCell(new Phrase(new Chunk("Days Worked (# days)", font)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER
            });
            t.AddCell(new PdfPCell(new Phrase(new Chunk("Abcences (# days)", font)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER
            });
            t.AddCell(new PdfPCell(new Phrase(new Chunk("Total Late (Hrs/Amt.)", font)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER
            });

            t.AddCell(new PdfPCell(new Phrase(new Chunk("Total Undertime(Hrs/Amt.)", font)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER
            });
            //t.AddCell(new PdfPCell(new Phrase(new Chunk("Total Overtime", font))) { HorizontalAlignment = Element.ALIGN_CENTER });

            t.AddCell(new PdfPCell(new Phrase(new Chunk("Reg OT(Hrs/Amt.)", font)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER
            });
            t.AddCell(new PdfPCell(new Phrase(new Chunk("Dayoff OT(Hrs/Amt.)", font)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER
            });
            t.AddCell(new PdfPCell(new Phrase(new Chunk("Legal Hol. OT(Hrs/Amt.)", font)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER
            });
            t.AddCell(new PdfPCell(new Phrase(new Chunk("Special Hol. OT(Hrs/Amt.)", font)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER
            });



            for (int r = 0; r < employees.Rows.Count; r++)
            {
                legal_hol_ot    = 0.00;
                special_hol_ot  = 0.00;
                employee_id     = employees.Rows[r]["empid"].ToString();
                employee_name   = employees.Rows[r]["firstname"].ToString() + ", " + employees.Rows[r]["lastname"].ToString();
                days_worked     = compute_daysworked(employee_id, date_from, date_to);
                absent_total    = compute_absent(employee_id, date_from, date_to, days_worked);
                late_total      = compute_late(employee_id, date_from, date_to);
                ut_total        = compute_undertime(employee_id, date_from, date_to);
                ot_total        = compute_overtime(employee_id, date_from, date_to);
                dayoff_ot_total = get_dayoff_ot_total(employee_id, pay_code);


                legal_hol_ot   = get_legal_hol_ot(employee_id, pay_code);
                special_hol_ot = get_special_hol_ot(employee_id, pay_code);



                t.AddCell(new PdfPCell(new Phrase(new Chunk(employee_name, font)))
                {
                    HorizontalAlignment = Element.ALIGN_LEFT
                });
                t.AddCell(new PdfPCell(new Phrase(new Chunk(days_worked, font)))
                {
                    HorizontalAlignment = Element.ALIGN_CENTER
                });
                t.AddCell(new PdfPCell(new Phrase(new Chunk(absent_total, font)))
                {
                    HorizontalAlignment = Element.ALIGN_CENTER
                });
                if (late_total > 0)
                {
                    t.AddCell(new PdfPCell(new Phrase(new Chunk(late_total.ToString("0.00"), font)))
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER
                    });
                }
                else
                {
                    t.AddCell(new PdfPCell(new Phrase(new Chunk("", font)))
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER
                    });
                }
                if (ut_total > 0)
                {
                    t.AddCell(new PdfPCell(new Phrase(new Chunk(ut_total.ToString("0.00"), font)))
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER
                    });
                }
                else
                {
                    t.AddCell(new PdfPCell(new Phrase(new Chunk("", font)))
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER
                    });
                }

                if (ot_total > 0)
                {
                    t.AddCell(new PdfPCell(new Phrase(new Chunk(ot_total.ToString("0.00"), font)))
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER
                    });
                }
                else
                {
                    t.AddCell(new PdfPCell(new Phrase(new Chunk("", font)))
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER
                    });
                }

                //t.AddCell(new PdfPCell(new Phrase(new Chunk("0", font))) { HorizontalAlignment = Element.ALIGN_CENTER });
                if (dayoff_ot_total > 0)
                {
                    t.AddCell(new PdfPCell(new Phrase(new Chunk(dayoff_ot_total.ToString("0.00"), font)))
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER
                    });
                }
                else
                {
                    t.AddCell(new PdfPCell(new Phrase(new Chunk("", font)))
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER
                    });
                }

                if (legal_hol_ot > 0)
                {
                    t.AddCell(new PdfPCell(new Phrase(new Chunk(legal_hol_ot.ToString("0.00"), font)))
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER
                    });
                }
                else
                {
                    t.AddCell(new PdfPCell(new Phrase(new Chunk("", font)))
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER
                    });
                }
                if (special_hol_ot > 0)
                {
                    t.AddCell(new PdfPCell(new Phrase(new Chunk(special_hol_ot.ToString("0.00"), font)))
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER
                    });
                }
                else
                {
                    t.AddCell(new PdfPCell(new Phrase(new Chunk("", font)))
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER
                    });
                }
            }


            document.Add(t);
            document.Close();


            code = db.get_pk("dtr_sum_id");
            col  = "dtr_sum_id,filename,date_created";
            val  = "'" + code + "','" + filename + "','" + DateTime.Now.ToShortDateString() + "'";

            if (db.InsertOnTable(table, col, val))
            {
                db.set_pkm99("dtr_sum_id", db.get_nextincrementlimitchar(code, 8)); //changes from 'hr_empid'
                MessageBox.Show("New DTR Summary created.");
            }
            else
            {
                MessageBox.Show("Failed on saving.");
            }
            pic_loading.Invoke(new Action(() => {
                pic_loading.Visible = false;
                btn_submit.Enabled  = true;
            }));

            display_list();
        }
Ejemplo n.º 8
0
        public MemoryStream GeneratePdfTemplate(GarmentCoverLetterViewModel viewModel, GarmentPackingListViewModel pl, Buyer buyer, int timeoffset)
        {
            const int MARGIN = 20;

            Font header_font_bold       = FontFactory.GetFont(BaseFont.HELVETICA_BOLD, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 12);
            Font header_font            = FontFactory.GetFont(BaseFont.HELVETICA, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 11);
            Font normal_font            = FontFactory.GetFont(BaseFont.HELVETICA, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 8);
            Font normal_font_underlined = FontFactory.GetFont(BaseFont.HELVETICA, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 8, Font.UNDERLINE);
            Font bold_font  = FontFactory.GetFont(BaseFont.HELVETICA_BOLD, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 8);
            Font small_font = FontFactory.GetFont(BaseFont.HELVETICA, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 5);
            //Font body_bold_font = FontFactory.GetFont(BaseFont.HELVETICA_BOLD, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 8);

            Document     document = new Document(PageSize.A4, MARGIN, MARGIN, 140, MARGIN);
            MemoryStream stream   = new MemoryStream();
            PdfWriter    writer   = PdfWriter.GetInstance(document, stream);

            writer.PageEvent = new GarmentCoverLetterPdfTemplatePageEvent();
            document.Open();

            PdfPTable tableTitle = new PdfPTable(1);

            tableTitle.WidthPercentage = 100;
            tableTitle.SetWidths(new float[] { 6f });
            PdfPCell cellTitle = new PdfPCell()
            {
                MinimumHeight = 15, Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_CENTER
            };

            //cellTitle.Phrase = new Phrase("Ref No. : FM-00-SP-24-008", header_font);
            //tableTitle.AddCell(cellTitle);
            cellTitle.Phrase = new Phrase("SURAT PENGANTAR", header_font_bold);
            tableTitle.AddCell(cellTitle);
            cellTitle.Phrase = new Phrase(viewModel.invoiceNo, header_font_bold);
            tableTitle.AddCell(cellTitle);

            tableTitle.SpacingAfter = 10;
            document.Add(tableTitle);

            #region header
            PdfPTable tableHeader = new PdfPTable(3);
            tableHeader.WidthPercentage = 100;
            tableHeader.SetWidths(new float[] { 3f, 1.5f, 2f });
            PdfPCell cellHeaderLeft = new PdfPCell()
            {
                MinimumHeight = 15, Border = Rectangle.BOTTOM_BORDER | Rectangle.LEFT_BORDER | Rectangle.RIGHT_BORDER | Rectangle.TOP_BORDER, HorizontalAlignment = Element.ALIGN_LEFT
            };

            cellHeaderLeft.Phrase = new Phrase("Kepada Yth.\n\n" +
                                               //$"{viewModel.emkl.Name} \n\n" +
                                               $"{viewModel.destination} \n" +
                                               $"{viewModel.address} \n" +
                                               $"PIC : {viewModel.pic} \n\n" +
                                               $"Forwarder : {viewModel.forwarder.name} \n\n" +
                                               $"ATTN  : {viewModel.attn} \n" +
                                               $"PHONE : {viewModel.phone}", normal_font);
            cellHeaderLeft.Rowspan = 7;
            tableHeader.AddCell(cellHeaderLeft);

            cellHeaderLeft.Phrase  = new Phrase("Tanggal", normal_font);
            cellHeaderLeft.Rowspan = 1;
            tableHeader.AddCell(cellHeaderLeft);
            cellHeaderLeft.Phrase = new Phrase(viewModel.date.GetValueOrDefault().ToOffset(new TimeSpan(timeoffset, 0, 0)).ToString("dd MMMM yyyy", new System.Globalization.CultureInfo("en-EN")), normal_font);
            tableHeader.AddCell(cellHeaderLeft);

            cellHeaderLeft.Phrase = new Phrase("Order ", normal_font);
            tableHeader.AddCell(cellHeaderLeft);
            cellHeaderLeft.Phrase = new Phrase(viewModel.order.Name, normal_font);
            tableHeader.AddCell(cellHeaderLeft);

            cellHeaderLeft.Phrase = new Phrase("Jumlah Pcs ", normal_font);
            tableHeader.AddCell(cellHeaderLeft);
            cellHeaderLeft.Phrase = new Phrase(viewModel.pcsQuantity == 0 ? "-" : $"{ string.Format("{0:n0}", viewModel.pcsQuantity)} PCS", normal_font);
            tableHeader.AddCell(cellHeaderLeft);

            cellHeaderLeft.Phrase = new Phrase("Jumlah Sets", normal_font);
            tableHeader.AddCell(cellHeaderLeft);
            cellHeaderLeft.Phrase = new Phrase(viewModel.setsQuantity == 0 ? "-" : $"{ string.Format("{0:n0}", viewModel.setsQuantity)} SETS", normal_font);
            tableHeader.AddCell(cellHeaderLeft);

            cellHeaderLeft.Phrase = new Phrase("Jumlah Packs", normal_font);
            tableHeader.AddCell(cellHeaderLeft);
            cellHeaderLeft.Phrase = new Phrase(viewModel.packQuantity == 0 ? "-" : $"{ string.Format("{0:n0}", viewModel.packQuantity)} PACKS", normal_font);
            tableHeader.AddCell(cellHeaderLeft);


            cellHeaderLeft.Phrase = new Phrase("Jumlah Collie", normal_font);
            tableHeader.AddCell(cellHeaderLeft);
            cellHeaderLeft.Phrase = new Phrase($"{ string.Format("{0:n0}", viewModel.cartoonQuantity)} COLLIE", normal_font);
            tableHeader.AddCell(cellHeaderLeft);

            cellHeaderLeft.Phrase = new Phrase("Invoice No.", normal_font);
            tableHeader.AddCell(cellHeaderLeft);
            cellHeaderLeft.Phrase = new Phrase(viewModel.invoiceNo, normal_font);
            tableHeader.AddCell(cellHeaderLeft);

            tableHeader.SpacingAfter = 10;
            document.Add(tableHeader);
            #endregion

            document.Add(new Paragraph("Dengan hormat,", normal_font));
            document.Add(new Paragraph("\n", normal_font));
            document.Add(new Paragraph("      Bersama ini kami kirimkan kepada Bapak sejumlah barang dengan", normal_font));

            document.Add(new Paragraph("\n", normal_font));
            document.Add(new Paragraph("\n", normal_font));

            #region detail
            PdfPTable tableDetail = new PdfPTable(7);
            tableDetail.WidthPercentage = 100;
            tableDetail.SetWidths(new float[] { 1f, 1f, 1f, 1f, 1f, 1f, 1f });
            PdfPCell cellDetail = new PdfPCell()
            {
                MinimumHeight = 15, Border = Rectangle.BOTTOM_BORDER | Rectangle.LEFT_BORDER | Rectangle.RIGHT_BORDER | Rectangle.TOP_BORDER, HorizontalAlignment = Element.ALIGN_LEFT
            };

            double cbmtotal = 0;
            if (pl.Measurements.Count > 0)
            {
                foreach (var m in pl.Measurements)
                {
                    double cbm = (m.Length * m.Width * m.Height * m.CartonsQuantity) / 1000000;
                    cbmtotal += cbm;
                }
            }

            cellDetail.Phrase = new Phrase("Truck", normal_font);
            tableDetail.AddCell(cellDetail);
            cellDetail.Phrase = new Phrase("Nomor Polisi", normal_font);
            tableDetail.AddCell(cellDetail);
            cellDetail.Phrase = new Phrase("Pengemudi", normal_font);
            tableDetail.AddCell(cellDetail);
            cellDetail.Phrase = new Phrase("No Kontainer", normal_font);
            tableDetail.AddCell(cellDetail);
            cellDetail.Phrase = new Phrase("Seal Pelayaran", normal_font);
            tableDetail.AddCell(cellDetail);
            cellDetail.Phrase = new Phrase("Seal Dan Liris", normal_font);
            tableDetail.AddCell(cellDetail);
            cellDetail.Phrase = new Phrase("Jumlah Muatan", normal_font);
            tableDetail.AddCell(cellDetail);

            Paragraph Truck = new Paragraph($"EMKL : {viewModel.emkl.Name} \n\n" +
                                            $"Truk : {viewModel.truck}", normal_font);
            cellDetail.Phrase            = Truck;
            cellDetail.VerticalAlignment = Element.ALIGN_TOP;
            tableDetail.AddCell(cellDetail);

            cellDetail.Phrase = new Phrase(viewModel.plateNumber, normal_font);
            tableDetail.AddCell(cellDetail);
            cellDetail.Phrase = new Phrase(viewModel.driver, normal_font);
            tableDetail.AddCell(cellDetail);
            cellDetail.Phrase = new Phrase(viewModel.containerNo, normal_font);
            tableDetail.AddCell(cellDetail);
            cellDetail.Phrase = new Phrase(viewModel.shippingSeal, normal_font);
            tableDetail.AddCell(cellDetail);
            cellDetail.Phrase = new Phrase(viewModel.dlSeal, normal_font);
            tableDetail.AddCell(cellDetail);
            Paragraph weight = new Paragraph($"GW  : {string.Format("{0:n2}", pl.GrossWeight)} KGS \n\n" +
                                             $"NW  : {string.Format("{0:n2}", pl.NettWeight)} KGS \n\n" +
                                             $"Volume : {string.Format("{0:n2}", Math.Round(cbmtotal, 2))} m", normal_font);
            Chunk chunk = new Chunk("3", small_font);
            chunk.SetTextRise(2);
            Paragraph m2 = new Paragraph(chunk);
            m2.Alignment = Element.ALIGN_TOP;
            weight.Add(m2);
            cellDetail.Phrase            = weight;
            cellDetail.VerticalAlignment = Element.ALIGN_TOP;
            tableDetail.AddCell(cellDetail);

            tableDetail.SpacingAfter = 10;
            document.Add(tableDetail);
            #endregion

            #region marks
            PdfPTable tableMark = new PdfPTable(4);
            tableMark.WidthPercentage = 100;
            tableMark.SetWidths(new float[] { 1f, 3f, 1f, 3f });
            PdfPCell cellMark = new PdfPCell()
            {
                MinimumHeight = 15, Border = Rectangle.BOTTOM_BORDER, HorizontalAlignment = Element.ALIGN_LEFT
            };

            cellMark.Phrase  = new Phrase("Shippig Mark :", normal_font);
            cellMark.Rowspan = 2;
            tableMark.AddCell(cellMark);

            cellMark.Phrase = new Phrase(pl.ShippingMark, normal_font);
            tableMark.AddCell(cellMark);

            string sealType = "";
            string seal     = "";
            if (!string.IsNullOrEmpty(viewModel.shippingSeal))
            {
                sealType += "Seal Pelayaran \n";
                seal     += ": " + viewModel.shippingSeal + "\n";
            }
            if (!string.IsNullOrEmpty(viewModel.dlSeal))
            {
                sealType += "Seal DL \n";
                seal     += ": " + viewModel.dlSeal + "\n";
            }
            if (!string.IsNullOrEmpty(viewModel.emklSeal))
            {
                sealType += "Seal EMKL \n";
                seal     += ": " + viewModel.emklSeal + "\n";
            }


            cellMark.Phrase              = new Phrase(sealType, normal_font);
            cellMark.Rowspan             = 1;
            cellMark.Border              = Rectangle.NO_BORDER;
            cellMark.HorizontalAlignment = Element.ALIGN_LEFT;
            tableMark.AddCell(cellMark);

            cellMark.Phrase              = new Phrase(seal, normal_font);
            cellMark.Rowspan             = 1;
            cellMark.Border              = Rectangle.NO_BORDER;
            cellMark.HorizontalAlignment = Element.ALIGN_LEFT;
            tableMark.AddCell(cellMark);

            //cellMark.Phrase = new Phrase("SEND TO          :", normal_font);
            //cellMark.Colspan = 1;
            //cellMark.HorizontalAlignment = Element.ALIGN_RIGHT;
            //cellMark.Border = Rectangle.BOTTOM_BORDER;
            //tableMark.AddCell(cellMark);

            //cellMark.Phrase = new Phrase($"{buyer.Name} \n" +
            //                             $"{buyer.Address} \n", normal_font);
            //cellMark.HorizontalAlignment = Element.ALIGN_LEFT;
            //tableMark.AddCell(cellMark);

            //tableMark.SpacingAfter = 15;
            //document.Add(tableMark);
            #endregion

            document.Add(new Paragraph("Demikian harap diterima dengan baik dan terima kasih.", normal_font));
            document.Add(new Paragraph("\n", normal_font));
            document.Add(new Paragraph("\n", normal_font));

            #region sign
            PdfPTable tableSign = new PdfPTable(5);
            tableSign.WidthPercentage = 100;
            tableSign.SetWidths(new float[] { 1f, 1f, 1f, 1f, 1f });
            PdfPCell cellSign = new PdfPCell()
            {
                MinimumHeight = 15, Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_CENTER
            };

            cellSign.Phrase  = new Phrase("Pengemudi Truck, \n\n\n\n\n\n", normal_font);
            cellSign.Colspan = 1;
            tableSign.AddCell(cellSign);

            cellSign.Phrase  = new Phrase("Mengetahui, \n\n\n\n\n\n", normal_font);
            cellSign.Colspan = 2;
            tableSign.AddCell(cellSign);

            cellSign.Phrase  = new Phrase("                          Hormat Kami, \n\n\n\n\n\n", normal_font);
            cellSign.Colspan = 1;
            tableSign.AddCell(cellSign);

            cellSign.Phrase  = new Phrase("             \n\n\n\n\n\n", normal_font);
            cellSign.Colspan = 1;
            tableSign.AddCell(cellSign);

            cellSign.Phrase = new Phrase("__________________", normal_font);
            tableSign.AddCell(cellSign);

            cellSign.Phrase = new Phrase("__________________", normal_font);
            tableSign.AddCell(cellSign);

            cellSign.Phrase = new Phrase("__________________", normal_font);
            tableSign.AddCell(cellSign);

            cellSign.Phrase = new Phrase("__________________", normal_font);
            tableSign.AddCell(cellSign);

            cellSign.Phrase = new Phrase("(    " + viewModel.shippingStaff.name + "    )", normal_font);
            tableSign.AddCell(cellSign);

            cellSign.Phrase = new Phrase("", normal_font);
            tableSign.AddCell(cellSign);

            cellSign.Phrase = new Phrase("Pembukuan DL", normal_font);
            tableSign.AddCell(cellSign);

            cellSign.Phrase = new Phrase("Sat Pam", normal_font);
            tableSign.AddCell(cellSign);

            cellSign.Phrase = new Phrase("Konfeksi " + $"{viewModel.unit}", normal_font);
            tableSign.AddCell(cellSign);

            cellSign.Phrase = new Phrase("Shipping Staff", normal_font);
            tableSign.AddCell(cellSign);

            cellSign.Phrase = new Phrase("\n\n\n\n\n\n\n\n\n\n\n\n\n", normal_font);
            tableSign.AddCell(cellSign);
            cellSign.Phrase = new Phrase("\n\n\n\n\n\n\n\n\n\n\n\n\n", normal_font);
            tableSign.AddCell(cellSign);
            cellSign.Phrase = new Phrase("\n\n\n\n\n\n\n\n\n\n\n\n\n", normal_font);
            tableSign.AddCell(cellSign);
            cellSign.Phrase = new Phrase("\n\n\n\n\n\n\n\n\n\n\n\n\n", normal_font);
            tableSign.AddCell(cellSign);
            cellSign.Phrase = new Phrase("\n\n\n\n\n\n\n\n\n\n\n\n\n", normal_font);
            tableSign.AddCell(cellSign);

            cellSign.Phrase = new Phrase("JAM MASUK : ______", normal_font);
            tableSign.AddCell(cellSign);
            cellSign.Phrase = new Phrase(" ", normal_font);
            tableSign.AddCell(cellSign);
            cellSign.Phrase = new Phrase(" ", normal_font);
            tableSign.AddCell(cellSign);
            cellSign.Phrase = new Phrase(" ", normal_font);
            tableSign.AddCell(cellSign);
            cellSign.Phrase = new Phrase(" ", normal_font);
            tableSign.AddCell(cellSign);

            cellSign.Phrase = new Phrase("JAM KELUAR : ______", normal_font);
            tableSign.AddCell(cellSign);
            cellSign.Phrase = new Phrase(" ", normal_font);
            tableSign.AddCell(cellSign);
            cellSign.Phrase = new Phrase(" ", normal_font);
            tableSign.AddCell(cellSign);
            cellSign.Phrase = new Phrase(" ", normal_font);
            tableSign.AddCell(cellSign);
            cellSign.Phrase = new Phrase(" ", normal_font);
            tableSign.AddCell(cellSign);

            cellSign.Phrase = new Phrase("\n\n", normal_font);
            tableSign.AddCell(cellSign);
            cellSign.Phrase = new Phrase("\n\n", normal_font);
            tableSign.AddCell(cellSign);
            cellSign.Phrase = new Phrase("\n\n", normal_font);
            tableSign.AddCell(cellSign);
            cellSign.Phrase = new Phrase("\n\n", normal_font);
            tableSign.AddCell(cellSign);
            cellSign.Phrase = new Phrase("\n\n", normal_font);
            tableSign.AddCell(cellSign);


            cellSign.Phrase = new Phrase("CATATAN : \n" +
                                         "1. Mohon bisa dikirim kembali Pengantar ini apabila barang sudah diterima \n" +
                                         "2. ....................................................", normal_font);
            cellSign.Colspan             = 3;
            cellSign.HorizontalAlignment = Element.ALIGN_LEFT;
            tableSign.AddCell(cellSign);

            cellSign.Phrase              = new Phrase("Diterima, \n\n\n\n\n\n", normal_font);
            cellSign.Rowspan             = 1;
            cellSign.HorizontalAlignment = Element.ALIGN_CENTER;
            tableSign.AddCell(cellSign);

            cellSign.Phrase              = new Phrase("", normal_font);
            cellSign.Colspan             = 3;
            cellSign.HorizontalAlignment = Element.ALIGN_LEFT;
            tableSign.AddCell(cellSign);

            cellSign.Phrase  = new Phrase("                              (__________________)", normal_font);
            cellSign.Rowspan = 1;
            tableSign.AddCell(cellSign);
            cellSign.Phrase              = new Phrase(" ", normal_font);
            cellSign.Colspan             = 3;
            cellSign.HorizontalAlignment = Element.ALIGN_LEFT;
            tableSign.AddCell(cellSign);

            cellSign.Phrase  = new Phrase("                              JAM DITERIMA : ______", normal_font);
            cellSign.Rowspan = 1;
            tableSign.AddCell(cellSign);


            document.Add(tableSign);
            #endregion

            document.Close();
            byte[] byteInfo = stream.ToArray();
            stream.Write(byteInfo, 0, byteInfo.Length);
            stream.Position = 0;

            return(stream);
        }
Ejemplo n.º 9
0
        public FileStreamResult printProjectForm(string PRJID)
        {
            var preBidDetails = HomeDal.getPreBidFormByProject(PRJID);
            // Set up the document and the MS to write it to and create the PDF writer instance
            MemoryStream ms       = new MemoryStream();
            Document     document = new Document(PageSize.A4);
            PdfWriter    writer   = PdfWriter.GetInstance(document, ms);

            // Open the PDF document
            document.Open();

            // Set up fonts used in the document
            var LightBlue = new BaseColor(14, 45, 76);
            var grey      = new BaseColor(119, 119, 119);

            iTextSharp.text.Font font_heading_1 = FontFactory.GetFont(FontFactory.HELVETICA_BOLD, 17, LightBlue);
            iTextSharp.text.Font font_body      = FontFactory.GetFont(FontFactory.HELVETICA, 12, LightBlue);
            iTextSharp.text.Font font_body_bold = FontFactory.GetFont(FontFactory.HELVETICA_BOLD, 12, LightBlue);
            iTextSharp.text.Font spanBold       = FontFactory.GetFont(FontFactory.HELVETICA_BOLD, 12, grey);
            iTextSharp.text.Font spanNormal     = FontFactory.GetFont(FontFactory.HELVETICA, 11, grey);

            preBidDetails.JobNumber = (string.IsNullOrWhiteSpace(preBidDetails.JobNumber) ? BusinessConstants.NA : preBidDetails.JobNumber);
            // Create the heading paragraph with the headig font
            Paragraph header;

            header = new Paragraph("Pre-Bid [" + Convert.ToString(Session["CommID"]) + (preBidDetails.PRJID) + "] Roll-Up", font_heading_1);
            iTextSharp.text.pdf.draw.VerticalPositionMark seperator = new iTextSharp.text.pdf.draw.LineSeparator();
            seperator.Offset = -4f;
            header.Add(seperator);
            document.Add(header);

            var HeaderTable = new PdfPTable(4);

            HeaderTable.HorizontalAlignment = 0;
            HeaderTable.SpacingBefore       = 5;
            HeaderTable.SpacingAfter        = 5;
            HeaderTable.DefaultCell.Border  = 0;
            HeaderTable.SetWidths(new int[] { 4, 7, 3, 4 });

            HeaderTable.AddCell(new Phrase("Form Type:", spanBold));
            HeaderTable.AddCell(new Phrase(preBidDetails.FormType, spanNormal));
            HeaderTable.AddCell(new Phrase());
            HeaderTable.AddCell(new Phrase());

            HeaderTable.AddCell(new Phrase("JobNumber:", spanBold));
            HeaderTable.AddCell(new Phrase(preBidDetails.JobNumber, spanNormal));
            HeaderTable.AddCell(new Phrase("Job Name:", spanBold));
            HeaderTable.AddCell(new Phrase(preBidDetails.JobName, spanNormal));
            HeaderTable.AddCell(new Phrase("Sales Person:", spanBold));
            HeaderTable.AddCell(new Phrase(Convert.ToString(preBidDetails.SalesPerson), spanNormal));
            HeaderTable.AddCell(new Phrase("Company:", spanBold));
            HeaderTable.AddCell(new Phrase(preBidDetails.Company, spanNormal));

            HeaderTable.AddCell(new Phrase("Rate Type:", spanBold));
            HeaderTable.AddCell(new Phrase(preBidDetails.RateType, spanNormal));
            HeaderTable.AddCell(new Phrase());
            HeaderTable.AddCell(new Phrase());
            HeaderTable.TotalWidth = 100;
            document.Add(HeaderTable);

            var SectionTable = new PdfPTable(3);

            SectionTable.HorizontalAlignment = 0;
            SectionTable.SpacingBefore       = 5;
            SectionTable.SpacingAfter        = 5;
            SectionTable.DefaultCell.Border  = 0;
            SectionTable.SetWidths(new int[] { 7, 4, 4 });
            SectionTable.AddCell(getLabelValue("Material Cost:", font_body));
            SectionTable.AddCell(getDecimalValue(preBidDetails.Material, spanNormal));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Material Handling Charge:", font_body));
            SectionTable.AddCell(getDecimalValue(preBidDetails.MaterialHandling, spanNormal));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Concrete:", font_body));
            SectionTable.AddCell(getDecimalValue(preBidDetails.Concrete, spanNormal));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Material Total:", font_body));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));
            SectionTable.AddCell(getDecimalValue(preBidDetails.MaterialTotal, font_body_bold));

            SectionTable.AddCell(getLabelValue("     ", spanNormal));
            SectionTable.AddCell(getLabelValue("     ", spanNormal));
            SectionTable.AddCell(getLabelValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Onsite Labor:", font_body));
            SectionTable.AddCell(getDecimalValue(preBidDetails.OnsiteLabor, spanNormal));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Load Labor:", font_body));
            SectionTable.AddCell(getDecimalValue(preBidDetails.LoadLabor, spanNormal));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Drive Labor:", font_body));
            SectionTable.AddCell(getDecimalValue(preBidDetails.DriveLabor, spanNormal));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Supervisor:", font_body));
            SectionTable.AddCell(getDecimalValue(preBidDetails.Supervisor, spanNormal));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Labor Reserve:", font_body));
            SectionTable.AddCell(getDecimalValue(preBidDetails.LaborReserve, spanNormal));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Labor Total:", font_body));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));
            SectionTable.AddCell(getDecimalValue(preBidDetails.LaborTotal, font_body_bold));

            SectionTable.AddCell(getLabelValue("     ", spanNormal));
            SectionTable.AddCell(getLabelValue("     ", spanNormal));
            SectionTable.AddCell(getLabelValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Other Charges:", font_body));
            SectionTable.AddCell(getDecimalValue(preBidDetails.OtherCharges, spanNormal));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Other Charges Markup:", font_body));
            SectionTable.AddCell(getDecimalValue(preBidDetails.OtherChargesMarkup, spanNormal));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Other Charges Total:", font_body));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));
            SectionTable.AddCell(getDecimalValue(preBidDetails.OtherChargesTotal, font_body_bold));

            SectionTable.AddCell(getLabelValue("     ", spanNormal));
            SectionTable.AddCell(getLabelValue("     ", spanNormal));
            SectionTable.AddCell(getLabelValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Equipment Cost:", font_body));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));
            SectionTable.AddCell(getDecimalValue(preBidDetails.EquipmentCost, font_body_bold));

            SectionTable.AddCell(getLabelValue("     ", spanNormal));
            SectionTable.AddCell(getLabelValue("     ", spanNormal));
            SectionTable.AddCell(getLabelValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Benefits:", font_body));
            SectionTable.AddCell(getDecimalValue(preBidDetails.Benefits, spanNormal));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Retirement:", font_body));
            SectionTable.AddCell(getDecimalValue(preBidDetails.Retirement, spanNormal));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Payroll Tax:", font_body));
            SectionTable.AddCell(getDecimalValue(preBidDetails.PayrollTax, spanNormal));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Workers Comp:", font_body));
            SectionTable.AddCell(getDecimalValue(preBidDetails.WorkersComp, spanNormal));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Indirect Total:", font_body));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));
            SectionTable.AddCell(getDecimalValue(preBidDetails.IndirectTotal, font_body_bold));

            SectionTable.AddCell(getLabelValue("     ", spanNormal));
            SectionTable.AddCell(getLabelValue("     ", spanNormal));
            SectionTable.AddCell(getLabelValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Job Cost:", font_body));
            SectionTable.AddCell(getDecimalValue(preBidDetails.JobCost, spanNormal));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Job Markup:", font_body));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));
            SectionTable.AddCell(getDecimalValue(preBidDetails.JobMarkUpTotal, font_body_bold));

            SectionTable.AddCell(getLabelValue("Suggested Sold For:", font_body));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));
            SectionTable.AddCell(getDecimalValue(preBidDetails.SuggestdSoldFor, font_body_bold));

            SectionTable.AddCell(getLabelValue("Pre-Tax Sold For:", font_body));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));
            SectionTable.AddCell(getDecimalValue(preBidDetails.PreTaxSoldFor, font_body_bold));

            SectionTable.AddCell(getLabelValue("     ", spanNormal));
            SectionTable.AddCell(getLabelValue("     ", spanNormal));
            SectionTable.AddCell(getLabelValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Sales Tax Total:", font_body));
            SectionTable.AddCell(getDecimalValue("     ", spanNormal));
            SectionTable.AddCell(getDecimalValue(preBidDetails.SalesTaxTotal, font_body_bold));

            SectionTable.AddCell(getLabelValue("     ", spanNormal));
            SectionTable.AddCell(getLabelValue("     ", spanNormal));
            SectionTable.AddCell(getLabelValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Days On Site:", font_body));
            SectionTable.AddCell(getDecimalValue(preBidDetails.DaysOnsite, spanNormal, hasBorder: false, plainText: true));
            SectionTable.AddCell(getLabelValue("     ", spanNormal));

            SectionTable.AddCell(getLabelValue("Crew Labor Budget:", font_body));
            SectionTable.AddCell(getDecimalValue(preBidDetails.CrewLaborBudget, spanNormal, hasBorder: false));
            SectionTable.AddCell(getLabelValue("     ", spanNormal));

            document.Add(SectionTable);

            document.Close();
            byte[]       file   = ms.ToArray();
            MemoryStream output = new MemoryStream();

            output.Write(file, 0, file.Length);
            output.Position = 0;

            HttpContext.Response.AddHeader("content-disposition", "inline; filename=PreBid_RollUp_" + preBidDetails.PRJID + ".pdf");
            return(File(output, "application/pdf"));
        }
Ejemplo n.º 10
0
        private void btnLeftPrint_Click(object sender, EventArgs e)
        {
            distanceInMm = Math.Round(Distance(golCircle, gorCircle) * mmtoPixelRatio, 2, MidpointRounding.ToEven);
            Console.WriteLine("distance in mm:" + distanceInMm);

            distanceInMmR = Math.Round(Distance(golCircleR, gorCircleR) * mmtoPixelRatioR, 2, MidpointRounding.ToEven);
            Console.WriteLine("distance in mm:" + distanceInMmR);

            msg f2 = new msg();

            f2.ShowDialog();//this way the form1 will hold untill the form 2(msg form ) is closed

            string         savePdfFilePath = "";
            SaveFileDialog sf = new SaveFileDialog();

            sf.InitialDirectory = @"C:\";
            sf.Title            = "Save Pdf in";
            sf.Filter           = "Pdf files (*.pdf)|*.pdf|All files (*.*)|*.*";
            if (sf.ShowDialog() == DialogResult.OK)
            {
                savePdfFilePath = System.IO.Path.GetFullPath(sf.FileName);
            }
            PdfWriter   writer = new PdfWriter(savePdfFilePath);
            PdfDocument pdf    = new PdfDocument(writer);

            float    a4Width  = PageSize.A4.GetWidth();
            float    a4Height = PageSize.A4.GetHeight();
            PageSize pagesize = new PageSize(a4Width, a4Height);

            pdf.SetDefaultPageSize(pagesize);


            Document document = new Document(pdf);



            Pen        p = new Pen(Color.Red);
            SolidBrush b = new SolidBrush(Color.Red);
            //Bitmap bmap = new Bitmap(picBoxLeft.Width, picBoxLeft.Height);

            Bitmap bmap      = new Bitmap(picBoxLeft.Image, picBoxLeft.Width, picBoxLeft.Height);
            Bitmap bmapRight = new Bitmap(picBoxRight.Image, picBoxRight.Width, picBoxRight.Height);


            bmap.MakeTransparent();
            bmapRight.MakeTransparent();

            Graphics g  = Graphics.FromImage(bmap);
            Graphics gr = Graphics.FromImage(bmapRight);

            foreach (Circle item in circleArray)
            {
                if (item != null)
                {
                    g.FillEllipse(b, item._location.X, item._location.Y, item._radius, item._radius);
                    g.DrawString(item._text, new Font(FontFamily.GenericSansSerif, 16, FontStyle.Bold), b, new Point(item._location.X, item._location.Y + item._radius - 70));
                    //g.Dispose();
                }
            }
            foreach (Circle item in circleArrayR)
            {
                if (item != null)
                {
                    gr.FillEllipse(b, item._location.X, item._location.Y, item._radius, item._radius);
                    gr.DrawString(item._text, new Font(FontFamily.GenericSansSerif, 16, FontStyle.Bold), b, new Point(item._location.X, item._location.Y + item._radius - 70));
                    //g.Dispose();
                }
            }



            MemoryStream ms  = new MemoryStream();
            MemoryStream msR = new MemoryStream();

            bmap.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
            bmapRight.Save(msR, System.Drawing.Imaging.ImageFormat.Jpeg);

            byte[] buff  = ms.GetBuffer();
            byte[] buffR = msR.GetBuffer();

            Paragraph header = new Paragraph("Created From Facial Mark App")
                               .SetTextAlignment(TextAlignment.CENTER)
                               .SetFontSize(20).SetMarginBottom(5);



            PdfImage img = new PdfImage(iText.IO.Image.ImageDataFactory
                                        .Create(buff)).SetTextAlignment(TextAlignment.LEFT);
            PdfImage imgR = new PdfImage(iText.IO.Image.ImageDataFactory
                                         .Create(buffR)).SetTextAlignment(TextAlignment.RIGHT);

            Table     table = new Table(1).SetTextAlignment(TextAlignment.CENTER);
            Paragraph p1    = new Paragraph();

            img.Scale(0.3f, 0.3f);
            imgR.Scale(0.3f, 0.3f);
            p1.Add(img);
            p1.Add(imgR);

            table.AddCell(p1);

            // Line separator
            LineSeparator ls        = new LineSeparator(new SolidLine()).SetMarginBottom(10);;
            Paragraph     subheader = new Paragraph("Answers")
                                      .SetTextAlignment(TextAlignment.LEFT)
                                      .SetFontSize(15).SetMarginBottom(10);



            Paragraph answerAssym = new Paragraph("Degree of asymmetry:-" + Form1.answerAssym)
                                    .SetTextAlignment(TextAlignment.LEFT)
                                    .SetFontSize(10);

            Paragraph answerSupport = new Paragraph("Degree of undereye support :-" + Form1.answerSupport)
                                      .SetTextAlignment(TextAlignment.LEFT)
                                      .SetFontSize(10);


            //"Distance(Side)" + Math.Round(distanceInMm / 10,2,MidpointRounding.ToEven) + "cm" + "
            Paragraph distancePara = new Paragraph("Distance(Frontal)" + Math.Round(distanceInMmR / 10, 2, MidpointRounding.ToEven) + "cm")
                                     .SetTextAlignment(TextAlignment.LEFT)
                                     .SetFontSize(10);

            Paragraph anglePara = new Paragraph("The angle created by the line from “Tr to Go” and “Go to Gn’”")
                                  .SetTextAlignment(TextAlignment.LEFT)
                                  .SetFontSize(12).SetBold().SetMarginBottom(15);

            if (angleLeft <= 0.0)
            {
                double answer = calculateAngle(circleArray);
                answer    = Math.Round(answer, 2, MidpointRounding.ToEven);
                angleLeft = answer;
            }

            if (angleRight <= 0.0)
            {
                double answer = calculateAngle(circleArrayR);
                answer     = Math.Round(answer, 2, MidpointRounding.ToEven);
                angleRight = answer;
            }
            Paragraph angleParaLeft = new Paragraph("Angle(Side):" + angleLeft + "\u00B0")
                                      .SetTextAlignment(TextAlignment.LEFT)
                                      .SetFontSize(10).SetMarginBottom(10);

            //Paragraph angleParaRight = new Paragraph("Angle(Front):" + angleRight + "\u00B0")
            //   .SetTextAlignment(TextAlignment.LEFT)
            //   .SetFontSize(10).SetMarginBottom(10);

            document.Add(header);
            document.Add(ls);
            document.Add(table);
            document.Add(subheader);
            document.Add(answerAssym);
            document.Add(answerSupport);
            document.Add(distancePara);
            document.Add(anglePara);
            document.Add(angleParaLeft);
            //document.Add(angleParaRight);
            //document.Add(img);
            //document.Add(imgR);
            document.Close();

            MessageBox.Show("Successfully Saved Pdf");
        }
Ejemplo n.º 11
0
        /// <summary>
        /// PDF作成
        /// </summary>
        /// <param name="dayStr">作成指定日時</param>
        /// <param name="classificationStr">分類文字列</param>
        /// <param name="periodTypeStr">期間指定文字列</param>
        /// <param name="originTable">表のオリジナルデータ</param>
        public void Create(string dayStr, string classificationStr, string periodTypeStr, DataTable originTable, string imgDataStr)
        {
            try
            {
                var doc    = new Document(SizeRect);
                var stream = new MemoryStream();
                //ファイルの出力先を設定
                var pw = PdfWriter.GetInstance(doc, stream);

                //ドキュメントを開く
                doc.Open();

                // A4 595x842 pt = 210x297
                Paragraph prgTitle  = new Paragraph();
                Font      titleFont = new Font(PdfFont, 24, 1, BaseColor.BLACK);
                prgTitle.Alignment = Element.ALIGN_LEFT;
                prgTitle.Add(new Chunk(dayStr + "の統計確認データ", titleFont));
                doc.Add(prgTitle);

                Paragraph p = new Paragraph(new Chunk(new LineSeparator(0.0f, 100.0f, BaseColor.BLACK, Element.ALIGN_LEFT, 0.0f)));
                doc.Add(p);

                Paragraph prgCreateDate  = new Paragraph();
                Font      createDateFont = new Font(PdfFont, 11, 1, BaseColor.BLACK);
                prgCreateDate.Alignment = Element.ALIGN_LEFT;
                prgCreateDate.Add(new Chunk("作成日時: " + DateTime.Now.ToString(AppConst.DTP_DAY_TIMESTR) + " "
                                            + DateTime.Now.ToShortTimeString(), createDateFont));
                doc.Add(prgCreateDate);
                doc.Add(new Chunk("\n", titleFont));

                Paragraph prgClassification  = new Paragraph();
                Paragraph prgPeriodType      = new Paragraph();
                Font      classificationFont = new Font(PdfFont, 18, 1, BaseColor.BLACK);
                prgClassification.Alignment = Element.ALIGN_LEFT;
                prgClassification.Add(new Chunk("分類: " + classificationStr, createDateFont));
                doc.Add(prgClassification);
                prgPeriodType.Alignment = Element.ALIGN_LEFT;
                prgPeriodType.Add(new Chunk("期間種類: " + periodTypeStr, createDateFont));
                doc.Add(prgPeriodType);

                //グラフ画像を表示
                string fileName = GetImageFile(imgDataStr);
                if (fileName != null && !string.IsNullOrEmpty(fileName))
                {
                    Image image = Image.GetInstance(fileName);
                    image.ScalePercent(75.0f); // WindowsとPDFのサイズ共通化のため
                    image.Alignment = Element.ALIGN_CENTER;
                    doc.Add(image);
                    doc.Add(new Chunk("\n", titleFont));
                }

                //表を作成
                PdfPTable table = new PdfPTable(originTable.Columns.Count)
                {
                    HorizontalAlignment = Element.ALIGN_CENTER
                };
                Font fntColumnHeader = new Font(PdfFont, 18, 1, BaseColor.WHITE);
                for (int i = 0; i < originTable.Columns.Count; i++)
                {
                    PdfPCell cell = new PdfPCell
                    {
                        BackgroundColor = BaseColor.GRAY
                    };
                    cell.AddElement(new Chunk(originTable.Columns[i].ColumnName.ToUpper(), fntColumnHeader));
                    table.AddCell(cell);
                }

                Font fntRowHeader = new Font(PdfFont, 18, 1, BaseColor.BLACK);
                for (int i = 0; i < originTable.Rows.Count; i++)
                {
                    for (int j = 0; j < originTable.Columns.Count; j++)
                    {
                        PdfPCell cell = new PdfPCell
                        {
                            BackgroundColor = BaseColor.WHITE
                        };
                        cell.AddElement(new Chunk(originTable.Rows[i][j].ToString(), fntRowHeader));
                        table.AddCell(cell);
                    }
                }
                doc.Add(table);

                //ドキュメントを閉じる
                doc.Close();

                //PDF作成
                using (BinaryWriter w = new BinaryWriter(File.OpenWrite(FileName)))
                {
                    w.Write(stream.ToArray());
                }

                Console.WriteLine("See the " + FileName);
            }
            catch (Exception e)
            {
                string s = e.Message;
                OriginMBox.MBoxErrorOK(AppConst.PDF_FAILURE_MESSAGE);
            }
        }
Ejemplo n.º 12
0
        /**
        * Imports the Cell properties into the RtfCell
        *
        * @param cell The PdfPCell to import
        * @since 2.1.3
        */
        private void ImportCell(PdfPCell cell)
        {
            this.content = new ArrayList();

            if (cell == null) {
                this.borders = new RtfBorderGroup(this.document, RtfBorder.CELL_BORDER, this.parentRow.GetParentTable().GetBorders());
                return;
            }

            // padding
            this.cellPadding = (int) this.parentRow.GetParentTable().GetCellPadding();
            this.cellPaddingBottom = cell.PaddingBottom;
            this.cellPaddingTop = cell.PaddingTop;
            this.cellPaddingRight = cell.PaddingRight;
            this.cellPaddingLeft = cell.PaddingLeft;

            // BORDERS
            this.borders = new RtfBorderGroup(this.document, RtfBorder.CELL_BORDER, cell.Border, cell.BorderWidth, cell.BorderColor);

            // border colors
            this.border = cell.Border;
            this.borderColor = cell.BorderColor;
            this.borderColorBottom = cell.BorderColorBottom;
            this.borderColorTop = cell.BorderColorTop;
            this.borderColorLeft = cell.BorderColorLeft;
            this.borderColorRight = cell.BorderColorRight;

            // border widths
            this.borderWidth = cell.BorderWidth;
            this.borderWidthBottom = cell.BorderWidthBottom;
            this.borderWidthTop = cell.BorderWidthTop;
            this.borderWidthLeft = cell.BorderWidthLeft;
            this.borderWidthRight = cell.BorderWidthRight;

            this.colspan = cell.Colspan;
            this.rowspan = 1; //cell.GetRowspan();
            //        if (cell.GetRowspan() > 1) {
            //            this.mergeType = MERGE_VERT_PARENT;
            //        }

            this.verticalAlignment = cell.VerticalAlignment;

            if (cell.BackgroundColor == null) {
                this.backgroundColor = new RtfColor(this.document, 255, 255, 255);
            } else {
                this.backgroundColor = new RtfColor(this.document, cell.BackgroundColor);
            }

            // does it have column composite info?
            ArrayList compositeElements = cell.CompositeElements;
            if (compositeElements != null) {
                // does it have column info?
                Paragraph container = null;
                foreach (IElement element in compositeElements) {
                    try {
                        // should we wrap it in a paragraph
                        if (!(element is Paragraph) && !(element is Legacy.Text.List)) {
                            if (container != null) {
                                container.Add(element);
                            } else {
                                container = new Paragraph();
                                container.Alignment = cell.HorizontalAlignment;
                                container.Add(element);
                            }
                        } else {
                            IRtfBasicElement[] rtfElements = null;
                            if (container != null) {
                                rtfElements = this.document.GetMapper().MapElement(container);
                                for (int i = 0; i < rtfElements.Length; i++) {
                                    rtfElements[i].SetInTable(true);
                                    this.content.Add(rtfElements[i]);
                                }
                                container = null;
                            }
                            // if horizontal alignment is undefined overwrite
                            // with that of enclosing cell
                            if (element is Paragraph && ((Paragraph) element).Alignment == Element.ALIGN_UNDEFINED) {
                                ((Paragraph) element).Alignment = cell.HorizontalAlignment;
                            }

                            rtfElements = this.document.GetMapper().MapElement(element);
                            for (int i = 0; i < rtfElements.Length; i++) {
                                rtfElements[i].SetInTable(true);
                                this.content.Add(rtfElements[i]);
                            }
                        }
                    } catch (DocumentException) {
                    }
                }
                if (container != null) {
                    try {
                        IRtfBasicElement[] rtfElements = this.document.GetMapper().MapElement(container);
                        for (int i = 0; i < rtfElements.Length; i++) {
                            rtfElements[i].SetInTable(true);
                            this.content.Add(rtfElements[i]);
                        }
                    } catch (DocumentException) {
                    }
                }
            }

            // does it have image info?

            Image img = cell.Image;
            if (img != null) {
                try {
                    IRtfBasicElement[] rtfElements = this.document.GetMapper().MapElement(img);
                    for (int i = 0; i < rtfElements.Length; i++) {
                        rtfElements[i].SetInTable(true);
                        this.content.Add(rtfElements[i]);
                    }
                } catch (DocumentException) {
                }
            }
            // does it have phrase info?
            Phrase phrase = cell.Phrase;
            if (phrase != null) {
                try {
                    IRtfBasicElement[] rtfElements = this.document.GetMapper().MapElement(phrase);
                    for (int i = 0; i < rtfElements.Length; i++) {
                        rtfElements[i].SetInTable(true);
                        this.content.Add(rtfElements[i]);
                    }
                } catch (DocumentException) {
                }
            }
            // does it have table info?
            PdfPTable table = cell.Table;
            if (table != null) {
                this.Add(table);
            //            try {
            //              RtfBasicElement[] rtfElements = this.document.GetMapper().MapElement(table);
            //              for (int i = 0; i < rtfElements.length; i++) {
            //                  rtfElements[i].SetInTable(true);
            //                  this.content.Add(rtfElements[i]);
            //              }
            //          } catch (DocumentException e) {
            //              // TODO Auto-generated catch block
            //              e.PrintStackTrace();
            //          }
            }
        }
Ejemplo n.º 13
0
        /**
        * Imports the Cell properties into the RtfCell
        *
        * @param cell The Cell to import
        */
        private void ImportCell(Cell cell)
        {
            this.content = new ArrayList();

            if (cell == null) {
                this.borders = new RtfBorderGroup(this.document, RtfBorder.CELL_BORDER, this.parentRow.GetParentTable().GetBorders());
                return;
            }

            this.colspan = cell.Colspan;
            this.rowspan = cell.Rowspan;
            if (cell.Rowspan > 1) {
                this.mergeType = MERGE_VERT_PARENT;
            }
            if (cell is RtfCell) {
                this.borders = new RtfBorderGroup(this.document, RtfBorder.CELL_BORDER, ((RtfCell) cell).GetBorders());
            } else {
                this.borders = new RtfBorderGroup(this.document, RtfBorder.CELL_BORDER, cell.Border, cell.BorderWidth, cell.BorderColor);
            }
            this.verticalAlignment = cell.VerticalAlignment;
            if (cell.BackgroundColor == null) {
                this.backgroundColor = new RtfColor(this.document, 255, 255, 255);
            } else {
                this.backgroundColor = new RtfColor(this.document, cell.BackgroundColor);
            }

            this.cellPadding = (int) this.parentRow.GetParentTable().GetCellPadding();

            Paragraph container = null;
            foreach (IElement element in cell.Elements) {
                try {
                    // should we wrap it in a paragraph
                    if (!(element is Paragraph) && !(element is Legacy.Text.List)) {
                        if (container != null) {
                            container.Add(element);
                        } else {
                            container = new Paragraph();
                            container.Alignment = cell.HorizontalAlignment;
                            container.Add(element);
                        }
                    } else {
                        if (container != null) {
                            IRtfBasicElement[] rtfElements = this.document.GetMapper().MapElement(container);
                            for (int i = 0; i < rtfElements.Length; i++) {
                                rtfElements[i].SetInTable(true);
                                this.content.Add(rtfElements[i]);
                            }
                            container = null;
                        }
                        // if horizontal alignment is undefined overwrite
                        // with that of enclosing cell
                        if (element is Paragraph && ((Paragraph) element).Alignment == Element.ALIGN_UNDEFINED) {
                            ((Paragraph) element).Alignment = cell.HorizontalAlignment;
                        }

                        IRtfBasicElement[] rtfElements2 = this.document.GetMapper().MapElement(element);
                        for (int i = 0; i < rtfElements2.Length; i++) {
                            rtfElements2[i].SetInTable(true);
                            this.content.Add(rtfElements2[i]);
                        }
                    }
                } catch (DocumentException) {
                }
            }
            if (container != null) {
                try {
                    IRtfBasicElement[] rtfElements = this.document.GetMapper().MapElement(container);
                    for (int i = 0; i < rtfElements.Length; i++) {
                        rtfElements[i].SetInTable(true);
                        this.content.Add(rtfElements[i]);
                    }
                } catch (DocumentException) {
                }
            }
        }
Ejemplo n.º 14
0
        private void OnSortByButtonClick(object sender, RoutedEventArgs e)
        {
            if (SortByWordsCountRadioButton.IsChecked.Value)
            {
                var sortedSentences = _text.GetSentences().OrderBy(sentence => sentence.Count);
                var text = new Text();

                foreach(var sentence in sortedSentences)
                {
                    var paragraph = new Paragraph();
                    paragraph.Add(sentence);
                    text.Add(paragraph);
                }

                TextContainer.ItemsSource = text;
            }
            else if (SortBySentenceCountRadioButton.IsChecked.Value)
            {
                var sortedParagraphs = _text.OrderBy(paragraph => paragraph.Count);
                var text = new Text();
                foreach(var paragraph in sortedParagraphs)
                {
                    text.Add(paragraph);
                    text.Add(new Paragraph());
                }

                TextContainer.ItemsSource = text;
            }
        }
Ejemplo n.º 15
0
        public void createReport(IEnumerable <DisplayComplaintViewModel> complaintData, FilterViewModel filterViewData)
        {
            try
            {
                System.IO.File.Delete(System.Web.HttpContext.Current.Server.MapPath("~/Content/PDF/complaints.pdf"));
            }
            catch
            { }

            String[] dateReceive = null, dateEntry = null;



            Document doc    = new Document(PageSize.LEGAL.Rotate());
            var      output = new FileStream(System.Web.HttpContext.Current.Server.MapPath("~/Content/PDF/complaints.pdf"), FileMode.Create);
            var      writer = PdfWriter.GetInstance(doc, output);

            doc.Open();

            PdfPTable header = new PdfPTable(2);

            header.WidthPercentage = 80f;
            float[] _columnWidths = { 10, 80 };
            header.SetWidths(_columnWidths);
            header.HorizontalAlignment = Element.ALIGN_LEFT;


            Image logo2 = Image.GetInstance(System.Web.HttpContext.Current.Server.MapPath("~/Content/PDF/doh.png"));

            logo2.ScaleAbsolute(60f, 60f);

            header.AddCell(new PdfPCell(logo2)
            {
                HorizontalAlignment = Element.ALIGN_LEFT, VerticalAlignment = Element.ALIGN_LEFT, Rowspan = 4, Border = 0
            });
            header.AddCell(new PdfPCell(new Paragraph("REPUBLIC OF THE PHILIPPINES"))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Border = 0
            });
            header.AddCell(new PdfPCell(new Paragraph("Department of Health"))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Border = 0
            });
            header.AddCell(new PdfPCell(new Paragraph("HEALTH FACILITIES AND SERVICES REGULATORY BUREAU/REGIONAL OFFICE VII"))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Border = 0
            });
            header.AddCell(new PdfPCell(new Paragraph("LOGSHEET OF COMPLAINTS"))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Border = 0
            });

            doc.Add(header);


            PdfPTable sheet_num = new PdfPTable(1);

            sheet_num.WidthPercentage = 100f;
            float[] sheet_num_withs = { 100 };
            sheet_num.SetWidths(sheet_num_withs);

            DateTime date_from = Convert.ToDateTime(filterViewData);
            DateTime date_to   = Convert.ToDateTime(filterViewData.date_to);

            String month = "";

            if (date_from.Month == date_to.Month)
            {
                month = date_to.ToString("MMMM");
            }
            else
            {
                month = date_to.ToString("MMMM");
            }

            sheet_num.AddCell(new PdfPCell(new Paragraph("Month of : " + month, new Font(Font.FontFamily.HELVETICA, 10f, Font.BOLD)))
            {
                HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, Padding = 5f
            });
            sheet_num.AddCell(new PdfPCell(new Paragraph("Year : " + date_to.ToString("yyyy"), new Font(Font.FontFamily.HELVETICA, 10f, Font.BOLD)))
            {
                HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0, Padding = 5f
            });

            doc.Add(sheet_num);

            PdfPTable _thead_page_break = new PdfPTable(16);

            _thead_page_break.WidthPercentage = 100f;
            float[] main = { 40, 40, 40, 40, 40, 40, 50, 50, 40, 40, 40, 40, 40, 40, 40, 40 };
            _thead_page_break.SetWidths(main);


            _thead_page_break.AddCell(new PdfPCell(new Paragraph("Date Received", new Font(Font.FontFamily.HELVETICA, 7f, Font.BOLD)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
            });
            _thead_page_break.AddCell(new PdfPCell(new Paragraph("Code Number", new Font(Font.FontFamily.HELVETICA, 7f, Font.BOLD)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
            });
            _thead_page_break.AddCell(new PdfPCell(new Paragraph("Name of Health Facility Being Complained", new Font(Font.FontFamily.HELVETICA, 7f, Font.BOLD)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
            });
            _thead_page_break.AddCell(new PdfPCell(new Paragraph("Address", new Font(Font.FontFamily.HELVETICA, 7f, Font.BOLD)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
            });
            _thead_page_break.AddCell(new PdfPCell(new Paragraph("Ownership", new Font(Font.FontFamily.HELVETICA, 7f, Font.BOLD)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
            });
            _thead_page_break.AddCell(new PdfPCell(new Paragraph("Name of Complainant", new Font(Font.FontFamily.HELVETICA, 7f, Font.BOLD)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
            });
            _thead_page_break.AddCell(new PdfPCell(new Paragraph("Types of Complaint", new Font(Font.FontFamily.HELVETICA, 7f, Font.BOLD)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
            });
            _thead_page_break.AddCell(new PdfPCell(new Paragraph("Assistance Needed", new Font(Font.FontFamily.HELVETICA, 7f, Font.BOLD)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
            });
            _thead_page_break.AddCell(new PdfPCell(new Paragraph("Form of Communication", new Font(Font.FontFamily.HELVETICA, 7f, Font.BOLD)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
            });
            _thead_page_break.AddCell(new PdfPCell(new Paragraph("Action Taken", new Font(Font.FontFamily.HELVETICA, 7f, Font.BOLD)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
            });
            _thead_page_break.AddCell(new PdfPCell(new Paragraph("Date Informed the HF/concerned office", new Font(Font.FontFamily.HELVETICA, 7f, Font.BOLD)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
            });
            _thead_page_break.AddCell(new PdfPCell(new Paragraph("Date HF/concerned office submitted reply", new Font(Font.FontFamily.HELVETICA, 7f, Font.BOLD)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
            });
            _thead_page_break.AddCell(new PdfPCell(new Paragraph("Date released to records section", new Font(Font.FontFamily.HELVETICA, 7f, Font.BOLD)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
            });
            _thead_page_break.AddCell(new PdfPCell(new Paragraph("Date Resolution of the complaint released to records/client", new Font(Font.FontFamily.HELVETICA, 7f, Font.BOLD)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
            });
            _thead_page_break.AddCell(new PdfPCell(new Paragraph("Status", new Font(Font.FontFamily.HELVETICA, 7f, Font.BOLD)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
            });
            _thead_page_break.AddCell(new PdfPCell(new Paragraph("Staff Assigned", new Font(Font.FontFamily.HELVETICA, 7f, Font.BOLD)))
            {
                HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
            });

            doc.Add(_thead_page_break);

            PdfPTable complaints_table = new PdfPTable(16);

            complaints_table.WidthPercentage = 100f;
            complaints_table.SetWidths(main);

            PageEvent pe = new PageEvent();

            writer.PageEvent = pe;

            foreach (DisplayComplaintViewModel c in complaintData)
            {
                complaints_table.AddCell(new PdfPCell(new Paragraph(c.dateCreated.ToShortDateString(), new Font(Font.FontFamily.HELVETICA, 7f)))
                {
                    HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                });
                complaints_table.AddCell(new PdfPCell(new Paragraph(c.codeNumber, new Font(Font.FontFamily.HELVETICA, 7f)))
                {
                    HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                });
                complaints_table.AddCell(new PdfPCell(new Paragraph(c.hospitalName, new Font(Font.FontFamily.HELVETICA, 7f)))
                {
                    HorizontalAlignment = Element.ALIGN_LEFT, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                });
                complaints_table.AddCell(new PdfPCell(new Paragraph(c.hospitalAddress, new Font(Font.FontFamily.HELVETICA, 7f)))
                {
                    HorizontalAlignment = Element.ALIGN_LEFT, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                });
                complaints_table.AddCell(new PdfPCell(new Paragraph(c.ownership == "P" ? "Private" : "Government", new Font(Font.FontFamily.HELVETICA, 7f)))
                {
                    HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                });
                complaints_table.AddCell(new PdfPCell(new Paragraph(c.annonymos == true ? c.nameOfComplainant : "Anonymous", new Font(Font.FontFamily.HELVETICA, 7f)))
                {
                    HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                });

                Paragraph complaint_type = new Paragraph();
                if (c.complaint_type != null && c.complaint_type.Count() > 0)
                {
                    foreach (string complaintType in c.complaint_type)
                    {
                        complaint_type.Add(new Chunk(complaintType + "\n", new Font(Font.FontFamily.HELVETICA, 7f)));
                    }

                    if (c.other_complaint != null)
                    {
                        complaint_type.Add(new Chunk("Others : " + c.other_complaint, new Font(Font.FontFamily.HELVETICA, 7f, Font.NORMAL)));
                    }
                    complaints_table.AddCell(new PdfPCell(complaint_type)
                    {
                        HorizontalAlignment = Element.ALIGN_LEFT, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                    });
                }
                else
                {
                    if (c.other_complaint != null)
                    {
                        Chunk otherComplaint = new Chunk("Others : " + c.other_complaint, new Font(Font.FontFamily.HELVETICA, 7f, Font.NORMAL));
                        complaint_type.Add(otherComplaint);
                        complaints_table.AddCell(new PdfPCell(complaint_type)
                        {
                            HorizontalAlignment = Element.ALIGN_LEFT, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                        });
                    }
                    else
                    {
                        complaints_table.AddCell(new PdfPCell(new Paragraph("-"))
                        {
                            HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                        });
                    }
                }

                Paragraph complaint_assistance = new Paragraph();
                if (c.assistanceNeeded != null && c.assistanceNeeded.Count() > 0)
                {
                    foreach (string complaintAssistance in c.assistanceNeeded)
                    {
                        complaint_assistance.Add(new Chunk(complaintAssistance + "\n", new Font(Font.FontFamily.HELVETICA, 7f)));
                    }
                    if (c.otherAssistanceNeed != null)
                    {
                        complaint_assistance.Add(new Chunk("Others : " + c.otherAssistanceNeed, new Font(Font.FontFamily.HELVETICA, 7f, Font.NORMAL)));
                    }
                    complaints_table.AddCell(new PdfPCell(complaint_assistance)
                    {
                        HorizontalAlignment = Element.ALIGN_LEFT, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                    });
                }
                else
                {
                    if (c.otherAssistanceNeed != null)
                    {
                        Chunk otherAssistance = new Chunk("Others : " + c.otherAssistanceNeed, new Font(Font.FontFamily.HELVETICA, 7f, Font.NORMAL));
                        complaint_assistance.Add(otherAssistance);
                        complaints_table.AddCell(new PdfPCell(complaint_assistance)
                        {
                            HorizontalAlignment = Element.ALIGN_LEFT, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                        });
                    }
                    else
                    {
                        complaints_table.AddCell(new PdfPCell(new Paragraph("-"))
                        {
                            HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                        });
                    }
                }

                complaints_table.AddCell(new PdfPCell(new Paragraph(c.pccCheck == true ? "PCC No. " + c.pccNumber : c.communication_form, new Font(Font.FontFamily.HELVETICA, 7f)))
                {
                    HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                });

                if (c._complaintActionDates != null && c._complaintActionDates.Count() > 0)
                {
                    Paragraph complaint_action_dates = new Paragraph();
                    foreach (complaint_action_dates acd in c._complaintActionDates)
                    {
                        complaint_action_dates.Add(new Chunk("(" + acd.Date.ToShortDateString() + ") " + acd.Action + "\n", new Font(Font.FontFamily.HELVETICA, 7f)));
                    }
                    complaints_table.AddCell(new PdfPCell(complaint_action_dates)
                    {
                        HorizontalAlignment = Element.ALIGN_LEFT, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                    });
                }
                else
                {
                    complaints_table.AddCell(new PdfPCell(new Paragraph("-", new Font(Font.FontFamily.HELVETICA, 7f)))
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                    });
                }

                if (c.date_informed_the_hf != null && c.date_informed_the_hf.Count() > 0)
                {
                    Paragraph p_date_informed_the_hf = new Paragraph();
                    foreach (String s in c.date_informed_the_hf)
                    {
                        p_date_informed_the_hf.Add(new Chunk(s + "\n", new Font(Font.FontFamily.HELVETICA, 7f)));
                    }
                    complaints_table.AddCell(new PdfPCell(p_date_informed_the_hf)
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                    });
                }
                else
                {
                    complaints_table.AddCell(new PdfPCell(new Paragraph("-", new Font(Font.FontFamily.HELVETICA, 7f)))
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                    });
                }
                if (c.date_hf_submitted_reply != null && c.date_hf_submitted_reply.Count() > 0)
                {
                    Paragraph p_date_hf_submitted_reply = new Paragraph();
                    foreach (String s in c.date_hf_submitted_reply)
                    {
                        p_date_hf_submitted_reply.Add(new Chunk(s + "\n", new Font(Font.FontFamily.HELVETICA, 7f)));
                    }
                    complaints_table.AddCell(new PdfPCell(p_date_hf_submitted_reply)
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                    });
                }
                else
                {
                    complaints_table.AddCell(new PdfPCell(new Paragraph("-", new Font(Font.FontFamily.HELVETICA, 7f)))
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                    });
                }
                if (c.date_release_to_records != null && c.date_release_to_records.Count() > 0)
                {
                    Paragraph p_date_release_to_records = new Paragraph();
                    foreach (String s in c.date_release_to_records)
                    {
                        p_date_release_to_records.Add(new Chunk(s + "\n", new Font(Font.FontFamily.HELVETICA, 7f)));
                    }
                    complaints_table.AddCell(new PdfPCell(p_date_release_to_records)
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                    });
                }
                else
                {
                    complaints_table.AddCell(new PdfPCell(new Paragraph("-", new Font(Font.FontFamily.HELVETICA, 7f)))
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                    });
                }
                if (c.date_final_resolution != null && c.date_final_resolution.Count() > 0)
                {
                    Paragraph p_date_final_resolution = new Paragraph();
                    foreach (String s in c.date_final_resolution)
                    {
                        p_date_final_resolution.Add(new Chunk(s + "\n", new Font(Font.FontFamily.HELVETICA, 7f)));
                    }
                    complaints_table.AddCell(new PdfPCell(p_date_final_resolution)
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                    });
                }
                else
                {
                    complaints_table.AddCell(new PdfPCell(new Paragraph("-", new Font(Font.FontFamily.HELVETICA, 7f)))
                    {
                        HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                    });
                }
                complaints_table.AddCell(new PdfPCell(new Paragraph(c.status == 1 ? "On Going" : "Resolved", new Font(Font.FontFamily.HELVETICA, 7f)))
                {
                    HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                });
                complaints_table.AddCell(new PdfPCell(new Paragraph(c.staff, new Font(Font.FontFamily.HELVETICA, 7f)))
                {
                    HorizontalAlignment = Element.ALIGN_CENTER, Rowspan = 4, VerticalAlignment = Element.ALIGN_CENTER
                });
            }

            doc.Add(complaints_table);

            doc.Close();
        }
Ejemplo n.º 16
0
        private void buttonCetak_Click(object sender, EventArgs e)
        {
            var boldFont   = FontFactory.GetFont(FontFactory.TIMES_BOLD, 12);
            var boldBig    = FontFactory.GetFont(FontFactory.TIMES_BOLD, 14);
            var normalFont = FontFactory.GetFont(FontFactory.TIMES_ROMAN, 12);

            var    pdfDoc = new Document(PageSize.A4, 40f, 40f, 60f, 60f);
            string path   = "E:\\";

            PdfWriter.GetInstance(pdfDoc, new FileStream(path + "/NotaLunasLayanan.pdf", FileMode.OpenOrCreate));
            pdfDoc.Open();

            var imagepath = @Directory.GetCurrentDirectory() + "\\KPS.PNG";
            var png       = iTextSharp.text.Image.GetInstance(imagepath);

            png.ScalePercent(87f);
            pdfDoc.Add(png);

            var spacer = new Paragraph("")
            {
                SpacingAfter  = 10f,
                SpacingBefore = 10f,
            };

            pdfDoc.Add(spacer);

            Paragraph p = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 100.0F, BaseColor.BLACK, Element.ALIGN_LEFT, 1)));

            pdfDoc.Add(p);
            Paragraph title = new Paragraph("Nota Lunas", boldBig);

            title.Alignment = Element.ALIGN_CENTER;
            pdfDoc.Add(title);
            pdfDoc.Add(p);
            pdfDoc.Add(spacer);

            Paragraph tgl = new Paragraph(Convert.ToString(DateTime.Now));

            tgl.Alignment = Element.ALIGN_RIGHT;
            pdfDoc.Add(tgl);


            Paragraph nomorTransaksi = new Paragraph(txtNomorTransaksi.Text);

            nomorTransaksi.Alignment = Element.ALIGN_LEFT;
            pdfDoc.Add(nomorTransaksi);
            pdfDoc.Add(spacer);

            Chunk  c1 = new Chunk("Member       : " + NamaPelanggan + " (" + NamaHewan + " - " + Jenis_Hewan + ")", normalFont);
            Chunk  c2 = new Chunk("\nTelepon       : " + NoTelp, normalFont);
            Phrase p1 = new Phrase();

            p1.Add(c1);
            p1.Add(c2);

            Chunk  c3 = new Chunk("\n\nNama CS       : " + NamaCS, normalFont);
            Chunk  c4 = new Chunk("\nNama Kasir   : " + NamaKasir, normalFont);
            Phrase p2 = new Phrase();

            p2.Add(c3);
            p2.Add(c4);

            Paragraph dataPembeli = new Paragraph();

            dataPembeli.Add(p1);
            dataPembeli.Add(p2);
            pdfDoc.Add(dataPembeli);
            pdfDoc.Add(spacer);

            pdfDoc.Add(p);
            Paragraph subtitle = new Paragraph("Jasa Layanan", boldBig);

            subtitle.Alignment = Element.ALIGN_CENTER;
            pdfDoc.Add(subtitle);
            pdfDoc.Add(p);
            pdfDoc.Add(spacer);

            PdfPTable table = new PdfPTable(5);

            //actual width of table in points
            table.TotalWidth = 500f;
            //fix the absolute width of the table
            table.LockedWidth = true;
            //relative col widths in proportions - 1/3 and 2/3
            float[] widths = new float[] { 3f, 12f, 12f, 8f, 12f };
            table.SetWidths(widths);
            table.HorizontalAlignment = 1;
            //leave a gap before and after the table
            table.SpacingBefore = 20f;
            table.SpacingAfter  = 30f;
            PdfPCell cell = new PdfPCell();

            cell.Colspan             = 5;
            cell.Border              = 0;
            cell.HorizontalAlignment = 1;
            table.AddCell(cell);
            table.AddCell("No");
            table.AddCell("Nama Jasa Layanan");
            table.AddCell("Harga");
            table.AddCell("Jumlah");
            table.AddCell("Sub Total");

            string connect = "datasource=127.0.0.1;port=3306;username=root;password=;database=kouvee;Convert Zero Datetime=True;";

            using (MySqlConnection conn = new MySqlConnection(connect))
            {
                string query = "SELECT L.NAMA_LAYANAN, L.HARGA_LAYANAN, P.JUMLAH_DETIL_LAYANAN , P.SUB_TOTAL_LAYANAN " +
                               "FROM detil_transaksi_layanan P " +
                               "JOIN layanan L ON (P.ID_LAYANAN = L.ID_LAYANAN) " +
                               "WHERE ID_TRANSAKSI_LAYANAN = '" + txtCari.Text + "'";
                MySqlCommand cmd = new MySqlCommand(query, conn);
                try
                {
                    int i = 0;
                    conn.Open();
                    using (MySqlDataReader rdr = cmd.ExecuteReader())
                    {
                        while (rdr.Read())
                        {
                            i++;
                            table.AddCell(Convert.ToString(i));
                            table.AddCell(rdr[0].ToString());
                            table.AddCell("Rp. " + rdr[1].ToString());
                            table.AddCell(rdr[2].ToString());
                            table.AddCell("Rp. " + rdr[3].ToString());
                        }
                    }
                    conn.Close();
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.ToString());
                }
            }
            pdfDoc.Add(table);



            Chunk  c5 = new Chunk("Sub Total    : Rp. " + Convert.ToString(txtSubtotal.Text), normalFont);
            Chunk  c6 = new Chunk("\n\nDiskon     : Rp. " + Convert.ToString(txtDiskon.Text), normalFont);
            Chunk  c7 = new Chunk("\n\nTotal      : Rp. " + Convert.ToString(txtTotalHarga.Text), boldFont);
            Phrase p3 = new Phrase();

            p3.Add(c5);
            p3.Add(c6);
            p3.Add(c7);
            Paragraph datapembayaran = new Paragraph();

            datapembayaran.Add(p3);
            datapembayaran.Alignment = Element.ALIGN_RIGHT;
            pdfDoc.Add(datapembayaran);
            pdfDoc.Add(spacer);
            pdfDoc.Close();
            MessageBox.Show("Nota Pembayaran telah dicetak!");
        }
        private void GeneratePDF()
        {
            rand[0] = (Convert.ToInt32(textbox.Text) * 1103515245) & 0x7fffffff;
            for (int i = 0; i < 49; i++)
            {
                rand[i + 1] = (rand[i] * 1103515245) & 0x7fffffff;
            }

            var             paper1          = new Document(PageSize.A4, 60, 60, 80, 50);
            PdfWriter       pdf             = PdfWriter.GetInstance(paper1, new FileStream("paper1.pdf", FileMode.Create));
            PageEventHelper pageEventHelper = new PageEventHelper();

            pdf.PageEvent = pageEventHelper;
            paper1.Open();
            Font roman = new Font(Font.FontFamily.TIMES_ROMAN, 10f);

            PdfPTable table = new PdfPTable(1);

            table.TotalWidth  = 480f;
            table.LockedWidth = true;

            var p = new Paragraph();

            p.Add(new Phrase("SECTION A(1) (35 marks)\n\n\n", new Font(Font.FontFamily.TIMES_ROMAN, 10f, Font.BOLD)));

            //Question 1
            p.Add(new Phrase("\n1.       Simplify  ", roman));
            string strquestion1 = GenerateQuestion(1);

            iTextSharp.text.Image png = iTextSharp.text.Image.GetInstance(new Uri(GenerateImage(strquestion1, "img1.png")));
            label.Content = strquestion1;
            png.ScalePercent(10f);
            p.Add(new Chunk(png, 0, -9f));
            p.Add(new Phrase("  and express your answer with positive indices.", roman));
            //p.TabSettings = new TabSettings();
            //p.Add(Chunk.TABBING);
            p.Add(new Chunk(new VerticalPositionMark()));
            p.Add(new Phrase("(3 marks)", roman));
            p.Add(new Phrase("_\n\n\n", FontFactory.GetFont("Times New Roman", 10, Font.BOLD, new iTextSharp.text.BaseColor(255, 255, 255))));
            for (int i = 0; i < 11; i++)
            {
                p.Add(new Phrase("        ____________________________________________________________________\n\n", new Font(Font.FontFamily.TIMES_ROMAN, 13f)));
            }

            //Question 2
            p.Add(new Phrase("\n2.       Make  ", roman));
            string strquestion2 = GenerateQuestion(2);

            png = iTextSharp.text.Image.GetInstance(new Uri(GenerateImage(strquestion2, "img2.png")));
            png.ScalePercent(10f);
            if (strquestion2.Contains("y"))
            {
                p.Add(new Chunk(png, 0, -2f));
            }
            else
            {
                p.Add(new Chunk(png, 0, 0));
            }
            p.Add(new Phrase("  the subject of the formula   ", roman));
            string strquestion3 = GenerateQuestion(3);

            png = iTextSharp.text.Image.GetInstance(new Uri(GenerateImage(strquestion3, "img3.png")));
            png.ScalePercent(10f);
            if (strquestion3.Contains("\\frac{"))
            {
                p.Add(new Chunk(png, 0, -7f));
            }
            else
            {
                p.Add(new Chunk(png, 0, -2f));
            }
            p.Add(new Phrase("  .", roman));
            p.Add(new Chunk(new VerticalPositionMark()));
            p.Add(new Phrase("(3 marks)", roman));
            p.Add(new Phrase("_\n\n\n", FontFactory.GetFont("Times New Roman", 10, Font.BOLD, new iTextSharp.text.BaseColor(255, 255, 255))));
            for (int i = 0; i < 11; i++)
            {
                p.Add(new Phrase("        ____________________________________________________________________\n\n", new Font(Font.FontFamily.TIMES_ROMAN, 13f)));
            }

            PdfPCell content = new PdfPCell(new Phrase(p));

            //content.Colspan = 4;
            table.AddCell(content);
            paper1.Add(table);

            Paragraph para = new Paragraph(new Phrase("Answers written in the margins will not be marked.", roman));

            para.Add(new Chunk(new VerticalPositionMark()));
            para.Add(new Phrase("Seed: " + textbox.Text.ToString(), roman));
            paper1.Add(para);
            //Paragraph password = new Paragraph(new Phrase("Password: "******"3.       Factorize\n\n          (a)     ", roman));
            string strquestion4 = GenerateQuestion(4);

            png = iTextSharp.text.Image.GetInstance(new Uri(GenerateImage(strquestion4, "img4.png")));
            png.ScalePercent(10f);
            p.Add(new Chunk(png, 0, -2f));
            p.Add(new Phrase("  ,\n\n          (b)     ", roman));
            string strquestion5 = GenerateQuestion(5);

            png = iTextSharp.text.Image.GetInstance(new Uri(GenerateImage(strquestion5, "img5.png")));
            png.ScalePercent(10f);
            p.Add(new Chunk(png, 0, -2f));
            p.Add(new Phrase("  .", roman));
            //p.TabSettings = new TabSettings();
            //p.Add(Chunk.TABBING);
            p.Add(new Chunk(new VerticalPositionMark()));
            p.Add(new Phrase("(3 marks)", roman));
            p.Add(new Phrase("_\n\n\n", FontFactory.GetFont("Times New Roman", 10, Font.BOLD, new iTextSharp.text.BaseColor(255, 255, 255))));
            for (int i = 0; i < 11; i++)
            {
                p.Add(new Phrase("        ____________________________________________________________________\n\n", new Font(Font.FontFamily.TIMES_ROMAN, 13f)));
            }



            content = new PdfPCell(new Phrase(p));
            //content.Colspan = 4;
            table.AddCell(content);
            paper1.Add(table);

            paper1.Add(para);

            paper1.Close();

            pdfWebViewer.Navigate(System.AppDomain.CurrentDomain.BaseDirectory + "paper1.pdf");
        }
        /// <summary>
        /// This method deals with the starting tags.
        /// </summary>
        /// <param name="name">the name of the tag</param>
        public void HandleEndingTags(string name)
        {
            //System.err.Println("Stop: " + name);

            if (ElementTags.IGNORE.Equals(name))
            {
                Ignore = false;
                return;
            }
            if (Ignore)
            {
                return;
            }
            // tags that don't have any content
            if (isNewpage(name) || ElementTags.ANNOTATION.Equals(name) || ElementTags.IMAGE.Equals(name) || isNewline(name))
            {
                return;
            }

            // titles of sections and chapters
            if (ElementTags.TITLE.Equals(name))
            {
                var current = (Paragraph)Stack.Pop();
                if (CurrentChunk != null)
                {
                    current.Add(CurrentChunk);
                    CurrentChunk = null;
                }
                var previous = (Section)Stack.Pop();
                previous.Title = current;
                Stack.Push(previous);
                return;
            }

            // all other endtags
            if (CurrentChunk != null)
            {
                ITextElementArray current;
                try
                {
                    current = (ITextElementArray)Stack.Pop();
                }
                catch
                {
                    current = new Paragraph();
                }
                current.Add(CurrentChunk);
                Stack.Push(current);
                CurrentChunk = null;
            }

            // chunks
            if (ElementTags.CHUNK.Equals(name))
            {
                return;
            }

            // phrases, anchors, lists, tables
            if (ElementTags.PHRASE.Equals(name) || ElementTags.ANCHOR.Equals(name) || ElementTags.LIST.Equals(name) ||
                ElementTags.PARAGRAPH.Equals(name))
            {
                var current = (IElement)Stack.Pop();
                try
                {
                    var previous = (ITextElementArray)Stack.Pop();
                    previous.Add(current);
                    Stack.Push(previous);
                }
                catch
                {
                    Document.Add(current);
                }
                return;
            }

            // listitems
            if (ElementTags.LISTITEM.Equals(name))
            {
                var listItem = (ListItem)Stack.Pop();
                var list     = (List)Stack.Pop();
                list.Add(listItem);
                Stack.Push(list);
            }

            // tables
            if (ElementTags.TABLE.Equals(name))
            {
                var table = (Table)Stack.Pop();
                try
                {
                    var previous = (ITextElementArray)Stack.Pop();
                    previous.Add(table);
                    Stack.Push(previous);
                }
                catch
                {
                    Document.Add(table);
                }
                return;
            }

            // rows
            if (ElementTags.ROW.Equals(name))
            {
                var   cells   = new ArrayList();
                var   columns = 0;
                Table table;
                Cell  cell;
                while (true)
                {
                    var element = (IElement)Stack.Pop();
                    if (element.Type == Element.CELL)
                    {
                        cell     = (Cell)element;
                        columns += cell.Colspan;
                        cells.Add(cell);
                    }
                    else
                    {
                        table = (Table)element;
                        break;
                    }
                }
                if (table.Columns < columns)
                {
                    table.AddColumns(columns - table.Columns);
                }
                cells.Reverse(0, cells.Count);
                string width;
                var    cellWidths = new float[columns];
                var    cellNulls  = new bool[columns];
                for (var i = 0; i < columns; i++)
                {
                    cellWidths[i] = 0;
                    cellNulls[i]  = true;
                }
                float total = 0;
                var   j     = 0;
                foreach (Cell c in cells)
                {
                    cell  = c;
                    width = cell.GetWidthAsString();
                    if (cell.Width.ApproxEquals(0))
                    {
                        if (cell.Colspan == 1 && cellWidths[j].ApproxEquals(0))
                        {
                            try
                            {
                                cellWidths[j] = 100f / columns;
                                total        += cellWidths[j];
                            }
                            catch
                            {
                                // empty on purpose
                            }
                        }
                        else if (cell.Colspan == 1)
                        {
                            cellNulls[j] = false;
                        }
                    }
                    else if (cell.Colspan == 1 && width.EndsWith("%"))
                    {
                        try
                        {
                            cellWidths[j] = float.Parse(width.Substring(0, width.Length - 1), System.Globalization.NumberFormatInfo.InvariantInfo);
                            total        += cellWidths[j];
                        }
                        catch
                        {
                            // empty on purpose
                        }
                    }
                    j += cell.Colspan;
                    table.AddCell(cell);
                }
                var widths = table.ProportionalWidths;
                if (widths.Length == columns)
                {
                    var left = 0.0f;
                    for (var i = 0; i < columns; i++)
                    {
                        if (cellNulls[i] && widths[i].ApproxNotEqual(0))
                        {
                            left         += widths[i];
                            cellWidths[i] = widths[i];
                        }
                    }
                    if (100.0 >= total)
                    {
                        for (var i = 0; i < widths.Length; i++)
                        {
                            if (cellWidths[i].ApproxEquals(0) && widths[i].ApproxNotEqual(0))
                            {
                                cellWidths[i] = (widths[i] / left) * (100.0f - total);
                            }
                        }
                    }
                    table.Widths = cellWidths;
                }
                Stack.Push(table);
            }

            // registerfont
            if (name.Equals("registerfont"))
            {
                return;
            }

            // header
            if (ElementTags.HEADER.Equals(name))
            {
                Document.Header = (HeaderFooter)Stack.Pop();
                return;
            }

            // footer
            if (ElementTags.FOOTER.Equals(name))
            {
                Document.Footer = (HeaderFooter)Stack.Pop();
                return;
            }

            // before
            if (name.Equals("before"))
            {
                return;
            }

            // after
            if (name.Equals("after"))
            {
                return;
            }

            // cells
            if (ElementTags.CELL.Equals(name))
            {
                return;
            }

            // sections
            if (ElementTags.SECTION.Equals(name))
            {
                Stack.Pop();
                return;
            }

            // chapters
            if (ElementTags.CHAPTER.Equals(name))
            {
                Document.Add((IElement)Stack.Pop());
                return;
            }

            // the documentroot
            if (IsDocumentRoot(name))
            {
                try
                {
                    while (true)
                    {
                        var element = (IElement)Stack.Pop();
                        try
                        {
                            var previous = (ITextElementArray)Stack.Pop();
                            previous.Add(element);
                            Stack.Push(previous);
                        }
                        catch
                        {
                            Document.Add(element);
                        }
                    }
                }
                catch
                {
                    // empty on purpose
                }
                if (ControlOpenClose)
                {
                    Document.Close();
                }

                return;
            }
        }
Ejemplo n.º 19
0
        protected void ExporttoPDF_Click(object sender, EventArgs e)
        {
            ShowMessage("Successfully Export to PDF File", MessageType.success);
            int columnsCount = DoctorsView.HeaderRow.Cells.Count;
            // Create the PDF Table specifying the number of columns
            PdfPTable pdfTable = new PdfPTable(columnsCount);

            // Loop thru each cell in GrdiView header row
            foreach (TableCell gridViewHeaderCell in DoctorsView.HeaderRow.Cells)
            {
                // Create the Font Object for PDF document
                Font font66 = new Font(Font.FontFamily.TIMES_ROMAN, 10.5f, Font.BOLD | Font.NORMAL, BaseColor.WHITE);
                // Set the font color to GridView header row font color

                PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewHeaderCell.Text, font66));
                pdfCell.PaddingTop          = 7;
                pdfCell.MinimumHeight       = 30;
                pdfCell.HorizontalAlignment = 1;
                pdfCell.BackgroundColor     = new BaseColor(61, 60, 65);


                // Add the cell to PDF table
                pdfTable.AddCell(pdfCell);
            }

            // Loop thru each datarow in GrdiView
            foreach (GridViewRow gridViewRow in DoctorsView.Rows)
            {
                if (gridViewRow.RowType == DataControlRowType.DataRow)
                {
                    // Loop thru each cell in GrdiView data row
                    foreach (TableCell gridViewCell in gridViewRow.Cells)
                    {
                        Font font55 = new Font(Font.FontFamily.TIMES_ROMAN, 10f, Font.NORMAL | Font.NORMAL, BaseColor.BLACK);

                        // Set the font color to GridView header row font color

                        PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewCell.Text, font55));
                        pdfCell.HorizontalAlignment = 1;
                        pdfCell.PaddingTop          = 7;
                        pdfCell.MinimumHeight       = 30;
                        //pdfCell.Width = 70;
                        pdfCell.BackgroundColor = new BaseColor(DoctorsView.RowStyle.BackColor);

                        pdfTable.AddCell(pdfCell);
                    }
                }
            }

            // Create the PDF document specifying page size and margins
            Document pdfDocument = new Document(PageSize.A4, 5f, 15f, 5f, 5f);

            pdfDocument.SetPageSize(PageSize.A4.Rotate());
            PdfWriter.GetInstance(pdfDocument, Response.OutputStream);

            pdfDocument.Open();
            //Report Header

            Font      font22     = new Font(Font.FontFamily.TIMES_ROMAN, 12f, Font.NORMAL | Font.NORMAL, BaseColor.BLACK);
            Font      font       = new Font(Font.FontFamily.TIMES_ROMAN, 20f, Font.NORMAL | Font.NORMAL, BaseColor.BLACK);
            Paragraph prgHeading = new Paragraph();

            prgHeading.Alignment = Element.ALIGN_CENTER;
            prgHeading.Add(new Chunk("\nHEALTH BRIDGE\n", font));
            prgHeading.Add(new Chunk("Digital Medical Service Platform Between Patients And Doctors", font22));
            pdfDocument.Add(prgHeading);

            //Filters
            Paragraph prgAuthor = new Paragraph();
            Font      font1     = new Font(Font.FontFamily.TIMES_ROMAN, 11f, Font.NORMAL | Font.NORMAL, BaseColor.BLACK);

            prgAuthor.Alignment = Element.ALIGN_RIGHT;
            prgAuthor.Add(new Chunk("Reported by : Ragiri Rajasekhar\n", font1));
            prgAuthor.Add(new Chunk("Report Date : " + DateTime.Now.ToShortDateString(), font1));
            pdfDocument.Add(prgAuthor);

            //Add a line seperation
            Paragraph p = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 100.0F, BaseColor.BLACK, Element.ALIGN_LEFT, 1)));

            pdfDocument.Add(p);

            //Add line break
            pdfDocument.Add(new Chunk("\n"));


            pdfDocument.Add(pdfTable);
            pdfDocument.Close();

            Response.ContentType = "application/pdf";
            Response.AppendHeader("content-disposition",
                                  "attachment;filename=DoctorsList.pdf");
            Response.Write(pdfDocument);
            Response.Flush();
            Response.End();
        }
        public void xuatBaoCao(GunaDataGridView dgv)
        {
            if (dgv.Rows.Count > 0)
            {
                SaveFileDialog sfd = new SaveFileDialog
                {
                    Filter   = "PDF (*.pdf)|*.pdf",
                    FileName = "Output.pdf"
                };
                bool fileError = false;
                if (sfd.ShowDialog() == DialogResult.OK)
                {
                    if (File.Exists(sfd.FileName))
                    {
                        try
                        {
                            File.Delete(sfd.FileName);
                        }
                        catch (IOException ex)
                        {
                            fileError = true;
                            frm.capNhatLoiNhan("Đang có chương trình mở file này!!!");
                            frm.ShowDialog();
                        }
                    }
                    if (!fileError)
                    {
                        try
                        {
                            PdfPTable pdfTable = new PdfPTable(dgv.Columns.Count);
                            pdfTable.DefaultCell.Padding = 3;
                            pdfTable.WidthPercentage     = 100;
                            pdfTable.HorizontalAlignment = Element.ALIGN_LEFT;

                            BaseFont             bf        = BaseFont.CreateFont(@"C:\WINDOWS\Fonts\TIMES.TTF", BaseFont.IDENTITY_H, true);
                            iTextSharp.text.Font fonttitle = new iTextSharp.text.Font(bf, 15);
                            iTextSharp.text.Font font      = new iTextSharp.text.Font(bf, 10);
                            iTextSharp.text.Font fonttext  = new iTextSharp.text.Font(bf, 12);

                            Paragraph header = new Paragraph
                            {
                                Alignment = Element.ALIGN_CENTER
                            };
                            Paragraph text = new Paragraph();

                            Chunk c1 = new Chunk("BÁO CÁO THỐNG KÊ TRÌNH ĐỘ CHUYÊN MÔN \n", fonttitle);
                            Chunk c2 = new Chunk(DateTime.Now.ToShortDateString() + "\n\n", font);
                            header.Add(c1);
                            header.Add(c2);

                            foreach (DataGridViewColumn column in dgv.Columns)
                            {
                                PdfPCell cell = new PdfPCell(new Phrase(column.HeaderText, fonttext));
                                pdfTable.AddCell(cell);
                            }


                            foreach (DataGridViewRow row in dgv.Rows)
                            {
                                foreach (DataGridViewCell cell in row.Cells)
                                {
                                    PdfPCell cell1 = new PdfPCell(new Phrase(cell.Value.ToString(), fonttext));
                                    pdfTable.AddCell(cell1);
                                }
                            }

                            using (FileStream stream = new FileStream(sfd.FileName, FileMode.Create))
                            {
                                Document pdfDoc = new Document(PageSize.A4, 10f, 20f, 20f, 10f);
                                PdfWriter.GetInstance(pdfDoc, stream);
                                pdfDoc.Open();
                                pdfDoc.Add(header);
                                pdfDoc.Add(pdfTable);
                                pdfDoc.Close();
                                stream.Close();
                            }

                            frm.capNhatLoiNhan("Xuất dữ liệu thành công!!!");
                            frm.ShowDialog();
                        }
                        catch (Exception ex)
                        {
                            frm.capNhatLoiNhan("Có lỗi xảy ra!!!");
                            frm.ShowDialog();
                        }
                    }
                }
            }
            else
            {
                frm.capNhatLoiNhan("Không có bản ghi nào được xuất!!!");
                frm.ShowDialog();
            }
        }
Ejemplo n.º 21
0
        public ActionResult MultiplePDF(string[] files, string[] custNo, string[] custName)
        {
            try
            {
                //string[] files = collection["files"];
                //    , int[] custNo, string[] custName
                var fName = string.Format(DateTime.Now.ToString() + "- .pdf", DateTime.Now.ToString("s"));

                using (MemoryStream stream = new System.IO.MemoryStream())
                {
                    //Initialize the PDF document object.
                    using (Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 10f))
                    {
                        PdfWriter writer = PdfWriter.GetInstance(pdfDoc, stream);
                        pdfDoc.Open();

                        int tableColumns = 3;
                        int col          = 3;

                        PdfPTable table = new PdfPTable(3);



                        for (int i = 0; i < files.Length; i++)
                        {
                            PdfPCell  cell  = new PdfPCell();
                            Paragraph p     = new Paragraph();
                            var       file  = files[i].Split(',')[1];
                            var       bytes = Convert.FromBase64String(file);


                            //Add the Image file to the PDF document object.
                            iTextSharp.text.Image img = iTextSharp.text.Image.GetInstance(bytes);
                            img.ScalePercent(28);


                            img.Border      = iTextSharp.text.Rectangle.BOX;
                            img.BorderColor = BaseColor.BLACK;
                            img.BorderWidth = 2f;
                            img.PaddingTop  = 6f;

                            cell.AddElement(img);


                            BaseFont bfTimes = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, false);


                            iTextSharp.text.Font times = new iTextSharp.text.Font(bfTimes, 9, iTextSharp.text.Font.BOLD, BaseColor.BLACK);


                            p.Add(new Paragraph(Convert.ToString(custNo[i]), times));
                            p.Add(new Paragraph(custName[i], times));
                            p.Alignment = Element.ALIGN_CENTER;
                            p.Add(" ");
                            p.Add(" ");
                            p.Add(" ");


                            cell.AddElement(p);


                            table.AddCell(cell);
                        }

                        pdfDoc.Add(table);



                        pdfDoc.Close();



                        //Download the PDF file.
                        //return File(stream.ToArray(), "application/pdf", "ImageExport.pdf");
                    }

                    var bytes1 = stream.ToArray();
                    Session[fName] = bytes1;

                    for (var i = 0; i < custNo.Length; i++)
                    {
                        var cid    = custNo[i].Split('-');
                        int intcid = Convert.ToInt32(cid[0].Trim());

                        var singlecustomer = db.Customers.Where(x => x.Cid == intcid).SingleOrDefault();
                        if (singlecustomer != null)
                        {
                            singlecustomer.QRCode          = 1;
                            db.Entry(singlecustomer).State = EntityState.Modified;
                            db.SaveChanges();
                        }
                    }
                }

                return(Json(new { success = true, pdf = true, fName }, JsonRequestBehavior.AllowGet));
            }

            catch (Exception e)
            {
                throw e;
            }
        }
Ejemplo n.º 22
0
        } // Add information about Client to Offer Form

        private void button2_Click(object sender, EventArgs e)
        {
            PdfPCell getCell(String text, int alignment)
            {
                string   ss = @"C:\Windows\Fonts\micross.ttf";
                BaseFont aa = BaseFont.CreateFont(ss, BaseFont.IDENTITY_H, BaseFont.EMBEDDED);

                iTextSharp.text.Font bb   = new iTextSharp.text.Font(aa, 8, iTextSharp.text.Font.NORMAL);
                PdfPCell             cell = new PdfPCell(new Phrase(text, bb));

                cell.Padding             = (0);
                cell.HorizontalAlignment = alignment;
                cell.Border = PdfPCell.NO_BORDER;
                return(cell);
            }

            string My_Info     = "";
            string Client_info = "";

            using (zlecenieEntities db = new zlecenieEntities())
            {
                int My_ID     = 20;
                int Client_ID = _o.ID;
                if (_o != null)
                {
                    Client_ID = _o.Id_zleceniodawca;
                }
                else
                {
                    Client_ID = client_id;
                }

                My_Info = db.kontrahent.Find(My_ID).Imie + " " + db.kontrahent.Find(My_ID).Nazwisko + "\n" + db.kontrahent.Find(My_ID).Nazwa_Firmy + "\nul. " + db.adres.Find(db.kontrahent.Find(My_ID).Adres).Nazwa_ulicy +
                          " " + db.adres.Find(db.kontrahent.Find(My_ID).Adres).Numer_budynku + "/" + db.adres.Find(db.kontrahent.Find(My_ID).Adres).Numer_mieszkania + "\n" +
                          db.adres.Find(db.kontrahent.Find(My_ID).Adres).Kod_pocztowy.Remove(2, 3) + "-" + db.adres.Find(db.kontrahent.Find(My_ID).Adres).Kod_pocztowy.Remove(0, 2) + " " + db.adres.Find(db.kontrahent.Find(My_ID).Adres).Miasto + "\nNIP: " +
                          db.kontrahent.Find(My_ID).NIP + "\nPESEL: " + db.kontrahent.Find(My_ID).Pesel + "\nEmail: " + db.kontrahent.Find(My_ID).E_mail + "\nTel: " + db.kontrahent.Find(My_ID).Telefon_1 +
                          "\nTel: " + db.kontrahent.Find(My_ID).Telefon_2 + "\nPaństwo: " + db.adres.Find(db.kontrahent.Find(My_ID).Adres).Państwo;

                Client_info = db.kontrahent.Find(Client_ID).Imie + " " + db.kontrahent.Find(Client_ID).Nazwisko + "\n" + db.kontrahent.Find(Client_ID).Nazwa_Firmy + "\nul. " + db.adres.Find(db.kontrahent.Find(Client_ID).Adres).Nazwa_ulicy +
                              " " + db.adres.Find(db.kontrahent.Find(Client_ID).Adres).Numer_budynku + "/" + db.adres.Find(db.kontrahent.Find(Client_ID).Adres).Numer_mieszkania + "\n" +
                              db.adres.Find(db.kontrahent.Find(Client_ID).Adres).Kod_pocztowy.Remove(2, 3) + "-" + db.adres.Find(db.kontrahent.Find(Client_ID).Adres).Kod_pocztowy.Remove(0, 2) + " " + db.adres.Find(db.kontrahent.Find(Client_ID).Adres).Miasto + "\nNIP: " +
                              db.kontrahent.Find(Client_ID).NIP + "\nPESEL: " + db.kontrahent.Find(Client_ID).Pesel + "\nEmail: " + db.kontrahent.Find(Client_ID).E_mail + "\nTel: " + db.kontrahent.Find(Client_ID).Telefon_1 +
                              "\nTel: " + db.kontrahent.Find(Client_ID).Telefon_2 + "\nPaństwo: " + db.adres.Find(db.kontrahent.Find(Client_ID).Adres).Państwo;
            }

            Document document = new Document();

            PdfWriter.GetInstance(document, new FileStream(@"E:\E-elektryk oferty\" + _o.ID + "_" + DateTime.Now.Month + "_" + DateTime.Now.Year + ".pdf", FileMode.Create));
            document.Open();

            #region font

            string               myFont             = @"C:\Windows\Fonts\micross.ttf";
            BaseFont             bf                 = BaseFont.CreateFont(myFont, BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
            iTextSharp.text.Font Font_Table_Headers = new iTextSharp.text.Font(bf, 8, iTextSharp.text.Font.BOLD);
            iTextSharp.text.Font Font_Table_Cells   = new iTextSharp.text.Font(bf, 6, iTextSharp.text.Font.NORMAL);
            iTextSharp.text.Font Title_Font         = new iTextSharp.text.Font(bf, 12, iTextSharp.text.Font.BOLD);

            #endregion

            #region Client_info

            PdfPTable headers = new PdfPTable(2);
            headers.HorizontalAlignment = Element.ALIGN_LEFT;
            headers.AddCell(getCell(My_Info, Element.ALIGN_LEFT));
            headers.AddCell(getCell(Client_info, Element.ALIGN_RIGHT));
            document.Add(headers);

            #endregion

            #region Title

            Paragraph title = new Paragraph();
            Chunk     c1    = new Chunk("Oferta nr: " + _o.ID + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year, Title_Font);
            title.Add(c1);
            title.Alignment = Element.ALIGN_CENTER;
            document.Add(title);
            Paragraph pause = new Paragraph();
            Chunk     c2    = new Chunk(" ", Title_Font);
            pause.Add(c2);
            pause.Alignment = Element.ALIGN_CENTER;
            document.Add(pause);

            #endregion

            #region date

            Paragraph date = new Paragraph();
            Chunk     c3   = new Chunk("Oferta ważna od: " + dateTimePicker1.Value.ToString().Remove(10, 9) + "\r", Font_Table_Cells);
            Chunk     c4   = new Chunk("Oferta ważna do: " + dateTimePicker2.Value.ToString().Remove(10, 9), Font_Table_Cells);
            date.Add(c3);
            date.Add(c4);
            date.Alignment = Element.ALIGN_LEFT;
            document.Add(date);
            document.Add(pause);

            #endregion

            #region tabela

            int       columns = dataGridView1.Columns.Count;
            PdfPTable table   = new PdfPTable(columns);

            float[] widths = new float[] { 10, 45, 25, 10, 15, 15, 15, 10, 15, 30 };
            table.SetWidths(widths);
            table.AddCell(new PdfPCell(new Phrase("ID", Font_Table_Headers)));
            table.AddCell(new PdfPCell(new Phrase("Nazwa", Font_Table_Headers)));
            table.AddCell(new PdfPCell(new Phrase("Producent", Font_Table_Headers)));
            table.AddCell(new PdfPCell(new Phrase("JM", Font_Table_Headers)));
            table.AddCell(new PdfPCell(new Phrase("Ilość", Font_Table_Headers)));
            table.AddCell(new PdfPCell(new Phrase("C.j", Font_Table_Headers)));
            table.AddCell(new PdfPCell(new Phrase("Netto", Font_Table_Headers)));
            table.AddCell(new PdfPCell(new Phrase("Vat", Font_Table_Headers)));
            table.AddCell(new PdfPCell(new Phrase("Brutto", Font_Table_Headers)));
            table.AddCell(new PdfPCell(new Phrase("Kategoria", Font_Table_Headers)));

            for (int j = 0; j < dataGridView1.Rows.Count; j++)
            {
                for (int i = 0; i < dataGridView1.Columns.Count; i++)
                {
                    table.AddCell(new PdfPCell(new Phrase(dataGridView1.Rows[j].Cells[i].Value.ToString(), Font_Table_Cells)));
                }
            }

            document.Add(table);

            #endregion

            document.Close();
            MessageBox.Show("Utworzono ofertę " + _o.ID + "." + DateTime.Now.Month + "." + DateTime.Now.Year + ".pdf");
            Process myProcess = new Process();
            myProcess.StartInfo.FileName  = "acroRd32.exe"; //not the full application path
            myProcess.StartInfo.Arguments = "\"" + @"E:\E-elektryk oferty\" + _o.ID + "_" + DateTime.Now.Month + "_" + DateTime.Now.Year + ".pdf" + "\"";
            myProcess.Start();
        } // Generate offer pdf using itextsharp
Ejemplo n.º 23
0
        public void GERARELATORIO(int tipo)
        {
            //CRIA O PDF
            Document relatorio = new Document(PageSize.A4.Rotate());

            relatorio.SetMargins(30, 20, 30, 20);
            relatorio.AddCreationDate();

            //CAMINHO ONDE O PDF É SALVO E O NOME DO PDF
            string caminho = @"C:\Users\defar\Desktop\relatoriopr.pdf";

            PdfWriter writer = PdfWriter.GetInstance(relatorio, new FileStream(caminho, FileMode.Create));

            //ABRI O PDF
            relatorio.Open();

            //-----------------------------------------------------------------------------------


            SqlDataReader leitor;
            SqlCommand    selecionafilme = new SqlCommand();
            SqlConnection conexao        = new SqlConnection();

            //-------------------------------------------------------------------------------------------------
            //-------------------------------------------------------------------------------------------------



            conexao = new SqlConnection("Data Source = DESKTOP-L0FTKI7; Initial Catalog = ALTERNATIVA; Integrated Security=SSPI");
            conexao.Open();


            selecionafilme = new SqlCommand("SELECT NOMEFAN AS NOME, ENDERECO, NUMERO, COMPLEMENTO, BARRIO AS BAIRRO, CEP, CIDADE, ESTADO, TELEFONE, CELULAR, EMAIL, VINCULAR FROM EMPRESA", conexao);


            //-------------------------------------------------------------------------------------------------
            //-------------------------------------------------------------------------------------------------
            Paragraph paragrafo = new Paragraph();

            leitor = selecionafilme.ExecuteReader();
            if (leitor.Read() != false)
            {
                if (leitor["VINCULAR"].ToString() == "S")
                {
                    paragrafo.Alignment = Element.ALIGN_CENTER;
                    paragrafo.Add(leitor["NOME"].ToString());
                    relatorio.Add(paragrafo);

                    if (leitor["COMPLEMENTO"].ToString() == "")
                    {
                        paragrafo           = new Paragraph();
                        paragrafo.Alignment = Element.ALIGN_CENTER;
                        paragrafo.Add(leitor["ENDERECO"].ToString() + ", " + leitor["NUMERO"].ToString() + " - " + leitor["BAIRRO"].ToString());
                        relatorio.Add(paragrafo);
                    }
                    else
                    {
                        paragrafo           = new Paragraph();
                        paragrafo.Alignment = Element.ALIGN_CENTER;
                        paragrafo.Add(leitor["ENDERECO"].ToString() + ", " + leitor["NUMERO"].ToString() + ", " + leitor["COMPLEMENTO"].ToString() + " - " + leitor["BAIRRO"].ToString());
                        relatorio.Add(paragrafo);
                    }

                    paragrafo           = new Paragraph();
                    paragrafo.Alignment = Element.ALIGN_CENTER;
                    paragrafo.Add("CEP " + leitor["CEP"].ToString() + " - " + leitor["CIDADE"].ToString() + " - " + leitor["ESTADO"].ToString());
                    relatorio.Add(paragrafo);


                    if ((leitor["TELEFONE"].ToString() == "(  )     -") && (leitor["CELULAR"].ToString() != "(  )     -"))
                    {
                        paragrafo           = new Paragraph();
                        paragrafo.Alignment = Element.ALIGN_CENTER;
                        paragrafo.Add("FONE: " + leitor["CELULAR"].ToString());
                        relatorio.Add(paragrafo);
                    }
                    else if ((leitor["TELEFONE"].ToString() != "(  )     -") && (leitor["CELULAR"].ToString() == "(  )     -"))
                    {
                        paragrafo           = new Paragraph();
                        paragrafo.Alignment = Element.ALIGN_CENTER;
                        paragrafo.Add("FONE: " + leitor["TELEFONE"].ToString());
                        relatorio.Add(paragrafo);
                    }
                    else
                    {
                        paragrafo           = new Paragraph();
                        paragrafo.Alignment = Element.ALIGN_CENTER;
                        paragrafo.Add("FONE: " + leitor["TELEFONE"].ToString() + " / " + leitor["CELULAR"].ToString());
                        relatorio.Add(paragrafo);
                    }

                    paragrafo           = new Paragraph();
                    paragrafo.Alignment = Element.ALIGN_CENTER;
                    paragrafo.Add("E-MAIL: " + leitor["EMAIL"].ToString());
                    relatorio.Add(paragrafo);

                    paragrafo           = new Paragraph();
                    paragrafo.Alignment = Element.ALIGN_CENTER;
                    paragrafo.Add(" ");
                    relatorio.Add(paragrafo);

                    paragrafo           = new Paragraph();
                    paragrafo.Alignment = Element.ALIGN_CENTER;
                    paragrafo.Add("RELATÓRIO DE PRODUTOS - MÍNIMO");

                    relatorio.Add(paragrafo);

                    paragrafo           = new Paragraph();
                    paragrafo.Alignment = Element.ALIGN_CENTER;
                    paragrafo.Add(" ");
                    relatorio.Add(paragrafo);
                }


                else
                {
                    //-----------------------------------------------------------------------------------
                    //PARAGRAFOS DE INICIO

                    paragrafo.Alignment = Element.ALIGN_CENTER;
                    paragrafo.Add("ALTERNATIVA MOTOS");
                    relatorio.Add(paragrafo);

                    paragrafo           = new Paragraph();
                    paragrafo.Alignment = Element.ALIGN_CENTER;
                    paragrafo.Add("RELATÓRIO DE PRODUTOS");
                    relatorio.Add(paragrafo);

                    for (int I = 0; I < 3; I++)
                    {
                        paragrafo           = new Paragraph();
                        paragrafo.Alignment = Element.ALIGN_CENTER;
                        paragrafo.Add(" ");
                        relatorio.Add(paragrafo);
                    }
                }
                leitor.Close();
                conexao.Close();

                if (tipo == 2)
                {
                    //TABELA COM OS DADOS DO CLIENTE
                    PdfPTable CABECALHO = new PdfPTable(7);

                    CABECALHO.TotalWidth  = 650f;
                    CABECALHO.LockedWidth = true;
                    float[] widths = new float[] { 75f, 85f, 150f, 100f, 100f, 70f, 70f };
                    CABECALHO.SetWidths(widths);


                    conexao = new SqlConnection("Data Source = DESKTOP-L0FTKI7; Initial Catalog = ALTERNATIVA; Integrated Security=SSPI");
                    conexao.Open();

                    selecionafilme = new SqlCommand("SELECT CODIGO, CBARRAS,DESCRICAO,MARCA,MODELO,QUANTIDADE,ESTOQUEMIN FROM PRODUTOS where quantidade <= estoquemin and tipo = 'Produto'", conexao);


                    Phrase item1 = new Phrase("Código");
                    var    cel   = new PdfPCell(item1);
                    CABECALHO.AddCell(cel);

                    Phrase item2 = new Phrase("Cód. de Barras");
                    cel = new PdfPCell(item2);
                    CABECALHO.AddCell(cel);


                    Phrase item3 = new Phrase("Descrição");
                    cel         = new PdfPCell(item3);
                    cel.Colspan = 1;
                    CABECALHO.AddCell(cel);

                    Phrase item4 = new Phrase("Marca");
                    cel = new PdfPCell(item4);
                    CABECALHO.AddCell(cel);

                    Phrase item5 = new Phrase("Modelo");
                    cel = new PdfPCell(item5);
                    CABECALHO.AddCell(cel);

                    Phrase item6 = new Phrase("Quantidade");
                    cel = new PdfPCell(item6);
                    CABECALHO.AddCell(cel);

                    Phrase item7 = new Phrase("Mínimo");
                    cel = new PdfPCell(item7);
                    CABECALHO.AddCell(cel);

                    item1               = new Phrase(" ");
                    item1.Font.Size     = 2;
                    cel                 = new PdfPCell(item1);
                    cel.Colspan         = 7;
                    cel.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
                    CABECALHO.AddCell(cel);


                    leitor = selecionafilme.ExecuteReader();
                    while (leitor.Read() != false)
                    {
                        item1 = new Phrase(leitor["CODIGO"].ToString());
                        cel   = new PdfPCell(item1);
                        CABECALHO.AddCell(cel);

                        item2 = new Phrase(leitor["CBARRAS"].ToString());
                        cel   = new PdfPCell(item2);
                        CABECALHO.AddCell(cel);


                        item3       = new Phrase(leitor["DESCRICAO"].ToString());
                        cel         = new PdfPCell(item3);
                        cel.Colspan = 1;
                        CABECALHO.AddCell(cel);


                        item4 = new Phrase(leitor["MARCA"].ToString());
                        cel   = new PdfPCell(item4);
                        CABECALHO.AddCell(cel);

                        item5 = new Phrase(leitor["MODELO"].ToString());
                        cel   = new PdfPCell(item5);
                        CABECALHO.AddCell(cel);


                        item6 = new Phrase(leitor["QUANTIDADE"].ToString());
                        cel   = new PdfPCell(item6);
                        CABECALHO.AddCell(cel);

                        item7 = new Phrase(leitor["ESTOQUEMIN"].ToString());
                        cel   = new PdfPCell(item7);
                        CABECALHO.AddCell(cel);
                    }
                    conexao.Close();
                    leitor.Close();


                    item1               = new Phrase(" ");
                    item1.Font.Size     = 2;
                    cel                 = new PdfPCell(item1);
                    cel.Colspan         = 7;
                    cel.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
                    CABECALHO.AddCell(cel);

                    relatorio.Add(CABECALHO);

                    paragrafo           = new Paragraph();
                    paragrafo.Alignment = Element.ALIGN_CENTER;
                    paragrafo.Add(" ");
                    relatorio.Add(paragrafo);

                    paragrafo           = new Paragraph();
                    paragrafo.Alignment = Element.ALIGN_CENTER;
                    paragrafo.Add(" ");
                    relatorio.Add(paragrafo);
                }
                else if (tipo == 1)
                {
                    //TABELA COM OS DADOS DO CLIENTE
                    PdfPTable CABECALHO = new PdfPTable(7);

                    CABECALHO.TotalWidth  = 650f;
                    CABECALHO.LockedWidth = true;
                    float[] widths = new float[] { 75f, 85f, 150f, 100f, 100f, 70f, 70f };
                    CABECALHO.SetWidths(widths);


                    conexao = new SqlConnection("Data Source = DESKTOP-L0FTKI7; Initial Catalog = ALTERNATIVA; Integrated Security=SSPI");
                    conexao.Open();

                    selecionafilme = new SqlCommand("SELECT CODIGO, CBARRAS,DESCRICAO,MARCA,MODELO,PVENDA,QUANTIDADE FROM PRODUTOS", conexao);


                    Phrase item1 = new Phrase("Código");
                    var    cel   = new PdfPCell(item1);
                    CABECALHO.AddCell(cel);

                    Phrase item2 = new Phrase("Cód. de Barras");
                    cel = new PdfPCell(item2);
                    CABECALHO.AddCell(cel);


                    Phrase item3 = new Phrase("Descrição");
                    cel         = new PdfPCell(item3);
                    cel.Colspan = 1;
                    CABECALHO.AddCell(cel);

                    Phrase item4 = new Phrase("Marca");
                    cel = new PdfPCell(item4);
                    CABECALHO.AddCell(cel);

                    Phrase item5 = new Phrase("Modelo");
                    cel = new PdfPCell(item5);
                    CABECALHO.AddCell(cel);

                    Phrase item6 = new Phrase("Preço de Venda");
                    cel = new PdfPCell(item6);
                    CABECALHO.AddCell(cel);

                    Phrase item7 = new Phrase("Quantidade");
                    cel = new PdfPCell(item7);
                    CABECALHO.AddCell(cel);

                    item1               = new Phrase(" ");
                    item1.Font.Size     = 2;
                    cel                 = new PdfPCell(item1);
                    cel.Colspan         = 7;
                    cel.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
                    CABECALHO.AddCell(cel);
                    double pvenda;

                    leitor = selecionafilme.ExecuteReader();
                    while (leitor.Read() != false)
                    {
                        item1 = new Phrase(leitor["CODIGO"].ToString());
                        cel   = new PdfPCell(item1);
                        CABECALHO.AddCell(cel);

                        item2 = new Phrase(leitor["CBARRAS"].ToString());
                        cel   = new PdfPCell(item2);
                        CABECALHO.AddCell(cel);


                        item3       = new Phrase(leitor["DESCRICAO"].ToString());
                        cel         = new PdfPCell(item3);
                        cel.Colspan = 1;
                        CABECALHO.AddCell(cel);


                        item4 = new Phrase(leitor["MARCA"].ToString());
                        cel   = new PdfPCell(item4);
                        CABECALHO.AddCell(cel);

                        item5 = new Phrase(leitor["MODELO"].ToString());
                        cel   = new PdfPCell(item5);
                        CABECALHO.AddCell(cel);

                        pvenda = double.Parse(leitor["PVENDA"].ToString());
                        item6  = new Phrase(pvenda.ToString("0.00"));
                        cel    = new PdfPCell(item6);
                        CABECALHO.AddCell(cel);

                        item7 = new Phrase(leitor["QUANTIDADE"].ToString());
                        cel   = new PdfPCell(item7);
                        CABECALHO.AddCell(cel);
                    }
                    conexao.Close();
                    leitor.Close();


                    item1               = new Phrase(" ");
                    item1.Font.Size     = 2;
                    cel                 = new PdfPCell(item1);
                    cel.Colspan         = 7;
                    cel.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
                    CABECALHO.AddCell(cel);

                    relatorio.Add(CABECALHO);

                    paragrafo           = new Paragraph();
                    paragrafo.Alignment = Element.ALIGN_CENTER;
                    paragrafo.Add(" ");
                    relatorio.Add(paragrafo);

                    paragrafo           = new Paragraph();
                    paragrafo.Alignment = Element.ALIGN_CENTER;
                    paragrafo.Add(" ");
                    relatorio.Add(paragrafo);
                }
            }

            //TEM QUE FECHAR O PDF PARA QUE CONSIGA VIZUALIZAR
            relatorio.Close();
            //APRESENTA O PDF
            System.Diagnostics.Process.Start(@"C:\Users\defar\Desktop\relatoriopr.pdf");
        }
Ejemplo n.º 24
0
        public MemoryStream GeneratePdfTemplate(ExternalPurchaseOrderViewModel viewModel, int clientTimeZoneOffset)
        {
            Font header_font  = FontFactory.GetFont(BaseFont.HELVETICA, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 18);
            Font normal_font  = FontFactory.GetFont(BaseFont.HELVETICA, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 9);
            Font small_font   = FontFactory.GetFont(BaseFont.HELVETICA, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 8);
            Font smaller_font = FontFactory.GetFont(BaseFont.HELVETICA, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 7);
            Font bold_font    = FontFactory.GetFont(BaseFont.HELVETICA_BOLD, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 7);
            Font bold_font2   = FontFactory.GetFont(BaseFont.HELVETICA_BOLD, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 8);
            Font bold_font3   = FontFactory.GetFont(BaseFont.HELVETICA_BOLD, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 9);
            Font bold_font4   = FontFactory.GetFont(BaseFont.HELVETICA_BOLD, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 10);

            Document     document = new Document(PageSize.A5, 25, 25, 25, 25);
            MemoryStream stream   = new MemoryStream();
            PdfWriter    writer   = PdfWriter.GetInstance(document, stream);

            document.Open();

            #region Header

            PdfPTable tableHeader = new PdfPTable(2);
            tableHeader.SetWidths(new float[] { 4f, 4f });
            PdfPCell cellHeaderContentLeft = new PdfPCell()
            {
                Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT
            };
            PdfPCell cellHeaderContentRight = new PdfPCell()
            {
                Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT
            };

            cellHeaderContentLeft.Phrase = new Phrase("PT. EFRATA RETAILINDO", bold_font4);
            tableHeader.AddCell(cellHeaderContentLeft);
            cellHeaderContentRight.Phrase = new Phrase("FM-PB-00-06-009/R1", bold_font);
            tableHeader.AddCell(cellHeaderContentRight);

            //cellHeaderContentLeft.Phrase = new Phrase("Head Office: Kelurahan Banaran", bold_font2);
            //tableHeader.AddCell(cellHeaderContentLeft);

            //cellHeaderContentRight.Phrase = new Phrase("FM-PB-00-06-009/R1" + "\n" + "Nomor PO: " + viewModel.no, bold_font2);
            //tableHeader.AddCell(cellHeaderContentRight);
            //cellHeaderContentRight.Phrase = new Phrase("FM-PB-00-06-009/R1", bold_font2);
            //tableHeader.AddCell(cellHeaderContentRight);

            cellHeaderContentLeft.Phrase = new Phrase("Head Office:" + "\n" + "Kelurahan Banaran" + "\n" + "Kecamatan Grogol" + "\n" + "Sukoharjo 57552" + "\n" + "JAWA TENGAH" + "\n" + "Telp. (0271) ) 740888, 719911" + "\n" + "Fax. (0271) ) 735222, 740777", bold_font);
            tableHeader.AddCell(cellHeaderContentLeft);

            cellHeaderContentRight.Phrase = new Phrase("Nomor PO: " + viewModel.no, bold_font2);
            tableHeader.AddCell(cellHeaderContentRight);

            PdfPCell cellHeader = new PdfPCell(tableHeader); // dont remove
            tableHeader.ExtendLastRow = false;
            tableHeader.SpacingAfter  = 10f;
            document.Add(tableHeader);

            string titleString = "ORDER PEMBELIAN";
            bold_font3.SetStyle(Font.UNDERLINE);
            Paragraph title = new Paragraph(titleString, bold_font3)
            {
                Alignment = Element.ALIGN_CENTER
            };
            document.Add(title);
            bold_font.SetStyle(Font.NORMAL);

            #endregion

            #region Identity

            PdfPTable tableIdentity = new PdfPTable(3);
            tableIdentity.SetWidths(new float[] { 1.2f, 2.5f, 2.9f });
            PdfPCell cellIdentityContentLeft = new PdfPCell()
            {
                Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT
            };
            PdfPCell cellIdentityContentRight = new PdfPCell()
            {
                Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT
            };
            cellIdentityContentLeft.Phrase = new Phrase("Kepada Yth", small_font);
            tableIdentity.AddCell(cellIdentityContentLeft);
            cellIdentityContentLeft.Phrase = new Phrase(": " + viewModel.supplier.name, small_font);
            tableIdentity.AddCell(cellIdentityContentLeft);
            cellIdentityContentRight.Phrase = new Phrase("Sukoharjo, " + viewModel.orderDate.ToOffset(new TimeSpan(clientTimeZoneOffset, 0, 0)).ToString("dd MMMM yyyy", new CultureInfo("id-ID")), small_font);
            tableIdentity.AddCell(cellIdentityContentRight);
            cellIdentityContentLeft.Phrase = new Phrase(" ", small_font);
            tableIdentity.AddCell(cellIdentityContentLeft);
            cellIdentityContentLeft.Phrase = new Phrase("  " + "Attn. \n  Telp.", small_font);
            tableIdentity.AddCell(cellIdentityContentLeft);
            cellIdentityContentRight.Phrase = new Phrase("Mohon di-fax kembali setelah ditandatangani dan distempel perusahaan. Terima Kasih.", small_font);
            tableIdentity.AddCell(cellIdentityContentRight);
            //cellIdentityContentLeft.Phrase = new Phrase(" ", normal_font);
            //tableIdentity.AddCell(cellIdentityContentLeft);
            //cellIdentityContentLeft.Phrase = new Phrase(" " + "Telp.", normal_font);
            //tableIdentity.AddCell(cellIdentityContentLeft);
            //cellIdentityContentRight.Phrase = new Phrase("ditandatangani dan distempel", normal_font);
            //tableIdentity.AddCell(cellIdentityContentRight);
            //cellIdentityContentLeft.Phrase = new Phrase(" ", normal_font);
            //tableIdentity.AddCell(cellIdentityContentLeft);
            //cellIdentityContentLeft.Phrase = new Phrase(" " + " ", normal_font);
            //tableIdentity.AddCell(cellIdentityContentLeft);
            //cellIdentityContentRight.Phrase = new Phrase("perusahaan. Terima Kasih.", normal_font);
            //tableIdentity.AddCell(cellIdentityContentRight);
            PdfPCell cellIdentity = new PdfPCell(tableIdentity); // dont remove
            tableIdentity.ExtendLastRow = false;
            tableIdentity.SpacingBefore = 5f;
            document.Add(tableIdentity);

            #endregion

            document.Add(new Paragraph("Dengan Hormat,", normal_font)
            {
                Alignment = Element.ALIGN_LEFT
            });
            string    firstParagraphString = "Yang bertanda tangan di bawah ini, PT. EFRATA RETAILINDO (selanjutnya disebut sebagai pihak Pembeli) dan " + viewModel.supplier.name + "(selanjutnya disebut sebagai pihak Penjual) saling menyetujui untuk mengadaan kontrak jual beli dengan ketentuan sebagai berikut : ";
            Paragraph firstParagraph       = new Paragraph(firstParagraphString, small_font)
            {
                Alignment = Element.ALIGN_LEFT
            };

            firstParagraph.SpacingAfter = 10f;
            document.Add(firstParagraph);

            #region Items

            PdfPCell cellCenter = new PdfPCell()
            {
                Border = Rectangle.TOP_BORDER | Rectangle.LEFT_BORDER | Rectangle.BOTTOM_BORDER | Rectangle.RIGHT_BORDER, HorizontalAlignment = Element.ALIGN_CENTER, VerticalAlignment = Element.ALIGN_MIDDLE, Padding = 5
            };
            PdfPCell cellCenter2 = new PdfPCell()
            {
                Border = Rectangle.TOP_BORDER | Rectangle.LEFT_BORDER | Rectangle.BOTTOM_BORDER | Rectangle.RIGHT_BORDER, HorizontalAlignment = Element.ALIGN_CENTER, VerticalAlignment = Element.ALIGN_MIDDLE, Padding = 0
            };
            PdfPCell cellRight = new PdfPCell()
            {
                Border = Rectangle.TOP_BORDER | Rectangle.LEFT_BORDER | Rectangle.BOTTOM_BORDER | Rectangle.RIGHT_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT, VerticalAlignment = Element.ALIGN_MIDDLE, Padding = 5
            };
            PdfPCell cellLeft = new PdfPCell()
            {
                Border = Rectangle.TOP_BORDER | Rectangle.LEFT_BORDER | Rectangle.BOTTOM_BORDER | Rectangle.RIGHT_BORDER, HorizontalAlignment = Element.ALIGN_LEFT, VerticalAlignment = Element.ALIGN_MIDDLE, Padding = 5
            };

            PdfPCell cellRightMerge = new PdfPCell()
            {
                Border = Rectangle.NO_BORDER | Rectangle.NO_BORDER | Rectangle.BOTTOM_BORDER | Rectangle.RIGHT_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT, VerticalAlignment = Element.ALIGN_TOP, Padding = 5
            };
            PdfPCell cellLeftMerge = new PdfPCell()
            {
                Border = Rectangle.NO_BORDER | Rectangle.LEFT_BORDER | Rectangle.BOTTOM_BORDER | Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT, VerticalAlignment = Element.ALIGN_TOP, Padding = 5
            };

            PdfPTable tableContent = new PdfPTable(6);
            tableContent.SetWidths(new float[] { 6.5f, 3f, 1.5f, 3.6f, 1.5f, 4.1f });

            cellCenter.Phrase = new Phrase("NAMA DAN JENIS BARANG", bold_font);
            tableContent.AddCell(cellCenter);
            cellCenter.Phrase = new Phrase("JUMLAH", bold_font);
            tableContent.AddCell(cellCenter);
            cellCenter.Phrase  = new Phrase("HARGA SATUAN", bold_font);
            cellCenter.Colspan = 2;
            tableContent.AddCell(cellCenter);
            cellCenter.Phrase  = new Phrase("SUB TOTAL", bold_font);
            cellCenter.Colspan = 2;
            tableContent.AddCell(cellCenter);

            double total = 0;
            //for (int a = 0; a < 20; a++) // coba kalau banyak baris ^_^
            foreach (ExternalPurchaseOrderItemViewModel item in viewModel.items)
            {
                for (int indexItem = 0; indexItem < item.details.Count; indexItem++)
                {
                    ExternalPurchaseOrderDetailViewModel detail = item.details[indexItem];

                    string line1 = detail.product.name + "\n";
                    string line2 = detail.productRemark + "\n";
                    string line3 = item.prNo;

                    Paragraph p1  = new Paragraph();
                    Phrase    ph1 = new Phrase(line1, smaller_font);
                    Phrase    ph2 = new Phrase(line2, smaller_font);
                    Phrase    ph3 = new Phrase(line3, smaller_font);

                    p1.Add(ph1);
                    p1.Add(ph2);
                    p1.Add(ph3);

                    tableContent.AddCell(p1);

                    cellCenter2.Phrase = new Phrase(string.Format("{0:n2}", detail.dealQuantity) + " " + $"{detail.dealUom.unit}", smaller_font);
                    tableContent.AddCell(cellCenter2);

                    cellLeftMerge.Phrase = new Phrase($"{viewModel.currency.code}", smaller_font);
                    tableContent.AddCell(cellLeftMerge);

                    cellRightMerge.Phrase = new Phrase($"{detail.pricePerDealUnit.ToString("N", new CultureInfo("id-ID"))}", smaller_font);
                    tableContent.AddCell(cellRightMerge);

                    double subtotalPrice = detail.pricePerDealUnit * detail.dealQuantity;

                    cellLeftMerge.Phrase = new Phrase($"{viewModel.currency.code}", smaller_font);
                    tableContent.AddCell(cellLeftMerge);

                    cellRightMerge.Phrase = new Phrase($"{subtotalPrice.ToString("N", new CultureInfo("id-ID"))}", smaller_font);
                    tableContent.AddCell(cellRightMerge);

                    total += subtotalPrice;
                }
            }


            cellRight.Colspan = 4;
            cellRight.Phrase  = new Phrase("Total", bold_font);
            tableContent.AddCell(cellRight);

            cellLeftMerge.Phrase = new Phrase($"{viewModel.currency.code}", smaller_font);
            tableContent.AddCell(cellLeftMerge);
            cellRightMerge.Phrase = new Phrase($"{total.ToString("N", new CultureInfo("id-ID"))}", smaller_font);
            tableContent.AddCell(cellRightMerge);

            cellRight.Colspan = 4;
            //cellRight.Phrase = new Phrase("PPN 11%", bold_font);
            cellRight.Phrase = new Phrase($"PPN {viewModel.vatRate}%", bold_font);
            tableContent.AddCell(cellRight);

            cellLeftMerge.Phrase = new Phrase($"{viewModel.currency.code}", smaller_font);
            tableContent.AddCell(cellLeftMerge);

            string ppn        = "0.00";
            double ppnNominal = 0;
            if (viewModel.useVat)
            {
                //ppnNominal = total * 11 / 100;
                ppnNominal = total * viewModel.vatRate / 100;
                ppn        = $"{ppnNominal.ToString("N", new CultureInfo("id-ID"))}";
            }
            cellRightMerge.Phrase = new Phrase(ppn, smaller_font);
            tableContent.AddCell(cellRightMerge);

            cellRight.Colspan = 4;
            cellRight.Phrase  = new Phrase("Grand Total", bold_font);
            tableContent.AddCell(cellRight);

            cellLeftMerge.Phrase = new Phrase($"{viewModel.currency.code}", smaller_font);
            tableContent.AddCell(cellLeftMerge);

            cellRightMerge.Phrase = new Phrase($"{(total+ ppnNominal).ToString("N", new CultureInfo("id-ID"))}", smaller_font);
            tableContent.AddCell(cellRightMerge);

            PdfPCell cellContent = new PdfPCell(tableContent); // dont remove
            tableContent.ExtendLastRow = false;
            tableContent.SpacingAfter  = 20f;
            document.Add(tableContent);

            #endregion

            #region Footer

            PdfPTable tableFooter = new PdfPTable(4);
            tableFooter.SetWidths(new float[] { 3.3f, 5.5f, 2f, 4.8f });

            //PdfPCell cellFooterContentLeft = new PdfPCell() { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT };
            //PdfPCell cellFooterContentRight = new PdfPCell() { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT };
            PdfPCell cellFooterContent = new PdfPCell()
            {
                Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT
            };



            cellFooterContent.Phrase = new Phrase("Ongkos Kirim", smaller_font);
            tableFooter.AddCell(cellFooterContent);
            cellFooterContent.Phrase = new Phrase(": " + viewModel.freightCostBy, smaller_font);
            tableFooter.AddCell(cellFooterContent);
            cellFooterContent.Phrase = new Phrase("Delivery", smaller_font);
            tableFooter.AddCell(cellFooterContent);
            cellFooterContent.Phrase = new Phrase(": " + (viewModel.deliveryDate.ToOffset(new TimeSpan(clientTimeZoneOffset, 0, 0)).ToString("dd MMMM yyyy", new CultureInfo("id-ID"))), smaller_font);
            tableFooter.AddCell(cellFooterContent);

            string duedays = "";
            if (Convert.ToInt32(viewModel.paymentDueDays) > 0)
            {
                duedays = viewModel.paymentDueDays + " hari setelah terima barang";
            }

            cellFooterContent.Phrase = new Phrase("Pembayaran", smaller_font);
            tableFooter.AddCell(cellFooterContent);
            cellFooterContent.Phrase = new Phrase(": " + viewModel.paymentMethod + "\n" + "  " + duedays, smaller_font);
            tableFooter.AddCell(cellFooterContent);

            cellFooterContent.Phrase = new Phrase("Lain-lain", smaller_font);
            tableFooter.AddCell(cellFooterContent);
            cellFooterContent.Phrase = new Phrase(": " + viewModel.remark, smaller_font);
            tableFooter.AddCell(cellFooterContent);

            PdfPCell cellFooter = new PdfPCell(tableFooter); // dont remove
            tableFooter.ExtendLastRow = false;
            tableContent.SpacingAfter = 20f;
            document.Add(tableFooter);

            #endregion


            #region TableSignature

            PdfPTable tableSignature = new PdfPTable(2);

            PdfPCell cellSignatureContent = new PdfPCell()
            {
                Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_CENTER
            };
            cellSignatureContent.Phrase = new Phrase("Pembeli\n\n\n\n\n\n\n(  " + viewModel.CreatedBy + "  )", bold_font);
            tableSignature.AddCell(cellSignatureContent);
            cellSignatureContent.Phrase = new Phrase("Menyetujui\n\n\n\n\n\n\n(  " + "Adi Nugroho" + "  )", bold_font);
            tableSignature.AddCell(cellSignatureContent);
            //cellSignatureContent.Phrase = new Phrase("Penjual\n\n\n\n\n\n\n(  " + viewModel.supplier.name + "  )", bold_font);
            //tableSignature.AddCell(cellSignatureContent);


            PdfPCell cellSignature = new PdfPCell(tableSignature); // dont remove
            tableSignature.ExtendLastRow = false;
            tableSignature.SpacingBefore = 20f;
            tableSignature.SpacingAfter  = 20f;
            document.Add(tableSignature);

            #endregion

            document.Close();
            byte[] byteInfo = stream.ToArray();
            stream.Write(byteInfo, 0, byteInfo.Length);
            stream.Position = 0;

            return(stream);
        }
Ejemplo n.º 25
0
        private void xuatThe_xuat_Click(object sender, EventArgs e)
        {
            if (xuatThe_ten != null)
            {
                try
                {
                    Document              The       = new Document(iTextSharp.text.PageSize.HALFLETTER);
                    PdfWriter             TheWriter = PdfWriter.GetInstance(The, new FileStream($@"{xuatThe_duongdan.Text + xuatThe_ten.Text}.pdf", FileMode.Create));
                    System.Drawing.Image  img1      = global::QLDG.Properties.Resources.rsz_npl;
                    System.Drawing.Image  img2      = global::QLDG.Properties.Resources._121616142_697353817797998_5539481938901508229_n;
                    iTextSharp.text.Image text_img1 = iTextSharp.text.Image.GetInstance(img1, System.Drawing.Imaging.ImageFormat.Png);
                    iTextSharp.text.Image Info_img2 = iTextSharp.text.Image.GetInstance(img2, System.Drawing.Imaging.ImageFormat.Png);
                    Info_img2.SetAbsolutePosition(The.PageSize.Width - 280f - 60f, The.PageSize.Height - 50f - 190f);
                    text_img1.SetAbsolutePosition(The.PageSize.Width - 280f - 60f, The.PageSize.Height - 30f - 75f);
                    // The.Add(text_img);
                    iTextSharp.text.Font f1        = FontFactory.GetFont(iTextSharp.text.Font.FontFamily.TIMES_ROMAN.ToString(), 20, iTextSharp.text.Font.BOLD, iTextSharp.text.BaseColor.BLUE);
                    string               exeFile   = (new System.Uri(Assembly.GetEntryAssembly().CodeBase)).AbsolutePath;
                    string               exeDir    = Path.GetDirectoryName(exeFile);
                    string               fullPath0 = Path.Combine(exeDir, @"VietFontsWeb1_ttf\vuTimesBold.ttf");
                    string               fullPath1 = Path.Combine(exeDir, @"VietFontsWeb1_ttf\vuTimes.ttf");
                    BaseFont             bf0       = BaseFont.CreateFont(fullPath0, BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
                    BaseFont             bf1       = BaseFont.CreateFont(fullPath1, BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
                    iTextSharp.text.Font f2        = new iTextSharp.text.Font(bf0, 15, iTextSharp.text.Font.ITALIC, iTextSharp.text.BaseColor.RED);
                    iTextSharp.text.Font f3        = new iTextSharp.text.Font(bf1, 10, iTextSharp.text.Font.NORMAL, iTextSharp.text.BaseColor.BLACK);
                    iTextSharp.text.Font f4        = new iTextSharp.text.Font(bf1, 8, iTextSharp.text.Font.ITALIC, iTextSharp.text.BaseColor.BLUE);

                    /*Paragraph p1 = new Paragraph("        LM_PROJECT.EC", f1);
                     * Paragraph p2 = new Paragraph($"                                        Mã số: {MS}", f3);
                     * Paragraph p3 = new Paragraph($"                                        Họ và tên: {Ten}", f3);
                     * Paragraph p4 = new Paragraph($"                                        Ngày sinh: {NgaySinh}", f3);
                     * Paragraph p5 = new Paragraph($"                                        Ngày lập thẻ: {NgayLapThe}", f3);
                     * Paragraph p6 = new Paragraph($"                                        Loai: {Loai}", f3);
                     * Paragraph Enter=new Paragraph("             ");
                     *
                     * p1.Alignment = Element.ALIGN_CENTER;
                     * p2.Alignment = Element.LISTITEM;
                     * p3.Alignment = Element.LISTITEM;
                     * p4.Alignment = Element.LISTITEM;
                     * p5.Alignment = Element.LISTITEM;
                     * p6.Alignment = Element.LISTITEM;
                     *
                     *
                     * The.Add(p1);
                     * The.Add(text_img1);
                     *
                     * The.Add(Info_img2);
                     * The.Add(Enter);
                     * The.Add(p2);
                     * The.Add(p3);
                     * The.Add(p4);
                     * The.Add(p5);
                     * The.Add(p6);
                     */

                    // iTextSharp.text.Font f = new iTextSharp.text.Font();
                    PdfPTable table = new PdfPTable(1);
                    table.DefaultCell.Padding       = 3;
                    table.DefaultCell.MinimumHeight = 20;
                    table.WidthPercentage           = 100;
                    table.HorizontalAlignment       = Element.ALIGN_CENTER;
                    table.DefaultCell.BorderWidth   = 1;
                    PdfPCell cellHoTen = new PdfPCell(new Phrase($"                                                      ooo000ooo", f3));
                    cellHoTen.BackgroundColor = new BaseColor(195, 195, 195);
                    Paragraph p1 = new Paragraph("             LM-PROJECT.EC\n", f1);
                    p1.Alignment = Element.ALIGN_CENTER;
                    Paragraph Enter = new Paragraph("             \n");
                    Paragraph p7    = new Paragraph($"                       THẺ ĐỘC GIẢ - {MS}\n", f2);
                    Paragraph p8    = new Paragraph($"                                         (Thẻ có giá trị sử dụng 180 ngày kể từ ngày lập thẻ)\n", f4);
                    p7.Alignment = Element.ALIGN_CENTER;
                    p8.Alignment = Element.ALIGN_CENTER;
                    table.AddCell(cellHoTen);
                    p1.Add(p7);
                    p1.Add(p8);
                    Paragraph p2 = new Paragraph($"\n\n                                                   Họ và tên: {Ten}\n\n"
                                                 + $"                                                   Loại độc giả: {Loai}\n\n"
                                                 + $"                                                   Ngày sinh: {NgaySinh}\n\n"
                                                 + $"                                                   Địa chỉ: {DiaChi}\n\n"
                                                 + $"                                                   Email: {Email}\n\n"
                                                 + $"                                                   Ngày lập thẻ : {NgayLapThe}\n\n"
                                                 + $"                                                   Người lập thẻ : {NgLap}\n\n", f3);
                    p1.Add(p2);
                    p1.PaddingTop = 10;
                    table.AddCell(p1);


                    The.Open();
                    //The.Add(p1);
                    The.Add(text_img1);
                    //The.Add(p7);
                    //The.Add(p8);
                    //The.Add(Enter);
                    The.Add(table);
                    The.Add(Info_img2);
                    The.Close();
                    TheWriter.Close();
                    MessageBox.Show("Thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                catch
                {
                    MessageBox.Show("Thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            else
            {
                MessageBox.Show("Thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 26
0
        private void criarPDF(string path)
        {
            Document doc = new Document(PageSize.A4);

            doc.SetMargins(40, 40, 40, 80);
            doc.AddCreationDate();

            PdfWriter writer = PdfWriter.GetInstance(doc, new FileStream(path, FileMode.Create));

            doc.Open();

            iTextSharp.text.Image img = iTextSharp.text.Image.GetInstance(@"C:\Users\GONIME\source\repos\Econobuy\Econobuy.Views\Repositório\Logo.png");
            img.ScaleAbsolute(50, 50);
            img.Alignment = Element.ALIGN_TOP;
            doc.Add(img);
            Paragraph titulo = new Paragraph();

            titulo.Font      = new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.TIMES_ROMAN, 40);
            titulo.Alignment = Element.ALIGN_CENTER;
            titulo.Add("\n\nRelatório Econobuy\n\n\n");
            doc.Add(titulo);
            Paragraph subtitulo = new Paragraph();

            subtitulo.Font      = new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.TIMES_ROMAN, 30);
            subtitulo.Alignment = Element.ALIGN_CENTER;
            if (content == 1 && type == 0)
            {
                subtitulo.Add("Relatório de produtos cadastrados\n\n\n\n\n");
            }
            else if (content == 1 && type == 1)
            {
                subtitulo.Add("Relatório de produtos Vendidos\n\n\n\n\n");
            }
            else if (content == 1 && type == 2)
            {
                subtitulo.Add("Relatório de produtos a serem entregues\n\n\n\n\n");
            }
            else if (content == 2 && type == 0)
            {
                subtitulo.Add("Relatório de pedidos em aguardo\n\n\n\n\n");
            }
            else if (content == 2 && type == 1)
            {
                subtitulo.Add("Relatório de pedidos entregues\n\n\n\n\n");
            }
            else if (content == 2 && type == 2)
            {
                subtitulo.Add("Relatório de todos os pedidos\n\n\n\n\n");
            }
            else if (content == 3 && type == 0)
            {
                subtitulo.Add("Relatório de clientes aguardando aprovação\n\n\n\n\n");
            }
            else if (content == 3 && type == 1)
            {
                subtitulo.Add("Relatório de clientes com pedido entregue\n\n\n\n\n");
            }
            else if (content == 3 && type == 0)
            {
                subtitulo.Add("Relatório de todos os clientes\n\n\n\n\n");
            }
            doc.Add(subtitulo);
            PdfPTable table = new PdfPTable(dt.Columns.Count);

            table.WidthPercentage = 100;
            PdfPCell cell = new PdfPCell(new Phrase("Products"));

            iTextSharp.text.Font fnt = new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.TIMES_ROMAN, 8);
            cell.Colspan = dt.Columns.Count;

            foreach (DataColumn c in dt.Columns)
            {
                table.AddCell(new Phrase(c.ColumnName, fnt));
            }

            foreach (DataRow r in dt.Rows)
            {
                for (int i = 0; i <= cell.Colspan - 1; i++)
                {
                    table.AddCell(new Phrase(r[i].ToString(), fnt));
                }
            }
            doc.Add(table); PrintDialog dialogPrint = new PrintDialog();
            doc.Close();
        }
Ejemplo n.º 27
0
        protected void btnExportar_Click(object sender, EventArgs e)
        {
            PdfPTable pdfTable = new PdfPTable(gvPlanes.HeaderRow.Cells.Count);

            foreach (TableCell headerCell in gvPlanes.HeaderRow.Cells)
            {
                PdfPCell pdfCell = new PdfPCell(new Phrase(headerCell.Text));
                pdfTable.AddCell(pdfCell);
            }
            foreach (GridViewRow gridViewRow in gvPlanes.Rows)
            {
                foreach (TableCell tableCell in gridViewRow.Cells)
                {
                    PdfPCell pdfCell = new PdfPCell(new Phrase(tableCell.Text));
                    pdfTable.AddCell(pdfCell);
                }
            }
            Document pdfDoc = new Document(PageSize.A4, 20f, 20f, 20f, 20f);

            PdfWriter.GetInstance(pdfDoc, Response.OutputStream);

            pdfDoc.Open();
            //Inserto titulo
            Paragraph paragraph = new Paragraph(); //se crea el parrafo
            Paragraph separador = new Paragraph();

            separador.Add("\n\n");

            paragraph.Font      = new iTextSharp.text.Font(FontFactory.GetFont("Arial", 25, BaseColor.BLACK));
            paragraph.Alignment = Element.ALIGN_CENTER;
            paragraph.Add("Reporte de Planes");

            //Inserto titulo de reporte
            paragraph.Add("\n\n");

            paragraph.Font      = new iTextSharp.text.Font(FontFactory.GetFont("Arial", 10, BaseColor.BLACK));
            paragraph.Alignment = Element.ALIGN_CENTER;
            paragraph.Add(this.ListadoTittleLabel.Text.ToString());


            // Creamos la imagen y le ajustamos el tamaño
            iTextSharp.text.Image imagen = iTextSharp.text.Image.GetInstance(@"C:\Users\Nicolás\Documents\UtnRosario.png");
            imagen.BorderWidth = 0;
            imagen.Alignment   = Element.ALIGN_RIGHT;
            float percentage = 0.0f;

            percentage = 150 / imagen.Width;
            imagen.ScalePercent(percentage * 100);

            // Insertamos la imagen en el documento
            pdfDoc.Add(imagen);
            pdfDoc.Add(separador);
            pdfDoc.Add(paragraph);
            pdfDoc.Add(separador);
            pdfDoc.Add(pdfTable);
            pdfDoc.Close();

            Response.ContentType = "application/pdf";
            Response.AppendHeader("content-disposition", "attachment;filename=ReportePlan.pdf");
            Response.Write(pdfDoc);
            Response.Flush();
            Response.End();
        }
Ejemplo n.º 28
0
        public MemoryStream GeneratePDF(AsInfoViewModel asInfoViewModel)
        {
            System.IO.MemoryStream fs = new MemoryStream();
            Document document         = new Document();

            document.SetPageSize(iTextSharp.text.PageSize.A4);
            PdfWriter writer = PdfWriter.GetInstance(document, fs);

            document.Open();

            var rootPath = _hostingEnvironment.WebRootPath;
            //Korean Font
            var gulim = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Fonts), "ARIALUNI.TTF");

            //Report Header
            iTextSharp.text.pdf.BaseFont bfntHead = iTextSharp.text.pdf.BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
            //iTextSharp.text.Font fntHead = new iTextSharp.text.Font(bfntHead, 16, 1, iTextSharp.text.BaseColor.GRAY);
            BaseFont  fntHead    = BaseFont.CreateFont(gulim, BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED);
            Font      f          = new Font(fntHead, 12, Font.NORMAL);
            Paragraph prgHeading = new Paragraph();

            prgHeading.Alignment = Element.ALIGN_CENTER;
            prgHeading.Add(new Chunk("A/S 신청안내", f));
            document.Add(prgHeading);


            //Add a line seperation
            Paragraph p = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 100.0F, iTextSharp.text.BaseColor.BLACK, Element.ALIGN_LEFT, 1)));

            document.Add(p);

            //Add line break
            document.Add(new Chunk("\n", f));

            //Write the table
            PdfPTable table = new PdfPTable(2);

            ////Table header
            //BaseFont btnColumnHeader = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
            //Font fntColumnHeader = new Font(btnColumnHeader, 10, 1, iTextSharp.text.BaseColor.WHITE);
            //for (int i = 0; i < dtblTable.Columns.Count; i++)
            //{
            //    PdfPCell cell = new PdfPCell();
            //    cell.BackgroundColor = Color.GRAY;
            //    cell.AddElement(new Chunk(dtblTable.Columns[i].ColumnName.ToUpper(), fntColumnHeader));
            //    table.AddCell(cell);
            //}
            //table Data

            table.AddCell(new Phrase("업체명", f));
            table.AddCell(new Phrase(asInfoViewModel.CompanyName, f));

            table.AddCell(new Phrase("담당자", f));
            table.AddCell(new Phrase(asInfoViewModel.Manager, f));

            table.AddCell(new Phrase("연락처", f));
            table.AddCell(new Phrase(asInfoViewModel.Contact, f));

            table.AddCell(new Phrase("FAX", f));
            table.AddCell(new Phrase(asInfoViewModel.Fax, f));

            table.AddCell(new Phrase("휴대전화", f));
            table.AddCell(new Phrase(asInfoViewModel.CellPhone, f));

            table.AddCell(new Phrase("이메일", f));
            table.AddCell(new Phrase(asInfoViewModel.Email, f));

            table.AddCell(new Phrase("제품명", f));
            table.AddCell(new Phrase(asInfoViewModel.ProductName, f));

            table.AddCell(new Phrase("Serial No.", f));
            table.AddCell(new Phrase(asInfoViewModel.SerialNumber, f));

            table.AddCell(new Phrase("증상", f));
            table.AddCell(new Phrase(asInfoViewModel.Symptom, f));

            table.AddCell(new Phrase("내용", f));
            table.AddCell(new Phrase(asInfoViewModel.Content, f));

            document.Add(table);
            document.Close();
            //writer.Close();
            //fs.Close();

            return(fs);
        }
        private void btn_excluirHorario_Click(object sender, EventArgs e)
        {
            string     nomeArquino = Globais.caminho + @"\turmas.pdf";
            FileStream arquivoPDF  = new FileStream(nomeArquino, FileMode.Create);
            Document   doc         = new Document(PageSize.A4);
            PdfWriter  escritorPDF = PdfWriter.GetInstance(doc, arquivoPDF);


            //Inserindo uma imagem
            iTextSharp.text.Image logo = iTextSharp.text.Image.GetInstance(Globais.caminho + @"\logo1.PNG");
            logo.ScaleToFit(112, 96);

            /*
             * um desses
             * logo.Alignment = Element.ALIGN_LEFT;
             * ou
             */
            logo.SetAbsolutePosition(35, 720f); // X , -Y(com 0 ele fica na base da pagina)

            //Inserindo uma imagem*/


            string dados = "";

            Paragraph paragrafo1 = new Paragraph(dados, new iTextSharp.text.Font(iTextSharp.text.Font.NORMAL, 25, (int)System.Drawing.FontStyle.Bold));

            paragrafo1.Alignment = Element.ALIGN_CENTER;
            paragrafo1.Add("Estudo PDF\n");
            paragrafo1.Font = new iTextSharp.text.Font(iTextSharp.text.Font.NORMAL, 14, (int)System.Drawing.FontStyle.Italic);
            paragrafo1.Add("Curso em C#\n");
            string texto = "\nRelatório de turmas";

            paragrafo1.Font = new iTextSharp.text.Font(iTextSharp.text.Font.NORMAL, 20, (int)System.Drawing.FontStyle.Bold);
            paragrafo1.Add(texto + "\n\n");


            Paragraph paragrafo2 = new Paragraph(dados, new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 25, (int)System.Drawing.FontStyle.Bold));

            paragrafo2.Alignment = Element.ALIGN_LEFT;
            paragrafo2.Add("\n\nParagrago 2\n");
            string texto2 = "esse é o texto do segundo aparagrafo\n Loollllaaaaaaaaaaaaaaaaaaaaaaaaaa.\n\n";

            paragrafo2.Font = new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 12, (int)System.Drawing.FontStyle.Italic);
            paragrafo2.Add(texto2 + "\n");



            //Inserindo Tabela
            PdfPTable tabela = new PdfPTable(3);//3Colunas

            tabela.DefaultCell.FixedHeight = 20;

            PdfPCell celula1 = new PdfPCell();

            celula1.Colspan = 3; //Linha 1 mescleda
            // celula1.AddElement(logo);
            celula1.HorizontalAlignment = Element.ALIGN_CENTER;
            celula1.VerticalAlignment   = Element.ALIGN_CENTER;
            celula1.HorizontalAlignment = Element.ALIGN_CENTER;

            tabela.AddCell(celula1);



            tabela.AddCell("ID Turma");
            tabela.AddCell("Turma");
            tabela.AddCell("Horário");

            string vquery = @"SELECT tbt.N_IDTURMA as 'ID' ,tbt.T_DSCTURMA as 'Turma',tbh.T_DSCHORARIO  as 'Horário da turma'
                FROM tb_turmas as tbt
                INNER JOIN
                tb_horarios as tbh on tbh.N_IDHORARIO = tbt.N_IDHORARIO";

            DataTable dtTurma = Banco.dql(vquery);

            for (int i = 0; i < dtTurma.Rows.Count; i++)
            {
                tabela.AddCell(dtTurma.Rows[i].Field <Int64>("ID").ToString());
                tabela.AddCell(dtTurma.Rows[i].Field <string>("Turma"));
                tabela.AddCell(dtTurma.Rows[i].Field <string>("Horário da turma"));
            }



            PdfPCell celula2 = new PdfPCell(new Phrase("Tabela 2 AQUI!"));

            celula2.Colspan             = 3; //Linha 1 mescla
            celula2.FixedHeight         = 40;
            celula2.Rotation            = 0;
            celula2.HorizontalAlignment = Element.ALIGN_CENTER;
            celula2.VerticalAlignment   = Element.ALIGN_MIDDLE;
            // tabela.AddCell(celula2);


            doc.Open();
            doc.Add(logo);
            doc.Add(paragrafo1);
            doc.Add(tabela);
            // doc.Add(paragrafo2);
            doc.Close();

            DialogResult res = MessageBox.Show("Desejsa abrir o Relatório", "Relatório", MessageBoxButtons.YesNo);

            if (res == DialogResult.Yes)
            {
                System.Diagnostics.Process.Start(Globais.caminho + @"\turmas.pdf");
            }
        }
Ejemplo n.º 30
0
        static Document CreateDocument(Result result)
        {
            // Create a new MigraDoc document
            Document document = new Document();

            #region Introduction Section

            Section introductionSection = document.AddSection();

            // Page Title
            Paragraph titleParagraph = introductionSection.AddParagraph();
            titleParagraph.Format.Alignment = ParagraphAlignment.Center;
            titleParagraph.AddFormattedText(Properties.Resources.ProductDescription, StyleLibrary.BlackTitleFont);
            titleParagraph.AddFormattedText(" (" + Properties.Resources.ProductName + ")", StyleLibrary.BlackTitleFont);

            // Introductory paragraph Title
            Paragraph introParagraphTitle = introductionSection.AddParagraph();
            introParagraphTitle.AddLineBreak();
            introParagraphTitle.AddLineBreak();
            introParagraphTitle.AddFormattedText("Introduction", StyleLibrary.HeadingFont);

            // Introductory paragraph
            Paragraph introParagraph = introductionSection.AddParagraph();
            introParagraph.AddLineBreak();
            introParagraph.AddFormattedText("VIQET is an easy to use no-reference photo quality evaluation tool. In order to perform photo quality evaluation, VIQET requires a set of photos " +
                                            "from a test device. It computes an overall image MOS score for a device based on the individual computed photo qualities of each image in the set. " +
                                            "The overall MOS is computed based on a number of features extracted from each image. The mapping from extracted features to MOS is based on a " +
                                            "psychophysics study that was conducted to create a large dataset of photos and associated subjective mean opinion ratings. The study was used to learn " +
                                            "a mapping from features to scores. The predicted quality score falls in the range of 1 to 5, where 1 corresponds to a low quality score and 5 corresponds to excellent quality", StyleLibrary.TextFont);

            Paragraph overallParagraphTitle = introductionSection.AddParagraph();
            overallParagraphTitle.AddLineBreak();
            overallParagraphTitle.AddLineBreak();
            overallParagraphTitle.AddFormattedText("Test Results", StyleLibrary.HeadingFont);

            // Overall Scores
            Paragraph overallScoreTitle = introductionSection.AddParagraph();
            overallScoreTitle.AddLineBreak();
            overallScoreTitle.AddFormattedText("Device Name: " + result.Name, StyleLibrary.TextFont);
            overallScoreTitle.AddLineBreak();
            overallScoreTitle.AddFormattedText("Total number of photos: " + result.PhotoList.Count, StyleLibrary.TextFont);
            overallScoreTitle.AddLineBreak();
            overallScoreTitle.AddFormattedText("Tool Version: " + Properties.Resources.VersionName + " " + Constants.Version, StyleLibrary.TextFont);

            FeatureDetail overallMOSDetail = result.GetOverallMOS();
            string        overallMOS       = double.IsNaN(overallMOSDetail.Value) ? "N/A" : overallMOSDetail.Value.ToString("0.0") + " +/-" + overallMOSDetail.StandardError.ToString("0.0");
            overallScoreTitle.AddLineBreak();
            overallScoreTitle.AddLineBreak();
            overallScoreTitle.AddFormattedText("Overall Score: " + overallMOS, StyleLibrary.HeadingFont);

            #endregion

            #region Summary for Categories

            // Categories Summary Section
            Section categoriesSummarySection = document.AddSection();

            // Introductory paragraph
            Paragraph categoriesSummaryParagraphTitle = categoriesSummarySection.AddParagraph();
            categoriesSummaryParagraphTitle.AddFormattedText("Photo Category Results", StyleLibrary.HeadingFont);


            foreach (Category outputCategory in result.outputCategoryList)
            {
                Paragraph categoriesSummaryParagraph = categoriesSummarySection.AddParagraph();
                categoriesSummaryParagraph.AddLineBreak();
                categoriesSummaryParagraph.AddLineBreak();
                categoriesSummaryParagraph.AddFormattedText("Category Name: " + outputCategory.Name, StyleLibrary.TextFontBold);
                categoriesSummaryParagraph.AddLineBreak();

                foreach (FeatureDetail featureDetail in outputCategory.FeatureDetails)
                {
                    if (featureDetail.DisplayPreference == Constants.DisplayPreference.RESULT_PAGE || featureDetail.DisplayPreference == Constants.DisplayPreference.RESULT_AND_DETAIL_PAGE)
                    {
                        categoriesSummaryParagraph.AddLineBreak();
                        if (outputCategory.MOSValue.Equals(Properties.Resources.NA))
                        {
                            categoriesSummaryParagraph.AddFormattedText(featureDetail.ParameterName + ": " + Properties.Resources.NA, StyleLibrary.TextFont);
                        }
                        else
                        {
                            categoriesSummaryParagraph.AddFormattedText(featureDetail.ParameterName + ": " + featureDetail.Value.ToString("0.00") + " +/- " + featureDetail.StandardError.ToString("0.00"), StyleLibrary.TextFont);
                        }
                    }
                }
            }

            #endregion


            #region Photo Details Section

            foreach (Category category in result.outputCategoryList)
            {
                bool firstLine = true;

                foreach (Photo photo in category.PhotoList)
                {
                    // Category Details Section
                    Section categoryDetailsSection = document.AddSection();

                    if (firstLine)
                    {
                        // Introductory paragraph
                        Paragraph categoryDetailsParagraphTitle = categoryDetailsSection.AddParagraph();
                        categoryDetailsParagraphTitle.AddFormattedText("Photos in  " + category.Name + " Category (" + category.PhotoList.Count + " photos)", StyleLibrary.HeadingFont);

                        firstLine = false;
                    }

                    // Introductory paragraph
                    Paragraph paragraphTitle = categoryDetailsSection.AddParagraph();
                    paragraphTitle.AddLineBreak();
                    paragraphTitle.AddFormattedText("Details for " + photo.Filename, StyleLibrary.TextFontBold);
                    paragraphTitle.AddLineBreak();
                    paragraphTitle.AddLineBreak();

                    //Add the source photo
                    Image sourceImage = new Image(photo.SourceFilePath);
                    sourceImage.Height = 200;
                    sourceImage.Width  = 400;

                    Paragraph sourceImageParagraph = categoryDetailsSection.AddParagraph();
                    sourceImageParagraph.Format.Alignment = ParagraphAlignment.Center;
                    sourceImageParagraph.Add(sourceImage);
                    sourceImageParagraph.AddLineBreak();
                    sourceImageParagraph.AddFormattedText("Source Photo", StyleLibrary.TextFont);
                    sourceImageParagraph.AddLineBreak();
                    sourceImageParagraph.AddLineBreak();

                    //Table with values for this photo
                    Table photoDetailsTable = categoryDetailsSection.AddTable();

                    Column photoParameterColumn = photoDetailsTable.AddColumn(Unit.FromCentimeter(6));
                    photoParameterColumn.Format.Alignment = ParagraphAlignment.Left;

                    Column photoValueColumn = photoDetailsTable.AddColumn(Unit.FromCentimeter(3));
                    photoValueColumn.Format.Alignment = ParagraphAlignment.Right;

                    //Add Header Row
                    Row photoHeaderRow = photoDetailsTable.AddRow();
                    photoHeaderRow.Cells[0].AddParagraph().AddFormattedText("Parameter", StyleLibrary.TextFontBold);
                    photoHeaderRow.Cells[1].AddParagraph().AddFormattedText("Value", StyleLibrary.TextFontBold);

                    //Add the details
                    foreach (PhotoDetail photoDetail in photo.PhotoDetails)
                    {
                        if (photoDetail.DisplayPreference == Constants.DisplayPreference.DETAIL_PAGE || photoDetail.DisplayPreference == Constants.DisplayPreference.RESULT_AND_DETAIL_PAGE)
                        {
                            Row detailRow = photoDetailsTable.AddRow();
                            detailRow.Cells[0].AddParagraph().AddFormattedText(photoDetail.ParameterName, StyleLibrary.TextFont);
                            detailRow.Cells[1].AddParagraph().AddFormattedText(photoDetail.Value.ToString("0.00"), StyleLibrary.TextFont);
                        }
                    }

                    //Add the visualization images
                    Section visualizationSection = document.AddSection();
                    foreach (VisualizationImage visualizationImage in photo.VisualizationImages)
                    {
                        Image image = new Image(visualizationImage.FilePath);
                        image.Height = 200;
                        image.Width  = 400;

                        Paragraph visualizationImageParagraph = visualizationSection.AddParagraph();
                        visualizationImageParagraph.AddLineBreak();
                        visualizationImageParagraph.Format.Alignment = ParagraphAlignment.Center;
                        visualizationImageParagraph.Add(image);
                        visualizationImageParagraph.AddLineBreak();
                        visualizationImageParagraph.AddFormattedText(visualizationImage.Visualization, StyleLibrary.TextFont);
                    }
                }
            }

            #endregion

            return(document);
        }
Ejemplo n.º 31
0
        /**
         * Adds currentContent list to a paragraph element. If addNewLines is true a
         * Paragraph object is returned, else a NoNewLineParagraph object is
         * returned.
         *
         * @param currentContent IList<IElement> of the current elements to be added.
         * @param addNewLines bool to declare which paragraph element should be
         *            returned, true if new line should be added or not.
         * @param applyCSS true if CSS should be applied on the paragraph
         * @param tag the relevant tag
         * @return a List with paragraphs
         */

        public virtual IList <IElement> CurrentContentToParagraph(IList <IElement> currentContent,
                                                                  bool addNewLines, bool applyCSS, Tag tag,
                                                                  IWorkerContext ctx)
        {
            try {
                int direction         = GetRunDirection(tag);
                IList <IElement> list = new List <IElement>();
                if (currentContent.Count > 0)
                {
                    if (addNewLines)
                    {
                        Paragraph p = CreateParagraph();
                        p.MultipliedLeading = 1.2f;
                        foreach (IElement e in currentContent)
                        {
                            if (e is LineSeparator)
                            {
                                try {
                                    HtmlPipelineContext htmlPipelineContext = GetHtmlPipelineContext(ctx);
                                    Chunk newLine = (Chunk)GetCssAppliers().Apply(new Chunk(Chunk.NEWLINE), tag, htmlPipelineContext);
                                    p.Add(newLine);
                                }
                                catch (NoCustomContextException exc) {
                                    throw new RuntimeWorkerException(
                                              LocaleMessages.GetInstance().GetMessage(LocaleMessages.NO_CUSTOM_CONTEXT), exc);
                                }
                            }
                            p.Add(e);
                        }
                        if (p.Trim())
                        {
                            if (applyCSS)
                            {
                                p = (Paragraph)GetCssAppliers().Apply(p, tag, GetHtmlPipelineContext(ctx));
                            }
                            if (direction.Equals(PdfWriter.RUN_DIRECTION_RTL))
                            {
                                DoRtlIndentCorrections(p);
                                InvertTextAlignForParagraph(p);
                            }
                            list.Add(p);
                        }
                    }
                    else
                    {
                        NoNewLineParagraph p = new NoNewLineParagraph(float.NaN);
                        p.MultipliedLeading = 1.2f;
                        foreach (IElement e in currentContent)
                        {
                            UpdateParagraphFontIfNeeded(p, e);
                            p.Add(e);
                        }
                        p = (NoNewLineParagraph)GetCssAppliers().Apply(p, tag, GetHtmlPipelineContext(ctx));
                        if (direction.Equals(PdfWriter.RUN_DIRECTION_RTL))
                        {
                            DoRtlIndentCorrections(p);
                            InvertTextAlignForParagraph(p);
                        }
                        list.Add(p);
                    }
                }
                return(list);
            }
            catch (NoCustomContextException e) {
                throw new RuntimeWorkerException(
                          LocaleMessages.GetInstance().GetMessage(LocaleMessages.NO_CUSTOM_CONTEXT), e);
            }
        }
Ejemplo n.º 32
0
        private void bgworker_DoWork(object sender, DoWorkEventArgs e)
        {
            String    query = "", empid = "", date_from = "", date_to = "", pay_code = "", table = "hr_other_earnings_files", filename = "", code = "", col = "", val = "", date_in = "";
            DataTable pay_period     = null;
            Double    total_earnings = 0.00;

            query = "SELECT empid, firstname, lastname FROM rssys.hr_employee";
            cbo_employee.Invoke(new Action(() => {
                if (cbo_employee.SelectedIndex != -1)
                {
                    empid  = cbo_employee.SelectedValue.ToString();
                    query += " WHERE empid='" + empid + "'";
                }
            }));

            query += " ORDER BY empid ASC";

            DataTable employees = db.QueryBySQLCode(query);

            cbo_payollperiod.Invoke(new Action(() => {
                pay_code = cbo_payollperiod.SelectedValue.ToString();
            }));

            pay_period = get_date(pay_code);

            if (pay_period.Rows.Count > 0)
            {
                date_from = gm.toDateString(pay_period.Rows[0]["date_from"].ToString(), "yyyy-MM-dd");
                date_to   = gm.toDateString(pay_period.Rows[0]["date_to"].ToString(), "yyyy-MM-dd");
            }

            filename  = RandomString(5) + "_" + DateTime.Now.ToString("yyyy-MM-dd");
            filename += ".pdf";


            //System.IO.FileStream fs = new FileStream("\\\\RIGHTAPPS\\RightApps\\Eastland\\payroll_reports\\other_earnings\\" + filename, FileMode.Create);
            System.IO.FileStream fs = new FileStream(fileloc_dtr + "\\ViewController\\RPT\\Payroll\\other_earnings\\" + filename, FileMode.Create);

            Document document = new Document(PageSize.LEGAL, 25, 25, 30, 30);

            PdfWriter.GetInstance(document, fs);
            document.Open();

            BaseFont bf = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);

            iTextSharp.text.Font font = new iTextSharp.text.Font(bf, 9, iTextSharp.text.Font.NORMAL);

            Paragraph paragraph = new Paragraph();

            paragraph.Alignment = Element.ALIGN_CENTER;
            paragraph.Font      = FontFactory.GetFont("Arial", 12);
            paragraph.SetLeading(1, 1);
            paragraph.Add("OTHER EARNINGS/INCOME SUMMARY");



            Phrase line_break = new Phrase("\n");

            document.Add(paragraph);
            document.Add(line_break);

            Paragraph paragraph_2 = new Paragraph();

            paragraph_2.Alignment = Element.ALIGN_CENTER;
            paragraph_2.Font      = FontFactory.GetFont("Arial", 12);
            paragraph_2.SetLeading(1, 1);
            paragraph_2.Add("For the payroll period " + date_from + " to " + date_to);


            Phrase line_break_2 = new Phrase("\n");

            document.Add(paragraph_2);
            document.Add(line_break_2);



            PdfPTable t = new PdfPTable(1);

            float[] widths = new float[] { 100 };
            t.WidthPercentage = 100;
            t.SetWidths(widths);

            PdfPTable dis_earnings = new PdfPTable(2);

            float[] _w2 = new float[] { 50, 50 };
            dis_earnings.SetWidths(_w2);

            foreach (DataRow _employees in employees.Rows)
            {
                total_earnings = 0.00;
                String fname = _employees["firstname"].ToString();
                String lname = _employees["lastname"].ToString();
                String empno = _employees["empid"].ToString();
                try
                {
                    DataTable has_earnings = db.QueryBySQLCode("SELECT emp_no FROM rssys.hr_earning_entry WHERE emp_no = '" + empno + "'");
                    if (has_earnings != null && has_earnings.Rows.Count > 0)
                    {
                        dis_earnings.AddCell(new PdfPCell(new Paragraph(fname + " " + lname))
                        {
                            Colspan = 2, Border = 2
                        });

                        DataTable hoe = db.QueryBySQLCode("SELECT DISTINCT(oe.code) as code,oe.description  FROM rssys.hr_earning_entry ee  LEFT JOIN rssys.hr_other_earnings oe  ON oe.code = ee.earning_code WHERE ee.emp_no = '" + empno + "'");

                        foreach (DataRow _hoe in hoe.Rows)
                        {
                            dis_earnings.AddCell(new PdfPCell(new Paragraph(_hoe["description"].ToString()))
                            {
                                PaddingLeft = 30f, Colspan = 2, Border = 0
                            });
                            DataTable hee = db.QueryBySQLCode("SELECT * FROM rssys.hr_earning_entry WHERE earning_code = '" + _hoe["code"].ToString() + "' AND payroll_period = '" + pay_code + "' AND emp_no = '" + empno + "'");
                            foreach (DataRow _hee in hee.Rows)
                            {
                                dis_earnings.AddCell(new PdfPCell(new Paragraph(_hee["amount"].ToString()))
                                {
                                    PaddingLeft = 40f, Colspan = 2, Border = 0
                                });
                                total_earnings += Convert.ToDouble(_hee["amount"].ToString());
                            }
                        }
                        dis_earnings.AddCell(new PdfPCell(new Paragraph("Total Earnings : " + total_earnings.ToString("0.00")))
                        {
                            Colspan = 2, Border = 0
                        });
                    }
                }catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }

            document.Add(dis_earnings);
            document.Add(t);
            document.Close();

            code = db.get_pk("earning_id");
            col  = "earning_id,filename,date_added";
            val  = "'" + code + "','" + filename + "','" + DateTime.Now.ToShortDateString() + "'";

            if (db.InsertOnTable(table, col, val))
            {
                db.set_pkm99("earning_id", db.get_nextincrementlimitchar(code, 8)); //changes from 'hr_empid'
                MessageBox.Show("New Other Earnings Summary added.");
            }
            else
            {
                MessageBox.Show("Failed on saving.");
            }
            pic_loading.Invoke(new Action(() => {
                pic_loading.Visible = false;
                btn_submit.Enabled  = true;
            }));

            display_list();
        }
Ejemplo n.º 33
0
        public void imprimir(List <Cliente> lista)
        {
            Document  doc    = new Document();
            PdfWriter writer = PdfWriter.GetInstance(doc, new FileStream(Application.StartupPath + @"\ListadoDeClientes.pdf", FileMode.Create));

            doc.Open();

            Font _standardFont  = new Font(Font.FontFamily.HELVETICA, 10, iTextSharp.text.Font.NORMAL, BaseColor.BLACK);
            Font _standardFont2 = new Font(Font.FontFamily.HELVETICA, 10, iTextSharp.text.Font.NORMAL, BaseColor.WHITE);

            Paragraph salto = new Paragraph("\n");

            doc.Add(salto);

            PdfPTable tableHeader = new PdfPTable(2);

            tableHeader.WidthPercentage = 100;

            PdfPCell cell = new PdfPCell(new Phrase("Bigons hnos"));

            cell.Border              = 0;
            cell.BorderWidthBottom   = 0.5f;
            cell.HorizontalAlignment = 0;

            PdfPCell cell1 = new PdfPCell(new Phrase(DateTime.Now.ToString()));

            cell1.Border              = 0;
            cell1.BorderWidthBottom   = 0.5f;
            cell1.HorizontalAlignment = 2;

            tableHeader.AddCell(cell);
            tableHeader.AddCell(cell1);
            doc.Add(tableHeader);

            doc.Add(salto);
            doc.Add(salto);

            Paragraph title = new Paragraph();

            title.Font = FontFactory.GetFont(FontFactory.TIMES, 24f);
            title.Add("Listado de clientes");
            title.Alignment = 1;
            doc.Add(title);

            PdfPTable tblPrueba = new PdfPTable(4);

            tblPrueba.WidthPercentage = 90;

            PdfPCell clDniHeader = new PdfPCell(new Phrase("Dni", _standardFont2));

            clDniHeader.BorderWidth       = 0;
            clDniHeader.BorderWidthBottom = 0.75f;
            clDniHeader.BackgroundColor   = BaseColor.GRAY;

            PdfPCell clApellidoHeader = new PdfPCell(new Phrase("Apellido", _standardFont2));

            clApellidoHeader.BorderWidth       = 0;
            clApellidoHeader.BorderWidthBottom = 0.75f;
            clApellidoHeader.BackgroundColor   = BaseColor.GRAY;

            PdfPCell clNombreHeader = new PdfPCell(new Phrase("Nombre", _standardFont2));

            clNombreHeader.BorderWidth       = 0;
            clNombreHeader.BorderWidthBottom = 0.75f;
            clNombreHeader.BackgroundColor   = BaseColor.GRAY;

            PdfPCell clTelefonoHeader = new PdfPCell(new Phrase("Telefono", _standardFont2));

            clTelefonoHeader.BorderWidth       = 0;
            clTelefonoHeader.BorderWidthBottom = 0.75f;
            clTelefonoHeader.BackgroundColor   = BaseColor.GRAY;

            // Añadimos las celdas a la tabla
            tblPrueba.AddCell(clDniHeader);
            tblPrueba.AddCell(clApellidoHeader);
            tblPrueba.AddCell(clNombreHeader);
            tblPrueba.AddCell(clTelefonoHeader);

            foreach (Cliente unCliente in lista)
            {
                PdfPCell clDni = new PdfPCell(new Phrase(unCliente.Dni, _standardFont));
                clDni.BorderWidth = 0;

                PdfPCell clApellido = new PdfPCell(new Phrase(unCliente.Apellido, _standardFont));
                clApellido.BorderWidth = 0;

                PdfPCell clNombre = new PdfPCell(new Phrase(unCliente.Nombre, _standardFont));
                clNombre.BorderWidth = 0;

                PdfPCell clTel = new PdfPCell(new Phrase(unCliente.Telefonos[0].Numero, _standardFont));
                clTel.BorderWidth = 0;

                // Añadimos las celdas a la tabla
                tblPrueba.AddCell(clDni);
                tblPrueba.AddCell(clApellido);
                tblPrueba.AddCell(clNombre);
                tblPrueba.AddCell(clTel);
            }


            doc.Add(new Paragraph("\n"));

            doc.Add(tblPrueba);

            doc.Close();
            writer.Close();

            System.Diagnostics.Process.Start(Application.StartupPath + @"\ListadoDeClientes.pdf");
        }
Ejemplo n.º 34
0
        private void ExportDataTableToPdf(DataTable dtbl, String pdfPath, string header)
        {
            try
            {
                FileStream fs       = new FileStream(pdfPath, FileMode.Create, FileAccess.Write, FileShare.None);
                Document   document = new Document();
                document.SetPageSize(PageSize.A4);
                PdfWriter writer = PdfWriter.GetInstance(document, fs);
                document.Open();

                //Report Header
                BaseFont  bfntHead   = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
                Font      fntHead    = new Font(bfntHead, 16, 1, iTextSharp.text.BaseColor.GRAY);
                Paragraph prgHeading = new Paragraph();
                prgHeading.Alignment = Element.ALIGN_CENTER;
                prgHeading.Add(new Chunk(header.ToUpper(), fntHead));
                document.Add(prgHeading);

                //Author
                Paragraph prgAuthor = new Paragraph();
                BaseFont  btnAuthor = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
                Font      fntAuthor = new Font(btnAuthor, 8, 2, BaseColor.GRAY);
                prgAuthor.Alignment = Element.ALIGN_LEFT;
                prgAuthor.Add(new Chunk("Fecha de reporte: " + DateTime.Now.ToShortDateString(), fntAuthor));
                document.Add(prgAuthor);

                //Img
                iTextSharp.text.Image logo = iTextSharp.text.Image.GetInstance(@"C:\Users\orell\Desktop\Actividades 1er Semestre 2018\Portafolio\Portafolio web\PortafolioNet\PortafolioNet.View\images\Logo.png");
                logo.ScaleAbsoluteHeight(50);
                logo.ScaleAbsoluteWidth(180);
                logo.Alignment = Element.ALIGN_RIGHT;
                document.Add(logo);

                //Separador de Linea.
                Paragraph p = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 100.0F, BaseColor.BLACK, Element.ALIGN_LEFT, 0.0F)));
                document.Add(p);

                document.Add(new Chunk("\n", fntHead));

                //EScribir la tabla:
                PdfPTable table = new PdfPTable(dtbl.Columns.Count);
                //Header de tabla.
                BaseFont btnColumnHeader = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
                Font     fntColumnHeader = new Font(btnColumnHeader, 10, 1, BaseColor.WHITE);
                for (int i = 0; i < dtbl.Columns.Count; i++)
                {
                    PdfPCell cell = new PdfPCell();
                    cell.BackgroundColor = BaseColor.GRAY;
                    cell.AddElement(new Chunk(dtbl.Columns[i].ColumnName.ToUpper(), fntColumnHeader));
                    table.AddCell(cell);
                }
                //Datos de table.
                for (int i = 0; i < dtbl.Rows.Count; i++)
                {
                    for (int j = 0; j < dtbl.Columns.Count; j++)
                    {
                        table.AddCell(dtbl.Rows[i][j].ToString());
                    }
                }
                document.Add(table);
                document.Close();
                writer.Close();
                fs.Close();
            }
            catch (Exception e)
            {
                string val = e.Message;
            }
        }
Ejemplo n.º 35
0
    public void Report1ExportToPdf(DataTable dataTable)
    {
        string path     = HttpContext.Current.Server.MapPath("PDF-Files");
        string filename = path + "/Report1_" + HttpContext.Current.Session["UserID"].ToString().Trim().Substring(0, 4) + ".pdf";

        Document document = new Document(new Rectangle(288f, 144f), 30, 20, 20, 20);

        document.SetPageSize(iTextSharp.text.PageSize.A4.Rotate());

        try
        {
            PdfWriter writer = PdfWriter.GetInstance(document, new FileStream(filename, FileMode.Create));
            document.Open();

            BaseFont header = iTextSharp.text.pdf.BaseFont.CreateFont("C:\\windows\\fonts\\timesbd.ttf", BaseFont.IDENTITY_H, BaseFont.EMBEDDED);

            FontSelector selector = new FontSelector();
            Font         f1       = FontFactory.GetFont(FontFactory.TIMES_BOLD, 12);
            f1.Color = BaseColor.MAGENTA;

            Font f2 = FontFactory.GetFont(FontFactory.HELVETICA_BOLD, 16);
            f1.Color = BaseColor.RED;

            iTextSharp.text.Font fontHeader = new iTextSharp.text.Font(header, 18, iTextSharp.text.Font.BOLD);

            DataTable dt = new DataTable();
            dt = VPCRMSBAL.GetCompanyName(Convert.ToDecimal(HttpContext.Current.Session["UserID"].ToString().Trim().Substring(0, 4)));
            if (dt.Rows.Count > 0)
            {
                Paragraph para1 = new Paragraph(dt.Rows[0]["clientname"].ToString().Trim(), f2);
                para1.Alignment = Element.ALIGN_CENTER;
                document.Add(para1);
                para1.SpacingAfter = 50f;
            }

            Paragraph para2   = new Paragraph();
            Phrase    phrase1 = new Phrase("DAILY SALES STATISTICS", f1);

            para2.Alignment = Element.ALIGN_LEFT;
            para2.Add(phrase1);
            document.Add(para2);

            Paragraph para3   = new Paragraph();
            Phrase    phrase2 = new Phrase("Sales Person: ");
            Phrase    phrase3 = new Phrase(HttpContext.Current.Session["UserFirstName"].ToString().Trim() + HttpContext.Current.Session["UserLastName"].ToString().Trim());
            para3.Add(phrase2);
            para3.Add(phrase3);
            para3.Alignment    = Element.ALIGN_RIGHT;
            para3.SpacingAfter = 50f;
            document.Add(para3);


            PdfPTable table = new PdfPTable(dataTable.Columns.Count);
            table.WidthPercentage = 100;

            //Set columns names in the pdf file
            for (int k = 0; k < dataTable.Columns.Count; k++)
            {
                PdfPCell cell = new PdfPCell(new Phrase(dataTable.Columns[k].ColumnName));

                cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;
                cell.VerticalAlignment   = PdfPCell.ALIGN_CENTER;
                cell.BackgroundColor     = new iTextSharp.text.BaseColor(51, 102, 102);

                table.AddCell(cell);
            }

            //Add values of DataTable in pdf file
            for (int i = 0; i < dataTable.Rows.Count; i++)
            {
                for (int j = 0; j < dataTable.Columns.Count; j++)
                {
                    PdfPCell cell = new PdfPCell(new Phrase(dataTable.Rows[i][j].ToString()));

                    //Align the cell in the center
                    cell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;
                    cell.VerticalAlignment   = PdfPCell.ALIGN_CENTER;

                    table.AddCell(cell);
                }
            }
            document.Add(table);
            document.Close();
        }
        catch (Exception ex)
        {
            ILog logger = log4net.LogManager.GetLogger("ErrorLog");
            logger.Error(ex.ToString());
            HttpContext.Current.Response.Redirect("ErrorPage.aspx");
        }
    }
Ejemplo n.º 36
0
        public static Text Parse(TextReader reader)
        {
            var text = new Text();

            var line = reader.ReadLine();
            while(!string.IsNullOrEmpty(line))
            {
                var paragraph = new Paragraph();
                text.Add(paragraph);

                while (!string.IsNullOrEmpty(line))
                {
                    var sentenceString = line;
                    var terminalPunctuationMark = line.GetFirstOrDefaultPunctuationMark(DefaultPunctuationMarks.TerminalPunctuationMarks);
                    if (terminalPunctuationMark.HasValue)
                    {
                        var index = line.IndexOfPunctuationMark(terminalPunctuationMark);
                        sentenceString = line.Substring(0, index).TrimStart(' ');
                        line = line.Remove(0, index + terminalPunctuationMark.StringValue.Length);

                        if(text.Count > 1)
                        {
                            var lastParagraph = text.Last(p => p.HasValue);
                            if (lastParagraph.Any())
                            {
                                var lastSentence = lastParagraph.Last();
                                if (lastSentence.IsNotFinished)
                                {
                                    text.Remove(paragraph);
                                    paragraph = lastParagraph;
                                    lastSentence.Concat(sentenceString);
                                    continue;
                                }
                            }
                        }
                    }
                    else
                    {
                        line = string.Empty;
                    }

                    var sentence = ParseSentenceString(sentenceString, terminalPunctuationMark);
                    paragraph.Add(sentence);
                }

                line = reader.ReadLine();
            }

            return text;
        }
Ejemplo n.º 37
0
        public async Task <IActionResult> CreateFile(int?id)
        {
            if (id == null)
            {
                return(NotFound());
            }

            var test = await _context.Tests
                       .FirstOrDefaultAsync(m => m.Id == id);

            if (test == null)
            {
                return(NotFound());
            }

            /* Criação de provas */
            string fileName = test.Student.Name + "-test";

            Document doc = new Document(PageSize.A4);

            doc.SetMargins(40, 40, 40, 80);
            doc.AddCreationDate();

            string pasta = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);

            string dir = pasta + @"\" + fileName + ".pdf";

            PdfWriter writer = PdfWriter.GetInstance(doc, new FileStream(dir, FileMode.Create));

            doc.Open();
            List <Paragraph> paragrafos = new List <Paragraph>();

            Paragraph p1 = new Paragraph("", new Font(Font.FontFamily.HELVETICA, 12));

            p1.Alignment = Element.ALIGN_CENTER;
            p1.Add($"FICTITOUS COLLEGE\n");
            p1.Add($"MULTIDISCIPLINARY EXAM\n\n");
            paragrafos.Add(p1);

            Paragraph p2 = new Paragraph("", new Font(Font.FontFamily.HELVETICA, 12));

            p2.Alignment = Element.ALIGN_JUSTIFIED;
            p2.Add($"NAME: {test.Student.Name.ToUpper()}    |   {test.Period.Name.ToUpper()} PERIOD\n");
            p2.Add($"TEACHER: ______________________________    |  DATE: {test.Data.Date.ToString()}\n");
            paragrafos.Add(p2);

            foreach (var q in test.TestQuestions)
            {
                Paragraph p = new Paragraph("", new Font(Font.FontFamily.HELVETICA, 12));
                p.Alignment = Element.ALIGN_JUSTIFIED;
                p.Add($"\n{q.Question.Id}. {q.Question.Text}\n");
                foreach (var alter in q.Question.Alternatives)
                {
                    p.Add($"( ) {alter.Text}\n");
                }

                paragrafos.Add(p);
            }

            foreach (var x in paragrafos)
            {
                doc.Add(x);
            }

            doc.Close();



            return(RedirectToAction(nameof(Index)));
        }
Ejemplo n.º 38
0
        /**
         * Gets the main appearance layer.
         * <p>
         * Consult <A HREF="http://partners.adobe.com/asn/developer/pdfs/tn/PPKAppearances.pdf">PPKAppearances.pdf</A>
         * for further details.
         * @return the main appearance layer
         * @throws DocumentException on error
         */
        public PdfTemplate GetAppearance() {
            if (IsInvisible()) {
                PdfTemplate t = new PdfTemplate(writer);
                t.BoundingBox = new Rectangle(0, 0);
                writer.AddDirectTemplateSimple(t, null);
                return t;
            }
            if (app[0] == null && !reuseAppearance)
                CreateBlankN0();            
            if (app[1] == null && !acro6Layers) {
                PdfTemplate t = app[1] = new PdfTemplate(writer);
                t.BoundingBox = new Rectangle(100, 100);
                writer.AddDirectTemplateSimple(t, new PdfName("n1"));
                t.SetLiteral(questionMark);
            }
            if (app[2] == null) {
                String text;
                if (layer2Text == null) {
                    StringBuilder buf = new StringBuilder();
                    buf.Append("Digitally signed by ");
                    String name = null;
                    CertificateInfo.X509Name x500name = CertificateInfo.GetSubjectFields((X509Certificate)signCertificate);
                    if (x500name != null) {
                        name = x500name.GetField("CN");
                        if (name == null)
                            name = x500name.GetField("E");
                    }
                    if (name == null)
                        name = "";
                    buf.Append(name).Append('\n');
                    buf.Append("Date: ").Append(signDate.ToString("yyyy.MM.dd HH:mm:ss zzz"));
                    if (reason != null)
                        buf.Append('\n').Append(reasonCaption).Append(reason);
                    if (location != null)
                        buf.Append('\n').Append(locationCaption).Append(location);
                    text = buf.ToString();
                }
                else
                    text = layer2Text;
                PdfTemplate t = app[2] = new PdfTemplate(writer);
                t.BoundingBox = rect;
                writer.AddDirectTemplateSimple(t, new PdfName("n2"));
                if (image != null) {
                    if (imageScale == 0) {
                        t.AddImage(image, rect.Width, 0, 0, rect.Height, 0, 0);
                    }
                    else {
                        float usableScale = imageScale;
                        if (imageScale < 0)
                            usableScale = Math.Min(rect.Width / image.Width, rect.Height / image.Height);
                        float w = image.Width * usableScale;
                        float h = image.Height * usableScale;
                        float x = (rect.Width - w) / 2;
                        float y = (rect.Height - h) / 2;
                        t.AddImage(image, w, 0, 0, h, x, y);
                    }
                }
                Font font;
                if (layer2Font == null)
                    font = new Font();
                else
                    font = new Font(layer2Font);
                float size = font.Size;

                Rectangle dataRect = null;
                Rectangle signatureRect = null;

                if (renderingMode == RenderingMode.NAME_AND_DESCRIPTION || 
                    (renderingMode == RenderingMode.GRAPHIC_AND_DESCRIPTION && this.SignatureGraphic != null)) {
                    // origin is the bottom-left
                    signatureRect = new Rectangle(
                        MARGIN, 
                        MARGIN, 
                        rect.Width / 2 - MARGIN,
                        rect.Height - MARGIN);
                    dataRect = new Rectangle(
                        rect.Width / 2 +  MARGIN / 2, 
                        MARGIN, 
                        rect.Width - MARGIN / 2,
                        rect.Height - MARGIN);

                    if (rect.Height > rect.Width) {
                        signatureRect = new Rectangle(
                            MARGIN, 
                            rect.Height / 2, 
                            rect.Width - MARGIN,
                            rect.Height);
                        dataRect = new Rectangle(
                            MARGIN, 
                            MARGIN, 
                            rect.Width - MARGIN,
                            rect.Height / 2 - MARGIN);
                    }
                }
                else if (renderingMode == RenderingMode.GRAPHIC) {
                    if (signatureGraphic == null) {
                        throw new InvalidOperationException(MessageLocalization.GetComposedMessage("a.signature.image.should.be.present.when.rendering.mode.is.graphic.only"));
                    }
                    signatureRect = new Rectangle(
                            MARGIN,
                            MARGIN,
                            rect.Width - MARGIN, // take all space available
                            rect.Height - MARGIN);
                }
                else {
                    dataRect = new Rectangle(
                        MARGIN, 
                        MARGIN, 
                        rect.Width - MARGIN,
                        rect.Height * (1 - TOP_SECTION) - MARGIN);
                }

                if (renderingMode == RenderingMode.NAME_AND_DESCRIPTION) {
                    string signedBy = CertificateInfo.GetSubjectFields(signCertificate).GetField("CN");
                    if (signedBy == null)
                        signedBy = CertificateInfo.GetSubjectFields(signCertificate).GetField("E");
                    if (signedBy == null)
                        signedBy = "";
                    Rectangle sr2 = new Rectangle(signatureRect.Width - MARGIN, signatureRect.Height - MARGIN );
                    float signedSize = ColumnText.FitText(font, signedBy, sr2, -1, runDirection);

                    ColumnText ct2 = new ColumnText(t);
                    ct2.RunDirection = runDirection;
                    ct2.SetSimpleColumn(new Phrase(signedBy, font), signatureRect.Left, signatureRect.Bottom, signatureRect.Right, signatureRect.Top, signedSize, Element.ALIGN_LEFT);

                    ct2.Go();
                }
                else if (renderingMode == RenderingMode.GRAPHIC_AND_DESCRIPTION) {
                    if (signatureGraphic == null) {
                        throw new InvalidOperationException(MessageLocalization.GetComposedMessage("a.signature.image.should.be.present.when.rendering.mode.is.graphic.and.description"));
                    }
                    ColumnText ct2 = new ColumnText(t);
                    ct2.RunDirection = runDirection;
                    ct2.SetSimpleColumn(signatureRect.Left, signatureRect.Bottom, signatureRect.Right, signatureRect.Top, 0, Element.ALIGN_RIGHT);

                    Image im = Image.GetInstance(SignatureGraphic);
                    im.ScaleToFit(signatureRect.Width, signatureRect.Height);

                    Paragraph p = new Paragraph();
                    // must calculate the point to draw from to make image appear in middle of column
                    float x = 0;
                    // experimentation found this magic number to counteract Adobe's signature graphic, which
                    // offsets the y co-ordinate by 15 units
                    float y = -im.ScaledHeight + 15;

                    x = x + (signatureRect.Width - im.ScaledWidth) / 2;
                    y = y - (signatureRect.Height - im.ScaledHeight) / 2;
                    p.Add(new Chunk(im, x + (signatureRect.Width - im.ScaledWidth) / 2, y, false));
                    ct2.AddElement(p);
                    ct2.Go();
                }

                else if (renderingMode == RenderingMode.GRAPHIC) {
                    ColumnText ct2 = new ColumnText(t);
                    ct2.RunDirection = runDirection;
                    ct2.SetSimpleColumn(signatureRect.Left, signatureRect.Bottom, signatureRect.Right, signatureRect.Top, 0, Element.ALIGN_RIGHT);

                    Image im = Image.GetInstance(signatureGraphic);
                    im.ScaleToFit(signatureRect.Width, signatureRect.Height);

                    Paragraph p = new Paragraph(signatureRect.Height);
                    // must calculate the point to draw from to make image appear in middle of column
                    float x = (signatureRect.Width - im.ScaledWidth) / 2;
                    float y = (signatureRect.Height - im.ScaledHeight) / 2;
                    p.Add(new Chunk(im, x, y, false));
                    ct2.AddElement(p);
                    ct2.Go();
                }
                
                if (renderingMode != RenderingMode.GRAPHIC) {
                    if (size <= 0) {
                        Rectangle sr = new Rectangle(dataRect.Width, dataRect.Height);
                        size = ColumnText.FitText(font, text, sr, 12, runDirection);
                    }
                    ColumnText ct = new ColumnText(t);
                    ct.RunDirection = runDirection;
                    ct.SetSimpleColumn(new Phrase(text, font), dataRect.Left, dataRect.Bottom, dataRect.Right, dataRect.Top, size, Element.ALIGN_LEFT);
                    ct.Go();
                }
            }
            if (app[3] == null && !acro6Layers) {
                PdfTemplate t = app[3] = new PdfTemplate(writer);
                t.BoundingBox = new Rectangle(100, 100);
                writer.AddDirectTemplateSimple(t, new PdfName("n3"));
                t.SetLiteral("% DSBlank\n");
            }
            if (app[4] == null && !acro6Layers) {
                PdfTemplate t = app[4] = new PdfTemplate(writer);
                t.BoundingBox = new Rectangle(0, rect.Height * (1 - TOP_SECTION), rect.Right, rect.Top);
                writer.AddDirectTemplateSimple(t, new PdfName("n4"));
                Font font;
                if (layer2Font == null)
                    font = new Font();
                else
                    font = new Font(layer2Font);
                float size = font.Size;
                String text = "Signature Not Verified";
                if (layer4Text != null)
                    text = layer4Text;
                Rectangle sr = new Rectangle(rect.Width - 2 * MARGIN, rect.Height * TOP_SECTION - 2 * MARGIN);
                size = ColumnText.FitText(font, text, sr, 15, runDirection);
                ColumnText ct = new ColumnText(t);
                ct.RunDirection = runDirection;
                ct.SetSimpleColumn(new Phrase(text, font), MARGIN, 0, rect.Width - MARGIN, rect.Height - MARGIN, size, Element.ALIGN_LEFT);
                ct.Go();
            }
            int rotation = writer.reader.GetPageRotation(page);
            Rectangle rotated = new Rectangle(rect);
            int n = rotation;
            while (n > 0) {
                rotated = rotated.Rotate();
                n -= 90;
            }
            if (frm == null) {
                frm = new PdfTemplate(writer);
                frm.BoundingBox = rotated;
                writer.AddDirectTemplateSimple(frm, new PdfName("FRM"));
                float scale = Math.Min(rect.Width, rect.Height) * 0.9f;
                float x = (rect.Width - scale) / 2;
                float y = (rect.Height - scale) / 2;
                scale /= 100;
                if (rotation == 90)
                    frm.ConcatCTM(0, 1, -1, 0, rect.Height, 0);
                else if (rotation == 180)
                    frm.ConcatCTM(-1, 0, 0, -1, rect.Width, rect.Height);
                else if (rotation == 270)
                    frm.ConcatCTM(0, -1, 1, 0, 0, rect.Width);
                if (reuseAppearance) {
                    AcroFields af = writer.GetAcroFields();
                    PdfIndirectReference refe = af.GetNormalAppearance(FieldName);
                    if (refe != null) {
                	    frm.AddTemplateReference(refe, new PdfName("n0"), 1, 0, 0, 1, 0, 0);
                    }
                    else {
                	    reuseAppearance = false;
                        if (app[0] == null) {
                            CreateBlankN0();
                        }
                    }
                }
                if (!reuseAppearance) {
            	    frm.AddTemplate(app[0], 0, 0);
                }
                if (!acro6Layers)
                    frm.AddTemplate(app[1], scale, 0, 0, scale, x, y);
                frm.AddTemplate(app[2], 0, 0);
                if (!acro6Layers) {
                    frm.AddTemplate(app[3], scale, 0, 0, scale, x, y);
                    frm.AddTemplate(app[4], 0, 0);
                }
            }
            PdfTemplate napp = new PdfTemplate(writer);
            napp.BoundingBox = rotated;
            writer.AddDirectTemplateSimple(napp, null);
            napp.AddTemplate(frm, 0, 0);
            return napp;
        }
Ejemplo n.º 39
0
 /**
 * Constructs a RtfHeaderFooter for a HeaderFooter.
 *
 * @param doc The RtfDocument this RtfHeaderFooter belongs to
 * @param headerFooter The HeaderFooter to base this RtfHeaderFooter on
 */
 protected internal RtfHeaderFooter(RtfDocument doc, Legacy.Text.HeaderFooter headerFooter)
     : base(new Phrase(""), false)
 {
     this.document = doc;
     Paragraph par = new Paragraph();
     par.Alignment = headerFooter.Alignment;
     if (headerFooter.Before != null) {
         par.Add(headerFooter.Before);
     }
     if (headerFooter.IsNumbered()) {
         par.Add(new FD.RtfPageNumber(this.document));
     }
     if (headerFooter.After != null) {
         par.Add(headerFooter.After);
     }
     try {
         this.content = new Object[1];
         this.content[0] = doc.GetMapper().MapElement(par)[0];
         ((IRtfBasicElement) this.content[0]).SetInHeader(true);
     } catch (DocumentException) {
     }
 }