This is a migrated thread and some comments may be shown as answers.

radgrid filter display problem....

14 Answers 331 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Raj asked on 21 Sep 2010, 03:25 PM

2.JPG

3.JPG

HI,

I created radgrid with show or hide filter option on button click. when i click show filter option Its looking good No issues. My problem is when i re-size the column to click on the filter button there is empty space is coming in the first row (Please see the image 3). Because of that the pagination is not displaying. I tried it by removing div tags but no luck... Can any one help me how to fix this. Thanks...

<div style="width: 100%; height: 650px; overflow: auto; overflow-y: hidden">

<telerik:RadGrid ID="gvPjtMnt" runat="server" Height="550px" Width="99%" AutoGenerateColumns="false"

BorderWidth="2px" BorderStyle="Solid" BackColor="White" AllowPaging="True" PagerStyle-AlwaysVisible="true"

PageSize="20" AllowSorting="True" AllowFilteringByColumn="true" OnNeedDataSource="gvPjtMnt_OnNeedDataSource"

OnItemCommand="gvPjtMnt_ItemCommand" OnItemCreated="gvPjtMnt_ItemCreated" OnItemDataBound="gvPjtMnt_ItemDataBound">

<HeaderStyle Height="20px" BackColor="#004000" Font-Size="8pt" Font-Bold="True" ForeColor="White"

HorizontalAlign="Center" BorderColor="White" BorderWidth="1px" />

<AlternatingItemStyle Font-Size="8pt" BackColor="#F5F5E9" HorizontalAlign="Center"

BorderWidth="1px" BorderColor="White" />

<ItemStyle HorizontalAlign="Center" />

<ExportSettings ExportOnlyData="true" IgnorePaging="true" FileName="Project Management">

</ExportSettings>

<MasterTableView GridLines="None" CommandItemDisplay="Top" DataKeyNames="ProjectId"

HorizontalAlign="Center" AllowFilteringByColumn="true">

<CommandItemTemplate>

<table style="width: 100%">

<tr>

<td align="right" style="width: 78%">

<asp:LinkButton ID="lnkshwFilter" Text="ShowFilter" Font-Underline="true" ForeColor="MidnightBlue"

runat="server" OnClientClick="return showFilterItem()" />

<asp:LinkButton ID="lnkhdFilter" Text="HideFilter" Font-Underline="true" ForeColor="MidnightBlue"

runat="server" OnClientClick="return hideFilterItem()" />

</td>

<td align="right" style="height: 10px;">

Total Records found: <asp:Label ID="lblTotRecCount" runat="server" Font-Bold="True"

Font-Size="10pt" ForeColor="Black" Text="0"></asp:Label>

</td>

<td align="right">

<asp:LinkButton ID="lnkExportAll" Text="ExportAll" Font-Underline="true" ForeColor="MidnightBlue"

runat="server" OnClick="ExportAll_Click" />

</td>

<td align="right" style="width: 2%">

<asp:ImageButton ID="ExportToExcelButton" runat="server" ImageUrl="~/images/ExportToExcel.gif"

ToolTip="Export to Excel" OnClick="ExportExcel_Click" />

</td>

</tr>

</table>

</CommandItemTemplate>

<Columns>

..... few columns here ............

</Columns>

<ItemStyle ForeColor="#3C5F22" Font-Size="8pt" BackColor="White" BorderWidth="0px"

BorderColor="White" />

<PagerStyle Mode="NextPrevAndNumeric" AlwaysVisible="true" />

</MasterTableView>

<ClientSettings AllowColumnsReorder="true">

<ClientEvents OnGridCreated="GridCreated" />

<Scrolling AllowScroll="true" UseStaticHeaders="true" />

<Resizing AllowColumnResize="true" />

</ClientSettings>

</telerik:RadGrid>

</div>

function showFilterItem() {

$find('<%=gvPjtMnt.ClientID %>').get_masterTableView().showFilterItem();

document.getElementById('ctl00_PagePlaceholder_gvPjtMnt_ctl00_ctl02_ctl00_lnkhdFilter').style.display = 'block';

document.getElementById('ctl00_PagePlaceholder_gvPjtMnt_ctl00_ctl02_ctl00_lnkshwFilter').style.display = 'none';

return false;

}

function hideFilterItem() {

document.getElementById('ctl00_PagePlaceholder_gvPjtMnt_ctl00_ctl02_ctl00_lnkhdFilter').style.display = 'none';

document.getElementById('ctl00_PagePlaceholder_gvPjtMnt_ctl00_ctl02_ctl00_lnkshwFilter').style.display = 'block';

$find('<%=gvPjtMnt.ClientID %>').get_masterTableView().hideFilterItem();

return false;

}

function GridCreated(sender, args) {

sender.get_masterTableView().hideFilterItem();

}

14 Answers, 1 is accepted

answered on 21 Sep 2010, 06:24 PM

Hi Dimo,

I am getting this error only in IE 7. Here is my full code

<%@ Page MasterPageFile="~/MasterPage.master" Language="C#" AutoEventWireup="true"

CodeFile="PrjMgmt.aspx.cs" EnableEventValidation="false" Inherits="PrjMgmt" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>

<%@ Register Assembly="Syncfusion.Shared.Web, Version=8.303.0.21, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89"

Namespace="Syncfusion.Web.UI.WebControls.Shared" TagPrefix="syncfusion" %>

<%@ Register Assembly="Syncfusion.Diagram.Web, Version=8.303.0.21, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89"

Namespace="Syncfusion.Web.UI.WebControls.Diagram" TagPrefix="syncfusion" %>

<%@ Register Assembly="Syncfusion.Tools.Web, Version=8.303.0.21, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89"

Namespace="Syncfusion.Web.UI.WebControls.Tools" TagPrefix="syncfusion" %>

<%@ Register Assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

Namespace="System.Web.UI.HtmlControls" TagPrefix="cc1" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc2" %>

<asp:Content ID="Content2" ContentPlaceHolderID="CSS_ScriptPlaceHolder" runat="server">

<link href="CSS/Css.css" rel="stylesheet" type="text/css" />

<link href="CSS/Forest.css" rel="stylesheet" type="text/css" />

<script type="text/javascript">

