private void SetApplicationSettings()
{
Configuration configSql = WebConfigurationManager.OpenWebConfiguration("~");
SqlSettingsSection sqlSection = (SqlSettingsSection)configSql.GetSection("SqlSettings");
ApplicationSettings settings = new ApplicationSettings();
settings.SqlDatabaseName = sqlSection.SqlDatabaseName;
settings.SqlPassword = sqlSection.SqlPassword;
settings.SqlUserName = sqlSection.SqlUserName;
settings.SqlServerName = sqlSection.SqlServerName;
settings.ConnectionTimeout = sqlSection.ConnectionTimeout;
settings.CommandTimeout = sqlSection.CommandTimeout;
Configuration configMail = WebConfigurationManager.OpenWebConfiguration("~");
MailSettingsSection mailSection = (MailSettingsSection)configMail.GetSection("MailSettings");
settings.MailFrom = mailSection.AdministrativeMail;
settings.MailServer = mailSection.MailServer;
SessionManager.SetSessionValue((IndBasePage)this, SessionStrings.APPLICATION_SETTINGS, settings);
}
/// <summary>
/// save data from textboxes to web.config file
/// </summary>
/// <returns></returns>
private void SaveSettings()
{
ApplicationSettings settings = (ApplicationSettings)SessionManager.GetSessionValueRedirect((IndBasePage)this.Page, SessionStrings.APPLICATION_SETTINGS);
//save in ApplicationSettings object
TestSqlConnection();
settings.SqlServerName = txtSqlServerName.Text;
settings.SqlDatabaseName = txtSqlDatabaseName.Text;
settings.SqlPassword = txtSqlServerPassword.Text;
settings.SqlUserName = txtSqlServerUserName.Text;
settings.MailServer = txtMailServer.Text;
settings.MailFrom = txtAdministrativeMail.Text;
Configuration configSql = WebConfigurationManager.OpenWebConfiguration("~");
SqlSettingsSection sqlSection = (SqlSettingsSection)configSql.GetSection("SqlSettings");
sqlSection.SqlDatabaseName = settings.SqlDatabaseName;
sqlSection.SqlPassword = settings.SqlPassword;
sqlSection.SqlUserName = settings.SqlUserName;
sqlSection.SqlServerName = settings.SqlServerName;
configSql.Save();
//save in mailsettings congfiguration file
Configuration configMail = WebConfigurationManager.OpenWebConfiguration("~");
MailSettingsSection mailSection = (MailSettingsSection)configMail.GetSection("MailSettings");
mailSection.MailServer = settings.MailServer;
mailSection.AdministrativeMail = settings.MailFrom;
configMail.Save();
SessionManager.SetSessionValue((IndBasePage)this.Page, SessionStrings.APPLICATION_SETTINGS, settings);
}