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