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