Intersoft Community - WebScheduler - Webscheduler dropdown binding

Webscheduler dropdown binding

Riendy — Mon, 08 Aug 2011 04:03:48 GMT

Hi Frank,

Of course you are possible to do that event. But, you are unable to use checkBox control to get the value because checkBox only get 0 or 1 return value.
If you want to use checkbox to return "company 1" until "Company 4", I suggest you to use a session as a parameter, so you have to define each checkbox value if checked or null if unchecked on page load and set each autoPostBack checkBox property to true.
I tried this one and it works well on my end.

Best regards.
Riendy

Webscheduler dropdown binding

frankgary — Fri, 05 Aug 2011 13:31:08 GMT

Gentlemen,

I was able to get this to work with a dropdown list following this post: http://intersoftpt.com/Community/WebScheduler/can-filter-resource-category-and-event/

However, I would like to know if I can use a checkbox list instead so my users can pick more than one company to show resources for. I have spent all night trying to get this to work. In my checkbox list with same parameters as the dropdown list I select mutiple companies, however the resources only show for the first company selected. For example my check box list is like:

Company1

Company2

Company3

Company4

If user checks Company2 and Company4, only Company2 resources show.

I have setup 6 or so (ID=?), (ID =?), OR (ID=?) OR (ID=?) etc, parameters and defined them in the ISDatasource, and they do display in my checkbox list. However only one "company" resources at a time will display.

Is this even possible to do? I am using a bound control rather than a session and perhaps that is where I am lost.

Thank you....

Webscheduler dropdown binding

frankgary — Thu, 04 Aug 2011 14:39:02 GMT

Riendy,

Please disregard my last post. I was able to get this to work.

Thanks!

Webscheduler dropdown binding

frankgary — Thu, 04 Aug 2011 11:48:14 GMT

Hi Riendy,

Thank you for your prompt reply. It is greatly appreciated.

I think I somewhat understand the concept, but in looking at Handy's examples I am not sure we are talking about the same thing. It appears in that scenario they are somehow using the logged in users session to load the desired resources on the webscheduler.

I am trying to do this through a dropdown. I think the online carrental example is a closer fit:

http://live.intersoftpt.com/cs/WebScheduler/CarRental.aspx?noframe=1&path=/WebScheduler/New%20Features%20in%20V3/New%20Reference%20Samples

Here you have a "Car Availabilty" where you select the car from a dropdown list similar to what I need. Instead of cars in a dropdown list I have company names in a dropdown list. When the user selects the company name from the dropdown list I only want to show the resources with that companyid.

I my company database I have 8 companies with companyID 1 through 8. In my resources table there is a field also with companyid on each resource also. My resources table looks something like

ID Resource CompanyID

1 Resource1 3

2 Resource2 4

3 Resource3 5

4 Resource4 6

5 Resource5 3

So if user selects company 3 from dropdown only resource1 and resource5 should display.

Is this possible?

I guess where I am lost is I am not sure how to "connect/bind" the companyid in the company dropdown to the companyid in the resources table with a "where" clause in the isdatesource resources table.

In resources table It would have to be something like:

where resources.companyid = companydropdown.companyid but this is not a valid sql where statement so that is where I am lost.

Webscheduler dropdown binding

Riendy — Thu, 04 Aug 2011 06:09:53 GMT

Hi Frank,

The important thing that you have to do to load/display the resources based on your selected value, is set a parameter in the "resources" query method. Then, the parameter must a specific resources.

After that, you need to set the value to the parameter. Last, you can bind the data into your WebScheduler.

Our support member whose named Handy have ever discussed it before. Please take a look at this thread to get more information and a simple runable sample.

Best regards.
Riendy

Webscheduler dropdown binding

frankgary — Wed, 03 Aug 2011 20:29:32 GMT

Gentlemen,

I have added a "Company" VS2010 dropdown control to the upper left corner of my webscheduler, (see attached screen shot).

I have been able to bind this control to both an sql data source as well as an isdatasource. This control basically displays a list of companies in my company table with data text field of Company Name and dataid field of SysCompanyID.

All of my "resources" in the webscheduler resources table and all of my "appointments" in the webscheduler events table are/have been saved with a SysCompanyID.

My question is, how can the webscheduler only load/display the resources and only load/display the events based on the company selected in the "Company" VS2010 dropdown control? I have exhausted all of my knowledge in trying to get this to work.

Can you please help?

Thanks!!!!