private void InitializeSmtpClient()
        {
            string host = Settings.Default.SmtpServerIP;
            int port = Settings.Default.SmtpServerPort;

            string userName = Settings.Default.SmtpAccountUserName;
            string password = Settings.Default.SmtpAccountPassword;
            string domain = Settings.Default.SmtpAccountDomain;
            bool useSsl = Settings.Default.UseSsl;

            string fromAddress = Settings.Default.SmtpServerFromAddress;
            string fromName = Settings.Default.SmtpServerFromName;

            _Subject = Settings.Default.EmailSubject;

            _Emailer = new SimpleEmailer(host, port, userName, password, domain, useSsl, fromAddress, fromName);
        }
        public void LoadSettingsFromDatabase()
        {
            CriticalResultsEntityManager manager = new CriticalResultsEntityManager();
            SettingEntity[] settings = manager.GetSettings("System");

            string host = null;
            int port = 587;

            string userName = "";
            string password = "";
            string domain = "";
            bool useSsl = false;
            string fromAddress = null;
            string fromName = "Critical Results";

            foreach (SettingEntity setting in settings)
            {
                switch (setting.EntryKey)
                {
                    case "SMTP_AccountName":
                        if (!String.IsNullOrEmpty(setting.Value))
                        {
                            userName = setting.Value;
                        }
                        break;
                    case "SMTP_AccountPassword":
                        if (!String.IsNullOrEmpty(setting.Value))
                        {
                            password = setting.Value;
                        }
                        break;
                    case "SMTP_AccountDomain":
                        if (!String.IsNullOrEmpty(setting.Value))
                        {
                            domain = setting.Value;
                        }
                        break;
                    case "SMTP_UseSSL":
                        if (!String.IsNullOrEmpty(setting.Value))
                        {
                            bool.TryParse(setting.Value, out useSsl);
                        }
                        break;
                    case "SMTP_ServerIP":
                        if (!String.IsNullOrEmpty(setting.Value))
                        {
                            host = setting.Value;
                        }
                        break;
                    case "SMTP_ServerPort":
                        if (!String.IsNullOrEmpty(setting.Value))
                        {
                            port = Int32.Parse(setting.Value);
                        }
                        break;
                    case "SMTP_FromAddress":
                        if (!String.IsNullOrEmpty(setting.Value))
                        {
                            fromAddress = setting.Value;
                        }
                        break;
                    case "SMTP_FromName":
                        if (!String.IsNullOrEmpty(setting.Value))
                        {
                            fromName = setting.Value;
                        }
                        break;
                }
            }
                //_Mailer = new SimpleEmailer(host, port, userName, password, domain, useSsl, fromAddress, fromName);
            _Mailer = new SimpleEmailer(host, port, userName, password, domain, useSsl, fromAddress, fromName);
        }