package secure;

        import java.sql.Connection;
        import java.sql.Date;
        ;
        import java.sql.DriverManager;
        import java.sql.PreparedStatement;
        import java.text.DateFormat;
        import java.text.Format;
        import java.text.SimpleDateFormat;
        import javax.swing.JOptionPane;
        import java.util.Calendar;
        import java.util.GregorianCalendar;
        import javax.swing.JFormattedTextField;





        public class telecaller extends javax.swing.JFrame {
             DateFormat df=new SimpleDateFormat("yyyy-MM-dd");

            public telecaller() {


                initComponents();

                currentdate();
                /*float minutes = 100.5f;
                Calendar c = Calendar.getInstance();
        c.set(Calendar.HOUR_OF_DAY, 0);
        c.set(Calendar.MINUTE, 0);
        c.set(Calendar.SECOND, 0);

        c.add(Calendar.MINUTE, (int) minutes);
        c.add(Calendar.SECOND, (int) ((minutes % (int) minutes) * 60));
        final Date date = (Date) c.getTime();

                 Format timeFormat=new SimpleDateFormat("HH:mm:ss");
                 JFormattedTextField t2=new JFormattedTextField(timeFormat);
             t2.setValue(date);*/
            }

            public void currentdate(){
            Calendar cal=new GregorianCalendar();
            int month=cal.get(Calendar.MONTH);
            int year=cal.get(Calendar.YEAR);
            int day=cal.get(Calendar.DAY_OF_MONTH);
            jLabel19.setText(year+"/"+(month+1)+"/"+day);

            int second=cal.get(Calendar.SECOND);
            int minute=cal.get(Calendar.MINUTE);
            int hour=cal.get(Calendar.HOUR);
            jLabel20.setText(hour+":"+(minute)+":"+second);
            }


            private void initComponents() {

private void jLabel2MouseClicked(java.awt.event.MouseEvent evt) {
                callerhome cm=new callerhome();
                cm.setVisible(true);
                this.setVisible(false);
            }




  this is also a label that if clicked takes us to another frame




            private void jLabel3MouseClicked(java.awt.event.MouseEvent evt) {
                telecaller tc=new telecaller();
                tc.setVisible(true);
                this.setVisible(false);
            }

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {






              Connection conn=null;
               PreparedStatement ps=null;
               try{
                   Class.forName("com.mysql.jdbc.Driver");
                   conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/customer","root","OD@2014");
                   ps=conn.prepareStatement("insert into customer (cname,bname,mobile,contact,email,website,btype,address,meetingdate) values(?,?,?,?,?,?,?,?,?)");
                   ps.setString(1, jTextField1.getText());
                   ps.setString(2, jTextField2.getText());
                   ps.setString(3, jTextField3.getText());
                   ps.setString(4, jTextField4.getText());
                   ps.setString(5, jTextField5.getText());
                   ps.setString(6, jTextField6.getText());
                   ps.setString(7, jTextField7.getText());
                   ps.setString(8, jTextField8.getText());
                   ps.setString(9, jTextField9.getDateFormatString());
                   /*ps.setString(9, jTextField9.getText());
                   ps.setString(10, jTextField10.getText());
                   ps.setString(9, soff);
                   ps.setString(10, progress);*/








                   ps.execute();
                   JOptionPane.showMessageDialog(null, "DATA IS SAVED");
                    int p=JOptionPane.showConfirmDialog(null,"DO YOU WANT TO VIEW YOUR DATA","SUBMIT",JOptionPane.YES_NO_OPTION);
                if(p==0){




                   customerview cv=new customerview();
                   customerview.cv1.setText(this.jTextField1.getText());
                   customerview.cv2.setText(this.jTextField2.getText());
                   customerview.cv3.setText(this.jTextField3.getText());
                   customerview.cv4.setText(this.jTextField4.getText());
                   customerview.cv5.setText(this.jTextField5.getText());
                   customerview.cv6.setText(this.jTextField6.getText());
                   customerview.cv7.setText(this.jTextField7.getText());
                   customerview.cv8.setText(this.jTextField8.getText());
                   /* customerview.cv9.setText(df.format(this.jTextField9.getDate())); */
                  /*   customerview.cv10.setText(this.jTextField10.getText()); */
                   cv.setVisible(true);


                 }else{
                    callerhome ch=new callerhome();
                    ch.setVisible(true);
                    this.setVisible(false);





               }


               }catch(Exception e){
                   JOptionPane.showMessageDialog(null, e);



               }




















            }

            private void jLabel18MouseClicked(java.awt.event.MouseEvent evt) {
               int p=JOptionPane.showConfirmDialog(null,"ARE YOU SURE YOU WANT TO LOGOUT","LOGOUT",JOptionPane.YES_NO_OPTION);
                if(p==0){

                login l=new login();
                l.setVisible(true);
                this.setVisible(false);
            }
        }