public async Task <IActionResult> Post([FromBody] CreateQueryCommand command)
{
var queryId = await QueryCreator.Create(command);
if (command.Params != null && command.Params.Any())
{
await QueryParamCreator.Create(new CreateQueryParamCommand(queryId, command.Params));
}
return(Ok());
}
public QueryDto Create(long projectId, string name)
{
var command = new CreateQueryCommand(name, projectId);
_commandDispatcher.Handle(command);
var query = new QueryByNameQuery(name, projectId);
var queryDto = _dataQueryDispatcher.Process <QueryByNameQuery, QueryDto>(query);
return(queryDto);
}
public async Task <int> Create(CreateQueryCommand command)
{
using (var connection = new SqlConnection(Configuration.ConnectionString))
return(await connection.ExecuteScalarAsync <int>(Query, command));
}
