apply from addService

apply.setOnAction(new EventHandler<ActionEvent>() {
                    @Override
                    public void handle(ActionEvent event) {
                        String providerOneName=(String) providerOneField.getValue();


                        if(nameField.getText().trim().isEmpty()) {
                            Alert alert = new Alert(AlertType.WARNING);
                            alert.setContentText("please enter service name");
                            alert.showAndWait();
                            return;
                        }
                        if(providerOneName=="None") {
                            Alert alert = new Alert(AlertType.WARNING);
                            alert.setContentText("please enter at least one provider name");
                            alert.showAndWait();
                            return;
                        }if(!fromEditPage) {
                            Connection conn = null;
                            try {
                                conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/company?useSSL=false",
                                        "root", "admin");
                                insertNewPatient(ID,conn);

                                int serviceID=serviceData(nameField.getText(), null, conn, ID,(int) ServiceReportField.getValue(),(String)paymentMethodField.getValue());

                                for(int i=0 ;i<moreProvidersName.size();i++) {
                                    String providerName=(String)moreProvidersName.get(i).getValue();
                                    if(providerName!="None") {
                                        providerData(providerName, serviceID, conn, ID);
                                    }
                                }

                                for(int i=0;i<serviceCalender.size();i=i+4) {
                                    String hr=(String)serviceCalender.get(i+1).getValue();
                                    if(!hr.equals("0")) {
                                        String Day=(String)serviceCalender.get(i).getValue();
                                        String min=(String)serviceCalender.get(i+2).getValue();
                                        String AM=(String)serviceCalender.get(i+3).getValue();
                                        String startTime=hr+":"+min+" "+AM;
                                    //  insertIntoServiceCalender(ID, serviceID, Day.toUpperCase(), startTime, conn);
                                    }
                                }

                                for(int i=0;i<doctorData.size();i=i+2) {
                                    TextField doctorField=(TextField) doctorData.get(i);
                                    CheckBox strangerBox=(CheckBox)doctorData.get(i+1);
                                    if(!doctorField.getText().trim().isEmpty()) {
                                        int doctorID=idNumber(strangerBox, doctorField.getText(), "doctor", "DName", "DID", conn);
                                        insertIntoHelpTable(ID,doctorID,-1,"patientDoctor",conn,false,0,null);
                                    }
                                }

                            } catch (SQLException e) {
                                // TODO Auto-generated catch block
                                e.printStackTrace();
                            }


                        current.close();
                        base.show();
                        }else {//Not correct for new update

                            Connection conn = null;
                            try {
                                conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/company?useSSL=false",
                                        "root", "admin");

                                int serviceID=serviceData(nameField.getText(), null, conn, ID,(int) ServiceReportField.getValue(),(String)paymentMethodField.getValue());

                                for(int i=0 ;i<moreProvidersName.size();i++) {
                                    String providerName=(String)moreProvidersName.get(i).getValue();
                                    if(providerName!="None") {
                                        providerData(providerName, serviceID, conn, ID);
                                    }
                                }

                                for(int i=0;i<serviceCalender.size();i=i+4) {
                                    String hr=(String)serviceCalender.get(i+1).getValue();
                                    if(!hr.equals("0")) {
                                        String Day=(String)serviceCalender.get(i).getValue();
                                        String min=(String)serviceCalender.get(i+2).getValue();
                                        String AM=(String)serviceCalender.get(i+3).getValue();
                                        String startTime=hr+":"+min+" "+AM;
                                    //  insertIntoServiceCalender(ID, serviceID, Day.toUpperCase(), startTime, conn);
                                    }
                                }


                            } catch (SQLException e) {
                                // TODO Auto-generated catch block
                                e.printStackTrace();
                            }
                            try {
                                Getinfo obj =new Getinfo(base, ID);
                                current.close();
                                obj.show();

                            } catch (SQLException e) {
                                // TODO Auto-generated catch block
                                e.printStackTrace();
                            }



                        }
                    }
                });