Codejock Developer Community : Best method ? Multi-USER / Multi-Resource

Best method ? Multi-USER / Multi-Resource : If you set sonnection string "provider=Custom"...

Sat, 21 Oct 2006 18:28:31 +0000

Author: sserge
Subject: 5295
Posted: 21 October 2006 at 6:28pm

If you set sonnection string "provider=Custom" the custom data provider is created. In this case calendar sends DoXXX events, which you have to catch and process like in our example (connect DB by yourself using ADO or somthing other, write SQL to read from DB and Update DB, etc)

If you set sonnection string "Provider=Microsoft.Jet.OLEDB.4.0; ..." the built-in Access data provider is created, which connects to DB and processes requests inside. DoXXX events are not sent in this case. This provider works with predefined tables.

You can use any of those providers.

Custom provider:
    Advantage:     flexibility. Everything is in your hands.
    Disadvantage: it is complex to implement.

Built-In Access data provider:
    Advantage:     it is easy to use.
    Disadvantage: it use some predefined tables, and not so flexibile.

In any case you can read Options and Schedules after you Open data provider. Just read data from DB and put it to CalendarControl.Option and CalendarDataProvider.Schedules objects.

When you call CalendarDataProvider.Open (or Create) those members are filled with default values (or empty).

And save this data to DB before closing a data provider (custom or access).

ps: regarding @gaudetm's advice: you can use notifications EventAdded, EventChanged, EventDeleted to mark that data has been changed. They are sending for any data provider.

--
WBR,
Serge

Best method ? Multi-USER / Multi-Resource : When I set the pRes0.SetDataProvider2...

Sat, 21 Oct 2006 11:39:35 +0000

Author: vbuser
Subject: 5295
Posted: 21 October 2006 at 11:39am

When I set the pRes0.SetDataProvider2 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\events.mdb", True everything runs file, the Schedules table is accessed, resource names are read, etc. When I set pRes0.SetDataProvider2 = "Provider=custom", True, the table is no longer read, where are do I process the table events? How do I access or set database events for the resources? In my application the resources names are to be read from an EMPLOYEES table, not the default 'Schedules' table. Also, how do I save the OPTIONS when in 'custom' mode?

I have tried different ways to make this work and I need help please...

Best method ? Multi-USER / Multi-Resource : Too bad about the scroll bar,...

Wed, 18 Oct 2006 19:51:39 +0000

Author: vbuser
Subject: 5295
Posted: 18 October 2006 at 7:51pm

Too bad about the scroll bar, I will think of a solution...

@gaudetm,

thanks for your great input - I was inclined to do something like that, and may be add code to avoid updating the calendar if user is editing an event, etc. Thanks again!

Best method ? Multi-USER / Multi-Resource : My solution for multiusers synchronisation...

Wed, 18 Oct 2006 10:21:58 +0000

Author: gaudetm
Subject: 5295
Posted: 18 October 2006 at 10:21am

My solution for multiusers synchronisation is simple, implent a new table in the database call Updates in that table add fields documenttype and lastupdate (time and date) and put a timer on my main form and check updates every 2 secondes and update only is lastdate > date in table updates so that way only update when someone do a change and when someone add, delete or modify a record on the save function just update the table updates

Hope this help, It's as far as I know the best solution yet, dont take so many time consuming besause of a good sql query and timers in vb6 are in a separated thread so don't freeze the application

Marc

Best method ? Multi-USER / Multi-Resource : vbuser wrote: QUESTION:...

Wed, 18 Oct 2006 03:36:03 +0000

Author: sserge
Subject: 5295
Posted: 18 October 2006 at 3:36am

vbuser wrote:

QUESTION: How can I add a horizontal scroll to the control?

I need this because I have to show many resources.

This is not possible. See also http://forum.codejock.com/forum_posts.asp?TID=3664

Try to think about some workaround like show only 1 day in DayView, or change resource configuration on the fly (after switching a day, or with some additional chackboxes available for a user, and so on)

