public IEnumerable <TeamMember> AllTeamMembers(TenantId tenantId)
{
using var conn = _provider.GetConnection();
var sql = $@"
select
tenant_id as {nameof(TeamMemberDTO.TenantId)},
username as {nameof(TeamMemberDTO.Username)},
first_name as {nameof(TeamMemberDTO.FirstName)},
last_name as {nameof(TeamMemberDTO.LastName)},
email_address as {nameof(TeamMemberDTO.EmailAddress)},
enabled as {nameof(TeamMemberDTO.Enabled)},
email_address_update_timestamp as {nameof(TeamMemberDTO.EmailAddressUpdateTimestamp)},
enabling_toggle_timestamp as {nameof(TeamMemberDTO.EnablingToggleTimestamp)},
name_update_timestamp as {nameof(TeamMemberDTO.NameUpdateTimestamp)}
from
tbl_team_member
where
tenant_id = @TenantId;
";
var teamMemberDTOs = conn.Query <TeamMemberDTO>(sql, new { TenantId = tenantId.Id });
return(teamMemberDTOs.
Select(c => new TeamMember(
new TenantId(c.TenantId),
c.Username,
c.LastName,
c.FirstName,
c.EmailAddress,
new MemberChangeTracker(c.EmailAddressUpdateTimestamp, c.EnablingToggleTimestamp, c.NameUpdateTimestamp))));
}
