public ArrayList GetCurrentUsers()
{
ArrayList ret = new ArrayList();
ClassQuery cq = new ClassQuery("Org.Reddragonit.FreeSwitchConfig.DataCore.DB.Users",
"SELECT usr.UserName,usr.FirstName,usr.LastName,usr.Email,usr.UserExtension.Number as extNumber,usr.Locked,usr.Disabled,usr.ID FROM User usr");
cq.Execute();
while (cq.Read())
{
Hashtable ht = new Hashtable();
ht.Add("UserName", cq[0].ToString());
ht.Add("FirstName", cq[1].ToString());
ht.Add("LastName", cq[2].ToString());
if (!cq.IsDBNull(3))
ht.Add("Email", cq[3].ToString());
if (!cq.IsDBNull(4))
ht.Add("Extension", cq[4].ToString());
ht.Add("Locked", cq.GetBoolean(5));
ht.Add("Disabled", cq.GetBoolean(6));
ht.Add("ID", cq.GetInt64(7));
ret.Add(ht);
}
cq.Close();
return ret;
}
