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(); } }