<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WorkQueue.aspx.cs" Inherits="Sterling.SNEF.Tax.Web.WorkQueue" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<!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
>Work Queue</
title
>
<
style
type
=
"text/css"
>
.RadGrid_Web20 .rgCommandRow
{
color: #35467C !important;
height: 24px !important;
}
</
style
>
</
head
>
<
telerik:RadCodeBlock
ID
=
"RadCodeBlock1"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function pageLoad(sender, eventArgs) {
if (!eventArgs.get_isPartialLoad()) {
$find("<%= RadAjaxManager1.ClientID %>").ajaxRequest("InitialPageLoad");
}
}
function onRequestStart(sender, args)
{
if (args.get_eventTarget().indexOf("ExportToExcelButton") >=0)
{
args.set_enableAjax(false);
}
}
</
script
>
</
telerik:RadCodeBlock
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
runat
=
"server"
>
</
telerik:RadScriptManager
>
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
>
<
ClientEvents
OnRequestStart
=
"onRequestStart"
/>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"RadAjaxManager1"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"Panel1"
LoadingPanelID
=
"LoadingPanel"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
<
telerik:AjaxSetting
AjaxControlID
=
"Panel1"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"Panel1"
LoadingPanelID
=
"RadAjaxLoadingPanel1"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManager
>
<
telerik:RadAjaxLoadingPanel
ID
=
"LoadingPanel"
runat
=
"server"
HorizontalAlign
=
"Center"
Width
=
"50px"
BorderColor
=
"#99CCFF"
>
<
asp:Image
ID
=
"Image1"
runat
=
"server"
ImageUrl
=
"Images/loading.gif"
ImageAlign
=
"Top"
>
</
asp:Image
>
</
telerik:RadAjaxLoadingPanel
>
<
telerik:RadAjaxLoadingPanel
ID
=
"RadAjaxLoadingPanel1"
runat
=
"server"
Skin
=
"Web20"
>
</
telerik:RadAjaxLoadingPanel
>
<
asp:Panel
ID
=
"Panel1"
runat
=
"server"
>
<
asp:Panel
ID
=
"Panel2"
Visible
=
"false"
runat
=
"server"
>
<
div
style="border: thin solid #666666; left: 5px; position: relative;
left: 5px; width: 900px; border-collapse: collapse; background-color: #CCCCCC">
<
table
>
<
tr
valign
=
"top"
>
<
td
align
=
"left"
style
=
"width: 220px;"
>
<
asp:Label
ID
=
"lblSearchBy"
runat
=
"server"
Font-Bold
=
"True"
Font-Names
=
"arial,sans-serif"
Font-Size
=
"12px"
>Search by: </
asp:Label
>
</
br
>
<
asp:DropDownList
ID
=
"DropDownList1"
runat
=
"server"
Font-Names
=
"Arial"
Font-Size
=
"12px"
>
<
asp:ListItem
>Select</
asp:ListItem
>
<
asp:ListItem
>Hard Stops</
asp:ListItem
>
<
asp:ListItem
>HOA</
asp:ListItem
>
<
asp:ListItem
>Late Release</
asp:ListItem
>
<
asp:ListItem
>Payment Denials</
asp:ListItem
>
<
asp:ListItem
>Unworkable</
asp:ListItem
>
<
asp:ListItem
>Work Status</
asp:ListItem
>
</
asp:DropDownList
>
</
td
>
<
td
align
=
"left"
style
=
"width: 200px;"
>
<
asp:Label
ID
=
"Label1"
runat
=
"server"
Font-Names
=
"arial,sans-serif"
Font-Bold
=
"True"
Font-Size
=
"12px"
>Name: </
asp:Label
>
</
br
>
<
asp:DropDownList
ID
=
"DropDownList2"
runat
=
"server"
Font-Names
=
"Arial"
Font-Size
=
"12px"
Width
=
"100px"
>
<
asp:ListItem
>Select </
asp:ListItem
>
</
asp:DropDownList
>
</
td
>
<
td
align
=
"left"
style
=
"width: 70px;"
>
<
asp:Label
ID
=
"Label3"
runat
=
"server"
Font-Bold
=
"True"
Font-Names
=
"arial,sans-serif"
Font-Size
=
"12px"
>From Date: </
asp:Label
>
</
br
>
<
telerik:RadDatePicker
ID
=
"dateStart"
runat
=
"server"
FocusedDate
=
""
Skin
=
"Web20"
Width
=
"130px"
TabIndex
=
"2"
>
<
Calendar
ID
=
"Calendar3"
runat
=
"server"
UseRowHeadersAsSelectors
=
"False"
UseColumnHeadersAsSelectors
=
"False"
ViewSelectorText
=
"x"
Skin
=
"Web20"
ShowRowHeaders
=
"false"
>
</
Calendar
>
<
DatePopupButton
ImageUrl
=
""
HoverImageUrl
=
""
></
DatePopupButton
>
<
DateInput
ID
=
"DateInput3"
runat
=
"server"
DisplayDateFormat
=
"M/d/yyyy"
DateFormat
=
"M/d/yyyy"
>
</
DateInput
>
</
telerik:RadDatePicker
>
</
td
>
<
td
align
=
"left"
style
=
"width: 50px;"
>
<
asp:Label
ID
=
"Label4"
runat
=
"server"
Font-Bold
=
"True"
Font-Names
=
"arial,sans-serif"
Font-Size
=
"12px"
>To Date: </
asp:Label
>
</
br
>
<
telerik:RadDatePicker
ID
=
"RadDatePicker2"
runat
=
"server"
FocusedDate
=
""
Skin
=
"Web20"
Width
=
"130px"
TabIndex
=
"2"
>
<
Calendar
ID
=
"Calendar1"
runat
=
"server"
UseRowHeadersAsSelectors
=
"False"
UseColumnHeadersAsSelectors
=
"False"
ViewSelectorText
=
"x"
Skin
=
"Web20"
ShowRowHeaders
=
"false"
>
</
Calendar
>
<
DatePopupButton
ImageUrl
=
""
HoverImageUrl
=
""
></
DatePopupButton
>
<
DateInput
ID
=
"DateInput1"
runat
=
"server"
DisplayDateFormat
=
"M/d/yyyy"
DateFormat
=
"M/d/yyyy"
>
</
DateInput
>
</
telerik:RadDatePicker
>
</
td
>
<
td
width
=
"90px"
valign
=
"bottom"
>
<
asp:Button
ID
=
"SearchButton"
runat
=
"server"
Text
=
"Search"
SkinID
=
"Web20"
/>
</
td
>
<
td
valign
=
"bottom"
>
<
asp:Button
ID
=
"DefaultButton"
runat
=
"server"
Text
=
"Default View"
SkinID
=
"Web20"
/>
</
td
>
</
tr
>
</
table
>
</
div
>
<
div
style
=
"left: 5px; position: relative; left: 5px;"
>
<
br
/>
<
asp:Label
ID
=
"lblCurrentandPrior"
runat
=
"server"
Font-Bold
=
"True"
Font-Size
=
"Large"
Font-Names
=
"Arial"
>Open Items Summary</
asp:Label
>
</
div
>
<
div
style="border: thin solid #5177B5; left: 5px; position: relative; left: 5px;
width: 900px;">
<
table
border
=
"1"
width
=
"800px"
style
=
"border-collapse: collapse;"
>
<
tr
>
<
td
align
=
"center"
style
=
"width: 145px; background-color: #7FA5D7;"
>
<
asp:Label
ID
=
"hdrAssignee"
runat
=
"server"
Text
=
"Assignees"
Font-Bold
=
"True"
Font-Names
=
"Arial"
Font-Size
=
"12px"
ForeColor
=
"White"
></
asp:Label
>
</
td
>
<
td
align
=
"center"
style
=
"width: 70px; background-color: #7FA5D7;"
>
<
asp:Label
ID
=
"Label5"
runat
=
"server"
Text
=
"States"
Font-Bold
=
"True"
Font-Names
=
"arial,sans-serif"
Font-Size
=
"12px"
ForeColor
=
"White"
></
asp:Label
>
</
td
>
<
td
align
=
"center"
style
=
"width: 100px; background-color: #7FA5D7;"
>
<
asp:Label
ID
=
"Label6"
runat
=
"server"
Text
=
"Jurisdictions"
Font-Bold
=
"True"
Font-Names
=
"Arial"
Font-Size
=
"12px"
ForeColor
=
"White"
></
asp:Label
>
</
td
>
<
td
align
=
"center"
style
=
"width: 100px; background-color: #7FA5D7;"
>
<
asp:Label
ID
=
"Label7"
runat
=
"server"
Text
=
"Total Items"
Font-Bold
=
"True"
Font-Names
=
"Arial"
Font-Size
=
"12px"
ForeColor
=
"White"
></
asp:Label
>
</
td
>
<
td
align
=
"center"
style
=
"width: 110px; background-color: #7FA5D7;"
>
<
asp:Label
ID
=
"Label8"
runat
=
"server"
Text
=
"Still Open"
Font-Bold
=
"True"
Font-Names
=
"Arial"
Font-Size
=
"12px"
ForeColor
=
"White"
></
asp:Label
>
</
td
>
<
td
align
=
"center"
style
=
"width: 100px; background-color: #7FA5D7;"
>
<
asp:Label
ID
=
"Label9"
runat
=
"server"
Text
=
"Unworkable"
Font-Bold
=
"True"
Font-Names
=
"Arial"
Font-Size
=
"12px"
ForeColor
=
"White"
></
asp:Label
>
</
td
>
<
td
align
=
"center"
style
=
"width: 90px; background-color: #7FA5D7;"
>
<
asp:Label
ID
=
"Label11"
runat
=
"server"
Text
=
"Workable"
Font-Bold
=
"True"
Font-Names
=
"Arial"
Font-Size
=
"12px"
ForeColor
=
"White"
></
asp:Label
>
</
td
>
<
td
align
=
"center"
style
=
"width: 85px; background-color: #7FA5D7;"
>
<
asp:Label
ID
=
"Label12"
runat
=
"server"
Text
=
"% Complete"
Font-Bold
=
"True"
Font-Names
=
"Arial"
Font-Size
=
"12px"
ForeColor
=
"White"
></
asp:Label
>
</
td
>
</
tr
>
<
tr
>
<
td
align
=
"right"
style
=
"width: 145px;"
>
<
asp:Label
ID
=
"lblhdrAssignees"
runat
=
"server"
Text
=
" "
Font-Names
=
"Arial"
Font-Size
=
"12px"
></
asp:Label
>
</
td
>
<
td
align
=
"right"
style
=
"width: 70px;"
>
<
asp:Label
ID
=
"lblhdrStates"
runat
=
"server"
Font-Names
=
"arial,sans-serif"
Font-Size
=
"12px"
></
asp:Label
>
</
td
>
<
td
align
=
"right"
style
=
"width: 100px;"
>
<
asp:Label
ID
=
"lblhdrJurisdictions"
runat
=
"server"
Font-Names
=
"arial,sans-serif"
Font-Size
=
"12px"
></
asp:Label
>
</
td
>
<
td
align
=
"right"
style
=
"width: 100px;"
>
<
asp:Label
ID
=
"lblhdrTotal"
runat
=
"server"
Font-Names
=
"arial,sans-serif"
Font-Size
=
"12px"
></
asp:Label
>
</
td
>
<
td
align
=
"right"
style
=
"width: 110px;"
>
<
asp:Label
ID
=
"lblhdrStillOpen"
runat
=
"server"
Font-Names
=
"arial,sans-serif"
Font-Size
=
"12px"
></
asp:Label
>
</
td
>
<
td
align
=
"right"
style
=
"width: 100px;"
>
<
asp:Label
ID
=
"lblhdrCannot"
runat
=
"server"
Font-Names
=
"arial,sans-serif"
Font-Size
=
"12px"
></
asp:Label
>
</
td
>
<
td
align
=
"right"
style
=
"width: 90px;"
>
<
asp:Label
ID
=
"lblhdrWorkable"
runat
=
"server"
Font-Names
=
"arial,sans-serif"
Font-Size
=
"12px"
></
asp:Label
>
</
td
>
<
td
align
=
"right"
style
=
"width: 85px;"
>
<
asp:Label
ID
=
"lblComplete"
runat
=
"server"
Font-Names
=
"arial,sans-serif"
Font-Size
=
"12px"
></
asp:Label
>
</
td
>
</
tr
>
</
table
>
</
div
>
<
br
/>
<
div
style
=
"left: 5px; position: relative; left: 5px;"
>
<
asp:Label
ID
=
"Label10"
runat
=
"server"
Font-Bold
=
"True"
Font-Size
=
"Large"
Font-Names
=
"Arial"
>Open Items by Assignee</
asp:Label
>
<
telerik:RadGrid
ID
=
"grdOpenItemsByAssignee"
AllowFilteringByColumn
=
"True"
Skin
=
"Web20"
AllowSorting
=
"True"
AllowPaging
=
"true"
PageSize
=
"100"
runat
=
"server"
AutoGenerateColumns
=
"False"
OnNeedDataSource
=
"grdOpenItemsByAssignee_NeedDataSource"
ShowStatusBar
=
"true"
EnableLinqExpressions
=
"false"
Width
=
"900px"
Height
=
"255px"
OnExcelMLExportRowCreated
=
"grdWorkItemsAssignee_ExcelMLExportRowCreated"
>
<
ExportSettings
FileName
=
"OpenItemsAssignee"
IgnorePaging
=
"True"
OpenInNewWindow
=
"True"
ExportOnlyData
=
"true"
Excel-Format
=
"ExcelML"
>
</
ExportSettings
>
<
MasterTableView
CommandItemDisplay
=
"Bottom"
AllowNaturalSort
=
"false"
UseAllDataFields
=
"true"
AllowPaging
=
"true"
>
<
CommandItemSettings
ShowExportToExcelButton
=
"true"
ShowAddNewRecordButton
=
"false"
ShowRefreshButton
=
"false"
/>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"AssigneeName"
HeaderText
=
"Assignee"
UniqueName
=
"AssigneeName"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"150px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"RadComboBoxTitle"
DataTextField
=
"value"
DataValueField
=
"value"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("AssigneeName").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="AssigneeIndexChanged" Width="145px"
DataSource="<%# GenerateComboBoxAssigneesJuris() %>">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock1"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function AssigneeIndexChanged(sender,args) {
var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("AssigneeName",args.get_item().get_value(),"EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"StateName"
HeaderText
=
"State"
UniqueName
=
"StateName"
ItemStyle-HorizontalAlign
=
"Center"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"60px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"RadComboBoxState"
DataTextField
=
"value"
DataValueField
=
"value"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("StateName").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="StateIndexChanged1" Width="50px"
DataSource="<%# ComboBoxAssigneeState() %>">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock2"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function StateIndexChanged1(sender,args) {
var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("StateName",args.get_item().get_value(),"EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
</
telerik:GridBoundColumn
>
<
telerik:GridTemplateColumn
DataField
=
"JurisdictionCount"
HeaderText
=
"Jurisdictions"
UniqueName
=
"JurisdictionCount"
SortExpression
=
"JurisdictionCount"
AllowFiltering
=
"false"
ItemStyle-HorizontalAlign
=
"Center"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"100px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
ItemTemplate
>
<
asp:Label
ID
=
"lbJurisdictionAssignee"
runat
=
"server"
Text='<%# Eval("JurisdictionCount", "{0:N0}")%>'></
asp:Label
>
</
ItemTemplate
>
<
ItemStyle
HorizontalAlign
=
"Right"
ForeColor
=
"Black"
/>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"true"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"TotalItems"
HeaderText
=
"Total Items"
UniqueName
=
"TotalItems"
SortExpression
=
"TotalItems"
AllowFiltering
=
"false"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"75px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblTotalItemsAssignee"
runat
=
"server"
Text='<%# Eval("TotalItems", "{0:N0}") %>'></
asp:Label
>
</
ItemTemplate
>
<
ItemStyle
HorizontalAlign
=
"Right"
ForeColor
=
"Black"
/>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"true"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"OpenItemsCount"
HeaderText
=
"Still Open"
UniqueName
=
"OpenItemsCount"
SortExpression
=
"OpenItemsCount"
AllowFiltering
=
"false"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"75px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
ItemTemplate
>
<
asp:Label
ID
=
"lbStillOpenAssignee"
runat
=
"server"
Text='<%# Eval("OpenItemsCount", "{0:N0}") %>'></
asp:Label
>
</
ItemTemplate
>
<
ItemStyle
HorizontalAlign
=
"Right"
ForeColor
=
"Black"
/>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"true"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"UnworkableItemsCount"
HeaderText
=
"Unworkable"
UniqueName
=
"UnworkableItemsCount"
SortExpression
=
"UnworkableItemsCount"
AllowFiltering
=
"false"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"105px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblUnworkableAssignee"
runat
=
"server"
Text='<%# Eval("UnworkableItemsCount", "{0:N0}") %>'></
asp:Label
>
</
ItemTemplate
>
<
ItemStyle
HorizontalAlign
=
"Right"
ForeColor
=
"Black"
/>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"true"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"WorkableItemsCount"
HeaderText
=
"Workable"
UniqueName
=
"WorkableItemsCount"
SortExpression
=
"WorkableItemsCount"
AllowFiltering
=
"false"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"105px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblWorkableAssignee"
runat
=
"server"
Text='<%# Eval("WorkableItemsCount", "{0:N0}") %>'></
asp:Label
>
</
ItemTemplate
>
<
ItemStyle
HorizontalAlign
=
"Right"
ForeColor
=
"Black"
/>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"true"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"PercentComplete"
HeaderText
=
"% Complete"
UniqueName
=
"PercentComplete"
SortExpression
=
"PercentComplete"
AllowFiltering
=
"false"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"80px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblPctCompleteAssignee"
runat
=
"server"
Text='<%# Eval("PercentComplete", "{0:F2}%")%>'></
asp:Label
>
</
ItemTemplate
>
<
ItemStyle
HorizontalAlign
=
"Right"
ForeColor
=
"Black"
/>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"true"
/>
</
telerik:GridTemplateColumn
>
</
Columns
>
</
MasterTableView
>
<
HeaderStyle
BorderStyle
=
"Solid"
/>
<
ClientSettings
>
<
Scrolling
AllowScroll
=
"True"
UseStaticHeaders
=
"True"
/>
</
ClientSettings
>
</
telerik:RadGrid
>
</
div
>
<
br
/>
<
div
style
=
"left: 5px; position: relative; left: 5px;"
>
<
asp:Label
ID
=
"Label13"
runat
=
"server"
Font-Bold
=
"True"
Font-Size
=
"Large"
Font-Names
=
"Arial"
>Open Items by Jurisdiction</
asp:Label
>
<
telerik:RadGrid
ID
=
"grdOpenItemsByJurisdiction"
AllowFilteringByColumn
=
"True"
Skin
=
"Web20"
AllowSorting
=
"True"
AllowPaging
=
"true"
PageSize
=
"100"
runat
=
"server"
AutoGenerateColumns
=
"False"
OnNeedDataSource
=
"grdOpenItemsByJurisdiction_NeedDataSource"
ShowStatusBar
=
"true"
HeaderStyle-Width
=
"900px"
EnableLinqExpressions
=
"false"
Width
=
"900px"
Height
=
"255px"
OnExcelMLExportRowCreated
=
"grdWorkItemsJurisdiction_ExcelMLExportRowCreated"
>
<
ExportSettings
FileName
=
"WorkItemsJurisdiction"
IgnorePaging
=
"True"
OpenInNewWindow
=
"True"
ExportOnlyData
=
"true"
Excel-Format
=
"ExcelML"
>
</
ExportSettings
>
<
MasterTableView
CommandItemDisplay
=
"Bottom"
AllowNaturalSort
=
"false"
UseAllDataFields
=
"true"
>
<
CommandItemSettings
ShowExportToExcelButton
=
"true"
ShowAddNewRecordButton
=
"false"
ShowRefreshButton
=
"false"
/>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"Assignee"
HeaderText
=
"Assignee"
UniqueName
=
"Assignee"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"150px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"RadComboBoxTitle"
DataTextField
=
"Value"
DataValueField
=
"Value"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("Assignee").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="TitleIndexChanged1" Width="145px"
DataSource="<%# GenerateComboBoxAssigneesJuris() %>">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock1"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function TitleIndexChanged1(sender,args) {
var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("Assignee",args.get_item().get_value(),"EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"State"
HeaderText
=
"State"
UniqueName
=
"State"
ItemStyle-HorizontalAlign
=
"Center"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"60px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"RadComboBoxState"
DataTextField
=
"value"
DataValueField
=
"value"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("State").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="StateIndexChanged2" Width="50px"
DataSource="<%# ComboBoxAssigneeState() %>">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock3"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function StateIndexChanged2(sender,args) {
var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("State",args.get_item().get_value(),"EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"WorkStatus"
HeaderText
=
"Work Status"
UniqueName
=
"WorkStatus"
ItemStyle-HorizontalAlign
=
"Center"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"150px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"RadComboWorkStatus"
DataTextField
=
"value"
DataValueField
=
"value"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("WorkStatus").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="WorkIndexChanged" Width="150px"
DataSource="<%# ComboBoxWorkStatus() %>">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock4"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function WorkIndexChanged(sender,args) {
var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("WorkStatus",args.get_item().get_value(),"EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
</
telerik:GridBoundColumn
>
<%-- <
telerik:GridTemplateColumn
DataField
=
"State"
HeaderText
=
"State"
UniqueName
=
"State"
SortExpression
=
"State"
AllowFiltering
=
"false"
Visible
=
"true"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"150px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
ItemTemplate
>
<
asp:Label
ID
=
"lbState"
runat
=
"server"
Text='<%# Eval("State") %>'></
asp:Label
>
</
ItemTemplate
>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"true"
/>
</
telerik:GridTemplateColumn
>--%>
<
telerik:GridTemplateColumn
DataField
=
"JurisdictionELD"
HeaderText
=
"ELD"
UniqueName
=
"ELD"
SortExpression
=
"JurisdictionELD"
AllowFiltering
=
"false"
ItemStyle-HorizontalAlign
=
"Center"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"60px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
ItemTemplate
>
<
asp:Label
ID
=
"lbELD"
runat
=
"server"
Text='<%# Eval("JurisdictionELD", "{0:M/yy}")%>'></
asp:Label
>
</
ItemTemplate
>
<
ItemStyle
HorizontalAlign
=
"Center"
ForeColor
=
"Black"
/>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"true"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"Jurisdiction"
HeaderText
=
"Jurisdiction"
UniqueName
=
"Jurisdiction"
ItemStyle-HorizontalAlign
=
"Center"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"150px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"RadComboJurisdiction"
DataTextField
=
"value"
DataValueField
=
"value"
AppendDataBoundItems
=
"true"
runat
=
"server"
OnClientSelectedIndexChanged
=
"JurisIndexChanged"
Width
=
"150px"
DataSource="<%# ComboBoxJurisdictions() %>">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock5"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function JurisIndexChanged(sender,args) {
var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("Jurisdiction",args.get_item().get_value(),"EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"ProcurementMethod"
HeaderText
=
"Proc Meth"
UniqueName
=
"ProcurementMethod"
ItemStyle-HorizontalAlign
=
"Center"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"150px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"RadComboProcMeth"
DataTextField
=
"Description"
DataValueField
=
"Description"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("ProcurementMethod").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="ProcIndexChanged" Width="150px"
DataSource="<%# GenerateProcMeth() %>">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock6"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function ProcIndexChanged(sender,args) {
var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("ProcurementMethod",args.get_item().get_value(),"EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
</
telerik:GridBoundColumn
>
<
telerik:GridTemplateColumn
DataField
=
"PercentComplete"
HeaderText
=
"% Complete"
UniqueName
=
"clmPctComplete"
SortExpression
=
"PercentComplete"
AllowFiltering
=
"false"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"80px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblPctCompleteAssignee"
runat
=
"server"
Text='<%# Eval("PercentComplete", "{0:F2}%")%>'></
asp:Label
>
</
ItemTemplate
>
<
ItemStyle
HorizontalAlign
=
"Right"
ForeColor
=
"Black"
/>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"true"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"TotalItems"
HeaderText
=
"Total Items"
UniqueName
=
"TotalItems"
SortExpression
=
"TotalItems"
AllowFiltering
=
"false"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"100px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblTotalItemsAssignee"
runat
=
"server"
Text='<%# Eval("TotalItems", "{0:N0}") %>'></
asp:Label
>
</
ItemTemplate
>
<
ItemStyle
HorizontalAlign
=
"Right"
ForeColor
=
"Black"
/>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"true"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"StillOpenCount"
HeaderText
=
"Still Open"
UniqueName
=
"StillOpen"
SortExpression
=
"StillOpenCount"
AllowFiltering
=
"false"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"100px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
ItemTemplate
>
<
asp:Label
ID
=
"lbStillOpenAssignee"
runat
=
"server"
Text='<%# Eval("StillOpenCount", "{0:N0}") %>'></
asp:Label
>
</
ItemTemplate
>
<
ItemStyle
HorizontalAlign
=
"Right"
ForeColor
=
"Black"
/>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"true"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"UnworkableItemsCount"
HeaderText
=
"Unworkable"
UniqueName
=
"Unworkable"
SortExpression
=
"UnworkableItemsCount"
AllowFiltering
=
"false"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"105px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblUnworkableAssignee"
runat
=
"server"
Text='<%# Eval("UnworkableItemsCount", "{0:N0}") %>'></
asp:Label
>
</
ItemTemplate
>
<
ItemStyle
HorizontalAlign
=
"Right"
ForeColor
=
"Black"
/>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"true"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"WorkableItemsCount"
HeaderText
=
"Workable"
UniqueName
=
"WorkableItemsCount"
SortExpression
=
"WorkableItemsCount"
AllowFiltering
=
"false"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"105px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblWorkableAssignee"
runat
=
"server"
Text='<%# Eval("WorkableItemsCount", "{0:N0}") %>'></
asp:Label
>
</
ItemTemplate
>
<
ItemStyle
HorizontalAlign
=
"Right"
ForeColor
=
"Black"
/>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"true"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"IsLR"
HeaderText
=
"LR"
UniqueName
=
"IsLR"
ItemStyle-HorizontalAlign
=
"Center"
SortExpression
=
"IsLR"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"60px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"RadComboBoxLR"
DataTextField
=
"value"
DataValueField
=
"value"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("IsLR").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="LRIndexChanged" Width="50px" DataSource="<%# ComboYesNo() %>">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock7"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function LRIndexChanged(sender,args) {
var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("IsLR",args.get_item().get_value(),"EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"IsHOA"
HeaderText
=
"HOA"
UniqueName
=
"IsHOA"
ItemStyle-HorizontalAlign
=
"Center"
SortExpression
=
"isHOA"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"60px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"RadComboBoxHOA"
DataTextField
=
"value"
DataValueField
=
"value"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("IsHOA").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="HOAIndexChanged" Width="50px" DataSource="<%# ComboYesNo() %>">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock8"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function HOAIndexChanged(sender,args) {
var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("IsHOA",args.get_item().get_value(),"EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
</
telerik:GridBoundColumn
>
<
telerik:GridTemplateColumn
DataField
=
"TSPayeeCode"
HeaderText
=
"TS Payee"
UniqueName
=
"TSPayee"
SortExpression
=
"TSPayeeCode"
AllowFiltering
=
"false"
>
<
HeaderStyle
Font-Bold
=
"True"
Width
=
"105px"
HorizontalAlign
=
"Center"
Font-Names
=
"Arial"
/>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblTSPayee"
runat
=
"server"
Text='<%# Eval("TSPayeeCode", "{0:N0}") %>'></
asp:Label
>
</
ItemTemplate
>
<
ItemStyle
HorizontalAlign
=
"Right"
ForeColor
=
"Black"
/>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"true"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"AssigneeEmployeeKey"
ReadOnly
=
"True"
UniqueName
=
"AssigneeEmployeeKey"
Visible
=
"False"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
<
HeaderStyle
BorderStyle
=
"Solid"
/>
<
ClientSettings
>
<
Scrolling
AllowScroll
=
"True"
UseStaticHeaders
=
"True"
/>
</
ClientSettings
>
</
telerik:RadGrid
>
</
div
>
</
asp:Panel
>
</
asp:Panel
>
</
form
>
</
body
>
</
html
>