<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="RadGridEditing.ascx.cs" Inherits="TelerikRadGrid.RadGridEditing" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<telerik:RadGrid runat="server" ID="RadGrid1" AllowAutomaticDeletes="true" AllowAutomaticUpdates="true"
    AllowAutomaticInserts="true" OnItemDeleted="RadGrid1_ItemDeleted" AllowPaging="true"
    AllowSorting="true" OnItemCommand="RadGrid1_ItemCommand" AllowMultiRowSelection="true"
    AllowFilteringByColumn="true" DataSourceID="dsDuShops" AutoGenerateColumns="false"
    OnNeedDataSource="RadGrid1_NeedDataSource" OnEditCommand="RadGrid1_EditCommand"
    OnItemDataBound="RadGrid1_ItemDataBound" OnItemCreated="RadGrid1_ItemCreated">
    <PagerStyle Mode="NextPrevNumericAndAdvanced" AlwaysVisible="true" />
    <MasterTableView DataKeyNames="id" IsFilterItemExpanded="true" CommandItemDisplay="Top"
        AllowFilteringByColumn="true">
        <CommandItemTemplate>
            <table border="0" cellpadding="0" cellspacing="0" width="100%">
                <tr>
                    <td align="left">
                        <asp:LinkButton ID="LinkButton2" runat="server" CommandName="InitInsert" Visible='<%# !RadGrid1.MasterTableView.IsItemInserted %>'><strong>Add new Location</strong></asp:LinkButton>
                    </td>
                    <td align="right">
                        <asp:LinkButton runat="server" ID="LinkButton1" Text="&lt;strong>Clear Filters</strong>" CommandName="ClearFilters" />
                    </td>
                </tr>
            </table>
            <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Height="75px"
                Width="75px" Transparency="0" IsSticky="true" Style="position: absolute; z-index: 999;
                top: 250px; left: 200px">
                <img alt="Loading..." src='<%= RadAjaxLoadingPanel.GetWebResourceUrl(Page, "Telerik.Web.UI.Skins.Default.Ajax.loading.gif") %>'
                    style="border: 0;" />
            </telerik:RadAjaxLoadingPanel>
        </CommandItemTemplate>
        <EditFormSettings>
            <EditColumn UpdateText="Update" CancelText="Close" Reorderable="true"  EditText="Edit"
                UniqueName="EditCommandColumn" HeaderText="View">
            </EditColumn>
        </EditFormSettings>
        <Columns>
            <telerik:GridBoundColumn DataField="id" ReadOnly="true" DataType="System.Int32" Visible="false"
                UniqueName="colID">
            </telerik:GridBoundColumn>
            
            <telerik:GridTemplateColumn UniqueName="Area">
                <ItemTemplate>
                    <asp:Label ID="lbl" runat="server" Text='<%#Eval("Area") %>' />
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:CheckBoxList ID="chkArea" runat="server" />
                </EditItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridBoundColumn DataField="Title" DataType="System.String" HeaderText="Title"
                UniqueName="Title">
            </telerik:GridBoundColumn>
            <telerik:GridEditCommandColumn UniqueName="EditCommandColumn" HeaderText="Edit" ButtonType="LinkButton"
                EditText="Edit">
            </telerik:GridEditCommandColumn>
        </Columns>
    </MasterTableView>
    <ClientSettings>
        <Selecting AllowRowSelect="true" />
    </ClientSettings>
</telerik:RadGrid>
<asp:SqlDataSource runat="server" ID="dsDuShops" ConnectionString="<%$ ConnectionStrings:Sitefinity %>"
    SelectCommand="SELECT    id, 
            title,
            area
            FROM Dushops" DeleteCommand="DELETE FROM [dushops] WHERE [id] = @id"
    UpdateCommand="update dushops set
            title = @title,
            area = @area
            where [id] = @id " 
            InsertCommand="insert into dushops (title, area) 
            values (@title, @chkarea)">
            <UpdateParameters>
                <asp:SessionParameter SessionField="chkArea" Name="area" />
            </UpdateParameters>
    <DeleteParameters>
        <asp:Parameter Name="id" Type="Int32" />
    </DeleteParameters>
</asp:SqlDataSource>
<input type="hidden" runat="server" id="hdnConfirm" />