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();
}
