Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WosinddieAzubis._Default" EnableEventValidation="False" %>
- <asp:Content ID="BodyContent" ContentPlaceHolderID="Content" runat="server">
- <script src="Scripts/Azubi.js"></script>
- <p></p>
- <h1 style="text-align: center;">Übersicht</h1>
- <div class="col-md-6">
- <div class="form-group">
- <label for="txtsearch">Filter:</label>
- <asp:TextBox ID="Filter" class="form-control" runat="server" OnTextChanged="Filter_TextChanged" AutoPostBack="True"></asp:TextBox>
- </div>
- </div>
- <div class="col-md-6">
- <div class="form-group">
- <button id="createButton" class="btn btn-primary" onclick="openDate();return false" data-toggle="tooltip" data-placement="top" title="">Hinzufügen</button>
- </div>
- </div>
- <div id="information-panel">
- <div class="container">
- <div class="row">
- <div class="col-md-12">
- <div class="table-responsive">
- <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" CssClass="table table-striped table-bordered table-hover" DataKeyNames='Azubi_ID' OnRowCommand="GridView1_RowCommand">
- <Columns>
- <asp:ButtonField Text="Auswählen" CommandName="cmdDoubleClick" ControlStyle-CssClass="btn btn-primary" />
- <asp:TemplateField HeaderText="Name">
- <ItemTemplate>
- <asp:Label ID="Label1" runat="server" Text='<%# Bind("name") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Vorname">
- <ItemTemplate>
- <asp:Label ID="Label1" runat="server" Text='<%# Bind("vorname") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Geburtsdatum">
- <ItemTemplate>
- <asp:Label ID="Label1" runat="server" Text='<%# Bind("Geburtsdatum") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Schule">
- <ItemTemplate>
- <asp:Label ID="Label1" runat="server" Text='<%# Bind("Bezeichnung_Schule") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Status">
- <ItemTemplate>
- <asp:Label ID="Label1" runat="server" Text='<%# Bind("Bezeichnung_Status") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Abteilung">
- <ItemTemplate>
- <asp:Label ID="Label1" runat="server" Text='<%# Bind("Bezeichnung_Abt") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Fachrichtung">
- <ItemTemplate>
- <asp:Label ID="Label1" runat="server" Text='<%# Bind("Bezeichnung_FS") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- </Columns>
- </asp:GridView>
- </div>
- </div>
- </div>
- </div>
- </div>
- <!--Pop up Message start-->
- <div class="modal fade" id="basicModal" tabindex="-1" role="dialog" aria-labelledby="basicModal" aria-hidden="true">
- <div class="modal-dialog">
- <div class="modal-content">
- <div class="modal-header">
- <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
- <h4 class="modal-title" id="myModalLabel">Zeit hinzufügen</h4>
- </div>
- <div class="text-center">
- <div class="modal-body">
- <div class="col-md-6">
- <div class="form-group">
- <label for="txtsearch">Nachname*:</label>
- <asp:TextBox ID="lasteName" runat="server" CssClass="form-control"></asp:TextBox>
- </div>
- </div>
- <div class="col-md-6">
- <div class="form-group">
- <label for="txtsearch">Vorname*:</label>
- <asp:TextBox ID="firstName" class="form-control" runat="server"></asp:TextBox>
- </div>
- </div>
- <div class="col-md-6">
- <div class="form-group">
- <label for="txtsearch">Fachrichtung:</label>
- <asp:DropDownList ID="fs" class="form-control" runat="server" AppendDataBoundItems="True" ValidateRequestMode="Inherit" DataSourceID="Azubi_Fachrichtung" DataTextField="Bezeichnung_FS" DataValueField="FS_ID">
- <asp:ListItem Selected="True"></asp:ListItem>
- </asp:DropDownList>
- </div>
- </div>
- <div class="col-md-6">
- <div class="form-group">
- <label for="txtsearch">Schule:</label>
- <asp:DropDownList ID="school" class="form-control" runat="server" AppendDataBoundItems="True" DataSourceID="Azubi_Schulen" DataTextField="Bezeichnung_Schule" DataValueField="Schule_ID">
- <asp:ListItem Selected="True"></asp:ListItem>
- </asp:DropDownList>
- </div>
- </div>
- <div class="col-md-6">
- <div class="form-group">
- <label for="txtsearch">Status:</label>
- <asp:DropDownList ID="status" class="form-control" runat="server" AppendDataBoundItems="True" DataSourceID="Azubi_Status" DataTextField="Bezeichnung_Status" DataValueField="Status_ID">
- <asp:ListItem Selected="True"></asp:ListItem>
- </asp:DropDownList>
- </div>
- </div>
- <div class="col-md-6">
- <div class="form-group">
- <label for="txtsearch">Geburtsdatum:</label>
- <asp:TextBox ID="birthdate" runat="server" CssClass="form-control"></asp:TextBox>
- <ajaxToolkit:CalendarExtender ID="CalendarExtender2" runat="server" BehaviorID="accountEndDate_CalendarExtender" TargetControlID="birthdate" Format="dd/MM/yyyy" />
- </div>
- </div>
- <div class="col-md-6">
- <div class="form-group">
- <asp:Button ID="InsertAzubi" runat="server" Text="Speichern" CssClass="btn btn-primary" OnClick="InsertAzubi_Click" />
- </div>
- </div>
- </div>
- </div>
- <div class="modal-footer">
- </div>
- </div>
- </div>
- </div>
- <!--Pop up Message end-->
- <asp:SqlDataSource ID="Azubi_Status" runat="server" ConnectionString="<%$ ConnectionStrings:azubisConnectionString %>" SelectCommand="SELECT * FROM [Azubi_Status]"></asp:SqlDataSource>
- <asp:SqlDataSource ID="Azubi_Schulen" runat="server" ConnectionString="<%$ ConnectionStrings:azubisConnectionString %>" SelectCommand="SELECT * FROM [Azubis_Schulen]"></asp:SqlDataSource>
- <asp:SqlDataSource ID="Azubi_Fachrichtung" runat="server" ConnectionString="<%$ ConnectionStrings:azubisConnectionString %>" SelectCommand="SELECT * FROM [Azubis_Fachrichtungen]"></asp:SqlDataSource>
- <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:azubisConnectionString %>" SelectCommand="SELECT Azubis_Namen.Name, Azubis_Namen.Vorname, Azubis_Namen.Geburtsdatum, Azubis_Namen.Azubi_ID, Azubis_Fachrichtungen.Bezeichnung_FS, Azubi_Status.Bezeichnung_Status, Azubis_Schulen.Bezeichnung_Schule, Azubi_Abteilung.Bezeichnung_Abt FROM Azubi_Status INNER JOIN Azubi_Abteilung INNER JOIN Azubis_Namen INNER JOIN Azubis_Fachrichtungen ON Azubis_Namen.Fach_ID = Azubis_Fachrichtungen.FS_ID INNER JOIN Azubis_Schulen ON Azubis_Namen.Schule_ID = Azubis_Schulen.Schule_ID INNER JOIN Azubis_Terminplan ON Azubis_Namen.Azubi_ID = Azubis_Terminplan.Azubi_ID ON Azubi_Abteilung.Abteilungs_ID = Azubis_Terminplan.Abteilungs_ID ON Azubi_Status.Status_ID = Azubis_Terminplan.Status_ID"></asp:SqlDataSource>
- </asp:Content>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement