Hi,
We are using the following controls in our VS2005 project.
radiobuttonlist
RadWindowManager
RadGrid
We have converted that project from VS2005 to VS2010.
When we are running the project in 4.0 of the VS2010, we got the following error like "Parameter count mismatch."
After that I set enableViewState = "false" in web.config, it was loading well.
The expand of the Grid is fine but when we click on this symbol (-) to collapse, it produces the same error like
"Parameter count mismatch."
I have attached the screen shot.
Kindly do the needful.
aspx
******
<%@ Register Assembly="RadWindow.Net2" Namespace="Telerik.WebControls" TagPrefix="radW" %>
<%@ Register Assembly="RadCombobox.Net2" Namespace="Telerik.WebControls" TagPrefix="radC" %>
<%@ Register Assembly="RadGrid.Net2" Namespace="Telerik.WebControls" TagPrefix="radG" %>
<%@ Register TagPrefix="UserControl" TagName="Header" Src="header.ascx" %>
<%@ Register TagPrefix="UserControl" TagName="Footer" Src="footer.ascx" %>
<link href="hierarchy.css" rel="stylesheet" type="text/css" />
<UserControl:Header ID="myHeader" runat="Server"></UserControl:Header>
<table border="0" width="100%" cellpadding="5" cellspacing="0" height="390" style="border-right: silver 1px solid;
border-top: silver 1px solid; border-left: silver 1px solid; border-bottom: silver 1px solid">
<form id="Form1" method="post" runat="server">
<tr>
<td colspan="3" height="22" style="border-bottom: silver 1px solid;" align="left"
valign="top">
<font class="Bread"> Cycle :: Task Status</font>
</td>
</tr>
<tr valign="middle" align="left">
<td width="5%">
<table cellpadding="0" cellspacing="0">
<tr>
<td>
<div id="btnRefreshB" runat="server">
<input type="button" class="Button" value="Refresh" onclick='RadGridNamespace.AsyncRequest( "<%= RadGrid1.ClientID %>", "Rebind", "<%= RadGrid1.ClientID %>")' />
</div>
</td>
</tr>
</table>
</td>
<td>
<table cellpadding="0" cellspacing="0" width="350" class="RadGrid" style="border: #cccccc 1px solid;">
<tr>
<td class="HeaderNew" align="center">
<label>
Select Site</label>
</td>
</tr>
<tr>
<td class="Row">
<asp:radiobuttonlist id="rbSites" runat="server" width="350" onselectedindexchanged="rbSites_SelectedIndexChanged"
autopostback="True" repeatdirection="Horizontal"><asp:ListItem Selected="True" Value="('B')">Billing</asp:ListItem>
</asp:radiobuttonlist>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="820" colspan="3">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td>
<radW:RadWindowManager ID="RadWindowManager1" runat="server">
<Windows>
<radW:RadWindow ID="RadWindow1" runat="server" Left="" Title="XMS Admin" Top="" Height="550px"
NavigateUrl="" VisibleStatusbar="False" Width="840px" EnableTheming="False" MinimizeMode="MinimizeZone"
MinimizeZoneId="MinimizeZone" />
</Windows>
</radW:RadWindowManager>
<radG:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" PageSize="100" CssClass="RadGrid"
HorizontalAlign="NotSet" EnableAsyncRequests="True" Width="930px" AllowSorting="True"
DataSourceID="XMS_CYCLE_TASK_B">
<MasterTableView AutoGenerateColumns="False" DataKeyNames="TASK_ID" DataSourceID="XMS_CYCLE_TASK_B">
<EditFormSettings>
<EditColumn UniqueName="EditCommandColumn">
</EditColumn>
</EditFormSettings>
<Columns>
<radG:GridBoundColumn DataField="TASK_ID" DataType="System.Decimal" HeaderText="Task ID"
ReadOnly="True" SortExpression="TASK_ID" UniqueName="TASK_ID">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridHyperLinkColumn DataTextField="CYCLE_ID" DataType="System.Decimal" HeaderText="Cycle ID"
DataNavigateUrlField="CYCLE_ID" DataNavigateUrlFormatString="javascript:function anon(){{window.radopen('dal_policy_detail.aspx?CycleId={0}','RadWindow1');}};anon();"
SortExpression="CYCLE_ID" UniqueName="CYCLE_ID">
<ItemStyle HorizontalAlign="Center" />
</radG:GridHyperLinkColumn>
<radG:GridHyperLinkColumn DataTextField="STATUS_NAME" HeaderText="Status" DataNavigateUrlField="TASK_ID"
DataNavigateUrlFormatString="javascript:function anon(){{window.radopen('log_viewer.aspx?AuditId={0}&EventSourceID=3','RadWindow1');}};anon();"
SortExpression="STATUS_NAME" UniqueName="STATUS_NAME_1">
<ItemStyle HorizontalAlign="Center" />
</radG:GridHyperLinkColumn>
<radG:GridBoundColumn DataField="STATUS_NAME" HeaderText="Status" ReadOnly="True"
SortExpression="STATUS_NAME" UniqueName="STATUS_NAME_2">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="SYSTEM_NAME" HeaderText="System" SortExpression="SYSTEM_NAME"
UniqueName="SYSTEM_NAME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="DOCUMENT_COUNT" HeaderText="T" SortExpression="DOCUMENT_COUNT"
UniqueName="DOCUMENT_COUNT">
<ItemStyle HorizontalAlign="Center" Width="16px" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="ERROR_COUNT" HeaderText="F" SortExpression="ERROR_COUNT"
UniqueName="ERROR_COUNT">
<ItemStyle HorizontalAlign="Center" Width="16px" ForeColor="Red" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="START_TIME" DataType="System.DateTime" HeaderText="Start Time"
SortExpression="START_TIME" UniqueName="START_TIME">
<ItemStyle HorizontalAlign="Left" Width="130px" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="END_TIME" DataType="System.DateTime" HeaderText="End Time"
SortExpression="END_TIME" UniqueName="END_TIME">
<ItemStyle HorizontalAlign="Left" Width="130px" />
</radG:GridBoundColumn>
</Columns>
<ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn">
<HeaderStyle Width="19px" />
</ExpandCollapseColumn>
<DetailTables>
<radG:GridTableView DataKeyNames="DEST_ID" DataSourceID="XMS_CYCLE_DEST_D" AutoGenerateColumns="False"
runat="server" HierarchyDefaultExpanded="True">
<ParentTableRelation>
<radG:GridRelationFields DetailKeyField="TASK_ID" MasterKeyField="TASK_ID" />
</ParentTableRelation>
<ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn">
<HeaderStyle Width="19px" />
</ExpandCollapseColumn>
<RowIndicatorColumn UniqueName="RowIndicator" Visible="False">
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<Columns>
<radG:GridBoundColumn DataField="DEST_ID" DataType="System.Decimal" HeaderText="Dest ID"
SortExpression="DEST_ID" UniqueName="DEST_ID">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="STATUS_NAME" HeaderText="Status" SortExpression="STATUS_NAME"
UniqueName="STATUS_NAME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="PRINT_DEST" HeaderText="Jobs" SortExpression="PRINT_DEST"
UniqueName="PRINT_DEST">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="POLICY_COUNT" HeaderText="Policies" SortExpression="POLICY_COUNT"
UniqueName="POLICY_COUNT">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="START_TIME" DataType="System.DateTime" HeaderText="Start Time"
SortExpression="START_TIME" UniqueName="START_TIME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="END_TIME" DataType="System.DateTime" HeaderText="End Time"
SortExpression="END_TIME" UniqueName="END_TIME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
</Columns>
<DetailTables>
<radG:GridTableView runat="server" DataKeyNames="SUBTASK_ID" DataSourceID="XMS_CYCLE_SUBTASK_D"
AutoGenerateColumns="False" HierarchyDefaultExpanded="True">
<ParentTableRelation>
<radG:GridRelationFields DetailKeyField="DEST_ID" MasterKeyField="DEST_ID" />
</ParentTableRelation>
<ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn">
<HeaderStyle Width="19px" />
</ExpandCollapseColumn>
<RowIndicatorColumn UniqueName="RowIndicator" Visible="False">
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<Columns>
<radG:GridBoundColumn DataField="SUBTASK_ID" DataType="System.Decimal" HeaderText="SubTask ID"
SortExpression="SUBTASK_ID" UniqueName="SUBTASK_ID">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="STATUS_NAME" HeaderText="Status" SortExpression="STATUS_NAME"
UniqueName="STATUS_NAME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="SUBSYSTEM_NAME" DataType="System.Decimal" HeaderText="Sub System"
SortExpression="SUBSYSTEM_NAME" UniqueName="SUBSYSTEM_NAME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="POLICY_COUNT" DataType="System.Decimal" HeaderText="Policies"
SortExpression="POLICY_COUNT" UniqueName="POLICY_COUNT">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="START_TIME" DataType="System.DateTime" HeaderText="Start Time"
SortExpression="START_TIME" UniqueName="START_TIME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="END_TIME" DataType="System.DateTime" HeaderText="End Time"
SortExpression="END_TIME" UniqueName="END_TIME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
</Columns>
<DetailTables>
<radG:GridTableView runat="server" DataKeyNames="BATCH_ID" DataSourceID="XMS_CYCLE_BATCH_D"
AutoGenerateColumns="False">
<ParentTableRelation>
<radG:GridRelationFields DetailKeyField="SUBTASK_ID" MasterKeyField="SUBTASK_ID" />
</ParentTableRelation>
<ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn" Visible="False">
<HeaderStyle Width="19px" />
</ExpandCollapseColumn>
<RowIndicatorColumn UniqueName="RowIndicator" Visible="False">
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<Columns>
<radG:GridBoundColumn DataField="BATCH_ID" DataType="System.Decimal" HeaderText="Batch ID"
SortExpression="BATCH_ID" UniqueName="BATCH_ID">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="STATUS_NAME" HeaderText="Status" SortExpression="STATUS_NAME"
UniqueName="STATUS_NAME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="POLICY_COUNT" DataType="System.Decimal" HeaderText="Policies"
SortExpression="POLICY_COUNT" UniqueName="POLICY_COUNT">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="START_TIME" DataType="System.DateTime" HeaderText="Start Time"
SortExpression="START_TIME" UniqueName="START_TIME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="END_TIME" DataType="System.DateTime" HeaderText="End Time"
SortExpression="END_TIME" UniqueName="END_TIME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
</Columns>
<EditFormSettings>
<EditColumn UniqueName="EditCommandColumn">
</EditColumn>
</EditFormSettings>
<HeaderStyle CssClass="HeaderNewAlt" />
</radG:GridTableView>
</DetailTables>
<EditFormSettings>
<EditColumn UniqueName="EditCommandColumn">
</EditColumn>
</EditFormSettings>
</radG:GridTableView>
</DetailTables>
<EditFormSettings>
<EditColumn UniqueName="EditCommandColumn">
</EditColumn>
</EditFormSettings>
<HeaderStyle CssClass="HeaderNewAlt" />
</radG:GridTableView>
</DetailTables>
<RowIndicatorColumn UniqueName="RowIndicator" Visible="False">
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
</MasterTableView>
<ItemStyle CssClass="Row" HorizontalAlign="Center" />
<HeaderStyle CssClass="Headerwhitespacewrap" />
<PagerStyle CssClass="Pager" Mode="NextPrevAndNumeric" Position="TopAndBottom" />
<FilterMenu HoverBackColor="LightSteelBlue" HoverBorderColor="Navy" NotSelectedImageUrl="~/RadControls/Grid/Skins/Default/NotSelectedMenu.gif"
SelectColumnBackColor="Control" SelectedImageUrl="~/RadControls/Grid/Skins/Default/SelectedMenu.gif"
TextColumnBackColor="Window"></FilterMenu>
<ClientSettings AllowExpandCollapse="True">
</ClientSettings>
<AlternatingItemStyle CssClass="Row" />
</radG:RadGrid>
<asp:sqldatasource id="XMS_CYCLE_TASK_B" runat="server" connectionstring="<%$ ConnectionStrings:XMS %>"
providername="<%$ ConnectionStrings:XMS.ProviderName %>" selectcommand="SELECT A.TASK_ID, C.STATUS_NAME, A.SYSTEM_ID, B.SYSTEM_NAME,D.CYCLE_ID,A.START_TIME, A.END_TIME,D.DOCUMENT_COUNT,DECODE(D.ERRORF,NULL,'N','Y') ERROR_FLAG FROM XMS_CYCLE_TASK A,XMS_SYSTEM B,XMS_STATUS_CODES C,(SELECT BILL.CYCLE_ID,DOCUMENT_COUNT,ERR.CYCLE_ID AS ERRORF FROM (SELECT DISTINCT CYCLE_ID FROM CUSTOMER_DATA_SCHEMA.BILLING B,XMS_CYCLE_BATCH XCB WHERE XCB.BATCH_STATUS=2399 AND B.XMS_BATCH_ID=XCB.BATCH_ID) ERR, (SELECT CYCLE_ID,COUNT(1) DOCUMENT_COUNT FROM CUSTOMER_DATA_SCHEMA.BILLING GROUP BY CYCLE_ID) BILL WHERE ERR.CYCLE_ID(+)=BILL.CYCLE_ID) D WHERE D.CYCLE_ID = A.CYCLE_ID AND A.SYSTEM_ID = B.SYSTEM_ID AND A.TASK_STATUS = C.STATUS_CODE AND A.SYSTEM_ID IN SYSTEM_IDS ORDER BY TASK_ID DESC"
onselecting="XMS_CYCLE_TASK_B_Selecting">
</asp:sqldatasource>
<asp:sqldatasource id="XMS_CYCLE_DEST_D" runat="server" connectionstring="<%$ ConnectionStrings:XMS %>"
providername="<%$ ConnectionStrings:XMS.ProviderName %>" selectcommand="SELECT A.DEST_ID, B.STATUS_NAME, A.TASK_ID, A.PRINT_DEST, A.POLICY_COUNT, A.START_TIME, A.END_TIME FROM XMS_CYCLE_DEST A INNER JOIN XMS_STATUS_CODES B ON A.DEST_STATUS = B.STATUS_CODE AND (A.TASK_ID = :TASK_ID) LEFT JOIN XMS_IMAGELOAD_TASK C ON A.DEST_ID = C.CYCLE_DEST_ID ORDER BY A.DEST_ID">
<SelectParameters>
<asp:Parameter Type="Decimal" Name="TASK_ID"></asp:Parameter>
</SelectParameters>
</asp:sqldatasource>
<asp:sqldatasource id="XMS_CYCLE_SUBTASK_D" runat="server" connectionstring="<%$ ConnectionStrings:XMS %>"
providername="<%$ ConnectionStrings:XMS.ProviderName %>" selectcommand='SELECT A."SUBTASK_ID", B."STATUS_NAME", C."SUBSYSTEM_NAME", A."POLICY_COUNT", A."START_TIME", A."END_TIME" FROM "XMS_CYCLE_SUBTASK" A, "XMS_STATUS_CODES" B , "XMS_SUBSYSTEM" C WHERE A.SUBTASK_STATUS = B.STATUS_CODE AND A.SUBSYSTEM_ID = C.SUBSYSTEM_ID AND ("DEST_ID" = :DEST_ID) ORDER BY "SUBTASK_ID"'><SelectParameters>
<asp:Parameter Type="Decimal" Name="DEST_ID"></asp:Parameter>
</SelectParameters>
</asp:sqldatasource>
<asp:sqldatasource id="XMS_CYCLE_BATCH_D" runat="server" connectionstring="<%$ ConnectionStrings:XMS %>"
providername="<%$ ConnectionStrings:XMS.ProviderName %>" selectcommand='SELECT "BATCH_ID", "STATUS_NAME", "POLICY_COUNT", "START_TIME", "END_TIME" FROM "XMS_CYCLE_BATCH" A, XMS_STATUS_CODES B WHERE A.BATCH_STATUS = B.STATUS_CODE AND ("SUBTASK_ID" = :SUBTASK_ID) ORDER BY "BATCH_ID"'><SelectParameters>
<asp:Parameter Type="Decimal" Name="SUBTASK_ID"></asp:Parameter>
</SelectParameters>
</asp:sqldatasource>
</td>
</tr>
<tr>
<td style="border-right: #e9e9e9 1px solid; border-left: #e9e9e9 1px solid; border-bottom: #e9e9e9 1px solid;">
<table class="radgrid" cellpadding="2" cellspacing="5" style="border-top-style: none;
border-right-style: none; border-left-style: none; border-bottom-style: none;">
<tr>
<td>
T - Total
</td>
<td>
F - Failed
</td>
<td>
P - Paper
</td>
<td>
E - Electronic
</td>
<td>
R - Replacements
</td>
<td>
C - Cost Disclosures
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td id="MinimizeZone">
</td>
</tr>
</table>
</td>
</tr>
</form>
</table>
<UserControl:Footer ID="myFooter" runat="Server"></UserControl:Footer>
.cs
***
protected void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
if (PageUtility.CheckLevel2(this.Session))
{
RadGrid1.Columns.FindByUniqueName("STATUS_NAME_1").Visible = false;
RadGrid1.Columns.FindByUniqueName("STATUS_NAME_2").Visible = true;
}
else
{
RadGrid1.Columns.FindByUniqueName("STATUS_NAME_2").Visible = false;
RadGrid1.Columns.FindByUniqueName("STATUS_NAME_1").Visible = true;
}
if (!Page.IsPostBack)
{
Initialize();
}
}
private void Initialize()
{
if (PageUtility.GetUserSite(this.Session) == "B")
{
rbSites.SelectedIndex = 0;
}
SiteSettings();
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
}
#endregion
protected override void RaisePostBackEvent(IPostBackEventHandler sourceControl, string eventArgument)
{
base.RaisePostBackEvent(sourceControl, eventArgument);
if (sourceControl == this.RadGrid1)
{
RadGrid1.Rebind();
}
}
protected void rbSystems_SelectedIndexChanged(object sender, EventArgs e)
{
SiteSettings();
RadGrid1.DataBind();
}
protected void XMS_CYCLE_TASK_B_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
string strArgValue = "";
if (rbSites.SelectedValue == "('B')")
{
strArgValue = "('B')";
}
string strQuery = e.Command.CommandText.Replace("SYSTEM_IDS", strArgValue);
e.Command.CommandText = strQuery;
}
protected void rbSites_SelectedIndexChanged(object sender, EventArgs e)
{
SiteSettings();
RadGrid1.DataBind();
}
private void SiteSettings()
{
if (rbSites.SelectedValue == "('B')")
{
RadGrid1.Visible = true;
btnRefreshB.Visible = true;
}
}
We are using the following controls in our VS2005 project.
radiobuttonlist
RadWindowManager
RadGrid
We have converted that project from VS2005 to VS2010.
When we are running the project in 4.0 of the VS2010, we got the following error like "Parameter count mismatch."
After that I set enableViewState = "false" in web.config, it was loading well.
The expand of the Grid is fine but when we click on this symbol (-) to collapse, it produces the same error like
"Parameter count mismatch."
I have attached the screen shot.
Kindly do the needful.
aspx
******
<%@ Register Assembly="RadWindow.Net2" Namespace="Telerik.WebControls" TagPrefix="radW" %>
<%@ Register Assembly="RadCombobox.Net2" Namespace="Telerik.WebControls" TagPrefix="radC" %>
<%@ Register Assembly="RadGrid.Net2" Namespace="Telerik.WebControls" TagPrefix="radG" %>
<%@ Register TagPrefix="UserControl" TagName="Header" Src="header.ascx" %>
<%@ Register TagPrefix="UserControl" TagName="Footer" Src="footer.ascx" %>
<link href="hierarchy.css" rel="stylesheet" type="text/css" />
<UserControl:Header ID="myHeader" runat="Server"></UserControl:Header>
<table border="0" width="100%" cellpadding="5" cellspacing="0" height="390" style="border-right: silver 1px solid;
border-top: silver 1px solid; border-left: silver 1px solid; border-bottom: silver 1px solid">
<form id="Form1" method="post" runat="server">
<tr>
<td colspan="3" height="22" style="border-bottom: silver 1px solid;" align="left"
valign="top">
<font class="Bread"> Cycle :: Task Status</font>
</td>
</tr>
<tr valign="middle" align="left">
<td width="5%">
<table cellpadding="0" cellspacing="0">
<tr>
<td>
<div id="btnRefreshB" runat="server">
<input type="button" class="Button" value="Refresh" onclick='RadGridNamespace.AsyncRequest( "<%= RadGrid1.ClientID %>", "Rebind", "<%= RadGrid1.ClientID %>")' />
</div>
</td>
</tr>
</table>
</td>
<td>
<table cellpadding="0" cellspacing="0" width="350" class="RadGrid" style="border: #cccccc 1px solid;">
<tr>
<td class="HeaderNew" align="center">
<label>
Select Site</label>
</td>
</tr>
<tr>
<td class="Row">
<asp:radiobuttonlist id="rbSites" runat="server" width="350" onselectedindexchanged="rbSites_SelectedIndexChanged"
autopostback="True" repeatdirection="Horizontal"><asp:ListItem Selected="True" Value="('B')">Billing</asp:ListItem>
</asp:radiobuttonlist>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="820" colspan="3">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td>
<radW:RadWindowManager ID="RadWindowManager1" runat="server">
<Windows>
<radW:RadWindow ID="RadWindow1" runat="server" Left="" Title="XMS Admin" Top="" Height="550px"
NavigateUrl="" VisibleStatusbar="False" Width="840px" EnableTheming="False" MinimizeMode="MinimizeZone"
MinimizeZoneId="MinimizeZone" />
</Windows>
</radW:RadWindowManager>
<radG:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" PageSize="100" CssClass="RadGrid"
HorizontalAlign="NotSet" EnableAsyncRequests="True" Width="930px" AllowSorting="True"
DataSourceID="XMS_CYCLE_TASK_B">
<MasterTableView AutoGenerateColumns="False" DataKeyNames="TASK_ID" DataSourceID="XMS_CYCLE_TASK_B">
<EditFormSettings>
<EditColumn UniqueName="EditCommandColumn">
</EditColumn>
</EditFormSettings>
<Columns>
<radG:GridBoundColumn DataField="TASK_ID" DataType="System.Decimal" HeaderText="Task ID"
ReadOnly="True" SortExpression="TASK_ID" UniqueName="TASK_ID">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridHyperLinkColumn DataTextField="CYCLE_ID" DataType="System.Decimal" HeaderText="Cycle ID"
DataNavigateUrlField="CYCLE_ID" DataNavigateUrlFormatString="javascript:function anon(){{window.radopen('dal_policy_detail.aspx?CycleId={0}','RadWindow1');}};anon();"
SortExpression="CYCLE_ID" UniqueName="CYCLE_ID">
<ItemStyle HorizontalAlign="Center" />
</radG:GridHyperLinkColumn>
<radG:GridHyperLinkColumn DataTextField="STATUS_NAME" HeaderText="Status" DataNavigateUrlField="TASK_ID"
DataNavigateUrlFormatString="javascript:function anon(){{window.radopen('log_viewer.aspx?AuditId={0}&EventSourceID=3','RadWindow1');}};anon();"
SortExpression="STATUS_NAME" UniqueName="STATUS_NAME_1">
<ItemStyle HorizontalAlign="Center" />
</radG:GridHyperLinkColumn>
<radG:GridBoundColumn DataField="STATUS_NAME" HeaderText="Status" ReadOnly="True"
SortExpression="STATUS_NAME" UniqueName="STATUS_NAME_2">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="SYSTEM_NAME" HeaderText="System" SortExpression="SYSTEM_NAME"
UniqueName="SYSTEM_NAME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="DOCUMENT_COUNT" HeaderText="T" SortExpression="DOCUMENT_COUNT"
UniqueName="DOCUMENT_COUNT">
<ItemStyle HorizontalAlign="Center" Width="16px" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="ERROR_COUNT" HeaderText="F" SortExpression="ERROR_COUNT"
UniqueName="ERROR_COUNT">
<ItemStyle HorizontalAlign="Center" Width="16px" ForeColor="Red" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="START_TIME" DataType="System.DateTime" HeaderText="Start Time"
SortExpression="START_TIME" UniqueName="START_TIME">
<ItemStyle HorizontalAlign="Left" Width="130px" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="END_TIME" DataType="System.DateTime" HeaderText="End Time"
SortExpression="END_TIME" UniqueName="END_TIME">
<ItemStyle HorizontalAlign="Left" Width="130px" />
</radG:GridBoundColumn>
</Columns>
<ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn">
<HeaderStyle Width="19px" />
</ExpandCollapseColumn>
<DetailTables>
<radG:GridTableView DataKeyNames="DEST_ID" DataSourceID="XMS_CYCLE_DEST_D" AutoGenerateColumns="False"
runat="server" HierarchyDefaultExpanded="True">
<ParentTableRelation>
<radG:GridRelationFields DetailKeyField="TASK_ID" MasterKeyField="TASK_ID" />
</ParentTableRelation>
<ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn">
<HeaderStyle Width="19px" />
</ExpandCollapseColumn>
<RowIndicatorColumn UniqueName="RowIndicator" Visible="False">
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<Columns>
<radG:GridBoundColumn DataField="DEST_ID" DataType="System.Decimal" HeaderText="Dest ID"
SortExpression="DEST_ID" UniqueName="DEST_ID">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="STATUS_NAME" HeaderText="Status" SortExpression="STATUS_NAME"
UniqueName="STATUS_NAME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="PRINT_DEST" HeaderText="Jobs" SortExpression="PRINT_DEST"
UniqueName="PRINT_DEST">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="POLICY_COUNT" HeaderText="Policies" SortExpression="POLICY_COUNT"
UniqueName="POLICY_COUNT">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="START_TIME" DataType="System.DateTime" HeaderText="Start Time"
SortExpression="START_TIME" UniqueName="START_TIME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="END_TIME" DataType="System.DateTime" HeaderText="End Time"
SortExpression="END_TIME" UniqueName="END_TIME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
</Columns>
<DetailTables>
<radG:GridTableView runat="server" DataKeyNames="SUBTASK_ID" DataSourceID="XMS_CYCLE_SUBTASK_D"
AutoGenerateColumns="False" HierarchyDefaultExpanded="True">
<ParentTableRelation>
<radG:GridRelationFields DetailKeyField="DEST_ID" MasterKeyField="DEST_ID" />
</ParentTableRelation>
<ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn">
<HeaderStyle Width="19px" />
</ExpandCollapseColumn>
<RowIndicatorColumn UniqueName="RowIndicator" Visible="False">
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<Columns>
<radG:GridBoundColumn DataField="SUBTASK_ID" DataType="System.Decimal" HeaderText="SubTask ID"
SortExpression="SUBTASK_ID" UniqueName="SUBTASK_ID">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="STATUS_NAME" HeaderText="Status" SortExpression="STATUS_NAME"
UniqueName="STATUS_NAME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="SUBSYSTEM_NAME" DataType="System.Decimal" HeaderText="Sub System"
SortExpression="SUBSYSTEM_NAME" UniqueName="SUBSYSTEM_NAME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="POLICY_COUNT" DataType="System.Decimal" HeaderText="Policies"
SortExpression="POLICY_COUNT" UniqueName="POLICY_COUNT">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="START_TIME" DataType="System.DateTime" HeaderText="Start Time"
SortExpression="START_TIME" UniqueName="START_TIME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="END_TIME" DataType="System.DateTime" HeaderText="End Time"
SortExpression="END_TIME" UniqueName="END_TIME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
</Columns>
<DetailTables>
<radG:GridTableView runat="server" DataKeyNames="BATCH_ID" DataSourceID="XMS_CYCLE_BATCH_D"
AutoGenerateColumns="False">
<ParentTableRelation>
<radG:GridRelationFields DetailKeyField="SUBTASK_ID" MasterKeyField="SUBTASK_ID" />
</ParentTableRelation>
<ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn" Visible="False">
<HeaderStyle Width="19px" />
</ExpandCollapseColumn>
<RowIndicatorColumn UniqueName="RowIndicator" Visible="False">
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<Columns>
<radG:GridBoundColumn DataField="BATCH_ID" DataType="System.Decimal" HeaderText="Batch ID"
SortExpression="BATCH_ID" UniqueName="BATCH_ID">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="STATUS_NAME" HeaderText="Status" SortExpression="STATUS_NAME"
UniqueName="STATUS_NAME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="POLICY_COUNT" DataType="System.Decimal" HeaderText="Policies"
SortExpression="POLICY_COUNT" UniqueName="POLICY_COUNT">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="START_TIME" DataType="System.DateTime" HeaderText="Start Time"
SortExpression="START_TIME" UniqueName="START_TIME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="END_TIME" DataType="System.DateTime" HeaderText="End Time"
SortExpression="END_TIME" UniqueName="END_TIME">
<ItemStyle HorizontalAlign="Center" />
</radG:GridBoundColumn>
</Columns>
<EditFormSettings>
<EditColumn UniqueName="EditCommandColumn">
</EditColumn>
</EditFormSettings>
<HeaderStyle CssClass="HeaderNewAlt" />
</radG:GridTableView>
</DetailTables>
<EditFormSettings>
<EditColumn UniqueName="EditCommandColumn">
</EditColumn>
</EditFormSettings>
</radG:GridTableView>
</DetailTables>
<EditFormSettings>
<EditColumn UniqueName="EditCommandColumn">
</EditColumn>
</EditFormSettings>
<HeaderStyle CssClass="HeaderNewAlt" />
</radG:GridTableView>
</DetailTables>
<RowIndicatorColumn UniqueName="RowIndicator" Visible="False">
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
</MasterTableView>
<ItemStyle CssClass="Row" HorizontalAlign="Center" />
<HeaderStyle CssClass="Headerwhitespacewrap" />
<PagerStyle CssClass="Pager" Mode="NextPrevAndNumeric" Position="TopAndBottom" />
<FilterMenu HoverBackColor="LightSteelBlue" HoverBorderColor="Navy" NotSelectedImageUrl="~/RadControls/Grid/Skins/Default/NotSelectedMenu.gif"
SelectColumnBackColor="Control" SelectedImageUrl="~/RadControls/Grid/Skins/Default/SelectedMenu.gif"
TextColumnBackColor="Window"></FilterMenu>
<ClientSettings AllowExpandCollapse="True">
</ClientSettings>
<AlternatingItemStyle CssClass="Row" />
</radG:RadGrid>
<asp:sqldatasource id="XMS_CYCLE_TASK_B" runat="server" connectionstring="<%$ ConnectionStrings:XMS %>"
providername="<%$ ConnectionStrings:XMS.ProviderName %>" selectcommand="SELECT A.TASK_ID, C.STATUS_NAME, A.SYSTEM_ID, B.SYSTEM_NAME,D.CYCLE_ID,A.START_TIME, A.END_TIME,D.DOCUMENT_COUNT,DECODE(D.ERRORF,NULL,'N','Y') ERROR_FLAG FROM XMS_CYCLE_TASK A,XMS_SYSTEM B,XMS_STATUS_CODES C,(SELECT BILL.CYCLE_ID,DOCUMENT_COUNT,ERR.CYCLE_ID AS ERRORF FROM (SELECT DISTINCT CYCLE_ID FROM CUSTOMER_DATA_SCHEMA.BILLING B,XMS_CYCLE_BATCH XCB WHERE XCB.BATCH_STATUS=2399 AND B.XMS_BATCH_ID=XCB.BATCH_ID) ERR, (SELECT CYCLE_ID,COUNT(1) DOCUMENT_COUNT FROM CUSTOMER_DATA_SCHEMA.BILLING GROUP BY CYCLE_ID) BILL WHERE ERR.CYCLE_ID(+)=BILL.CYCLE_ID) D WHERE D.CYCLE_ID = A.CYCLE_ID AND A.SYSTEM_ID = B.SYSTEM_ID AND A.TASK_STATUS = C.STATUS_CODE AND A.SYSTEM_ID IN SYSTEM_IDS ORDER BY TASK_ID DESC"
onselecting="XMS_CYCLE_TASK_B_Selecting">
</asp:sqldatasource>
<asp:sqldatasource id="XMS_CYCLE_DEST_D" runat="server" connectionstring="<%$ ConnectionStrings:XMS %>"
providername="<%$ ConnectionStrings:XMS.ProviderName %>" selectcommand="SELECT A.DEST_ID, B.STATUS_NAME, A.TASK_ID, A.PRINT_DEST, A.POLICY_COUNT, A.START_TIME, A.END_TIME FROM XMS_CYCLE_DEST A INNER JOIN XMS_STATUS_CODES B ON A.DEST_STATUS = B.STATUS_CODE AND (A.TASK_ID = :TASK_ID) LEFT JOIN XMS_IMAGELOAD_TASK C ON A.DEST_ID = C.CYCLE_DEST_ID ORDER BY A.DEST_ID">
<SelectParameters>
<asp:Parameter Type="Decimal" Name="TASK_ID"></asp:Parameter>
</SelectParameters>
</asp:sqldatasource>
<asp:sqldatasource id="XMS_CYCLE_SUBTASK_D" runat="server" connectionstring="<%$ ConnectionStrings:XMS %>"
providername="<%$ ConnectionStrings:XMS.ProviderName %>" selectcommand='SELECT A."SUBTASK_ID", B."STATUS_NAME", C."SUBSYSTEM_NAME", A."POLICY_COUNT", A."START_TIME", A."END_TIME" FROM "XMS_CYCLE_SUBTASK" A, "XMS_STATUS_CODES" B , "XMS_SUBSYSTEM" C WHERE A.SUBTASK_STATUS = B.STATUS_CODE AND A.SUBSYSTEM_ID = C.SUBSYSTEM_ID AND ("DEST_ID" = :DEST_ID) ORDER BY "SUBTASK_ID"'><SelectParameters>
<asp:Parameter Type="Decimal" Name="DEST_ID"></asp:Parameter>
</SelectParameters>
</asp:sqldatasource>
<asp:sqldatasource id="XMS_CYCLE_BATCH_D" runat="server" connectionstring="<%$ ConnectionStrings:XMS %>"
providername="<%$ ConnectionStrings:XMS.ProviderName %>" selectcommand='SELECT "BATCH_ID", "STATUS_NAME", "POLICY_COUNT", "START_TIME", "END_TIME" FROM "XMS_CYCLE_BATCH" A, XMS_STATUS_CODES B WHERE A.BATCH_STATUS = B.STATUS_CODE AND ("SUBTASK_ID" = :SUBTASK_ID) ORDER BY "BATCH_ID"'><SelectParameters>
<asp:Parameter Type="Decimal" Name="SUBTASK_ID"></asp:Parameter>
</SelectParameters>
</asp:sqldatasource>
</td>
</tr>
<tr>
<td style="border-right: #e9e9e9 1px solid; border-left: #e9e9e9 1px solid; border-bottom: #e9e9e9 1px solid;">
<table class="radgrid" cellpadding="2" cellspacing="5" style="border-top-style: none;
border-right-style: none; border-left-style: none; border-bottom-style: none;">
<tr>
<td>
T - Total
</td>
<td>
F - Failed
</td>
<td>
P - Paper
</td>
<td>
E - Electronic
</td>
<td>
R - Replacements
</td>
<td>
C - Cost Disclosures
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td id="MinimizeZone">
</td>
</tr>
</table>
</td>
</tr>
</form>
</table>
<UserControl:Footer ID="myFooter" runat="Server"></UserControl:Footer>
.cs
***
protected void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
if (PageUtility.CheckLevel2(this.Session))
{
RadGrid1.Columns.FindByUniqueName("STATUS_NAME_1").Visible = false;
RadGrid1.Columns.FindByUniqueName("STATUS_NAME_2").Visible = true;
}
else
{
RadGrid1.Columns.FindByUniqueName("STATUS_NAME_2").Visible = false;
RadGrid1.Columns.FindByUniqueName("STATUS_NAME_1").Visible = true;
}
if (!Page.IsPostBack)
{
Initialize();
}
}
private void Initialize()
{
if (PageUtility.GetUserSite(this.Session) == "B")
{
rbSites.SelectedIndex = 0;
}
SiteSettings();
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
}
#endregion
protected override void RaisePostBackEvent(IPostBackEventHandler sourceControl, string eventArgument)
{
base.RaisePostBackEvent(sourceControl, eventArgument);
if (sourceControl == this.RadGrid1)
{
RadGrid1.Rebind();
}
}
protected void rbSystems_SelectedIndexChanged(object sender, EventArgs e)
{
SiteSettings();
RadGrid1.DataBind();
}
protected void XMS_CYCLE_TASK_B_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
string strArgValue = "";
if (rbSites.SelectedValue == "('B')")
{
strArgValue = "('B')";
}
string strQuery = e.Command.CommandText.Replace("SYSTEM_IDS", strArgValue);
e.Command.CommandText = strQuery;
}
protected void rbSites_SelectedIndexChanged(object sender, EventArgs e)
{
SiteSettings();
RadGrid1.DataBind();
}
private void SiteSettings()
{
if (rbSites.SelectedValue == "('B')")
{
RadGrid1.Visible = true;
btnRefreshB.Visible = true;
}
}