using System;

namespace Duck
{
    /// <summary>
    /// Keeps settings loaded from duck_config for usage by the emulator.
    /// </summary>
    public static class Config
    {
        #region Declares
        /// <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 virtual 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 virtual 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 virtual 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 duck_config table and stores them in this class.
        /// </summary>
        public static void Init()
        {
            IO.WriteLine("Initializing configuration from duck_config...");
            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");

            IO.WriteLine("Loaded configuration.");
        }
        /// <summary>
        /// Gets the value from a config entry in duck_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 DB.runRead("SELECT cvalue FROM duck_config WHERE ckey = '" + Key + "'");
        }
        /// <summary>
        /// Gets the value from a config entry in duck_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 DB.runRead("SELECT cvalue FROM duck_config WHERE ckey = '" + Key + "'", null);
        }
        #endregion
    }
}