// fetches user information private void FetchUser(object obj, IDBManager dbmgr) { string qryLocal = "SELECT * FROM USERLIST WHERE NAME=@name"; _user = (User)obj; dbmgr.CreateParameters(1); dbmgr.AddParameters(0, "@name", _user.name); dbmgr.ExecuteReader(CommandType.Text, qryLocal); if (dbmgr.DataReader.Read()) { // get properties of object and fetch object PropertyInfo[] p = _user.GetType().GetProperties(); _user = (User)FetchObject(_user, p, dbmgr); } else { _user.initial = ""; _user.password = null; } dbmgr.CloseReader(); }
// fetches user access list private void FetchAccessList(IDBManager dbmgr) { string qryString = "SELECT * FROM USERLIST ORDER BY NAME"; User item = new User(); ArrayList list = new ArrayList(); PropertyInfo[] p = item.GetType().GetProperties(); dbmgr.ExecuteReader(CommandType.Text, qryString); while (dbmgr.DataReader.Read()) { item = new User(); item = (User)FetchObject(item, p, dbmgr); list.Add(item); } dbmgr.CloseReader(); _accesslist = list; }