How to Use Dictionary to sort the list in asp.net web api

I have updated another sample code with column sort. please have a look and confirm

Hi Prasad 

Let me check you solution  and let you know 

Please take a look at the sample attached. I believe, its sorting as expected. you are expecting the sorting as below.

Sort by Publisher, Author last name, authorfirst name then title. as you are starting the sort with Publisher first, always the records will be displayed based on the Publisher. 

if you are satifisifed with this result, please do let me know the expected output.

did you try my first sample code where I have included the sorting on List?

Hi Prasad This is my table structure

I want to write the api method to return a sorted list of these by Publisher, Author last name, authorfirst name then title. And yesterday i cleared the error but still i didnt get the values in the sorted order

Please use the modified method as give me below and let me know if you are facing the issue

private T GetValueOrDefault(DataRow row, string columnName)
{
    if (!DBNull.Value.Equals(row[columnName]))
    {
        object value = row[columnName];
        return (T)Convert.ChangeType(value, typeof(T));
    }

    return default(T);
}

I would request you to share the sample data so that I can take a look. I would request you share your expected output as well.

Hi Prasath 

Still the order is not formed as per my expectation Please look below image

Hi Prasad 

Thanks for the solution currently i am getting one error .Please check below 

I have refactored the code as below

I simplified the null value checks by utilizing the GetValueOrDefault method and removed the redundant ToString() calls

public IEnumerable GetBook()
{
    ISqlDBHelper sqlDBHelper = new SqlDBHelper();
    DataTable dt = sqlDBHelper.ExecuteSelectCommand("uspBooklst", CommandType.StoredProcedure);

    List bklst = new List();

    foreach (DataRow row in dt.Rows)
    {
        BookViewModel bvm = new BookViewModel();

        bvm.UID = GetValueOrDefault(row, "UID");
        bvm.Publisher = GetValueOrDefault(row, "Publisher");
        bvm.AuthorFirstName = GetValueOrDefault(row, "AuthorFirstName");
        bvm.AuthorLastName = GetValueOrDefault(row, "AuthorLastName");
        bvm.Title = GetValueOrDefault(row, "Title");
        bvm.Price = GetValueOrDefault(row, "Price");

        bklst.Add(bvm);
    }

    bklst = bklst.OrderBy(b => b.Publisher)
                 .ThenBy(b => b.AuthorFirstName)
                 .ThenBy(b => b.AuthorLastName)
                 .ThenBy(b => b.Title)
                 .ThenBy(b => b.Price)
                 .ToList();

    return bklst;
}

private T GetValueOrDefault(DataRow row, string columnName)
{
    if (!DBNull.Value.Equals(row[columnName]))
    {
        return Convert.ChangeType(row[columnName], typeof(T));
    }

    return default(T);
}

In the refactored code:

• After populating the list with BookViewModel objects, I use the LINQ OrderBy and ThenBy methods to sort the list based on the specified properties in the desired order.
• The OrderBy method is used to sort the list by the Publisher property.
• The ThenBy method is used to perform subsequent sorting on the AuthorFirstName, AuthorLastName, Title, and Price properties.
• Finally, I convert the sorted sequence back to a list using the ToList method.
• The rest of the code remains the same as before

Please do let me know your thoughts.

I'm wondering the why you need to Dictionary for sorting? Please provide more details on this