mono/mcs/tools/sqlsharp/gui/gtk-sharp/LoginDialog.cs

// LoginDialog.cs
//
// Author:
//     Daniel Morgan <[email protected]>
//
// (C)Copyright 2002-2003 by Daniel Morgan
//
// To be included with Mono as a SQL query tool licensed under the GPL license.
//

namespace Mono.Data.SqlSharp.Gui.GtkSharp 
{
	using System;
	using System.Collections;
	using System.Data;
	using System.Drawing;
	using System.Text;
	using System.IO;
	using Gtk;
	using GtkSharp;
	using SqlEditorSharp;
	using System.Reflection;
	using System.Runtime.Remoting;
	using System.Diagnostics;

	public class LoginDialog 
	{	
		Dialog dialog;
		Entry connection_entry;
		Entry provider_entry;
		SqlSharpGtk sqlSharp;
		OptionMenu providerOptionMenu;
		int providerSelected = 0;

		public LoginDialog(SqlSharpGtk sqlSharpGtk) 
		{ 
			sqlSharp = sqlSharpGtk;
			CreateGui();
		}

		public void CreateGui() 
		{
			dialog = new Dialog ();
			dialog.Title = "Login";
			dialog.BorderWidth = 3;
			dialog.VBox.BorderWidth = 5;
			dialog.HasSeparator = false;

			Frame frame = new Frame ("Connection");
			string image = Stock.DialogInfo;
			
			HBox hbox = new HBox (false, 2);
			hbox.BorderWidth = 5;
			hbox.PackStart (new Gtk.Image (image, IconSize.Dialog), true, true, 0);
		
			Table table = new Table (2, 3, false);
			hbox.PackStart (table);
			table.ColumnSpacing = 4;
			table.RowSpacing = 4;
			Label label = null;

			label = Label.NewWithMnemonic ("_Provider");
			table.Attach (label, 0, 1, 0, 1);
			providerOptionMenu = CreateProviderOptionMenu();
			table.Attach (providerOptionMenu, 1, 2, 0, 1);
			
			label = Label.NewWithMnemonic ("_Connection String");
			table.Attach (label, 0, 1, 1, 2);
			connection_entry = new Entry ();
			table.Attach (connection_entry, 1, 2, 1, 2);

			frame.Add (hbox);

			dialog.VBox.PackStart (frame, true, true, 0);

			Button button = null;
			button = new Button(Stock.Ok);
			button.Clicked += new EventHandler (Connect_Action);
			button.CanDefault = true;
			dialog.ActionArea.PackStart (button, true, true, 0);
			button.GrabDefault ();

			button = new Button(Stock.Cancel);
			button.Clicked += new EventHandler (Dialog_Cancel);
			dialog.ActionArea.PackStart (button, true, true, 0);
			dialog.Modal = true;

			dialog.ShowAll ();
		}

		public OptionMenu CreateProviderOptionMenu() 
		{
			OptionMenu optionMenu = new OptionMenu();
			
			Menu providerMenu = new Menu ();
			MenuItem menuItem;
			
			if (sqlSharp.dbProvider == null)
				providerSelected = 0;

			for(int i = 0; i < sqlSharp.providerList.Count; i++) {
				DbProvider p = sqlSharp.providerList[i];
				menuItem = new MenuItem(p.Name);
				providerMenu.Append (menuItem);
				if (sqlSharp.dbProvider != null)
					if (sqlSharp.dbProvider.Name.Equals(p.Name))
						providerSelected = i;
			}	
			
			optionMenu.Menu = providerMenu;
			optionMenu.Changed += new EventHandler (provider_changed_cb);

			optionMenu.SetHistory ((uint) providerSelected);

			return optionMenu;
		}

		void provider_changed_cb (object o, EventArgs args) 
		{
			if(providerOptionMenu != null)
				providerSelected = providerOptionMenu.History;
		}

		void Connect_Action (object o, EventArgs args) 
		{
			try {
				sqlSharp.dbProvider = null;
				sqlSharp.dbProvider = sqlSharp.providerList[providerSelected];
				string connection = "";

				connection = connection_entry.Text;

				sqlSharp.connectionString = connection;				
				sqlSharp.OpenDataSource();
				
			} catch (Exception e) {
				sqlSharp.AppendText(sqlSharp.buf, 
					"Error: Unable to connect.");
			}
			dialog.Destroy ();
			dialog = null;
		}

		void Dialog_Cancel (object o, EventArgs args) 
		{
			dialog.Destroy ();
			dialog = null;
		}
	}
}