Questions on UI for ASP.NET AJAX Forum

3 answers

195 views

Disabled Days with Range Selection and Multiple Calendars

Howdy,

I can't seem to get the disabled days function to be working after I combined it with the Data Selector Range Demo (http://demos.telerik.com/aspnet-ajax/calendar/examples/functionality/rangeselection/defaultcs.aspx)

DefaultVB.aspx

<%@ Page CodeFile="DefaultVB.aspx.vb" Language="vb" AutoEventWireup="false"  Inherits="testlayouts_samples_rangeselection_DefaultVB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

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

<head>

<title>ASP.NET Calendar Demo - Range Selection</title>

</head>

<body>

<form id="form1" runat="server">

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

<telerik:RadSkinManager ID="QsfSkinManager" runat="server" ShowChooser="true" />

<telerik:RadFormDecorator ID="QsfFromDecorator" runat="server" DecoratedControls="All" EnableRoundedCorners="false" />

<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">

<script type="text/javascript">

// necessary to disable the weekends on client-side navigation

function OnDayRender(calendarInstance, args) {

// convert the date-triplet to a javascript date

// we need Date.getDay() method to determine

// which days should be disabled (e.g. every Saturday (day = 6) and Sunday (day = 0))

var jsDate = new Date(args.get_date()[0], args.get_date()[1] - 1, args.get_date()[2]);

if (jsDate.getDay() == 0 || jsDate.getDay() == 6) {

var otherMonthCssClass = "rcOutOfRange";

args.get_cell().className = otherMonthCssClass;

// replace the default cell content (anchor tag) with a span element

// that contains the processed calendar day number -- necessary for the calendar skinning mechanism

args.get_cell().innerHTML = "<span>" + args.get_date()[2] + "</span>";

// disable selection and hover effect for the cell

args.get_cell().DayId = "";

}

</script>

<telerik:RadAjaxLoadingPanel runat="server" ID="RadAjaxLoadingPanel1">

</telerik:RadAjaxLoadingPanel>

</telerik:RadCodeBlock>

<h3 class="qsfSubtitle">Multi Month View with enabled AutoPostBack</h3>

<table>

<tr>

<td colspan="2">

<label for="RaddatePicker1">Start Date: </label>

<telerik:RadDatePicker runat="server" ID="RadDatePicker1">

</telerik:RadDatePicker>

<label for="RadDatePicker2">End Date: </label>

<telerik:RadDatePicker runat="server" ID="RadDatePicker2">

</telerik:RadDatePicker>

<asp:Button runat="server" ID="Button1" Text="Set range" OnClick="Button1_Click">

</asp:Button>

</td>

</tr>

</table>

<br />

<telerik:RadCalendar runat="server" ID="RadCalendar2" AutoPostBack="true" MultiViewColumns="2"

MultiViewRows="1" RangeSelectionMode="ConsecutiveClicks" EnableViewSelector="true" OnDayRender="Calendar_OnDayRender">

</telerik:RadCalendar>

<br />

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

DefaultLoadingPanelID="RadAjaxLoadingPanel2">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="RadDatePicker1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadCalendar2" UpdatePanelCssClass="" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="RadDatePicker2">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadCalendar2" UpdatePanelCssClass="" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="Button1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadCalendar2" UpdatePanelCssClass="" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="RadCalendar2">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadDatePicker1" UpdatePanelCssClass="" />

<telerik:AjaxUpdatedControl ControlID="RadDatePicker2" UpdatePanelCssClass="" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel2" runat="server" Skin="Default">

</telerik:RadAjaxLoadingPanel>

</form>

</body>

</html>

DefaultVB.aspx.vb

Imports Telerik.Web.UI

Partial Class testlayouts_samples_rangeselection_DefaultVB

Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

' necessary not to repeat the special days on postback

If Not Page.IsPostBack Then

RadDatePicker1.Calendar.SpecialDays.Clear()

End If

End Sub

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs)

If RadDatePicker1.SelectedDate.HasValue AndAlso RadDatePicker2.SelectedDate.HasValue Then

RadCalendar2.RangeSelectionStartDate = RadDatePicker1.SelectedDate.Value

RadCalendar2.RangeSelectionEndDate = RadDatePicker2.SelectedDate.Value

Else

'RadAjaxpanel1.Alert("To set range of dates in RadCalendar you need to choose both Start and End date")

RadAjaxManager1.Alert("To set range of dates in RadCalendar you need to choose both Start and End date")

End If

End Sub

Protected Overrides Sub OnPreRender(ByVal e As EventArgs)

MyBase.OnPreRender(e)

Dim calendarMinDate As New DateTime(1980, 1, 1)

Dim calendarMaxDate As New DateTime(2099, 12, 30)

If RadCalendar2.RangeSelectionStartDate <> calendarMinDate AndAlso RadCalendar2.RangeSelectionEndDate <> calendarMaxDate Then

RadDatePicker1.SelectedDate = RadCalendar2.RangeSelectionStartDate

