trunk/TSControlPanel/frmConfigureControlPanel.cs

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 AnywhereTS.DBSupport;
using Microsoft.Win32;

namespace AnywhereTS
{
    public partial class frmConfigureControlPanel : Form
    {
        public frmConfigureControlPanel()
        {
            InitializeComponent();
        }


        private void GetAnywhereTSDatabase(string ATSServer, out string DBServer, out string DBInstance)
        {
            DBServer = string.Empty;
            DBInstance = string.Empty;
            try
            {
                Logging.DatabaseLog.InfoFormat("Getting AnywhereTS Database Server and Instance from: {0}", ATSServer);
                RegistryKey rk = RegistryKey.OpenRemoteBaseKey(RegistryHive.LocalMachine, ATSServer);
                rk = rk.OpenSubKey(string.Format(@"SOFTWARE\{0}\ts-config", ATSGlobals.ApplicationName));
                DBServer = (string)rk.GetValue(ProSupport.strRegDatabaseServer);
                DBInstance = (string)rk.GetValue(ProSupport.strRegDatabaseInstance);
                Logging.DatabaseLog.DebugFormat("DBServer={0} DBInstance={1}", DBServer, DBInstance);
                Logging.DatabaseLog.InfoFormat("Successfully retreived AnywhereTS Database Server and Instance from: {0}", ATSServer);
            }
            catch (Exception ex)
            {
                using (log4net.NDC.Push(string.Format("{0}: MESSAGE={1}{2}Diagnostics:{2}{3}", ex.GetType().Name, ex.Message, System.Environment.NewLine, ex.ToString())))
                {
                    Logging.DatabaseLog.Error(string.Format("Failed to open Database {0}", ATSGlobals.strDatabaseName));
                }
            }

        }

