Get overlapping time range in linq C#

Question

0.00/5 (No votes)

See more:

I have been doing some overlapping ranges test and have successfully concluded the overlapping date ranges scenario, But on the other hand I have to check for the overlapping time ranges, and I am unable to perform that. I have a scenario as below,

I have a range of 8am to 5pm and second range of 8 pm to 9am

I have tried like 3

C#

bool overlap = a.start < b.end && b.start < a.end;

And the expected results are true as 8am overlapps in the 8pm to 9am range, but because of the date part associated, it causing the trouble.

Any ideas or guide to solve this?

What I have tried:

C#

bool overlap = a.start < b.end && b.start < a.end;

Posted 25-Oct-16 21:48pm

VICK

Updated 3-Nov-16 2:36am

Add a Solution

3 solutions

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)

#realJSOP · Answer 1 · 2016-10-25T23:56:00

Solution 1

Try this:

C#

bool overlap = a.start.TimeOfDay < b.end.TimeOfDay && b.start.TimeOfDay < a.end.TimeOfDay;

Posted 25-Oct-16 23:56pm

#realJSOP

Comments

VICK 3-Nov-16 6:55am

Posted solution only works when the time range also includes the date part as well. Or the range is linear i.e. not the cross day.

johannesnestler · Answer 2 · 2016-10-26T00:04:00

Solution 2

I asume a.start and a.end are DateTime/DateTimeOffset instances.
Use the a.start.TimeOfDay property from your DateTimes to get an TimeSpan from the dates (to ignore the date part in the calculation)

like this:

C#

bool overlap = a.start.TimeOfDay < b.end.TimeOfDay  && b.start.TimeOfDay  < a.end.TimeOfDay;

or just store the times in the first place e.g like this then your comparison would also work

C#

DateTime myTime = default(DateTime).Add(myDateTime.TimeOfDay);

Posted 26-Oct-16 0:04am

johannesnestler

Comments

VICK 3-Nov-16 6:55am

Posted solution only works when the time range also includes the date part as well. Or the range is linear i.e. not the cross day.

johannesnestler 3-Nov-16 7:56am

I don't get what you are trying to tell... we compare times only here - what you mean with "date part". You asked how to check time-overlaps...

VICK 3-Nov-16 8:37am

Please have a look at my solution posted, In which I have tried to explain the exact issue I was facing and the solution I made to it.

**VICK** · Answer 3 · 2016-11-03T02:36:00

Suppose we Have a date range a which start and end time are as below

C#

a.start = '1900-01-01 08:00:00.000'; i.e 8am
a.end = '1900-01-01 17:00:00.000'; i.e. 5pm

and we want to check it either it overlaps with the existing ranges or not.
suppose one of the previous range is b which have start and end time like below,

C#

b.start = '1900-01-01 23:00:00.000'; i.e 11pm
b.end = '1900-01-01 09:00:00.000'; i.e. 9am

so b has a overlapping period of 8am to 9am with a, as the time slots are cross-day so I find the overlapping like below.

C#

bool isOverLapping = false;
a = FirstRange;

double basehours = (a.end - a.start).TotalHours;

if (basehours <= 0)
{
    basehours = basehours + 24;
}


foreach(var b in previousRanges)
{
 	double alpha1 = (b.start - a.start).TotalHours;

	if (alpha1 <= 0)
	{
	  alpha1 = alpha1 + 24;
	}

	double alpha2 = (b.end - a.start).TotalHours;

	if (alpha2 <= 0)
	{
	  alpha2 = alpha2 + 24;
	}

	if (basehours <= alpha1 && basehours <= alpha2)
	{
	  isOverLapping = false;
	}
	else
	{
	  isOverLapping = true;	
	}
}

I hope it will help someone who faces the issue like i did.