Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
78 views

I have a web portal that’s built using Visual Studio 2008 using C# and ASP.net. We are using your controls on this site especially the grid control. We using a master page and one WebUserControl .

 

My problem is with the WebUserControl. It’s basically a telerik grid that’s used to look up a persons by name or social security number. When any page that uses this WebUserControl is displayed the WebUserControl is set to invisible and when the user click a button on a asp:Content page, the page is set to visible = false and the WebUserControl is set to visible = true. This work fine BUT I would like to use the RadAjaxLoadingPanel when the grid is loading. The RadAjaxLoadingPanel works great on all the other grids on the site, but using it in the WebUserControl is nothing but problems, I’ve tried a lot of different way to make it work but it just won’t work correctly. I had to remove the RadAjaxLoadingPanel from the site as it has to be consist across all grids and the grid in the WebUserControl is the most important grid in the site than really needs the RadAjaxLoadingPanel as it take a fair amount of time to load.

I’ve include a copy of the Master Page, a page the uses the WebUserControl and the WebUserControl.

Can’t you provide any help getting the webUserControl to work correctly with the RadAjaxLoadingPanel?

Thank

John

==================================================================================================
Master Page
==================================================================================================
<%@ Master Language="C#" AutoEventWireup="true" CodeFile="MasterPage.master.cs" Inherits="MasterPage" %>
 
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="aspx" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
 
<script type="text/javascript">
 
    // Trap Backspace(8) and Enter(13) -
    // Except bksp on text/textareas, enter on textarea/submit
 
    if (typeof window.event != 'undefined') // IE
        document.onkeydown = function() // IE
        {
            var t = event.srcElement.type;
            var kc = event.keyCode;
            return ((kc != 8 && kc != 13) || (t == 'text' && kc != 13) ||
             (t == 'textarea') || (t == 'submit' && kc == 13))
        }
 
    function GridCreated(sender, args) {
        var scrollArea = sender.GridDataDiv;
        var dataHeight = sender.get_masterTableView().get_element().clientHeight; if (dataHeight < 350) {
            scrollArea.style.height = dataHeight + 18 + "px";
        }
    }
</script>
 
<head id="Head1" runat="server">
    <title>Master Page</title>
    <link rel="stylesheet" type="text/css" href="CSS/style.css" />
    <link rel="stylesheet" type="text/css" href="CSS/WebBlue.css" />
    <meta http-equiv="Pragma" content="no-cache" />
    <style type="text/css">
        .style1
        {
            width: 100%;
        }
    </style>
</head>
<body onload="window.history.forward();">
    <form id="Form1" runat="server">
    <aspx:ToolkitScriptManager runat="Server" ID="ScriptManager1" />
    <table width="100%">
        <tr>
            <td align="center" width="100%">
                <table id="header" style="width: 9in; height: 80px" cellspacing="0" cellpadding="0"
                    border="0">
                    <tr>
                        <td style="height: 75px; width: 100%;" valign="top" align="center">
                            <asp:Image ID="TopImage" runat="server" ImageUrl="~/Images/LUISWebTop.gif" Width="860px"
                                ImageAlign="Middle" Height="75px" />
                        </td>
                    </tr>
                </table>
                <table id="menu" style="width: 9in;" cellspacing="0" cellpadding="0" border="0">
                    <tr>
                        <td style="height: 20px; width: 100%; background-color: #0066b3;" valign="top">
                            <telerik:RadMenu runat="server" ID="RadMenu2" DataSourceID="SiteMapDataSource1" Style="z-index: 4"
                                EnableEmbeddedSkins="false" EnableRoundedCorners="false" EnableShadows="true"
                                CollapseDelay="50" CollapseAnimation-Type="Linear" ExpandAnimation-Type="Linear"
                                Skin="WebBlue">
                            </telerik:RadMenu>
                        </td>
                    </tr>
                </table>
                <table id="leftNav" cellspacing="0" cellpadding="0" border="0" style="width: 9in;
                    table-layout: fixed">
                    <tr>
                        <td style="width: 100%; height: 100%;" valign="top" align="center">
                            <asp:ContentPlaceHolder ID="middleContent" runat="server">
                            </asp:ContentPlaceHolder>
                        </td>
                    </tr>
                </table>
                <table style="border: thin solid #C0C0C0; width: 9in; height: 40px; background-color: #0066B3;"
                    cellspacing="0" cellpadding="0">
                    <tr>
                        <td style="text-align: center">
                            <label class="FooterLabels">
                                Administration Main Phone: (717) 299-8021</label>
                        </td>
                    </tr>
                </table>
                <table style="border: thin solid #C0C0C0; width: 9in; background-color: #0066B3;"
                    cellspacing="0" cellpadding="0">
                    <tr>
                        <td style="width: 33%">
                            <table style="border-color: #C0C0C0; border-style: solid; border-width: thin; padding-left: 5px;
                                width: 100%" cellspacing="0" cellpadding="0">
                                <tr style="line-height: 20px">
                                    <td style="width: 100%">
                                        <label class="FooterLabels">
                                            For Claims:
                                        </label>
                                        <label class="FooterLabels">
                                            MHMRClaimQS@co.lancaster.pa.us
                                        </label>
                                    </td>
                                </tr>
                            </table>
                        </td>
                        <td style="width: 33%">
                            <table style="border-color: #C0C0C0; border-style: solid; border-width: thin; padding-left: 5px;
                                width: 99.7%;" cellspacing="0" cellpadding="0">
                                <tr style="line-height: 20px">
                                    <td style="width: 100%">
                                        <label class="FooterLabels">
                                            For Fiscal/Contracts:
                                        </label>
                                        <label class="FooterLabels">
                                            MHMREIFiscal@co.lancaster.pa.us
                                        </label>
                                    </td>
                                </tr>
                            </table>
                        </td>
                        <td style="width: 33%">
                            <table style="border-color: #C0C0C0; border-style: solid; border-width: thin; padding-left: 5px;
                                width: 100%;" cellspacing="0" cellpadding="0">
                                <tr style="line-height: 20px">
                                    <td style="width: 100%">
                                        <label class="FooterLabels">
                                            For General Assistance:
                                        </label>
                                        <label class="FooterLabels">
                                            MHMRHelpDesk@co.lancaster.pa.us
                                        </label>
                                    </td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
    <asp:SiteMapDataSource ID="SiteMapDataSource1" ShowStartingNode="false" runat="server" />
    </form>
</body>
</html>
======================================================================================================================
Master Page Code
======================================================================================================================
using System;
 
public partial class MasterPage : System.Web.UI.MasterPage
{
    #region Declarations
    clsSessionState ss = new clsSessionState();
    #endregion
 
    public void cmdLogout_Click(object sender, EventArgs e)
    {
        ss.LoginName = "";
 
        Server.Transfer("/LUISPortal/Login.aspx");
    }
 
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
        }
    }
}
================================================================================================================
Content Page
================================================================================================================
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true"
    CodeFile="AddAuth.aspx.cs" Inherits="Authorizations_AddAuth" Title="LUIS - Add Authorizations" %>
 
