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

  public VipAdd() {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    this.getContentPane().setLayout(null);
    jButton1.setBounds(new Rectangle(60, 226, 91, 33));
    jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jButton1.setText("添加");
    jButton1.addActionListener(new VipAdd_jButton1_actionAdapter(this));
    lbladd.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
    lblid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblintegral.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblgrade.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblgrade.setText("會員等級:");
    lblgrade.setBounds(new Rectangle(60, 176, 99, 23));
    txtintegral.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtintegral.setText("");
    txtintegral.setBounds(new Rectangle(180, 130, 170, 29));
    txtintegral.addKeyListener(new VipAdd_txtintegral_keyAdapter(this));
    txtname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtname.setText("");
    txtname.setBounds(new Rectangle(180, 88, 170, 29));
    txtname.addKeyListener(new VipAdd_txtname_keyAdapter(this));
    txtid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtid.setText("");
    txtid.setBounds(new Rectangle(180, 44, 170, 29));
    txtid.addKeyListener(new VipAdd_txtid_keyAdapter(this));
    lblintegral.setText("會員積分:");
    lblintegral.setBounds(new Rectangle(60, 133, 99, 23));
    jLabel3.setText("會員姓名:");
    jLabel3.setBounds(new Rectangle(60, 91, 99, 23));
    lblid.setText("會員卡號:");
    lblid.setBounds(new Rectangle(60, 49, 99, 23));
    lbladd.setText("會   員   添   加");
    lbladd.setBounds(new Rectangle(140, 7, 171, 23));
    jButton2.addActionListener(new VipAdd_jButton2_actionAdapter(this));
    this.getContentPane().setBackground(new Color(212, 208, 200));
    this.setForeground(Color.black);
    this.setTitle("會員添加");
    jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    cmbgrade.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    cmbgrade.setBounds(new Rectangle(179, 169, 171, 30));
    cmbgrade.addKeyListener(new VipAdd_cmbgrade_keyAdapter(this));
    cmbgrade.addItem("高級會員");
    cmbgrade.addItem("普通會員");
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setBounds(new Rectangle(1, 32, 391, 264));
    jPanel1.setLayout(null);
    jPanel2.setBorder(BorderFactory.createEtchedBorder());
    jPanel2.setBounds(new Rectangle(1, 0, 391, 32));
    jPanel2.setLayout(null);
    jPanel3.setBorder(BorderFactory.createEtchedBorder());
    jPanel3.setBounds(new Rectangle(0, 189, 391, 49));
    jPanel3.setLayout(null);
    this.getContentPane().add(txtintegral);
    this.getContentPane().add(lbladd);
    this.getContentPane().add(txtname);
    this.getContentPane().add(jLabel3);
    this.getContentPane().add(lblintegral);
    this.getContentPane().add(lblgrade);
    this.getContentPane().add(jButton2);
    this.getContentPane().add(txtid);
    this.getContentPane().add(lblid);
    this.getContentPane().add(jButton1);
    this.getContentPane().add(cmbgrade);
    this.getContentPane().add(jPanel1);
    jPanel1.add(jPanel3);
    this.getContentPane().add(jPanel2);
    this.setModal(true);
    jButton2.setBounds(new Rectangle(259, 226, 91, 33));
    jButton2.setText("返回");

  }

  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JLabel lbladd = new JLabel();
  JLabel lblid = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel lblintegral = new JLabel();
  JTextField txtid = new JTextField();
  JTextField txtname = new JTextField();
  JTextField txtintegral = new JTextField();
  JLabel lblgrade = new JLabel();
  JComboBox cmbgrade = new JComboBox();
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  JPanel jPanel3 = new JPanel();
  public void jButton1_actionPerformed(ActionEvent e) {
    String id = txtid.getText().trim();
    String name = txtname.getText().trim();
    String integral = txtintegral.getText().trim();
    String grade= cmbgrade.getSelectedItem().toString();
    if (id.equals("") || name.equals("")) {
      JOptionPane.showMessageDialog(null, "請輸入完整的信息", "提示",
                                    JOptionPane.INFORMATION_MESSAGE);
      return;
    }
    int i=1;
    if(grade.equals("高級會員")){
    i=2;
  }
  Link lk = new Link();
    lk.connection();
     String sql="select cardid from vip where cardid='"+id+"'";
     ResultSet rt=lk.Select(sql);//查詢是否存在的會員卡號
    try {
      if (rt.next()) {
        JOptionPane.showMessageDialog(null, "會員卡號已經存在", "錯誤",
                                    JOptionPane.ERROR_MESSAGE);
      rt.close();
      lk.close();
      return;
      }
    }
    catch (SQLException ex) {
    }

   sql = "insert into vip values('"+id+"','"+name+"',"+integral+","+i+")";
   int rs=lk.Update(sql);
   if(rs>0){
     txtid.setText("");
     txtname.setText("");
     txtintegral.setText("");
      JOptionPane.showMessageDialog(null,"會員添加成功");

   }
    lk.close();
  }

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

  public void txtid_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 txtintegral_keyPressed(KeyEvent e) {
    if((int)e.getKeyChar()==10){
      jButton1_actionPerformed(null);
}
  }

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

class VipAdd_jButton2_actionAdapter
    implements ActionListener {
  private VipAdd adaptee;
  VipAdd_jButton2_actionAdapter(VipAdd adaptee) {
    this.adaptee = adaptee;
  }

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

class VipAdd_jButton1_actionAdapter
    implements ActionListener {
  private VipAdd adaptee;
  VipAdd_jButton1_actionAdapter(VipAdd adaptee) {
    this.adaptee = adaptee;
  }

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

class VipAdd_txtid_keyAdapter
    extends KeyAdapter {
  private VipAdd adaptee;
  VipAdd_txtid_keyAdapter(VipAdd adaptee) {
    this.adaptee = adaptee;
  }

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

class VipAdd_txtname_keyAdapter
    extends KeyAdapter {
  private VipAdd adaptee;
  VipAdd_txtname_keyAdapter(VipAdd adaptee) {
    this.adaptee = adaptee;
  }

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

class VipAdd_txtintegral_keyAdapter
    extends KeyAdapter {
  private VipAdd adaptee;
  VipAdd_txtintegral_keyAdapter(VipAdd adaptee) {
    this.adaptee = adaptee;
  }

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

class VipAdd_cmbgrade_keyAdapter
    extends KeyAdapter {
  private VipAdd adaptee;
  VipAdd_cmbgrade_keyAdapter(VipAdd adaptee) {
    this.adaptee = adaptee;
  }

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