The quick start guides you through the steps of adding C1PdfDocument in your MVC web application and adding data to it. Complete the following steps to see how the data appears in the generated PDF after data binding:
Back to TopCreate a new MVC application using the ComponentOne or VisualStudio templates. For more information about creating an MVC application, see Configuring your MVC Application topic.
The example uses C1NWind database. The C1NWind.mdf file is available on your system at the following location:
Documents\ComponentOne Samples\ASP.NET MVC\MVC\MvcExplorer\App_Data
AppData
folder in the Solution Explorer.Models|Add New Item|Data
, and select ADO.NET Entity Data Model.Products
table and click Finish.If you can see C1NWind.edmx added to your project under the Models folder, you have successfully configured the data source for your application.
Back to TopComplete the following steps to initialize a FlexGrid control.
Add a new Controller
PDFController
).C# |
Copy Code
|
---|---|
using <ApplicationName>.Models;
|
C# |
Copy Code
|
---|---|
private readonly C1NWindEntities _dataBase = new C1NWindEntities(); private C1PdfDocument _c1Pdf; public ActionResult CreatePdf() { try { InitialPdfDocument(); var stream = new MemoryStream(); _c1Pdf.Save(stream); stream.Position = 0; return File(stream, "application/pdf"); } catch (Exception ex) { return Content(ex.Message); } } |
C# |
Copy Code
|
---|---|
private readonly Font _fontBody = new Font("Tahoma", 10); private readonly Font _fontTitle = new Font("Tahoma", 15, FontStyle.Bold); private readonly Font _fontHeader = new Font("Tahoma", 11, FontStyle.Bold); private StringFormat _sfRight; private StringFormat _sfRightCenter; public void InitialPdfDocument() { _c1Pdf = new C1PdfDocument(); //create StringFormat for right-aligned fields _sfRight = new StringFormat(); _sfRight.Alignment = StringAlignment.Far; _sfRightCenter = new StringFormat(); _sfRightCenter.Alignment = StringAlignment.Far; _sfRightCenter.LineAlignment = StringAlignment.Center; //initialize pdf generator _c1Pdf.Clear(); //get page rectangle, discount margins RectangleF rcPage = _c1Pdf.PageRectangle; rcPage.Inflate(-72, -92); //loop through selected categories int page = 0; List<Category> categories = _dataBase.Categories.ToList(); foreach (Category category in categories) { //add page break, update page counter if (page > 0) _c1Pdf.NewPage(); page++; //get current category name string catName = category.CategoryName; //add title to page _c1Pdf.DrawString(catName, _fontTitle, Brushes.Blue, rcPage); //add outline entry _c1Pdf.AddBookmark(catName, 0, 0); //build row template RectangleF[] rcRows = new RectangleF[6]; for (int i = 0; i < rcRows.Length; i++) { rcRows[i] = RectangleF.Empty; rcRows[i].Location = new PointF(rcPage.X, rcPage.Y + _fontHeader.SizeInPoints + 10); rcRows[i].Size = new SizeF(0, _fontBody.SizeInPoints + 3); } rcRows[0].Width = 110; // Product Name rcRows[1].Width = 60; // Unit Price rcRows[2].Width = 80; // Qty/Unit rcRows[3].Width = 60; // Stock Units rcRows[4].Width = 60; // Stock Value rcRows[5].Width = 60; // Reorder for (int i = 1; i < rcRows.Length; i++) rcRows[i].X = rcRows[i - 1].X + rcRows[i - 1].Width + 8; //add column headers _c1Pdf.FillRectangle(Brushes.DarkGray, RectangleF.Union(rcRows[0], rcRows[5])); _c1Pdf.DrawString("Product Name", _fontHeader, Brushes.White, rcRows[0]); _c1Pdf.DrawString("Unit Price", _fontHeader, Brushes.White, rcRows[1], _sfRight); _c1Pdf.DrawString("Qty/Unit", _fontHeader, Brushes.White, rcRows[2]); _c1Pdf.DrawString("Stock Units", _fontHeader, Brushes.White, rcRows[3], _sfRight); _c1Pdf.DrawString("Stock Value", _fontHeader, Brushes.White, rcRows[4], _sfRight); _c1Pdf.DrawString("Reorder", _fontHeader, Brushes.White, rcRows[5]); //loop through products in this category List<Product> products = _dataBase.Products.Where(pro => pro.CategoryID == category.CategoryID).ToList(); foreach (Product product in products) { //move on to next row for (int i = 0; i < rcRows.Length; i++) rcRows[i].Y += rcRows[i].Height; _c1Pdf.DrawString(product.ProductName, _fontBody, Brushes.Black, rcRows[0]); _c1Pdf.DrawString(string.Format("{0:c}", product.UnitPrice), _fontBody, Brushes.Black, rcRows[1], _sfRight); _c1Pdf.DrawString(string.Format("{0}", product.QuantityPerUnit), _fontBody, Brushes.Black, rcRows[2]); _c1Pdf.DrawString(string.Format("{0}", product.UnitsInStock), _fontBody, Brushes.Black, rcRows[3], _sfRight); _c1Pdf.DrawString(string.Format("{0:c}", product.UnitPrice * product.UnitsInStock), _fontBody, Brushes.Black, rcRows[4], _sfRight); _c1Pdf.DrawString(string.Format("{0}", product.ReorderLevel), _fontBody, Brushes.Black, rcRows[5], _sfRight); } } } |
Add a View for the controller:
ExcelController
) to open it.Index()
.Index.cshtml
to open it.C# |
Copy Code
|
---|---|
@{ Layout = null; } @Html.ActionLink("GenerateExcel", "GenerateExcel") |
This creates a PDF with NorthWind product information wherein each product category is placed on a separate page and added to an outline structure with bookmarks.