private async Task <UserDetailsDto> GetUserInfo(string username) { using (var connection = await DbConnectionFactory.GetOpenMySqlConnectionAsync()) { return(await connection.QueryFirstOrDefaultAsync <UserDetailsDto>( "SELECT * FROM app_users WHERE username = @Username", new { Username = username })); } }
private async Task <string> GetHashedPasswordFromTable(string username) { using (var connection = await DbConnectionFactory.GetOpenMySqlConnectionAsync()) { return(await connection.QueryFirstOrDefaultAsync <string>( "SELECT password FROM app_users WHERE username = @Username", new { Username = username })); } }
public async Task CreateNewUser(UserDetailsDto user) { var hashedPassword = PasswordHasher.HashPassword(user, user.Password); using (var connection = await DbConnectionFactory.GetOpenMySqlConnectionAsync()) { await connection.ExecuteAsync( @"INSERT INTO app_users (username, password) VALUES (@Username, @Password)", new { Username = user.Username, Password = hashedPassword }); } }