public Boolean addItemToOrder(InventoryItem inventoryItem, int count)
        {
            if (count <= inventoryItem.getProductCount())
            {
                OrderItem orderItem = new OrderItem();
                orderItem.setProductId(inventoryItem.getInventoryId());
                orderItem.setCount(count);
                orderItem.setSalePrice(inventoryItem.getSalePrice());

                orderItems.Add(orderItem);

                inventoryItem.orderItem(count);
                inventoryItems.Add(inventoryItem);
                return true;
            }
            else
            {
                return false;
            }
        }
        private List<OrderItem> getOrderItems(int orderId)
        {
            using (OleDbConnection sqlConn = new OleDbConnection(database))
            {
                List<OrderItem> orderItems = new List<OrderItem>();
                try
                {
                    sqlConn.Open();
                    OleDbCommand cmd = sqlConn.CreateCommand();

                    String select = "SELECT * FROM [ORDER_ITEMS] WHERE [order_id] = @orderId";
                    cmd.CommandText = select;
                    cmd.Parameters.Add("orderId", OleDbType.Integer).Value = orderId;

                    OleDbDataReader reader = cmd.ExecuteReader();

                    while (reader.Read())
                    {
                        OrderItem orderItem = new OrderItem();
                        orderItem.setOrderId((int)reader["order_id"]);
                        orderItem.setProductId((int)reader["product_id"]);
                        orderItem.setCount((int)reader["count"]);
                        orderItem.setSalePrice(Double.Parse(reader["sale_price"].ToString(), NumberStyles.Currency));

                        orderItems.Add(orderItem);
                    }

                    return orderItems;
                }
                catch (OleDbException ex)
                {
                    orderItems = null;
                    return orderItems;
                }
                finally
                {
                    sqlConn.Close();
                }
            }
        }
 public int addOrderItem(OrderItem orderItem)
 {
     orderItems.Add(orderItem);
     return this.getOrderItemsCount();
 }
 public int removeOrderItem(OrderItem orderItem)
 {
     orderItems.Remove(orderItem);
     return this.getOrderItemsCount();
 }