Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
108 views
Currently I have an application that is sitting on a tabstrip with pageviews that are actually usercontrols.  On one of my usercontrols there is a grid with nestedviews.  I have a need to when the tab changes to close all the rows in my grid.  I have tried several ways of doing this and have not found a way.  Any help would be appreciated.

I've tried the following.

rdInsLines.DataBind();

rdInsLines.ReBind();
foreach (GridItem item in rdInsLines.MasterTableView.Controls[0].Controls){
  if (item is GridDataItem){
    if (item.Expanded){
       item.FireCommandEvent(
"ExpandCollapse", String.Empty);
    }
   item.FireCommandEvent(
"Validate", String.Empty);
 }
}

foreach
(GridDataItem item in RadGrid1.Items)
//loops through each grid item
{
item.Expanded = false;//collapse item
}

If you notice in the Page_Load Procedure some code that says

if (strControlName == "TabChanged")

                {
                    if (!ValidateData())
                    {
                        if (Session["ErrorTab"] == null)
                            Session["ErrorTab"] = "Insurance";
                    }
                    rdInsLines.DataBind();
                }

This is where I'm trying to close the grid but it's not working.


<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="InsuranceUC.ascx.cs"
    Inherits="SterlingNational.Tax.WebApp.ActionPages.InsuranceUC" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  
<script type="text/javascript">
  
    function OnRowDblClick(sender, eventArgs) {
        try {
            var dataItem = $get(eventArgs.get_id());
            var grid = sender;
            var MasterTable = grid.get_masterTableView();
            var row = MasterTable.get_dataItems()[eventArgs.get_itemIndexHierarchical()];
            var cell = MasterTable.getCellByColumnUniqueName(row, "LSS_INSURANCE_LINE_KEY");
            var value = cell.innerHTML
            __doPostBack('DoubleClick', value);
  
        }
        catch (e) {
            _showAndLogException("STES.InsuranceUC.ascz.OnRowDblClick: " + e.message);
        }
    }
  
    function keyPressed(sender, args) {
        if (args.get_keyCode() == 13) {
            var e = args.get_domEvent().rawEvent;
            __doPostBack('SaveData');
            e.returnValue = false;
            e.cancelBubble = true;
  
            if (e.stopPropagation) {
                e.preventDefault();
                e.stopPropagation();
            }
        }
    }
  
      
</script>
  
