Telerik RadScheduler - Zero Code to Support DataBase Source CRUD + reminder

本文链接：https://blog.csdn.net/riverlau/article/details/7048104

http://tv.telerik.com/watch/radtips/episode/customizing-radscheduler-appointments-with-resources

Demo Appearance

Database Schema:

Sample Data:

dbo.Appointment

ID Subject Description Start End RecurrenceRule RecurrenceParentID Reminder Annotations TestResourceId
1 .NET User Group Meeting NULL 2011-11-14 12:00:00.000 2011-11-15 12:00:00.000 NULL NULL NULL NULL 1
2 Scrum Training !!! www 2011-11-30 12:00:00.000 2011-12-02 12:00:00.000 NULL NULL NULL NULL 1
3 Integration Partners Conference Call NULL 2011-11-22 12:00:00.000 2011-11-25 12:00:00.000 NULL NULL NULL NULL 2
4 DevConnect conference NULL 2011-11-11 12:00:00.000 2011-11-15 12:00:00.000 NULL NULL NULL NULL 2
5 DevMedia conference NULL 2011-11-01 06:30:00.000 2011-11-01 07:30:00.000 DTSTART:20111101T063000Z DTEND:20111101T073000Z RRULE:FREQ=DAILY;UNTIL=20111120T210000Z;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR EXDATE:20111116T063000Z NULL NULL NULL 3
7 DevMedia conference 2011-11-23 06:30:00.000 2011-11-23 07:30:00.000 5 NULL 3
9 yes 2011-12-06 00:00:00.000 2011-12-07 00:00:00.000 NULL BEGIN:VALARM TRIGGER:-PT10M X-TELERIK-UID:7998b08d-2595-4e14-8756-d988c8f8b6d9 END:VALARM NULL 1
10 yes 2011-11-21 00:00:00.000 2011-11-22 00:00:00.000 NULL BEGIN:VALARM TRIGGER:-PT5M X-TELERIK-UID:bb06f789-8fbb-4050-af24-4eab2b24d0dd END:VALARM NULL 2

dbo.TestResource

Id Description
1 resource A
2 resource B
3 resource C
4 resource D
5 resource E

Add RadScheduler Control And Config DataSource

Config RadScheduler Control Resource DataSource

Source Code:

<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
    CodeBehind="Default.aspx.cs" Inherits="telerikScheduler._Default" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
    <h2>
        Welcome to ASP.NET!
    </h2>
    <p>
        To learn more about ASP.NET visit <a href="http://www.asp.net" title="ASP.NET Website">www.asp.net</a>.
    </p>
    <p>
        You can also find <a href="http://go.microsoft.com/fwlink/?LinkID=152368&clcid=0x409"
            title="MSDN ASP.NET Docs">documentation on ASP.NET at MSDN</a>.
    </p>
    <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
    </telerik:RadScriptManager>
    <telerik:RadScheduler ID="RadScheduler1" runat="server" 
        DataDescriptionField="Description" DataEndField="End" DataKeyField="ID" 
        DataRecurrenceField="RecurrenceRule" 
        DataRecurrenceParentKeyField="RecurrenceParentID" DataReminderField="Reminder" 
        DataSourceID="EntityDataSource1" DataStartField="Start" 
        DataSubjectField="Subject" EnableDescriptionField="True" Height=""
        Reminders-Enabled="true">
        <ResourceTypes>
            <telerik:ResourceType DataSourceID="EntityDataSource2" 
                ForeignKeyField="TestResourceId" KeyField="Id" Name="Resource Type 0" 
                TextField="Description" />
        </ResourceTypes>
            <AdvancedForm Modal="true" />
            <Reminders Enabled="true" />
            <TimeSlotContextMenuSettings EnableDefault="true" />
            <AppointmentContextMenuSettings EnableDefault="true" />
    </telerik:RadScheduler>
    <asp:EntityDataSource ID="EntityDataSource2" runat="server" 
        ConnectionString="name=IAppointmentEntities" 
        DefaultContainerName="IAppointmentEntities1" EnableFlattening="False" 
        EntitySetName="TestResources">
    </asp:EntityDataSource>
    <asp:EntityDataSource ID="EntityDataSource1" runat="server" 
        ConnectionString="name=IAppointmentEntities" 
        DefaultContainerName="IAppointmentEntities1" EnableDelete="True" 
        EnableInsert="True" EnableUpdate="True" 
        EntitySetName="Appointments">
    </asp:EntityDataSource>
</asp:Content>