/*
 * Copyright (C) 2006 SQL Explorer Development Team
 * http://sourceforge.net/projects/eclipsesql
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 2.1 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 */
package net.sourceforge.sqlexplorer.connections.actions;

import java.util.Set;

import net.sourceforge.sqlexplorer.IConstants;
import net.sourceforge.sqlexplorer.Messages;
import net.sourceforge.sqlexplorer.dbproduct.Alias;
import net.sourceforge.sqlexplorer.dbproduct.SQLConnection;
import net.sourceforge.sqlexplorer.dbproduct.Session;
import net.sourceforge.sqlexplorer.dbproduct.User;
import net.sourceforge.sqlexplorer.plugin.SQLExplorerPlugin;
import net.sourceforge.sqlexplorer.util.ImageUtil;

import org.eclipse.jface.dialogs.IDialogConstants;
import org.eclipse.jface.dialogs.MessageDialogWithToggle;
import org.eclipse.ui.IViewActionDelegate;

/**
 * @author Davy Vanherbergen
 * 
 */
public class CloseAllConnectionsAction extends AbstractConnectionTreeAction implements IViewActionDelegate {

    public CloseAllConnectionsAction() {
		super("ConnectionsView.Actions.CloseAllConnections", "ConnectionsView.Actions.CloseAllConnectionsToolTip", "Images.CloseAllConnsIcon");
		setDisabledImageDescriptor(ImageUtil.getDescriptor("Images.DisabledCloseAllConnsIcon"));
	}

    /*
     * (non-Javadoc)
     * 
     * @see org.eclipse.jface.action.IAction#run()
     */
    public void run() {
    	boolean confirm = SQLExplorerPlugin.getDefault().getPluginPreferences().getBoolean(IConstants.CONFIRM_BOOL_CLOSE_ALL_CONNECTIONS);
    	if (confirm) {
	    	MessageDialogWithToggle dialog = MessageDialogWithToggle.openYesNoQuestion(getView().getSite().getShell(), 
	    			Messages.getString("ConnectionsView.Actions.CloseAll.Confirm.Title"), 
	    			Messages.getString("ConnectionsView.Actions.CloseAll.Confirm.Message"), 
	    			Messages.getString("ConnectionsView.Actions.CloseAll.Confirm.Toggle"), 
	    			false, null, null);
	    	
	    	if (dialog.getToggleState() && dialog.getReturnCode() == IDialogConstants.YES_ID)
	    		SQLExplorerPlugin.getDefault().getPluginPreferences().setValue(IConstants.CONFIRM_BOOL_CLOSE_ALL_CONNECTIONS, false);
	    	if (dialog.getReturnCode() != IDialogConstants.YES_ID)
	    		return;
    	}
    	
    	Set<SQLConnection> connections = getView().getSelectedConnections(true);
    	for (SQLConnection connection : connections) {
    		synchronized(connection) {
	    		Session session = connection.getSession();
	    		if (session != null) {
	    			synchronized(session) {
	    				if (!session.isConnectionInUse())
	    					session.disposeConnection();
	    			}
	    		} else
	    			connection.getUser().releaseFromPool(connection);
    		}
    	}

        setEnabled(false);
        getView().refresh();
    }

    /**
     * Action is available when there are open sessions
     */
    public boolean isAvailable() {
    	Set<SQLConnection> connections = getView().getSelectedConnections(true);
    	if (connections.isEmpty()) {
    		for (Alias alias : SQLExplorerPlugin.getDefault().getAliasManager().getAliases())
    			for (User user : alias.getUsers())
    				for (SQLConnection connection : user.getConnections()) {
    		    		Session session = connection.getSession();
    		    		if (session == null || !session.isConnectionInUse())
    		    			return true;
    		    	}
    	} else
	    	for (SQLConnection connection : connections) {
	    		Session session = connection.getSession();
	    		if (session == null || !session.isConnectionInUse())
	    			return true;
	    	}
    	return false;
    }
}