RadDatePicker2.SelectedDate = RadCalendar2.RangeSelectionEndDate

Else

RadDatePicker1.Clear()

RadDatePicker2.Clear()

End If

End Sub

' necessary to disable the weekend days on first page load

Protected Sub Calendar_OnDayRender(ByVal sender As Object, ByVal e As Telerik.Web.UI.Calendar.DayRenderEventArgs)

' modify the cell rendered content for the days we want to be disabled (e.g. every Saturday and Sunday)

If (e.Day.Date.DayOfWeek = DayOfWeek.Saturday Or e.Day.Date.DayOfWeek = DayOfWeek.Sunday) Then

' if you are using the skin bundled as a webresource("Default"), the Skin property returns empty string

Dim calendarSkin = RadDatePicker1.Calendar.Skin

If (calendarSkin = "") Then

calendarSkin = "Default"

End If

Dim otherMonthCssClass As String = "rcOutOfRange"

' clear the default cell content (anchor tag) as we need to disable the hover effect for this cell

e.Cell.Text = ""

e.Cell.CssClass = otherMonthCssClass ' set new CssClass for the disabled calendar day cells (e.g. look like other month days here)

' render a span element with the processed calendar day number instead of the removed anchor -- necessary for the calendar skinning mechanism

Dim label As Label = New Label

label.Text = e.Day.Date.Day.ToString

e.Cell.Controls.Add(label)

' disable the selection for the specific day

Dim calendarDay As RadCalendarDay = New RadCalendarDay

calendarDay.Date = e.Day.Date

calendarDay.IsSelectable = False

calendarDay.ItemStyle.CssClass = otherMonthCssClass

RadDatePicker1.Calendar.SpecialDays.Add(calendarDay)

End If

End Sub

End Class

Calendar

answered on 12 Feb 2014

3 answers

440 views

ASP chart in RadEditor giving "PDF corrupted" error when exported to PDF

I have ASP chart which gets populated dynamically & i'm able to put it inside RadEditor but when i try to export it to PDF, the PDF viewer is throwing "Format error: not a pdf or corrupted" error.

Editor

answered on 12 Feb 2014

2 answers

79 views

Need Scrollbars enabled while RadGrid is disabled

Is there any way to have my vertical scrollbar enabled when my grid is disabled? I have the condition where a grid is disabled but need the scrollbar to be enabled so users can scroll thru the items.

Grid

answered on 12 Feb 2014

4 answers

119 views

[Solved] ContextMenu on Child Grid with RadMultiPage

I am trying to get a RadContextMenu to fire on individual child grids and I'm running into roadblocks. I have followed the demo and I have the RadContextMenu working on individual grids with no problem, but when I add children I am unable to fire the context menu. When applying the <ClientEvents OnRowContextMenu="RowContextMenu" /> to any grid (parent or child) I get a "Object doesn't support this property or method. " for menu.show(evt);

<telerik:RadCodeBlock runat="server" ID="RadCodeBlock1">

<script type="text/javascript">

