How to set the property SortOrder in GridEX Janus - C#

Question

I need to set the property SortOrder in the GridEx, and this property is only get.

What can I do?

the code:

private void M_Grid_ColumnHeaderClick(object sender, Janus.Windows.GridEX.ColumnActionEventArgs e)
{
    if (e.Column.DataMember == "Filed1")
    {
        var list = m_Grid.DataSource;

        if (e.Column.SortOrder == Janus.Windows.GridEX.SortOrder.Descending)
        {
            list = list.OrderBy(p => p.ParticipationDate).ToList();
            e.Column.SortOrder = Janus.Windows.GridEX.SortIndicator.Ascending;// it's not good
        }
        else
        {
            list = list.OrderByDescending(p => p.ParticipationDate).ToList();
            e.Column.SortOrder = Janus.Windows.GridEX.SortIndicator.Descending;// it's not good
        }
        m_Grid.DataSource = list;
    }
}

Why do you need perform this manually if you are working with Janus will be done by default, you can look at design time of a grid control and can define the sort defaults for each column and other many options.. — Oleg, Oct 06 '19 at 07:29
I know, but this is the grid now in the big project, and I can't change it on time... — Ayal, Oct 06 '19 at 07:33

Oleg · Answer 1 · 2019-10-06T07:59:46.890

0

Not recommended way:

private void M_Grid_ColumnHeaderClick(object sender, Janus.Windows.GridEX.ColumnActionEventArgs e)
{
    if (e.Column.DataMember == "Filed1")
    {
        var list = m_Grid.DataSource;

        if (e.Column.SortOrder == Janus.Windows.GridEX.SortOrder.Descending)
        {
            list = list.OrderBy(p => p.ParticipationDate).ToList();
          //  e.Column.SortOrder = Janus.Windows.GridEX.SortIndicator.Ascending;
        }
        else
        {
            list = list.OrderByDescending(p => p.ParticipationDate).ToList();
         //   e.Column.SortOrder = Janus.Windows.GridEX.SortIndicator.Descending;
        }
        m_Grid.DataSource = list;
        m_Grid.Refetch();
    }
}

Another approach working with sortkeys for example:

private void M_Grid_ColumnHeaderClick(object sender, Janus.Windows.GridEX.ColumnActionEventArgs e)
{
    if (e.Column.DataMember == "Filed1")
    {
         //Removing any sort key that may be present in the table
        m_Grid.RootTable.SortKeys.Clear(); //or can be removed only specific 
       // sortkey

        // get the column to be sorted
        column = e.Column;

        if (e.Column.SortOrder == Janus.Windows.GridEX.SortOrder.Descending)
        {
             sortKey = new GridEXSortKey(column, SortOrder.Ascending);
        }
        else
        {
          sortKey = new GridEXSortKey(column, SortOrder.Descending);
        }

       m_Grid.RootTable.SortKeys.Add(sortKey);
    }
}

edited Oct 06 '19 at 07:59

answered Oct 06 '19 at 07:38

Oleg

3,580
1
7
12

It's not good, becouse the property `SortOrder` is only `get`. – Ayal Oct 06 '19 at 07:46
Updated the code, if you make manually order by in list, no need it – Oleg Oct 06 '19 at 07:47
not work good. becouse the vale is date but is date in format string and that disrupts sorting... – Ayal Oct 06 '19 at 08:29
Do you have another idea?? – Ayal Oct 06 '19 at 08:29
You can format the date to YYYY/MM/DD and sort by string in linq – Oleg Oct 06 '19 at 08:40
I need format `dd/MM/yyyy` and this format not good in the sorting. So if you have another idea what can I do? – Ayal Oct 06 '19 at 09:00
list = list.OrderBy(p =>DateTime.Parse(p.ParticipationDate).ToString("yyyyMMdd ")).ToList(); – Oleg Oct 06 '19 at 09:37
or list.OrderBy(p =>DateTime.Parse(p.ParticipationDate)).ToList() – Oleg Oct 06 '19 at 09:43

Ayal · Answer 2 · 2019-10-06T11:37:05.970

After a lot of experimenting and being the right answer.

In case you want to sort a particular field by any other value and not by default Use the property: SortComparer and implement the Compare() function of the IComparer class

For example, what I did is:

On the load of the component write:

m_Grid.RootTable.Columns["Field1"].SortComparer = new Field1Sort();

The class to implement:

public class Field1Sort: IComparer
{
    public Field1Sort()
    {
    }

    public int Compare(object x, object y)
    {
        var xString = (string)x;
        var yString = (string)y;

        var date1 = xString.Substring(0, 10).ToDateTime();
        var date2 = yString.Substring(0, 10).ToDateTime();

        if (date1 < date2)
            return -1;
        if (date1 > date2)
            return 1;
        else
            return 0;
    }
}

How to set the property SortOrder in GridEX Janus - C#

2 Answers2

Linked