Radscheduler1.Resources(0).Color = color<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="RadGrid1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadGrid1" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <asp:EntityDataSource ID="dsTypes" runat="server" ConnectionString="name=Entities" DefaultContainerName="Entities" EnableFlattening="False" EntitySetName="Types"> </asp:EntityDataSource> <asp:EntityDataSource ID="dsCustomerData" runat="server" ConnectionString="name=Entities" DefaultContainerName="Entities" EnableFlattening="False" EnableUpdate="True" EnableInsert="true" EntitySetName="CustomerData" AutoGenerateWhereClause="True" Include="Type"> </asp:EntityDataSource> <telerik:RadGrid ID="RadGrid1" runat="server" GridLines="None" DataSourceID="dsCustomerData" AutoGenerateColumns="False" AutoGenerateEditColumn="True" AutoGenerateDeleteColumn="True" > <MasterTableView DataSourceID="dsCustomerData" DataKeyNames="CustomerDataID"> <RowIndicatorColumn> <HeaderStyle Width="20px"></HeaderStyle> </RowIndicatorColumn> <ExpandCollapseColumn> <HeaderStyle Width="20px"></HeaderStyle> </ExpandCollapseColumn> <Columns> <telerik:GridDropDownColumn DataField="TypeID" DataSourceID="dsTypes" HeaderText="Type" ListTextField="TypeName" ListValueField="TypeID" UniqueName="TypeID"> </telerik:GridDropDownColumn> <telerik:GridBoundColumn DataField="Make" HeaderText="Make" UniqueName="column"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Model" HeaderText="Age" UniqueName="column1"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Age" HeaderText="Age" UniqueName="column2"> </telerik:GridBoundColumn> </Columns> </MasterTableView> </telerik:RadGrid><CommandItemTemplate> <table> <tr> <td align="left"> <b>Bulk Actions</b> </td> <td align="left"> <asp:LinkButton ID="btnEditSelected" runat="server" CommandName="EditSelected" Visible='<%# rg200.EditIndexes.Count == 0 %>'><img style="border:0px;vertical-align:middle;" alt="" src="Images/Edit.gif" />Edit selected</asp:LinkButton> </td> <td align="left"> <asp:LinkButton ID="btnUpdateEdited" runat="server" CommandName="UpdateEdited" Visible='<%# rg200.EditIndexes.Count > 0 %>'><img style="border:0px;vertical-align:middle;" alt="" src="Images/Update.gif" />Update</asp:LinkButton> </td> <td align="left"> <asp:LinkButton ID="btnCancel" runat="server" CommandName="CancelAll" Visible='<%# rg200.EditIndexes.Count > 0 || rg200.MasterTableView.IsItemInserted %>'><img style="border:0px;vertical-align:middle;" alt="" src="Images/Cancel.gif" />Cancel editing</asp:LinkButton> </td> <td align="right"> <img style="border: 0px; vertical-align: middle;" alt="" src="Images/AddRecord.gif" /> </td> <td align="left"> <asp:LinkButton ID="LinkButton2" runat="server" CommandName="InitInsert" Visible='<%# !rg200.MasterTableView.IsItemInserted %>'>Add New Record</asp:LinkButton> </td> <td align="right"> <img style="border: 0px; vertical-align: middle;" alt="" src="Images/Delete.gif" /> </td> <td align="left"> <asp:LinkButton ID="LinkButton1" OnClientClick="javascript:return confirm('Delete all selected Records?')" runat="server" CommandName="DeleteSelected">Delete Selected</asp:LinkButton> </td> <td align="right"> <img style="border: 0px; vertical-align: middle;" alt="" src="Images/Refresh.gif" /> </td> <td align="left"> <asp:LinkButton ID="LinkButton4" runat="server" CommandName="Rebind">Refresh</asp:LinkButton> </td></tr> </table> </CommandItemTemplate>clsTaskUpdates_BL objBL = new clsTaskUpdates_BL();GridEditableItem editedItem = e.Item as GridEditableItem;string OrdID = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["orderId"].ToString();string ClarifyAccountNbr = (editedItem.FindControl("TextBox1") as TextBox).Text;string SiteID = (editedItem.FindControl("TextBox2") as TextBox).Text;string QuoteID = (editedItem.FindControl("TextBox3") as TextBox).Text;CheckBox chkEDP = (editedItem.FindControl("CheckBox1") as CheckBox);try{ objBL.setTask200_Bl(OrdID, ClarifyAccountNbr, SiteID, QuoteID, chkEDP.Checked); Session["SearchRes"] = null; rg200.Rebind();}catch (Exception ex){ rg200.Controls.Add(new LiteralControl("Unable to update Employee. Reason: " + ex.Message)); e.Canceled = true;}if (e.CommandName == "UpdateEdited") { foreach (GridEditableItem editedItem in rg200.EditItems) { GridDataItem dataitem = editedItem as GridDataItem; clsTaskUpdates_BL objBL = new clsTaskUpdates_BL(); string OrdID = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["orderId"].ToString(); string ClarifyAccountNbr = (editedItem.FindControl("TextBox1") as TextBox).Text; string SiteID = (editedItem.FindControl("TextBox2") as TextBox).Text; string QuoteID = (editedItem.FindControl("TextBox3") as TextBox).Text; CheckBox chkEDP = (editedItem.FindControl("CheckBox1") as CheckBox); try { objBL.setTask200_Bl(OrdID, ClarifyAccountNbr, SiteID, QuoteID, chkEDP.Checked); Session["SearchRes"] = null; rg200.Rebind(); } catch (Exception ex) { rg200.Controls.Add(new LiteralControl("Unable to update Employee. Reason: " + ex.Message)); e.Canceled = true; } } }<EditFormSettings EditFormType="Template"> <FormTemplate> <table id="Table1" cellspacing="1" cellpadding="1"> <tr> <td> <telerik:RadTabStrip runat="server" ID="RadTabStrip1" Orientation="HorizontalTop" SelectedIndex="0" MultiPageID="RadMultiPage1"> <Tabs> <telerik:RadTab Text="Task Data" PageViewID="RadPageView1"> </telerik:RadTab> <telerik:RadTab Text="Notes" PageViewID="RadPageView2"> </telerik:RadTab> </Tabs> </telerik:RadTabStrip> <telerik:RadMultiPage runat="server" ID="RadMultiPage1" SelectedIndex="0"> <telerik:RadPageView runat="server" ID="RadPageView1"> <table id="Table3" cellspacing="1" cellpadding="1" width="250" border="0" class="module"> <tr> <td> </td> <td> </td> </tr> <tr> <td> Clarify Account Nbr: </td> <td> <asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval( "Clarify Account Nbr" ) %>'> </asp:TextBox> </td> </tr> <tr> <td> Site ID: </td> <td> <asp:TextBox ID="TextBox2" runat="server" Text='<%# Eval( "Site ID") %>' TabIndex="1"> </asp:TextBox> </td> </tr> <tr> <td> Quote ID: </td> <td> <asp:TextBox ID="TextBox3" runat="server" Text='<%# Eval( "Quote ID") %>' TabIndex="2"> </asp:TextBox> </td> </tr> <tr> <td> EDP Created?: </td> <td> <asp:CheckBox ID="CheckBox1" runat="server" Text='<%# Eval( "EDP Created?") %>' TabIndex="3"> </asp:CheckBox> </td> </tr> <tr> <td align="right" colspan="2"> <asp:Button ID="btnUpdate" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>' runat="server" CommandName='Update'></asp:Button> <asp:Button ID="btnCancel" Text="Cancel" runat="server" CausesValidation="False" CommandName="Cancel"></asp:Button> </td> </tr> </table> </telerik:RadPageView> <telerik:RadPageView runat="server" ID="RadPageView2"> </telerik:RadPageView> </telerik:RadMultiPage> </td> </tr> </table> </FormTemplate> </EditFormSettings> protected void Page_Init(object sender, System.EventArgs e) { DefineGridStructure(); // this method will populate this RadGrid1. } private void DefineGridStructure() { // populate this RadGrid1. string sqlCxn = "Data Source=DESQL2008;Initial Catalog=DrawOnTime;User Id=ontimeweb;Password=ontime1234;", sql2008; sql2008 = "select IncidentId, IncidentNumber, Incidents.Name, " + " CASE " + " WHEN DATEPART (YYYY,ReportedDate)=1899 THEN ' / / '" + " ELSE" + " CONVERT (char(8),ReportedDate,1)" + " END " + " as 'Reported Date'," + " Substring(Incidents.Description,1,72)+'\n'+" + " Substring(Incidents.Description,73,72)+'\n'+" + " Substring(Incidents.Description,145,72)+'\n'+" + " Substring(Incidents.Description,217,72) as IncidentDesc," + "Users.FirstName + ' '+" + "Users.LastName as 'IT Employee Assigned', WorkFlowSteps.StepName as 'Flow'," + "000.00 as nLabor, space(40) as workDescr" + " from incidents " + "left join WorkFlowSteps on Incidents.WorkFlowStepId = WorkFlowSteps.WorkFlowStepId " + "left join WorkLog on IncidentId = ItemId " + " left join Users on Users.UserId=Incidents.AssignedToId " + " where (WorkLogId is null and Left(WorkFlowSteps.StepName,6) <>'Closed' and Left(WorkFlowSteps.StepName,3) <>'UAT' and " + "Left(WorkFlowSteps.StepName,4)<>'Hold' ) and " + " ( AssignedToId=0 or AssignedToId = @UID ) "; SqlConnection dbconn = new SqlConnection(sqlCxn), dbconn2; dbconn2 = new SqlConnection(sqlCxn); dbconn.Open(); dbconn2.Open(); SqlCommand myCommand = new SqlCommand(sql2008, dbconn), mycommand2; mycommand2 = new SqlCommand(sql2008, dbconn2); SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand), myAdapter2; myAdapter2 = new SqlDataAdapter(mycommand2); DataSet ds = new DataSet(), ds2; ds2 = new DataSet(); myCommand.Parameters.AddWithValue("UID", 5); //Default.UID); myAdapter.Fill(ds);// if (ds.Tables[0].Rows.Count == 0) // this.btnSubmit.Visible = false; // .Enabled = false; mycommand2.Parameters.AddWithValue("UID", 5); myAdapter2.Fill(ds2); RadGrid1.DataSource = ds; RadGrid1.DataBind();/* RadGrid2.DataSource = ds2; RadGrid2.DataBind(); */ RadGrid2.Visible = false;// RadGrid1.Visible = true; }}<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Default" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title> <telerik:RadStyleSheetManager id="RadStyleSheetManager1" runat="server" /></head><body> <form id="form1" runat="server"> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> <Scripts> <%--Needed for JavaScript IntelliSense in VS2010--%> <%--For VS2008 replace RadScriptManager with ScriptManager--%> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" /> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" /> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" /> </Scripts> </telerik:RadScriptManager> <script type="text/javascript"> //Put your JavaScript code here. </script> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> </telerik:RadAjaxManager> <div> </div> <telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False" Width = "817px" Height="341px" MasterTableView-CanRetrieveAllData ="true" MasterTableView-Visible ="true" AllowAutomaticUpdates="True" ><MasterTableView><RowIndicatorColumn><HeaderStyle Width="20px"></HeaderStyle></RowIndicatorColumn><ExpandCollapseColumn><HeaderStyle Width="20px"></HeaderStyle></ExpandCollapseColumn> <Columns> <telerik:GridBoundColumn DataField="IncidentNumber" HeaderText="Incident #" ReadOnly="True" UniqueName="column"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Name" HeaderText="Subject" UniqueName="column1"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ActualDuration" DataType="System.Decimal" DefaultInsertValue="0.00" HeaderText="Actual Duration" Resizable="False" UniqueName="column2"> </telerik:GridBoundColumn> </Columns></MasterTableView> </telerik:RadGrid> <telerik:RadGrid ID="RadGrid2" runat="server" GridLines="None" style="margin-top: 27px"><MasterTableView AutoGenerateColumns="False" DataKeyNames="IncidentId"><RowIndicatorColumn><HeaderStyle Width="20px"></HeaderStyle></RowIndicatorColumn><ExpandCollapseColumn><HeaderStyle Width="20px"></HeaderStyle></ExpandCollapseColumn> <Columns> <telerik:GridBoundColumn DataField="IncidentId" DataType="System.Int32" HeaderText="IncidentId" ReadOnly="True" SortExpression="IncidentId" UniqueName="IncidentId"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="IncidentNumber" HeaderText="IncidentNumber" SortExpression="IncidentNumber" UniqueName="IncidentNumber"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Name" HeaderText="Name" SortExpression="Name" UniqueName="Name"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Description" HeaderText="Description" SortExpression="Description" UniqueName="Description"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ReplicationProcedures" HeaderText="ReplicationProcedures" SortExpression="ReplicationProcedures" UniqueName="ReplicationProcedures"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Resolution" HeaderText="Resolution" SortExpression="Resolution" UniqueName="Resolution"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Notes" HeaderText="Notes" SortExpression="Notes" UniqueName="Notes"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="PriorityTypeId" DataType="System.Int32" HeaderText="PriorityTypeId" SortExpression="PriorityTypeId" UniqueName="PriorityTypeId"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="StatusTypeId" DataType="System.Int32" HeaderText="StatusTypeId" SortExpression="StatusTypeId" UniqueName="StatusTypeId"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="SeverityTypeId" DataType="System.Int32" HeaderText="SeverityTypeId" SortExpression="SeverityTypeId" UniqueName="SeverityTypeId"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ProjectId" DataType="System.Int32" HeaderText="ProjectId" SortExpression="ProjectId" UniqueName="ProjectId"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ReportedById" DataType="System.Int32" HeaderText="ReportedById" SortExpression="ReportedById" UniqueName="ReportedById"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="AssignedToId" DataType="System.Int32" HeaderText="AssignedToId" SortExpression="AssignedToId" UniqueName="AssignedToId"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="WorkflowStepId" DataType="System.Int32" HeaderText="WorkflowStepId" SortExpression="WorkflowStepId" UniqueName="WorkflowStepId"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ReportedByCustomerContactId" DataType="System.Int32" HeaderText="ReportedByCustomerContactId" SortExpression="ReportedByCustomerContactId" UniqueName="ReportedByCustomerContactId"> </telerik:GridBoundColumn> <telerik:GridCheckBoxColumn DataField="PubliclyViewable" DataType="System.Boolean" HeaderText="PubliclyViewable" SortExpression="PubliclyViewable" UniqueName="PubliclyViewable"> </telerik:GridCheckBoxColumn> <telerik:GridBoundColumn DataField="ReportedDate" DataType="System.DateTime" HeaderText="ReportedDate" SortExpression="ReportedDate" UniqueName="ReportedDate"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="StartDate" DataType="System.DateTime" HeaderText="StartDate" SortExpression="StartDate" UniqueName="StartDate"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DueDate" DataType="System.DateTime" HeaderText="DueDate" SortExpression="DueDate" UniqueName="DueDate"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CompletionDate" DataType="System.DateTime" HeaderText="CompletionDate" SortExpression="CompletionDate" UniqueName="CompletionDate"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ActualDuration" DataType="System.Single" HeaderText="ActualDuration" SortExpression="ActualDuration" UniqueName="ActualDuration"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ActualUnitTypeId" DataType="System.Int32" HeaderText="ActualUnitTypeId" SortExpression="ActualUnitTypeId" UniqueName="ActualUnitTypeId"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="EstimatedDuration" DataType="System.Single" HeaderText="EstimatedDuration" SortExpression="EstimatedDuration" UniqueName="EstimatedDuration"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DurationUnitTypeId" DataType="System.Int32" HeaderText="DurationUnitTypeId" SortExpression="DurationUnitTypeId" UniqueName="DurationUnitTypeId"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="PercentComplete" DataType="System.Byte" HeaderText="PercentComplete" SortExpression="PercentComplete" UniqueName="PercentComplete"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="EscalationLevelId" DataType="System.Int32" HeaderText="EscalationLevelId" SortExpression="EscalationLevelId" UniqueName="EscalationLevelId"> </telerik:GridBoundColumn> <telerik:GridCheckBoxColumn DataField="Archived" DataType="System.Boolean" HeaderText="Archived" SortExpression="Archived" UniqueName="Archived"> </telerik:GridCheckBoxColumn> <telerik:GridBoundColumn DataField="CreatedDateTime" DataType="System.DateTime" HeaderText="CreatedDateTime" SortExpression="CreatedDateTime" UniqueName="CreatedDateTime"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CreatedById" DataType="System.Int32" HeaderText="CreatedById" SortExpression="CreatedById" UniqueName="CreatedById"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="LastUpdatedDateTime" DataType="System.DateTime" HeaderText="LastUpdatedDateTime" SortExpression="LastUpdatedDateTime" UniqueName="LastUpdatedDateTime"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="LastUpdatedById" DataType="System.Int32" HeaderText="LastUpdatedById" SortExpression="LastUpdatedById" UniqueName="LastUpdatedById"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="RemainingDuration" DataType="System.Single" HeaderText="RemainingDuration" SortExpression="RemainingDuration" UniqueName="RemainingDuration"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="RemainingUnitTypeId" DataType="System.Int32" HeaderText="RemainingUnitTypeId" SortExpression="RemainingUnitTypeId" UniqueName="RemainingUnitTypeId"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ReleaseId" DataType="System.Int32" HeaderText="ReleaseId" SortExpression="ReleaseId" UniqueName="ReleaseId"> </telerik:GridBoundColumn> </Columns></MasterTableView> </telerik:RadGrid> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand="select * from incidents where incidentid >1500"> </asp:SqlDataSource> </form></body></html><telerik:RadGrid Skin="Vista" ID="GrigliaProgetti" runat="server" Width="500px" Height="400px" AutoGenerateColumns="false" AllowPaging="true" AllowSorting="true"> <PagerStyle Mode="NextPrevAndNumeric" /> <GroupingSettings CaseSensitive="false" /> <MasterTableView TableLayout="Fixed" > <Columns> <telerik:GridNumericColumn HeaderText="Project Id"/> <telerik:GridBoundColumn HeaderText="Project name"/> </Columns> </MasterTableView> </telerik:RadGrid> function onCheckBoxClick(chk) {
var combo = $find("<%= rcbDocType.ClientID %>");
//holds the text of all checked items
var text = "";
//holds the values of all checked items
var values = "";
//get the collection of all items
var items = combo.get_items();
//enumerate all items
for (var i = 0; i < items.get_count(); i++) {
var item = items.getItem(i);
//get the checkbox element of the current item
var chk1 = $get(combo.get_id() + "_i" + i + "_cbItem");
if (chk1.checked) {
if (text == "") {
text = item.get_text();
}
else {
text = "[Multi]";
}
values += item.get_value() + ",";
}
}
//remove the last comma from the string
values = removeLastComma(values);
if (text.length > 0) {
//set the text of the combobox
combo.set_text(text);
}
else {
//all checkboxes are unchecked
//so reset the controls
combo.set_text("");
}
}
//this method removes the ending comma from a string
function removeLastComma(str) {
return str.replace(/,$/, "");
}
function StopPropagation(e) {
//cancel bubbling
e.cancelBubble = true;
if (e.stopPropagation) {
e.stopPropagation();
}
}