using System;
using System.Collections.Generic;
using System.Web;
using SteamWare;

/// <summary>
/// Summary description for TA_app
/// </summary>
public class TA_app
{
  #region table adapters

  public GIM_dataLayer.DS_applicazioneTableAdapters.LogUpdateDbTableAdapter taLogUpdate;
  public GIM_dataLayer.DS_applicazioneTableAdapters.AnagImpiantiTableAdapter taImpianti;
  public GIM_dataLayer.DS_applicazioneTableAdapters.v_macchineTableAdapter taMacchine;
  public GIM_dataLayer.DS_applicazioneTableAdapters.v_selFamMaccTableAdapter taMacc2Fam;
  public GIM_dataLayer.DS_applicazioneTableAdapters.v_intervExpTableAdapter taInterventiMtz;
  public GIM_dataLayer.DS_applicazioneTableAdapters.AnagStatiTableAdapter taStati;
  public GIM_dataLayer.DS_applicazioneTableAdapters.AnagPrioritaTableAdapter taPrior;
  public GIM_dataLayer.DS_applicazioneTableAdapters.InterventoOpMtzTableAdapter taIntOpMtz;
  public GIM_dataLayer.DS_applicazioneTableAdapters.v_mtzProgExpTableAdapter taMtzPro;
  public GIM_dataLayer.DS_applicazioneTableAdapters.CalendFesteFerieTableAdapter taCalFF;
  public GIM_dataLayer.DS_applicazioneTableAdapters.OreAperturaSettTableAdapter taOreApert;
  public GIM_dataLayer.DS_applicazioneTableAdapters.FiltroImpiantiTableAdapter taFiltImp;
  public GIM_dataLayer.DS_applicazioneTableAdapters.FiltroMacchineTableAdapter taFiltMac;
  public GIM_dataLayer.DS_applicazioneTableAdapters.FiltroStatiTableAdapter taFiltSta;
  public GIM_dataLayer.DS_applicazioneTableAdapters.AnagCausaliTableAdapter taAnagCau;
  public GIM_dataLayer.DS_applicazioneTableAdapters.ImpiegoRisorseTableAdapter taImpRis;
  public GIM_dataLayer.DS_applicazioneTableAdapters.v_allDataTableAdapter taAllData;
  public GIM_dataLayer.DS_applicazioneTableAdapters.ElencoIntervExtTableAdapter taElencoIntExt;
  public GIM_dataLayer.DS_applicazioneTableAdapters.MtzProg_ScadenzeTableAdapter taScadenze;
  public GIM_dataLayer.DS_MagTableAdapters.AnagItemsTableAdapter taAnagItem;
  public GIM_dataLayer.DS_MagTableAdapters.AnagLocazioniTableAdapter taAnagLoc;
  public GIM_dataLayer.DS_MagTableAdapters.AnagTagsTableAdapter taAnagTags;
  public GIM_dataLayer.DS_MagTableAdapters.MagRicTableAdapter taMagRic;
  public GIM_dataLayer.DS_MagTableAdapters.MovMagRicTableAdapter taMovMag;
  public GIM_dataLayer.DS_MagTableAdapters.SinonimiTagTableAdapter taSinTag;
  public GIM_dataLayer.DS_MagTableAdapters.StatoMagTableAdapter taStatoMag;
  public GIM_dataLayer.DS_MagTableAdapters.Tag2ItemTableAdapter taTag2Item;
  public GIM_dataLayer.DS_MagTableAdapters.Tag2MaccTableAdapter taTag2Macc;
  public GIM_dataLayer.DS_utilityTableAdapters.v_elencoImpiantiMacchineTableAdapter taElencoImpMacch;
  public GIM_dataLayer.DS_utilityTableAdapters.v_elencoIntervFiltTableAdapter taElencoIntFilt;
  public GIM_dataLayer.DS_utilityTableAdapters.sp_elencoIntMTBF_MTTRTableAdapter taElenco_MTBF_MTTR;
  public GIM_dataLayer.DS_utilityTableAdapters.v_selImpiantiTableAdapter taSelImpianti;
  public GIM_dataLayer.DS_utilityTableAdapters.v_selMacchineTableAdapter taSelMacchine;
  public GIM_dataLayer.DS_utilityTableAdapters.v_selOperMtzTableAdapter taSelMatrOp;
  public GIM_dataLayer.DS_utilityTableAdapters.v_selCodRicAmmTableAdapter taSelCRA;

