private void Backmixerbtn_Click(object sender, EventArgs e) { SpiritsWindow spiritsWindow = new SpiritsWindow(userID, firstName, lastName, OrderList.Items, Usernamelbl.Text, AmountLabel.Text, RunningTotal); spiritsWindow.Show(); this.Close(); }
private void Spiritsbtn_Click_1(object sender, EventArgs e) { this.Hide(); SpiritsWindow spiritsWindow = new SpiritsWindow(userID, firstName, lastName, OrderList.Items, Usernamelbl.Text, AmountLabel.Text, RunningTotal); spiritsWindow.Show(); }
private void Cocacolabtn_Click(object sender, EventArgs e) { SqlConnection connection = new SqlConnection(); connection.ConnectionString = "Server =.; Database = systembar; Trusted_Connection = True;"; SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandText = "SELECT [ProductName],[UnitPrice] FROM systembar.dbo.Product WHERE [ProductName] = 'Coca - Cola'"; command.CommandType = CommandType.Text; try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Product product = new Product(); product.productName = (string)reader["ProductName"]; product.unitPrice = float.Parse((string)reader["UnitPrice"].ToString()); ItemPrice = product.unitPrice; OrderList.Items.Add(product.productName + " " + product.unitPrice.ToString("£#0.00")); NewTotal = RunningTotal + product.unitPrice; RunningTotal = NewTotal; AmountLabel.Text = NewTotal.ToString("£#0.00"); } reader.Close(); } catch { } finally { if (connection.State == ConnectionState.Open) { connection.Close(); } } SpiritsWindow spiritsWindow = new SpiritsWindow(userID, firstName, lastName, OrderList.Items, Usernamelbl.Text, AmountLabel.Text, RunningTotal); spiritsWindow.Show(); this.Hide(); }