using System.Linq;

namespace Common
{
    public static class Settings
    {
        private static string GetSetting(string settingName, string defaultValue)
        {
            using (var db = new DataModel())
            {
                var setting = db.Settings.FirstOrDefault(s => s.SettingName == settingName);
                return setting == null ? defaultValue : setting.SettingValue;
            }
        }

        private static string GetSetting(string settingName) { return GetSetting(settingName, string.Empty); }

        private static void SaveSetting(string settingName, string settingValue)
        {
            using (var db = new DataModel())
            {
                var setting = db.Settings.FirstOrDefault(s => s.SettingName == settingName);
                if (setting != null) setting.SettingValue = settingValue;
                else
                {
                    setting = new Setting {SettingName = settingName, SettingValue = settingValue};
                    db.Settings.Add(setting);
                }
                db.SaveChanges();
            }
        }

        public static string CompanyName
        {
            get { return GetSetting("Company Name"); }
            set { SaveSetting("Company Name", value); }
        }

        public static string CompanyAddress
        {
            get { return GetSetting("Company Address"); }
            set { SaveSetting("Company Address", value); }
        }

        public static string CompanyPhone
        {
            get { return GetSetting("Company Phone"); }
            set { SaveSetting("Company Phone", value); }
        }

        public static string CompanyEmail
        {
            get { return GetSetting("Company Email"); }
            set { SaveSetting("Company Email", value); }
        }

        public static string CompanyVatNumber
        {
            get { return GetSetting("Company VAT Number"); }
            set { SaveSetting("Company VAT Number", value); }
        }

        public static string WebServiceUrl
        {
            get { return GetSetting("Web Service Url", "http://pl-server"); }
            //get { return GetSetting("Web Service Url", "http://localhost:51033"); }
            set { SaveSetting("Web Service Url", value); }
        }

        public static string ServiceUrl
        {
            get { return GetSetting("Service Url"); }
            set { SaveSetting("Service Url", value); }
        }

        public static string EmailSubjectCountReconIssue
        {
            get { return GetSetting("Email-Subject: CountRecon Issue"); }
            set { SaveSetting("Email-Subject: CountRecon Issue", value); }
        }

        public static string EmailBodyCountReconIssue
        {
            get { return GetSetting("Email-Body: CountRecon Issue"); }
            set { SaveSetting("Email-Body: CountRecon Issue", value); }
        }

        public static string EmailSubjectCondemnIssue
        {
            get { return GetSetting("Email-Subject: Condemn Issue"); }
            set { SaveSetting("Email-Subject: Condemn Issue", value); }
        }

        public static string EmailBodyCondemnIssue
        {
            get { return GetSetting("Email-Body: Condemn Issue"); }
            set { SaveSetting("Email-Body: Condemn Issue", value); }
        }

    }
}