public async Task <List <Model.KeyValuePair> > GetSettings(Guid application)
{
var result = new List <Model.KeyValuePair>();
Logger.Trace("BEGIN | Matrix.Server.Configurator.Database.ConfigurationRepository.GetSettings");
DbConnection connection = null;
try
{
using (connection = GetDbConnection())
{
await connection.OpenAsync();
dynamic entity = await connection.QueryAsync <dynamic>("SELECT [Id], [Application], [Enabled], [Key], [Value], [Created], [Updated] FROM [Configuration] WHERE [Application] = @application AND [Deleted] = @deleted", new { @application = application, @deleted = false });
foreach (var i in entity)
{
var o = new Model.KeyValuePair();
o.Id = Parse.Guid(i.Id);
o.Application = Parse.Guid(i.Id);
o.Enabled = Parse.Bool(i.Enabled);
o.Key = i.Key;
o.Value = i.Value;
o.Created = Parse.DateTime(i.Created);
o.Updated = Parse.DateTime(i.Updated);
result.Add(o);
}
connection.Close();
}
}
catch (Exception e)
{
Logger.Trace("ERROR | Matrix.Server.Configurator.Database.ConfigurationRepository.GetSettings");
Logger.Error(e);
}
Logger.Trace("END | Matrix.Server.Configurator.Database.ConfigurationRepository.GetSettings");
return(result);
}
public async Task <Model.KeyValuePair> GetSettings(Guid application, string key)
{
var result = new Model.KeyValuePair();
Logger.Trace("BEGIN | Matrix.Server.Configurator.Database.ConfigurationRepository.GetSettings");
DbConnection connection = null;
try
{
using (connection = GetDbConnection())
{
await connection.OpenAsync();
dynamic entity = (await connection.QueryAsync <dynamic>("SELECT [Id], [Application], [Enabled], [Key], [Value], [Created], [Updated] FROM [Configuration] WHERE [Application] = @application AND [Key] = @key AND [Deleted] = @deleted", new { @application = application, @key = key, @deleted = false }))?.FirstOrDefault();
if (entity != null)
{
result.Id = Parse.Guid(entity.Id);
result.Application = Parse.Guid(entity.Id);
result.Enabled = Parse.Bool(entity.Enabled);
result.Key = entity.Key;
result.Value = entity.Value;
result.Created = Parse.DateTime(entity.Created);
result.Updated = Parse.DateTime(entity.Updated);
}
connection.Close();
}
}
catch (Exception e)
{
Logger.Trace("ERROR | Matrix.Server.Configurator.Database.ConfigurationRepository.GetSettings");
Logger.Error(e);
}
Logger.Trace("END | Matrix.Server.Configurator.Database.ConfigurationRepository.GetSettings");
return(result);
}
