package 畢業設計;

import java.awt.*;
import javax.swing.*;
import javax.swing.border.TitledBorder;
import java.awt.event.ComponentEvent;
import java.awt.event.ComponentAdapter;
import javax.swing.table.*;
import java.util.Vector;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;

public class dlgPublish extends JDialog {

    JTable tblDisplay = new JTable();
    JTextField txtPublish = new JTextField();
    JButton btnSearch = new JButton();
    JButton btnUpdate = new JButton();
    JButton btnDelete = new JButton();
    JButton btnExit = new JButton();
    JButton btnAdd = new JButton();
    DefaultTableModel dt;
    Vector vtColName = new Vector();
    Vector vt;
    JScrollPane jScrollPane1 = new JScrollPane();
    public dlgPublish() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        setSize(new Dimension(326, 471));
        this.setTitle("出版社維護");
        tblDisplay.setBounds(new Rectangle(20, 25, 274, 281));
        tblDisplay.addMouseListener(new dlgPublish_tblDisplay_mouseAdapter(this));
        btnSearch.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnUpdate.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnAdd.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnDelete.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnExit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnAdd.setBounds(new Rectangle(133, 368, 75, 27));
        btnAdd.setText("添加");
        btnAdd.addActionListener(new dlgPublish_btnAdd_actionAdapter(this));
        btnExit.setBounds(new Rectangle(224, 404, 75, 28));
        btnExit.setText("退出");
        btnExit.addActionListener(new dlgPublish_btnExit_actionAdapter(this));
        btnDelete.setBounds(new Rectangle(132, 405, 76, 28));
        btnDelete.setText("刪除");
        btnDelete.addActionListener(new dlgPublish_btnDelete_actionAdapter(this));
        btnUpdate.setBounds(new Rectangle(223, 367, 76, 28));
        btnUpdate.setText("更新");
        btnUpdate.addActionListener(new dlgPublish_btnUpdate_actionAdapter(this));
        btnSearch.setBounds(new Rectangle(19, 384, 97, 30));
        btnSearch.setText("模糊查詢");
        btnSearch.addActionListener(new dlgPublish_btnSearch_actionAdapter(this));
        jScrollPane1.setBounds(new Rectangle(15, 13, 293, 300));
        this.getContentPane().add(btnDelete);
        this.getContentPane().add(btnExit);
        this.getContentPane().add(txtPublish);
        this.getContentPane().add(btnAdd);
        this.getContentPane().add(btnSearch);
        this.getContentPane().add(btnUpdate);
        this.getContentPane().add(jScrollPane1);
        this.setResizable(false);
        jScrollPane1.getViewport().add(tblDisplay);
        txtPublish.setText("");
        txtPublish.setBounds(new Rectangle(14, 324, 290, 32));
        vtColName.add("編號");
        vtColName.add("出版社名");
        DisplayAllPublish();
//        tblDisplay.setAutoResizeMode(tblDisplay.AUTO_RESIZE_OFF);
        tblDisplay.getTableHeader().setReorderingAllowed(false);
    }

    public void DisplayAllPublish() {
        PublishConDB publishDB = new PublishConDB();
        vt = publishDB.SearchAll();
        publishDB.ClosePublishDB();
        dt = new DefaultTableModel(vt, vtColName);
        tblDisplay.setModel(dt);
    }

    public void ShowPublish() {
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension dlgSize = this.getSize();
        if (dlgSize.height > screenSize.height) {
            dlgSize.height = screenSize.height;
        }
        if (dlgSize.width > screenSize.width) {
            dlgSize.width = screenSize.width;
        }
        this.setLocation((screenSize.width - dlgSize.width) / 2,
                         (screenSize.height - dlgSize.height) / 2);
        this.setModal(true);
        this.setVisible(true);
    }

    public void btnExit_actionPerformed(ActionEvent e) {
        this.dispose();
    }

    public void btnSearch_actionPerformed(ActionEvent e) {
        PublishConDB publishDB = new PublishConDB();
        if (txtPublish.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "請輸入內容");
        } else {
            vt = publishDB.SearchPublish(txtPublish.getText());
            publishDB.ClosePublishDB();
            if (vt.size() < 1) {
                dt = new DefaultTableModel(vt, vtColName);
                tblDisplay.setModel(dt);
                JOptionPane.showMessageDialog(this, "找不到記錄!");
            } else {
                dt = new DefaultTableModel(vt, vtColName);
                tblDisplay.setModel(dt);
            }
        }
    }

    public void btnAdd_actionPerformed(ActionEvent e) {
        if (txtPublish.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "請輸入一個出版社名稱!");
        }
        else {
            PublishConDB publishDB = new PublishConDB();
            publishDB.AddPublish(txtPublish.getText());
            publishDB.ClosePublishDB();
            DisplayAllPublish();
            JOptionPane.showMessageDialog(this, "出版社添加成功!");
        }
    }

    public void btnUpdate_actionPerformed(ActionEvent e) {
        if (tblDisplay.getSelectedRow() < 0) {
            JOptionPane.showMessageDialog(this, "請選擇你要更新的出版社!");
        } else if (txtPublish.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "請輸入一個出版社名稱!");
        } else {
            int Id = Integer.parseInt(tblDisplay.getValueAt(tblDisplay.
                    getSelectedRow(), 0).toString());
            PublishConDB publishDB = new PublishConDB();
            boolean Success;
            Success = publishDB.UpdatePublish(Id, txtPublish.getText());
            if( !Success)
            {
                publishDB.ClosePublishDB();
                JOptionPane.showMessageDialog(this, "更新失敗!");
                return;
            }
            publishDB.ClosePublishDB();
            DisplayAllPublish();
            JOptionPane.showMessageDialog(this, "出版社更新成功!");
        }
    }

    public void btnDelete_actionPerformed(ActionEvent e) {
        if (tblDisplay.getSelectedRow() < 0) {
            JOptionPane.showMessageDialog(this, "請選擇你要刪除的出版社!");
        } else {
            int Id = Integer.parseInt(tblDisplay.getValueAt(tblDisplay.
                    getSelectedRow(), 0).toString());
            PublishConDB publishDB = new PublishConDB();
            publishDB.DeletePublish(Id);
            publishDB.ClosePublishDB();
            DisplayAllPublish();
            txtPublish.setText("");
            JOptionPane.showMessageDialog(this, "刪除成功!");
        }
    }

    public void tblDisplay_mouseClicked(MouseEvent e) {
        txtPublish.setText(tblDisplay.getValueAt(tblDisplay.getSelectedRow(), 1).
                           toString());
    }
}


