or
<telerik:RadWindowManager ID="RadWindowManager1" runat="server" EnableShadow="true"></telerik:RadWindowManager><telerik:RadAjaxPanel runat="server" ID="RadAjaxPanel1"> <telerik:RadGrid ID="RadGrid1" DataSourceID="ds_ActivityCodes" AutoGenerateColumns="False" AllowSorting="True" AllowAutomaticDeletes="False" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowPaging="True" GridLines="None" PageSize="10" Width="750px" runat="server"> <MasterTableView CommandItemDisplay="TopAndBottom" DataKeyNames="activity_id" DataSourceID="ds_ActivityCodes" HorizontalAlign="NotSet" EditMode="Batch" AutoGenerateColumns="False"> <CommandItemSettings ShowSaveChangesButton="false" /> <BatchEditingSettings EditType="Cell" OpenEditingEvent="None" /> <SortExpressions> <telerik:GridSortExpression FieldName="ActivityCode" SortOrder="Ascending" /> </SortExpressions> <Columns> <telerik:GridBoundColumn DataField="ActivityCode" HeaderStyle-Width="60px" HeaderText="Activity Code" SortExpression="ActivityCode" UniqueName="ActivityCode"> <ColumnValidationSettings EnableRequiredFieldValidation="true"> <RequiredFieldValidator ForeColor="Red" Text="*This field is required"> </RequiredFieldValidator> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ActivityDescription" HeaderStyle-Width="210px" HeaderText="Description" SortExpression="ActivityDescription" UniqueName="ActivityDescription"> <ColumnValidationSettings EnableRequiredFieldValidation="true"> <RequiredFieldValidator ForeColor="Red" Text="*This field is required"> </RequiredFieldValidator> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridCheckBoxColumn DataField="display" HeaderStyle-Width="60px" HeaderText="Display" SortExpression="display" UniqueName="display" > </telerik:GridCheckBoxColumn> </Columns> </MasterTableView> </telerik:RadGrid> <telerik:GridTextBoxColumnEditor runat="server" ID="TextEditor"> <TextBoxStyle Width="200px" /> </telerik:GridTextBoxColumnEditor> <telerik:GridCheckBoxColumnEditor runat="server" ID="CheckBoxEditor"> <CheckBoxStyle Width="20px" /> </telerik:GridCheckBoxColumnEditor></telerik:RadAjaxPanel>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="projects.aspx.cs" Inherits="projects" %><%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %><!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>Projects</title></head><body> <table width="100%"> <tr> <td><img src="images/logo.PNG" /></td> </tr> </table> <form id="form1" runat="server"> <div> </div> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> </telerik:RadScriptManager> <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server"> <script type="text/javascript"> // <![CDATA[ //On insert and update buttons click temporarily disables ajax to perform upload actions function conditionalPostback(sender, eventArgs) { var theRegexp = new RegExp("\.UpdateButton$|\.PerformInsertButton$", "ig"); if (eventArgs.get_eventTarget().match(theRegexp)) { var upload = $find(window['UploadId']); //alert(upload); if (upload == null) { eventArgs.set_enableAjax(false); return; } //AJAX is disabled only if file is selected for upload if (upload.getFileInputs()[0].value != "") { eventArgs.set_enableAjax(false); } } } function validateRadUpload(source, e) { e.IsValid = false; var upload = $find(source.parentNode.getElementsByTagName('div')[0].id); if (upload == null) { return; } var inputs = upload.getFileInputs(); for (var i = 0; i < inputs.length; i++) { //check for empty string or invalid extension if (inputs[i].value != "" && upload.isExtensionValid(inputs[i].value)) { e.IsValid = true; break; } } } // ]]> </script> </telerik:RadCodeBlock> <table width="100%"> <tr> <td> <telerik:RadMenu ID="RadMenu1" runat="server" Skin="Default" Width="100%" Font-Size="Large"> <Items> <telerik:RadMenuItem Text="Login" runat="server"></telerik:RadMenuItem> <telerik:RadMenuItem Text="Home" runat="server" NavigateUrl="home.aspx" ></telerik:RadMenuItem> <telerik:RadMenuItem Text="Data Administration" runat="server" NavigateUrl="~/dataAdmin.aspx"> <Items> <telerik:RadMenuItem runat="server" NavigateUrl="customers.aspx" Text="Customers"> </telerik:RadMenuItem> <telerik:RadMenuItem runat="server" NavigateUrl="manufacturers.aspx" Text="Manufactures"> </telerik:RadMenuItem> <telerik:RadMenuItem runat="server" NavigateUrl="product.aspx" Text="Products"> </telerik:RadMenuItem> <telerik:RadMenuItem runat="server" NavigateUrl="events.aspx" Text="Events"> </telerik:RadMenuItem> <telerik:RadMenuItem runat="server" Selected="True" Text="Projects"> </telerik:RadMenuItem> </Items> </telerik:RadMenuItem> <telerik:RadMenuItem Text="Search" runat="server" NavigateUrl="search.aspx"></telerik:RadMenuItem> <telerik:RadMenuItem Text="Indust. Reports" runat="server" NavigateUrl="industry_report.aspx"></telerik:RadMenuItem> <telerik:RadMenuItem runat="server" NavigateUrl="~/reports_Start_page.aspx" Text="Reports Section"> </telerik:RadMenuItem> <telerik:RadMenuItem Text="Administration" runat="server" NavigateUrl="users.aspx"></telerik:RadMenuItem> <telerik:RadMenuItem Text="Help" runat="server" NavigateUrl="help.aspx" ></telerik:RadMenuItem> <telerik:RadMenuItem Text="Log Out" runat="server" NavigateUrl="logout.aspx"></telerik:RadMenuItem> </Items> </telerik:RadMenu> </td> </tr> </table> <table> <tr> <td><asp:Button ID="Button2" runat="server" Text="Export XL" OnClick="Button2_Click" /></td> </tr> </table> <table width="100%"> <tr> <td> <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" clientevents-onrequeststart="conditionalPostback" RestoreOriginalRenderDelegate="false" LoadingPanelID="RadAjaxLoadingPanel1"> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" > <AjaxSettings> <telerik:AjaxSetting AjaxControlID="RadGrid1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadGrid1" ></telerik:AjaxUpdatedControl> <telerik:AjaxUpdatedControl ControlID="RequiredFieldValidator1"></telerik:AjaxUpdatedControl> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Telerik"> </telerik:RadAjaxLoadingPanel> <telerik:RadGrid runat="server" ID="RadGrid1" AllowPaging="True" AllowFilteringByColumn="True" AllowSorting="True" AllowMultiRowSelection="true" AutoGenerateColumns="False" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowAutomaticDeletes="True" ShowStatusBar="True" OnDetailTableDataBind="RadGrid1_DetailTableDataBind" GridLines="None" DataSourceID="SqlDataSource1" PageSize="10" CellSpacing="0" OnDeleteCommand="RadGrid1_DeleteCommand" OnItemCreated="RadGrid1_ItemCreated" OnItemCommand="RadGrid1_ItemCommand" OnItemInserted="RadGrid1_ItemInserted" OnItemUpdated="RadGrid1_ItemUpdated" OnItemDataBound="RadGrid1_ItemDataBound" OnUpdateCommand="RadGrid1_UpdateCommand" oninsertcommand="RadGrid1_InsertCommand" > <PagerStyle Mode="NextPrevAndNumeric" AlwaysVisible="true"></PagerStyle> <MasterTableView Width="100%" CommandItemDisplay="Top" DataKeyNames="proj_id" Name="Master" > <Columns> <telerik:GridClientSelectColumn UniqueName="ChkSel" > </telerik:GridClientSelectColumn> <telerik:GridEditCommandColumn ButtonType="ImageButton"> <HeaderStyle Width="36px"></HeaderStyle> </telerik:GridEditCommandColumn> <telerik:GridTemplateColumn HeaderText="ProjectID" UniqueName="proj_id" DataField="proj_id" > <ItemTemplate> <asp:Label ID="lblid" runat="server" Text='<%# Bind("proj_id") %>'></asp:Label> </ItemTemplate> <EditItemTemplate > <asp:TextBox ID="txtid" Width="300px" runat="server" Text='<%# Bind("proj_id") %>' ReadOnly="true"> </asp:TextBox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Project Name" UniqueName="proj_name" DataField="proj_name" SortExpression="proj_name"> <ItemTemplate> <asp:Label ID="lblpn" runat="server" Text='<%# Bind("proj_name") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="txtpn" Width="300px" runat="server" Text='<%# Bind("proj_name") %>' > </asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" ControlToValidate="txtpn" ErrorMessage="This field is required" runat="server" Display="Dynamic"> </asp:RequiredFieldValidator> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridDropDownColumn DataSourceID="SqlDataSource2" ListTextField="custname" ListValueField="custid" UniqueName="ddl" SortExpression="proj_cust_id" EmptyListItemText="Select Customer" EnableEmptyListItem="true" HeaderText="Customer" DropDownControlType="RadComboBox" DataField="proj_cust_id"> </telerik:GridDropDownColumn> <telerik:GridDropDownColumn DataSourceID="SqlDataSource3" ListTextField="manname" ListValueField="manid" UniqueName="ddl2" SortExpression="proj_man_id" EmptyListItemText="Select Manufacturer" EnableEmptyListItem="true" HeaderText="Manufacturer" DropDownControlType="RadComboBox" DataField="proj_man_id"> </telerik:GridDropDownColumn> <telerik:GridDropDownColumn DataSourceID="SqlDataSource4" ListTextField="prodname" ListValueField="prodid" UniqueName="ddl3" SortExpression="proj_prod_id" EmptyListItemText="Select Product" EnableEmptyListItem="true" HeaderText="Product" DropDownControlType="RadComboBox" DataField="proj_prod_id"> </telerik:GridDropDownColumn> <telerik:GridDateTimeColumn UniqueName="proj_date" PickerType="DatePicker" HeaderText="Proj Date" DataField="proj_date" DataFormatString="{0:MM/dd/yyyy}"> <ItemStyle Width="120px"></ItemStyle> </telerik:GridDateTimeColumn> <telerik:GridTemplateColumn HeaderText="Num Of Vehicle" UniqueName="proj_num_of_vehicles" DataField="proj_num_of_vehicles" display="false"> <ItemTemplate> <asp:Label ID="lblnov" runat="server" Text='<%# Eval("proj_num_of_vehicles") %>' width="50px"></asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadNumericTextBox ID="txtnov" Width="50px" runat="server" Text='<%# Bind("proj_num_of_vehicles") %>' > <NumberFormat DecimalDigits="0" /> </telerik:RadNumericTextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator2" ControlToValidate="txtnov" ErrorMessage="This field is required" runat="server" Display="Dynamic"> </asp:RequiredFieldValidator> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Coach per Vehicle" UniqueName="proj_coach_vehicle" DataField="proj_coach_vehicle" display="false"> <ItemTemplate> <asp:Label ID="lblcv" runat="server" Text='<%# Eval("proj_coach_vehicle") %>' width="50px"></asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadNumericTextBox ID="txtcv" Width="50px" runat="server" Text='<%# Bind("proj_coach_vehicle") %>' > <NumberFormat DecimalDigits="0" /> </telerik:RadNumericTextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator3" ControlToValidate="txtcv" ErrorMessage="This field is required" runat="server" Display="Dynamic"> </asp:RequiredFieldValidator> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Contract Value(€)" UniqueName="proj_contract_value" DataField="proj_contract_value" display="false" > <ItemTemplate> <asp:Label ID="lblcval" runat="server" Text='<%# Eval("proj_contract_value") %>' width="150px"></asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadNumericTextBox ID="txtcval" Width="150px" runat="server" Text='<%# Bind("proj_contract_value") %>' > <NumberFormat DecimalDigits="0" /> </telerik:RadNumericTextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator4" ControlToValidate="txtcval" ErrorMessage="This field is required" runat="server" Display="Dynamic"> </asp:RequiredFieldValidator> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Avg Price per Coach(€)" UniqueName="proj_avg_price_per_coach" DataField="proj_avg_price_per_coach" display="false"> <ItemTemplate></ItemTemplate> <EditItemTemplate> <telerik:RadNumericTextBox ID="txtppc" Width="150px" runat="server" ReadOnly="true" > <NumberFormat DecimalDigits="0" /> </telerik:RadNumericTextBox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Length(m)" UniqueName="proj_length" DataField="proj_length" display="false"> <ItemTemplate> <asp:Label ID="lblpl" runat="server" Text='<%# Eval("proj_length") %>' width="50px"></asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadNumericTextBox ID="txtpl" Width="50px" runat="server" Text='<%# Bind("proj_length") %>' > <NumberFormat DecimalDigits="0" /> </telerik:RadNumericTextBox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Width(mm)" UniqueName="proj_width" DataField="proj_width" display="false"> <ItemTemplate> <asp:Label ID="lblpw" runat="server" Text='<%# Eval("proj_width") %>' width="50px"></asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadNumericTextBox ID="txtpw" Width="50px" runat="server" Text='<%# Bind("proj_width") %>' > <NumberFormat DecimalDigits="0" /> </telerik:RadNumericTextBox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Height(mm)" UniqueName="proj_height" DataField="proj_height" display="false"> <ItemTemplate> <asp:Label ID="lblph" runat="server" Text='<%# Eval("proj_height") %>' width="50px"></asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadNumericTextBox ID="txtph" Width="50px" runat="server" Text='<%# Bind("proj_height") %>' > <NumberFormat DecimalDigits="0" /> </telerik:RadNumericTextBox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Passenger Seats" UniqueName="proj_passenger_seats" DataField="proj_passenger_seats" display="false"> <ItemTemplate> <asp:Label ID="lblps" runat="server" Text='<%# Eval("proj_passenger_seats") %>' width="50px"></asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadNumericTextBox ID="txtps" Width="50px" runat="server" Text='<%# Bind("proj_passenger_seats") %>' > <NumberFormat DecimalDigits="0" /> </telerik:RadNumericTextBox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Passengers Total" UniqueName="proj_passenger_total" DataField="proj_passenger_seats" display="false"> <ItemTemplate> <asp:Label ID="lblpat" runat="server" Text='<%# Eval("proj_passenger_total") %>' width="50px"></asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadNumericTextBox ID="txtpat" Width="50px" runat="server" Text='<%# Bind("proj_passenger_total") %>' > <NumberFormat DecimalDigits="0" /> </telerik:RadNumericTextBox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Brand" UniqueName="proj_brand" DataField="proj_brand" display="false"> <ItemTemplate> <asp:Label ID="lblbr" runat="server" Text='<%# Eval("proj_brand") %>' width="100px"></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:textbox ID="txtbr" Width="100px" runat="server" Text='<%# Bind("proj_brand") %>' > </asp:textbox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="System Voltage" UniqueName="proj_systemvoltage" DataField="proj_systemvoltage" display="false"> <ItemTemplate> <asp:Label ID="lblsv" runat="server" Text='<%# Eval("proj_systemvoltage") %>' width="100px"></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:textbox ID="txtsv" Width="100px" runat="server" Text='<%# Bind("proj_systemvoltage") %>' > </asp:textbox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Gauge" UniqueName="proj_gauge" DataField="proj_gauge" display="false"> <ItemTemplate> <asp:Label ID="lblga" runat="server" Text='<%# Eval("proj_gauge") %>' width="100px"></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:textbox ID="txtga" Width="100px" runat="server" Text='<%# Bind("proj_gauge") %>' > </asp:textbox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Service Speed" UniqueName="proj_service_speed" DataField="proj_service_speed" display="false"> <ItemTemplate> <asp:Label ID="lblss" runat="server" Text="Service Speed (Km/h)" width="100px"></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:textbox ID="txtss" Width="100px" runat="server" Text='<%# Bind("proj_service_speed") %>' > </asp:textbox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Available Attachments" UniqueName="proj_attach" DataField="proj_attach" display="false"> <ItemTemplate></ItemTemplate> <EditItemTemplate> <asp:TextBox ID="txtprojattach" Width="300px" runat="server" Text='<%# Bind("proj_attach") %>' ReadOnly="true"> </asp:TextBox> <asp:Button id="btn" OnClick="btn_Click" runat="server" Text="View Attachments"/> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:gridtemplatecolumn uniquename="Upload" HeaderText="Select attachments (jpg, jpeg, pdf, txt)" Display="false"> <ItemTemplate></ItemTemplate> <edititemtemplate> <telerik:radupload id="RadUpload1" runat="server" MaxFileInputsCount="1" AllowedFileExtensions=".jpg,.jpeg,.pdf,.txt" TargetFolder="~/Proj_AttachFiles" ControlObjectsVisibility="None" /> </edititemtemplate> </telerik:gridtemplatecolumn> <telerik:GridTemplateColumn HeaderText="Notes" UniqueName="proj_notes" DataField="proj_notes" display="false"> <ItemTemplate> <asp:Label ID="lblnotes" runat="server" Text='<%# Eval("proj_notes") %>' width="300px"></asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadTextBox ID="txtnotes" Width="500px" runat="server" Text='<%# Bind("proj_notes") %>' Height="100px" TextMode="MultiLine" > </telerik:RadTextBox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="uname" DataField="uname" HeaderText="Modified By"> <ItemTemplate> <asp:Label ID="lbluname" runat="server" Text='<%# Bind("uname") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="uname" runat="server" Text='<%# Bind("uname") %>' ReadOnly="true"> </asp:TextBox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridButtonColumn UniqueName="Delete_col" Text="Delete" CommandName="Delete" ConfirmText="Delete this record ?" ConfirmDialogType="RadWindow" ButtonType="ImageButton"> <HeaderStyle Width="36px"></HeaderStyle> </telerik:GridButtonColumn> </Columns> <DetailTables > <telerik:GridTableView DataKeyNames="proj_id" ClientDataKeyNames="proj_id" HierarchyLoadMode="ServerBind" Width="100%" runat="server" CommandItemDisplay="Top" Name="Details" > <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="proj_id" MasterKeyField="proj_id"></telerik:GridRelationFields> </ParentTableRelation> <Columns> <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn1"> <HeaderStyle Width="36px"></HeaderStyle> </telerik:GridEditCommandColumn> <telerik:GridTemplateColumn HeaderText="ID" UniqueName="id" DataField="id" display="false"> <ItemTemplate> <asp:Label ID="lblid" runat="server" Text='<%# Bind("id") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="txtid" Width="70px" runat="server" Text='<%# Bind("id") %>' ReadOnly="true"> </asp:TextBox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridDropDownColumn DataSourceID="SqlDataSource3" ListTextField="manname" ListValueField="manname" UniqueName="ddl7" SortExpression="b_man_id" EmptyListItemText="Select Manufacturer" EnableEmptyListItem="true" HeaderText="Manufacturer" DropDownControlType="RadComboBox" DataField="b_man_id" > </telerik:GridDropDownColumn> <telerik:GridNumericColumn DataField="b_contract_price" HeaderText="Contract Value(€)" UniqueName="b_contract_price" > </telerik:GridNumericColumn > <telerik:GridTemplateColumn UniqueName="b_avg_price" DataField="b_avg_price" HeaderText="Avg Price per Coach(€)"> <ItemTemplate> <asp:Label ID="lblavgp" runat="server" Text='<%# Bind("b_avg_price") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadNumericTextBox ID="txtavgp" runat="server" Text='<%# Bind("b_avg_price") %>' ReadOnly="true" Width="100px" > <NumberFormat DecimalDigits="0" /> </telerik:RadNumericTextBox> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridButtonColumn UniqueName="Delete_col2" Text="Delete" CommandName="Delete" ConfirmText="Delete this record ?" ConfirmDialogType="RadWindow" ButtonType="ImageButton"> <HeaderStyle Width="36px"></HeaderStyle> </telerik:GridButtonColumn> </Columns> </telerik:GridTableView> </DetailTables> <EditFormSettings> <EditColumn ButtonType="ImageButton"> </EditColumn> </EditFormSettings> </MasterTableView> <ClientSettings> <Selecting AllowRowSelect="true"/> </ClientSettings> </telerik:RadGrid> </telerik:RadAjaxPanel></td></tr></table> <asp:SqlDataSource runat="server" ID="SqlDataSource2" ConnectionString="<%$ ConnectionStrings:stad_conn %>" SelectCommand="SELECT cust_id as custid,cust_name as custname FROM customers order by cust_name"> </asp:SqlDataSource> <asp:SqlDataSource runat="server" ID="SqlDataSource22" ConnectionString="<%$ ConnectionStrings:stad_conn %>" SelectCommand="SELECT cust_name,cust_id FROM customers order by cust_name"> </asp:SqlDataSource> <asp:SqlDataSource runat="server" ID="SqlDataSource3" ConnectionString="<%$ ConnectionStrings:stad_conn %>" SelectCommand="SELECT man_id as manid,man_name as manname FROM manufacturers order by man_name"> </asp:SqlDataSource> <asp:SqlDataSource runat="server" ID="SqlDataSource4" ConnectionString="<%$ ConnectionStrings:stad_conn %>" SelectCommand="SELECT prod_id as prodid,prod_type as prodname FROM products order by prod_type"> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:stad_conn %>" DeleteCommand="DELETE FROM [projects] WHERE [ID] = @ID" InsertCommand="INSERT INTO [projects] ([proj_id],[proj_cust_id], [proj_man_id], [proj_date],[proj_num_of_vehicles], [proj_coach_vehicle],[proj_contract_value],[proj_length],[proj_width], [proj_height],[proj_passenger_seats],[proj_passenger_total],[proj_notes], [uname],[proj_name],[proj_prod_id],[proj_brand],[proj_systemvoltage],[proj_gauge],[proj_service_speed]) VALUES (@proj_id,@proj_cust_id,@proj_man_id, @proj_date,@proj_num_of_vehicles,@proj_coach_vehicle, @proj_contract_value,@proj_length, @proj_width,@proj_height,@proj_passenger_seats, @proj_passenger_total,@proj_notes,@uname,@proj_name,@proj_prod_id,@proj_brand,@proj_systemvoltage,@proj_gauge,@proj_service_speed)" SelectCommand="SELECT [id],[proj_id],[proj_cust_id], [proj_man_id], [proj_date],[proj_num_of_vehicles],[proj_coach_vehicle], [proj_contract_value],[proj_length],[proj_width],[proj_height] ,[proj_attach],[proj_prod_id],[proj_service_speed], [proj_passenger_seats],[proj_passenger_total],[proj_notes],[uname],[proj_name],[proj_brand],[proj_systemvoltage],[proj_gauge] from projects" UpdateCommand="UPDATE [projects] SET [proj_id] = @proj_id,[proj_cust_id] = @proj_cust_id, [proj_man_id] = @proj_man_id, [proj_date] = @proj_date,[proj_prod_id] = @proj_prod_id, [proj_num_of_vehicles] = @proj_num_of_vehicles, [proj_coach_vehicle] = @proj_coach_vehicle, [proj_contract_value] = @proj_contract_value, [proj_service_speed] = @proj_service_speed, [proj_length] = @proj_length, [proj_width] = @proj_width, [proj_height] = @proj_height, [proj_passenger_seats] = @proj_passenger_seats, [proj_passenger_total] = @proj_passenger_total, [proj_notes] = @proj_notes,[proj_name]=@proj_name, [proj_brand]=@proj_brand,[proj_systemvoltage]=@proj_systemvoltage,[proj_gauge]=@proj_gauge WHERE [ID] = @ID"> <DeleteParameters> <asp:Parameter Name="ID" Type="Int32"></asp:Parameter> </DeleteParameters> <InsertParameters> <asp:Parameter Name="proj_cust_id" Type="String"></asp:Parameter> <asp:Parameter Name="proj_prod_id" Type="String"></asp:Parameter> <asp:Parameter Name="proj_brand" Type="String"></asp:Parameter> <asp:Parameter Name="proj_systemvoltage" Type="String"></asp:Parameter> <asp:Parameter Name="proj_gauge" Type="String"></asp:Parameter> <asp:Parameter Name="proj_man_id" Type="String"></asp:Parameter> <asp:Parameter Name="proj_service_speed" Type="String"></asp:Parameter> <asp:Parameter Name="proj_date" Type="DateTime"></asp:Parameter> <asp:Parameter Name="proj_num_of_vehicles" Type="Int16"></asp:Parameter> <asp:Parameter Name="proj_coach_vehicle" Type="Int16"></asp:Parameter> <asp:Parameter Name="proj_contract_value" Type="Double"></asp:Parameter> <asp:Parameter Name="proj_length" Type="Double"></asp:Parameter> <asp:Parameter Name="proj_width" Type="Double"></asp:Parameter> <asp:Parameter Name="proj_system_voltage" Type="Double"></asp:Parameter> <asp:Parameter Name="proj_height" Type="Double"></asp:Parameter> <asp:Parameter Name="proj_passenger_seats" Type="Int16"></asp:Parameter> <asp:Parameter Name="proj_passenger_total" Type="Int16"></asp:Parameter> <asp:Parameter Name="proj_notes" Type="String"></asp:Parameter> <asp:Parameter Name="proj_name" Type="String"></asp:Parameter> <asp:Parameter Name="uname" Type="String"></asp:Parameter> <asp:Parameter Name="proj_id" Type="String"></asp:Parameter> </InsertParameters> <UpdateParameters> <asp:Parameter Name="proj_cust_id" Type="String"></asp:Parameter> <asp:Parameter Name="proj_prod_id" Type="String"></asp:Parameter> <asp:Parameter Name="proj_man_id" Type="String"></asp:Parameter> <asp:Parameter Name="proj_brand" Type="String"></asp:Parameter> <asp:Parameter Name="proj_service_speed" Type="String"></asp:Parameter> <asp:Parameter Name="proj_systemvoltage" Type="String"></asp:Parameter> <asp:Parameter Name="proj_gauge" Type="String"></asp:Parameter> <asp:Parameter Name="proj_date" Type="DateTime"></asp:Parameter> <asp:Parameter Name="proj_num_of_vehicles" Type="Int16"></asp:Parameter> <asp:Parameter Name="proj_coach_vehicle" Type="Int16"></asp:Parameter> <asp:Parameter Name="proj_contract_value" Type="Double"></asp:Parameter> <asp:Parameter Name="proj_length" Type="Double"></asp:Parameter> <asp:Parameter Name="proj_width" Type="Double"></asp:Parameter> <asp:Parameter Name="proj_system_voltage" Type="Double"></asp:Parameter> <asp:Parameter Name="proj_height" Type="Double"></asp:Parameter> <asp:Parameter Name="proj_passenger_seats" Type="Int16"></asp:Parameter> <asp:Parameter Name="proj_passenger_total" Type="Int16"></asp:Parameter> <asp:Parameter Name="proj_notes" Type="String"></asp:Parameter> <asp:Parameter Name="proj_name" Type="String"></asp:Parameter> <asp:Parameter Name="ID" Type="Int32"></asp:Parameter> </UpdateParameters> </asp:SqlDataSource> </form></body></html><%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Test.aspx.cs" Inherits="Test" %><%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %><asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server"> <style type="text/css"> .divRadios { margin-bottom: 15px; } .background { background: url("arrows.png") no-repeat scroll 0 0 transparent; padding: 115px 0 0 0px; margin-left: 45px; } #RadTreeView1 { margin-bottom: 15px; } .divTree { float: left; width: 315px; } .schedulerPositioning { width: 960px; float: left; display: block; } </style></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server"> <telerik:RadAjaxManager runat="server" ID="RadAjaxManager1" EnableAJAX="true"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="RadScheduler1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadScheduler1" LoadingPanelID="RadAjaxLoadingPanel1"> </telerik:AjaxUpdatedControl> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadAjaxLoadingPanel runat="server" ID="RadAjaxLoadingPanel1"> </telerik:RadAjaxLoadingPanel> <telerik:RadScriptBlock ID="RadScriptBlock1" runat="server"> <script type="text/javascript"> //<![CDATA[ //Shows whether an Appointment is inserted directly, or the //the Advanced Insert Form is opened when TreeView node is dropped on the Scheduler. var directlyInsertAppointment = true; function pageLoad() { $telerik.$('#<%=RadioButtonListChooseInsert.ClientID %>').click(radioButtonListChooseInsert_click); } function radioButtonListChooseInsert_click(radioButtonList) { //Gets the currently selected item of the RadioButtonList. var selectedItemValue = $telerik.$('#<%=RadioButtonListChooseInsert.ClientID %> input[type=radio]:checked').val(); if (selectedItemValue == "DirectInsert") { directlyInsertAppointment = true; } else { directlyInsertAppointment = false; } } function nodeDropping(sender, eventArgs) { var htmlElement = eventArgs.get_htmlElement(); var scheduler = $find('<%= RadScheduler1.ClientID %>'); if (isPartOfSchedulerAppointmentArea(htmlElement)) { //Gets the TimeSlot where an Appointment is dropped. var timeSlot = scheduler.get_activeModel().getTimeSlotFromDomElement(htmlElement); var startTime = timeSlot.get_startTime(); var endTime = new Date(startTime); //Gets all the data needed for the an Appointment, from the TreeView node. var node = eventArgs.get_sourceNode(); var text = node.get_text(); var attributes = node.get_attributes(); var duration = attributes.getAttribute("Duration"); endTime.setMinutes(endTime.getMinutes() + parseInt(duration)); var speaker = attributes.getAttribute("Speaker"); var parentValue = node.get_parent().get_value(); var category = scheduler.get_resources().getResourceByTypeAndKey("Category", parentValue); //New appointment is created. The start/end time, subject and category are set. var newAppointment = new Telerik.Web.UI.SchedulerAppointment(); newAppointment.set_start(startTime); newAppointment.set_end(endTime); newAppointment.set_subject(text + " (by " + speaker + ")"); if (category != null) { newAppointment.get_resources().add(category); } //Checks for the user's choice of the method for inserting Appointments. if (directlyInsertAppointment) { scheduler.insertAppointment(newAppointment); } else { //If Advanced Form is opened, the information from the TreeVew node is stored in a hidden input. var appointmentInfo = { subject: text, duration: duration, speaker: speaker, category: category }; var appointmentInfoSerialized = Sys.Serialization.JavaScriptSerializer.serialize(appointmentInfo); $get("<%=HiddenInputAppointmentInfo.ClientID%>").value = appointmentInfoSerialized; scheduler.showInsertFormAt(timeSlot); } } else { //The node was dropped elsewhere on the document. eventArgs.set_cancel(true); } } function isPartOfSchedulerAppointmentArea(htmlElement) { // Determines if an HTML element is part of the scheduler appointment area. // This can be either the rsContent or the rsAllDay div (in day and week view). return $telerik.$(htmlElement).parents().is("div.rsAllDay") || $telerik.$(htmlElement).parents().is("div.rsContent") } function formCreated(scheduler, args) { var mode = args.get_mode(); if (mode == Telerik.Web.UI.SchedulerFormMode.AdvancedInsert || mode == Telerik.Web.UI.SchedulerFormMode.AdvancedEdit) { //Gets the value from the hidden input, and populates the Appointment's data from it. if ($get("<%=HiddenInputAppointmentInfo.ClientID%>").value != "") { var hiddenInputValue = Sys.Serialization.JavaScriptSerializer.deserialize($get("<%=HiddenInputAppointmentInfo.ClientID%>").value); if (hiddenInputValue) { var subjectObject = $find('<%= RadScheduler1.ClientID %>' + "_Form_Subject"); subjectObject.set_value(hiddenInputValue.subject + " (by " + hiddenInputValue.speaker + ")"); var startTime = $find('<%= RadScheduler1.ClientID %>' + "_Form_StartTime").get_selectedDate(); var endTime = new Date(startTime.setMinutes(startTime.getMinutes() + parseInt(hiddenInputValue.duration))); $find('<%= RadScheduler1.ClientID %>' + "_Form_EndTime").set_selectedDate(endTime); $find('<%= RadScheduler1.ClientID %>' + "_Form_ResCategory").findItemByText(hiddenInputValue.category._text).select(); } } } } //ToolTip events. //The ToolTip is activated on Appointment's click. function appointmentClick(sender, args) { var apt = args.get_appointment(); showTooltip(apt); } //The ToolTip contains: start/end time, subject and category for the clicked Appointment. function showTooltip(apt) { var tooltip = $find('<%=RadToolTip1.ClientID %>'); tooltip.set_targetControl(apt.get_element()); $get("startTime").innerHTML = "<strong>Starts on: </strong>" + apt.get_start().format("MM/dd/yyyy HH:mm"); $get("endTime").innerHTML = "<strong>Ends on: </strong>" + apt.get_end().format("MM/dd/yyyy HH:mm"); $get("subject").innerHTML = "<strong>Subject: </strong>" + apt.get_subject(); $get("category").innerHTML = "<strong>Category: </strong>" + apt.get_resources().getResourceByType("Category").get_text(); tooltip.set_text($get("contentContainer").innerHTML); setTimeout(function () { tooltip.show(); }, 20); } function hideTooltip() { setTimeout(function () { var activeTooltip = Telerik.Web.UI.RadToolTip.getCurrent(); if (activeTooltip) { activeTooltip.hide(); } }, 50); } function appointmentMoving(sender, args) { hideTooltip(); } //]]> </script> </telerik:RadScriptBlock> <div> <div class="divRadios"> <span><strong>Choose a Method to Insert an Appointment</strong></span> <asp:RadioButtonList ID="RadioButtonListChooseInsert" runat="server" RepeatDirection="Vertical"> <asp:ListItem Text="Directly insert an appointment" Value="DirectInsert" Selected="true"></asp:ListItem> <asp:ListItem Text="Use advanced form to insert an appointment" Value="AdvancedInsert"></asp:ListItem> </asp:RadioButtonList> </div> <div class="background"> </div> <div class="divTree"> <span><strong>Drag a Node to the Scheduler</strong></span> <telerik:RadTreeView ID="RadTreeView1" runat="server" EnableDragAndDrop="True" Width="340px" OnClientNodeDropping="nodeDropping"> <Nodes> <telerik:RadTreeNode Value="1" Text="Technology" AllowDrag="false" Expanded="true"> <Nodes> <telerik:RadTreeNode Text="A prosthetic arm that 'feels'" Speaker="Todd Kuiken" Duration="90" /> <telerik:RadTreeNode Text="Wireless data from every light bulb" Speaker="Harald Haas" Duration="50" /> <telerik:RadTreeNode Text="Beware conflicts of interest" Speaker="Dan Ariely" Duration="60" /> <telerik:RadTreeNode Text="Can we make things that make themselves?" Speaker="Skylar Tibbits" Duration="40" /> </Nodes> </telerik:RadTreeNode> <telerik:RadTreeNode Value="2" Text="Science" AllowDrag="false"> <Nodes> <telerik:RadTreeNode Text="Finding life we can't imagine" Speaker="Christoph Adami" Duration="70"> </telerik:RadTreeNode> <telerik:RadTreeNode Text="The real reason for brains" Speaker="Daniel Wolpert" Duration="80"> </telerik:RadTreeNode> <telerik:RadTreeNode Text="Making matter come alive" Speaker="Lee Cronin" Duration="90"> </telerik:RadTreeNode> <telerik:RadTreeNode Text="Finding planets around other stars" Speaker="Lucianne Walkowicz" Duration="50"> </telerik:RadTreeNode> </Nodes> </telerik:RadTreeNode> <telerik:RadTreeNode Value="3" Text="Business" AllowDrag="false"> <Nodes> <telerik:RadTreeNode Text="3 things I learned while my plane crashed" Speaker="Ric Elias" Duration="70"> </telerik:RadTreeNode> <telerik:RadTreeNode Text="The surprising math of cities and corporations" Speaker="Geoffrey West" Duration="60"> </telerik:RadTreeNode> <telerik:RadTreeNode Text="How the market can keep streams flowing" Speaker="Rob Harmon" Duration="50"> </telerik:RadTreeNode> <telerik:RadTreeNode Text="How to use experts -- and when not to" Speaker="Noreena Hertz" Duration="90"> </telerik:RadTreeNode> </Nodes> </telerik:RadTreeNode> <telerik:RadTreeNode Value="4" Text="Entertainment" AllowDrag="false"> <Nodes> <telerik:RadTreeNode Text="On being just crazy enough" Speaker="Joshua Walters" Duration="70"> </telerik:RadTreeNode> <telerik:RadTreeNode Text="A flirtatious aria" Speaker="Danielle de Niese" Duration="60"> </telerik:RadTreeNode> <telerik:RadTreeNode Text="A history of the universe in sound" Speaker="Honor Harger" Duration="80"> </telerik:RadTreeNode> <telerik:RadTreeNode Text="The magic of truth and lies (and iPods)" Speaker="Marko Tempest" Duration="50"> </telerik:RadTreeNode> </Nodes> </telerik:RadTreeNode> <telerik:RadTreeNode Value="5" Text="Global Issues" AllowDrag="false"> <Nodes> <telerik:RadTreeNode Text="We can recycle plastic" Speaker="Mike Biddle" Duration="50"> </telerik:RadTreeNode> <telerik:RadTreeNode Text="Learning from a barefoot movement" Speaker="Bunker Roy" Duration="40"> </telerik:RadTreeNode> <telerik:RadTreeNode Text="How the economic inequality harms societies" Speaker="Rickard Wilkinson" Duration="70"> </telerik:RadTreeNode> <telerik:RadTreeNode Text="Ending hunger now" Speaker="Josette Sheeran" Duration="30"> </telerik:RadTreeNode> </Nodes> </telerik:RadTreeNode> </Nodes> <CollapseAnimation Duration="100" Type="OutQuint" /> <ExpandAnimation Duration="100" /> </telerik:RadTreeView> </div> <div class="schedulerPositioning"> <telerik:RadAjaxPanel ID="RadAjaxPanel" runat="server"> <telerik:RadScheduler runat="server" ID="RadScheduler1" StartInsertingInAdvancedForm="true" DataKeyField="ID" DataSubjectField="Subject" DataStartField="Start" DataEndField="End" OnClientAppointmentClick="appointmentClick" OnClientAppointmentMoving="appointmentMoving" OnClientFormCreated="formCreated" EnableDescriptionField="true" OverflowBehavior="Auto"> <AdvancedForm Modal="true"></AdvancedForm> </telerik:RadScheduler> <input id="HiddenInputAppointmentInfo" name="HiddenInputAppointmentInfo" type="hidden" runat="server"> </telerik:RadAjaxPanel> <telerik:RadToolTip ID="RadToolTip1" runat="server" RelativeTo="Element" Position="BottomCenter" AutoCloseDelay="0" ShowEvent="FromCode" Width="250px"> <div id="contentContainer"> <div id="startTime"> </div> <div id="endTime"> </div> <div id="subject"> </div> <div id="category"> </div> </div> </telerik:RadToolTip> </div> </div></asp:Content>using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using Telerik.Web.UI;public partial class Test : System.Web.UI.Page{ private const string ProviderSessionKey = "Telerik.Web.Examples.Scheduler.XmlSchedulerProvider.DefaultCS"; protected void Page_Load(object sender, EventArgs e) { if (Session.Count == 0 || Session["Login"] == null || Session["Login"].ToString() == "No") { Response.Redirect("Login.aspx"); } }}<telerik:RadTileList ID="tllReporting" runat="server" Skin="FriskaMetro" EnableEmbeddedSkins="False" Height="500px"> <Groups> <%--Sales--%> <telerik:TileGroup> <Tiles> <telerik:RadContentTemplateTile NavigateUrl="Sales/CombinedSales.aspx" Shape="Square" Name="tileSalesCombined"> <ContentTemplate> <div class="SlidePanel" style="width: 100%; height: 80px"> <h1> Combined Sales</h1> </div> <div class="SlidePanelTitle" style="width: 100%; height: 50px"> <h3> Sales</h3> </div> </ContentTemplate> <PeekTemplate> <div class="SlidePanel" style="width: 88%; height: 120px"> Report to show the combined retail and catering sales for period </div> </PeekTemplate> <PeekTemplateSettings Animation="Slide" AnimationDuration="800" Easing="easeInOutBack" ShowInterval="0" CloseDelay="5000" ShowPeekTemplateOnMouseOver="true" HidePeekTemplateOnMouseOut="true" /> </telerik:RadContentTemplateTile> <telerik:RadContentTemplateTile NavigateUrl="Sales/ProductsSoldReport.aspx" Shape="Square" Name="tileSalesProductsSold"> <ContentTemplate> <div class="SlidePanel" style="width: 100%; height: 80px"> <h1> Product <br />Sales</h1> </div> <div class="SlidePanelTitle" style="width: 100%; height: 50px"> <h3> Sales</h3> </div> </ContentTemplate> <PeekTemplate> <div class="SlidePanel" style="width: 88%; height: 120px"> Report to show the total number of products sold in a period </div> </PeekTemplate> <PeekTemplateSettings Animation="Slide" AnimationDuration="800" Easing="easeInOutBack" ShowInterval="0" CloseDelay="5000" ShowPeekTemplateOnMouseOver="true" HidePeekTemplateOnMouseOut="true" /> </telerik:RadContentTemplateTile> <telerik:RadContentTemplateTile NavigateUrl="Sales/SalesPOReceiptsReport.aspx" Shape="Wide" Name="tileSalesPOReceipts"> <ContentTemplate> <div class="SlidePanel" style="width: 100%; height: 80px"> <h1> Paid Out Receipts</h1> </div> <div class="SlidePanelTitle" style="width: 100%; height: 50px"> <h3> Sales</h3> </div> </ContentTemplate> <PeekTemplate> <div class="SlidePanel" style="width: 88%; height: 120px"> Report to show the paid out cash receipts per store </div> </PeekTemplate> <PeekTemplateSettings Animation="Slide" AnimationDuration="800" Easing="easeInOutBack" ShowInterval="0" CloseDelay="5000" ShowPeekTemplateOnMouseOver="true" HidePeekTemplateOnMouseOut="true" /> </telerik:RadContentTemplateTile> <telerik:RadContentTemplateTile NavigateUrl="Sales/SalesSummaryReport.aspx" Shape="Square" Name="tileSalesSalesSummary"> <ContentTemplate> <div class="SlidePanel" style="width: 100%; height: 80px"> <h1> Sales Summary</h1> </div> <div class="SlidePanelTitle" style="width: 100%; height: 50px"> <h3> Sales</h3> </div> </ContentTemplate> <PeekTemplate> <div class="SlidePanel" style="width: 88%; height: 120px"> Report to show the value of the sales in a period per store </div> </PeekTemplate> <PeekTemplateSettings Animation="Slide" AnimationDuration="800" Easing="easeInOutBack" ShowInterval="0" CloseDelay="5000" ShowPeekTemplateOnMouseOver="true" HidePeekTemplateOnMouseOut="true" /> </telerik:RadContentTemplateTile>
</Tiles> </telerik:TileGroup> </Groups> </telerik:RadTileList> Thenn I set the visible property as such:Is this a bug?foreach (RadBaseTile tile in tllReporting.GetAllTiles()) { tile.Visible = Authentication.HasUserPageAccess("~/Reporting/"+tile.NavigateUrl); }
<telerik:RadGrid ID="GridStaff" runat="server" ShowStatusBar="True" OnItemCommand="GridStaff_ItemCommand" OnItemUpdated="GridStaff_ItemUpdated" OnItemCreated="GridStaff_ItemCreated" OnUpdateCommand="GridStaff_UpdateCommand" OnItemInserted="GridStaff_ItemInserted" OnInsertCommand="GridStaff_InsertCommand" OnPreRender="GridStaff_PreRender" AutoGenerateColumns="False" PageSize="20" AllowSorting="True" AllowAutomaticInserts="True" AllowPaging="True" DataSourceID="SqlDataSourceStaff" AllowAutomaticDeletes="true" OnItemDataBound="GridStaff_ItemDataBound" AllowAutomaticUpdates="True" Width="835px" FilterType="CheckedList" AllowFilteringByColumn="True" GridLines="None" CellSpacing="0"> <ExportSettings> <Pdf> <PageHeader> <LeftCell Text="" /> <MiddleCell Text="" /> <RightCell Text="" /> </PageHeader> <PageFooter> <LeftCell Text="" /> <MiddleCell Text="" /> <RightCell Text="" /> </PageFooter> </Pdf> </ExportSettings> <MasterTableView DataSourceID="SqlDataSourceStaff" InsertItemDisplay="Top" InsertItemPageIndexAction="ShowItemOnFirstPage" DataKeyNames="UserID" EditMode="EditForms" AutoGenerateColumns="false" AllowMultiColumnSorting="False" Width="100%" CommandItemDisplay="Top" Name="admStaff"> <CommandItemSettings ShowAddNewRecordButton="true" AddNewRecordText="Add New Staff Member" ShowExportToPdfButton="true" /> <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column" Visible="True"> </RowIndicatorColumn> <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column" Visible="True"> </ExpandCollapseColumn> <Columns> <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn"> <HeaderStyle Width="20px"> </HeaderStyle> </telerik:GridEditCommandColumn> <telerik:GridBoundColumn SortExpression="UserID" ShowFilterIcon="false" AllowFiltering="false" HeaderText="#" HeaderButtonType="TextButton" DataField="UserID" UniqueName="UserID" MaxLength="7"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="EnglishName" HeaderText="Name" HeaderButtonType="TextButton" DataField="EnglishName" UniqueName="EnglishName" MaxLength="40"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="Subject" HeaderText="Subject" HeaderButtonType="TextButton" DataField="SubEn" UniqueName="Subject"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="DepEn" HeaderText="Department" HeaderButtonType="TextButton" DataField="DepartID" UniqueName="DepEn"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn HeaderText="Load/Week" UniqueName="TLoad" AllowFiltering="false" > <ItemStyle Width="20px" /> <ItemTemplate> <asp:Label ID="lblTeacherLoad" runat="server"></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn SortExpression="PhoneNumber" HeaderText="PhoneNumber" HeaderButtonType="TextButton" AllowFiltering="false" DataField="PhoneNumber" UniqueName="PhoneNumber"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn HeaderText="MSG" UniqueName="SendMSG" AllowFiltering="false" > <ItemStyle Width="20px" /> <ItemTemplate> <asp:ImageButton ID="img_SendMSG" runat="server" CommandName="SendMsgToStaff" ImageUrl="~/images/sendmsgicon.png" CommandArgument='<%# Bind("UserID") %>' Width="20px" Height="20px" /> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="SMS" UniqueName="SendSMS" AllowFiltering="false" > <ItemStyle Width="20px" /> <ItemTemplate> <asp:ImageButton ID="img_SendSMS" runat="server" CommandName="SendSmsToStaff" ImageUrl="~/images/sendsmsicon.png" CommandArgument='<%# Bind("UserID") %>' Width="20px" Height="20px" /> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> <EditFormSettings EditFormType="Template" PopUpSettings-Modal="true"> <FormTemplate> <div class="register"> <div class="divClass"> <fieldset class="rowPersonalEn"> <legend>Personal Details </legend> <p> <label>User ID </label> <asp:TextBox ID="txtUserID" CssClass="long" Text='<%# Bind("UserID") %>' Enabled="false" runat="server"></asp:TextBox> </p> <p> <label>First Name </label> <asp:TextBox ID="txtFirstNameEn" CssClass="long" Text='<%# Bind("FirstNameEn") %>' runat="server"></asp:TextBox> </p> <p> <label>Second Name </label> <asp:TextBox ID="txtSecondNameEn" CssClass="long" Text='<%# Bind("SecondNameEn") %>' runat="server"></asp:TextBox> </p> <p> <label>Family Name </label> <asp:TextBox ID="txtFamilyNameEn" CssClass="long" Text='<%# Bind("FamilyNameEn") %>' runat="server"></asp:TextBox> </p> <p> <label>Date of Birth </label> <asp:TextBox ID="txtDOB" CssClass="long" Text='<%# Bind("DOB") %>' runat="server"></asp:TextBox> </p> <p> <label>Nationality </label> <asp:DropDownList ID="ddlNationality" runat="server"> </asp:DropDownList> </p> <p> <label>ID No. </label> <asp:TextBox ID="txtIDNo" CssClass="long" Text='<%# Bind("IDNo") %>' runat="server"></asp:TextBox> </p> <p> <label>Mobile </label> <asp:TextBox ID="txtMobile" CssClass="long" Text='<%# Bind("PhoneNumber") %>' runat="server"></asp:TextBox> </p> <p> <label>Email </label> <asp:TextBox ID="txtEmail" CssClass="long" Text='<%# Bind("Email") %>' runat="server"></asp:TextBox> </p> <p> <label>Notes </label> <asp:TextBox ID="txtNotes" TextMode="MultiLine" Text='<%# Bind("Notes") %>' CssClass="multi" runat="server"></asp:TextBox> </p> </fieldset> <fieldset class="rowPersonalAr"> <legend>المعلومات الشخصية</legend> <p style="text-align:left"> <asp:TextBox ID="txtFirstNameAr" CssClass="long" Text='<%# Bind("FirstNameAr") %>' runat="server"></asp:TextBox> <label>الاسم الأول </label> </p> <p> <asp:TextBox ID="txtSecondNameAr" CssClass="long" Text='<%# Bind("SecondNameAr") %>' runat="server"></asp:TextBox> <label>الاسم الثاني </label> </p> <p> <asp:TextBox ID="txtFamilyNameAr" CssClass="long" Text='<%# Bind("FamilyNameAr") %>' runat="server"></asp:TextBox> <label>العائلة </label> </p> </fieldset> <fieldset class="rowAcademical"> <legend>Academical Information </legend> <p> <label>Degree</label> <asp:DropDownList ID="ddlAcademicDegree" runat="server" DataSourceID="DataSourceAD" DataTextField="ADEn" DataValueField="ADID" AppendDataBoundItems="true" > <asp:ListItem Selected="True" Text="Select" Value="0"></asp:ListItem> </asp:DropDownList> </p> <p> <label>Experience </label> <asp:TextBox ID="txtExp" CssClass="long" Text='<%# Bind("YearsOfExp") %>' runat="server"></asp:TextBox> </p> <p> <label>College/Uni. </label> <asp:TextBox ID="txtUniv" CssClass="long" Text='<%# Bind("CollegeName") %>' runat="server"></asp:TextBox> </p> <p> <label>Department</label> <asp:DropDownList ID="ddlDept" runat="server" DataSourceID="DataSourceDepartments" DataTextField="DepartmentEn" DataValueField="DepartmentID" AppendDataBoundItems="true" > <asp:ListItem Selected="True" Text="Select" Value="0" > </asp:ListItem> </asp:DropDownList> </p> <p> <label>Stage</label> <asp:DropDownList ID="ddlStage" runat="server" DataSourceID="DataSourceStages" DataTextField="StageEn" DataValueField="StageID" AppendDataBoundItems="true"> <asp:ListItem Selected="True" Text="Select" Value="0"></asp:ListItem> </asp:DropDownList> </p> <p> <label>Subject</label> <asp:DropDownList ID="ddlSubject" runat="server" DataSourceID="DataSourceSubjects" DataTextField="SubEn" DataValueField="SubID" AppendDataBoundItems="true"> <asp:ListItem Selected="True" Text="Select" Value="0"></asp:ListItem> </asp:DropDownList> </p> <p> <label>Hired Date</label> <asp:TextBox ID="txtHireDate" CssClass="long" Text='<%# Bind("HiredDate") %>' runat="server"></asp:TextBox> </p> </fieldset> <div> <asp:Button ID="btnUpdate" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>' runat="server" CommandName="Update"> </asp:Button> <asp:Button ID="btnCancel" Text="Close" runat="server" CausesValidation="False" CommandName="Cancel"></asp:Button> </div> </div> </div> </FormTemplate> </EditFormSettings> <BatchEditingSettings EditType="Cell" /> <PagerStyle AlwaysVisible="True" PageSizeControlType="RadComboBox" /> </MasterTableView> <PagerStyle AlwaysVisible="True" PageSizeControlType="RadComboBox" /> <FilterMenu EnableImageSprites="False"> </FilterMenu> </telerik:RadGrid><asp:SqlDataSource ID="SqlDataSourceStaff" runat="server" ConnectionString="<%$ ConnectionStrings:EschoolTestV2ConnectionString %>" SelectCommand="SELECT usr.*, usr.FirstNameEn+' '+usr.FamilyNameEn AS EnglishName, dept.DepEn AS DepartID,dept.DepID AS DeparID,sub.SubEn,sub.SubID, ad.ADEn,st.StageEn FROM AttUsers usr,AttStages st, AttAcademicalDegrees ad, AttDepartments dept, AttSubjects sub WHERE st.StageID=usr.Stage AND ad.ADID=usr.AcademicalDegree AND sub.SubID=usr.Subject AND usr.Department=dept.DepID" UpdateCommand="UPDATE AttUsers SET [FirstNameEn]=@FirstNameEn, [FirstNameAr]=@FirstNameAr, [SecondNameEn]=@SecondNameEn,[SecondNameAr]=@SecondNameAr,[FamilyNameEn]=@FamilyNameEn,[FamilyNameAr]=@FamilyNameAr,[DOB]=@DOB,[IDNo]=IDNo,[PhoneNumber]=@PhoneNumber,[Email]=@Email,[Notes]=@Notes,[YearsOfExp]=@YearsOfExp,[CollegeName]=@CollegeName,[Department]=@DeparID,[Subject]=@Subject,[AcademicalDegree]=@AcademicalDegree,[Stage]=@Stage,[HiredDate]=@HiredDate WHERE UserID=@UserID" InsertCommand="INSERT INTO AttUsers (FirstNameAr,SecondNameAr,FamilyNameAr,FirstNameEn,SecondNameEn,FamilyNameEn,DOB,IDNo,PhoneNumber,Email,Notes,YearsOfExp,CollegeName,Department,Subject,AcademicalDegree,Stage,HiredDate) VALUES (@FirstNameAr,@SecondNameAr,@FamilyNameAr,@FirstNameEn,@SecondNameEn,@FamilyNameEn,@DOB,@IDNo,@PhoneNumber,@Email,@Notes,@YearsOfExp,@CollegeName,@DeparID,@Subject,@AcademicalDegree,@Stage,@HiredDate)"> <UpdateParameters> <asp:Parameter Name="UserID" Type="String"></asp:Parameter> <asp:Parameter Name="FirstNameAr" Type="String"></asp:Parameter> <asp:Parameter Name="FirstNameEn" Type="String"></asp:Parameter> <asp:Parameter Name="SecondNameAr" Type="String"></asp:Parameter> <asp:Parameter Name="SecondNameEn" Type="String"></asp:Parameter> <asp:Parameter Name="FamilyNameAr" Type="String"></asp:Parameter> <asp:Parameter Name="FamilyNameEn" Type="String"></asp:Parameter> <asp:Parameter Name="DOB" Type="DateTime"></asp:Parameter> <asp:Parameter Name="IDNo" Type="String"></asp:Parameter> <asp:Parameter Name="PhoneNumber" Type="String"></asp:Parameter> <asp:Parameter Name="Email" Type="String"></asp:Parameter> <asp:Parameter Name="Notes" Type="String"></asp:Parameter> <asp:Parameter Name="YearsOfExp" Type="String"></asp:Parameter> <asp:Parameter Name="CollegeName" Type="String"></asp:Parameter> <asp:Parameter Name="DeparID" Type="String"></asp:Parameter> <asp:Parameter Name="Subject" Type="String"></asp:Parameter> <asp:Parameter Name="AcademicalDegree" Type="String"></asp:Parameter> <asp:Parameter Name="HiredDate" Type="DateTime"></asp:Parameter> <asp:Parameter Name="Stage" Type="String" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="FirstNameAr" Type="String"></asp:Parameter> <asp:Parameter Name="FirstNameEn" Type="String"></asp:Parameter> <asp:Parameter Name="SecondNameAr" Type="String"></asp:Parameter> <asp:Parameter Name="SecondNameEn" Type="String"></asp:Parameter> <asp:Parameter Name="FamilyNameAr" Type="String"></asp:Parameter> <asp:Parameter Name="FamilyNameEn" Type="String"></asp:Parameter> <asp:Parameter Name="DOB" Type="DateTime"></asp:Parameter> <asp:Parameter Name="IDNo" Type="String"></asp:Parameter> <asp:Parameter Name="PhoneNumber" Type="String"></asp:Parameter> <asp:Parameter Name="Email" Type="String"></asp:Parameter> <asp:Parameter Name="Notes" Type="String"></asp:Parameter> <asp:Parameter Name="YearsOfExp" Type="String"></asp:Parameter> <asp:Parameter Name="CollegeName" Type="String"></asp:Parameter> <asp:Parameter Name="DeparID" Type="String"></asp:Parameter> <asp:Parameter Name="Subject" Type="String"></asp:Parameter> <asp:Parameter Name="Stage" Type="String"></asp:Parameter> <asp:Parameter Name="AcademicalDegree" Type="String"></asp:Parameter> <asp:Parameter Name="HiredDate" Type="DateTime"></asp:Parameter> </InsertParameters></asp:SqlDataSource><asp:SqlDataSource ID="DataSourceDepartments" runat="server" ConnectionString="<%$ ConnectionStrings:EschoolTestV2ConnectionString %>" SelectCommand="SELECT DepEn AS DepartmentEn, DepID AS DepartmentID FROM AttDepartments ORDER BY DepID ASC"> </asp:SqlDataSource><asp:SqlDataSource ID="DataSourceSubjects" runat="server" ConnectionString="<%$ ConnectionStrings:EschoolTestV2ConnectionString %>" SelectCommand="SELECT SubEn, SubID FROM AttSubjects ORDER BY SubID ASC"> </asp:SqlDataSource><asp:SqlDataSource ID="DataSourceAD" runat="server" ConnectionString="<%$ ConnectionStrings:EschoolTestV2ConnectionString %>" SelectCommand="SELECT ADID, ADEn FROM AttAcademicalDegrees ORDER BY ADID ASC"> </asp:SqlDataSource><asp:SqlDataSource ID="DataSourceStages" runat="server" ConnectionString="<%$ ConnectionStrings:EschoolTestV2ConnectionString %>" SelectCommand="SELECT StageID, StageEn FROM AttStages ORDER BY StageID ASC"> </asp:SqlDataSource>