LINQ OrderByDescdending for date field is not working razor pages

Question

LINQ OrderByDescdending for date field is not working razor pages

Blooming Developer 281

Hi,

i want to display records based on booked dates. For that i used OrderByDescending in LINQ query, but it is not sorting based on date field.

ManageBooking = await _context.ManageBooking.Where(e => (e.BookingDate >= DateTime.Today && e.EmployeeNo == EmployeeNumber)).ToListAsync();
                ManageBooking = ManageBooking.OrderByDescending(e => e.BookingDate).ToList();

Any help would be appreciated.

Thanks,

Teena John

Viorel 122.6K Reputation points

2023-02-03T08:05:03.7666667+00:00

Did you check the value of ManageBooking using the Debugger? Maybe it is correct, but is not displayed correctly in your Web page.
Blooming Developer 281 Reputation points

2023-02-05T21:35:26.4266667+00:00

Hi,

Yes the query is correct, but not displaying in the page correctly. How to display this correctly?
Anonymous

2023-02-06T02:44:13.5266667+00:00

Yes the query is correct, but not displaying in the page correctly. How to display this correctly?

How do you display the query result in the page? Redirect to current page or use JQuery Ajax? Check this part of code, before refresh the page, make sure you're using sorted data.
Blooming Developer 281 Reputation points

2023-02-06T05:52:10.4833333+00:00

Hi @Anonymous ,

Redirect to current page. Even if i give orderby clause in my foreach loop , its not showing.

Thanks,

Teena John
Anonymous

2023-02-06T07:33:33.9433333+00:00

Redirect to current page. Even if i give orderby clause in my foreach loop , its not showing.

It's so weird, try to set a break point in the foreach loop, before loop the data, whether the data is sorted by BookingDate? Can you share the relates razor page code(.cshtml and .cshtml.cs file) or create a minimal, complete sample to reproduce the problem?

Blooming Developer 281

Hi @Anonymous ,

Here is my code

index.cshtml

<table class="table table-hover" id="data" style="width:100%">
                    <thead class="bg-gradient-secondary">
                        <tr>
                            <th>
                                @Html.DisplayNameFor(model => model.ManageBooking[0].ActivityType)
                            </th>
                            <th>
                                @Html.DisplayNameFor(model => model.ManageBooking[0].ActivityName)
                            </th>
                            <th>
                                @Html.DisplayNameFor(model => model.ManageBooking[0].BookingDate)
                            </th>
                            <th>
                                @Html.DisplayNameFor(model => model.ManageBooking[0].Duration)
                            </th>
                            <th>                                
                                @Html.DisplayNameFor(model => model.ManageBooking[0].PreferredTimeslot)
                            </th>
                            @*<th>
                                @Html.DisplayNameFor(model => model.ManageBooking[0].EmployeeNo)
                            </th>
                            <th>
                                @Html.DisplayNameFor(model => model.ManageBooking[0].EmployeeName)
                            </th>
                            <th>
                                @Html.DisplayNameFor(model => model.ManageBooking[0].EmployeeEmailAddress)
                            </th>
                            <th>
                                @Html.DisplayNameFor(model => model.ManageBooking[0].EmployeePhoneNumber)
                            </th>*@
                            <th>
                                @Html.DisplayNameFor(model => model.ManageBooking[0].SupervisorName)
                            </th>
                            @*<th>
                                @Html.DisplayNameFor(model => model.ManageBooking[0].SupervisorEmailAddress)
                            </th>*@
                            @*<th>
                                @Html.DisplayNameFor(model => model.ManageBooking[0].LastModifiedTimeStamp)
                            </th>*@
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody>
                @foreach (var item in Model.ManageBooking.OrderByDescending(e=>e.BookingDate)) {
                        <tr>
                            <td>
                                @Html.DisplayFor(modelItem => item.ActivityType)
                            </td>
                            <td>
                                @Html.DisplayFor(modelItem => item.ActivityName)
                            </td>
                            <td>
                                @Html.DisplayFor(modelItem => item.BookingDate)
                            </td>
                            <td>
                                @Html.DisplayFor(modelItem => item.Duration)
                            </td>
                            <td>
                                    @if(item.PreferredTimeslot == null)
                                    {
                                        @Html.DisplayFor(modelItem => item.PreferredHalfAnHourTimeslot)
                                    }
                                    else{
                                        @Html.DisplayFor(modelItem => item.PreferredTimeslot)
                                    }
                            </td>
                            @*<td>
                                @Html.DisplayFor(modelItem => item.EmployeeNo)
                            </td>
                            <td>
                                @Html.DisplayFor(modelItem => item.EmployeeName)
                            </td>
                            <td>
                                @Html.DisplayFor(modelItem => item.EmployeeEmailAddress)
                            </td>
                            <td>
                                @Html.DisplayFor(modelItem => item.EmployeePhoneNumber)
                            </td>*@
                            <td>
                                @Html.DisplayFor(modelItem => item.SupervisorName)
                            </td>
                            @*<td>
                                @Html.DisplayFor(modelItem => item.SupervisorEmailAddress)
                            </td>*@
                            @*<td>
                                @Html.DisplayFor(modelItem => item.LastModifiedTimeStamp)
                            </td>*@
                            <td>
                                    @*<a asp-page="./Edit" class="btn btn-primary" asp-route-id="@item.id" disabled>
                                        <i class="fas fa-pencil-alt"></i> Edit
                                    </a>*@
                                    <a asp-page="./Delete" class="btn btn-danger" asp-route-id="@item.id">
                                        <i class="fas fa-trash"></i> Cancel
                                    </a>
                            </td>
                        </tr>
                }
                    </tbody>

