CODEWITHSUNDEEP
c#entity-frameworklinq
dotnetcoder
dotnetcoder

Reputation: 51

how to write linq query with where clause to get records between 9 am to 5 pm

how to write a linq query with to get records between 9 am 5 pm only. the records beyond that should be discarded.

timestamp datatype

enter image description here

code

var items = Pirs.Where(a => !a.dataFrame.EndsWith("AAAAAAAAAAA=") && (fromDate == null || fromDate.Value.Date <= TimeZoneInfo.ConvertTimeFromUtc(Convert.ToDateTime(a.timestamp), TimeZoneInfo.FindSystemTimeZoneById("India Standard Time")).Date) && (toDate == null || toDate.Value.Date >= TimeZoneInfo.ConvertTimeFromUtc(Convert.ToDateTime(a.timestamp), TimeZoneInfo.FindSystemTimeZoneById("India Standard Time")).Date))
                     .GroupBy(a => a.dataFrame.Substring(a.dataFrame.Length - 12))
                     .Select(g => g.First()).OrderBy(a => a.timestamp);

Upvotes: 0

Views: 452

Answers (2)

Harisyam M
Harisyam M

Reputation: 427

Do the following in where condition

TimeSpan span = TimeSpan.Parse("09:00:00");
TimeSpan espan = TimeSpan.Parse("17:00:00");

Pirs.Where(a => a.timestamp >= startDate && a.timestamp <= toDate && a.timestamp.TimeOfDay >= span && a.timestamp.TimeOfDay <= espan);

Upvotes: 4

MadddinTribleD
MadddinTribleD

Reputation: 395

Pirs.Where(a.timestamp.TimeOfDay > new TimeStamp(9, 0, 0) &&   //all times after 9am
           a.timestamp.TimeOfDay < new TimeStamp(17, 0, 0) &&  //all times before 5pm
           a.timestamp.Date > fromDate &&                      //all dates after fromData
           a.timestamp.Date < toDate)                          //all dates before toDate

Upvotes: 5

Related Questions