  #endregion

  /// <summary>
  /// effettua setup dei connection strings da web.config della singola applicazione
  /// </summary>
  protected virtual void setupConnectionString()
  {
    // connections del db
    string connString = memLayer.ML.confReadString("AppConnectionString");
    taLogUpdate.Connection.ConnectionString = connString;
    taImpianti.Connection.ConnectionString = connString;
    taMacchine.Connection.ConnectionString = connString;
    taSelImpianti.Connection.ConnectionString = connString;
    taSelMacchine.Connection.ConnectionString = connString;
    taMacc2Fam.Connection.ConnectionString = connString;
    taInterventiMtz.Connection.ConnectionString = connString;
    taStati.Connection.ConnectionString = connString;
    taPrior.Connection.ConnectionString = connString;
    taIntOpMtz.Connection.ConnectionString = connString;
    taMtzPro.Connection.ConnectionString = connString;
    taElencoImpMacch.Connection.ConnectionString = connString;
    taElencoIntFilt.Connection.ConnectionString = connString;
    taElenco_MTBF_MTTR.Connection.ConnectionString = connString;
    taCalFF.Connection.ConnectionString = connString;
    taOreApert.Connection.ConnectionString = connString;
    taFiltImp.Connection.ConnectionString = connString;
    taFiltMac.Connection.ConnectionString = connString;
    taFiltSta.Connection.ConnectionString = connString;
    taAnagCau.Connection.ConnectionString = connString;
    taSelMatrOp.Connection.ConnectionString = connString;
    taSelCRA.Connection.ConnectionString = connString;
    taImpRis.Connection.ConnectionString = connString;
    taAllData.Connection.ConnectionString = connString;
    taElencoIntExt.Connection.ConnectionString = connString;
    taScadenze.Connection.ConnectionString = connString;
    taAnagItem.Connection.ConnectionString = connString;
    taAnagLoc.Connection.ConnectionString = connString;
    taAnagTags.Connection.ConnectionString = connString;
    taMagRic.Connection.ConnectionString = connString;
    taMovMag.Connection.ConnectionString = connString;
    taSinTag.Connection.ConnectionString = connString;
    taStatoMag.Connection.ConnectionString = connString;
    taTag2Item.Connection.ConnectionString = connString;
    taTag2Macc.Connection.ConnectionString = connString;
  }
  protected TA_app()
  {
    initTA();
    setupConnectionString();
  }

