public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
POPrintout rpt = new POPrintout();
rpt.Site = this.Site;
return(rpt);
}
private void PO_PrintScreen_Load(object sender, EventArgs e)
{ //When screen loads, details of the RFQ Printout should already be displayed.
//---MYSQL CONNECTION
connection = new MySqlConnection(ConnectionStringManager.reicpomsConnection.ConnectionString);
connection.Open();
//DEBUG MESSAGES
if (connection.State == System.Data.ConnectionState.Open)
{
MessageBox.Show("Crystal Report: Connection to SQL successful!");
}
else
{
MessageBox.Show("Crystal Report: Connection to SQL failed!");
}
//---SELECT Statements
reicpomsds = new reicpomsDataSet();
//Data from supplier_t
string selectRFQSupplier = string.Format("SELECT supplier_t.supplier_id, supplier_name, contact_person, contact_number, email_address, address " +
"FROM po_t, supplier_t " +
"WHERE po_t = '{0}' " +
"AND po_t.supplier_id = supplier_t.supplier_id;", PONo);
adapter = new MySqlDataAdapter(selectRFQSupplier, connection);
adapter.Fill(reicpomsds, "supplier_t");
//Data from po_order_line_t, inserted into item_t
string selectPOOrderLineItems = string.Format("SELECT item_t.part_number, item_name, item_description, supplier_unit_price, mark_up_percentage, reic_unit_price, minimum_order_quantity, unit_of_measurement, from_date, to_date, supplier_id " +
"FROM po_order_line_t, item_t " +
"WHERE po_no = '{0}' " +
"AND po_order_line_t.part_number = item_t.part_number;", PONo);
adapter = new MySqlDataAdapter(selectPOOrderLineItems, connection);
adapter.Fill(reicpomsds, "item_t");
//Data from po_t
string selectPO = string.Format("SELECT * FROM po_t WHERE po_no='{0}';", PONo);
adapter = new MySqlDataAdapter(selectPO, connection);
adapter.Fill(reicpomsds, "po_t");
//Data from po_order_line_t
string selectPOOrderLine = string.Format("SELECT * FROM po_order_line_t WHERE po_no='{0}';", PONo);
adapter = new MySqlDataAdapter(selectPOOrderLine, connection);
adapter.Fill(reicpomsds, "po_order_line_t");
connection.Close();
//---INSTANTIATE CRYSTAL REPORT
POPrintout po = new POPrintout();
po.Load();
po.SetDataSource(reicpomsds); //Added a code snippet in app.config file. If else, will result to a System.IOFileNotFoundException error.
string fileName = "C:\\REIC Files\\Purchase Orders\\PO " + PONo + ".pdf";
if (FirstTime == true)
{
po.ExportToDisk(ExportFormatType.PortableDocFormat, fileName);
MessageBox.Show("A PDF file of this Purchase Order can be found in \nC:\\REIC Files\\Purchase Orders.");
}
CrystalReportViewer.ReportSource = po; //Display POPrintout.rpt in the print preview
}
