Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
195
Need WebSchedule Help
posted
In an effort to learn how to use the WebSchedule myself I've spent the last 2 days researching but I still can't get it to work. What I have..... I'm using MSSQL Server 2005 and I used the WebSchedule2.sql scripts AS IS found in C:\Documents and Settings\All Users\Documents\Infragistics\NetAdvantage for .NET 2007 Vol. 3 CLR 2.0\WebSchedule\Data to build my data base. I added in the of my web.config and added directly after On my page (which has a master page) I have an SQLDataSource, a WebScheduleSqlClientProvider, a WebScheduleInfo, a WebMonthView and a WebDayView. The WebMonthView, WebDayView and WebScheduleSqlClientProvider all have the WebScheduleInfoID pointing to my WebScheduleInfo, the WebScheduleSqlClientProvider has my SQLDataSource set as it's DataSourceID. My Problem..... I'm to the point where the WebMonthView and WebDayView are displaying but whenever I click on either to add an appointment the AppointmentAdd page opens and closes in a flash. I'm not sure but it might have something to do with not setting the Resource on the WebScheduleInfo properly. There appears to be nothing in the documentation that I found which explains how to use or do this. I'm assuming that each Resource equates to the different Calendars that I want, in my case I want different users to have their own calendars. I did find something which referred to adding to the Resource table using one of the ASP.NET Samples but I couldn't find the sample they referred to on my system, there are plenty of other samples but not that one. My Resource Table has 1 record with ResoruceID -999 so I manually added a record which is now ResourceID 1, I also manually added a record to ResourcePreference with ResourceID of 1. I would really like for all my users to be able to maintain their own calendar, each user has a unique name which is set in a session variable. A little long winded but I hope the background helps explain my situation, hope someone can help.
  • 4960
    posted

    I'm glad that you got everything working, John.  Let me just answer a few of the questions here for others.

    I did find something which referred to adding to the Resource table using one of the ASP.NET Samples but I couldn't find the sample they referred to on my system, there are plenty of other samples but not that one.

    This is the Resource Administration sample, it is in the "AdminSample" folder.  Where that gets installed on your system varies depending on whether you are running Windows Vista or Windows XP, the samples are rooted in the following folders:

    Windows Vista:  C:\Users\Public\Documents

    Windows XP:   %USERPROFILE%\My Documents   (where %USER PROFILE% is something like C:\Documents and Settings\LOGON_NAME)

    From here the C# sample can be found in Infragistics\NetAdvantage for .NET 2008 Vol. 3 CLR 2.0\Samples\ASP.NET\WebFeatureBrowser\WebSchedule\AdminSample and the VB sample can be found in Infragistics\NetAdvantage for .NET 2008 Vol. 3 CLR 2.0\Samples\ASP.NET\WebFeatureBrowserVB\WebSchedule\AdminSample.

    I'm not sure but it might have something to do with not setting the Resource on the WebScheduleInfo properly. There appears to be nothing in the documentation that I found which explains how to use or do this.

    See the "Creating a Logon Dialog Box for Your WebSchedule Application" walkthrough for information on setting the ActiveResourceName property on the WebScheduleInfo control.  I'm afraid most of the other examples in the help avoid setting an Active Resource so that they can focus on just the code necessary for their particular topic.  When no ActiveResourceName is set, the Unassigned Resource (-999) is used.  Yes, when you do this you'll need rows corresponding to each named user in your Resources table.

    I'm not sure the flash and quick close of the Edit Appointment form you mention would be caused by the Resource not being set, because there is always the Unassigned Resource. If anyone has this problem, they may wish to consult the documentation for "Including WebSchedule Dialog Forms in your C# Web Site" (or VB.NET version of same).

  • 195
    Verified Answer
    posted

    I've got it working now.  Not exactly sure what I did but after playing with the controls it appears to be working on my development system.  I'm having a security problem on my production system that I'll submit in another post.