| .class1 {text-decoration:underline;color:Red} |
| .class2 {font-weight:bold;font-size:20px} |
| .class3 {font-size:10px;color:Gray} |
| <telerik:RadEditor ID="RadEditor1" Runat="server"> |
| <Tools> |
| <telerik:EditorToolGroup> |
| <telerik:EditorTool Name="ApplyClass" /> |
| </telerik:EditorToolGroup> |
| </Tools> |
| <CssFiles> |
| <telerik:EditorCssFile Value="StyleSheet.css" /> |
| </CssFiles> |
| <CssClasses> |
| <telerik:EditorCssClass Name="" Value="" /> |
| <telerik:EditorCssClass Name="Class one" Value=".class1" /> |
| <telerik:EditorCssClass Name="Class two" Value=".class2" /> |
| </CssClasses> |
| </telerik:RadEditor> |
| <root> |
| <tools> |
| <tool name="FormatCodeBlock"/> |
| <tool name="ApplyClass"/> |
| </tools> |
| <classes> |
| <class name="Class one" value=".class1" /> |
| <class name="Class two" value=".class2" /> |
| </classes> |
| </root> |
| <style> |
| .FeatureTitle {text-align:center;} |
| .StandardText {text-align:center;} |
| .NewText {text-align:center;} |
| </style> |
<%@ Master Language="C#" AutoEventWireup="true" CodeFile="Main_Master.master.cs"
Inherits="Web_Master_Pages_Main_Page" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" >
<html>
<head id="Head1" runat="server">
<title>Focalpoint - Manager's Compensation Tool</title>
<link id="Link1" runat="server" />
</head>
<body style="margin: 0px; margin-left: 2px; background-color: Gainsboro;">
<form id="form1" runat="server">
<div>
<telerik:RadScriptManager ID="rsm" runat="server">
</telerik:RadScriptManager>
<table cellpadding="0" cellspacing="0">
<tr runat="server" id="WelcomeHeader" visible="false">
</tr>
<tr runat="server" id="MainHeader" visible="True">
<td style="width: 990px">
<table id="Table4" cellpadding="0" cellspacing="0" style="background-color: #96b2ca;
width: 990px;" border="0">
<tr>
<td style="height: 17px;" align="right">
<asp:Label ID="lblMainWelcome" runat="server" Font-Bold="true" Font-Size="12px" ForeColor="White"
Font-Names="Arial" Font-Italic="true"></asp:Label> |
</td>
</tr>
</table>
</td>
</tr>
<%--<tr runat="server" id="WelcomeSection" visible="False">
<td style="width: 990px">
<asp:ContentPlaceHolder ID="WelcomeContent" runat="server">
</asp:ContentPlaceHolder>
</td>
</tr>--%>
<tr runat="server" id="MainSection" visible="True">
<td style="width: 990px">
<table cellpadding="0" cellspacing="0" style="background-color: #F0F0F0;">
<tr>
<td>
<telerik:RadSplitter ID="RadSplitter1" Skin="WebBlue" runat="server" Width="990px"
Height="538px">
<telerik:RadPane ID="RadPane1" runat="server" Width="145px" BackColor="#F0F0F0">
<asp:UpdatePanel id="UpdatePanel1" runat ="server">
<ContentTemplate >
<table cellpadding="0" cellspacing="0" style="background-color: #F0F0F0;">
<tr>
<td style="width: 200px; background-color: #f0f0f0;">
<telerik:RadTreeView ID="MenuRadTreeView" SSL="true" runat="server" AutoPostBack="True"
OnNodeClick="MenuRadTreeView_NodeClick">
</telerik:RadTreeView>
</td>
</tr>
</table>
</ContentTemplate>
</asp:UpdatePanel>
</telerik:RadPane>
<telerik:RadSplitBar ID="RadSplitBar1" Width="450px" runat="server" CollapseMode="None" />
<telerik:RadPane ID="RadPane2" runat="server">
<asp:ContentPlaceHolder ID="MainContentPlaceHolder" runat="server">
</asp:ContentPlaceHolder>
</telerik:RadPane>
</telerik:RadSplitter>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="width: 990px">
<table id="Table3" style="height: 8px; background-color: #F0F0F0;" cellspacing="0"
cellpadding="0" width="990" border="0">
<tr>
<td style="background-color: white;">
<table id="Table1" style="height: 8px; background-color: #F0F0F0;" cellspacing="0"
cellpadding="0" width="990" border="0">
<tr align="left">
<td align="left" style="height: 20px;">
<asp:Image ID="LoadingImage" runat="server" ImageUrl="~/App_Images/images/saveTrpt.gif"
ImageAlign="texttop" Width="65" Height="13" />
<telerik:RadAjaxLoadingPanel ID="FooterAjaxLoadingPanel" runat="server">
<asp:Image ID="Image1" runat="server" AlternateText="Saving..." ImageUrl="~/App_Images/images/LoadingProgressBar.gif"
ImageAlign="Middle" />
</telerik:RadAjaxLoadingPanel>
</td>
<td align="left" style="height: 20px; padding-left: 10px;">
<asp:Label ID="SaveMessagelbl" runat="server" SkinID="GreenviewSkinLabel" Font-Bold="True"
Font-Size="11px" Style="font-family: Arial;" Width="660px" /></td>
<td align="right" bgcolor="whitesmoke" colspan="2" valign="top">
<asp:Image ID="Image2" runat="server" ImageUrl="~/App_Images/images/LaserBeam.gif" /></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
Content page:
<%@ Page Language="C#" MasterPageFile="~/Web_Master_Pages/Main_Master.master" AutoEventWireup="true" CodeFile="xmlservices.aspx.cs" Inherits="Web_Pages_Dev_xml_xmlservices" Title="" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContentPlaceHolder" Runat="Server">
<script type="text/javascript" src="../../Web_Javascript/Common.js">
</script>
<telerik:RadAjaxManager ID="RadAjaxManager1" ClientEvents-OnRequestStart="xmlservicesconditionalPostback" runat="server" >
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="PanelXmlservices">
<UpdatedControls >
<telerik:AjaxUpdatedControl ControlID="PanelXmlservices" />
<telerik:AjaxUpdatedControl ControlID="MenuRadTreeView" />
<telerik:AjaxUpdatedControl ControlID="SaveMessagelbl" />
<telerik:AjaxUpdatedControl ControlID="LoadingImage" LoadingPanelID="FooterAjaxLoadingPanel" />
</UpdatedControls >
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>
<div align="left" style="background-color:White; height:535px;">
<asp:Panel ID="PanelXmlservices" runat="server" BackColor="white">
<table cellpadding="0" align="left" cellspacing="0" border="0" width="100%" style="background-color:white;">
<tr>
<td style="width: 800px;padding-left:20px;padding-top:20px;">
<div align="center" >
<asp:Panel ID="excelPanel" runat="server" Width="100%" >
<fieldset id ="fldexcel" runat ="server" style=" border-right: dodgerblue 1px solid; border-top: dodgerblue 1px solid; border-left: dodgerblue 1px solid; border-bottom: dodgerblue 1px solid; background-color: #ffffff; text-align: center;padding-Left:10px;">
<legend style="font-family:Arial; font-weight:bold; font-size:small; color: #000000;">
Load Spread Sheet</legend>
<table style="width: 781px">
<tr><td align="left">
<asp:Label ID="ccc" runat="server" Text="Template" Font-Names="Arial" Font-Size="Small"></asp:Label></td>
<td align="left" >
<asp:DropDownList ID="drpTemplate" runat="server" Width="150px" SkinID="DropDownSkin" AutoPostBack="True" OnSelectedIndexChanged="drpTemplate_SelectedIndexChanged">
</asp:DropDownList></td>
</tr>
<tr>
<td style="height: 28px" align="left">
<asp:Label ID="lblselectfile" runat="server" Font-Names="Arial" Text="Excel File"
Font-Size="Small"></asp:Label>
</td>
</tr>
<tr>
<td style="height: 28px" align="left">
<asp:Label ID="lblSheet" runat="server" Font-Names="Arial" Text="Sheet Name" Visible="true"
Font-Size="Small"></asp:Label></td>
<td style="height: 28px;" align="left">
<asp:TextBox ID="TxtSheetName" runat="server" Width="145px" Visible="true" ></asp:TextBox>
</td>
</tr>
</table>
<br />
<table>
<tr>
</tr>
<tr>
<td colspan="3">
<asp:Label ID="lblLocationpath" runat="server" Visible="false" Text="Label"></asp:Label>
<asp:Label ID="lblemsg" runat="server" Font-Bold="True" Font-Size="Smaller" ForeColor="Red" Font-Names="Arial"></asp:Label></td>
</tr>
</table>
</fieldset>
<br />
<br />
<table cellpadding="0" cellspacing="0" >
<tr >
<td>
<fieldset id ="fldexcelxml" runat ="server" style=" border-right: dodgerblue 1px solid; border-top: dodgerblue 1px solid; border-left: dodgerblue 1px solid; border-bottom: dodgerblue 1px solid; background-color: #ffffff; text-align: center;">
<legend style="font-family:Arial; font-weight:bold; font-size:small; color: #000000;">
Validate Spread Sheet</legend>
<br />
<telerik:RadGrid ID="Grdxmlvalidate" ShowFooter="True" EnableEmbeddedSkins ="false" runat="server" AllowPaging="true" PageSize= "5"
GridLines="None" AutoGenerateColumns="False" HeaderStyle-HorizontalAlign="Center"
FooterStyle-Font-Bold="true" FooterStyle-HorizontalAlign="left" HeaderStyle-Height="15px" EditItemStyle-Width="98%" OnPreRender="Grdxmlvalidate_PreRender" OnItemCommand="Grdxmlvalidate_ItemCommand" OnNeedDataSource="Grdxmlvalidate_NeedDataSource">
<MasterTableView EditMode="InPlace" DataKeyNames="xmlnum" Width="100%">
<Columns>
<telerik:GridTemplateColumn HeaderText="Sheet Name" UniqueName="TemplateColumn7" >
<ItemTemplate>
<asp:Label ID="lblsheetname" runat="server" Text='<%# Eval("sheetname") %>' Width="150px">
</asp:Label>
</ItemTemplate>
<HeaderStyle Width="150px" />
<ItemStyle HorizontalAlign ="left" />
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Schema" UniqueName="TemplateColumn7" Visible="false">
<ItemTemplate>
<asp:Label ID="lblschemaname" runat="server" Text='<%# Eval("xmlschema") %>'>
</asp:Label>
</ItemTemplate>
<HeaderStyle Width="120px" />
</telerik:GridTemplateColumn>
</Columns>
<EditFormSettings>
<EditColumn UniqueName="EditCommandColumn1">
</EditColumn>
</EditFormSettings>
<ExpandCollapseColumn Visible="False">
<HeaderStyle Width="19px" />
</ExpandCollapseColumn>
<RowIndicatorColumn Visible="False">
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<PagerStyle Mode="NextPrev" />
<ItemStyle Font-Bold ="true" Font-Names ="Arial" Font-Size ="11px" />
</MasterTableView>
<ClientSettings>
<Selecting AllowRowSelect="True" />
</ClientSettings>
<HeaderStyle BackColor="#92B4E1" Height="15px" HorizontalAlign="Center" />
<FooterStyle Font-Bold="True" HorizontalAlign="Left" />
<EditItemStyle Width="98%" />
</telerik:RadGrid><br />
<asp:Button ID="btnvalidate" runat="server" Text="Validate" Enabled="false" OnClick="btnvalidate_Click" Font-Size="Smaller" />
</fieldset>
</td>
</tr></table>
<table>
<tr>
<td style="width: 443px">
<asp:GridView ID="GridViewerr" AutoGenerateColumns="false" runat="server" BackColor="White" Width="433px" >
<Columns>
<asp:TemplateField HeaderText="xmlnum" Visible="False">
<ItemTemplate>
<asp:Label ID="lblxmlnum" runat="server" Text='<%# Eval("xmlnum") %>'>
</asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Possible errorneous columns">
<ItemTemplate>
<asp:Label ID="lblxmlerr" runat="server" Text='<%# Eval("valerr") %>'>
</asp:Label>
</ItemTemplate>
<HeaderStyle Font-Bold="True" Font-Names="arial" Font-Size="Smaller" ForeColor="White" />
</asp:TemplateField>
</Columns>
<HeaderStyle BackColor="#2C8FC8" />
</asp:GridView>
</td>
</tr>
</table>
<asp:Label ID="lblerrdatatype" runat="server" SkinID="RedviewSkinLabel"></asp:Label><br />
</asp:Panel>
</div>
</td>
</tr>
</table>
</asp:Panel>
</div>
</asp:Content>
| [OperationContract] |
| public ResultData GetDataAndCount(int startRowIndex, int maximumRows, string sortExpression, string filterExpression) |
| { |
| GridBindingData data = RadGrid.GetBindingData("Waivenet.DataClassesDataContext", "productAttrib", startRowIndex, maximumRows, sortExpression, filterExpression); |
| ResultData result = new ResultData(); |
| //var products = DataClassesDataContext.uspGetProductsByCategory(SessionWrapper.userID); |
| //data.Data = DataClassesDataContext.uspGetProductsByCategory(SessionWrapper.userID); |
| result.Data = data.Data.OfType<DataClassesDataContext.uspGetProductsByCategory(SessionWrapper.userID)>().Select(p => new Product() |
| { |
| productID = p.productID, |
| productCode = p.productCode, |
| name = p.name, |
| description = p.description, |
| quantType = p.quantType, |
| sellPrice = p.sellPrice, |
| uom = p.uom, |
| imageThumb = p.imageThumb, |
| categoryID = p.categoryID |
| }).ToList(); |
| result.Count = data.Count; |
| Debug.WriteLine("row index: " + startRowIndex + ", max rows:" + maximumRows + ", sort expression: " + sortExpression + ", filter expression: " + filterExpression); |
| return result; |
| } |
| <table cellpadding="2" cellspacing="2" border="0"> | |
| <tr> | |
| <td width="1"><asp:Image runat="server" ImageUrl="~/_assets/images/Filter.gif" /></td> | |
| <td>Show Filtering Options: </td> | |
| <td> | |
| <input type="radio" name="<%=this.Grid.ClientID%>ButtonGroup" onclick="showFilterItem('<%=this.Grid.ClientID%>')" /> | |
| <label for="<%=this.Grid.ClientID%>ButtonGroup">Yes</label> | |
| <input type="radio" name="<%=this.Grid.ClientID%>ButtonGroup" checked="true" onclick="hideFilterItem('<%=this.Grid.ClientID%>')"/> | |
| <label for="<%=this.Grid.ClientID%>ButtonGroup">No</label> | |
| </td> | |
| </tr> | |
| </table> |
| protected void Page_Load(object sender, EventArgs e) | |
| { | |
| InitControl(); | |
| } | |
| protected void InitControl() | |
| { | |
| if (!Page.ClientScript.IsClientScriptBlockRegistered("CodeScript")) | |
| { | |
| string java = @"function showFilterItem(GridName) { | |
| var c = document.getElementsByName(GridName + 'ButtonGroup'); | |
| c.item(0).checked = true; | |
| $find(GridName).get_masterTableView().showFilterItem();} | |
| function hideFilterItem(GridName) { | |
| var c = document.getElementsByName(GridName + 'ButtonGroup'); | |
| c.item(1).checked = true; | |
| $find(GridName).get_masterTableView().hideFilterItem();} | |
| function GridCreated(sender, eventArgs) { | |
| hideFilterItem(sender.get_id());}"; | |
| Page.ClientScript.RegisterClientScriptBlock(GetType(), "CodeScript", java, true); | |
| Grid.ClientSettings.ClientEvents.OnGridCreated = "GridCreated"; | |
| } | |
| //Grid.ClientSettings.ClientEvents.OnDataBound = "hideFilterItem('" + RadGridClientId + "')"; | |
| } | |
| public string RadGridId { get; set; } | |
| RadGrid _Grid; | |
| protected RadGrid Grid | |
| { | |
| get | |
| { | |
| if (_Grid == null) | |
| { | |
| //_Grid = (RadGrid)((Novelis.MetalProcurement.Web.site)Page.Master).FindControl(this.Parent, RadGridId); | |
| _Grid = this.Parent.FindControlRecursive(this.RadGridId) as RadGrid; | |
| _Grid.ItemCreated += new GridItemEventHandler(_Grid_ItemCreated); | |
| } | |
| return _Grid; | |
| } | |
| } | |
| void _Grid_ItemCreated(object sender, GridItemEventArgs e) | |
| { | |
| if (!IsPostBack && e.Item is GridFilteringItem) | |
| { | |
| //Grid.ClientSettings.ClientEvents.OnGridCreated = "hideFilterItem('" + RadGridClientId + "')"; | |
| //e.Item.Style["display"] = "none"; | |
| } | |
| } | |
| public string RadGridClientId | |
| { | |
| get { return Grid.ClientID; } | |
| } | |
| public string RadioGroupName | |
| { | |
| get { return RadGridClientId + "ButtonGroup"; } | |
| } | |
| <telerik:RadPanelBar runat="server" ID="RadPanelBar1" Width="575px" ExpandMode="SingleExpandedItem"> | |
| <Items> | |
| <telerik:RadPanelItem runat="server" Text="Step 1: Select Product" Value="ProductSelector" Expanded="true" Selected="true"> | |
| <Items> | |
| <telerik:RadPanelItem runat="server"> | |
| <ItemTemplate> | |
| <uc:rgfilman ID="ucFilMan" runat="server" RadGridId="rgProducts" /> | |
| <telerik:RadGrid ID="rgProducts" SkinID="Selector" Width="575px" runat="server" OnNeedDataSource="rgProducts_NeedDataSource" OnSortCommand="rgProducts_SortCommand" AllowSorting="true" SortingSettings-SortedBackColor="Transparent" AllowFilteringByColumn="true" OnDataBound="rgProducts_DataBound"> | |
| <MasterTableView AutoGenerateColumns="false" DataKeyNames="Id" AllowMultiColumnSorting="true" AllowNaturalSort="true" ItemStyle-Wrap="false"> | |
| <Columns> | |
| <telerik:GridBoundColumn DataField="Id" UniqueName="Id" Visible="false"/> | |
| <telerik:GridBoundColumn HeaderText="Description" DataField="Name" UniqueName="Product" /> | |
| </Columns> | |
| </MasterTableView> | |
| <ClientSettings EnableRowHoverStyle="true" Selecting-AllowRowSelect="true"> | |
| <ClientEvents OnRowDblClick="__rowSelected" /> | |
| </ClientSettings> | |
| </telerik:RadGrid> | |
| </ItemTemplate> | |
| </telerik:RadPanelItem> | |
| </Items> | |
| </telerik:RadPanelItem> | |
| </Items> | |
| </telerik:RadPanelBar> | |