Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@ 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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement