public Task <AppUser> FindByIdAsync(string userId, CancellationToken cancellationToken)
{
ThrowIfDisposed();
if ((object)userId == null)
{
throw new ArgumentNullException(nameof(userId));
}
return(_connection.FirstOrDefault <AppUser>($"SELECT * FROM {_configuration.UserTableDataKey.Item1} WHERE {_configuration.UserTableDataKey.Item2} = '{userId}'"));
}
public async Task Initialize(int userGroupId)
{
string sql = $"SELECT * FROM UserGroups WHERE UserGroupId = '{userGroupId}'";
var queryResult = (await _connection.FirstOrDefault <UserGroupManager>(sql));
if (queryResult == null)
{
throw new InvalidDbModelCastException();
}
UserGroupId = queryResult.UserGroupId;
UserGroupName = queryResult.UserGroupName;
PasswordOptions = new PasswordOptions
{
RequiredLength = queryResult.PasswordRequiredLength,
RequireNonAlphanumeric = queryResult.PasswordRequireNonAlphanumeric,
RequireUppercase = queryResult.PasswordRequireUppercase,
RequireLowercase = queryResult.PasswordRequireLowercase,
RequireDigit = queryResult.PasswordRequireDigit,
};
_connection.Dispose();
}
