/// <summary> /// Load's room data by RoomId /// </summary> /// <param name="id">RoomId</param> public static List <RoomSql> GetData() { // Uses MySql Reader, since i had problems with NHibernate doing this. var room = new List <RoomSql>(); MySqlDataReader reader = MySqlHelper.ExecuteReader(Application.ConnectionString, "SELECT * FROM rooms"); if (reader.HasRows) { while (reader.Read()) { var instance = new RoomSql(); instance.id = reader.GetInt32("id"); instance.ownerId = reader.GetInt32("owner_id"); instance.caption = reader.GetString("name"); instance.description = reader.GetString("description"); instance.model = reader.GetString("model"); instance.state = reader.GetString("state"); instance.category = reader.GetInt32("category"); instance.password = reader.GetString("password"); instance.wallpaper = reader.GetString("wallpaper"); instance.wallsize = reader.GetInt32("wallsize"); instance.floor = reader.GetString("floor"); instance.floorsize = reader.GetInt32("floorsize"); instance.score = reader.GetInt32("score"); instance.tags.Add(reader.GetString("tags")); instance.iconbg = reader.GetInt32("iconbg"); instance.iconfg = reader.GetInt32("iconfg"); instance.iconitems.Add(reader.GetString("iconitems")); instance.usersMax = reader.GetInt32("users_max"); instance.usersNow = reader.GetInt32("users_now"); AllRooms.Add(instance); } } return(room); }
/// <summary> /// Load's room data by RoomId /// </summary> /// <param name="id">RoomId</param> public static List<RoomSql> GetData() { // Uses MySql Reader, since i had problems with NHibernate doing this. var room = new List<RoomSql>(); MySqlDataReader reader = MySqlHelper.ExecuteReader(Application.ConnectionString, "SELECT * FROM rooms"); if (reader.HasRows) { while (reader.Read()) { var instance = new RoomSql(); instance.id = reader.GetInt32("id"); instance.ownerId = reader.GetInt32("owner_id"); instance.caption = reader.GetString("name"); instance.description = reader.GetString("description"); instance.model = reader.GetString("model"); instance.state = reader.GetString("state"); instance.category = reader.GetInt32("category"); instance.password = reader.GetString("password"); instance.wallpaper = reader.GetString("wallpaper"); instance.wallsize = reader.GetInt32("wallsize"); instance.floor = reader.GetString("floor"); instance.floorsize = reader.GetInt32("floorsize"); instance.score = reader.GetInt32("score"); instance.tags.Add(reader.GetString("tags")); instance.iconbg = reader.GetInt32("iconbg"); instance.iconfg = reader.GetInt32("iconfg"); instance.iconitems.Add(reader.GetString("iconitems")); instance.usersMax = reader.GetInt32("users_max"); instance.usersNow = reader.GetInt32("users_now"); AllRooms.Add(instance); } } return room; }