Exemple #1
0
        /// <summary>
        /// Получить список обратных каналов
        /// </summary>
        /// <returns></returns>
        private List <InrouteGroup> GetInrouteGroups()
        {
            List <InrouteGroup> inrouteGroups = new List <InrouteGroup>();

            MySqlCommand    command = new MySqlCommand(Queries.GetInrouteGroupsQuery, _connection);
            MySqlDataReader reader  = command.ExecuteReader();

            object[] values = new object[_maxResultFieldsCount];

            while (reader.Read())
            {
                reader.GetValues(values);
                InrouteGroup currentInrouteGroup = new InrouteGroup();
                currentInrouteGroup.Id        = Convert.ToUInt32(values[0]);
                currentInrouteGroup.Name      = values[1].ToString();
                currentInrouteGroup.NetworkId = Convert.ToUInt32(values[2]);
                inrouteGroups.Add(currentInrouteGroup);
            }
            reader.Close();

            return(inrouteGroups);
        }
        /// <summary>
        /// Получить список обратных каналов
        /// </summary>
        /// <returns></returns>
        private List<InrouteGroup> GetInrouteGroups()
        {
            List<InrouteGroup> inrouteGroups = new List<InrouteGroup>();

            MySqlCommand command = new MySqlCommand(Queries.GetInrouteGroupsQuery, _connection);
            MySqlDataReader reader = command.ExecuteReader();
            object[] values = new object[_maxResultFieldsCount];

            while (reader.Read())
            {
                reader.GetValues(values);
                InrouteGroup currentInrouteGroup = new InrouteGroup();
                currentInrouteGroup.Id = Convert.ToUInt32(values[0]);
                currentInrouteGroup.Name = values[1].ToString();
                currentInrouteGroup.NetworkId = Convert.ToUInt32(values[2]);
                inrouteGroups.Add(currentInrouteGroup);
            }
            reader.Close();

            return inrouteGroups;
        }