Codejock Developer Community : Copy to Multiple Schedules is Wasteful http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 13 May 2026 09:04:12 +0000 Thu, 21 Sep 2006 08:24:52 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=5107 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Copy to Multiple Schedules is Wasteful : Hello Charlie,Thanks, your idea...]]> http://forum.codejock.com/forum_posts.asp?TID=5107&PID=15962&title=copy-to-multiple-schedules-is-wasteful#15962 Author: sserge
Subject: 5107
Posted: 21 September 2006 at 8:24am

Hello Charlie,

Thanks, your idea is clear enough. We also thought about this approach when created multischedules functionality (as well as some other nice ideas )
But implementation of this will add redundant complexity to data structure, to data provider, and to the control. So, for the beginning we decided not to implement this feature.

Below are a few notes and suggestions which may help you to choose a way of resolving this problem. Calendar have some features to avoid copying of events.
NOTE:
1) Each calendar resource can display more than one schedule ID.
2) For shared events you can use some special ScheduleID.
3) There is a PrePopulate notification where you can filter calendar events before displaying.
 
Implementation:

1. Virtual common schedule.
Example: PersonalScheduleMike (ID 1), PersonalScheduleJohn (ID 2), CommonScheduleMikeJohn (ID 3)
a) You create a single event with ScheduleID = 3
b) You setup Calendar to show 2 resoruces: Mike (ID 1 and 3), John (ID 2 and 3)

This approach has only 1 disadvantage -- you have to create a lot of CommonSchedules when there are a lot of people. However, each such record takes a very small amount of storage.

2. Shared events know their Schedules.
a) For shared events set ScheduleID = -1 (some default shared ID) and use CustomProperties collection to store ScheduleIDs of peoples who participate in this event.
b) Such shared events will be populated for all users, and you should use PrePopulate notification to filter events. Check whether the ViewGroup's first ScheduleID presents in CustomProperties ScheduleIDs set. If not - remove such event from the collection.
An advise: iterating from last to first element would let you easily remove event at current index.
 
3. Use IsEditOperationDisabled, BeforeEditOperation to customize shared events editing. For example you can disable moving shared events between users, but let to change a time start and duration.
 
--
Best regards,
Sergey
]]> Thu, 21 Sep 2006 08:24:52 +0000 http://forum.codejock.com/forum_posts.asp?TID=5107&PID=15962&title=copy-to-multiple-schedules-is-wasteful#15962 <![CDATA[Copy to Multiple Schedules is Wasteful : I&#039;m working on incorporating...]]> http://forum.codejock.com/forum_posts.asp?TID=5107&PID=15933&title=copy-to-multiple-schedules-is-wasteful#15933 Author: CharlieF2
Subject: 5107
Posted: 20 September 2006 at 12:17pm

I'm working on incorporating your wonderful Calendar Active X control into my application and would like to make a suggestion: rather than having to copy a row from the event table to each schedule ID (to allow an event to show up for multiple people), you should consider allowing for a concatenated field of schedule IDs for which the event would be related. 
 
For example:
 
Currently, if Mike (ID 1) and John (ID 2) wanted to meet and John created the event in his schedule, then there would be a ScheduleID of 2 for this.  The event would have to be copied (second row) with ScheduleID of 1 for this to appear also for Mike.  This is of course would work. 
 
The problem is that if there are 10 users and they each create 3 events a day then that is 1000 x 10 = 10,000 created each year.  If each of these records need to beshared with at least one other person then, using your existing approach, would bloat the database up to 20,000 (at least) events.  Using my suggest approach would still keep this to 10,000 records. 
 
I hope this is clear. 
 
Thanks,
]]> Wed, 20 Sep 2006 12:17:09 +0000 http://forum.codejock.com/forum_posts.asp?TID=5107&PID=15933&title=copy-to-multiple-schedules-is-wasteful#15933