public virtual User[] GetUsers(Dictionary<string, string> query)
{
List<User> users;
using (var selectCommand = DatabaseProvider.DbProviderFactory.CreateCommand())
{
users = new List<User>();
InitializeGetUsersCommand(selectCommand, query);
using (var reader = DatabaseProvider.ExecuteReader(selectCommand))
{
User user;
while (reader.Read())
{
user = new User(reader.GetString(0));
user.IsAdmin = (bool)reader["IsAdmin"];
user.Expires = reader.GetColumnValue<DateTime>("Expires");
user.UseCardReader = reader.GetColumnValue<bool>("UseCardReader");
user.FriendlyName = reader.GetColumnValue<string>("FriendlyName");
user.UserType = reader.GetColumnValueOrDefault<string>("UserType");
var extendedName = reader.GetColumnValueOrDefault<string>("ExtendedName");
//resolve to proper format
var resolvedName = UserNameResolver.FromDb(user.UserName, extendedName, user.UserType);
user.UserName = resolvedName.Item1;
user.UserType = resolvedName.Item2;
users.Add(user);
}
}
}
return users.ToArray();
}
public virtual User [] GetUsers( )
{
List <User> users;
using (var selectCommand = DatabaseProvider.DbProviderFactory.CreateCommand())
{
users = new List <User>();
InitializeGetUsersCommand(selectCommand);
using (var reader = DatabaseProvider.ExecuteReader(selectCommand))
{
User user;
while (reader.Read())
{
user = new User(reader.GetColumnValue <string>("UserName"));
user.IsAdmin = reader.GetColumnValue <bool>("IsAdmin");
var UserType = reader.GetColumnValueOrDefault <string>("UserType");
var extendedName = reader.GetColumnValueOrDefault <string>("ExtendedName");
var resolvedName = UserNameResolver.FromDb(user.UserName, extendedName, user.UserType);
user.UserName = resolvedName.Item1;
users.Add(user);
}
}
return(users.ToArray());
}
}
public string IntGetuserType(string userName)
{
userName = FromInputUserName(userName);
try
{
object result;
using (var command = DatabaseProvider.DbProviderFactory.CreateCommand())
{
InitializeIsValidateOnDomainCommand(command, userName);
result = DatabaseProvider.ExecuteScalar(command);
if (null != result)
{
var typ = UserNameResolver.DecodeType(result.ToString());
return(typ);
}
}
}
catch {
}
return(null);
}
public UserPermission[] GetAllUserPermissions()
{
List <UserPermission> permissions = new List <UserPermission>();
using (var command = DatabaseProvider.DbProviderFactory.CreateCommand())
{
InitializeGetAllUserPermissions(command);
using (IDataReader reader = DatabaseProvider.ExecuteReader(command))
{
while (reader.Read())
{
UserPermission up = new UserPermission();
up.Permission = reader.GetColumnValue <string>("Permission");
up.Username = reader.GetColumnValue <string>("Username");
var userType = reader.GetColumnValueOrDefault <string>("UserType");
var extendedName = reader.GetColumnValueOrDefault <string>("ExtendedName");
//resolve to proper format
var resolvedName = UserNameResolver.FromDb(up.Username, extendedName, userType);
up.Username = resolvedName.Item1;
permissions.Add(up);
}
}
}
return(permissions.ToArray());
}
public bool AddUser(string userName, string friendlyName, SecureString password, DateTime? expireDate, string userType)
{
Exception _e = null;
try
{
using (var command = DatabaseProvider.DbProviderFactory.CreateCommand())
{
var resolvedName = UserNameResolver.ToDb(userName, userType);
InitializeGenericAddUserCommandExt(command, resolvedName.Item1, resolvedName.Item2, friendlyName, GetHashedPassword(password), expireDate, resolvedName.Item3);
return (DatabaseProvider.ExecuteNonQuery(command) > 0);
}
}
catch (Exception e)
{
//might fail for older schema databases, we fall through for backward compatibility
_e = e;
}
try
{
using (var command = DatabaseProvider.DbProviderFactory.CreateCommand())
{
InitializeGenericAddUserCommand(command, userName, friendlyName, GetHashedPassword(password), expireDate, string.IsNullOrEmpty(userType) ? UserType.Classic : userType);
return (DatabaseProvider.ExecuteNonQuery(command) > 0);
}
}
catch (Exception e)
{
//might fail for older schema databases, we fall through for backward compatibility
_e = e;
}
if (string.IsNullOrEmpty(userType) || userType == UserType.Classic)
{
return base.AddUser(userName, friendlyName, password, expireDate, false);
}
else if (userType == UserType.SmartCard)
{
return base.AddUser(userName, friendlyName, password, expireDate, true);
}
else
{
throw _e;
}
}
//all interface methods implementations that receive a userName should call this function
public virtual string FromInputUserName(string userName)
{
return(UserNameResolver.ToDb(userName, string.Empty).Item1);
}