        private void btnOk_Click(object sender, EventArgs e)
        {
            // Validate database server
            string dataServer;
            dataServer = textInput.Text.Trim();

            string DBServer = "";
            string DBInstance = "";

            GetAnywhereTSDatabase(dataServer, out DBServer, out DBInstance);
            ATSGlobals.SetATSRegValue(ProSupport.strRegDatabaseServer, DBServer);
            ATSGlobals.SetATSRegValue(ProSupport.strRegDatabaseInstance, DBInstance);
            ProSupport.strDatabaseServer = DBServer;
            ProSupport.strDatabaseInstance = DBInstance;

            //Create a connection to SQL Server
            Exception ErrorInfo = null;
            Logging.ATSAdminLog.Debug("frmConfigureControlPanel.btnOk_Click() called ");
            using (MsSqlConnector conn = new MsSqlConnector(ProSupport.strDatabaseServer, ProSupport.strDatabaseInstance, "master"))
            {
                try
                {
                    Logging.ATSAdminLog.Info(string.Format("Opening Database {0}", ATSGlobals.strDatabaseName));
                    conn.CreateConnection(out ErrorInfo);
                    conn.OpenConnection(out ErrorInfo);
                    Logging.ATSAdminLog.Info(string.Format("Opened Database {0}", ATSGlobals.strDatabaseName));
                }
                catch (SqlException ex)
                {
                    using (log4net.NDC.Push(string.Format("SqlException: ID={0} MESSAGE={1}{2}Diagnostics:{2}{3}", ex.Number.ToString(), ex.Message, System.Environment.NewLine, ex.ToString())))
                    {
                        Logging.DatabaseLog.Error(string.Format("Failed to open Database {0}", ATSGlobals.strDatabaseName));
                    }
                    ErrorInfo = ex; throw ErrorInfo;
                }
                catch (Exception ex)
                {
                    using (log4net.NDC.Push(string.Format("{0}: MESSAGE={1}{2}Diagnostics:{2}{3}", ex.GetType().Name, ex.Message, System.Environment.NewLine, ex.ToString())))
                    {
                        Logging.DatabaseLog.Error(string.Format("Failed to open Database {0}", ATSGlobals.strDatabaseName));
                    }
                    ErrorInfo = ex; throw ErrorInfo;
                }
            }
            if (ErrorInfo != null) { MessageBox.Show(string.Format("Failed to open database {0}. Please check the log for errors.", ATSGlobals.strDatabaseName)); }
            // Save database server to variable and registry
            ProSupport.strAnywhereTSServer = dataServer;
            ATSGlobals.SetATSRegValue(ProSupport.strRegAnywhereTSServer, ProSupport.strAnywhereTSServer);
            DialogResult = DialogResult.OK; //return
        }
    }
}
Revision:	206
Committed:	Mon Jul 16 18:03:31 2012 UTC (9 years, 11 months ago) by william
File size:	4665 byte(s)
Log Message:	+ fix issue where: 1) you install TSControlPanel on a system that does not have ATSAdmin installed 2) you do not have a DBServer or DBInstance setting in the registry ** fixed by using the entered ATSServer name, and retrieving the values using remote registry access
#	User	Rev	Content
1	william	4	using System;
2			using System.Collections.Generic;
3			using System.ComponentModel;
4			using System.Data;
5			using System.Drawing;
6			using System.Text;
7			using System.Windows.Forms;
8			using System.Data.SqlClient;
9	william	91	using AnywhereTS.DBSupport;
10	william	206	using Microsoft.Win32;
11	william	4
12			namespace AnywhereTS
13			{
14			public partial class frmConfigureControlPanel : Form
15			{
16			public frmConfigureControlPanel()
17			{
18			InitializeComponent();
19			}
20
21	william	206
22			private void GetAnywhereTSDatabase(string ATSServer, out string DBServer, out string DBInstance)
23			{
24			DBServer = string.Empty;
25			DBInstance = string.Empty;
26			try
27			{
28			Logging.DatabaseLog.InfoFormat("Getting AnywhereTS Database Server and Instance from: {0}", ATSServer);
29			RegistryKey rk = RegistryKey.OpenRemoteBaseKey(RegistryHive.LocalMachine, ATSServer);
30			rk = rk.OpenSubKey(string.Format(@"SOFTWARE\{0}\ts-config", ATSGlobals.ApplicationName));
31			DBServer = (string)rk.GetValue(ProSupport.strRegDatabaseServer);
32			DBInstance = (string)rk.GetValue(ProSupport.strRegDatabaseInstance);
33			Logging.DatabaseLog.DebugFormat("DBServer={0} DBInstance={1}", DBServer, DBInstance);
34			Logging.DatabaseLog.InfoFormat("Successfully retreived AnywhereTS Database Server and Instance from: {0}", ATSServer);
35			}
36			catch (Exception ex)
37			{
38			using (log4net.NDC.Push(string.Format("{0}: MESSAGE={1}{2}Diagnostics:{2}{3}", ex.GetType().Name, ex.Message, System.Environment.NewLine, ex.ToString())))
39			{
40			Logging.DatabaseLog.Error(string.Format("Failed to open Database {0}", ATSGlobals.strDatabaseName));
41			}
42			}
43
44			}
45
46	william	4	private void btnOk_Click(object sender, EventArgs e)
47			{
48			// Validate database server
49			string dataServer;
50			dataServer = textInput.Text.Trim();
51	william	206
52			string DBServer = "";
53			string DBInstance = "";
54
55			GetAnywhereTSDatabase(dataServer, out DBServer, out DBInstance);
56			ATSGlobals.SetATSRegValue(ProSupport.strRegDatabaseServer, DBServer);
57			ATSGlobals.SetATSRegValue(ProSupport.strRegDatabaseInstance, DBInstance);
58			ProSupport.strDatabaseServer = DBServer;
59			ProSupport.strDatabaseInstance = DBInstance;
60
61	william	4	//Create a connection to SQL Server
62	william	91	Exception ErrorInfo = null;
63			Logging.ATSAdminLog.Debug("frmConfigureControlPanel.btnOk_Click() called ");
64	william	92	using (MsSqlConnector conn = new MsSqlConnector(ProSupport.strDatabaseServer, ProSupport.strDatabaseInstance, "master"))
65	william	4	{
66	william	91	try
67	william	46	{
68	william	206	Logging.ATSAdminLog.Info(string.Format("Opening Database {0}", ATSGlobals.strDatabaseName));
69	william	91	conn.CreateConnection(out ErrorInfo);
70			conn.OpenConnection(out ErrorInfo);
71			Logging.ATSAdminLog.Info(string.Format("Opened Database {0}", ATSGlobals.strDatabaseName));
72			}
73			catch (SqlException ex)
74			{
75			using (log4net.NDC.Push(string.Format("SqlException: ID={0} MESSAGE={1}{2}Diagnostics:{2}{3}", ex.Number.ToString(), ex.Message, System.Environment.NewLine, ex.ToString())))
76	william	49	{
77	william	91	Logging.DatabaseLog.Error(string.Format("Failed to open Database {0}", ATSGlobals.strDatabaseName));
78	william	49	}
79	william	91	ErrorInfo = ex; throw ErrorInfo;
80	william	46	}
81	william	91	catch (Exception ex)
82			{
83			using (log4net.NDC.Push(string.Format("{0}: MESSAGE={1}{2}Diagnostics:{2}{3}", ex.GetType().Name, ex.Message, System.Environment.NewLine, ex.ToString())))
84			{
85			Logging.DatabaseLog.Error(string.Format("Failed to open Database {0}", ATSGlobals.strDatabaseName));
86			}
87			ErrorInfo = ex; throw ErrorInfo;
88			}
89	william	4	}
90	william	91	if (ErrorInfo != null) { MessageBox.Show(string.Format("Failed to open database {0}. Please check the log for errors.", ATSGlobals.strDatabaseName)); }
91	william	4	// Save database server to variable and registry
92	william	206	ProSupport.strAnywhereTSServer = dataServer;
93	william	92	ATSGlobals.SetATSRegValue(ProSupport.strRegAnywhereTSServer, ProSupport.strAnywhereTSServer);
94	william	4	DialogResult = DialogResult.OK; //return
95			}
96			}
97			}