iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
Gentlemen,
I am struggling with a critical implementation issue as follows:
Background:
1). I have a SysCompanyDropdownlist1 implemented on my webscheduler control. The dropdownlist is bound to my intersoftdataset into a "SysCompany" table that displays "Companies" in the dropdown list, (based on SysCompanyID).
2). In my master ISDataSource1 the resources table has a clause - WHERE (SysCompanyID = @Param1) OR (SysCompanyID = @Param2) OR (SysCompanyID = @Param3) OR (SysCompanyID = @Param4) OR (SysCompanyID = @Param5) OR (SysCompanyID = @Param6)
and these parameters are defined as 1 for Param1, 2 for Param2, 3 for Param3, etc in the ISDataSource1 Resources "Define Parameters" where the parameters source is my SysCompanyDropdownlist1
3). This is all working. When I pick company 1 from the dropdown list, only company 1 resources and events are displayed, when I pick company 2 from the dropdown list only company 2 resources and events are displayed and etc.
4). Recently I posted a question/resolution regarding loading the webscheduler with a default date passed externally into the webscheduler and it works perfectly: http://www.intersoftpt.com/Community/WebScheduler/Passing-default-dates-into-timeline-view/
My Problem:
1). I am now trying to load the webscheduler with the default SysCompanyID externally similar to passing the dates into the webscheduler as outlined in #4 above.
2). The externally passed default SysCompanyID is passing into the webscheduler SysCompanyDropdownlist1 perfectly on page load.
3). The problem is although the default SysCompanyID is passing into the webscheduler SysCompanyDropdownlist1 perfectly on page load, the initial data is showing for ALL companies, like the query never happened on page load. However, if I change the company after the initial page load the query shows the right information. For example:
Initial Webscheduler Page load shows externally passed syscompany 2 in the SysCompanyDropdownlist1 but shows data for ALL companies. If I then select syscompany 1 in the SysCompanyDropdownlist1 it works and I get only the data for syscompany1, if I then select syscompany2 I get only the data for syscompany2.
My problem is that even though the syscompanyid is being passed into the webscheduler externally on page load, and shows correctly in the SysCompanyDropdownlist1, on initial page load it is not running the parameterized query at all, until I reinvoke the SysCompanyDropdownlist1 again after page load.
I am assuming something needs to execute either on page load or in a client side event?
If I can provide additional information, images, code files etc please let me know. I have attached my webscheduler code behind file for reference.
I would greatly appreciate assistance on this challenge.
Thanks - Frank Gary
Hello,
Thank you for your information.Base on your snippet code that you post, there isn’t a problem with your code.Could you create a simple runnable project that replicates this issue, so that I can investigate the issue from my end?
Thank you.Regards,Hans.
Hi Hans,
Thank you for your reply.
Could you please be more specific as to what a "simple runnable project" is? Our project is 300+ tables and hundreds of pages. Although it would seem obvious what you are asking for, it is an undertaking to "extract out" the necessary files that you need, so knowing exactly what you require would be a great help.
Please advise and best regards,
Frank Gary
I assumed that you have a complex project. Therefore I ask you to make a simple project/sample that replicate/similar this issue.I need your simple project to investigate your issue. Example in debug mode, I can understand which part that you missed.
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname