AccessFactory.cs

using System;
using System.Collections;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using System.Data.Common;
using System.Configuration;
using be.gaudry.bibliobrol.model.enums;
using be.gaudry.bibliobrol.model.dao.config;
using be.gaudry.bibliobrol.config;
 
namespace be.gaudry.bibliobrol.model.dao.msaccess
{
    public class AccessFactory:DAOFactory
    {
        private DbProviderFactory dbpf;
        private String connStr, provider;
        private AccessConfig dbConfig;
        public AccessFactory()
        {
            setConnectionSettings();
        }
 
 
        private void setConnectionSettings()
        {
            if (dbpf == null)
            {
                //provider = ConfigurationManager.ConnectionStrings[dbName].ProviderName;
                provider = "System.Data.OleDb";
                dbpf = DbProviderFactories.GetFactory(provider);
            }
        }
        public String getConnectionString()
        {
            /*StringBuilder str = new StringBuilder("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=");
            str.Append(ConfigurationManager.AppSettings["sourceDB"]);
            return str.ToString();*/
            if (connStr == null)
            {
                AccessConfig dbConfig = new AccessConfig();
                DbConnectionStringBuilder str = new DbConnectionStringBuilder();
                ACCESS_VERSION version = dbConfig.AccessVersion;
                switch (version)
                {
                    case ACCESS_VERSION.Access03:
                        str.Add("Provider", "Microsoft.Jet.OLEDB.4.0");
                        break;
                    case ACCESS_VERSION.Access07:
                        str.Add("Provider", "Microsoft.ACE.OLEDB.12.0");
                        break;
                }
 
                str.Add("Data Source", dbConfig.getAdaptedPath());
                connStr =  str.ConnectionString;
            }
            return connStr;
        }
 
        public DbProviderFactory getDbpf()
        {
            return this.dbpf;
        }
 
        #region getDao methods
        public override AbstractDBConfig getDBConfig()
        {
            return dbConfig;
        }
 
        public override IConfigDao getConfigDao()
        {
            return AccessConfigDao.Instance;
        }
 
        public override IPersonDao getPersonDao()
        {
            return AccessPersonDao.Instance;
        }
 
        public override IBrolDao getBrolDao()
        {
            return AccessBrolDao.Instance;
        }
 
        public override IMediaBrolDao getMediaBrolDao()
        {
            return AccessMediaBrolDao.Instance;
        }
 
        public override ITaskDao getTaskDao()
        {
            return AccessTaskDao.Instance;
        }
 
        public override IExporterDao getExporterDao()
        {
            return AccessExporterDao.Instance;
        }
 
        public override IImporterDao getImporterDao()
        {
            return AccessImporterDao.Instance;
        }
 
        public override IStatsDao getStatsDao()
        {
            return AccessStatsDao.Instance;
        }
 
        public override ISerieDao getSerieDao()
        {
            return AccessSerieDao.Instance;
        } 
        #endregion
    }
}