public CacheConfig getConfigurazioneCache(string idAmministrazione)
{
CacheConfig info = null;
DocsPaUtils.Query queryDef = DocsPaUtils.InitQuery.getInstance().getQuery("S_CONFIG_CACHE");
queryDef.setParam("idAmministrazione", "'" + idAmministrazione + "'");
logger.Debug("getConfigurazioneCache - query :" + queryDef.getSQL());
string commandText = queryDef.getSQL();
using (DocsPaDB.DBProvider dbProvider = new DocsPaDB.DBProvider())
{
using (System.Data.IDataReader reader = dbProvider.ExecuteReader(commandText))
{
if (reader != null)
{
while (reader.Read())
{
info = new CacheConfig();
info.caching = reader.GetInt32(reader.GetOrdinal("CACHING")) == 1 ? true : false;
info.doc_root_server = reader.GetString(reader.GetOrdinal("DOC_ROOT_SERVER"));
info.massima_dimensione_caching = reader.GetDouble(reader.GetOrdinal("MASSIMA_DIMENSIONE_CACHING"));
info.massima_dimensione_file = reader.GetDouble(reader.GetOrdinal("MASSIMA_DIMENSIONE_FILE"));
info.idAmministrazione = reader.GetString(reader.GetOrdinal("idAmministrazione"));
info.ora_fine_cache = reader.GetString(reader.GetOrdinal("ORA_FINE_CACHE"));
info.ora_inizio_cache = reader.GetString(reader.GetOrdinal("ORA_INIZIO_CACHE"));
info.urlwscaching = reader.GetString(reader.GetOrdinal("urlwscaching"));
info.url_ws_caching_locale = reader.GetString(reader.GetOrdinal("url_ws_caching_locale"));
info.doc_root_server_locale = reader.GetString(reader.GetOrdinal("doc_root_server_locale"));
}
}
}
}
return(info);
}
public double PreencheAtributo(System.Data.IDataReader lDataReader, int NumeroColuna, double Atributo)
{
if ((lDataReader.IsDBNull(NumeroColuna) == true))
{
return(double.MinValue);
}
else
{
return(lDataReader.GetDouble(NumeroColuna));
}
}
public override float DrToFloat(System.Data.IDataReader dr, int index)
{
Type t = dr.GetFieldType(index);
if (t.Equals(typeof(decimal)))
{
return(dr.IsDBNull(index) ? 0 : (float)dr.GetDecimal(index));
}
else if (t.Equals(typeof(double)))
{
return(dr.IsDBNull(index) ? 0 : (float)dr.GetDouble(index));
}
else if (t.Equals(typeof(float)))
{
return(dr.IsDBNull(index) ? 0 : dr.GetFloat(index));
}
throw new NotImplementedException();
}
public double GetDouble(int i)
{
return(_innerReader.GetDouble(i));
}
