Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Bronze Super Contributor
Posts: 141
Registered: ‎02-22-2010

Help Needed For New Column in Association Grid SLX web 7.5.2 Grid

 

I need help urgently

 

 

I have added new column in association table called “AssociationSource”. I want to show this column in the grid. I have added the data bound column to the Association.ascx page.

 

 

But I am confused how can we add a new column to the Association Grid Data source.

 

 

Basically data source is taking a from business rule.

 

The below is the  business rule of the association data source(I have renamed it)

 

public static IList<AccountAssociation> GetAccountAssociations1(IAccount account)

    {

        List<AccountAssociation> list = new List<AccountAssociation>();

        using (ISession session = new SessionScopeWrapper())

        {

            string queryString = "from Association assoc where (assoc.FromId = :AccountId)";

            IQuery query = session.CreateQuery(queryString);

            query.SetAnsiString("AccountId", account.Id.ToString());

            foreach (IAssociation association in query.List<IAssociation>())

            {

                AccountAssociation item = new AccountAssociation(association, account, AssociationDirection.adFoward);

               

                if (item.Account != null)

                {

                    list.Add(item);

                }

            }

            queryString = "from Association assoc where (assoc.ToId = :AccountId)";

            query = session.CreateQuery(queryString);

            query.SetAnsiString("AccountId", account.Id.ToString());

            foreach (IAssociation association3 in query.List<IAssociation>())

            {

                AccountAssociation association4 = new AccountAssociation(association3, account, AssociationDirection.adBackWard);

                if (association4.Account != null)

                {

                    list.Add(association4);

                }

            }

        }

        return list;

    }

 

 

 

I have pasted it in the  assocaiton.ascx.cs page and renamed it and assigned it like below in loadgrid() method

 

 

string accountId = EntityService.EntityID.ToString();

        IAccount account = EntityFactory.GetRepository<IAccount>().FindFirstByProperty("Id", accountId);

        //IList<AccountAssociation> accountAssocList = Sage.SalesLogix.Association.AssociationBusinessRules.GetAccountAssociations(account);

 

        IList<AccountAssociation> accountAssocList = GetAccountAssociations1(account);

 

 

 

 

        AccountAssociations_Grid.DataSource = accountAssocList;

        AccountAssociations_Grid.DataBind();

 

 

 

 

 

It is working fine. But I am not getting how can we add a new column to the exiting method(business rule method). Could any one please help.

 

 

It is really important I am struggling with this from last three days

 

 

 

 

Jack