<%@ Page Title="" Language="C#" MasterPageFile="~/template.master" AutoEventWireup="true" CodeFile="adremservico.aspx.cs" Inherits="oficinas_prestacaoservico_adremservico" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <div class="col-md-6">
        <h1>Adicionar Serviços</h1>
        <asp:CheckBoxList ID="CheckBoxList1" runat="server" DataSourceID="SqlDataSource1" DataTextField="Nome" DataValueField="idServico">

        </asp:CheckBoxList>

        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [Servicos] WHERE idServico NOT IN (SELECT idServicoFK FROM OficinasHasServicos WHERE idOficinaFK=@idOficinaFK) ORDER BY [Nome]">
            <SelectParameters>
                <asp:SessionParameter Name="idOficinaFK" SessionField="id" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:Button id="btn1" runat="server" text="test" OnClick="btn1_Click"/>
    </div>
        <div class="col-md-6">
            <h1>Serviços Disponibilizados</h1>
            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" class="table col-md-6 col-lg-6">
                <Columns >
                    <asp:BoundField DataField="Nome" HeaderText="Nome" SortExpression="Nome" />
                    <asp:CommandField ButtonType="Link" ShowDeleteButton="true"/>
                </Columns>

            </asp:GridView>


            <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [Servicos] WHERE idServico IN (SELECT idServicoFK FROM OficinasHasServicos WHERE idOficinaFK=@idOficinaFK) ORDER BY [Nome]" DeleteCommand="Delete from oficinashasservicos where idOficinaFK=@idOficina and idServicoFK=@idservico">
                <DeleteParameters>
                    <asp:Parameter Name="idoficina" />
                    <asp:Parameter Name="idservicos" />
                </DeleteParameters>
                <SelectParameters>
                    <asp:SessionParameter Name="idOficinaFK" SessionField="id" />
                </SelectParameters>
            </asp:SqlDataSource>


        </div>
</asp:Content>