<%@ OutputCache Location="None" VaryByParam="None" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<%@ Register Src="../../WebUserControls/MemberSearch.ascx" TagName="MemberSearch"
    TagPrefix="uc1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="middleContent" runat="Server">
    <asp:UpdatePanel ID="updPage" runat="server" UpdateMode="Conditional">
        <ContentTemplate>
            <asp:Panel ID="pnlSelector" runat="server" Width="9in" BorderWidth="0">
                <table style="width: 9in">
                    <tr align="center">
                        <td align="right">
                            <asp:RadioButton ID="optAdd" runat="server" Text="Add Authorization" Checked="True"
                                Font-Bold="True" Font-Size="Large" GroupName="AddEdit" OnCheckedChanged="optAdd_OnCheckedChanged"
                                AutoPostBack="True" />
                        </td>
                        <td align="left">
                            <asp:RadioButton ID="optEdit" runat="server" Text="Edit Authorization" Font-Bold="True"
                                Font-Size="Large" GroupName="AddEdit" OnCheckedChanged="optEdit_OnCheckedChanged"
                                AutoPostBack="True" />
                        </td>
                    </tr>
                </table>
            </asp:Panel>
            <asp:Panel ID="pnlTitle" runat="server" Width="9in" BorderWidth="0">
                <table width="100%" border="1">
                    <tr>
                        <td>
                            <table cellpadding="0" cellspacing="0" style="width: 100%; background-color: #0066B3;">
                                <tr align="left" valign="middle">
                                    <td align="left" valign="middle" style="width: 1.6in">
                                           
                                        <asp:Button ID="cmdMemberSearch" runat="server" Text="Member Lookup" Width="1.4in"
                                            OnClick="cmdMemberSearch_Click" />
                                    </td>
                                    <td align="center" valign="middle">
                                        <asp:Label ID="lblAddEdit" runat="server" Text="Add Authorization" ForeColor="White"
                                            Font-Bold="True" Font-Names="Arial" Font-Size="Large">
                                        </asp:Label>
                                    </td>
                                    <td align="right" valign="middle" style="width: 1.6in">
                                        <asp:Button ID="cmdShowAllMembers" runat="server" Text="Show All Members" Width="1.4in"
                                            OnClick="cmdShowAllMembers_Click" />
                                           
                                    </td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                </table>
            </asp:Panel>
            <asp:Panel ID="pnlMemberName" runat="server" Width="9in" BorderWidth="0">
                <table border="1" cellpadding="0" cellspacing="0" style="width: 9in; background-color: #0066B3;">
                    <tr align="center">
                        <td>
                            <table style="width: 100%; background-color: #0066B3;">
                                <tr align="center">
                                    <td align="center" valign="middle">
                                        <asp:Label ID="lblMemberName" runat="server" Text="" Font-Bold="True" ForeColor="White"
                                            Font-Size="Medium">
                                        </asp:Label>
                                    </td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                </table>
            </asp:Panel>
            <asp:UpdatePanel ID="updGrids" runat="server" UpdateMode="Conditional">
                <ContentTemplate>
                    <asp:Panel ID="pnlAuthTitle" runat="server" Width="9in" BorderWidth="0">
                        <table cellpadding="0" cellspacing="0" bgcolor="0066B3" width="100%" style="border: 5px solid #0066B3;">
                            <tr>
                                <td align="left" valign="middle">
                                    <asp:Label ID="Label21" runat="server" Text="Authorizations" Font-Bold="True" ForeColor="White"
                                        Font-Size="Medium">
                                    </asp:Label>
                                </td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <asp:Panel ID="pnlAuthFilter" runat="server" Width="9in" BorderWidth="0">
                        <table style="border: 2px solid #0066B3; width: 100%;">
                            <tr style="vertical-align: middle">
                                <td style="vertical-align: middle">
                                    <asp:Label ID="Label111" runat="server" CssClass="Labels"  Text="Filter: Start Date: "></asp:Label>
                                    <telerik:RadDatePicker runat="server" ID="txtAuthStartDate" Width="1in" Height=".22in"
                                        Calendar-FastNavigationStep="12" DateInput-DateFormat="MM/dd/yyyy" DateInput-DisplayDateFormat="MM/dd/yyyy"
                                        CssClass="TextBox" TabIndex="1">
                                    </telerik:RadDatePicker>
                                      
                                    <asp:Label ID="Label121" runat="server" CssClass="Labels" Text="End Date: "></asp:Label>
                                    <telerik:RadDatePicker runat="server" ID="txtAuthEndDate" Width="1in" Height=".22in"
                                        Calendar-FastNavigationStep="12" DateInput-DateFormat="MM/dd/yyyy" DateInput-DisplayDateFormat="MM/dd/yyyy"
                                        CssClass="TextBox" TabIndex="2">
                                    </telerik:RadDatePicker>
                                      
                                    <asp:Label ID="Label6" runat="server" CssClass="Labels" Text="Status: "></asp:Label>
                                    <asp:DropDownList ID="cboAuthStatus" runat="server" Width="1in" CssClass="DropDown"
                                        TabIndex="3">
                                        <asp:ListItem Text="" Value="-1" />
                                        <asp:ListItem Text="Pending" Value="2" />
                                        <asp:ListItem Text="In Review" Value="4" />
                                        <asp:ListItem Text="Requested" Value="3" />
                                        <asp:ListItem Text="Approved" Value="1" />
                                        <asp:ListItem Text="Rejected" Value="5" />
                                    </asp:DropDownList>
                                      
                                    <asp:Label ID="Label15" runat="server" CssClass="Labels" Text="Division: "></asp:Label>
                                    <asp:DropDownList ID="cboAuthDivision" runat="server" Width=".52in" CssClass="DropDown"
                                        TabIndex="4">
                                        <asp:ListItem Text="" Value="-1" />
                                        <asp:ListItem Text="MH" Value="1" />
                                        <asp:ListItem Text="MR" Value="2" />
                                        <asp:ListItem Text="EI" Value="3" />
                                    </asp:DropDownList>
                                    <asp:Button ID="cmdAuthFilter" runat="server" Width=".55in" Text="Filter" TabIndex="5"
                                        OnClick="cmdAuthFilter_Click" Style="vertical-align: middle" />
                                    <asp:Button ID="cmdAuthClear" runat="server" Width=".55in" Text="Clear" TabIndex="6"
                                        OnClick="cmdAuthClear_Click" Style="vertical-align: middle" />
                                    <asp:Button ID="cmdAuthReset" runat="server" Width=".55in" Text="Reset" TabIndex="7"
                                        OnClick="cmdAuthReset_Click" Style="vertical-align: middle" />
                                </td>
                            </tr>
                        </table>
                        <asp:Label ID="lblAuthError" runat="server" ForeColor="Red" Font-Names="Arial" Text="You must select an auth header!!"
                            Visible="False">
                        </asp:Label>
                    </asp:Panel>
                    <telerik:RadGrid ID="grdAuths" runat="server" Skin="WebBlue" EnableEmbeddedSkins="false"
                        OnNeedDataSource="grdAuths_OnNeedDataSource" OnPageIndexChanged="grdAuths_OnPageIndexChanged"
                        OnSelectedIndexChanged="grdAuths_OnSelectedIndexChanged">
                        <ClientSettings>
                            <Scrolling AllowScroll="True" UseStaticHeaders="false" SaveScrollPosition="false"
                                ScrollHeight=""></Scrolling>
                            <ClientEvents OnGridCreated="GridCreated" />
                        </ClientSettings>
                        <MasterTableView TableLayout="Auto" Width="100%" AllowNaturalSort="false" AutoGenerateColumns="False"
                            BorderColor="#0066B3" BorderWidth="2" AllowSorting="True" GridLines="Both" AllowPaging="True"
                            CellSpacing="0">
                            <Columns>
                                <telerik:GridButtonColumn Text="Select" CommandName="Select" HeaderStyle-Width=".4in">
                                </telerik:GridButtonColumn>
                                <telerik:GridBoundColumn HeaderText="AuthID" DataField="ID" UniqueName="ID" SortExpression="ID"
                                    Visible="false" ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Status" DataField="ApprovalStatus" UniqueName="ApprovalStatus"
                                    SortExpression="ApprovalStatus" HeaderStyle-HorizontalAlign="Center" ShowSortIcon="False"
                                    ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False" ItemStyle-Wrap="false">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Originator" DataField="CreatedBy" UniqueName="CreatedBy"
                                    SortExpression="CreatedBy" ItemStyle-Wrap="False" ShowSortIcon="False" ShowFilterIcon="False"
                                    ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="MemberID" DataField="MemberID" UniqueName="MemberID"
                                    SortExpression="MemberID" Visible="False" ShowSortIcon="False" ShowFilterIcon="False"
                                    ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Member Name" DataField="Member Name" UniqueName="MemberName"
                                    HeaderStyle-HorizontalAlign="Center" SortExpression="Member Name" ItemStyle-Wrap="False"
                                    ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Auth #" DataField="AuthNumber" UniqueName="AuthNumber"
                                    SortExpression="AuthNumber" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width=".75in"
                                    ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Adj #" DataField="AuthAmendment" UniqueName="AuthAmendment"
                                    SortExpression="AuthAmendment" ItemStyle-Wrap="False" HeaderStyle-Width=".3in"
                                    ItemStyle-HorizontalAlign="Right" DataFormatString="{0:#0}" ShowSortIcon="False"
                                    ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False" DataType="System.Int32"
                                    HeaderStyle-HorizontalAlign="Center">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Service Description" DataField="Service Description"
                                    UniqueName="ServiceDescription" SortExpression="Service Description" ShowSortIcon="False"
                                    ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False" ItemStyle-Wrap="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Start Date" DataField="StartDate" UniqueName="StartDate"
                                    SortExpression="StartDate" DataType="System.DateTime" HeaderStyle-Width=".65in"
                                    ItemStyle-Wrap="False" DataFormatString="{0:MM/dd/yyyy}" ShowSortIcon="False"
                                    ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="End Date" DataField="EndDate" UniqueName="EndDate"
                                    SortExpression="EndDate" DataType="System.DateTime" HeaderStyle-Width=".65in"
                                    ItemStyle-Wrap="False" DataFormatString="{0:MM/dd/yyyy}" ShowSortIcon="False"
                                    ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Max Units" DataField="MaxUnits" UniqueName="MaxUnits"
                                    SortExpression="MaxUnits" ItemStyle-Wrap="False" HeaderStyle-Width=".3in" DataType="System.Int32"
                                    DataFormatString="{0:###,##0}" ItemStyle-HorizontalAlign="Right" ShowSortIcon="False"
                                    ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False" HeaderStyle-HorizontalAlign="Center">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Units Used" DataField="Units Used" UniqueName="UnitsUsed"
                                    SortExpression="Units Used" ItemStyle-Wrap="False" HeaderStyle-Width=".3in" DataType="System.Int32"
                                    DataFormatString="{0:###,##0}" ItemStyle-HorizontalAlign="Right" ShowSortIcon="False"
                                    ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False" HeaderStyle-HorizontalAlign="Center">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="ProviderLocation" DataField="ProviderLocation"
                                    Visible="false" UniqueName="ProviderLocation" SortExpression="ProviderLocation"
                                    ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False"
                                    ItemStyle-Wrap="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Division" DataField="Division" UniqueName="Division"
                                    SortExpression="Division" ItemStyle-Wrap="False" HeaderStyle-Width=".5in" ShowSortIcon="False"
                                    ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False" ItemStyle-HorizontalAlign="Center">
                                </telerik:GridBoundColumn>
                            </Columns>
                        </MasterTableView>
                    </telerik:RadGrid>
                    <asp:Panel ID="pnlContract" runat="server" Width="9in" BorderWidth="0">
                        <table cellpadding="0" cellspacing="0" style="width: 5in">
                            <tr>
                                <td>
                                    <asp:Label ID="Label7" runat="server" Font-Names="Arial" Font-Size="12px" Text="Select year to view: "></asp:Label>
                                </td>
                                <td style="height: 26px">
                                    <asp:RadioButton ID="rbPriorYear" runat="server" Font-Names="Arial" Font-Size="12px"
                                        GroupName="Years" Text="Prior Year" OnCheckedChanged="rbPriorYear_CheckedChanged"
                                        AutoPostBack="True" />
                                </td>
                                <td style="height: 26px">
                                    <asp:RadioButton ID="rbCurrentYear" runat="server" Font-Names="Arial" Font-Size="12px"
                                        Checked="true" GroupName="Years" Text="Current Year" OnCheckedChanged="rbCurrentYear_CheckedChanged"
                                        AutoPostBack="True" />
                                </td>
                                <td style="height: 26px">
                                    <asp:RadioButton ID="rbNextYear" runat="server" Font-Names="Arial" Font-Size="12px"
                                        GroupName="Years" Text="Next Year" OnCheckedChanged="rbNextYear_CheckedChanged"
                                        AutoPostBack="True" />
                                </td>
                            </tr>
                        </table>
                        <table cellpadding="0" cellspacing="0" bgcolor="0066B3" width="100%" style="border: 5px solid #0066B3;">
                            <tr>
                                <td align="left" valign="middle">
                                    <asp:Label ID="Label20" runat="server" Text="Contracts" Font-Bold="True" ForeColor="White"
                                        Font-Size="Medium">
                                    </asp:Label>
                                </td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <telerik:RadGrid ID="grdContracts" runat="server" Skin="WebBlue" EnableEmbeddedSkins="false"
                        OnNeedDataSource="grdContracts_OnNeedDataSource" OnSelectedIndexChanged="grdContracts_OnSelectedIndexChanged">
                        <ClientSettings>
                            <Scrolling AllowScroll="True" UseStaticHeaders="false" SaveScrollPosition="false"
                                ScrollHeight=""></Scrolling>
                            <ClientEvents OnGridCreated="GridCreated" />
                        </ClientSettings>
                        <MasterTableView TableLayout="Auto" Width="100%" AllowNaturalSort="false" AutoGenerateColumns="False"
                            BorderColor="#0066B3" BorderWidth="2" AllowSorting="True" GridLines="Both" AllowPaging="True"
                            CellSpacing="0">
                            <Columns>
                                <telerik:GridButtonColumn Text="Select" CommandName="Select" HeaderStyle-Width=".4in">
                                </telerik:GridButtonColumn>
                                <telerik:GridBoundColumn HeaderText="ProviderID" DataField="ProviderID" UniqueName="ProviderID"
                                    Visible="false" SortExpression="ProviderID" HeaderStyle-HorizontalAlign="Center"
                                    ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Status" DataField="StatusDescription" UniqueName="StatusDescription"
                                    SortExpression="StatusDescription" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width=".5in"
                                    ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Contract #" DataField="ContractNumber" UniqueName="ContractNumber"
                                    SortExpression="ContractNumber" HeaderStyle-Width=".5in" HeaderStyle-HorizontalAlign="Center"
                                    ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Amendment #" DataField="Sequence" UniqueName="Sequence"
                                    HeaderStyle-Width=".3in" SortExpression="Sequence" ShowSortIcon="False" HeaderStyle-HorizontalAlign="Center"
                                    ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="ID" DataField="ID" UniqueName="ID" Visible="false"
                                    SortExpression="ID" ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True"
                                    AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Description" DataField="Description" UniqueName="Description"
                                    SortExpression="Description" ItemStyle-Wrap="False" ShowSortIcon="False" ShowFilterIcon="False"
                                    ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Start Date" DataField="ValidStarting" UniqueName="ValidStarting"
                                    SortExpression="ValidStarting" DataType="System.DateTime" HeaderStyle-Width=".65in"
                                    ItemStyle-Wrap="False" DataFormatString="{0:MM/dd/yyyy}" ShowSortIcon="False"
                                    ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="End Date" DataField="ValidEnding" UniqueName="ValidEnding"
                                    SortExpression="ValidEnding" DataType="System.DateTime" HeaderStyle-Width=".65in"
                                    ItemStyle-Wrap="False" DataFormatString="{0:MM/dd/yyyy}" ShowSortIcon="False"
                                    ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="OfficeID" DataField="OfficeID" UniqueName="OfficeID"
                                    Visible="false" SortExpression="OfficeID" ShowSortIcon="False" ShowFilterIcon="False"
                                    ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                            </Columns>
                        </MasterTableView>
                    </telerik:RadGrid>
                    <asp:Panel ID="pnlBreak1" runat="server" BorderWidth="0">
                        <br />
                    </asp:Panel>
                    <asp:Panel ID="pnlContractLocations" runat="server" Width="9in" BorderWidth="0">
                        <table cellpadding="0" cellspacing="0" bgcolor="0066B3" width="100%" style="border: 5px solid #0066B3;">
                            <tr>
                                <td align="left" valign="middle">
                                    <asp:Label ID="Label19" runat="server" Text="Contract Locations" Font-Bold="True"
                                        ForeColor="White" Font-Size="Medium">
                                    </asp:Label>
                                </td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <telerik:RadGrid ID="grdContractLocations" runat="server" Skin="WebBlue" EnableEmbeddedSkins="false"
                        OnNeedDataSource="grdContractLocations_OnNeedDataSource" OnSelectedIndexChanged="grdContractLocations_OnSelectedIndexChanged">
                        <ClientSettings>
                            <Scrolling AllowScroll="True" UseStaticHeaders="false" SaveScrollPosition="false"
                                ScrollHeight=""></Scrolling>
                            <ClientEvents OnGridCreated="GridCreated" />
                        </ClientSettings>
                        <MasterTableView TableLayout="Auto" Width="100%" AllowNaturalSort="false" AutoGenerateColumns="False"
                            BorderColor="#0066B3" BorderWidth="2" AllowSorting="True" GridLines="Both" AllowPaging="True"
                            CellSpacing="0">
                            <Columns>
                                <telerik:GridButtonColumn Text="Select" CommandName="Select" HeaderStyle-Width=".4in">
                                </telerik:GridButtonColumn>
                                <telerik:GridBoundColumn HeaderText="ID" DataField="ID" UniqueName="ID" Visible="false"
                                    SortExpression="ID" ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True"
                                    AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="ProviderLocationID" DataField="ProviderLocationID"
                                    UniqueName="ProviderLocationID" Visible="false" SortExpression="ProviderLocationID"
                                    ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Location" DataField="ProviderLocationDescription"
                                    UniqueName="ProviderLocationDescription" SortExpression="ProviderLocationDescription"
                                    HeaderStyle-HorizontalAlign="Center" ShowSortIcon="False" ShowFilterIcon="False"
                                    ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Address" DataField="Address1" UniqueName="Address1"
                                    SortExpression="Address1" HeaderStyle-HorizontalAlign="Center" ShowSortIcon="False"
                                    ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                            </Columns>
                        </MasterTableView>
                    </telerik:RadGrid>
                    <asp:Panel ID="pnlBreak2" runat="server" BorderWidth="0">
                        <br />
                    </asp:Panel>
                    <asp:Label ID="lblContractServiceError" runat="server" Font-Names="Arial" ForeColor="Red"
                        Text="You must select a contract service line!!" Visible="false">
                    </asp:Label>
                    <asp:Panel ID="pnlContractServices" runat="server" Width="9in" BorderWidth="0">
                        <table cellpadding="0" cellspacing="0" bgcolor="0066B3" width="100%" style="border: 5px solid #0066B3;">
                            <tr>
                                <td align="left" valign="middle">
                                    <asp:Label ID="Label18" runat="server" Text="Contract Services" Font-Bold="True"
                                        ForeColor="White" Font-Size="Medium">
                                    </asp:Label>
                                </td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <telerik:RadGrid ID="grdContractServices" runat="server" Skin="WebBlue" EnableEmbeddedSkins="false"
                        OnNeedDataSource="grdContractServices_OnNeedDataSource" OnSelectedIndexChanged="grdContractServices_OnSelectedIndexChanged">
                        <ClientSettings>
                            <Scrolling AllowScroll="True" UseStaticHeaders="false" SaveScrollPosition="false"
                                ScrollHeight=""></Scrolling>
                            <ClientEvents OnGridCreated="GridCreated" />
                        </ClientSettings>
                        <MasterTableView TableLayout="Auto" Width="100%" AllowNaturalSort="false" AutoGenerateColumns="False"
                            BorderColor="#0066B3" BorderWidth="2" AllowSorting="True" GridLines="Both" AllowPaging="True"
                            CellSpacing="0">
                            <Columns>
                                <telerik:GridButtonColumn Text="Select" CommandName="Select" HeaderStyle-Width=".4in">
                                </telerik:GridButtonColumn>
                                <telerik:GridBoundColumn HeaderText="ID" DataField="ID" UniqueName="ID" Visible="false"
                                    SortExpression="ID" ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True"
                                    AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="sgID" DataField="sgID" UniqueName="sgID" Visible="false"
                                    SortExpression="sgID" ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True"
                                    AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="chID" DataField="chID" UniqueName="chID" Visible="false"
                                    SortExpression="chID" ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True"
                                    AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Service Description" DataField="Description"
                                    UniqueName="Description" SortExpression="Description" Visible="true" ShowSortIcon="False"
                                    ShowFilterIcon="False" ItemStyle-Wrap="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Code" DataField="Code" UniqueName="Code" SortExpression="Code"
                                    HeaderStyle-Width=".3in" HeaderStyle-HorizontalAlign="Center" ShowSortIcon="False"
                                    ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Mod 1" DataField="Modifier1" UniqueName="Modifier1"
                                    SortExpression="Modifier1" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width=".3in"
                                    ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Mod 2" DataField="Modifier2" UniqueName="Modifier2"
                                    SortExpression="Modifier2" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width=".3in"
                                    ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Mod 3" DataField="Modifier3" UniqueName="Modifier3"
                                    SortExpression="Modifier3" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width=".3in"
                                    ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Mod 4" DataField="Modifier4" UniqueName="Modifier4"
                                    SortExpression="Modifier4" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width=".3in"
                                    ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Mod 5" DataField="Modifier5" UniqueName="Modifier5"
                                    SortExpression="Modifier5" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width=".3in"
                                    ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="HCPCS" DataField="HCPCS" UniqueName="HCPCS"
                                    SortExpression="HCPCS" HeaderStyle-HorizontalAlign="Center" ShowSortIcon="False"
                                    ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Start Age" DataField="ValidStartAge" UniqueName="ValidStartAge"
                                    SortExpression="ValidStartAge" DataType="System.Int32" HeaderStyle-Width=".3in"
                                    ItemStyle-Wrap="False" DataFormatString="{0:###}" ShowSortIcon="False" ShowFilterIcon="False"
                                    ItemStyle-HorizontalAlign="Right" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="End Age" DataField="ValidEndAge" UniqueName="ValidEndAge"
                                    SortExpression="ValidEndAge" DataType="System.Int32" HeaderStyle-Width=".3in"
                                    ItemStyle-Wrap="False" DataFormatString="{0:###}" ShowSortIcon="False" ShowFilterIcon="False"
                                    ItemStyle-HorizontalAlign="Right" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Start Date" DataField="ValidStartDate" UniqueName="ValidStartDate"
                                    SortExpression="ValidStartDate" DataType="System.DateTime" HeaderStyle-Width=".65in"
                                    ItemStyle-Wrap="False" DataFormatString="{0:MM/dd/yyyy}" ShowSortIcon="False"
                                    Visible="false" ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="End Date" DataField="ValidEndDate" UniqueName="ValidEndDate"
                                    SortExpression="ValidEndDate" DataType="System.DateTime" HeaderStyle-Width=".65in"
                                    ItemStyle-Wrap="False" DataFormatString="{0:MM/dd/yyyy}" ShowSortIcon="False"
                                    Visible="false" ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="ContractLocationID" DataField="ContractLocationID"
                                    UniqueName="ContractLocationID" Visible="false" SortExpression="ContractLocationID"
                                    ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="ProviderID" DataField="ProviderID" UniqueName="ProviderID"
                                    Visible="false" SortExpression="ProviderID" ShowSortIcon="False" ShowFilterIcon="False"
                                    ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="ServiceID" DataField="ServiceID" UniqueName="ServiceID"
                                    Visible="false" SortExpression="ServiceID" ShowSortIcon="False" ShowFilterIcon="False"
                                    ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="UnitRate" DataField="UnitRate" UniqueName="UnitRate"
                                    Visible="false" SortExpression="UnitRate" ShowSortIcon="False" ShowFilterIcon="False"
                                    ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="VariableRate" DataField="VariableRate" UniqueName="VariableRate"
                                    Visible="false" SortExpression="VariableRate" ShowSortIcon="False" ShowFilterIcon="False"
                                    ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Division" DataField="Division" UniqueName="Division"
                                    Visible="false" SortExpression="Division" ShowSortIcon="False" ShowFilterIcon="False"
                                    ReadOnly="True" AllowFiltering="False">
                                </telerik:GridBoundColumn>
                            </Columns>
                        </MasterTableView>
                    </telerik:RadGrid>
                    <br />
                    <asp:UpdatePanel ID="updEnteredData" runat="server" UpdateMode="Conditional">
                        <ContentTemplate>
                            <asp:Table ID="Table3" runat="server" BorderWidth="2" BorderColor="#0066B3" Width="9in">
                                <asp:TableRow>
                                    <asp:TableCell>
                                        <asp:Table runat="server" Width="100%">
                                            <asp:TableRow>
                                                <asp:TableCell HorizontalAlign="Center">
                                                    <asp:Label ID="lblEditLabel" runat="server" Text="Select a Contract Service and Enter data."
                                                        Font-Bold="True">
                                                    </asp:Label>
                                                </asp:TableCell>
                                            </asp:TableRow>
                                        </asp:Table>
                                        <asp:Panel ID="Panel1" runat="server" Width="100%" BorderWidth="0">
                                            <asp:Table ID="Table2" runat="server" HorizontalAlign="Center" Width="50%">
                                                <asp:TableRow>
                                                    <asp:TableCell HorizontalAlign="Center" Width=".75in">
                                                        <asp:Label ID="Label2" runat="server" CssClass="Labels" Text="Units" Width=".4in"></asp:Label>
                                                        <asp:Label ID="Label12" runat="server" ForeColor="Red" Text=" *"></asp:Label>
                                                    </asp:TableCell>
                                                    <asp:TableCell HorizontalAlign="Center" Width="1.1in">
                                                        <asp:Label ID="Label3" runat="server" CssClass="Labels" Text="Rate" Width=".3in"></asp:Label>
                                                        <asp:Label ID="Label11" runat="server" ForeColor="Red" Text=" *"></asp:Label>
                                                    </asp:TableCell>
                                                    <asp:TableCell HorizontalAlign="Center" Width="1.3in">
                                                        <asp:Label ID="Label5" runat="server" CssClass="Labels" Text="Start Date" Width=".7in"></asp:Label>
                                                        <asp:Label ID="Label13" runat="server" ForeColor="Red" Text=" *"></asp:Label>
                                                    </asp:TableCell>
                                                    <asp:TableCell HorizontalAlign="Center" Width="1.3in">
                                                        <asp:Label ID="Label4" runat="server" CssClass="Labels" Text="End Date" Width=".7in"></asp:Label>
                                                        <asp:Label ID="Label14" runat="server" ForeColor="Red" Text=" *"></asp:Label>
                                                    </asp:TableCell>
                                                </asp:TableRow>
                                                <asp:TableRow>
                                                    <asp:TableCell HorizontalAlign="Center" Width=".75in">
                                                        <telerik:RadNumericTextBox runat="server" ID="txtUnits" Width=".5in" CssClass="TextBox"
                                                            DataType="System.Int16" NumberFormat-DecimalDigits="0">
                                                        </telerik:RadNumericTextBox>
                                                    </asp:TableCell>
                                                    <asp:TableCell HorizontalAlign="Center" Width="1.1in">
                                                        <telerik:RadNumericTextBox runat="server" ID="txtRate" Width=".9in" CssClass="TextBox"
                                                            Type="Currency">
                                                        </telerik:RadNumericTextBox>
                                                    </asp:TableCell>
                                                    <asp:TableCell HorizontalAlign="Center" Width="1.3in">
                                                        <telerik:RadDatePicker runat="server" ID="txtStartDate" Width="1.1in" Calendar-FastNavigationStep="12"
                                                            DateInput-DateFormat="MM/dd/yyyy" DateInput-DisplayDateFormat="MM/dd/yyyy" CssClass="TextBox">
                                                        </telerik:RadDatePicker>
                                                    </asp:TableCell>
                                                    <asp:TableCell HorizontalAlign="Center" Width="1.3in">
                                                        <telerik:RadDatePicker runat="server" ID="txtEndDate" Width="1.1in" Calendar-FastNavigationStep="12"
                                                            DateInput-DateFormat="MM/dd/yyyy" DateInput-DisplayDateFormat="MM/dd/yyyy" CssClass="TextBox">
                                                        </telerik:RadDatePicker>
                                                    </asp:TableCell>
                                                </asp:TableRow>
                                            </asp:Table>
                                            <asp:Table ID="Table4" runat="server" Width="100%">
                                                <asp:TableRow>
                                                    <asp:TableCell HorizontalAlign="Center">
                                                        <asp:Label ID="Label9" runat="server" CssClass="Labels" Text="Items with a red " Font-Bold="True" />
                                                        <asp:Label ID="Label10" runat="server" CssClass="Labels" Text="*" Font-Bold="True" ForeColor="Red" />
                                                        <asp:Label ID="Label8" runat="server" Text=" are required." Font-Bold="True" />
                                                    </asp:TableCell>
                                                </asp:TableRow>
                                            </asp:Table>
                                            <asp:Table ID="Table1" runat="server" BorderWidth="2" BorderColor="#0066B3" Width="100%"
                                                HorizontalAlign="Center">
                                                <asp:TableRow>
                                                    <asp:TableCell HorizontalAlign="Center" Width="50%">
                                                        <asp:Button ID="cmdSave" runat="server" Text="Save" Width="100%" OnClick="cmdSave_Click" />
                                                    </asp:TableCell>
                                                    <asp:TableCell HorizontalAlign="Center" Width="50%">
                                                        <asp:Button ID="cmdCancel" runat="server" Text="Cancel" Width="100%" OnClick="cmdCancel_Click" />
                                                    </asp:TableCell>
                                                </asp:TableRow>
                                            </asp:Table>
                                        </asp:Panel>
                                        <asp:Table ID="tabEnteredDataError" runat="server" Width="100%" Visible="false">
                                            <asp:TableRow>
                                                <asp:TableCell Width="100%">
                                                    <asp:TextBox ID="lblEnteredDataError" runat="server" TextMode="MultiLine" ForeColor="Red"
                                                        ReadOnly="True" BorderStyle="Solid" Font-Bold="True" Width="100%" BorderColor="Black"
                                                        BorderWidth="1px" Height="1in">
                                                    </asp:TextBox>
                                                </asp:TableCell>
                                            </asp:TableRow>
                                        </asp:Table>
                                        <asp:Table ID="tabOverride" runat="server" Width="100%" Visible="false">
                                            <asp:TableRow>
                                                <asp:TableCell Width="100%">
                                                    <asp:TextBox ID="lblOverrideDataError" runat="server" TextMode="MultiLine" ForeColor="Red"
                                                        ReadOnly="True" BorderStyle="Solid" Font-Bold="True" Width="100%" BorderColor="Black"
                                                        BorderWidth="1px" Height="1in">
                                                    </asp:TextBox>
                                                </asp:TableCell>
                                            </asp:TableRow>
                                            <asp:TableRow>
                                                <asp:TableCell Width="100%">
                                                    <asp:Button ID="cmdOverride" runat="server" Text="Override" Width="100%" OnClick="cmdOverride_Click"
                                                        TabIndex="10" />
                                                </asp:TableCell>
                                            </asp:TableRow>
                                        </asp:Table>
                                    </asp:TableCell>
                                </asp:TableRow>
                            </asp:Table>
                        </ContentTemplate>
                    </asp:UpdatePanel>
                </ContentTemplate>
            </asp:UpdatePanel>
            <uc1:MemberSearch ID="MemberSearch" runat="server" />
        </ContentTemplate>
    </asp:UpdatePanel>