<body>
    <div>
        <table>
            <tr>
                <td width="100%">
                         
                    <asp:Label ID="Label20" runat="server" Text="Borrower Name:" Font-Bold="True" Font-Names="Arial"
                        Font-Size="Small"></asp:Label
                    <asp:Label ID="lblCustName3" runat="server" Text="" Font-Names="Arial" Font-Size="Small"></asp:Label>
                </td>
            </tr>
            <tr>
                <td>
                       
                </td>
            </tr>
            <tr>
                <td>
                         
                    <asp:Label ID="Label23" runat="server" Text="Create, edit, and confirm insurance lines for the escrowed insurance payments for this loan."
                        Font-Bold="True" Font-Names="Arial" Font-Size="Small"></asp:Label>
                </td>
            </tr>
        </table>
        <table width="800px">
            <tr>
                <td colspan="2">
                        
                    <asp:Button ID="btnAddIns" runat="server" SkinID="Web20" Text="Add Insurance Line(s)"
                        Width="130px" ToolTip="Add insurance policy payment lines." OnClick="btnAddIns_onClick"
                        UseSubmitBehavior="false" /> 
                    <asp:Label ID="lblInsuranceError" runat="server" Text="" Font-Bold="True" Font-Size="10pt"
                        Font-Names="Arial" ForeColor="Red" Visible="false"></asp:Label
                </td>
            </tr>
            <tr>
                <td colspan="2">
                       
                </td>
            </tr>
            <tr style="height: 310px;">
                <td>
                        
                </td>
                <td align="left">
                    <div id="divInsGrid" style="display: none; width: 100%;" runat="server">
                        <telerik:RadGrid ID="rdInsLines" runat="server" AllowPaging="True" AllowSorting="True"
                            OnNeedDataSource="rdInsLines_NeedDataSource" AutoGenerateColumns="False" GridLines="Horizontal"
                            Height="300px" GroupingEnabled="False" OnItemCommand="rdInsLines_ItemCommand"
                            ShowGroupPanel="True" Skin="Web20">
                            <MasterTableView>
                                <NoRecordsTemplate>
                                    No insurance data found.
                                </NoRecordsTemplate>
                                <NestedViewTemplate>
                                    <asp:Panel runat="server" ID="InnerInsContainer" Visible="false" BorderColor="#2C57A2"
                                        BorderStyle="Solid" BackColor="White" BorderWidth="1px">
                                        <table>
                                            <tr>
                                                <td colspan="3">
                                                    <asp:Label ID="Label40" runat="server" Text="Type:" Font-Bold="True" Font-Names="Arial"
                                                        Font-Size="Small"></asp:Label
                                                    <telerik:RadComboBox ID="ddInsuranceTypes" runat="server" Skin="Web20" Width="200px"
                                                        AutoPostBack="True" OnSelectedIndexChanged="ddInsuranceTypes_SelectedIndexChanged"
                                                        TabIndex="1">
                                                    </telerik:RadComboBox>
                                                </td>
                                                <td colspan="2">
                                                    <asp:Label ID="Label18" runat="server" Text="Insurance Company" Font-Bold="True"
                                                        Font-Names="Arial" Font-Size="14px" Visible="false"></asp:Label>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td colspan="3">
                                                    <asp:Label ID="Label24" runat="server" Text="Policy Information" Font-Bold="True"
                                                        Font-Names="Arial" Font-Size="14px" Visible="false"></asp:Label>
                                                </td>
                                                <td align="right" style="width: 100px;">
                                                    <asp:Label ID="Label30" runat="server" Text="Name:" Font-Bold="True" Font-Names="Arial"
                                                        Font-Size="Small" Visible="false"></asp:Label>
                                                </td>
                                                <td>
                                                    <telerik:RadTextBox ID="txtInsCompany" Width="200px" MaxLength="100" runat="server"
                                                        Visible="false" TabIndex="9">
                                                    </telerik:RadTextBox>
                                                </td>
                                                <td style="width: 50px;">
                                                    <asp:Label ID="lblErrorCompany" runat="server" Text="" Font-Bold="True" Font-Size="9pt"
                                                        Font-Names="Arial" ForeColor="Red"></asp:Label
                                                </td>
                                            </tr>
                                            <tr>
                                                <td align="right">
                                                    <asp:Label ID="Label19" runat="server" Text="Policy Number:" Font-Bold="True" Font-Names="Arial"
                                                        Font-Size="Small" Visible="false"></asp:Label>
                                                </td>
                                                <td style="width: 125px;">
                                                    <telerik:RadTextBox ID="txtPolicyNumber" Width="100px" MaxLength="50" runat="server"
                                                        Visible="false" TabIndex="2">
                                                    </telerik:RadTextBox>
                                                </td>
                                                <td>
                                                </td>
                                                <td align="right">
                                                    <asp:Label ID="Label25" runat="server" Text="Address:" Font-Bold="True" Font-Names="Arial"
                                                        Font-Size="Small" Visible="false"></asp:Label>
                                                </td>
                                                <td>
                                                    <telerik:RadTextBox ID="txtInsAddress" Width="200px" MaxLength="50" runat="server"
                                                        Visible="false" TabIndex="10">
                                                    </telerik:RadTextBox>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td align="right">
                                                    <asp:Label ID="Label43" runat="server" Text="Monthly Amount:" Font-Bold="True" Font-Names="Arial"
                                                        Font-Size="Small" Visible="false"></asp:Label>
                                                    <asp:Label ID="Label44" runat="server" Text="Effective Date:" Font-Bold="True" Font-Names="Arial"
                                                        Font-Size="Small" Visible="false"></asp:Label>
                                                </td>
                                                <td>
                                                    <telerik:RadNumericTextBox ID="txtMonthlyPremium" runat="server" Culture="English (United States)"
                                                        Skin="Web20" Type="Currency" Width="100px" Visible="false" TabIndex="3" MaxLength="8"
                                                        MinValue="0">
                                                    </telerik:RadNumericTextBox>
                                                    <telerik:RadDatePicker ID="rdEffectiveDate" runat="server" FocusedDate="" Skin="Web20"
                                                        Width="130px" Visible="false" TabIndex="4" DateInput-DateFormat="MM/dd/yyyy">
                                                        <Calendar ID="Calendar2" runat="server" UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False"
                                                            ViewSelectorText="x" Skin="Web20" ShowRowHeaders="false">
                                                        </Calendar>
                                                        <DateInput ID="DateInput2" runat="server" DisplayDateFormat="M/d/yyyy" DateFormat="M/d/yyyy">
                                                        </DateInput>
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td>
                                                    <asp:Label ID="lblEffectiveDate" runat="server" Text="" Font-Bold="True" Font-Size="9pt"
                                                        Font-Names="Arial" ForeColor="Red"></asp:Label
                                                </td>
                                                <td align="right">
                                                    <asp:Label ID="Label26" runat="server" Text="City:" Font-Bold="True" Font-Names="Arial"
                                                        Font-Size="Small" Visible="false"></asp:Label>
                                                </td>
                                                <td>
                                                    <telerik:RadTextBox ID="txtInsCity" Width="200px" MaxLength="100" runat="server"
                                                        Visible="false" TabIndex="11">
                                                    </telerik:RadTextBox>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td align="right">
                                                    <asp:Label ID="Label49" runat="server" Text="First Due Date:" Font-Bold="True" Font-Names="Arial"
                                                        Font-Size="Small" Visible="false"></asp:Label>
                                                    <asp:Label ID="Label51" runat="server" Text="Expiration Date:" Font-Bold="True" Font-Names="Arial"
                                                        Font-Size="Small" Visible="false"></asp:Label>
                                                </td>
                                                <td>
                                                    <telerik:RadDatePicker ID="rdPMIEffectiveDate" runat="server" FocusedDate="" Skin="Web20"
                                                        Width="130px" Visible="false" TabIndex="5" DateInput-DateFormat="MM/dd/yyyy">
                                                        <Calendar ID="Calendar3" runat="server" UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False"
                                                            ViewSelectorText="x" Skin="Web20" ShowRowHeaders="false">
                                                        </Calendar>
                                                        <DateInput ID="DateInput3" runat="server" DisplayDateFormat="M/d/yyyy" DateFormat="M/d/yyyy">
                                                        </DateInput>
                                                    </telerik:RadDatePicker>
                                                    <telerik:RadDatePicker ID="rdExpirationDate" runat="server" FocusedDate="" Skin="Web20"
                                                        Width="130px" Visible="false" TabIndex="6" DateInput-DateFormat="MM/dd/yyyy">
                                                        <Calendar ID="Calendar5" runat="server" UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False"
                                                            ViewSelectorText="x" Skin="Web20" ShowRowHeaders="false">
                                                        </Calendar>
                                                        <DateInput ID="DateInput5" runat="server" DisplayDateFormat="M/d/yyyy" DateFormat="M/d/yyyy">
                                                        </DateInput>
                                                    </telerik:RadDatePicker>
                                                </td>
                                                <td style="width: 115px;">
                                                    <asp:Label ID="lblErrorExpDate" runat="server" Text="" Font-Bold="True" Font-Size="9pt"
                                                        Font-Names="Arial" ForeColor="Red"></asp:Label
                                                    <asp:Label ID="lblErrorExpDate2" runat="server" Text="" Font-Bold="True" Font-Size="9pt"
                                                        Font-Names="Arial" ForeColor="Red"></asp:Label>                                                         
                                                </td>
                                                <td align="right">
                                                    <asp:Label ID="Label29" runat="server" Text="State:" Font-Bold="True" Font-Names="Arial"
                                                        Font-Size="Small" Visible="false"></asp:Label>
                                                </td>
                                                <td>
                                                    <telerik:RadComboBox ID="ddInsState" runat="server" Skin="Web20" Width="60px" Visible="false"
                                                        TabIndex="12">
                                                    </telerik:RadComboBox>
                                                        
                                                    <asp:Label ID="Label31" runat="server" Text="ZIP:" Font-Bold="True" Font-Names="Arial"
                                                        Font-Size="Small" Visible="false"></asp:Label>
                                                    <telerik:RadMaskedTextBox ID="txtInsZip" runat="server" Width="90px" Mask="#####-####"
                                                        Skin="Web20" Visible="false" TabIndex="13" SelectionOnFocus="CaretToBeginning">
                                                    </telerik:RadMaskedTextBox>
                                                </td>
                                                <td>
                                                    <asp:Label ID="lblZipError" runat="server" Text="" Font-Bold="True" Font-Size="9pt"
                                                        Font-Names="Arial" ForeColor="Red"></asp:Label
                                                </td>
                                            </tr>
                                            <tr>
                                                <td align="right">
                                                    <asp:Label ID="lblDueDate" runat="server" Text="Due Date:" Font-Bold="True" Font-Names="Arial"
                                                        Font-Size="Small" Visible="false"></asp:Label>
                                                </td>
                                                <td>
                                                    <telerik:RadDatePicker ID="rdDueDate" runat="server" FocusedDate="" Skin="Web20"
                                                        Width="130px" Visible="false" TabIndex="5" DateInput-DateFormat="MM/dd/yyyy">
                                                        <Calendar ID="Calendar1" runat="server" UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False"
                                                            ViewSelectorText="x" Skin="Web20" ShowRowHeaders="false">
                                                        </Calendar>
                                                        <DateInput ID="DateInput1" runat="server" DisplayDateFormat="M/d/yyyy" DateFormat="M/d/yyyy">
                                                        </DateInput>
                                                    </telerik:RadDatePicker>
                                                </td>                     
                                                <td>
                                                </td>                                                                                                                            
                                                <td align="right">
                                                    <asp:Label ID="Label32" runat="server" Text="Phone:" Font-Bold="True" Font-Names="Arial"
                                                        Font-Size="Small" Visible="false"></asp:Label>
                                                </td>
                                                <td colspan="2">
                                                    <telerik:RadMaskedTextBox ID="txtInsPhone" Width="100px" MaxLength="20" runat="server"
                                                        Mask="(###) ###-####" Skin="Web20" Visible="false" TabIndex="14" SelectionOnFocus="CaretToBeginning">
                                                    </telerik:RadMaskedTextBox>
                                                    <asp:Label ID="lblErrorPhone" runat="server" Text="" Font-Bold="True" Font-Size="9pt"
                                                        Font-Names="Arial" ForeColor="Red"></asp:Label
                                                </td>
                                            </tr>
                                            <tr>
                                                 <td align="right">
                                                    <asp:Label ID="lblStatus" runat="server" Text="Status:" Font-Bold="True" Font-Names="Arial"
                                                        Font-Size="Small" Visible="false"></asp:Label>
                                                </td>    
                                                <td>                                                
                                                  <telerik:RadComboBox ID="cboStatus" runat="server" Skin="Web20" Width="105px"
                                                        AutoPostBack="True" TabIndex="1" Visible="false">
                                                        <Items>
                                                           <telerik:RadComboBoxItem runat="server" Text="Paid" />
                                                           <telerik:RadComboBoxItem runat="server" Text="UnPaid" />
                                                        </Items>
                                                  </telerik:RadComboBox>                                                
                                                </td>   
                                                <td>
                                                </td>                                                                                                                                                                                                                                                               
                                                <td align="right">
                                                    <asp:Label ID="Label33" runat="server" Text="Agency Name:" Font-Bold="True" Font-Names="Arial"
                                                        Font-Size="Small" Visible="false"></asp:Label>
                                                </td>
                                                <td>
                                                    <telerik:RadTextBox ID="txtAgencyName" Width="200px" MaxLength="100" runat="server"
                                                        Visible="false" TabIndex="15">
                                                    </telerik:RadTextBox>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td align="right">
                                                    <asp:Label ID="Label39" runat="server" Text="Annual Premium:" Font-Bold="True" Font-Names="Arial"
                                                        Font-Size="Small" Visible="false"></asp:Label>
                                                </td>
                                                <td>
                                                    <telerik:RadNumericTextBox ID="txtYearlyPremium" runat="server" Culture="English (United States)"
                                                        Skin="Web20" Type="Currency" Width="100px" Visible="false" TabIndex="7" MaxLength="8"
                                                        MinValue="0">
                                                    </telerik:RadNumericTextBox>
                                                </td>
                                                <td>
                                                    <asp:Label ID="lblErrorYearly" runat="server" Text="" Font-Bold="True" Font-Size="9pt"
                                                        Font-Names="Arial" ForeColor="Red"></asp:Label
                                                </td>           
                                                <td align="right">
                                                    <asp:Label ID="Label34" runat="server" Text="Agency Phone:" Font-Bold="True" Font-Names="Arial"
                                                        Font-Size="Small" Visible="false"></asp:Label>
                                                </td>
                                                <td colspan="2">
                                                    <telerik:RadMaskedTextBox ID="txtAgencyPhone" Width="100px" MaxLength="20" runat="server"
                                                        Mask="(###) ###-####" Skin="Web20" Visible="false" TabIndex="16" SelectionOnFocus="CaretToBeginning">
                                                    </telerik:RadMaskedTextBox>
                                                    <asp:Label ID="lblAgencyPhone" runat="server" Text="" Font-Bold="True" Font-Size="9pt"
                                                        Font-Names="Arial" ForeColor="Red"></asp:Label
                                                </td>
                                            </tr>
                                             <tr>
                                             <td align="right">
                                                    <asp:Label ID="Label42" runat="server" Text="Coverage Amount:" Font-Bold="True" Font-Names="Arial"
                                                        Font-Size="Small" Visible="false"></asp:Label>
                                                </td>
                                                <td>
                                                    <telerik:RadNumericTextBox ID="txtCoverageAmount" runat="server" Culture="English (United States)"
                                                        Skin="Web20" Type="Currency" Width="100px" Visible="false" TabIndex="8" MaxValue="9999999999"
                                                        MinValue="0" MaxLength="8">
                                                    </telerik:RadNumericTextBox>
                                                </td>                                                 
                                            </tr>                                            
                                        </table>
                                    </asp:Panel>
                                </NestedViewTemplate>
                                <Columns>
                                    <telerik:GridBoundColumn DataField="INSURANCE_TYPE_MDESC" HeaderText="Type" UniqueName="INSURANCE_TYPE_MDESC"
                                        EmptyDataText="">
                                        <HeaderStyle Font-Bold="True" HorizontalAlign="Center" Width="105px" />
                                        <ItemStyle Width="105px" />
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="INSURANCE_COMPANY_NAME" HeaderText="Insurance Company"
                                        UniqueName="INSURANCE_COMPANY_NAME" EmptyDataText="">
                                        <HeaderStyle Font-Bold="True" HorizontalAlign="Center" Width="190px" />
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="YEARLY_PREMIUM" HeaderText="Premium" UniqueName="YEARLY_PREMIUM"
                                        EmptyDataText="">
                                        <HeaderStyle Font-Bold="True" HorizontalAlign="Center" Width="70px" />
                                        <ItemStyle HorizontalAlign="Right" Width="70px" />
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="EXPIRATION_DATE" HeaderText="Exp. Date" UniqueName="EXPIRATION_DATE"
                                        EmptyDataText="">
                                        <HeaderStyle Font-Bold="True" HorizontalAlign="Center" Width="60px" />
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="POLICY_NUMBER" HeaderText="Policy Number" UniqueName="POLICY_NUMBER"
                                        EmptyDataText="">
                                        <HeaderStyle Font-Bold="True" HorizontalAlign="Center" Width="170px" />
                                    </telerik:GridBoundColumn>
                                    <telerik:GridButtonColumn ButtonType="ImageButton" ImageUrl='../Images/edit.GIF' CommandName="ExpandCollapse"  UniqueName="InsEdit">
                                        <HeaderStyle Font-Bold="True" HorizontalAlign="Center" Width="35px" />
                                    </telerik:GridButtonColumn>
                                    <telerik:GridButtonColumn ButtonType="ImageButton" ImageUrl='../Images/deleteX.GIF' CommandName="Delete" ConfirmText="Are you sure you want to delete this Insurance Line?">
                                        <HeaderStyle Font-Bold="True" HorizontalAlign="Center" Width="40px" />
                                    </telerik:GridButtonColumn>
                                    <telerik:GridBoundColumn DataField="LSS_INSURANCE_LINE_KEY" Display="False" UniqueName="LSS_INSURANCE_LINE_KEY"
                                        EmptyDataText="">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="LSS_INSURANCE_TYPE" Display="False" UniqueName="LSS_INSURANCE_TYPE"
                                        EmptyDataText="">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="INSURANCE_COMPANY_STREET" Display="False" UniqueName="INSURANCE_COMPANY_STREET"
                                        EmptyDataText="">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="INSURANCE_COMPANY_CITY" Display="False" UniqueName="INSURANCE_COMPANY_CITY"
                                        EmptyDataText="">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="INSURANCE_COMPANY_STATE" Display="False" UniqueName="INSURANCE_COMPANY_STATE"
                                        EmptyDataText="">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="INSURANCE_COMPANY_ZIP" Display="False" UniqueName="INSURANCE_COMPANY_ZIP"
                                        EmptyDataText="">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="INSURANCE_COMPANY_PHONE" Display="False" UniqueName="INSURANCE_COMPANY_PHONE"
                                        EmptyDataText="">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="AGENCY_NAME" Display="False" UniqueName="AGENCY_NAME"
                                        EmptyDataText="">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="AGENCY_PHONE_NUMBER" Display="False" UniqueName="AGENCY_PHONE_NUMBER"
                                        EmptyDataText="">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="COVERAGE_AMOUNT" Display="False" UniqueName="COVERAGE_AMOUNT"
                                        EmptyDataText="">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="PAYMENT_DUE_DATE" Display="False" UniqueName="PAYMENT_DUE_DATE"
                                        EmptyDataText="">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="EFFECTIVE_DATE" Display="False" UniqueName="EFFECTIVE_DATE"
                                        EmptyDataText="">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="PAYMENTS_PER_YEAR" Display="False" UniqueName="PAYMENTS_PER_YEAR"
                                        EmptyDataText="">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="LENDER_NUMBER" Display="False" UniqueName="LENDER_NUMBER"
                                        MaxLength="100" EmptyDataText="">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="LOAN_NUMBER" Display="False" UniqueName="LOAN_NUMBER"
                                        EmptyDataText="">
                                    </telerik:GridBoundColumn>                                        
                                    <telerik:GridBoundColumn DataField="DUE_DATE" Display="False" UniqueName="DUE_DATE"
                                        EmptyDataText="">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="PAID_IND" Display="False" UniqueName="PAID_IND"
                                        EmptyDataText="">                                                                                
                                    </telerik:GridBoundColumn>
                                </Columns>
                            </MasterTableView>
                            <SelectedItemStyle BackColor="#F8C320" />
                            <ClientSettings EnableRowHoverStyle="true">
                                <ClientEvents OnRowDblClick="OnRowDblClick" />
                                <ClientEvents OnKeyPress="keyPressed" />
                                <Selecting AllowRowSelect="false" />
                                <Scrolling AllowScroll="True" UseStaticHeaders="True" SaveScrollPosition="true" />
                            </ClientSettings>
                        </telerik:RadGrid>
                    </div>
                </td>
            </tr>
        </table>
    </div>
