Exemple #1
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="membershipId"></param>
        /// <param name="connection"></param>
        /// <param name="transaction"></param>
        /// <returns></returns>
        public ICollection <long> Get(long membershipId, DbConnection connection, DbTransaction transaction)
        {
            var reader = default(KandaDbDataReader);

            try
            {
                reader = MembershipUsersGateway.Select(new MembershipUsersCriteria()
                {
                    MembershipID = membershipId,
                }, connection, transaction);

                var gotten = new Collection <long>();
                while (reader.Read())
                {
                    gotten.Add(reader.GetInt64(@"UserID"));
                }

                return(gotten);
            }
            finally
            {
                if (reader != null)
                {
                    reader.Close();
                }
            }
        }
Exemple #2
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="userId"></param>
        /// <param name="connection"></param>
        /// <param name="transaction"></param>
        /// <returns></returns>
        public long Find(long userId, DbConnection connection, DbTransaction transaction)
        {
            var reader = default(IDataReader);

            try
            {
                reader = MembershipUsersGateway.Select(new MembershipUsersCriteria()
                {
                    UserID = userId,
                }, connection, transaction);

                var found = (reader.Read() ? reader.GetInt64(@"MembershipID") : -1L);

                return(found);
            }
            finally
            {
                if (reader != null)
                {
                    reader.Close();
                }
            }
        }