Getting group id of a group?

[RickSilver]

I've created a group called "customers". I have code working that sets new registrations to this group by assigning the customer id of 8. I know it's 8 because I can 'view source' the admin groups page. But I don't want that "8" hard-coded. How can I get the group id of a group, given its name?

Thanks
Rick

[RickSilver]

I tried this:

GroupCollection storeGroups = GroupDataSource.LoadForStore();
for (int i=0; i<storeGroups.Tables[0].Rows.Count; i++)
{

}

and got this error:
error CS0117: 'CommerceBuilder.Users.GroupCollection' does not contain a definition for 'Tables'

[AbleMods]

All data in AC7 is strongly-typed, so just snag into a data class (all are defined by the API) and you're all set.

Code: Select all

Group _Group = GroupDataSource.LoadforCriteria("Name='<groupname>' ");
int _GroupId = _Group.GroupId;

[mazhar]

I tried this:

GroupCollection storeGroups = GroupDataSource.LoadForStore();
for (int i=0; i<storeGroups.Tables[0].Rows.Count; i++)
{

}

and got this error:
error CS0117: 'CommerceBuilder.Users.GroupCollection' does not contain a definition for 'Tables'

The correct fix for your code would be

Code: Select all

GroupCollection storeGroups = GroupDataSource.LoadForStore();
    	for (int i=0; i<storeGroups.Count; i++)
    	{
    		Group group = storeGroups[i];
                int groupId = groupd.GroupId;
    	}

[RickSilver]

Thanks for the solutions!

[RickSilver]

AbleMods, that didn't work.

Error: 'CommerceBuilder.Users.GroupDataSource' does not contain a definition for 'LoadforCriteria'

[AbleMods]

AbleMods, that didn't work.

Error: 'CommerceBuilder.Users.GroupDataSource' does not contain a definition for 'LoadforCriteria'

Whoops I forgot to capitalize the "f" in "for" ... should be ".LoadForCriteria"

My Bad

[AbleMods]

If you haven't yet, you should get the free copy of Visual Studio 2008 Express from Microsoft. The Intellisense feature will show you all the options and parameters available for every data class. It's really helpful in seeing what's available on each object.

[RickSilver]

AbleMods, I'm afraid that doesn't work either:

Group _Group = GroupDataSource.LoadForCriteria("Name='Customer'");

Cannot implicitly convert type 'CommerceBuilder.Users.GroupCollection' to 'CommerceBuilder.Users.Group'

But this did work:

Group _Group = GroupDataSource.LoadForCriteria("Name='Customer'")[0];

[AbleMods]

Sigh I'm having one of those weeks, sorry.

LoadForCriteria returns a collection of groups, not a single group. Thus the brackets narrow it down to the first object in the collection.

That's what I get for leaving my snug and cozy world of VB code

[nickc]

My 2 cents:
- an explicit reference to an element for a list of unknown size (or possible null value) is dangerous - get the object, test for existence, then use it.
- Avoid database calls when possible. Able pre-populates groups in the Token object, so you don't need a database call every time you want a reference to the Customers group

Code: Select all

            CommerceBuilder.Users.Group group = Token.Instance.Store.Groups.Find(delegate(CommerceBuilder.Users.Group t) { return t.Name == "Customer"; });
            if (group != null)
            {
                // do stuff here
            }

[RickSilver]

Thanks! Good advice.