Resources with Custom Provider

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

Hi all,

  currently I am working on a prototype for a Counseling system which each Counselor is considered as a Resource.  I would like to have the calendar initially display all appointments when there is not counselor selected (counselors are listed in a checkbox-list).  When one or more counselors are select (checked), the calendar shall displayed in a column-ed basis for each counselor with their own appointments.

  I am using a custom provider which connect to an Access database with the tables and structures designed for the software.

  I cannot seem to get the control to read data based on each of the resource (counselor per se).

Any suggestion?

Any help is appreciated!

+-------------+
| Counselor |
+-------------+
| ID (auto)   |
| ...              |
+-------------+

+----------------+
| Appointment |
+-----------------+
| ID (auto)        |
| Counselor_ID |
| StartDateTime|
| ...                   |
+-----------------+

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
BVoon Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 25 November 2008 Location: Malaysia Status: Offline Points: 5	Post Options Post Reply Quote BVoon Report Post Thanks(0) Quote Reply Topic: Resources with Custom Provider Posted: 26 November 2008 at 4:31am
	Hi all, currently I am working on a prototype for a Counseling system which each Counselor is considered as a Resource. I would like to have the calendar initially display all appointments when there is not counselor selected (counselors are listed in a checkbox-list). When one or more counselors are select (checked), the calendar shall displayed in a column-ed basis for each counselor with their own appointments. I am using a custom provider which connect to an Access database with the tables and structures designed for the software. I cannot seem to get the control to read data based on each of the resource (counselor per se). Any suggestion? Any help is appreciated! +-------------+ \| Counselor \| +-------------+ \| ID (auto) \| \| ... \| +-------------+ +----------------+ \| Appointment \| +-----------------+ \| ID (auto) \| \| Counselor_ID \| \| StartDateTime\| \| ... \| +-----------------+
	nothingcool

mandrews Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 01 December 2008 Location: United States Status: Offline Points: 3	Post Options Post Reply Quote mandrews Report Post Thanks(0) Quote Reply Posted: 01 December 2008 at 7:50pm
	I'm building something very similiar. Perhaps we could share what each of us have so far? I have some hack code which loads in Resources but nothing is pretty at this point. If interested checkout www.rptsoftware.com for contact info and email me. Note: I'm building my solution entirely in Access. Also I just started today to try and decipher how everything works.

BVoon Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 25 November 2008 Location: Malaysia Status: Offline Points: 5	Post Options Post Reply Quote BVoon Report Post Thanks(0) Quote Reply Posted: 10 December 2008 at 8:48pm
	I actually get the feature done. Just need some optimization on the database access part when query against the database. If you like to know how i manage that, please let me know.
	nothingcool

mandrews Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 01 December 2008 Location: United States Status: Offline Points: 3	Post Options Post Reply Quote mandrews Report Post Thanks(0) Quote Reply Posted: 29 December 2008 at 1:57pm
	I would love to share code examples back and forth. I got a lot to work but still figuring out some small pieces of the solution. I need your email address. Mark RPT Software http://www.rptsoftware.com PS: All my info is on my web site.

BVoon Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 25 November 2008 Location: Malaysia Status: Offline Points: 5	Post Options Post Reply Quote BVoon Report Post Thanks(0) Quote Reply Posted: 05 January 2009 at 8:39pm
	my email is voonbs@gmail.com
	nothingcool