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