Codejock Developer Community : Multiple Resources/Schedules With SQL Server http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 13 May 2026 12:17:04 +0000 Mon, 18 Dec 2006 12:27:22 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=5799 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Multiple Resources/Schedules With SQL Server : Thanks for the thorough explanation....]]> http://forum.codejock.com/forum_posts.asp?TID=5799&PID=18337&title=multiple-resources-schedules-with-sql-server#18337 Author: hildegoat
Subject: 5799
Posted: 18 December 2006 at 12:27pm

Thanks for the thorough explanation. After re-looking at some other threads, I think I have it mostly figured out. ]]> Mon, 18 Dec 2006 12:27:22 +0000 http://forum.codejock.com/forum_posts.asp?TID=5799&PID=18337&title=multiple-resources-schedules-with-sql-server#18337 <![CDATA[Multiple Resources/Schedules With SQL Server : Data provider has Schedules collection....]]> http://forum.codejock.com/forum_posts.asp?TID=5799&PID=18302&title=multiple-resources-schedules-with-sql-server#18302 Author: sserge
Subject: 5799
Posted: 17 December 2006 at 2:52pm

Data provider has Schedules collection. It contains pairs {ScheduleID, ScheduleName}.
This collection defines Name for each schedule ID.
You have to create such table (or may be use some existing table like Employees or Rooms)
 
CalendarResource defines data group to be displayed in a separate column on a day view.
It has a reference to a data provider and a collection of schedules.
In a simple configuration all resources have reference to the same dada provider and one shedule ID in collection.
 
When you opening custom data provider, firstly add your persons to data provider shedules collection.
 
Then confgure resources to display schedules. For the simple case this just a set of visible schedule IDs. May be stored as additional field like 'IsVisible' in Schedules DB table.
 
Calendar resource filters events by its ScheduleID property.
 
Try to look at the logic in our sample (mnuMultiSchedulesSimple_Click).
 
See also:
 
http://forum.codejock.com/forum_posts.asp?TID=4921
 
Main Resorce configuration (which stored in XML) contains following information:
    DataProvider    - as connection string.
    Schedule IDs   - as array of IDs
    Enabled          - as boolean (means is visible)
       ..
Look at the configuration XML file for more details. It is quite easy.
 
But you have to save only properties which you need.

--
WBR,
Serge
]]> Sun, 17 Dec 2006 14:52:19 +0000 http://forum.codejock.com/forum_posts.asp?TID=5799&PID=18302&title=multiple-resources-schedules-with-sql-server#18302 <![CDATA[Multiple Resources/Schedules With SQL Server : Hi, I&#039;ve got my calendar...]]> http://forum.codejock.com/forum_posts.asp?TID=5799&PID=18235&title=multiple-resources-schedules-with-sql-server#18235 Author: hildegoat
Subject: 5799
Posted: 14 December 2006 at 2:50pm

Hi,
 
I've got my calendar working in VB.NET 2005 with a SQL Server 2000 back-end. The next step is to move the multiple resources/schedules to SQL Server, so that I can keep it all (events and schedules) in one database.
 
After looking through the sample code, I still can't define what a Resource and a Schedule is. If I just want to show multiple calendars at once, would I make one resource and multiple schedules?
 
Is there also an easy way to convert those XML files into corresponding SQL Server tables? Do I just need to make a Schedules table (ScheduleID, Name) or do I need to make a Resources table as well?
 
Finally, what's the easiest way to connect to the newly made SQL Server tables? The same way I connected the calendars?
 
-Matt
]]> Thu, 14 Dec 2006 14:50:03 +0000 http://forum.codejock.com/forum_posts.asp?TID=5799&PID=18235&title=multiple-resources-schedules-with-sql-server#18235