package supermarket;

import DB.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyEvent;
import java.awt.event.KeyAdapter;
import java.sql.ResultSet;
import java.sql.*;

public class UserAdd
    extends JDialog {
  public UserAdd() {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    lbltitle.setFont(new java.awt.Font("Dialog", Font.PLAIN, 25));
    lbltitle.setText("添   加   用   戶");
    lbltitle.setBounds(new Rectangle(102, 11, 197, 43));
    this.getContentPane().setLayout(null);
    txtpsw.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtpsw.setText("");
    txtpsw.setBounds(new Rectangle(167, 117, 194, 22));
    txtpsw.addKeyListener(new UserAdd_txtpsw_keyAdapter(this));
    jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jButton1.addActionListener(new UserAdd_jButton1_actionAdapter(this));
    cmbpurview.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblpurview.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblpsw.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jPanel2.setBorder(BorderFactory.createEtchedBorder());
    jPanel2.setBounds(new Rectangle(19, 12, 362, 40));
    jPanel2.setLayout(null);
    txtname.setText("");
    txtname.setBounds(new Rectangle(167, 76, 194, 22));
    txtname.addKeyListener(new UserAdd_txtname_keyAdapter(this));
    lblpurview.setText("權       限:");
    lblpurview.setBounds(new Rectangle(66, 200, 89, 23));
    cmbpurview.setBounds(new Rectangle(167, 197, 132, 29));
    cmbpurview.addKeyListener(new UserAdd_cmbpurview_keyAdapter(this));
    lblpsw.setText("密       碼:");
    lblpsw.setBounds(new Rectangle(66, 117, 89, 22));
    lblname.setText("用  戶  名:");
    lblname.setBounds(new Rectangle(66, 76, 89, 22));
    jButton2.setBounds(new Rectangle(208, 256, 91, 33));
    jButton2.setText("取消");
    jButton2.addActionListener(new UserAdd_jButton2_actionAdapter(this));
    cmbpurview.addItem("系統管理員");
    cmbpurview.addItem("倉庫管理員");
    cmbpurview.addItem("收銀員");
    lblpsw2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblpsw2.setText("確認密碼:");
    lblpsw2.setBounds(new Rectangle(66, 158, 89, 23));
    txtpsw2.setText("");
    txtpsw2.setBounds(new Rectangle(167, 158, 194, 22));
    txtpsw2.addKeyListener(new UserAdd_txtpsw2_keyAdapter(this));
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setBounds(new Rectangle(19, 50, 362, 246));
    jPanel1.setLayout(null);
    jLabel1.setForeground(Color.red);
    jLabel1.setText("*");
    jLabel1.setBounds(new Rectangle(346, 25, 22, 23));
    jLabel2.setForeground(Color.red);
    jLabel2.setText("*");
    jLabel2.setBounds(new Rectangle(346, 65, 22, 23));
    jLabel3.setForeground(Color.red);
    jLabel3.setText("*");
    jLabel3.setBounds(new Rectangle(345, 109, 26, 23));
    jLabel4.setForeground(Color.red);
    jLabel4.setText("*");
    jLabel4.setBounds(new Rectangle(285, 152, 51, 23));
    this.getContentPane().add(txtname);
    this.getContentPane().add(lblname);
    this.getContentPane().add(lbltitle, null);
    this.getContentPane().add(jPanel2);
    this.getContentPane().add(jButton1);
    this.getContentPane().add(lblpurview);
    this.getContentPane().add(cmbpurview);
    this.getContentPane().add(lblpsw2);
    this.getContentPane().add(jButton2);
    this.getContentPane().add(txtpsw);
    this.getContentPane().add(lblpsw);
    this.getContentPane().add(txtpsw2);
    this.getContentPane().add(jPanel1);
    jPanel1.add(jLabel1);
    jPanel1.add(jLabel3);
    jPanel1.add(jLabel2);
    jPanel1.add(jLabel4);
    this.setModal(true);
    jButton1.setBounds(new Rectangle(66, 254, 91, 33));
    jButton1.setText("提交");
  }

  JLabel lbltitle = new JLabel();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JLabel lblname = new JLabel();
  JLabel lblpsw = new JLabel();
  JComboBox cmbpurview = new JComboBox();
  JLabel lblpurview = new JLabel();
  JTextField txtname = new JTextField();
  JPasswordField txtpsw = new JPasswordField();
  JPanel jPanel2 = new JPanel();
  JLabel lblpsw2 = new JLabel();
  JPasswordField txtpsw2 = new JPasswordField();
  JPanel jPanel1 = new JPanel();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  public void jButton2_actionPerformed(ActionEvent e) {
    this.dispose();
  }

  public void jButton1_actionPerformed(ActionEvent e) {
    String name = txtname.getText().trim(); //存用戶名
    String psw = String.valueOf(txtpsw.getPassword()); //存密碼;
    String psw2 = String.valueOf(txtpsw2.getPassword());
    String purview = cmbpurview.getSelectedItem().toString();
    if (name.equals("") || psw.equals("")) {
      JOptionPane.showMessageDialog(null, "請完整填寫信息", "提示",
                                    JOptionPane.INFORMATION_MESSAGE);
      return;
    }
    if (!psw.equals(psw2)) {
      JOptionPane.showMessageDialog(null, "兩次密碼不符,請驗證", "提示",
                                    JOptionPane.INFORMATION_MESSAGE);
      return;

    }
    String sql = "";
    Link lk = new Link();
    lk.connection();
    sql = "select username from usertitle where username='" + name + "'";
    ResultSet rs = lk.Select(sql);
    try {
      if (rs.next()) {
        JOptionPane.showMessageDialog(null, "用戶名已存在", "提示",
                                      JOptionPane.INFORMATION_MESSAGE);
        rs.close();
        lk.close();
        return;
      }
    }
    catch (SQLException ex) {
    }
    if (purview.equals("系統管理員")) {
      sql = "insert into usertitle values('" + name + "','" + psw + "'," + 3 +
          ")";
    }
    if (purview.equals("倉庫管理員")) {
      sql = "insert into usertitle values('" + name + "','" + psw + "'," + 2 +
          ")";
    }
    if (purview.equals("收銀員")) {
      sql = "insert into usertitle values('" + name + "','" + psw + "'," + 1 +
          ")";
    }
    int rt = lk.Update(sql);
    if (rt > 0) {
      JOptionPane.showMessageDialog(null, "添加成功");
      txtname.setText("");
      txtpsw.setText("");
      txtpsw2.setText("");
    }
    lk.close();
  }

  public void txtpsw2_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      jButton1_actionPerformed(null);
    }
  }

  public void txtpsw_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      jButton1_actionPerformed(null);
    }
  }

  public void txtname_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      jButton1_actionPerformed(null);
    }
  }

  public void cmbpurview_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      jButton1_actionPerformed(null);
    }
  }
}

