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
>