using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using SteamWare;

namespace WebSCR_data
{
    public class DtProxy
    {
        #region area protected

        protected DtProxy()
        {
            // inizializzo i table adapters
            avvioTableAdapters();
            setupConnectionString();
        }

        /// <summary>
        /// procedura di avvio dei tableAdapter
        /// </summary>
        protected virtual void avvioTableAdapters()
        {
            taATC = new DS_ApplicazioneTableAdapters.AnagTipoConsegneTableAdapter();
            taAC = new DS_ApplicazioneTableAdapters.AnagClientiTableAdapter();
            taAS = new DS_ApplicazioneTableAdapters.AnagSquadreTableAdapter();
            taAsSq = new DS_ApplicazioneTableAdapters.AssegnSquadreTableAdapter();
            taASSD = new DS_ApplicazioneTableAdapters.AssegnSlotSquadreDipTableAdapter();
            taAZ = new DS_ApplicazioneTableAdapters.AnagZoneTableAdapter();
            taImp = new DS_ApplicazioneTableAdapters.ImpegniTableAdapter();
            taDetImp = new DS_ApplicazioneTableAdapters.DettImpegnoTableAdapter();
            taVcz = new DS_ApplicazioneTableAdapters.v_clientiZoneTableAdapter();
            taDocs = new DS_ApplicazioneTableAdapters.DB2_DOCSTableAdapter();
            taDisp = new DS_ApplicazioneTableAdapters.DisponibilitaTableAdapter();
            taVRI = new DS_ApplicazioneTableAdapters.v_resImpTableAdapter();
            taFile = new DS_UtilityTableAdapters.tblFilesTableAdapter();
            taListVal = new DS_UtilityTableAdapters.ListValuesTableAdapter();
        }
        /// <summary>
        /// effettua setup dei connection strings da web.config della singola applicazione
        /// </summary>
        protected virtual void setupConnectionString()
        {
            string connStr = memLayer.ML.confReadString("WebSCRConnectionString");
            string connStrFiles = memLayer.ML.confReadString("WebSCRFilesConnectionString");
            // connections del db vocabolario
            taATC.Connection.ConnectionString = connStr;
            taAC.Connection.ConnectionString = connStr;
            taAS.Connection.ConnectionString = connStr;
            taAsSq.Connection.ConnectionString = connStr;
            taASSD.Connection.ConnectionString = connStr;
            taAZ.Connection.ConnectionString = connStr;
            taImp.Connection.ConnectionString = connStr;
            taDetImp.Connection.ConnectionString = connStr;
            taVcz.Connection.ConnectionString = connStr;
            taDocs.Connection.ConnectionString = connStr;
            taDisp.Connection.ConnectionString = connStr;
            taVRI.Connection.ConnectionString = connStr;
            taFile.Connection.ConnectionString = connStrFiles;
            taListVal.Connection.ConnectionString = connStrFiles;
        }

        #endregion

        #region area public

        public DS_ApplicazioneTableAdapters.AnagTipoConsegneTableAdapter taATC;
        public DS_ApplicazioneTableAdapters.AnagClientiTableAdapter taAC;
        public DS_ApplicazioneTableAdapters.AnagSquadreTableAdapter taAS;
        public DS_ApplicazioneTableAdapters.AnagZoneTableAdapter taAZ;
        public DS_ApplicazioneTableAdapters.AssegnSquadreTableAdapter taAsSq;
        public DS_ApplicazioneTableAdapters.AssegnSlotSquadreDipTableAdapter taASSD;
        public DS_ApplicazioneTableAdapters.ImpegniTableAdapter taImp;
        public DS_ApplicazioneTableAdapters.DettImpegnoTableAdapter taDetImp;
        public DS_ApplicazioneTableAdapters.v_clientiZoneTableAdapter taVcz;
        public DS_ApplicazioneTableAdapters.DB2_DOCSTableAdapter taDocs;
        public DS_ApplicazioneTableAdapters.DisponibilitaTableAdapter taDisp;
        public DS_ApplicazioneTableAdapters.v_resImpTableAdapter taVRI;
        public DS_UtilityTableAdapters.tblFilesTableAdapter taFile;
        public DS_UtilityTableAdapters.ListValuesTableAdapter taListVal;

        public static DtProxy man = new DtProxy();

        #endregion
    }
}