Ejemplo n.º 1
0
        /// <summary>
        /// Returns the available tables at a polling venue
        /// for a client application to choose between.
        /// </summary>
        /// <param name="clientName">The id of the client.</param>
        /// <returns>The available tables for the client to choose as a string array.</returns>
        public string[] ValidTableRequestHandler(string clientName)
        {
            var queryBuilder = new QueryBuilder();
            queryBuilder.SetType("select");
            queryBuilder.SetTable("Person");
            queryBuilder.SetColumns(new [] { "polling_table" } );
            queryBuilder.SetGroupBy("polling_table");

            var results = queryBuilder.ExecuteQuery();
            var tables = new string [results.Count];

            var i = 0;
            foreach (var result in results) {
                tables[i++] = (string) ((Hashtable) result)["polling_table"];
            }

            return tables;
        }