public async Task LogoutAsync(UserSessionId id, DateTime utcNow)
{
var sqlParams = new
{
Id = id.RawValue,
LogoutTime = DateTime.UtcNow
};
string sql = @";
UPDATE dbo.UserSessions
SET LogoutTime = @LogoutTime
WHERE Id = @Id
AND LogoutTime IS NULL;
";
await _db.Execute(async (db) =>
{
await db.ExecuteAsync(sql, sqlParams);
});
}
public async Task UpdateAsync(UserAuthenticationDTO userAuth)
{
var sqlParams = new
{
Id = Guid.NewGuid(),
userAuth.DisplayName,
userAuth.IsRevoked,
userAuth.RevokeTime
};
string sql = @";
UPDATE dbo.UserAuthenticationMethods
SET DisplayName = @DisplayName,
IsRevoked = @IsRevoked,
RevokeTime = @RevokeTime
WHERE Id = @Id;
";
await _db.Execute(async (db) =>
{
await db.ExecuteAsync(sql, sqlParams);
});
}