/// <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(); } } }
/// <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(); } } }