using System;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;

namespace webapi.Infrastructure.Core
{
    public static class Constants
    {
        public const string FBA_CONNECTION_STRING = "TaloyhtioFBA_String";
        public const string GENERAL_USER_EMAIL = "asiakaspalvelu@taloyhtio.info";

        //public const string KEY_AZURE_STORAGE = "AzureProdConnectionString";
        //public const string AZURE_TABLE_NAME = "MaintenanceFees";

        

        public static class AdminNews
        {
            public const string LIST_TITLE = "Taloyhtio.Info tiedottaa";
        }

        // Apua lists are created on the root site of web application - they are not localized
        public static class Apua
        {
            public const string LINKS_LIST_TITLE = "Apua linkit";
            public const string MANUALS_LIST_TITLE = "Käyttöohjeet";
            public const string SUPPORT_MATERIALS_LIST_TITLE = "Tukimateriaalit";
            public const string FAQ_LIST_TITLE = "Usein kysytyt kysymykset";
            public const string VIDEO_LIST_TITLE = "Apua videot";
            public const string FEEDBACK_LIST_TITLE = "Palautetta Taloyhtio.Infosta";

            public const string FEEDBACK_FIELD_TYPE = "Yhteydenoton laji";
            public const string FEEDBACK_FIELD_ROLE = "Olen";
            public const string FEEDBACK_FIELD_MESSAGE = "Viesti";
            public const string FEEDBACK_FIELD_ANSWER = "Haluan vastauksen";
            public const string FEEDBACK_FIELD_NAME = "Nimi";
            public const string FEEDBACK_FIELD_PHONE = "Puhelin";
            public const string FEEDBACK_FIELD_EMAIL = "Sähköposti";
            public const string FEEDBACK_FIELD_COMPANY = "Taloyhtiö / Isännöitsijätoimisto";

            public const string ROLE_TENANTS = "Asukkaille";
            public const string ROLE_BOARD_MEMBERS = "Hallitus";
            public const string ROLE_PROPERTY_MANAGERS = "Isännöitsijät";
            public const string ROLE_ALL = "Kaikki";

            public const string FIELD_PAGE_URL = "URL-osoite";
            public const string FIELD_TARGET_ROLE = "Rooli";
            public const string FIELD_THUMBNAIL = "Thumbnail";
            public const string FIELD_DESCRIPTION = "Kuvaus";

            public const string FIELD_QUESTION = "Kysysmys";
            public const string FIELD_ANSWER = "Vastaus";

            public const string FEEDBACK_EMAIL = "asiakaspalvelu@taloyhtio.info";
            public const string EMAIL_TEMPLATE = "feedback.txt";
        }

        public static class Email
        {
            public const string TEMPLATE_REGISTER_NEW = "emailRegisterNew.txt";
            public const string TEMPLATE_REGISTER_EXISTING = "emailRegisterExisting.txt";
            public const string TEMPLATE_NOTIFY_APPROVER = "emailNotifyApprover.txt";
            public const string TEMPLATE_REQUEST_APPROVED = "emailNotifyRequestApproved.txt";
            public const string TEMPLATE_REQUEST_REJECTED = "emailNotifyRequestRejected.txt";
        }

        public static class PropertyBag
        {
            public const string KEY_CONDO_POST_CONFIGURED = "PostConfigured";
            public const string KEY_CONDO_SHORT_NAME = "CondoShortName";
            public const string KEY_CUSTOM_BACKGROUND_USE_CUSTOM = "CondoAutomation_CustomBackground_UseCustom";
            public const string KEY_CUSTOM_BACKGROUND_URL = "CondoAutomation_CustomBackground_Url";
            public const string CONDO_VERSION = "CondoVersion";
        }

        public static class Security
        {
            public const string GENERAL_USER_EMAIL = "asiakaspalvelu@taloyhtio.info";
            //            public const string GENERAL_TENANT_PASSWORD = "12345";
            //            public const string GENERAL_LANDLORD_PASSWORD = "67890";
            public const string GENERAL_TENANT_PASSWORD_KEY = "TaloyhtioGeneralTentantPwd";
            public const string GENERAL_LANDLORD_PASSWORD_KEY = "TaloyhtioGeneralLandlordPwd";

            public const string ALERTS_OWNER_EMAIL = "alerts@example.com";
            public const string ALERTS_OWNER_USER_NAME = "alerts owner";
        }