--
WBR,
Serge

Best method ? Multi-USER / Multi-Resource : Yeah, I had left those 2 lines...

Wed, 18 Oct 2006 02:55:15 +0000

Author: vbuser
Subject: 5295
Posted: 18 October 2006 at 2:55am

Yeah, I had left those 2 lines - I think the trick was to make sure the pRes0.SetDataProvider2 has 'Provider=custom. Thank you

QUESTION: How can I add a horizontal scroll to the control?

I need this because I have to show many resources.

Best method ? Multi-USER / Multi-Resource : 1. Call Populate method: Cale...

Tue, 17 Oct 2006 07:51:20 +0000

Author: sserge
Subject: 5295
Posted: 17 October 2006 at 7:51am

1. Call Populate method:


CalendarControl.SetMultipleResources
CalendarControl. Populate

2. Calendar Event has ScheduleID field and property.
Ensure that events in you table have ScheduleIDs corresponding
other ScheduleIDs which you setup in data provider Schedules member.

--
WBR,
Serge

Best method ? Multi-USER / Multi-Resource : I converted the providerSQLServer...

Tue, 17 Oct 2006 03:37:51 +0000

Author: vbuser
Subject: 5295
Posted: 17 October 2006 at 3:37am

I converted the providerSQLServer to use Access in CUSTOM mode, so I can handle all the DoXX events for Multi-User enviroments.

I CANNOT figure out how to set up multi-resources, how do I populate pRes0.SetDataProvider2 ? This is what I got from teh sample:

Dim arResources As New CalendarResources
    Dim pRes0 As New CalendarResource
    Dim pRes1 As New CalendarResource

    pRes0.SetDataProvider2 ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\events.mdb", True

    If pRes0.DataProvider Is Nothing Then
        Debug.Assert False
        Exit Sub
    End If

    If Not pRes0.DataProvider.Open Then
        If Not pRes0.DataProvider.Create Then
            Debug.Assert False
            Exit Sub
        End If
    End If

    '// ** schedules
    Dim pSchedules As CalendarSchedules
    Set pSchedules = pRes0.DataProvider.Schedules

    If pSchedules Is Nothing Then
        Exit Sub
    End If

    If pSchedules.Count < 1 Then
        pSchedules.AddNewSchedule "Tech 1"
        pSchedules.AddNewSchedule "Tech 2"
        pRes0.DataProvider.Save
    End If

    '// ** resources

    pRes0.Name = pSchedules.Item(0).Name
    pRes0.ScheduleIDs.Add pSchedules.Item(0).Id

    pRes1.SetDataProvider pRes0.DataProvider, False
    pRes1.Name = pSchedules.Item(1).Name
    pRes1.ScheduleIDs.Add pSchedules.Item(1).Id


    arResources.Add pRes0
    arResources.Add pRes1

    CalendarControl.SetMultipleResources arResources

The problem here is that when I do this the Calendar control switches back to the internal access data provider and no longer calls the DoXX events... What did I miss?

Also, I need a SCROLL BAR at the buttom of the scheduler because I need to have MANY resources, about 17, in day view, and the scheduler cannot fit them properly - how can I implement this? Thank yoU!

Best method ? Multi-USER / Multi-Resource : No we have only built-in Access...

Mon, 16 Oct 2006 12:09:21 +0000

Author: sserge
Subject: 5295
Posted: 16 October 2006 at 12:09pm

No we have only built-in Access data provider.
Try to use SQL Server custom data provider sample to create the same one for Access...

--
WBR,
Serge

Best method ? Multi-USER / Multi-Resource : Do you have a sampleusing Access...

Mon, 16 Oct 2006 10:30:26 +0000

Author: vbuser
Subject: 5295
Posted: 16 October 2006 at 10:30am

Do you have a sample using Access in CUSTOM mode? Perhaps an access implementation of the 'providerSQLServer" class?

thank you!