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, }); } }