</asp:Content>
=============================================================================================================
Content Page Code
===================================================================================================================
using System;
using System.Data;
using System.Text;
using Telerik.Web.UI;
 
public partial class Authorizations_AddAuth : System.Web.UI.Page
{
    #region Declarations
    clsSessionState ss = new clsSessionState();
 
    public const int Auth_ID = 3;
    public const int Auth_Status = 4;
    public const int Auth_Originator = 5;
    public const int Auth_MemberID = 6;
    public const int Auth_MemberName = 7;
    public const int Auth_AuthNumber = 8;
    public const int Auth_AuthAdjustmentNumber = 9;
    public const int Auth_ServiceDescription = 10;
    public const int Auth_StartDate = 11;
    public const int Auth_EndDate = 12;
    public const int Auth_MaxUnits = 13;
    public const int Auth_UnitsUsed = 14;
    public const int Auth_ProviderLocation = 15;
    public const int Auth_Division = 16;
 
    #endregion
 
    #region Events
 
    protected void cmdMemberSearch_Click(object sender, System.EventArgs e)
    {
        ss.LiabilityMemberPersonSearchMode = "";
 
        pnlMemberName.Visible = false;
        updGrids.Visible = false;
        updGrids.Update();
        updEnteredData.Visible = false;
        updEnteredData.Update();
 
        cmdMemberSearch.Visible = false;
        cmdShowAllMembers.Visible = false;
 
        pnlSelector.Visible = false;
 
        MemberSearch.SetMemberSearchVisible();
 
        if (ss.MemberID > 0)
        {
            cmdShowAllMembers.Enabled = true;
        }
 
        ClearAuthsData();
 
        updPage.Update();
    }
 
    protected void cmdShowAllMembers_Click(object sender, System.EventArgs e)
    {
        ss.MemberID = 0;
 
        if (optAdd.Checked)
        {
            //BindAuths(false);
        }
        else
        {
            BindAuths(false);
        }
 
        cmdShowAllMembers.Enabled = false;
 
        pnlMemberName.Visible = false;
        ClearAuthsData();
    }
 
