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