RadCombobox onchange

9 posts, 0 answers
  1. mohamed
    mohamed avatar
    311 posts
    Member since:
    Mar 2011

    Posted 30 Dec 2012 Link to this post

    Radcombobox change java script not fired,
    how i achieve this one



    RadComboBox DedSer1 = (RadComboBox)e.Item.FindControl("DedSer1");
     
    DedSer1.Attributes.Add("onChange", string.Format("CalculationAmount('{0}','{1}','{2}','{3}','{4}','{5}','{6}');", InvFinalamount.ClientID, DedValue.ClientID, DedInvoiceMinus.ClientID, GetValueSev.ClientID, GstInvoice.ClientID, InvoiceType.ClientID, DedSer1.ClientID));


    Thanks Advance,
    Mohamed.
  2. Shinu
    Shinu avatar
    17764 posts
    Member since:
    Mar 2007

    Posted 31 Dec 2012 Link to this post

    Hi,

    Try the following code snippet to fire the Javascript function.

    C#:
    . . .
     DedSer1.Attributes.Add("onChange","CalculationAmount('"+InvFinalamount.ClientID+"', '"+DedValue.ClientID+"', '"+DedInvoiceMinus.ClientID+"', '"+GetValueSev.ClientID+"', '"+GstInvoice.ClientID+"', '"+InvoiceType.ClientID+"', '"+DedSer1.ClientID+"')");
    . . .

    Thanks,
    Shinu.
  3. mohamed
    mohamed avatar
    311 posts
    Member since:
    Mar 2011

    Posted 31 Dec 2012 Link to this post

    Thanks for ur reply Shinu

    as your coding not fired any thing .
    any other suggestion

    Thanks Advance,
    Mohamed.
  4. Shinu
    Shinu avatar
    17764 posts
    Member since:
    Mar 2007

    Posted 02 Jan 2013 Link to this post

    Hi 

    Unfortunately I couldn't replicate the issue that you are facing. Here is the code that I tried and which worked as expected at my end. 

    ASPX:
    <telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="true"  DataSourceID="SqlDataSource1" onitemdatabound="RadGrid1_ItemDataBound">
        <MasterTableView>
            <Columns>
                <telerik:GridTemplateColumn>
                    <ItemTemplate>
                        <telerik:RadComboBox ID="DedSer1" runat="server" AutoPostBack="true">
                                ........
                        </telerik:RadComboBox>
                    </ItemTemplate>
                </telerik:GridTemplateColumn>
                .............
            </Columns>
        </MasterTableView>
    </telerik:RadGrid>

    C#:
    protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridDataItem)
        {
            GridDataItem DataItem = (GridDataItem)e.Item;
            RadComboBox DedSer = (RadComboBox)DataItem.FindControl("DedSer1");
            DedSer1.Attributes.Add("onChange","CalculationAmount('"+InvFinalamount.ClientID+"', '"+DedValue.ClientID+"', '"+DedInvoiceMinus.ClientID+"', '"+GetValueSev.ClientID+"', '"+GstInvoice.ClientID+"', '"+InvoiceType.ClientID+"', '"+DedSer1.ClientID+"')");
        }
    }

    JS:
    <script type="text/javascript">
        function CalculationAmount(InvFinalamount,DedValue,DedInvoiceMinus,GetValueSev,GstInvoice,InvoiceType,DedSer1.ClientID){
            //Your code
        }
    </script>

    Please provide your full code if it doesn't helps.

    Regards,
    Shinu.
  5. mohamed
    mohamed avatar
    311 posts
    Member since:
    Mar 2011

    Posted 02 Jan 2013 Link to this post

    Thanks For Ur reply Shinu

    .aspx
    <telerik:RadComboBox runat="server" id="DedSer1" AutoPostBack="true" AppendDataBoundItems="true" width="50px">
                                                     
                                                    </telerik:RadComboBox>

    I bind the values in run time like that
    .cs
    protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)
           {
               if (e.Item.OwnerTableView.IsItemInserted)
                   {
                      RadComboBox DedSer1 = (RadComboBox)item.FindControl("DedSer1");
     
                      DedSer1.Items.Add(new RadComboBoxItem("6", "6"));
                      DedSer1.Items.Add(new RadComboBoxItem("8", "8"));
                  }
           }

    i call like that from itemdatabount
    .cs
    protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
          {
              if (e.Item is GridEditableItem && e.Item.IsInEditMode)
              {
                   RadComboBox DedSer1 = (RadComboBox)e.Item.FindControl("DedSer1");
     
                  DedSer1.Attributes.Add("onChange", "CalculationAmount('" + InvFinalamount.ClientID + "', '" + DedValue.ClientID + "', '" + DedInvoiceMinus.ClientID + "', '" + GetValueSev.ClientID + "', '" + GstInvoice.ClientID + "', '" + InvoiceType.ClientID + "', '" + DedSer1.ClientID + "')");
              }
         }

    See the attachment screen

    Thanks advance,
    Mohamed.
  6. Shinu
    Shinu avatar
    17764 posts
    Member since:
    Mar 2007

    Posted 02 Jan 2013 Link to this post

    Hi,

    After inspecting your code I guess you want to populate the RadComboBox in both edit and insert mode. Please try the following code snippet which worked as expected for me.

    C#:
    protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridEditableItem && e.Item.IsInEditMode)
            {
                GridEditableItem DataItem = (GridEditableItem)e.Item;
                RadComboBox DedSer = (RadComboBox)DataItem.FindControl("DedSer1");
                DedSer1.Attributes.Add("onChange", "CalculationAmount('" + InvFinalamount.ClientID + "', '" + DedValue.ClientID + "', '" + DedInvoiceMinus.ClientID + "', '" + GetValueSev.ClientID + "', '" + GstInvoice.ClientID + "', '" + InvoiceType.ClientID + "', '" + DedSer1.ClientID + "')");
            }
    }
    protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridEditableItem && e.Item.IsInEditMode)
        {
            GridEditableItem item = (GridEditableItem)e.Item;
            RadComboBox DedSer1 = (RadComboBox)item.FindControl("DedSer1");
            DedSer1.Items.Add(new RadComboBoxItem("6", "6"));
            DedSer1.Items.Add(new RadComboBoxItem("8", "8"));
        }
    }

    Hope this helps.

    Regards,
    Shinu.
  7. mohamed
    mohamed avatar
    311 posts
    Member since:
    Mar 2011

    Posted 02 Jan 2013 Link to this post

    Thanks for r reply

    As you told like that i did in my side but not fired the javascript
    .aspx
    <telerik:RadComboBox runat="server" id="DedSer1" AutoPostBack="true" AppendDataBoundItems="true" width="50px">
                                                    </telerik:RadComboBox>

    Thanks Advance,
    Mohamed.
  8. Shinu
    Shinu avatar
    17764 posts
    Member since:
    Mar 2007

    Posted 03 Jan 2013 Link to this post

    Hi Mohamed,

    Unfortunately I couldn't replicate the issue that you are facing. Please provide your entire code so that I can replicate the issue at my end.

    Regards,
    Shinu.
  9. mohamed
    mohamed avatar
    311 posts
    Member since:
    Mar 2011

    Posted 03 Jan 2013 Link to this post

    <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="workorder.aspx.cs" Inherits="DOSKMANAGEMENT.PMS.workorder"
        MasterPageFile="~/Site.Master" %>
     
    <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
    <asp:Content ID="Content1" ContentPlaceHolderID="TitleContent" runat="server">
        <%= Resources.FormName.workorder%>
    </asp:Content>
    <asp:Content ID="Content2" ContentPlaceHolderID="FormName" runat="server">
        <%= Resources.FormName.workorder%>
    </asp:Content>
    <asp:Content ID="aboutContent" ContentPlaceHolderID="MainContent" runat="server">
        <telerik:RadCodeBlock runat="server" ID="radCodeBlock">
            <script type="text/javascript">
                function Surviour(totest) {
                    var Toalest = $find(totest).get_value();
                    var md = 0;
                    if (Toalest == "") {
     
                        var duratn = $find(totest);
                        duratn.set_value(md);
                    }
                }
                function Jointer(totest) {
                    var Toalest = $find(totest).get_value();
                    var md = 0;
                    if (Toalest == "") {
                        var duratn = $find(totest);
                        duratn.set_value(md);
                    }
                }
                function changeEndDate(startDateID, endDateID, chk) {
                    var startDateObj = $find(startDateID);
                    var startDate = startDateObj.get_selectedDate();
                    var endDateObj = $find(endDateID);
                    var endofdate = endDateObj.get_selectedDate();
                    if (endDateObj._element.value != "") {
                        if (endofdate <= startDate) {                       
                            if (chk == 0) {
                                endDateObj.clear();
                                alert("Commencement Date should be greater than Work Order Date");                           
                            }
                            else if (chk == 1) {
                                endDateObj.clear();
                                alert("Completion Date should be greater than Commencement Date");                           
                            }
                        }
                    }
                }
                function onToolBarClientButtonClicking(sender, args) {
                    var grid = $find("<%=RadGrid1.ClientID %>");
                    var comandName = args.get_item().get_commandName();
                    if (comandName == "Filter") {
                        if (grid.get_masterTableView().get_isFilterItemVisible()) {
                            grid.get_masterTableView().hideFilterItem();
                        }
                        else {
                            grid.get_masterTableView().showFilterItem();
                        }
                    }
                }
                function onRequestStart(sender, args) {
                    if (args.get_eventTarget().indexOf("btnExport") >= 0)
                        args.set_enableAjax(false);
                }
                //this for to avoid decimal point
                function NoDecimal(sender, eventArgs) {
                    //debugger;
                    var c = eventArgs.get_keyCharacter();
                    if (c == '.')
                        eventArgs.set_cancel(true);
                }
                //this for to avoid decimal point
                function KeyPress(sender, args) {
                    if (args.get_keyCharacter() == sender.get_numberFormat().DecimalSeparator) {
                        args.set_cancel(true);
                    }
                }
            </script>
        </telerik:RadCodeBlock>
        <telerik:RadFormDecorator ID="FormDecorator1" runat="server" EnableRoundedCorners="false"
            DecoratedControls="All"></telerik:RadFormDecorator>
        <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" UpdatePanelsRenderMode="Inline"
            DefaultLoadingPanelID="tbsLoadingPanel">
            <AjaxSettings>
                <telerik:AjaxSetting AjaxControlID="RadGrid1">
                    <UpdatedControls>
                        <telerik:AjaxUpdatedControl ControlID="RadGrid1" />
                    </UpdatedControls>
                </telerik:AjaxSetting>
            </AjaxSettings>
        </telerik:RadAjaxManager>
        <telerik:RadAjaxLoadingPanel ID="tbsLoadingPanel" runat="server" Skin="Default" IsSticky="false">
        </telerik:RadAjaxLoadingPanel>
        <table style="margin-top: 10px; width: 100%">
            <tr>
                <td>
                    <telerik:RadGrid ID="RadGrid1" runat="server" Skin="Office2007" AllowAutomaticInserts="True"
                        AllowAutomaticUpdates="True" GridLines="None" autocompletetype="Disabled" AllowFilteringByColumn="True"
                        AllowPaging="True" AllowSorting="True" OnNeedDataSource="RadGrid1_NeedDataSource"
                        VirtualItemCount="500" OnItemCommand="RadGrid1_ItemCommand" OnItemCreated="RadGrid1_ItemCreated"
                        EnableHeaderContextMenu="true" EnableHeaderContextFilterMenu="true" OnPreRender="RadGrid1_PreRender"
                        OnItemDataBound="RadGrid1_ItemDataBound">
                        <ExportSettings>
                            <Pdf PageHeight="297mm" PageWidth="210mm" />
                        </ExportSettings>
                        <GroupingSettings CaseSensitive="true" />
                        <MasterTableView AutoGenerateColumns="False" CommandItemDisplay="Top" EditMode="PopUp"
                            IsFilterItemExpanded="false" EditFormSettings-PopUpSettings-Modal="true" AllowFilteringByColumn="true"
                            AllowMultiColumnSorting="true">
                            <CommandItemTemplate>
                                <telerik:RadToolBar ID="RadToolBar1" runat="server" OnClientButtonClicking="onToolBarClientButtonClicking"
                                    OnButtonClick="RadToolBar1_ButtonClick">
                                    <Items>
                                        <telerik:RadToolBarButton Text="Add New" CommandName="InitInsert" ImageUrl="../../images/AddRecord.gif"
                                            Visible='<%# !RadGrid1.MasterTableView.IsItemInserted %>'>
                                        </telerik:RadToolBarButton>
                                        <telerik:RadToolBarButton Text="<%$ Resources:FormName, Filter %>" CommandName="Filter"
                                            ImageUrl="../../images/Filter 3.gif">
                                        </telerik:RadToolBarButton>
                                        <telerik:RadToolBarButton Text="<%$ Resources:FormName, Refresh %>" CommandName="RebindGrid"
                                            ImageUrl="../../images/Refresh.gif">
                                        </telerik:RadToolBarButton>
                                        <telerik:RadToolBarButton runat="server" Value="HeaderDisplay">
                                            <ItemTemplate>
                                                <table>
                                                    <tr>
                                                        <td align="right">
                                                            <telerik:RadComboBox runat="server" ID="DeleteOption" OnSelectedIndexChanged="DeleteOption_SelectedIndexChanged"
                                                                AutoPostBack="true" AppendDataBoundItems="true">
                                                                <Items>
                                                                    <telerik:RadComboBoxItem runat="server" Text="All" Value="All" />
                                                                    <telerik:RadComboBoxItem runat="server" Text="Deleted" Value="Deleted" />
                                                                    <telerik:RadComboBoxItem runat="server" Text="Not Deleted" Value="Not Deleted" />
                                                                </Items>
                                                            </telerik:RadComboBox>
                                                        </td>
                                                        <td>
                                                            <telerik:RadComboBox runat="server" ID="PendingSearch" OnSelectedIndexChanged="PendingSearch_SelectedIndexChanged"
                                                                AutoPostBack="true" AppendDataBoundItems="true">
                                                                <Items>
                                                                    <telerik:RadComboBoxItem runat="server" Text="All" Value="All1" />
                                                                    <telerik:RadComboBoxItem runat="server" Text="Pending" Value="Pending" />
                                                                    <telerik:RadComboBoxItem runat="server" Text="Completed" Value="Completed" />
                                                                    <telerik:RadComboBoxItem runat="server" Text="Certified" Value="Certified" />
                                                                </Items>
                                                            </telerik:RadComboBox>
                                                        </td>
                                                    </tr>
                                                </table>
                                            </ItemTemplate>
                                        </telerik:RadToolBarButton>
                                    </Items>
                                </telerik:RadToolBar>
                            </CommandItemTemplate>
                            <PagerStyle BackColor="#D8EBFC" Mode="NextPrevNumericAndAdvanced" />
                            <HeaderStyle CssClass="dataheadcolor" />
                            <RowIndicatorColumn>
                                <HeaderStyle Width="20px"></HeaderStyle>
                            </RowIndicatorColumn>
                            <CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings>
                            <Columns>
                                <telerik:GridEditCommandColumn ButtonType="ImageButton" HeaderStyle-Width="10px"
                                    UniqueName="EditButton" HeaderText="<%$ Resources:FormName, EDIT %>" />
                                <telerik:GridNumericColumn ReadOnly="true" DataField="workordid" HeaderText="workordid"
                                    SortExpression="workordid" UniqueName="workordid" MaxLength="6" HeaderStyle-Width="80px"
                                    Visible="false">
                                </telerik:GridNumericColumn>
                                <telerik:GridBoundColumn DataField="workordno" HeaderText="Work Order No" SortExpression="workordno"
                                    UniqueName="workordno" FilterControlWidth="100px" HeaderStyle-Width="100px">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn UniqueName="orderamount" SortExpression="orderamount" HeaderText="Order Amt. (S$)"
                                    DataField="orderamount" FilterControlWidth="100px" HeaderStyle-Width="100px"
                                    DataType="System.Decimal" DataFormatString="{0:C}">
                                    <HeaderStyle Width="100px"></HeaderStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="jointeramt" HeaderText="Jointer Amt. (S$)" SortExpression="jointeramt"
                                    UniqueName="jointeramt" FilterControlWidth="130px" HeaderStyle-Width="100px"
                                    DataType="System.Decimal" DataFormatString="{0:C}">
                                    <HeaderStyle Width="100px"></HeaderStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="survivoram" HeaderText="Surveyor Amt. (S$)" SortExpression="survivoram"
                                    UniqueName="survivoram" FilterControlWidth="100px" HeaderStyle-Width="110px"
                                    DataType="System.Decimal" DataFormatString="{0:C}">
                                    <HeaderStyle Width="110px"></HeaderStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="worklocatn" HeaderText="Work Location" SortExpression="worklocatn"
                                    UniqueName="worklocatn" FilterControlWidth="100px" HeaderStyle-Width="160px"
                                    DataType="System.String">
                                </telerik:GridBoundColumn>
                                <telerik:GridDateTimeColumn DataField="commencement" HeaderText="Commencement" SortExpression="commencement"
                                    UniqueName="commencement" FilterControlWidth="40px" HeaderStyle-Width="40px"
                                    PickerType="DatePicker" DataFormatString="{0:dd/MM/yyyy}" DataType="System.DateTime">
                                </telerik:GridDateTimeColumn>
                                <telerik:GridDateTimeColumn DataField="completion" HeaderText="Completion" SortExpression="completion"
                                    UniqueName="completion" FilterControlWidth="40px" HeaderStyle-Width="40px" PickerType="DatePicker"
                                    DataFormatString="{0:dd/MM/yyyy}" DataType="System.DateTime">
                                </telerik:GridDateTimeColumn>
                                <telerik:GridBoundColumn DataField="Remarkss" HeaderText="Remarks" SortExpression="Remarkss"
                                    UniqueName="Remarkss" FilterControlWidth="100px" HeaderStyle-Width="160px" DataType="System.String">
                                </telerik:GridBoundColumn>
                                <telerik:GridButtonColumn HeaderText="<%$ Resources:FormName, Delete %>" CommandName="Delete"
                                    ButtonType="ImageButton" UniqueName="DeleteColumn" CommandArgument="Child" ConfirmDialogType="RadWindow"
                                    ConfirmText="Are You Sure Want To Delete This Record?" ConfirmTitle="Delete Confirm"
                                    HeaderStyle-Width="10px" />
                            </Columns>
                            <EditFormSettings CaptionFormatString="Create" EditFormType="Template" PopUpSettings-Width="825"
                                PopUpSettings-Height="390">
                                <EditColumn UniqueName="EditCommandColumn1">
                                </EditColumn>
                                <FormTemplate>
                                    <div style="margin-left: 3%; margin-right: 3%;">
                                        <table width="100%">
                                            <tr>
                                                <td style="height: 75px; width: 75%;">
                                                    <table style="float: right;">
                                                        <tr>
                                                            <td>
                                                                <asp:Label ID="Label3" runat="server" ForeColor="Red" Text="*" Width="1px"></asp:Label>
                                                                <asp:Label ID="Label2" Text="Mandatory Field(s)" runat="server"></asp:Label>
                                                            </td>
                                                        </tr>
                                                    </table>
                                                    <br />
                                                    <br />
                                                    <section class="chunk">
        <fieldset>
            <legend class="hd" >
                <span class="text">
                <%= Resources.FormName.workorder%>
                </span>
            </legend>
            <div class="bd">
             <table cellspacing="1" cellpadding="1" width="100%" border="0">
                                                    <tr>
                                                        <td colspan="4">
                                                            <asp:TextBox Width="100px" ID="workordid" AutoCompleteType="Disabled" runat="server"
                                                                Text='<%# Bind("workordid") %>' Visible="false"></asp:TextBox>
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        <td>
                                                        <%--<asp:Label ID="Label1" runat="server" ForeColor="Red" Text="*" Width="1px"></asp:Label>--%>
                                                            <asp:Label ID="Type" Text="Work Order No." runat="server" ></asp:Label>
                                                        </td>
                                                        <td>                     
                                                            <%--<telerik:RadNumericTextBox Width="50%" ID="Workorderno" AutoCompleteType="Disabled" runat="server" FocusedStyle-BackColor="Lavender"
                                                                MaxLength="8" onkeydown = "return (event.keyCode!=13);">
                                                                <NumberFormat GroupSeparator="" DecimalDigits="0" AllowRounding="true"   KeepNotRoundedValue="false"  />  
                                                                <IncrementSettings InterceptMouseWheel="false" InterceptArrowKeys="false"  />                                                           
                                                            </telerik:RadNumericTextBox>--%><%--CssClass="Capitalize1"--%>
                                                            <telerik:RadTextBox Width="50%" ID="Workorderno" AutoCompleteType="Disabled" runat="server" FocusedStyle-BackColor="Lavender"  MaxLength="16"
                                                             onkeydown = "return (event.keyCode!=13);" Text='<%# Bind("workordno") %>' ></telerik:RadTextBox
                                                        </td>
                                                        <td>
                                                            <%--<asp:Label ID="Label4" runat="server" ForeColor="Red" Text="*" Width="1px"></asp:Label>--%>
                                                            <asp:Label ID="ClientNam" Text="Work Order Date" runat="server"></asp:Label>
                                                        </td>
                                                        <td>
                                                        <telerik:RadDatePicker ID="workorderdate" AutoCompleteType="Disabled" runat="server"
                                                                    Enabled="true" Width="50%">
                                                                    <DateInput ID="DateInput1" DateFormat="dd/MM/yyyy" runat="server" ReadOnly="true"></DateInput>
                                                                </telerik:RadDatePicker>   
                                                                </td>                                                       
                                                    </tr>
                                                    <tr>
                                                        <td colspan="4" style="height: 5px;">
                                                        </td>
                                                    </tr>
                                                    <tr>                                                 
                                                        <td>                                                       
                                                            <asp:Label ID="StoreyN" Text="Contract No." runat="server"></asp:Label>
                                                        </td>
                                                        <td>
     
                                                            <telerik:RadTextBox Width="50%" ID="ContractNo" runat="server" AutoCompleteType="Disabled" Text='9120211' FocusedStyle-BackColor="Lavender"
                                                                Readonly="true" onkeydown = "return (event.keyCode!=13);" CssClass="Capitalize1">
                                                            </telerik:RadTextBox>
                                                        </td>
                                                         <td>                                                       
                                                            <asp:Label ID="UnitN" Text="Client" runat="server"></asp:Label>
                                                        </td>
                                                        <td>
                                                             
                                                            <telerik:RadTextBox Width="95%" ID="Clientname" AutoCompleteType="Disabled" runat="server" FocusedStyle-BackColor="Lavender" Text="SP Powergrid Ltd" Readonly="true"
                                                                MaxLength="30" onkeydown = "return (event.keyCode!=13);" CssClass="Capitalize1"></telerik:RadTextBox>
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        <td colspan="4" style="height: 5px;">
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        <td>                                                       
                                                            <asp:Label ID="MainCon" Text="Main Contractor" runat="server"></asp:Label>
                                                        </td>
                                                        <td>
                                                         
                                                            <telerik:RadTextBox Width="95%" ID="MainCont" AutoCompleteType="Disabled" runat="server" FocusedStyle-BackColor="Lavender" Text="Uniglory Construction Pte Ltd" Readonly="true"
                                                                MaxLength="50" onkeydown = "return (event.keyCode!=13);" CssClass="Capitalize1">
                                                            </telerik:RadTextBox>
                                                        </td>
                                                        <td>                                                       
                                                            <asp:Label ID="MainSubCon" Text="Main Sub Contractor" runat="server"></asp:Label>
                                                        </td>
                                                        <td>
                                                         
                                                            <telerik:RadTextBox Width="95%" ID="MainSubCont" AutoCompleteType="Disabled" runat="server" FocusedStyle-BackColor="Lavender" text="PowerCom Engineering Works Pte Ltd" Readonly="true"
                                                                MaxLength="50" onkeydown = "return (event.keyCode!=13);" CssClass="Capitalize1">
                                                            </telerik:RadTextBox >
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        <td colspan="4" style="height: 5px;">
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        <td>                                                       
                                                            <asp:Label ID="workloc" Text="Work Location" runat="server"></asp:Label>
                                                        </td>
                                                        <td>
                                                            <telerik:RadTextBox Width="95%" ID="WorlLocation" AutoCompleteType="Disabled" MaxLength="50" FocusedStyle-BackColor="Lavender"
                                                                runat="server"  onkeydown = "return (event.keyCode!=13);" CssClass="Capitalize1">
                                                            </telerik:RadTextBox>
                                                             
                                                        </td>
                                                        <td>                                                       
                                                            <asp:Label ID="ordamt" Text="Order Amount (S$)" runat="server"></asp:Label>
                                                        </td>
                                                        <td>
                                                            <telerik:RadNumericTextBox Width="50%" ID="Orderamount" AutoCompleteType="Disabled" runat="server" FocusedStyle-BackColor="Lavender"
                                                                MaxLength="8" onkeydown = "return (event.keyCode!=13);">
                                                                <NumberFormat GroupSeparator="," GroupSizes="3" DecimalDigits="2" AllowRounding="true"   KeepNotRoundedValue="false"  />  
                                                                <IncrementSettings InterceptMouseWheel="false" InterceptArrowKeys="false"  />                                                           
                                                            </telerik:RadNumericTextBox>
                                                        </td>
                                                         
                                                         
                                                    </tr>
                                                    <tr>
                                                        <td colspan="4" style="height: 5px;">
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                    <td>                                                       
                                                            <asp:Label ID="commencemnet" Text="Commencement Date" runat="server"></asp:Label>
                                                        </td>
                                                        <td>
                                                            <telerik:RadDatePicker ID="DateofCommencement" AutoCompleteType="Disabled" runat="server" Enabled="true" Width="50%">
                                                                    <DateInput ID="DateInput2" DateFormat="dd/MM/yyyy" runat="server" ReadOnly="true" FocusedStyle-BackColor="Lavender" Width="50%"></DateInput>
                                                                </telerik:RadDatePicker>
                                                        </td>
                                                        <td>
     
                                                            <asp:Label ID="CompletionDat" Text="Completion Date" runat="server"></asp:Label>
                                                        </td>
                                                        <td>
                                                             <telerik:RadDatePicker ID="DateofCompletion" AutoCompleteType="Disabled" runat="server"
                                                                    Enabled="true" Width="50%">
                                                                    <DateInput ID="DateInput3" DateFormat="dd/MM/yyyy" runat="server" ReadOnly="true"></DateInput>
                                                                </telerik:RadDatePicker>
                                                        </td>
                                                         
                                                    </tr>
                                                    <tr>
                                                        <td colspan="4" style="height: 5px;">
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        <td>                                                       
                                                            <asp:Label ID="jointeramt" Text="Jointer Amount (S$)" runat="server"></asp:Label>
                                                        </td>
                                                        <td>
                                                            <telerik:RadNumericTextBox Width="50%" ID="JointerAmount" AutoCompleteType="Disabled" runat="server" FocusedStyle-BackColor="Lavender"
                                                                MaxLength="8" onkeydown = "return (event.keyCode!=13);">
                                                                <NumberFormat GroupSeparator="," GroupSizes="3" DecimalDigits="2" AllowRounding="true"   KeepNotRoundedValue="false"  />  
                                                                <IncrementSettings InterceptMouseWheel="false" InterceptArrowKeys="false"  />                                                       
                                                            </telerik:RadNumericTextBox>
                                                        </td>
                                                        <td>                                                       
                                                            <asp:Label ID="surviour" Text="Surveyor Amount (S$)" runat="server"></asp:Label>
                                                        </td>
                                                        <td>
                                                            <telerik:RadNumericTextBox Width="50%" ID="Surviouramount" AutoCompleteType="Disabled" runat="server" FocusedStyle-BackColor="Lavender"
                                                                MaxLength="8" onkeydown = "return (event.keyCode!=13);">
                                                                <NumberFormat GroupSeparator="," GroupSizes="3" DecimalDigits="2" AllowRounding="true"   KeepNotRoundedValue="false"  />  
                                                                <IncrementSettings InterceptMouseWheel="false" InterceptArrowKeys="false"  />                                                       
                                                            </telerik:RadNumericTextBox>
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        <td colspan="4" style="height: 5px;">
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                    <td>
                                                    <asp:Label runat="server" Text="Remarks"></asp:Label>
                                                    </td>
                                                    <td>
                                                            <telerik:RadTextBox Width="95%" ID="Remark" AutoCompleteType="Disabled" MaxLength="500" FocusedStyle-BackColor="Lavender"
                                                                runat="server"  onkeydown = "return (event.keyCode!=13);" CssClass="Capitalize1">
                                                            </telerik:RadTextBox>
                                                    </td>
                                                    </tr>
                                                    <tr>
                                                        <td colspan="4" style="height: 5px;">
                                                        </td>
                                                    </tr>
                                                </table>
            </div>
        </fieldset>
    </section>
                                                </td>
                                            </tr>
                                        </table>
                                        <center>
                                            <table>
                                                <tr>
                                                    <td>
                                                        <telerik:RadButton ID="Button3" runat="server" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>'
                                                            CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'
                                                            Icon-PrimaryIconCssClass="rbOk">
                                                        </telerik:RadButton>
                                                        <telerik:RadButton ID="Button4" runat="server" Text="Cancel" CausesValidation="false"
                                                            CommandName="Cancel" Icon-PrimaryIconCssClass="rbCancel">
                                                        </telerik:RadButton>
                                                    </td>
                                                </tr>
                                            </table>
                                        </center>
                                    </div>
                                </FormTemplate>
                                <PopUpSettings Modal="True"></PopUpSettings>
                            </EditFormSettings>
                        </MasterTableView>
                        <ClientSettings>
                            <Selecting AllowRowSelect="True" EnableDragToSelectRows="True" />
                            <ClientEvents OnFilterMenuShowing="filterMenuShowing" />
                        </ClientSettings>
                        <FilterMenu OnClientShown="MenuShowing" />
                    </telerik:RadGrid>
                </td>
            </tr>
        </table>
    </asp:Content>

    .aspx part


    using System;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    using Telerik.Web.UI;
    using DOSKMANAGEMENT.Models;
    using DoskContractServices;
    using System.Linq;
    using System.Collections;
    using System.Globalization;
     
    namespace DOSKMANAGEMENT.PMS
    {
        public partial class workorder : System.Web.UI.Page
        {
            #region Public Variables
     
            DBClientADO oDBClientADO = new DBClientADO();
            public static Int32 dupcount, maxva, dupcount1;
            public static Int32 Work = 0, Worklct = 0, OrdAmnt = 0, Workdate = 0, CommDate = 0, CoplDate = 0, DiiComm = 0, DifComp = 0, joinamnt = 0, survamnt = 0;
            public static string DeleteOption, PendingSearch;
            public static string projcode, usercode, formnam, compcode;
     
            #endregion
     
            protected void Page_Load(object sender, EventArgs e)
            {
                projcode = Convert.ToString(Session["projcode"]);
                usercode = Convert.ToString(Session["usercode"]);
                compcode = Convert.ToString(Session["compcode"]);
                if (!IsPostBack)
                {
                    DeleteOption = "Not Deleted";
                    PendingSearch = "Pending";
                }
            }
     
            protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
            {
                #region All
     
                if (DeleteOption == "All")
                {
                    if (PendingSearch == "All1")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.compcode == compcode
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                        }
                    }
                    else if (PendingSearch == "Pending")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.compcode == compcode && a.workstatus == "STR"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                        }
                    }
                    else if (PendingSearch == "Completed")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.compcode == compcode && a.workstatus == "STC"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                        }
                    }
                    else if (PendingSearch == "Certified")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.compcode == compcode && a.workstatus != "STR" && a.workstatus != "STC"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                        }
                    }
                }
     
                #endregion
     
                #region Deleted
     
                else if (DeleteOption == "Deleted")
                {
                    if (PendingSearch == "All1")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status == "DEL" && a.compcode == compcode
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                        }
                    }
                    else if (PendingSearch == "Pending")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status == "DEL" && a.compcode == compcode && a.workstatus == "STR"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                        }
                    }
                    else if (PendingSearch == "Completed")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status == "DEL" && a.compcode == compcode && a.workstatus == "STC"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                        }
                    }
                    else if (PendingSearch == "Certified")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status == "DEL" && a.compcode == compcode && a.workstatus != "STR"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                        }
                    }
                }
     
                #endregion
     
                #region Not Deleted
     
                else if (DeleteOption == "Not Deleted")
                {
                    if (PendingSearch == "All1")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status != "DEL" && a.compcode == compcode
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                        }
                    }
                    else if (PendingSearch == "Pending")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status != "DEL" && a.compcode == compcode && a.workstatus == "STR"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                        }
                    }
                    else if (PendingSearch == "Completed")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status != "DEL" && a.compcode == compcode && a.workstatus == "STC"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                        }
                    }
                    else if (PendingSearch == "Certified")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status != "DEL" && a.compcode == compcode && a.workstatus != "STR"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                        }
     
                    }
                }
     
                #endregion
            }
     
            protected void RadToolBar1_ButtonClick(object sender, RadToolBarEventArgs e)
            {
     
            }
     
            protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
            {
                dsworkorder oworkorder = new dsworkorder();
                if (e.CommandName == RadGrid.PerformInsertCommandName)
                {
                    if (e.Item is GridEditFormItem)
                    {
                        GridEditFormItem item = (GridEditFormItem)e.Item;
                        RadTextBox Workorderno = (RadTextBox)item.FindControl("Workorderno");
                        RadDatePicker workorderdate = (RadDatePicker)item.FindControl("workorderdate");
                        RadTextBox ContractNo = (RadTextBox)item.FindControl("ContractNo");
                        RadTextBox Clientname = (RadTextBox)item.FindControl("Clientname");
                        RadTextBox MainCont = (RadTextBox)item.FindControl("MainCont");
                        RadTextBox MainSubCont = (RadTextBox)item.FindControl("MainSubCont");
                        RadTextBox WorklLocation = (RadTextBox)item.FindControl("WorlLocation");
                        RadDatePicker DateofCommencement = (RadDatePicker)item.FindControl("DateofCommencement");
                        RadDatePicker DateofCompletion = (RadDatePicker)item.FindControl("DateofCompletion");
                        RadNumericTextBox Orderamount = (RadNumericTextBox)item.FindControl("Orderamount");
                        RadNumericTextBox JointerAmount = (RadNumericTextBox)item.FindControl("JointerAmount");
                        RadNumericTextBox Surviouramount = (RadNumericTextBox)item.FindControl("Surviouramount");
                        RadTextBox Remark = (RadTextBox)item.FindControl("Remark");
     
                        oworkorder.workordno = Workorderno.Text;
                        oworkorder.workordat = workorderdate.SelectedDate;
                        oworkorder.contractno = System.Globalization.CultureInfo.CurrentUICulture.TextInfo.ToTitleCase(ContractNo.Text);
                        oworkorder.clientnam = System.Globalization.CultureInfo.CurrentUICulture.TextInfo.ToTitleCase(Clientname.Text);
                        oworkorder.maincontr = System.Globalization.CultureInfo.CurrentUICulture.TextInfo.ToTitleCase(MainCont.Text);
                        oworkorder.mainsubcon = System.Globalization.CultureInfo.CurrentUICulture.TextInfo.ToTitleCase(MainSubCont.Text);
                        oworkorder.worklocatn = System.Globalization.CultureInfo.CurrentUICulture.TextInfo.ToTitleCase(WorklLocation.Text);
                        oworkorder.commencement = DateofCommencement.SelectedDate;
                        oworkorder.completion = DateofCompletion.SelectedDate;
     
                        if (Orderamount.Text != "")
                            oworkorder.orderamount = Convert.ToDecimal(Orderamount.Text);
                        else
                            oworkorder.orderamount = 0;
     
                        if (JointerAmount.Text != "")
                            oworkorder.jointeramt = Convert.ToDecimal(JointerAmount.Text);
                        else
                            oworkorder.jointeramt = 0;
     
                        if (Surviouramount.Text != "")
                            oworkorder.survivoram = Convert.ToDecimal(Surviouramount.Text);
                        else
                            oworkorder.survivoram = 0;
     
                        oworkorder.status = "ADD";
                        oworkorder.oprstamp = usercode;
                        oworkorder.timstamp = DateTime.Now;
                        oworkorder.compcode = compcode;
                        oworkorder.workstatus = "STR";
                        oworkorder.cerfinlamot = null;
                        oworkorder.cerjoinamot = null;
                        oworkorder.cersurvamot = null;
                        oworkorder.actcompletion = null;
                        oworkorder.Remarkss = Remark.Text;
     
                        #region client code generation
     
                        //using (var db = new DoskContractServicesDataContext(Globals.strcon))
                        //{
                        //    var orgreqfinal = (from a in db.dsdatamasters
                        //                       select new { a.clientcode, a.clientname, a.singapore }).tolist();
                        //    dupcount = orgreqfinal.count();
     
                        //    var maxvalue = (from a in db.dsdatamasters
                        //                    select new { a.dataid }).tolist();
     
     
                        //    var query = from p in db.dsdatamasters
                        //                select p.dataid;
                        //    if (query.count() > 1)
                        //        maxva = convert.toint16(query.max()) + 1;
                        //    else
                        //        maxva = 1;
                        //}
     
                        #endregion
     
                        #region CheckNull
     
     
                        if (oworkorder.workordno == "")
                        {
                            Work = 1;
                            RadAjaxManager1.Alert(" Enter Work Order No");
                            Workorderno.Focus();
                        }
                        else { Work = 0; }
     
                        if (oworkorder.worklocatn == "")
                        {
                            Worklct = 1;
                            RadAjaxManager1.Alert(" Enter Work Location");
                            WorklLocation.Focus();
                        }
                        else { Worklct = 0; }
     
                        if (oworkorder.orderamount <= 0)
                        {
                            OrdAmnt = 1;
                            RadAjaxManager1.Alert(" Enter Order Amount ");
                            Orderamount.Focus();
                        }
                        else { OrdAmnt = 0; }
     
                        if (oworkorder.jointeramt < 0)
                        {
                            joinamnt = 1;
                            RadAjaxManager1.Alert(" Enter Jointer Amount ");
                            JointerAmount.Focus();
                        }
                        else { joinamnt = 0; }
     
                        if (oworkorder.survivoram < 0)
                        {
                            survamnt = 1;
                            RadAjaxManager1.Alert(" Enter Surveyor Amount ");
                            Surviouramount.Focus();
                        }
                        else { survamnt = 0; }
     
                        if (workorderdate.IsEmpty)
                        {
                            Workdate = 1;
                            RadAjaxManager1.Alert(" Select The Work Order Date");
                        }
                        else { Workdate = 0; }
     
                        if (DateofCommencement.IsEmpty)
                        {
                            CommDate = 1;
                            RadAjaxManager1.Alert(" Select The Date Commencement");
                        }
                        else { CommDate = 0; }
     
                        if (DateofCompletion.IsEmpty)
                        {
                            CoplDate = 1;
                            RadAjaxManager1.Alert(" Select The Date Completion");
                        }
                        else { CoplDate = 0; }
     
                        if (DateofCommencement.SelectedDate < workorderdate.SelectedDate)
                        {
                            DiiComm = 1;
                            RadAjaxManager1.Alert(" Commencement Date should be greater than Work Order Date");
                        }
                        else { DiiComm = 0; }
     
                        if (DateofCompletion.SelectedDate < DateofCommencement.SelectedDate)
                        {
                            DifComp = 1;
                            RadAjaxManager1.Alert(" Completion Date should be greater than Commencement Date");
                        }
                        else { DifComp = 0; }
     
                        #endregion
     
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var orgreqfinal = (from a in db.dsworkorders
                                               where a.workordno == Workorderno.Text && a.status != "del"
                                               select new { a.workordno, a.clientnam, a.contractno }).ToList();
                            dupcount1 = orgreqfinal.Count();
                        }
     
                        if (dupcount1 == 0)
                        {
                            using (var db = new DoskContractServicesDataContext(Globals.strCon))
                            {
                                var orgreqfinal = (from a in db.dsworkorders
                                                   where a.workordno == Workorderno.Text && a.status != "del"
                                                   select new { a.workordno, a.clientnam, a.contractno }).ToList();
                                dupcount = orgreqfinal.Count();
                            }
     
                            if (dupcount > 0)
                            {
                                RadAjaxManager1.Alert("     Already given for this Work Order \n" +
                                                          "   Work Order : " + oworkorder.workordno);
     
                            }
     
                            else
                            {
                                if (oworkorder.workordno != "")
                                {
                                    try
                                    {
                                        if (Work == 0 && OrdAmnt == 0 && Workdate == 0 && CommDate == 0 && CoplDate == 0 && Worklct == 0 && DiiComm == 0 && DifComp == 0 && survamnt == 0 && joinamnt == 0)
                                        {
                                            DbClient.Insert<dsworkorder>(oworkorder);
                                            RadGrid1.Rebind();
                                            RadAjaxManager1.Alert("          data successfully saved \n" +
                                                                  "          Work Order :   " + oworkorder.workordno);
     
                                            RadGrid1.MasterTableView.IsItemInserted = false;
                                            RadGrid1.DataBind();
                                            e.Canceled = true;
                                        }
                                    }
                                    catch (Exception ex)
                                    {
                                        RadGrid1.Controls.Add(new LiteralControl("unable to insert employee. reason: " + ex.Message));
                                    }
                                }
                                else
                                {
                                    RadAjaxManager1.Alert("Enter the Work Order No");
                                }
                            }
                        }
                        else
                        {
                            RadAjaxManager1.Alert("Work Order No Is Already Entered");
                        }
                    }
                }
                else if (e.CommandName == RadGrid.UpdateCommandName)
                {
                    GridEditableItem editedItem = e.Item as GridEditableItem;
     
                    if (e.Item is GridEditFormItem)
                    {
                        GridEditFormItem item = (GridEditFormItem)e.Item;
                        TextBox workordid = (TextBox)item.FindControl("workordid");
                        RadTextBox Workorderno = (RadTextBox)item.FindControl("Workorderno");
                        RadDatePicker workorderdate = (RadDatePicker)item.FindControl("workorderdate");
                        RadTextBox ContractNo = (RadTextBox)item.FindControl("ContractNo");
                        RadTextBox Clientname = (RadTextBox)item.FindControl("Clientname");
                        RadTextBox MainCont = (RadTextBox)item.FindControl("MainCont");
                        RadTextBox MainSubCont = (RadTextBox)item.FindControl("MainSubCont");
                        RadTextBox WorklLocation = (RadTextBox)item.FindControl("WorlLocation");
                        RadDatePicker DateofCommencement = (RadDatePicker)item.FindControl("DateofCommencement");
                        RadDatePicker DateofCompletion = (RadDatePicker)item.FindControl("DateofCompletion");
                        RadNumericTextBox Orderamount = (RadNumericTextBox)item.FindControl("Orderamount");
                        RadNumericTextBox JointerAmount = (RadNumericTextBox)item.FindControl("JointerAmount");
                        RadNumericTextBox Surviouramount = (RadNumericTextBox)item.FindControl("Surviouramount");
                        RadTextBox Remark = (RadTextBox)item.FindControl("Remark");
     
                        oworkorder.workordid = Convert.ToInt32(workordid.Text);
                        oworkorder.workordno = Workorderno.Text;
                        oworkorder.workordat = workorderdate.SelectedDate;
                        oworkorder.contractno = System.Globalization.CultureInfo.CurrentUICulture.TextInfo.ToTitleCase(ContractNo.Text);
                        oworkorder.clientnam = System.Globalization.CultureInfo.CurrentUICulture.TextInfo.ToTitleCase(Clientname.Text);
                        oworkorder.maincontr = System.Globalization.CultureInfo.CurrentUICulture.TextInfo.ToTitleCase(MainCont.Text);
                        oworkorder.mainsubcon = System.Globalization.CultureInfo.CurrentUICulture.TextInfo.ToTitleCase(MainSubCont.Text);
     
     
     
                        oworkorder.worklocatn = System.Globalization.CultureInfo.CurrentUICulture.TextInfo.ToTitleCase(WorklLocation.Text);
                        oworkorder.commencement = DateofCommencement.SelectedDate;
                        oworkorder.completion = DateofCompletion.SelectedDate;
     
                        if (Orderamount.Text != "")
                            oworkorder.orderamount = Convert.ToDecimal(Orderamount.Text);
                        else
                            oworkorder.orderamount = 0;
     
                        if (JointerAmount.Text != "")
                            oworkorder.jointeramt = Convert.ToDecimal(JointerAmount.Text);
                        else
                            oworkorder.jointeramt = 0;
     
                        if (Surviouramount.Text != "")
                            oworkorder.survivoram = Convert.ToDecimal(Surviouramount.Text);
                        else
                            oworkorder.survivoram = 0;
     
                        oworkorder.status = "MOD";
                        oworkorder.oprstamp = usercode;
                        oworkorder.timstamp = DateTime.Now;
                        oworkorder.compcode = compcode;
                        oworkorder.workstatus = "STR";
                        oworkorder.cerfinlamot = null;
                        oworkorder.cerjoinamot = null;
                        oworkorder.cersurvamot = null;
                        oworkorder.actcompletion = null;
                        oworkorder.Remarkss = Remark.Text;
     
                        #region Checknull
     
     
                        if (oworkorder.workordno == "")
                        {
                            Work = 1;
                            RadAjaxManager1.Alert(" Enter Work Order No");
                            Workorderno.Focus();
                        }
                        else { Work = 0; }
     
                        if (oworkorder.worklocatn == "")
                        {
                            Worklct = 1;
                            RadAjaxManager1.Alert(" Enter Work Location");
                            WorklLocation.Focus();
                        }
                        else { Worklct = 0; }
     
                        if (oworkorder.orderamount <= 0)
                        {
                            OrdAmnt = 1;
                            RadAjaxManager1.Alert(" Enter Order Amount ");
                            Orderamount.Focus();
                        }
                        else { OrdAmnt = 0; }
     
                        if (oworkorder.jointeramt < 0)
                        {
                            joinamnt = 1;
                            RadAjaxManager1.Alert(" Enter Jointer Amount ");
                            JointerAmount.Focus();
                        }
                        else { joinamnt = 0; }
     
                        if (oworkorder.survivoram < 0)
                        {
                            survamnt = 1;
                            RadAjaxManager1.Alert(" Enter Surveyor Amount ");
                            Surviouramount.Focus();
                        }
                        else { survamnt = 0; }
     
                        if (workorderdate.IsEmpty)
                        {
                            Workdate = 1;
                            RadAjaxManager1.Alert(" Select The Work Order Date");
                        }
                        else { Workdate = 0; }
     
                        if (DateofCommencement.IsEmpty)
                        {
                            CommDate = 1;
                            RadAjaxManager1.Alert(" Select The Date Commencement");
                        }
                        else { CommDate = 0; }
     
                        if (DateofCompletion.IsEmpty)
                        {
                            CoplDate = 1;
                            RadAjaxManager1.Alert(" Select The Date Completion");
                        }
                        else { CoplDate = 0; }
     
                        if (DateofCommencement.SelectedDate < workorderdate.SelectedDate)
                        {
                            DiiComm = 1;
                            RadAjaxManager1.Alert(" Commencement Date should be greater than Work Order Date");
                        }
                        else { DiiComm = 0; }
     
                        if (DateofCompletion.SelectedDate < DateofCommencement.SelectedDate)
                        {
                            DifComp = 1;
                            RadAjaxManager1.Alert(" Completion Date should be greater than Commencement Date");
                        }
                        else { DifComp = 0; }
     
                        #endregion
     
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var orgreqfinal = (from a in db.dsworkorders
                                               where a.workordno == Workorderno.Text && a.status != "del"
                                               select new { a.workordno, a.clientnam, a.contractno }).ToList();
                            dupcount1 = orgreqfinal.Count();
                        }
     
                        if (dupcount1 == 1)
                        {
                            using (var db = new DoskContractServicesDataContext(Globals.strCon))
                            {
                                var orgreqfinal = (from a in db.dsworkorders
                                                   where a.workordid == oworkorder.workordid
                                                   select new { a.status, a.workstatus }).ToList();
                                string statuschk = orgreqfinal[0].status.ToString();
     
     
                                if (statuschk != "DEL")
                                {
                                    if (oworkorder.workordno != "")
                                    {
                                        try
                                        {
                                            if (Work == 0 && OrdAmnt == 0 && Workdate == 0 && CommDate == 0 && CoplDate == 0 && Worklct == 0 && DiiComm == 0 && DifComp == 0 && survamnt == 0 && joinamnt == 0)
                                            {
                                                DbClient.Update<dsworkorder>(oworkorder, "workordid==" + oworkorder.workordid);
                                                RadGrid1.Rebind();
                                                RadAjaxManager1.Alert("          Data Successfully Modified \n" +
                                                                      "          Work Order No. : " + oworkorder.workordno);
     
                                                RadGrid1.EditIndexes.Clear();
                                                RadGrid1.DataBind();
                                                e.Canceled = true;
                                            }
                                        }
                                        catch (Exception ex)
                                        {
                                            RadGrid1.Controls.Add(new LiteralControl("Unable to update Employee. Reason: " + ex.Message));
                                        }
                                    }
                                    else
                                    {
                                        RadAjaxManager1.Alert("Select Data Type");
                                    }
                                }
                                else
                                { RadAjaxManager1.Alert("This Data is Deleted Data Edit is Not Possible"); }
                            }
                        }
                    }
                }
                else if (e.CommandName == RadGrid.DeleteCommandName)
                {
                    GridDataItem item = (GridDataItem)e.Item;
                    string workid = item["workordid"].Text;
                    string workordeno = item["workordno"].Text;
                    //decimal contracno = item["contractno"].Text;
     
     
                    using (var db = new DoskContractServicesDataContext(Globals.strCon))
                    {
                        var orgreqfinal = (from a in db.dsworkorders
                                           where a.workordid == Convert.ToInt16(workid)
                                           select new { a.status, a.workstatus }).ToList();
                        string statuschk = orgreqfinal[0].status.ToString();
                        string Workchk = orgreqfinal[0].workstatus.ToString();
     
                        if (statuschk != "DEL" && Workchk == "STR")
                        {
                            try
                            {
                                string preference = ("UPDATE dsworkorder SET status = 'DEL' ,WORKSTATUS = 'STR' , oprstamp = '" + usercode + "' where workordid = " + workid);
                                long RecordAffect = oDBClientADO.ExecuteSql(preference);
                                RadGrid1.Rebind();
                                RadAjaxManager1.Alert("             Data Successfully Deleted \n" +
                                                      "          Work Order No. :     " + workordeno);
                            }
                            catch (Exception ex)
                            {
                                RadGrid1.Controls.Add(new LiteralControl("Unable to delete Id. Reason: " + ex.Message));
                                e.Canceled = true;
                            }
                        }
                        else { RadAjaxManager1.Alert("This Data is Already Deleted Or Certification Over "); }
                    }
                }
            }
     
            protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)
            {
                if (e.Item.OwnerTableView.IsItemInserted)
                {
                    RadGrid1.MasterTableView.EditFormSettings.CaptionFormatString = "Create";
                }
                else
                {
                    RadGrid1.MasterTableView.EditFormSettings.CaptionFormatString = "Edit";
                }
                if (e.Item is GridEditFormItem && e.Item.IsInEditMode)
                {
                    if (e.Item.OwnerTableView.IsItemInserted)
                    {
                        GridEditFormItem item = (GridEditFormItem)e.Item;
                        RadTextBox workordno = (RadTextBox)item.FindControl("Workorderno");
                        RadDatePicker dtcommencement1 = item.FindControl("DateofCommencement") as RadDatePicker;
                        RadDatePicker dtcompletion = item.FindControl("DateofCompletion") as RadDatePicker;
                        workordno.Focus();
                    }
                    else
                    {
                        GridEditFormItem item = (GridEditFormItem)e.Item;
                        RadTextBox workordno = (RadTextBox)item.FindControl("Workorderno");
                        RadDatePicker workorderdate = item.FindControl("workorderdate") as RadDatePicker;
                        RadTextBox ContractNo = (RadTextBox)item.FindControl("ContractNo");
                        RadTextBox Clientname = (RadTextBox)item.FindControl("Clientname");
                        RadTextBox MainCont = (RadTextBox)item.FindControl("MainCont");
                        RadTextBox MainSubCont = (RadTextBox)item.FindControl("MainSubCont");
                        RadTextBox WorklLocation = (RadTextBox)item.FindControl("WorlLocation");
                        RadDatePicker dtcommencement1 = item.FindControl("DateofCommencement") as RadDatePicker;
                        RadDatePicker dtcompletion = item.FindControl("DateofCompletion") as RadDatePicker;
                        RadNumericTextBox Orderamount = item.FindControl("Orderamount") as RadNumericTextBox;
                        RadNumericTextBox JointerAmount = item.FindControl("JointerAmount") as RadNumericTextBox;
                        RadNumericTextBox Surviouramount = item.FindControl("Surviouramount") as RadNumericTextBox;
                        RadTextBox Remark = (RadTextBox)item.FindControl("Remark");
     
                        workordno.ReadOnly = true;
                        ContractNo.Focus();
     
                        if (e.Item.IsInEditMode)
                        {
                            GridEditableItem editedItem = e.Item as GridEditableItem;
                            GridEditFormItem editForm = (GridEditFormItem)e.Item;
                            string workid = editForm["workordid"].Text;
     
                            if (workid != " ")
                            {
                                if (Convert.ToInt32(workid) > 0)
                                {
     
                                    using (var db = new DoskContractServicesDataContext(Globals.strCon))
                                    {
     
                                        var checkwork = (from a in db.dsworkorders
                                                         where a.workordid == Convert.ToInt32(workid)
                                                         select new { a.workstatus }).ToList();
     
                                        string workchk = checkwork[0].workstatus.ToString();
                                        if (workchk == "STR")
                                        {
                                            var Projtext = (from a in db.dsworkorders
                                                            where a.workordid == Convert.ToInt32(workid) && a.workstatus == "STR"
                                                            select new { a.workordid, a.workordno, a.workordat, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
     
                                            workordno.Text = Projtext[0].workordno.ToString();
                                            workorderdate.SelectedDate = Projtext[0].workordat;
                                            ContractNo.Text = Projtext[0].contractno.ToString();
                                            Clientname.Text = Projtext[0].clientnam.ToString();
                                            MainCont.Text = Projtext[0].maincontr.ToString();
                                            MainSubCont.Text = Projtext[0].mainsubcon.ToString();
                                            WorklLocation.Text = Projtext[0].worklocatn.ToString();
                                            dtcommencement1.SelectedDate = Projtext[0].commencement;
                                            dtcompletion.SelectedDate = Projtext[0].completion;
                                            Orderamount.Text = Projtext[0].orderamount.ToString();
                                            JointerAmount.Text = Projtext[0].jointeramt.ToString();
                                            Surviouramount.Text = Projtext[0].survivoram.ToString();
                                            Remark.Text = Projtext[0].Remarkss.ToString();
                                        }
                                        else
                                        {
                                            RadGrid1.EditIndexes.Clear();
                                            RadGrid1.DataBind();
                                            RadAjaxManager1.Alert("This Work Order Already Certification is Done Cannot Be Edited");
                                            e.Canceled = true;
     
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
     
            protected void RadGrid1_PreRender(object sender, EventArgs e)
            {
                GridCommandItem commandItem = RadGrid1.MasterTableView.GetItems(GridItemType.CommandItem)[0] as GridCommandItem;
                RadToolBar toolBar = commandItem.FindControl("RadToolBar1") as RadToolBar;
                RadToolBarItem textItem = toolBar.FindItemByValue("HeaderDisplay");
                RadComboBox Comobovalue = (RadComboBox)textItem.FindControl("DeleteOption");
                RadComboBox Pending = (RadComboBox)textItem.FindControl("PendingSearch");
                GridHeaderItem item = RadGrid1.MasterTableView.GetItems(GridItemType.Header)[0] as GridHeaderItem;
                Comobovalue.SelectedValue = DeleteOption;
                Pending.SelectedValue = PendingSearch;
     
                //foreach (GridDataItem item1 in RadGrid1.Items)
                //{
                //    RadButton btn = (RadButton)item1.FindControl("Work");
     
                //    if (PendingSearch == "Completed" || PendingSearch == "Pending")
                //    {
                //        item["WorkNoAss"].Visible = true;                   
                //        btn.Visible = true;
                //    }
                //    else
                //    {
                //        //item["WorkNoAss"].Visible = false;
                //        item["WorkNoAss"].Text = "";
                //        btn.Visible = false;
                //    }
                //}
            }
     
            protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
            {
                if (e.Item is GridEditableItem && e.Item.IsInEditMode)
                {
                    RadDatePicker workorderdate = (RadDatePicker)e.Item.FindControl("workorderdate");
                    RadDatePicker DateofCommencement = (RadDatePicker)e.Item.FindControl("DateofCommencement");
                    RadDatePicker DateofCompletion = (RadDatePicker)e.Item.FindControl("DateofCompletion");
                    RadNumericTextBox jointeramt = (RadNumericTextBox)e.Item.FindControl("JointerAmount");
                    RadNumericTextBox survivoram = (RadNumericTextBox)e.Item.FindControl("Surviouramount");
     
     
                    DateofCommencement.ClientEvents.OnDateSelected = "function (button,button1,args){changeEndDate('" + workorderdate.ClientID + "','" + DateofCommencement.ClientID + "','0');}";
                    DateofCompletion.ClientEvents.OnDateSelected = "function (button,button1,args){changeEndDate('" + DateofCommencement.ClientID + "','" + DateofCompletion.ClientID + "','1');}";
                    survivoram.Attributes.Add("onblur", string.Format("Surviour('{0}');", survivoram.ClientID));
                    jointeramt.Attributes.Add("onblur", string.Format("Jointer('{0}');", jointeramt.ClientID));
     
     
                }
            }
     
            protected void DeleteOption_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
            {
                GridCommandItem commandItem = RadGrid1.MasterTableView.GetItems(GridItemType.CommandItem)[0] as GridCommandItem;
                RadToolBar toolBar = commandItem.FindControl("RadToolBar1") as RadToolBar;
                RadToolBarItem textItem = toolBar.FindItemByValue("HeaderDisplay");
                RadComboBox Comobovalue = (RadComboBox)textItem.FindControl("DeleteOption");
                RadComboBox Pending = (RadComboBox)textItem.FindControl("PendingSearch");
                DeleteOption = Comobovalue.SelectedValue;
                PendingSearch = Pending.SelectedValue;
     
                #region ALL
     
                if (DeleteOption == "All")
                {
                    if (PendingSearch == "All1")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                    else if (PendingSearch == "Pending")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.workstatus == "STR"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                    else if (PendingSearch == "Completed")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.compcode == compcode && a.workstatus == "STC"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                    else if (PendingSearch == "Certified")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.workstatus != "STR"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                }
     
                #endregion
     
                #region DELETED
     
                else if (DeleteOption == "Deleted")
                {
                    if (PendingSearch == "All1")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status == "DEL" && a.compcode == compcode
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                    else if (PendingSearch == "Pending")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status == "DEL" && a.compcode == compcode && a.workstatus == "STR"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                    else if (PendingSearch == "Completed")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status == "DEL" && a.compcode == compcode && a.workstatus == "STC"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                    else if (PendingSearch == "Certified")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status == "DEL" && a.compcode == compcode && a.workstatus != "STR"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
     
                }
     
                #endregion
     
                #region NOT DELETED
     
     
                else if (DeleteOption == "Not Deleted")
                {
                    if (PendingSearch == "All1")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status != "DEL" && a.compcode == compcode
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                    else if (PendingSearch == "Pending")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status != "DEL" && a.compcode == compcode && a.workstatus == "STR"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                    else if (PendingSearch == "Completed")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status != "DEL" && a.compcode == compcode && a.workstatus == "STC"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                    else if (PendingSearch == "Certified")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status != "DEL" && a.compcode == compcode && a.workstatus != "STR"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                }
     
                #endregion
            }
     
            protected void PendingSearch_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
            {
                GridCommandItem commandItem = RadGrid1.MasterTableView.GetItems(GridItemType.CommandItem)[0] as GridCommandItem;
                RadToolBar toolBar = commandItem.FindControl("RadToolBar1") as RadToolBar;
                RadToolBarItem textItem = toolBar.FindItemByValue("HeaderDisplay");
                RadComboBox Comobovalue = (RadComboBox)textItem.FindControl("DeleteOption");
                RadComboBox Pending = (RadComboBox)textItem.FindControl("PendingSearch");
                DeleteOption = Comobovalue.SelectedValue;
                PendingSearch = Pending.SelectedValue;
     
                #region ALL
     
                if (DeleteOption == "All")
                {
                    if (PendingSearch == "All1")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                    else if (PendingSearch == "Pending")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.workstatus == "STR"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                    else if (PendingSearch == "Completed")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.compcode == compcode && a.workstatus == "STC"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                    else if (PendingSearch == "Certified")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.workstatus != "STR"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                }
     
                #endregion
     
                #region DELETED
     
                else if (DeleteOption == "Deleted")
                {
                    if (PendingSearch == "All1")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status == "DEL" && a.compcode == compcode
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                    else if (PendingSearch == "Pending")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status == "DEL" && a.compcode == compcode && a.workstatus == "STR"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                    else if (PendingSearch == "Completed")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status == "DEL" && a.compcode == compcode && a.workstatus == "STC"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                    else if (PendingSearch == "Certified")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status == "DEL" && a.compcode == compcode && a.workstatus != "STR"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
     
                }
     
                #endregion
     
                #region NOT DELETED
     
     
                else if (DeleteOption == "Not Deleted")
                {
                    if (PendingSearch == "All1")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status != "DEL" && a.compcode == compcode
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                    else if (PendingSearch == "Pending")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status != "DEL" && a.compcode == compcode && a.workstatus == "STR"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                    else if (PendingSearch == "Completed")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status != "DEL" && a.compcode == compcode && a.workstatus == "STC"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                    else if (PendingSearch == "Certified")
                    {
                        using (var db = new DoskContractServicesDataContext(Globals.strCon))
                        {
                            var result = (from a in db.dsworkorders
                                          where a.status != "DEL" && a.compcode == compcode && a.workstatus != "STR"
                                          select new { a.workordid, a.workordno, a.contractno, a.clientnam, a.maincontr, a.mainsubcon, a.worklocatn, a.commencement, a.completion, a.orderamount, a.jointeramt, a.survivoram, a.Remarkss }).ToList();
                            RadGrid1.DataSource = result;
                            RadGrid1.Rebind();
                        }
                    }
                }
     
                #endregion
            }
        }
    }

    .cs page

    that is my coding side

    thanks advance,
    Mohamed




Back to Top