<Telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
<AjaxSettings>
<Telerik:AjaxSetting AjaxControlID ="dgvDevelopmentActivity">
<UpdatedControls>
<Telerik:AjaxUpdatedControl ControlID ="dgvDevelopmentActivity" LoadingPanelID ="Radajaxloadingpanel1" />
<telerik:AjaxUpdatedControl ControlID="RadWindowManager1" />
</UpdatedControls>
</Telerik:AjaxSetting>
<Telerik:AjaxSetting AjaxControlID ="dgvFunctionalStrength">
<UpdatedControls>
<Telerik:AjaxUpdatedControl ControlID ="dgvFunctionalStrength" LoadingPanelID ="Radajaxloadingpanel1" />
<telerik:AjaxUpdatedControl ControlID="RadWindowManager1" />
</UpdatedControls>
</Telerik:AjaxSetting>
</AjaxSettings>
</Telerik:RadAjaxManager>
<Telerik:RadStyleSheetManager ID="RadStyleSheetManager1" runat="server">
</Telerik:RadStyleSheetManager>
<
Telerik:RadGrid ID="dgvLeadershipStrength" runat="server"
AllowMultiRowEdit="true" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" GridLines="None"
OnItemCommand="dgvLeadershipStrength_ItemCommand"
OnItemCreated="dgvLeadershipStrength_ItemCreated"
OnItemDataBound="dgvLeadershipStrength_ItemDataBound"
OnNeedDataSource="dgvLeadershipStrength_NeedDataSource" PageSize="7"
ShowStatusBar="true" Skin="Outlook" Width="750px">
<headercontextmenu enableautoscroll="True">
</headercontextmenu>
<mastertableview commanditemdisplay="Top" datakeynames="DetailID" dir="LTR" editmode="EditForms" >
<commanditemsettings addnewrecordtext="Leadership Strength" ShowRefreshButton ="false" />
<Columns>
<Telerik:GridEditCommandColumn ButtonType="ImageButton" HeaderText="Edit">
<ItemStyle Width="20px" />
</Telerik:GridEditCommandColumn>
<Telerik:GridBoundColumn AutoPostBackOnFilter="true" ColumnEditorID="txtVanish"
DataField="DetailID" HeaderText="Vanish" UniqueName="colVanished"
Visible="false">
</Telerik:GridBoundColumn>
<Telerik:GridBoundColumn AutoPostBackOnFilter="true"
ColumnEditorID="ddlCompetency" DataField="Competency" HeaderText="Competency"
UniqueName="colCompetency">
</Telerik:GridBoundColumn>
<Telerik:GridBoundColumn AutoPostBackOnFilter="true"
ColumnEditorID="ddlCompetencyArea" DataField="area" HeaderText="areas"
SortExpression="area" UniqueName="colCompetencyArea">
</Telerik:GridBoundColumn>
<Telerik:GridBoundColumn AutoPostBackOnFilter="true" ColumnEditorID="ddlLevel"
DataField="level" HeaderText="Level" SortExpression="level"
UniqueName="colLevel">
</Telerik:GridBoundColumn>
<Telerik:GridBoundColumn AutoPostBackOnFilter="true"
ColumnEditorID="ddlIndicator" DataField="Indicator" HeaderText="Indicator"
SortExpression="Name" UniqueName="colIndicator">
</Telerik:GridBoundColumn>
<Telerik:GridBoundColumn DataField="Evidence" HeaderText="Evidence"
SortExpression="Evidence" UniqueName="colEvidence" />
<Telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete"
HeaderText="Delete" UniqueName="DeleteColumn" />
</Columns>
<editformsettings editformtype="Template"
formstyle-backcolor="Transparent">
<editcolumn uniquename="EditCommandColumn1">
</editcolumn>
<formstyle backcolor="Transparent" />
<formtemplate>
<div style="width: 100%; height: 100%">
<table border="0" cellspacing="2" style="width: 100%; border-color: #99ccff">
<tr>
<td style="width: 10%; text-align: left; vertical-align: top;" visible="false">
<asp:Label ID="lblVanish" runat="server" CssClass="captionlbl" Visible="false"
Width="100px"><b>Vanish</b></asp:Label>
</td>
<td style="width: 60%; text-align: left;" visible="false">
<Telerik:RadTextBox ID="txtVanish" runat="Server" AutoPostBack="True"
Text='<%# Eval("DetailID") %>' Visible="false" Width="500px">
</Telerik:RadTextBox>
</td>
</tr>
<tr>
<td style="width: 10%; text-align: left; vertical-align: top;">
<asp:Label ID="Competency" runat="server" CssClass="captionlbl" Width="100px"><b>Competency</b></asp:Label>
</td>
<td style="width: 60%; text-align: left;">
<Telerik:RadComboBox ID="ddlCompetency" runat="Server" AutoPostBack="True"
OnSelectedIndexChanged="ddlCompetency_SelectedIndexChanged" Skin="Outlook"
TabIndex="1" Width="500px">
</Telerik:RadComboBox>
</td>
</tr>
<tr>
<td style="vertical-align: top; width: 10%; text-align: left;">
<asp:Label ID="CompetencyArea" runat="server" CssClass="captionlbl"
Height="15px"><b>Area</b></asp:Label>
</td>
<td style="width: 60%; text-align: left;">
<Telerik:RadComboBox ID="ddlCompetencyArea" runat="Server" AutoPostBack="True"
OnSelectedIndexChanged="ddlCompetencyArea_SelectedIndexChanged" Skin="Outlook"
TabIndex="2" Width="500px">
</Telerik:RadComboBox>
</td>
</tr>
<tr>
<td style="width: 10%; text-align: left; height: 15px;">
<asp:Label ID="lblLevel" runat="server" CssClass="captionlbl"><b>Level</b></asp:Label>
</td>
<td style="width: 60%; text-align: left;">
<Telerik:RadComboBox ID="ddlLevel" runat="Server" AutoPostBack="True"
OnSelectedIndexChanged="ddlLevel_SelectedIndexChanged" Skin="Outlook"
TabIndex="3" Width="500px">
</Telerik:RadComboBox>
</td>
</tr>
<tr>
<td style="vertical-align: top; width: 10%; text-align: left; height: 15px;">
<asp:Label ID="lblIndicator" runat="server" CssClass="captionlbl"><b>Indicator</b></asp:Label>
</td>
<td style="width: 60%; text-align: left;">
<Telerik:RadComboBox ID="ddlIndicator" runat="Server" AutoPostBack="True"
Skin="Outlook" TabIndex="4" Width="500px">
</Telerik:RadComboBox>
</td>
</tr>
<tr>
<td style="vertical-align: top; width: 10%; text-align: left; height: 15px;">
<asp:Label ID="lblEvidance" runat="server" CssClass="captionlbl"><b>Evidance</b></asp:Label>
</td>
<td style="width: 60%; text-align: left;">
<Telerik:RadTextBox ID="txtEvidence" runat="server" AutoPostBack="true"
Skin="Outlook" Text='<%# Eval("Evidence", "{0:C}") %>' Width="500px">
</Telerik:RadTextBox>
</td>
</tr>
<tr style="width: 100%">
<td colspan="2" style="height: 15px; text-align: left;">
</td>
</tr>
<tr>
<td align="left" colspan="2">
<asp:Button ID="btnEmpKrainsert" runat="server" CommandName='<%# (Container is Telerik.Web.UI.GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'
Text='<%# (Container is Telerik.Web.UI.GridEditFormInsertItem) ? "Insert" : "Update" %>'
Width="70px" Font-Bold ="true" ForeColor ="Blue" EnableTheming ="true" BorderStyle ="Solid"/>
<asp:Label ID="Label6" runat="server"
Text="Please Click to Perform the Operation" CssClass="captionlbl"
Style="color: #0000cc" />
</td>
</tr>
<tr>
<td align="left" colspan="2">
<asp:Button ID="btnEmpKraCancel" runat="server" BackColor="AliceBlue" BorderWidth="1px" CausesValidation="False" CommandName="Cancel"
Text="Cancel" Width="70px" Font-Bold ="true" ForeColor ="Blue" EnableTheming ="true" BorderStyle ="Solid" />
<asp:Label ID="Label7" runat="server" Text="Please Click Cancel to Perform" CssClass="captionlbl" Style="color: #0000cc"></asp:Label>
</td>
</tr>
<tr>
<td colspan="2" style="height: 15px; text-align: left;">
</td>
</tr>
</table>
</div>
</formtemplate>
</editformsettings>
</mastertableview><clientsettings>
<clientevents onrowdblclick="RowDblClick" />
</clientsettings>
</Telerik:RadGrid>
<
Telerik:RadGrid ID="dgvDevelopmentActivity" runat="server"
AllowMultiRowEdit="true" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" GridLines="None"
OnItemCommand="dgvDevelopmentActivity_ItemCommand"
OnItemCreated="dgvDevelopmentActivity_ItemCreated"
OnItemDataBound="dgvDevelopmentActivity_ItemDataBound"
OnNeedDataSource="dgvDevelopmentActivity_NeedDataSource" PageSize="7"
ShowStatusBar="true" Skin="Outlook" Width="750px">
<headercontextmenu enableautoscroll="True">
</headercontextmenu>
<mastertableview commanditemdisplay="Top" datakeynames="ID" dir="LTR"
editmode="EditForms">
<commanditemsettings addnewrecordtext="Development Activity" ShowRefreshButton ="false" />
<Columns>
<Telerik:GridEditCommandColumn ButtonType="ImageButton" HeaderText="Edit">
<ItemStyle Width="20px" />
</Telerik:GridEditCommandColumn>
<Telerik:GridBoundColumn AutoPostBackOnFilter="true" ColumnEditorID="txtVanish"
DataField="ID" HeaderText="Vanish" UniqueName="Vanish" Visible="false">
</Telerik:GridBoundColumn>
<Telerik:GridBoundColumn AutoPostBackOnFilter="true" ColumnEditorID="What"
DataField="What" HeaderText="What" UniqueName="What">
</Telerik:GridBoundColumn>
<Telerik:GridBoundColumn AutoPostBackOnFilter="true" ColumnEditorID="How"
DataField="How" HeaderText="How" SortExpression="How" UniqueName="How">
</Telerik:GridBoundColumn>
<Telerik:GridBoundColumn AutoPostBackOnFilter="true" ColumnEditorID="Whenn"
DataField="Whenn" HeaderText="When" SortExpression="Whenn" UniqueName="Whenn">
</Telerik:GridBoundColumn>
<Telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete"
HeaderText="Delete" ItemStyle-Width="20px" Text="Delete"
UniqueName="DeleteColumn">
<ItemStyle Width="20px" />
</Telerik:GridButtonColumn>
</Columns>
<editformsettings editformtype="Template"
formstyle-backcolor="Transparent">
<editcolumn uniquename="EditCommandColumn1">
</editcolumn>
<formstyle backcolor="Transparent" />
<formtemplate>
<div style="width: 100%; height: 100%">
<table border="0" cellspacing="2" style="width: 100%; border-color: #99ccff">
<tr>
<td style="width: 10%; text-align: left; vertical-align: top;" visible="false">
<asp:Label ID="lblVanish" runat="server" CssClass="captionlbl" Visible="false"
Width="100px"><b>Vanish</b></asp:Label>
</td>
<td style="width: 60%; text-align: left;" visible="false">
<Telerik:RadTextBox ID="txtVanish" runat="Server" AutoPostBack="True"
Skin="Web20" Text='<%# Eval("ID") %>' Visible="false" Width="500px">
</Telerik:RadTextBox>
</td>
</tr>
<tr>
<td style="width: 10%; text-align: left; vertical-align: top;">
<asp:Label ID="What" runat="server" CssClass="captionlbl" Width="100px"><b>What</b></asp:Label>
</td>
<td style="width: 60%; text-align: left;">
<Telerik:RadTextBox ID="txtWhat" runat="Server" AutoPostBack="True"
Skin="Web20" TabIndex="1" Text='<%# Eval("What")%>' Width="500px">
</Telerik:RadTextBox>
</td>
</tr>
<tr>
<td style="vertical-align: top; width: 10%; text-align: left;">
<asp:Label ID="How" runat="server" CssClass="captionlbl" Height="15px"><b>How</b></asp:Label>
</td>
<td style="width: 60%; text-align: left;">
<Telerik:RadTextBox ID="txtHow" runat="Server" AutoPostBack="True" Skin="Web20"
TabIndex="2" Text='<%# Eval("How")%>' Width="500px">
</Telerik:RadTextBox>
</td>
</tr>
<tr>
<td style="width: 10%; text-align: left; height: 15px;">
<asp:Label ID="lblWhen" runat="server" CssClass="captionlbl"><b>When</b></asp:Label>
</td>
<td style="width: 60%; text-align: left;">
<Telerik:RadDateTimePicker ID="dtpwhen" runat="Server" AutoPostBack="True"
Skin="Outlook" TabIndex="3" Width="200px">
<%
-- <calendar skin="Outlook" usecolumnheadersasselectors="False"
userowheadersasselectors="False" viewselectortext="x">
</calendar>
<timeview cellspacing="-1">
</timeview>
<timepopupbutton hoverimageurl="" imageurl="" />
<datepopupbutton hoverimageurl="" imageurl="" tabindex="3" />
<dateinput autopostback="True" dateformat="dd MMM yyyy"
displaydateformat="dd MMM yyyy" tabindex="3">
</dateinput>--
%>
</Telerik:RadDateTimePicker>
</td>
</tr>
<tr style="width: 100%">
<td colspan="2" style="height: 15px; text-align: left;">
</td>
</tr>
<tr>
<td align="left" colspan="2">
<asp:Button ID="btnEmpKrainsert" runat="server" CommandName='<%# (Container is Telerik.Web.UI.GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'
Text='<%# (Container is Telerik.Web.UI.GridEditFormInsertItem) ? "Insert" : "Update" %>'
Width="70px" Font-Bold ="true" ForeColor ="Blue" EnableTheming ="true" BorderStyle ="Solid"/>
<asp:Label ID="Label6" runat="server"
Text="Please Click to Perform the Operation" CssClass="captionlbl"
Style="color: #0000cc" />
</td>
</tr>
<tr>
<td align="left" colspan="2">
<asp:Button ID="btnEmpKraCancel" runat="server" BackColor="AliceBlue" BorderWidth="1px" CausesValidation="False" CommandName="Cancel"
Text="Cancel" Width="70px" Font-Bold ="true" ForeColor ="Blue" EnableTheming ="true" BorderStyle ="Solid" />
<asp:Label ID="Label7" runat="server" Text="Please Click Cancel to Perform" CssClass="captionlbl" Style="color: #0000cc"></asp:Label>
</td>
</tr>
<tr>
<td colspan="2" style="height: 15px; text-align: left;">
</td>
</tr>
</table>
</div>
</formtemplate>
</editformsettings>
</mastertableview>
<clientsettings>
<clientevents onrowdblclick="RowDblClick" />
</clientsettings>
</Telerik:RadGrid>
<telerik:RadGrid ID="gridEntitiesAndCCs" runat="server" AllowSorting="True" AllowMultiRowSelection="true" AutoGenerateColumns="False" GridLines="None" Height="150" Width="100%" EnableViewState="false"> <MasterTableView DataKeyNames="FacilityID,CostCtr" AllowMultiColumnSorting="true"> <Columns> <telerik:GridClientSelectColumn UniqueName="ClientSelectColumn" > <HeaderStyle Width="25" /> <ItemStyle Width="25" /> </telerik:GridClientSelectColumn> <telerik:GridBoundColumn DataField="FacilityName" HeaderText="Facility" SortExpression="FacilityName" UniqueName="FacilityName"> <HeaderStyle Width="150" /> <ItemStyle Width="150" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CostCtr" HeaderText="Cost Center" SortExpression="CostCtr" UniqueName="CostCtr"> <HeaderStyle Width="100" /> <ItemStyle Width="100" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DeptName" HeaderText="Dept Name" SortExpression="DeptName" UniqueName="DeptName"> </telerik:GridBoundColumn> </Columns> </MasterTableView> <ClientSettings EnablePostBackOnRowClick="false"> <Scrolling AllowScroll="true" UseStaticHeaders="true" /> <Selecting AllowRowSelect="true" UseClientSelectColumnOnly="true" /> </ClientSettings> </telerik:RadGrid><telerik:RadGrid ID="RadGrid1" AllowPaging="True" PageSize="5" runat="server" GridLines="None" Width="100%" OnItemCreated="RadGrid1_ItemCreated" OnItemCommand="RadGrid1_ItemCommand" Skin="Black"> <PagerStyle Mode="NextPrevAndNumeric" AlwaysVisible="true" /> <ItemStyle HorizontalAlign="Center" /> <MasterTableView> <CommandItemSettings ExportToPdfText="Export to Pdf" /> <RowIndicatorColumn> <HeaderStyle Width="20px" /> </RowIndicatorColumn> <ExpandCollapseColumn> <HeaderStyle Width="20px" /> </ExpandCollapseColumn> <PagerStyle AlwaysVisible="True" /> </MasterTableView> <HeaderStyle HorizontalAlign="Center" /> <AlternatingItemStyle HorizontalAlign="Center" /> </telerik:RadGrid>//Paging private DataSet CreateDataSetFilterPaging(String Filter) { //Subject Filter string SubjectstrExpr = "SUBSTRING(DESCR,1,1) ='" + Filter + "'"; //Staff Filter string StaffsstrExpr = "SUBSTRING(DESCR,1,1) ='" + Filter + "'"; //Venue Filter string VenuestrExpr = "SUBSTRING(DESCR,1,1) ='" + Filter + "'"; //Timetable Filter string TimetablestrExpr = "SUBSTRING(Code,1,1) ='" + Filter + "'"; DataColumn[] keys = new DataColumn[1]; DataSet dsFinalTimeTable = new DataSet(); DataTable tbldt; tbldt = new DataTable("Subjects"); //Add Staff Table XmlDataDocument xmlDatadocStaff = new XmlDataDocument(); xmlDatadocStaff.DataSet.ReadXml(@"C:\Pilot Project\App_Data\Subjects.xml"); tbldt = xmlDatadocStaff.DataSet.Tables["Subjects"]; keys = new DataColumn[1]; keys[0] = tbldt.Columns["ID"]; tbldt.PrimaryKey = keys; DataView dvSubjects = tbldt.DefaultView; dvSubjects.RowFilter = StaffsstrExpr; DataTable tbldtFinal = dvSubjects.Table; dsFinalTimeTable.Tables.Add(tbldtFinal.Copy()); //Add Venue Table tbldt = new DataTable("Venues"); XmlDataDocument xmlDatadocVenue = new XmlDataDocument(); xmlDatadocVenue.DataSet.ReadXml(@"C:\Pilot Project\App_Data\XML_Venue.xml"); tbldt = xmlDatadocVenue.DataSet.Tables["VENUES"]; keys = new DataColumn[1]; keys[0] = tbldt.Columns["ID"]; tbldt.PrimaryKey = keys; //DataView dvVenues = tbldt.DefaultView; //dvVenues.RowFilter = VenuestrExpr; //tbldt.Clear(); //tbldt = dvVenues.Table; dsFinalTimeTable.Tables.Add(tbldt.Copy()); //TimeTable tbldt = new DataTable("TimeTable"); XmlDataDocument xmlDatadocTimeTable = new XmlDataDocument(); xmlDatadocTimeTable.DataSet.ReadXml(@"C:\Pilot Project\App_Data\TimeTableFull.xml"); tbldt = xmlDatadocTimeTable.DataSet.Tables[0]; keys = new DataColumn[1]; keys[0] = tbldt.Columns["ID"]; tbldt.PrimaryKey = keys; DataView dvTimeTable = tbldt.DefaultView; dvTimeTable.RowFilter = TimetablestrExpr; DataTable tbldtfinaltime = dvTimeTable.Table; dsFinalTimeTable.Tables.Add(tbldtfinaltime.Copy()); //Setup RelationsTimeTable// DataRelation VenuesRelations = new DataRelation("VenuesRel", dsFinalTimeTable.Tables["Appointment"].Columns["ID"], dsFinalTimeTable.Tables["Venues"].Columns["ID"]); DataRelation ModuleRelations = new DataRelation("SubjectRel", dsFinalTimeTable.Tables["Subjects"].Columns["ID"], dsFinalTimeTable.Tables["Appointment"].Columns["subjectid"]); dsFinalTimeTable.Relations.Add(VenuesRelations); dsFinalTimeTable.Relations.Add(ModuleRelations); return dsFinalTimeTable; }protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e) { if (e.Item is GridPagerItem) { GridPagerItem pagerItem = (e.Item as GridPagerItem); pagerItem.PagerContentCell.Controls.Clear(); for (int i = 65; i <= 65 + 25; i++) { LinkButton linkButton1 = new LinkButton(); LiteralControl lc = new LiteralControl(" "); linkButton1.Text = "" + (char)i; linkButton1.CommandName = "alpha"; linkButton1.CommandArgument = "" + (char)i; pagerItem.PagerContentCell.Controls.Add(linkButton1); pagerItem.PagerContentCell.Controls.Add(lc); } LiteralControl lcLast = new LiteralControl(" "); pagerItem.PagerContentCell.Controls.Add(lcLast); LinkButton linkButtonAll = new LinkButton(); linkButtonAll.Text = "All"; linkButtonAll.CommandName = "NoFilter"; pagerItem.PagerContentCell.Controls.Add(linkButtonAll); } }protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e) { String value = null; switch (e.CommandName) { case ("alpha"): { value = string.Format("{0}", e.CommandArgument); break; } case ("NoFilter"): { value = "%"; break; } } RadGrid1.DataSource = CreateDataSetFilterPaging(value); RadGrid1.Rebind(); }