This is a migrated thread and some comments may be shown as answers.

RadCombobox onchange

8 Answers 1641 Views

ComboBox

This is a migrated thread and some comments may be shown as answers.

8 Answers, 1 is accepted

answered on 02 Jan 2013, 11:54 AM

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.

answered on 02 Jan 2013, 02:05 PM

Work.GIF

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.

answered on 03 Jan 2013, 04:04 AM

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.

answered on 04 Jan 2013, 05:02 AM

<%@ 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 />

<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");