class UserAdd_txtname_keyAdapter
    extends KeyAdapter {
  private UserAdd adaptee;
  UserAdd_txtname_keyAdapter(UserAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtname_keyPressed(e);
  }
}

class UserAdd_cmbpurview_keyAdapter
    extends KeyAdapter {
  private UserAdd adaptee;
  UserAdd_cmbpurview_keyAdapter(UserAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.cmbpurview_keyPressed(e);
  }
}

class UserAdd_txtpsw_keyAdapter
    extends KeyAdapter {
  private UserAdd adaptee;
  UserAdd_txtpsw_keyAdapter(UserAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtpsw_keyPressed(e);
  }
}

class UserAdd_txtpsw2_keyAdapter
    extends KeyAdapter {
  private UserAdd adaptee;
  UserAdd_txtpsw2_keyAdapter(UserAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {

    adaptee.txtpsw2_keyPressed(e);
  }
}

class UserAdd_jButton1_actionAdapter
    implements ActionListener {
  private UserAdd adaptee;
  UserAdd_jButton1_actionAdapter(UserAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {

    adaptee.jButton1_actionPerformed(e);
  }
}

class UserAdd_jButton2_actionAdapter
    implements ActionListener {
  private UserAdd adaptee;
  UserAdd_jButton2_actionAdapter(UserAdd adaptee) {
    this.adaptee = adaptee;
  }

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