// ---------------------------------------------------------------------------
/**
* Creates a PDF document.
*/
public byte[] CreatePdf()
{
using (MemoryStream ms = new MemoryStream())
{
// step 1
using (Document document = new Document())
{
// step 2
PdfWriter.GetInstance(document, ms);
// step 3
document.Open();
// step 4
// Add text with a local destination
Paragraph p = new Paragraph();
Chunk top = new Chunk("Country List", FilmFonts.BOLD);
top.SetLocalDestination("top");
p.Add(top);
document.Add(p);
// Add text with a link to an external URL
Chunk imdb = new Chunk("Internet Movie Database", FilmFonts.ITALIC);
imdb.SetAction(new PdfAction(new Uri("http://www.imdb.com/")));
p = new Paragraph(
@"Click on a country, and you'll get a list of movies,
containing links to the "
);
p.Add(imdb);
p.Add(".");
document.Add(p);
// Add text with a remote goto
p = new Paragraph("This list can be found in a ");
Chunk page1 = new Chunk("separate document");
page1.SetAction(new PdfAction(RESULT1, 1));
p.Add(page1);
p.Add(".");
document.Add(p);
document.Add(Chunk.NEWLINE);
// Get a list with countries from the database
var SQL =
@"SELECT DISTINCT mc.country_id, c.country, count(*) AS c
FROM film_country c, film_movie_country mc
WHERE c.id = mc.country_id
GROUP BY mc.country_id, country
ORDER BY c DESC";
using (var c = AdoDB.Provider.CreateConnection())
{
c.ConnectionString = AdoDB.CS;
using (DbCommand cmd = c.CreateCommand())
{
cmd.CommandText = SQL;
c.Open();
using (var r = cmd.ExecuteReader())
{
while (r.Read())
{
Paragraph country = new Paragraph(r["country"].ToString());
country.Add(": ");
Chunk link = new Chunk(string.Format(
"{0} movies", r["c"].ToString()
));
link.SetAction(PdfAction.GotoRemotePage(
RESULT1,
r["country_id"].ToString(),
false,
true
));
country.Add(link);
document.Add(country);
}
}
}
}
document.Add(Chunk.NEWLINE);
// Add text with a local goto
p = new Paragraph("Go to ");
top = new Chunk("top");
top.SetAction(PdfAction.GotoLocalPage("top", false));
p.Add(top);
p.Add(".");
document.Add(p);
}
return(ms.ToArray());
}
}
