SofiaCarRentalEntityDiagrams.
I can't see any note that explain how to get started with it. Witch version of SQLExpress do I have to use?
And do you have any documentation about this demo somewhere?
Thank you
Myriam
<td style="width:"10%" > ag: <br /> <telerik:RadListBox runat="server" ID="RadListBox_Unselectedag" AutoPostBack="false" Width="120px" Height="200px" TransferToID="RadListBox_selectedag" AllowTransfer="true" TransferMode="Copy" AutoPostBackOnTransfer="true" SelectionMode="Multiple" AllowDelete="false" AllowReorder="false" ontransferred="RadListBox_Unselectedag_Transferred" > </telerik:RadListBox> </td> <td style="width:"2%">aselected <br /> <telerik:RadListBox runat="server" ID="RadListBox_selectedag" AllowDelete="true" AllowReorder="false" AutoPostBack="false" SelectionMode="Multiple" Width="140px" Height="200px" > <ItemTemplate> <asp:CheckBox ID="chkAD" runat="server" /> <asp:CheckBox ID="chkAS" runat="server" /> <asp:Label ID="lblagSelected" runat="server" Text='<%# DataBinder.Eval(Container,"Text") %>'></asp:Label> </ItemTemplate> </telerik:RadListBox> </td> <td> protected void RadListBox_Unselectedag_Transferred(object sender, RadListBoxTransferredEventArgs e) { foreach (RadListBoxItem item in e.Items) { item.DataBind(); } }<telerik:RadDatePicker ID="txtDate" Runat="server" Skin="Sunset" FocusedDate="" MinDate="01/01/2006" ShowPopupOnFocus="True" TabIndex="20" Width="155px" MaxDate="01/01/2020"> <Calendar UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False" ViewSelectorText="x" Skin="Sunset"></Calendar> <DatePopupButton ImageUrl="" HoverImageUrl="" TabIndex="20"></DatePopupButton> <DateInput DisplayDateFormat="dd/MM/yyyy" DateFormat="MM/dd/yyyy" TabIndex="20"></DateInput> </telerik:RadDatePicker>txtDate.SelectedDate =DateTime.Now.Date.AddDays(-10);public override void OnActionExecuting(ActionExecutingContext context){ //This compression filter eats server errors. I'd like to see them during debugging. if (!HttpContext.Current.IsDebuggingEnabled) { HttpRequestBase request = context.HttpContext.Request; string acceptEncoding = request.Headers["Accept-Encoding"]; if (string.IsNullOrEmpty(acceptEncoding)) return; acceptEncoding = acceptEncoding.ToUpperInvariant(); HttpResponseBase response = context.HttpContext.Response; if (acceptEncoding.Contains("GZIP")) { response.AppendHeader("Content-encoding", "gzip"); response.Filter = new GZipStream(response.Filter, CompressionMode.Compress); } else if (acceptEncoding.Contains("DEFLATE")) { response.AppendHeader("Content-encoding", "deflate"); response.Filter = new DeflateStream(response.Filter, CompressionMode.Compress); } }}<
telerik:RadScheduler runat="server" ID="RadScheduler2" Width="750px" TimeZoneOffset="03:00:00"
SelectedDate="2007-03-30" DayStartTime="08:00:00" DayEndTime="18:00:00" EnableViewState="false"
StartInsertingInAdvancedForm="true" StartEditingInAdvancedForm="true"
SelectedView="MonthView" DataKeyField="ID" DataSubjectField="Subject" DataStartField="Start"
DataEndField="End" DataReminderField="Reminder" DataRecurrenceField="RecurrenceRule"
DataRecurrenceParentKeyField="RecurrenceParentID" DataSourceID="AppointmentsDataSource"
Reminders-Enabled="false" Skin="Telerik">
<AdvancedForm Modal="false" />
<ResourceTypes>
<telerik:ResourceType KeyField="ID" Name="Room" TextField="RoomName" ForeignKeyField="RoomID"
DataSourceID="RoomsDataSource" />
<telerik:ResourceType KeyField="ID" Name="User" TextField="UserName" ForeignKeyField="UserID"
DataSourceID="UsersDataSource" />
</ResourceTypes>
<TimeSlotContextMenuSettings EnableDefault="true" />
<AppointmentContextMenuSettings EnableDefault="true" />
</telerik:RadScheduler>
<
asp:SqlDataSource ID="AppointmentsDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:Team_ConnectionString %>"
OnSelecting="AppointmentsDataSource_Selecting" OnSelected="AppointmentsDataSource_Selected"
SelectCommand="SELECT * FROM [TEMP_SCHDTEST] WHERE ([Start] < @RangeEnd AND [End] > @RangeStart) OR ([RecurrenceRule] <> '') OR ([RecurrenceParentID] IS NOT NULL)"
InsertCommand="INSERT INTO [TEMP_SCHDTEST] ([Subject], [Start], [End], [UserID],
[RoomID], [RecurrenceRule], [RecurrenceParentID], [Annotations], [Description], [Reminder],
[LastModified]) VALUES (@Subject, @Start, @End, @UserID, @RoomID, @RecurrenceRule,
@RecurrenceParentID, @Annotations, @Description, @Reminder, @LastModified)"
UpdateCommand="UPDATE [Appointments] SET [Subject] = @Subject, [Start] = @Start, [End] = @End,
[UserID] = @UserID, [RoomID] = @RoomID, [RecurrenceRule] = @RecurrenceRule,
[RecurrenceParentID] = @RecurrenceParentID, [Annotations] = @Annotations, [Description] = @Description, [Reminder] = @Reminder, [LastModified] = @LastModified WHERE [ID] = @ID"
DeleteCommand="DELETE FROM [TEMP_SCHDTEST] WHERE [ID] = @ID">
<SelectParameters>
<asp:Parameter Name="RangeStart" Type="DateTime" DefaultValue="1900/1/1" />
<asp:Parameter Name="RangeEnd" Type="DateTime" DefaultValue="2900/1/1" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Subject" Type="String" />
<asp:Parameter Name="Start" Type="DateTime" />
<asp:Parameter Name="End" Type="DateTime" />
<asp:Parameter Name="UserID" Type="Int32" />
<asp:Parameter Name="RoomID" Type="Int32" />
<asp:Parameter Name="RecurrenceRule" Type="String" />
<asp:Parameter Name="RecurrenceParentID" Type="Int32" />
<asp:Parameter Name="Annotations" Type="String" />
<asp:Parameter Name="Description" Type="String" />
<asp:Parameter Name="Reminder" Type="String" />
<asp:Parameter Name="LastModified" Type="String" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="Subject" Type="String" />
<asp:Parameter Name="Start" Type="DateTime" />
<asp:Parameter Name="End" Type="DateTime" />
<asp:Parameter Name="UserID" Type="Int32" />
<asp:Parameter Name="RoomID" Type="Int32" />
<asp:Parameter Name="RecurrenceRule" Type="String" />
<asp:Parameter Name="RecurrenceParentID" Type="Int32" />
<asp:Parameter Name="Annotations" Type="String" />
<asp:Parameter Name="Description" Type="String" />
<asp:Parameter Name="Reminder" Type="String" />
<asp:Parameter Name="LastModified" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
<telerik:RadGrid ID="rgActions" runat="server" Width="100%" ShowHeader="true" OnItemDataBound="rgActions_ItemDataBound" OnItemCommand="rgActions_ItemCommand"> <MasterTableView NoMasterRecordsText="Aucune action" ShowHeadersWhenNoRecords="true" AutoGenerateColumns="false" EditMode="PopUp" DataKeyNames="Idaction" CommandItemDisplay="Top" InsertItemDisplay="Top"> <CommandItemSettings AddNewRecordText="Ajouter une action" RefreshText="Actualiser" /> <EditFormSettings PopUpSettings-Width="620px" PopUpSettings-Modal="true"></EditFormSettings> <RowIndicatorColumn> <HeaderStyle Width="20px"></HeaderStyle> </RowIndicatorColumn> <ExpandCollapseColumn> <HeaderStyle Width="20px"></HeaderStyle> </ExpandCollapseColumn> <Columns> <telerik:GridBoundColumn DataField="Idaction" HeaderText="Idaction" ReadOnly="True" UniqueName="Idaction" ForceExtractValue="InEditMode" Visible="False"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn DataField="DateSaisie" HeaderText="Date saisie" UniqueName="DateSaisie" ForceExtractValue="InEditMode"> <HeaderStyle Width="100px"/> <ItemStyle Width="100px" VerticalAlign="Top"/> <ItemTemplate> <asp:Label ID="lblDateSaisie" runat="server" Text='<%# Eval("DateSaisie", "{0:dd/MM/yyyy}") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:Label ID="lblDateSaisie" runat="server" Text='<%# Eval("DateRealisation")==DBNull.Value ? DateTime.Now.Date.ToShortDateString() : Eval("DateSaisie", "{0:dd/MM/yyyy}") %>'></asp:Label> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="Description" HeaderText="Description" UniqueName="Description" ForceExtractValue="InEditMode"> <ItemStyle VerticalAlign="Top"/> <ItemTemplate> <asp:Label ID="lblDescription" runat="server" Text='<%# Eval("DescriptionHtml") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadTextBox ID="tbDescription" runat="server" Width="500px" Height="50px" TextMode="MultiLine" MaxLength="500" Text='<%# Eval("Description") %>'></telerik:RadTextBox> <asp:RequiredFieldValidator ID="rfvDescription" runat="server" ErrorMessage="*" ControlToValidate="tbDescription" Display="Dynamic"></asp:RequiredFieldValidator> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="DatePrevue" HeaderText="Date prévue" UniqueName="DatePrevue" ForceExtractValue="InEditMode"> <HeaderStyle Width="100px"/> <ItemStyle Width="100px" VerticalAlign="Top"/> <ItemTemplate> <asp:Label ID="lblDatePrevue" runat="server" Text='<%# Eval("DatePrevue", "{0:dd/MM/yyyy}") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadDatePicker ID="dpDatePrevue" runat="server" SelectedDate='<%# Eval("DatePrevue")==DBNull.Value ? DateTime.Now.Date : Eval("DatePrevue") %>'></telerik:RadDatePicker> <asp:RequiredFieldValidator ID="rfvDatePrevue" runat="server" ErrorMessage="*" ControlToValidate="dpDatePrevue" Display="Dynamic"></asp:RequiredFieldValidator> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="Personnes" HeaderText="Personne(s)" UniqueName="Personnes" ForceExtractValue="InEditMode"> <HeaderStyle Width="30%"/> <ItemStyle Width="30%" VerticalAlign="Top"/> <ItemTemplate> <asp:Label ID="lblPersonnes" runat="server" Text='<%# Eval("Personnes") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadTextBox ID="tbPersonnes" runat="server" Width="500px" Height="30px" TextMode="MultiLine" MaxLength="200" Text='<%# Eval("Personnes") %>'></telerik:RadTextBox> <asp:RequiredFieldValidator ID="rfvPersonnes" runat="server" ErrorMessage="*" ControlToValidate="tbPersonnes" Display="Dynamic"></asp:RequiredFieldValidator> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="DateRealisation" HeaderText="Date réalisation" UniqueName="DateRealisation" ForceExtractValue="InEditMode"> <HeaderStyle Width="100px"/> <ItemStyle Width="100px" VerticalAlign="Top"/> <ItemTemplate> <asp:Label ID="lblDateRealisation" runat="server" Text='<%# Eval("DateRealisation", "{0:dd/MM/yyyy}") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadDatePicker ID="dpDateRealisation" runat="server" SelectedDate='<%# Eval("DateRealisation")==DBNull.Value ? DateTime.Now.Date : Eval("DateRealisation") %>'></telerik:RadDatePicker> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridEditCommandColumn UniqueName="EditCommandColumn" ButtonType="ImageButton" EditText="Editer" UpdateText="Valider" CancelText="Annuler" InsertText="Ajouter" EditImageUrl="Resources/Images/Edit.gif" UpdateImageUrl="Resources/Images/Update.gif" CancelImageUrl="Resources/Images/Cancel.gif" InsertImageUrl="Resources/Images/Update.gif"> <HeaderStyle Width="40px" /> <ItemStyle Width="40px" VerticalAlign="Top"/> </telerik:GridEditCommandColumn> </Columns> <EditFormSettings> <EditColumn ButtonType="ImageButton" CancelText="Annuler" InsertText="Ajouter" UpdateText="Valider" CancelImageUrl="Resources/images/Cancel.gif" UpdateImageUrl="Resources/images/Update.gif" InsertImageUrl="Resources/images/Update.gif"> </EditColumn> </EditFormSettings> <CommandItemTemplate> <asp:ImageButton ID="btnImageAddAction" runat="server" CommandName="InitInsert" ImageUrl="Resources/Images/Add.gif" style="vertical-align:middle;" /> <asp:LinkButton ID="btnAddAction" runat="server" CommandName="InitInsert" style="vertical-align:middle;">Ajouter une action</asp:LinkButton> </CommandItemTemplate> </MasterTableView> <ClientSettings> <ClientEvents OnPopUpShowing="PopUpShowing" /> <Selecting AllowRowSelect="true" /> </ClientSettings> <FilterMenu Skin="Office2007" EnableTheming="True"> <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> </FilterMenu> </telerik:RadGrid>