<!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(); }