    protected void cmdCancel_Click(object sender, EventArgs e)
    {
        try
        {
            this.ClearControls(false);
        }
        catch (Exception ex)
        {
            clsPortalErrorLog err = new clsPortalErrorLog(ss.dbConnect);
            err.LogError(ex.ToString(), User.Identity.Name, "AddAuth.aspx", "cmdCancel_Click");
        }
    }
    protected void cmdSave_Click(object sender, EventArgs e)
    {
        try
        {
            if (ss.AuthAddEditMode == "A")
            {
                ProcessAddValidationAndSave(true);
            }
            else
            {
                ProcessEditValidationAndSave(true);
            }
        }
        catch (Exception ex)
        {
            clsPortalErrorLog err = new clsPortalErrorLog(ss.dbConnect);
            err.LogError(ex.ToString(), User.Identity.Name, "AddAuth.aspx", "cmdSave_Click");
        }
    }
 
    protected void cmdAuthFilter_Click(object sender, System.EventArgs e)
    {
        lblAuthError.Visible = false;
        lblAuthError.Text = "";
 
        if (txtAuthStartDate.SelectedDate.ToString() == "" || txtAuthEndDate.SelectedDate.ToString() == "")
        {
            lblAuthError.Text = "You must enter a Start Date and End Date.";
            lblAuthError.Visible = true;
            updGrids.Update();
            return;
        }
 
        this.BindAuths(false);
    }
 
    protected void cmdAuthReset_Click(object sender, System.EventArgs e)
    {
        DateTime StartDate = DateTime.Now;
        DateTime EndDate = DateTime.Now;
 
        ComputeCurrentFiscalYearDates(ref StartDate, ref EndDate);
 
        txtAuthStartDate.SelectedDate = StartDate;
        txtAuthEndDate.SelectedDate = EndDate;
 
        cboAuthDivision.SelectedIndex = -1;
        cboAuthStatus.SelectedIndex = -1;
 
        BindAuths(false);
    }
 
    protected void cmdAuthClear_Click(object sender, System.EventArgs e)
    {
        lblAuthError.Visible = false;
        lblAuthError.Text = "";
 
        this.txtAuthStartDate.Clear();
        this.txtAuthEndDate.Clear();
        this.cboAuthStatus.SelectedIndex = -1;
        this.cboAuthDivision.SelectedIndex = -1;
 
        ss.MemberID = 0;
 
        pnlMemberName.Visible = false;
 
        ClearAuths();
 
        updGrids.Update();
        updPage.Update();
    }
 
    protected void grdAuths_OnSelectedIndexChanged(object sender, EventArgs e)
    {
        try
        {
            double dDollars = 0;
            bool VariableRate = false;
            double MaxUnits = 0;
 
            foreach (Telerik.Web.UI.GridDataItem dataItem in grdAuths.MasterTableView.Items)
            {
                if (dataItem.Selected == true)
                {
                    ss.MemberID = Convert.ToInt32(dataItem.Cells[Auth_MemberID].Text);
                    ss.MemberName = dataItem.Cells[Auth_MemberName].Text;
                    ss.AuthStatus = (dataItem.Cells[Auth_Status].Text);
                    ss.AuthID = Convert.ToInt32(dataItem.Cells[Auth_ID].Text);
                    ss.AuthNumber = Convert.ToInt32(dataItem.Cells[Auth_AuthNumber].Text);
                    ss.Division = dataItem.Cells[Auth_Division].Text;
                    ss.AuthStartDate = Convert.ToDateTime(dataItem.Cells[Auth_StartDate].Text);
                    ss.AuthEndDate = Convert.ToDateTime(dataItem.Cells[Auth_EndDate].Text);
                    MaxUnits = Convert.ToDouble(dataItem.Cells[Auth_MaxUnits].Text);
                    break;
                }
            }
 
            clsAuthorizationServiceLines AuthService = new clsAuthorizationServiceLines(ss.dbConnect);
 
            DataSet dsAuthService;
            dsAuthService = AuthService.GetAuthServiceLines(ss.AuthNumber);
 
            if (dsAuthService.Tables[0].Rows.Count == 0)
            {
                ss.AuthServiceID = 0;
                ss.AuthServiceStartDate = DateTime.MinValue;
                ss.AuthServiceEndDate = DateTime.MinValue;
                ss.ContractServiceID = 0;
            }
            else
            {
                ss.AuthServiceID = Convert.ToInt32(dsAuthService.Tables[0].Rows[0]["ID"].ToString());
                ss.AuthServiceStartDate = Convert.ToDateTime(dsAuthService.Tables[0].Rows[0]["AuthServiceValidStartDate"].ToString());
                ss.AuthServiceEndDate = Convert.ToDateTime(dsAuthService.Tables[0].Rows[0]["AuthServiceValidEndDate"].ToString());
                ss.ContractServiceID = Convert.ToInt32(dsAuthService.Tables[0].Rows[0]["AuthOrigCSLID"].ToString());
 
                dDollars = Convert.ToDouble(dsAuthService.Tables[0].Rows[0]["AuthServicePrice"].ToString());
            }
 
            clsContractService CS = new clsContractService(ss.dbConnect);
            DataSet dsCS;
 
            dsCS = CS.GetContractServiceDetails(ss.ContractServiceID);
 
            lblMemberName.Text = ss.MemberName;
            pnlMemberName.Visible = true;
 
            this.updPage.Update();
        }
        catch (Exception ex)
        {
            clsPortalErrorLog err = new clsPortalErrorLog(ss.dbConnect);
            err.LogError(ex.ToString(), User.Identity.Name, "AddAuth.aspx", "grdAuthServices_OnSelectedIndexChanged");
        }
    }
 
    protected void optAdd_OnCheckedChanged(object sender, EventArgs e)
    {
        SetupAdd();
    }
 
    protected void optEdit_OnCheckedChanged(object sender, EventArgs e)
    {
        SetupEdit();
    }
 
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            MemberSearch.PassMemberID += new MemberSearch.PassMemberIDHandler(MemberSearch_PassMemberID);
            MemberSearch.PageUpdate += new MemberSearch.PageUpdateIDHandler(MemberSearch_PageUpdate);
 
            lblContractServiceError.Visible = false;
 
