Example #1
0
 internal List<RoomData> GetAllFriends()
 {
     List<RoomData> temp = new List<RoomData>();
     foreach(MessengerBuddy friend in friends.Values)
     {
         DataTable Data = new DataTable();
         using (IQueryAdapter dbClient = SilverwaveEnvironment.GetDatabaseManager().getQueryreactor())
         {
             dbClient.setQuery("SELECT * FROM rooms WHERE owner = '"+friend.mUsername+"';");
             Data = dbClient.getTable();
             
         }
         foreach (DataRow d in Data.Rows)
         {
             RoomData x = new RoomData();
             t = (uint)d["id"];
             RoomManager s = new RoomManager();
             x = s.FetchRoomData(Convert.ToUInt32(t), d);
             temp.Add(x);
         }
     }
     return temp;
 }