

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