Hi,
We are in the process of developing an appointment scheduling application using RadSchedular and we are very pleased with the results so far. We have build screens for the staff to maintain their own calendars and we using sql server as a back end.
We have to create a customer facing application where the customer will select the date and staff type they wish to make an booking with and will be presented with a list of appointments times for example they would enter the date 8 Jan 2008 and select the staff as “Mechanic” . They would then get a list of available appointment times to select from
10:00 Joe Bloggs
11:30 Joe Bloggs
10:30 James Jones
We do this by using a stored procedure to search for free slots in all the calendars for that StaffType . This is easy enough to do for regular appointments by using the Start and End Date however I would like to be able to do this for recurring appointments. Is there any SQL or .NET code available which would allow us to interrogate the RecurranceRule columns
I hope this make sense
Thanks
Joe
| <root> |
| <modules> |
| <module name="RadEditorHtmlInspector" dockingZone="Module" enabled="true" visible="false" /> |
| </modules> |
| <tools name="MainToolbar" isribbon="false" dockable="true"> |
| <tool name="AjaxSpellCheck"/> |
| <tool name="FindAndReplace" shortcut="CTRL+F"/> |
| <tool name="Copy" shortcut="CTRL+C"/> |
| <tool name="Paste" shortcut="CTRL+V"/> |
| <tool name="PasteFromWord" /> |
| <tool name="PasteFromWordNoFontsNoSizes" /> |
| <tool name="PastePlainText" /> |
| <tool name="PasteAsHtml" /> |
| <tool separator="true"/> |
| <tool name="Undo" shortcut="CTRL+Z"/> |
| <tool name="Redo" shortcut="CTRL+Y"/> |
| </tools> |
| <tools isribbon = "false"> |
| <tool name="Bold" shortcut="CTRL+B"/> |
| <tool name="Italic" shortcut="CTRL+I"/> |
| <tool name="Underline" shortcut="CTRL+U"/> |
| <tool name="StrikeThrough" /> |
| <tool separator="true"/> |
| <tool name="JustifyLeft" /> |
| <tool name="JustifyCenter" /> |
| <tool name="JustifyRight" /> |
| <tool name="JustifyFull" /> |
| <tool name="JustifyNone" /> |
| <tool separator="true"/> |
| <tool name="Indent" /> |
| <tool name="Outdent" /> |
| <tool name="InsertOrderedList" /> |
| <tool name="InsertUnorderedList" /> |
| </tools> |
| <tools isribbon="false"> |
| <tool name="ConvertToLower" /> |
| <tool name="ConvertToUpper" /> |
| <tool separator="true"/> |
| <tool name="InsertTable" /> |
| <tool name="InsertSnippet" /> |
| <tool name="InsertFormElement" /> |
| <tool name="InsertSymbol" /> |
| </tools> |
| <tools name="DropdownToolbar" isribbon="false"> |
| <tool name="FormatBlock"/> |
| <tool name="FontName"/> |
| <tool name="FontSize"/> |
| <tool separator="true"/> |
| <tool name="FormatStripper"/> |
| <tool name="ApplyClass"/> |
| <tool name="InsertCustomLink"/> |
| <tool name="ForeColor"/> |
| <tool name="BackColor"/> |
| </tools> |
| <links> |
| </links> |
| <tools name="DialogToolbar" dockingZone="Top" enabled="true" isribbon="false"> |
| <tool name="IncreaseSize" shortcut="F10"/> |
| <tool name="DecreaseSize" shortcut="F9"/> |
| <tool name="Print" shortcut="CTRL+P"/> |
| <tool name="Superscript" /> |
| <tool name="Subscript" /> |
| <tool name="InsertParagraph" /> |
| <tool name="InsertHorizontalRule" /> |
| <tool name="InsertDate" /> |
| <tool name="InsertTime" /> |
| <tool separator="true"/> |
| <tool name="AboutDialog" /> |
| <tool name="Help" shortcut="F1"/> |
| </tools> |
| <snippets> |
| </snippets> |
| <symbols></symbols> |
| <fontNames> </fontNames> |
| <fontSizes></fontSizes> |
| <colors></colors> |
| <paragraphs></paragraphs> |
| <classes></classes> |
| <dialogParameters></dialogParameters> |
| <languages></languages> |
| <contextMenus></contextMenus> |
| </root> |
| <!-- ============================================================================================== |
| The ToolsFile must have a valid structure as shown below |
| All attributes and their values are case sensitive! |
| <root> |
| <modules> |
| <module /> |
| <module/> |
| </modules> |
| <tools> |
| <tool /> |
| <tool /> |
| ... |
| </tools> |
| ... |
| <colors> |
| <color/> |
| <color/> |
| </colors> |
| </root> |
| <tool> element valid attributes: |
| name (required): Bold Italic Underline StrikeThrough Superscript Subscript |
| JustifyLeft JustifyCenter JustifyRight JustifyFull InsertOrderedList InsertUnorderedList |
| Outdent Indent Cut Copy Paste PasteFromWord |
| PastePlainText PasteAsHtml Print Undo Redo ImageManager |
| AbsolutePosition LinkManager Unlink InsertBoldHorizontalRule InsertTable ToggleTableBorder |
| FormatBlock ApplyClass FontName FontSize InsertCustomLink Custom |
| InsertSymbol BackColor ForeColor FlashManager MediaManager SpellCheck |
| FormatStripper InsertParagraph InsertSnippet Help FindAndReplace DocumentManager |
| PasteFromWordNoFontsNoSizes InsertFormElement InsertDate InsertTime TemplateManager ToggleScreenMode |
| Zoom ModuleManager ToggleDocking RepeatLastCommand AboutDialog |
| shortcut |
| (not required): |
| The key combination for the specific tool. Examples: |
| <tool name="TemplateManager" shortcut="Ctrl+Shift+Alt+N"/> |
| <tool name="LinkManager" shortcut="Ctrl+L" /> |
| <separator> element |
| true/false Indicates whether a separator should appear at current position. |
| <tools> element valid attributes: |
| name (required): This string will identify the toolbar. |
| enabled (not required): true/false (Indicates whether the tool will be available on the client or not) |
| visible (not required): |
| true/false (Indicates whether the tool should appear in the toolbar or not. This toolbar will be available client-side - the property defines only the visibility of the tool.) |
| dockable (not required): |
| true/false (Indicates whether you will be able to drag&drop the toolbar to the docking zones) |
| <module> element valid attributes: |
| (module elements should appear as child elements of an element "modules") |
| name (required): |
| The friendly name of the module. When in floating mode the name will appear in the tool's titlebar. |
| dockable (not required): |
| (Indicates whether you will be able to drag&drop the tool to the docking zones) |
| enabled (not required): |
| (Indicates whether the module will be available on the client or not) |
| visible (not required): |
| (Indicates whether the module should appear in the toolbar or not. This module will be available client-side - the property defines only the visibility of the module. ) |
| <link> element valid attributes: |
| (link elements should appear as child elements of an element "links") |
| name (required): |
| Link/Category Name/Alias |
| href (not required): |
| URL of the link/category |
| target (not required): |
| The target window of the link |
| tooltip (not required): |
| The tooltip for the link |
| <symbol> element valid attributes: |
| (symbol elements should appear as child elements of an element "symbols") |
| value (required): |
| The symbol to be displayed |
| <font> element valid attributes: |
| (font elements should appear as child elements of a tool element with "name" attribute set to "fontNames") |
| name (required): |
| Font Name |
| <class> element valid attributes: |
| (class elements should appear as child elements of an element "classes") |
| name (required): |
| Class Alias |
| value (required): |
| Class Name |
| <paragraph> element valid attributes: |
| (paragraph elements should appear as child elements of an element "paragraphs") |
| name (required): |
| Paragraph Alias |
| value (required): |
| Paragraph Name |
| <color> element valid attributes: |
| (color elements should appear as child elements of an element "colors") |
| value (not required): |
| Hex value of the color |
| <snippet> element valid attributes: |
| (snippet elements should appear as child elements of an element "snippets") |
| name (required): |
| Snippet Alias |
| <language> element valid attributes: |
| (language elements should appear as child elements of an element "Languages") |
| code (required): |
| Language code |
| title (required): |
| Language Title |
| The contextMenus tag in the Tools file allows you to change the default or specify custom context menus for different HTML elements. |
| <contextMenu > element valid attributes: |
| (contextMenu elements should appear as child elements of an element "contextMenus") |
| forElement (required): |
| The HTML element that will call this menu. |
| enabled (required): |
| Defines if this context menu is switched. |
| The example below shows how to attach custom context menus for <A> and <P> elements. |
| <contextMenus> |
| <contextMenu forElement="A" enabled="false"> |
| </contextMenu> |
| <contextMenu forElement="P"> |
| <tool name="JustifyLeft" /> |
| <tool name="JustifyCenter" /> |
| <tool name="JustifyRight" /> |
| <tool name="JustifyFull" /> |
| </contextMenu> |
| </contextMenus> |
| =============================================================================================== --> |
| <telerik:RadEditor ID="sText" runat="server" Skin="Default" Height="300" Width="500" ToolsFile="~/resources/ToolsFile_the-dl-outlet.xml"> |
| </telerik:RadEditor> |