private void btn_placeOrder_Click(object sender, EventArgs e) { using (MySqlConnection mysqlCon = new MySqlConnection(connectionString)) { MySqlCommand cmd; cmd = new MySqlCommand("UPDATE purchase_order SET Status='Placed' WHERE OrderID=@OrderID", mysqlCon); mysqlCon.Open(); cmd.Parameters.AddWithValue("@OrderID", order_id); cmd.ExecuteNonQuery(); MessageBox.Show("Order Status Updated Successfully"); if (txt_orderRef.Text != "") { Document pdoc = new Document(PageSize.A4, 50f, 0f, 0f, 30f); PdfWriter pWriter = PdfWriter.GetInstance(pdoc, new FileStream("C:/" + txt_orderRef.Text + ".pdf", FileMode.Create)); pdoc.Open(); System.Drawing.Image PImage = System.Drawing.Image.FromFile("C:\\ReportHeader.png"); iTextSharp.text.Image ItextImage = iTextSharp.text.Image.GetInstance(PImage, System.Drawing.Imaging.ImageFormat.Png); ItextImage.Alignment = Element.ALIGN_CENTER; pdoc.Add(ItextImage); Paragraph address = new Paragraph("KHS2 Cnstructions (Pvt) Ltd ," + "\n" + "No: 01 ," + "\n" + "Dane's Plains ," + "\n" + "Katukurunda ," + "\n" + "Kaluthara North." + "\n"); address.Alignment = Element.ALIGN_LEFT; pdoc.Add(address); Paragraph heading = new Paragraph("\n" + "\n" + "Prchase Order Requisition" + "\n" + "\n"); heading.Alignment = Element.ALIGN_CENTER; pdoc.Add(heading); Paragraph para = new Paragraph("\n" + "Purchase Order Details are as of below. Please be kind enough to let us know if there are any information that should be modified." + "\n" + "\n" + "\n"); para.Alignment = Element.ALIGN_LEFT; pdoc.Add(para); Paragraph para1 = new Paragraph("Order Reference : " + txt_orderRef.Text + "\n" + "Construction Site : " + txt_site.Text + "\n" + "Order Material : " + txt_material.Text + "\n" + "Order Description : " + txt_des.Text + "\n" + "Supplier Name : " + txt_supplier.Text + "\n" + "Agreed Price : LKR. " + txt_amount.Text + "\n" + "Delivery Date : " + dtp_po.Value + "\n" + "\n"); para1.Alignment = Element.ALIGN_BASELINE; pdoc.Add(para1); Paragraph para2 = new Paragraph("\n" + "Thanks & Regards!" + "\n"); para2.Alignment = Element.ALIGN_LEFT; pdoc.Add(para2); System.Drawing.Image PImage1 = System.Drawing.Image.FromFile("C:\\stamp.png"); iTextSharp.text.Image ItextImage1 = iTextSharp.text.Image.GetInstance(PImage1, System.Drawing.Imaging.ImageFormat.Png); ItextImage1.Alignment = Element.ALIGN_LEFT; pdoc.Add(ItextImage1); pdoc.Close(); MessageBox.Show("Order Report Created Successfully."); } GridFill(); } if (txt_orderRef.Text != "") { string userMail = null; using (MySqlConnection mysqlCon = new MySqlConnection(connectionString)) { mysqlCon.Open(); String sql = "SELECT Email FROM pml_user WHERE Username='******'"; MySqlCommand mySc = new MySqlCommand(sql, mysqlCon); MySqlDataReader myDr = mySc.ExecuteReader(); while (myDr.Read()) { userMail = myDr.GetValue(0).ToString(); } } string Tomail = null; using (MySqlConnection mysqlCon = new MySqlConnection(connectionString)) { mysqlCon.Open(); String sql = "SELECT Email FROM suppliers WHERE name='" + txt_supplier.Text + "'"; MySqlCommand mySc = new MySqlCommand(sql, mysqlCon); MySqlDataReader myDr = mySc.ExecuteReader(); while (myDr.Read()) { Tomail = myDr.GetValue(0).ToString(); } } string ccMail = null; using (MySqlConnection mysqlCon = new MySqlConnection(connectionString)) { mysqlCon.Open(); String sql = "SELECT Email FROM pml_user WHERE Username='******'"; MySqlCommand mySc = new MySqlCommand(sql, mysqlCon); MySqlDataReader myDr = mySc.ExecuteReader(); while (myDr.Read()) { ccMail = myDr.GetValue(0).ToString(); } } Mail.userEmail = userMail; Mail.toName = Tomail; Mail.ccName = ccMail; Mail.attachment = "C:\\" + txt_orderRef.Text + ".pdf"; Mail.subject = "Purchase Order Requisition"; Mail.message = "Please find the attached pdf file of order details of " + txt_material.Text + " Order No: " + txt_orderRef.Text + "\n" + "\n" + "Thanks & Regards!"; Mail openMail = new Mail(); openMail.Show(); } else { MessageBox.Show("Please select an order to be placed"); } }