public IEnumerable <dynamic> Execute(LookupDefinition lookup, IDictionary <string, string> replaceableValues)
{
var sqlToExecute = Replace(lookup.Sql, replaceableValues);
using (var connection = new SqlConnection(_configuration.GetConnectionString(lookup.Name)))
{
connection.Open();
return(connection.Query(sqlToExecute));
}
}
private static LookupDefinitionForClient MapLookupDefinition(LookupDefinition def)
{
return(new LookupDefinitionForClient
{
MainMenuIcon = def.MainMenuIcon,
MainMenuSortKey = def.MainMenuSortKey ?? 0m,
MainMenuSection = def.MainMenuSection,
TitlePlural = def.TitlePlural,
TitlePlural2 = def.TitlePlural2,
TitlePlural3 = def.TitlePlural3,
TitleSingular = def.TitleSingular,
TitleSingular2 = def.TitleSingular2,
TitleSingular3 = def.TitleSingular3,
});
}
