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

/*

 * 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);

    }

}