Index.cshtml.cs

 public async Task OnGetAsync()
        {
            EmployeeNumber = HttpContext.Session.GetString("EmployeeNumber");
            if (_context.ManageBooking != null)
            {
                ManageBooking = await _context.ManageBooking.Where(e => (e.BookingDate >= DateTime.Today && e.EmployeeNo == EmployeeNumber)).AsNoTracking().ToListAsync();
                //ManageBooking = ManageBooking.OrderByDescending(e => e.BookingDate).ToList();
            }
        }

Anonymous

2023-02-07T09:28:59.7+00:00

Hi @Blooming Developer

Your shared code is correct.

According to your code I create a razor page and define the BookingDate as DateTime type, the OrderByDescending works well, the result as below:

You can try to restart the application or create a new page to check it. If still not working, might be the issue relates other code, such as JS.

3 answers

Your answer

Viorel 122.6K Reputation points

2023-02-03T08:05:03.7666667+00:00

Did you check the value of ManageBooking using the Debugger? Maybe it is correct, but is not displayed correctly in your Web page.
Blooming Developer 281 Reputation points

2023-02-05T21:35:26.4266667+00:00

Hi,

Yes the query is correct, but not displaying in the page correctly. How to display this correctly?
Anonymous

2023-02-06T02:44:13.5266667+00:00

Yes the query is correct, but not displaying in the page correctly. How to display this correctly?

How do you display the query result in the page? Redirect to current page or use JQuery Ajax? Check this part of code, before refresh the page, make sure you're using sorted data.
Blooming Developer 281 Reputation points

2023-02-06T05:52:10.4833333+00:00

Hi @Anonymous ,

Redirect to current page. Even if i give orderby clause in my foreach loop , its not showing.

Thanks,

Teena John
Anonymous

2023-02-06T07:33:33.9433333+00:00

Redirect to current page. Even if i give orderby clause in my foreach loop , its not showing.

It's so weird, try to set a break point in the foreach loop, before loop the data, whether the data is sorted by BookingDate? Can you share the relates razor page code(.cshtml and .cshtml.cs file) or create a minimal, complete sample to reproduce the problem?
Anonymous

2023-02-07T09:28:59.7+00:00

Hi @Blooming Developer

Your shared code is correct.

According to your code I create a razor page and define the BookingDate as DateTime type, the OrderByDescending works well, the result as below:

You can try to restart the application or create a new page to check it. If still not working, might be the issue relates other code, such as JS.

Answer 1

Bruce (SqlWork.com) 78,006 Volunteer Moderator

as you don't show any code, hard to guess what you did wrong.

Answer 2

DOTNETVIC 0

Assuming the list is indeed passed to your view correctly, you can order it on the view.

For example:

@model List<ManageBooking>

foreach(var item in Model.OrderByDescending(e => e.BookingDate))
{     
}

if this works, and this is used by one application only then just remove the order by statement (OrderByDescending(e => e.BookingDate)) from your repo and just order it in your views.

Blooming Developer 281 Reputation points

2023-02-06T06:54:01.31+00:00
Hi @DOTNETVIC,

I did this already, still its showing the same way, what i understood is its dispalying the list based on ActivityType.

@foreach (var item in Model.ManageBooking.OrderByDescending(e=>e.BookingDate)) {}

ManageBooking = await _context.ManageBooking.Where(e => (e.BookingDate >= DateTime.Today && e.EmployeeNo == EmployeeNumber)).AsNoTracking().ToListAsync();

Thanks,

Teena John

Answer 3

Naimish Makwana 175

Hello

Try below code.

ManageBooking = await _context.ManageBooking
    .Where(e => (e.BookingDate >= DateTime.Today && e.EmployeeNo == EmployeeNumber))
    .OrderByDescending(e => e.BookingDate)
    .ToListAsync();

Thanks

Naimish Makwana

Share via

LINQ OrderByDescdending for date field is not working razor pages

3 answers

Your answer