public async Task <int> GetAllProductCountAsync(GetAllProductCount query) { const string sql = @"SELECT COUNT(Id) FROM Products;"; await using var connection = new SqlConnection(_connectionString); await using var command = new SqlCommand(sql, connection); await connection.EnsureIsOpenAsync().ConfigureAwait(false); await using var reader = await command.ExecuteReaderAsync().ConfigureAwait(false); if (!await reader.ReadAsync().ConfigureAwait(false)) { return(0); } var count = reader.AsInt32(0); return(count); }
public Task <int> HandleAsync(GetAllProductCount query) { return(_readRepository.GetAllProductCountAsync(query)); }
public async Task <IActionResult> GetAllProductCountAsync([FromQuery] GetAllProductCount query) { var data = await Mediator.QueryAsync(query).ConfigureAwait(false); return(Ok(data)); }
public async Task <IActionResult> GetAllProductCount(GetAllProductCount query) { var count = await _queryProcessor.QueryAsync(query); return(Ok(count)); }