Questions on UI for ASP.NET AJAX Forum

110,777 questions

2 answers

99 views

Hello, I'm trying to create grid columns types of which I don't know at runtime.
For that I'm using (GridElement) class with Dictionary property:

public class GridElement

{

Dictionary<string, object> properties = new Dictionary<string, object>();

public object this[string name]

{

get

{

if (properties.ContainsKey(name))

return properties[name];

return null;

}

set

{

properties[name] = value;

}

public Dictionary<string, object> Properties

{

get { return properties; }

set { properties = value; }

}

I'd like to do something like that..

List<GridElement> elementList= new List<GridElement>();

//Adding some data to elementList

//trying to generate columns

foreach (var element in elementList[0].Properties)

{

GridBoundColumn column = new GridBoundColumn();

this.TestRadGrid.MasterTableView.Columns.Add(column);

column.HeaderText = element.Key.ToString();

column.DataField = ???

}

this.TestRadGrid.MasterTableView.DataSource = elementList;

Any suggestions how can i make this work?

Grid

answered on 09 Feb 2012

1 answer

84 views

RadAjaxLoadingPanel in a WebUserControl


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>

<html xmlns="http://www.w3.org/1999/xhtml">

<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>

<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();

}

Grid

answered on 09 Feb 2012

10 answers

333 views

Problem in Row Delete Clientside

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

Grid

answered on 09 Feb 2012

1 answer

174 views

RadTab - accessing using JQuery or Javascript (Urgent)

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

TabStrip

answered on 09 Feb 2012

2 answers

139 views

Help Setting a GridDropDownListColumnEditor Style In Code Behind

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!

Grid

answered on 09 Feb 2012

2 answers

159 views

UserControl disappear after postback

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

PanelBar

answered on 09 Feb 2012

3 answers

101 views

Update and Delete problem of radgrid

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

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">

<html xmlns="http://www.w3.org/1999/xhtml">

<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 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.

Grid

answered on 09 Feb 2012

1 answer

311 views

Close RadWindow server-side without postback

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.

Window

answered on 09 Feb 2012

1 answer

153 views

Insert image in sql Image taken from a web url ,or solution with radimage column

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

Grid

answered on 09 Feb 2012

6 answers

164 views

Create Client Event Property to UserControl ComboBox

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

ComboBox

answered on 09 Feb 2012

Top users last month