MySQLFactory.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;
using MySql.Data.MySqlClient;
 
namespace be.gaudry.bibliobrol.model.dao.mysql
{
    public class MySQLFactory:DAOFactory
    {
        private DbProviderFactory dbpf;
        private String connStr, provider;
        private MySQLConfig dbConfig;
        public MySQLFactory()
        {
            setConnectionSettings();
        }
 
 
        private void setConnectionSettings()
        {
            if (dbpf == null)
            {
                provider = "MySql.Data.MySqlClient";
                dbpf = DbProviderFactories.GetFactory(provider);
            }
        }
        public String getConnectionString()
        {
            /*
             * String conStr = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;UID=root;DATABASE=bibliobrol;Password=;";
             * System.Data.Odbc.OdbcConnection con = new System.Data.Odbc.OdbcConnection(conStr);
             */
            if (connStr == null)
            {
                dbConfig = new MySQLConfig();
 
                //connStr = "Provider=MySQL ODBC 5.1 Driver;SERVER=localhost;UID=root;DATABASE=bibliobrol;Password=;";
                //MySqlConnectionStringBuilder str = new MySqlConnectionStringBuilder();
                //str.Database = "bibliobrol";
                //str.Password = "";
                //str.Server = "localhost";
                //str.UserID = "root";
 
                DbConnectionStringBuilder str = new DbConnectionStringBuilder();
                //str.Add("Provider", "{MySQL ODBC 5.1 Driver}");//.NET Framework Data Provider for MySQL
                str.Add("Data Source", dbConfig.DBUrl);//Data Source or Server ?
                str.Add("Database", dbConfig.DBName);
                str.Add("User Id", dbConfig.DBUserName);
                str.Add("Password", dbConfig.DBPassword);
 
                connStr = str.ConnectionString;//server=localhost;user id=root;database=bibliobrol
 
                //connStr = "Provider=MySQLProv;Data Source=localhost;User Id=root;Database=bibliobrol;Password=;";
 
            }
            return connStr;
        }
 
        public DbProviderFactory getDbpf()
        {
            return this.dbpf;
        }
 
        #region getDao methods
        public override AbstractDBConfig getDBConfig()
        {
            return dbConfig;
        }
 
        public override IConfigDao getConfigDao()
        {
            return NoChangeConfigDao.Instance;
 
        }
 
        public override IPersonDao getPersonDao()
        {
            return NoChangePersonDao.Instance;
        }
 
        public override IBrolDao getBrolDao()
        {
            return NoChangeBrolDao.Instance;
        }
 
        public override IMediaBrolDao getMediaBrolDao()
        {
            return MySQLMediaBrolDao.Instance;
        }
 
        public override ITaskDao getTaskDao()
        {
            return NoChangeTaskDao.Instance;
        }
 
        public override IExporterDao getExporterDao()
        {
            return NoChangeExporterDao.Instance;
        }
 
        public override IImporterDao getImporterDao()
        {
            return NoChangeImporterDao.Instance;
        }
 
        public override IStatsDao getStatsDao()
        {
            return MySQLStatsDao.Instance;
        }
 
        public override ISerieDao getSerieDao()
        {
            return NoChangeSerieDao.Instance;
        } 
        #endregion
    }
}