XML/XSLT Word Report Generator

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

using System.Data.SqlClient;
using System.Reflection;
using System.IO;


namespace WordReportGenerator
{
    public partial class WRG : Form
    {
        private WRGEngine engine;

        public static DAL dal;
        public static string _namespace = typeof(WRG).Namespace;
        public static Assembly _assembly = Assembly.GetExecutingAssembly();
        public static string _path;
        public static string _assemblyName;

        private SqlConnection cnn;

        public WRG(){
            InitializeComponent();
            
            dal = new DAL();
            cnn = new SqlConnection(global::WordReportGenerator.Properties.Settings.Default.SQLConnectionString);

            this.Load += new EventHandler(ObjectsEditorForm_Load);
            this.FormClosing += new FormClosingEventHandler(WRG_FormClosing);

        }

        void WRG_FormClosing(object sender, FormClosingEventArgs e)
        {
            if (MessageBox.Show("Do you want to save changes?", "", MessageBoxButtons.OKCancel) == DialogResult.OK)
            {
                this.btn_apply_Click(sender, (EventArgs)e);
            }
        }

        void ObjectsEditorForm_Load(object sender, EventArgs e)
        {

            cnn.Open();
            dal.Init(cnn, true, true);
            dal.Fill("wordreports");
            engine = new WRGEngine();
            engine.LoadData();

            _path = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.CommonApplicationData), "WordReportGenerator");
            try
            {
                PathCreationEngine.CreateDirectory(_path, this, "CommonDataPath");
            }
            catch (Exception ex) { MessageBox.Show(ex.Message); }


            _assemblyName = _assembly.GetName().Name;
            btn_loadtemplate.Click += new EventHandler(engine.btn_loadtemplate_Click);
            btn_genreport.Click += new EventHandler(engine.btn_genreport_Click);

            this.gv.DataSource = WRG.dal.bs_wordreports;
            this.nav.BindingSource = WRG.dal.bs_wordreports;
            this.pg.SelectedObject = engine;
            engine.pg = this.pg;
            engine.gv = this.gv;
            this.Text = "Word Report Generator";
            cb.Checked = true;

        }

        private void btn_apply_Click(object sender, EventArgs e){
            WRG.dal.Update("wordreports");
            WRG.dal.Fill("wordreports");
        }

        private void btn_OK_Click(object sender, EventArgs e){
            WRG.dal.Update("wordreports");
            DialogResult = DialogResult.OK;
            Close();
        }

        private void btn_cancel_Click(object sender, EventArgs e)
        {
            DialogResult = DialogResult.Cancel;
            Close();
        }

        private void btn_Refresh_Click(object sender, EventArgs e){
            WRG.dal.Fill("wordreports");
            engine.LoadData();
        }

        private void toolStripButton3_Click(object sender, EventArgs e){
            Object value = engine;
            SqlExecutor sqlexec = new SqlExecutor(ref value);
            if (sqlexec.ShowDialog() == DialogResult.OK)
            {

            }
        }

        private void cb_CheckedChanged(object sender, EventArgs e){
            engine.autoset = cb.Checked;
        }

    }

    public class DocumentInstanceException : Exception
    { }

    public class ValidDocumentException : Exception
    { }

    public class WordInstanceException : Exception
    { }
}