A Helpful Database Library

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Runtime.InteropServices;
using MSDASC;
using ADODB;
using Settings = LDC_10.Properties.Settings;

namespace LDC_10
{
    internal partial class Setup : Form
    {
        public Setup()
        {
            InitializeComponent();
        }

        private void btnCancel_Click(object sender, EventArgs e)
        {
            try
            {
                if (Settings.Default.DirMonitor == "" || Settings.Default.ConnString == "")
                {
                    Settings.Default.Stop = true;
                    MessageBox.Show("Application Stoping!\nApplication Parameters are not set.\nRun Application with setup command.", "Application Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                this.Close();
            }
            catch (Exception ebtnCancel)
            {
                MessageBox.Show(ebtnCancel.ToString());
            }
        }

        private void dirBrowse_Click(object sender, EventArgs e)
        {
            try
            {
                FolderBrowserDialog _fld = new FolderBrowserDialog();
                _fld.ShowDialog();
                if (_fld.SelectedPath != null)
                {
                    txtDirMon.Text = _fld.SelectedPath;
                    txtDirMon.Refresh();
                }
            }
            catch (Exception edirBrowse)
            {
                MessageBox.Show(edirBrowse.ToString());
            }
        }

        private void dataSel_Click(object sender, EventArgs e)
        {
            try
            {
                DataLinksClass _dl = new DataLinksClass();
                
                _dl.hWnd = this.Handle.ToInt32();
                Connection _con = (Connection)_dl.PromptNew();
                if (_con != null)
                {
                    txtData.Text = _con.ConnectionString;
                    txtData.Refresh();
                }
            }
            catch (Exception edataSel)
            {
                MessageBox.Show(edataSel.ToString());
            }
        }

        private void xmlBrowse_Click(object sender, EventArgs e)
        {
            try
            {
                FolderBrowserDialog _fld = new FolderBrowserDialog();
                _fld.ShowDialog();
                if (_fld.SelectedPath != null)
                {
                    txtXML.Text = _fld.SelectedPath;
                    txtXML.Refresh();
                }
            }
            catch (Exception exmlBrowse)
            {
                MessageBox.Show(exmlBrowse.ToString());
            }
        }

        private void rdoYes_CheckedChanged(object sender, EventArgs e)
        {
            try
            {
                if (rdoNo.Checked)
                {
                    rdoNo.Checked = false;
                    rdoYes.Checked = true;
                    txtXML.Enabled = true;
                    txtXML.Refresh();
                    xmlBrowse.Enabled = true;
                    xmlBrowse.Refresh();
                }
            }
            catch (Exception erdoYes)
            {
                MessageBox.Show(erdoYes.ToString());
            }
        }

        private void rdoNo_CheckedChanged(object sender, EventArgs e)
        {
            try
            {
                if (rdoYes.Checked)
                {
                    rdoYes.Checked = false;
                    rdoNo.Checked = true;
                    txtXML.Enabled = false;
                    txtXML.Refresh();
                    xmlBrowse.Enabled = false;
                    xmlBrowse.Refresh();
                }
            }
            catch (Exception erdoNo)
            {
                MessageBox.Show(erdoNo.ToString());
            }
        }

        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                if (txtData.Text == "" || txtDirMon.Text == "")
                {
                    MessageBox.Show("You must enter a diretory to monitor and a data storage location.", "Setup Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else
                {

                    System.Data.OleDb.OleDbConnection oleConn = new System.Data.OleDb.OleDbConnection(txtData.Text);
                    string newconn = txtData.Text;
                    newconn = newconn.Substring((newconn.IndexOf(";") + 1), (newconn.Length - ((newconn.IndexOf(";") + 1))));
                    Settings.Default.Provider = oleConn.Provider;
                    Settings.Default.DirMonitor = txtDirMon.Text;
                    Settings.Default.ConnString = txtData.Text;
                    Settings.Default.ConnStringSQL = newconn;
                    Settings.Default.XMLDir = txtXML.Text;
                    Settings.Default.CreateXML = rdoYes.Checked;
                    Settings.Default.Stop = false;
                    Settings.Default.Save();
                    this.Close();
                }
            }
            catch (Exception ebtnSave)
            {
                MessageBox.Show(ebtnSave.ToString());
            }
        }
    }
}