Scheduler connect to database

[MarkLince]

Hi,
I'm new to CGDevTools and have some questions before I buy. We are porting a scheduling program over to a web ap using intraweb (V14.0.46 delphi xe7). Our desktop version uses TMS planner components which work great, but the TMS webplanner is not so great, so we are looking at the CGDevTools scheduler and component suite to switch from TMS.

We are also intending to utilise our exsisteng DB engine which is DBISam (at least initially), so My first questions are;

1. Can we use DBISam (BDE Alternative) with the scheduler?
2. If yes how do we connect the database?

Sorry if I'm being stupid, but I just can't see it so need some help.
Thanks in advance
Mark

[assapan]

Hi,
I have also ported desktop application using TMS software components and at beginning was using TMS for intraweb .
I have completely swaped to CGDevtools with some adaptations .
Scheduler component is not directly linked to database but it is really easy to interface it.


P.S. I have none company actions nor link with Central gest

[Jorge Sousa]

Hi MarkLince

Thank you assapan

As we can see in our demo - JQueryDemoV3, is just a matter of filling the Scheduler.JQSchedulerOptions.EventItems at create/design time, for full page submits.

or using

CGDisableCallbackResponse;
try
// Refresh the Items
Scheduler.AjaxReRender;
finally
CGEnableCallbackResponse;
end;

to refresh items in ajax events.

For lazy data loading, ie, only when the scheduler needs the page data, us the event Scheduler.OnGetData, this is a data event only.

[MarkLince]

Hi,
Thanks assapan and jorge, its the leg up I needed.
Just one more silly question, I don't want the user to be able to create a new event by clicking the scheduler so how do I disable this, I can't see where its being triggered.
again sorry for my ignorance.
Mark

[MarkLince]

OK I see the FastCRUD property but what I want is for nothing to fire. I want to be able to strictly control when events are created and not prompt the user.

Looks like the source is needed for this.
Mark

[Jorge Sousa]

Hello Mark

I'm afraid we've to implement a new feature to determine if the user can create/edit/delete events

[assapan]

Why not set the events OnAdd and OnEdit to an empty proc ?

[MarkLince]

Hi,
Thanks for the replies.

I'm afraid we've to implement a new feature to determine if the user can create/edit/delete events

Need to be able to select a cell, show the cell as the selected cell and let the end user decide whether to initiate a new/edit event item or not. Rather than always assuming that that's what the user wants. It would get very annoying to my customers if every time they clicked on an empty cell they had to deal with a dialog box.

Why not set the events OnAdd and OnEdit to an empty proc ?

I have tried this in the demo and also setting the FastCRUD to true (has no effect otherwise) does suppress the dialogs from firing when clicking on a blank cell it also stops them firing on an existing event item so it prevents editing of an item. Another effect is that it draws an event box in whatever empty cell is clicked and persists until the scheduler is reloaded.

I can understand why assuming that the user wants to create an event when clicking a cell might be a legitimate assumption but I don't think its appropriate in all instances and certainly for my application would be quite annoying to my end users.

That said, I'm really liking your components.
Mark

[Jorge Sousa]

Hi

I'm sorry, i was wrong, didn't search correctly.

Reading

http://www.cgdevtools.com/docs/_html/IWCGJQScheduler.TIWCGJQSchedulerOptions.htm

you'll see the property

ReadOnly : Indicate calendar is readonly or editable

The properties and method in the option classes always reflects / represents what the jquery plugin can do, on client side.

[MarkLince]

Hi,
Thanks again Jorge.

Sorry to disagree, but I don't think making the calendar readonly is the same as what I'm proposing which is being able to control when individual event items are selected, created and or edited. I don't want the control to be not editable I just would like to be able to choose when and how each event item is created/ edited. It would seem at the moment that this is an all or nothing arrangement.

Might I suggest some events such as OnClick, OnEventClick or OnEventDblClick and also a toggle to switch off the auto creation of event items without having to resort to making the whole schedule readonly would be extremely useful and make life a whole lot easier, from my perspective anyway.

But please, if there is something I'm missing with this please, please enlighten me, I like your work and really want to commit to CGDevTools.

Mark