public async Task HandleAsync(ConfirmEmailCommand handled)
{
using (var context = _provider.GetConnection())
{
await context.QueryAsync("SELECT funcs.activate(@Url)", new { Url = handled.Activation });
}
}
public async Task <User> HandleAsync(UserByLoginQuery handled)
{
using (var context = _provider.GetConnection())
{
var founded = await context.QueryFirstOrDefaultAsync <UserDB>(
"SELECT * FROM tables.users WHERE login = @Login LIMIT 1",
handled);
return(founded is null ? null : _mapper.Map <UserDB, User>(founded));
}
}
public async Task <Token> HandleAsync(TokenQuery handled)
{
using (var context = _provider.GetConnection())
{
var founded = await context.QueryFirstOrDefaultAsync <TokenDB>(
"SELECT * FROM tables.tokens WHERE token = @Token LIMIT 1",
handled);
return(founded is null ? null : _mapper.Map <TokenDB, Token>(founded));
}
}
public async Task <User> HandleAsync(AuthQuery handled)
{
using (var context = _provider.GetConnection())
{
var founded = await context.QueryFirstOrDefaultAsync <UserDB>(
"SELECT * FROM tables.users WHERE (login = @Login OR email = @Login) AND password = @Password",
handled
);
return(founded is null ? null : _mapper.Map <UserDB, User>(founded));
}
}
public async Task HandleAsync(AddUserCommand handled)
{
using (var context = _provider.GetConnection())
{
await context.QueryAsync <bool>(
"SELECT funcs.register(@Id, @Login, @Password, @Email, @ActivationUrl);",
new
{
Id = handled.UserToAdd.Id,
Login = handled.UserToAdd.Login,
Password = handled.UserToAdd.Password,
Email = handled.UserToAdd.UserEmail.Email,
ActivationUrl = handled.UserToAdd.UserEmail.ActivationUrl,
});
}
}
public async Task HandleAsync(WriteTokenCommand handled)
{
using (var context = _provider.GetConnection())
{
await context.QueryAsync(
"SELECT funcs.write_token(@UserId, @Token, @Platform, @Expiry, @Creation, @Jwt)",
new
{
UserId = handled.UserId,
Token = handled.Token,
Platform = handled.Platform,
Expiry = handled.ExpiryDate,
Creation = DateTime.UtcNow,
Jwt = handled.JwtId,
});
}
}