        public static class Retargeting
        {
            public const string BOARD_MEMBERS_OLD_TARGET_LIST_ID_ON_START_PAGE = "65851B2A-3CD2-4EF2-8669-27C05D3F3561";
            public const string CONDO_SITE_OLD_TARGET_LIST_ID_ON_START_PAGE = "336A3B34-C1D3-42D3-9AE2-C435D6FA43E9";
            public const string LANDLORDS_OLD_TARGET_LIST_ID_ON_START_PAGE = "65851B2A-3CD2-4EF2-8669-27C05D3F3561";
            public const string OLD_TARGET_LIST_ID_ON_NEWS_PAGE = "336A3B34-C1D3-42D3-9AE2-C435D6FA43E9";
            public const string OLD_TARGET_WEB_URL = "/demo2/";
        }

        public static class SiteTemplates
        {
            public static string[] CONDO_PREFIXES = new[]
                {
                    "as oy", "asoy", "asunto oy", "asunto-oy", "as. oy", "as.oy", "asunto-osakeyhtiö", "koy", "k oy",
                    "kiint oy", "kiinteistö oy"
                };
            public const int CONDO_SITE_WEB_TEMPLATE_ID = 10101;
            public const string CONDO_WEB_TEMPLATE_NAME = "TaloyhtioCondoSite";
            public const short CONDO_WEB_CONFIGURATION = 0;
            public const string COMPANY_SITE_TEMPLATE_NAME = "TaloyhtioCompanySite";
            public static int COMPANY_SITE_WEB_TEMPLATE_ID = 10200;
            public const string PMC_PREFIX1 = " oy";
            public const string PMC_PREFIX2 = " ky";

            public const string URL_TENANTS = "asukkaille";
            public const string URL_OWNERS = "osakkaille";
            public const string URL_BOARD = "hallitukselle";
        }

        public static class Url
        {
            public const string DOCLIB_URL_DOCUMENTS = "Documents";
            public const string DEFAULT_ASPX = "default.aspx";
            public const string WEB_URL_ALERTS_FOR_TENANTS = "Halytys";
            public const string WEB_URL_ALERTS_FOR_LANDLORDS = "Osakashalytys";
            public const string WEB_URL_ALERTS_FOR_BOARD_MEMBERS = "Hallitushalytys";

            public const string WEB_URL_TENANTS_AKATEMIA = "akatemia";
            public const string WEB_URL_BOARD_MEMBERS_AKATEMIA = "hallitusakatemia";
            public const string FOLDER_URL_CAROUSEL = "etusivukuvat";
        }

        public static class Fields
        {
            public const string URL_STATIC_NAME = "URL";
            public const string DOCUMENT_DESCRIPTION_STATIC_NAME = "DocumentDescription";
            public const string DOC_ICON_STATIC_NAME = "DocIcon";
            public const string LINK_FILENAME_STATIC_NAME = "LinkFilename";
            public const string MODIFIED_STATIC_NAME = "Modified";
            public const string FILE_SIZE_DISPLAY_STATIC_NAME = "FileSizeDisplay";
            public const string CONTACTS_JOB_TITLE_INTERNAL_NAME = "JobTitle";
            public const string CONTACTS_LAST_NAME_INTERNAL_NAME = "LinkTitleNoMenu";
            public const string CONTACTS_FIRST_NAME_INTERNAL_NAME = "FirstName";
            public const string CONTACTS_PHONE_INTERNAL_NAME = "WorkPhone";
            public const string CONTACTS_EMAIL_INTERNAL_NAME = "Email";
            public const string ICS_FIELD_NAME = "ICS";
        }

        public static class Log
        {
            public const string CATEGORY = "Condo creation";
        }

        public static class Features
        {
            public static readonly Guid PMC_ROOT_ID = new Guid("a82bd1bc-5f1d-4556-b600-c84eb1f63c04");
            public static readonly Guid PMC_CONTACTS_UPDATE_TOOL_ID = new Guid("7912CF98-DA3F-41e5-B9D1-5793262BFCEA");
        }

        public static class QueryString
        {
            public const string BUSINESS_ID = "BusinessID";
        }

        //public static string ConnectionString
        //{
        //    get
        //    {
        //        return ConfigurationManager.ConnectionStrings[Constants.FBA_CONNECTION_STRING].ConnectionString;
        //    }
        //}

        //private static SqlConnection _connection = null;
        //public static SqlConnection Connection
        //{
        //    get
        //    {
        //        if (_connection == null && !string.IsNullOrEmpty(ConnectionString))
        //        {
        //            _connection = new SqlConnection(ConnectionString);
        //        }
        //        if (_connection != null && !_connection.State.Equals(ConnectionState.Open))
        //        {
        //            _connection.Open();
        //        }

        //        return _connection;
        //    }
        //}
    }
}