} //button to save pdf file about all the customers in the table
private void showSuppliersbtn_Click(object sender, EventArgs e)
{
Pfile pd = new Pfile("Suppliers Report.pdf");
pd.doc.OpenDocument();
pd.SetTitle("Suppliers");
PdfPTable myTable = new PdfPTable(5);
float[] widthCell = new float[5];
for (int i = 0; i < 5; i++)
{
widthCell[i] = 20;
}
PdfPCell myCell = new PdfPCell();
myCell.FixedHeight = 20;
myCell.HorizontalAlignment = Element.ALIGN_CENTER;
myCell.VerticalAlignment = Element.ALIGN_CENTER;
suppliers[] supp;
supp = dataB.getAllsuppliers();
myCell.Phrase = new Phrase("suppplier ID");
myTable.AddCell(myCell);
myCell.Phrase = new Phrase(" Name");
myTable.AddCell(myCell);
myCell.Phrase = new Phrase("Address");
myTable.AddCell(myCell);
myCell.Phrase = new Phrase("Phone Number");
myTable.AddCell(myCell);
myCell.Phrase = new Phrase("Email");
myTable.AddCell(myCell);
for (int i = 0; i < supp.Length; i++)
{
myCell.Phrase = new Phrase(supp[i].Supplier_id.ToString());
myTable.AddCell(myCell);
myCell.Phrase = new Phrase(supp[i].Sup_name.ToString());
myTable.AddCell(myCell);
myCell.Phrase = new Phrase(supp[i].Address.ToString());
myTable.AddCell(myCell);
myCell.Phrase = new Phrase(supp[i].Phone.ToString());
myTable.AddCell(myCell);
myCell.Phrase = new Phrase(supp[i].Email.ToString());
myTable.AddCell(myCell);
}
try
{
pd.doc.Add(myTable);
MessageBox.Show("Success file downloaded");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
pd.CloseReport();
}//button to save pdf file about all the suppliers in the table
private void ShowCustomersBtn_Click_1(object sender, EventArgs e)
{
Pfile pd = new Pfile("Customers Report.pdf");
pd.doc.OpenDocument();
pd.SetTitle("Customers");
PdfPTable myTable = new PdfPTable(7);
float[] widthCell = new float[7];
for (int i = 0; i < 7; i++)
{
widthCell[i] = 20;
}
PdfPCell myCell = new PdfPCell();
myCell.FixedHeight = 20;
myCell.HorizontalAlignment = Element.ALIGN_CENTER;
myCell.VerticalAlignment = Element.ALIGN_CENTER;
Customers[] custo;
custo = dataB.getAllCustomers();
myCell.Phrase = new Phrase("Customer ID");
myTable.AddCell(myCell);
myCell.Phrase = new Phrase(" First Name");
myTable.AddCell(myCell);
myCell.Phrase = new Phrase(" Last Name");
myTable.AddCell(myCell);
myCell.Phrase = new Phrase("Address");
myTable.AddCell(myCell);
myCell.Phrase = new Phrase("Email");
myTable.AddCell(myCell);
myCell.Phrase = new Phrase("Phone Number");
myTable.AddCell(myCell);
myCell.Phrase = new Phrase("Amount");
myTable.AddCell(myCell);
for (int i = 0; i < custo.Length; i++)
{
myCell.Phrase = new Phrase(custo[i].Customer_id.ToString());
myTable.AddCell(myCell);
myCell.Phrase = new Phrase(custo[i].Customer_FirstName.ToString());
myTable.AddCell(myCell);
myCell.Phrase = new Phrase(custo[i].Customer_LastName.ToString());
myTable.AddCell(myCell);
myCell.Phrase = new Phrase(custo[i].Customer_Address.ToString());
myTable.AddCell(myCell);
myCell.Phrase = new Phrase(custo[i].Customer_Email.ToString());
myTable.AddCell(myCell);
myCell.Phrase = new Phrase(custo[i].Customer_PhoneNo.ToString());
myTable.AddCell(myCell);
myCell.Phrase = new Phrase(custo[i].Customer_amount.ToString());
myTable.AddCell(myCell);
}
try
{
pd.doc.Add(myTable);
MessageBox.Show("Success file downloaded");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
pd.CloseReport();
} //button to save pdf file about all the customers in the table