function RowContextMenu(sender, eventArgs) {

var menu = $find("<%=RadGrid1.ClientID %>");

var evt = eventArgs.get_domEvent();

if (evt.target.tagName == "INPUT" || evt.target.tagName == "A") {

return;

}

var index = eventArgs.get_itemIndexHierarchical();

document.getElementById("radGridClickedRowIndex").value = index;

sender.get_masterTableView().selectItem(sender.get_masterTableView().get_dataItems()[index].get_element(), true);

menu.show(evt);

evt.cancelBubble = true;

evt.returnValue = false;

if (evt.stopPropagation) {

evt.stopPropagation();

evt.preventDefault();

}

</script>

</telerik:RadCodeBlock>

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

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="RadGrid1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1"></telerik:AjaxUpdatedControl>

<telerik:AjaxUpdatedControl ControlID="RadMenu1"></telerik:AjaxUpdatedControl>

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="RadMenu1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1"></telerik:AjaxUpdatedControl>

<telerik:AjaxUpdatedControl ControlID="RadMenu1"></telerik:AjaxUpdatedControl>

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server">

</telerik:RadAjaxLoadingPanel>

<input type="hidden" id="radGridClickedRowIndex" name="radGridClickedRowIndex" />

<telerik:RadGrid ID="RadGrid1" OnPreRender="RadGrid1_PreRender" DataSourceID="SqlDataSource1"

runat="server" AutoGenerateColumns="False" OnItemCommand="RadGrid1_ItemCommand">

<ClientSettings>

<ClientEvents OnRowContextMenu="RowContextMenu" />

<Selecting AllowRowSelect="true" />

</ClientSettings>

<MasterTableView DataSourceID="SqlDataSource1" DataKeyNames="JobID">

<NestedViewTemplate>

<asp:Panel runat="server" ID="InnerContainer" CssClass="viewWrap" Visible="false">

<telerik:RadTabStrip runat="server" ID="TabStrip1" MultiPageID="Multipage1" Skin="WebBlue"

Align="justify" AutoPostBack="true">

<Tabs>

<%--RadTabs--%>

</Tabs>

</telerik:RadTabStrip>

<telerik:RadMultiPage runat="server" ID="Multipage1" RenderSelectedPageOnly="false" SelectedIndex="0">

<telerik:RadPageView runat="server" ID="PageView1">

<telerik:RadGrid runat="server" ID="OrdersGrid" DataSourceID="SqlDataSource2">

<ClientSettings Selecting-AllowRowSelect="true" />

<MasterTableView ShowHeader="true" AutoGenerateColumns="False" ClientDataKeyNames="Employee_Identifier" HierarchyDefaultExpanded="true">

<Columns>

<%--column info--%>

</Columns>

</MasterTableView>

</telerik:RadGrid>

<asp:SqlDataSource ID="SqlDataSource2" runat="server" />

</telerik:RadPageView>

</telerik:RadMultiPage>

</asp:Panel>

<telerik:RadTabStrip runat="server" ID="TabStrip2" Skin="WebBlue" Align="Justify" Width="900px"

Orientation="HorizontalBottom">

<Tabs>

<telerik:RadTab runat="server" Text="Tab 1">

</telerik:RadTab>

<telerik:RadTab runat="server" Text="Tab 2">

</telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

</NestedViewTemplate>

<Columns>

<%--Column info--%>

</Columns>

</MasterTableView>

</telerik:RadGrid>

<asp:SqlDataSource ID="SqlDataSource1" ProviderName="System.Data.SqlClient" runat="server"></asp:SqlDataSource>

</div>

<telerik:RadContextMenu ID="RadMenu1" runat="server" OnItemClick="RadMenu1_ItemClick"

EnableRoundedCorners="true" EnableShadows="true">

<Items>

<telerik:RadMenuItem Text="Menu Item Text">

</telerik:RadMenuItem>

</Items>

</telerik:RadContextMenu>

Is there a demo out there showing how to perform a RadContextMenu on a child RadGrid when used in conjunction with RadMultiPage and RadTabStrip?

Grid

answered on 12 Feb 2014

7 answers

114 views

Edit Window Template in Window manager

I added a Windows Manager so that I could close windows from an external JavaScript file which works fine.

My issue is that I still have work to do with the contents of the individual Window Templates but after I add the windows to the Windows Manager I can't see the windows in Visual Studio anymore, How do I edit the Window Templates after adding them to the window manager since I don't see an "Edit Template menu item in Windows Manager?

Window

answered on 12 Feb 2014

1 answer

133 views

Detect Collapse/Expand Client-Side Event

I am using a RadTreeList control. How can I detect when a user has collapsed or expanded a node on the client-side before the post-back?

Thanks.

Chris J.

TreeList

answered on 12 Feb 2014

3 answers

156 views

disable RadWindow

I am using the example DBContentProvider-Vb.
How do i disable RadWindow to open when i want to download a images, pdf, ecxel and other files?
I only want to have the download dialog....

FileExplorer

answered on 12 Feb 2014

1 answer

83 views

Rad window in side using Rad button how to set the validation in client side

Window

answered on 12 Feb 2014

0 answers

81 views

Icon of paging images are exporting in excel

Hi All ,
1. I have two detail Tables in my RadGrid . when I am exporting it in excel the bad image of paging icons are also getting exported in excel.
2.   with this code when I am exporting the excel file records are hidden by default (have records but rows are not visible by default we have to increase the row height every time to see the records) please see the attached image

these bad images are exporting only for those child grids which have data in it. please let me know what I am doing wrong. my code behind code is

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPages/.master" AutoEventWireup="true"
CodeFile="Sample.aspx.cs" Inherits="Sample" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder_Content" runat="Server">
<script type="text/javascript">


//To refresh domains and roles grid
function RefreshSampleRadGrid() {
var radMgr = $find('<%=RadAjaxManager.GetCurrent(Page).ClientID %>');
radMgr.ajaxRequest("SampleRadGrid");
return false;
}

function DisableAjax(eventTarget, eventArgument) {

$find('<%=RadAjaxManager.GetCurrent(Page).ClientID %>').__doPostBack(eventTarget, eventArgument);
}
</script>
<telerik:RadSplitter ID="SampleRadSplitter" runat="server">
<telerik:RadPane ID="TopRadPane" runat="server" SkinID="TopRadPane">
</telerik:RadPane>
<telerik:RadSplitBar ID="ProfileRadSplitBar" runat="server" />
<telerik:RadPane ID="SampleRadPane" runat="server" SkinID="BottomRadPane">
<telerik:RadDockLayout ID="SampleRadDockLayout" runat="server" OnLoadDockLayout="SampleRadDockLayout_LoadDockLayout">
<asp:Label ID="MessageLabel" runat="server" Visible="false" SkinID="MessageLabel"></asp:Label>
<telerik:RadDockZone BorderStyle="None" ID="SampleRadDockZone" runat="server">
<telerik:RadDock ID="SampleRadDock" runat="server" OnCommand="RadDock_Command">
<TitlebarTemplate>
<table class="RadDockTitlebarTemplateTableClass">
<tr>
<td>
<asp:Label ID="ConfigurationFileLabel" runat="server" Text="Configuration File"
SkinID="RadDockTitleLabel" />
</td>
<td>
<asp:LinkButton ID="RemoveLinkButton" runat="server" Text="Clear Selected" SkinID="SmallLinkButton"
OnClick="RemoveLinkButton_Click"></asp:LinkButton>
</td>
</tr>
</table>
</TitlebarTemplate>
<ContentTemplate>
<div class="RadGridHorizontalScroll">
<telerik:RadGrid ID="SampleRadGrid" OnPreRender="SampleRadGrid_PreRender" OnNeedDataSource="SampleRadGrid_NeedDataSource"
runat="server" Width="99.4%" OnDetailTableDataBind="SampleRadGrid_DetailTableDataBind"
OnItemDataBound="SampleRadGrid_ItemDataBound" OnItemCreated="SampleRadGrid_ItemCreated"
OnPageIndexChanged="SampleRadGrid_PageIndexChanged">
<ClientSettings>
<Resizing AllowColumnResize="true" EnableRealTimeResize="true" ResizeGridOnColumnResize="true"
ClipCellContentOnResize="true" />
</ClientSettings>
<MasterTableView DataKeyNames="userID,userName" HierarchyLoadMode="Client"
HierarchyDefaultExpanded="false" TableLayout="Fixed" CommandItemDisplay="Top">
<CommandItemTemplate>
<table width="100%">
<tr>
<td></td>
<td class="ExportButtonIconSaperator">
<asp:ImageButton ID="ExportToExcelImageButton" SkinID="ExportToExcelImageButtonSkin"
runat="server" OnClick="ExportToExcelImageButton_Click" />
</td>
</tr>
</table>
</CommandItemTemplate>

<Columns>
<telerik:GridBoundColumn SortExpression="userName" HeaderText="user" HeaderButtonType="TextButton"
DataField="userName">
<%-- Defect# 12711--%>
</telerik:GridBoundColumn>
</Columns>
<DetailTables>
<telerik:GridTableView DataKeyNames="ConfigurationID,userID" GridLines="None" HierarchyLoadMode="Client" HierarchyDefaultExpanded="true">
<PagerStyle Visible="false" />
<ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="userID" MasterKeyField="userID" />
</ParentTableRelation>
<Columns>
<telerik:GridBoundColumn DataField="ConfigurationDesc" HeaderText="Configuration Name"
UniqueName="ConfigurationDesc">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="user" HeaderText="user" UniqueName="user">
<%-- Defect# 12711--%>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="FixedColumn" HeaderText="Fixed Column" UniqueName="FixedColumn">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="meter" HeaderText="meter" UniqueName="meter">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Type" HeaderText="Code"
UniqueName="DisbursementType">
</telerik:GridBoundColumn>
</Columns>
<DetailTables>
<telerik:GridTableView DataKeyNames="ID,userID" Width="100%" GridLines="None"
HierarchyLoadMode="Client" AllowCustomPaging="true">
<ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="userID" MasterKeyField="userID" />
</ParentTableRelation>
<Columns>
<telerik:GridTemplateColumn UniqueName="SelectItemCheckBoxColumn" Resizable="false" Reorderable="false">
<ItemTemplate>
<asp:CheckBox ID="SelectItemCheckBox" runat="server" onclick="return CheckItem(this);" />
</ItemTemplate>
<HeaderTemplate>
<asp:CheckBox ID="SelectHeaderCheckBox" runat="server" onclick="CheckAll(this);" />
</HeaderTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Action" UniqueName="TemplateColumn" Resizable="false" Reorderable="false">
<ItemTemplate>
<asp:HyperLink ID="EditHyperLink" runat="server" Text="Edit" SkinID="SmallHyperLink"></asp:HyperLink>
</ItemTemplate>
<HeaderStyle Width="5%" />
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="UniqueNumber" HeaderText="Unique Number"
UniqueName="UniqueNumber" SortExpression="UniqueNumber">
<HeaderStyle Width="10%" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Number" HeaderText="Number" UniqueName="Number"
SortExpression="Number">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="com" HeaderText="com" UniqueName="com"
SortExpression="com">
<HeaderStyle Width="10%" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Date/Time" HeaderText="Date/Time" UniqueName="Date/Time"
SortExpression="Date/Time">
<HeaderStyle Width="10%" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="com" HeaderText=" com" UniqueName="com" SortExpression="com">
<%-- Defect# 12711--%>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Pump" HeaderText=" Dispenser" UniqueName="Pump" SortExpression="Pump">
<%-- Defect# 12711--%>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Type" HeaderText=" Type" UniqueName="Type"
SortExpression="Type">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Quantity" HeaderText="Quantity" UniqueName="Quantity"
SortExpression="Quantity">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Cost" HeaderText="Cost" UniqueName="Cost" SortExpression="Cost">
<telerik:GridBoundColumn DataField="ErrorDescription" HeaderText="Error Description"
UniqueName="ErrorDescription" SortExpression="ErrorDescription">
<HeaderStyle Width="20%" />
</telerik:GridBoundColumn>
</Columns>
</telerik:GridTableView>
</DetailTables>
</telerik:GridTableView>
</DetailTables>
</MasterTableView>
</telerik:RadGrid>
</div>
</ContentTemplate>
<Commands>
<telerik:DockCommand Text="Save Position" AutoPostBack="true" />
<telerik:DockExpandCollapseCommand />
</Commands>
</telerik:RadDock>
</telerik:RadDockZone>
</telerik:RadDockLayout>
<telerik:RadWindowManager ID="RadWindowManager" runat="server">
<Windows>
<telerik:RadWindow ID="EditDialog" Title=" Transactions"
Left="150px" runat="server" />
<telerik:RadWindow ID="ErrorDialog" Title="Process Errors" Left="150px" runat="server"></telerik:RadWindow>
</Windows>
</telerik:RadWindowManager>
</telerik:RadPane>
</telerik:RadSplitter>
</asp:Content>

public partial class Sample
{
#region Events

protected void Page_Load(object sender, EventArgs e)
{
TitleSetHelper.Instance.SetHeaderText(sampleRadGrid);
ValidateCredentials(FuelPermission.Check(SecurityAttribute.FuelPerm.FuelTransactionImport), false);
RadAjaxManager radAjaxManager = Master.FindControl("RadAjaxManagerFuel") as RadAjaxManager;
if (radAjaxManager != null)
{
radAjaxManager.AjaxSettings.AddAjaxSetting(radAjaxManager, sampleRadGrid);
radAjaxManager.AjaxSettings.AddAjaxSetting(sampleRadGrid, sampleRadGrid);
radAjaxManager.AjaxSettings.AddAjaxSetting(radAjaxManager, RemoveLinkButton);
radAjaxManager.AjaxSettings.AddAjaxSetting(sampleRadGrid, RemoveLinkButton);
radAjaxManager.AjaxSettings.AddAjaxSetting(sampleRadGrid, MessageLabel);
radAjaxManager.AjaxSettings.AddAjaxSetting(RemoveLinkButton, MessageLabel);
}

}

protected void Page_Init(object sender, EventArgs e)
{
AddCustomPager(sampleRadGrid);
GridTableView gridTableView = sampleRadGrid.MasterTableView.DetailTables[0].DetailTables[0];
if (gridTableView != null)
{
gridTableView.AllowPaging = true;
gridTableView.PagerStyle.AlwaysVisible = true;
}

}

protected void sampleRadGrid_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
{
try
{
userInfoList userInfoList = userInfoList.GetInfoList("user", (Int32)userStatus.Active);
DataTable dataTable = new DataTable("userInfoListData");
dataTable.Columns.Add(new DataColumn("userID", Type.GetType("System.Int32")));
dataTable.Columns.Add(new DataColumn("userName", Type.GetType("System.String")));

foreach (userInfo userInfo in userInfoList)
{
DataRow dataRow = dataTable.NewRow();
dataRow["userID"] = userInfo.userID;
dataRow["userName"] = userInfo.userName;
dataTable.Rows.Add(dataRow);
}
sampleRadGrid.DataSource = dataTable;
}
catch (Exception ex)
{
FasterExceptionHandler.Instance.HandleException(ex, ExceptionResources.userInfoListGet, MessageLabel, null);
}
if (Cacheobject[String.Format("GridPageIndex{0}", _guid)] != null)
sampleRadGrid.CurrentPageIndex = (Int32)Cacheobject[String.Format("GridPageIndex{0}", _guid)];
}

protected void sampleRadGrid_DetailTableDataBind(object source, Telerik.Web.UI.GridDetailTableDataBindEventArgs e)
{


Cacheobject.Remove(String.Format("IDList{0}", _guid));
//if (Cacheobject[String.Format("user{0}", _guid)] != null)
Cacheobject.Remove(String.Format("user{0}", _guid));
//if (Cacheobject[String.Format("GridPageIndex{0}", _guid)] != null)
Cacheobject.Remove(String.Format("GridPageIndex{0}", _guid));
List<Int32> transactionIDList = new List<Int32>();
Int32 userID = 0;
Int32 ConfigurationID = 0;
String userName = String.Empty;
GridDataItem dataItem = e.DetailTableView.ParentItem;
userID = Convert.ToInt32(dataItem.GetDataKeyValue("userID"));
AddCache(String.Format("user{0}", _guid), userID);
userName = Convert.ToString(dataItem.GetDataKeyValue("userName"));
ConfigurationID = Convert.ToInt32(dataItem.GetDataKeyValue("ConfigurationID"));
DataSet dataSet = new DataSet();

if (ConfigurationID == 0)
{
try
{
sampleRadGrid.VirtualItemCount = InfoList.GetTotalRecords(userID);
}

catch (Exception ex)
{
ExceptionHandler.Instance.HandleException(ex, ExceptionResources.InfoList, MessageLabel, null, "userID: " + userID);
}



DataTable dataTable = new DataTable("Configuration");
dataTable.Columns.Add(new DataColumn("ConfigurationID", System.Type.GetType("System.Int32")));
dataTable.Columns.Add(new DataColumn("userID", System.Type.GetType("System.Int32")));
dataTable.Columns.Add(new DataColumn("ConfigurationDesc", System.Type.GetType("System.String")));
dataTable.Columns.Add(new DataColumn("user", System.Type.GetType("System.String")));
dataTable.Columns.Add(new DataColumn("FixedColumn", System.Type.GetType("System.String")));
dataTable.Columns.Add(new DataColumn("meter", System.Type.GetType("System.String")));
dataTable.Columns.Add(new DataColumn("Type", System.Type.GetType("System.String")));
ConfigurationInfo ConfigurationInfo = null;
try
{
ConfigurationInfo = ConfigurationInfo.GetInfo(null, userID);
}

catch (Exception ex)
{
FasterExceptionHandler.Instance.HandleException(ex, ExceptionResources.ConfigurationInfoGet, MessageLabel, null);
}

if (ConfigurationInfo != null)
{
DataRow row = dataTable.NewRow();
row["ConfigurationID"] = ConfigurationInfo.ConfigurationID;
row["userID"] = ConfigurationInfo.userID;
row["ConfigurationDesc"] = ConfigurationInfo.ConfigurationDesc;
row["user"] = userName;
row["FixedColumn"] = ConfigurationInfo.IsColumnFixed ? "Yes" : "No";
try
{
row["meter"] = ConfigurationInfo.DelimeterID == null ? String.Empty : STLImportConfigurationDelimeterInfo.GetInfo(Convert.ToInt32(ConfigurationInfo.DelimeterID)).DelimeterDesc;
}

catch (Exception ex)
{
FasterExceptionHandler.Instance.HandleException(ex, ExceptionResources.ImportConfigurationDelimeterGet, MessageLabel, null);
}
try
{
row["Type"] = ConfigurationInfo.DisbursementID == null ? String.Empty : STLDisbursementInfo.GetInfo(Convert.ToInt32(ConfigurationInfo.DisbursementID)).DisbursementDesc;
}
//Updated by CB for Feature# 2575
catch (Exception ex)
{
FasterExceptionHandler.Instance.HandleException(ex, ExceptionResources.STLDisbursementInfoGet, MessageLabel, null);
}
dataTable.Rows.Add(row);
}
dataSet.Merge(dataTable);

}
else
{
#region Processing Errors Grid

DataTable tempDataTable = new DataTable("tempDataTable");
tempDataTable.Columns.Add(new DataColumn("TransactionID", Type.GetType("System.Int32")));
tempDataTable.Columns.Add(new DataColumn("userID", Type.GetType("System.Int32")));
tempDataTable.Columns.Add(new DataColumn("TransactionNumber", Type.GetType("System.String")));
tempDataTable.Columns.Add(new DataColumn("AssetNumber", Type.GetType("System.String")));
tempDataTable.Columns.Add(new DataColumn("Organization", Type.GetType("System.String")));
tempDataTable.Columns.Add(new DataColumn("Date/Time", Type.GetType("System.String")));
tempDataTable.Columns.Add(new DataColumn("Site", Type.GetType("System.String")));
tempDataTable.Columns.Add(new DataColumn("Pump", Type.GetType("System.String")));
tempDataTable.Columns.Add(new DataColumn("FuelType", Type.GetType("System.String")));
tempDataTable.Columns.Add(new DataColumn("Quantity", Type.GetType("System.String")));
tempDataTable.Columns.Add(new DataColumn("ErrorDescription", Type.GetType("System.String")));
//To get sort expression.
System.Text.StringBuilder sortExpression = new System.Text.StringBuilder();
foreach (GridSortExpression gridSortExpression in sampleRadGrid.MasterTableView.SortExpressions)
{
sortExpression.Append(gridSortExpression.FieldName);
if (gridSortExpression.SortOrder == GridSortOrder.Descending)
sortExpression.Append(" Desc");
else
sortExpression.Append(" Asc");
sortExpression.Append(",");
}
try
{
if (Cacheobject[String.Format("DetailTablePageIndex{0}", _guid)] != null && Cacheobject[String.Format("IsPageIndexChanged{0}", _guid)] != null)
{
e.DetailTableView.CurrentPageIndex = (Int32)Cacheobject[String.Format("DetailTablePageIndex{0}", _guid)];
Cacheobject.Remove(String.Format("IsPageIndexChanged{0}", _guid));
}
if (Cacheobject[String.Format("PageSize{0}", _guid)] != null)
{
e.DetailTableView.PageSize = (Int32)Cacheobject[String.Format("PageSize{0}", _guid)];
Cacheobject.Remove(String.Format("PageSize{0}", _guid));
}
InfoList InfoList = InfoList.GetInfoList(userID, e.DetailTableView.CurrentPageIndex + 1, e.DetailTableView.PageSize, sortExpression.ToString());
_pageSize = e.DetailTableView.PageSize;
_sortExpression = sortExpression.ToString();
foreach (TempFuelTransactionInfo tempFuelTransaction in InfoList)
{
if (IDList.Count < e.DetailTableView.PageSize)
{
String site = String.Empty;
String pump = String.Empty;
String errorDescription = String.Empty;
String billCode = String.Empty;
DataRow Row = tempDataTable.NewRow();
Row["TransactionID"] = temp.ID;
Row["userID"] = tempFuelTransaction.userID;
Row["TransactionNumber"] = tempFuelTransaction.TransactionNumber;
Row["Organization"] = tempFuelTransaction.Organization;
if (!String.IsNullOrEmpty(tempFuelTransaction.TransactionDate))
Row["Date/Time"] = Convert.ToDateTime(tempFuelTransaction.TransactionDate).ToString("MM/dd/yyyy HH:mm:sss");
_transactionID = tempFuelTransaction.TransactionID;
Boolean isError = false;
String rejectedRecordBits = tempFuelTransaction.RejectedRecordsBitsString;

IDList.Add(tempFuelTransaction.TransactionID);
}
AddSlidingCache(String.Format("IDList{0}", _guid), transactionIDList);
AddSlidingCache(String.Format("GridPageIndex{0}", _guid), sampleRadGrid.CurrentPageIndex);
AddSlidingCache(String.Format("DetailTablePageIndex{0}", _guid), e.DetailTableView.CurrentPageIndex);
}

catch (Exception ex)
{
FasterExceptionHandler.Instance.HandleException(ex, ExceptionResources.TempFuelTransactionInfoGet, MessageLabel, null);
}
dataSet.Merge(tempDataTable);

#endregion
}
e.DetailTableView.DataSource = dataSet;
}

protected void sampleRadGrid_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
HyperLink editHyperLink = e.Item.FindControl("EditHyperLink") as HyperLink;
if (editHyperLink != null)
{
GridDataItem dataItem = e.Item as GridDataItem;
string checkSite = dataItem["Site"].Text;
//String formatting off of data item
//<Font color=red></font>
if (checkSite.Contains(@"<Font color=red>"))
checkSite = checkSite.Replace(@"<Font color=red>", "");
if (checkSite.Contains(@"</Font>"))
checkSite = checkSite.Replace(@"</Font>", "");
if (checkSite.Contains(_errorImagePath))
checkSite = checkSite.Replace(_errorImagePath, "");

}
}
}
protected void sampleRadGrid_PreRender(object sender, EventArgs e)
{
Boolean hasRecords = false;
if (sampleRadGrid.MasterTableView.Items.Count > 0)
{
foreach (GridDataItem dataItem in sampleRadGrid.MasterTableView.Items)
{

foreach (GridDataItem nestedDataItem in dataItem.ChildItem.NestedTableViews[0].Items)
{

if (!hasRecords && nestedDataItem.ChildItem.NestedTableViews[0].Items.Count > 0)
{
hasRecords = true;
break;
}
}
if (hasRecords)
break;

}
}
RemoveLinkButton.Enabled = hasRecords;

}

protected void RemoveLinkButton_Click(object sender, EventArgs e)
{
String cacheName = String.Format("TempTransactionID{0}", _guid);
if (Cacheobject[cacheName] != null)
{
Cacheobject.Remove(cacheName);
}
MessageLabel.Visible = false;
List<Int32> transactionIDList = new List<Int32>();
foreach (GridDataItem gridDataItem in sampleRadGrid.Items)
{
CheckBox processErrorcheckBox = gridDataItem.FindControl("SelectItemCheckBox") as CheckBox;
if (processErrorcheckBox != null && processErrorcheckBox.Checked)
{
Int32 ID = 0;
Int32.TryParse(Convert.ToString(gridDataItem.GetDataKeyValue("ID")), out ID);
transactionIDList.Add(ID);
}
}

}
protected void ExportToExcelImageButton_Click(object sender, EventArgs e)
{
ExportDataToFile();
ExportToExcel(sampleRadGrid, "sampleResults", false, String.Empty);
}
protected void Page_PreRender(object sender, System.EventArgs e)
{
GridItem commandItem = sampleRadGrid.MasterTableView.GetItems(GridItemType.CommandItem)[0];
ImageButton exportToExcelImageButton = commandItem.FindControl("ExportToExcelImageButton") as ImageButton;
Boolean isGridHasData = sampleRadGrid.Items.Count > 0;
if (exportToExcelImageButton != null)
{
exportToExcelImageButton.Enabled = isGridHasData;
if (exportToExcelImageButton.Enabled)
{
exportToExcelImageButton.Attributes.Add("onclick", String.Format("DisableAjax(\"{0}\", \"\"); return false;", exportToExcelImageButton.UniqueID));
exportToExcelImageButton.Style.Add(StringResources.CssCursorKey, StringResources.CssCursorValue);
}
}
}
private userFuelSiteInfo userFuelSiteGet(string checkSite, int userID)
{
userFuelSiteInfo userFuelSiteInfo = null;

try
{
userFuelSiteInfo = userFuelSiteInfo.GetInfo(checkSite, userID);
}
//Updated by CB for Feature# 2575
catch (Exception ex)
{
FasterExceptionHandler.Instance.HandleException(ex, ExceptionResources.userFuelSiteInfoGet, MessageLabel, null, "userID:" + userID.ToString() + "userFuelSite:" + checkSite);
}
return userFuelSiteInfo;
}

protected void sampleRadGrid_ItemCreated(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
if (Cacheobject[String.Format("user{0}", _guid)] != null && e.Item.OwnerTableView.HierarchyDefaultExpanded)
{
if (Convert.ToInt32(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["userID"]) == (Int32)Cacheobject[String.Format("user{0}", _guid)])
e.Item.OwnerTableView.HierarchyDefaultExpanded = true;
else
e.Item.OwnerTableView.HierarchyDefaultExpanded = false;
}
}
}

