or
Protected
Sub
rgTimeslips_ItemCommand(
ByVal
source
As
Object
,
ByVal
e
As
GridCommandEventArgs)
Handles
rgTimeslips.ItemCommand
LogID = e.Item.OwnerTableView.DataKeyValues(e.Item.ItemIndex)(
"KeyID"
)
DocID = e.Item.OwnerTableView.DataKeyValues(e.Item.ItemIndex)(
"SONumber"
)
Label7.Text = LogID &
","
& DocID
pnlForm.Visible =
True
pnlLogGrid.Visible =
False
'set values of Time Entry user control
Dim
u
As
UserControl = TryCast(FindControl(
"TimeEntry2"
), UserControl)
Dim
ddlso
As
DropDownList = TryCast(u.FindControl(
"ddlSO"
), DropDownList)
ddlso.SelectedValue = DocID
Dim
SOLogKeyID
As
HiddenField = TryCast(u.FindControl(
"SOLogKeyID"
), HiddenField)
Dim
TimeSlipKeyID
As
HiddenField = TryCast(u.FindControl(
"TimeSlipKeyID"
), HiddenField)
If
DocID = 0
Then
SOLogKeyID.Value =
"0"
TimeSlipKeyID.Value = LogID
Else
SOLogKeyID.Value = LogID
TimeSlipKeyID.Value =
"0"
End
If
ddlso.Enabled =
False
End
Sub
<
telerik:RadGrid
ID
=
"rgDepartaments"
runat
=
"server"
AllowPaging
=
"true"
AllowSorting
=
"true"
AllowFilteringByColumn
=
"true"
PageSize
=
"10"
AllowMultiRowEdit
=
"true"
OnItemCreated
=
"rgDepartaments_ItemCreated"
>
<
MasterTableView
DataKeyNames
=
"IdDepartament"
ClientDataKeyNames
=
"IdDepartament"
CommandItemDisplay
=
"Bottom"
>
<
Columns
>
<
telerik:GridBoundColumn
UniqueName
=
"Departament"
DataField
=
"Departamento"
DataType
=
"System.String"
>
</
telerik:GridBoundColumn
>
<
telerik:GridDateTimeColumn
UniqueName
=
"UpdateDate"
DataField
=
"UpdateDate"
DataType
=
"System.DateTime"
DataFormatString
=
"{0:dd/MM/yyyy HH:mm}"
HeaderStyle-Width
=
"150px"
>
</
telerik:GridDateTimeColumn
>
</
Columns
>
</
MasterTableView
>
<
ClientSettings
>
<
DataBinding
Location
=
"~/DesktopModules/Comun/Services/DepartmentSvc.svc"
SelectCountMethod
=
"TotalDepartments"
>
<
DataService
TableName
=
"Departament"
/>
</
DataBinding
>
</
ClientSettings
>
</
telerik:RadGrid
>
[WebGet]
public int TotalDepartments(string where)
{
return String.IsNullOrEmpty(where) ? this.CurrentDataSource.Department.Count() : this.CurrentDataSource.Department.Where(where).Count();
}
TotalDepartments
is executed with a where condition having a UpdateDate
filter I get the following error: Edm.DateTime and Edm.String are not compatible types. UpdateDate
(21/07/2011 --> 21st July 2011). When I try to filter through UpdateDate
width 16/07/2011 and "major than" I get no record (all records must have been returned). By if I filter with 16/07/2001 and "less than" I get all the records (no record must have been returned).Dim exp As String = "(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\d\d"
Dim sql As String = ""
Dim DATE_EXP As System.Text.RegularExpressions.Match = System.Text.RegularExpressions.Regex.Match(e.Text, exp)
sql = "SELECT NAMECOLUMNS from TABLE "
If DATE_EXP .Success Then
sql += " where CONVERT(VARCHAR(12),DATE_COLUMN,103) = CONVERT(VARCHAR(12), '" & e.Text & "', 103) "
Else
sql += " WHERE OTHERCOLUMN LIKE '%" + e.Text + "%'"
End If
SessionDataSource1.SelectCommand = sql
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
runat
=
"server"
>
</
telerik:RadScriptManager
>
<%
System.Collections.Generic.List<
RadComboBoxItem
> choices = new System.Collections.Generic.List<
RadComboBoxItem
>();
for(int i=1; i <= 10; i++)
{ choices.Add(new RadComboBoxItem("" + i + "- Complex Display Detail", "" + i));
}
RadComboBox1.DataSource = choices;
RadComboBox1.DataBind();
%>
<
telerik:RadComboBox
ID
=
"RadComboBox1"
runat
=
"server"
AllowCustomText
=
"true"
DataTextField
=
"Value"
DataValueField
=
"Value"
Width
=
"333px"
CheckBoxes
=
"false"
>
<
ItemTemplate
>
<
asp:Label
runat
=
"server"
><%# Eval("Text") %></
asp:Label
>
</
ItemTemplate
>
</
telerik:RadComboBox
>
<
telerik:RadAjaxLoadingPanel
ID
=
"RadAjaxLoadingPanel1"
runat
=
"server"
>
</
telerik:RadAjaxLoadingPanel
>
<
telerik:RadAjaxManager
ID
=
"rad1"
runat
=
"server"
>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"rgTest"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"rgTest"
LoadingPanelID
=
"RadAjaxLoadingPanel1"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManager
>
<
telerik:RadAjaxLoadingPanel
ID
=
"RadAjaxLoadingPanel1"
runat
=
"server"
Skin
=
"Default"
>
</
telerik:RadAjaxLoadingPanel
>
<
telerik:RadAjaxManager
ID
=
"rad1"
runat
=
"server"
>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"rgTest"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"rgTest"
LoadingPanelID
=
"RadAjaxLoadingPanel1"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManager
>