using System;
using System.Collections.Generic;
using System.Text;
using NLog;

namespace ETS_Data
{
    /// <summary>
    /// classe di wrap verso i TableAdapter impiegati
    /// </summary>
    public class DataWrap
    {
        #region area protected

        /// <summary>
        /// metodo protected di avvio della classe
        /// </summary>
        protected DataWrap()
        {
            // inizializzo i table adapters
            avvioTableAdaptersSpec();
            setupConnectionStringSpec();
        }

        /// <summary>
        /// procedura di avvio dei tableAdapter
        /// </summary>
        protected virtual void avvioTableAdaptersSpec()
        {
            taCdc = new DataLayer_AnagGenTableAdapters.CDCTableAdapter();
            taDiritti = new DataLayer_AnagGenTableAdapters.DIRITTITableAdapter();
            taPermessi = new DataLayer_AnagGenTableAdapters.PermessiTableAdapter();
            taFunzione = new DataLayer_AnagGenTableAdapters.FUNZIONETableAdapter();
            taPermessi2Funzione = new DataLayer_AnagGenTableAdapters.Permessi2FunzioneTableAdapter();
            taUtente = new DataLayer_AnagGenTableAdapters.UTENTETableAdapter();
            taUserData = new DataLayer_AnagGenTableAdapters.UserDataTableAdapter();
            taUserDataExt = new DataLayer_AnagGenTableAdapters.UserDataExtTableAdapter();
            taLogAna = new DataLayer_AnagGenTableAdapters.LogUpdateDbTableAdapter();
        }
        /// <summary>
        /// effettua setup dei connection strings da web.config delal singola applicazione
        /// </summary>
        protected virtual void setupConnectionStringSpec()
        {
            string connStrUt = utils.obj.confReadString("UtenteCdcConnectionString");
            string connStrPerm = utils.obj.confReadString("PermessiConnectionString");
            // cambio le connString - db anagrafica principale
            taCdc.Connection.ConnectionString = connStrUt;
            taDiritti.Connection.ConnectionString = connStrUt;
            taFunzione.Connection.ConnectionString = connStrUt;
            taUtente.Connection.ConnectionString = connStrUt;
            taUserData.Connection.ConnectionString = connStrUt;
            taUserDataExt.Connection.ConnectionString = connStrUt;
            taLogAna.Connection.ConnectionString = connStrUt;
            // connections del db dell'applicazione
            taPermessi.Connection.ConnectionString = connStrPerm;
            taPermessi2Funzione.Connection.ConnectionString = connStrPerm;
        }

        #endregion

        #region area public

        /// <summary>
        /// tableAdapter diritti
        /// </summary>
        public DataLayer_AnagGenTableAdapters.DIRITTITableAdapter taDiritti;
        /// <summary>
        /// tableAdapter permessi
        /// </summary>
        public DataLayer_AnagGenTableAdapters.PermessiTableAdapter taPermessi;
        /// <summary>
        /// tableAdapter funzione
        /// </summary>
        public DataLayer_AnagGenTableAdapters.FUNZIONETableAdapter taFunzione;
        /// <summary>
        /// tableAdapter permessi2funzione
        /// </summary>
        public DataLayer_AnagGenTableAdapters.Permessi2FunzioneTableAdapter taPermessi2Funzione;
        /// <summary>
        /// tableAdapter CdC
        /// </summary>
        public DataLayer_AnagGenTableAdapters.CDCTableAdapter taCdc;
        /// <summary>
        /// tableAdapter utenti
        /// </summary>
        public DataLayer_AnagGenTableAdapters.UTENTETableAdapter taUtente;
        /// <summary>
        /// tableAdapter userData (user/pwd)
        /// </summary>
        public DataLayer_AnagGenTableAdapters.UserDataTableAdapter taUserData;
        /// <summary>
        /// tableAdapter userDataExt (user/pwd)
        /// </summary>
        public DataLayer_AnagGenTableAdapters.UserDataExtTableAdapter taUserDataExt;
        /// <summary>
        /// table adapter versione anagrafica
        /// </summary>
        public DataLayer_AnagGenTableAdapters.LogUpdateDbTableAdapter taLogAna;
        /// <summary>
        /// classe singleton x la gestione dei tableadapters
        /// </summary>
        public static DataWrap DW = new DataWrap();

        #endregion
    }
}