</body>
</html>

 

 

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 SterlingNational.OracleDataAccess;
using Telerik.Web.UI;
using SterlingNational.DomainLibrary;
using System.Collections;
using SterlingNational.Tax.WebApp.BasePages;
  
namespace SterlingNational.Tax.WebApp.ActionPages
{
    public partial class InsuranceUC : BaseUserControl
    {
        private TaxUserData taxUserData;
        private InsuranceData insuranceData;
        private LoanData loanData;
        public int errorCount = 0;
  
        protected void Page_Load(object sender, EventArgs e)
        {
            taxUserData = new TaxUserData();
            BorrowerData borrowerData = new BorrowerData();
            LoanData loanData = new LoanData();
  
            if (taxUserData.UserID == null)
            {
                Response.Redirect(CONST.C_SESSION_EXPIRE_REDIRECT, true);
            }
  
            if (!Page.IsPostBack)
            {
                LoadData();
            }
            else
            {
                string strControlName = "";
                strControlName = Request.Params.Get("__EVENTTARGET");
                if (strControlName == "TabChanged")
                {
                    if (!ValidateData())
                    {
                        if (Session["ErrorTab"] == null)
                            Session["ErrorTab"] = "Insurance";
                    }
                    rdInsLines.DataBind();
                }
                if (strControlName == "DoubleClick")
                {
                    foreach (GridItem item in rdInsLines.MasterTableView.Controls[0].Controls)
                    {
                        if (item is GridDataItem)
                        {
                            GridDataItem dataItem = (GridDataItem)item;
                            if (dataItem["LSS_INSURANCE_LINE_KEY"].Text == Request.Params.Get("__EVENTARGUMENT"))
                            {
                                item.FireCommandEvent("ExpandCollapse", String.Empty);
                            }
                        }
                    }
                }
             
                // Refresh the borrower name
                lblCustName3.Text =
                    borrowerData.MortgagorLastName + ", " + borrowerData.MortgagorFirstName;
            }
            btnAddIns.Focus();
        }
  
