package supermarket;
import DB.*;
import javax.swing.*;
import java.awt.CardLayout;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Vector;
import java.awt.event.KeyEvent;
import java.awt.event.KeyAdapter;

public class VipUpdate
    extends JDialog {
//VipFrm vf;
  public VipUpdate(Vector vt, int i) {
  //  this.vf=vf;,VipFrm vf
    try {
      jbInit();
      Vector v = (Vector) vt.get(i); //動態數組
      txtid.setText(v.get(0).toString()); //存會員卡號
      txtname.setText(v.get(1).toString()); //會員的名字
      txtintegral.setText(v.get(2).toString()); //會員的積分
      cmbgrade.setSelectedItem(v.get(3)); //會員等級
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    this.getContentPane().setLayout(null);
    lbltitle.setFont(new java.awt.Font("Dialog", Font.PLAIN, 25));
    lbltitle.setText("會   員   修   改");
    lbltitle.setBounds(new Rectangle(113, 7, 185, 38));
    txtid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtid.setEditable(false);
    lblid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblname.setToolTipText("");
    lblintegral.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtintegral.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtintegral.setEditable(true);
    lblgrade.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    cmbgrade.setEnabled(true);
    cmbgrade.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    cmbgrade.setEditable(false);
    cmbgrade.setBounds(new Rectangle(187, 198, 152, 29));
    cmbgrade.addKeyListener(new VipUpdate_cmbgrade_keyAdapter(this));
    cmbgrade.addItem("高級會員");
    cmbgrade.addItem("普通會員");
    txtintegral.setText("");
    txtintegral.setBounds(new Rectangle(187, 154, 152, 29));
    txtname.setText("");
    txtname.setBounds(new Rectangle(187, 108, 152, 29));
    txtname.addKeyListener(new VipUpdate_txtname_keyAdapter(this));
    txtid.setText("");
    txtid.setBounds(new Rectangle(187, 63, 152, 29));
    btnfanhui.setBounds(new Rectangle(248, 239, 91, 33));
    btnfanhui.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btnfanhui.setText("返回");
    btnfanhui.addActionListener(new VipUpdate_jButton2_actionAdapter(this));
    jButton1.setBounds(new Rectangle(70, 239, 91, 33));
    jButton1.setText("修改");
    jButton1.addActionListener(new VipUpdate_jButton1_actionAdapter(this));
    lblgrade.setText("會員等級:");
    lblgrade.setBounds(new Rectangle(67, 199, 96, 23));
    lblintegral.setText("會員積分:");
    lblintegral.setBounds(new Rectangle(67, 155, 96, 23));
    lblname.setText("會員姓名:");
    lblname.setBounds(new Rectangle(67, 110, 96, 23));
    this.getContentPane().setBackground(new Color(212, 208, 200));
    this.setTitle("會員修改");
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setBounds(new Rectangle(12, 5, 375, 54));
    jPanel1.setLayout(null);
    jPanel2.setBorder(BorderFactory.createEtchedBorder());
    jPanel2.setBounds(new Rectangle(12, 57, 375, 180));
    jPanel2.setLayout(null);
    jPanel3.setBorder(BorderFactory.createEtchedBorder());
    jPanel3.setBounds(new Rectangle(12, 233, 375, 52));
    jPanel3.setLayout(null);
    this.getContentPane().add(lblname);
    this.getContentPane().add(lblintegral);
    this.getContentPane().add(lblgrade);
    this.getContentPane().add(txtname);
    this.getContentPane().add(txtintegral);
    this.getContentPane().add(jButton1);
    this.getContentPane().add(btnfanhui);
    this.getContentPane().add(cmbgrade);
    this.getContentPane().add(txtid);
    this.getContentPane().add(lblid);
    this.getContentPane().add(jPanel1);
    jPanel1.add(lbltitle);
    this.getContentPane().add(jPanel2);
    this.getContentPane().add(jPanel3);
    this.setModal(true);
    lblid.setText("會員卡號:");
    lblid.setBounds(new Rectangle(67, 66, 96, 23));
  }

  JLabel lbltitle = new JLabel();
  JLabel lblid = new JLabel();
  JLabel lblname = new JLabel();
  JLabel lblintegral = new JLabel();
  JLabel lblgrade = new JLabel();
  JButton jButton1 = new JButton();
  JButton btnfanhui = new JButton();
  JTextField txtid = new JTextField();
  JTextField txtname = new JTextField();
  JTextField txtintegral = new JTextField();
  JComboBox cmbgrade = new JComboBox();
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  JPanel jPanel3 = new JPanel();
  public void jButton2_actionPerformed(ActionEvent e) {
    this.dispose();
  }

  public void jButton1_actionPerformed(ActionEvent e) {
    if (txtname.getText().trim().equals("")) { //驗證會員名是否為空
      JOptionPane.showMessageDialog(null, "會員名不能為空!", "錯誤",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }
    String grade = cmbgrade.getSelectedItem().toString(); //取到下拉框的值
    int i = 1;
    if (grade.equals("高級會員")) {
      i = 2;
    }
    String sql = "update vip set grade =" + i + ",VIPname='" +
        txtname.getText().trim() + "',integral=" + txtintegral.getText().trim() +
        " where cardid='" + txtid.getText() + "'";//修改會員信息
    Link lk = new Link();
    lk.connection();
    int count = lk.Update(sql);
    if (count > 0) { //成功
      JOptionPane.showMessageDialog(null, "更新成功!", "成功",
                                    JOptionPane.INFORMATION_MESSAGE);
      this.dispose();
     // vf.gengxin();
     // vf.tablehuiyuan.updateUI();
    }
    else { //錯誤
      JOptionPane.showMessageDialog(null, "更新失敗,請核實后再操作!", "錯誤",
                                    JOptionPane.ERROR_MESSAGE);
      lk.close();
      return;
    }
    lk.close();
  }

  public void txtname_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 VipUpdate_jButton1_actionAdapter
    implements ActionListener {
  private VipUpdate adaptee;
  VipUpdate_jButton1_actionAdapter(VipUpdate adaptee) {
    this.adaptee = adaptee;
  }

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

class VipUpdate_txtname_keyAdapter
    extends KeyAdapter {
  private VipUpdate adaptee;
  VipUpdate_txtname_keyAdapter(VipUpdate adaptee) {
    this.adaptee = adaptee;
  }

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

class VipUpdate_cmbgrade_keyAdapter
    extends KeyAdapter {
  private VipUpdate adaptee;
  VipUpdate_cmbgrade_keyAdapter(VipUpdate adaptee) {
    this.adaptee = adaptee;
  }

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

class VipUpdate_jButton2_actionAdapter
    implements ActionListener {
  private VipUpdate adaptee;
  VipUpdate_jButton2_actionAdapter(VipUpdate adaptee) {
    this.adaptee = adaptee;
  }

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