Example #1
0
        public void Get(int contactId)
        {
            SqlStoredProcedureAccessor sp = new SqlStoredProcedureAccessor("net_businessEntity_contact_get_batch");

            sp.Parameters.Add("@contactId", SqlDbType.BigInt);
            sp.Parameters.SetLong("@contactId", contactId);

            SqlDataReaderAccessor reader     = null;
            ArrayList             addressIDs = new ArrayList();

            try
            {
                //
                // net_businessEntity_contact_get_batch will return the objects contained in a business in the following order:
                //
                //	- descriptions
                //	- phones
                //	- emails
                //  - addresses
                reader = sp.ExecuteReader();

                //
                // Read the descriptions
                //
                Descriptions.Read(reader);

                //
                // Read the phones
                //
                if (true == reader.NextResult())
                {
                    Phones.Read(reader);
                }

                //
                // Read the emails
                //
                if (true == reader.NextResult())
                {
                    Emails.Read(reader);
                }

                //
                // Read the addresses
                //
                if (true == reader.NextResult())
                {
                    addressIDs = Addresses.Read(reader);
                }
            }
            finally
            {
                if (reader != null)
                {
                    reader.Close();
                }
            }

            //
            // These calls will make separate sproc calls, so we have to close our reader first.
            //
            Addresses.Populate(addressIDs);

#if never
            //
            // Call get method on sub-objects personName and UseType
            // should have been populate by contacts.get() method;
            //
            Descriptions.Get(contactId, EntityType.Contact);
            Phones.Get(contactId);
            Emails.Get(contactId);
            Addresses.Get(contactId);
#endif
        }