StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » SF Messaging Editor - Category (How to?)

SF Messaging Editor - Category (How to?)

Edhy Rijo — Fri, 14 Aug 2009 17:31:29 GMT

Hi Trent,

I am working on a form in which I have the need to create a feature to assign a record to a "Category" in the same easy and elegant way implemented in the SF Messaging Editor (see image attached).

I don't want to create another lookup table to handle the Categories, so would you mind explaining how you guys did it in the Messaging Editor?

Thanks!

RE: SF Messaging Editor - Category (How to?)

Trent L. Taylor — Fri, 14 Aug 2009 17:31:29 GMT

Cool :cool:

RE: SF Messaging Editor - Category (How to?)

Edhy Rijo — Fri, 14 Aug 2009 16:34:02 GMT

Thanks again Trent, that was the problem. Still learning new stuff every day!

RE: SF Messaging Editor - Category (How to?)

Trent L. Taylor — Fri, 14 Aug 2009 13:35:48 GMT

Change the binding property to Text instead of the SelectedValue. Bet that is your problem ;)

RE: SF Messaging Editor - Category (How to?)

Edhy Rijo — Fri, 14 Aug 2009 12:29:02 GMT

Here are some screenshots.

RE: SF Messaging Editor - Category (How to?)

Edhy Rijo — Fri, 14 Aug 2009 12:22:01 GMT

I have setup my combobox and get the data OK, but if I type in the Category instead of selecting from the combobox it does not persist and is never saved. In other words, I cannot enter any value in the combobox.

What am I missing?

RE: SF Messaging Editor - Category (How to?)

Trent L. Taylor — Fri, 14 Aug 2009 10:52:37 GMT

No problem :)

RE: SF Messaging Editor - Category (How to?)

Edhy Rijo — Fri, 14 Aug 2009 10:52:11 GMT

Understood! thanks again :P

RE: SF Messaging Editor - Category (How to?)

Trent L. Taylor — Fri, 14 Aug 2009 10:46:19 GMT

[quote]One more question, in the Tree shortcut menu there is an option to "Rename" the categories, I guess in your case you will just filter out the BO for this category and rename them all in a one pass, right? or is there another more efficient trick?[/quote]

Actually I created a sproc to update all of the categories at once then I reload the BO. That way there are fewer changes and queries going back and forth. I did it as you had mentioned originally, but it was so slow the larger the project became that I did it in a single query, requeried, then set the index back on the changed item.

RE: SF Messaging Editor - Category (How to?)

Edhy Rijo — Fri, 14 Aug 2009 10:39:59 GMT

Great, it is in fact simple.

One more question, in the Tree shortcut menu there is an option to "Rename" the categories, I guess in your case you will just filter out the BO for this category and rename them all in a one pass, right? or is there another more efficient trick?

RE: SF Messaging Editor - Category (How to?)

Trent L. Taylor — Fri, 14 Aug 2009 10:35:09 GMT

Sure. It really isn't that complicated. It is just another VarChar field in the same table. Then the combo populates with the Distinct values for the project. This way it doesn't "bleed" into other projects where the category is not defined. If you prefer to show all distinct categories across all projects (using this example) then you would not add a WHERE to filter out the categories for the project.

So generally I will create a FillWithDistinctCategories method in the BO that has the category field and then populate the combo from there.

Let me know if you need more explanation. :)