// ---------------------------------------------------------------------------
/**
* Creates a PDF document.
*/
public byte[] CreatePdf() {
using (MemoryStream ms = new MemoryStream()) {
using (var c = AdoDB.Provider.CreateConnection()) {
c.ConnectionString = AdoDB.CS;
c.Open();
// step 1
using (Document document = new Document(PageSize.A5)) {
// step 2
PdfWriter writer = PdfWriter.GetInstance(document, ms);
// step 3
document.Open();
// step 4
int[] start = new int[3];
for (int i = 0; i < 3; i++) {
start[i] = writer.PageNumber;
AddParagraphs(document, c, SQL[i], FIELD[i]);
document.NewPage();
}
PdfPageLabels labels = new PdfPageLabels();
labels.AddPageLabel(start[0], PdfPageLabels.UPPERCASE_LETTERS);
labels.AddPageLabel(start[1], PdfPageLabels.DECIMAL_ARABIC_NUMERALS);
labels.AddPageLabel(
start[2], PdfPageLabels.DECIMAL_ARABIC_NUMERALS,
"Movies-", start[2] - start[1] + 1
);
writer.PageLabels = labels;
}
return ms.ToArray();
}
}
}