/// <summary> /// Select ticket for bill adjustment /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button_Click(object sender, RoutedEventArgs e) { List<Cart> totalCart = new List<Cart>(); decimal running_total = 0m; ticketNumber.Text = "N/A"; authBy.Text = "Employee"; foreach (client c in clientList) { if (c.name == Discounted_Tickets_List.SelectedValue.ToString()) { try { string SQLConnectionString = "Server=tcp:omsdb.database.windows.net,1433;Database=OMSDB;User ID=csce4444@omsdb;Password=Pineapple!;"; // Create an SqlConnection from the provided connection string. using (SqlConnection connection = new SqlConnection(SQLConnectionString)) { // Formulate the command. SqlCommand command = new SqlCommand(@"SELECT * FROM dbo.Orders WHERE Client=@cli", connection); command.Parameters.AddWithValue("@cli", c.ip.ToString()); connection.Open(); SqlDataReader reader = command.ExecuteReader(); // while not done reading the stuff returned from the query while (reader.Read()) { Cart tempCart = new Cart(); tempCart = (Cart)commHelper.ByteToObject((byte[])reader[1]); tempCart.Order_num = (int)reader[0]; totalCart.Add(tempCart); } } } catch (Exception) { } foreach (Cart item in totalCart) { foreach (cartItem food in item.Items) { running_total += food.price; } } running_total = Math.Round(running_total, 2); originalAmt.Text = running_total.ToString(); discountAmt.Text = c.adjustment.ToString(); } } reason.Text = "N/A"; }
/// <summary> /// Update the database to make it work nicer, and change the /// </summary> public void createOrders() { Dispatcher.Invoke(() => { orderList.Items.Clear(); }); myOrders.Clear(); try { string SQLConnectionString = "Server=tcp:omsdb.database.windows.net,1433;Database=OMSDB;User ID=csce4444@omsdb;Password=Pineapple!;"; // Create an SqlConnection from the provided connection string. using (C.SqlConnection connection = new C.SqlConnection(SQLConnectionString)) { // Formulate the command. C.SqlCommand command = new C.SqlCommand(); command.Connection = connection; // Specify the query to be executed. command.CommandType = D.CommandType.Text; command.CommandText = @" SELECT * FROM dbo.Orders WHERE Finished=0 "; // Open a connection to database. connection.Open(); // Read data returned for the query. C.SqlDataReader reader = command.ExecuteReader(); // while not done reading the stuff returned from the query while (reader.Read()) { Cart tempCart = new Cart(); tempCart = (Cart)ByteToObject((byte[])reader[1]); tempCart.Order_num = (int)reader[0]; myOrders.Add(tempCart); } connection.Close(); foreach (Cart item in myOrders) { foreach (cartItem food in item.Items) { order += (food.name + ", "); } Dispatcher.Invoke(() => { orderList.Items.Add(item.Order_num + " " + order); }); order = ""; } } } catch (Exception) { } }
private void tick_done_Click(object sender, RoutedEventArgs e) { List<Cart> temp = new List<Cart>(); string ip = ""; foreach (ClientInfo thing in TableList) { if (thing.Name == currentTableName.Content.ToString()) { ip = thing.IP.ToString(); } } try { string SQLConnectionString = "Server=tcp:omsdb.database.windows.net,1433;Database=OMSDB;User ID=csce4444@omsdb;Password=Pineapple!;"; // Create an SqlConnection from the provided connection string. using (SqlConnection connection = new SqlConnection(SQLConnectionString)) { // Formulate the command. SqlCommand command = new SqlCommand(); command.Connection = connection; // Specify the query to be executed. command.CommandType = CommandType.Text; command.CommandText = @" SELECT * FROM dbo.Orders WHERE Client=@cli "; command.Parameters.AddWithValue("@cli", ip); // Open a connection to database. connection.Open(); // Read data returned for the query. SqlDataReader reader = command.ExecuteReader(); // while not done reading the stuff returned from the query while (reader.Read()) { Cart tempCart = new Cart(); tempCart = (Cart)ByteToObject((byte[])reader[1]); tempCart.Order_num = (int)reader[0]; temp.Add(tempCart); } } } catch (Exception) { } decimal running_total = 0m; foreach (Cart item in temp) { foreach (cartItem food in item.Items) { running_total += food.price; } } if (Convert.ToDecimal(comp.Text) > running_total) { MessageBox.Show("NO FREE FOOD"); } else { commHelper.functionSend("ticketAdjusted"); commHelper.functionSend(comp.Text); commHelper.functionSend(ip); tick_ad.Visibility = Visibility.Hidden; } }