private void btnAddProject1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnAddProject1ActionPerformed

        // TODO add your handling code here:
        
        // clear fields
        
        this.txtItem11.setText("");
        this.txtItem12.setText("");
        this.txtItem13.setText("");
        this.txtItem14.setText("");
        this.txtItem15.setText("");
        this.txtItem16.setText("");
        this.txtItem17.setText("");
        this.txtItem18.setText("");
        this.txtItem19.setText("");
        this.txtItem20.setText("");
        
        this.txtQ12.setText("");
        this.txtQ13.setText("");
        this.txtQ14.setText("");
        this.txtQ15.setText("");
        this.txtQ16.setText("");
        this.txtQ17.setText("");
        this.txtQ18.setText("");
        this.txtQ19.setText("");
        this.txtQ20.setText("");
        this.txtQ11.setText("");
        
   

        
        this.date11.setCalendar(null);
        this.date12.setCalendar(null);
        this.date13.setCalendar(null);
        this.date14.setCalendar(null);
        this.date15.setCalendar(null);
        this.date17.setCalendar(null);
        this.date18.setCalendar(null);
        this.date19.setCalendar(null);
        this.date16.setCalendar(null);
        this.date20.setCalendar(null);
        this.jDateChooser2.setCalendar(null);
        this.dateGlobal1.setCalendar(null);
        
        this.cmbSupp11.setSelectedItem("Not Available");
        this.cmbSupp12.setSelectedItem("Not Available");
        this.cmbSupp13.setSelectedItem("Not Available");
        this.cmbSupp14.setSelectedItem("Not Available");
        this.cmbSupp15.setSelectedItem("Not Available");
        this.cmbSupp16.setSelectedItem("Not Available");
        this.cmbSupp17.setSelectedItem("Not Available");
        this.cmbSupp18.setSelectedItem("Not Available");
        this.cmbSupp19.setSelectedItem("Not Available");
        this.cmbSupp20.setSelectedItem("Not Available");
        this.cmbSuppGlobal1.setSelectedItem("Not Available");
        
        
        
        
        //clear fields ends
        
        
        //load item numbers to array
        
        String iPid = this.txtProID1.getText().toString();
        
        int p1=0;
        
        String tt = "select * from item where iPID = '"+iPid+"'";
       
        
        ResultSet result111= db1.executeSQLQuery(tt);
        
        try
        {
            /*
         if(p1==1)
            {
            result111.next();
        
            this.txtItem11.setText(result111.getString("iName"));
            this.txtQ11.setText(result111.getString("iName"));
            
            }
            */
            
            for(int x=0; x<10; x++)
            {
                result111.next();
                
                itemNumber[x] = result111.getString("iID");
                
            }
            
        }
        catch(Exception e)
        {
            
        }
        
        
        // finish loading
        
        
        
        String selected = this.cmbProName.getSelectedItem().toString();
        
        
        
        String gen = "select * from project where pName = '"+selected+"'";
       
        
        ResultSet result1= db1.executeSQLQuery(gen);
        
        
        try
        {
        while(result1.next())
        {
            this.txtProID1.setText(result1.getString("pID"));
            startDate = (result1.getString("pSdate"));
            Date d = (convertStringToDate(result1.getString("pEndDate")));
            this.jDateChooser2.setDate(d);
            System.out.println(result1.getString("pGdate"));
            /*
            if(result1.getString("pGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result1.getString("pGdate");
                this.dateGlobal1.setDate(convertStringToDate(x));
            }
            */
            
        }
        
        }
        catch(Exception e)
        {
            JOptionPane.showMessageDialog(null, e.getMessage(),"METROPOLITAN ENGINEERING (PVT) LTD", 1);
        }
        
        
        //check how many
        
        String gene = "select count(*) as 'field' from item where iPID = '"+this.txtProID1.getText().toString()+"'";
   
        int n1=0;
      
        
        ResultSet count1 = db1.executeSQLQuery(gene);
        
        try
        {
            if(count1.next())
            {
                n1 += Integer.parseInt(count1.getString("field"));
            }
        }
        catch(Exception e)
        {
            JOptionPane.showMessageDialog(null, e.getMessage(),"METROPOLITAN ENGINEERING (PVT) LTD", 1);
        }
        
        
        
        //load items
        
        String gen1 = "select * from item where iPID = '"+this.txtProID1.getText().toString()+"'";
       
        
        ResultSet result11= db1.executeSQLQuery(gen1);
        
        
        try
        {
            
            // 1..............
            if(n1==1)
            {
            result11.next();
        
            this.txtItem11.setText(result11.getString("iName"));
            this.txtQ11.setText(result11.getString("iQtyA"));
            this.cmbSupp11.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                System.out.println(x);
                this.date11.setDate(convertStringToDate(x));
            }
            
            }
            
            
            // 2 .....................
            
            if(n1==2)
            {
            result11.next();
            
            this.txtItem11.setText(result11.getString("iName"));
            this.txtQ11.setText(result11.getString("iQtyA"));
            this.cmbSupp11.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date11.setDate(convertStringToDate(x));
            }
            result11.next();
        
            this.txtItem12.setText(result11.getString("iName"));
            this.txtQ12.setText(result11.getString("iQtyA"));
            this.cmbSupp12.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date12.setDate(convertStringToDate(x));
            }
            }
            
            // 3 .....................
            
            if(n1==3)
            {
            result11.next();
            this.txtItem11.setText(result11.getString("iName"));
            this.txtQ11.setText(result11.getString("iQtyA"));
            this.cmbSupp11.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date11.setDate(convertStringToDate(x));
            }
            result11.next();
             this.txtItem12.setText(result11.getString("iName"));
            this.txtQ12.setText(result11.getString("iQtyA"));
            this.cmbSupp12.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date12.setDate(convertStringToDate(x));
            }
            result11.next();
        
            this.txtItem13.setText(result11.getString("iName"));
            this.txtQ13.setText(result11.getString("iQtyA"));
            this.cmbSupp13.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date13.setDate(convertStringToDate(x));
            }
            }
            
            // 4 .....................
            
            if(n1==4)
            {
            result11.next();
            this.txtItem11.setText(result11.getString("iName"));
            this.txtQ11.setText(result11.getString("iQtyA"));
            this.cmbSupp11.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date11.setDate(convertStringToDate(x));
            }
            result11.next();
             this.txtItem12.setText(result11.getString("iName"));
            this.txtQ12.setText(result11.getString("iQtyA"));
            this.cmbSupp12.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date12.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem13.setText(result11.getString("iName"));
            this.txtQ13.setText(result11.getString("iQtyA"));
            this.cmbSupp13.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date13.setDate(convertStringToDate(x));
            }
            result11.next();
            
        
            this.txtItem14.setText(result11.getString("iName"));
            this.txtQ14.setText(result11.getString("iQtyA"));
            this.cmbSupp14.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date14.setDate(convertStringToDate(x));
            }
            }
            
            // 5 .....................
            
            if(n1==5)
            {
            result11.next();
            this.txtItem11.setText(result11.getString("iName"));
            this.txtQ11.setText(result11.getString("iQtyA"));
            this.cmbSupp11.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date11.setDate(convertStringToDate(x));
            }
            result11.next();
             this.txtItem12.setText(result11.getString("iName"));
            this.txtQ12.setText(result11.getString("iQtyA"));
            this.cmbSupp12.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date12.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem13.setText(result11.getString("iName"));
            this.txtQ13.setText(result11.getString("iQtyA"));
            this.cmbSupp13.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date13.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem14.setText(result11.getString("iName"));
            this.txtQ14.setText(result11.getString("iQtyA"));
            this.cmbSupp14.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date14.setDate(convertStringToDate(x));
            }
            result11.next();
        
            this.txtItem15.setText(result11.getString("iName"));
            this.txtQ15.setText(result11.getString("iQtyA"));
            this.cmbSupp15.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date15.setDate(convertStringToDate(x));
            }
            }
            
            // 6 .....................
            
            if(n1==6)
            {
            result11.next();
            this.txtItem11.setText(result11.getString("iName"));
            this.txtQ11.setText(result11.getString("iQtyA"));
            this.cmbSupp11.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date11.setDate(convertStringToDate(x));
            }
            result11.next();
             this.txtItem12.setText(result11.getString("iName"));
            this.txtQ12.setText(result11.getString("iQtyA"));
            this.cmbSupp12.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date12.setDate(convertStringToDate(x));
            }
            result11.next();
            this.txtItem13.setText(result11.getString("iName"));
            this.txtQ13.setText(result11.getString("iQtyA"));
            this.cmbSupp13.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date13.setDate(convertStringToDate(x));
            }
            result11.next();
            this.txtItem14.setText(result11.getString("iName"));
            this.txtQ14.setText(result11.getString("iQtyA"));
            this.cmbSupp14.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date14.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem15.setText(result11.getString("iName"));
            this.txtQ15.setText(result11.getString("iQtyA"));
            this.cmbSupp15.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date15.setDate(convertStringToDate(x));
            }
            result11.next();
        
            this.txtItem16.setText(result11.getString("iName"));
            this.txtQ16.setText(result11.getString("iQtyA"));
            this.cmbSupp16.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date16.setDate(convertStringToDate(x));
            }
            }
            
            // 7 .....................
            
            if(n1==7)
            {
                
            
            result11.next();
            this.txtItem11.setText(result11.getString("iName"));
            this.txtQ11.setText(result11.getString("iQtyA"));
            this.cmbSupp11.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date11.setDate(convertStringToDate(x));
            }
            result11.next();
             this.txtItem12.setText(result11.getString("iName"));
            this.txtQ12.setText(result11.getString("iQtyA"));
            this.cmbSupp12.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date12.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem13.setText(result11.getString("iName"));
            this.txtQ13.setText(result11.getString("iQtyA"));
            this.cmbSupp13.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date13.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem14.setText(result11.getString("iName"));
            this.txtQ14.setText(result11.getString("iQtyA"));
            this.cmbSupp14.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date14.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem15.setText(result11.getString("iName"));
            this.txtQ15.setText(result11.getString("iQtyA"));
            this.cmbSupp15.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date15.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem16.setText(result11.getString("iName"));
            this.txtQ16.setText(result11.getString("iQtyA"));
            this.cmbSupp16.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date16.setDate(convertStringToDate(x));
            }
            result11.next();
        
            this.txtItem17.setText(result11.getString("iName"));
            this.txtQ17.setText(result11.getString("iQtyA"));
            this.cmbSupp17.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date17.setDate(convertStringToDate(x));
            }
            }
            
            // 8 .....................
            
            if(n1==8)
            {
            result11.next();
            this.txtItem11.setText(result11.getString("iName"));
            this.txtQ11.setText(result11.getString("iQtyA"));
            this.cmbSupp11.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date11.setDate(convertStringToDate(x));
            }
            result11.next();
             this.txtItem12.setText(result11.getString("iName"));
            this.txtQ12.setText(result11.getString("iQtyA"));
            this.cmbSupp12.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date12.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem13.setText(result11.getString("iName"));
            this.txtQ13.setText(result11.getString("iQtyA"));
            this.cmbSupp13.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date13.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem14.setText(result11.getString("iName"));
            this.txtQ14.setText(result11.getString("iQtyA"));
            this.cmbSupp14.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date14.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem15.setText(result11.getString("iName"));
            this.txtQ15.setText(result11.getString("iQtyA"));
            this.cmbSupp15.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date15.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem16.setText(result11.getString("iName"));
            this.txtQ16.setText(result11.getString("iQtyA"));
            this.cmbSupp16.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date16.setDate(convertStringToDate(x));
            }
            result11.next();
        
            this.txtItem17.setText(result11.getString("iName"));
            this.txtQ17.setText(result11.getString("iQtyA"));
            this.cmbSupp17.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date17.setDate(convertStringToDate(x));
            }
            result11.next();
            
        
            this.txtItem18.setText(result11.getString("iName"));
            this.txtQ18.setText(result11.getString("iQtyA"));
            this.cmbSupp18.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date18.setDate(convertStringToDate(x));
            }
            
            }
            // 9 .....................
            
            if(n1==9)
            {
            result11.next();
            this.txtItem11.setText(result11.getString("iName"));
            this.txtQ11.setText(result11.getString("iQtyA"));
            this.cmbSupp11.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date11.setDate(convertStringToDate(x));
            }
            result11.next();
             this.txtItem12.setText(result11.getString("iName"));
            this.txtQ12.setText(result11.getString("iQtyA"));
            this.cmbSupp12.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date12.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem13.setText(result11.getString("iName"));
            this.txtQ13.setText(result11.getString("iQtyA"));
            this.cmbSupp13.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date13.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem14.setText(result11.getString("iName"));
            this.txtQ14.setText(result11.getString("iQtyA"));
            this.cmbSupp14.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date14.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem15.setText(result11.getString("iName"));
            this.txtQ15.setText(result11.getString("iQtyA"));
            this.cmbSupp15.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date15.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem16.setText(result11.getString("iName"));
            this.txtQ16.setText(result11.getString("iQtyA"));
            this.cmbSupp16.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date16.setDate(convertStringToDate(x));
            }
            result11.next();
        
            this.txtItem17.setText(result11.getString("iName"));
            this.txtQ17.setText(result11.getString("iQtyA"));
            this.cmbSupp17.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date17.setDate(convertStringToDate(x));
            }
            result11.next();
            
        
            this.txtItem18.setText(result11.getString("iName"));
            this.txtQ18.setText(result11.getString("iQtyA"));
            this.cmbSupp18.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date18.setDate(convertStringToDate(x));
            }
            result11.next();
        
            this.txtItem19.setText(result11.getString("iName"));
            this.txtQ19.setText(result11.getString("iQtyA"));
            this.cmbSupp19.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date19.setDate(convertStringToDate(x));
            }
            
            }
            // 10 .....................
            
            if(n1==10)
            {
            result11.next();
            this.txtItem11.setText(result11.getString("iName"));
            this.txtQ11.setText(result11.getString("iQtyA"));
            this.cmbSupp11.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date11.setDate(convertStringToDate(x));
            }
            result11.next();
             this.txtItem12.setText(result11.getString("iName"));
            this.txtQ12.setText(result11.getString("iQtyA"));
            this.cmbSupp12.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date12.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem13.setText(result11.getString("iName"));
            this.txtQ13.setText(result11.getString("iQtyA"));
            this.cmbSupp13.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date13.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem14.setText(result11.getString("iName"));
            this.txtQ14.setText(result11.getString("iQtyA"));
            this.cmbSupp14.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date14.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem15.setText(result11.getString("iName"));
            this.txtQ15.setText(result11.getString("iQtyA"));
            this.cmbSupp15.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date15.setDate(convertStringToDate(x));
            }
            result11.next();
            
            this.txtItem16.setText(result11.getString("iName"));
            this.txtQ16.setText(result11.getString("iQtyA"));
            this.cmbSupp16.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date16.setDate(convertStringToDate(x));
            }
            result11.next();
        
            this.txtItem17.setText(result11.getString("iName"));
            this.txtQ17.setText(result11.getString("iQtyA"));
            this.cmbSupp17.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date17.setDate(convertStringToDate(x));
            }
            result11.next();
            
        
            this.txtItem18.setText(result11.getString("iName"));
            this.txtQ18.setText(result11.getString("iQtyA"));
            this.cmbSupp18.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date18.setDate(convertStringToDate(x));
            }
            result11.next();
        
            this.txtItem19.setText(result11.getString("iName"));
            this.txtQ19.setText(result11.getString("iQtyA"));
            this.cmbSupp19.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date19.setDate(convertStringToDate(x));
            }
            result11.next();
           
        
            this.txtItem20.setText(result11.getString("iName"));
            this.txtQ20.setText(result11.getString("iQtyA"));
            this.cmbSupp20.setSelectedItem(result11.getString("iSupplier"));
            if(result11.getString("iGdate").equals("00-00-00"))
            {
            }
            else
            {
                String x = result11.getString("iGdate");
                this.date20.setDate(convertStringToDate(x));
            }
        
            
            }
        }
        catch(Exception e)
        {
            JOptionPane.showMessageDialog(null, e.getMessage(),"METROPOLITAN ENGINEERING (PVT) LTD", 1);
        }
        
        
    }