Resources to learn how to develop a schedule/appointment system in C#? [closed]?

Up vote 4 down vote favorite 1 share g+ share fb share tw.

Not a job/task schedule, but actual appointment system people can use to create recurring events (like a calendar). It should support many recurrence patterns such as 1st Monday of each month, every Tues/Thurs, a specific date, etc. I've been trying to review RFC 2445, but I'm finding it difficult to absorb, there's A LOT of content in it. I've looked through the sysschedules table from SQL Server, but it is more along the lines of a job schedule (which I'm sure shares some many similarities, but is still melting my brain at this point).

I'll be attempting to build one using ASP. NET MVC, C#, on SQL Server 2008R2. The table schema, how to query for specified dates, etc... still elude me at this time.

Are there resources out there (website, eBook, printed book, etc...) to help programmers learn how to program a schedule/calendar system (free or paid, I don't mind). C# asp. Net-mvc architecture ical link|improve this question asked Feb 28 at 3:46Chad2,21111548 91% accept rate.

That's an awfully big domain. – StriplingWarrior Feb 28 at 3:50 @StriplingWarrior: it seems from the question is that he is struggling with where to start. Where would you start?

The answer to this is probably what he is struggling with right now. – zespri Feb 28 at 4:33 @StriplingWarrior - Primarily, it's the recurrence "stuff". I don't want to have multiple entries in my DB for one event (they don't need to be editable as individual occurrences).

The event should follow a recurrence pattern, with a wide range or possibilities (1st Mon of the month, every 2 weeks on Tues/Thurs, etc...). And then... how do I query for "events" occurring on specific days? – Chad Feb 28 at 5:25.

In my opinion for the task you about to do. It important to think how different your system will be from the ones that have been build beforeI would recommend looking at some of the open source application some are do great job. Here are some thinks that you may find useful codeproject.com/Articles/148500/Event-Ca... quartznet.sourceforge.net/index.html codeproject.com/Articles/14107/Using-Day....

When I was working through the sysschedules table, I put together my own schema based off the Freq_type, intervals, etc... that I thought would fit into my design. Then I got to thinking, how would I find all the "events" happening on this Tuesday? Wouldn't be hard for events that fall on every Tues, but what about relative ones, such as recurring every other week on Tues?

How does the event know if it's week 1, or week 2? Repeat for days, months, etc... and my brain starts melting and I stop, play some XBOX for the rest of the night and try again the next day. ;) – Chad Feb 28 at 5:12 yeah you need a good schema and it should work – COLD TOLD Feb 28 at 5:15 If I don't need to individual occurrences of an "event" editable, would the schema on the sysschedules link I posted work?

I have Freq_Type, Interval, RelativeFactor, etc... it seemed to be working well, until I tried to imagine how I would query for events which recur with a relative factor (like once every other week). How do I calculate if it's the "on or off" week for the recurring event? – Chad Feb 28 at 5:30 I think it would work as a partial table design but I think you want to make more advanced I think you need some relation tables like where dates are related to event ids and week ids – COLD TOLD Feb 28 at 5:36.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.