        internal override void SaveData()
        {
            try
            {
                StatementsData statementsData = new StatementsData(); // Shouldn't this field be in InsuranceData?
                insuranceData = new InsuranceData();
                taxUserData = new TaxUserData();
  
                // Save to the database
                if (insuranceData.InsuranceDataTable.Rows.Count > 0)
                {
                    if (ValidateData())
                    {
                        foreach (DataRow row in insuranceData.InsuranceDataTable.Rows)
                        {
                            // Don't save the deleted data
                            if (row.RowState != DataRowState.Deleted)
                            {
                                Hashtable insuranceInfo = new Hashtable();
                                if (errorCount == 0)
                                {
                                    insuranceInfo[DBEscrowServicing.LENDER_NUMBER] = row[DBEscrowServicing.LENDER_NUMBER];
                                    insuranceInfo[DBEscrowServicing.LOAN_NUMBER] = row[DBEscrowServicing.LOAN_NUMBER];
  
                                    insuranceInfo[DBEscrowServicing.LSS_INSURANCE_LINE_KEY] = row[DBEscrowServicing.LSS_INSURANCE_LINE_KEY];
  
                                    insuranceInfo[DBEscrowServicing.LSS_INSURANCE_TYPE] = row[DBEscrowServicing.LSS_INSURANCE_TYPE];
                                    insuranceInfo[DBEscrowServicing.INSURANCE_TYPE_MDESC] = row[DBEscrowServicing.INSURANCE_TYPE_MDESC];
  
                                    insuranceInfo[DBEscrowServicing.POLICY_NUMBER] = row[DBEscrowServicing.POLICY_NUMBER];
  
                                    insuranceInfo[DBEscrowServicing.PAYMENTS_PER_YEAR] = row[DBEscrowServicing.PAYMENTS_PER_YEAR];
  
                                    insuranceInfo[DBEscrowServicing.EFFECTIVE_DATE] = row[DBEscrowServicing.EFFECTIVE_DATE];
                                    insuranceInfo[DBEscrowServicing.EXPIRATION_DATE] = row[DBEscrowServicing.EXPIRATION_DATE];
                                    insuranceInfo[DBEscrowServicing.COVERAGE_AMOUNT] = row[DBEscrowServicing.COVERAGE_AMOUNT];
                                    insuranceInfo[DBEscrowServicing.YEARLY_PREMIUM] = row[DBEscrowServicing.YEARLY_PREMIUM];
                                    insuranceInfo[DBEscrowServicing.AGENCY_NAME] = row[DBEscrowServicing.AGENCY_NAME];
                                    insuranceInfo[DBEscrowServicing.AGENCY_PHONE_NUMBER] = row[DBEscrowServicing.AGENCY_PHONE_NUMBER];
                                    insuranceInfo[DBEscrowServicing.INSURANCE_COMPANY_CITY] = row[DBEscrowServicing.INSURANCE_COMPANY_CITY];
                                    insuranceInfo[DBEscrowServicing.INSURANCE_COMPANY_NAME] = row[DBEscrowServicing.INSURANCE_COMPANY_NAME];
                                    insuranceInfo[DBEscrowServicing.INSURANCE_COMPANY_PHONE] = row[DBEscrowServicing.INSURANCE_COMPANY_PHONE];
                                    insuranceInfo[DBEscrowServicing.INSURANCE_COMPANY_STATE] = row[DBEscrowServicing.INSURANCE_COMPANY_STATE];
                                    insuranceInfo[DBEscrowServicing.INSURANCE_COMPANY_STREET] = row[DBEscrowServicing.INSURANCE_COMPANY_STREET];
                                    insuranceInfo[DBEscrowServicing.INSURANCE_COMPANY_ZIP] = row[DBEscrowServicing.INSURANCE_COMPANY_ZIP];
                                    insuranceInfo[DBEscrowServicing.DUE_DATE] = row[DBEscrowServicing.DUE_DATE];
                                    insuranceInfo[DBEscrowServicing.PAID_IND] = row[DBEscrowServicing.PAID_IND];
  
                                    insuranceInfo[DBEscrowServicing.LAST_CHANGE_EMPLOYEE_KEY] = taxUserData.EmployeeKey;
                                    insuranceInfo[DBEscrowServicing.CUSHION_MONTHS] = statementsData.InsuranceCushionMonths;
  
                                    // If this item does not exist, insert
                                    if (row[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].ToString() == "0")
                                    {
                                        int newLssLineKey =
                                            DBEscrowServicing.CreateInsuranceLine(insuranceInfo);
  
                                        // Update the session data
                                        ((DataTable)Session["InsGridSource"]).Rows.Find("0").SetField(
                                            DBEscrowServicing.LSS_INSURANCE_LINE_KEY, newLssLineKey.ToString());
                                        Session["SavedCorrectly"] = "True";
                                    }
                                    // Else update
                                    else
                                    {
                                        DBEscrowServicing.UpdateInsuranceLine(insuranceInfo);
                                        Session["SavedCorrectly"] = "True";
                                    }
                                }
                                else
                                {
                                    Session["SavedCorrectly"] = "False";
                                }
                            }
                        }
                        LoadData();
                    }
                    else
                    {
                        Session["SavedCorrectly"] = "False";
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(
                    "Exception in SaveData " + ex.Message);
            }
        }
  
        internal override void LoadData()
        {
            BorrowerData borrowerData = new BorrowerData();
            InsuranceData insuranceData = new InsuranceData();
  
            lblCustName3.Text =
                borrowerData.MortgagorLastName + ", " + borrowerData.MortgagorFirstName;
  
            if (insuranceData.InsuranceDataTable.Rows.Count > 0)
            {
                rdInsLines.DataSource = insuranceData.InsuranceDataTable;
                rdInsLines.DataBind();
                divInsGrid.Style["display"] = "";
            }
            else
            {
                rdInsLines.DataSource = insuranceData.InsuranceDataTable;
                rdInsLines.DataBind();
                divInsGrid.Style["display"] = "none";
            }
        }
  
        protected void rdInsLines_ItemCommand(object source, GridCommandEventArgs e)
        {
            GridDataItem dataItem = e.Item as GridDataItem;
            loanData = new LoanData();
            if (e.CommandName == RadGrid.ExpandCollapseCommandName)
            {
                ((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").Visible = !e.Item.Expanded;
  
                if (!e.Item.Expanded)
                {
                    RadComboBox StateList = (RadComboBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("ddInsState");
                    StateList.DataSource = Session["StateList"];
                    StateList.DataTextField = "STATE_ABBREVIATION";
                    StateList.DataValueField = "STATE_ABBREVIATION";
                    StateList.DataBind();
  
                    RadComboBox InsuranceList = (RadComboBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("ddInsuranceTypes");
                    InsuranceList.DataSource = Session["InsuranceList"];
                    InsuranceList.DataTextField = "MDESC";
                    InsuranceList.DataValueField = "TYPE";
                    InsuranceList.DataBind();
  
                    RadComboBox InsuranceType = (RadComboBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("ddInsuranceTypes");
                    InsuranceType.SelectedValue = dataItem["LSS_INSURANCE_TYPE"].Text;
  
                    if (dataItem["LSS_INSURANCE_LINE_KEY"].Text == "0")
                        InsuranceType.Enabled = true;
                    else
                        InsuranceType.Enabled = false;
  
                    LoadNestedView(dataItem["LSS_INSURANCE_TYPE"].Text, dataItem, e);
  
                    RadTextBox PolicyNumber = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtPolicyNumber");
                      
                    if (InsuranceType.Enabled == true)
                        InsuranceType.Focus();
                    else
                        PolicyNumber.Focus();
                }
                else
                {
  
                    RadComboBox InsuranceType = (RadComboBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("ddInsuranceTypes");
                    dataItem["LSS_INSURANCE_TYPE"].Text = InsuranceType.SelectedValue;
  
                    RadComboBox InsuranceDesc = (RadComboBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("ddInsuranceTypes");
                    dataItem["INSURANCE_TYPE_MDESC"].Text = InsuranceDesc.Text;
  
                    RadTextBox PolicyNumber = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtPolicyNumber");
                    dataItem["POLICY_NUMBER"].Text = PolicyNumber.Text;
  
                    RadTextBox InsuranceCo = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtInsCompany");
                    dataItem["INSURANCE_COMPANY_NAME"].Text = InsuranceCo.Text;
  
                    RadDatePicker dtDueDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdDueDate");
                    dataItem["DUE_DATE"].Text = String.Format("{0:d}", dtDueDate.SelectedDate);
  
                    RadComboBox Status = (RadComboBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("cboStatus");
                    dataItem["PAID_IND"].Text = Status.Text;
  
                    if ((InsuranceType.SelectedValue != "998") && (InsuranceType.SelectedValue != "999"))
                    {
                        RadDatePicker EffectiveDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdEffectiveDate");
                        dataItem["EFFECTIVE_DATE"].Text = String.Format("{0:d}", EffectiveDate.SelectedDate);
  
                        dataItem[DBEscrowServicing.PAYMENTS_PER_YEAR].Text = "1";
  
                        RadDatePicker ExpDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdExpirationDate");
                        dataItem["EXPIRATION_DATE"].Text = String.Format("{0:d}", ExpDate.SelectedDate);
  
                        RadNumericTextBox YearlyPremium = (RadNumericTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtYearlyPremium");
                        if (YearlyPremium.Text != "")
                        {
                            Decimal decimalVal = System.Convert.ToDecimal(YearlyPremium.Text);
                            String payment = String.Format("{0:C}", decimalVal);
                            dataItem["YEARLY_PREMIUM"].Text = payment;
                        }
                        else
                        {
                            dataItem["YEARLY_PREMIUM"].Text = "";
                        }
                    }
                    else
                    {
                        RadDatePicker PMIEffectiveDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdPMIEffectiveDate");
                        dataItem["EFFECTIVE_DATE"].Text = String.Format("{0:d}", PMIEffectiveDate.SelectedDate);
  
                        if (PMIEffectiveDate.SelectedDate != null)
                        {
                            DateTime effDate = (DateTime)PMIEffectiveDate.SelectedDate;
                            DateTime fpddDate = (DateTime)Convert.ToDateTime(loanData.FirstPaymentDueDate);
  
                            if (effDate.Date < fpddDate.Date)
                                effDate = fpddDate;
  
                            TimeSpan diffDate = fpddDate.AddMonths(12).Subtract(effDate);
  
                            int months = (diffDate.Days / 30);
  
                            if (months <= 0)
                                months = 12;
  
                            dataItem[DBEscrowServicing.PAYMENTS_PER_YEAR].Text = months.ToString();
                        }
                        else
                            dataItem[DBEscrowServicing.PAYMENTS_PER_YEAR].Text = "0";
  
  
                        RadNumericTextBox MonthlyPremium = (RadNumericTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtMonthlyPremium");
                        if (MonthlyPremium.Text != "")
                        {
                            Decimal decimalVal = System.Convert.ToDecimal(MonthlyPremium.Text);
                            String payment = String.Format("{0:C}", decimalVal);
                            dataItem["YEARLY_PREMIUM"].Text = payment;
                        }
                        else
                        {
                            dataItem["YEARLY_PREMIUM"].Text = "";
                        }
                    }
  
                    RadTextBox InsuranceStreet = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtInsAddress");
                    dataItem["INSURANCE_COMPANY_STREET"].Text = InsuranceStreet.Text;
  
                    RadTextBox InsuranceCity = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtInsCity");
                    dataItem["INSURANCE_COMPANY_CITY"].Text = InsuranceCity.Text;
  
                    RadComboBox InsuranceState = (RadComboBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("ddInsState");
                    dataItem["INSURANCE_COMPANY_STATE"].Text = InsuranceState.SelectedValue;
  
                    RadNumericTextBox CoverageAmount = (RadNumericTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtCoverageAmount");
                    if (CoverageAmount.Text != "")
                    {
                        Decimal decimalVal1 = System.Convert.ToDecimal(CoverageAmount.Text);
                        String payment1 = String.Format("{0:C}", decimalVal1);
                        dataItem["COVERAGE_AMOUNT"].Text = payment1;
                    }
                    else
                    {
                        dataItem["COVERAGE_AMOUNT"].Text = "";
                    }
  
                    RadMaskedTextBox InsuranceZip = (RadMaskedTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtInsZip");
                    dataItem["INSURANCE_COMPANY_ZIP"].Text = InsuranceZip.Text;
  
                    RadMaskedTextBox InsurancePhone = (RadMaskedTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtInsPhone");
                    dataItem["INSURANCE_COMPANY_PHONE"].Text = InsurancePhone.Text;
  
                    RadTextBox AgencyName = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtAgencyName");
                    dataItem["AGENCY_NAME"].Text = AgencyName.Text;
  
                    RadMaskedTextBox AgencyPhone = (RadMaskedTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtAgencyPhone");
                    dataItem["AGENCY_PHONE_NUMBER"].Text = AgencyPhone.Text;
  
                }
            }
            if (e.CommandName == "Delete")
            {
                //DELETE Ins LINE
                if (dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text != "")
                {
                    int insLineKey = Convert.ToInt32(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text);
  
                    DBEscrowServicing.DeleteInsuranceLine(insLineKey, taxUserData.EmployeeKey);
  
                    Session["SavedCorrectly"] = true;
  
                    //insuranceData = new InsuranceData();
  
                    //insuranceData.InsuranceDataTable.Rows.Find(insLineKey).Delete();
                    Session["InsGridSource"] = DBEscrowServicing.GetInsLines(Session["CurrentLender"].ToString(), loanData.LoanNumber.ToString());
  
                    InsuranceData insuranceData = new InsuranceData();
  
                    // Update the Session data object
                    //Session["InsGridSource"] = insuranceData.InsuranceDataTable;
                    LoadData();
                }
            }
  
            if (e.CommandName == "Custom")
            {
                RadComboBox StateList = (RadComboBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("ddInsState");
                StateList.DataSource = Session["StateList"];
                StateList.DataTextField = "STATE_ABBREVIATION";
                StateList.DataValueField = "STATE_ABBREVIATION";
                StateList.DataBind();
  
                if (dataItem["LSS_INSURANCE_LINE_KEY"].Text == "0")
                {
  
                    Label InsName = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label30");
                    InsName.Visible = true;
  
                    Label InsAddress = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label25");
                    InsAddress.Visible = true;
  
                    Label InsCity = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label26");
                    InsCity.Visible = true;
  
                    Label InsState = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label29");
                    InsState.Visible = true;
  
                    Label InsZip = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label31");
                    InsZip.Visible = true;
  
                    Label InsPhone = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label32");
                    InsPhone.Visible = true;
  
                    Label InsCo = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label18");
                    InsCo.Visible = true;
  
                    Label Policy = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label24");
                    Policy.Visible = true;
  
                    Label PolicyNo = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label19");
                    PolicyNo.Visible = true;
  
                    RadTextBox InsuranceCo = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtInsCompany");
                    Label lblErrorCompany = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblErrorCompany");
                    InsuranceCo.Visible = true;
                    InsuranceCo.Text = "";
                    lblErrorCompany.Text = "";
  
                    RadTextBox InsuranceStreet = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtInsAddress");
                    InsuranceStreet.Visible = true;
                    InsuranceStreet.Text = "";
  
                    RadTextBox InsuranceCity = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtInsCity");
                    InsuranceCity.Visible = true;
                    InsuranceCity.Text = "";
  
                    RadComboBox InsuranceState = (RadComboBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("ddInsState");
                    InsuranceState.Visible = true;
                    InsuranceState.SelectedValue = "";
  
                    RadMaskedTextBox InsuranceZip = (RadMaskedTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtInsZip");
                    Label lblZipCode = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblZipError");
                    InsuranceZip.Visible = true;
                    InsuranceZip.Text = "";
                    lblZipCode.Text = "";
  
                    RadMaskedTextBox InsurancePhone = (RadMaskedTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtInsPhone");
                    Label lblErrorPhone = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblErrorPhone");
                    InsurancePhone.Visible = true;
                    InsurancePhone.Text = "";
                    lblErrorPhone.Text = "";
  
                    RadTextBox PolicyNumber = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtPolicyNumber");
                    PolicyNumber.Visible = true;
                    PolicyNumber.Text = "";
  
                    Label lblErrorYearly = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblErrorYearly");
                    lblErrorYearly.Text = "";
  
                    Label lblEffectiveDate = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblEffectiveDate");
                    lblEffectiveDate.Text = "";
  
                    Label lblErrorExpDate2 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblErrorExpDate2");
                    lblErrorExpDate2.Text = "";
  
                    Label lblErrorExpDate = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblErrorExpDate");
                    lblErrorExpDate.Text = "";
  
                    Label lblAgencyPhone = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblAgencyPhone");
                    lblAgencyPhone.Text = "";
  
                    Label lblPMIEffectiveDate = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblEffectiveDate");
                    lblPMIEffectiveDate.Text = "";
  
                    RadDatePicker DueDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdDueDate");
                    DueDate.Visible = true;
                    DueDate.SelectedDate = null;
  
                    if ((dataItem["LSS_INSURANCE_TYPE"].Text != "998") && (dataItem["LSS_INSURANCE_TYPE"].Text != "999"))
                    {
  
                        Label Label33 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label33");
                        Label33.Visible = true;
  
                        Label Label34 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label34");
                        Label34.Visible = true;
  
                        Label Label44 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label44");
                        Label44.Visible = true;
  
                        Label Label51 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label51");
                        Label51.Visible = true;
  
                        Label Label39 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label39");
                        Label39.Visible = true;
  
                        Label Label42 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label42");
                        Label42.Visible = true;
  
                        RadTextBox AgencyName = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtAgencyName");
                        AgencyName.Visible = true;
                        AgencyName.Text = "";
  
                        RadMaskedTextBox AgencyPhone = (RadMaskedTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtAgencyPhone");
                        AgencyPhone.Visible = true;
                        AgencyPhone.Text = "";
  
                        RadDatePicker EffectiveDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdEffectiveDate");
                        EffectiveDate.Visible = true;
                        EffectiveDate.SelectedDate = null;
  
                        RadDatePicker ExpirationDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdExpirationDate");
                        ExpirationDate.Visible = true;
                        ExpirationDate.SelectedDate = null;
  
                        RadNumericTextBox CoverageAmount = (RadNumericTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtCoverageAmount");
                        CoverageAmount.Visible = true;
                        CoverageAmount.Text = "";
  
                        RadDatePicker ExpDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdExpirationDate");
                        ExpDate.Visible = true;
                        ExpDate.SelectedDate = null;
  
                        RadNumericTextBox YearlyPremium = (RadNumericTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtYearlyPremium");
                        YearlyPremium.Visible = true;
                        YearlyPremium.Text = "";
  
                        Label MonAmount = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label43");
                        MonAmount.Visible = false;
  
                        Label Label49 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label49");
                        Label49.Visible = false;
  
                        RadNumericTextBox MonthlyAmount = (RadNumericTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtMonthlyPremium");
                        MonthlyAmount.Visible = false;
  
                        RadDatePicker PMIEffectiveDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdPMIEffectiveDate");
                        PMIEffectiveDate.Visible = false;
  
                    }
                    else
                    {
  
                        Label Label33 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label33");
                        Label33.Visible = false;
  
                        Label Label34 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label34");
                        Label34.Visible = false;
  
                        Label Label44 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label44");
                        Label44.Visible = false;
  
                        Label Label51 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label51");
                        Label51.Visible = false;
  
                        Label Label39 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label39");
                        Label39.Visible = false;
  
                        Label Label42 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label42");
                        Label42.Visible = false;
  
                        RadTextBox AgencyName = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtAgencyName");
                        AgencyName.Visible = false;
  
                        RadMaskedTextBox AgencyPhone = (RadMaskedTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtAgencyPhone");
                        AgencyPhone.Visible = false;
  
                        RadDatePicker EffectiveDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdEffectiveDate");
                        EffectiveDate.Visible = false;
  
                        RadDatePicker ExpirationDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdExpirationDate");
                        ExpirationDate.Visible = false;
  
                        RadNumericTextBox CoverageAmount = (RadNumericTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtCoverageAmount");
                        CoverageAmount.Visible = false;
  
                        RadNumericTextBox YearlyPremium = (RadNumericTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtYearlyPremium");
                        YearlyPremium.Visible = false;
  
                        Label MonAmount = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label43");
                        MonAmount.Visible = true;
  
                        Label Label49 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label49");
                        Label49.Visible = true;
  
                        RadNumericTextBox MonthlyAmount = (RadNumericTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtMonthlyPremium");
                        MonthlyAmount.Visible = true;
                        MonthlyAmount.Text = "";
  
                        RadDatePicker PMIEffectiveDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdPMIEffectiveDate");
                        PMIEffectiveDate.Visible = true;
                        PMIEffectiveDate.SelectedDate = null;
                    }
  
                    Session["LSS_INS_TYPE"] = dataItem["LSS_INSURANCE_TYPE"].Text;
                    //LoadNestedView(dataItem["LSS_INSURANCE_TYPE"].Text, dataItem, e);
                    RadComboBox InsuranceType = (RadComboBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("ddInsuranceTypes");
                    if (InsuranceType.Enabled == true)
                        InsuranceType.Focus();
                    else
                        PolicyNumber.Focus();
                }
            }
            if (e.CommandName == "Validate")
            {
                int rowCount = 0;
  
                ((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").Visible = !e.Item.Expanded;
  
                LoadNestedView(dataItem["LSS_INSURANCE_TYPE"].Text, dataItem, e);
  
                //LinkButton button = dataItem["InsEdit"].Controls[0] as LinkButton;
                //button.Text = "Edit";
  
                RadTextBox InsuranceCo = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtInsCompany");
                Label lblErrorCompany = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblErrorCompany");
                if (InsuranceCo.Text == "")
                {
                    lblErrorCompany.Text = "*Required";
                    errorCount += 1;
                    rowCount += 1;
                }
                else
                {
                    lblErrorCompany.Text = "";
                }
  
                RadMaskedTextBox InsPhone = (RadMaskedTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtInsPhone");
                Label lblErrorPhone = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblErrorPhone");
                if (InsPhone.Text.Length > 0)
                {
                    if (InsPhone.Text.Length < 10)
                    {
                        lblErrorPhone.Text = "*Must be ten digits";
                        errorCount += 1;
                        rowCount += 1;
                    }
                    else
                    {
                        lblErrorPhone.Text = "";
                    }
                }
                else
                    lblErrorPhone.Text = "";
  
                RadMaskedTextBox ZipCode = (RadMaskedTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtInsZip");
                Label lblZipCode = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblZipError");
                if (ZipCode.Text.Length > 0)
                {
                    if (ZipCode.Text.Length < 5)
                    {
                        lblZipCode.Text = "*Minimum 5 digits";
                        errorCount += 1;
                        rowCount += 1;
                    }
                    else
                    {
                        //string zipCode = ZipCode.TextWithPrompt.Substring(0, 5).Replace("_", "").ToString();
                        //if (zipCode.Length < 5)
                        //{
                        //    lblZipCode.Text = "*Invalid Zip Code";
                        //    errorCount += 1;
                        //    rowCount += 1;
                        //}
                        //else
                        lblZipCode.Text = "";
                    }
                }
                else
                    lblZipCode.Text = "";
  
                RadComboBox InsuranceType = (RadComboBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("ddInsuranceTypes");
                InsuranceType.SelectedValue = dataItem["LSS_INSURANCE_TYPE"].Text;
  
                if ((InsuranceType.SelectedValue != "998") && (InsuranceType.SelectedValue != "999"))
                {
                    RadNumericTextBox YearlyPremium = (RadNumericTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtYearlyPremium");
                    Label lblErrorYearly = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblErrorYearly");
                    if ((YearlyPremium.Text == "") || (YearlyPremium.Text == "0"))
                    {
                        lblErrorYearly.Text = "*Required";
                        errorCount += 1;
                        rowCount += 1;
                    }
                    else
                    {
                        lblErrorYearly.Text = "";
                    }
  
                    RadDatePicker EffectiveDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdEffectiveDate");
                    Label lblEffectiveDate = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblEffectiveDate");
                    if (EffectiveDate.SelectedDate.ToString() == "")
                    {
                        lblEffectiveDate.Text = "*Required";
                        errorCount += 1;
                        rowCount += 1;
                    }
                    else
                    {
                        DateTime now = DateTime.Now;
                       
                        if (Convert.ToDateTime(EffectiveDate.SelectedDate) < now.Date.AddYears(-1))
                        {
                            lblEffectiveDate.Text = "Date cannot be more than one year in the past.";
                            errorCount += 1;
                            rowCount += 1;
                        }
                        else
                        {
                            lblEffectiveDate.Text = "";
                        }
                    }
  
                    RadDatePicker ExpirationDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdExpirationDate");
                    Label lblErrorExpDate2 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblErrorExpDate2");
                    if (ExpirationDate.SelectedDate.ToString() == "")
                    {
                        lblErrorExpDate2.Text = "*Required";
                        errorCount += 1;
                        rowCount += 1;
                    }
                    else
                    {
                        if (EffectiveDate.SelectedDate.ToString() != "")
                        {
                            if (Convert.ToDateTime(ExpirationDate.SelectedDate) > Convert.ToDateTime(EffectiveDate.SelectedDate).AddYears(+1))
                            {
                                lblErrorExpDate2.Text = "Cannot be more than one year past the Effective Date.";
                                errorCount += 1;
                                rowCount += 1;
                            }
                            else
                            {
                                lblErrorExpDate2.Text = "";
                            }
                        }
                        else
                        {
                            lblErrorExpDate2.Text = "";
                        }
                    }
  
                    Label lblErrorExpDate = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblErrorExpDate");
                    if ((ExpirationDate.SelectedDate.ToString() != "") && (EffectiveDate.SelectedDate.ToString() != ""))
                    {
                        if ((Convert.ToDateTime(EffectiveDate.SelectedDate) > Convert.ToDateTime(ExpirationDate.SelectedDate)))
                        {
                            lblErrorExpDate.Text = "Effective Date cannot be greater than Expiration Date.";
                            errorCount += 1;
                            rowCount += 1;
                        }
                        else
                        {
                            lblErrorExpDate.Text = "";
                        }
                    }
  
                    RadMaskedTextBox AgencyPhone = (RadMaskedTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtAgencyPhone");
                    Label lblAgencyPhone = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblAgencyPhone");
                    if (AgencyPhone.Text.Length > 0)
                    {
                        if (AgencyPhone.Text.Length < 10)
                        {
                            lblAgencyPhone.Text = "*Must be ten digits.";
                            errorCount += 1;
                            rowCount += 1;
                        }
                        else
                        {
                            lblAgencyPhone.Text = "";
                        }
                    }
                    else
                        lblAgencyPhone.Text = "";
                }
                else
                {
                    RadNumericTextBox YearlyPremium = (RadNumericTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtMonthlyPremium");
                    Label lblPMIEffectiveDate = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblEffectiveDate");
                     
                    if ((YearlyPremium.Text == "") || (YearlyPremium.Text == "0"))
                    {
                        lblPMIEffectiveDate.Text = "*Required";
                        errorCount += 1;
                        rowCount += 1;
                    }
                    else
                    {
                        lblPMIEffectiveDate.Text = "";
                    }
  
                    RadDatePicker PMIFPDD = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdPMIEffectiveDate");
                    Label lblErrorExpDate = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblErrorExpDate");
                    if (PMIFPDD.SelectedDate.ToString() == "")
                    {
                        lblErrorExpDate.Text = "*Required";
                        errorCount += 1;
                        rowCount += 1;
                    }
                    else
                    {
                        lblErrorExpDate.Text = "";
                    }
  
                }
  
                if (rowCount != 0)
                    dataItem.FireCommandEvent("ExpandCollapse", String.Empty);
            }
        }
  
  
        protected void btnAddIns_onClick(object sender, EventArgs e)
        {
            try
            {
                SaveData();
  
                insuranceData = new InsuranceData();
  
                if (Session["SavedCorrectly"].ToString() == "True")
                {
                    divInsGrid.Style["display"] = "";
                    DataTable insList = insuranceData.InsuranceDataTable;
  
                    //Add a new row
                    DataRow newRow = insList.NewRow();
  
                    newRow[DBEscrowServicing.LENDER_NUMBER] = Session["CurrentLender"].ToString();
                    newRow[DBEscrowServicing.LOAN_NUMBER] = Session["LOAN_NUMBER"];
                    newRow[DBEscrowServicing.LSS_INSURANCE_TYPE] = "351";
                    Session["LSS_INS_TYPE"] = "351";
                    newRow[DBEscrowServicing.LSS_INSURANCE_LINE_KEY] = 0;
  
                    insList.Rows.Add(newRow);
                    rdInsLines.DataSource = insList;
                    rdInsLines.DataBind();
                    Session["InsGridSource"] = rdInsLines.DataSource;
                    foreach (GridItem item in rdInsLines.MasterTableView.Controls[0].Controls)
                    {
                        if (item is GridDataItem)
                        {
                            GridDataItem dataItem = (GridDataItem)item;
                            if (dataItem["LSS_INSURANCE_LINE_KEY"].Text == "0")
                            {
                                item.FireCommandEvent("ExpandCollapse", String.Empty);
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(
                    "Exception in btnAddIns_onClick " + ex.Message);
            }
        }
  
        protected void rdInsLines_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
        {
            rdInsLines.DataSource = Session["InsGridSource"] as DataTable;
        }
  
        internal override bool ValidateData()
        {
            insuranceData = new InsuranceData();
  
            foreach (GridItem item in rdInsLines.MasterTableView.Controls[0].Controls)
            {
                if (item is GridDataItem)
                {
                    if (item.Expanded)
                    {
                        item.FireCommandEvent("ExpandCollapse", String.Empty);
                    }
  
                    item.FireCommandEvent("Validate", String.Empty);
  
  
                    GridDataItem dataItem = (GridDataItem)item;
  
                    insuranceData.InsuranceDataTable.Rows.Find(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text).SetField(
                            DBEscrowServicing.LSS_INSURANCE_TYPE, dataItem[DBEscrowServicing.LSS_INSURANCE_TYPE].Text);
  
                    insuranceData.InsuranceDataTable.Rows.Find(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text).SetField(
                        DBEscrowServicing.INSURANCE_TYPE_MDESC, dataItem[DBEscrowServicing.INSURANCE_TYPE_MDESC].Text);
  
  
                    insuranceData.InsuranceDataTable.Rows.Find(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text).SetField(
                        DBEscrowServicing.POLICY_NUMBER, dataItem[DBEscrowServicing.POLICY_NUMBER].Text);
  
                    insuranceData.InsuranceDataTable.Rows.Find(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text).SetField(
                        DBEscrowServicing.PAYMENTS_PER_YEAR, dataItem[DBEscrowServicing.PAYMENTS_PER_YEAR].Text);
  
                    insuranceData.InsuranceDataTable.Rows.Find(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text).SetField(
                        DBEscrowServicing.EFFECTIVE_DATE, dataItem[DBEscrowServicing.EFFECTIVE_DATE].Text);
  
                    insuranceData.InsuranceDataTable.Rows.Find(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text).SetField(
                        DBEscrowServicing.DUE_DATE, dataItem[DBEscrowServicing.DUE_DATE].Text);
  
                    insuranceData.InsuranceDataTable.Rows.Find(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text).SetField(
                        DBEscrowServicing.PAID_IND, dataItem[DBEscrowServicing.PAID_IND].Text);
  
                    insuranceData.InsuranceDataTable.Rows.Find(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text).SetField(
                        DBEscrowServicing.EXPIRATION_DATE, dataItem[DBEscrowServicing.EXPIRATION_DATE].Text);
  
                    insuranceData.InsuranceDataTable.Rows.Find(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text).SetField(
                        DBEscrowServicing.COVERAGE_AMOUNT, dataItem[DBEscrowServicing.COVERAGE_AMOUNT].Text);
  
                    insuranceData.InsuranceDataTable.Rows.Find(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text).SetField(
                        DBEscrowServicing.YEARLY_PREMIUM, dataItem[DBEscrowServicing.YEARLY_PREMIUM].Text);
  
                    insuranceData.InsuranceDataTable.Rows.Find(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text).SetField(
                        DBEscrowServicing.AGENCY_NAME, dataItem[DBEscrowServicing.AGENCY_NAME].Text);
  
                    insuranceData.InsuranceDataTable.Rows.Find(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text).SetField(
                        DBEscrowServicing.AGENCY_PHONE_NUMBER, dataItem[DBEscrowServicing.AGENCY_PHONE_NUMBER].Text);
  
                    insuranceData.InsuranceDataTable.Rows.Find(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text).SetField(
                        DBEscrowServicing.INSURANCE_COMPANY_CITY, dataItem[DBEscrowServicing.INSURANCE_COMPANY_CITY].Text);
  
                    insuranceData.InsuranceDataTable.Rows.Find(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text).SetField(
                        DBEscrowServicing.INSURANCE_COMPANY_NAME, dataItem[DBEscrowServicing.INSURANCE_COMPANY_NAME].Text);
  
                    insuranceData.InsuranceDataTable.Rows.Find(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text).SetField(
                        DBEscrowServicing.INSURANCE_COMPANY_PHONE, dataItem[DBEscrowServicing.INSURANCE_COMPANY_PHONE].Text);
  
                    insuranceData.InsuranceDataTable.Rows.Find(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text).SetField(
                        DBEscrowServicing.INSURANCE_COMPANY_STATE, dataItem[DBEscrowServicing.INSURANCE_COMPANY_STATE].Text);
  
                    insuranceData.InsuranceDataTable.Rows.Find(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text).SetField(
                        DBEscrowServicing.INSURANCE_COMPANY_STREET, dataItem[DBEscrowServicing.INSURANCE_COMPANY_STREET].Text);
  
                    insuranceData.InsuranceDataTable.Rows.Find(dataItem[DBEscrowServicing.LSS_INSURANCE_LINE_KEY].Text).SetField(
                        DBEscrowServicing.INSURANCE_COMPANY_ZIP, dataItem[DBEscrowServicing.INSURANCE_COMPANY_ZIP].Text);
  
                }
            }
            // Update the Session data
            Session["InsGridSource"] = insuranceData.InsuranceDataTable;
  
            if (errorCount == 0)
            {
                lblInsuranceError.Visible = false;
                return true;
            }
            else
            {
                lblInsuranceError.Visible = true;
                return false;
            }
  
        }
  
        private void LoadNestedView(String InsType, GridDataItem dataItem, GridCommandEventArgs e)
        {
            Label InsName = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label30");
            InsName.Visible = true;
  
            Label InsAddress = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label25");
            InsAddress.Visible = true;
  
            Label InsCity = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label26");
            InsCity.Visible = true;
  
            Label InsState = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label29");
            InsState.Visible = true;
  
            Label InsZip = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label31");
            InsZip.Visible = true;
  
            Label InsPhone = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label32");
            InsPhone.Visible = true;
  
            Label InsCo = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label18");
            InsCo.Visible = true;
  
            Label Policy = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label24");
            Policy.Visible = true;
  
            Label PolicyNo = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label19");
            PolicyNo.Visible = true;
  
            Label DueDate = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblDueDate");
            DueDate.Visible = true;
  
            Label lblStatus = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("lblStatus");
            lblStatus.Visible = true;
  
            RadTextBox InsuranceCo = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtInsCompany");
            InsuranceCo.Visible = true;
            InsuranceCo.Text = dataItem["INSURANCE_COMPANY_NAME"].Text;
  
            RadTextBox InsuranceStreet = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtInsAddress");
            InsuranceStreet.Visible = true;
            InsuranceStreet.Text = dataItem["INSURANCE_COMPANY_STREET"].Text;
  
            RadTextBox InsuranceCity = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtInsCity");
            InsuranceCity.Visible = true;
            InsuranceCity.Text = dataItem["INSURANCE_COMPANY_CITY"].Text;
  
            RadComboBox InsuranceState = (RadComboBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("ddInsState");
            InsuranceState.Visible = true;
            InsuranceState.SelectedValue = dataItem["INSURANCE_COMPANY_STATE"].Text;
  
            RadMaskedTextBox InsuranceZip = (RadMaskedTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtInsZip");
            InsuranceZip.Visible = true;
            InsuranceZip.Text = dataItem["INSURANCE_COMPANY_ZIP"].Text;
  
            RadMaskedTextBox InsurancePhone = (RadMaskedTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtInsPhone");
            InsurancePhone.Visible = true;
            InsurancePhone.Text = dataItem["INSURANCE_COMPANY_PHONE"].Text;
  
            RadTextBox PolicyNumber = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtPolicyNumber");
            PolicyNumber.Visible = true;
            PolicyNumber.Text = dataItem["POLICY_NUMBER"].Text;
  
            RadDatePicker dtDueDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdDueDate");
            dtDueDate.Visible = true;
            if ((dataItem["DUE_DATE"].Text != "") && (dataItem["DUE_DATE"].Text != ""))
                dtDueDate.SelectedDate = Convert.ToDateTime(dataItem["DUE_DATE"].Text.ToString());
  
  
            RadComboBox Status = (RadComboBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("cboStatus");
            Status.Visible = true;
            Status.SelectedValue = dataItem["PAID_IND"].Text;
  
            if ((InsType != "998") && (InsType != "999"))
            {
                Label Label33 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label33");
                Label33.Visible = true;
  
                Label Label34 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label34");
                Label34.Visible = true;
  
                Label Label44 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label44");
                Label44.Visible = true;
  
                Label Label51 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label51");
                Label51.Visible = true;
  
                Label Label39 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label39");
                Label39.Visible = true;
  
                Label Label42 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label42");
                Label42.Visible = true;
  
                RadTextBox AgencyName = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtAgencyName");
                AgencyName.Visible = true;
                AgencyName.Text = dataItem["AGENCY_NAME"].Text;
  
                RadMaskedTextBox AgencyPhone = (RadMaskedTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtAgencyPhone");
                AgencyPhone.Visible = true;
                AgencyPhone.Text = dataItem["AGENCY_PHONE_NUMBER"].Text;
  
                RadDatePicker EffectiveDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdEffectiveDate");
                EffectiveDate.Visible = true;
                if (dataItem["EFFECTIVE_DATE"].Text != "")
                    EffectiveDate.SelectedDate = Convert.ToDateTime(dataItem["EFFECTIVE_DATE"].Text.ToString());
  
                RadDatePicker ExpirationDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdExpirationDate");
                ExpirationDate.Visible = true;
                if ((dataItem["EXPIRATION_DATE"].Text != "") && (dataItem["EXPIRATION_DATE"].Text != ""))
                    ExpirationDate.SelectedDate = Convert.ToDateTime(dataItem["EXPIRATION_DATE"].Text.ToString());
  
                RadNumericTextBox CoverageAmount = (RadNumericTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtCoverageAmount");
                String amount = dataItem["COVERAGE_AMOUNT"].Text.Replace("$", "");
                CoverageAmount.Visible = true;
                if (amount != "")
                    CoverageAmount.Text = amount;
  
                RadNumericTextBox YearlyPremium = (RadNumericTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtYearlyPremium");
                String amount2 = dataItem["YEARLY_PREMIUM"].Text.Replace("$", "");
                YearlyPremium.Visible = true;
                if (amount2 != "")
                    YearlyPremium.Text = amount2;
  
                Label MonAmount = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label43");
                MonAmount.Visible = false;
  
                Label Label49 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label49");
                Label49.Visible = false;
  
                RadNumericTextBox MonthlyAmount = (RadNumericTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtMonthlyPremium");
                MonthlyAmount.Visible = false;
  
                RadDatePicker PMIEffectiveDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdPMIEffectiveDate");
                PMIEffectiveDate.Visible = false;
  
            }
            else
            {
                Label Label33 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label33");
                Label33.Visible = false;
  
                Label Label34 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label34");
                Label34.Visible = false;
  
                Label Label44 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label44");
                Label44.Visible = false;
  
                Label Label51 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label51");
                Label51.Visible = false;
  
                Label Label39 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label39");
                Label39.Visible = false;
  
                Label Label42 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label42");
                Label42.Visible = false;
  
                RadTextBox AgencyName = (RadTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtAgencyName");
                AgencyName.Visible = false;
  
                RadMaskedTextBox AgencyPhone = (RadMaskedTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtAgencyPhone");
                AgencyPhone.Visible = false;
  
                RadDatePicker EffectiveDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdEffectiveDate");
                EffectiveDate.Visible = false;
  
                RadDatePicker ExpirationDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdExpirationDate");
                ExpirationDate.Visible = false;
  
  
                RadNumericTextBox CoverageAmount = (RadNumericTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtCoverageAmount");
                CoverageAmount.Visible = false;
  
                RadNumericTextBox YearlyPremium = (RadNumericTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtYearlyPremium");
                YearlyPremium.Visible = false;
  
                Label MonAmount = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label43");
                MonAmount.Visible = true;
  
                Label Label49 = (Label)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("Label49");
                Label49.Visible = true;
  
                RadNumericTextBox MonthlyAmount = (RadNumericTextBox)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("txtMonthlyPremium");
                String amount = dataItem["YEARLY_PREMIUM"].Text.Replace("$", "");
                MonthlyAmount.Visible = true;
                if (amount != "")
                    MonthlyAmount.Text = amount;
  
                RadDatePicker PMIEffectiveDate = (RadDatePicker)((GridDataItem)e.Item).ChildItem.FindControl("InnerInsContainer").FindControl("rdPMIEffectiveDate");
                PMIEffectiveDate.Visible = true;
                if (dataItem["EFFECTIVE_DATE"].Text != "")
                    PMIEffectiveDate.SelectedDate = Convert.ToDateTime(dataItem["EFFECTIVE_DATE"].Text.ToString());
            }
        }
  
        protected void ddInsuranceTypes_SelectedIndexChanged(object o, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
        {
            foreach (GridItem item in rdInsLines.MasterTableView.Controls[0].Controls)
            {
                if (item is GridDataItem)
                {
                    if (item.Expanded)
                    {
                        GridDataItem dataItem = item as GridDataItem;
  
                        RadComboBox InsuranceType = (RadComboBox)(dataItem.ChildItem.FindControl("InnerInsContainer").FindControl("ddInsuranceTypes"));
                        dataItem["LSS_INSURANCE_TYPE"].Text = InsuranceType.SelectedValue;
                        item.FireCommandEvent("Custom", String.Empty);
                    }
                }
            }
        }
    }
}

 

 

 

Tsvetina
Telerik team
 answered on 03 Feb 2011
0 answers
74 views
hi team,

i found a solution to show all appointments in grid... i need to show current day events in grid...



also need to show the recurrence for current days +7 or -7 in another grid... !!!



can anyone help on this
ganesh
Top achievements
Rank 2
 asked on 03 Feb 2011
1 answer
146 views
Hi Telerik,
I need to achieve the fuction set_text like get_text.Because i append some text from database .That why i am asking.......
Thank you.
Rumen
Telerik team
 answered on 03 Feb 2011
1 answer
47 views
Hi;
I am using RADLIST BOX drag and drop functionality.
My question is how can I find which value User has selected to Drag from One list box to another
For Example:
I have one Listbox as ListBox1 which contains value India,SriLanka,USA etc.... How Can I find user has selected India to drag and drop
from ListBox1 to ListBox2  and viceversa.

From ListBox1 to ListBox2  If I fire sever side event "OnTransferred" then I can easily track the value but my question is IF the user drag and drop some value like India from ListBox2  to ListBox1 how can I find this Value

Please Reply ASAP it is very Urgent 
Princy
Top achievements
Rank 2
 answered on 03 Feb 2011
7 answers
139 views
Hi,
how to translate label ("Update", "Cancel") in pop-up of RadGrid:

http://img844.imageshack.us/img844/1816/przechwytywanietz.png

Thanks :)
Daniel
Telerik team
 answered on 03 Feb 2011
1 answer
75 views
Hi,

I have a radgrid, with a delete option as below:

<telerik:RadScriptManager ID="RadScriptManager1" runat="server"></telerik:RadScriptManager>   
    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="pnlMaster">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="pnlMaster" />
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManager>
  
  
<telerik:RadGrid ID="grdCompanyList"
                runat="server" GridLines="None"
                AutoGenerateColumns="False"
                AllowSorting="True"
                AllowFilteringByColumn = "True"
                AllowPaging="True"
                EnableLinqExpressions="False"
                PageSize="10"
                OnNeedDataSource="grdCompanyList_NeedDataSource"                
                OnItemDataBound="grdCompanyList_ItemDataBound"
                OnItemCommand = "grdCompanyList_ItemCommand">
                  
                <PagerStyle Mode="NextPrevAndNumeric"></PagerStyle>                                
                <MasterTableView DataKeyNames="watchlist_id" CommandItemDisplay="Top" EditMode="PopUp">
                <CommandItemSettings ShowAddNewRecordButton="false"/>
                <Columns>
  
                    <telerik:GridBoundColumn DataField="watchlist_id" DataType="System.Int32" 
                        HeaderText="watchlist_id" ReadOnly="True" SortExpression="watchlist_id" 
                        UniqueName="watchlist_id" Visible="false" >
                    </telerik:GridBoundColumn>
                      
                    <telerik:GridBoundColumn DataField="company_id" DataType="System.Int32" 
                        HeaderText="company_id" ReadOnly="True" SortExpression="company_id" 
                        UniqueName="company_id" Visible="false" >
                    </telerik:GridBoundColumn>
                      
                    <telerik:GridTemplateColumn AllowFiltering="false" ItemStyle-Width="180px">
                    <ItemTemplate>
                        <asp:Image width="142" height="58" ID="CompLogos" ImageUrl="<%# showCompLogo(Container.DataItem) %>"
                         runat="server" AlternateText="Logo" />
                    </ItemTemplate>
                    </telerik:GridTemplateColumn>
                      
                    <telerik:GridBoundColumn DataField="company_name"
                        HeaderText="Company name" SortExpression="company_name" ItemStyle-Width="450"
                        UniqueName="company_name" ReadOnly="true">
                        <ItemStyle Width="450px" />
                    </telerik:GridBoundColumn>                   
                    
                    <telerik:GridTemplateColumn AllowFiltering="false" ItemStyle-Width="150px" HeaderText="Actions">
                    <ItemTemplate>
                        <div>
                            <span style="padding:0 5px">
                                <asp:HyperLink ID="CoLink" runat="server" ImageUrl="~/images/viewicon_big.png"
                                ToolTip="View Details"></asp:HyperLink>
                            </span>
                            <span style="padding:0 5px">                                
                                <asp:ImageButton runat="server" ID="DelButton" ImageUrl="~/images/delete-32.png" ToolTip="Delete"
                                CausesValidation="false" CommandName="Delete" />
                            </span>
                        </div>                        
                    </ItemTemplate>
                    </telerik:GridTemplateColumn>
                </Columns>
                </MasterTableView>
                <ClientSettings EnableRowHoverStyle="true"></ClientSettings>
                </telerik:RadGrid>

The following is the delete code in c#:

protected void grdCompanyList_ItemCommand(object sender, GridCommandEventArgs e)
    {
        if (e.CommandName == RadGrid.DeleteCommandName)
        {
            GridDataItem item = (GridDataItem)e.Item;
            string iWatch = item["watchlist_id"].Text;
  
            Power50MiddleWare.BL.Watchlist oWatch = new Power50MiddleWare.BL.Watchlist();
            oWatch._WatchlistId = Int32.Parse(iWatch);
            try
            {
                int retResult = oWatch.RemoveWatchlist();
                if (retResult == 1)
                {
                    GenerateWatchlist();
                    pnlMsg.Visible = true;
                    lblMsg.Text = "Successfully deleted your watchlist item";
                }
                else
                {
                    pnlMsg.Visible = true;
                    lblMsg.Text = "Sorry could not delete the item, please contact your system administrator";
                }
            }
            catch (System.Exception exp)
            {
                pnlMsg.Visible = true;
                lblMsg.Text = exp.Message.ToString() + exp.StackTrace;
            }
        }

However when i try this, i get an JS error as attached.

Please suggest.

Thanks,

Debashis
Radoslav
Telerik team
 answered on 03 Feb 2011
8 answers
343 views
I want to know if this is possible - I haven't seen anything out there yet.  I have a radTextBox in the header of my radGrid.  When the user enters a letter/number for the name I want the radGrid to autopopulate based upon what is entered in the search box - could be 1 - 7 letters.  Thanks for your help.
Tsvetina
Telerik team
 answered on 03 Feb 2011
1 answer
47 views
Hello,

  At the base of my Grid control, I have the Telerik.Web.UI.GridPagerMode.NextPrevAndNumeric set as PagerStyle.Mode.  It shows the next page buttons, as well as a drop down list box of items on the page to the left.  And on the far right, it shows the number of items per page, such as "5 items in 4 pages."

  I would like to move that "5 items in 4 pages" text to be left aligned with the drop down box.  However, I can't figure out how to do it.  It seems as though the drop down box has a width of 100%, which pushes the "5 items" text to the right size.  I've tried various CSS tags to style the controls, but either I'm not doing it right, or what I want to do can't be done.

  Has anyone tackled this?  I think it's pretty simple, but I'm just stumped on how to do it.

Thanks!
Kevin J Baird
Iana Tsolova
Telerik team
 answered on 03 Feb 2011
1 answer
45 views
Hello,
I have a solution using masterpage, in witch i have pur radAjaxManager, and every page i am doing ajax, it is done in the master , with loadingpanel, that is set in the master. I have wrote it like this :

<

 

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

 

 

Skin="Vista" IsSticky="true" BackgroundPosition="Center" Height="60px"

 

 

Width="70px" HorizontalAlign="Center">

 

 

</telerik:RadAjaxLoadingPanel>

 

 

<asp:ContentPlaceHolder ID="contentBody" runat="server">

 

 

--------------Here comes the pages---------------
</
asp:ContentPlaceHolder>
Actually , when ajax workes, i see the image loading but it is positioned in top of the page, and also take place. I want it to be in the center of the ajaxed place, and to above the content, not instead place in the content.
Is it possible?

I have attached a picture of how my loadingPanel is seen when ajaxed.

Thanks,
gila

 

gila
Top achievements
Rank 1
 answered on 03 Feb 2011
2 answers
118 views

Hi

I’m trying to setup a terms & conditions box.

What mechanism/control can I use to display html T & C text (coming from a data field) on a web form such that when user scrolls to the bottom of the text using scroll bar then an event is fired to designate that user has read all the text?

Many Thanks

Regards

John
Top achievements
Rank 1
 answered on 03 Feb 2011
Narrow your results
Selected tags
Tags
+? more
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?