// 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;
}