PDA-Bank-Cards-Info

1
<%@ Page Title="Карты" Language="C#" MasterPageFile="~/MasterPage.master"
2
    AutoEventWireup="true" CodeFile="Cards.aspx.cs" Inherits="Cards" %>
3

4
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
5
</asp:Content>
6
<asp:Content ID="Content2" ContentPlaceHolderID="Content" runat="Server">
7
    <asp:DataList ID="CardsList" runat="server" DataSourceID="SqlCards"
8
        DataKeyField="card_id" OnSelectedIndexChanged="CardsList_SelectedIndexChanged"
9
        OnPreRender="CardsList_PreRender" ShowFooter="False">
10
        <HeaderTemplate>
11
            Подключенные карты
12
        </HeaderTemplate>
13
        <ItemTemplate>
14
            <b>
15
                <%# Eval("card_number") %></b>
16
            <%# Eval("card_type_name") %>
17
            <%# Eval("exp_date", "{0:MM'/'yy}") %><br />
18
            <small><center><font color=gray>(Статус: <%# Eval("card_status") %>)</font></center></small>
19
            <table width="100%">
20
                <tr>
21
                    <td>
22
                        Доступно:
23
                    </td>
24
                    <td align="right">
25
                        <b><%# Eval("amount_available", "{0:F2}") %></b>
26
                        <%# Eval("card_currency") %>
27
                    </td>
28
                </tr>
29
                <tr>
30
                    <td>
31
                        Блокир.:
32
                    </td>
33
                    <td align="right">
34
                        <b><%# Eval("amount_on_hold", "{0:F2}") %></b>
35
                        <%# Eval("card_currency") %>
36
                    </td>
37
                </tr>
38
                <tr>
39
                    <td>
40
                        Задолж.:
41
                    </td>
42
                    <td align="right">
43
                        <b><%# Eval("amount_debt", "{0:F2}") %></b>
44
                        <%# Eval("card_currency") %>
45
                    </td>
46
                </tr>
47
                <tr>
48
                    <td colspan="2" align="right">
49
                        <asp:Button ID="MoreButton" runat="server" Text="Подробнее" CommandName="select" /></div>
50
                    </td>
51
                </tr>
52
            </table>
53
        </ItemTemplate>
54
        <FooterTemplate>
55
            Вы подключились к системе, но, как видно, у Вас нет на данный
56
            момент подключенных карт, которые были бы сейчас действительны.
57
            <br />
58
            Пожалуйста, позвоните в Банк и уточните этот вопрос.
59
        </FooterTemplate>
60
    </asp:DataList>
61
    <asp:DataList ID="TransList" runat="server" DataSourceID="SqlTrans"
62
        Width="100%" >
63
        <HeaderTemplate>
64
            Операции за
65
            <%# RepDate.ToString("MMMM yy") %>
66
            <asp:Button ID="FilterButton1" runat="server" Text="<<" CommandName="prev"
67
                CommandArgument="-1" OnCommand="FilterButton_Command" />
68
            <asp:Button ID="FilterButton2" runat="server" Text=">>" CommandName="next"
69
                CommandArgument="1" OnCommand="FilterButton_Command" />
70
            <asp:Button ID="FilterButton3" runat="server" Text=">|" CommandName="today"
71
                CommandArgument="0" OnCommand="FilterButton_Command" />
72
        </HeaderTemplate>
73
        <ItemTemplate>
74
            <asp:Label ID="Date" runat="server" Text='<%# Eval("transaction_date", "{0:dd.MM}") %>' />
75
            <asp:Label ID="Sum" runat="server" Text='<%# Eval("amount", "{0:F2}") %>' Font-Bold="true"
76
                /><asp:Label ID="Cur" runat="server" Text='<%# Eval("operation_currency_iso") %>' />
77
            <table>
78
                <tr>
79
                    <td>
80
                        <%# Eval("comment") %>
81
                    </td>
82
                </tr>
83
            </table>
84
        </ItemTemplate>
85
        <FooterTemplate>
86
            Итого операций:
87
            <%# TransList.Items.Count.ToString() %>
88
        </FooterTemplate>
89
    </asp:DataList>
90
    
91
    <asp:DataList ID="HoldsList" runat="server" DataSourceID="SqlHolds"
92
        OnPreRender="HoldsList_PreRender" ShowHeader="False" Width="100%">
93
        <HeaderTemplate>
94
            Блокировки по карте
95
        </HeaderTemplate>
96
        <ItemTemplate>
97
            <%# Eval("operation_date", "{0:dd.MM}")%>
98
            <b><%# Eval("amount", "{0:F2}") %></b>
99
            <%# Eval("operation_currency_iso") %>
100
            <table>
101
                <tr>
102
                    <td>
103
                        <%# Eval("comment") %>
104
                    </td>
105
                </tr>
106
            </table>
107
        </ItemTemplate>
108
    </asp:DataList>
109
    <asp:DetailsView ID="DetailDebts" runat="server" AutoGenerateRows="False"
110
        DataSourceID="SqlDebts">
111
        <HeaderTemplate>
112
            Задолженность по валютам
113
        </HeaderTemplate>
114
        <Fields>
115
            <asp:BoundField DataField="amount_810" DataFormatString="{0:F2}RUR"
116
                HeaderText="Рубли РФ:" SortExpression="amount_810">
117
                <ItemStyle HorizontalAlign="Right" Wrap="False" />
118
            </asp:BoundField>
119
            <asp:BoundField DataField="amount_840" DataFormatString="{0:F2}USD"
120
                HeaderText="Доллары США:" SortExpression="amount_840">
121
                <ItemStyle HorizontalAlign="Right" Wrap="False" />
122
            </asp:BoundField>
123
            <asp:BoundField DataField="amount_978" DataFormatString="{0:F2}EUR"
124
                HeaderText="Евро:" SortExpression="amount_978">
125
                <ItemStyle HorizontalAlign="Right" Wrap="False" />
126
            </asp:BoundField>
127
        </Fields>
128
    </asp:DetailsView>
129
    <br />
130
    <asp:Button ID="BackButton" runat="server" Text="Карты" OnClick="BackButton_Click"
131
        Visible="False" />
132
    <asp:SqlDataSource ID="SqlCards" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionDataMart %>"
133
        SelectCommand="wsp_dm_pc_get_cards_num" SelectCommandType="StoredProcedure">
134
        <SelectParameters>
135
            <asp:Parameter Name="client_login" Type="String" />
136
        </SelectParameters>
137
    </asp:SqlDataSource>
138
    <asp:SqlDataSource ID="SqlTrans" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionDataMart %>"
139
        SelectCommand="wsp_dm_pc_get_operations" SelectCommandType="StoredProcedure"
140
        FilterExpression="transaction_date&gt;='{0}' and transaction_date&lt;'{1}'">
141
        <SelectParameters>
142
            <asp:Parameter Name="client_login" Type="String" />
143
            <asp:ControlParameter ControlID="CardsList" Name="card_id" PropertyName="SelectedValue"
144
                Type="Int32" />
145
        </SelectParameters>
146
    </asp:SqlDataSource>
147
    <asp:SqlDataSource ID="SqlHolds" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionDataMart %>"
148
        SelectCommand="wsp_dm_pc_get_on_hold" SelectCommandType="StoredProcedure">
149
        <SelectParameters>
150
            <asp:Parameter Name="client_login" Type="String" />
151
            <asp:ControlParameter ControlID="CardsList" Name="card_id" PropertyName="SelectedValue"
152
                Type="Int32" />
153
        </SelectParameters>
154
    </asp:SqlDataSource>
155
    <asp:SqlDataSource ID="SqlDebts" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionDataMart %>"
156
        SelectCommand="wsp_dm_pc_get_debt" SelectCommandType="StoredProcedure">
157
        <SelectParameters>
158
            <asp:Parameter Name="client_login" Type="String" />
159
            <asp:ControlParameter ControlID="CardsList" Name="card_id" PropertyName="SelectedValue"
160
                Type="Int32" />
161
        </SelectParameters>
162
    </asp:SqlDataSource>
163
</asp:Content>
164