public async Task <Permission> ExecuteAsync(int id, SqlConnection connection, CancellationToken cancellationToken = default)
{
using var command = Get(id, connection);
using var reader = await command.ExecuteReaderAsync(cancellationToken);
if (reader.HasRows && await reader.ReadAsync(cancellationToken))
{
return(_readerConverter.Convert(reader));
}
return(default);
public async Task ExecuteAsync(Permission.SearchModel model, Permission.SearchResult result, SqlConnection connection, CancellationToken cancellationToken = default)
{
using var command = Get(model, connection);
using var reader = await command.ExecuteReaderAsync(cancellationToken);
if (reader.HasRows)
{
while (await reader.ReadAsync(cancellationToken))
{
result.Permissions.Add(_readerConverter.Convert(reader));
}
}
result.TotalCount = await ReadTotalCountAsync(reader, cancellationToken);
}