[]
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:
Create a new MVC application using the ComponentOne or VisualStudio templates. For more information about creating an MVC application, see Configuring your MVC Application topic.
type=note
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.
Complete the following steps to initialize a FlexGrid control.
Add a new Controller
In the Solution Explorer, right click the folder Controllers.
From the context menu, select Add | Controller. The Add Scaffold dialog appears.
Complete the following steps in the Add Scaffold dialog:
PDFController
).Include the MVC references as shown below.
using <ApplicationName>.Models;
Generate a PDF using CreatePdf method as shown in the following 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);
}
}
Add pages to the PDF for each product category using the following 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:
From the Solution Explorer, expand the folder Controllers and double click the controller (for example: ExcelController
) to open it.
Place the cursor inside the method Index()
.
Right click and select Add View. The Add View dialog appears.
In the Add View dialog, verify that the View name is Index and View engine is Razor (CSHTML).
Click Add. A view is added for the controller.
In the Solution Explorer, double click Index.cshtml
to open it.
Replace the default code in the Views\Index.cshtml file with the following code to display a message about the PDF being generated.
@{
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.