Compare current time with lambda expression in WPF

Question

I want to using lambda expression to compare current DateTime.Now with time retrieved from database (time).

I try this:

string time = DateTime.Now.Hour.ToString("00") + DateTime.Now.Minute.ToString("00") + DateTime.Now.Second.ToString("00");
TimeSpan _currentTime = TimeSpan.ParseExact(time, "HHmmss", CultureInfo.InvariantCulture);

IQueryable<user> Query = _context.user.Where(s => s.userShifts.Any(s2 => s2.DayOfWeekId == _todayNumber && _currentTime >= s2.TimeFrom && _currentTime <= s2.TimeTo));

I got the following error:

{"Input string was not in a correct format."}

What's the wrong !!

That code won't compile: the first statement has two errors, to start with. Please provide an *actual* [mcve]. — Jon Skeet, Apr 08 '17 at 15:14
why go through the trouble of parsing ? why not just do var _currentTIme= DateTime.Now.TimeOfDay — Danny D, Apr 08 '17 at 16:50
Note that given that your second line is where the exception was being thrown, you should have been able to tell that this has nothing to do with WPF or lambda expressions. Please really work on diagnostics before asking a question. — Jon Skeet, Apr 08 '17 at 19:20

score 1 · Accepted Answer · answered Apr 08 '17 at 16:58

1

Use TimeOfDay in place of parseExact

var _currentTime= DateTime.Now.TimeOfDay

answered Apr 08 '17 at 16:58

Danny D

828
1
9
20

Thanks Danny, This is the right way to do what I want. – Abdulsalam Elsharif Apr 08 '17 at 17:00

score 0 · Answer 2 · answered Apr 08 '17 at 16:49

0

Ok .. The right format is:

TimeSpan _currentTime = TimeSpan.ParseExact(time, "hh':'mm':'ss", null);

Hope this help.

answered Apr 08 '17 at 16:49

Abdulsalam Elsharif

4,773
7
32
66

Compare current time with lambda expression in WPF

2 Answers2