            if (!IsPostBack)
            {
                ss.StartDate = DateTime.Now;
                ss.EndDate = DateTime.Now;
 
                ComputeContractHeaderStartAndEndDates();
 
                txtAuthStartDate.SelectedDate = ss.StartDate;
                txtAuthEndDate.SelectedDate = ss.EndDate;
 
                if (ss.AuthAddEditMode == "A")
                {
                    SetupAdd();
                }
                else
                {
                    SetupEdit();
                }
            }
        }
        catch (Exception ex)
        {
            clsPortalErrorLog err = new clsPortalErrorLog(ss.dbConnect);
            err.LogError(ex.ToString(), User.Identity.Name, "AddAuth.aspx", "Page_Load");
        }
    }
 
    void MemberSearch_PageUpdate(object sender, int MemberID)
    {
        MemberSearch.SetMemberSearchVisible();
 
        updPage.Update();
    }
 
    void MemberSearch_PassMemberID(object sender, int MemberID)
    {
        MemberSearch.SetMemberSearchHidden();
 
        pnlSelector.Visible = true;
 
        cmdMemberSearch.Visible = true;
        cmdShowAllMembers.Visible = true;
 
        if (ss.MemberID > 0)
        {
            cmdShowAllMembers.Enabled = true;
        }
        else
        {
            cmdShowAllMembers.Enabled = false;
        }
 
        pnlMemberName.Visible = true;
        updGrids.Visible = true;
        updGrids.Update();
        updEnteredData.Visible = true;
        updEnteredData.Update();
 
        if (optAdd.Checked)
        {
            cmdShowAllMembers.Visible = false;
 
            if (ss.MemberID > 0)
            {
                pnlMemberName.Visible = true;
                lblMemberName.Text = ss.MemberName;
 
                BindContracts(false);
            }
            else
            {
                pnlMemberName.Visible = false;
                lblMemberName.Text = "All Members";
 
                ClearContracts();
                ClearContractLocation();
                ClearContractServices();
            }
        }
        else
        {
            if (ss.MemberID == 0)
            {
                pnlMemberName.Visible = false;
                lblMemberName.Text = "All Members";
                cmdShowAllMembers.Visible = true;
            }
            else
            {
                pnlMemberName.Visible = true;
                lblMemberName.Text = ss.MemberName;
            }
 
            BindAuths(false);
        }
 
        updPage.Update();
    }
 
 
    #endregion
 
    #region Private Methods
    private void ClearAuthsData()
    {
        this.txtStartDate.Clear();
        this.txtEndDate.Clear();
        this.txtUnits.Text = "";
        this.txtRate.Text = "";
    }
 
    private void AddAuths()
    {
        try
        {
            //Get Provder
        }
        catch (Exception ex)
        {
            clsPortalErrorLog err = new clsPortalErrorLog(ss.dbConnect);
            err.LogError(ex.ToString(), User.Identity.Name, "AddAuth.aspx", "AddAuths");
        }
    }
    private void BindAuths(bool SkipBinding)
    {
        try
        {
            clsAuthorizations auth = new clsAuthorizations(ss.dbConnect);
 
            DateTime FromDate;
            DateTime ToDate;
 
            if (this.txtAuthStartDate.SelectedDate == null)
            {
                FromDate = System.DateTime.Now.AddYears(-50);
            }
            else
            {
                FromDate = txtAuthStartDate.SelectedDate.Value;
            }
 
            if (txtAuthEndDate.SelectedDate == null)
            {
                ToDate = System.DateTime.Now.AddYears(50);
            }
            else
            {
                ToDate = txtAuthEndDate.SelectedDate.Value;
            }
 
            this.grdAuths.DataSource = auth.GetAllAuths(ss.ProviderID, ss.MemberID, FromDate, ToDate, this.cboAuthStatus.SelectedItem.Text, this.cboAuthDivision.SelectedItem.Text, ss.listDivisionString);
 
            if (SkipBinding == false)
            {
                this.grdAuths.DataBind();
            }
        }
        catch (Exception ex)
        {
            clsPortalErrorLog err = new clsPortalErrorLog(ss.dbConnect);
            err.LogError(ex.ToString(), User.Identity.Name, "AddAuth.aspx", "BindAuths");
        }
    }
    private void ClearAuths()
    {
        try
        {
            clsClearGrid cg = new clsClearGrid(ss.dbConnect);
 
            this.grdAuths.DataSource = cg.ClearGrid();
            this.grdAuths.DataBind();
        }
        catch (Exception ex)
        {
            clsPortalErrorLog err = new clsPortalErrorLog(ss.dbConnect);
            err.LogError(ex.ToString(), User.Identity.Name, "AddAuth.aspx", "ClearAuths");
        }
    }
 
    private void ComputeContractHeaderStartAndEndDates()
    {
        int CurrentYear;
        int EndingYear;
        int CurrentMonth;
 
        CurrentMonth = System.DateTime.Now.Month;
 
        if (CurrentMonth > 6)
        {
            CurrentYear = System.DateTime.Now.Year;
            EndingYear = CurrentYear + 1;
        }
        else
        {
            CurrentYear = System.DateTime.Now.Year - 1;
            EndingYear = CurrentYear + 1;
        }
 
        if (rbPriorYear.Checked == true)
        {
            CurrentYear -= 1;
            EndingYear = CurrentYear + 1;
        }
 
        if (rbNextYear.Checked == true)
        {
            CurrentYear += 1;
            EndingYear = CurrentYear + 1;
        }
 
        ss.StartDate = Convert.ToDateTime("7/1/" + CurrentYear);
        ss.EndDate = Convert.ToDateTime("6/30/" + EndingYear);
    }
 
    private bool ValidatePreAuthUpdate(bool FromSave)
    {
        try
        {
            return true;
        }
        catch (Exception ex)
        {
            clsPortalErrorLog err = new clsPortalErrorLog(ss.dbConnect);
            err.LogError(ex.ToString(), User.Identity.Name, "AddAuth.aspx", "ValidatePreAuthUpdate");
            return false;
        }
    }
 
    private void ClearControls(bool SkipGrids)
    {
        txtUnits.Text = "";
        txtStartDate.Clear();
        txtEndDate.Clear();
        txtRate.Text = "";
 
        txtRate.Enabled = true;
 
        if (SkipGrids == false)
        {
            if (ss.AuthAddEditMode == "A")
            {
            }
            else
            {
                BindAuths(false);
            }
        }
 
        tabEnteredDataError.Visible = false;
 
        this.updGrids.Update();
        this.updEnteredData.Update();
    }
 
    private void SetupAdd()
    {
        this.lblAddEdit.Text = "Add Authorization";
 
        ClearAuths();
 
        pnlAuthTitle.Visible = false;
        grdAuths.Visible = false;
 
        if (ss.MemberID == 0)
        {
            pnlMemberName.Visible = false;
            lblMemberName.Text = "All Members";
 
        }
        else
        {
            pnlMemberName.Visible = true;
            lblMemberName.Text = ss.MemberName;
 
        }
 
        cmdShowAllMembers.Visible = false;
 
        pnlAuthFilter.Visible = false;
 
        lblEditLabel.Text = "Select a Contract Service and enter data.";
 
        pnlBreak1.Visible = true;
        pnlBreak2.Visible = true;
 
        ClearControls(true);
 
        optAdd.Checked = true;
        optEdit.Checked = false;
 
        updGrids.Update();
        updEnteredData.Update();
 
        ss.ClearDataSession();
 
        ss.AuthAddEditMode = "A";
    }
 
    private void SetupEdit()
    {
        this.lblAddEdit.Text = "Edit Authorization";
 
        DateTime StartDate = DateTime.Now;
        DateTime EndDate = DateTime.Now;
 
        ComputeCurrentFiscalYearDates(ref StartDate, ref EndDate);
 
        if (ss.MemberID == 0)
        {
            pnlMemberName.Visible = false;
            lblMemberName.Text = "All Members";
            cmdShowAllMembers.Enabled = false;
        }
        else
        {
            pnlMemberName.Visible = true;
            lblMemberName.Text = ss.MemberName;
            cmdShowAllMembers.Enabled = true;
        }
 
        txtAuthStartDate.SelectedDate = StartDate;
        txtAuthEndDate.SelectedDate = EndDate;
 
        BindAuths(false);
 
        cmdShowAllMembers.Visible = true;
 
        pnlAuthTitle.Visible = true;
        pnlAuthFilter.Visible = true;
        grdAuths.Visible = true;
 
        lblEditLabel.Text = "Select an Authorization and enter data.";
 
        pnlBreak1.Visible = false;
        pnlBreak2.Visible = false;
 
        ClearControls(true);
 
        optEdit.Checked = true;
        optAdd.Checked = false;
 
        updGrids.Update();
        updEnteredData.Update();
 
        ss.ClearDataSession();
 
        ss.AuthAddEditMode = "E";
    }
 
    #endregion
 
    #region Public Properties
 
 
    #endregion
 
    private void ProcessAddValidationAndSave(bool FromSave)
    {
        bool Selected = false;
 
        foreach (Telerik.Web.UI.GridDataItem dataItem in grdContractServices.MasterTableView.Items)
        {
            if (dataItem.Selected == true)
            {
                Selected = true;
 
                break;
            }
        }
 
        if (Selected == false)
        {
            lblEnteredDataError.Text = "You must select a Contract Service";
            tabEnteredDataError.Visible = true;
            updEnteredData.Update();
            return;
        }
 
        if (ValidatePreAuthUpdate(FromSave))
        {
            AddAuths();
 
            this.ClearControls(false);
        }
    }
 
    private void ProcessEditValidationAndSave(bool FromSave)
    {
        bool Selected = false;
 
        foreach (Telerik.Web.UI.GridDataItem dataItem in grdAuths.MasterTableView.Items)
        {
            if (dataItem.Selected == true)
            {
                Selected = true;
 
                break;
            }
        }
 
        if (Selected == false)
        {
            lblEnteredDataError.Text = "You must select a Authorization";
            tabEnteredDataError.Visible = true;
            updEnteredData.Update();
            return;
        }
 
        if (ValidatePreAuthUpdate(FromSave))
        {
            AddAuths();
 
            this.ClearControls(false);
        }
    }
 
    private bool CheckForOpenMember(string Division)
    {
        try
        {
            clsMemberCMSCHistory cmhist = new clsMemberCMSCHistory();
            bool _HasOpenCase = false;
 
            DataSet ds = new DataSet();
            ds = cmhist.ShowCMActivity(ss.MemberID, Division);
 
            foreach (DataRow dataRow in ds.Tables[0].Rows)
            {
                if (dataRow["Division"].ToString().Trim() == "MH")
                {
                    if (dataRow["CaseOpenDate"] != System.DBNull.Value && dataRow["CaseCloseDate"] == System.DBNull.Value)
                    {
                        _HasOpenCase = true;
                    }
                }
 
            }
 
            return _HasOpenCase;
        }
        catch (Exception ex)
        {
            clsPortalErrorLog err = new clsPortalErrorLog(ss.dbConnect);
            err.LogError(ex.ToString(), User.Identity.Name, "AddAuth.aspx", "CheckForOpenMember");
 
            return false;
        }
    }
 
    protected void grdAuths_OnPageIndexChanged(object source, GridPageChangedEventArgs e)
    {
        ClearAuthsData();
 
        pnlMemberName.Visible = false;
 
        updPage.Update();
    }
 
    protected void grdAuths_OnNeedDataSource(object source, GridNeedDataSourceEventArgs e)
    {
        try
        {
            if (cmdShowAllMembers.Enabled == false)
            {
                ss.MemberID = 0;
            }
 
            BindAuths(true);
        }
        catch (Exception ex)
        {
            clsPortalErrorLog err = new clsPortalErrorLog(ss.dbConnect);
            err.LogError(ex.ToString(), User.Identity.Name, "AddAuth.aspx", "grdAuths_OnNeedDataSource");
        }
    }
 
    private void ComputeCurrentFiscalYearDates(ref DateTime StartDate, ref DateTime EndDate)
    {
        int CurrentYear;
        int EndingYear;
        int CurrentMonth;
 
        CurrentMonth = System.DateTime.Now.Month;
 
        if (CurrentMonth > 6)
        {
            CurrentYear = System.DateTime.Now.Year;
            EndingYear = CurrentYear + 1;
        }
        else
        {
            CurrentYear = System.DateTime.Now.Year - 1;
            EndingYear = CurrentYear + 1;
        }
 
        if (rbPriorYear.Checked == true)
        {
            CurrentYear -= 1;
            EndingYear = CurrentYear + 1;
        }
 
        if (rbNextYear.Checked == true)
        {
            CurrentYear += 1;
            EndingYear = CurrentYear + 1;
        }
 
        StartDate = Convert.ToDateTime("7/1/" + CurrentYear);
        EndDate = Convert.ToDateTime("6/30/" + EndingYear);
    }
}
===================================================================================================================
WebUserControl Page
===================================================================================================================
<%@ Control Language="C#" AutoEventWireup="true" CodeFile="MemberSearch.ascx.cs"
    Inherits="MemberSearch" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<asp:UpdatePanel ID="updMemberSearch" runat="server" UpdateMode="Conditional">
    <ContentTemplate>
        <asp:Panel runat="server" ID="pnlMemberSearch" BorderStyle="Solid" BorderWidth="1px"
            Width="9in" HorizontalAlign="Center">
            <asp:Panel ID="Panel2" runat="server" Width="100%">
                <table width="100%" border="1">
                    <tr>
                        <td>
                            <table cellpadding="0" cellspacing="0" style="width: 100%; background-color: #0066B3;">
                                <tr align="left" valign="middle">
                                    <td align="center" valign="middle">
                                        <asp:Label ID="lblAddEdit" runat="server" Text="Member Lookup" ForeColor="White"
                                            Font-Bold="True" Font-Names="Arial" Font-Size="Large">
                                        </asp:Label>
                                    </td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                </table>
            </asp:Panel>
            <asp:Panel ID="Panel4" runat="server" BackColor="Silver" Width="100%">
                <table width="100%">
                    <tr>
                        <td style="width: .25in; height: 26px">
                              
                        </td>
                        <td style="width: 1.5in; height: 26px">
                            <asp:Label ID="Label51" runat="server" Font-Names="Arial" Text="Member Number:" Font-Size="12px"></asp:Label>
                            <asp:TextBox ID="txtMemberSearchMemberNumber" runat="server" Font-Size="12px"></asp:TextBox>
                        </td>
                        <td style="width: 1.5in; height: 26px" valign="middle">
                            <asp:RadioButton ID="rbMemberSearchSSN" runat="server" Checked="True" Font-Names="Arial"
                                Font-Size="12px" GroupName="B" Text="Social Sec Number" TabIndex="1" />
                        </td>
                        <td style="width: 1.2in; height: 26px" valign="middle">
                            <asp:RadioButton ID="rbMemberSearchBSU" runat="server" Font-Names="Arial" Font-Size="12px"
                                GroupName="B" Text="BSU Number" TabIndex="2" />
                        </td>
                        <td style="width: 1.2in; height: 26px" valign="middle">
                            <asp:RadioButton ID="rbMemberSearchCIS" runat="server" Font-Names="Arial" Font-Size="12px"
                                GroupName="B" Text="CIS Number" TabIndex="3" />
                        </td>
                        <td style="width: 2.35in; height: 26px">
                              
                        </td>
                    </tr>
                </table>
                <table width="100%">
                    <tr>
                        <td style="width: .25in; height: 26px">
                              
                        </td>
                        <td style="width: 1.5in; height: 26px">
                            <asp:Label ID="Label52" runat="server" Font-Names="Arial" Text="Last Name " Font-Size="12px"></asp:Label>
                            <asp:TextBox ID="txtMemberSearchLastName" runat="server" Font-Size="12px" Width="1.75in"
                                Text="">
                            </asp:TextBox>
                        </td>
                        <td style="width: 1in; height: 26px">
                            <asp:Label ID="Label53" runat="server" Font-Names="Arial" Text="First Name " Font-Size="12px"></asp:Label>
                            <asp:TextBox ID="txtMemberSearchFirstName" runat="server" Font-Size="12px" Text=""></asp:TextBox>
                        </td>
                        <td style="width: .2in; height: 26px" align="center">
                            <asp:Label ID="Label54" runat="server" Font-Names="Arial" Text="MI " Font-Size="12px"></asp:Label>
                            <asp:TextBox ID="txtMemberSearchMiddleInit" runat="server" Font-Size="12px" Width="0.2in"></asp:TextBox>
                        </td>
                        <td style="width: 1in; height: 26px">
                              
                        </td>
                        <td style="width: 1.5in; height: 26px" valign="bottom">
                            <asp:Button ID="cmdMemberSearchFind" runat="server" Text="Find" Width="100%" OnClick="cmdMemberSearchFind_Click" />
                        </td>
                        <td style="width: 1.5in; height: 26px" valign="bottom">
                            <asp:Button ID="cmdMemberSearchCancel" runat="server" Text="Cancel" Width="100%"
                                OnClick="cmdMemberSearchCancel_Click" />
                        </td>
                        <td style="width: 1.5in; height: 26px" valign="bottom">
                            <asp:Button ID="cmdMemberSearchClear" runat="server" Text="Clear" Width="100%" OnClick="cmdMemberSearchClear_Click" />
                        </td>
                        <td style="width: .5in; height: 26px">
                              
                        </td>
                    </tr>
                </table>
                <asp:Panel ID="pnlMemberError" runat="server" Visible="false">
                    <table width="100%">
                        <tr>
                            <td style="height: 26px" align="center">
                                <asp:Label ID="lblMemberError" runat="server" Font-Size="15px" Font-Bold="True" ForeColor="Red"
                                    Font-Names="arial" Text="There are no Member." Visible="False">
                                </asp:Label>
                            </td>
                        </tr>
                    </table>
                </asp:Panel>
            </asp:Panel>
            <table border="1" cellpadding="0" cellspacing="0" width="100%" style="background-color: #0066B3;">
                <tr align="center">
                    <td>
                        <b style="font-family: Arial; color: #FFFFFF;">Members</b>
                    </td>
                </tr>
            </table>
            <telerik:RadGrid AutoGenerateColumns="False" ID="grdMembers" runat="server" Skin="WebBlue"
                Height="6in" EnableEmbeddedSkins="false" OnSortCommand="grdMembers_OnSortCommand"
                OnNeedDataSource="grdMembers_OnNeedDataSource" OnSelectedIndexChanged="grdMembers_OnSelectedIndexChanged">
                <ClientSettings>
                    <Scrolling AllowScroll="True" UseStaticHeaders="False" SaveScrollPosition="false">
                    </Scrolling>
                </ClientSettings>
                <MasterTableView TableLayout="Auto" Width="100%" AllowNaturalSort="false" BorderColor="#0066B3"
                    BorderWidth="2" AllowSorting="True" GridLines="Both" CellSpacing="0">
                    <Columns>
                        <telerik:GridButtonColumn Text="Select" CommandName="Select">
                        </telerik:GridButtonColumn>
                        <telerik:GridBoundColumn HeaderText="ID" DataField="ID" UniqueName="ID" Visible="false"
                            SortExpression="ID" HeaderStyle-HorizontalAlign="Center" ShowSortIcon="False"
                            ShowFilterIcon="False" ReadOnly="True" AllowFiltering="False">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="Member Name" DataField="MemberName" UniqueName="MemberName"
                            SortExpression="MemberName" HeaderStyle-HorizontalAlign="Center" ShowSortIcon="False"
                            ShowFilterIcon="False" ItemStyle-Wrap="False" ReadOnly="True" AllowFiltering="False">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="Family Name" DataField="familyDescription" UniqueName="familyDescription"
                            SortExpression="familyDescription" HeaderStyle-HorizontalAlign="Center" ShowSortIcon="False"
                            ShowFilterIcon="False" ItemStyle-Wrap="False" ReadOnly="True" AllowFiltering="False">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="Family Code" DataField="familyCode" UniqueName="familyCode"
                            Visible="false" SortExpression="familyCode" HeaderStyle-HorizontalAlign="Center"
                            ShowSortIcon="False" ShowFilterIcon="False" ItemStyle-Wrap="False" ReadOnly="True"
                            AllowFiltering="False">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="DOB" DataField="DOB" UniqueName="DOB" SortExpression="DOB"
                            DataType="System.DateTime" ItemStyle-Wrap="False" DataFormatString="{0:MM/dd/yyyy}"
                            HeaderStyle-HorizontalAlign="Center" ShowSortIcon="False" ShowFilterIcon="False"
                            ReadOnly="True" AllowFiltering="False">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="SSN" DataField="SSN" UniqueName="SSN" SortExpression="SSN"
                            HeaderStyle-HorizontalAlign="Center" ShowSortIcon="False" ShowFilterIcon="False"
                            ItemStyle-Wrap="False" ReadOnly="True" AllowFiltering="False">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="Address 1" DataField="Address1" UniqueName="Address1"
                            SortExpression="Address1" ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True"
                            HeaderStyle-HorizontalAlign="Center" ItemStyle-Wrap="False" AllowFiltering="False">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="Address 2" DataField="Address2" UniqueName="Address2"
                            SortExpression="Address2" ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True"
                            HeaderStyle-HorizontalAlign="Center" ItemStyle-Wrap="False" AllowFiltering="False">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="City" DataField="City" UniqueName="City" SortExpression="City"
                            ItemStyle-Wrap="False" ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True"
                            HeaderStyle-HorizontalAlign="Center" AllowFiltering="False">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="State" DataField="State" UniqueName="State"
                            SortExpression="State" ItemStyle-Wrap="False" ShowSortIcon="False" ShowFilterIcon="False"
                            ReadOnly="True" HeaderStyle-HorizontalAlign="Center" AllowFiltering="False">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="ZIP" DataField="ZIPCode" UniqueName="ZIPCode"
                            SortExpression="ZIPCode" ItemStyle-Wrap="False" ShowSortIcon="False" ShowFilterIcon="False"
                            ReadOnly="True" HeaderStyle-HorizontalAlign="Center" AllowFiltering="False">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="BSU" DataField="BSU" UniqueName="BSU" SortExpression="BSU"
                            ItemStyle-Wrap="False" ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True"
                            HeaderStyle-HorizontalAlign="Center" AllowFiltering="False" Visible="True">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="CIS" DataField="CIS" UniqueName="CIS" SortExpression="CIS"
                            ItemStyle-Wrap="False" ShowSortIcon="False" ShowFilterIcon="False" ReadOnly="True"
                            HeaderStyle-HorizontalAlign="Center" AllowFiltering="False" Visible="True">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="LiabilityPerson" DataField="LiabilityPerson"
                            UniqueName="LiabilityPerson" Visible="false" SortExpression="LiabilityPerson"
                            HeaderStyle-HorizontalAlign="Center" ShowSortIcon="False" ShowFilterIcon="False"
                            ReadOnly="True" AllowFiltering="False">
                        </telerik:GridBoundColumn>
                    </Columns>
                </MasterTableView>
            </telerik:RadGrid>
        </asp:Panel>
    </ContentTemplate>
