private void button1_Click(object sender, EventArgs e)
{
string inputFile = @"..\..\..\..\..\..\Data\DigitalSignature.pdf";
//Load a PDF document
PdfDocument doc = new PdfDocument();
doc.LoadFromFile(inputFile);
//Get the first page
PdfPageBase page = doc.Pages[0];
//Load a certificate .pfx file
String pfxPath = @"..\..\..\..\..\..\Data\ComodoSSL.pfx";
PdfCertificate cer = new PdfCertificate(pfxPath, "08100601", X509KeyStorageFlags.Exportable);
//Add a signature to the specified position
PdfSignature signature = new PdfSignature(doc, page, cer, "signature");
signature.Bounds = new RectangleF(new PointF(90, 550), new SizeF(180, 90));
//set the signature content
signature.NameLabel = "Digitally signed by:Gary";
signature.LocationInfoLabel = "Location:";
signature.LocationInfo = "CN";
signature.ReasonLabel = "Reason: ";
signature.Reason = "Ensure authenticity";
signature.ContactInfoLabel = "Contact Number: ";
signature.ContactInfo = "028-81705109";
signature.DocumentPermissions = PdfCertificationFlags.AllowFormFill | PdfCertificationFlags.ForbidChanges;
signature.GraphicsMode = GraphicMode.SignImageAndSignDetail;
signature.SignImageSource = PdfImage.FromFile(@"..\..\..\..\..\..\Data\logo.png");
//Configure OCSP which must conform to RFC 2560
signature.ConfigureHttpOCSP(null, null);
//Save the PDF file
string outputFile = "result.pdf";
doc.SaveToFile(outputFile, FileFormat.PDF);
//Launch the file
PDFDocumentViewer(outputFile);
}
private void GenerateButton_Click(object sender, EventArgs e)
{
matric = matricNo.Text.ToLower();
if (!(TransactionID.Text.Equals("") || ReceiptID.Text.Equals("") || matricNo.Text.Equals("")))
{
MySqlCommand command = new MySqlCommand("SELECT * FROM `data` WHERE `matric`=@user", db.getConnection());
command.Parameters.Add("@user", MySqlDbType.VarChar).Value = matric;
db.openConnection();
MySqlDataReader rdr = command.ExecuteReader();
matric = "";
while (rdr.Read())
{
f_data = rdr.GetString(4);
name = rdr.GetString(2);
matric = rdr.GetString(3);
}
rdr.Close();
matric = matric.ToLower();
if (matric.Equals(matricNo.Text))
{
String t_id = TransactionID.Text;
String r_id = ReceiptID.Text;
Document doc = new Document();
string newPath = Directory.GetCurrentDirectory();
doc.LoadFromFile(newPath + "\\Receipt Template.docx");
doc.Replace("_Matric_", matric, false, true);
doc.Replace("_Id_", t_id, false, true);
doc.Replace("_Receipt_", r_id, false, true);
doc.Replace("_Name_", name, false, true);
doc.Replace("_Date_", DateTime.Today.ToShortDateString(), false, true);
doc.Replace("_Method_", "Quickteller", false, true);
//Save PDF file.
doc.SaveToFile("Receipt.pdf", Spire.Doc.FileFormat.PDF);
pdf.LoadFromFile("Receipt.pdf");
//Set document info
pdf.DocumentInformation.Author = "Bowen University";
pdf.DocumentInformation.Creator = "Ali Akolade";
pdf.DocumentInformation.Keywords = "Bursary, Receipt, Clearance";
pdf.DocumentInformation.Producer = "Bowen University";
pdf.DocumentInformation.Subject = f_data;
pdf.DocumentInformation.Title = "Bursary Clearance of " + name;
//File info
pdf.FileInfo.CrossReferenceType = PdfCrossReferenceType.CrossReferenceStream;
pdf.FileInfo.IncrementalUpdate = false;
//Set an owner password, enable the permissions of Printing and Copying, set encryption level
String pfxPath = "AliAkolade.pfx";
PdfCertificate cer = new PdfCertificate(pfxPath, "Abc123!@#$%^&*()2020", X509KeyStorageFlags.Exportable);
//Get the first page
PdfPageBase page = pdf.Pages[0];
//Add a signature to the specified position
PdfSignature signature = new PdfSignature(pdf, page, cer, "signature");
//signature.Bounds = new RectangleF(new PointF(90, 550), new SizeF(180, 90));
//set the signature content
signature.NameLabel = "Digitally signed by: Bowen University";
signature.LocationInfoLabel = "Location: Iwo, Osun State";
signature.LocationInfo = "Iwo";
signature.ReasonLabel = "Reason: Biometric Security Certificate";
signature.Reason = "Ensures authenticity";
signature.ContactInfoLabel = "Contact Number: 09032942619";
signature.ContactInfo = "@AliAkolade";
signature.DocumentPermissions = PdfCertificationFlags.ForbidChanges;
signature.GraphicsMode = GraphicMode.SignNameAndSignDetail;
//signature.SignImageSource = PdfImage.FromFile(@"..\..\..\..\..\..\Data\logo.png");
//Configure OCSP which must conform to RFC 2560
signature.ConfigureHttpOCSP(null, null);
//
command = new MySqlCommand("INSERT INTO `receipts`(`Matric Number`, `Transaction ID`, `Receipt ID`, `Amount Paid`, `Amount Due`) VALUES (@matric, @t_id, @r_id, @paid, @due)", db.getConnection());
command.Parameters.Add("@matric", MySqlDbType.VarChar).Value = matric;
command.Parameters.Add("@t_id", MySqlDbType.Int64).Value = t_id;
command.Parameters.Add("@r_id", MySqlDbType.Int64).Value = r_id;
command.Parameters.Add("@paid", MySqlDbType.Int64).Value = 824662;
command.Parameters.Add("@due", MySqlDbType.Int64).Value = 0;
db.openConnection();
if (command.ExecuteNonQuery() == 1)
{
AutoClosingMessageBox.Show("Added to Database", "RECEIPT GENERATION SUCCESSFUL", 1500);
}
db.closeConnection();
//Save and launch
SaveFileDialog dialog = new SaveFileDialog();
dialog.Filter = "PDF document (*.pdf)|*.pdf";
DialogResult result = dialog.ShowDialog();
string fileName = dialog.FileName;
if (result == DialogResult.OK)
{
pdf.SaveToFile(fileName);
AutoClosingMessageBox.Show("Save Successful", "", 1000);
}
System.Diagnostics.Process.Start(fileName);
}
else
{
AutoClosingMessageBox.Show("Please Input Valid Matric Number", "ERROR", 1000);
}
}
else
{
AutoClosingMessageBox.Show("Please Input Valid Details", "ERROR", 1000);
}
}