/// <summary> /// Extract a single page from PDF file. /// </summary> /// <param name="sourceFile">The source file.</param> /// <param name="outputFile">The output file.</param> /// <param name="pageNumber">The specific page number.</param> public static void ExtractPage(string sourceFile, string outputFile, int pageNumber) { try { PdfReader reader = new PdfReader(sourceFile); if (pageNumber > reader.NumberOfPages) { Console.WriteLine("This page number is out of reach."); return; } Document document = new Document(); PdfCopy pdfCopy = new PdfCopy(document, new FileStream(outputFile, FileMode.Create)); document.Open(); PdfImportedPage importedPage = pdfCopy.GetImportedPage(reader, pageNumber); pdfCopy.AddPage(importedPage); document.Close(); reader.Close(); } catch (Exception ex) { throw ex; } }
public static byte[] MergePdfs(IEnumerable<byte[]> inputFiles) { MemoryStream outputStream = new MemoryStream(); Document document = new Document(); PdfWriter writer = PdfWriter.GetInstance(document, outputStream); document.Open(); PdfContentByte content = writer.DirectContent; foreach (byte[] input in inputFiles) { PdfReader reader = new PdfReader(input); for (int i = 1; i <= reader.NumberOfPages; i++) { document.SetPageSize(reader.GetPageSizeWithRotation(i)); document.NewPage(); PdfImportedPage page = writer.GetImportedPage(reader, i); int rotation = reader.GetPageRotation(i); if (rotation == 90 || rotation == 270) { content.AddTemplate(page, 0, -1f, 1f, 0, 0, reader.GetPageSizeWithRotation(i).Height); } else { content.AddTemplate(page, 1f, 0, 0, 1f, 0, 0); } } } document.Close(); return outputStream.ToArray(); }
public override void ViewDidLoad() { base.ViewDidLoad (); filePdf = Path.Combine (Environment.GetFolderPath (Environment.SpecialFolder.InternetCache), "PDF_Temp.pdf"); var document = new Document(PageSize.LETTER); // Create a new PdfWriter object, specifying the output stream var output = new FileStream(filePdf, FileMode.Create); var writer = PdfWriter.GetInstance(document, output); // Open the Document for writing document.Open(); BaseFont bf = BaseFont.CreateFont (BaseFont.HELVETICA, BaseFont.CP1252, false); iTextSharp.text.Font font = new iTextSharp.text.Font (bf, 16, iTextSharp.text.Font.BOLD); var p = new Paragraph ("Sample text", font); document.Add (p); document.Close (); writer.Close (); //Close the Document - this saves the document contents to the output stream document.Close(); writer.Close (); }
public static void CreateTmpPDFFile(string tmpPDFFile, string jpgFile) { Document doc = new Document(iTextSharp.text.PageSize.A4, 0, 0, 0, 0); try { string pdfFilePath = tmpPDFFile; //Create Document class object and set its size to letter and give space left, right, Top, Bottom Margin PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream(pdfFilePath, FileMode.Create)); doc.Open();//Open Document to write ////Write some content into pdf file //Paragraph paragraph = new Paragraph("This is my first line using Paragraph."); // Now image in the pdf file string imageFilePath = jpgFile; iTextSharp.text.Image jpg = iTextSharp.text.Image.GetInstance(imageFilePath); //Resize image depend upon your need //jpg.ScalePercent(20); jpg.ScaleToFit(600f, 950f); //Give space before image //jpg.SpacingBefore = 30f; //Give some space after the image //jpg.SpacingAfter = 1f; jpg.Alignment = Element.ALIGN_CENTER; //doc.Add(paragraph); // add paragraph to the document doc.Add(jpg); //add an image to the created pdf document doc.Close(); } catch (DocumentException docEx) { //handle pdf document exception if any } catch (IOException ioEx) { // handle IO exception } catch (Exception ex) { // ahndle other exception if occurs } finally { //Close document and writer doc.Close(); } }
public void DoPdf() { PdfPTable pdfPTable = new PdfPTable(diseaseWiseReportGridView.HeaderRow.Cells.Count); foreach (TableCell headerCell in diseaseWiseReportGridView.HeaderRow.Cells) { PdfPCell pdfCell = new PdfPCell(new Phrase(headerCell.Text)); pdfPTable.AddCell(pdfCell); } int count = 1; foreach (GridViewRow gridViewRow in diseaseWiseReportGridView.Rows) { if (count != 0) foreach (TableCell tableCell in gridViewRow.Cells) { PdfPCell pdfCell = new PdfPCell(new Phrase(tableCell.Text)); pdfPTable.AddCell(pdfCell); } count++; } Document document = new Document(iTextSharp.text.PageSize.LETTER, 10, 10, 42, 35); PdfWriter.GetInstance(document, Response.OutputStream); //PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream("test.pdf", FileMode.Create)); Paragraph diseaseName = new Paragraph("Disease Name: " + diseaseDropDownList.SelectedItem.Text); Paragraph strartingDate = new Paragraph("Starting Date: " + firstdateTextBox.Text); Paragraph lastdate = new Paragraph("Last Date: " + lastdateTextBox.Text); Paragraph text = new Paragraph("\n\n"); document.Open(); document.Add(diseaseName); document.Add(strartingDate); document.Add(lastdate); document.Add(text); document.Add(pdfPTable); document.Close(); Response.ContentType = "Application"; Response.AppendHeader("content-disposition", "attachment;filename=DiseaseWiseReport.pdf"); Response.Write(document); Response.Flush(); Response.End(); document.Close(); }
public void ExportToPdf(DataTable table, string filename, HttpResponse Response) { using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter hw = new HtmlTextWriter(sw)) { //To Export all pages GridView gridView = new GridView(); gridView.DataSource = table; gridView.DataBind(); gridView.AllowPaging = false; gridView.RenderControl(hw); StringReader sr = new StringReader(sw.ToString()); iTextSharp.text.Document pdfDoc = new iTextSharp.text.Document(iTextSharp.text.PageSize.A2, 10f, 10f, 10f, 0f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); PdfWriter.GetInstance(pdfDoc, Response.OutputStream); pdfDoc.Open(); htmlparser.Parse(sr); pdfDoc.Close(); Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment;filename=Report.pdf"); Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.Write(pdfDoc); Response.End(); } } }
protected void btnPDF_Click(object sender, ImageClickEventArgs e) { Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment;filename=UserDetails.pdf"); Response.Cache.SetCacheability(HttpCacheability.NoCache); var sw = new StringWriter(); var hw = new HtmlTextWriter(sw); gvdetails.AllowPaging = false; gvdetails.DataBind(); gvdetails.RenderControl(hw); gvdetails.HeaderRow.Style.Add("width", "15%"); gvdetails.HeaderRow.Style.Add("font-size", "10px"); gvdetails.Style.Add("text-decoration", "none"); gvdetails.Style.Add("font-family", "Arial, Helvetica, sans-serif;"); gvdetails.Style.Add("font-size", "8px"); var sr = new StringReader(sw.ToString()); var pdfDoc = new Document(PageSize.A2, 7f, 7f, 7f, 0f); var htmlparser = new HTMLWorker(pdfDoc); PdfWriter.GetInstance(pdfDoc, Response.OutputStream); pdfDoc.Open(); htmlparser.Parse(sr); pdfDoc.Close(); Response.Write(pdfDoc); Response.End(); }
private void LoadClinicRegistrationToBrowser(string htmlText) { //create a PDF document in MemoryStream System.IO.MemoryStream m = new System.IO.MemoryStream(); iTextSharp.text.Document document = new iTextSharp.text.Document(iTextSharp.text.PageSize.LETTER); iTextSharp.text.pdf.PdfWriter writer = iTextSharp.text.pdf.PdfWriter.GetInstance(document, m); document.Open(); //make an arraylist ....with STRINGREADER since its not reading file... List <iTextSharp.text.IElement> htmlarraylist = iTextSharp.text.html.simpleparser.HTMLWorker.ParseToList(new StringReader(htmlText), null); //add the collection to the document for (int k = 0; k < htmlarraylist.Count; k++) { document.Add((iTextSharp.text.IElement)htmlarraylist[k]); } document.Close(); //Stream PDF document back to browser Response.ContentType = "Application/pdf"; Response.BinaryWrite(m.GetBuffer()); Response.Flush(); Response.SuppressContent = true; Response.End(); }
// to generate the report call the GeneratePDFReport static method. // The pdf file will be generated in the SupermarketChain.ConsoleClient folder // TODO measures are missing // TODO code refactoring to limitr repeated chunks public static void GeneratePDFReport() { Document doc = new Document(iTextSharp.text.PageSize.A4, 10, 10, 40, 35); string filePath = @"..\..\..\..\Reports\salesReports.pdf"; PdfWriter writer = PdfWriter.GetInstance(doc, new FileStream(filePath, FileMode.Create)); doc.Open(); PdfPTable table = new PdfPTable(5); Font verdana = FontFactory.GetFont("Verdana", 16, Font.BOLD); Font verdana2 = FontFactory.GetFont("Verdana", 12, Font.BOLD); PdfPCell header = new PdfPCell(new Phrase("Aggregated Sales Report", verdana)); header.Colspan = 5; header.HorizontalAlignment = 1; table.AddCell(header); double totalSales = PourReportData(table); PdfPCell totalSum = new PdfPCell(new Phrase("Grand total:")); totalSum.Colspan = 4; totalSum.HorizontalAlignment = 2; totalSum.BackgroundColor = new BaseColor(161, 212, 224); table.AddCell(totalSum); PdfPCell totalSumNumber = new PdfPCell(new Phrase(String.Format("{0:0.00}", totalSales), verdana)); totalSumNumber.BackgroundColor = new BaseColor(161, 212, 224); table.AddCell(totalSumNumber); doc.Add(table); doc.Close(); DirectoryInfo directoryInfo = new DirectoryInfo(filePath); Console.WriteLine("Pdf report generated."); Console.WriteLine("File: {0}", directoryInfo.FullName); }
/// <summary> /// Save a pdf file in "../../test.pdf". /// </summary> /// <param name="deals">Expect Collection of objects that have Name, Address, ProductName and formula.</param> public void GenerateReport(IEnumerable<PdfReportModel> deals) { FileStream fileStream = new FileStream(ReportsPath, FileMode.Create, FileAccess.Write, FileShare.None); Rectangle pageSize = new Rectangle(PageSize.A4); Document reportDocument = new Document(pageSize); PdfWriter pdfWriter = PdfWriter.GetInstance(reportDocument, fileStream); var boldFont = FontFactory.GetFont(FontFactory.HELVETICA_BOLD, 17); reportDocument.Open(); PdfPTable reportTable = new PdfPTable(6); reportTable.HorizontalAlignment = Element.ALIGN_LEFT; PdfPCell headerCell = new PdfPCell(new Phrase("Produced products information", boldFont)); headerCell.Colspan = 6; headerCell.HorizontalAlignment = 0; reportTable.AddCell(headerCell); this.PutHeadCells(reportTable); foreach (var deal in deals) { reportTable.AddCell(deal.ProductName); reportTable.AddCell(deal.Quantity); reportTable.AddCell(deal.PricePerUnit); reportTable.AddCell(deal.Formula); reportTable.AddCell(deal.Address); reportTable.AddCell(deal.Total); } reportDocument.Add(reportTable); reportDocument.Close(); }
public bool TryCreatePdf(string nameBank) { try { using (FileStream file = new FileStream(String.Format(path,nameBank), FileMode.Create)) { Document document = new Document(PageSize.A7); PdfWriter writer = PdfWriter.GetInstance(document, file); /// Create metadate pdf file document.AddAuthor(""); document.AddLanguage("pl"); document.AddSubject("Payment transaction"); document.AddTitle("Transaction"); /// Create text in pdf file document.Open(); document.Add(new Paragraph(_przelew+"\n")); document.Add(new Paragraph(String.Format("Bank {0}: zaprasza\n",nameBank))); document.Add(new Paragraph(DateTime.Now.ToString())); document.Close(); writer.Close(); file.Close(); return true; } } catch (SystemException ex) { return false; } }
public void ASPXToPDF(HtmlTable objhtml1, HtmlTable objhtml2) { string fileName = "AsignacionFolios.pdf"; HttpContext.Current.Response.ClearContent(); HttpContext.Current.Response.Clear(); StringWriter sw1 = new StringWriter(); HtmlTextWriter hw1 = new HtmlTextWriter(sw1); objhtml1.RenderControl(hw1); StringWriter sw2 = new StringWriter(); HtmlTextWriter hw2 = new HtmlTextWriter(sw2); objhtml2.RenderControl(hw2); StringReader sr1 = new StringReader(sw1.ToString()); StringReader sr2 = new StringReader(sw2.ToString()); Document pdfDoc = new Document(PageSize.A2, 5f, 5f, 5f, 5f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); PdfWriter.GetInstance(pdfDoc, HttpContext.Current.Response.OutputStream); pdfDoc.Open(); htmlparser.Parse(sr1); pdfDoc.NewPage(); htmlparser.Parse(sr2); pdfDoc.Close(); HttpContext.Current.Response.ContentType = "application/pdf"; HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + fileName); HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache); HttpContext.Current.Response.Write(pdfDoc); HttpContext.Current.Response.End(); }
protected void btnExpotGraph_Click(object sender, EventArgs e) { //code obtained from here: http://www.aspsnippets.com/Articles/Export-ASPNet-Chart-Control-to-PDF-Document-using-iTextSharp-Library.aspx. Used under the site's license. if (cboFileSelectionGraExp.SelectedIndex == 0) { string timeStamp = DateTime.Now.Year.ToString() + "_" + DateTime.Now.Month.ToString() + "_" + DateTime.Now.Day.ToString() + "-" + DateTime.Now.Hour.ToString() + "_" + DateTime.Now.Minute.ToString() + "_" + DateTime.Now.Second.ToString(); Document pdfDoc = new Document(new RectangleReadOnly(1248,816), 88f, 88f, 10f, 10f); PdfWriter.GetInstance(pdfDoc, Response.OutputStream); pdfDoc.Open(); using (MemoryStream stream = new MemoryStream()) { Chart1.SaveImage(stream, ChartImageFormat.Png); iTextSharp.text.Image chartImage = iTextSharp.text.Image.GetInstance(stream.GetBuffer()); chartImage.ScalePercent(75f); pdfDoc.Add(chartImage); pdfDoc.Close(); Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment;filename=Chart_" + timeStamp + ".pdf"); Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.Write(pdfDoc); Response.End(); } } }
protected override void MakePdf(string outPdf) { Document doc = new Document(PageSize.A4.Rotate()); PdfWriter pdfWriter = PdfWriter.GetInstance(doc, new FileStream(outPdf, FileMode.Create)); doc.SetMargins(45, 45, 0, 100); doc.Open(); CssFilesImpl cssFiles = new CssFilesImpl(); cssFiles.Add( XMLWorkerHelper.GetCSS( File.OpenRead(RESOURCES + Path.DirectorySeparatorChar + testPath + Path.DirectorySeparatorChar + testName + Path.DirectorySeparatorChar + "complexDiv_files" + Path.DirectorySeparatorChar + "main.css"))); cssFiles.Add( XMLWorkerHelper.GetCSS( File.OpenRead(RESOURCES + Path.DirectorySeparatorChar + testPath + Path.DirectorySeparatorChar + testName + Path.DirectorySeparatorChar + "complexDiv_files" + Path.DirectorySeparatorChar + "widget082.css"))); StyleAttrCSSResolver cssResolver = new StyleAttrCSSResolver(cssFiles); HtmlPipelineContext hpc = new HtmlPipelineContext( new CssAppliersImpl(new XMLWorkerFontProvider(RESOURCES + @"\tool\xml\examples\fonts"))); hpc.SetAcceptUnknown(true).AutoBookmark(true).SetTagFactory(Tags.GetHtmlTagProcessorFactory()); hpc.SetImageProvider(new SampleTestImageProvider()); hpc.SetPageSize(doc.PageSize); HtmlPipeline htmlPipeline = new HtmlPipeline(hpc, new PdfWriterPipeline(doc, pdfWriter)); IPipeline pipeline = new CssResolverPipeline(cssResolver, htmlPipeline); XMLWorker worker = new XMLWorker(pipeline, true); XMLParser p = new XMLParser(true, worker, Encoding.GetEncoding("UTF-8")); p.Parse(File.OpenRead(inputHtml), Encoding.GetEncoding("UTF-8")); doc.Close(); }
private void ExportToPDF() { using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter hw = new HtmlTextWriter(sw)) { //To Export all pages this.gvExportToPdf.AllowPaging = false; //this.BindGridView(); this.gvExportToPdf.RenderControl(hw); StringReader sr = new StringReader(sw.ToString()); Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment;filename=DashboardReport.pdf"); Response.Cache.SetCacheability(HttpCacheability.NoCache); PdfWriter.GetInstance(pdfDoc, Response.OutputStream); pdfDoc.Open(); htmlparser.Parse(sr); pdfDoc.Close(); Response.Write(pdfDoc); Response.End(); } } }
public void VerticalPositionTest0() { String file = "vertical_position.pdf"; Document document = new Document(); PdfWriter writer = PdfWriter.GetInstance(document, File.Create(OUTPUT_FOLDER + file)); document.Open(); writer.PageEvent = new CustomPageEvent(); PdfPTable table = new PdfPTable(2); for (int i = 0; i < 100; i++) { table.AddCell("Hello " + i); table.AddCell("World " + i); } document.Add(table); document.NewPage(); StringBuilder sb = new StringBuilder(); for (int i = 0; i < 1000; i++) { sb.Append("some more text "); } document.Add(new Paragraph(sb.ToString())); document.Close(); // compare CompareTool compareTool = new CompareTool(); String errorMessage = compareTool.CompareByContent(OUTPUT_FOLDER + file, TEST_RESOURCES_PATH + file, OUTPUT_FOLDER, "diff"); if (errorMessage != null) { Assert.Fail(errorMessage); } }
protected void generatePDFButton_Click(object sender, EventArgs e) { PdfPTable pdfPTable = new PdfPTable(CreatedStudentInformationGridView.HeaderRow.Cells.Count); foreach (TableCell headerCell in CreatedStudentInformationGridView.HeaderRow.Cells) { PdfPCell pfdPCell = new PdfPCell(new Phrase(headerCell.Text)); //pfdPCell.BackgroundColor = new BaseColor(newCenterGridView.HeaderStyle.ForeColor); pdfPTable.AddCell(pfdPCell); } foreach (GridViewRow gridViewRow in CreatedStudentInformationGridView.Rows) { foreach (TableCell tableCell in gridViewRow.Cells) { PdfPCell pfdPCell = new PdfPCell(new Phrase(tableCell.Text)); //pfdPCell.BackgroundColor = new BaseColor(newCenterGridView.HeaderStyle.ForeColor); pdfPTable.AddCell(pfdPCell); } } Document pdfDocument = new Document(PageSize.A4, 10f, 10f, 10f, 10f); PdfWriter.GetInstance(pdfDocument, Response.OutputStream); pdfDocument.Open(); pdfDocument.Add(pdfPTable); pdfDocument.Close(); Response.ContentType = "application/pdf"; Response.AppendHeader("content-disposition", "attachment;filename=NewCenter.pdf"); Response.Write(pdfDocument); Response.Flush(); Response.End(); }
public int Convert(string from, string to) { _logger.DebugFormat("Text转换为Pdf, {0},到:{1}", from, to); try { var content = File.ReadAllText(@from, Encoding.Default); Document document = new Document(); BaseFont bf = BaseFont.CreateFont("c:\\windows\\fonts\\SIMSUN.TTC,1", BaseFont.IDENTITY_H, BaseFont.EMBEDDED); Font font = new Font(bf); PdfWriter.GetInstance(document, new FileStream(@to, FileMode.Create)); document.Open(); document.Add(new Paragraph(content, font)); document.Close(); return ErrorMessages.Success; } catch(Exception ex) { throw new ConverterException(ErrorMessages.TextToPdfFailed, ex); } }
public void TextLeadingTest() { String file = "phrases.pdf"; Document document = new Document(); PdfWriter writer = PdfWriter.GetInstance(document, File.Create(OUTPUT_FOLDER + file)); document.Open(); Phrase p1 = new Phrase("first, leading of 150"); p1.Leading = 150; document.Add(p1); document.Add(Chunk.NEWLINE); Phrase p2 = new Phrase("second, leading of 500"); p2.Leading = 500; document.Add(p2); document.Add(Chunk.NEWLINE); Phrase p3 = new Phrase(); p3.Add(new Chunk("third, leading of 20")); p3.Leading = 20; document.Add(p3); document.Close(); // compare CompareTool compareTool = new CompareTool(); String errorMessage = compareTool.CompareByContent(OUTPUT_FOLDER + file, TEST_RESOURCES_PATH + file, OUTPUT_FOLDER, "diff"); if (errorMessage != null) { Assert.Fail(errorMessage); } }
virtual public void CreateAllSamples() { bool success = true; foreach (String str in list) { try { Console.WriteLine(str); Document doc = new Document(); PdfWriter writer = null; try { writer = PdfWriter.GetInstance(doc, new FileStream(TARGET + "/" + str + "Test.pdf", FileMode.Create)); } catch (DocumentException e) { Console.WriteLine(e); } doc.Open(); StreamReader bis = File.OpenText(RESOURCE_TEST_PATH + "/snippets/" + str + "snippet.html"); XMLWorkerHelper helper = XMLWorkerHelper.GetInstance(); helper.ParseXHtml(writer, doc, bis); doc.Close(); } catch (Exception e) { Console.Write(e); success = false; } } if (!success) { Assert.Fail(); } }
public Document CreatePdfDocument(Chart chart, string path) { RenderTargetBitmap renderBitmap = new RenderTargetBitmap( (int) chart.ActualWidth, (int) chart.ActualHeight, 96d, 96d, PixelFormats.Pbgra32); renderBitmap.Render(chart); MemoryStream stream = new MemoryStream(); BitmapEncoder encoder = new BmpBitmapEncoder(); encoder.Frames.Add(BitmapFrame.Create(renderBitmap)); encoder.Save(stream); Bitmap bitmap = new Bitmap(stream); System.Drawing.Image image = bitmap; System.Drawing.Image resizedImage = ResizeImage(image, image.Width*2, image.Height); Document doc = new Document(PageSize.A4); PdfWriter.GetInstance(doc, new FileStream(path, FileMode.OpenOrCreate)); doc.Open(); Image pdfImage = Image.GetInstance(resizedImage, ImageFormat.Jpeg); doc.Add(pdfImage); doc.Close(); return doc; }
protected void btnExport_Click(object sender, EventArgs e) { using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter hw = new HtmlTextWriter(sw)) { //To Export all pages grid_monthly_attendanceDetailed.AllowPaging = false; //this.BindGrid(); grid_monthly_attendanceDetailed.RenderBeginTag(hw); grid_monthly_attendanceDetailed.HeaderRow.RenderControl(hw); foreach (GridViewRow row in grid_monthly_attendanceDetailed.Rows) { row.RenderControl(hw); } grid_monthly_attendanceDetailed.FooterRow.RenderControl(hw); grid_monthly_attendanceDetailed.RenderEndTag(hw); StringReader sr = new StringReader(sw.ToString()); Document pdfDoc = new Document(PageSize.A2, 10f, 10f, 10f, 0f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); PdfWriter.GetInstance(pdfDoc, Response.OutputStream); pdfDoc.Open(); htmlparser.Parse(sr); pdfDoc.Close(); Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment;filename=Report.pdf"); Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.Write(pdfDoc); Response.End(); } } }
/// <summary> /// Creates a MemoryStream but does not dispose it. /// </summary> /// <param name="members"></param> /// <param name="expiration"></param> /// <returns></returns> public static MemoryStream CreateCards(IEnumerable<Member> members, DateTime expiration) { iTextSharp.text.Document doc = new iTextSharp.text.Document(new iTextSharp.text.Rectangle(CARD_WIDTH, CARD_HEIGHT)); MemoryStream memStream = new MemoryStream(); PdfWriter writer = PdfWriter.GetInstance(doc, memStream); writer.CloseStream = false; doc.Open(); foreach (var member in members) { foreach (var passport in new[] { false, true}) { Render_FrontBase(writer.DirectContentUnder, expiration); Render_FrontContent(writer.DirectContent, member); doc.NewPage(); Render_BackBase(writer.DirectContentUnder); Render_BackContent(writer.DirectContent, member, passport); doc.NewPage(); } } doc.Close(); byte[] buf = new byte[memStream.Position]; memStream.Position = 0; return memStream; }
private void AusgangsrechnungenPDF_Click(object sender, EventArgs e) { string pdfString = ""; Document pdfDoc = new Document(); PdfWriter writer = PdfWriter.GetInstance(pdfDoc, new System.IO.FileStream(System.IO.Directory.GetCurrentDirectory() + "\\exportAusgangsrechnungen.pdf", System.IO.FileMode.Create)); pdfDoc.Open(); foreach (DataGridViewRow row in dataGridViewAusgangsrechnung.SelectedRows) { foreach(DataGridViewCell cell in row.Cells) { pdfString += cell.Value.ToString() + " "; } pdfDoc.Add(new Paragraph (pdfString)); pdfString = ""; } PdfContentByte cb = writer.DirectContent; cb.MoveTo(pdfDoc.PageSize.Width, pdfDoc.PageSize.Height); cb.LineTo(pdfDoc.PageSize.Width / 2, pdfDoc.PageSize.Height); cb.Stroke(); pdfDoc.Close(); }
protected override void TransformHtml2Pdf() { Document doc = new Document(PageSize.A1.Rotate()); PdfWriter pdfWriter = PdfWriter.GetInstance(doc, new FileStream(outPdf, FileMode.Create)); doc.SetMargins(doc.LeftMargin - 10, doc.RightMargin - 10, doc.TopMargin, doc.BottomMargin); doc.Open(); CssFilesImpl cssFiles = new CssFilesImpl(); cssFiles.Add( XMLWorkerHelper.GetCSS( File.OpenRead(RESOURCES + Path.DirectorySeparatorChar + testPath + testName + Path.DirectorySeparatorChar + "complexDiv02_files" + Path.DirectorySeparatorChar + "minimum0.css"))); cssFiles.Add( XMLWorkerHelper.GetCSS( File.OpenRead(RESOURCES + Path.DirectorySeparatorChar + testPath + testName + Path.DirectorySeparatorChar + "complexDiv02_files" + Path.DirectorySeparatorChar + "print000.css"))); cssFiles.Add(XMLWorkerHelper.GetCSS(File.OpenRead(RESOURCES + @"\tool\xml\examples\" + "sampleTest.css"))); StyleAttrCSSResolver cssResolver = new StyleAttrCSSResolver(cssFiles); HtmlPipelineContext hpc = new HtmlPipelineContext( new CssAppliersImpl(new XMLWorkerFontProvider(RESOURCES + @"\tool\xml\examples\fonts"))); hpc.SetAcceptUnknown(true).AutoBookmark(true).SetTagFactory(Tags.GetHtmlTagProcessorFactory()); hpc.SetImageProvider(new SampleTestImageProvider()); HtmlPipeline htmlPipeline = new HtmlPipeline(hpc, new PdfWriterPipeline(doc, pdfWriter)); IPipeline pipeline = new CssResolverPipeline(cssResolver, htmlPipeline); XMLWorker worker = new XMLWorker(pipeline, true); XMLParser p = new XMLParser(true, worker, Encoding.GetEncoding("UTF-8")); p.Parse(File.OpenRead(inputHtml), Encoding.GetEncoding("UTF-8")); doc.Close(); }
virtual public void ParseXfaOnlyXML() { StreamReader bis = File.OpenText(RESOURCE_TEST_PATH + SNIPPETS + TEST + "snippet.html"); Document doc = new Document(PageSize.A4); float margin = utils.ParseRelativeValue("10%", PageSize.A4.Width); doc.SetMargins(margin, margin, margin, margin); PdfWriter writer = null; try { writer = PdfWriter.GetInstance(doc, new FileStream( TARGET + TEST + "_charset.pdf", FileMode.Create)); } catch (DocumentException e) { Console.WriteLine(e); } CssFilesImpl cssFiles = new CssFilesImpl(); cssFiles.Add(XMLWorkerHelper.GetInstance().GetDefaultCSS()); StyleAttrCSSResolver cssResolver = new StyleAttrCSSResolver(cssFiles); HtmlPipelineContext hpc = new HtmlPipelineContext(null); hpc.SetAcceptUnknown(true) .AutoBookmark(true) .SetTagFactory(Tags.GetHtmlTagProcessorFactory()) .CharSet(Encoding.GetEncoding("ISO-8859-1")); IPipeline pipeline = new CssResolverPipeline(cssResolver, new HtmlPipeline(hpc, new PdfWriterPipeline(doc, writer))); XMLWorker worker = new XMLWorker(pipeline, true); doc.Open(); XMLParser p = new XMLParser(true, worker); p.Parse(bis); doc.Close(); }
protected void Page_Load(object sender, EventArgs e) { string html = GetHTMLOutput("~/render.aspx?id=1"); if (!string.IsNullOrEmpty(html)) { string file = Server.MapPath("~/pdf") + "\\using.pdf"; using (Document doc = new Document(PageSize.LETTER, 25, 25, 25, 25)) { using (PdfWriter pdf = PdfWriter.GetInstance(doc, new FileStream(file, FileMode.Create))) { List<IElement> code = HTMLWorker.ParseToList(new StringReader(html), null); doc.Open(); foreach (IElement el in code) { doc.Add(el); } doc.Close(); } } } }
public static void GeneratePdfSingleDataType(string filePath, string title, string content) { try { Logger.LogI("GeneratePDF -> " + filePath); var doc = new Document(PageSize.A3, 36, 72, 72, 144); using (var fs = new FileStream(filePath, FileMode.Create, FileAccess.Write, FileShare.ReadWrite)) { PdfWriter.GetInstance(doc, fs); doc.Open(); doc.AddTitle(title); doc.AddAuthor(Environment.MachineName); doc.Add( new Paragraph("Title : " + title + Environment.NewLine + "ServerName : " + Environment.MachineName + Environment.NewLine + "Author : " + Environment.UserName)); doc.NewPage(); doc.Add(new Paragraph(content)); doc.Close(); } } catch (Exception ex) { Logger.LogE(ex.Source + " -> " + ex.Message + "\n" + ex.StackTrace); } }
protected void Button1_Click(object sender, EventArgs e) { Page.Title = "Contact List"; MemoryStream PDFData = new MemoryStream(); // step 1: creation of a document-object Document document = new Document(); // step 2: // we create a writer that listens to the document // and directs a PDF-stream to a file PdfWriter.GetInstance(document, PDFData); // step 3: we open the document document.Open(); // step 4: we add a paragraph to the document document.Add(new Paragraph(DateTime.Now.ToString())); Contact oContact = new Contact(); DataTable dtContact = oContact.LoadAll(); int numRow = dtContact.Rows.Count; int numCol = 5; iTextSharp.text.Table aTable = new iTextSharp.text.Table(numCol, numRow); aTable.AutoFillEmptyCells = true; aTable.Padding = 1; aTable.Spacing = 1; Cell cell = new Cell(new Phrase("Contact List", FontFactory.GetFont(FontFactory.TIMES, 14, Font.BOLD))); cell.Header = true; cell.Colspan = numCol; cell.BackgroundColor = Color.LIGHT_GRAY; cell.HorizontalAlignment = Element.ALIGN_CENTER; aTable.AddCell(cell); for (int i = 0; i < dtContact.Rows.Count; i++) { for (int n = 1; n <= numCol; n++) aTable.AddCell(dtContact.Rows[i][n].ToString()); } document.Add(aTable); // step 5: we close the document document.Close(); Response.Clear(); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/pdf"; Response.Charset = string.Empty; Response.Cache.SetCacheability(System.Web.HttpCacheability.Public); Response.AddHeader("Content-Disposition", "attachment; filename=" + Title.Replace(" ", "").Replace(":", "-") + ".pdf"); Response.OutputStream.Write(PDFData.GetBuffer(), 0, PDFData.GetBuffer().Length); Response.OutputStream.Flush(); Response.OutputStream.Close(); Response.End(); }
public static void Export(DetailsView dvGetStudent) { int rows = dvGetStudent.Rows.Count; int columns = dvGetStudent.Rows[0].Cells.Count; int pdfTableRows = rows; iTextSharp.text.Table PdfTable = new iTextSharp.text.Table(2, pdfTableRows); PdfTable.BorderWidth = 1; PdfTable.Cellpadding = 0; PdfTable.Cellspacing = 0; for (int rowCounter = 0; rowCounter < rows; rowCounter++) { for (int columnCounter = 0; columnCounter < columns; columnCounter++) { string strValue = dvGetStudent.Rows[rowCounter].Cells[columnCounter].Text; PdfTable.AddCell(strValue); } } Document Doc = new Document(); PdfWriter.GetInstance(Doc, HttpContext.Current.Response.OutputStream); Doc.Open(); Doc.Add(PdfTable); Doc.Close(); HttpContext.Current.Response.ContentType = "application/pdf"; HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=StudentDetails.pdf"); HttpContext.Current.Response.End(); }
public void CvAdd(CurriculumVitae curriculumVitae) { Document document = new iTextSharp.text.Document(); PdfWriter.GetInstance(document, new FileStream(@"C:\Users\ademk\Desktop\PoldyMyCv.pdf", FileMode.Create)); BaseFont arial = BaseFont.CreateFont("c:\\windows\\fonts\\arial.ttf", BaseFont.IDENTITY_H, BaseFont.EMBEDDED); Font font = new Font(arial, 12, Font.NORMAL); if (document.IsOpen() == false) { document.Open(); // iTextSharp.text.Image img = iTextSharp.text.Image.GetInstance(@"C:\Users\ademk\source\repos\Poldy4\deneme\PoldyCv\vesikalik.jpg"); // img.ScalePercent(30f, 20f); string text; if (curriculumVitae.MaritalStatus.ToString() == "False") { this.medenidurum = "Bekar"; } else if (curriculumVitae.MaritalStatus.ToString() == "True") { this.medenidurum = "Evli"; } text = "Kişisel Bilgiler \n" + "--------------------" + "\n Ad :" + curriculumVitae.FirstName + "\n Soyad : " + curriculumVitae.LastName + "\n Doğum Tarihi : " + curriculumVitae.BirthDate + "\n Doğum Yeri : " + curriculumVitae.PlaceOfBirth + "\n Medeni Durum : " + this.medenidurum + "\n ----------------------------------------" + "\n Eğitim Bilgileri" + "\n--------------------" + "\n Öğrenim Seviyesi :" + curriculumVitae.EducationStatus + "\n Okul Adı : " + curriculumVitae.School + "\n Okul Başlangıç : " + curriculumVitae.SchoolStart + "\n Okul Bitiş : " + curriculumVitae.SchoolFinish + "\n --------------------" + "\n İletişim Bilgileri" + "\n ---------------------" + "\n Cep Numarası : " + curriculumVitae.MobilTelefonNumber + "\n Mail Adresi : " + curriculumVitae.Mail + "\n Adres : " + curriculumVitae.Address + "\n --------------------" + "\n Yabancı Dil Bilgileri" + "\n ---------------------" + "\n Yabancı Dil : " + curriculumVitae.ForeignLanguage + "\n Yabancı Dil Seviye : " + curriculumVitae.ForeignLanguageLevel + "\n --------------------" + "\n Yabancı Dil Bilgileri" + "\n ---------------------" + "\n Yetkinlikler : " + curriculumVitae.Competences + "\n ----------------------------" + "\n Referanslar : " + curriculumVitae.Reference ; //document.Add(img); text = Turkish1.TurkishCharacter(text); document.Add(new Paragraph(text, font)); document.Close(); this.CvPdf = File.ReadAllBytes(@"C:\Users\ademk\Desktop\PoldyMyCv.pdf"); } }
public bool GenerateMCDSlipDocument() { storeNumber = GlobalDataAccessor.Instance.CurrentSiteId.StoreNumber; reportNumber = "CL-OP-68"; DataTable checkInfoDetails; string errorCode; string errorText; //Get the report data ShopProcedures.GetStoreManualCheckDepositData(GlobalDataAccessor.Instance.OracleDA, GlobalDataAccessor.Instance.CurrentSiteId.StoreId, ShopDateTime.Instance.ShopDate, out checkInfoDetails, out errorCode, out errorText); if (checkInfoDetails == null || checkInfoDetails.Rows.Count == 0) { FileLogger.Instance.logMessage(LogLevel.ERROR, this, "No data returned from stored procedure for manual check deposit slips " + errorText); return(false); } //Initialize fonts RptFont = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.NORMAL); this.HeaderTitleFont = new Font(BaseFont.CreateFont(BaseFont.HELVETICA_BOLD, BaseFont.CP1252, BaseFont.NOT_EMBEDDED), 10); this.MCDSlipReportTitle = @"Check Cash Deposit Slip"; document = new Document(PageSize.LETTER); document.AddTitle(MCDSlipReportTitle); PdfPTable table = new PdfPTable(8); rptFileName = SecurityAccessor.Instance.EncryptConfig.ClientConfig.GlobalConfiguration.BaseLogPath + "\\MCD" + DateTime.Now.ToString("MMddyyyyhhmmssFFFFFFF") + ".pdf"; PdfWriter writer = PdfWriter.GetInstance(document, new FileStream(rptFileName, FileMode.Create)); MCDPageEvents events = new MCDPageEvents(); writer.PageEvent = events; document.SetPageSize(PageSize.LETTER); document.SetMargins(0, 0, 10, 45); Image image = Image.GetInstance(Properties.Resources.logo, BaseColor.WHITE); image.ScalePercent(25); //Insert the report header InsertReportHeader(table, image); document.Open(); document.Add(table); PdfPTable newtable = new PdfPTable(4); //Insert the column headers InsertColumnHeaders(newtable); table.HeaderRows = 7; decimal totalCheckAmount = 0; int totalNumChecks = 0; foreach (DataRow dr in checkInfoDetails.Rows) { string makerName = Common.Libraries.Utility.Utilities.GetStringValue(dr["makername"]); string cdName = Utilities.GetStringValue(dr["username"]); decimal chkAmount = Utilities.GetDecimalValue(dr["checkamount"]); string depositDate = Utilities.GetDateTimeValue(dr["creationdate"]).FormatDate(); totalNumChecks++; totalCheckAmount += chkAmount; PdfPCell pCell = new PdfPCell(); pCell.Colspan = 1; pCell.HorizontalAlignment = Element.ALIGN_JUSTIFIED; pCell.Border = Rectangle.NO_BORDER; pCell.Phrase = new Phrase(makerName, RptFont); newtable.AddCell(pCell); pCell.Phrase = new Phrase(cdName, RptFont); newtable.AddCell(pCell); pCell.Phrase = new Phrase(depositDate, RptFont); newtable.AddCell(pCell); pCell.Phrase = new Phrase(String.Format("{0:n}", chkAmount), RptFont); pCell.HorizontalAlignment = Element.ALIGN_RIGHT; newtable.AddCell(pCell); } //Add a blank line before summary newtable.AddCell(generateBlankLine(8)); //Insert summary table PdfPCell newCell = new PdfPCell(new Paragraph("", RptFont)); newCell.HorizontalAlignment = Element.ALIGN_LEFT; newCell.Border = Rectangle.TOP_BORDER; newCell.Colspan = 4; newtable.AddCell(newCell); newCell.Colspan = 1; newCell.HorizontalAlignment = Element.ALIGN_LEFT; newCell.Border = Rectangle.NO_BORDER; newCell.Phrase = new Phrase("Count of all Checks", RptFont); newtable.AddCell(newCell); newCell.Phrase = new Phrase(totalNumChecks.ToString(), RptFont); newtable.AddCell(newCell); newCell.Phrase = new Phrase("Total Amount of all Checks:", RptFont); newtable.AddCell(newCell); newCell.Phrase = new Phrase(string.Format("{0:n}", totalCheckAmount), RptFont); newCell.HorizontalAlignment = Element.ALIGN_RIGHT; newtable.AddCell(newCell); newCell = new PdfPCell(new Paragraph("", RptFont)); newCell.HorizontalAlignment = Element.ALIGN_LEFT; newCell.Border = Rectangle.BOTTOM_BORDER; newCell.Colspan = 4; newtable.AddCell(newCell); document.Add(newtable); //Insert report footer PdfPTable finalSummaryTable = new PdfPTable(8); finalSummaryTable.TotalWidth = 500f; InsertReportFooter(ref finalSummaryTable); float yAbsolutePosition = newtable.CalculateHeights(true); finalSummaryTable.WriteSelectedRows(0, -1, document.LeftMargin + 30, yAbsolutePosition + 30, writer.DirectContent); document.Close(); //Print and save the document PrintDocument(); return(true); }
private static string exportAsPDF(string path, Event ev, User user, string logo) { string filename = "billet_" + ev.Name + "_" + user.Firstname + "_" + user.Lastname; PDF.Document doc = new PDF.Document(PDF.PageSize.A4, 20, 20, 42, 42); FileStream file = new FileStream(path + filename + ".pdf", FileMode.OpenOrCreate); PdfWriter pdf = PdfWriter.GetInstance(doc, file); doc.Open(); /* Réservation */ PDF.Paragraph par = new PDF.Paragraph("Réservation"); PDF.Paragraph ph = new PDF.Paragraph("Merci de votre réservation pour l'événement " + ev.Name); PDF.Paragraph ph2 = new PDF.Paragraph(user.Firstname + " " + user.Lastname); /* Logo */ PDF.Image logoBilleterie = PDF.Image.GetInstance(logo); logoBilleterie.ScalePercent(20.0f); /* QRcode */ PDF.Image qrcode = PDF.Image.GetInstance(QRCode.getImage(ev.Name + "(^_^)" + user.Id), PDF.BaseColor.WHITE); /* Receipt */ PdfPTable table2 = new PdfPTable(4); PdfPCell cell21 = new PdfPCell(); PdfPCell cell22 = new PdfPCell(); PdfPCell cell23 = new PdfPCell(); PdfPCell cell24 = new PdfPCell(); cell21.AddElement(new PDF.Paragraph("Billet")); cell22.AddElement(new PDF.Paragraph("Date de début")); cell23.AddElement(new PDF.Paragraph("Date de fin")); cell24.AddElement(new PDF.Paragraph("Prix")); table2.AddCell(cell21); table2.AddCell(cell22); table2.AddCell(cell23); table2.AddCell(cell24); PdfPCell cell31 = new PdfPCell(); PdfPCell cell32 = new PdfPCell(); PdfPCell cell33 = new PdfPCell(); PdfPCell cell34 = new PdfPCell(); Thread.CurrentThread.CurrentCulture = new CultureInfo("fr-FR"); float price_value = -1; string price_name = ""; try { object[] tmp = Database.Database.database.RequestLine("f_get_participant", 2, user.Id, ev.Name); price_name = (string)tmp[0]; price_value = (float)tmp[1]; } catch (Exception) { } cell31.AddElement(new PDF.Paragraph(price_name)); cell32.AddElement(new PDF.Paragraph(ev.Begin.ToShortDateString() + " " + ev.Begin.ToShortTimeString())); cell33.AddElement(new PDF.Paragraph(ev.End.ToShortDateString() + " " + ev.End.ToShortTimeString())); cell34.AddElement(new PDF.Paragraph(price_value.ToString("C"))); table2.AddCell(cell31); table2.AddCell(cell32); table2.AddCell(cell33); table2.AddCell(cell34); /* Add */ doc.Add(logoBilleterie); doc.Add(par); doc.Add(ph); doc.Add(ph2); doc.Add(qrcode); doc.Add(table2); doc.Close(); return(filename + ".pdf"); }
public void PDFESTADOCERO() { Buscadores bus = new Buscadores(); var doc = new iTextSharp.text.Document(PageSize.A4); string path = Server.MapPath("~"); PdfWriter writer = PdfWriter.GetInstance(doc, new FileStream(path + "/Taller.pdf", FileMode.Create)); doc.Open(); //Cabecera BaseFont bfntHead = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED); iTextSharp.text.Font fntHead = new iTextSharp.text.Font(bfntHead, 16, 1, iTextSharp.text.BaseColor.GREEN.Darker()); Paragraph prgHeading = new Paragraph(); prgHeading.Alignment = 1; prgHeading.Add(new Chunk("Taller de Reparaciones".ToUpper(), fntHead)); doc.Add(prgHeading); doc.Add(Chunk.NEWLINE); //Generado By Paragraph prgGeneratedBY = new Paragraph(); BaseFont btnAuthor = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED); iTextSharp.text.Font fntAuthor = new iTextSharp.text.Font(btnAuthor, 12, 2, iTextSharp.text.BaseColor.BLACK); prgGeneratedBY.Alignment = Element.ALIGN_RIGHT; prgGeneratedBY.Add(new Chunk("Generado por: " + LogEmpleado.nombreyapellido, fntAuthor)); //Agregar LOG Empleado prgGeneratedBY.Add(new Chunk("\nFecha : " + DateTime.Now.ToShortDateString(), fntAuthor)); prgGeneratedBY.Add(new Chunk("\nN° de Orden : " + OrdenActual.id_orden, fntAuthor)); doc.Add(prgGeneratedBY); Paragraph p = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 100.0F, iTextSharp.text.BaseColor.BLACK, Element.ALIGN_LEFT, 1))); doc.Add(p); //Espacio doc.Add(new Chunk("\n", fntHead)); //Datos Paragraph Datos = new Paragraph(); BaseFont bfntDatos = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED); iTextSharp.text.Font fntDatos = new iTextSharp.text.Font(bfntDatos, 12, 0, iTextSharp.text.BaseColor.BLACK); Datos.Alignment = Element.ALIGN_CENTER; Datos.Add(new Chunk("\nPatente: " + OrdenActual.vehiculo.patente + " Modelo:" + OrdenActual.vehiculo.modelo.nombre + " Marca: " + OrdenActual.vehiculo.modelo.marca.nombre, fntDatos)); doc.Add(Datos); //Espacio doc.Add(new Chunk("\n", fntHead)); foreach (servicio oservicio in LSUSO) { doc.Add(p); Paragraph Dato = new Paragraph(); Dato.Alignment = Element.ALIGN_LEFT; Dato.Add(new Chunk("\nServicio: " + oservicio.detalle, fntDatos)); doc.Add(Dato); //Espacio doc.Add(new Chunk("\n", fntHead)); //Creo una tabla DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[4] { new DataColumn("Codigo"), new DataColumn("Detalle"), new DataColumn("Marca"), new DataColumn("Cantidad") }); //nombre de las columnas List <stock> Lstock = bus.Lstockuso(oservicio.id_servicios.ToString()); foreach (stock ostock in Lstock) { dt.Rows.Add(ostock.codigo, ostock.detalle, ostock.marca, ostock.cantidad); //Agrego las filas a la tabla } //Tabla PdfPTable table = new PdfPTable(dt.Columns.Count); for (int i = 0; i < dt.Columns.Count; i++) { string cellText = Server.HtmlDecode(dt.Columns[i].ColumnName); PdfPCell cell = new PdfPCell(); cell.Phrase = new Phrase(cellText, new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.TIMES_ROMAN, 10, 1, new BaseColor(System.Drawing.ColorTranslator.FromHtml("#000000")))); cell.BackgroundColor = new BaseColor(System.Drawing.ColorTranslator.FromHtml("#C8C8C8")); cell.HorizontalAlignment = Element.ALIGN_CENTER; cell.PaddingBottom = 5; table.AddCell(cell); } for (int i = 0; i < dt.Rows.Count; i++) { for (int j = 0; j < dt.Columns.Count; j++) { table.AddCell(dt.Rows[i][j].ToString()); } } doc.Add(table); //Espacio doc.Add(new Chunk("\n", fntHead)); } doc.Close(); Page.ClientScript.RegisterStartupScript(this.GetType(), "OpenWindow", "window.open('Taller.pdf','_newtab');", true); }
private bool PrintMemo(ExtensionMemoInfo extnInfo) { try { //Set Font for the report rptFont = FontFactory.GetFont("Arial", 8, Font.NORMAL); rptFontBold = FontFactory.GetFont("Arial", 8, Font.BOLD); var rptFileName = RptObject.ReportTempFileFullName.Replace(".pdf", "_" + extnInfo.TicketNumber + ".pdf"); if (!string.IsNullOrEmpty(rptFileName)) { document = new Document(PageSize.HALFLETTER.Rotate()); document.AddTitle(RptObject.ReportTitle); const int mainTableColumns = 6; var writer = PdfWriter.GetInstance(document, new FileStream(rptFileName, FileMode.Create)); var mainTable = new PdfPTable(mainTableColumns) { WidthPercentage = 100 }; //Insert the report header var headerTable = new PdfPTable(5); BuildReportHeaderTable(headerTable, extnInfo); mainTable.AddCell(new PdfPCell(headerTable) { Colspan = mainTableColumns, Border = Rectangle.NO_BORDER }); mainTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER, Colspan = mainTableColumns }); // empty row //Set number of header rows mainTable.HeaderRows = 0; document.Open(); var topDataTable = new PdfPTable(5) { WidthPercentage = 100 }; topDataTable.AddCell(new PdfPCell(new Paragraph("Previous Maturity Date :", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); topDataTable.AddCell(new PdfPCell(new Paragraph(extnInfo.DueDate.FormatDate(), rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); topDataTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER }); topDataTable.AddCell(new PdfPCell(new Paragraph("New Maturity Date :", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT }); topDataTable.AddCell(new PdfPCell(new Paragraph(extnInfo.NewDueDate.FormatDate(), rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT }); topDataTable.AddCell(new PdfPCell(new Paragraph("Previous Default Date :", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); topDataTable.AddCell(new PdfPCell(new Paragraph(extnInfo.OldPfiEligible.FormatDate(), rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); topDataTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER }); topDataTable.AddCell(new PdfPCell(new Paragraph("Last Day of Grace :", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT }); topDataTable.AddCell(new PdfPCell(new Paragraph(extnInfo.NewPfiEligible.FormatDate(), rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT }); topDataTable.AddCell(new PdfPCell(new Paragraph("Pawn Charge Paid Today :", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); topDataTable.AddCell(new PdfPCell(new Paragraph(extnInfo.ExtensionAmount.ToString("c"), rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); topDataTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER }); topDataTable.AddCell(new PdfPCell(new Paragraph("Pawn Charge Paid to :", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT }); topDataTable.AddCell(new PdfPCell(new Paragraph(extnInfo.DueDate.FormatDate(), rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT }); mainTable.AddCell(new PdfPCell(topDataTable) { Colspan = mainTableColumns, Border = Rectangle.NO_BORDER }); mainTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER, Colspan = mainTableColumns, FixedHeight = 10 }); // empty row var bottomDataTable = new PdfPTable(5) { WidthPercentage = 100 }; bottomDataTable.AddCell(new PdfPCell(new Paragraph("AMOUNTS DUE AT MATURITY DATE", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT, Colspan = 2 }); bottomDataTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER }); bottomDataTable.AddCell(new PdfPCell(new Paragraph("AMOUNTS DUE ON LAST DAY TO REDEEM", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT, Colspan = 2 }); bottomDataTable.AddCell(new PdfPCell(new Paragraph("Amount Financed :", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); bottomDataTable.AddCell(new PdfPCell(new Paragraph(extnInfo.Amount.ToString("c"), rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); bottomDataTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER }); bottomDataTable.AddCell(new PdfPCell(new Paragraph("Amount Financed :", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT }); bottomDataTable.AddCell(new PdfPCell(new Paragraph(extnInfo.Amount.ToString("c"), rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT }); if (GlobalDataAccessor.Instance.CurrentSiteId.State.Equals(States.Ohio)) { bottomDataTable.AddCell(new PdfPCell(new Paragraph("Pawn Charge :", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); bottomDataTable.AddCell(new PdfPCell(new Paragraph((extnInfo.InterestAmount + extnInfo.Fees).ToString("c"), rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); bottomDataTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER }); bottomDataTable.AddCell(new PdfPCell(new Paragraph("Pawn Charge :", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT }); bottomDataTable.AddCell(new PdfPCell(new Paragraph(((extnInfo.InterestAmount + extnInfo.Fees) * extnInfo.ExtendedBy).ToString("c"), rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT }); bottomDataTable.AddCell(new PdfPCell(new Paragraph("**TOTAL** :", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); bottomDataTable.AddCell(new PdfPCell(new Paragraph((extnInfo.Amount + extnInfo.InterestAmount + extnInfo.Fees).ToString("c"), rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); bottomDataTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER }); bottomDataTable.AddCell(new PdfPCell(new Paragraph("**TOTAL** :", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT }); bottomDataTable.AddCell(new PdfPCell(new Paragraph((extnInfo.Amount + ((extnInfo.InterestAmount + extnInfo.Fees) * extnInfo.ExtendedBy)).ToString("c"), rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT }); mainTable.AddCell(new PdfPCell(bottomDataTable) { Colspan = mainTableColumns, Border = Rectangle.NO_BORDER }); mainTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER, Colspan = mainTableColumns }); // empty row } else { //Indiana bottomDataTable.AddCell(new PdfPCell(new Paragraph("Pawn Charge :", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); bottomDataTable.AddCell(new PdfPCell(new Paragraph((extnInfo.InterestAmount + extnInfo.Fees).ToString("c"), rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); bottomDataTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER }); bottomDataTable.AddCell(new PdfPCell(new Paragraph("Pawn Charge :", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT }); bottomDataTable.AddCell(new PdfPCell(new Paragraph(((extnInfo.InterestAmount + extnInfo.Fees) * extnInfo.ExtendedBy).ToString("c"), rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT }); bottomDataTable.AddCell(new PdfPCell(new Paragraph("**TOTAL** :", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); bottomDataTable.AddCell(new PdfPCell(new Paragraph((extnInfo.Amount + extnInfo.InterestAmount + extnInfo.Fees).ToString("c"), rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); bottomDataTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER }); bottomDataTable.AddCell(new PdfPCell(new Paragraph("**TOTAL** :", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT }); bottomDataTable.AddCell(new PdfPCell(new Paragraph((extnInfo.Amount + ((extnInfo.InterestAmount + extnInfo.Fees) * extnInfo.ExtendedBy)).ToString("c"), rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT }); mainTable.AddCell(new PdfPCell(bottomDataTable) { Colspan = mainTableColumns, Border = Rectangle.NO_BORDER }); mainTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER, Colspan = mainTableColumns }); // empty row } if (GlobalDataAccessor.Instance.CurrentSiteId.State.Equals(States.Ohio)) { mainTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER, Colspan = mainTableColumns }); mainTable.AddCell(new PdfPCell(new Paragraph("IF THE PLEDGOR FAILS TO REDEEM OR EXTEND THE LOAN BEFORE THE", rptFontBold)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_CENTER, Colspan = mainTableColumns }); mainTable.AddCell(new PdfPCell(new Paragraph("CLOSE OF BUSINESS ON THE LAST DAY OF GRACE, THE LICENSEE BECOMES THE OWNER", rptFontBold)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_CENTER, Colspan = mainTableColumns }); mainTable.AddCell(new PdfPCell(new Paragraph("OF THE PLEDGED PROPERTY.", rptFontBold)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_CENTER, Colspan = mainTableColumns }); mainTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER, Colspan = mainTableColumns }); // empty row } else { //Indiana mainTable.AddCell(new PdfPCell(new Paragraph("Daily Rate of Pawn Charge Accrual If Redeemed After Maturity:", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT, Colspan = 3 }); mainTable.AddCell(new PdfPCell(new Paragraph((extnInfo.DailyAmount).ToString("c"), rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); mainTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER, Colspan = mainTableColumns }); // empty row mainTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER, Colspan = mainTableColumns }); mainTable.AddCell(new PdfPCell(new Paragraph("UNREDEEMED PLEDGED GOODS MUST BE HELD BY PAWNBROKER FOR SIXTY (60 DAYS", rptFontBold)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_CENTER, Colspan = mainTableColumns }); mainTable.AddCell(new PdfPCell(new Paragraph("(NOT NECESSARILY TWO (2) MONTHS FROM NEW MATURITY DATE.", rptFontBold)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_CENTER, Colspan = mainTableColumns }); mainTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER, Colspan = mainTableColumns }); // empty row } if (GlobalDataAccessor.Instance.CurrentSiteId.State.Equals(States.Ohio)) { mainTable.AddCell(new PdfPCell(new Paragraph("Last Day Of Grace :", rptFontBold)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT, Colspan = mainTableColumns / 2 }); mainTable.AddCell(new PdfPCell(new Paragraph(extnInfo.NewPfiEligible.FormatDate(), rptFontBold)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT, Colspan = mainTableColumns / 2 }); mainTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER, Colspan = mainTableColumns, FixedHeight = 20 }); // empty row } mainTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER, Colspan = mainTableColumns }); mainTable.AddCell(new PdfPCell(new Paragraph("Pledger :", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); mainTable.AddCell(new PdfPCell(new Paragraph(extnInfo.CustomerName, rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); mainTable.AddCell(new PdfPCell(new Paragraph(new Phrase())) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT }); mainTable.AddCell(new PdfPCell(new Paragraph("_________________________________________", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT, Colspan = 3 }); mainTable.AddCell(new PdfPCell(new Paragraph(new Phrase())) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT, Colspan = 3 }); mainTable.AddCell(new PdfPCell(new Paragraph("Pledger", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT, Colspan = 3 }); mainTable.AddCell(new PdfPCell(new Phrase()) { Border = Rectangle.NO_BORDER, Colspan = mainTableColumns, FixedHeight = 20 }); // empty row mainTable.AddCell(new PdfPCell(new Paragraph("PAWNBROKER:", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_CENTER, Colspan = mainTableColumns }); mainTable.AddCell(new PdfPCell(new Paragraph("Prepare in duplicate; original to Pledgor; second copy for store file.", rptFont)) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_CENTER, Colspan = mainTableColumns }); document.Add(mainTable); document.Close(); AddDocument(extnInfo, rptFileName); return(true); } FileLogger.Instance.logMessage(LogLevel.ERROR, this, "Extension memo printing failed since file name is not set"); return(false); } catch (Exception de) { FileLogger.Instance.logMessage(LogLevel.ERROR, this, "Extension memo printing" + de.Message); return(false); } }
public JsonResult AddPdfByHtml(string CoANo, string Html, string titles, string CASNo, string Specification) { titles = titles.Substring(0, titles.Length - 1); Specification = Specification.Substring(0, Specification.Length - 1); ChemCloud_COA model = Newtonsoft.Json.JsonConvert.DeserializeObject <ChemCloud_COA>(Html); List <string> titlelist = titles.Split(';').ToList <string>(); List <string> SpecificationList = Specification.Split(';').ToList <string>(); string serverFilepath = Server.MapPath(string.Format("/Storage/PDF/{0}/ ", base.CurrentUser.Id)); if (!System.IO.Directory.Exists(serverFilepath)) { System.IO.Directory.CreateDirectory(serverFilepath); } string serverFileName = "CoAReports" + DateTime.Now.ToString("yyyyMMddHHmmssffff") + ".pdf"; Result res = new Result(); iTextSharp.text.Document document = new iTextSharp.text.Document(PageSize.A4); try { iTextSharp.text.pdf.PdfWriter.GetInstance(document, new FileStream(serverFilepath + serverFileName, FileMode.Create)); document.Open(); iTextSharp.text.pdf.BaseFont bfChinese = iTextSharp.text.pdf.BaseFont.CreateFont("C:\\WINDOWS\\Fonts\\simsun.ttc,1", iTextSharp.text.pdf.BaseFont.IDENTITY_H, iTextSharp.text.pdf.BaseFont.NOT_EMBEDDED); iTextSharp.text.Font Titlefont = new iTextSharp.text.Font(bfChinese, 16, iTextSharp.text.Font.BOLD); iTextSharp.text.Font titleDetial = new iTextSharp.text.Font(bfChinese, 11, iTextSharp.text.Font.BOLD); iTextSharp.text.Font normall = new iTextSharp.text.Font(bfChinese, 11, iTextSharp.text.Font.NORMAL); iTextSharp.text.Font newtable = new iTextSharp.text.Font(bfChinese, 12, iTextSharp.text.Font.BOLD); iTextSharp.text.Font newtableInner = new iTextSharp.text.Font(bfChinese, 12, iTextSharp.text.Font.NORMAL); Paragraph p = new Paragraph("CERTIFICATE OF ANALYSIS" + "\n\n", Titlefont); p.Alignment = iTextSharp.text.Element.ALIGN_CENTER; document.Add(p); PdfPTable table = new PdfPTable(4); table.DefaultCell.MinimumHeight = 30; table.SetWidths(new int[] { 35, 15, 35, 15 }); PdfPCell cell; cell = new PdfPCell(); Paragraph pCell; pCell = new Paragraph("CertificateNumber", titleDetial); table.AddCell(pCell); pCell = new Paragraph(model.CertificateNumber, normall); table.AddCell(pCell); pCell = new Paragraph("Suppiler", titleDetial); table.AddCell(pCell); pCell = new Paragraph(ServiceHelper.Create <IShopService>().GetShopName(base.CurrentSellerManager.ShopId), normall); table.AddCell(pCell); cell = new PdfPCell(); pCell = new Paragraph("Product Code", titleDetial); table.AddCell(pCell); pCell = new Paragraph(model.ProductCode, normall); table.AddCell(pCell); pCell = new Paragraph("Manufacturer's Batch #", titleDetial); table.AddCell(pCell); pCell = new Paragraph(model.ManufacturersBatchNo, normall); table.AddCell(pCell); cell = new PdfPCell(); pCell = new Paragraph("Product", titleDetial); table.AddCell(pCell); pCell = new Paragraph(model.ProductName, normall); table.AddCell(pCell); pCell = new Paragraph("Sydco's Lab.Batch #", titleDetial); table.AddCell(pCell); pCell = new Paragraph(model.SydcosLabBatchNo, normall); table.AddCell(pCell); cell = new PdfPCell(); pCell = new Paragraph("Date of Manufacture", titleDetial); table.AddCell(pCell); pCell = new Paragraph(model.DateofManufacture.ToShortDateString(), normall); table.AddCell(pCell); pCell = new Paragraph("ExpiryDate", titleDetial); table.AddCell(pCell); pCell = new Paragraph(model.ExpiryDate.ToShortDateString(), normall); table.AddCell(pCell); document.Add(table); Paragraph pfoot = new Paragraph("\n The undersigned hereby certifies the following data to be true specification" + "\n\n\n\n\n", titleDetial); p.Alignment = iTextSharp.text.Element.ALIGN_CENTER; document.Add(pfoot); foreach (ChemCloud_COADetails item in model.ChemCloud_COADetails) { PdfPTable table1 = new PdfPTable(3); table1.DefaultCell.MinimumHeight = 30; table1.SetWidths(new int[] { 40, 20, 35 }); pCell = new Paragraph("Tests", newtable); table1.AddCell(pCell); pCell = new Paragraph("Results", newtable); table1.AddCell(pCell); pCell = new Paragraph("Specifications(BP)", newtable); table1.AddCell(pCell); pCell = new Paragraph(titlelist[0], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(item.Appearance, newtableInner); table1.AddCell(pCell); pCell = new Paragraph(SpecificationList[0], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(titlelist[1], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(item.IIdentity, newtableInner); table1.AddCell(pCell); pCell = new Paragraph(SpecificationList[1], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(titlelist[2], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(item.Carbonates, newtableInner); table1.AddCell(pCell); pCell = new Paragraph(SpecificationList[2], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(titlelist[3], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(item.Solubility, newtableInner); table1.AddCell(pCell); pCell = new Paragraph(SpecificationList[3], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(titlelist[4], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(item.Ammonium, newtableInner); table1.AddCell(pCell); pCell = new Paragraph(SpecificationList[4], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(titlelist[5], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(item.Calcium, newtableInner); table1.AddCell(pCell); pCell = new Paragraph(SpecificationList[5], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(titlelist[6], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(item.Arsenic, newtableInner); table1.AddCell(pCell); pCell = new Paragraph(SpecificationList[6], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(titlelist[7], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(item.HeavyMetals, newtableInner); table1.AddCell(pCell); pCell = new Paragraph(SpecificationList[7], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(titlelist[8], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(item.Iron, newtableInner); table1.AddCell(pCell); pCell = new Paragraph(SpecificationList[8], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(titlelist[9], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(item.Sulphates, newtableInner); table1.AddCell(pCell); pCell = new Paragraph(SpecificationList[9], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(titlelist[10], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(item.Chlorides, newtableInner); table1.AddCell(pCell); pCell = new Paragraph(SpecificationList[10], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(titlelist[11], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(item.Appearanceofsolution, newtableInner); table1.AddCell(pCell); pCell = new Paragraph(SpecificationList[11], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(titlelist[12], newtableInner); table1.AddCell(pCell); pCell = new Paragraph(item.MicroStatus, newtableInner); table1.AddCell(pCell); pCell = new Paragraph(SpecificationList[12], newtableInner); table1.AddCell(pCell); document.Add(table1); Paragraph ppp = new Paragraph("\n\n\n\n\n\n", titleDetial); ppp.Alignment = iTextSharp.text.Element.ALIGN_CENTER; document.Add(ppp); } } catch (Exception de) { res.success = false; return(Json(res)); } document.Close(); res.success = true; //string pdfpath1 = string.Format("/Storage/PDF/{0}/", base.CurrentUser.Id); string str = ImgHelper.PostImg(serverFilepath + serverFileName, "coapic"); COAList cr = new COAList() { Addtime = DateTime.Now, CoANo = CoANo, URL = str, UserId = base.CurrentUser.Id, AddUserType = 2, CASNo = CASNo }; ServiceHelper.Create <ICOAListService>().AddCoAReportInfo(cr); return(Json(res)); }
private void ToolStripButton8_Click(object sender, EventArgs e) { SaveFileDialog s = new SaveFileDialog { Filter = "pdf files (*.pdf)|*.pdf|All files (*.*)|*.*" }; string path = ""; if (s.ShowDialog() == DialogResult.OK) { path = s.FileName; } try { MySqlDataAdapter mda = new MySqlDataAdapter("SELECT Orders.Order_id, Service_type.Type_name, Services.Service_name, Orders.Order_date, Orders.Price, Status.Status_name FROM Orders INNER JOIN Services on(Services.Service_id=Orders.Service_id) INNER JOIN Service_type on(Services.Type_id=Service_type.Type_id) INNER JOIN Status on(Status.Status_id=Orders.Status_id) WHERE Orders.Worker_id=" + Id + " " + Search + ";", conn); DataSet ds = new DataSet(); mda.Fill(ds, "Orders"); iTextSharp.text.Document doc = new iTextSharp.text.Document(); PdfWriter.GetInstance(doc, new FileStream(path, FileMode.Create)); doc.Open(); BaseFont baseFont = BaseFont.CreateFont("C:\\Windows\\Fonts\\arial.ttf", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED); iTextSharp.text.Font font = new iTextSharp.text.Font(baseFont, iTextSharp.text.Font.DEFAULTSIZE, iTextSharp.text.Font.NORMAL); PdfPTable table = new PdfPTable(ds.Tables["Orders"].Columns.Count); PdfPCell cell = new PdfPCell(new Phrase(" " + "Orders" + " ", font)) { Colspan = ds.Tables["Orders"].Columns.Count, HorizontalAlignment = PdfPCell.ALIGN_CENTER, Border = 0 }; table.AddCell(cell); for (int j = 0; j < dataGridView1.ColumnCount; j++) { cell = new PdfPCell(new Phrase(new Phrase(dataGridView1.Columns[j].HeaderText, font))) { BackgroundColor = iTextSharp.text.BaseColor.LIGHT_GRAY }; table.AddCell(cell); } for (int j = 0; j < ds.Tables["Orders"].Rows.Count; j++) { for (int k = 0; k < ds.Tables["Orders"].Columns.Count; k++) { table.AddCell(new Phrase(ds.Tables["Orders"].Rows[j][k].ToString(), font)); } } doc.Add(table); doc.Close(); MessageBox.Show("Pdf-document saved!"); } catch (Exception) { MessageBox.Show("Problems with saving to PDF format!"); } }
public void getClentOrderList(ReportBindingModel model, int clientId) { if (!File.Exists("TIMCYR.TTF")) { File.WriteAllBytes("TIMCYR.TTF", Properties.Resources.TIMCYR); } //открываем файл для работы FileStream fs = new FileStream(model.FileName, FileMode.OpenOrCreate, FileAccess.Write); //создаем документ, задаем границы, связываем документ и поток iTextSharp.text.Document doc = new iTextSharp.text.Document(); doc.SetMargins(0.5f, 0.5f, 0.5f, 0.5f); PdfWriter writer = PdfWriter.GetInstance(doc, fs); doc.Open(); BaseFont baseFont = BaseFont.CreateFont("TIMCYR.TTF", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED); //вставляем заголовок var phraseTitle = new Phrase("Заказы клиента", new iTextSharp.text.Font(baseFont, 16, iTextSharp.text.Font.BOLD)); iTextSharp.text.Paragraph paragraph = new iTextSharp.text.Paragraph(phraseTitle) { Alignment = Element.ALIGN_CENTER, SpacingAfter = 12 }; doc.Add(paragraph); var phrasePeriod = new Phrase("c " + model.DateFrom.Value.ToShortDateString() + " по " + model.DateTo.Value.ToShortDateString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.BOLD)); paragraph = new iTextSharp.text.Paragraph(phrasePeriod) { Alignment = Element.ALIGN_CENTER, SpacingAfter = 12 }; doc.Add(paragraph); //вставляем таблицу, задаем количество столбцов, и ширину колонок PdfPTable table = new PdfPTable(6) { TotalWidth = 800F }; table.SetTotalWidth(new float[] { 160, 140, 160, 100, 100, 140 }); //вставляем шапку PdfPCell cell = new PdfPCell(); var fontForCellBold = new iTextSharp.text.Font(baseFont, 10, iTextSharp.text.Font.BOLD); table.AddCell(new PdfPCell(new Phrase("ФИО клиента", fontForCellBold)) { HorizontalAlignment = Element.ALIGN_CENTER }); table.AddCell(new PdfPCell(new Phrase("Дата создания", fontForCellBold)) { HorizontalAlignment = Element.ALIGN_CENTER }); table.AddCell(new PdfPCell(new Phrase("Изделие", fontForCellBold)) { HorizontalAlignment = Element.ALIGN_CENTER }); table.AddCell(new PdfPCell(new Phrase("Количество", fontForCellBold)) { HorizontalAlignment = Element.ALIGN_CENTER }); table.AddCell(new PdfPCell(new Phrase("Сумма", fontForCellBold)) { HorizontalAlignment = Element.ALIGN_CENTER }); table.AddCell(new PdfPCell(new Phrase("Статус", fontForCellBold)) { HorizontalAlignment = Element.ALIGN_CENTER }); //заполняем таблицу var list = context.Orders.Where(o => o.ClientId == clientId).Select(o => new OrderViewModel { Id = o.Id, ClientId = o.ClientId, Sum = o.Sum, Reserved = o.Reserved, Status = o.Status.ToString(), DateCreate = SqlFunctions.DateName("dd", o.DateCreate) + " " + SqlFunctions.DateName("mm", o.DateCreate) + " " + SqlFunctions.DateName("yyyy", o.DateCreate) }).ToList(); iTextSharp.text.Font fontForCells = new iTextSharp.text.Font(baseFont, 10); foreach (var order in list) { foreach (var op in context.OrderProducts.Where(op => op.OrderId == order.Id)) { cell = new PdfPCell(new Phrase(context.Clients.First(c => c.Id == order.ClientId).Name, fontForCells)); table.AddCell(cell); cell = new PdfPCell(new Phrase(order.DateCreate, fontForCells)); table.AddCell(cell); cell = new PdfPCell(new Phrase(context.Products.First(p => p.Id == op.ProductId).Name, fontForCells)); table.AddCell(cell); cell = new PdfPCell(new Phrase(op.Count.ToString(), fontForCells)); cell.HorizontalAlignment = Element.ALIGN_RIGHT; table.AddCell(cell); cell = new PdfPCell(new Phrase((context.Products.First(p => p.Id == op.ProductId).Price *op.Count).ToString(), fontForCells)); cell.HorizontalAlignment = Element.ALIGN_RIGHT; table.AddCell(cell); cell = new PdfPCell(new Phrase(order.Status, fontForCells)); table.AddCell(cell); } } //вставляем итого cell = new PdfPCell(new Phrase("Итого:", fontForCellBold)) { HorizontalAlignment = Element.ALIGN_RIGHT, Colspan = 4, Border = 0 }; table.AddCell(cell); cell = new PdfPCell(new Phrase(list.Sum(rec => rec.Sum).ToString(), fontForCellBold)) { HorizontalAlignment = Element.ALIGN_RIGHT, Border = 0 }; table.AddCell(cell); cell = new PdfPCell(new Phrase("", fontForCellBold)) { Border = 0 }; table.AddCell(cell); //вставляем таблицу doc.Add(table); doc.Close(); SendEmail(model.Email, "Оповещение по заказам", "", model.FileName); }
public void End() { document.Close(); }
public void GenerateReport(List <ISimulationObject> objects, string format, Stream ms) { string ptext = ""; switch (format) { case "PDF": iTextSharp.text.Document document = new iTextSharp.text.Document(PageSize.A4, 25, 25, 30, 30); var writer = iTextSharp.text.pdf.PdfWriter.GetInstance(document, ms); var bf = iTextSharp.text.pdf.BaseFont.CreateFont(iTextSharp.text.pdf.BaseFont.COURIER, iTextSharp.text.pdf.BaseFont.CP1252, true); var regfont = new Font(bf, 12, Font.NORMAL); var boldfont = new Font(bf, 12, Font.BOLD); document.Open(); document.Add(new Paragraph("DWSIM Simulation Results Report", boldfont)); document.Add(new Paragraph("Simulation Name: " + Options.SimulationName, boldfont)); document.Add(new Paragraph("Date created: " + System.DateTime.Now.ToString() + "\n\n", boldfont)); foreach (var obj in objects) { ptext = obj.GetDisplayName() + ": " + obj.GraphicObject.Tag + "\n\n"; document.Add(new Paragraph(ptext, boldfont)); ptext = obj.GetReport(Options.SelectedUnitSystem, System.Globalization.CultureInfo.CurrentCulture, Options.NumberFormat); ptext += "\n"; document.Add(new Paragraph(ptext, regfont)); } document.Close(); writer.Close(); break; case "TXT": string report = ""; report += "DWSIM Simulation Results Report\nSimulation Name: " + Options.SimulationName + "\nDate created: " + System.DateTime.Now.ToString() + "\n\n"; foreach (var obj in objects) { ptext = ""; ptext += obj.GetDisplayName() + ": " + obj.GraphicObject.Tag + "\n\n"; ptext += obj.GetReport(Options.SelectedUnitSystem, System.Globalization.CultureInfo.CurrentCulture, Options.NumberFormat); ptext += "\n"; report += ptext; } using (StreamWriter wr = new StreamWriter(ms)) { wr.Write(report); } break; default: throw new NotImplementedException("Sorry, this feature is not yet available."); } }
private void Button_Click(object sender, RoutedEventArgs e) //Sauvgarder le profile topographique en pdf { RenderTargetBitmap rtb = new RenderTargetBitmap((int)chart.ActualWidth, (int)chart.ActualHeight, 96, 96, PixelFormats.Pbgra32); rtb.Render(visual: chart); PngBitmapEncoder png = new PngBitmapEncoder(); png.Frames.Add(BitmapFrame.Create(rtb)); MemoryStream stream = new MemoryStream(); png.Save(stream); SaveToPng(chart, "MyChart.png"); //le nom de l'image iTextSharp.text.Document doc = new iTextSharp.text.Document(iTextSharp.text.PageSize.A3, 10, 40, 42, 35); //les dimensions du fichier pdf Microsoft.Win32.SaveFileDialog dlg = new Microsoft.Win32.SaveFileDialog(); dlg.FileName = "Document"; // Default file name dlg.DefaultExt = ".pdf"; // Default file extension //dlg.Filter = "Text documents (.topo)|*.topo"; // Filter files by extension // Show open file dialog box Nullable <bool> result = dlg.ShowDialog(); // Process open file dialog box results string filename = null; if (result == true) { // Open document filename = dlg.FileName; } try { PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream(filename, FileMode.Create)); } catch (ArgumentNullException excp) { MessageBox.Show("il faut specifier un fichier pdf"); //le cas de ne pas selectioner un fichier } //L'exportation en pdf doc.Open(); iTextSharp.text.Image jpg = iTextSharp.text.Image.GetInstance("./MyChart.PNG"); jpg.Border = iTextSharp.text.Rectangle.BOX; jpg.BorderWidth = 5f; doc.Add(jpg); iTextSharp.text.Paragraph paragraph = new iTextSharp.text.Paragraph(); paragraph.Font = new Font(FontFactory.GetFont("Arial", 16, Font.BOLD)); paragraph.Alignment = Element.ALIGN_CENTER;//here is the change paragraph.Add("Profile Topographique"); doc.Add(paragraph); Viewbox viewbox = new Viewbox(); //Ajuster la photo dans un cadre doc.Close(); Export.IsEnabled = false; //desactivation du button de l'exportation }
public static string test(string path, string filename) { PDF.Document doc = new PDF.Document(PDF.PageSize.A4, 20, 20, 42, 42); FileStream file = new FileStream(path + filename, FileMode.OpenOrCreate); PdfWriter pdf = PdfWriter.GetInstance(doc, file); doc.Open(); /* LOGO BILLET */ PDF.Image logoBilleterie = PDF.Image.GetInstance("~/Content/logo_bg1.png"); logoBilleterie.ScalePercent(20.0f); PdfPTable table1 = new PdfPTable(2); table1.DefaultCell.Border = 0; table1.WidthPercentage = 80; PdfPCell cell11 = new PdfPCell(); cell11.Colspan = 1; cell11.AddElement(new PDF.Paragraph("ABC Traders Receipt")); cell11.AddElement(new PDF.Paragraph("Thankyou for shoping at ABC traders,your order details are below")); cell11.VerticalAlignment = PDF.Element.ALIGN_LEFT; PdfPCell cell12 = new PdfPCell(); cell12.VerticalAlignment = PDF.Element.ALIGN_CENTER; table1.AddCell(cell11); table1.AddCell(cell12); PdfPTable table2 = new PdfPTable(3); //One row added PdfPCell cell21 = new PdfPCell(); cell21.AddElement(new PDF.Paragraph("Photo Type")); PdfPCell cell22 = new PdfPCell(); cell22.AddElement(new PDF.Paragraph("No. of Copies")); PdfPCell cell23 = new PdfPCell(); cell23.AddElement(new PDF.Paragraph("Amount")); table2.AddCell(cell21); table2.AddCell(cell22); table2.AddCell(cell23); //New Row Added PdfPCell cell31 = new PdfPCell(); cell31.AddElement(new PDF.Paragraph("Safe")); cell31.FixedHeight = 300.0f; PdfPCell cell32 = new PdfPCell(); cell32.AddElement(new PDF.Paragraph("2")); cell32.FixedHeight = 300.0f; PdfPCell cell33 = new PdfPCell(); cell33.AddElement(new PDF.Paragraph("20.00 * " + "2" + " = " + (20 * Convert.ToInt32("2")) + ".00")); cell33.FixedHeight = 300.0f; table2.AddCell(cell31); table2.AddCell(cell32); table2.AddCell(cell33); PdfPCell cell2A = new PdfPCell(table2); cell2A.Colspan = 2; table1.AddCell(cell2A); PdfPCell cell41 = new PdfPCell(); cell41.AddElement(new PDF.Paragraph("Name : " + "ABC")); cell41.AddElement(new PDF.Paragraph("Advance : " + "advance")); cell41.VerticalAlignment = PDF.Element.ALIGN_LEFT; PdfPCell cell42 = new PdfPCell(); cell42.AddElement(new PDF.Paragraph("Customer ID : " + "011")); cell42.AddElement(new PDF.Paragraph("Balance : " + "3993")); cell42.VerticalAlignment = PDF.Element.ALIGN_RIGHT; table1.AddCell(cell41); table1.AddCell(cell42); doc.Add(table1); doc.Close(); return(filename); }
private void button5_Click(object sender, EventArgs e) { if (dataGridView1.Rows.Count == 0) { MessageBox.Show("Search Data & Try Again.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { var pgSize = new iTextSharp.text.Rectangle(841, 594); var doc = new iTextSharp.text.Document(pgSize, 22, 22, 22, 22); PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream(System.AppDomain.CurrentDomain.BaseDirectory.ToString() + "\\Documents\\Account Report" + DateTime.Now.Date.ToString("ddMMyyyy") + ".pdf", FileMode.Create)); MessageBox.Show("Your Document Is Ready To Be Printed. Press OK Button.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); doc.Open(); iTextSharp.text.Image headerImage = iTextSharp.text.Image.GetInstance("logo.jpg"); headerImage.ScalePercent(16f); headerImage.SetAbsolutePosition(doc.PageSize.Width - 510f - 22f, doc.PageSize.Height - 30f - 16f); //doc.Add(headerImage); iTextSharp.text.Font fontTitle = FontFactory.GetFont("Arial", 16, iTextSharp.text.Font.NORMAL, BaseColor.BLACK); Paragraph title = new Paragraph(shopName, fontTitle); title.Alignment = Element.ALIGN_CENTER; doc.Add(title); iTextSharp.text.Font fontAddress = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.NORMAL, BaseColor.BLACK); Paragraph address = new Paragraph(shopAddress, fontAddress); address.Alignment = Element.ALIGN_CENTER; doc.Add(address); iTextSharp.text.Font fontTable3 = FontFactory.GetFont("Times New Roman", 8, iTextSharp.text.Font.NORMAL, BaseColor.BLACK); PdfPTable tableInfo = new PdfPTable(3); tableInfo.SpacingBefore = 16f; tableInfo.WidthPercentage = 100; PdfPCell cell = new PdfPCell(new Phrase("Account Report")); cell.Colspan = 3; cell.HorizontalAlignment = 1; cell.BackgroundColor = BaseColor.LIGHT_GRAY; tableInfo.AddCell(cell); tableInfo.AddCell(new Phrase("Time: " + DateTime.Now.ToString("hh:mm:ss tt"), fontTable3)); tableInfo.AddCell(new Phrase("Date: " + DateTime.Now.ToString("dd/MM/yyyy"), fontTable3)); tableInfo.AddCell(new Phrase("Printed By: " + realName, fontTable3)); tableInfo.AddCell(new Phrase("Search By: " + comboBoxSearchBy.Text, fontTable3)); tableInfo.AddCell(new Phrase("Query: " + textBoxQuery.Text, fontTable3)); tableInfo.AddCell(new Phrase("Date Period: Not Applicable", fontTable3)); tableInfo.AddCell(new Phrase("Total Account: " + labelTotalAccount.Text, fontTable3)); tableInfo.AddCell(new Phrase("Total Balance: " + labelTotalBalance.Text, fontTable3)); tableInfo.AddCell(new Phrase("Total Price: Not Applicable", fontTable3)); doc.Add(tableInfo); iTextSharp.text.Font fontTable = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.NORMAL, BaseColor.BLACK); PdfPTable table = new PdfPTable(dataGridView1.Columns.Count - 1); table.SpacingBefore = 2f; table.WidthPercentage = 100; table.HorizontalAlignment = Element.ALIGN_CENTER; for (int j = 1; j < dataGridView1.Columns.Count; j++) { table.AddCell(new Phrase(dataGridView1.Columns[j].HeaderText, fontTable)); } table.HeaderRows = 1; for (int i = 0; i < dataGridView1.Rows.Count; i++) { for (int k = 1; k < dataGridView1.Columns.Count; k++) { if (dataGridView1[k, i].Value != null) { table.AddCell(new Phrase(dataGridView1[k, i].Value.ToString(), fontTable)); } } } doc.Add(table); iTextSharp.text.Font footerFont = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.NORMAL, BaseColor.BLACK); Paragraph footer = new Paragraph("", footerFont); footer.SpacingBefore = 20f; footer.Alignment = Element.ALIGN_RIGHT; doc.Add(footer); doc.Close(); System.Diagnostics.Process.Start(System.AppDomain.CurrentDomain.BaseDirectory.ToString() + "\\Documents\\Account Report" + DateTime.Now.Date.ToString("ddMMyyyy") + ".pdf"); } }
private void button1_Click(object sender, EventArgs e) { int AA; button1.Enabled = true; if (TotalPriceLib.Text != "0" || Total_in_Cafe.Text != "0") { double a; string first1 = TotalPriceLib.Text; string second1 = Total_in_Cafe.Text; double.TryParse(second1, out double secondD); double.TryParse(first1, out double firstD); a = firstD + secondD; TotalTotalLbl.Text = a.ToString(); using (SaveFileDialog sfd = new SaveFileDialog() { Filter = "PDF file|.pdf", ValidateNames = true }) { if (sfd.ShowDialog() == DialogResult.OK) { iTextSharp.text.Document doc = new iTextSharp.text.Document(PageSize.A4.Rotate()); try { PdfWriter.GetInstance(doc, new FileStream(sfd.FileName, FileMode.OpenOrCreate)); doc.Open(); doc.Add(new iTextSharp.text.Paragraph("Total price : \n")); doc.Add(new iTextSharp.text.Paragraph(TotalTotalLbl.Text)); doc.Add(new iTextSharp.text.Paragraph("\nEnd!")); //doc.Pages.Add // doc.Add(new iTextSharp.text.Paragraph(DateTime.Now)); //Image image = new Image(@"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQ9zJZcEV_YhZbsxSPbG8asz92NCpzao9r9pw&usqp=CAU", 0, 0); // page.Elements.Add(image); } catch (Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { doc.Close(); } } } // button1.Enabled=false; // button1.Enabled = false; } if (TotalPriceLib.Text == "0" || Total_in_Cafe.Text == "0") { button1.Enabled = true; } button1.Enabled = false; //TotalTotalLbl.Text; //TotalPriceLib //Total_in_Cafe }
public ResultResponse GenerateWorkerBarcode(List <UserInformation> users) { ResultResponse resultResponse = new ResultResponse(); var pgSize = new iTextSharp.text.Rectangle(225, 75); //100,65 //200,65 iTextSharp.text.Document doc = new iTextSharp.text.Document(pgSize, 0, 0, 2, 2); //0,0,0,0 string path = HttpContext.Current.Server.MapPath("~/GenaratePDF/"); DateTime dt = DateTime.Now; string fileName = dt.Minute.ToString() + dt.Second.ToString() + dt.Millisecond.ToString(); PdfWriter.GetInstance(doc, new FileStream(path + fileName + ".pdf", FileMode.Create)); //open the document for writing doc.Open(); // doc.SetPageSize(new iTextSharp.text.Rectangle(100,65)); PdfPTable pdftable = new PdfPTable(1); for (int i = 0; i < users.Count; i++) { int count = 0; iTextSharp.text.Font font = FontFactory.GetFont("Calibri", 6.0f, BaseColor.BLACK); // from 5.0f count++; // var bw = new ZXing.BarcodeWriter(); //var encOptions = new ZXing.Common.EncodingOptions() { Margin = 0 }; // margin 0 to 1 //bw.Options = encOptions; //bw.Format = ZXing.BarcodeFormat.PDF_417; var bw = new ZXing.BarcodeWriter() { Format = ZXing.BarcodeFormat.PDF_417 }; bw.Options = new ZXing.Common.EncodingOptions() { Margin = 1 }; var result = new Bitmap(bw.Write(users[i].UserSQNumber), new Size(210, 55)); //200,50 result.Save(path + users[i].UserSQNumber, System.Drawing.Imaging.ImageFormat.Png); string first = "Employee Code : " + users[i].UserSQNumber; string last = users[i].UserInformationName.ToString() + " - " + users[i].DesignationName.ToString(); iTextSharp.text.Paragraph paragraph = new iTextSharp.text.Paragraph(first, font); iTextSharp.text.Paragraph lastparagraph = new iTextSharp.text.Paragraph(last, font); paragraph.SetLeading(0.8f, 0.8f); paragraph.SpacingAfter = 1; lastparagraph.SetLeading(0.8f, 0.8f); lastparagraph.SpacingBefore = 1; iTextSharp.text.Image image = iTextSharp.text.Image.GetInstance(path + users[i].UserSQNumber); // image.ScaleToFit(new iTextSharp.text.Rectangle(85, 100)); //image.SetAbsolutePosition(0.0f,0.0f); // image.PaddingTop = 5; PdfPCell cell = new PdfPCell { PaddingLeft = 0, PaddingTop = 0, PaddingBottom = 0, PaddingRight = 0 }; // cell.FixedHeight = 60; cell.AddElement(paragraph); cell.AddElement(image); cell.AddElement(lastparagraph); cell.Border = 0; pdftable.AddCell(cell); File.Delete(path + users[i].UserSQNumber); } doc.Add(pdftable); doc.Close(); resultResponse.isSuccess = true; resultResponse.data = path + fileName + ".pdf"; return(resultResponse); }
private void Button4_Click(object sender, EventArgs e) { SaveFileDialog s = new SaveFileDialog { Filter = "pdf files (*.pdf)|*.pdf|All files (*.*)|*.*" }; string path = ""; if (s.ShowDialog() == DialogResult.OK) { path = s.FileName; } try { string sql = ""; if (Search == "") { sql = "SELECT Detail_order.D_Order_id, Detail.Detail_name, Detail.Prod_country, Detail.Price, Detail_order.D_Order_date, Detail_order.D_Count, Worker.Worker_surname, Worker.Worker_name, Status.Status_name FROM Detail_order INNER JOIN Detail on(Detail_order.Detail_id=Detail.Detail_id) INNER JOIN Status on(Detail_order.Status_id=Status.Status_id) INNER JOIN Worker on(Worker.Worker_id=Detail_order.Worker_id);"; } else { sql = "SELECT Detail_order.D_Order_id, Detail.Detail_name, Detail.Prod_country, Detail.Price, Detail_order.D_Order_date, Detail_order.D_Count, Worker.Worker_surname, Worker.Worker_name, Status.Status_name FROM Detail_order INNER JOIN Detail on(Detail_order.Detail_id=Detail.Detail_id) INNER JOIN Status on(Detail_order.Status_id=Status.Status_id) INNER JOIN Worker on(Worker.Worker_id=Detail_order.Worker_id) WHERE" + Search + ";"; } MySqlDataAdapter mda = new MySqlDataAdapter(sql, conn); DataSet ds = new DataSet(); mda.Fill(ds, "Detail_order"); iTextSharp.text.Document doc = new iTextSharp.text.Document(); PdfWriter.GetInstance(doc, new FileStream(path, FileMode.Create)); doc.Open(); BaseFont baseFont = BaseFont.CreateFont("C:\\Windows\\Fonts\\arial.ttf", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED); iTextSharp.text.Font font = new iTextSharp.text.Font(baseFont, iTextSharp.text.Font.DEFAULTSIZE, iTextSharp.text.Font.NORMAL); PdfPTable table = new PdfPTable(ds.Tables["Detail_order"].Columns.Count); PdfPCell cell = new PdfPCell(new Phrase(" " + this.Text + " ", font)) { Colspan = ds.Tables["Detail_order"].Columns.Count, HorizontalAlignment = PdfPCell.ALIGN_CENTER, Border = 0 }; table.AddCell(cell); for (int j = 0; j < dataGridView1.ColumnCount; j++) { cell = new PdfPCell(new Phrase(new Phrase(dataGridView1.Columns[j].HeaderText, font))) { BackgroundColor = iTextSharp.text.BaseColor.LIGHT_GRAY }; table.AddCell(cell); } for (int j = 0; j < ds.Tables["Detail_order"].Rows.Count; j++) { for (int k = 0; k < ds.Tables["Detail_order"].Columns.Count; k++) { table.AddCell(new Phrase(ds.Tables["Detail_order"].Rows[j][k].ToString(), font)); } } doc.Add(table); doc.Close(); MessageBox.Show("Pdf-документ збережено!"); } catch (Exception) { MessageBox.Show("Проблеми конвертації до PDF формату!"); } }
public override byte[] Render(global::Campus.Report.Base.Report report) { byte[] buffer; using (var outputMemoryStream = new MemoryStream()) { var pdfDocument = new iTextSharp.text.Document(iTextSharp.text.PageSize.A4, 50, 25, 15, 10); var arialuniTff = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Fonts), "arial.ttf"); FontFactory.Register(arialuniTff); //FontFactory.Register(Environment.GetFolderPath(Environment.SpecialFolder.Fonts)); var pdfWriter = PdfWriter.GetInstance(pdfDocument, outputMemoryStream); pdfWriter.CloseStream = false; pdfDocument.Open(); //pdfDocument.NewPage(); pdfDocument.Add(new Paragraph(new Phrase(" "))); foreach (var x in report) { if (x is TextElement) { var element = x as TextElement; if (Render(element, pdfDocument, arialuniTff)) { continue; } } if (x is TableElement) { var element = x as TableElement; if (Render(element, pdfDocument, arialuniTff)) { continue; } } if (x is ImageElement) { var element = x as ImageElement; if (Render(element, pdfDocument)) { continue; } } if (x is ComplexHeaderCell) { var element = x as ComplexHeaderCell; if (Render(element, pdfDocument)) { continue; } } if (x is ComplexHeader) { var element = x as ComplexHeader; if (Render(element, pdfDocument)) { continue; } } } pdfDocument.Close(); pdfDocument.CloseDocument(); buffer = new byte[outputMemoryStream.Position]; outputMemoryStream.Position = 0; outputMemoryStream.Read(buffer, 0, buffer.Length); } return(buffer); }
protected void Page_Load(object sender, EventArgs e) { var learningId = Convert.ToInt32(Request.QueryString["id"]); var companyId = Convert.ToInt32(Request.QueryString["companyId"]); var company = new Company(companyId); var res = ActionResult.NoAction; var user = HttpContext.Current.Session["User"] as ApplicationUser; var dictionary = HttpContext.Current.Session["Dictionary"] as Dictionary<string, string>; var learning = new Learning(learningId, companyId); string path = HttpContext.Current.Request.PhysicalApplicationPath; if (!path.EndsWith(@"\", StringComparison.OrdinalIgnoreCase)) { path = string.Format(CultureInfo.InvariantCulture, @"{0}\", path); } var formatedDescription = ToolsPdf.NormalizeFileName(learning.Description); var fileName = string.Format( CultureInfo.InvariantCulture, @"{0}_{1}_Data_{2:yyyyMMddhhmmss}.pdf", dictionary["Item_Learning"], formatedDescription, DateTime.Now); // FONTS var pathFonts = HttpContext.Current.Request.PhysicalApplicationPath; if (!path.EndsWith(@"\", StringComparison.OrdinalIgnoreCase)) { pathFonts = string.Format(CultureInfo.InstalledUICulture, @"{0}\", pathFonts); } this.headerFont = BaseFont.CreateFont(string.Format(CultureInfo.InvariantCulture, @"{0}fonts\ARIAL.TTF", pathFonts), BaseFont.IDENTITY_H, BaseFont.EMBEDDED); this.arial = BaseFont.CreateFont(string.Format(CultureInfo.InvariantCulture, @"{0}fonts\ARIAL.TTF", pathFonts), BaseFont.IDENTITY_H, BaseFont.EMBEDDED); var descriptionFont = new Font(this.headerFont, 12, Font.BOLD, BaseColor.BLACK); var document = new iTextSharp.text.Document(PageSize.A4, 40, 40, 65, 55); var writer = PdfWriter.GetInstance(document, new FileStream(Request.PhysicalApplicationPath + "\\Temp\\" + fileName, FileMode.Create)); var pageEventHandler = new TwoColumnHeaderFooter() { CompanyLogo = string.Format(CultureInfo.InvariantCulture, @"{0}\images\logos\{1}.jpg", path, companyId), IssusLogo = string.Format(CultureInfo.InvariantCulture, "{0}issus.png", path), Date = string.Format(CultureInfo.InvariantCulture, "{0:dd/MM/yyyy}", DateTime.Now), CreatedBy = string.Format(CultureInfo.InvariantCulture, "{0}", user.UserName), CompanyId = learning.CompanyId, CompanyName = company.Name, Title = dictionary["Item_Learning"] }; writer.PageEvent = pageEventHandler; var borderSides = Rectangle.RIGHT_BORDER + Rectangle.LEFT_BORDER + Rectangle.BOTTOM_BORDER; document.Open(); #region Dades bàsiques // Ficha pincipal var table = new PdfPTable(6) { WidthPercentage = 100, HorizontalAlignment = 0 }; table.SetWidths(new float[] { 30f, 30f, 30f, 30f, 30f, 30f }); table.AddCell(TitleLabel(dictionary["Item_Learning_FieldLabel_Course"])); table.AddCell(new iTSpdf.PdfPCell(new iTS.Phrase(learning.Description, descriptionFont)) { Border = 0, BackgroundColor = new iTS.BaseColor(255, 255, 255), Padding = 6f, PaddingTop = 4f, HorizontalAlignment = Rectangle.ALIGN_LEFT, Colspan = 5 }); table.AddCell(TitleLabel(dictionary["Item_Learning_FieldLabel_EstimatedDate"])); table.AddCell(ToolsPdf.DataCell(learning.DateEstimated, descriptionFont)); table.AddCell(TitleLabel(dictionary["Item_Learning_FieldLabel_Hours"])); table.AddCell(ToolsPdf.DataCell(learning.Hours, descriptionFont)); string statusText = string.Empty; switch (learning.Status) { case 1: statusText = dictionary["Item_Learning_Status_Started"]; break; case 2: statusText = dictionary["Item_Learning_Status_Finished"]; break; case 3: statusText = dictionary["Item_Learning_Status_Evaluated"]; break; default: statusText = dictionary["Item_Learning_Status_InProgress"]; break; } table.AddCell(TitleLabel(dictionary["Item_Learning_ListHeader_Status"])); table.AddCell(ToolsPdf.DataCell(statusText, descriptionFont)); table.AddCell(TitleLabel(dictionary["Item_Learning_FieldLabel_StartDate"])); table.AddCell(ToolsPdf.DataCell(learning.RealStart, descriptionFont)); table.AddCell(TitleLabel(dictionary["Item_Learning_FieldLabel_EndDate"])); table.AddCell(ToolsPdf.DataCell(learning.RealFinish, descriptionFont)); table.AddCell(TitleLabel(dictionary["Item_Learning_FieldLabel_Amount"])); table.AddCell(ToolsPdf.DataCellMoney(learning.Amount, descriptionFont)); table.AddCell(TitleLabel(dictionary["Item_Learning_FieldLabel_Coach"])); table.AddCell(new iTSpdf.PdfPCell(new iTS.Phrase(learning.Master, descriptionFont)) { Border = 0, BackgroundColor = new iTS.BaseColor(255, 255, 255), Padding = 6f, PaddingTop = 4f, HorizontalAlignment = Rectangle.ALIGN_LEFT, Colspan = 5 }); // Objective table.AddCell(SeparationRow()); table.AddCell(TitleAreaCell(dictionary["Item_Learning_Objetive"])); table.AddCell(TextAreaCell(Environment.NewLine + learning.Objective, borderSides, Rectangle.ALIGN_LEFT, 6)); // Methodology table.AddCell(SeparationRow()); table.AddCell(TitleAreaCell(dictionary["Item_Learning_FieldLabel_Methodology"])); table.AddCell(TextAreaCell(Environment.NewLine + learning.Methodology, borderSides, Rectangle.ALIGN_LEFT, 6)); // Notes table.AddCell(SeparationRow()); table.AddCell(TitleAreaCell(dictionary["Item_Learning_FieldLabel_Notes"])); table.AddCell(TextAreaCell(Environment.NewLine + learning.Notes, borderSides, Rectangle.ALIGN_LEFT, 6)); document.Add(table); #endregion #region Asistentes var backgroundColor = new iTS.BaseColor(225, 225, 225); var rowPair = new iTS.BaseColor(255, 255, 255); var rowEven = new iTS.BaseColor(240, 240, 240); var headerFontFinal = new iTS.Font(headerFont, 9, iTS.Font.NORMAL, iTS.BaseColor.BLACK); document.SetPageSize(PageSize.A4.Rotate()); document.NewPage(); var tableAssistants = new iTSpdf.PdfPTable(3) { WidthPercentage = 100, HorizontalAlignment = 1, SpacingBefore = 20f }; tableAssistants.SetWidths(new float[] { 90f, 20f, 20f }); tableAssistants.AddCell(new PdfPCell(new Phrase(learning.Description, descriptionFont)) { Colspan = 5, Border = Rectangle.NO_BORDER, PaddingTop = 20f, PaddingBottom = 20f, HorizontalAlignment = Element.ALIGN_CENTER }); tableAssistants.AddCell(ToolsPdf.HeaderCell(dictionary["Item_LearningAssistants"])); tableAssistants.AddCell(ToolsPdf.HeaderCell(dictionary["Item_LearningAssistant_Status_Done"])); tableAssistants.AddCell(ToolsPdf.HeaderCell(dictionary["Item_LearningAssistant_Status_Evaluated"])); int cont = 0; bool pair = false; var times = new iTS.Font(arial, 8, iTS.Font.NORMAL, iTS.BaseColor.BLACK); var timesBold = new iTS.Font(arial, 8, iTS.Font.BOLD, iTS.BaseColor.BLACK); learning.ObtainAssistance(); foreach (var assistance in learning.Assistance) { int border = 0; var lineBackground = pair ? rowEven : rowPair; tableAssistants.AddCell(new iTSpdf.PdfPCell(new iTS.Phrase(assistance.Employee.FullName, times)) { Border = border, BackgroundColor = lineBackground, Padding = ToolsPdf.PaddingTableCell, PaddingTop = ToolsPdf.PaddingTopTableCell }); string completedText = string.Empty; if (assistance.Completed.HasValue) { completedText = assistance.Completed.Value ? dictionary["Common_Yes"] : dictionary["Common_No"]; } tableAssistants.AddCell(new iTSpdf.PdfPCell(new iTS.Phrase(completedText, times)) { Border = border, BackgroundColor = lineBackground, HorizontalAlignment = Element.ALIGN_CENTER, Padding = ToolsPdf.PaddingTableCell, PaddingTop = ToolsPdf.PaddingTopTableCell }); string successText = string.Empty; if (assistance.Success.HasValue) { successText = assistance.Success.Value ? dictionary["Common_Yes"] : dictionary["Common_No"]; } tableAssistants.AddCell(new iTSpdf.PdfPCell(new iTS.Phrase(successText, times)) { Border = border, BackgroundColor = lineBackground, HorizontalAlignment = Element.ALIGN_CENTER, Padding = ToolsPdf.PaddingTableCell, PaddingTop = ToolsPdf.PaddingTopTableCell }); cont++; } // TotalRow if(learning.Assistance.Count == 0) { tableAssistants.AddCell(new iTSpdf.PdfPCell(new iTS.Phrase(dictionary["Item_LearningList_NoAssistants"], descriptionFont)) { Border = iTS.Rectangle.TOP_BORDER, BackgroundColor = rowEven, Padding = ToolsPdf.PaddingTableCell, PaddingTop = ToolsPdf.PaddingTopTableCell, Colspan = 3, HorizontalAlignment = Rectangle.ALIGN_CENTER }); } tableAssistants.AddCell(new iTSpdf.PdfPCell(new iTS.Phrase(string.Format( CultureInfo.InvariantCulture, @"{0}: {1}", dictionary["Common_RegisterCount"], cont), times)) { Border = iTS.Rectangle.TOP_BORDER, BackgroundColor = rowEven, Padding = ToolsPdf.PaddingTableCell, PaddingTop = ToolsPdf.PaddingTopTableCell, Colspan = 3 }); document.Add(tableAssistants); #endregion document.Close(); Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("Content-Disposition", "inline;filename=outfile.pdf"); Response.ContentType = "application/pdf"; Response.WriteFile(Request.PhysicalApplicationPath + "\\Temp\\" + fileName); Response.Flush(); Response.Clear(); }
protected void SonucYazdır_Click(object sender, EventArgs e) { MongoClient client = new MongoClient(); var database = client.GetDatabase("hastane"); var collection = database.GetCollection <yatanhastalar>("yatanhastalar"); var servislistesi = collection.Find(x => x._id != null).ToList().SelectMany(x => x.ServisList).ToList(); var hastalistesi = servislistesi.SelectMany(x => x.HastaList).ToList().Where(x => x._id == ObjectId.Parse(ddlHasta2.SelectedValue)).ToList().FirstOrDefault(); var sonuc = database.GetCollection <islemsonuc>("sonuclistesi").Find(x => x._id == ObjectId.Parse(ddlsonuctarih.SelectedValue) && x.sonuc_cesidi == "Laboratuvar").ToList().SelectMany(x => x.SonucList).ToList(); #region Font seç BaseFont trArial = BaseFont.CreateFont(@"C:\WINDOWS\Fonts\tahoma.ttf", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED); iTextSharp.text.Font fontArial = new iTextSharp.text.Font(trArial, 10, iTextSharp.text.Font.NORMAL, iTextSharp.text.BaseColor.DARK_GRAY); iTextSharp.text.Font fontArialHeader = new iTextSharp.text.Font(trArial, 13, iTextSharp.text.Font.BOLD, iTextSharp.text.BaseColor.BLACK); iTextSharp.text.Font fontArialbold = new iTextSharp.text.Font(trArial, 9, iTextSharp.text.Font.BOLD, iTextSharp.text.BaseColor.DARK_GRAY); iTextSharp.text.Font fontArialboldgeneral = new iTextSharp.text.Font(trArial, 10, iTextSharp.text.Font.BOLD, iTextSharp.text.BaseColor.BLACK); #endregion #region Sonuç pdf oluştur iTextSharp.text.Document pdfFile = new iTextSharp.text.Document(); PdfWriter.GetInstance(pdfFile, new FileStream("C:\\Users\\Önder\\Desktop\\Yeni klasör\\Kan Sonucu (" + hastalistesi.hasta_adi + " " + hastalistesi.hasta_soyadi + " " + ddlsonuctarih.SelectedItem.Text + ").pdf", FileMode.Create)); pdfFile.Open(); #endregion #region Sonuç oluşturan bilgileri pdfFile.AddCreator("Önder"); //Oluşturan kişinin isminin eklenmesi pdfFile.AddCreationDate(); //Oluşturulma tarihinin eklenmesi pdfFile.AddAuthor("Laboratuvar"); //Yazarın isiminin eklenmesi pdfFile.AddHeader("Başlık", "PDF UYGULAMASI OLUSTUR"); pdfFile.AddTitle("Sonuç Raporu"); //Başlık ve title eklenmesi #endregion #region Sonuç firma resmi ve tarihi oluştur iTextSharp.text.Image jpgimg = iTextSharp.text.Image.GetInstance(@"C:/Users/Önder/Desktop/Önder Fatih Buhurcu Staj Projesi/WebApplicationHastane/WebApplicationHastane/login/images/İsimsiz-1.png"); jpgimg.ScalePercent(35); jpgimg.Alignment = iTextSharp.text.Image.LEFT_ALIGN; PdfPTable pdfTableHeader = new PdfPTable(3); pdfTableHeader.TotalWidth = 500f; pdfTableHeader.LockedWidth = true; pdfTableHeader.DefaultCell.Border = Rectangle.NO_BORDER; PdfPCell cellheader1 = new PdfPCell(jpgimg); cellheader1.HorizontalAlignment = PdfPCell.ALIGN_LEFT; cellheader1.VerticalAlignment = PdfPCell.ALIGN_BOTTOM; cellheader1.FixedHeight = 60f; cellheader1.Border = 0; pdfTableHeader.AddCell(cellheader1); PdfPCell cellheader2 = new PdfPCell(new Phrase("SONUÇ RAPORU", fontArialHeader)); cellheader2.HorizontalAlignment = PdfPCell.ALIGN_CENTER; cellheader2.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; cellheader2.FixedHeight = 60f; cellheader2.Border = 0; pdfTableHeader.AddCell(cellheader2); PdfPCell cellheader3 = new PdfPCell(new Phrase(DateTime.Now.ToShortDateString(), fontArial)); cellheader3.HorizontalAlignment = PdfPCell.ALIGN_RIGHT; cellheader3.VerticalAlignment = PdfPCell.ALIGN_MIDDLE; cellheader3.FixedHeight = 60f; cellheader3.Border = 0; pdfTableHeader.AddCell(cellheader3); #endregion Phrase p = new Phrase("\n"); Paragraph yazi = new Paragraph("Hasta TC: " + hastalistesi.hasta_tc + "\nHasta Adı: " + hastalistesi.hasta_adi + "\nHasta Soyadı: " + hastalistesi.hasta_soyadi + "\n\n\n"); #region Tabloyu Oluştur PdfPTable pdfTable = new PdfPTable(2); pdfTable.TotalWidth = 500f; pdfTable.LockedWidth = true; pdfTable.HorizontalAlignment = 1; pdfTable.DefaultCell.Padding = 5; pdfTable.DefaultCell.BorderColor = iTextSharp.text.BaseColor.GRAY; foreach (var item in sonuc) { pdfTable.AddCell(new Phrase(item.tahlil_adi, fontArialboldgeneral)); pdfTable.AddCell(new Phrase(item.sonuc, fontArial)); } #endregion #region Pdfe yaz ve dosyayı kapat if (pdfFile.IsOpen() == false) { pdfFile.Open(); } pdfFile.Add(pdfTableHeader); pdfFile.Add(p); pdfFile.Add(yazi); pdfFile.Add(pdfTable); pdfFile.Close(); #endregion }
public ResultResponse SaveBarcodes(BarcodeGenarateModal barcodeGenarateModal, int userId) { ResultResponse resultResponse = new ResultResponse(); int masterPrimaryKey = 0; try { accessManager.SqlConnectionOpen(DataBase.WorkerInsentive); List <SqlParameter> aParameters = new List <SqlParameter>(); aParameters.Add(new SqlParameter("@StyleNo", barcodeGenarateModal.StyleID)); aParameters.Add(new SqlParameter("@GenarateDate", barcodeGenarateModal.SelectDate)); aParameters.Add(new SqlParameter("@BundleQuantity", barcodeGenarateModal.Quantity)); aParameters.Add(new SqlParameter("@Size", barcodeGenarateModal.BundleSize)); aParameters.Add(new SqlParameter("@Color", barcodeGenarateModal.Color)); aParameters.Add(new SqlParameter("@CreateBy", userId)); aParameters.Add(new SqlParameter("@CutNo", barcodeGenarateModal.CutNo)); aParameters.Add(new SqlParameter("@ShadeNo", barcodeGenarateModal.ShadeNO)); aParameters.Add(new SqlParameter("@BuyerId", barcodeGenarateModal.BuyerID)); aParameters.Add(new SqlParameter("@PONumber", barcodeGenarateModal.PONumber)); aParameters.Add(new SqlParameter("@QuantityGenarate", (barcodeGenarateModal.Quantity * barcodeGenarateModal.NoOfBundle))); aParameters.Add(new SqlParameter("@BusinessUnitId", barcodeGenarateModal.BusinessUnitId)); aParameters.Add(new SqlParameter("@MachineId", barcodeGenarateModal.MachineId)); aParameters.Add(new SqlParameter("@LotNo", barcodeGenarateModal.LotNo)); masterPrimaryKey = accessManager.SaveDataReturnPrimaryKey("sp_SaveGenaratedMasterTable", aParameters); } catch (Exception exception) { accessManager.SqlConnectionClose(true); throw exception; } finally { accessManager.SqlConnectionClose(); } var pgSize = new iTextSharp.text.Rectangle(225, 75); //225,75 iTextSharp.text.Document doc = new iTextSharp.text.Document(pgSize, 0, 0, 2, 2); //0,0,0,0 string path = HttpContext.Current.Server.MapPath("~/GenaratePDF/"); DateTime dt = DateTime.Now; string fileName = dt.Minute.ToString() + dt.Second.ToString() + dt.Millisecond.ToString(); PdfWriter.GetInstance(doc, new FileStream(path + fileName + ".pdf", FileMode.Create)); //open the document for writing doc.Open(); // doc.SetPageSize(new iTextSharp.text.Rectangle(100,65)); PdfPTable pdftable = new PdfPTable(1); for (int i = 0; i < barcodeGenarateModal.NoOfBundle; i++) { int count = 0; iTextSharp.text.Font font = FontFactory.GetFont("Calibri", 6f, BaseColor.BLACK); // from 5.0f iTextSharp.text.Font fontlast = FontFactory.GetFont("Calibri", 6f, BaseColor.BLACK); // from 5.0f //String header = "Buyer Name : " + barcodeGenarateModal.BuyerName+"\nStyle : " + barcodeGenarateModal.StyleName + "\nBundle Quantity : " + barcodeGenarateModal.Quantity + // "\nBundle No : " + (i+1) + "\nColor : " + barcodeGenarateModal.Color + ", Size : " + barcodeGenarateModal.BundleSize+ "\nPO Number : " + barcodeGenarateModal.PONumber; //iTextSharp.text.Paragraph paraheader = new iTextSharp.text.Paragraph(header, font); //PdfPCell cell1 = new PdfPCell { PaddingLeft = 0, PaddingTop = 0, PaddingBottom = 0, PaddingRight = 0 }; // cell1.AddElement(paraheader); // cell1.Border = 0; //pdftable.AddCell(cell1); foreach (CommonModel barcodeGenarate in barcodeGenarateModal.OprationList) { count++; int barcodeNo = BarcodePrimaryKey(masterPrimaryKey, i + 1, barcodeGenarate, barcodeGenarateModal.BusinessUnitId); var bw = new ZXing.BarcodeWriter() { Format = ZXing.BarcodeFormat.PDF_417 }; bw.Options = new ZXing.Common.EncodingOptions() { Margin = 1 }; // var encOptions = new ZXing.Common.EncodingOptions() { Margin = 0}; // margin 0 to 1 //bw.Format = ZXing.BarcodeFormat.CODE_128; var bitmap = bw.Write(barcodeNo + "," + barcodeGenarate.OperationSMV); Bitmap result = new Bitmap(bitmap, new Size(210, 55)); //100,60 // 210,60 //var result = new Bitmap(); result.Save(path + barcodeGenarate.OperationName, System.Drawing.Imaging.ImageFormat.Png); //barcodeNo + "-" + string first = barcodeNo + " , " + barcodeGenarateModal.StyleName + ", " + barcodeGenarate.OperationName + "," + barcodeGenarateModal.BundleSize; string last = barcodeGenarate.OperationSMV + ", " + barcodeGenarateModal.SelectDate + "," + barcodeGenarateModal.Quantity + ", " + (i + 1) + "-" + count + ", " + barcodeGenarateModal.Color + "," + barcodeGenarateModal.PONumber; iTextSharp.text.Paragraph paragraph = new iTextSharp.text.Paragraph(first, font); iTextSharp.text.Paragraph lastparagraph = new iTextSharp.text.Paragraph(last, fontlast); paragraph.SetLeading(0.8f, 0.8f); paragraph.SpacingAfter = 1; //2 lastparagraph.SetLeading(0.8f, 0.8f); iTextSharp.text.Image image = iTextSharp.text.Image.GetInstance(path + barcodeGenarate.OperationName); //image.SpacingAfter = 5;// for code 128 //image.ScaleAbsolute(85,50); // image.PaddingTop = 3.0f; PdfPCell cell = new PdfPCell { PaddingLeft = 0, PaddingTop = 0, PaddingBottom = 0, PaddingRight = 0 }; // cell.FixedHeight = 60; cell.AddElement(paragraph); cell.AddElement(image); cell.AddElement(lastparagraph); cell.Border = 0; pdftable.AddCell(cell); File.Delete(path + barcodeGenarate.OperationName); } } doc.Add(pdftable); doc.Close(); resultResponse.isSuccess = true; resultResponse.data = path + fileName + ".pdf"; return(resultResponse); }
public string PrintVoucher(paymentvoucher pvh, List <paymentvoucherdetail> pvDetails) { string fileName = ""; try { string payMode = ""; if (pvh.BookType.Equals("BANKBOOK")) { payMode = "Bank"; } else { payMode = "Cash"; } string HeaderString = "No : " + pvh.VoucherNo + Main.delimiter1 + "Date : " + pvh.VoucherDate.ToString("dd-MM-yyyy") + Main.delimiter1 + "Payment Mode" + Main.delimiter1 + payMode + Main.delimiter1 + "Paied To" + Main.delimiter1 + pvh.SLName + Main.delimiter1 + "Amount(" + pvh.CurrencyID + ")" + Main.delimiter1 + pvh.VoucherAmount + Main.delimiter1 + "Amount In Words" + Main.delimiter1 + NumberToString.convert(pvh.VoucherAmount.ToString()).Trim().Replace("INR", pvh.CurrencyID) + Main.delimiter1 + "Narration" + Main.delimiter1 + pvh.Narration; string ColHeader = "SI No.;Bill No;Date;Amount(" + pvh.CurrencyID + ");Account Name"; string footer3 = "Receiver's Signature;Authorised Signatory"; int n = 1; string ColDetailString = ""; var count = pvDetails.Count(); List <string> billNos = new List <string>(); List <string> billDates = new List <string>(); string[] billdetail = pvh.BillDetails.Split(Main.delimiter2); // 0: doctype, 1: billno, 2 : billdate foreach (string str in billdetail) { if (str.Trim().Length != 0) { string[] subStr = str.Split(Main.delimiter1); billNos.Add(subStr[1]); billDates.Add(Convert.ToDateTime(subStr[2]).ToString("dd-MM-yyyy")); } } foreach (paymentvoucherdetail pvd in pvDetails) { if (pvd.AmountCredit != 0) { if (pvh.BillDetails.Trim().Length != 0) { //ColDetailString = ColDetailString + n + Main.delimiter1 + billdetail[1] + Main.delimiter1 + // Convert.ToDateTime(billdetail[2].Replace(Main.delimiter2.ToString(), "")).ToString("dd-MM-yyyy") + // Main.delimiter1 + pvd.AmountCreditINR + Main.delimiter1 // + pvd.AccountName + Main.delimiter2; ColDetailString = ColDetailString + n + Main.delimiter1 + String.Join(",", billNos.ToArray()) + Main.delimiter1 + string.Join(",", billDates.ToArray()) + Main.delimiter1 + pvd.AmountCredit + Main.delimiter1 + pvd.AccountName + Main.delimiter2; } else { ColDetailString = ColDetailString + n + Main.delimiter1 + "" + Main.delimiter1 + "" + Main.delimiter1 + pvd.AmountCredit + Main.delimiter1 + pvd.AccountName + Main.delimiter2; } n++; } } SaveFileDialog sfd = new SaveFileDialog(); sfd.Title = "Save As PDF"; sfd.Filter = "Pdf files (*.Pdf)|*.pdf"; sfd.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); sfd.FileName = pvh.DocumentID + "-" + pvh.VoucherNo; if (sfd.ShowDialog() == DialogResult.Cancel || sfd.FileName == "") { return(""); } FileStream fs = new FileStream(sfd.FileName, FileMode.Create, FileAccess.Write); fileName = sfd.FileName; Rectangle rec = new Rectangle(PageSize.A4); iTextSharp.text.Document doc = new iTextSharp.text.Document(rec); PdfWriter writer = PdfWriter.GetInstance(doc, fs); MyEvent evnt = new MyEvent(); writer.PageEvent = evnt; doc.Open(); Font font1 = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.NORMAL, BaseColor.BLACK); Font font2 = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.BOLD, BaseColor.BLACK); Font font3 = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.ITALIC, BaseColor.BLACK); //String imageURL = @"D:\Smrutiranjan\PurchaseOrder\index.jpg"; //iTextSharp.text.Image jpg = iTextSharp.text.Image.GetInstance(imageURL); String URL = "Cellcomm2.JPG"; iTextSharp.text.Image img = iTextSharp.text.Image.GetInstance(URL); img.Alignment = Element.ALIGN_LEFT; PdfPTable tableMain = new PdfPTable(2); tableMain.WidthPercentage = 100; PdfPCell cellImg = new PdfPCell(); Paragraph pp = new Paragraph(); pp.Add(new Chunk(img, 0, 0)); cellImg.AddElement(pp); cellImg.Border = 0; tableMain.AddCell(cellImg); PdfPCell cellAdd = new PdfPCell(); Paragraph ourAddr = new Paragraph(""); CompanyDetailDB compDB = new CompanyDetailDB(); cmpnydetails det = compDB.getdetails().FirstOrDefault(comp => comp.companyID == 1); if (det != null) { string addr = det.companyname + "\n" + det.companyAddress; ourAddr = new Paragraph(new Phrase(addr, font2)); ourAddr.Alignment = Element.ALIGN_RIGHT; } cellAdd.AddElement(ourAddr); cellAdd.Border = 0; tableMain.AddCell(cellAdd); Paragraph paragraph2 = new Paragraph(new Phrase("Payment Voucher", font2)); paragraph2.Alignment = Element.ALIGN_CENTER; //PrintPurchaseOrder prog = new PrintPurchaseOrder(); string[] HeaderStr = HeaderString.Split(Main.delimiter1); PdfPTable table = new PdfPTable(4); table.SpacingBefore = 20f; table.WidthPercentage = 100; float[] HWidths = new float[] { 2f, 1f, 1f, 2f }; table.SetWidths(HWidths); PdfPCell cell = null; for (int i = 0; i < HeaderStr.Length; i++) { if ((i % 2) != 0) { cell = new PdfPCell(new Phrase(HeaderStr[i].Trim(), font1)); cell.Colspan = 3; cell.HorizontalAlignment = 0; //0=Left, 1=Centre, 2=Right table.AddCell(cell); } else { table.AddCell(new PdfPCell(new Phrase(HeaderStr[i].Trim(), font1))); } } Paragraph paragraph3 = new Paragraph(new Phrase("Bill Details", font2)); paragraph3.Alignment = Element.ALIGN_CENTER; paragraph3.SpacingBefore = 10; paragraph3.SpacingAfter = 10; string[] ColHeaderStr = ColHeader.Split(';'); PdfPTable table1 = new PdfPTable(5); table1.DefaultCell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table1.WidthPercentage = 100; float[] width = new float[] { 0.5f, 2f, 3f, 3f, 6f }; table1.SetWidths(width); for (int i = 0; i < ColHeaderStr.Length; i++) { PdfPCell hcell = new PdfPCell(new Phrase(ColHeaderStr[i].Trim(), font2)); hcell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table1.AddCell(hcell); } //--- PdfPCell foot = new PdfPCell(new Phrase("")); foot.Colspan = 5; foot.BorderWidthTop = 0; foot.MinimumHeight = 0.5f; table1.AddCell(foot); table1.HeaderRows = 2; table1.FooterRows = 1; table1.SkipFirstHeader = false; table1.SkipLastFooter = true; //--- string[] DetailStr = ColDetailString.Split(Main.delimiter2); float hg = 0f; for (int i = 0; i < DetailStr.Length; i++) { if (DetailStr[i].Length != 0) { hg = table1.GetRowHeight(i + 1); string[] str = DetailStr[i].Split(Main.delimiter1); for (int j = 0; j < str.Length; j++) { PdfPCell pcell; //if (j == 1 || j == 3 || j == 4) //{ // pcell = new PdfPCell(new Phrase(str[j], font2)); //} //else pcell = new PdfPCell(new Phrase(str[j], font1)); pcell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table1.AddCell(pcell); } } } string[] ft = footer3.Split(';'); PdfPTable tableFooter = new PdfPTable(3); tableFooter.SpacingBefore = 50; tableFooter.DefaultCell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; tableFooter.WidthPercentage = 100; PdfPCell fcell1 = new PdfPCell(new Phrase(ft[0], font2)); fcell1.Border = 0; fcell1.HorizontalAlignment = PdfPCell.ALIGN_CENTER; PdfPCell fcell2 = new PdfPCell(new Phrase(ft[1], font2)); fcell2.Border = 0; fcell2.HorizontalAlignment = PdfPCell.ALIGN_CENTER; PdfPCell fcell3 = new PdfPCell(); fcell3.Border = 0; tableFooter.AddCell(fcell1); tableFooter.AddCell(fcell3); tableFooter.AddCell(fcell2); if (table1.Rows.Count > 10) { table1.KeepRowsTogether(table1.Rows.Count - 4, table1.Rows.Count); } doc.Add(tableMain); //doc.Add(img); doc.Add(paragraph2); doc.Add(table); doc.Add(paragraph3); doc.Add(table1); doc.Add(tableFooter); doc.Close(); //-----watermark String wmurl = ""; if (pvh.status == 98) { //cancelled wmurl = "003.png"; } else { wmurl = "001.png"; } ////String wmurl = "napproved-1.jpg"; iTextSharp.text.Image wmimg = iTextSharp.text.Image.GetInstance(URL); PrintWaterMark.PdfStampWithNewFile(wmurl, sfd.FileName); //----- MessageBox.Show("Document Saved"); } catch (Exception ie) { MessageBox.Show("Failed to save.\n" + ie.Message); } return(fileName); }
/// <summary> /// Utility function to crop a png into page-sized portions and embed each png into the pdf. /// </summary> /// <param name="png"></param> /// <returns></returns> public static byte[] ConvertPngToPdf(byte[] png) { using (MemoryStream pdfStream = new MemoryStream()) { Document pdfDocument = new iTextSharp.text.Document(PageSize.LETTER, 36, 36, 36, 36); var writer = PdfWriter.GetInstance(pdfDocument, pdfStream); writer.CloseStream = false; pdfDocument.Open(); var maxImageHeight = pdfDocument.PageSize.Height + 36; using (var source = new System.Drawing.Bitmap(new MemoryStream(png))) { if (source.Height > maxImageHeight) { int heightOffset = 0; while (heightOffset < source.Height) { Rectangle sourceRect = heightOffset + (int)(maxImageHeight) > source.Height ? new System.Drawing.Rectangle(0, heightOffset, source.Width, source.Height) : new System.Drawing.Rectangle(0, heightOffset, source.Width, (int)(maxImageHeight)); using (var target = new System.Drawing.Bitmap(sourceRect.Width, sourceRect.Height)) { using (var g = Graphics.FromImage(target)) { g.DrawImage(source, new System.Drawing.Rectangle(0, 0, target.Width, target.Height), sourceRect, GraphicsUnit.Pixel); } using (MemoryStream ms = new MemoryStream()) { target.Save(ms, ImageFormat.Png); pdfDocument.Add(new Paragraph()); Image img = Image.GetInstance(ms.GetBuffer()); img.ScaleToFit(pdfDocument.PageSize.Width - 72, img.Height); pdfDocument.Add(img); if (sourceRect.Height >= maxImageHeight) { pdfDocument.NewPage(); } } } heightOffset += sourceRect.Height; } } else { pdfDocument.Add(new Paragraph()); Image img = Image.GetInstance(png); img.ScaleToFit(pdfDocument.PageSize.Width - 72, img.Height); pdfDocument.Add(img); } } if (pdfDocument.IsOpen()) { pdfDocument.Close(); } pdfStream.Flush(); pdfStream.Seek(0, SeekOrigin.Begin); return(pdfStream.GetBuffer()); } }
private void CreateReport(string filePath) { AppFileTemplate f = (AppFileTemplate)DataContext; // margins float left = 30; float right = 10; float top = 10; float bottom = 10; float headH = 20; float indent = 5; //string fontName = "C:\\WINDOWS\\FONTS\\CALIBRI.TTF"; string fontName = System.IO.Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Fonts), "CALIBRI.TTF"); iText.Font NormalSatirFont = iText.FontFactory.GetFont(fontName, "CP1254", 10, iText.Font.NORMAL); iText.Font BoldSatirFont = iText.FontFactory.GetFont(fontName, "CP1254", 10, iText.Font.BOLD); iText.Font NormalRiseFont = iText.FontFactory.GetFont(fontName, "CP1254", 8, iText.Font.NORMAL); iText.Font NormalSymbolFont = iText.FontFactory.GetFont(iText.FontFactory.SYMBOL, 10, iText.Font.NORMAL); iText.Document doc = new iText.Document(iText.PageSize.A4, left, right, top, bottom); float xLL = doc.GetLeft(left); float yLL = doc.GetBottom(bottom); float xUR = doc.GetRight(right); float yUR = doc.GetTop(top); float w = xUR - xLL; float h = yUR - yLL; float xUL = xLL; float yUL = yUR; float xLR = xUR; float yLR = yLL; //float graphW = w - 10; //float graphH = graphW * 2 / 3; float graphH = 3 * h / 5; float graphW = w - 10; PdfWriter writer = PdfWriter.GetInstance(doc, new FileStream(filePath, FileMode.Create)); doc.Open(); // direct content PdfContentByte cb = writer.DirectContent; // çizgiler DrawLine(cb, xUR - w, yUR, xUR, yUR); DrawLine(cb, xUR - w, yUR, xLL, yLL); DrawLine(cb, xLL, yLL, xLL + w, yLL); DrawLine(cb, xLL + w, yLL, xUR, yUR); DrawLine(cb, xUL, yUL - headH, xUR, yUR - headH); DrawLine(cb, xUL, yUL - headH - graphH, xUR, yUR - headH - graphH); // başlık ColumnText ct = new ColumnText(cb); ct.Indent = indent; iText.Phrase txt = new iText.Phrase(); txt.Add(new iText.Chunk(f.ReportTitle, NormalSatirFont)); ct.SetSimpleColumn(txt, xUL, yUL - headH, xUR, yUR, headH / 1.5f, iText.Element.ALIGN_LEFT | iText.Element.ALIGN_MIDDLE); ct.Go(); var stream = new MemoryStream(); var pngExporter = new PngExporter { Width = (int)graphW, Height = (int)graphH, Background = OxyColors.White }; pngExporter.Export(PlotView.Model, stream); iText.Image png = iText.Image.GetInstance(stream.GetBuffer()); png.Alignment = iText.Element.ALIGN_CENTER | iText.Element.ALIGN_MIDDLE; png.SetAbsolutePosition(xUL, yUL - headH - graphH); doc.Add(png); float kstW = w / 2; float kstH = (h - headH - graphH) / 1.5f; ColumnText ctKesit = new ColumnText(cb); ctKesit.Indent = indent; txt = new iText.Phrase(); txt.Add(new iText.Chunk("Kesit\n", BoldSatirFont)); txt.Add(new iText.Chunk(String.Format("Genişlik, b = {0:0} cm\n", f.b), NormalSatirFont)); txt.Add(new iText.Chunk(String.Format("Yükseklik, h = {0:0} cm\n", f.h), NormalSatirFont)); txt.Add(new iText.Chunk(String.Format("Alan, bxh = {0:0} cm²\n", f.b * f.h), NormalSatirFont)); txt.Add(new iText.Chunk("\nMalzeme\n", BoldSatirFont)); txt.Add(new iText.Chunk("f", NormalSatirFont)); txt.Add(new iText.Chunk("c", NormalRiseFont).SetTextRise(-1.0f)); txt.Add(new iText.Chunk(String.Format(" = {0:0} MPa ", f.Beton().fc.TonnesForcePerSquareMeter().Megapascals), NormalSatirFont)); txt.Add(new iText.Chunk("f", NormalSatirFont)); txt.Add(new iText.Chunk("y", NormalRiseFont).SetTextRise(-1.0f)); txt.Add(new iText.Chunk(String.Format(" = {0:0} MPa\n", f.DonatiCeligi().fy.TonnesForcePerSquareMeter().Megapascals), NormalSatirFont)); txt.Add(new iText.Chunk("f", NormalSatirFont)); txt.Add(new iText.Chunk("cd", NormalRiseFont).SetTextRise(-1.0f)); txt.Add(new iText.Chunk(String.Format(" = {0:0} MPa ", f.Beton().fcd.TonnesForcePerSquareMeter().Megapascals), NormalSatirFont)); txt.Add(new iText.Chunk("f", NormalSatirFont)); txt.Add(new iText.Chunk("yd", NormalRiseFont).SetTextRise(-1.0f)); txt.Add(new iText.Chunk(String.Format(" = {0:0} MPa\n", f.DonatiCeligi().fyd.TonnesForcePerSquareMeter().Megapascals), NormalSatirFont)); txt.Add(new iText.Chunk("E", NormalSatirFont)); txt.Add(new iText.Chunk("c", NormalRiseFont).SetTextRise(-1.0f)); txt.Add(new iText.Chunk(String.Format(" = {0:0} MPa ", f.Beton().E.TonnesForcePerSquareMeter().Megapascals), NormalSatirFont)); txt.Add(new iText.Chunk("E", NormalSatirFont)); txt.Add(new iText.Chunk("s", NormalRiseFont).SetTextRise(-1.0f)); txt.Add(new iText.Chunk(String.Format(" = {0:0} MPa\n", f.DonatiCeligi().E.TonnesForcePerSquareMeter().Megapascals), NormalSatirFont)); txt.Add(new iText.Chunk("e", NormalSymbolFont)); txt.Add(new iText.Chunk("cu", NormalRiseFont).SetTextRise(-1.0f)); txt.Add(new iText.Chunk(String.Format(" = {0:0.0000} m/m ", f.Beton().Ecu), NormalSatirFont)); txt.Add(new iText.Chunk("e", NormalSymbolFont)); txt.Add(new iText.Chunk("yd", NormalRiseFont).SetTextRise(-1.0f)); txt.Add(new iText.Chunk(String.Format(" = {0:0.00000} m/m\n", f.DonatiCeligi().Eyd), NormalSatirFont)); txt.Add(new iText.Chunk("k", NormalSatirFont)); txt.Add(new iText.Chunk("1", NormalRiseFont).SetTextRise(-1.0f)); txt.Add(new iText.Chunk(String.Format(" = {0:0.000}\n", f.Beton().k1), NormalSatirFont)); ctKesit.SetSimpleColumn(txt, xUL, yUL - headH - graphH - kstH, xUL + kstW, yUL - headH - graphH, 15, iText.Element.ALIGN_LEFT); ctKesit.Go(); ColumnText ctDonati = new ColumnText(cb); txt = new iText.Phrase(); txt.Add(new iText.Chunk("Donatı\n", BoldSatirFont)); int j = 1; foreach (var rb in f.ReinforcingBars) { txt.Add(new iText.Chunk("A", NormalSatirFont)); txt.Add(new iText.Chunk(string.Format("s{0}", j), NormalRiseFont).SetTextRise(-1.0f)); txt.Add(new iText.Chunk(string.Format("={0:0.00} cm², ", rb.As), NormalSatirFont)); txt.Add(new iText.Chunk("d", NormalSatirFont)); txt.Add(new iText.Chunk(string.Format("{0}", j), NormalRiseFont).SetTextRise(-1.0f)); txt.Add(new iText.Chunk(string.Format("={0:0.00} cm\n", rb.di), NormalSatirFont)); j++; } txt.Add(new iText.Chunk("r", NormalSymbolFont)); txt.Add(new iText.Chunk(string.Format("=%{0:0.00}\n", 100.0 * f.ReinforcingBars.Sum(i => i.As) / (f.b * f.h)), NormalSatirFont)); txt.Add(new iText.Chunk("(d", NormalSatirFont)); txt.Add(new iText.Chunk("i", NormalRiseFont).SetTextRise(-1.0f)); txt.Add(new iText.Chunk(":Kesit basınç yüzeyinin donatı eksenine uzaklığı)\n", NormalSatirFont)); txt.Add(new iText.Chunk("\nDayanım Azaltma Katsayıları\n", BoldSatirFont)); txt.Add(new iText.Chunk("f", NormalSymbolFont)); txt.Add(new iText.Chunk("a", NormalRiseFont).SetTextRise(-1.0f)); txt.Add(new iText.Chunk(string.Format(" = {0:0.00}, ", f.PhiA), NormalSatirFont)); txt.Add(new iText.Chunk("f", NormalSymbolFont)); txt.Add(new iText.Chunk("b", NormalRiseFont).SetTextRise(-1.0f)); txt.Add(new iText.Chunk(string.Format(" = {0:0.00}, ", f.PhiB), NormalSatirFont)); txt.Add(new iText.Chunk("f", NormalSymbolFont)); txt.Add(new iText.Chunk("c", NormalRiseFont).SetTextRise(-1.0f)); txt.Add(new iText.Chunk(string.Format(" = {0:0.00}", f.PhiC), NormalSatirFont)); //txt.Add(new iText.Chunk("\n\nTasarım:\n", BoldSatirFont)); //txt.Add(new iText.Chunk(f.Code.ToString(), NormalSatirFont)); ctDonati.SetSimpleColumn(txt, xUL + kstW, yUL - headH - graphH - kstH, xUL + 2 * kstW, yUL - headH - graphH, 15, iText.Element.ALIGN_LEFT); ctDonati.Go(); ColumnText ctTesir = new ColumnText(cb); ctTesir.Indent = indent; txt = new iText.Phrase(); txt.Add(new iText.Chunk("Maksimum eksenel basınç, N", NormalSatirFont)); txt.Add(new iText.Chunk("max", NormalRiseFont).SetTextRise(-1.0f)); txt.Add(new iText.Chunk(string.Format(" = {0:0.00} t\n", f.Pmax), NormalSatirFont)); txt.Add(new iText.Chunk("Maksimum eksenel çekme, N", NormalSatirFont)); txt.Add(new iText.Chunk("min", NormalRiseFont).SetTextRise(-1.0f)); txt.Add(new iText.Chunk(string.Format(" = {0:0.00} t\n\n", f.Pmin), NormalSatirFont)); txt.Add(new iText.Chunk("Yönetmelik maksimum eksenel basınç sınırı, N", NormalSatirFont)); txt.Add(new iText.Chunk("max", NormalRiseFont).SetTextRise(-1.0f)); txt.Add(new iText.Chunk(string.Format(" = {0:0.00} t", f.ActualPmax), NormalSatirFont)); ctTesir.SetSimpleColumn(txt, xUL, yUL - headH - graphH - 1.5f * kstH, xUL + kstW, yUL - headH - graphH - kstH, 15, iText.Element.ALIGN_LEFT); ctTesir.Go(); doc.Close(); }
public ActionResult Imprimir(int id) { var empleado = db.Empleadoes.FirstOrDefault(e => e.ID_Empleado == id); var cargoEmpleado = empleado.Cargo_Empleado.FirstOrDefault(); var nomina = empleado.Nominas.FirstOrDefault(); decimal recargo = 0; decimal auxilioTransporte = 0; if (cargoEmpleado.ID_Jornada == (int)WorkingDay.Night) { recargo = CalcularRecargoNocturno(cargoEmpleado.Salario_Basico, nomina.Extras_Nocturnas); } if (cargoEmpleado.Salario_Basico <= 1656232) { auxilioTransporte += 97032; } var horasextrasdiurnas = CalcularExtrasDiurnas(cargoEmpleado.Salario_Basico, nomina.Extras_Diurnas); var TotalDevengado = cargoEmpleado.Salario_Basico + recargo + horasextrasdiurnas + auxilioTransporte - empleado.Nominas.FirstOrDefault().Aporte_Salud - empleado.Nominas.FirstOrDefault().Aporte_Pension; iTextSharp.text.Document doc = new iTextSharp.text.Document(); PdfWriter.GetInstance(doc, new FileStream($"{MapPath("~/Pdf")}/hola.pdf", FileMode.Create)); doc.Open(); Paragraph title = new Paragraph(); title.Font = FontFactory.GetFont(FontFactory.TIMES, 18f, BaseColor.BLUE); title.Add("NomiProSA"); doc.Add(title); doc.Add(new Paragraph("NIT: 900565456-9")); doc.Add(new Paragraph("CORREO: [email protected]")); doc.Add(new Paragraph("Direccion: Calle 8 sur # 78-67")); doc.Add(new Paragraph("-------------------------------------------------------------------------------------------------------------------------------")); doc.Add(new Paragraph($"Empleado: {empleado.Apellido} {empleado.Nombre}")); doc.Add(new Paragraph("Documento de Identidad:" + empleado.Numero_Documento)); doc.Add(new Paragraph("Básico:" + empleado.Cargo_Empleado.FirstOrDefault().Salario_Basico)); doc.Add(new Paragraph("Cargo:" + cargoEmpleado.Cargo.Descripción_Cargo)); doc.Add(new Paragraph("Cargo:" + cargoEmpleado.TipoContrato)); doc.Add(new Paragraph("Jornada:" + cargoEmpleado.Jornada.Nombre)); doc.Add(new Paragraph("Periodo de Liquidacion Inicial:" + empleado.Nominas.LastOrDefault().Fecha_Inicial_Pago)); doc.Add(new Paragraph("Periodo de Liquidacion Final:" + empleado.Nominas.LastOrDefault().Fecha_Final_Pago)); doc.Add(new Paragraph("-------------------------------------------------------------------------------------------------------------------------------")); doc.Add(new Paragraph("Recibo de pago")); doc.Add(new Paragraph("=========================================================================")); PdfPTable table = new PdfPTable(9); table.AddCell("Basico"); table.AddCell("Total Horas"); table.AddCell("Auxi.Transporte"); table.AddCell("Salud"); table.AddCell("Pension"); table.AddCell("Extras Dia"); table.AddCell("Extras Noche"); table.AddCell("Recargo"); table.AddCell("Neto"); table.AddCell("" + empleado.Cargo_Empleado.FirstOrDefault().Salario_Basico); table.AddCell("" + empleado.Nominas.LastOrDefault().Total_Horas_Laboradas); table.AddCell("" + auxilioTransporte); table.AddCell("" + nomina.Aporte_Salud); table.AddCell("" + nomina.Aporte_Pension); table.AddCell("" + nomina.Extras_Diurnas); table.AddCell("" + nomina.Extras_Nocturnas); table.AddCell("" + recargo); table.AddCell("" + TotalDevengado); doc.Add(table); doc.Close(); // db.Nominas.Add(imprimir); // db.SaveChanges(); // return RedirectToAction("Index", "Roster"); //byte[] fileBytes = System.IO.File.ReadAllBytes($"{MapPath("~/Pdf")}/hola.pdf"); //string fileName = "myfile.pdf"; //return File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, fileName); return(Redirect("/Pdf/hola.pdf")); }
public byte[] ToPDF() { try { byte[] pdfBytes; using (MemoryStream ms = new MemoryStream()) { iTextSharp.text.Document doc = new iTextSharp.text.Document(); PdfWriter writer = PdfWriter.GetInstance(doc, ms); iTextSharp.text.Image jpg = iTextSharp.text.Image.GetInstance(HttpContext.Current.Server.MapPath("~/Content/Images/InvoiceSheet/blank_invoice.jpg")); doc.SetPageSize(iTextSharp.text.PageSize.A4); jpg.ScaleToFit(iTextSharp.text.PageSize.A4.Width, iTextSharp.text.PageSize.A4.Height); jpg.Alignment = iTextSharp.text.Image.UNDERLYING; jpg.SetAbsolutePosition(10, -5); doc.Open(); doc.Add(jpg); Font defaultFont = new Font(Font.FontFamily.HELVETICA, 7); var cb = writer.DirectContent; ColumnText desc_col = new ColumnText(cb); ColumnText item_col = new ColumnText(cb); ColumnText item_price_col = new ColumnText(cb); ColumnText purchase_col = new ColumnText(cb); ColumnText invoice_col = new ColumnText(cb); ColumnText invoice_date_col = new ColumnText(cb); ColumnText total_sub_price_col = new ColumnText(cb); ColumnText vat_col = new ColumnText(cb); ColumnText total_price_col = new ColumnText(cb); ColumnText job_title_col = new ColumnText(cb); job_title_col.SetSimpleColumn(165, doc.Top - 200, 500, 200, 15, Element.ALIGN_TOP); invoice_col.SetSimpleColumn(doc.Right - 110, doc.Top - 154.2f, 500, 100, 15, Element.ALIGN_TOP); invoice_date_col.SetSimpleColumn(doc.Right - 110, doc.Top - 166.3f, 500, 100, 15, Element.ALIGN_TOP); purchase_col.SetSimpleColumn(200, doc.Top - 270, 500, 100, 15, Element.ALIGN_TOP); desc_col.SetSimpleColumn(165, doc.Top - 320, 415, 200, 15, Element.ALIGN_TOP); item_col.SetSimpleColumn(165, doc.Top - 340, 415, 200, 15, Element.ALIGN_TOP); item_price_col.SetSimpleColumn(doc.Right - 110, doc.Top - 340, 500, 100, 15, Element.ALIGN_TOP); total_sub_price_col.SetSimpleColumn(doc.Right - 110, doc.Bottom - 100, 500, 145, 15, Element.ALIGN_TOP); vat_col.SetSimpleColumn(doc.Right - 110, doc.Bottom - 100, 500, 125, 15, Element.ALIGN_TOP); total_price_col.SetSimpleColumn(doc.Right - 110, doc.Bottom, 500, 105, 15, Element.ALIGN_TOP); job_title_col.AddElement(CreateInfo(this.Title)); invoice_col.AddElement(CreateInfo(this.InvoiceNumber.ToString())); invoice_date_col.AddElement(CreateInfo(this.CreatedDate.ToString("dd MMM yyyy"))); purchase_col.AddElement(CreateInfo(this.PurchaseOrder)); desc_col.AddElement(CreateInfoLight(this.Description)); vat_col.AddElement(CreateInfoLight("20%")); // add invoice items to page var items = this.Items; foreach (var item in items) { item_col.AddElement(CreateInfoLight("item title")); item_price_col.AddElement(CreateInfoLight(item.Value.ToString())); } //totals total_sub_price_col.AddElement(CreateInfo(this.SubValue.ToString("C"))); total_price_col.AddElement(CreateInfo(this.TotalValue.ToString("C"))); job_title_col.Go(); purchase_col.Go(); invoice_col.Go(); invoice_date_col.Go(); desc_col.Go(); item_col.Go(); item_price_col.Go(); total_sub_price_col.Go(); total_price_col.Go(); vat_col.Go(); // column9.Go(); // column10.Go(); // column11.Go(); doc.Close(); pdfBytes = ms.ToArray(); } return(pdfBytes); } catch (Exception) { throw; } }
protected void Page_Load(object sender, EventArgs e) {//Logging Start string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { if (Request.QueryString["caseid"] != null && Request.QueryString["cmpid"] != null) { string szCaseID = Request.QueryString["caseid"].ToString(); string szCompanyID = Request.QueryString["cmpid"].ToString(); DataSet ds = new DataSet(); MUVGenerateFunction objSettings = new MUVGenerateFunction(); ds = GetPatienView(szCaseID, szCompanyID); string szfirstname = ""; string szlastname = ""; if (ds.Tables[0].Rows[0]["SZ_PATIENT_FIRST_NAME"].ToString() != "") { szfirstname = ds.Tables[0].Rows[0]["SZ_PATIENT_FIRST_NAME"].ToString(); szfirstname = szfirstname.Replace(" ", string.Empty); szfirstname = szfirstname.Replace(".", string.Empty); szfirstname = szfirstname.Replace(",", string.Empty); } if (ds.Tables[0].Rows[0]["SZ_PATIENT_LAST_NAME"].ToString() != "") { szlastname = ds.Tables[0].Rows[0]["SZ_PATIENT_LAST_NAME"].ToString(); szlastname = szlastname.Replace(" ", string.Empty); szlastname = szlastname.Replace(".", string.Empty); szlastname = szlastname.Replace(",", string.Empty); } string path = ApplicationSettings.GetParameterValue("PatientInfoSaveFilePath"); string OpenFilepath = ApplicationSettings.GetParameterValue("PatientInfoOpenFilePath"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } string newPdfFilename = szfirstname.Trim() + "_" + szlastname.Trim() + "_" + DateTime.Now.ToString("MM_dd_yyyyhhmm") + ".pdf"; string pdfPath = path + newPdfFilename; MemoryStream m = new MemoryStream(); iTextSharp.text.Document document = new iTextSharp.text.Document(PageSize.A4, 36, 36, 20, 20); float[] wBase = { 4f }; PdfPTable tblBase = new PdfPTable(wBase); tblBase.DefaultCell.Border = Rectangle.NO_BORDER; tblBase.WidthPercentage = 100; PdfWriter writer = PdfWriter.GetInstance(document, m); document.Open(); #region "for printed by" float[] width = { 4f, 4f }; PdfPTable tblprintby = new PdfPTable(width); tblprintby.TotalWidth = document.PageSize.Width - document.LeftMargin - document.RightMargin; tblprintby.DefaultCell.Border = Rectangle.NO_BORDER; tblprintby.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_LEFT; tblprintby.DefaultCell.VerticalAlignment = iTextSharp.text.Element.ALIGN_TOP; tblprintby.AddCell(new Phrase("Printed By : " + ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_NAME, iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); tblprintby.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_RIGHT; tblprintby.AddCell(new Phrase("Printed on : " + DateTime.Now.ToString("MM/dd/yyyy"), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); tblBase.AddCell(tblprintby); #endregion tblBase.AddCell(" "); #region "for patient information" float[] wdh = { 4f }; PdfPTable tblheading = new PdfPTable(wdh); tblheading.TotalWidth = document.PageSize.Width - document.LeftMargin - document.RightMargin; tblheading.DefaultCell.Border = Rectangle.NO_BORDER; tblheading.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_CENTER; tblheading.DefaultCell.VerticalAlignment = iTextSharp.text.Element.ALIGN_MIDDLE; tblheading.AddCell(new Phrase("Patient Information", iTextSharp.text.FontFactory.GetFont("Arial", 14, Font.BOLD, iTextSharp.text.Color.BLACK))); tblBase.AddCell(tblheading); #endregion #region for Personal Information float[] w11 = { 3f, 3f, 3f, 3f }; PdfPTable table = new PdfPTable(w11); table.WidthPercentage = 100; table.DefaultCell.BorderColor = Color.BLACK; PdfPCell cell1 = new PdfPCell(new Phrase("Personal Information", iTextSharp.text.FontFactory.GetFont("Arial", 12, iTextSharp.text.Color.BLACK))); cell1.Colspan = 4; cell1.BackgroundColor = Color.LIGHT_GRAY; cell1.BorderColor = Color.BLACK; table.AddCell(cell1); table.AddCell(new Phrase("First Name", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_PATIENT_FIRST_NAME"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_PATIENT_FIRST_NAME"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("Middle Name", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["MI"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["MI"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("Last Name", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_PATIENT_LAST_NAME"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_PATIENT_LAST_NAME"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("D.O.B", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["DOB"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["DOB"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("Gender", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_GENDER"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_GENDER"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("Address", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_PATIENT_ADDRESS"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_PATIENT_ADDRESS"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("City", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_PATIENT_CITY"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_PATIENT_CITY"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("State", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_PATIENT_STATE"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_PATIENT_STATE"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("Cell Phone #", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["sz_patient_cellno"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["sz_patient_cellno"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("Home Phone", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_PATIENT_PHONE"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_PATIENT_PHONE"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("Work", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_WORK_PHONE"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_WORK_PHONE"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("Zip", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_PATIENT_ZIP"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_PATIENT_ZIP"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("Email", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_PATIENT_EMAIL"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_PATIENT_EMAIL"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("Extn.", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_WORK_PHONE_EXTENSION"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_WORK_PHONE_EXTENSION"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("Attorney", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_ATTORNEY"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_ATTORNEY"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("Case Type", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_CASE_TYPE"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_CASE_TYPE"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("Attorney Address", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_ATTORNEY_ADDRESS"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_ATTORNEY_ADDRESS"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("Attorney Phone", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["sz_attorney_phone"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["sz_attorney_phone"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("Case Status", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_CASE_STATUS"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_CASE_STATUS"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } table.AddCell(new Phrase("SSN", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_SOCIAL_SECURITY_NO"].ToString() != "") { table.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_SOCIAL_SECURITY_NO"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { table.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } PdfPCell cell2 = new PdfPCell(new Phrase("")); cell2.Colspan = 2; cell2.BorderColor = Color.BLACK; table.AddCell(cell2); tblBase.AddCell(table); #endregion tblBase.AddCell(" "); #region for Insurance Information float[] wd1 = { 3f, 3f, 3f, 3f }; PdfPTable tblInsurance = new PdfPTable(wd1); tblInsurance.WidthPercentage = 100; tblInsurance.DefaultCell.BorderColor = Color.BLACK; PdfPCell cell3 = new PdfPCell(new Phrase("Insurance Information", iTextSharp.text.FontFactory.GetFont("Arial", 12, iTextSharp.text.Color.BLACK))); cell3.Colspan = 4; cell3.BorderColor = Color.BLACK; cell3.BackgroundColor = Color.LIGHT_GRAY; tblInsurance.AddCell(cell3); tblInsurance.AddCell(new Phrase("Policy Holder", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_POLICY_HOLDER"].ToString() != "") { tblInsurance.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_POLICY_HOLDER"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblInsurance.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblInsurance.AddCell(new Phrase("Name", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_INSURANCE_NAME"].ToString() != "") { tblInsurance.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_INSURANCE_NAME"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblInsurance.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblInsurance.AddCell(new Phrase("Address", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_INSURANCE_ADDRESS"].ToString() != "") { tblInsurance.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_INSURANCE_ADDRESS"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblInsurance.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblInsurance.AddCell(new Phrase("City", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_INSURANCE_CITY"].ToString() != "") { tblInsurance.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_INSURANCE_CITY"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblInsurance.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblInsurance.AddCell(new Phrase("State", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_INSURANCE_STATE"].ToString() != "") { tblInsurance.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_INSURANCE_STATE"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblInsurance.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblInsurance.AddCell(new Phrase("Zip", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_INSURANCE_ZIP"].ToString() != "") { tblInsurance.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_INSURANCE_ZIP"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblInsurance.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblInsurance.AddCell(new Phrase("Phone", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_INSURANCE_PHONE"].ToString() != "") { tblInsurance.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_INSURANCE_PHONE"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblInsurance.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblInsurance.AddCell(new Phrase("Fax", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_FAX_NUMBER"].ToString() != "") { tblInsurance.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_FAX_NUMBER"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblInsurance.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblInsurance.AddCell(new Phrase("Contact Person", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_CONTACT_PERSON"].ToString() != "") { tblInsurance.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_CONTACT_PERSON"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblInsurance.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblInsurance.AddCell(new Phrase("Claim File #", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_CLAIM_NUMBER"].ToString() != "") { tblInsurance.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_CLAIM_NUMBER"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblInsurance.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblInsurance.AddCell(new Phrase("Policy #", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_POLICY_NUMBER"].ToString() != "") { tblInsurance.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_POLICY_NUMBER"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblInsurance.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } PdfPCell cell14 = new PdfPCell(new Phrase("")); cell14.Colspan = 2; cell14.BorderColor = Color.BLACK; tblInsurance.AddCell(cell14); tblBase.AddCell(tblInsurance); #endregion tblBase.AddCell(" "); #region for Accident Information float[] wd2 = { 3f, 3f, 3f, 3f }; PdfPTable tblAccident = new PdfPTable(wd2); tblAccident.WidthPercentage = 100; tblAccident.DefaultCell.BorderColor = Color.BLACK; PdfPCell cell4 = new PdfPCell(new Phrase("Accident Information", iTextSharp.text.FontFactory.GetFont("Arial", 12, iTextSharp.text.Color.BLACK))); cell4.Colspan = 4; cell4.BorderColor = Color.BLACK; cell4.BackgroundColor = Color.LIGHT_GRAY; tblAccident.AddCell(cell4); tblAccident.AddCell(new Phrase("Accident Date", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["DT_ACCIDENT_DATE"].ToString() != "") { tblAccident.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["DT_ACCIDENT_DATE"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblAccident.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblAccident.AddCell(new Phrase("Plate Number", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_PLATE_NO"].ToString() != "") { tblAccident.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_PLATE_NO"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblAccident.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblAccident.AddCell(new Phrase("Report Number", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_REPORT_NO"].ToString() != "") { tblAccident.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_REPORT_NO"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblAccident.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblAccident.AddCell(new Phrase("Address", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_ACCIDENT_ADDRESS"].ToString() != "") { tblAccident.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_ACCIDENT_ADDRESS"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblAccident.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblAccident.AddCell(new Phrase("City", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_ACCIDENT_CITY"].ToString() != "") { tblAccident.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_ACCIDENT_CITY"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblAccident.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblAccident.AddCell(new Phrase("State", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_ACCIDENT_INSURANCE_STATE"].ToString() != "") { tblAccident.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_ACCIDENT_INSURANCE_STATE"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblAccident.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblAccident.AddCell(new Phrase("Hospital Name", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_HOSPITAL_NAME"].ToString() != "") { tblAccident.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_HOSPITAL_NAME"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblAccident.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblAccident.AddCell(new Phrase("Hospital Address", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_HOSPITAL_ADDRESS"].ToString() != "") { tblAccident.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_HOSPITAL_ADDRESS"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblAccident.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblAccident.AddCell(new Phrase("Date of Admission", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["DT_ADMISSION_DATE"].ToString() != "") { tblAccident.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["DT_ADMISSION_DATE"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblAccident.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblAccident.AddCell(new Phrase("Additional Patient", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_PATIENT_FROM_CAR"].ToString() != "") { tblAccident.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_PATIENT_FROM_CAR"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblAccident.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblAccident.AddCell(new Phrase("Describe Injury", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_DESCRIBE_INJURY"].ToString() != "") { tblAccident.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_DESCRIBE_INJURY"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblAccident.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblAccident.AddCell(new Phrase("Patient Type", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_PATIENT_TYPE"].ToString() != "") { tblAccident.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_PATIENT_TYPE"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblAccident.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblBase.AddCell(tblAccident); #endregion tblBase.AddCell(" "); #region for Employer Information float[] wd3 = { 3f, 3f, 3f, 3f }; PdfPTable tblEmployer = new PdfPTable(wd3); tblEmployer.WidthPercentage = 100; tblEmployer.DefaultCell.BorderColor = Color.BLACK; PdfPCell cell5 = new PdfPCell(new Phrase("Employer Information", iTextSharp.text.FontFactory.GetFont("Arial", 12, iTextSharp.text.Color.BLACK))); cell5.Colspan = 4; cell5.BorderColor = Color.BLACK; cell5.BackgroundColor = Color.LIGHT_GRAY; tblEmployer.AddCell(cell5); tblEmployer.AddCell(new Phrase("Name", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_EMPLOYER_NAME"].ToString() != "") { tblEmployer.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_EMPLOYER_NAME"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblEmployer.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblEmployer.AddCell(new Phrase("Address", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_EMPLOYER_ADDRESS"].ToString() != "") { tblEmployer.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_EMPLOYER_ADDRESS"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblEmployer.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblEmployer.AddCell(new Phrase("City", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_EMPLOYER_CITY"].ToString() != "") { tblEmployer.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_EMPLOYER_CITY"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblEmployer.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblEmployer.AddCell(new Phrase("State", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_EMPLOYER_STATE"].ToString() != "") { tblEmployer.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_EMPLOYER_STATE"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblEmployer.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblEmployer.AddCell(new Phrase("Zip", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_EMPLOYER_ZIP"].ToString() != "") { tblEmployer.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_EMPLOYER_ZIP"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblEmployer.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblEmployer.AddCell(new Phrase("Phone", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_EMPLOYER_PHONE"].ToString() != "") { tblEmployer.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_EMPLOYER_PHONE"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblEmployer.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblEmployer.AddCell(new Phrase("Date of First Treatment", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["DT_FIRST_TREATMENT"].ToString() != "") { tblEmployer.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["DT_FIRST_TREATMENT"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblEmployer.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblEmployer.AddCell(new Phrase("Chart #", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_CHART_NO"].ToString() != "") { tblEmployer.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_CHART_NO"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblEmployer.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblBase.AddCell(tblEmployer); #endregion tblBase.AddCell(" "); #region for Adjuster Information float[] wd4 = { 3f, 3f, 3f, 3f }; PdfPTable tblAdjuster = new PdfPTable(wd4); tblAdjuster.WidthPercentage = 100; tblAdjuster.DefaultCell.BorderColor = Color.BLACK; PdfPCell cell6 = new PdfPCell(new Phrase("Adjuster Information", iTextSharp.text.FontFactory.GetFont("Arial", 12, iTextSharp.text.Color.BLACK))); cell6.Colspan = 4; cell6.BorderColor = Color.BLACK; cell6.BackgroundColor = Color.LIGHT_GRAY; tblAdjuster.AddCell(cell6); tblAdjuster.AddCell(new Phrase("Name", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_ADJUSTER_NAME"].ToString() != "") { tblAdjuster.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_ADJUSTER_NAME"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblAdjuster.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblAdjuster.AddCell(new Phrase("Phone", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_PHONE"].ToString() != "") { tblAdjuster.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_PHONE"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblAdjuster.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblAdjuster.AddCell(new Phrase("Extension", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_EXTENSION"].ToString() != "") { tblAdjuster.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_EXTENSION"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblAdjuster.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblAdjuster.AddCell(new Phrase("Fax", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_FAX"].ToString() != "") { tblAdjuster.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_FAX"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblAdjuster.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblAdjuster.AddCell(new Phrase("Email", iTextSharp.text.FontFactory.GetFont("Arial", 8, Font.BOLD, iTextSharp.text.Color.BLACK))); if (ds.Tables[0].Rows[0]["SZ_EMAIL"].ToString() != "") { tblAdjuster.AddCell(new Phrase(Convert.ToString(ds.Tables[0].Rows[0]["SZ_EMAIL"]), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblAdjuster.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } PdfPCell cell7 = new PdfPCell(new Phrase("")); cell7.Colspan = 2; cell7.BorderColor = Color.BLACK; tblAdjuster.AddCell(cell7); tblBase.AddCell(tblAdjuster); #endregion tblBase.AddCell(" "); tblBase.AddCell(" "); tblBase.AddCell(" "); tblBase.AddCell(" "); tblBase.AddCell(" "); tblBase.AddCell(" "); tblBase.AddCell(" "); tblBase.AddCell(" "); tblBase.AddCell(" "); tblBase.AddCell(" "); tblBase.AddCell(" "); #region "for websource information" float[] wd5 = { 4f }; PdfPTable tblSource = new PdfPTable(wd5); tblSource.TotalWidth = document.PageSize.Width - document.LeftMargin - document.RightMargin; tblSource.DefaultCell.Border = Rectangle.NO_BORDER; tblSource.DefaultCell.HorizontalAlignment = iTextSharp.text.Element.ALIGN_LEFT; tblSource.DefaultCell.VerticalAlignment = iTextSharp.text.Element.ALIGN_BOTTOM; if (ds.Tables[0].Rows[0]["SZ_WEBSOURCE"].ToString() != "") { tblSource.AddCell(new Phrase("Source : " + ds.Tables[0].Rows[0]["SZ_WEBSOURCE"].ToString(), iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } else { tblAdjuster.AddCell(new Phrase("-", iTextSharp.text.FontFactory.GetFont("Arial", 8, iTextSharp.text.Color.BLACK))); } tblBase.AddCell(tblSource); #endregion document.Add(tblBase); document.Close(); System.IO.File.WriteAllBytes(pdfPath, m.GetBuffer()); string OpenPdfFilepath = OpenFilepath + newPdfFilename; Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "sandeep", "<script type='text/javascript'>window.location.href='" + OpenPdfFilepath + "'</script>"); } } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
public void PDFESTADOCERO() { Buscadores bus = new Buscadores(); var doc = new iTextSharp.text.Document(PageSize.A4); string path = Server.MapPath("~"); PdfWriter writer = PdfWriter.GetInstance(doc, new FileStream(path + "/Factura.pdf", FileMode.Create)); vehiculo ovehiculo = bus.buscarvehiculoid(Ordenn.id_vehiculo ?? default(int)); cliente ocliente = bus.ocliente(ovehiculo); modelo omodelo = bus.buscarmodelo(ovehiculo); marca omarca = bus.buscarmarca(omodelo); doc.Open(); //Cabecera BaseFont bfntHead = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED); iTextSharp.text.Font fntHead = new iTextSharp.text.Font(bfntHead, 16, 1, iTextSharp.text.BaseColor.BLUE.Darker()); Paragraph prgHeading = new Paragraph(); prgHeading.Alignment = 1; prgHeading.Add(new Chunk("Factura".ToUpper(), fntHead)); doc.Add(prgHeading); doc.Add(Chunk.NEWLINE); //Generado By Paragraph prgGeneratedBY = new Paragraph(); BaseFont btnAuthor = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED); iTextSharp.text.Font fntAuthor = new iTextSharp.text.Font(btnAuthor, 12, 2, iTextSharp.text.BaseColor.BLACK); prgGeneratedBY.Alignment = Element.ALIGN_RIGHT; prgGeneratedBY.Add(new Chunk("Generado por: " + LogEmpleado.nombreyapellido, fntAuthor)); //Agregar LOG Empleado prgGeneratedBY.Add(new Chunk("\nFecha : " + DateTime.Now.ToShortDateString(), fntAuthor)); prgGeneratedBY.Add(new Chunk("\nN° de Orden : " + Ordenn.id_orden, fntAuthor)); doc.Add(prgGeneratedBY); doc.Add(Chunk.NEWLINE); doc.Add(Chunk.NEWLINE); //tablados PdfPTable tabla2 = new PdfPTable(2); tabla2.WidthPercentage = 100; tabla2.SpacingAfter = 20; PdfPCell vehiculoTitulo = new PdfPCell(new Phrase("Vehiculo")); vehiculoTitulo.BorderWidth = 0; vehiculoTitulo.BorderWidthRight = 0.75f; vehiculoTitulo.BorderWidthTop = 0.75f; vehiculoTitulo.BorderWidthLeft = 0.75f; vehiculoTitulo.HorizontalAlignment = Element.ALIGN_CENTER; vehiculoTitulo.BackgroundColor = new BaseColor(System.Drawing.ColorTranslator.FromHtml("#C8C8C8")); PdfPCell clienteTitulo = new PdfPCell(new Phrase("Cliente")); clienteTitulo.BorderWidth = 0; clienteTitulo.BorderWidthTop = 0.75f; clienteTitulo.BorderWidthRight = 0.75f; clienteTitulo.HorizontalAlignment = Element.ALIGN_CENTER; clienteTitulo.BackgroundColor = new BaseColor(System.Drawing.ColorTranslator.FromHtml("#C8C8C8")); PdfPCell patente = new PdfPCell(new Phrase("Patente: " + ovehiculo.patente)); patente.BorderWidth = 0; patente.BorderWidthRight = 0.75f; patente.BorderWidthBottom = 0.75f; patente.BorderWidthLeft = 0.75f; patente.BackgroundColor = new BaseColor(System.Drawing.ColorTranslator.FromHtml("#C8C8C8")); PdfPCell marca = new PdfPCell(new Phrase("Marca: " + omarca.nombre)); marca.BorderWidth = 0; marca.BorderWidthRight = 0.75f; marca.BorderWidthLeft = 0.75f; marca.BackgroundColor = new BaseColor(System.Drawing.ColorTranslator.FromHtml("#C8C8C8")); PdfPCell modelo = new PdfPCell(new Phrase("Modelo: " + omodelo.nombre)); modelo.BorderWidth = 0; modelo.BorderWidthRight = 0.75f; modelo.BorderWidthLeft = 0.75f; modelo.BackgroundColor = new BaseColor(System.Drawing.ColorTranslator.FromHtml("#C8C8C8")); PdfPCell nombre = new PdfPCell(new Phrase("Apellido y Nombre: " + ocliente.nombre)); nombre.BorderWidth = 0; nombre.BorderWidthLeft = 0.75f; nombre.BorderWidthBottom = 0.75f; nombre.BorderWidthRight = 0.75f; nombre.BackgroundColor = new BaseColor(System.Drawing.ColorTranslator.FromHtml("#C8C8C8")); PdfPCell dni = new PdfPCell(new Phrase("DNI: " + ocliente.dni)); dni.BorderWidth = 0; dni.BorderWidthBottom = 0.75f; dni.BorderWidthRight = 0.75f; dni.BackgroundColor = new BaseColor(System.Drawing.ColorTranslator.FromHtml("#C8C8C8")); tabla2.AddCell(vehiculoTitulo); tabla2.AddCell(clienteTitulo); tabla2.AddCell(marca); tabla2.AddCell(modelo); tabla2.AddCell(nombre); tabla2.AddCell(patente); tabla2.AddCell(dni); doc.Add(tabla2); dt.Rows.Add("", "", "Total", lblprecio.Text); PdfPTable table = new PdfPTable(dt.Columns.Count); for (int i = 0; i < dt.Columns.Count; i++) { string cellText = Server.HtmlDecode(dt.Columns[i].ColumnName); PdfPCell cell = new PdfPCell(); cell.Phrase = new Phrase(cellText, new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.TIMES_ROMAN, 10, 1, new BaseColor(System.Drawing.ColorTranslator.FromHtml("#000000")))); cell.BackgroundColor = new BaseColor(System.Drawing.ColorTranslator.FromHtml("#C8C8C8")); cell.HorizontalAlignment = Element.ALIGN_CENTER; cell.VerticalAlignment = Element.ALIGN_CENTER; cell.PaddingBottom = 5; table.AddCell(cell); } //Agregando Campos a la tabla for (int i = 0; i < dt.Rows.Count; i++) { for (int j = 0; j < dt.Columns.Count; j++) { PdfPCell cell = new PdfPCell(); cell.Phrase = new Phrase(dt.Rows[i][j].ToString(), new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.TIMES_ROMAN, 10, 0, new BaseColor(System.Drawing.ColorTranslator.FromHtml("#000000")))); if (j == 1) { cell.HorizontalAlignment = Element.ALIGN_LEFT; } else { cell.HorizontalAlignment = Element.ALIGN_CENTER; } if (dt.Rows[i][j].ToString() == "Total") { cell.Phrase = new Phrase(dt.Rows[i][j].ToString(), new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.TIMES_ROMAN, 10, 1, new BaseColor(System.Drawing.ColorTranslator.FromHtml("#000000")))); } table.AddCell(cell); } } table.SetWidths(new float[] { 2, 8, 1, 1 }); doc.Add(table); //Espacio doc.Close(); Page.ClientScript.RegisterStartupScript(this.GetType(), "OpenWindow", "window.open('Factura.pdf','_newtab');", true); //Response.Redirect("Presupuesto.pdf"); }
public void PrintIO(invoiceoutheader ioh, List <invoiceoutdetail> IODetails, string taxStr, string podocID) { try { Dictionary <string, string> companyInfo = getCompanyInformation(); string[] pos = ioh.TrackingNos.Split(';'); int b = 0; int[] a = (from s in pos where int.TryParse(s, out b) select b).ToArray(); int min = a.Min(); string[] dates = ioh.TrackingDates.Split(';'); string poStr = ""; string billingAdd = ""; string othRef = ""; for (int i = 0; i < pos.Length - 1; i++) { string custPOStr = POPIHeaderDB.getCustomerPOAndDateForInvoiceOut(Convert.ToInt32(pos[i]), Convert.ToDateTime(dates[i]), podocID); string[] custPO = custPOStr.Split(Main.delimiter1); ////if (Convert.ToInt32(pos[i]) == min) ////billingAdd = custPO[2]; poStr = poStr + custPO[0] + ", Date: " + String.Format("{0:dd MMMM, yyyy}", Convert.ToDateTime(custPO[1])) + "\n"; othRef = othRef + pos[i] + ","; } companybank cb = CompanyBankDB.getCompBankDetailForIOPrint(ioh.BankAcReference); customer custDetail = CustomerDB.getCustomerDetailForPO(ioh.ConsigneeID); string[] companyBillingAdd = CompanyAddressDB.getCompTopBillingAdd(Login.companyID); string ConsgAdd = "Consignee:\n" + custDetail.name + Main.delimiter2 + "\n" + ioh.DeliveryAddress + "\n"; string buyer = "Buyer:\n" + custDetail.name + Main.delimiter2 + "\n" + custDetail.BillingAddress + "\n"; if (custDetail.StateName.ToString().Length != 0) { ConsgAdd = ConsgAdd + "Sate Name:" + custDetail.StateName; buyer = buyer + "Sate Name:" + custDetail.StateName; if (custDetail.StateCode.ToString().Length != 0) { ConsgAdd = ConsgAdd + " ,\nState Code:" + custDetail.StateCode; buyer = buyer + " ,\nState Code:" + custDetail.StateCode; } } else { if (custDetail.StateCode.ToString().Length != 0) { ConsgAdd = ConsgAdd + "\nState Code:" + custDetail.StateCode; buyer = buyer + "\nState Code:" + custDetail.StateCode; } } if (custDetail.OfficeName.ToString().Length != 0) { ConsgAdd = ConsgAdd + "\nGST:" + custDetail.OfficeName; // For GST Code buyer = buyer + "\nGST:" + custDetail.OfficeName; // For GST Code } if (CustomerDB.getCustomerPANForInvoicePrint(ioh.ConsigneeID).Length != 0) { ConsgAdd = ConsgAdd + "\nPAN:" + custDetail.OfficeName; // For PAN Code buyer = buyer + "\nPAN:" + custDetail.OfficeName; // For PAN Code } string HeaderString = buyer + Main.delimiter1 + "Invoice No : " + ioh.InvoiceNo + " , Date: " + String.Format("{0:dd MMMM, yyyy}", ioh.InvoiceDate) + Main.delimiter1 + "Buyer's Reference : " + poStr.Trim() + Main.delimiter1 + "Mode of Dispatch : " + ioh.TransportationModeName + Main.delimiter1 + "Terms of Payment : " + ioh.TermsOfPayment + Main.delimiter1 + //Description : Name of terms of payment ConsgAdd + Main.delimiter1 + "Supplier's Reference : " + othRef.Trim().Substring(0, othRef.Length - 1) + Main.delimiter1 + "Reverse Charge : " + ioh.ReverseCharge + Main.delimiter1 + ioh.SpecialNote; string footer1 = "Amount in words\n\n"; string ColHeader = ""; if (ioh.DocumentID == "PRODUCTINVOICEOUT" || ioh.DocumentID == "PRODUCTEXPORTINVOICEOUT") { ColHeader = "SI No.;Description of Goods;HSN;Quantity;Unit;Unit Rate;Amount"; } else { ColHeader = "SI No.;Description of Goods;SAC;Quantity;Unit;Unit Rate;Amount"; } CompanyDetailDB compDB = new CompanyDetailDB(); cmpnydetails det = compDB.getdetails().FirstOrDefault(comp => comp.companyID == 1); string compName = ""; if (det != null) { compName = det.companyname; } string footer2 = "\n\nAccount Name : " + compName + "\nAccount No : " + cb.AccountCode + "\nAccount Type : " + cb.AccountType + "\nBank : " + cb.BankName + "\nBranch : " + cb.BranchName + "\nIFSC : " + cb.CreateUser; //"\nSWIFT Code : " + cb.CompanyID + string footer3 = "For Cellcomm Solutions Limited;Authorised Signatory"; double totQuant = 0.00; double totAmnt = 0.00; int n = 1; string ColDetailString = ""; var count = IODetails.Count(); foreach (invoiceoutdetail iod in IODetails) { if (ioh.DocumentID == "PRODUCTINVOICEOUT") { iod.HSNCode = iod.HSNCode.Substring(0, 4); } else if (ioh.DocumentID == "SERVICEINVOICEOUT") { iod.HSNCode = iod.HSNCode.Substring(0, 6); } if (n == count) { //if (ioh.DocumentID == "PRODUCTINVOICEOUT") ColDetailString = ColDetailString + n + Main.delimiter1 + iod.CustomerItemDescription + Main.delimiter1 + iod.HSNCode + Main.delimiter1 + iod.Quantity + Main.delimiter1 + iod.Unit + Main.delimiter1 + iod.Price + Main.delimiter1 + (iod.Quantity * iod.Price); //else // ColDetailString = ColDetailString + n + Main.delimiter1 + iod.CustomerItemDescription + Main.delimiter1 + iod.HSNCode.Substring(0, 4) + Main.delimiter1 + iod.Quantity + Main.delimiter1 // + iod.Price + Main.delimiter1 + (iod.Quantity * iod.Price); } else { //if (ioh.DocumentID == "PRODUCTINVOICEOUT") ColDetailString = ColDetailString + n + Main.delimiter1 + iod.CustomerItemDescription + Main.delimiter1 + iod.HSNCode + Main.delimiter1 + iod.Quantity + Main.delimiter1 + iod.Unit + Main.delimiter1 + iod.Price + Main.delimiter1 + (iod.Quantity * iod.Price) + Main.delimiter2; //else // ColDetailString = ColDetailString + n + Main.delimiter1 + iod.CustomerItemDescription + Main.delimiter1 + iod.HSNCode.Substring(0, 4) + Main.delimiter1 + iod.Quantity + Main.delimiter1 // + iod.Price + Main.delimiter1 + (iod.Quantity * iod.Price) + Main.delimiter2; } totQuant = totQuant + iod.Quantity; totAmnt = totAmnt + (iod.Quantity * iod.Price); n++; } try { SaveFileDialog sfd = new SaveFileDialog(); sfd.Title = "Save As PDF"; sfd.Filter = "Pdf files (*.Pdf)|*.pdf"; sfd.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); if (ioh.status == 0 && ioh.DocumentStatus < 99) { sfd.FileName = ioh.DocumentID + "-Temp-" + ioh.TemporaryNo; } else { sfd.FileName = ioh.DocumentID + "-" + ioh.InvoiceNo; } if (sfd.ShowDialog() == DialogResult.Cancel || sfd.FileName == "") { return; } FileStream fs = new FileStream(sfd.FileName, FileMode.Create, FileAccess.Write); Rectangle rec = new Rectangle(PageSize.A4); rec.Bottom = 10; iTextSharp.text.Document doc = new iTextSharp.text.Document(rec); PdfWriter writer = PdfWriter.GetInstance(doc, fs); MyEvent evnt = new MyEvent(); writer.PageEvent = evnt; doc.Open(); Font font1 = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.NORMAL, BaseColor.BLACK); Font font2 = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.BOLD, BaseColor.BLACK); Font font3 = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.ITALIC, BaseColor.BLACK); Font font4 = FontFactory.GetFont("Arial", 5, iTextSharp.text.Font.NORMAL, BaseColor.BLACK); String URL = "Cellcomm2.JPG"; iTextSharp.text.Image img = iTextSharp.text.Image.GetInstance(URL); img.Alignment = Element.ALIGN_LEFT; PdfPTable tableHeader = new PdfPTable(2); tableHeader.WidthPercentage = 100; PdfPCell cellImg = new PdfPCell(); Paragraph pp = new Paragraph(); pp.Add(new Chunk(img, 0, 0)); cellImg.AddElement(pp); cellImg.Border = 0; tableHeader.AddCell(cellImg); PdfPCell cellAdd = new PdfPCell(); Paragraph ourAddr = new Paragraph(""); if (det != null) { ourAddr.Add(new Chunk(det.companyname + "\n", font2)); ourAddr.Add(new Chunk(det.companyAddress.Replace("\r\n", "\n"), font4)); StringBuilder sb = new StringBuilder(); sb.Append("\nGST : " + companyInfo["GST"] + "\nState Code for GST : " + companyInfo["StateCode"] + "\nCIN : " + companyInfo["CIN"] + "\nPAN : " + companyInfo["PAN"]); ourAddr.Add(new Chunk(sb.ToString(), font4)); ourAddr.Alignment = Element.ALIGN_RIGHT; ourAddr.SetLeading(0.0f, 1.5f); } cellAdd.AddElement(ourAddr); cellAdd.Border = 0; tableHeader.AddCell(cellAdd); Paragraph ParagraphDocumentName = new Paragraph(new Phrase("Tax Invoice", font2)); ParagraphDocumentName.Alignment = Element.ALIGN_CENTER; PrintPurchaseOrder prog = new PrintPurchaseOrder(); string[] HeaderStr = HeaderString.Split(Main.delimiter1); PdfPTable TableAddress = new PdfPTable(7); TableAddress.SpacingBefore = 20f; TableAddress.WidthPercentage = 100; float[] HWidths = new float[] { 1f, 8f, 1.5f, 2f, 1.5f, 2f, 3f }; TableAddress.SetWidths(HWidths); PdfPCell cell; int[] arr = { 3, 7, 9, 10 }; float wid = 0; for (int i = 0; i < HeaderStr.Length; i++) { if (i == 0 || i == 5) { string[] format = HeaderStr[i].Split(Main.delimiter2); Phrase phr = new Phrase(); phr.Add(new Chunk(format[0], font2)); phr.Add(new Chunk(format[1], font1)); cell = new PdfPCell(phr); if (i == 0) { cell.Rowspan = 4; } else { cell.Rowspan = 3; } cell.Colspan = 2; cell.HorizontalAlignment = 0; //0=Left, 1=Centre, 2=Right TableAddress.AddCell(cell); } else { cell = new PdfPCell(new Phrase(HeaderStr[i].Trim(), font1)); cell.Colspan = 5; cell.MinimumHeight = wid; TableAddress.AddCell(cell); } } string[] ColHeaderStr = ColHeader.Split(';'); PdfPTable TableItemDetail = new PdfPTable(7); TableItemDetail.DefaultCell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; TableItemDetail.WidthPercentage = 100; float[] widthProd = new float[] { 1f, 8f, 1.5f, 2f, 1.5f, 2f, 3f }; float[] widthServ = new float[] { 1f, 8f, 1.5f, 2f, 0f, 2f, 3f }; if (ioh.DocumentID == "PRODUCTINVOICEOUT" || ioh.DocumentID == "PRODUCTEXPORTINVOICEOUT") { TableItemDetail.SetWidths(widthProd); } else { TableItemDetail.SetWidths(widthServ); } //Table Row No : 1 (Header Column) for (int i = 0; i < ColHeaderStr.Length; i++) { if (i == (ColHeaderStr.Length - 1) || i == (ColHeaderStr.Length - 2)) { PdfPCell hcell = new PdfPCell(new Phrase(ColHeaderStr[i].Trim() + "\n(" + ioh.CurrencyID + ")", font2)); hcell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; TableItemDetail.AddCell(hcell); } else { PdfPCell hcell = new PdfPCell(new Phrase(ColHeaderStr[i].Trim(), font2)); hcell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; TableItemDetail.AddCell(hcell); } } //--- //Table Row No : 2 (Footer Column) PdfPCell foot = new PdfPCell(new Phrase("")); foot.Colspan = 7; foot.BorderWidthTop = 0; foot.MinimumHeight = 0.5f; TableItemDetail.AddCell(foot); TableItemDetail.HeaderRows = 2; TableItemDetail.FooterRows = 1; TableItemDetail.SkipFirstHeader = false; TableItemDetail.SkipLastFooter = true; //--- int track = 0; decimal dc1 = 0; decimal dc2 = 0; //Table Row No : 3 (Header Column) string[] DetailStr = ColDetailString.Split(Main.delimiter2); float hg = 0f; for (int i = 0; i < DetailStr.Length; i++) { track = 0; hg = TableItemDetail.GetRowHeight(i + 1); string[] str = DetailStr[i].Split(Main.delimiter1); for (int j = 0; j < str.Length; j++) { PdfPCell pcell; if (j == 3 || j == 5 || j == 6) { decimal p = 1; if (Decimal.TryParse(str[j], out p)) { pcell = new PdfPCell(new Phrase(String.Format("{0:0.00}", Convert.ToDecimal(str[j])), font1)); } else { pcell = new PdfPCell(new Phrase("")); } pcell.Border = 0; if (j == 6) { dc1 = Convert.ToDecimal(str[j]); } } else { if (j == 2) { if (str[j].Trim().Length == 0) { pcell = new PdfPCell(new Phrase("", font1)); } else { pcell = new PdfPCell(new Phrase(str[j], font1)); } } else if (j == 4) { int m = 1; if (Int32.TryParse(str[j], out m) == true) { if (Convert.ToInt32(str[j]) == 0) { pcell = new PdfPCell(new Phrase("", font1)); } else { pcell = new PdfPCell(new Phrase(str[j], font1)); } } else { pcell = new PdfPCell(new Phrase(str[j], font1)); } } else { pcell = new PdfPCell(new Phrase(str[j], font1)); } pcell.Border = 0; } pcell.MinimumHeight = 10; if (j == 1) { pcell.HorizontalAlignment = PdfPCell.ALIGN_LEFT; } else { pcell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; } pcell.BorderWidthLeft = 0.01f; pcell.BorderWidthRight = 0.01f; TableItemDetail.AddCell(pcell); } } PdfPCell Temp = new PdfPCell(new Phrase("")); Temp.Border = 0; Temp.BorderWidthLeft = 0.01f; Temp.BorderWidthRight = 0.01f; int dd = 0; if (ioh.TaxAmount != 0) { ////Table Row No : 4 (Total Amount) PdfPCell Temp1 = new PdfPCell(new Phrase("")); Temp1.Border = 0; Temp1.BorderWidthTop = 0.01f; Temp1.BorderWidthLeft = 0.01f; Temp1.BorderWidthRight = 0.01f; TableItemDetail.AddCell(Temp1); //blank cell TableItemDetail.AddCell(Temp1); PdfPCell cellCom = new PdfPCell(new Phrase("", font1)); cellCom.Colspan = 4; cellCom.Border = 0; cellCom.BorderWidthLeft = 0.01f; cellCom.BorderWidthRight = 0.01f; cellCom.BorderWidthTop = 0.01f; cellCom.HorizontalAlignment = PdfPCell.ALIGN_CENTER; TableItemDetail.AddCell(cellCom); PdfPCell cellTot = new PdfPCell(new Phrase(String.Format("{0:0.00}", Convert.ToDecimal(totAmnt)), font2)); cellTot.HorizontalAlignment = PdfPCell.ALIGN_CENTER; TableItemDetail.AddCell(cellTot); dd++; string[] tax = taxStr.Split(Main.delimiter2); for (int i = 0; i < tax.Length - 1; i++) { TableItemDetail.AddCell(Temp); //blank cell TableItemDetail.AddCell(Temp); string[] subtax = tax[i].Split(Main.delimiter1); PdfPCell cellinrtax = new PdfPCell(new Phrase(subtax[0], font1)); cellinrtax.Colspan = 4; cellinrtax.HorizontalAlignment = PdfPCell.ALIGN_RIGHT; TableItemDetail.AddCell(cellinrtax); PdfPCell pcell2; pcell2 = new PdfPCell(new Phrase(String.Format("{0:0.00}", Convert.ToDecimal(subtax[1])), font1)); pcell2.HorizontalAlignment = PdfPCell.ALIGN_CENTER; TableItemDetail.AddCell(pcell2); dd++; } double taxAmRnd = Math.Round(ioh.TaxAmount, 0); if (taxAmRnd != ioh.TaxAmount) { TableItemDetail.AddCell(Temp); //blank cell TableItemDetail.AddCell(Temp); PdfPCell cellTotTax = new PdfPCell(new Phrase("", font1)); cellTotTax.Colspan = 4; cellTotTax.Border = 0; cellTotTax.BorderWidthLeft = 0.01f; cellTotTax.BorderWidthRight = 0.01f; //cellCom.BorderWidthTop = 0.01f; cellTotTax.HorizontalAlignment = PdfPCell.ALIGN_CENTER; TableItemDetail.AddCell(cellTotTax); PdfPCell cellTotTaxValue = new PdfPCell(new Phrase(String.Format("{0:0.00}", Convert.ToDecimal(totAmnt + ioh.TaxAmount)), font2)); cellTotTaxValue.HorizontalAlignment = PdfPCell.ALIGN_CENTER; TableItemDetail.AddCell(cellTotTaxValue); dd++; } } double roundedAmt = Math.Round(ioh.InvoiceAmount, 0); double diffAmount = roundedAmt - ioh.InvoiceAmount; if (diffAmount != 0) { TableItemDetail.AddCell(""); TableItemDetail.AddCell(""); PdfPCell cellRound = new PdfPCell(new Phrase("Rounding off", font1)); cellRound.Colspan = 4; cellRound.HorizontalAlignment = PdfPCell.ALIGN_RIGHT; TableItemDetail.AddCell(cellRound); TableItemDetail.AddCell(new Phrase(String.Format("{0:0.00}", diffAmount), font1)); //table1.AddCell(""); dd++; } TableItemDetail.AddCell(""); TableItemDetail.AddCell(""); PdfPCell cellRoundTot = new PdfPCell(new Phrase("Total", font1)); cellRoundTot.Colspan = 4; cellRoundTot.HorizontalAlignment = PdfPCell.ALIGN_RIGHT; TableItemDetail.AddCell(cellRoundTot); PdfPCell roundTot = new PdfPCell(new Phrase(String.Format("{0:0.00}", roundedAmt), font2)); roundTot.HorizontalAlignment = PdfPCell.ALIGN_CENTER; TableItemDetail.AddCell(roundTot); //table1.AddCell(""); string total = footer1 + NumberToString.convert(roundedAmt.ToString()).Replace("INR", ioh.CurrencyID) + "\n\n"; PdfPCell fcell1 = new PdfPCell(new Phrase((total), font1)); fcell1.Border = 0; fcell1.Colspan = 6; fcell1.HorizontalAlignment = PdfPCell.ALIGN_LEFT; fcell1.BorderWidthLeft = 0.5f; fcell1.BorderWidthBottom = 0.5f; fcell1.BorderWidthRight = 0; fcell1.BorderWidthTop = 0; TableItemDetail.AddCell(fcell1); PdfPCell fcell4 = new PdfPCell(new Phrase("E. & O.E", font1)); fcell4.HorizontalAlignment = PdfPCell.ALIGN_RIGHT; fcell4.Border = 0; fcell4.BorderWidthBottom = 0.5f; fcell4.BorderWidthRight = 0.5f; fcell4.BorderWidthLeft = 0; fcell4.BorderWidthTop = 0; TableItemDetail.AddCell(fcell4); TableItemDetail.KeepRowsTogether(TableItemDetail.Rows.Count - (dd + 4), TableItemDetail.Rows.Count); //int HSNMappCount = TaxDataTable.Rows.Count + 6; //int itemCount = DetailStr.Length; //int tableCount = table1.Rows.Count; //================================================= //DataTable TaxDataTable = new DataTable("TaxDetails"); //DataColumn[] colArr = { new DataColumn("HSN Code"), new DataColumn("Taxable Value"), new DataColumn("CGST %"), // new DataColumn("CGST Amt"), new DataColumn("SGST %"), new DataColumn("SGST Amt"), new DataColumn("IGST %"), // new DataColumn("IGST Amt"), new DataColumn("Total Amt") }; //TaxDataTable.Columns.AddRange(colArr); //DataRow myDataRow = TaxDataTable.NewRow(); //myDataRow[colArr[0]] = "1111"; //myDataRow[colArr[1]] = "1000"; //myDataRow[colArr[2]] = "9"; //myDataRow[colArr[3]] = "200"; //myDataRow[colArr[4]] = "9"; //myDataRow[colArr[5]] = "200"; //myDataRow[colArr[6]] = "14"; //myDataRow[colArr[7]] = "600"; //myDataRow[colArr[8]] = "2000"; //TaxDataTable.Rows.Add(myDataRow); //DataRow myDataRow1 = TaxDataTable.NewRow(); //myDataRow1[colArr[0]] = "2222"; //myDataRow1[colArr[1]] = "2000"; //myDataRow1[colArr[2]] = "9"; //myDataRow1[colArr[3]] = "300"; //myDataRow1[colArr[4]] = "9"; //myDataRow1[colArr[5]] = "400"; //myDataRow1[colArr[6]] = "14"; //myDataRow1[colArr[7]] = "1300"; //myDataRow1[colArr[8]] = "4000"; //TaxDataTable.Rows.Add(myDataRow1); //============================================== InvoiceOutHeaderDB iohDB = new InvoiceOutHeaderDB(); DataTable TaxDataTable = iohDB.taxDetails4Print(IODetails, ioh.DocumentID); PdfPTable TabTaxDetail = new PdfPTable(TaxDataTable.Columns.Count); TabTaxDetail.DefaultCell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; TabTaxDetail.WidthPercentage = 100; //TabTaxDetail.SpacingBefore = 10; PdfPCell cellTax = new PdfPCell(); //Adding columns in table List <string> colListStr = new List <string>(); List <string> colListSubStr = new List <string>(); double amtTot = 0; double TaxTot1 = 0; double TaxTot2 = 0; double TaxTot3 = 0; double TaxTot = 0; Dictionary <int, string> dictTot = new Dictionary <int, string>(); for (int p = 0; p < TaxDataTable.Columns.Count; p++) { if (p != 0 && p != 1 && p != TaxDataTable.Columns.Count - 1) { TaxTot1 = 0; string substr = TaxDataTable.Columns[p].ColumnName; colListStr.Add(substr.Trim()); //CGST colListSubStr.Add(TaxDataTable.Columns[p].ColumnName); //CGST% in subList colListSubStr.Add(TaxDataTable.Columns[p + 1].ColumnName); //CGST amount in subList p++; if (p % 2 != 0) { TaxTot1 = TaxDataTable.AsEnumerable().Sum(c => c.Field <double>(TaxDataTable.Columns[p].ColumnName)); dictTot.Add(p, String.Format("{0:0.00}", Convert.ToDecimal(TaxTot1))); } } else { colListStr.Add(TaxDataTable.Columns[p].ColumnName); if (p == 1) { amtTot = TaxDataTable.AsEnumerable().Sum(c => c.Field <double>(TaxDataTable.Columns[p].ColumnName)); dictTot.Add(p, String.Format("{0:0.00}", Convert.ToDecimal(amtTot))); } if (p == TaxDataTable.Columns.Count - 1) { TaxTot = TaxDataTable.AsEnumerable().Sum(c => c.Field <double>(TaxDataTable.Columns[p].ColumnName)); dictTot.Add(p, String.Format("{0:0.00}", Convert.ToDecimal(TaxTot))); } } } foreach (string str in colListStr) { int index = colListStr.FindIndex(x => x == str); if (index == 0 || index == 1 || index == colListStr.Count - 1) { cellTax = new PdfPCell(); cellTax.Rowspan = 2; Paragraph p = new Paragraph(str, font2); p.Alignment = Element.ALIGN_CENTER; cellTax.AddElement(p); TabTaxDetail.AddCell(cellTax); } else { cellTax = new PdfPCell(); cellTax.Colspan = 2; Paragraph p = new Paragraph(str, font2); p.Alignment = Element.ALIGN_CENTER; cellTax.AddElement(p); TabTaxDetail.AddCell(cellTax); } } foreach (string str in colListSubStr) { cellTax = new PdfPCell(); Paragraph p = new Paragraph(str, font2); p.Alignment = Element.ALIGN_CENTER; cellTax.AddElement(p); TabTaxDetail.AddCell(cellTax); } int t = 0; foreach (DataRow row in TaxDataTable.Rows) { int l = 0; foreach (DataColumn col in TaxDataTable.Columns) { cellTax = new PdfPCell(); if (l == 1 || l % 2 != 0 || l == TaxDataTable.Columns.Count - 1) { Paragraph p = new Paragraph(String.Format("{0:0.00}", Convert.ToDecimal(row[col].ToString())), font1); p.Alignment = Element.ALIGN_CENTER; cellTax.AddElement(p); TabTaxDetail.AddCell(cellTax); } else { Paragraph p = new Paragraph(row[col].ToString(), font1); p.Alignment = Element.ALIGN_CENTER; cellTax.AddElement(p); TabTaxDetail.AddCell(cellTax); } t++; l++; } } for (int k = 0; k < TaxDataTable.Columns.Count; k++) { if (k == 0) { cellTax = new PdfPCell(); Paragraph p = new Paragraph("Total", font2); p.Alignment = Element.ALIGN_CENTER; cellTax.AddElement(p); TabTaxDetail.AddCell(cellTax); } else if (dictTot.ContainsKey(k)) { cellTax = new PdfPCell(); Paragraph p = new Paragraph(dictTot[k], font2); p.Alignment = Element.ALIGN_CENTER; cellTax.AddElement(p); TabTaxDetail.AddCell(cellTax); } else { cellTax = new PdfPCell(); Paragraph p = new Paragraph("", font1); p.Alignment = Element.ALIGN_CENTER; cellTax.AddElement(p); TabTaxDetail.AddCell(cellTax); } } //TabTaxDetail.KeepRowsTogether(TabTaxDetail.Rows.Count - 10, TabTaxDetail.Rows.Count); TabTaxDetail.KeepTogether = true; //Bank dtails and authorised Signature PdfPTable tableFooter = new PdfPTable(2); tableFooter.WidthPercentage = 100; Phrase phrs = new Phrase(); phrs.Add(new Chunk("\nBank Details for Payment", font2)); phrs.Add(new Chunk(footer2, font1)); PdfPCell fcell2 = new PdfPCell(phrs); fcell2.HorizontalAlignment = PdfPCell.ALIGN_LEFT; fcell2.BorderWidthRight = 0; tableFooter.AddCell(fcell2); string[] ft = footer3.Split(';'); PdfPCell fcell3 = new PdfPCell(); Chunk ch1 = new Chunk(ft[0], font1); Chunk ch2 = new Chunk(ft[1], font1); Phrase phrase = new Phrase(); phrase.Add(ch1); for (int i = 0; i < 3; i++) { phrase.Add(Chunk.NEWLINE); } phrase.Add(ch2); Paragraph para = new Paragraph(); para.Add(phrase); para.Alignment = Element.ALIGN_RIGHT; fcell3.AddElement(para); fcell3.Border = 0; fcell3.BorderWidthRight = 0.5f; fcell3.BorderWidthBottom = 0.5f; fcell3.MinimumHeight = 50; tableFooter.AddCell(fcell3); PdfPTable tableSub = new PdfPTable(1); tableSub.DefaultCell.Border = 0; tableSub.DefaultCell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; tableSub.AddCell(new Phrase("Subject To Bangalore Jurisdiction", font2)); PdfPCell celSub = new PdfPCell(tableSub); celSub.Border = 0; celSub.Colspan = 2; tableFooter.AddCell(celSub); //======= doc.Add(tableHeader); doc.Add(ParagraphDocumentName); doc.Add(TableAddress); doc.Add(TableItemDetail); doc.Add(TabTaxDetail); doc.Add(tableFooter); doc.Close(); if (ioh.status == 0 && ioh.DocumentStatus < 99) { String wmurl = ""; wmurl = "004.png"; PrintWaterMark.PdfStampWithNewFile(wmurl, sfd.FileName); } if (ioh.status == 98) { String wmurl = ""; wmurl = "003.png"; PrintWaterMark.PdfStampWithNewFile(wmurl, sfd.FileName); } MessageBox.Show("Document Saved"); } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error-" + ex.ToString()); MessageBox.Show("Failed TO Save"); } } catch (Exception ex) { MessageBox.Show("Exception : " + ex.ToString()); MessageBox.Show("Failed TO Save"); } }
/// <summary> /// Concatenates two or more PDF files into one file. /// </summary> /// <param name="inputFiles">A string array containing the names of the pdf files to concatenate</param> /// <param name="outputFile">Name of the concatenated file.</param> public void ConcatenatePDFFiles(String[] inputFiles, String outputFile) { if (inputFiles != null && inputFiles.Length > 0) { if (!String.IsNullOrEmpty(outputFile) && !String.IsNullOrWhiteSpace(outputFile)) { var concatDocument = new iTextSharpText.Document(); var outputCopy = new iTextSharpPDF.PdfCopy(concatDocument, new FileStream(outputFile, FileMode.Create, FileAccess.ReadWrite)); concatDocument.Open(); try { for (int loop = 0; loop <= inputFiles.GetUpperBound(0); loop++) { var inputDocument = new iTextSharpPDF.PdfReader(inputFiles[loop]); for (int pageLoop = 1; pageLoop <= inputDocument.NumberOfPages; pageLoop++) { concatDocument.SetPageSize(inputDocument.GetPageSizeWithRotation(pageLoop)); outputCopy.AddPage(outputCopy.GetImportedPage(inputDocument, pageLoop)); } inputDocument.Close(); outputCopy.FreeReader(inputDocument); inputDocument = null; } concatDocument.Close(); outputCopy.Close(); } catch { if (concatDocument != null && concatDocument.IsOpen()) concatDocument.Close(); if (outputCopy != null) outputCopy.Close(); if (File.Exists(outputFile)) { try { File.Delete(outputFile); } catch { } } throw; } } else { throw new ArgumentNullException("outputFile", exceptionArgumentNullOrEmptyString); } } else { throw new ArgumentNullException("inputFiles", exceptionArgumentNullOrEmptyString); } }
protected void Page_Load(object sender, EventArgs e) { iTextSharp.text.pdf.BarcodeQRCode qrcode = new BarcodeQRCode("testing", 50, 50, null); iTextSharp.text.Image img1 = qrcode.GetImage(); Document doc = new Document(); try { PdfWriter.GetInstance(doc, new FileStream(Server.MapPath("css") + "/Images.pdf", FileMode.Create)); doc.Open(); doc.Add(new Paragraph("GIF")); doc.Add(img1); MemoryStream ms = new MemoryStream(img1.OriginalData); System.Drawing.Image returnImage = System.Drawing.Image.FromStream(ms); // img = returnImage.Save(new Stream(), System.Drawing.Imaging.ImageFormat.Jpeg); } catch (Exception ex) { } finally { doc.Close(); } }