using System;

using Woodpecker.Data;

namespace Woodpecker.Core
{
    /// <summary>
    /// Keeps settings loaded from woodpecker_config for usage by the application.
    /// </summary>
    public static class Config
    {
        #region Declares
        /// <summary>
        /// The set of characters that the client is allowed to use in the session.
        /// </summary>
        public static string Client_characterSet;
        /// <summary>
        /// The default motto that users gain at registration.
        /// </summary>
        public static string Registration_Motto;
        /// <summary>
        /// The amount of credits that users gain at registration.
        /// </summary>
        public static int Registration_Credits;
        /// <summary>
        /// The amount of tickets that users gain at registration.
        /// </summary>
        public static int Registration_Tickets;
        /// <summary>
        /// The amount of films that users gain at registration.
        /// </summary>
        public static int Registration_Films;
        /// <summary>
        /// Indicates if to log transactions by users. (purchases of items etc)
        /// </summary>
        public static bool logTransactions;
        /// <summary>
        /// The max amount of rooms to show when opening a category in the Hotel Navigator.
        /// </summary>
        public static int Rooms_Navigator_openCategory_maxResults;
        /// <summary>
        /// The max amount of rooms to show when searching a guestroom in the Hotel Navigator.
        /// </summary>
        public static int Rooms_Navigator_searchGuestroom_maxResults;
        /// <summary>
        /// The max amount of guestrooms that a user can have. When this amount is reached, no new rooms can be created until one is destroyed.
        /// </summary>
        public static int Rooms_guestRooms_maxPerUser;
        /// <summary>
        /// The max amount of rooms that a user can have in it's favorite rooms list. When this amount is reached, no new rooms can be added until one is removed from the list.
        /// </summary>
        public static int Rooms_Favorites_maxPerUser;
        #endregion

        #region Methods
        /// <summary>
        /// Initializes various settings from the woodpeckerconfig table and stores them in this class.
        /// </summary>
        public static void Init()
        {
            Logging.logHolyInfo("Initializing configuration...");
            Client_characterSet = getStringEntry("client.charset");
            Registration_Motto = getStringEntry("users.registration.motto");
            Registration_Credits = getNumericEntry("users.registration.credits");
            Registration_Tickets = getNumericEntry("users.registration.tickets");
            Registration_Films = getNumericEntry("users.registration.films");
            logTransactions = (getStringEntry("users.transactions.enabled") == "1");

            Rooms_Navigator_openCategory_maxResults = getNumericEntry("rooms.navigator.opencategory.max");
            Rooms_Navigator_searchGuestroom_maxResults = getNumericEntry("rooms.navigator.searchguestroom.max");
            Rooms_guestRooms_maxPerUser = getNumericEntry("rooms.guestrooms.maxperuser");
            Rooms_Favorites_maxPerUser = getNumericEntry("rooms.favorites.maxperuser");

            Logging.logHolyInfo("Configuration initialized.");
        }
        /// <summary>
        /// Gets the value from a config entry in woodpecker_config table, and returns it as a string.
        /// </summary>
        /// <param name="Key">The key of the config entry.</param>
        public static string getStringEntry(string Key)
        {
            return Database.runRead("SELECT cvalue FROM woodpecker_config WHERE ckey = '" + Key + "'");
        }
        /// <summary>
        /// Gets the value from a config entry in woodpecker_config table, and returns it as an integer.
        /// </summary>
        /// <param name="Key">The key of the config entry.</param>
        public static int getNumericEntry(string Key)
        {
            return Database.runReadInteger("SELECT cvalue FROM woodpecker_config WHERE ckey = '" + Key + "'");
        }
        #endregion
    }
}