</asp:UpdatePanel>
===================================================================================================================
WebUserControl Code
===================================================================================================================
using System;
using System.Data;
using Telerik.Web.UI;
 
public partial class MemberSearch : System.Web.UI.UserControl
{
    clsSessionState ss = new clsSessionState();
 
    public delegate void PassMemberIDHandler(object sender, int MemberID);
    public event PassMemberIDHandler PassMemberID;
 
    public delegate void PageUpdateIDHandler(object sender, int MemberID);
    public event PageUpdateIDHandler PageUpdate;
 
    public const int Member_ID = 3;
    public const int Member_MemberName = 4;
    public const int Member_FamilyDescription = 5;
    public const int Member_FamilyCode = 6;
    public const int Member_DOB = 7;
    public const int Member_SSN = 8;
    public const int Member_Address1 = 9;
    public const int Member_Address2 = 10;
    public const int Member_City = 11;
    public const int Member_State = 12;
    public const int Member_ZIPCode = 13;
    public const int Member_BSU = 14;
    public const int Member_CIS = 15;
    public const int Member_LiabilityPerson = 16;
 
    private int MemberID = 0;
    private bool SkipBinding = false;
 
    public void MemberSelected()
    {
        PassMemberID(this, ss.LiabilityMemberID);
    }
 
    public void UpdateMasterPage()
    {
        PageUpdate(this, MemberID);
    }
 
    public void SetMemberSearchHidden()
    {
        ClearLookupFields();
 
        pnlMemberError.Visible = false;
 
        updMemberSearch.Visible = false;
        updMemberSearch.Update();
    }
 
    public void SetMemberSearchVisible()
    {
        updMemberSearch.Visible = true;
        updMemberSearch.Update();
    }
 
    protected void cmdMemberSearchCancel_Click(object sender, EventArgs e)
    {
        ClearMember();
 
        if (ss.LiabilityMemberPersonSearchMode == "Person")
        {
            ss.LiabilityPersonID = 0;
            ss.LiabilityPersonName = "";
        }
        else
        {
            ss.LiabilityMemberID = 0;
            ss.LiabilityMemberName = "";
        }
 
        MemberSelected();
    }
 
    protected void cmdMemberSearchClear_Click(object sender, EventArgs e)
    {
        SkipBinding = false;
 
        ClearLookupFields();
 
        ClearMember();
 
        lblMemberError.Visible = false;
        pnlMemberError.Visible = false;
        updMemberSearch.Update();
        UpdateMasterPage();
    }
 
    protected void cmdMemberSearchFind_Click(object sender, EventArgs e)
    {
        SkipBinding = false;
        grdMembers.MasterTableView.SortExpressions.Clear();
 
        lblMemberError.Text = "";
        lblMemberError.Visible = false;
        pnlMemberError.Visible = false;
 
        if (txtMemberSearchLastName.Text.Length > 0 && txtMemberSearchMemberNumber.Text.Length > 0)
        {
            pnlMemberError.Visible = true;
            lblMemberError.Text = "Please choose either a Member Number OR Lastname, not both";
            lblMemberError.Visible = true;
 
            this.updMemberSearch.Update();
 
            UpdateMasterPage();
            return;
        }
 
        if (ss.LiabilityMemberPersonSearchMode == "Member")
        {
            ProcessLiabilityMember();
        }
 
        UpdateMasterPage();
    }
 
    protected void grdMembers_OnSelectedIndexChanged(object sender, EventArgs e)
    {
        if (ss.LiabilityMemberPersonSearchMode == "Person")
        {
            FindLiabiliyPerson();
             
            clsMemberMain mm = new clsMemberMain(ss.dbConnect);
            mm.LogThisMemberAccess(ss.LiabilityPersonID);
 
            //return;
        }
        else
        {
            FindLiabiliyMember();
 
            clsMemberMain mm = new clsMemberMain(ss.dbConnect);
            mm.LogThisMemberAccess(ss.LiabilityMemberID);
        }
 
        ClearMember();
 
        updMemberSearch.Visible = false;
        updMemberSearch.Update();
 
        MemberSelected();
    }
 
    protected void grdMembers_OnNeedDataSource(object source, GridNeedDataSourceEventArgs e)
    {
        SkipBinding = true;
 
        //lblMemberError.Text = "";
        //lblMemberError.Visible = false;
 
        if (ss.LiabilityMemberPersonSearchMode == "Member")
        {
            ProcessLiabilityMember();
        }
 
        UpdateMasterPage();
    }
 
    protected void Page_Load(object sender, EventArgs e)
    {
        //string cn = System.Configuration.ConfigurationManager.ConnectionStrings["LUISDB"].ConnectionString;
        //ss.dbConnect = cn;
 
        //if (!IsPostBack)
        //{
        //    ClearLookupFields();
        //}
 
        updMemberSearch.Visible = false;
        updMemberSearch.Update();
    }
 
    private void ClearMember()
    {
        clsMemberMain mem = new clsMemberMain(ss.dbConnect);
 
        DataSet ds = new DataSet();
 
        ds = mem.ClearMember();
 
        grdMembers.DataSource = ds;
 
        if (SkipBinding == false)
        {
            grdMembers.DataBind();
        }
 
        updMemberSearch.Update();
    }
 
    public void ClearLookupFields()
    {
        txtMemberSearchMemberNumber.Text = "";
        txtMemberSearchLastName.Text = "";
        txtMemberSearchFirstName.Text = "";
        txtMemberSearchMiddleInit.Text = "";
        rbMemberSearchSSN.Checked = true;
        //pnlMemberError.Visible = false;
    }
 
    private void FindLiabiliyPerson()
    {
        foreach (Telerik.Web.UI.GridDataItem dataItem in grdMembers.MasterTableView.Items)
        {
            if (dataItem.Selected == true)
            {
                ss.LiabilityPersonID = Convert.ToInt32(dataItem.Cells[Member_ID].Text);
                //ss.LiabilityPersonName = Convert.ToString(dataItem.Cells[Member_MemberName].Text);
 
                clsMemberMain mm = new clsMemberMain(ss.dbConnect);
 
                mm.Read(ss.LiabilityPersonID);
 
                ss.LiabilityPersonName = mm.FirstName.Trim() + " " + mm.MiddleInitial.Trim() + " " + mm.LastName.Trim();
                break;
            }
        }
    }
 
    private void FindLiabiliyMember()
    {
        string IsLiabilityMember = "N";
        string FamilyDescription = "";
        string FamilyCode = "";
        int FamilyID = 0;
        int MemberID = 0;
 
        foreach (Telerik.Web.UI.GridDataItem dataItem in grdMembers.MasterTableView.Items)
        {
            if (dataItem.Selected == true)
            {
                ss.MemberID = Convert.ToInt32(dataItem.Cells[Member_ID].Text);
                ss.MemberName = Convert.ToString(dataItem.Cells[Member_MemberName].Text);
                ss.LiabilityMemberID = Convert.ToInt32(dataItem.Cells[Member_ID].Text);
                ss.LiabilityMemberName = Convert.ToString(dataItem.Cells[Member_MemberName].Text);
                IsLiabilityMember = Convert.ToString(dataItem.Cells[Member_LiabilityPerson].Text);
                FamilyDescription = Convert.ToString(dataItem.Cells[Member_FamilyDescription].Text);
                FamilyCode = Convert.ToString(dataItem.Cells[Member_FamilyCode].Text);
                break;
            }
        }
 
        if (IsLiabilityMember == "N")
        {
            clsFamilyDefinitions FD = new clsFamilyDefinitions(ss.dbConnect);
            DataSet dsFD;
 
            dsFD = FD.GetFamilyDescription(FamilyDescription);
 
            FamilyID = Convert.ToInt32(dsFD.Tables[0].Rows[0]["ID"].ToString());
 
            clsMHLiability liab = new clsMHLiability(ss.dbConnect);
            clsFamilyTransactions FT = new clsFamilyTransactions(ss.dbConnect);
 
            DataSet dsliab;
            DataSet dsFT;
 
            dsFT = FT.GetFamilyIDs(FamilyID);
 
            for (int row = 0; row < dsFT.Tables[0].Rows.Count - 1; row++)
            {
                MemberID = Convert.ToInt32(dsFT.Tables[0].Rows[row]["MemberID"].ToString());
 
                dsliab = liab.GetLiabilityMember(MemberID);
 
                if (dsliab.Tables[0].Rows.Count > 0)
                {
                    ss.LiabilityMemberID = Convert.ToInt32(dsliab.Tables[0].Rows[0]["MemberID"].ToString());
                    ss.LiabilityMemberName = dsliab.Tables[0].Rows[0]["MemberName"].ToString();
 
                    break;
                }
 
                dsliab.Clear();
            }
        }
    }
 
    private void ProcessLiabilityMember()
    {
        lblMemberError.Text = "";
        lblMemberError.Visible = false;
 
        string sMemberNumber = "";
        string LastName = "";
        string FirstName = "";
        string MI = "";
 
        clsMemberMain mm = new clsMemberMain(ss.dbConnect);
        DataSet ds = new DataSet();
 
        ClearMember();
 
        sMemberNumber = this.txtMemberSearchMemberNumber.Text.Trim();
        LastName = this.txtMemberSearchLastName.Text.Trim();
        FirstName = this.txtMemberSearchFirstName.Text.Trim();
        MI = this.txtMemberSearchMiddleInit.Text.Trim();
 
        if (sMemberNumber != "" && LastName != "")
        {
            lblMemberError.Text = "Please choose either a Member Number OR Lastname, not both";
            lblMemberError.Visible = true;
 
            this.updMemberSearch.Update();
 
            return;
        }
 
        int ProviderID = ss.ProviderID;
 
            if ((ds.Tables.Count == 0) || (ds.Tables[0].Rows.Count == 0))
            {
                lblMemberError.Text = "No member with the SSN number or not a valid SSN number";
                lblMemberError.Visible = true;
 
                this.updMemberSearch.Update();
 
                return;
            }
        }
 
        if ((ds.Tables.Count == 0) || (ds.Tables[0].Rows.Count == 0))
        {
            ds = mm.GetMembersSearchWithProviderIDForFamily(ProviderID, LastName, FirstName, MI, "", "", "", Days, ss.listDivisionString);
 
            if ((ds.Tables.Count == 0) || (ds.Tables[0].Rows.Count == 0))
            {
                lblMemberError.Text = "No members match your Lastname, Firstname, Middle Init criteria";
                lblMemberError.Visible = true;
 
                this.updMemberSearch.Update();
 
                return;
            }
        }
 
        this.grdMembers.DataSource = ds;
 
        if (SkipBinding == false)
        {
            this.grdMembers.DataBind();
        }
 
        this.updMemberSearch.Update();
    }
 
}

 

 

Maria Ilieva
Telerik team
 answered on 09 Feb 2012
10 answers
317 views
Hello,

  I am using RadGrid in which I have used the gridclientdeletecolumn to delete the row from client side.
But the problem i have here is, if i have 2 rows in my grid and if i delete one row and when i try to save the page, in code behind i see the radgrid row count as 0 even though there is one row left.

Here is the code overview:

<telerik:GridClientDeleteColumn  ConfirmText="Are you sure you want to delete"
                        HeaderStyle-Width="35px" ButtonType="ImageButton" ImageUrl="Delete.gif" /> 

I have tried adding this but no luck..  <MasterTableView AlloAutomaticDeletes ="True" DataKeyNames = "Number">

P.S: I have this radgrid inside the update panel.

Thanks
Tsvetina
Telerik team
 answered on 09 Feb 2012
1 answer
162 views

H,

I am using RadTabstrip with RadMultipage.

