or
<
telerik:GridTemplateColumn
DataField
=
"OrderQuantity"
HeaderText
=
"Order Quantity"
UniqueName
=
"OrderQuantity"
Visible
=
"true"
>
<
InsertItemTemplate
>
<
telerik:RadTextBox
ID
=
"RadtxtOrderQuantity"
runat
=
"server"
Text='<%# Bind("OrderQuantity") %>' >
</
telerik:RadTextBox
>
</
InsertItemTemplate
>
<
EditItemTemplate
>
<
telerik:RadTextBox
ID
=
"RadtxtOrderQuantity"
runat
=
"server"
Text='<%# Eval("OrderQuantity") %>' >
</
telerik:RadTextBox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"UnitPrice"
HeaderText
=
"Unit Price"
UniqueName
=
"UnitPrice"
Visible
=
"true"
>
<
InsertItemTemplate
>
<
telerik:RadTextBox
ID
=
"RadtxtUnitPrice"
runat
=
"server"
Text='<%# Bind("UnitPrice") %>' >
</
telerik:RadTextBox
>
</
InsertItemTemplate
>
<
EditItemTemplate
>
<
telerik:RadTextBox
ID
=
"RadtxtUnitPrice"
runat
=
"server"
Text='<%# Eval("UnitPrice") %>' >
</
telerik:RadTextBox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridNumericColumn
DataField
=
"FinalPrice"
HeaderText
=
"Final Price"
UniqueName
=
"FinalPrice"
>
</
telerik:GridNumericColumn
>
setInterval(function () { $find("<%= RamMaster.ClientID %>").ajaxRequest("Reminder"); }, 10000);
<
div
>
<
table
cellpadding
=
"0"
cellspacing
=
"0"
border
=
"0"
>
<
tr
>
<
td
>
<
telerik:RadNotification
ID
=
"n1"
runat
=
"server"
Text
=
"Initial text"
Position
=
"Center"
Style
=
"z-index: 0"
AutoCloseDelay
=
"0"
Width
=
"700px"
Title
=
"Reminder"
>
<
ContentTemplate
>
<
table
width
=
"100%"
cellpadding
=
"0"
cellspacing
=
"0"
border
=
"0"
>
<
tr
>
<
td
align
=
"right"
>
<
span
style
=
"color: Red"
>*</
span
><
strong
>Move the mouse over a Message to see more details</
strong
>
</
td
>
</
tr
>
<
tr
>
<
td
>
<
telerik:RadAjaxPanel
ID
=
"rap"
runat
=
"server"
>
<
telerik:RadGrid
ID
=
"gvReminder"
runat
=
"server"
Width
=
"100%"
AutoGenerateColumns
=
"false"
PageSize
=
"10"
ShowStatusBar
=
"true"
ClientIDMode
=
"AutoID"
AllowPaging
=
"true"
AllowSorting
=
"false"
Skin
=
"Office2007"
OnNeedDataSource
=
"gvReminder_NeedDataSource"
>
<
MasterTableView
DataKeyNames
=
"ReminderID"
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"ReminderID"
Visible
=
"false"
/>
<
telerik:GridTemplateColumn
HeaderText
=
"Message"
HeaderStyle-Font-Bold
=
"true"
>
<
ItemTemplate
>
<
asp:HyperLink
ID
=
"targetControl"
runat
=
"server"
Text='<%#TextLimitString(Eval("Message").ToString()) %>'></
asp:HyperLink
>
<
telerik:RadToolTip
ID
=
"tltRttip"
runat
=
"server"
TargetControlID
=
"targetControl"
AutoCloseDelay
=
"0"
ShowEvent
=
"OnMouseOver"
Skin
=
"Office2007"
>
<
div
>
<
div
style
=
"margin: 0 auto; text-align: center"
>
New Note From <
b
>
<%# GetUserName(Eval("CreatedBy").ToString()) %></
b
></
div
>
<
br
/>
<
div
style
=
"float: left; width: 100px"
>
<
b
>Patient Name:</
b
></
div
>
<
div
>
<%#Eval("PatName")%>
</
div
>
<
br
/>
<
div
style
=
"float: left; width: 100px"
>
<
b
>Message:</
b
></
div
>
<
div
>
<%#Eval("Message") %></
div
>
</
div
>
</
telerik:RadToolTip
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
ItemStyle-HorizontalAlign
=
"Center"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderStyle-Font-Bold
=
"true"
HeaderText
=
"Snooze"
>
<
ItemTemplate
>
<
telerik:RadComboBox
ID
=
"RcbSnooze"
runat
=
"server"
Style
=
"z-index: 100000"
>
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"1 Min"
Value
=
"1"
Selected
=
"true"
/>
<
telerik:RadComboBoxItem
Text
=
"5 Min"
Value
=
"5"
/>
<
telerik:RadComboBoxItem
Text
=
"10 Min"
Value
=
"10"
/>
<
telerik:RadComboBoxItem
Text
=
"20 Min"
Value
=
"20"
/>
<
telerik:RadComboBoxItem
Text
=
"30 Min"
Value
=
"30"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadButton
ID
=
"btnSnooze"
runat
=
"server"
Text
=
"Snooze"
OnClick
=
"btnID_Click"
CommandName='<%# Eval("ReminderID") %>' CommandArgument="False" />
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
ItemStyle-HorizontalAlign
=
"Center"
>
<
ItemTemplate
>
<
telerik:RadButton
ID
=
"btnID"
runat
=
"server"
Text
=
"Dismiss"
OnClick
=
"btnID_Click"
CommandName='<%# Eval("ReminderID") %>' CommandArgument="True" />
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
</
telerik:RadAjaxPanel
>
</
td
>
</
tr
>
</
table
>
</
ContentTemplate
>
<
NotificationMenu
ID
=
"TitleMenu"
>
</
NotificationMenu
>
</
telerik:RadNotification
>
</
td
>
</
tr
>
</
table
>
</
div
>
protected void RadAjaxManager1_AjaxRequest(object sender, AjaxRequestEventArgs e)
{
try
{
dt = new DataTable();
if (e.Argument == "Reminder")
{
CurUsr = 14;
_objPD.FillReminderList(CurUsr, gvReminder);
gvReminder.DataBind();
if (gvReminder.Items.Count > 0)
{
n1.Show();
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
<
a
href
=
"[cp:scripting key='column' name='address' /]"
/>[cp:scripting key='column' name='title' /]</
a
>
<
a
href
=
"[cp:scripting%20key='column'%20name='address'%20/]"
>[cp:scripting key='column' name='title' /]</
a
>
<
a
href
=
"javascript:alert('are spaces replaced');"
>Alert</
a
>
<
a
href
=
"javascript:alert('are%20spaces%20replaced');"
>Alert</
a
>
Please help me out how to assign the quarter, month etc. Do I have to calculate
the data by month, quarter in the database?
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="Intolerances.aspx.vb"
Inherits="GESPHARxLite_2.Intolerances" %>
<%@ Import Namespace="GESPHARxLite_2.GestionMessages" %>
<%@ Register TagPrefix="GESPHARxLite_2" TagName="DateRangeFilter" Src="~/DateRangeFilter.ascx" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" IE=edge>
<
html
xmlns
=
"http://www.w3.org/1999/xhtml"
>
<
head
runat
=
"server"
>
<
meta
http-equiv
=
"X-UA-Compatible"
content
=
"IE=9; IE=8; IE=7; IE=EDGE"
/>
<
title
></
title
>
<
link
href
=
"css/GESPHARxLite.css"
rel
=
"stylesheet"
type
=
"text/css"
/>
<
style
type
=
"text/css"
>
html, body, form
{
height: 100%;
}
</
style
>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
runat
=
"server"
>
<
Scripts
>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.Core.js"
>
</
asp:ScriptReference
>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.jQuery.js"
>
</
asp:ScriptReference
>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.jQueryInclude.js"
>
</
asp:ScriptReference
>
<
asp:ScriptReference
Path
=
"Scripts/UtilsCGSI.js"
/>
<
asp:ScriptReference
Path
=
"Scripts/Resizer.js"
/>
<
asp:ScriptReference
Path
=
"Scripts/AutoEditValidation.js"
/>
</
Scripts
>
</
telerik:RadScriptManager
>
<
telerik:RadFormDecorator
EnableRoundedCorners
=
"false"
ID
=
"RadFormDecorator1"
DecoratedControls
=
"All"
runat
=
"server"
/>
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
ClientEvents-OnResponseEnd
=
"OnResponseEnd"
>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"gridIntolerances"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"gridIntolerances"
LoadingPanelID
=
"RadAjaxLoadingPanel1"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManager
>
<
div
id
=
"lediv"
>
<
telerik:RadAjaxLoadingPanel
ID
=
"RadAjaxLoadingPanel1"
runat
=
"server"
Skin
=
"Default"
>
</
telerik:RadAjaxLoadingPanel
>
<
telerik:RadGrid
ID
=
"gridIntolerances"
runat
=
"server"
CellSpacing
=
"0"
>
<
MasterTableView
CommandItemDisplay
=
"Top"
>
<
CommandItemSettings
ExportToPdfText
=
"Export to PDF"
></
CommandItemSettings
>
<
RowIndicatorColumn
Visible
=
"True"
FilterControlAltText
=
"Filter RowIndicator column"
>
</
RowIndicatorColumn
>
<
ExpandCollapseColumn
Visible
=
"True"
FilterControlAltText
=
"Filter ExpandColumn column"
>
</
ExpandCollapseColumn
>
<
Columns
>
<
telerik:GridEditCommandColumn
FilterControlAltText
=
"Filter EditCommandColumn column"
ButtonType
=
"ImageButton"
Resizable
=
"False"
EditImageUrl
=
"Images/Icons/006-Write-New-Icon.png"
UniqueName
=
"colEdit"
>
<
HeaderStyle
Width
=
"32px"
></
HeaderStyle
>
</
telerik:GridEditCommandColumn
>
<
telerik:GridButtonColumn
CommandName
=
"Delete"
ConfirmText
=
"Êtez-vous sûr de vouloir supprimer?"
FilterControlAltText
=
"Filter column column"
Text
=
"Supprimer"
UniqueName
=
"colDelete"
ButtonType
=
"ImageButton"
ImageUrl
=
"Images/Icons/059-Close-Delete-circle-Icon.png"
ConfirmDialogType
=
"RadWindow"
>
<
HeaderStyle
Width
=
"32px"
></
HeaderStyle
>
</
telerik:GridButtonColumn
>
<
telerik:GridBoundColumn
AutoPostBackOnFilter
=
"true"
DataField
=
"pint_noauto"
FilterControlAltText
=
"Filter column1 column"
UniqueName
=
"colNoAuto"
Visible
=
"False"
ReadOnly
=
"True"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
AutoPostBackOnFilter
=
"true"
DataField
=
"allergie"
FilterControlAltText
=
"Filter column2 column"
UniqueName
=
"colAllergie"
CurrentFilterFunction
=
"StartsWith"
ShowFilterIcon
=
"false"
ReadOnly
=
"True"
>
</
telerik:GridBoundColumn
>
<
telerik:GridCheckBoxColumn
DataField
=
"isGroupe"
DataType
=
"System.Boolean"
FilterControlAltText
=
"Filter column column"
ReadOnly
=
"True"
UniqueName
=
"colIsGroupe"
ShowFilterIcon
=
"false"
AllowFiltering
=
"False"
>
<
ItemStyle
HorizontalAlign
=
"Center"
/>
<
HeaderStyle
HorizontalAlign
=
"Center"
Width
=
"64px"
/>
</
telerik:GridCheckBoxColumn
>
<
telerik:GridDateTimeColumn
AutoPostBackOnFilter
=
"true"
DataField
=
"Date"
FilterControlAltText
=
"Filter column3 column"
UniqueName
=
"colDate"
DataType
=
"System.DateTime"
>
<
FilterTemplate
>
<
GESPHARxLite_2:DateRangeFilter
runat
=
"server"
ID
=
"drfDate"
StartDate='<%# startDate %>' EndDate='<%# endDate %>' />
</
FilterTemplate
>
<
HeaderStyle
Width
=
"140px"
/>
</
telerik:GridDateTimeColumn
>
<
telerik:GridDropDownColumn
FilterControlAltText
=
"Filter column8 column"
UniqueName
=
"colGenerique"
ListValueField
=
"gene_numero"
ListTextField
=
"gene_nom"
ShowFilterIcon
=
"False"
Visible
=
"False"
DropDownControlType
=
"RadComboBox"
DataField
=
"gene_numero"
>
</
telerik:GridDropDownColumn
>
<
telerik:GridDropDownColumn
FilterControlAltText
=
"Filter column7 column"
UniqueName
=
"colGroupeDesc"
ListValueField
=
"gral_numero"
ListTextField
=
"gral_description"
ShowFilterIcon
=
"False"
Visible
=
"False"
DropDownControlType
=
"RadComboBox"
DataField
=
"gral_numero"
>
</
telerik:GridDropDownColumn
>
<
telerik:GridBoundColumn
AutoPostBackOnFilter
=
"true"
DataField
=
"pint_texte_1"
FilterControlAltText
=
"Filter column4 column"
UniqueName
=
"colTexte1"
CurrentFilterFunction
=
"StartsWith"
ShowFilterIcon
=
"false"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
AutoPostBackOnFilter
=
"true"
DataField
=
"pint_texte_2"
FilterControlAltText
=
"Filter column5 column"
UniqueName
=
"colTexte2"
CurrentFilterFunction
=
"StartsWith"
ShowFilterIcon
=
"false"
>
</
telerik:GridBoundColumn
>
<
telerik:GridCheckBoxColumn
DataField
=
"isImprime"
FilterControlAltText
=
"Filter colImprimer column"
UniqueName
=
"colImprimer"
Visible
=
"False"
>
</
telerik:GridCheckBoxColumn
>
</
Columns
>
<
SortExpressions
>
<
telerik:GridSortExpression
FieldName
=
"allergie"
SortOrder
=
"Ascending"
/>
</
SortExpressions
>
<
EditFormSettings
>
<
EditColumn
ButtonType
=
"PushButton"
FilterControlAltText
=
"Filter EditCommandColumn column"
>
</
EditColumn
>
</
EditFormSettings
>
</
MasterTableView
>
<
FilterMenu
EnableImageSprites
=
"False"
>
</
FilterMenu
>
<
EditItemStyle
BackColor
=
"Silver"
/>
</
telerik:RadGrid
>
</
div
>
<
telerik:RadWindowManager
runat
=
"server"
ID
=
"rwm"
Modal
=
"true"
VisibleOnPageLoad
=
"true"
VisibleStatusbar
=
"false"
IconUrl
=
"Images/favicon.ico"
MaxWidth
=
"330px"
MaxHeight
=
"100px"
Title
=
"GESPHARxLite"
>
</
telerik:RadWindowManager
>
<
telerik:RadCodeBlock
ID
=
"RadCodeBlock1"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
<!--
function GenSelectionChanged(sender, eventArgs)
{
var cbo = $find(GetServerElement("RCB_colGroupeDesc", "div").id);
clearGrpOrGenSelection(cbo);
}
function GrpSelectionChanged(sender, eventArgs)
{
var cbo = $find(GetServerElement("RCB_colGenerique", "div").id);
clearGrpOrGenSelection(cbo);
}
function Resize()
{
var grid = $find("<%= gridIntolerances.ClientID %>");
ResizeRadControl(grid, 2);
}
-->
</
script
>
</
telerik:RadCodeBlock
>
</
form
>
</
body
>
</
html
>
<%@ Control Language="vb" AutoEventWireup="false" CodeBehind="DateRangeFilter.ascx.vb"
Inherits="GESPHARxLite_2.DateRangeFilter" %>
<%@ Import Namespace="GESPHARxLite_2.GestionMessages" %>
<
div
>
<
div
style
=
"margin: 0px 0px 3px 0px;"
>
<
div
class
=
"alignLeft"
style
=
"width: 30px;"
>
<%#GetMessageEx(1617).TexteHTML%>
:
</
div
>
<
div
class
=
"alignLeft"
>
<
telerik:RadDatePicker
runat
=
"server"
ID
=
"rdpFrom"
Width
=
"95px"
DbSelectedDate='<%# StartDate %>' AutoPostBack="false">
<
ClientEvents
OnDateSelected
=
"FromDateSelected"
/>
</
telerik:RadDatePicker
>
</
div
>
<
div
class
=
"spacer"
>
</
div
>
</
div
>
<
div
>
<
div
class
=
"alignLeft"
style
=
"width: 30px;"
>
<%#GetMessageEx(1618).TexteHTML%>
:
</
div
>
<
div
class
=
"alignLeft"
>
<
telerik:RadDatePicker
runat
=
"server"
ID
=
"rdpTo"
Width
=
"95px"
DbSelectedDate='<%# EndDate %>'>
<
ClientEvents
OnDateSelected
=
"ToDateSelected"
/>
</
telerik:RadDatePicker
>
</
div
>
<
div
class
=
"spacer"
></
div
>
</
div
>
</
div
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock1"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function FromDateSelected(sender, args)
{
var tableView = $find("<%# TryCast(NamingContainer,GridItem).OwnerTableView.ClientID %>");
var ToPicker = $find('<%# rdpTo.ClientID %>');
var fromDate = FormatSelectedDate(sender);
var toDate = FormatSelectedDate(ToPicker);
tableView.filter("colDate", fromDate + " " + toDate, Telerik.Web.UI.GridFilterFunction.Between);
console.debug(fromDate + " " + toDate);
}
function ToDateSelected(sender, args)
{
var tableView = $find("<%# TryCast(NamingContainer,GridItem).OwnerTableView.ClientID %>");
var FromPicker = $find('<%# rdpFrom.ClientID %>');
var fromDate = FormatSelectedDate(FromPicker);
var toDate = FormatSelectedDate(sender);
tableView.filter("colDate", fromDate + " " + toDate, Telerik.Web.UI.GridFilterFunction.Between);
console.debug(fromDate + " " + toDate);
}
function FormatSelectedDate(picker)
{
var date = picker.get_selectedDate();
var dateInput = picker.get_dateInput();
var formattedDate = dateInput.get_dateFormatInfo().FormatDate(date, dateInput.get_displayDateFormat());
return formattedDate;
}
</
script
>
</
telerik:RadScriptBlock
>
Public
Partial
Class
DateRangeFilter
Inherits
System.Web.UI.UserControl
Private
_startDate
As
System.Nullable(Of DateTime)
Private
_endDate
As
System.Nullable(Of DateTime)
Public
Property
StartDate()
As
System.Nullable(Of DateTime)
Get
Return
ViewState(
"startD"
)
End
Get
Set
(
ByVal
value
As
System.Nullable(Of DateTime))
ViewState(
"startD"
) = value
End
Set
End
Property
Public
Property
EndDate()
As
System.Nullable(Of DateTime)
Get
If
ViewState(
"endD"
) <>
Nothing
Then
Return
DirectCast
(ViewState(
"endD"
), DateTime)
Else
Return
Nothing
End
If
End
Get
Set
(
ByVal
value
As
System.Nullable(Of DateTime))
ViewState(
"endD"
) = value
End
Set
End
Property
Protected
Sub
Page_Load(
ByVal
sender
As
Object
,
ByVal
e
As
System.EventArgs)
Handles
Me
.Load
End
Sub
Private
Sub
Page_PreRender(
ByVal
sender
As
Object
,
ByVal
e
As
System.EventArgs)
Handles
Me
.PreRender
rdpFrom.SelectedDate = StartDate
rdpTo.SelectedDate = EndDate
End
Sub
End
Class
Protected
Sub
gridIntolerances_ItemCommand(
ByVal
sender
As
Object
,
ByVal
e
As
Telerik.Web.UI.GridCommandEventArgs)
Handles
gridIntolerances.ItemCommand
If
e.CommandName = RadGrid.FilterCommandName
Then
Dim
eItem
As
GridFilteringItem = e.Item
Dim
ctrl
As
DateRangeFilter = eItem(
"colDate"
).FindControl(
"drfDate"
)
Dim
rdpFrom
As
RadDatePicker = ctrl.FindControl(
"rdpFrom"
)
Dim
rdpTo
As
RadDatePicker = ctrl.FindControl(
"rdpTo"
)
startDate = rdpFrom.SelectedDate
endDate = rdpTo.SelectedDate
End
If
End
Sub