public List <S_Room> GetRoomsInStation(string id) { SqlParameter[] parms = { new SqlParameter("@StationId", SqlDbType.VarChar, 100) }; parms[0].Value = SqlTypeConverter.DBNullStringChecker(id); var entities = new List <S_Room>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_S_Room_Repository_GetRoomsInStation, parms)) { while (rdr.Read()) { var entity = new S_Room(); entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]); entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]); entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]); entity.Type = new C_RoomType { Id = SqlTypeConverter.DBNullStringHandler(rdr["RoomTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["RoomTypeName"]) }; entity.Vendor = SqlTypeConverter.DBNullStringHandler(rdr["Vendor"]); entity.Floor = SqlTypeConverter.DBNullInt32Handler(rdr["Floor"]); entity.PropertyId = SqlTypeConverter.DBNullInt32Handler(rdr["PropertyId"]); entity.Address = SqlTypeConverter.DBNullStringHandler(rdr["Address"]); entity.Length = SqlTypeConverter.DBNullStringHandler(rdr["Length"]); entity.Width = SqlTypeConverter.DBNullStringHandler(rdr["Width"]); entity.Heigth = SqlTypeConverter.DBNullStringHandler(rdr["Heigth"]); entity.FloorLoad = SqlTypeConverter.DBNullStringHandler(rdr["FloorLoad"]); entity.LineHeigth = SqlTypeConverter.DBNullStringHandler(rdr["LineHeigth"]); entity.Square = SqlTypeConverter.DBNullStringHandler(rdr["Square"]); entity.EffeSquare = SqlTypeConverter.DBNullStringHandler(rdr["EffeSquare"]); entity.FireFighEuip = SqlTypeConverter.DBNullStringHandler(rdr["FireFighEuip"]); entity.Owner = SqlTypeConverter.DBNullStringHandler(rdr["Owner"]); entity.QueryPhone = SqlTypeConverter.DBNullStringHandler(rdr["QueryPhone"]); entity.PowerSubMain = SqlTypeConverter.DBNullStringHandler(rdr["PowerSubMain"]); entity.TranSubMain = SqlTypeConverter.DBNullStringHandler(rdr["TranSubMain"]); entity.EnviSubMain = SqlTypeConverter.DBNullStringHandler(rdr["EnviSubMain"]); entity.FireSubMain = SqlTypeConverter.DBNullStringHandler(rdr["FireSubMain"]); entity.AirSubMain = SqlTypeConverter.DBNullStringHandler(rdr["AirSubMain"]); entity.Contact = SqlTypeConverter.DBNullStringHandler(rdr["Contact"]); entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]); entity.AreaName = SqlTypeConverter.DBNullStringHandler(rdr["AreaName"]); entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]); entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]); entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]); entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]); entities.Add(entity); } } return(entities); }
public static void C_RoomHandler(PacketSession session, IMessage packet) { Console.WriteLine("Room Give Please"); ClientSession clientSession = session as ClientSession; S_Room roomPacket = new S_Room(); for (int i = 1; i < RoomManager.Instance._roomId; i++) { RoomInfo roomInfo = new RoomInfo(); roomInfo.PlayerNumber = RoomManager.Instance.Find(i).PlayerNumber; roomInfo.RoomId = i; roomInfo.Name = RoomManager.Instance.Find(i).RoomName; roomInfo.Password = RoomManager.Instance.Find(i).Password; if (!RoomManager.Instance.Find(i).isCreating&& !RoomManager.Instance.Find(i).isPlaying) { roomPacket.Room.Add(roomInfo); } } clientSession.Send(roomPacket); }