private void OnSave(object sender, RoutedEventArgs e) { int instanceExpandMask = 0; try { foreach (var item in cbe_DefaultInstanceExpandMask.SelectedItems) { instanceExpandMask += ((KeyValuePair <string, int>)item).Value; } SQLInformation.Data.ApplicationDataSet.ServersRow newServer = Common.ApplicationDataSet.Servers.NewServersRow(); newServer.ID = Guid.Parse(textEdit_ID.Text); newServer.NetName = textEdit_NetName.Text; newServer.ADDomain = cbe_ADDomain.Text; newServer.Environment = cbe_Environment.Text; newServer.DefaultInstanceExpandMask = instanceExpandMask; Common.ApplicationDataSet.Servers.AddServersRow(newServer); Common.ApplicationDataSet.ServersTA.Update(Common.ApplicationDataSet.Servers); } catch (Exception ex) { VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2); } ClearEntries(); }
private void OnCreateNewServer(object sender, RoutedEventArgs e) { try { SQLInformation.Data.ApplicationDataSet.ServersRow newServer = Common.ApplicationDataSet.Servers.NewServersRow(); newServer.ID = Guid.NewGuid(); newServer.NetName = te_ServerName.Text.ToUpper(); Window parentWindow = Window.GetWindow(this); if (CanPingServer(newServer.NetName)) { Common.ApplicationDataSet.Servers.AddServersRow(newServer); Common.ApplicationDataSet.Servers_Update(); //Common.ApplicationDataSet.ServersTA.Update(Common.ApplicationDataSet.Servers); parentWindow.DialogResult = true; } else { MessageBox.Show("Cannot Ping Server. Check Name"); parentWindow.DialogResult = false; } } catch (Exception ex) { VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2); } }
private void SyncServerInfoAndInstanceInfo(SQLInformation.Data.ApplicationDataSet.InstancesRow instance) { var servers = from s in Common.ApplicationDataSet.Servers where s.NetName == instance.NetName select s; try { SQLInformation.Data.ApplicationDataSet.ServersRow server = servers.First(); instance.Server_ID = server.ID; server.OSVersion = instance.OSVersion; server.PhysicalMemory = instance.PhysicalMemory; server.Platform = instance.Platform; server.Processors = instance.Processors; server.EndEdit(); } catch (Exception ex) { // No matching server. MessageBox.Show("No matching server. Add new entry then continue"); } }
private void OnPingServer_Click(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e) { SQLInformation.Data.ApplicationDataSet.ServersRow server = (SQLInformation.Data.ApplicationDataSet.ServersRow) ((System.Data.DataRowView)dataGrid.View.FocusedRowData.Row).Row; Helpers.Server.PingServer(server.NetName); }
private void OnGetIPAddress(object sender, RoutedEventArgs e) { SQLInformation.Data.ApplicationDataSet.ServersRow server = (SQLInformation.Data.ApplicationDataSet.ServersRow) ((System.Data.DataRowView)dataGrid.View.FocusedRowData.Row).Row; server.IPAddress = Helpers.Server.GetIPV4Address(server.NetName); Common.ApplicationDataSet.ServersTA.Update(Common.ApplicationDataSet.Servers); }
private void UpdateInfo() { SQLInformation.Data.ApplicationDataSet.ServersRow server = (SQLInformation.Data.ApplicationDataSet.ServersRow) ((System.Data.DataRowView)serversDataGrid.SelectedItem).Row; Console.WriteLine(server.NetName); Console.WriteLine(server.ID.ToString()); System.Diagnostics.Debug.WriteLine(server.NetName); //var row1 = serversDataGrid.SelectedItem; //var gridRow = serversDataGrid.ItemContainerGenerator.ContainerFromItem(serversDataGrid.SelectedItem); //System.Data.DataRowView row2 = (System.Data.DataRowView)serversDataGrid.SelectedItem; //var realRow = row2.Row; //var realRow2 = (Data.ApplicationDataSet.ServersRow)row2.Row; //Data.ApplicationDataSet.ServersRow typedRow = (Data.ApplicationDataSet.ServersRow)row2.Row; //ManagedComputer mc = new ManagedComputer(typedRow.name); //Common.WriteToDebugWindow(typedRow.name); //Common.WriteToDebugWindow(String.Format("Name:{0} State:{1}", mc.Name, mc.State)); //foreach (ClientProtocol cp in mc.ClientProtocols) //{ // Common.WriteToDebugWindow(String.Format(" CP Name:{0} Order:{1} IsEnabled:{2}", cp.Name, cp.Order, cp.IsEnabled)); //} //foreach (ServerInstance si in mc.ServerInstances) //{ // Common.WriteToDebugWindow(String.Format(" SI Name:{0}", si.Name)); // foreach (ServerProtocol sp in si.ServerProtocols) // { // Common.WriteToDebugWindow(String.Format(" SP Name:{0} IsEnabled:{1}", sp.Name, sp.IsEnabled)); // foreach (ServerIPAddress sipa in sp.IPAddresses) // { // Common.WriteToDebugWindow(String.Format(" SIPA Name:{0} IPAddress:{1} State:{2}", sipa.Name, sipa.IPAddress, sipa.State )); // foreach (IPAddressProperty ipap in sipa.IPAddressProperties) // { // Common.WriteToDebugWindow(String.Format(" IPAP Name:{0} Value:{1}", ipap.Name, ipap.Value)); // } // } // } //} }
private void OnGetMultipleIPAddress(object sender, RoutedEventArgs e) { var rows = tableView1.SelectedRows; foreach (DataRowView s in tableView1.SelectedRows) { SQLInformation.Data.ApplicationDataSet.ServersRow server = (SQLInformation.Data.ApplicationDataSet.ServersRow)s.Row; server.IPAddress = Helpers.Server.GetIPV4Address(server.NetName); Common.ApplicationDataSet.ServersTA.Update(Common.ApplicationDataSet.Servers); } }
private void btnLoadFromXML_Click(object sender, RoutedEventArgs e) { Test_Data.InstanceData.LoadNewInstancesInfoFromFile(); // Use just the server part of the instance list. foreach (var instance in Test_Data.InstanceData.DBInstances) { SQLInformation.Data.ApplicationDataSet.ServersRow newServer = Common.ApplicationDataSet.Servers.NewServersRow(); newServer.ID = Guid.NewGuid(); newServer.NetName = instance.server; Common.ApplicationDataSet.Servers.AddServersRow(newServer); } }
private void Button_Click(object sender, RoutedEventArgs e) { SQLInformation.Data.ApplicationDataSet.ServersRow newServer = Common.ApplicationDataSet.Servers.NewServersRow(); newServer.ID = Guid.Parse(iDTextBox.Text); newServer.NetName = netNameTextBox.Text; newServer.Environment = environmentTextBox.Text; newServer.OSVersion = oSVersionTextBox.Text; newServer.PhysicalMemory = int.Parse(physicalMemoryTextBox.Text); newServer.Platform = platformTextBox.Text; newServer.Processors = int.Parse(processorsTextBox.Text); Common.ApplicationDataSet.Servers.AddServersRow(newServer); Common.ApplicationDataSet.ServersTA.Update(Common.ApplicationDataSet.Servers); }
private void SyncServerInfoAndInstanceInfo(SQLInformation.Data.ApplicationDataSet.InstancesRow instance) { var servers = from s in Common.ApplicationDataSet.Servers where s.NetName == instance.NetName select s; SQLInformation.Data.ApplicationDataSet.ServersRow server = servers.First(); instance.Server_ID = server.ID; server.OSVersion = instance.OSVersion; server.PhysicalMemory = instance.PhysicalMemory; server.Platform = instance.Platform; server.Processors = instance.Processors; server.EndEdit(); }
/// <summary> /// Store current values in ServerInfo history table. /// </summary> /// <param name="instance"></param> /// <param name="database"></param> private void TakeSnapShot(string instanceName, SQLInformation.Data.ApplicationDataSet.ServersRow serverRow) { //SMO.Server server = SMOH.SMOD.GetServer(instanceName); SQLInformation.Data.ApplicationDataSetTableAdapters.ServerInfoTableAdapter tableAdapter = new SQLInformation.Data.ApplicationDataSetTableAdapters.ServerInfoTableAdapter(); tableAdapter.Connection.ConnectionString = SQLInformation.Data.Config.SQLMonitorDBConnection; //int dbID = int.Parse(serverRow.ID_DB); //SMO.Database db = server.Databases.ItemById(dbID); SQLInformation.Data.ApplicationDataSet.ServerInfoRow newSnapShot = Common.ApplicationDataSet.ServerInfo.NewServerInfoRow(); newSnapShot.Server_ID = serverRow.ID; newSnapShot.SnapShotDate = DateTime.Now; Common.ApplicationDataSet.ServerInfo.AddServerInfoRow(newSnapShot); tableAdapter.Update(Common.ApplicationDataSet.ServerInfo); }
private void SyncServerInfoAndInstanceInfo(SQLInformation.Data.ApplicationDataSet.InstancesRow instance) { var servers = from s in Common.ApplicationDataSet.Servers where s.NetName.ToUpper() == instance.NetName.ToUpper() select s; try { SQLInformation.Data.ApplicationDataSet.ServersRow server = servers.First(); instance.Server_ID = server.ID; // TODO: Verify these are set before trying to SYNC. try { server.ADDomain = instance.ADDomain; server.Environment = instance.Environment; server.SecurityZone = instance.SecurityZone; server.OSVersion = instance.OSVersion; server.PhysicalMemory = instance.PhysicalMemory; server.Platform = instance.Platform; server.Processors = instance.Processors; } catch (Exception) { } server.EndEdit(); } catch (Exception) { // No matching server. MessageBox.Show("No matching server found. Adding new server."); int instanceExpandMask = 127; try { SQLInformation.Data.ApplicationDataSet.ServersRow newServer = Common.ApplicationDataSet.Servers.NewServersRow(); newServer.ID = Guid.NewGuid(); newServer.NetName = instance.NetName.ToUpper(); newServer.DefaultInstanceExpandMask = instanceExpandMask; // Wrap in exception in case not populated try { newServer.OSVersion = instance.OSVersion; newServer.PhysicalMemory = instance.PhysicalMemory; newServer.Platform = instance.Platform; newServer.Processors = instance.Processors; } catch (Exception) { } Common.ApplicationDataSet.Servers.AddServersRow(newServer); Common.ApplicationDataSet.Servers_Update(); //Common.ApplicationDataSet.ServersTA.Update(Common.ApplicationDataSet.Servers); instance.Server_ID = newServer.ID; Common.ApplicationDataSet.Instances_Update(); //Common.ApplicationDataSet.InstancesTA.Update(Common.ApplicationDataSet.Instances); } catch (Exception ex) { VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2); } } }