I have 3 tabs with 3 pageviews. I am using ContentURL property of pageview to load the page as a main page’s content.
I have a button in the main page .when I click on the button  a javascript calls and open a new window using window.open javascript method.
My aim is to pass id of the selected radtab in the window.open .
My aim is to  get the id  of these  radtabs in the newly opened window using javascript or jquery?
How can I find these radtabs?

Thanks,
Sindu


Kate
Telerik team
 answered on 09 Feb 2012
2 answers
130 views
Hi there-

I am struggling to figure out how to do this task. I have a RadGrid with several bound GridDropDownColumns and am trying to do some server side validation when a user clicks Edit to check if the current value is valid. Since these rows may not match a good value, I want to highlight the border of the cell when it is invalid, even though the default behavior of GridDropDownColumns selects a default value when none is given.

Here is the page code:
<telerik:RadGrid ID="RadGrid1" GridLines="None" runat="server" CssClass="AutoShrink"
           AllowPaging="True" AllowAutomaticUpdates="True" PagerStyle-AlwaysVisible='true'
            AutoGenerateColumns="False"
           DataSourceID="AutoInventory_OUStaging_DataSource" OnItemUpdated="RadGrid1_ItemUpdated"
            OnItemDeleted="RadGrid1_ItemDeleted"
           OnItemInserted="RadGrid1_ItemInserted" OnDataBound="RadGrid1_DataBound" OnItemDataBound="RadGrid1_ItemDataBound"
           AllowAutomaticDeletes="True" AllowAutomaticInserts="True" Skin="Sunset"
           AllowSorting="True" PageSize="15">

Here is the code behind:
protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
    if (e.Item is GridEditableItem && e.Item.IsInEditMode)
    {
 
        GridEditableItem item = e.Item as GridEditableItem;
        GridEditManager editMan = item.EditManager;
        GridDropDownListColumnEditor editor = (GridDropDownListColumnEditor)(editMan.GetColumnEditor("DataCenterCode"));
        //DropDownList ddList = editor.DropDownListControl;
 
        editor.DropDownStyle.BorderColor = Color.Red;
        editor.DropDownStyle.BorderStyle = BorderStyle.Solid;
 
        //ddList.Items[0].Attributes["style"] = "color: red";
 
        // item["DataCenterCode"].BorderColor = Color.Red;
        //item["DataCenterCode"].CssClass = "invalidfield";
        //item["DataCenterCode"].ControlStyle.BorderColor = Color.Red;
        //// We can get the id of the edit record by
 
        //GridEditManager editMan = item.EditManager;
 
        //GridDropDownListColumnEditor editor = editMan.GetColumnEditor("DataCenterCode") as GridDropDownListColumnEditor;
        //editor.DropDownStyle.BorderColor = Color.Red;
 
        //list.BorderColor = Color.Red;
 
        //GridDataItem item = (GridDataItem)e.Item;
        //Literal litrl = (Literal)item["DataCenterCode"].Controls[0];  
 
 
        //int updateId = Convert.ToInt32(item.GetDataKeyValue("ServerId"));
        // now write code for binding row data in the interface
 
    }
}

as you can see I have tried many options but haven't been able to get the behavior I desire. I am looking to have the same styling as if I were to set the ItemStyle-BorderColor="RED" on the object like this:
<telerik:GridDropDownColumn DataField="DataCenterCode" DataSourceID="SqlDataSource_DataCenters"
                           HeaderText="DataCenterCode" ListTextField="Acronym" ListValueField="Acronym"
                           UniqueName="DataCenterCode" ColumnEditorID="GridDropDownColumnEditor2" ItemStyle-BorderColor="Red">
                     </telerik:GridDropDownColumn>

how can i accomplish this?

thanks for any help!

Andrey
Telerik team
 answered on 09 Feb 2012
2 answers
144 views
Hi,

I'm having a problem with a UserControl inside a RadPanelBar. The PanelBar is nested inside an UpdatePanel (although it reacts the same if I remove it).

<telerik:RadPanelBar runat="server" ID="pnlBar" Width="100%" ExpandMode="SingleExpandedItem" OnClientLoad="PanelBarLoad">
        <Items>
          <%--Panel::Member--%>
          <telerik:RadPanelItem>
            <HeaderTemplate>
              Member </HeaderTemplate>
            <ContentTemplate>
              <asp:LinkButton runat="server" CommandName="_memberClicked" OnCommand="ShowReport_Command">
                <h1>
                  <asp:Literal ID="litMemberName" Text="" runat="server" />
                </h1>
              </asp:LinkButton>
              <cc:LinkButton ID="myTest" runat="server" IgnorePermission="true" CommandName="_memberClicked" OnCommand="ShowReport_Command">
                  $ <asp:Literal ID="litMemberRevenue"  Text="" runat="server" />
              </cc:LinkButton>
            </ContentTemplate>
          </telerik:RadPanelItem>
....

After a PostBack, the default ASP:LinkButton is still visible, the custom control LinkButton disappears. 

My custom LinkButton is a simple as the following:
  [ToolboxData("<{0}:LinkButton runat=\"server\"></{0}:LinkButton>")]
  public class LinkButton: System.Web.UI.WebControls.LinkButton {
    private bool _ShowLoadingMessage = true;
    public bool ShowLoadingMessage {
      get { return _ShowLoadingMessage; }
      set { _ShowLoadingMessage = value; }
    }
 
    protected override void OnPreRender(EventArgs e) {
      base.OnPreRender(e);
 
      //add loading client click, only if not added before
      if (ShowLoadingMessage) {
        if (!this.OnClientClick.Contains("mn_ShowLoadingMessage();")) {
          this.OnClientClick = this.OnClientClick.Insert(0, "mn_ShowLoadingMessage();");
        }
      }
    }
  }

Any ideas?

Thanks
Danny
Top achievements
Rank 1
 answered on 09 Feb 2012
3 answers
97 views
Imports Microsoft.VisualBasic
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration
 
 
Public Class DAO
 
    Shared strConnection As String = ConfigurationManager.ConnectionStrings("Con").ConnectionString
    Dim sqlCommand As New SqlCommand
    Dim sqlConnection As New SqlConnection
    Dim sqlDataAdapter As New SqlDataAdapter
 
    Public Function InsertEmployee(ByVal objEmployee As Entities.Employee) As Entities.Employee
        Dim EmployeeId As Integer
        sqlConnection = New SqlConnection(strConnection)
        sqlConnection.Open()
        sqlCommand.Connection = sqlConnection
        sqlCommand.CommandType = CommandType.StoredProcedure
        sqlCommand.CommandText = "dbo.Employee_Info_INS"
        Try
            If objEmployee IsNot Nothing Then
                sqlCommand.Parameters.AddWithValue("@Employee_Name", objEmployee.EmployeeName)
                sqlCommand.Parameters.AddWithValue("@Employee_Age", objEmployee.EmployeeAge)
                sqlCommand.Parameters.AddWithValue("@Employee_Salary", objEmployee.EmployeeSalary)
                sqlCommand.Parameters.AddWithValue("@Employee_Dept", objEmployee.EmployeeDept)
                Dim sqlparameter As SqlParameter = sqlCommand.Parameters.AddWithValue("@Employee_Id", objEmployee.EmployeeId)
                sqlparameter.Direction = ParameterDirection.Output
                sqlCommand.ExecuteNonQuery()
                Integer.TryParse(sqlparameter.Value, EmployeeId)
                objEmployee.EmployeeId = EmployeeId
            End If
        Catch ex As Exception
            Throw ex
        Finally
            sqlConnection.Close()
        End Try
        Return objEmployee
    End Function
 
    Public Sub DeleteEmployee(ByVal EmployeeId As Integer)
 
        sqlConnection = New SqlConnection(strConnection)
        sqlConnection.Open()
        sqlCommand.Connection = sqlConnection
        sqlCommand.CommandType = CommandType.StoredProcedure
        sqlCommand.CommandText = "dbo.Employee_Info_DEL"
        Try
            sqlCommand.Parameters.AddWithValue("@Employee_Id", EmployeeId)
            sqlCommand.ExecuteNonQuery()
        Catch ex As Exception
            Throw ex
        Finally
            sqlConnection.Close()
        End Try
 
    End Sub
 
 
    Public Function GetEmployee() As List(Of Entities.Employee)
        Dim objEmployeeList As List(Of Entities.Employee) = Nothing
        Dim objEmployee As Entities.Employee = Nothing
        Dim dsEmployee As New DataSet
        sqlConnection = New SqlConnection(strConnection)
        sqlConnection.Open()
        sqlCommand.Connection = sqlConnection
        sqlCommand.CommandType = CommandType.StoredProcedure
        sqlCommand.CommandText = "dbo.Employee_Info_SEL"
        dsEmployee.Tables.Clear()
 
        Try
            sqlDataAdapter.SelectCommand = sqlCommand
            sqlDataAdapter.Fill(dsEmployee)
            If dsEmployee IsNot Nothing AndAlso dsEmployee.Tables(0).Rows.Count > 0 Then
                objEmployeeList = New List(Of Entities.Employee)
                objEmployee = New Entities.Employee
                With dsEmployee.Tables(0).Rows(0)
                    For Each row As DataRow In dsEmployee.Tables(0).Rows
                        objEmployee = New Entities.Employee
                        objEmployee.EmployeeId = row("Employee_Id")
                        objEmployee.EmployeeName = row("Employee_Name")
                        objEmployee.EmployeeAge = row("Employee_Age")
                        objEmployee.EmployeeSalary = row("Employee_Salary")
                        objEmployee.EmployeeDept = row("Employee_Dept")
                        objEmployeeList.Add(objEmployee)
                    Next
                    objEmployee.EmployeeId = .Item("Employee_Id")
                End With
            End If
 
        Catch ex As Exception
            Throw ex
        Finally
            sqlConnection.Close()
        End Try
 
        Return objEmployeeList
    End Function
 
    Public Function UpdateEmployee(ByVal objEmployee As Entities.Employee) As Entities.Employee
        sqlConnection = New SqlConnection(strConnection)
        sqlConnection.Open()
        sqlCommand.Connection = sqlConnection
        sqlCommand.CommandType = CommandType.StoredProcedure
        sqlCommand.CommandText = "dbo.Employee_Info_UPD"
        Try
            If objEmployee IsNot Nothing Then
                sqlCommand.Parameters.AddWithValue("@Employee_Name", objEmployee.EmployeeName)
                sqlCommand.Parameters.AddWithValue("@Employee_Age", objEmployee.EmployeeAge)
                sqlCommand.Parameters.AddWithValue("@Employee_Salary", objEmployee.EmployeeSalary)
                sqlCommand.Parameters.AddWithValue("@Employee_Dept", objEmployee.EmployeeDept)
                sqlCommand.Parameters.AddWithValue("@Employee_Id", objEmployee.EmployeeId)
                sqlCommand.ExecuteNonQuery()
            End If
        Catch ex As Exception
            Throw ex
        Finally
            sqlConnection.Close()
        End Try
        Return objEmployee
    End Function
 
End Class
Imports Microsoft.VisualBasic
 
Public Class Entities
    Public Class Employee
        Private strName As String
        Private intAge As Integer
        Private decSalary As Decimal
        Private strDept As String
        Private intEmployeeId As Integer
 
 
        Public Property EmployeeName() As String
            Get
                Return strName
            End Get
            Set(ByVal value As String)
                strName = value
            End Set
        End Property
 
        Public Property EmployeeAge() As Integer
            Get
                Return intAge
            End Get
            Set(ByVal value As Integer)
                intAge = value
            End Set
        End Property
 
        Public Property EmployeeSalary() As Decimal
            Get
                Return decSalary
            End Get
            Set(ByVal value As Decimal)
                decSalary = value
            End Set
        End Property
 
        Public Property EmployeeDept() As String
            Get
                Return strDept
            End Get
            Set(ByVal value As String)
                strDept = value
            End Set
        End Property
 
        Public Property EmployeeId() As Integer
            Get
                Return intEmployeeId
            End Get
            Set(ByVal value As Integer)
                intEmployeeId = value
            End Set
        End Property
 
    End Class
    Public Class Dept
 
    End Class
End Class
Imports Microsoft.VisualBasic
 
Public Class Impl
    Public Function InsertEmployee(ByVal objEmployee As Entities.Employee) As Entities.Employee
        Dim objDAO As New DAO
        Return objDAO.InsertEmployee(objEmployee)
    End Function
 
    Public Function GetEmployee() As List(Of Entities.Employee)
        Dim objDAO As New DAO
        Return objDAO.GetEmployee()
    End Function
 
    Public Sub DeleteEmployee(ByVal EmployeeId As Integer)
        Dim objDAO As New DAO
        objDAO.DeleteEmployee(EmployeeId)
    End Sub
 
    Public Function UpdateEmployee(ByVal objEmployee As Entities.Employee) As Entities.Employee
        Dim objDAO As New DAO
        Return objDAO.UpdateEmployee(objEmployee)
    End Function
End Class
Here i am placing my aspx and code page
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
 
