package stumng;

import javax.swing.*;
import javax.swing.JOptionPane;
import java.awt.*;
import com.borland.jbcl.layout.*;
import java.awt.event.*;

public class delStuInf extends JFrame {
  DBConnManager dbconnmanager = new DBConnManager();
  XYLayout xYLayout1 = new XYLayout();
  JLabel jLabel1 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JLabel jLabel3 = new JLabel();
  JTextField jTextField3 = new JTextField();
  JLabel jLabel5 = new JLabel();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JComboBox jComboBox2 = new JComboBox();

  int astu_id; //學號
  String userid; //接收界面傳人的學號
  String aname; //姓名
  String aclass; //班級
  private boolean flag = false;
  private int opt = 0;

  public delStuInf() {
    try {
      jbInit();
      //設置frame的大小
      this.setSize(600, 400);
      //得到當前屏幕大小
      Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
      //得到frame的大小
      Dimension frameSize = this.getSize();
      if (frameSize.height > screenSize.height) {
        frameSize.height = screenSize.height;
      }
      if (frameSize.width > screenSize.width) {
        frameSize.width = screenSize.width;
      }
      this.setTitle("刪除學生信息");
      //設置frame在屏幕上顯示的位置
      this.setLocation( (screenSize.width - frameSize.width) / 2,
                       (screenSize.height - frameSize.height) / 2);
      this.setResizable(false);
      //添加響應事件
      jButton1.addActionListener(new ActionListener()
     {
       public void actionPerformed( ActionEvent event )
      {
        boolean flag;
        userid = jTextField3.getText().trim();
        aname =  jTextField1.getText().trim();
        flag = dbconnmanager.checkStuid(userid);
        if(userid.equals(""))
        {
          JOptionPane.showMessageDialog(null, "請輸入學號為不能為空");
        }
        else if( flag == false )
        {
           JOptionPane.showMessageDialog(null, "學號只能是0－9數字");
        }
        else if(aname.equals(""))
        {
          JOptionPane.showMessageDialog(null, "姓名不能為空");
        }
        else
        {
          JOptionPane pane = new JOptionPane("將刪出該學生的基本信息及成績信息，繼續嗎?");
          JDialog dialog = pane.createDialog(null,"刪除學生基本信息");
          pane.setOptionType(pane.YES_NO_OPTION);
          dialog.show();
          Object selectedvalue = pane.getValue();
          if( pane.YES_OPTION == 0)
          {
            astu_id = Integer.parseInt(userid);
            aclass = (String) jComboBox2.getSelectedItem();
            //檢查該學生在此班是否存在
            flag = dbconnmanager.userExist(astu_id, aclass);
            if (flag == false) {
              JOptionPane.showMessageDialog(null, "該班不存在該學生");
            }
            else {
              flag = addstuinf();
              if (flag == true) {
                JOptionPane.showMessageDialog(null, "刪除成功");
              }
              else {
                JOptionPane.showMessageDialog(null, "刪除失敗");
              }
            }
          }
        }
      }
    }
     );

     //退出frame
     jButton2.addActionListener(new java.awt.event.ActionListener()
    {
      public void actionPerformed(ActionEvent e)
      {
        jButton2_actionPerformed(e);
      }
    });
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  void jbInit() throws Exception {
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel1.setText("姓名");
    this.getContentPane().setLayout(xYLayout1);
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel3.setText("學號");
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel5.setText("班級");
    jButton1.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton1.setText("刪除");
    xYLayout1.setWidth(524);
    xYLayout1.setHeight(375);
    jTextField1.setText("");
    jTextField1.setFont(new java.awt.Font("Dialog", 0, 13));
    jTextField3.setEnabled(true);
    jTextField3.setFont(new java.awt.Font("Dialog", 0, 13));
    jTextField3.setMinimumSize(new Dimension(11, 21));
    jTextField3.setToolTipText("");
    jTextField3.setText("");
    jButton2.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton2.setText("退出");
    jComboBox2.addItem("A2241");
    jComboBox2.addItem("A2242");
    jComboBox2.addItem("A2243");
    jComboBox2.setFont(new java.awt.Font("Dialog", 0, 13));
    this.getContentPane().add(jButton1, new XYConstraints(172, 261, 69, 30));
    this.getContentPane().add(jTextField1, new XYConstraints(223, 51, 125, 32));
    this.getContentPane().add(jLabel1, new XYConstraints(130, 48, 55, 38));
    this.getContentPane().add(jLabel3, new XYConstraints(126, 108, 39, 38));
    this.getContentPane().add(jLabel5, new XYConstraints(127, 180, 38, 32));
    this.getContentPane().add(jButton2, new XYConstraints(299, 259, 74, 31));
    this.getContentPane().add(jComboBox2, new XYConstraints(221, 178, 127, 30));
    this.getContentPane().add(jTextField3,  new XYConstraints(221, 113, 128, 31));
  }

  //刪除學生基本信息 包括其成績的記錄 flag = true 則成功
  private boolean addstuinf()
  {
    boolean flag;
    aclass = (String)jComboBox2.getSelectedItem();
    flag = dbconnmanager.removeUser(astu_id, aname, aclass);
    return flag;
  }
  void jButton2_actionPerformed(ActionEvent e)
  {
    this.dispose();
    dbconnmanager.closeConns();
  }

}