public static bool CannotCache(string key)
{
var settingsValue = ConfigurationProvider.Get("Settings:" + key + Constants.PosFixoRedis);
if (!String.IsNullOrEmpty(settingsValue))
{
bool result;
if (bool.TryParse(settingsValue, out result))
{
return(!result);
}
}
return(true);
}
public DataSet ExecuteStoredProcedure(string storedProcedureName, SqlParameter[] parameters = null, bool isAcademicoRDS = false)
{
try
{
var connectionString = "";
if (isAcademicoRDS)
{
connectionString = ConfigurationProvider.Get("ConnectionStrings:AcademicoRDS");
}
else
{
connectionString = ConfigurationProvider.Get("ConnectionStrings:DesenvConnection");
}
var ds = new DataSet();
using (var conn = new SqlConnection(connectionString))
{
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = storedProcedureName;
cmd.CommandType = CommandType.StoredProcedure;
if (parameters != null)
{
foreach (var parameter in parameters)
{
if (parameter.Value == null)
{
continue;
}
cmd.Parameters.Add(parameter);
}
}
using (var adapter = new SqlDataAdapter(cmd))
adapter.Fill(ds);
}
}
return(ds);
}
catch
{
throw;
}
}
public static void Connect()
{
try
{
var timeoutConnection = Convert.ToInt32(ConfigurationProvider.Get("Settings:RedisCacheConnectionTimeout"));
var configurationOptions = new ConfigurationOptions()
{
ConnectTimeout = timeoutConnection,
SyncTimeout = timeoutConnection,
EndPoints =
{
{ ConfigurationProvider.Get("Settings:RedisCacheConnection"), Convert.ToInt32(ConfigurationProvider.Get("Settings:RedisCacheConnectionPort")) }
}
};
var Connection = ConnectionMultiplexer.Connect(configurationOptions);
Db = Connection.GetDatabase();
Server = Connection.GetServer(Connection.GetEndPoints().FirstOrDefault());
DefaultTimeout = TimeSpan.FromDays(DefaultTimeoutDaysValue);
}
catch
{
ResetValues();
}
}
