How to fetch list by am and pm?

Question

0.00/5 (No votes)

See more:

Hii,

I have a customer list which shows like
A-Customer ----- 10:00 AM ----- Branch1
B-Customer ----- 1:00 PM ------ Branch1
c-Customer ----- 5:00 PM ------ Branch1
D-Customer ----- 7:00 PM ------ Branch1
E-Customer ----- 12:00 PM ------ Branch1

here my problem is how to set 12:00 PM first in PM list and then all PM list will be in show in ascending order.

What I have tried:

@foreach (var item in Model.OrderBy(x => x.AMPM).ThenBy(x => x.hour).ThenBy(x => x.minute))
{
<tr @Html.Raw(Model.IndexOf(item) == 0 ? "style=\"background-color:lightblue;\"" : "")>

@item.FirstName @item.BookingTime @item.EmployeeName }

Posted 3-Apr-18 23:59pm

Member 13254700

Updated 4-Apr-18 0:31am

Add a Solution

Comments

F-ES Sitecore 4-Apr-18 6:22am

Without knowing the data structure and types involved it is impossible to say. If you are storing the data correctly in the correct date types then it could be a case of saying where the time\hour is >= 12 then order by that date. If you are storing your dates as text then it all gets much more complicated, which is why you shouldn't.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

W∴ Balboos, *GHB* · Accepted Answer · 2018-04-04T00:33:00

Make your life easy: reconfigure your data into 24hour time - then sorting by time is very easy: 0:00 through 23:59.

If that is impossible, then you need to have a multiple step set of conditionals in your sort where you look for 12:nn and set its position separately compared to all of the other values.

something like (oversimplified time, psuedo-code):
// Separate out morning times

if( (hour<12 and daytime='AM') or (hour==12 and daytime='PM) )
  SortByHour(); //  since your 12 is at the end 
                //  of this time block
else
  HandleTheOthers();

But I cannot overemphasize that converting to 24 hour time is the way to go!