<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<
html
xmlns
=
"http://www.w3.org/1999/xhtml"
>
<
head
runat
=
"server"
>
<
title
>Test Telerik boxes</
title
>
<
style
type
=
"text/css"
>
/* The following CSS needs to be copied to the page to produce textbox-like RadEditor */
.reWrapper_corner, .reWrapper_center, .reToolZone,
.reToolCell,
.reBottomZone,
.reModule
{
display: none !important;
}
.reLeftVerticalSide,
.reRightVerticalSide
{
background: white !important;
}
.reContentCell
{
border-width: 0 !important;
width:100%;
}
</
style
>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
runat
=
"server"
EnableScriptCombine
=
"true"
OutputCompression
=
"AutoDetect"
>
<
Scripts
>
<%--Needed for JavaScript IntelliSense in VS2010--%>
<%--For VS2008 replace RadScriptManager with ScriptManager--%>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.Core.js"
/>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.jQuery.js"
/>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.jQueryInclude.js"
/>
</
Scripts
>
</
telerik:RadScriptManager
>
<
div
> </
div
><
div
> </
div
>
<
div
>1:</
div
>
<
div
>
<
telerik:RadEditor
ID
=
"RadEditor0"
runat
=
"server"
EditModes
=
"Design"
AutoResizeHeight
=
"true"
ContentAreaMode
=
"Div"
Height
=
"30px"
ToolsWidth
=
"685px"
>
<
Content
></
Content
>
</
telerik:RadEditor
>
</
div
>
<
div
> </
div
><
div
> </
div
>
<
div
>2:</
div
>
<
div
>
<
telerik:RadEditor
ID
=
"RadEditor1"
runat
=
"server"
EditModes
=
"Design"
AutoResizeHeight
=
"true"
ContentAreaMode
=
"Div"
Height
=
"30px"
ToolsWidth
=
"685px"
>
</
telerik:RadEditor
>
</
div
>
<
div
> </
div
><
div
> </
div
>
<
div
>3:</
div
>
<
div
>
<
telerik:RadEditor
ID
=
"RadEditor2"
runat
=
"server"
EditModes
=
"Design"
AutoResizeHeight
=
"true"
ContentAreaMode
=
"Div"
Height
=
"30px"
ToolsWidth
=
"685px"
>
</
telerik:RadEditor
>
</
div
>
<
div
>4:</
div
>
<
div
>
<
telerik:RadEditor
ID
=
"RadEditor3"
runat
=
"server"
EditModes
=
"Design"
AutoResizeHeight
=
"true"
ContentAreaMode
=
"Div"
Height
=
"30px"
ToolsWidth
=
"685px"
>
</
telerik:RadEditor
>
</
div
>
<
div
>5:</
div
>
<
div
>
<
telerik:RadEditor
ID
=
"RadEditor4"
runat
=
"server"
EditModes
=
"Design"
AutoResizeHeight
=
"true"
ContentAreaMode
=
"Div"
Height
=
"30px"
ToolsWidth
=
"685px"
>
</
telerik:RadEditor
>
</
div
>
<
div
>6:</
div
>
<
div
>
<
telerik:RadEditor
ID
=
"RadEditor5"
runat
=
"server"
EditModes
=
"Design"
AutoResizeHeight
=
"true"
ContentAreaMode
=
"Div"
Height
=
"30px"
ToolsWidth
=
"685px"
>
</
telerik:RadEditor
>
</
div
>
<
div
>7:</
div
>
<
div
>
<
telerik:RadEditor
ID
=
"RadEditor6"
runat
=
"server"
EditModes
=
"Design"
AutoResizeHeight
=
"true"
ContentAreaMode
=
"Div"
Height
=
"30px"
ToolsWidth
=
"685px"
>
</
telerik:RadEditor
>
</
div
>
<
div
>8:</
div
>
<
div
>
<
telerik:RadEditor
ID
=
"RadEditor7"
runat
=
"server"
EditModes
=
"Design"
AutoResizeHeight
=
"true"
ContentAreaMode
=
"Div"
Height
=
"30px"
ToolsWidth
=
"685px"
>
</
telerik:RadEditor
>
</
div
>
<
div
>9:</
div
>
<
div
>
<
telerik:RadEditor
ID
=
"RadEditor8"
runat
=
"server"
EditModes
=
"Design"
AutoResizeHeight
=
"true"
ContentAreaMode
=
"Div"
Height
=
"30px"
ToolsWidth
=
"685px"
>
</
telerik:RadEditor
>
</
div
>
<
div
>10:</
div
>
<
div
>
<
telerik:RadEditor
ID
=
"RadEditor9"
runat
=
"server"
EditModes
=
"Design"
AutoResizeHeight
=
"true"
ContentAreaMode
=
"Div"
Height
=
"30px"
ToolsWidth
=
"685px"
>
</
telerik:RadEditor
>
</
div
>
<
div
>11:</
div
>
<
div
>
<
telerik:RadEditor
ID
=
"RadEditor10"
runat
=
"server"
EditModes
=
"Design"
AutoResizeHeight
=
"true"
ContentAreaMode
=
"Div"
Height
=
"30px"
ToolsWidth
=
"685px"
>
</
telerik:RadEditor
>
</
div
>
<
div
>12:</
div
>
<
div
>
<
telerik:RadEditor
ID
=
"RadEditor11"
runat
=
"server"
EditModes
=
"Design"
AutoResizeHeight
=
"true"
ContentAreaMode
=
"Div"
Height
=
"30px"
ToolsWidth
=
"685px"
>
</
telerik:RadEditor
>
</
div
>
<
div
>13:</
div
>
<
div
>
<
telerik:RadEditor
ID
=
"RadEditor12"
runat
=
"server"
EditModes
=
"Design"
AutoResizeHeight
=
"true"
ContentAreaMode
=
"Div"
Height
=
"30px"
ToolsWidth
=
"685px"
>
</
telerik:RadEditor
>
</
div
>
<
div
>14:</
div
>
<
div
>
<
telerik:RadEditor
ID
=
"RadEditor13"
runat
=
"server"
EditModes
=
"Design"
AutoResizeHeight
=
"true"
ContentAreaMode
=
"Div"
Height
=
"30px"
ToolsWidth
=
"685px"
>
</
telerik:RadEditor
>
</
div
>
<
div
>15:</
div
>
<
div
>
<
telerik:RadEditor
ID
=
"RadEditor14"
runat
=
"server"
EditModes
=
"Design"
AutoResizeHeight
=
"true"
ContentAreaMode
=
"Div"
Height
=
"30px"
ToolsWidth
=
"685px"
>
</
telerik:RadEditor
>
</
div
>
<
div
>16:</
div
>
<
div
>
<
telerik:RadEditor
ID
=
"RadEditor15"
runat
=
"server"
EditModes
=
"Design"
AutoResizeHeight
=
"true"
ContentAreaMode
=
"Div"
Height
=
"30px"
ToolsWidth
=
"685px"
>
</
telerik:RadEditor
>
</
div
>
<
div
>17:</
div
>
<
div
>
<
telerik:RadEditor
ID
=
"RadEditor16"
runat
=
"server"
EditModes
=
"Design"
AutoResizeHeight
=
"true"
ContentAreaMode
=
"Div"
Height
=
"30px"
ToolsWidth
=
"685px"
>
</
telerik:RadEditor
>
</
div
>
<
div
>18:</
div
>
<
div
>
<
telerik:RadEditor
ID
=
"RadEditor17"
runat
=
"server"
EditModes
=
"Design"
AutoResizeHeight
=
"true"
ContentAreaMode
=
"Div"
Height
=
"30px"
ToolsWidth
=
"685px"
>
</
telerik:RadEditor
>
</
div
>
</
form
>
</
body
>
</
html
>
var
element = document.all ? editor.get_document().body : editor.get_document();
$telerik.addExternalHandler(element,
"blur"
,
this
._onBlurDelegate);
I followed the exact example as given in the demo - http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/filtering/filter-templates/defaultvb.aspx?show-source=true
When the radgrid is displayed, the date is given as 1/16/1520, see attached image.
When tried to filter using the raddatepicker, it takes in the input as M/d/yyyy (e.g. 4/3/2015) format and gives the OracleSQL error "month not valid"
I tried to set the date format in the radgrid_columncreated -
CType(e.Column, GridBoundColumn).DataFormatString = "{0:MM\/dd\/yyyy}"
CType(e.Column, GridBoundColumn).DataFormatString = "{0:d}"
and other rad date formats. Still no luck.
With the rad filter template the date formats are wrong but with the basic filter or no filter the Radgrid is good.
private
RecurrenceRule CreateRecurrenceRule(Appointment appq, ExchangeService service)
{
var pattern = (Microsoft.Exchange.WebServices.Data.Recurrence.IntervalPattern)appq.Recurrence;
var interval = pattern.Interval;
var schedulerPattern =
new
RecurrencePattern();
var schedulerRange =
new
RecurrenceRange { Start = appq.Start, EventDuration = appq.Duration };
if
(!appq.Recurrence.HasEnd) { }
else
{
if
(appq.Recurrence.NumberOfOccurrences !=
null
)
schedulerRange.MaxOccurrences = Convert.ToInt32(appq.Recurrence.NumberOfOccurrences);
else
if
(appq.Recurrence.EndDate !=
null
)
schedulerRange.RecursUntil = Convert.ToDateTime(appq.Recurrence.EndDate).Date.AddMinutes(appq.Duration.Minutes);
if
(appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.DailyPattern) || appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.DailyRegenerationPattern))
{
schedulerPattern.Frequency = RecurrenceFrequency.Daily;
schedulerPattern.Interval = interval;
}
else
if
(appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.WeeklyPattern) || appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.WeeklyRegenerationPattern))
{
var weekpattern = (Microsoft.Exchange.WebServices.Data.Recurrence.WeeklyPattern)appq.Recurrence;
schedulerPattern.Frequency = RecurrenceFrequency.Weekly;
schedulerPattern.Interval = interval;
var dayOfWeekMask =
new
RecurrenceDay();
foreach
(var day
in
weekpattern.DaysOfTheWeek)
{
switch
(day)
{
case
DayOfTheWeek.Monday: dayOfWeekMask = dayOfWeekMask | RecurrenceDay.Monday;
break
;
case
DayOfTheWeek.Tuesday: dayOfWeekMask = dayOfWeekMask | RecurrenceDay.Tuesday;
break
;
case
DayOfTheWeek.Wednesday: dayOfWeekMask = dayOfWeekMask | RecurrenceDay.Wednesday;
break
;
case
DayOfTheWeek.Thursday: dayOfWeekMask = dayOfWeekMask | RecurrenceDay.Thursday;
break
;
case
DayOfTheWeek.Friday: dayOfWeekMask = dayOfWeekMask | RecurrenceDay.Friday;
break
;
case
DayOfTheWeek.Saturday: dayOfWeekMask = dayOfWeekMask | RecurrenceDay.Saturday;
break
;
case
DayOfTheWeek.Sunday: dayOfWeekMask = dayOfWeekMask | RecurrenceDay.Sunday;
break
;
}
}
schedulerPattern.DaysOfWeekMask = dayOfWeekMask;
}
else
if
(appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.MonthlyPattern) || appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.MonthlyRegenerationPattern))
{
var monthpattern = (Microsoft.Exchange.WebServices.Data.Recurrence.MonthlyPattern)appq.Recurrence;
schedulerPattern.Frequency = RecurrenceFrequency.Monthly;
schedulerPattern.Interval = interval;
schedulerPattern.DayOfMonth = monthpattern.DayOfMonth;
}
else
if
(appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.RelativeMonthlyPattern))
{
var monthpattern = (Microsoft.Exchange.WebServices.Data.Recurrence.RelativeMonthlyPattern)appq.Recurrence;
schedulerPattern.Frequency = RecurrenceFrequency.Monthly;
schedulerPattern.Interval = interval;
schedulerPattern.DaysOfWeekMask = GetDayOfWeekMask(monthpattern.DayOfTheWeek);
schedulerPattern.DayOrdinal = GetDayOfTheWeekIndex(monthpattern.DayOfTheWeekIndex);
}
else
if
(appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.YearlyPattern) || appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.YearlyRegenerationPattern))
{
var yearpattern = (Microsoft.Exchange.WebServices.Data.Recurrence.YearlyPattern)appq.Recurrence;
schedulerPattern.Frequency = RecurrenceFrequency.Yearly;
schedulerPattern.DayOfMonth = yearpattern.DayOfMonth;
schedulerPattern.Month = GetRecurrenceMonth(yearpattern.Month);
}
else
if
(appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.RelativeYearlyPattern))
{
var yearpattern = (Microsoft.Exchange.WebServices.Data.Recurrence.RelativeYearlyPattern)appq.Recurrence;
schedulerPattern.Frequency = RecurrenceFrequency.Yearly;
schedulerPattern.DaysOfWeekMask = GetDayOfWeekMask(yearpattern.DayOfTheWeek);
schedulerPattern.DayOrdinal = GetDayOfTheWeekIndex(yearpattern.DayOfTheWeekIndex);
schedulerPattern.Month = GetRecurrenceMonth(yearpattern.Month);
}
var rrule = RecurrenceRule.FromPatternAndRange(schedulerPattern, schedulerRange);
if
(appq.ModifiedOccurrences !=
null
)
{
foreach
(var item
in
appq.ModifiedOccurrences)
{
rrule.Exceptions.Add(
new
DateTime(Convert.ToInt32(item.OriginalStart.Year), Convert.ToInt32(item.OriginalStart.Month), Convert.ToInt32(item.OriginalStart.Day), Convert.ToInt32(item.OriginalStart.Hour), Convert.ToInt32(item.OriginalStart.Minute), Convert.ToInt32(item.OriginalStart.Second)).ToLocalTime());
}
}
if
(appq.DeletedOccurrences ==
null
)
return
rrule;
foreach
(var item
in
appq.DeletedOccurrences)
{
rrule.Exceptions.Add(
new
DateTime(Convert.ToInt32(item.OriginalStart.Year), Convert.ToInt32(item.OriginalStart.Month), Convert.ToInt32(item.OriginalStart.Day), Convert.ToInt32(item.OriginalStart.Hour), Convert.ToInt32(item.OriginalStart.Minute), Convert.ToInt32(item.OriginalStart.Second)).ToLocalTime());
}
return
rrule;
}
return
null
;
}
<
telerik:RadGrid
AutoGenerateColumns
=
"False"
ID
=
"RadGrid1"
AllowFilteringByColumn
=
"True"
AllowPaging
=
"True"
AllowSorting
=
"True"
runat
=
"server"
OnItemCommand
=
"RadGrid1_ItemCommand"
OnItemCreated
=
"RadGrid1_ItemCreated"
EnableLinqExpressions
=
"true"
HtmlEncode
=
"true"
OnNeedDataSource
=
"RadGrid1_NeedDataSource"
GroupByExpression
=
"JobStatusID Group By JobStatusID"
ShowGroupPanel
=
"True"
CellSpacing
=
"-1"
GridLines
=
"Both"
Skin
=
"Office2010Silver"
EnableViewState
=
"true"
Width
=
"100%"
>
<
PagerStyle
Mode
=
"NextPrevAndNumeric"
/>
<
GroupingSettings
CaseSensitive
=
"false"
/>
<
ClientSettings
AllowKeyboardNavigation
=
"true"
>
</
ClientSettings
>
<
ExportSettings
OpenInNewWindow
=
"true"
FileName
=
"i-Dispatch General Report"
>
<
Pdf
PageHeight
=
"210mm"
PageWidth
=
"297mm"
DefaultFontFamily
=
"Arial Unicode MS"
PageTopMargin
=
"45mm"
BorderStyle
=
"Medium"
BorderColor
=
"#666666"
PaperSize
=
"A4"
>
</
Pdf
>
</
ExportSettings
>
<
MasterTableView
Width
=
"100%"
DataKeyNames
=
"JobID"
HierarchyLoadMode
=
"ServerOnDemand"
>
<
Columns
>
<
telerik:GridMaskedColumn
DataField
=
"JobID"
HeaderText
=
"JobID#"
FilterControlWidth
=
"50px"
AutoPostBackOnFilter
=
"false"
CurrentFilterFunction
=
"EqualTo"
FilterDelay
=
"2000"
ShowFilterIcon
=
"false"
Mask
=
"#####"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
</
ColumnValidationSettings
>
</
telerik:GridMaskedColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Customer Ref No"
DataField
=
"JobCustomerRefNo"
UniqueName
=
"JobCustomerRefNo"
SortExpression
=
"JobCustomerRefNo"
HeaderStyle-Width
=
"180px"
FilterControlAltText
=
"Filter JobCustomerRefNo column"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"JobTitle"
FilterControlAltText
=
"Filter JobTitle column"
HeaderText
=
"Job Title"
SortExpression
=
"JobTitle"
UniqueName
=
"JobTitle"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridDateTimeColumn
DataField
=
"JobBookedDate"
PickerType
=
"DatePicker"
EnableTimeIndependentFiltering
=
"true"
DataFormatString
=
"{0:dd/MM/yyyy HH:mm }"
DataType
=
"System.DateTime"
FilterControlAltText
=
"Filter JobBookedDate column"
HeaderText
=
"Job Booked Date"
SortExpression
=
"JobBookedDate"
UniqueName
=
"JobBookedDate"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridDateTimeColumn
>
<
telerik:GridBoundColumn
DataField
=
"JobAddress1"
FilterControlAltText
=
"Filter JobAddress1 column"
HeaderText
=
"Address"
SortExpression
=
"JobAddress1"
UniqueName
=
"JobAddress1"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"JobSuburb"
FilterControlAltText
=
"Filter JobSuburb column"
HeaderText
=
"Suburb"
SortExpression
=
"JobSuburb"
UniqueName
=
"JobSuburb"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"JobPostCode"
FilterControlAltText
=
"Filter JobPostCode column"
HeaderText
=
"PostCode"
SortExpression
=
"JobPostCode"
UniqueName
=
"JobPostCode"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"JobState"
FilterControlAltText
=
"Filter JobState column"
HeaderText
=
"State"
SortExpression
=
"JobState"
UniqueName
=
"JobState"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridTemplateColumn
DataField
=
"JobStatusID"
HeaderText
=
"Status Type"
UniqueName
=
"JobStatusID"
HeaderStyle-Width
=
"200px"
SortExpression
=
"JobStatusID"
>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"comboJobStatus"
DataTextField
=
"JobStatusName"
DataValueField
=
"JobStatusID"
Height
=
"100px"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("JobStatusID").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="JobStatusIndexChanged">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock3"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function JobStatusIndexChanged(sender, args) {
var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("JobStatusID", args.get_item().get_value(), "EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
<
ItemTemplate
>
<%# Eval("JobStatus") %>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"ClientID"
HeaderText
=
"Client"
UniqueName
=
"ClientID"
HeaderStyle-Width
=
"200px"
SortExpression
=
"ClientID"
>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"comboClient"
DataTextField
=
"ClientName"
DataValueField
=
"ClientID"
Height
=
"100px"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("ClientID").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="ClientIndexChanged">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock2"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function ClientIndexChanged(sender, args) {
var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("ClientID", args.get_item().get_value(), "EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
<
ItemTemplate
>
<%# Eval("Client") %>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"AssignedStaffID"
HeaderText
=
"Staff"
UniqueName
=
"AssignedStaffID"
HeaderStyle-Width
=
"200px"
SortExpression
=
"AssignedStaffID"
>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"comboStaff"
DataTextField
=
"StaffName"
DataValueField
=
"StaffID"
Height
=
"100px"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("AssignedStaffID").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="StaffIndexChanged">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock10"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function StaffIndexChanged(sender, args) {
var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("AssignedStaffID", args.get_item().get_value(), "EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
<
ItemTemplate
>
<%# Eval("AssignedStaff") %>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
</
Columns
>
<
NestedViewTemplate
>
<
asp:Panel
runat
=
"server"
ID
=
"InnerContainer"
CssClass
=
"viewWrap"
Visible
=
"false"
>
<
telerik:RadGrid
runat
=
"server"
ID
=
"JobStatusGrid"
OnNeedDataSource
=
"JobStatusGrid_NeedDataSource"
>
<
MasterTableView
ShowHeader
=
"true"
AutoGenerateColumns
=
"False"
AllowPaging
=
"true"
DataKeyNames
=
"JobStatusHistoryID"
PageSize
=
"7"
HierarchyLoadMode
=
"Client"
>
<
Columns
>
<
telerik:GridBoundColumn
HeaderText
=
"Status Type"
HeaderButtonType
=
"TextButton"
DataField
=
"JobStatus"
UniqueName
=
"JobStatusID"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Created By"
HeaderButtonType
=
"TextButton"
DataField
=
"CreatedBy"
UniqueName
=
"CreatedBy"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Created On"
HeaderButtonType
=
"TextButton"
DataField
=
"CreatedOn"
UniqueName
=
"CreatedOn"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
</
asp:Panel
>
</
NestedViewTemplate
>
</
MasterTableView
>
<
ClientSettings
AllowDragToGroup
=
"true"
>
<
Scrolling
AllowScroll
=
"True"
UseStaticHeaders
=
"True"
/>
</
ClientSettings
>
</
telerik:RadGrid
>
protected
void
btnGeneralReportPDF_Click(
object
sender, ImageClickEventArgs e)
{
//RadGrid1.ExportSettings.ExportOnlyData = true;
RadGrid1.ExportSettings.OpenInNewWindow =
true
;
//RadGrid1.ExportSettings.IgnorePaging = true;
headerMiddleCell = headerMiddleCell.Replace(
"<$companyname$>"
, "company name");
headerMiddleCell = headerMiddleCell.Replace(
"<$reportname$>"
,
"Report"
);
headerMiddleCell = headerMiddleCell.Replace(
"<$daterange$>"
, "1-1-2015 / 2-2-2015"
);
RadGrid1.ExportSettings.Pdf.PageHeader.MiddleCell.Text = headerMiddleCell;
// to get lanscape orientation
RadGrid1.ExportSettings.Pdf.PageHeight = Unit.Parse(
"162mm"
);
RadGrid1.ExportSettings.Pdf.PageWidth = Unit.Parse(
"600mm"
);
foreach
(GridDataItem gi
in
RadGrid1.MasterTableView.Items)
{
gi.Expanded =
true
;
if
(gi.HasChildItems)
{
RadGrid rgHeader = (RadGrid)gi.ChildItem.NestedViewCell.Controls[0].Controls[1].Controls[1];
rgHeader.Rebind();
}
}
RadGrid1.MasterTableView.HierarchyDefaultExpanded =
true
;
//RadGrid1.Rebind();
RadGrid1.MasterTableView.ExportToPdf();
}