/// <summary>
        ///   The deleteUnmoderated method deletes a previously
        ///   submitted joke (unmoderated) joke
        ///   (for moderators only)
        /// </summary>
        /// <param name='userName'
        ///   type='string'
        ///   desc='name of moderator'>
        /// </param>
        /// <param name='password'
        ///   type='string'
        ///   desc='password of moderator'>
        /// </param>
        /// <param name='jokeID'
        ///   type='int'
        ///   desc='joke ID of joke'>
        /// </param>
        /// <returns>true</returns>
        protected internal bool deleteUnmoderated(
            string userName, string password, int jokeID)
        {
            string retCode;

            try {
                // check if user is a moderator
                userAdminImplement myUser     = new userAdminImplement();
                SqlCommand         sqlCommand = new SqlCommand();

                myUser.createSqlCheckUser(
                    userName, password, "true", sqlCommand);

                databaseAccess myDatabase = new databaseAccess();
                sqlCommand.Connection = myDatabase.getConnection();
                sqlCommand.Connection.Open();

                sqlCommand.ExecuteNonQuery();

                retCode = sqlCommand.Parameters["@@return"].Value.ToString();

                // exit, if user not a moderator
                if (retCode != "S_OK")
                {
                    sqlCommand.Connection.Close();
                    throw new jokeException(retCode);
                }

                // delete the joke
                sqlCommand.Parameters.Clear();
                createSqlManageJoke(
                    userName, "", "", jokeID.ToString(), "delete", sqlCommand);

                sqlCommand.ExecuteNonQuery();
                sqlCommand.Connection.Close();

                retCode = sqlCommand.Parameters["@@return"].Value.ToString();

                // catch problems within the stored procedure
                if (retCode == "S_OK")
                {
                    return(true);
                }
                else
                {
                    throw new jokeException(retCode);
                }
                // catch problems with the database
            } catch (Exception e) {
                throw e;
            }
        }
        /// <summary>
        ///   The getUnmoderated method retrieves howMany jokes from
        ///   the database
        ///   (for moderators only)
        /// </summary>
        /// <param name='userName'
        ///   type='string'
        ///   desc='name of moderator'>
        /// </param>
        /// <param name='password'
        ///   type='string'
        ///   desc='password of moderator'>
        /// </param>
        /// <param name='howMany'
        ///   type='int'
        ///   desc='number of jokes to return'>
        /// </param>
        /// <returns>an XML representation (xmlJokesReturn)
        ///   of a single joke</returns>
        protected internal xmlJokesReturn[] getUnmoderated(
            string userName, string password, int howMany)
        {
            string retCode;

            try {
                // check if user is a moderator
                userAdminImplement myUser     = new userAdminImplement();
                SqlCommand         sqlCommand = new SqlCommand();

                myUser.createSqlCheckUser(
                    userName, password, "true", sqlCommand);

                databaseAccess myDatabase = new databaseAccess();
                sqlCommand.Connection = myDatabase.getConnection();
                sqlCommand.Connection.Open();

                sqlCommand.ExecuteNonQuery();

                retCode = sqlCommand.Parameters["@@return"].Value.ToString();

                // exit, if user not a moderator
                if (retCode != "S_OK")
                {
                    sqlCommand.Connection.Close();
                    throw new jokeException(retCode);
                }

                // retrieve the first <howMany> unmoderated jokes

                // maximum is 10 jokes
                if ((howMany < 1) || (howMany > 10))
                {
                    throw new jokeException("F_10JokesMax");
                }

                sqlCommand.Parameters.Clear();
                createSqlReturnJokes(
                    howMany.ToString(), "false", "false", sqlCommand);

                sqlCommand.ExecuteNonQuery();

                sqlCommand.Connection.Close();

                SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
                DataTable      dataTable      = new DataTable("sqlReturn");
                sqlDataAdapter.Fill(dataTable);

                // convert SQL table into xmlJokesReturn class
                int rowCount             = dataTable.Rows.Count;
                xmlJokesReturn[] myJokes = new xmlJokesReturn[rowCount];
                for (int i = 0; i < rowCount; i++)
                {
                    myJokes[i]        = new xmlJokesReturn();
                    myJokes[i].jokeID = dataTable.Rows[i][0].ToString();
                    myJokes[i].joke   = dataTable.Rows[i][1].ToString();
                    myJokes[i].rating = dataTable.Rows[i][2].ToString();
                }
                // catch problems within the stored procedure
                if (rowCount > 0)
                {
                    return(myJokes);
                }
                else
                {
                    throw new jokeException("F_noJokes");
                }
                // catch problems with the database
            } catch (Exception e) {
                throw e;
            }
        }