Intersoft Community - WebScheduler - Group events by users

Group events by users

bernard — Thu, 20 Jun 2013 22:15:33 GMT

Hi Jakub,

From your message above, you mentioned that you have successfully insert the resource data to your database. And right now you're facing the problem that comes from EventsAdapter update method. However if you have successfully insert the resource data to database and control the identity ID, the events won't show the old data. As you can see in WebScheduler sample (SoftwareDevelopmentTimeline.aspx), it also control handle the identity value. Although, you can use this function to refresh the resources from clientside events:

var scheduler = ISGetObject(controlId);
scheduler.RefreshResources();
return true;

Actually, I need to trace and debug this problem in our local end. Perhaps, you can guide us to replicate this issue by giving us a simple sample that can replicate this issue in our local end. Look forward to hear any feedback from you so I can help you further.

Regards,
Bernard

Group events by users

jamesik@centrum.cz — Thu, 20 Jun 2013 07:43:08 GMT

The stored procedure p_WebSchedulerResources_ins properly inserts new resources row to the database and returns new ResourceID (@@IDENTITY) and this identity value is returned from the Insert method of ResourceAdapter. There is nothing wrong with the resource related functionaly.
Later, ther is a problem with EventsAdapter - Update method as this method automatically takes old ResourceID (not the updated one). So the new record is not updated.
I need to refresh page manually and the it stars working properly.
So I believe only the problem here is the new resourceID is not properly sent between ResourcesAdapter and EventsAdapter.

Thanks,
Jakub

Group events by users

bernard — Wed, 19 Jun 2013 22:40:36 GMT

Hi Jakub,

I have tried to replicate your issue here. Unfortunately, I couldn't replicate your issue in our local end. Please check if your stored procedure (p_WebSchedulerResources_ins) have the right parameter from your TableAdapter. However, when using DataSet ResourcesTableAdapter Insert function, I don't have any difficulties to insert the data to my database. Using that method I just have to add the ResourcesName, Description, Color and Location parameter, then it will control the new ID (identity) for the new resources. Is there any executable simple sample in our local end that can replicate your issue? I really need to track where the problem comes from so I can help your further.

Regards,
Bernard

Group events by users

jamesik@centrum.cz — Wed, 19 Jun 2013 12:44:16 GMT

I'm now stuck with the following problem:
I programmatically enter data row to Resources table and return the new ResourceID - I explicitly call ResourcesTableAdapter.Insert method from EventsTableAdapter and return ResourceID as return value from ResourcesTableAdapter.Insert method.
But after I try to update the newly entered event later, the ResourceID is not updated - I always get lower ResourceID than the last entered in the EventsTableAdapter.Update method...

The problem is probably I crate new instance of ResourcesTableAdapter explicitly (as I need to get access to ResourcesTableAdapter from EventsTableAdapter)...
(new WebSchedulerResourcesTableAdapter()).Insert(-1, _userID, "User", null, "#00AA00");

Please, is there any way to access the existing instance of ResourcesTableAdapter from EventsTableAdapter?

Source code attached.

Thank you,
Jakub

Group events by users

bernard — Sun, 16 Jun 2013 21:42:26 GMT

Hi Jakub,

Actually, this matter happen in all of our control. This matter happen because there are some changes in our framework that made our the control couldn't make the object automatically in aspx page. However, you still can make client side events in your page, First, you can make javascript manually in your aspx page and then you can manually added the function name to client side event's property inside WebScheduler (i.e. <ClientSideEvents OnBeforeAdd="WebScheduler1_OnBeforeAdd" />). We are really sorry for this problem and if you still found any difficulties regarding this problem, please let me know. I'll guide you further. Hope this helps.

Regards,
Bernard

Group events by users

jamesik@centrum.cz — Fri, 14 Jun 2013 05:50:11 GMT

Unfortunately I'm unable to create any ClientSideEvent handler (via properties tab in designer). I'm getting well know "Object reference not set to an instance of an object" exception any time when trying to create client side event handler.
I've installed WebScheduler, IsDataSource and ISLinqDataSource tools using trial version webuistudio2012r2web.exe.

Do you have an idea what might be a problem? I also tried to uninstall and re-install the plugin and registered SmartWebResources.
The same issue when trying to create client event handlers via Component Designer 2.0 (Component Type: WebScheduler.NET 3.0)

Thanks,
Jakub

Group events by users

bernard — Thu, 13 Jun 2013 22:53:26 GMT

Hi Jakub,

I think that scenario is possible to do with WebScheduler. Although, you can extend the column of Resources table then filter it using the parameter in extended column of Resources table. When Resources table filtered, events will be shows regarding the Resources that WebScheduler got from server side. You can also change the structure of the CallOut in OnCallOUtShow event. Here's the code:

function OnCallOutShow(controlId, mode) {
var WebScheduler1 = ISGetObject(controlId);
WebScheduler1.GetCallOutDataElement().children[0].rows[2].style.display = "none";
return true;

}

You can also control the insert data in WebScheduler in OnBeforeAdd event. please let me know if you have any difficulties to achieve this scenario. Hope this helps.

Regards,
Bernard

Group events by users

jamesik@centrum.cz — Thu, 13 Jun 2013 09:25:02 GMT

Hi Bernard,

I've got another related problem. Say we might have dozens thousands users. Is there any way to forbid/disallow user to select resource manually?
I'd need to add a record to resources table automatically on first user's hit. My idea is to extend Resources table to contain UserID. This approach would allow me to pair user events with users the events belong to.
Every user should see only his/her event and no user should have an opportunity to select resource manually.
So I'd like to hide resources view (possible to do by setting DisplayResourcesTable to false) and also I'd like to disable / hide the resourceid dropdown in "create new event" flyout. I'd like to fill the resourceID programatically based on the retrieved UserID - getting resourceID programatically based on UserID via stored procedure and then filtering events programatically by the retrieved resourceID.
Thus users would automatically see ONLY events that were entered under their own UserID.
Is this possible to do or are there any suitable alternatives?

Thank you,
Jakub

Group events by users

bernard — Tue, 11 Jun 2013 21:18:00 GMT

Hi Jamesik,

Actually, there are 3 primary table on WebScheduler which are Resources, Events and Categories. However, Resources is the table that usually used to bind each event with single resources. This table also used to hide or show some events in WebScheduler. I'm glad that you have solved your problem.

Hope this helps.

Regards,
Bernard

Group events by users

jamesik@centrum.cz — Tue, 11 Jun 2013 03:00:18 GMT

Hi Bernard,

thank you for your answer. Yes, you're right. I don't know why I omitted the resources table. From some reason I was in some illusion that this table is intended for something slightly different. But this wasn't true.

Thanks again,
Regards,
Jakub

Group events by users

jamesik@centrum.cz — Mon, 10 Jun 2013 09:39:04 GMT

Hi,

Is there any possibility to group events by users? We'd like to display only user specific events. So users who are logged in would see only their events.

Thank you,

Jakub