public ChannelInfo[] GetAllChannels()
        {
            _db.Open();

            List<ChannelInfo> channels = new List<ChannelInfo>();

            DbDataReader reader = _db.ExcecuteReader(DbNames.GETALLCHANNELS_STOREDPROC, System.Data.CommandType.StoredProcedure, null);

            int ordinalId = reader.GetOrdinal(DbNames.CHANNELINFO_ID);
            int ordinalName = reader.GetOrdinal(DbNames.CHANNELINFO_NAME);
            int ordinalDesc = reader.GetOrdinal(DbNames.CHANNELINFO_DESC);
            int ordinalIP = reader.GetOrdinal(DbNames.CHANNELINFO_IP);
            int ordinalPort = reader.GetOrdinal(DbNames.CHANNELINFO_PORT);
            int ordinalPK = reader.GetOrdinal(DbNames.CHANNELINFO_PK);
            while (reader.Read())
            {
                ChannelInfo channel = new ChannelInfo
                {
                    ChannelId = reader.GetInt32(ordinalId),
                    ChannelName = reader.GetString(ordinalName),
                    ChannelDesc = reader.GetString(ordinalDesc),
                    IPAddress = reader.GetString(ordinalIP),
                    Port = reader.GetInt32(ordinalPort),
                    PK = reader.GetBoolean(ordinalPK)
                };

                channels.Add(channel);
            }

            reader.Close();
            _db.Close();

            return channels.ToArray();
        }
 /// <summary>
 /// Send channel to client
 /// </summary>
 /// <param name="CI">Channel Info, containing id, name, desc, ip address and port</param>
 /// <param name="TotalChannels"></param>
 /// <returns></returns>
 public static byte[] SendChannel(ChannelInfo CI, int TotalChannels)
 {
     Packet p = new Packet(500);
     p.WriteByte(TotalChannels); // total channels
     p.WriteByte(CI.ChannelId); // channel id
     p.WriteString(CI.ChannelName); // name
     p.WriteString(CI.ChannelDesc); // desc
     p.WriteHexString("12 F4 01");
     p.WriteString(CI.IPAddress); // ip
     p.WriteShort(CI.Port); // port
     p.WriteHexString("00 00 00");
     return p.GetWrittenBuffer(PacketIds.SendChannelList);
 }