Пример #1
0
        private void AddItemToOrder(string itemName, int quantity)
        {
            int.TryParse(insertedOrderId, out int orderNumber);
            // Get item ID
            int itemId = GetItemId(itemName);

            // Setting up a variable for the datatable from the database
            RestaurantDataSet.OrderItemsDataTable orderItems = new RestaurantDataSet.OrderItemsDataTable();
            // Setting up an order items adaptor and it's to fill in the datatable
            RestaurantDataSetTableAdapters.OrderItemsTableAdapter orderItemsTableAdap = new RestaurantDataSetTableAdapters.OrderItemsTableAdapter();
            // Getting the order items data from the database
            orderItemsTableAdap.GetData();
            // Filling the data to the datatable
            orderItemsTableAdap.Fill(orderItems);
            // Add the selection to the preview list
            orderPreviewListBox.Items.Add(itemName + " (" + quantity + ")");
            // Adding the new record to the database
            orderItemsTableAdap.Insert(quantity.ToString(), itemId, orderNumber);
        }