or
<ul class="rsTimePickers"> <li class="rsTimePick"> <label for='<%= StartDate.ClientID %>_dateInput_text'> <%= Owner.Localization.AdvancedFrom +":" %></label><%-- Leaving a newline here will affect the layout, so we use a comment instead. --%><telerik:RadDatePicker runat="server" ID="StartDate" CssClass="rsAdvDatePicker" Width="83px" Culture='<%# Owner.Culture %>' Skin="Office2007" MinDate="1900-01-01"> <DatePopupButton Visible="False" /> <DateInput ID="DateInput1" runat="server" DateFormat='<%# Owner.AdvancedForm.DateFormat %>' EmptyMessageStyle-CssClass="riError" EmptyMessage=" " /> </telerik:RadDatePicker> <%-- --%><telerik:RadTimePicker runat="server" Width="70px" ID="StartTime" CssClass="rsAdvTimePicker" Culture='<%# Owner.Culture %>' Skin="Office2007" On> <DateInput ID="DateInput2" runat="server" EmptyMessageStyle-CssClass="riError" EmptyMessage=" " /> <TimePopupButton Visible="false" /> <TimeView ID="TimeView1" runat="server" Columns="4" ShowHeader="false" Interval="00:30" /> </telerik:RadTimePicker> </li> <li class="rsTimePick"> <label for='<%= EndDate.ClientID %>_dateInput_text'> <%= Owner.Localization.AdvancedTo +":"%></label><%-- --%><telerik:RadDatePicker runat="server" ID="EndDate" CssClass="rsAdvDatePicker" Width="83px" Culture='<%# Owner.Culture %>' MinDate="1900-01-01" Skin="Office2007"> <DatePopupButton Visible="False" /> <DateInput ID="DateInput3" runat="server" DateFormat='<%# Owner.AdvancedForm.DateFormat %>' EmptyMessageStyle-CssClass="riError" EmptyMessage=" " /> </telerik:RadDatePicker> <%-- --%><telerik:RadTimePicker runat="server" Width="70px" ID="EndTime" CssClass="rsAdvTimePicker" Culture='<%# Owner.Culture %>' Skin="Office2007" On> <DateInput ID="DateInput4" runat="server" EmptyMessageStyle-CssClass="riError" EmptyMessage=" " /> <TimePopupButton Visible="false" /> <TimeView ID="TimeView2" runat="server" Columns="4" ShowHeader="false" Interval="00:30" /> </telerik:RadTimePicker> </li> <li class="rsAllDayWrapper" style="display: none;"> <asp:CheckBox runat="server" ID="AllDayEvent" CssClass="rsAdvChkWrap" Checked="false" /> </li></ul>
<rad:radgrid id="gridFilings" runat="server" allowsorting="True" autogeneratecolumns="False" enableajax="True" enableajaxloadingtemplate="True" gridlines="None" loadingtemplatetransparency="50" showstatusbar="True" skin="Windows" width="98%" ShowGroupPanel="True" AllowPaging="false" OnItemDataBound="gridFilings_ItemDataBound" OnNeedDataSource ="gridFilings_NeedDataSource" > <ClientSettings AllowDragToGroup="True"> <Selecting AllowRowSelect="True" /> </ClientSettings> <MasterTableView AllowCustomPaging="True" DataKeyNames="FileID" AutoGenerateColumns="False" DataSourcePersistenceMode="NoPersistence" AlternatingItemStyle-BackColor="ControlLight"> <Columns> <rad:GridBoundColumn DataField="FileID" UniqueName="FileID" Groupable="False" AllowSorting="True" Visible="True" HeaderText="Job #" HeaderStyle-CssClass="headerLeft" DataType="System.String"> </rad:GridBoundColumn> <rad:GridTemplateColumn DataField="ClientName" HeaderText="Client Name" HeaderStyle-CssClass="headerLeft" SortExpression="ClientName" UniqueName="ClientName" GroupByExpression="ClientName Group By ClientName"> <itemTemplate> <%# Eval("ClientName")%> </itemTemplate> </rad:GridTemplateColumn> <rad:GridTemplateColumn DataField="GroupName" HeaderText="Group" HeaderStyle-CssClass="headerLeft" SortExpression="GroupName" UniqueName="GroupName" GroupByExpression="GroupName Group By GroupName"> <ItemTemplate> <%# Eval("GroupName")%> </ItemTemplate> </rad:GridTemplateColumn> <rad:GridTemplateColumn HeaderText="Operator" HeaderStyle-CssClass="headerLeft" SortExpression="AssignedTo" UniqueName="OperatorTemplate" GroupByExpression="AssignedTo Group By AssignedTo"> <ItemTemplate> <asp:DropDownList ID="OperatorDropDown" runat="server" EnableViewState="false"></asp:DropDownList> </ItemTemplate> </rad:GridTemplateColumn> <rad:GridTemplateColumn DataField="DateIn" HeaderText="Date In" HeaderStyle-CssClass="headerLeft" SortExpression="DateIn" UniqueName="DateIn" GroupByExpression="DateIn Group By DateIn" > <ItemTemplate> <%# String.Format("{0:MM/dd/yyyy}", Eval("DateIn"))%> </ItemTemplate> </rad:GridTemplateColumn> <rad:GridTemplateColumn DataField="DueDate" HeaderText="Due Date" HeaderStyle-CssClass="headerLeft" SortExpression="DueDate" UniqueName="DueDate" GroupByExpression="DueDate Group By DueDate"> <ItemTemplate> <%# String.Format("{0:MM/dd/yyyy}", Eval("DueDate"))%> </ItemTemplate> </rad:GridTemplateColumn> <rad:GridTemplateColumn DataField="FileTypeName" HeaderText="Form Type" HeaderStyle-CssClass="headerLeft" SortExpression="FileTypeName" UniqueName="FileTypeName" Groupable="False"> <ItemTemplate> <%# Eval("FileTypeName")%> </ItemTemplate> </rad:GridTemplateColumn> <rad:GridTemplateColumn DataField="ConvertedPageCount" Groupable="false" HeaderText="Converted<br>Page Count" HeaderStyle-CssClass="headerRight" ItemStyle-HorizontalAlign="Right" UniqueName="ConvertedPageCount"> <ItemTemplate> <%# Eval("ConvertedPageCount")%> </ItemTemplate> </rad:GridTemplateColumn> <rad:GridTemplateColumn DataField="ChangedPageCount" Groupable="false" HeaderText="Changed<br>Page Count" HeaderStyle-CssClass="headerRight" ItemStyle-HorizontalAlign="Right" UniqueName="ChangedPageCount"> <ItemTemplate> <%# Eval("ChangedPageCount")%> </ItemTemplate> </rad:GridTemplateColumn> <rad:GridTemplateColumn DataField="ConversionType" Groupable="false" HeaderText="Conversion" ItemStyle-HorizontalAlign="Center" UniqueName="ConversionType"> <ItemTemplate> <%# Eval("ConversionType")%> </ItemTemplate> </rad:GridTemplateColumn> <rad:GridBoundColumn DataField="FileStatusTypeID" UniqueName="FileStatusTypeID" Groupable="False" AllowFiltering="False" Visible="False"> </rad:GridBoundColumn> <rad:GridBoundColumn DataField="AssignedTo" UniqueName="AssignedTo" Groupable="False" AllowFiltering="False" Visible="False"> </rad:GridBoundColumn> <rad:GridTemplateColumn HeaderText="Status" HeaderStyle-CssClass="headerLeft" AllowFiltering="False" SortExpression="FileStatusTypeID" UniqueName="FileStatusTypeIDTemplate" GroupByExpression="FileStatusTypeID Group By FileStatusTypeID"> <ItemTemplate> <asp:DropDownList ID="StatusTypeID" runat="server" EnableViewState="false" DataTextField="FileStatusTypeName" DataValueField="FileStatusTypeID"></asp:DropDownList> </ItemTemplate> </rad:GridTemplateColumn> <rad:GridTemplateColumn AllowFiltering="False" UniqueName="ViewFiling" Groupable="false"> <ItemTemplate> <a href="javascript:openDialog('ViewFiling.aspx?fileid=<%# Eval("FileID")%>', 800, 600, 'file', 'scrollbars=yes,resizable=yes');"> <img alt="View Filing" border="0" src="RadControls/Grid/Skins/Windows/View.gif" title="View Filing" /></a> </ItemTemplate> </rad:GridTemplateColumn> <rad:GridTemplateColumn AllowFiltering="False" UniqueName="EditFiling" Groupable="false"> <ItemTemplate> <a href="EditFiling.aspx?fileid=<%# Eval("FileID")%>"> <img alt="Edit Filing" border="0" src="RadControls/Grid/Skins/Windows/Edit.gif" title="Edit Filing" /></a> </ItemTemplate> </rad:GridTemplateColumn> <rad:GridTemplateColumn AllowFiltering="False" UniqueName="DocumentLink" Groupable="false"> <ItemTemplate> <a href="javascript:openDialog('FileManager.aspx?fileid=<%# Eval("FileID")%>', 800, 600, 'file', 'scrollbars=yes,resizable=yes');"> <img alt="View Files" border="0" src="RadControls/Grid/Skins/Windows/folder.gif" title="View Files" /></a> </ItemTemplate> <HeaderStyle Width="20px" /> </rad:GridTemplateColumn> <rad:GridTemplateColumn DataField="GroupID" UniqueName="GroupID" Display="false"> <ItemTemplate> <%# Eval("GroupID")%> </ItemTemplate> </rad:GridTemplateColumn> </Columns> <ExpandCollapseColumn Resizable="False" Visible="False"> <HeaderStyle Width="20px" /> </ExpandCollapseColumn> <RowIndicatorColumn Visible="False"> <HeaderStyle Width="20px" /> </RowIndicatorColumn> </MasterTableView> </rad:radgrid>protected void gridFilings_NeedDataSource(object source, GridNeedDataSourceEventArgs e) { SqlDataSource1.SelectCommand= "SELECT [FileID], [ClientID], [ClientName], [DateIn], [DueDate], [FileTypeName], [FileLocation], [FileStatusTypeName], [FileStatusTypeID] , [GroupID], [GroupName], [PageCount], [ConvertedPageCount], [ChangedPageCount], [ConversionType], IsNull([AssignedTo], '') as 'AssignedTo' FROM [FileDetailView] WHERE [FileStatusTypeID] <= 90 "; if (Page.User.IsInRole("GROUP")) SqlDataSource1.SelectCommand += " and [GroupID] = " + Session["GroupID"].ToString(); else if (Page.User.IsInRole("CLIENT")) SqlDataSource1.SelectCommand += " and [ClientID] = " + Session["ClientID"].ToString() + " and FileStatusTypeID = 0"; if (ClientName.SelectedValue.Length > 0) SqlDataSource1.SelectCommand += " and ClientID = " + ClientName.SelectedValue; if (ClientGroup.SelectedValue.Length > 0) SqlDataSource1.SelectCommand += " and GroupID = " + ClientGroup.SelectedValue; if (StartDueDate.Text.Length > 0) { if (EndDueDate.Text.Length > 0) SqlDataSource1.SelectCommand += " and (DueDate >= '" + StartDueDate.Text + "' and DueDate <= '" + EndDueDate.Text + "')"; else SqlDataSource1.SelectCommand += " and DueDate = '" + StartDueDate.Text + "'"; } if (StartDateIn.Text.Length > 0) { if (EndDateIn.Text.Length > 0) SqlDataSource1.SelectCommand += " and (DateIn >= '" + StartDateIn.Text + "' and DateIn <= '" + EndDateIn.Text + "')"; else SqlDataSource1.SelectCommand += " and DateIn = '" + StartDateIn.Text + "'"; } SqlDataSource1.SelectCommand += " Order by FileStatusTypeID"; gridFilings.DataSource = SqlDataSource1;