<%@ 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">
<head runat="server">
    <title></title>
    <link href="App_Themes/Employee.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
    <div class="main-content">
        <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
        </telerik:RadScriptManager>
        <div class="employeediv">
            <div class="employeesdiv">
                <asp:Label ID="lblEmployeeName" CssClass="employeelbl" Text="Employee Name" runat="server"></asp:Label>
                <telerik:RadTextBox ID="rtxtEmployeeName" CssClass="employeertxt" runat="server">
                </telerik:RadTextBox>
            </div>
            <div class="employeesdiv">
                <asp:Label ID="lblEmployeeAge" CssClass="employeelbl" Text="Employee Age" runat="server"></asp:Label>
                <telerik:RadTextBox ID="rtxtEmployeeAge" CssClass="employeertxt" runat="server">
                </telerik:RadTextBox>
            </div>
            <div class="employeesdiv">
                <asp:Label ID="lblEmployeeSalary" CssClass="employeelbl" Text="Employee Salary" runat="server"></asp:Label>
                <telerik:RadTextBox ID="rtxtEmployeeSalary" CssClass="employeertxt" runat="server">
                </telerik:RadTextBox>
            </div>
            <div class="employeesdiv">
                <asp:Label ID="lblEmployeeDept" CssClass="employeelbl" Text="Employee Dept" runat="server"></asp:Label>
                <telerik:RadTextBox ID="rtxtEmployeeDept" CssClass="employeertxt" runat="server">
                </telerik:RadTextBox>
            </div>
            <div class="employeesdiv">
                <telerik:RadButton ID="rbtnSave" Text="save" runat="server" CssClass="emloyeebtn">
                </telerik:RadButton>
            </div>
        </div>
        <div class="employeegriddiv">
            <telerik:RadGrid ID="rgdEmployee" runat="server" AutoGenerateColumns="false" Width="908">
                <MasterTableView EditMode="InPlace">
                    <Columns>
                        <telerik:GridTemplateColumn>
                            <EditItemTemplate>
                                <asp:LinkButton ID="lnkUpdate" runat="server" Text="Update" CommandName="Update"
                                    Style="float: left;">
                                </asp:LinkButton>
                                <asp:LinkButton ID="lnkCancel" runat="server" Text="Cancel" CommandName="Cancel"
                                    Style="float: left; margin-left: 5px;">
                                </asp:LinkButton>
                            </EditItemTemplate>
                            <ItemTemplate>
                                <asp:LinkButton ID="lnkEdit" runat="server" Text="Edit" CommandName="Edit">
                                </asp:LinkButton>
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn HeaderText="EmployeeName">
                            <ItemTemplate>
                                <asp:Literal ID="ltlName" runat="server" Text='<%#Eval("EmployeeName") %>'></asp:Literal>
                            </ItemTemplate>
                            <EditItemTemplate>
                                <telerik:RadTextBox ID="rtxtName" runat="server" Text='<%#Eval("EmployeeName") %>'
                                    Width="170px">
                                </telerik:RadTextBox>
                            </EditItemTemplate>
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn HeaderText="EmployeeAge">
                            <ItemTemplate>
                                <asp:Literal ID="ltlAge" runat="server" Text='<%#Eval("EmployeeAge") %>'></asp:Literal>
                            </ItemTemplate>
                            <EditItemTemplate>
                                <telerik:RadTextBox ID="rtxtAge" runat="server" Text='<%#Eval("EmployeeAge") %>'
                                    Width="170px">
                                </telerik:RadTextBox>
                            </EditItemTemplate>
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn HeaderText="EmployeeSalary">
                            <ItemTemplate>
                                <asp:Literal ID="ltlSalary" runat="server" Text='<%#Eval("EmployeeSalary") %>'></asp:Literal>
                            </ItemTemplate>
                            <EditItemTemplate>
                                <telerik:RadTextBox ID="rtxtSalary" runat="server" Text='<%#Eval("EmployeeSalary") %>'
                                    Width="170px">
                                </telerik:RadTextBox>
                            </EditItemTemplate>
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn HeaderText="EmployeeName">
                            <ItemTemplate>
                                <asp:Literal ID="ltlDept" runat="server" Text='<%#Eval("EmployeeDept") %>'></asp:Literal>
                            </ItemTemplate>
                            <EditItemTemplate>
                                <telerik:RadTextBox ID="rtxtDept" runat="server" Text='<%#Eval("EmployeeDept") %>'
                                    Width="170px">
                                </telerik:RadTextBox>
                            </EditItemTemplate>
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn>
                            <EditItemTemplate>
                                <asp:HiddenField ID="hidEmployeeId" Value=<%#Eval("EmployeeId")%> runat="server" />
                            </EditItemTemplate>
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn>
                            <EditItemTemplate>                               
                                <asp:LinkButton ID="lnkDelete" runat="server" Text="delete" CommandName="Delete" > </asp:LinkButton>
                            </EditItemTemplate>
                        </telerik:GridTemplateColumn>
                    </Columns>
                </MasterTableView>
            </telerik:RadGrid>
        </div>
        <asp:HiddenField ID="hdEmployeeId" runat="server" />
    </div>
    </form>
</body>
</html>
Imports Telerik.Web.UI
 
Partial Class _Default
    Inherits System.Web.UI.Page
    Dim objDAO As New DAO
    Dim objimpl As New Impl
 
#Region "Methods"
 
    Private Sub ShowJavaScript(ByVal str As String)
 
        Dim page As Page = TryCast(HttpContext.Current.Handler, Page)
        ScriptManager.RegisterStartupScript(page, page.GetType(), "msg", "alert('" & str & "');", True)
 
    End Sub
 
    Private Sub AddEmployeeDetails()
 
        Dim objEmployee As New Entities.Employee
        objEmployee.EmployeeName = rtxtEmployeeName.Text
        objEmployee.EmployeeAge = rtxtEmployeeAge.Text
        objEmployee.EmployeeSalary = rtxtEmployeeSalary.Text
        objEmployee.EmployeeDept = rtxtEmployeeDept.Text
        objEmployee.EmployeeId = Session("EmployeeId")
        objimpl.InsertEmployee(objEmployee)
 
    End Sub
 
    Private Sub LoadEmployeeDetails()
 
        Dim objEmployeeList As List(Of Entities.Employee)
        Dim objEmployee As New Entities.Employee
        objEmployeeList = objimpl.GetEmployee()
        rgdEmployee.DataSource = objEmployeeList
 
    End Sub
 
#End Region
 
#Region "Events"
 
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
 
        Try
             
            LoadEmployeeDetails()
            rgdEmployee.DataBind()
             
        Catch ex As Exception
            Throw ex
        End Try
 
    End Sub
 
    Protected Sub rbtnSave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles rbtnSave.Click
 
        If rtxtEmployeeName.Text = "" AndAlso rtxtEmployeeAge.Text = "" AndAlso rtxtEmployeeSalary.Text = "" AndAlso rtxtEmployeeDept.Text = "" Then
            ShowJavaScript("Enter The Employee Details in the textboxes")
            Exit Sub
        End If
        AddEmployeeDetails()
        LoadEmployeeDetails()
        rgdEmployee.DataBind()
 
        rtxtEmployeeName.Text = String.Empty
        rtxtEmployeeAge.Text = String.Empty
        rtxtEmployeeSalary.Text = String.Empty
        rtxtEmployeeDept.Text = String.Empty
 
 
    End Sub
 
    Protected Sub rgdEmployee_ItemCommand(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles rgdEmployee.ItemCommand
        'If e.CommandArgument <> String.Empty Then
        '    If e.CommandName = "Delete" Then
        '        'Session("Employee_Id") = Val(e.CommandArgument)
        '        objimpl.DeleteEmployee(Val(e.CommandArgument))
        '        LoadEmployeeDetails()
        '    End If
        'End If
        Dim objEmployee As New Entities.Employee
        Dim rtxtName As RadTextBox
        Dim rtxtAge As RadTextBox
        Dim rtxtSalary As RadTextBox
        Dim rtxtDept As RadTextBox
        Dim hdEmployeeId As HiddenField
        Dim EmployeeId As Integer
 
        If e.CommandName = RadGrid.UpdateCommandName Then
            rtxtName = e.Item.FindControl("rtxtName")
            objEmployee.EmployeeName = rtxtName.Text
            rtxtAge = e.Item.FindControl("rtxtAge")
            objEmployee.EmployeeAge = rtxtAge.Text
            rtxtSalary = e.Item.FindControl("rtxtSalary")
            objEmployee.EmployeeSalary = rtxtSalary.Text
            rtxtDept = e.Item.FindControl("rtxtDept")
            objEmployee.EmployeeDept = rtxtDept.Text
            hdEmployeeId = e.Item.FindControl("hidEmployeeId")
            Integer.TryParse(hdEmployeeId.Value, objEmployee.EmployeeId)
            objimpl.UpdateEmployee(objEmployee)
            LoadEmployeeDetails()
        ElseIf e.CommandName = RadGrid.DeleteCommandName Then
            rgdEmployee.MasterTableView.ClearEditItems()
            hdEmployeeId = e.Item.FindControl("hidEmployeeId")
            Integer.TryParse(hdEmployeeId.Value, EmployeeId)
            objimpl.DeleteEmployee(EmployeeId)
            LoadEmployeeDetails()
        End If
    End Sub
 
#End Region
 
End Class


The issue is when i delete the second or third or last row the first row is being deleted.
When i update the values being changed are not changing  the previous values are only displayed.
kindly go through   the code and suggest me something.
I have also posted my services
Thanks in advance.

Naveen kumar
Top achievements
Rank 1
 answered on 09 Feb 2012
1 answer
286 views
Hello,

I need some help for showing and closing a RadWindow server-side without any postbacks.

The RadWindow is always added to the page (CreateChildControls):

m_overlayWindow = new RadWindow();
 m_overlayWindow.ID = "m_overlayWindow";
 m_overlayWindow.Behaviors = WindowBehaviors.None;
 m_overlayWindow.AutoSize = true;
 m_overlayWindow.VisibleOnPageLoad = false;
 Controls.Add(m_overlayWindow);
 
 RadAjaxManager manager = RadAjaxManager.GetCurrent(Page);
 AjaxSetting ajaxSetting1 = new AjaxSetting(m_ribbonBar.ID);
 ajaxSetting1.UpdatedControls.Add(new AjaxUpdatedControl(this.ID, LoadingPanel.ID) { UpdatePanelHeight = new Unit("100%") });
manager.AjaxSettings.Add(ajaxSetting1);

It should open in the click event handler of a RadRibbonBar;

m_overlayWindow.Modal = true;
m_overlayWindow.VisibleOnPageLoad = true;
          
RadButton buttonClose = new RadButton();
buttonClose.ID = "bclose";
buttonClose.Text = "Close";
buttonClose.Value = "close";
buttonClose.Click += new System.EventHandler(buttonClose_Click);
m_overlayWindow.ContentContainer.Controls.Add(buttonClose);
 
string script = "function f(){$find(\"" + m_overlayWindow.ClientID + "\").show(); Sys.Application.remove_load(f);}Sys.Application.add_load(f);";
FmWebUtil.RegisterStartupScript(this.Page, "key", script, true);
RadAjaxManager manager = RadAjaxManager.GetCurrent(Page);
manager.AjaxSettings.AddAjaxSetting(m_overlayWindow, this, LoadingPanel);

Currently, the RadWindow only contains a simple button which should close the RadWindow:
void buttonClose_Click(object sender, System.EventArgs e)
      {
         m_overlayWindow.VisibleOnPageLoad = false;
      }

Note: The code which is executed when the RadRibbon bar's click event is handled is also executed after a postback (I save to the viewstate if I have to reopen the RadWindow).

My problem is: the RadWindow opens correctly, but clicking the close button does the first time I click nothing and the second time I click a full page reload. How do I have to open the RadWindow (and keep it open after a postback) and how do I close it without a complete page reload?

Thanks for your help!

Edit: Executing the javascript only when the RadWindow is opened from the click event (and not from another postback) resolves the problem that I have to click twice to close it. But closing still does a full page reload.
Marin Bratanov
Telerik team
 answered on 09 Feb 2012
1 answer
148 views

I remotely took an image from web into my asp:Image   , now I want to insert that image into sql server , please help ,with a simple table id(pk)  ,my image(image) wirte some hint ot code ,I later will be needing it to bound with RabBinary image column 

Or is it possible to insert image taken from web  into the sql server image datatype when only thing avialable to you is image url 

the above solution if I can do will be great , but any other suggestion by which I can store user image along side its row in db and keep its image privacy is also wellcome 

thanks 

Andrey
Telerik team
 answered on 09 Feb 2012
6 answers
158 views
Hi,

I have a RadComboBox as a UserControl ,

I Created Some Custom Properties to it from CodeBehind ,
I Succedded adding a Server Event which is  OnSelectedIndexChanged .

The Question is:

How to add a Client Event On it.

 --> Specifically I want to add OnClientSelectedIndexChanged Event

Please Can anyone tell me how to do that

I believe it is a JavaScript Code or Something like that

I need Help Quickly Please...

Best Regards,

Mahmoud
Mahmoud
Top achievements
Rank 1
 answered on 09 Feb 2012
1 answer
127 views
Hello,

I am using window manger and have two window within it as shown:

<telerik:RadWindowManager ID="wndwManager" runat="server">
      <Windows>
          <telerik:RadWindow runat="server" Behaviors="Maximize,Close,Move,Minimize" ID="editorWindow"
              VisibleStatusbar="false" Width="800px" OnClientClose="OnWindowClose" ShowOnTopWhenMaximized="true" Modal="true"
              Height="500px" Style="z-index: 2900; position: absolute"/>
          <telerik:RadWindow runat="server" Behaviors="Maximize,Close,Move,Minimize" ID="ratesWindow"
              VisibleStatusbar="false" Width="800px" OnClientClose="OnWindowClose" Modal="true"
              Height="500px" Style="z-index: 7001"/>
      </Windows>
  </telerik:RadWindowManager>

Now, as you can see i have set the z-index for both the window, the issue is when i open the window 2 from window 1, window 2 is getting open behind window 1 if window 1 is maximize. If window 1 is not in maximize state everything works find. i want to open window 2 above window 1 when window 1 is maximized..

Thanks.
Dhaval
Princy
Top achievements
Rank 2
 answered on 09 Feb 2012
Narrow your results
Selected tags
Tags
+? more
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?