protected void sampleRadGrid_PageIndexChanged(object source, GridPageChangedEventArgs e)
{
e.Item.OwnerTableView.CurrentPageIndex = e.NewPageIndex;
AddSlidingCache(String.Format("GridPageIndex{0}", _guid), sampleRadGrid.CurrentPageIndex);
Cacheobject.Remove(String.Format("DetailTablePageIndex{0}", _guid));
}

#endregion

#region Class Functions
/// <summary>
/// Create Export Data
/// </summary>
private void ExportDataToFile()
{
sampleRadGrid.MasterTableView.ExpandCollapseColumn.Display = false;
sampleRadGrid.MasterTableView.HierarchyLoadMode = GridChildLoadMode.Client;
sampleRadGrid.MasterTableView.DetailTables[0].ExpandCollapseColumn.Display = false;
sampleRadGrid.MasterTableView.DetailTables[0].DetailTables[0].ExpandCollapseColumn.Display = false;
sampleRadGrid.MasterTableView.DetailTables[0].DetailTables[0].ShowFooter = false;
sampleRadGrid.MasterTableView.DetailTables[0].DetailTables[0].ShowGroupFooter= false;
sampleRadGrid.MasterTableView.DetailTables[0].DetailTables[0].PagerStyle.Visible = false;
sampleRadGrid.ExportSettings.IgnorePaging = true;
sampleRadGrid.MasterTableView.DetailTables[0].DetailTables[0].AllowPaging = false;
GridTemplateColumn templateColumn = sampleRadGrid.MasterTableView.DetailTables[0].DetailTables[0].Columns.FindByUniqueName("TemplateColumn") as GridTemplateColumn;
if (templateColumn != null)
templateColumn.Visible = false;
GridTemplateColumn selectItemCheckBoxColumn = sampleRadGrid.MasterTableView.DetailTables[0].DetailTables[0].Columns.FindByUniqueName("SelectItemCheckBoxColumn") as GridTemplateColumn;
if (selectItemCheckBoxColumn != null)
selectItemCheckBoxColumn.Visible = false;
}
protected void ExportToExcel(RadGrid searchRadGrid, String fileName, Boolean isActionColumn, String columnUniqueName)
{
if (isActionColumn)
searchRadGrid.MasterTableView.Columns.FindByUniqueName(columnUniqueName).Display = false;

if (searchRadGrid.MasterTableView.HasDetailTables)
{
foreach (GridTableView gridTableView in searchRadGrid.MasterTableView.DetailTables)
{
// Added by partner CB to Fix defect 15597
gridTableView.AllowPaging = false;
gridTableView.HierarchyDefaultExpanded = true;
}
}
searchRadGrid.ExcelExportCellFormatting += new OnExcelExportCellFormattingEventHandler(SearchRadGrid_ExcelExportCellFormatting);
searchRadGrid.ItemCreated += new GridItemEventHandler(RadGrid_ItemCreated);
searchRadGrid.ExportSettings.ExportOnlyData = true;
searchRadGrid.ExportSettings.IgnorePaging = true;
searchRadGrid.ExportSettings.OpenInNewWindow = true;
searchRadGrid.ExportSettings.FileName = fileName;
_isExport = true;
searchRadGrid.MasterTableView.ExportToExcel();
}
#endregion
}

Grid

asked on 12 Feb 2014

4 answers

149 views

[Solved] How to hide the dotted line above or below an item that's being dragged too

I am using the drag and drop feature on the grid to swap rows. The challenage is the dotted line that shows above or below the drop row is confusing to users. Is their a weay to hide the dotted line above or below an item that's being dragged too?

Thanks,
Todd.

Grid

answered on 12 Feb 2014