<%@ Page Title="" Language="C#" MasterPageFile="~/VEtterem.Master" AutoEventWireup="true"
    CodeBehind="ServedOrdersDetails.aspx.cs" Inherits="VEtterem.Pultos.TeljesitettOrdersDetails" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="CPHMain" runat="server">
    <asp:Panel ID="Panel1" runat="server" CssClass="panel">
        <asp:DetailsView ID="DetailsView1" runat="server" Width="300px" DataSourceID="ARDetailsSqlDataSource"
            CssClass="gw" AutoGenerateRows="False">
            <FooterStyle CssClass="gwFooter" />
            <RowStyle CssClass="gwRStyle" />
            <HeaderStyle CssClass="gwHeader" />
            <Fields>
                <asp:BoundField DataField="BEJELENTKEZESINEV" HeaderText="Bejelentkezési név" ReadOnly="True"
                    SortExpression="BEJELENTKEZESINEV" Visible="True" />
                <asp:BoundField DataField="EMAIL" HeaderText="E-mail cím" ReadOnly="True" SortExpression="EMAIL" />
                <asp:BoundField DataField="TELJESNEV" HeaderText="Teljes név" ReadOnly="True" SortExpression="TELJESNEV" />
                <asp:BoundField DataField="CIM" HeaderText="Cím" ReadOnly="True" SortExpression="CIM" />
                <asp:BoundField DataField="TEL" HeaderText="Telefonszám" ReadOnly="True" SortExpression="TEL" />
                <asp:BoundField DataField="FELADVA" HeaderText="Feladva" ReadOnly="True" SortExpression="FELADVA" />
                <asp:BoundField DataField="TELJESITVE" HeaderText="Teljesítve" ReadOnly="True" SortExpression="TELJESITVE" />
                <asp:BoundField DataField="AKCIOS_VEGOSSZEG" HeaderText="Akciós végösszeg" ReadOnly="True"
                    SortExpression="AKCIOS_VEGOSSZEG" />
            </Fields>
        </asp:DetailsView>
        <asp:SqlDataSource ID="ARDetailsSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:VCS %>"
            ProviderName="<%$ ConnectionStrings:VCS.ProviderName %>" SelectCommand="SELECT UGYFEL.BEJELENTKEZESINEV, UGYFEL.EMAIL, UGYFEL.TELJESNEV, UGYFEL.CIM, UGYFEL.TEL, RENDELES.FELADVA, RENDELES.TELJESITVE, RENDELES.AKCIOS_VEGOSSZEG FROM ETLAP INNER JOIN RENDELES_TETEL ON ETLAP.ETLAPID = RENDELES_TETEL.CIKK INNER JOIN RENDELES ON RENDELES_TETEL.RENDELES = RENDELES.RENDELESID INNER JOIN UGYFEL ON RENDELES.UGYFEL = UGYFEL.UGYFELID WHERE (UGYFEL.UGYFELID = :UGYFELID AND RENDELES.RENDELESID = :RENDELESID)">
            <SelectParameters>
                <asp:QueryStringParameter Name="UGYFELID" QueryStringField="UgyfelID" />
                <asp:QueryStringParameter Name="RENDELESID" QueryStringField="RendelesID" />
            </SelectParameters>
        </asp:SqlDataSource>
        <br />
        <asp:GridView ID="TetelekGridView" runat="server" DataSourceID="TetelekSqlDataSource"
            AutoGenerateColumns="False" CssClass="gw" Width="300px">
            <RowStyle CssClass="gwRStyle" />
            <Columns>
                <asp:BoundField DataField="ENEV" HeaderText="Étel" ReadOnly="True" SortExpression="ENEV" />
                <asp:BoundField DataField="DB" HeaderText="Mennyiség" ReadOnly="True" SortExpression="DB" />
            </Columns>
            <FooterStyle CssClass="gwFooter" />
            <HeaderStyle CssClass="gwHeader" />
            <AlternatingRowStyle CssClass="gwAltRStyle" />
        </asp:GridView>
        <asp:SqlDataSource ID="TetelekSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:VCS %>"
            ProviderName="<%$ ConnectionStrings:VCS.ProviderName %>" SelectCommand="SELECT ETLAP.ENEV, RENDELES_TETEL.DB FROM RENDELES INNER JOIN RENDELES_TETEL ON RENDELES.RENDELESID = RENDELES_TETEL.RENDELES INNER JOIN ETLAP ON RENDELES_TETEL.CIKK = ETLAP.ETLAPID WHERE (RENDELES.RENDELESID = :RendelesID)">
            <SelectParameters>
                <asp:QueryStringParameter Name="RENDELESID" QueryStringField="RendelesID" />
            </SelectParameters>
        </asp:SqlDataSource>
        &nbsp;
    </asp:Panel>
</asp:Content>
