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(); } }
public DataSet ExecuteQuery(string query, bool isAcademicoRDS = false) { 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 = query; cmd.CommandType = CommandType.Text; using (var adapter = new SqlDataAdapter(cmd)) adapter.Fill(ds); } } return(ds); }
public bool ExecuteNonQuery(string query) { try { var connectionString = ConfigurationProvider.Get("ConnectionStrings:DesenvConnection"); var ds = new DataSet(); using (var conn = new SqlConnection(connectionString)) { conn.Open(); using (var cmd = conn.CreateCommand()) { cmd.CommandText = query; cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); return(true); } } } catch (Exception) { return(false); } }
public static ContribuicaoBucketDTO GetConfig() { var config = new ContribuicaoBucketDTO(); config.AccessKeyId = ConfigurationProvider.Get("Settings:ContribuicaoAccessKey"); config.SecretAccessKey = ConfigurationProvider.Get("Settings:ContribuicaoSecretAccessKey"); config.Region = ConfigurationProvider.Get("Settings:ContribuicaoRegion"); config.Bucket = ConfigurationProvider.Get("Settings:ContribuicaoBucket"); config.ACL = ConfigurationProvider.Get("Settings:ContribuicaoACL"); config.GetSignedUrl = ConfigurationProvider.Get("Settings:ContribuicaoGetSignedUrl"); return(config); }
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; } }