Advertisement
Guest User

Untitled

a guest
Jun 25th, 2016
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 4.43 KB | None | 0 0
  1. <%@ Page Title="" Language="C#" MasterPageFile="~/ProjectoFase2.Master" AutoEventWireup="true" CodeBehind="SistemaDomotico.aspx.cs" Inherits="ProjectoFase2.SistemaDomotico" %>
  2.  
  3. <asp:Content ID="SDHeadContent" ContentPlaceHolderID="head" runat="server">
  4. </asp:Content>
  5.  
  6. <asp:Content ID="SDContent" CssClass="main-content" ContentPlaceHolderID="MainContentPlaceHolder" runat="server">
  7.     <asp:SqlDataSource runat="server" ID="SQLDataSource"
  8.         ConnectionString='<%$ ConnectionStrings:ProjectoFase2_PIConnectionString %>'
  9.         SelectCommand="SELECT DISTINCT [ConsolaID], [ConsolaNome] FROM [Consola]"
  10.         UpdateCommand="UPDATE Consola SET ConsolaNome = @ConsolaNome WHERE ConsolaID = @ConsolaID"
  11.         DeleteCommand="DELETE FROM Consola WHERE ConsolaID = @ConsolaID"
  12.         InsertCommand="INSERT INTO Consola (ConsolaNome) VALUES (@ConsolaNome)">
  13.         <UpdateParameters>
  14.             <asp:Parameter Name="ConsolaNome" Type="String" />
  15.             <asp:Parameter Name="ConsolaID" Type="Int32" />
  16.         </UpdateParameters>
  17.         <DeleteParameters>
  18.             <asp:Parameter Name="ConsolaID" Type="Int32" />
  19.         </DeleteParameters>
  20.         <InsertParameters>
  21.             <asp:Parameter Name="ConsolaNome" Type="String" />
  22.         </InsertParameters>
  23.     </asp:SqlDataSource>
  24.     <asp:ListView runat="server" ID="ListaConsolas" DataSourceID="SQLDataSource" InsertItemPosition="None" DataKeyNames="ConsolaID">
  25.         <LayoutTemplate>
  26.             <table runat="server" id="table1" style="text-align: center;">
  27.                 <tr runat="server" id="itemPlaceholder"></tr>
  28.             </table>
  29.             <div style="text-align: center">
  30.                 <asp:LinkButton runat="server" CausesValidation="true" OnClick="MostrarInsertTemplate">
  31.                     <i class="fa fa-plus-circle" style="color: black;" aria-hidden="true"></i>
  32.                 </asp:LinkButton>
  33.             </div>
  34.         </LayoutTemplate>
  35.         <ItemTemplate>
  36.             <tr runat="server">
  37.                 <td runat="server">
  38.                     <asp:HiddenField ID="ConsolaID" Value='<%# Eval("ConsolaID") %>' runat="server" />
  39.                     <asp:LinkButton ID="EditConsola" CommandName="Edit" CausesValidation="true" runat="server"><i class="fa fa-pencil-square-o" style="color: black;" aria-hidden="true"></i></asp:LinkButton>
  40.                     <asp:HyperLink ID="lblConsolaNome" runat="server" Text='<%# Eval("ConsolaNome") %>' NavigateUrl='<%# String.Format("~/Compartimentos.aspx?ConsolaID={0}",Eval("ConsolaID"))%>' />
  41.                     <asp:LinkButton ID="DeleteConsola" CommandName="Delete" runat="server"><i class="fa fa-trash-o" aria-hidden="true"></i></asp:LinkButton>
  42.                 </td>
  43.             </tr>
  44.         </ItemTemplate>
  45.         <EmptyDataTemplate>
  46.             <div style="text-align: center">
  47.                 <asp:LinkButton runat="server" CausesValidation="true" OnClick="MostrarInsertTemplate">
  48.                     <i class="fa fa-plus-circle" style="color: black;" aria-hidden="true"></i>
  49.                 </asp:LinkButton>
  50.             </div>
  51.         </EmptyDataTemplate>
  52.         <EditItemTemplate>
  53.             <div style="text-align: center">
  54.                 <asp:HiddenField ID="ConsolaID" Value='<%# Bind("ConsolaID") %>' runat="server" />
  55.                 <asp:TextBox runat="server" ID="ConsolaNome" Text='<%# Bind("ConsolaNome") %>' />
  56.                 <asp:LinkButton runat="server" CommandName="Update"><i class="fa fa-check-circle" aria-hidden="true"></i></asp:LinkButton>
  57.                 <asp:LinkButton runat="server" CommandName="Cancel"><i class="icon-remove-sign" aria-hidden="true"></i></asp:LinkButton>
  58.                 <asp:RequiredFieldValidator runat="server" ControlToValidate="ConsolaNome" Display="Dynamic" ForeColor="Red" ErrorMessage="O campo não pode ser vazio" />
  59.             </div>
  60.         </EditItemTemplate>
  61.         <InsertItemTemplate>
  62.             <div style="text-align: center">
  63.                 <asp:TextBox runat="server" ID="ConsolaNome" Text='<%# Bind("ConsolaNome") %>' />
  64.                 <asp:LinkButton runat="server" CommandName="Insert" OnClick="EsconderInsertTemplate"><i class="fa fa-check-circle" aria-hidden="true"></i></asp:LinkButton>
  65.                 <asp:RequiredFieldValidator runat="server" ControlToValidate="ConsolaNome" Display="Dynamic" ForeColor="Red" ErrorMessage="O campo não pode ser vazio" />
  66.             </div>
  67.         </InsertItemTemplate>
  68.     </asp:ListView>
  69. </asp:Content>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement