Hide deleted values in UltraComboEditor inside UltraGrid in Edit mode

Talha Anwer posted over 4 years ago

I have following data in a lookup table.

ID	Category	Deleted
1	Electronics	False
2	Personal Care	True
3	Smartphones	False

I have an editable UltraGrid that allows users to select a category for each row, using a column having UltraComboEditor to display categories.

Users can only select categories that are not deleted i.e. Electronics and Smartphones. However, if the row already has a record that references deleted category (Personal care, Id=2), it should be added to the list of items in the UltraComboEditor

For all new rows, it UltraComboEditor should only contain non-deleted categories.

My Category column is similar to EmployeeID column in the following snapshot:

How can I accomplish that?

Thanks

- Talha Anwer

Top Replies

469350

Offline Mike Saltzman posted over 4 years ago in reply to Talha Anwer +1
So then what I would do is use UltraDropDown (instead of UltraComboEditor) and handle the InitializeRow event of the control. Handle the CellListDopDown...view reply »
80

Offline Talha Anwer posted over 4 years ago in reply to Teodosia Hristodorova +1 verified
I was able to use UltraComboEditor by using the DataFilter (implementing IEditorDataFilter). My Convert() method looks like this: public object Convert...view reply »

Parents

1560

Offline Teodosia Hristodorova posted over 4 years ago
Hello,

In order to make sure that I understand your requirement correctly I have several questions:

For already initialized records in the grid, the UltraComboEditor would have to show all items including the deleted if some of the records contain them, however, the user will not be able to select them?

When a new row is added to the grid at runtime the UltraComboEditor would have to display only values that have Deleted property equal to false?

Answering these questions is going to be highly appreciated.

Thank you for your cooperation.

Looking forward to hearing from you.

Sincerely,

Teodosia Hristodorova

Associate Software Developer
Cancel
Reply

Cancel

Reply

80

Offline Talha Anwer posted over 4 years ago in reply to Teodosia Hristodorova

I would like users to be able to keep/select deleted categories for existing rows, but once they have modified the existing record and selected a non-deleted category, they should not be able to go back to select the deleted category. For all new rows, user should not be able to selected a deleted category.
Cancel
Reply

Cancel

Children

80

Verified Answer
Offline Talha Anwer posted over 4 years ago in reply to Teodosia Hristodorova

I was able to use UltraComboEditor by using the DataFilter (implementing IEditorDataFilter). My Convert() method looks like this:

public object Convert(EditorDataFilterConvertArgs conversionArgs)

{

    if ((conversionArgs.Direction != ConversionDirection.EditorToDisplay) || conversionArgs.Value == null ||

        conversionArgs.Value == DBNull.Value)

    {

        return conversionArgs.Value;

    }

    string rawValue = conversionArgs.Value.ToString();

    if (string.IsNullOrWhiteSpace(rawValue) ||

        !_maskedCycleFieldEditor._unmaskedItems.TryGetValue(rawValue[0], out string itemtext))

    {

        return conversionArgs.Value;

    }

    // If raw value exists in the dictionary, we are dealing with an unmasked item

    conversionArgs.Handled = true;

    return itemtext;

}

I went for this because it looks simple, and we were already using UltraComboEditor. So we don't need to modify a lot of code that depended on UltraComboEditor.

I appreciate your help and suggestions on this issue
Cancel
Reply

Reject Answer

Cancel
1560

Offline Teodosia Hristodorova posted over 4 years ago in reply to Talha Anwer

Hello,

It is possible to achieve a required behavior using the UltraDropDown's InitializeRow, BeforeDropDown, and AfterCloseUp events. This will eliminate the need to create a new control derived from UltraDropDown.

The InitializeRow gets fired for every row in the UltraDropDown and there you could hide the row depending on its Deleted value.

The BeforeDropDown gets fired right before the drop down is about to drop down and there you could get the value in the grid's cell and make this row in the drop-down visible.

The AfterCloseUp gets fired after the drop-down has closed up and there could hide the deleted row from the drop-down if you keep it in a global variable.

Additionally, the UltraDropDown could be styled to look exactly as UltraComboEditor using the InitializeLayout where could be hidden the ID and Deleted columns, all column headers and set the width of the Category column to the value of the grid's cell, and set the border of the UltraDropDown's rows and cells to Transparent.

I have modified the previous sample in order to demonstrate this behavior and it could be found attached below. Please test it on your side and let me know if I may be of any further assistance.

Sincerely,

Teodosia Hristodorova

Associate Software Developer

3513.UltraGrid_UltraDropDown.zip
Cancel
Reply

Cancel
80

Offline Talha Anwer posted over 4 years ago in reply to Mike Saltzman

Yes, this approach actually works. However, I am wondering if I could write a control, maybe derived from UltraDropDown and use the control's events to achieve the same behavior. Without having to bind to UltraGrid events.

Thanks
Cancel
Reply

Cancel
469350

Offline Mike Saltzman posted over 4 years ago in reply to Talha Anwer

So then what I would do is use UltraDropDown (instead of UltraComboEditor) and handle the InitializeRow event of the control.

Handle the CellListDopDown event of the grid. Loop through the rows of the UltraDropDown and set the Hidden property on each row. If the row is Deleted and it's value does not match the current value of the cell, hide it.

But you will need to store the value of the current cell when the user enters that cell in case they drop down more than once. You could use AfterCellActivate for that.
Cancel
Reply

Cancel
80

Offline Talha Anwer posted over 4 years ago in reply to Mike Saltzman

I don't want to force users to modify records that already reference deleted records. They should be able to select all the active records, plus one deleted record that is currently being referenced by the row.

In a scenario where we have two active categories (say IDs 1 and 2) and two deleted categories (IDs 3 and 4). And we have two rows, first referencing deleted category 3 and the other referencing deleted category 4. So for first row, I would like to list categories 1, 2 and 3. For second row, I'd like users to be able to select from categories 1, 2, and 4.

Thanks
Cancel
Reply

Cancel