ConnectionStringManager (build, edit connectionString in app.config file)

 

using riteweigh.core.interfaces;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using System.Data.SqlClient;
using System.Web.Configuration;

using SimpleEventBroker;
using riteweigh.core.framework;

namespace riteweigh.business.systemsettings
{
    public class ConnectionStringManager : IConnectionStringManager
    {
        #region private fields
        private string[] _permissions = { };
        #endregion

        [Publishes(RWCommands.UserNotAuthorised)]
        public event EventHandler NotAuthorised;


        public string DBConName { get { return "riteWeighConnString"; } }
        public string ADConName { get { return "ADConnectionString"; } }
        public string SMTPConName { get { return "SMTPConnectionString"; } }
        public virtual string ModuleName { get { return "ConnectionString"; } }



        public void SaveConnection(string name, string connString)
        {
            System.Configuration.Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);

            if (config.ConnectionStrings.ConnectionStrings[name] != null)
            {
                ConnectionStringSettings mysetting = new ConnectionStringSettings(name, connString);
                config