package GUI;

import javax.swing.*;
import javax.swing.table.DefaultTableModel;

import Class.User;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;

/**
 * Created by user on 2018-01-03.
 */
public class MenuFrame {
    public JPanel mainPanel;
    private JButton buttonHisotry;
    private JButton ButtonWithDraw;
    private JButton buttonDeposit;
    User user;
    Connection conn;
    ResultSet rs;
    PreparedStatement ps;


    public MenuFrame(User user)
    {
        this.user=new User();
        this.user=user;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            conn= DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","Artur1","giwera1");
        } catch (SQLException e1) {
            e1.printStackTrace();
        } catch (ClassNotFoundException e1) {
            e1.printStackTrace();
        }

        buttonHisotry.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                HistoryFrame historyFrame=new HistoryFrame();
                DefaultTableModel model = new DefaultTableModel(new Object[]{"KURS", "POSTAWIONE_SRODKI", "WYGRANA","STATUS"}, 0)
                {
                    @Override
                    public boolean isCellEditable(int row, int column) {
                        //all cells false
                        return false;
                    }
                };
                try {
                    ps =conn.prepareStatement("SELECT TRUNC(KURS,2),TRUNC(POSTAWIONE_SRODKI,2),TRUNC(WYGRANA,2),STATUS From KUPON where UZYTKOWNIK_ID=(?)");
                    ps.setInt(1,user.getUser_id());
                    ps.execute();
                    rs= ps.getResultSet();
                    model.addRow(new Object[]{"KURS", "POSTAWIONE_SRODKI", "WYGRANA","STATUS"});
                    while (rs.next())
                    {
                        String a = rs.getString(1);
                        String b = rs.getString(2);
                        String c = rs.getString(3);
                        int d = rs.getInt(4);
                        String f;
                        if(d==1)
                        {
                            f="Wygrana";
                        }
                        else f="Przegrana";
                        model.addRow(new Object[]{a, b, c,f});

                    }
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
                historyFrame.tableHistory.setModel(model);
                JFrame hisFrame =new JFrame ("Historia");
                hisFrame.setContentPane(historyFrame.mainPanel);
                hisFrame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
                hisFrame.pack();
                hisFrame.setVisible(true);
                hisFrame.setLocationRelativeTo(null);
            }
        });
        ButtonWithDraw.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                JFrame drawFrame=new JFrame("Wypłata");
                WithDrawFrame withdrawFrame=new WithDrawFrame(user.getUser_id());
                drawFrame.setContentPane(withdrawFrame.mainPanel);
                drawFrame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
                drawFrame.pack();
                drawFrame.setVisible(true);
                drawFrame.setLocationRelativeTo(null);
                drawFrame.addWindowListener(new java.awt.event.WindowAdapter() {
                    @Override
                    public void windowClosing(java.awt.event.WindowEvent windowEvent) {
                        try {
                            ps =conn.prepareStatement("SELECT SRODKI From KONTO where UZYTKOWNIK_ID=(?)");
                            ps.setInt(1,user.getUser_id());
                            ps.execute();
                            rs= ps.getResultSet();
                            rs.next();
                            user.setMoney(rs.getFloat(1));
                        } catch (SQLException e1) {
                            e1.printStackTrace();
                        }
                    }
                });
            }
        });
        buttonDeposit.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                JFrame depositFrame=new JFrame("Wpłata");
                DepositFrame depFrame=new DepositFrame(user.getUser_id());
                depositFrame.setContentPane(depFrame.mainPanel);
                depositFrame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
                depositFrame.pack();
                depositFrame.setVisible(true);
                depositFrame.setLocationRelativeTo(null);
                depositFrame.addWindowListener(new java.awt.event.WindowAdapter() {
                    @Override
                    public void windowClosing(java.awt.event.WindowEvent windowEvent) {
                        try {
                            ps =conn.prepareStatement("SELECT SRODKI From KONTO where UZYTKOWNIK_ID=(?)");
                            ps.setInt(1,user.getUser_id());
                            ps.execute();
                            rs= ps.getResultSet();
                            rs.next();
                            user.setMoney(rs.getFloat(1));
                        } catch (SQLException e1) {
                            e1.printStackTrace();
                        }
                    }
                });
            }
        });
    }
}