  private void initTA()
  {
    // avvio table adapters
    taLogUpdate = new GIM_dataLayer.DS_applicazioneTableAdapters.LogUpdateDbTableAdapter();
    taImpianti = new GIM_dataLayer.DS_applicazioneTableAdapters.AnagImpiantiTableAdapter();
    taMacchine = new GIM_dataLayer.DS_applicazioneTableAdapters.v_macchineTableAdapter();
    taSelImpianti = new GIM_dataLayer.DS_utilityTableAdapters.v_selImpiantiTableAdapter();
    taSelMacchine = new GIM_dataLayer.DS_utilityTableAdapters.v_selMacchineTableAdapter();
    taMacc2Fam = new GIM_dataLayer.DS_applicazioneTableAdapters.v_selFamMaccTableAdapter();
    taInterventiMtz = new GIM_dataLayer.DS_applicazioneTableAdapters.v_intervExpTableAdapter();
    taStati = new GIM_dataLayer.DS_applicazioneTableAdapters.AnagStatiTableAdapter();
    taPrior = new GIM_dataLayer.DS_applicazioneTableAdapters.AnagPrioritaTableAdapter();
    taIntOpMtz = new GIM_dataLayer.DS_applicazioneTableAdapters.InterventoOpMtzTableAdapter();
    taMtzPro = new GIM_dataLayer.DS_applicazioneTableAdapters.v_mtzProgExpTableAdapter();
    taElencoImpMacch = new GIM_dataLayer.DS_utilityTableAdapters.v_elencoImpiantiMacchineTableAdapter();
    taElencoIntFilt = new GIM_dataLayer.DS_utilityTableAdapters.v_elencoIntervFiltTableAdapter();
    taElenco_MTBF_MTTR = new GIM_dataLayer.DS_utilityTableAdapters.sp_elencoIntMTBF_MTTRTableAdapter();
    taCalFF = new GIM_dataLayer.DS_applicazioneTableAdapters.CalendFesteFerieTableAdapter();
    taOreApert = new GIM_dataLayer.DS_applicazioneTableAdapters.OreAperturaSettTableAdapter();
    taFiltImp = new GIM_dataLayer.DS_applicazioneTableAdapters.FiltroImpiantiTableAdapter();
    taFiltMac = new GIM_dataLayer.DS_applicazioneTableAdapters.FiltroMacchineTableAdapter();
    taFiltSta = new GIM_dataLayer.DS_applicazioneTableAdapters.FiltroStatiTableAdapter();
    taAnagCau = new GIM_dataLayer.DS_applicazioneTableAdapters.AnagCausaliTableAdapter();
    taSelMatrOp = new GIM_dataLayer.DS_utilityTableAdapters.v_selOperMtzTableAdapter();
    taSelCRA = new GIM_dataLayer.DS_utilityTableAdapters.v_selCodRicAmmTableAdapter();
    taImpRis = new GIM_dataLayer.DS_applicazioneTableAdapters.ImpiegoRisorseTableAdapter();
    taAllData = new GIM_dataLayer.DS_applicazioneTableAdapters.v_allDataTableAdapter();
    taElencoIntExt = new GIM_dataLayer.DS_applicazioneTableAdapters.ElencoIntervExtTableAdapter();
    taScadenze = new GIM_dataLayer.DS_applicazioneTableAdapters.MtzProg_ScadenzeTableAdapter();
    taAnagItem = new GIM_dataLayer.DS_MagTableAdapters.AnagItemsTableAdapter();
    taAnagLoc = new GIM_dataLayer.DS_MagTableAdapters.AnagLocazioniTableAdapter();
    taAnagTags = new GIM_dataLayer.DS_MagTableAdapters.AnagTagsTableAdapter();
    taMagRic = new GIM_dataLayer.DS_MagTableAdapters.MagRicTableAdapter();
    taMovMag = new GIM_dataLayer.DS_MagTableAdapters.MovMagRicTableAdapter();
    taSinTag = new GIM_dataLayer.DS_MagTableAdapters.SinonimiTagTableAdapter();
    taStatoMag = new GIM_dataLayer.DS_MagTableAdapters.StatoMagTableAdapter();
    taTag2Item = new GIM_dataLayer.DS_MagTableAdapters.Tag2ItemTableAdapter();
    taTag2Macc = new GIM_dataLayer.DS_MagTableAdapters.Tag2MaccTableAdapter();
  }

  /// <summary>
  /// Singleton
  /// </summary>
  public static TA_app obj = new TA_app();
  /// <summary>
  /// restituisce versione corrente del db applicativo
  /// </summary>
  public int appDB_act
  {
    get
    {
      int answ = -1;
      try
      {
        answ = (int)taLogUpdate.getDbVers();
      }
      catch
      {
        logger.lg.scriviLog("Errore recupero versione DB applicativo GIM!", tipoLog.EXCEPTION);
      }
      return answ;
    }
  }
  /// <summary>
  /// restituisce versione corrente del db vocabolario
  /// </summary>
  public int vocDB_act
  {
    get
    {
      int answ = -1;
      try
      {
        answ = (int)DataWrap.DW.taLogVoc.getDbVers();
      }
      catch
      {
        logger.lg.scriviLog("Errore recupero versione DB Vocabolario!", tipoLog.EXCEPTION);
      }
      return answ;
    }
  }
  /// <summary>
  /// restituisce versione corrente del db anagrafica
  /// </summary>
  public int anaDB_act
  {
    get
    {
      int answ = -1;
      try
      {
        answ = answ = (int)DataWrap.DW.taLogAna.getDbVers();
      }
      catch
      {
        logger.lg.scriviLog("Errore recupero versione DB Anagrafica!", tipoLog.EXCEPTION);
      }
      return answ;
    }
  }
  /// <summary>
  /// restituisce versione richiesta per il db applicativo
  /// </summary>
  public int appDB_req
  {
    get
    {
      return memLayer.ML.confReadInt("dbAppVers");
    }
  }
  /// <summary>
  /// restituisce versione richiesta per il db vocabolario
  /// </summary>
  public int vocDB_req
  {
    get
    {
      return memLayer.ML.confReadInt("dbVocabVers");
    }
  }
  /// <summary>
  /// restituisce versione richiesta per il db anagrafica
  /// </summary>
  public int anaDB_req
  {
    get
    {
      return memLayer.ML.confReadInt("dbAuthVers");
    }
  }
}