public static void AddInvoicePurchaseOrder(InvoicePurchaseOrder purchase) { SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); SqlCommand command; connection.Open(); try { command = connection.CreateCommand(); command.CommandText = "INSERT INTO UnileverInvoiceTrackingSystem.dbo.purchaseorder (invoiceno, purchaseorderno, attachment, purchaseorderdate) VALUES (@IN,@PON,@ATT,@POD);"; command.Parameters.AddWithValue("@IN", Convert.ToInt64(purchase.InvoiceNo)); command.Parameters.AddWithValue("PON", Convert.ToString(purchase.PurchaseOrderNo)); command.Parameters.AddWithValue("@ATT", Convert.ToString(purchase.Attachment)); command.Parameters.AddWithValue("@POD", Convert.ToDateTime(purchase.PurchaseOrderDate)); command.ExecuteNonQuery(); } catch (Exception) { throw; } finally { if (connection.State == ConnectionState.Open) { connection.Close(); } } }
protected void POEntryRecordButton_Click(object sender, EventArgs e) { var invoicepurchaseorderentry = new InvoicePurchaseOrder(); invoicepurchaseorderentry.InvoiceNo = Convert.ToInt64(POInvoiceNoTextBox.Text); invoicepurchaseorderentry.PurchaseOrderNo = Convert.ToString(PONoTextBox.Text); invoicepurchaseorderentry.Attachment = "No"; invoicepurchaseorderentry.PurchaseOrderDate = Convert.ToDateTime(PODateTextBox.Text); InvoicePurchaseOrderHandler.AddInvoicePurchaseOrder(invoicepurchaseorderentry); cleardata(); }