class dlgPublish_btnDelete_actionAdapter implements ActionListener {
    private dlgPublish adaptee;
    dlgPublish_btnDelete_actionAdapter(dlgPublish adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnDelete_actionPerformed(e);
    }
}


class dlgPublish_btnUpdate_actionAdapter implements ActionListener {
    private dlgPublish adaptee;
    dlgPublish_btnUpdate_actionAdapter(dlgPublish adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnUpdate_actionPerformed(e);
    }
}


class dlgPublish_btnAdd_actionAdapter implements ActionListener {
    private dlgPublish adaptee;
    dlgPublish_btnAdd_actionAdapter(dlgPublish adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnAdd_actionPerformed(e);
    }
}


class dlgPublish_btnSearch_actionAdapter implements ActionListener {
    private dlgPublish adaptee;
    dlgPublish_btnSearch_actionAdapter(dlgPublish adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnSearch_actionPerformed(e);
    }
}


class dlgPublish_tblDisplay_mouseAdapter extends MouseAdapter {
    private dlgPublish adaptee;
    dlgPublish_tblDisplay_mouseAdapter(dlgPublish adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.tblDisplay_mouseClicked(e);
    }
}


class dlgPublish_btnExit_actionAdapter implements ActionListener {
    private dlgPublish adaptee;
    dlgPublish_btnExit_actionAdapter(dlgPublish adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnExit_actionPerformed(e);
    }
}