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