1. cs = conn.prepareCall("{call STP_Insert_tblReceipt(?,?,?, ?,?,?, ?,?,?, ?,?,?, ?,?,?, ?,?,?, ?,?,?, ?,?,?, ?,?,?)}");
  2. // cs = conn.prepareCall("{call STP_Receipt_Form_Insertion_Trial(?,?,?, ?,?,?, ?,?,?, ?,?,?, ?)}");
  3. cs.setLong(1, Long.parseLong(txtMobileNo.getText()));
  4. cs.setString(2, String.valueOf(cboDistributor.getSelectedItem()));
  5. cs.setLong(3, Long.parseLong(txtBoxNo.getText()));
  6. cs.setInt(4, Integer.parseInt(txtFileNo.getText()));
  7. cs.setString(5, pickUp_date);
  8. cs.setString(6, rec_date);
  9. cs.setString(7, String.valueOf(cmbCtrlNo.getSelectedItem()));
  10. cs.setString(8, UserName);
  11. cs.setString(9, rec_date);
  12. cs.setString(10, RegionLocation);
  13. cs.setString(11, txtRemark.getText().trim());
  14. cs.setString(12, txtSimNo.getText().trim());
  15. cs.setInt(13, 2);
  16. cs.setString(14, String.valueOf(cmbAryanRegion.getSelectedItem()));
  17. cs.setString(15, String.valueOf(cboPickUpType.getSelectedItem()));
  18. cs.setString(16, String.valueOf(txtCafNo.getText()));
  19. cs.setString(17, distributorId);
  20. //cs.setString(18, circleName);
  21. cs.setString(18, cboCircle.getSelectedItem().toString());
  22. cs.registerOutParameter(19, java.sql.Types.INTEGER);
  23. cs.setString(20, auditorName);
  24. cs.setString(21, retailerName);
  25. cs.setString(22, retailerCode);
  26. cs.setInt(23, mappedFlag);
  27. //cs.setString(24, distCode);
  28. cs.setString(24, cboDistCode.getSelectedItem().toString());
  29. //cs.setString(25, zoneName);
  30. cs.setString(25, cboZone.getSelectedItem().toString());
  31. cs.setString(26, comment);
  32. **cs.setInt(27, 1);** **this is for CPV Flag**
  33.  
  34. cs.registerOutParameter(19, java.sql.Types.INTEGER);