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); }