Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculating which recurring events happen in a date rang
Message
From
18/06/2010 17:46:41
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
18/06/2010 09:42:33
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
General information
Forum:
ASP.NET
Category:
LINQ
Miscellaneous
Thread ID:
01469538
Message ID:
01469686
Views:
35
>>>I was going to do some ugly processing with loops, but I figured maybe Linq could help me out.
>>>
>>>RecurringEvents
>>>ID (PK)
>>>StartDate (datetime)
>>>RecurrenceDays (int)
>>>
>>>How can I calculate which of these recurring events happen within a specified date range. Linq's gotta have some sexy method that will do this easily...
>>
>>Linq would surely have nice ways to have it but your layout seems very inadequate to me. For example what does RecurrenceDays stand for? Assuming it is the days that the event would be available continously from start:
>>
>>
var evList = from e in events
>>  where e.StartDate <= end && e.StartDate.AddDays( e.RecurrenceDays ) >= start
>>  select e;
>>
>>In method syntax:
>>
>>
var evList = events.Where( e => e.StartDate <= end && e.StartDate.AddDays( e.RecurrenceDays ) >= start);
>>
>>PS: You could also create extension methods in your say "ScheduleExtensions" namespace and simply use those methods for selection. It then might look like (assuming you created WithIn extension method for RecurringEvent that takes start, end parameters):
>>
>>
var evList = events.Where( e => e.WithIn( start, end ));
>>
>>Is there a setting somewhere to say that this is C# code and not VFP? Maybe class attribute or another tag?
>>Cetin
>
>I'm open to a new layout, if you have a suggestion.

iCalendar is the typical layout standard. I have done partial implementation in VFP and sooner or later I will need an enhanced version in C# myself:) One caveat I have seen is that also it is called a standard, it doesn't seem to be a standard and say outlook may return "unrecognized calendar format" to an icalendar format that is created by outlook:).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform