<telerik:RadComboBox ID="cboProvinciaT" runat="server" Width="200px" OnClientSelectedIndexChanging="LoadLocalidades" OnItemsRequested="cboProvinciaT_ItemsRequested" MarkFirstMatch="true" Skin="Sunset"></telerik:RadComboBox><telerik:RadComboBox ID="cboLocalidadT" runat="server" Width="200px" OnClientSelectedIndexChanging="LoadTiposVia" OnClientItemsRequested="ItemsLoaded" OnItemsRequested="cboLocalidadT_ItemsRequested" MarkFirstMatch="true" Skin="Sunset"></telerik:RadComboBox><telerik:RadComboBox ID="cboTipoViaT" runat="server" Width="80px" OnClientSelectedIndexChanged="LoadNombresVia" OnClientItemsRequested="ItemsLoaded" OnItemsRequested="cboTipoViaT_ItemsRequested" MarkFirstMatch="true" Skin="Sunset"></telerik:RadComboBox><telerik:RadComboBox ID="cboNombreVia" runat="server" OnClientItemsRequested="ItemsLoaded" OnItemsRequested="cboNombreVia_ItemsRequested" Filter="Contains" Skin="Sunset"></telerik:RadComboBox><script type="text/javascript"> var LocalidadesCombo; var TiposViaCombo; var NombresVia; function pageLoad() { LocalidadesCombo = $find("<%= cboLocalidadT.ClientID %>"); TiposViaCombo = $find("<%= cboTipoViaT.ClientID %>"); NombresVia = $find("<%= cboNombreVia.ClientID %>"); } function LoadLocalidades(sender, eventArgs) { var item = eventArgs.get_item(); LocalidadesCombo.set_text("Cargando..."); TiposViaCombo.clearSelection(); if (item.get_index() > 0) { LocalidadesCombo.requestItems(item.get_value(), false); LocalidadesCombo.clearSelection(); } else { LocalidadesCombo.set_text(" "); LocalidadesCombo.clearItems(); TiposViaCombo.set_text(" "); TiposViaCombo.clearItems(); } } function LoadTiposVia(sender, eventArgs) { var item = eventArgs.get_item(); TiposViaCombo.set_text("Cargando..."); TiposViaCombo.requestItems(item.get_value(), false); TiposViaCombo.clearSelection(); if (item.get_index() > 0) { TiposViaCombo.requestItems(item.get_value(), false); TiposViaCombo.clearSelection(); } else { TiposViaCombo.set_text(" "); TiposViaCombo.clearItems(); NombresVia.set_text(" "); NombresVia.clearItems(); } } function LoadNombresVia(sender, eventArgs) { var item = eventArgs.get_item(); NombresVia.set_text("Cargando..."); NombresVia.requestItems(item.get_value(), false); NombresVia.clearSelection(); } function ItemsLoaded(sender, eventArgs) { sender.showDropDown(); }</script>if (!Page.IsPostBack){ CargarProvincias(); //This method fill cboProvinciaT}else if (!Page.IsCallback){ LoadLocalidades(cboProvinciaT.SelectedValue); LoadTiposVia(cboLocalidadT.SelectedValue); LoadNombresVia(cboTipoViaT.SelectedValue);}#region Direcciónprotected void LoadLocalidades(string pIdProvincia){ try { AD.Motor mMotorAD = new AD.Motor(); DataTable mDT = new DataTable(); mDT = mMotorAD.ExecuteDataTable("Select 0 as ID, 'Localidad...' as Nombre union SELECT ID, Nombre FROM tlLocalidadDN where idProvincia=" + pIdProvincia + " ORDER BY Nombre ASC"); DataSet mDS = new DataSet(); mDS.Tables.Add(mDT); cboLocalidadT.DataTextField = "Nombre"; cboLocalidadT.DataValueField = "ID"; cboLocalidadT.DataSource = mDS.Tables[0]; cboLocalidadT.DataBind(); } catch (Exception ex) { throw ex; } }protected void LoadTiposVia(string pIdLocalidad){ try { AD.Motor mMotorAD = new AD.Motor(); DataTable mDT = new DataTable(); mDT = mMotorAD.ExecuteDataTable("Select 0 as ID, 'VÃa..' as Nombre union SELECT ID, Nombre FROM tlTipoViaDN ORDER BY Nombre ASC"); DataSet mDS = new DataSet(); mDS.Tables.Add(mDT); cboTipoViaT.DataTextField = "Nombre"; cboTipoViaT.DataValueField = "ID"; cboTipoViaT.DataSource = mDS.Tables[0]; cboTipoViaT.DataBind(); } catch (Exception ex) { throw ex; }}protected void LoadNombresVia(string pIdTipoVia){ try { //HERE ALWAYS GET empty ("")
string mIdLocalidad = cboLocalidadT.SelectedValue;
AD.Motor mMotorAD = new AD.Motor(); DataTable mDT = new DataTable(); mDT = mMotorAD.ExecuteDataTable("Select 0 as ID, ' Nombre de la VÃa..' as Nombre union SELECT ID, Nombre FROM tlViaDN where idLocalidad=" + mIdLocalidad + " and idTipovia=" + pIdTipoVia + " order by Nombre"); DataSet mDS = new DataSet(); mDS.Tables.Add(mDT); cboNombreVia.DataTextField = "Nombre"; cboNombreVia.DataValueField = "ID"; cboNombreVia.DataSource = mDS.Tables[0]; cboNombreVia.DataBind(); } catch (Exception ex) { throw ex; }}protected void LoadNombresVia(string pIdTipoVia, string pIdLocalidad){ try { AD.Motor mMotorAD = new AD.Motor(); DataTable mDT = new DataTable(); mDT = mMotorAD.ExecuteDataTable("Select 0 as ID, ' Nombre de la VÃa..' as Nombre union SELECT ID, Nombre FROM tlViaDN where idLocalidad=" + pIdLocalidad + " and idTipovia=" + pIdTipoVia + " order by Nombre"); DataSet mDS = new DataSet(); mDS.Tables.Add(mDT); cboNombreVia.DataTextField = "Nombre"; cboNombreVia.DataValueField = "ID"; cboNombreVia.DataSource = mDS.Tables[0]; cboNombreVia.DataBind(); } catch (Exception ex) { throw ex; }}protected void cboNombreVia_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e){ LoadNombresVia(e.Text);}protected void cboProvinciaT_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e){ CargarProvincias();}protected void cboLocalidadT_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e){ LoadLocalidades(e.Text);}protected void cboTipoViaT_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e){ LoadTiposVia(e.Text);}#endregionprotected void LoadNombresVia(string pIdTipoVia) { try { //******************************************** //**** HERE ALWAYS GET EMPTY VALUE --> "" **** //******************************************** string mIdLocalidad = cboLocalidadT.Text; //******************************************** AD.Motor mMotorAD = new AD.Motor(); DataTable mDT = new DataTable(); mDT = mMotorAD.ExecuteDataTable("Select 0 as ID, ' Nombre de la VÃa..' as Nombre union SELECT ID, Nombre FROM tlViaDN where idLocalidad=" + mIdLocalidad + " and idTipovia=" + pIdTipoVia + " order by Nombre"); DataSet mDS = new DataSet(); mDS.Tables.Add(mDT); cboNombreVia.DataTextField = "Nombre"; cboNombreVia.DataValueField = "ID"; cboNombreVia.DataSource = mDS.Tables[0]; cboNombreVia.DataBind(); } catch (Exception ex) { throw ex; } }<asp:panel id="div_projectsAssigned" runat="server" class="infoBox-projectsAssigned"> <telerik:RadTextBox ID="txtProjectsAssigned" runat="server" Text="0" BorderStyle="None" ReadOnly="True" Width="42" > <ClientEvents OnValueChanged="onValueChanged()" /> <ReadOnlyStyle HorizontalAlign="Center" BackColor="Transparent" ForeColor="White" Font-Bold="True" Font-Names="Segoe UI" Font-Size="12pt" Width="30px"> </ReadOnlyStyle> </telerik:RadTextBox></asp:panel>ClientEvents OnValueChanged="onValueChanged()" />
<script type="text/javascript"> function onValueChanged(sender, args) { if (args.get_oldvalue != args.get_newvalue) { thisDiv = $get("<%= div_projectsAssigned.ClientID %>"); esteDiv = "#" + thisDiv; animateDiv(thisDiv); } } function animateDiv(divToAnimate) { for (i = 1; i <= 3; i++) { $(divToAnimate).animate( { "opacity": "0.15" }, "slow"); $(divToAnimate).animate( { "opacity": "1.00" }, "slow"); } } </script><style type="text/css"> .style1 { color:Red !important; border:Blue; } </style> <form id="form1" runat="server"> <rad:RadScriptManager runat="server"></rad:RadScriptManager> <div> <asp:LinkButton ID="LinkButton1" runat="server" Text="Welcome"></asp:LinkButton> <rad:RadToolTip ID="Tooltip1" runat="server" Text="Hello Everyone" Enabled="true" CssClass="style1" Font-Size="Medium" TargetControlID="LinkButton1" RelativeTo="Element" Position="BottomCenter" AutoCloseDelay="2000" ShowEvent="OnMouseOver" EnableTheming="true" EnableEmbeddedSkins="true"></rad:RadToolTip> </div> </form>
<telerik:RadGrid ID="RadGrid1" runat="server" Height="412px" Width="818px" AutoGenerateColumns="true" AllowSorting="true" GroupingSettings-CaseSensitive="false" ClientSettings-Scrolling-AllowScroll="true" AutoGenerateHierarchy="true" PageSize="20" Skin="WebBlue" PagerStyle-AlwaysVisible="true" ClientSettings-ClientEvents-OnRowDblClick="RowDblClick" ClientSettings-Resizing-AllowColumnResize="true" ClientSettings-Scrolling-UseStaticHeaders="false" ClientSettings-Selecting-AllowRowSelect="true" ClientSettings-ClientEvents-OnRowClick="RadGrid1_RowSelected" ClientSettings-Scrolling-SaveScrollPosition="true" AllowFilteringByColumn="true" AllowPaging="true" OnNeedDataSource="RadGrid1_NeedDataSource" OnDetailTableDataBind="RadGrid1_DetailTableDataBind" OnColumnCreated="RadGrid1_ColumnCreated" OnPreRender="RadGrid1_PreRender" OnItemDataBound="RadGrid1_ItemDataBound" OnItemCreated="RadGrid1_ItemCreated" ondatabound="RadGrid1_DataBound"> <MasterTableView AllowMultiColumnSorting="True" ClientDataKeyNames="rvlPropertyID" DataKeyNames="rvlPropertyID" HierarchyLoadMode="Client" Name="Property" Width="100%"> </MasterTableView> <HeaderStyle VerticalAlign="Top" Width="125px" /> <PagerStyle AlwaysVisible="True" /></telerik:RadGrid>switch (m_GridViewType){ case "Access": RadGrid1.MasterTableView.DetailTables[0].Name = "Access"; RadGrid1.MasterTableView.DetailTables[0].DataKeyNames = new string[] { "rvlPropertyID", "rvlPropertyAccessID" }; RadGrid1.MasterTableView.DetailTables[0].ClientDataKeyNames = new string[] { "rvlPropertyID", "rvlPropertyAccessID" }; break; case "Assessment": RadGrid1.MasterTableView.DetailTables[0].Name = "Assessment"; RadGrid1.MasterTableView.DetailTables[0].DataKeyNames = new string[] { "rvlPropertyID", "rvlPropAssessmentID" }; RadGrid1.MasterTableView.DetailTables[0].ClientDataKeyNames = new string[] { "rvlPropertyID", "rvlPropAssessmentID" }; break; case "Status": RadGrid1.MasterTableView.DetailTables[0].Name = "Status"; RadGrid1.MasterTableView.DetailTables[0].DataKeyNames = new string[] { "rvlPropertyID", "rvlPropertyStatusID" }; RadGrid1.MasterTableView.DetailTables[0].ClientDataKeyNames = new string[] { "rvlPropertyID", "rvlPropertyStatusID" }; break; case "Contact": RadGrid1.MasterTableView.DetailTables[0].Name = "Contact"; RadGrid1.MasterTableView.DetailTables[0].DataKeyNames = new string[] { "rvlPropertyID", "cntContactID" }; RadGrid1.MasterTableView.DetailTables[0].ClientDataKeyNames = new string[] { "rvlPropertyID", "cntContactID" }; break; case "Call": RadGrid1.MasterTableView.DetailTables[0].Name = "Call"; RadGrid1.MasterTableView.DetailTables[0].DataKeyNames = new string[] { "rvlPropertyID", "clnCallinLogID" }; RadGrid1.MasterTableView.DetailTables[0].ClientDataKeyNames = new string[] { "rvlPropertyID", "clnCallinLogID" }; break;}function RowDblClick(sender, eventArgs) { var propid = eventArgs.getDataKeyValue("rvlPropertyID"); switch (document.getElementById('<%=cmbGridViews.ClientID %>').value) { case "Access": var childID = eventArgs.getDataKeyValue("RvlPropertyAccessID"); break; case "Assessment": var childID = eventArgs.getDataKeyValue("RvlPropAssessmentID"); break; case "Status": var childID = eventArgs.getDataKeyValue("RvlPropertyStatusID"); break; case "Contact": var childID = eventArgs.getDataKeyValue("CntContactID"); break; case "Call": var childID = eventArgs.getDataKeyValue("ClnCallinLogID"); break; default: break; } var targetCell = eventArgs.get_domEvent().target; if (childID == undefined) { if (targetCell.cellIndex == 1) // Property Name window.radopen("Editors/PropertyEditor.aspx?propid=" + propid, "editWindow"); else if (targetCell.cellIndex == 7 && targetCell.innerHTML != "0") // photocounter and does not = 0 window.radopen(GetPhotoViewerURL() + "PhotoViewer.aspx?id=" + propid, "PhotoWindow"); } else { // is child row if (targetCell.cellIndex == 0) // Assessment date window.radopen("Editors/PropertyAssessmentEditor.aspx?id=" + rvlAssessmentID, "editWindow"); else if (targetCell.cellIndex == 11 && targetCell.innerHTML != "0") window.radopen(GetPhotoViewerURL() + "PhotoViewer.aspx?id=" + rvlAssessmentID, "PhotoWindow"); } }
<asp:Panel ID="pnlDetailGrid" runat="server" Visible="false" CssClass="myPanelClass">
<asp:ImageButton ID="ImageButton1" runat="server" AlternateText="Export to Excel"
CssClass="imButton" ImageUrl="~/Images/Excel.jpg" OnClick="ImageButton1_Click" />
<telerik:RadGrid ID="RadGrid1" runat="server" Width="100%"
AutoGenerateColumns="False" AllowMultiRowSelection="False" AllowPaging="true" PageSize="15"
OnDetailTableDataBind="RadGrid1_DetailTableDataBind" Skin="Black" AllowCustomPaging="true"
onneeddatasource="RadGrid1_NeedDataSource"
onitemcreated="RadGrid1_ItemCreated" onitemcommand="RadGrid1_ItemCommand"
onexcelexportcellformatting="RadGrid1_ExcelExportCellFormatting"
onexcelmlexportrowcreated="RadGrid1_ExcelMLExportRowCreated"
onexcelmlexportstylescreated="RadGrid1_ExcelMLExportStylesCreated">
<PagerStyle Mode="NumericPages" />
<MasterTableView TableLayout="Fixed" AllowMultiColumnSorting="True" cellpadding="0" DataKeyNames="TXNORDER" Width="100%" CommandItemDisplay="Top" GroupLoadMode="Server">
<CommandItemTemplate>
<asp:CheckBox ID="CheckBox2" AutoPostBack="true" CssClass="CheckBox" runat="server" ForeColor="White" Text="Show Filter" />
</CommandItemTemplate>
 
<DetailTables>
<telerik:GridTableView DataKeyNames="TXNORDER" Name="Orders" Width="100%">
<Columns>
<telerik:GridTemplateColumn HeaderStyle-Width="5px">
<ItemTemplate>
<asp:ImageButton ID="imgCheck" runat="server" CausesValidation="false"
CommandArgument='<%# DataBinder.Eval(Container.DataItem, "CaptureImageKey")%>'
CommandName='<%# DataBinder.Eval(Container.DataItem, "ItemTypePK")%>'
Height="20px" ImageUrl="~/Images/check-template.png" onclick="imgCheck_Click"
ToolTip="Check Image" Width="30px"/>
</ItemTemplate>
<HeaderStyle Width="40px" />
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="TXNORDER" HeaderButtonType="TextButton"
HeaderText="Transaction#" SortExpression="TXNORDER"
UniqueName="TXNORDER" Visible="False">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ItemTypePK" HeaderButtonType="TextButton"
HeaderText="Type" SortExpression="ItemTypePK" UniqueName="ItemTypePK">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="FIELD7" HeaderButtonType="TextButton"
HeaderText="Serial#" SortExpression="FIELD7" UniqueName="FIELD7">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="FIELD6" HeaderButtonType="TextButton"
HeaderText="P44" SortExpression="FIELD6" UniqueName="FIELD6">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="FIELD5" HeaderButtonType="TextButton"
HeaderText="Routing#" SortExpression="FIELD5" UniqueName="FIELD5">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="FIELD4" HeaderButtonType="TextButton"
HeaderText="AltSerial#" SortExpression="FIELD4" UniqueName="FIELD4">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="FIELD3" HeaderButtonType="TextButton"
HeaderText="Account#" SortExpression="FIELD3" UniqueName="FIELD3">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="FIELD2" HeaderButtonType="TextButton"
HeaderText="TC#" SortExpression="FIELD2" UniqueName="FIELD2">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Amount" HeaderButtonType="TextButton"
HeaderText="Amount" SortExpression="Amount" UniqueName="Amount"
HeaderStyle-HorizontalAlign="left" ItemStyle-HorizontalAlign="left">
<HeaderStyle HorizontalAlign="Center" />
<ItemStyle CssClass="pad" HorizontalAlign="Right" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="CaptureImageKey" HeaderButtonType="TextButton"
HeaderText="CaptureImageKey" SortExpression="CaptureImageKey"
UniqueName="CaptureImageKey" Visible="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="EnterpriseID" HeaderButtonType="TextButton"
HeaderText="EnterpriseID" SortExpression="EnterpriseID"
UniqueName="EnterpriseID" Visible="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ReverseReason" HeaderButtonType="TextButton"
HeaderText="ReverseReason" SortExpression="ReverseReason"
UniqueName="ReverseReason" Visible="false">
</telerik:GridBoundColumn>
</Columns>
</telerik:GridTableView>
</DetailTables>
<Columns>
<telerik:GridTemplateColumn HeaderStyle-Width="5px">
<ItemTemplate>
<asp:ImageButton ID="imgReverseTransaction" runat="server"
CausesValidation="false" Height="20px" Width="20px"
CommandArgument='<%#Eval("TXNORDER") + ","+Eval("EnterpriseID")+ ","+Eval("BankID")+ ","+Eval("BranchID")+ ","+Eval("BatchID")+ ","+Eval("OPENEDTIME") + ","+Eval("SourceTypePK")+ ","+Eval("AuxBatchID")%>'
CommandName="ReverseTransaction"
ImageUrl="~/Images/green-undo-icon.png" onclick="imgReverseTransaction_Click"
OnClientClick="javascript:return confirm('Are you sure? \n This action cannot be undone.')"
ToolTip="Reverse Transaction"
visible='<%#DataBinder.Eval(Container.DataItem,"ShowImgReverseTransaction")%>'/>
</ItemTemplate>
<HeaderStyle Width="30px" />
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="TXNORDER" HeaderButtonType="TextButton"
HeaderText="Transaction #" SortExpression="TXNORDER"
UniqueName="TXNORDER">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="CaptureStatus" HeaderButtonType="TextButton"
HeaderText="Capture Status" SortExpression="CaptureStatus">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="TRANSACTIONTIME" HeaderButtonType="TextButton"
HeaderText="Transaction Time" SortExpression="TRANSACTIONTIME">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Amount" HeaderButtonType="TextButton"
HeaderText="Amount" SortExpression="Amount" UniqueName="Amount"
HeaderStyle-HorizontalAlign="left" ItemStyle-HorizontalAlign="left">
<HeaderStyle HorizontalAlign="Center" />
<ItemStyle CssClass="pad" HorizontalAlign="Center" />
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
<ClientSettings>
<Scrolling AllowScroll="True" EnableVirtualScrollPaging="True" UseStaticHeaders="True"
SaveScrollPosition="True"></Scrolling>
</ClientSettings>
</telerik:RadGrid>
</asp:Panel>