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 dlgSort extends JDialog {

    JTable tblDisplay = new JTable();
    JTextField txtSort = 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 dlgSort() {
        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 dlgSort_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 dlgSort_btnAdd_actionAdapter(this));
        btnExit.setBounds(new Rectangle(224, 404, 75, 28));
        btnExit.setText("退出");
        btnExit.addActionListener(new dlgSort_btnExit_actionAdapter(this));
        btnDelete.setBounds(new Rectangle(132, 405, 76, 28));
        btnDelete.setText("刪除");
        btnDelete.addActionListener(new dlgSort_btnDelete_actionAdapter(this));
        btnUpdate.setBounds(new Rectangle(223, 367, 76, 28));
        btnUpdate.setText("更新");
        btnUpdate.addActionListener(new dlgSort_btnUpdate_actionAdapter(this));
        btnSearch.setBounds(new Rectangle(19, 384, 97, 30));
        btnSearch.setText("模糊查詢");
        btnSearch.addActionListener(new dlgSort_btnSearch_actionAdapter(this));
        jScrollPane1.setBounds(new Rectangle(15, 13, 293, 300));
        this.getContentPane().add(btnDelete);
        this.getContentPane().add(btnExit);
        this.getContentPane().add(txtSort);
        this.getContentPane().add(btnAdd);
        this.getContentPane().add(btnSearch);
        this.getContentPane().add(btnUpdate);
        this.getContentPane().add(jScrollPane1);
        this.setResizable(false);
        jScrollPane1.getViewport().add(tblDisplay);
        txtSort.setText("");
        txtSort.setBounds(new Rectangle(14, 324, 290, 32));
        vtColName.add("編號");
        vtColName.add("圖書類別");
        DisplayAllSort();
        //  tblDisplay.setAutoResizeMode(tblDisplay.AUTO_RESIZE_OFF);
        tblDisplay.getTableHeader().setReorderingAllowed(false);
    }

    //****************************顯示所有圖書類別**********************************
     public void DisplayAllSort() {
         SortConDB SortDB = new SortConDB();
         vt = SortDB.SearchAll();
         SortDB.CloseSortDB();
         dt = new DefaultTableModel(vt, vtColName);
         tblDisplay.setModel(dt);
     }

     //***************************查詢同名圖書類別***********************************
     public boolean SearchSortName()
     {
         boolean SameName = false;
         Vector tempvt = new Vector();
         SortConDB sortDB = new SortConDB();
         tempvt = sortDB.SearchAll();
         sortDB.CloseSortDB();
         for (int i = 0; i < tempvt.size(); i++) {
             if (((Vector) (tempvt.get(i))).get(1).toString().equals(txtSort.
                     getText())) {
                 SameName = true;
             }
         }
         return SameName;
     }
    //***************************顯示窗口***********************************
     public void ShowSort() {
         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) {
         SortConDB SortDB = new SortConDB();
         if (txtSort.getText().equals("")) {
             JOptionPane.showMessageDialog(this, "請輸入內容");
         } else {
             vt = SortDB.SearchSort(txtSort.getText());
             SortDB.CloseSortDB();
             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 (txtSort.getText().equals(""))
             JOptionPane.showMessageDialog(this, "請輸入一個出版社名稱!");
         else {
             boolean SameName = SearchSortName();
             if(SameName) {
                 JOptionPane.showMessageDialog(this, "存在同名的圖書類別!");
                 return;
             }
             SortConDB SortDB = new SortConDB();
             boolean Success;
             Success = SortDB.AddSort(txtSort.getText());
             if (!Success) {
                 SortDB.CloseSortDB();
                 JOptionPane.showMessageDialog(this, "添加失敗!");
                 return;
             }
             SortDB.CloseSortDB();
             DisplayAllSort();
             JOptionPane.showMessageDialog(this, "出版社添加成功!");
         }
     }

    //******************************更新按鈕事件********************************
     public void btnUpdate_actionPerformed(ActionEvent e) {
         if (tblDisplay.getSelectedRow() < 0) {
             JOptionPane.showMessageDialog(this, "請選擇你要更新的出版社!");
         } else if (txtSort.getText().equals("")) {
             JOptionPane.showMessageDialog(this, "請輸入一個出版社名稱!");
         } else {
             boolean SameName = SearchSortName();
             if(SameName) {
                 JOptionPane.showMessageDialog(this, "存在同名的圖書類別!");
                 return;
             }
             int Id = Integer.parseInt(tblDisplay.getValueAt(tblDisplay.
                     getSelectedRow(), 0).toString());
             SortConDB SortDB = new SortConDB();
             boolean Success;
             Success = SortDB.UpdateSort(Id, txtSort.getText());
             if (!Success) {
                 SortDB.CloseSortDB();
                 JOptionPane.showMessageDialog(this, "更新失敗!");
                 return;
             }
             SortDB.CloseSortDB();
             DisplayAllSort();
             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());
             SortConDB SortDB = new SortConDB();
             SortDB.DeleteSort(Id);
             SortDB.CloseSortDB();
             DisplayAllSort();
             txtSort.setText("");
             JOptionPane.showMessageDialog(this, "刪除成功!");
         }
     }

    //********************************鼠標點擊表格事件******************************
     public void tblDisplay_mouseClicked(MouseEvent e) {
         txtSort.setText(tblDisplay.getValueAt(tblDisplay.getSelectedRow(), 1).
                         toString());
     }
}


class dlgSort_btnDelete_actionAdapter implements ActionListener {
    private dlgSort adaptee;
    dlgSort_btnDelete_actionAdapter(dlgSort adaptee) {
        this.adaptee = adaptee;
    }

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


class dlgSort_btnUpdate_actionAdapter implements ActionListener {
    private dlgSort adaptee;
    dlgSort_btnUpdate_actionAdapter(dlgSort adaptee) {
        this.adaptee = adaptee;
    }

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


class dlgSort_btnAdd_actionAdapter implements ActionListener {
    private dlgSort adaptee;
    dlgSort_btnAdd_actionAdapter(dlgSort adaptee) {
        this.adaptee = adaptee;
    }

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


class dlgSort_btnSearch_actionAdapter implements ActionListener {
    private dlgSort adaptee;
    dlgSort_btnSearch_actionAdapter(dlgSort adaptee) {
        this.adaptee = adaptee;
    }

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


class dlgSort_tblDisplay_mouseAdapter extends MouseAdapter {
    private dlgSort adaptee;
    dlgSort_tblDisplay_mouseAdapter(dlgSort adaptee) {
        this.adaptee = adaptee;
    }

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


class dlgSort_btnExit_actionAdapter implements ActionListener {
    private dlgSort adaptee;
    dlgSort_btnExit_actionAdapter(dlgSort adaptee) {
        this.adaptee = adaptee;
    }

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