#region Disclaimer / License
// Copyright (C) 2011, Jackie Ng
// http://trac.osgeo.org/mapguide/wiki/maestro, jumpinjackie@gmail.com
// 
// This library 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., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
// 
#endregion
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Text;
using System.Windows.Forms;
using System.Collections.Specialized;
using Maestro.Editors.Common;
using OSGeo.MapGuide.MaestroAPI.Services;

namespace Maestro.Editors.FeatureSource.Providers.Odbc.SubEditors
{
    [ToolboxItem(false)]
    internal partial class UnmanagedCtrl : EditorBase, IOdbcSubEditor
    {
        public UnmanagedCtrl()
        {
            InitializeComponent();
        }

        private IResourceService _resSvc;

        public override void Bind(IEditorService service)
        {
            service.RegisterCustomNotifier(this);
            _resSvc = service.ResourceService;
        }

        public Control Content
        {
            get { return this; }
        }

        void OnConnectionChanged()
        {
            var handler = this.ConnectionChanged;
            if (handler != null)
                handler(this, EventArgs.Empty);
        }

        private static string InferDriver(string fileName, bool use64Bit)
        {
            string ext = System.IO.Path.GetExtension(fileName).ToUpper();
            switch (ext)
            {
                case ".ACCDB":
                    return Properties.Resources.OdbcDriverAccess64;
                case ".MDB":
                    return use64Bit ? Properties.Resources.OdbcDriverAccess64 : Properties.Resources.OdbcDriverAccess;
                case ".XLS":
                    return use64Bit ? Properties.Resources.OdbcDriverExcel64 : Properties.Resources.OdbcDriverExcel;
                case ".XLSX":
                case ".XLSM":
                case ".XLSB":
                    return Properties.Resources.OdbcDriverExcel64;
            }
            return null;
        }

        public NameValueCollection ConnectionProperties
        {
            get
            {
                return GetConnectionPropertiesInternal(false);
            }
            set
            {
                var cstr = value["ConnectionString"];
                var builder = new System.Data.Common.DbConnectionStringBuilder();
                builder.ConnectionString = cstr;
                if (builder["Dbq"] != null)
                    txtFilePath.Text = builder["Dbq"].ToString();
            }
        }

        private NameValueCollection GetConnectionPropertiesInternal(bool use64Bit)
        {
            var values = new NameValueCollection();
            string path = txtFilePath.Text;
            if (string.IsNullOrEmpty(path))
                return values;
            //throw new InvalidOperationException(Properties.Resources.OdbcNoMarkedFile);

            string drv = InferDriver(path, use64Bit);
            if (drv == null)
                return values;
            //throw new InvalidOperationException(string.Format(Properties.Resources.OdbcCannotInferDriver, path));

            var inner = new System.Data.Odbc.OdbcConnectionStringBuilder();
            inner["Driver"] = drv;
            inner["Dbq"] = path;
            values["ConnectionString"] = inner.ToString();

            return values;
        }

        public NameValueCollection Get64BitConnectionProperties()
        {
            return GetConnectionPropertiesInternal(true);
        }

        public event EventHandler ConnectionChanged;

        private void btnBrowse_Click(object sender, EventArgs e)
        {
            using (var open = new OpenFileDialog())
            {
                open.Filter = Properties.Resources.OdbcDriverAccess + "|*.mdb|" +
                              Properties.Resources.OdbcDriverAccess64 + "|*.accdb,*.mdb|" + 
                              Properties.Resources.OdbcDriverExcel + "|*.xls|" +
                              Properties.Resources.OdbcDriverExcel64 + "|*.xlsx,*.xlsm,*.xlsb";

                if (open.ShowDialog() == DialogResult.OK)
                {
                    txtFilePath.Text = open.FileName;
                }
            }
        }

        private void btnBrowseAlias_Click(object sender, EventArgs e)
        {
            using (var picker = new UnmanagedFileBrowser(_resSvc))
            {
                if (picker.ShowDialog() == DialogResult.OK)
                {
                    txtFilePath.Text = picker.SelectedItem;
                }
            }
        }

        private void txtFilePath_TextChanged(object sender, EventArgs e)
        {
            OnConnectionChanged();
        }


        public event EventHandler RequestDocumentReset;
    }
}