function DisplayDateToday(sender, args) {

if (sender._selectedDate == null) {

sender._selectedDate = new Date();

}

function openpopups(winprjname) {

var winTitle = winprjname;

var radwind = window.radopen("", "winBlkTskAssign");

radwind.SetTitle(winTitle);

}

function ClosePopups() {

var oWnd = GetRadWindowManager().GetWindowByName("winBlkTskAssign");

oWnd.Close();

}

function showAddNotes() {

document.getElementById('trAddNewNotes').style.display = "block";

document.getElementById('ctl00_PagePlaceholder_winBlkTskAssign_C_tabTskAssign_TabNotes_trNotes').style.display = "none";

return false;

}

function hideAddNotes() {

document.getElementById('trAddNewNotes').style.display = "none";

document.getElementById('ctl00_PagePlaceholder_winBlkTskAssign_C_tabTskAssign_TabNotes_trNotes').style.display = "block";

return false;

}

function OnClientSelectedIndexChanged(sender, eventArgs) {

document.getElementById('ctl00_PagePlaceholder_txtHeadName_Input').value = "";

document.getElementById('ctl00_PagePlaceholder_txtMarName_Input').value = "";

document.getElementById('ctl00_PagePlaceholder_txtProjName_Input').value = "";

document.getElementById('ctl00_PagePlaceholder_txtPrjMgrName_Input').value = "";

}

function onRequestStart(sender, args) {

if (args.get_eventTarget().indexOf("ExportToExcelButton") >= 0 ||

args.get_eventTarget().indexOf("lnkExportAll") >= 0) {

args.set_enableAjax(false);

}

function showFilterItem() {

$find('<%=gvPjtMnt.ClientID %>').get_masterTableView().showFilterItem();

document.getElementById('ctl00_PagePlaceholder_gvPjtMnt_ctl00_ctl02_ctl00_lnkhdFilter').style.display = 'block';

document.getElementById('ctl00_PagePlaceholder_gvPjtMnt_ctl00_ctl02_ctl00_lnkshwFilter').style.display = 'none';

return false;

}

function hideFilterItem() {

document.getElementById('ctl00_PagePlaceholder_gvPjtMnt_ctl00_ctl02_ctl00_lnkhdFilter').style.display = 'none';

document.getElementById('ctl00_PagePlaceholder_gvPjtMnt_ctl00_ctl02_ctl00_lnkshwFilter').style.display = 'block';

$find('<%=gvPjtMnt.ClientID %>').get_masterTableView().hideFilterItem();

return false;

}

function GridCreated(sender, args) {

sender.get_masterTableView().hideFilterItem();

}

</script>

<style>

.modalBackground

{

background-color: Gray;

filter: alpha(opacity=70);

opacity: 0.7;

}

.AjaxCalendar .ajax__calendar_container

{

border: 1px solid #646464;

background-color: White;

color: Black;

}

.AjaxCalendar .ajax__calendar_other .ajax__calendar_day, .AjaxCalendar .ajax__calendar_other .ajax__calendar_year

{

color: #999999;

}

.AjaxCalendar .ajax__calendar_hover .ajax__calendar_day, .AjaxCalendar .ajax__calendar_hover .ajax__calendar_month, .AjaxCalendar .ajax__calendar_hover .ajax__calendar_year

{

color: Red;

}

.AjaxCalendar .ajax__calendar_active .ajax__calendar_day, .AjaxCalendar .ajax__calendar_active .ajax__calendar_month, .AjaxCalendar .ajax__calendar_active .ajax__calendar_year

{

background-color: #78C43C;

color: Black;

text-align: center;

font-weight: bold;

}

.rgRow td

{

border-bottom: 1px dotted #aaaaaa !important;

border-bottom-style: dotted !important;

border-bottom-width: inherit !important;

}

.rgAltRow td

{

border-bottom: 1px dotted #aaaaaa !important;

border-bottom-style: dotted !important;

border-bottom-width: inherit !important;

}

.rgPageFirst, .rgPagePrev, .rgPageNext, .rgPageLast

{

display: none !important;

}

div.RadGrid_Default .rgHeader, div.RadGrid_Default th.rgResizeCol

{

background-image: none !important;

}

</style>

</asp:Content>

<asp:Content ID="Content3" ContentPlaceHolderID="subMenu" runat="Server">

<div class='TopLevelSubNavigationItemVisible'>

<div style="float: left; padding-left: 30px" class="TopLevelSubNavigationItem">

<a href="Default.aspx">my tasks</a>

</div>

<div class="TopLevelSubNavigationItemSeperator" style="display: inline;">

|</div>

</div>

<div class='TopLevelSubNavigationItemVisible' id="trActions" runat="server">

<div style="float: left;" class="TopLevelSubNavigationItem">

<a href="Actions.aspx">my actions</a>

</div>

<div class="TopLevelSubNavigationItemSeperator" style="display: inline;">

|</div>

</div>

<div class='TopLevelSubNavigationItemVisible'>

<div style="float: left;" class="TopLevelSubNavigationItem">

<a href="Exports.aspx">my exports</a>

</div>

<div class="TopLevelSubNavigationItemSeperator" style="display: inline;">

|</div>

</div>

<div class='TopLevelSubNavigationItemVisible'>

<div style="float: left;" class="TopLevelSubNavigationSelectedItem">

<a href="PrjMgmt.aspx">project management</a>

</div>

<div class="TopLevelSubNavigationItemSeperator" style="display: none">

|</div>

</div>

</asp:Content>

<asp:Content ID="Content1" ContentPlaceHolderID="PagePlaceholder" runat="server">

<telerik:RadScriptManager ID="sm" runat="server" />

<div style="width: 100%;">

<div style="padding-top: 10px; padding-bottom: 25px; padding-left: 25px; padding-right: 25px;">

<table width="100%">

<tr>

<td style="width: 100%">

<asp:UpdatePanel ID="upRes" runat="server">

<ContentTemplate>

<table width="100%" cellpadding="0" cellspacing="0">

<tr style="background-color: White;">

<td>

<div class="TitleBarTextArea" style="padding-top: 5px; padding-left: 3px">

<h1 class="TitleBarTitle">

Project Management

</h1>

</div>

</td>

</tr>

<tr style="background-color: White;">

<td align="right" valign="top">

<table cellpadding="0" cellspacing="5" align="center" width="100%">

<tr>

<td align="left">

<span style="font-size: 8pt"><b>Line Of Business</b></span>

</td>

<td align="left">

<span style="font-size: 8pt"><b>Division Name</b></span>

</td>

<td align="left">

<span style="font-size: 8pt"><b>Region Name</b></span>

</td>

<td align="left">

<span style="font-size: 8pt"><b>Project Manager Name</b></span>

</td>

<td align="left">

<span style="font-size: 8pt"><b>Project Name</b></span>

</td>

</tr>

<tr>

<td align="left" style="width: 11%">

<telerik:RadComboBox ID="txtLineOfBus" OnSelectedIndexChanged="txtLineOfBus_SelectedIndexChanged"

MarkFirstMatch="true" runat="server" CollapseDelay="0" CollapseAnimation-Duration="0"

Width="100%" Height="130px" DropDownWidth="140px" AllowCustomText="true" AutoPostBack="true"

DataTextField="LobDesc" DataValueField="LobId" DataSourceID="sqlDsLOB" OnClientSelectedIndexChanged="OnClientSelectedIndexChanged">

</telerik:RadComboBox>

<asp:SqlDataSource ID="sqlDsLOB" runat="server" ConnectionString="<%$ ConnectionStrings:SqlConnectionString %>"

SelectCommand="select distinct LobDesc,LobID from v_qryGetSites order by LobID" />

</td>

<td align="left" style="width: 15%">

<telerik:RadComboBox ID="txtHeadName" AutoPostBack="true" OnSelectedIndexChanged="txtHeadName_SelectedIndexChanged"

AllowCustomText="true" CollapseDelay="0" CollapseAnimation-Duration="0" runat="server"

Width="100%" Height="180px" DataSourceID="sqlDSHeadName" DataTextField="DivisionName"

DropDownWidth="200px" DataValueField="DId" MarkFirstMatch="true">

</telerik:RadComboBox>

<asp:SqlDataSource ID="sqlDSHeadName" runat="server" ConnectionString="<%$ ConnectionStrings:SqlConnectionString %>"

SelectCommand="select distinct DivisionName, DId from v_qryGetSites where LobDesc like @Lob order by DivisionName">

<SelectParameters>

<asp:Parameter Name="Lob" DefaultValue="%" />

</SelectParameters>

</asp:SqlDataSource>

</td>

<td align="left" style="width: 11%">

<telerik:RadComboBox ID="txtMarName" OnSelectedIndexChanged="txtMarName_SelectedIndexChanged"

MarkFirstMatch="true" runat="server" CollapseDelay="0" CollapseAnimation-Duration="0"

Width="100%" Height="190px" DropDownWidth="148px" AllowCustomText="true" AutoPostBack="true"

DataTextField="MarketName" DataValueField="mId" DataSourceID="sqldsMarName">

</telerik:RadComboBox>

<asp:SqlDataSource ID="sqldsMarName" runat="server" ConnectionString="<%$ ConnectionStrings:SqlConnectionString %>"

SelectCommand="select distinct MarketName, mId from v_qryGetSites where LobDesc like @Lob and DivisionName like @DivisionName order by MarketName">

<SelectParameters>

<asp:Parameter Name="Lob" DefaultValue="%" />

<asp:Parameter Name="DivisionName" DefaultValue="%" />

</SelectParameters>

</asp:SqlDataSource>

</td>

<td align="left" style="width: 15%">

<telerik:RadComboBox ID="txtPrjMgrName" runat="server" Width="100%" OnSelectedIndexChanged="txtPrjMgrName_SelectedIndexChanged"

AllowCustomText="true" CollapseDelay="0" CollapseAnimation-Duration="0" Height="180px"

DropDownWidth="206px" DataSourceID="sqlPMNProName" DropDownCssClass="drpBorder"

AutoPostBack="true" DataTextField="ProjectMgrName" DataValueField="usrid" MarkFirstMatch="true">

</telerik:RadComboBox>

<asp:SqlDataSource ID="sqlPMNProName" runat="server" ConnectionString="<%$ ConnectionStrings:SqlConnectionString %>"

SelectCommand="select distinct ProjectMgrName, usrid from v_qryGetSites where LobDesc like @Lob and DivisionName like @DivisionName and MarketName Like @MarketName order by ProjectMgrName">

<SelectParameters>

<asp:Parameter Name="Lob" DefaultValue="%" />

<asp:Parameter Name="DivisionName" DefaultValue="%" />

<asp:Parameter Name="MarketName" DefaultValue="%" />

</SelectParameters>

</asp:SqlDataSource>

</td>

<td align="left" style="width: 22%">

<telerik:RadComboBox ID="txtProjName" runat="server" Width="100%" AllowCustomText="true"

CollapseDelay="0" CollapseAnimation-Duration="0" Height="180px" DropDownWidth="315px"

DataSourceID="sqlDSProName" DropDownCssClass="drpBorder" DataTextField="ProjectDesc"

DataValueField="ProjectId" MarkFirstMatch="true">

</telerik:RadComboBox>

<asp:SqlDataSource ID="sqlDSProName" runat="server"

SelectCommand="select distinct ProjectDesc, ProjectId from v_qryGetSites where LobDesc like @Lob and DivisionName like @DivisionName and MarketName Like @MarketName and isnull(ProjectMgrName,' ') Like @ProjectMgrName and ProjectId > 1 order by ProjectDesc"

ConnectionString="<%$ ConnectionStrings:SqlConnectionString %>">

<SelectParameters>

<asp:Parameter Name="Lob" DefaultValue="%" />

<asp:Parameter Name="DivisionName" DefaultValue="%" />

<asp:Parameter Name="MarketName" DefaultValue="%" />

<asp:Parameter Name="ProjectMgrName" DefaultValue="%" />

</SelectParameters>

</asp:SqlDataSource>

</td>

<td valign="bottom" style="width: 3%">

<asp:ImageButton ID="btnSearch" runat="server" ImageAlign="Middle" ImageUrl="~/Images/img_btn_search.png"

OnClick="btnSearch_Click" />

</td>

</tr>

</table>

</td>

</tr>

<tr>

<td>

</td>

</tr>

<tr id="dispmsg" visible="false" runat="server">

<td valign="top" align="center" style="width: 90%;">

<div style="width: 95%;">

<asp:Label ID="lblMsge" runat="server" Font-Bold="True" Font-Size="10pt" BackColor="Yellow"

ForeColor="Black"></asp:Label>

</div>

</td>

</tr>

<tr>

<td valign="top" style="width: 100%; height: 502px" align="left">

<div id="trResults" visible="false" runat="server" style="width: 100%;">

<table cellpadding="0" cellspacing="0" align="left" width="100%">

<tr>

<td align="left">

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

<ClientEvents OnRequestStart="onRequestStart" />

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="gvPjtMnt">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="gvPjtMnt" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<div style="width: 100%; height: 650px; overflow: auto; overflow-y: hidden">

<telerik:RadGrid ID="gvPjtMnt" runat="server" Height="600px" Width="99%" AutoGenerateColumns="false"

BorderWidth="2px" BorderStyle="Solid" BackColor="White" AllowPaging="True" PagerStyle-AlwaysVisible="true"

PageSize="20" AllowSorting="True" AllowFilteringByColumn="true" OnNeedDataSource="gvPjtMnt_OnNeedDataSource"

OnItemCommand="gvPjtMnt_ItemCommand" OnItemCreated="gvPjtMnt_ItemCreated" OnItemDataBound="gvPjtMnt_ItemDataBound">

<HeaderStyle Height="20px" BackColor="#004000" Font-Size="8pt" Font-Bold="True" ForeColor="White"

HorizontalAlign="Center" BorderColor="White" BorderWidth="1px" />

<AlternatingItemStyle Font-Size="8pt" BackColor="#F5F5E9" HorizontalAlign="Center"

BorderWidth="1px" BorderColor="White" />

<ItemStyle HorizontalAlign="Center" />

<ExportSettings ExportOnlyData="true" IgnorePaging="true" FileName="Project Management">

</ExportSettings>

<MasterTableView GridLines="None" CommandItemDisplay="Top" DataKeyNames="ProjectId"

HorizontalAlign="Center" AllowFilteringByColumn="true">

<CommandItemTemplate>

<table style="width: 100%">

<tr>

<td align="right" style="width: 78%">

<asp:LinkButton ID="lnkshwFilter" Text="ShowFilter" Font-Underline="true" ForeColor="MidnightBlue"

runat="server" OnClientClick="return showFilterItem()" />

<asp:LinkButton ID="lnkhdFilter" Text="HideFilter" Font-Underline="true" ForeColor="MidnightBlue"

runat="server" OnClientClick="return hideFilterItem()" />

</td>

<td align="right" style="height: 10px;">

Total Records found: <asp:Label ID="lblTotRecCount" runat="server" Font-Bold="True"

Font-Size="10pt" ForeColor="Black" Text="0"></asp:Label>

</td>

<td align="right">

<asp:LinkButton ID="lnkExportAll" Text="ExportAll" Font-Underline="true" ForeColor="MidnightBlue"

runat="server" OnClick="ExportAll_Click" />

</td>

<td align="right" style="width: 2%">

<asp:ImageButton ID="ExportToExcelButton" runat="server" ImageUrl="~/images/ExportToExcel.gif"

ToolTip="Export to Excel" OnClick="ExportExcel_Click" />

</td>

</tr>

</table>

</CommandItemTemplate>

<Columns>

<telerik:GridBoundColumn DataField="ProjectId" UniqueName="ProjectId" Visible="false">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="LOB" DataField="LOB" UniqueName="LOB">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Division Name" DataField="Division" UniqueName="Division">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Region Name" DataField="MarketName" UniqueName="MarketName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Project Name" DataField="ProjectName" UniqueName="ProjectName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Project Manager Name" DataField="ProjectMgrName"

UniqueName="ProjectMgrName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Number Of Sites Received" DataField="NumSitesReceived"

UniqueName="NumSitesReceived">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Accept Service Order Date" DataField="AcceptServiceOrderTaskCompleteDate"

UniqueName="AcceptServiceOrderTaskCompleteDate" DataFormatString="{0:MM/dd/yyyy}">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="PTD" DataField="PTD" UniqueName="PTD" DataFormatString="{0:MM/dd/yyyy}">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Health Reason" DataField="HealthReason" UniqueName="HealthReason">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Project Health" DataField="ProjectHealth" UniqueName="ProjectHealth">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Customer Signed Date" DataField="CustomerSignedDate"

UniqueName="CustomerSignedDate" DataFormatString="{0:MM/dd/yyyy}">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="OA Complete Date" DataField="OACompleteDate"

UniqueName="OACompleteDate" DataFormatString="{0:MM/dd/yyyy}">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Customer Requested Due Date" DataField="CustomerRequestedDueDate"

UniqueName="CustomerRequestedDueDate" DataFormatString="{0:MM/dd/yyyy}">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Last Note Added" DataField="LastNoteAdded" HeaderStyle-Width="10%"

ItemStyle-Width="10%" UniqueName="LastNoteAdded">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn UniqueName="EditRows" HeaderStyle-Width="2%" ItemStyle-Width="2%"

AllowFiltering="false">

<ItemTemplate>

<asp:ImageButton runat="server" ID="EditPMTsk" CommandName="EditRow" ImageUrl="Images/edit-icon.png"

ImageAlign="Middle" ToolTip="Edit Task" />

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

<ItemStyle ForeColor="#3C5F22" Font-Size="8pt" BackColor="White" BorderWidth="0px"

BorderColor="White" />

<PagerStyle Mode="NextPrevAndNumeric" AlwaysVisible="true" />

</MasterTableView>

<ClientSettings AllowColumnsReorder="true">

<ClientEvents OnGridCreated="GridCreated" />

<Scrolling AllowScroll="true" UseStaticHeaders="true" ScrollHeight="580px" />

<Resizing AllowColumnResize="true" EnableRealTimeResize="false" ResizeGridOnColumnResize="false" ShowRowIndicatorColumn="false" />

</ClientSettings>

</telerik:RadGrid>

</div>

</td>

</tr>

</table>

</div>

</td>

</tr>

</table>

</ContentTemplate>

</asp:UpdatePanel>

</td>

</tr>

</table>

<asp:UpdateProgress ID="UpdateProgress2" DisplayAfter="1" AssociatedUpdatePanelID="upRes"

runat="server">

<ProgressTemplate>

<iframe frameborder="0" src="about:blank" class="iframestyle"></iframe>

<div class="iframeDiv">

<img src="Images/rotate_large.gif" alt="" />

</div>

<div>

</div>

</ProgressTemplate>

</asp:UpdateProgress>

<telerik:RadWindowManager ID="RadWindowManager1" runat="server" EnableViewState="true">

<Windows>

<telerik:RadWindow ID="winBlkTskAssign" runat="server" ShowContentDuringLoad="false"

Width="820px" Height="550px" Skin="Forest" Behaviors="Default" Animation="FlyIn">

<ContentTemplate>

<div style="padding-top: 5px; padding-left: 10px">

<asp:UpdatePanel runat="server" ID="upBlkTskAssign" OnUnload="RegisterUpdatePanel2">

<ContentTemplate>

<div style="padding-right: 10px; padding-top: 5px; text-align: left">

<table class="customFont" cellspacing="5" width="100%">

<tr align="left">

<td align="left">

<table cellpadding="0" cellspacing="6" align="left">

<tr class="customFont">

<td align="right">

<b>Project Name :</b>

</td>

<td align="left">

<asp:Label ID="lblpjtName" runat="server"></asp:Label>

</td>

</tr>

<tr class="customFont">

<td align="right">

<b>Line Of Business :</b>

</td>

<td align="left">

<asp:Label ID="lbllob" runat="server"></asp:Label>

</td>

</tr>

<tr class="customFont">

<td align="right">

<b>Division Name :</b>

</td>

<td align="left">

<asp:Label ID="lblHeadendName" runat="server"></asp:Label>

</td>

</tr>

<tr class="customFont">

<td align="right">

<b>Region Name :</b>

</td>

<td align="left">

<asp:Label ID="lblMarName" runat="server"></asp:Label>

</td>

</tr>

</table>

</td>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

<td align="left">

<cc2:TabContainer ID="tabTskAssign" runat="server" Height="300px" Width="98%" ActiveTabIndex="0">

<cc2:TabPanel runat="server" ID="Editandassign" Enabled="true" Width="100%">

<HeaderTemplate>

Edit Project

</HeaderTemplate>

<ContentTemplate>

<div style="text-align: left; vertical-align: top;">

<img src="Images/img_info_dot.png" alt="" title="Information" />

<asp:Label ID="lblInfo" runat="server" ForeColor="Black" BackColor="Yellow" Font-Size="10pt"

Text="Please use update button to reflect your data changes"></asp:Label>

<table runat="server" style="font-size: 8pt" cellpadding="0" cellspacing="0">

<tr>

<td>

</td>

<td>

</td>

<td>

</td>

<td>

</td>

</tr>

<tr>

<td>

<table align="left">

<tr>

<td align="right" width="100px; ">

Project Health :

</td>

<td align="left" style="padding-bottom: 4px;">

<telerik:RadComboBox ID="PJHealth" EmptyMessage="Please select" runat="server" CollapseDelay="0"

DropDownWidth="160px" Width="160px" AllowCustomText="True" MarkFirstMatch="True"

CausesValidation="true" DataTextField="ProjHealth" DataValueField="ProjHealth"

DataSourceID="sqlDSProjHlth">

<CollapseAnimation Duration="0" />

</telerik:RadComboBox>

<asp:SqlDataSource ID="sqlDSProjHlth" runat="server" ConnectionString="<%$ ConnectionStrings:SqlConnectionString %>"

SelectCommand="select distinct ProjHealth from ProjHealth"></asp:SqlDataSource>

</td>

</tr>

</table>

</td>

<td>

<table align="right">

<tr>

<td align="right" width="200px; ">

Customer Req Due Date :

</td>

<td align="left">

<asp:TextBox ID="txtCustDueDt" runat="server"></asp:TextBox>

<cc2:CalendarExtender CssClass="AjaxCalendar" OnClientShowing="DisplayDateToday"

ID="CalendarExtender25" runat="server" PopupButtonID="txtCustDueDt" PopupPosition="TopLeft"

TargetControlID="txtCustDueDt" Enabled="True" />

<asp:RegularExpressionValidator ID="valtxtCustDueDt" runat="server" Display="None"

ControlToValidate="txtCustDueDt" ErrorMessage="Please enter valid Date." ValidationExpression=

"((^(10|12|0?[13578])([/])(3[01]|[12][0-9]|0?[1-9])([/])((1[8-9]\d{2})|([2-9]\d{3}))$)|(^(11|0?[469])([/])(30|[12][0-9]|0?[1-9])([/])((1[8-9]\d{2})|([2-9]\d{3}))$)|(^(0?2)([/])(2[0-8]|1[0-9]|0?[1-9])([/])((1[8-9]\d{2})|([2-9]\d{3}))$)|(^(0?2)([/])(29)([/])([2468][048]00)$)|(^(0?2)([/])(29)([/])([3579][26]00)$)|(^(0?2)([/])(29)([/])([1][89][0][48])$)|(^(0?2)([/])(29)([/])([2-9][0-9][0][48])$)|(^(0?2)([/])(29)([/])([1][89][2468][048])$)|(^(0?2)([/])(29)([/])([2-9][0-9][2468][048])$)|(^(0?2)([/])(29)([/])([1][89][13579][26])$)|(^(0?2)([/])(29)([/])([2-9][0-9][13579][26])$))"

></asp:RegularExpressionValidator>

<cc2:ValidatorCalloutExtender ID="ValidatorCalloutExtender24" runat="server" Enabled="True"

TargetControlID="valtxtCustDueDt">

</cc2:ValidatorCalloutExtender>

</td>

</tr>

</table>

</td>

</tr>

<tr>

<td>

<table align="left">

<tr>

<td align="right" width="100px;">

Health Reason :

</td>

<td align="left" style="padding-bottom: 4px;">

<telerik:RadComboBox ID="DDHlthReason" DataValueField="prjhealthdesc" EmptyMessage="Please select"

DataTextField="prjhealthdesc" MarkFirstMatch="True" runat="server" CollapseDelay="0"

DropDownWidth="160px" AllowCustomText="True" DataSourceID="SqlHlthReason">

<CollapseAnimation Duration="0" />

</telerik:RadComboBox>

<asp:SqlDataSource ID="SqlHlthReason" runat="server" ConnectionString="<%$ ConnectionStrings:SqlConnectionString %>"

SelectCommand="select prjhealthdesc from projhealthreason" />

</td>

</tr>

</table>

</td>

<td>

<table align="left">

<tr>

<td align="right" width="200px;">

Customer Signed Date :

</td>

<td align="left">

<asp:TextBox ID="txtCustSigndt" runat="server"></asp:TextBox>

<cc2:CalendarExtender CssClass="AjaxCalendar" OnClientShowing="DisplayDateToday"

ID="CalendarExtender23" runat="server" PopupButtonID="txtCustSigndt" PopupPosition="TopLeft"

TargetControlID="txtCustSigndt" Enabled="True" />

<asp:RegularExpressionValidator ID="valtxtCustSigndt" runat="server" ControlToValidate="txtCustSigndt"

ErrorMessage="Please enter valid Date." Display="None" ValidationExpression=

"((^(10|12|0?[13578])([/])(3[01]|[12][0-9]|0?[1-9])([/])((1[8-9]\d{2})|([2-9]\d{3}))$)|(^(11|0?[469])([/])(30|[12][0-9]|0?[1-9])([/])((1[8-9]\d{2})|([2-9]\d{3}))$)|(^(0?2)([/])(2[0-8]|1[0-9]|0?[1-9])([/])((1[8-9]\d{2})|([2-9]\d{3}))$)|(^(0?2)([/])(29)([/])([2468][048]00)$)|(^(0?2)([/])(29)([/])([3579][26]00)$)|(^(0?2)([/])(29)([/])([1][89][0][48])$)|(^(0?2)([/])(29)([/])([2-9][0-9][0][48])$)|(^(0?2)([/])(29)([/])([1][89][2468][048])$)|(^(0?2)([/])(29)([/])([2-9][0-9][2468][048])$)|(^(0?2)([/])(29)([/])([1][89][13579][26])$)|(^(0?2)([/])(29)([/])([2-9][0-9][13579][26])$))"

></asp:RegularExpressionValidator>

<cc2:ValidatorCalloutExtender ID="ValidatorCalloutExtender22" runat="server" Enabled="True"

TargetControlID="valtxtCustSigndt">

</cc2:ValidatorCalloutExtender>

</td>

</tr>

</table>

</td>

</tr>

<tr>

<td>

<table align="left">

<tr>

<td>

</td>

<td>

</td>

</tr>

</table>

</td>

<td>

<table align="left">

<tr>

<td align="right" width="200px;">

OA Complete Date :

</td>

<td align="left">

<asp:TextBox ID="txtOACmptDt" runat="server"></asp:TextBox>

<cc2:CalendarExtender CssClass="AjaxCalendar" OnClientShowing="DisplayDateToday"

ID="CalendarExtender24" runat="server" PopupButtonID="txtOACmptDt" PopupPosition="BottomLeft"

TargetControlID="txtOACmptDt" Enabled="True" />

<asp:RegularExpressionValidator ID="valtxtOACmptDt" runat="server" ControlToValidate="txtOACmptDt"

Display="None" ErrorMessage="Please enter valid Date." ValidationExpression=

"((^(10|12|0?[13578])([/])(3[01]|[12][0-9]|0?[1-9])([/])((1[8-9]\d{2})|([2-9]\d{3}))$)|(^(11|0?[469])([/])(30|[12][0-9]|0?[1-9])([/])((1[8-9]\d{2})|([2-9]\d{3}))$)|(^(0?2)([/])(2[0-8]|1[0-9]|0?[1-9])([/])((1[8-9]\d{2})|([2-9]\d{3}))$)|(^(0?2)([/])(29)([/])([2468][048]00)$)|(^(0?2)([/])(29)([/])([3579][26]00)$)|(^(0?2)([/])(29)([/])([1][89][0][48])$)|(^(0?2)([/])(29)([/])([2-9][0-9][0][48])$)|(^(0?2)([/])(29)([/])([1][89][2468][048])$)|(^(0?2)([/])(29)([/])([2-9][0-9][2468][048])$)|(^(0?2)([/])(29)([/])([1][89][13579][26])$)|(^(0?2)([/])(29)([/])([2-9][0-9][13579][26])$))"

></asp:RegularExpressionValidator>

<cc2:ValidatorCalloutExtender ID="ValidatorCalloutExtender23" runat="server" Enabled="True"

TargetControlID="valtxtOACmptDt">

</cc2:ValidatorCalloutExtender>

</td>

</tr>

</table>

</td>

</tr>

<tr>

<td colspan="4" style="font-size: medium; height: 30px; font-weight: bold;">

Project Assignment

</td>

</tr>

<tr>

<td>

<table align="left">

<tr>

<td align="right" width="100px;">

Task Owner :

</td>

<td align="left" style="padding-bottom: 4px;">

<telerik:RadComboBox ID="ddlPmgmtTaskOwner" runat="server" MarkFirstMatch="True"

CollapseAnimation-Duration="0" CollapseDelay="0" DropDownWidth="160px" AllowCustomText="True"

EmptyMessage="Please Select">

</telerik:RadComboBox>

</td>

</tr>

</table>

</td>

<td>

<table>

<tr>

<td>

</td>

<td>

</td>

</tr>

</table>

</td>

</tr>

<tr>

<td colspan="4" align="right">

<asp:Button ID="btnSubmit" OnClick="btnSubmit_Click" ValidationGroup="EditTask" runat="server"

Text="Update" />

<asp:Button ID="btnCancel" OnClientClick="ClosePopups()" runat="server" Text="Cancel" />

</td>

</tr>

</table>

</div>

</ContentTemplate>

</cc2:TabPanel>

<cc2:TabPanel runat="server" ID="TabNotes" Enabled="true" Width="100%">

<HeaderTemplate>

Add Notes

</HeaderTemplate>

<ContentTemplate>

<table class="customFont" width="97%">

<tr id="trNotes" runat="server">

<td align="right">

<asp:Button Text="Add Note" runat="server" ID="btnAddNewNote" OnClientClick="return showAddNotes()" />

</td>

</tr>

<tr style="display: none; position: relative" id="trAddNewNotes">

<td>

<table style="background-color: #F5F5E9" cellspacing="2">

<tr>

<td align="left" style="width: 70px;">

Note Type

</td>

<td align="left" style="width: 80px; height: 24px;">

<telerik:RadComboBox ID="ddlNoteType" EmptyMessage="Please select" runat="server"

MarkFirstMatch="True" CollapseDelay="0" Width="115px" DropDownWidth="100px" AllowCustomText="True">

<CollapseAnimation Duration="0" />

</telerik:RadComboBox>

<asp:RequiredFieldValidator InitialValue="" ValidationGroup="Notes" ID="custValCou"

runat="server" ControlToValidate="ddlNoteType" ClientValidationFunction="ddlNt"

Display="None" ErrorMessage="Please select Note Type."></asp:RequiredFieldValidator>

<cc2:ValidatorCalloutExtender ID="valExt" TargetControlID="custValCou" runat="server"

Enabled="True">

</cc2:ValidatorCalloutExtender>

</td>

</tr>

<tr>

<td align="left" valign="middle" style="width: 70px;">

Notes

</td>

<td align="left">

<asp:TextBox ID="txtNoteDesc" runat="server" TextMode="MultiLine" Rows="3" Width="570px"></asp:TextBox>

<asp:RequiredFieldValidator ID="valCliID" ValidationGroup="Notes" ControlToValidate="txtNoteDesc"

Display="None" runat="server" ErrorMessage="Please enter Notes."></asp:RequiredFieldValidator>

<cc2:ValidatorCalloutExtender ID="ValidatorCalloutExtender19" TargetControlID="valCliID"

runat="server">

</cc2:ValidatorCalloutExtender>

</td>

<td valign="middle">

<asp:Button ID="btnAddNote" Width="50px" OnClick="btnAddNote_Click" ValidationGroup="Notes"

runat="server" Text="Add" />

<asp:Button ID="imgbtnNotesCancel" Width="50px" runat="server" OnClientClick="return hideAddNotes()"

Text="Cancel" />

</td>

</tr>

</table>

</td>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

<td>

<telerik:RadGrid ID="gvNotes" GridLines="None" AllowSorting="false" Width="100%"

runat="server" AutoGenerateColumns="false" ShowFooter="false" ShowGroupPanel="false"

ShowStatusBar="false" EnableEmbeddedSkins="false" HeaderStyle-HorizontalAlign="Left"

ItemStyle-HorizontalAlign="Left" Font-Size="7.5pt">

<HeaderStyle BackColor="#004000" ForeColor="White" Font-Size="7.5pt" Font-Bold="True"

HorizontalAlign="Left" BorderColor="White" />

<AlternatingItemStyle BackColor="#F5F5E9" />

<MasterTableView>

<Columns>

<telerik:GridBoundColumn HeaderText="#" DataField="rowNum" HeaderStyle-Width="8px"

ItemStyle-Width="8px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn ReadOnly="true" HeaderStyle-Width="414px" ItemStyle-Width="414px"

UniqueName="Notes" HeaderText="Notes" DataField="Notes">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn UniqueName="Type Description" HeaderStyle-Width="58px" ItemStyle-Width="58px"

HeaderText="Note Type" DataField="Type Description" ReadOnly="true">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn HeaderText="Created By">

<ItemTemplate>

<asp:Label ID="lblCreatedBy" runat="server" Width="78px" Text='<%# Bind("CreatedBy") %>'></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn UniqueName="CreationDate" HeaderText="Created Date" DataField="CreationDate"

ReadOnly="true">

</telerik:GridBoundColumn>

</Columns>

</MasterTableView>

<ClientSettings>

<Scrolling AllowScroll="True" UseStaticHeaders="True" ScrollHeight="120px" SaveScrollPosition="True">

</Scrolling>

</ClientSettings>

</telerik:RadGrid>

</td>

</tr>

</table>

</ContentTemplate>

</cc2:TabPanel>

</cc2:TabContainer>

</td>

</tr>

</table>

</div>

<asp:UpdateProgress ID="UpdateProgress1" AssociatedUpdatePanelID="upBlkTskAssign"

DisplayAfter="0" runat="server">

<ProgressTemplate>

<iframe frameborder="0" src="about:blank" class="iframestyle"></iframe>

<div class="iframeDiv">

<img src="Images/rotate_large.gif" alt="" />

</div>

</ProgressTemplate>

</asp:UpdateProgress>

<input id="selTskOwner" runat="server" type="hidden" name="selTskOwner" />

</ContentTemplate>

</asp:UpdatePanel>

</div>

</ContentTemplate>

</telerik:RadWindow>

</Windows>

</telerik:RadWindowManager>

</div>

</asp:Content>

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Text;

using System.Collections;

using System.Reflection;

using Telerik.Web.UI;

using Telerik.Web.UI.GridExcelBuilder;

using System.Data.SqlClient;

using Excel;

using System.IO;

using System.Threading;

public partial class PrjMgmt : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

Response.AddHeader("Refresh", Convert.ToString((Session.Timeout * 60) + 5));

gvNotes.Attributes.Add("style", "word-break:break-all;word-wrap:break-word");

if (!IsPostBack)

{

clsTaskUpdates_BL objBL = new clsTaskUpdates_BL();

ddlNoteType.DataSource = objBL.getNoteTypes_BL();

ddlNoteType.DataTextField = "nTypeDesc";

ddlNoteType.DataValueField = "nTypeDesc";

ddlNoteType.DataBind();

ddlPmgmtTaskOwner.DataSource = objBL.getPMUserNames_BL("6");

ddlPmgmtTaskOwner.DataTextField = "ProjectManagerName";

ddlPmgmtTaskOwner.DataValueField = "ProjectManagerName";

ddlPmgmtTaskOwner.DataBind();

}

protected void btnSearch_Click(object sender, EventArgs e)

{

try

{

DataSet dsResult = new DataSet();

lblMsge.Text = string.Empty;

string strHeadName, strMarName, strProName, strLOC, strpmname;

if (txtLineOfBus.Text.Trim() != string.Empty)

strLOC =txtLineOfBus.SelectedItem.Value.Trim();

else

strLOC = "%";

if (txtHeadName.Text.Trim() != string.Empty)

strHeadName = txtHeadName.SelectedItem.Value.Trim();

else

strHeadName = "%";

if (txtMarName.Text.Trim() != string.Empty)

strMarName = txtMarName.SelectedItem.Value.Trim();

else

strMarName = "%";

if (txtProjName.Text.Trim() != string.Empty)

strProName = txtProjName.SelectedItem.Value.Trim();

else

strProName = "%";

if (txtPrjMgrName.Text.Trim() != string.Empty)

strpmname = txtPrjMgrName.SelectedItem.Value.Trim();

else

strpmname = "%";

clsTaskUpdates_BL clsObj = new clsTaskUpdates_BL();

dsResult = clsObj.getSitePMgmtSearch_BL(strProName, strHeadName, strMarName, strLOC, strpmname);

Session["PmgmtResults"] = dsResult;

if (dsResult.Tables[0].Rows.Count > 0)

ScriptManager.RegisterClientScriptBlock(this.upRes, this.GetType(), "RecCount", "document.getElementById('ctl00_PagePlaceholder_gvPjtMnt_ctl00_ctl02_ctl00_lblTotRecCount').innerHTML='" + dsResult.Tables[0].Rows.Count + "'", true);

string ResultCount = dsResult.Tables[0].Rows.Count.ToString();

Session["RtCount"] = ResultCount;

gvPjtMnt.DataSource = dsResult;

gvPjtMnt.Rebind();

if (gvPjtMnt.Items.Count <= 0)

{

lblMsge.Text = "No records found, please change the search criteria and try again.";

trResults.Visible = false;

dispmsg.Visible = true;

}

else

{

dispmsg.Visible = false;

trResults.Visible = true;

}

catch (Exception ex)

{

}

protected void btnAddNote_Click(object sender, EventArgs e)

{

try

{

clsTaskUpdates_BL objBL = new clsTaskUpdates_BL();

string strName = Session["UserName"].ToString();

string strPjtID = Session["projctId"].ToString();

string straddnote = txtNoteDesc.Text.Trim();

string DDLPMNoteType = ddlNoteType.Text.Trim();

gvNotes.DataSource = objBL.setPMNotes_Bl(strPjtID, strName, DDLPMNoteType, straddnote);

gvNotes.DataBind();

ddlNoteType.ClearSelection();

txtNoteDesc.Text = string.Empty;

}

catch (Exception ex)

{

}

protected void btnSubmit_Click(object sender, EventArgs e)

{

try

{

string HlthReason = DDHlthReason.Text.Trim();

string PjtHealth = PJHealth.Text.Trim();

string CustSgndDt = txtCustSigndt.Text;

string OACmptDt = txtOACmptDt.Text;

string CustRqstDueDt = txtCustDueDt.Text;

string ProjtID = Session["projctId"].ToString();

int PrjtID = 0;

int.TryParse(ProjtID, out PrjtID);

string TskAssignPM = ddlPmgmtTaskOwner.Text.Trim();

clsTaskUpdates_BL objBL = new clsTaskUpdates_BL();

objBL.setTaskPmgmt_Bl(TskAssignPM, HlthReason, PjtHealth, CustSgndDt, OACmptDt, CustRqstDueDt, PrjtID);

btnSearch_Click(sender, e);

DDHlthReason.Text = "";

ddlPmgmtTaskOwner.Text = "";

PJHealth.Text = "";

txtCustSigndt.Text = "";

txtOACmptDt.Text = "";

txtCustDueDt.Text = "";

ScriptManager.RegisterClientScriptBlock(this.upRes, this.GetType(), "strBlkTskAssignment", "ClosePopups()", true);

}

catch (Exception ex)

{

}

protected void gvPjtMnt_OnNeedDataSource(object sender, GridNeedDataSourceEventArgs e)

{

if(Session["PmgmtResults"]!=null)

btnSearch_Click(sender, e);

}

protected void gvPjtMnt_ItemCommand(object sender, GridCommandEventArgs e)

{

string TotalCount = Session["RtCount"].ToString();

int myIntVal = 0;

int.TryParse(TotalCount, out myIntVal);

if (myIntVal > 0)

if (e.CommandName == "EditRow")

{

GridDataItem dataitem = e.Item as GridDataItem;

string strPMPjtid = dataitem["ProjectId"].Text.Trim();

Session["projctId"] = strPMPjtid.Trim();

lbllob.Text = dataitem["LOB"].Text.Trim();

lblpjtName.Text = dataitem["ProjectName"].Text.Trim();

Session["strlblpjtName"] = lblpjtName.Text.Trim();

lblMarName.Text = dataitem["MarketName"].Text.Trim();

lblHeadendName.Text = dataitem["Division"].Text.Trim();

DBLayer obj = new DBLayer();

SqlCommand cmd = new SqlCommand();

SqlParameter param = new SqlParameter("@fProjectId", SqlDbType.NVarChar, 50);

param = new SqlParameter("@fProjectId", SqlDbType.NVarChar, 25);

param.Value = strPMPjtid;

param.Direction = ParameterDirection.Input;

cmd.Parameters.Add(param);

DataSet dsPMNotes = obj.ExecuteDatasetSql("[usp_GetProjectNotes]", cmd);

gvNotes.DataSource = dsPMNotes;

gvNotes.DataBind();

string winprjname = "Edit Project: " + lblpjtName.Text;

ScriptManager.RegisterClientScriptBlock(this.upRes, this.GetType(), "strBlkTskAssignment", "openpopups('" + winprjname + "')", true);

}

protected void gvPjtMnt_ItemCreated(object sender, GridItemEventArgs e)

{

try

{

//if (e.Item is GridFilteringItem)

//{

// e.Item.Visible = false;

//}

if (e.Item is GridCommandItem)

{

LinkButton st = (LinkButton)e.Item.FindControl("lnkhdFilter");

st.Style["display"] = "none";

}

catch (Exception ex)

{

}

protected void gvPjtMnt_ItemDataBound(object sender, GridItemEventArgs e)

{

if (e.Item is GridDataItem)

{

GridDataItem dataItem = e.Item as GridDataItem;

TableCell myCell = dataItem["ProjectHealth"];

myCell.Font.Size = 10;

myCell.Font.Bold = true;

if (myCell.Text.Trim() == "GREEN")

{

myCell.BackColor = System.Drawing.Color.Green;

myCell.ForeColor = System.Drawing.Color.White;

}

if (myCell.Text.Trim() == "RED")

{

myCell.BackColor = System.Drawing.Color.Red;

myCell.ForeColor = System.Drawing.Color.White;

}

if (myCell.Text.Trim() == "YELLOW")

{

myCell.BackColor = System.Drawing.Color.Yellow;

}

protected void txtLineOfBus_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)

{

lblMsge.Text = string.Empty;

try

{

if (txtLineOfBus.Text != string.Empty)

{

sqlDSHeadName.SelectParameters["Lob"].DefaultValue = txtLineOfBus.Text;

sqldsMarName.SelectParameters["Lob"].DefaultValue = txtLineOfBus.Text;

sqlPMNProName.SelectParameters["Lob"].DefaultValue = txtLineOfBus.Text;

sqlDSProName.SelectParameters["Lob"].DefaultValue = txtLineOfBus.Text;

}

else

{

sqlDSHeadName.SelectParameters["Lob"].DefaultValue = "%";

sqldsMarName.SelectParameters["Lob"].DefaultValue = "%";

sqlPMNProName.SelectParameters["Lob"].DefaultValue = "%";

sqlDSProName.SelectParameters["Lob"].DefaultValue = "%";

}

catch (Exception ex)

{

}

protected void txtHeadName_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)

{

lblMsge.Text = string.Empty;

try

{

if (txtLineOfBus.Text != string.Empty)

{

sqlDSHeadName.SelectParameters["Lob"].DefaultValue = txtLineOfBus.Text;

sqldsMarName.SelectParameters["Lob"].DefaultValue = txtLineOfBus.Text;

sqlPMNProName.SelectParameters["Lob"].DefaultValue = txtLineOfBus.Text;

sqlDSProName.SelectParameters["Lob"].DefaultValue = txtLineOfBus.Text;

}

else

{

sqlDSHeadName.SelectParameters["Lob"].DefaultValue = "%";

sqldsMarName.SelectParameters["Lob"].DefaultValue = "%";

sqlPMNProName.SelectParameters["Lob"].DefaultValue = "%";

sqlDSProName.SelectParameters["Lob"].DefaultValue = "%";

}

if (txtHeadName.Text != string.Empty)

{

sqldsMarName.SelectParameters["DivisionName"].DefaultValue = txtHeadName.Text;

sqlPMNProName.SelectParameters["DivisionName"].DefaultValue = txtHeadName.Text;

sqlDSProName.SelectParameters["DivisionName"].DefaultValue = txtHeadName.Text;

}

else

{

sqldsMarName.SelectParameters["DivisionName"].DefaultValue = "%";

sqlPMNProName.SelectParameters["DivisionName"].DefaultValue = "%";

sqlDSProName.SelectParameters["DivisionName"].DefaultValue = "%";

}

catch (Exception ex)

{

}

protected void txtMarName_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)

{

lblMsge.Text = string.Empty;

try

{

if (txtLineOfBus.Text != string.Empty)

{

sqlDSHeadName.SelectParameters["Lob"].DefaultValue = txtLineOfBus.Text;

sqldsMarName.SelectParameters["Lob"].DefaultValue = txtLineOfBus.Text;

sqlPMNProName.SelectParameters["Lob"].DefaultValue = txtLineOfBus.Text;

sqlDSProName.SelectParameters["Lob"].DefaultValue = txtLineOfBus.Text;

}

else

{

sqlDSHeadName.SelectParameters["Lob"].DefaultValue = "%";

sqldsMarName.SelectParameters["Lob"].DefaultValue = "%";

sqlPMNProName.SelectParameters["Lob"].DefaultValue = "%";

sqlDSProName.SelectParameters["Lob"].DefaultValue = "%";

}

if (txtHeadName.Text != string.Empty)

{

sqldsMarName.SelectParameters["DivisionName"].DefaultValue = txtHeadName.Text;

sqlPMNProName.SelectParameters["DivisionName"].DefaultValue = txtHeadName.Text;

sqlDSProName.SelectParameters["DivisionName"].DefaultValue = txtHeadName.Text;

}

else

{

sqldsMarName.SelectParameters["DivisionName"].DefaultValue = "%";

sqlPMNProName.SelectParameters["DivisionName"].DefaultValue = "%";

sqlDSProName.SelectParameters["DivisionName"].DefaultValue = "%";

}

if (txtMarName.Text != string.Empty)

{

sqlPMNProName.SelectParameters["MarketName"].DefaultValue = txtMarName.Text;

sqlDSProName.SelectParameters["MarketName"].DefaultValue = txtMarName.Text;

}

else

{

sqlPMNProName.SelectParameters["MarketName"].DefaultValue = "%";

sqlDSProName.SelectParameters["MarketName"].DefaultValue = "%";

}

catch (Exception ex)

{

}

protected void txtPrjMgrName_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)

{

lblMsge.Text = string.Empty;

try

{

if (txtLineOfBus.Text != string.Empty)

{

sqlDSHeadName.SelectParameters["Lob"].DefaultValue = txtLineOfBus.Text;

sqldsMarName.SelectParameters["Lob"].DefaultValue = txtLineOfBus.Text;

sqlPMNProName.SelectParameters["Lob"].DefaultValue = txtLineOfBus.Text;

sqlDSProName.SelectParameters["Lob"].DefaultValue = txtLineOfBus.Text;

}

else

{

sqlDSHeadName.SelectParameters["Lob"].DefaultValue = "%";

sqldsMarName.SelectParameters["Lob"].DefaultValue = "%";

sqlPMNProName.SelectParameters["Lob"].DefaultValue = "%";

sqlDSProName.SelectParameters["Lob"].DefaultValue = "%";

}

if (txtHeadName.Text != string.Empty)

{

sqldsMarName.SelectParameters["DivisionName"].DefaultValue = txtHeadName.Text;

sqlPMNProName.SelectParameters["DivisionName"].DefaultValue = txtHeadName.Text;

sqlDSProName.SelectParameters["DivisionName"].DefaultValue = txtHeadName.Text;

}

else

{

sqldsMarName.SelectParameters["DivisionName"].DefaultValue = "%";

sqlPMNProName.SelectParameters["DivisionName"].DefaultValue = "%";

sqlDSProName.SelectParameters["DivisionName"].DefaultValue = "%";

}

if (txtMarName.Text != string.Empty)

{

sqlPMNProName.SelectParameters["MarketName"].DefaultValue = txtMarName.Text;

sqlDSProName.SelectParameters["MarketName"].DefaultValue = txtMarName.Text;

}

else

{

sqlPMNProName.SelectParameters["MarketName"].DefaultValue = "%";

sqlDSProName.SelectParameters["MarketName"].DefaultValue = "%";

}

if (txtPrjMgrName.Text != string.Empty)

{

sqlDSProName.SelectParameters["ProjectManagerName"].DefaultValue = txtPrjMgrName.Text;

}

else

{

sqlDSProName.SelectParameters["ProjectManagerName"].DefaultValue = "%";

}

catch (Exception ex)

{

}

protected void ExportExcel_Click(object sender, ImageClickEventArgs e)

{

gvPjtMnt.ExportSettings.IgnorePaging = true;

gvPjtMnt.ExportSettings.ExportOnlyData = true;

gvPjtMnt.MasterTableView.GetColumn("EditRows").Display = false;

gvPjtMnt.MasterTableView.ExportToExcel();

}

protected void ExportAll_Click(object sender, EventArgs e)

{

string XportLoc, XportDivName, XportMarkName, XportPrjName, XportPMName;

if (txtLineOfBus.Text.Trim() != string.Empty)

XportLoc = txtLineOfBus.Text.Trim();

else

XportLoc = "%";

if (txtHeadName.Text.Trim() != string.Empty)

XportDivName = txtHeadName.Text.Trim();

else

XportDivName = "%";

if (txtMarName.Text.Trim() != string.Empty)

XportMarkName = txtMarName.Text.Trim();

else

XportMarkName = "%";

if (txtProjName.Text.Trim() != string.Empty)

XportPrjName = txtProjName.Text.Trim();

else

XportPrjName = "%";

if (txtPrjMgrName.Text.Trim() != string.Empty)

XportPMName = txtPrjMgrName.Text.Trim();

else

XportPMName = "%";

clsTaskUpdates_BL clsObj = new clsTaskUpdates_BL();

DataSet XportDS = clsObj.getXportAllSearch_BL(XportPrjName.Trim(), XportDivName.Trim(), XportMarkName.Trim(), XportLoc.Trim(), XportPMName.Trim());

ExportDataset objExport = new ExportDataset();

objExport.ExportToExcel(XportDS, 0, Response, "ProjectManagement_AllNotes");

}

public class ExportDataset

{

public void ExportToExcel(DataSet dSet, int TableIndex, HttpResponse Response, string FileName)

{

Response.Clear();

Response.Charset = "";

Response.ContentType = "application/vnd.ms-excel";

Response.AppendHeader("content-disposition", "attachment; filename=" + FileName + ".xls");

System.IO.StringWriter sw = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);

GridView gv = new GridView();

gv.DataSource = dSet.Tables[TableIndex];

gv.DataBind();

gv.RenderControl(hw);

Response.Write(sw.ToString());

Response.End();

}

public void RegisterUpdatePanel2(object sender, EventArgs e)

{

UpdatePanel panel = upBlkTskAssign;

MethodInfo m = (from methods in typeof(ScriptManager).GetMethods(BindingFlags.NonPublic | BindingFlags.Instance)

where methods.Name.Equals("System.Web.UI.IScriptManagerInternal.RegisterUpdatePanel")

select methods).First<MethodInfo>();

m.Invoke(ScriptManager.GetCurrent(Page), new object[] { panel });

}

//protected void gvPjtMnt_ExcelMLExportRowCreated(object source, GridExportExcelMLRowCreatedArgs e)

//{

// e.Worksheet.Name = "Project Management_" + txtLineOfBus.Text.Trim() + "_" + txtProjName.Text.Trim();

// if (e.RowType == GridExportExcelMLRowType.HeaderRow)

// {

// gvPjtMnt.Rebind();

// //add a new column to the ExcelML

// e.Worksheet.Table.Columns.Add(new ColumnElement());

// CellElement cell = new CellElement();

// //correct the autofilter

//        e.Worksheet.AutoFilter.Range = String.Format("R{0}C{1}:R{0}C{2}", 1, 1, e.Worksheet.Table.Columns.Count + 1);

// e.Row.Cells.Add(cell);

// }

// if (e.RowType == GridExportExcelMLRowType.DataRow)

// {

// //create cell for the current row

// CellElement cell = new CellElement();

// int currentRow = e.Worksheet.Table.Rows.IndexOf(e.Row) - 1;

// //populate the cell

// cell.Data.DataItem = gvTrackers1.MasterTableView.Items[currentRow]["Accept Service Order"].Text;

// cell.StyleValue = "myStyle";

// e.Row.Cells.Add(cell);

// }

//}

//protected void gvPjtMnt_ExcelMLExportStylesCreated(object source, GridExportExcelMLStyleCreatedArgs e)

//{

// StyleElement myStyle = new StyleElement("myStyle");

// myStyle.AlignmentElement.Attributes["ss:WrapText"] = "1";

// e.Styles.Add(myStyle);

//}

//protected void gvPjtMnt_RowDataBound(object sender, GridViewRowEventArgs e)

//{

// try

// {

// if (e.Row.RowType == DataControlRowType.DataRow)

// {

// foreach (TableCell cell in e.Row.Cells)

// {

//                cell.Attributes.Add("Style", "border-bottom: 2px dotted #ccc;background-position:center");

// }

// if (e.Row.RowType == DataControlRowType.DataRow)

// {

//            //e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#c4c4c4';this.style.cursor='pointer'");

// //e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#ffffff';");

//            //e.Row.Attributes["onclick"] = ClientScript.GetPostBackClientHyperlink(gvNotes, "Select$" + e.Row.RowIndex.ToString());

// }

// catch (Exception ex)

// {

// }

//}

//protected void gvPjtMnt_RowCommand(object sender, GridViewCommandEventArgs e)

//{

// try

// {

// //if (e.CommandName == "Edit")

// //{

// // GridViewRow rw = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer);

// // Label LBLH = (Label)rw.FindControl("lblHndName");

// // Label LBLM = (Label)rw.FindControl("lblMrkName");

// // Label LBLP = (Label)rw.FindControl("lblProjectName");

// // Label LBLL = (Label)rw.FindControl("lblLOBName");

// // lblMarName.Text = LBLM.Text;

// // lblHeadendName.Text = LBLH.Text;

// // lblpjtName.Text = LBLP.Text;

// // Session["strlblpjtName"] = lblpjtName.Text;

// // lbllob.Text = LBLL.Text;

// // Label pId = (Label)rw.FindControl("PjtID");

// // //Session["pmId"] = pId.Text.Trim();

// // tabTskAssign.ActiveTab = Editandassign;

//        //    ScriptManager.RegisterClientScriptBlock(this.upRes, this.GetType(), "strBlkTskAssignment", "openpopups()", true);

// //}

// if (e.CommandName == "AddPMNotes")

// {

// tabTskAssign.ActiveTab = TabNotes;

// GridViewRow rw = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer);

// Label lblpId = (Label)rw.FindControl("PjtID");

// Session["projctId"] = lblpId.Text;

// Label LBLHName = (Label)rw.FindControl("lblHndName");

// Label LBLMName = (Label)rw.FindControl("lblMrkName");

// Label LBLPName = (Label)rw.FindControl("lblProjectName");

// Label LBLLName = (Label)rw.FindControl("lblLOBName");

// lblMarName.Text = LBLMName.Text;

// lblHeadendName.Text = LBLHName.Text;

// lblpjtName.Text = LBLPName.Text;

// lbllob.Text = LBLLName.Text;

// DBLayer obj = new DBLayer();

// SqlCommand cmd = new SqlCommand();

// SqlParameter param = new SqlParameter("@fProjectId", SqlDbType.NVarChar, 50);

// param = new SqlParameter("@fProjectId", SqlDbType.NVarChar, 25);

// param.Value = lblpId.Text;

// param.Direction = ParameterDirection.Input;

// cmd.Parameters.Add(param);

// DataSet dsPMNotes = obj.ExecuteDatasetSql("[usp_GetProjectNotes]", cmd);

// gvNotes.DataSource = dsPMNotes;

// gvNotes.DataBind();

//            ScriptManager.RegisterClientScriptBlock(this.upRes, this.GetType(), "strBlkTskAssignment", "openpopups()", true);

// }

// catch (Exception ex)

// {

// }

//}

//protected void gvPjtMnt_RowEditing(object sender, GridViewEditEventArgs e)

//{

// Label lblMN = (Label)gvPjtMnt.Rows[e.NewEditIndex].FindControl("lblMrkName");

// lblMarName.Text = lblMN.Text;

// Label lblHN = (Label)gvPjtMnt.Rows[e.NewEditIndex].FindControl("lblHndName");

// lblHeadendName.Text = lblHN.Text;

// Label lblPN = (Label)gvPjtMnt.Rows[e.NewEditIndex].FindControl("lblProjectName");

// lblpjtName.Text = lblPN.Text;

// Session["strlblpjtName"] = lblpjtName.Text;

// Label lblLN = (Label)gvPjtMnt.Rows[e.NewEditIndex].FindControl("lblLOBName");

// lbllob.Text = lblLN.Text;

// Label pId = (Label)gvPjtMnt.Rows[e.NewEditIndex].FindControl("PjtID");

// Session["projctId"] = pId.Text;

// DBLayer obj = new DBLayer();

// SqlCommand cmd = new SqlCommand();

// SqlParameter param = new SqlParameter("@fProjectId", SqlDbType.NVarChar, 50);

// param = new SqlParameter("@fProjectId", SqlDbType.NVarChar, 25);

// param.Value = pId.Text;

// param.Direction = ParameterDirection.Input;

// cmd.Parameters.Add(param);

// DataSet dsPMNotes = obj.ExecuteDatasetSql("[usp_GetProjectNotes]", cmd);

// gvNotes.DataSource = dsPMNotes;

// gvNotes.DataBind();

// tabTskAssign.ActiveTab = Editandassign;

//    ScriptManager.RegisterClientScriptBlock(this.upRes, this.GetType(), "strBlkTskAssignment", "openpopups()", true);

//}

//protected void gvPjtMnt_SelectedIndexChanged(object sender, EventArgs e)

//{

// try

// {

// }

// catch (Exception ex)

// {

// }

//}

//protected void gvPjtMnt_PageIndexChanging(object sender, GridViewPageEventArgs e)

//{

// try

// {

// gvPjtMnt.PageIndex = e.NewPageIndex;

// gvPjtMnt.DataSource = Session["PmgmtResults"];

// gvPjtMnt.DataBind();

// }

// catch (Exception ex)

// {

// }

//}

//protected void gvPjtMnt_Sorting(object sender, GridViewSortEventArgs e)

//{

// try

// {

// DataSet ds = (DataSet)Session["PmgmtResults"];

// DataView dataView = ds.Tables[0].DefaultView;

// if (dataView != null)

// {

// if (Session["ResSortDire"] != null)

// {

// if (Session["ResSortDire"].ToString() == "Ascending")

// {

// e.SortDirection = SortDirection.Descending;

// Session["ResSortDire"] = "Descending";

// }

// else

// {

// Session["ResSortDire"] = "Ascending";

// }

// else

// {

// Session["ResSortDire"] = e.SortDirection;

// }

// dataView.Sort = e.SortExpression + " " + ConvertSortDirectionToSql(e.SortDirection);

// gvPjtMnt.DataSource = dataView;

// gvPjtMnt.DataBind();

// }

// catch (Exception ex)

// {

// }

//}

//private string ConvertSortDirectionToSql(SortDirection sortDirection)

//{

// string newSortDirection = String.Empty;

// switch (sortDirection)

// {

// case SortDirection.Ascending:

// newSortDirection = "ASC";

// break;

// case SortDirection.Descending:

// newSortDirection = "DESC";

// break;

// }

// return newSortDirection;

//}

}

answered on 22 Sep 2010, 02:29 PM

Hello Raj,

Maybe you should apply hasLayout (see link below) to some other element(s). In order to test and investigate the problem locally, we will need a simple standalone demo, which can be run without making any modifications. Use some dummy datasource for any controls, which will require one.

If it will be difficult for you to isolate the problem in a standalone web page, you can provide a live URL. At any rate, I recommend you to read the following:

http://www.satzansatz.de/cssd/onhavinglayout.html

Regards,
Dimo
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

radgrid filter display problem....

14 Answers, 1 is accepted