OpenConcerto

Dépôt officiel du code source de l'ERP OpenConcerto
sonarqube

svn://code.openconcerto.org/openconcerto

Rev

Blame | Last modification | View Log | RSS feed

/*
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
 * 
 * Copyright 2011 OpenConcerto, by ILM Informatique. All rights reserved.
 * 
 * The contents of this file are subject to the terms of the GNU General Public License Version 3
 * only ("GPL"). You may not use this file except in compliance with the License. You can obtain a
 * copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific
 * language governing permissions and limitations under the License.
 * 
 * When distributing the software, include this License Header Notice in each file.
 */
 
 package org.openconcerto.erp.core.sales.invoice.action;

import org.openconcerto.erp.core.finance.payment.element.EncaisserMontantSQLElement;
import org.openconcerto.sql.model.ConnectionHandlerNoSetup;
import org.openconcerto.sql.model.SQLDataSource;
import org.openconcerto.sql.utils.SQLUtils;
import org.openconcerto.ui.SwingThreadUtils;
import org.openconcerto.utils.ExceptionHandler;

import java.awt.Component;
import java.awt.FileDialog;
import java.awt.Frame;
import java.awt.event.ActionEvent;
import java.io.File;
import java.io.IOException;
import java.sql.SQLException;

import javax.swing.AbstractAction;
import javax.swing.Action;
import javax.swing.JOptionPane;

public class ImportReglementSageAction extends AbstractAction {
    private final EncaisserMontantSQLElement elt;

    public ImportReglementSageAction(EncaisserMontantSQLElement elt) {
        super();
        this.elt = elt;
        this.putValue(Action.NAME, "Import XML des réglements depuis Sage");
    }

    @Override
    public void actionPerformed(ActionEvent e) {
        final Frame frame = SwingThreadUtils.getAncestorOrSelf(Frame.class, (Component) e.getSource());
        final FileDialog fd = new FileDialog(frame, "Import XML des réglements Sage", FileDialog.LOAD);
        if (fd.getFile() != null) {
            try {
                SQLUtils.executeAtomic(this.elt.getTable().getDBSystemRoot().getDataSource(), new ConnectionHandlerNoSetup<Object, IOException>() {
                    @Override
                    public Object handle(final SQLDataSource ds) throws SQLException, IOException {

                        ImportReglementSage sageImporter = new ImportReglementSage(ImportReglementSageAction.this.elt);
                        try {
                            sageImporter.importFromFile(new File(fd.getDirectory(), fd.getFile()));
                        } catch (Exception e) {
                            e.printStackTrace();
                            new SQLException(e);
                        }
                        return null;
                    }

                });
                JOptionPane.showMessageDialog(null, "Import des paiements terminés!");
            } catch (IOException exn) {
                ExceptionHandler.handle(frame, "Erreur lors de la lecture du fichier", exn);
            } catch (SQLException exn) {
                ExceptionHandler.handle(frame, "Erreur lors de l'insertion des paiements dans la base", exn);
            }

        }
        fd.setVisible(true);

    }
}