I'm planning to use WebSchedule along with its database to store user Activities.
Qustion: How does WebSchedule database store the information that link user (who is logged in) with his/her Activities?
Looks like Resource is what suppose to represent a user. If that is so, then ResourceID needs to be linked with my custom User table, and I will have a table ResourceUserResource with two columns (ResourceID and UserID) where UserID is id of a user in my own database.
Am I on the right track here?
warzone said: I have a similar question. Let's say after getting a user name, then how do I feed the @OrganizerName in the storedprocedure Activity_SelByDate? Which method I need to call or modify and/or any changes to the current stored procedure?
I have a similar question. Let's say after getting a user name, then how do I feed the @OrganizerName in the storedprocedure Activity_SelByDate? Which method I need to call or modify and/or any changes to the current stored procedure?
The organizer name for which activities are selected is the WebScheduleInfo.ActiveResourceName.
warzone said: Also, the time adding a record to Activity table, how do I feed that @OrganizerName and create a link in the AcitivityResouce table?
Also, the time adding a record to Activity table, how do I feed that @OrganizerName and create a link in the AcitivityResouce table?
If you're asking how the Infragistics data providers do this, they use the same ActiveResourceName property. If you have a custom data provider (and it may be serializing to something that isn't a relational DB) then how you implement the relationship between Activities and Resources is up to you.
There is an administrative API method on the Infragistics data providers, AddActivity(Activity, Resource), that allows you to pass-in an Activity object and a Resource object, and it will save them to the database creating the tie in the ActivityResource table. In that case, it takes the Resource.Name property.
Hi,
I have a similar question. Let's say after getting a user name, then how do I feed the @OrganizerName in the storedprocedure Activity_SelByDate? Which method I need to call or modify and/or any changes to the current stored procedure? Also, the time adding a record to Activity table, how do I feed that @OrganizerName and create a link in the AcitivityResouce table? Thank you very much.
Do I have to build a custom solution to link my User table with Resource?
Like creating UserResource table with UserID and ResourceID.
The process as I imagine it would go like this.
I wonder if I'm missing something here. Is there a better way to do this or am I on the right track?
A resource can be a person, place or thing — so yes, you are on the right track. Resource was chosen to be general enough of a term that it allows for scheduling equipment, or listing events in a conference room, building or city. Most often, they are the users who own the activities, though.
There is an ActivityResource table that links a resource to its activities in a one-to-many relationship; see Data Model.