public static void SaveConnection()
{
if (RegistryModifyAccess)
{
RegistryHandler.SaveToRegistry("ConnectionString", ConnectionStringSecurity.EncodeConnectionString(ConnectionStringToSave, "ConnectionString"));
}
}
private void DecryptedTextBox_KeyUp(object sender, KeyEventArgs e)
{
string encryptedPassword = ConnectionStringSecurity.Encode(decryptedTextBox.Text);
encryptedTextBox.Text = encryptedPassword;
if (encryptedTextBox.Text != "")
{
copyLinkLabel.Enabled = true;
}
else
{
copyLinkLabel.Enabled = false;
}
}
public static void SaveConfig()
{
RegistryHandler.SaveToRegistry("ConnectionString", ConnectionStringSecurity.Encode(ConnectionStringToSave, "ConnectionString"));
RegistryHandler.SaveToRegistry("SaveConnectionString", SaveConnectionString);
RegistryHandler.SaveToRegistry("WindowSize", WindowSize);
RegistryHandler.SaveToRegistry("SplitterDistanceVertical", SplitterDistanceVertical);
RegistryHandler.SaveToRegistry("SplitterDistanceHorizontal", SplitterDistanceHorizontal);
RegistryHandler.SaveToRegistry("DescriptionFields", GetDescriptionFieldListToXml(_descriptionFields));
RegistryHandler.SaveToRegistry("DescriptionTemplates", GetDescriptionTemplateListToXml(_descriptionTemplates));
RegistryHandler.SaveToRegistry("TextDataFontFamily", TextDataFontFamily);
RegistryHandler.SaveToRegistry("TextDataFontSize", TextDataFontSize);
RegistryHandler.SaveToRegistry("DescriptionFontFamily", DescriptionFontFamily);
RegistryHandler.SaveToRegistry("DescriptionFontSize", DescriptionFontSize);
RegistryHandler.SaveToRegistry("CheckForUpdatesOnStart", CheckForUpdatesOnStart);
RegistryHandler.SaveToRegistry("ShowDdlScript", ShowDdlScript);
RegistryHandler.SaveToRegistry("SchemaName", SchemaName);
}
private static DatabaseMessageObject GetDatabaseMessage(string connectionString, string sql)
{
string message = "";
bool success = false;
DatabaseOperation databaseOperation = new DatabaseOperation();
SqlConnectionStringBuilder tempConnString = new SqlConnectionStringBuilder(connectionString);
tempConnString.Password = ConnectionStringSecurity.Decode(tempConnString.Password);
databaseOperation.InitializeDal(tempConnString.ToString());
ErrorFormParams errorFormParams = databaseOperation.GetErrorFormParams();
if (errorFormParams != null)
{
message = errorFormParams.Message;
}
else
{
try
{
DataTable dataTable = databaseOperation.ExecuteDataTable(sql);
if (dataTable != null)
{
message = dataTable.Rows[0]["Message"].ToString();
success = true;
}
}
catch (Exception ex)
{
message = ex.Message;
}
}
return(new DatabaseMessageObject(success, message));
}
public static void SaveConnection()
{
RegistryHandler.SaveToRegistry("ConnectionString", ConnectionStringSecurity.Encode(ConnectionStringToSave, "ConnectionString"));
RegistryHandler.SaveToRegistry("SaveConnectionString", SaveConnectionString);
RegistryHandler.SaveToRegistry("OfflineMode", OfflineModeToSave);
}
public static void LoadConfig()
{
ConnectionString = ConnectionStringSecurity.Decode(RegistryHandler.ReadFromRegistry("ConnectionString"), "ConnectionString");
if (ConnectionString == "")
{
ConnectionString = @"Data Source=SQLServerName\SQLServerInstance;Initial Catalog=master;Integrated Security=True";
}
ConnectionStringToSave = ConnectionStringSecurity.Decode(RegistryHandler.ReadFromRegistry("ConnectionString"), "ConnectionString");
if (ConnectionStringToSave == "")
{
ConnectionStringToSave = @"Data Source=SQLServerName\SQLServerInstance;Initial Catalog=master;Integrated Security=True";
}
SaveConnectionString = RegistryHandler.ReadFromRegistry("SaveConnectionString");
if (SaveConnectionString == "")
{
SaveConnectionString = "True";
}
WordWrap = RegistryHandler.ReadFromRegistry("WordWrap");
if (WordWrap == "")
{
WordWrap = "False";
}
if (TraceFileDirectory == null)
{
TraceFileDirectory = "";
}
EditWindowSize = RegistryHandler.ReadFromRegistry("EditWindowSize");
if (EditWindowSize == "")
{
EditWindowSize = GenericHelper.DefaultWindowSize;
}
EditorWindowSize = RegistryHandler.ReadFromRegistry("EditorWindowSize");
if (EditorWindowSize == "")
{
EditorWindowSize = GenericHelper.DefaultWindowSize;
}
CommandLineParametersWindowSize = RegistryHandler.ReadFromRegistry("CommandLineParametersWindowSize");
if (CommandLineParametersWindowSize == "")
{
CommandLineParametersWindowSize = GenericHelper.DefaultWindowSize;
}
MainWindowSize = RegistryHandler.ReadFromRegistry("MainWindowSize");
if (MainWindowSize == "")
{
MainWindowSize = GenericHelper.DefaultWindowSize;
}
ResultsWindowSize = RegistryHandler.ReadFromRegistry("ResultsWindowSize");
if (ResultsWindowSize == "")
{
ResultsWindowSize = GenericHelper.DefaultWindowSize;
}
ValueSubstitutorWindowSize = RegistryHandler.ReadFromRegistry("ValueSubstitutorWindowSize");
if (ValueSubstitutorWindowSize == "")
{
ValueSubstitutorWindowSize = GenericHelper.DefaultWindowSize;
}
EditorFontFamily = RegistryHandler.ReadFromRegistry("EditorFontFamily");
if (EditorFontFamily == "")
{
EditorFontFamily = "Courier New";
}
EditorFontSize = RegistryHandler.ReadFromRegistry("EditorFontSize");
if (EditorFontSize == "")
{
EditorFontSize = "10";
}
DefaultStylesheet = RegistryHandler.ReadFromRegistry("DefaultStylesheet");
if (DefaultStylesheet == "")
{
DefaultStylesheet = "Graphs";
}
UseExtendedEvents = RegistryHandler.ReadFromRegistry("UseExtendedEvents");
if (UseExtendedEvents == "")
{
UseExtendedEvents = "";
}
IgnoreErrors = RegistryHandler.ReadFromRegistry("IgnoreErrors");
OfflineMode = RegistryHandler.ReadFromRegistry("OfflineMode");
if (OfflineMode == "")
{
OfflineMode = "False";
}
OfflineModeToSave = RegistryHandler.ReadFromRegistry("OfflineModeToSave");
if (OfflineModeToSave == "")
{
OfflineModeToSave = "False";
}
CheckForUpdatesOnStart = RegistryHandler.ReadFromRegistry("CheckForUpdatesOnStart");
if (CheckForUpdatesOnStart == "")
{
CheckForUpdatesOnStart = "True";
}
string installed = RegistryHandler.ReadFromRegistry("Installed", Registry.CurrentUser);
if (installed == "1")
{
SaveConfig(); // To set default values in registry
if (TaskHelper.TaskCollection.Tasks.Count == 0)
{
TaskHelper.TaskCollection.Description = "No Task Collection loaded.\r\nTo load or create a Task Collection choose \"Options\", \"Task Collection Editor...\".";
TaskHelper.TaskCollection.Connections = 1;
TaskHelper.TaskCollection.PerformanceCountersSamplingInterval = 0;
TaskHelper.TaskCollection.TimeBetweenConnections = 0;
}
if (StylesheetHelper.StylesheetCollection.Stylesheets.Count == 0)
{
StylesheetHelper.StylesheetCollection = StylesheetHelper.XmlToStylesheetCollection(PerformanceTestTool.Properties.Resources.DefaultStylesheets);
}
SessionHelper.SaveSession();
RegistryHandler.SaveToRegistry("Installed", "2", Registry.CurrentUser);
}
UpdateServiceUrl = RegistryHandler.ReadFromRegistry("UpdateServiceUrl");
if (UpdateServiceUrl == "")
{
UpdateServiceUrl = "http://virtcore.com/VirtcoreService.asmx";
RegistryHandler.SaveToRegistry("UpdateServiceUrl", UpdateServiceUrl);
}
}
public static void LoadConfig()
{
ConnectionString = ConnectionStringSecurity.Decode(RegistryHandler.ReadFromRegistry("ConnectionString"), "ConnectionString");
if (ConnectionString == "")
{
ConnectionString = @"Data Source=SQLServerName\SQLServerInstance;Initial Catalog=master;Integrated Security=True";
}
ConnectionStringToSave = ConnectionStringSecurity.Decode(RegistryHandler.ReadFromRegistry("ConnectionString"), "ConnectionString");
if (ConnectionStringToSave == "")
{
ConnectionStringToSave = @"Data Source=SQLServerName\SQLServerInstance;Initial Catalog=master;Integrated Security=True";
}
SaveConnectionString = RegistryHandler.ReadFromRegistry("SaveConnectionString");
if (SaveConnectionString == "")
{
SaveConnectionString = "True";
}
DescriptionFields = XmlToDescriptionFields(RegistryHandler.ReadFromRegistry("DescriptionFields"));
DescriptionTemplates = XmlToDescriptionTemplates(RegistryHandler.ReadFromRegistry("DescriptionTemplates"));
WindowSize = RegistryHandler.ReadFromRegistry("WindowSize");
if (WindowSize == "")
{
WindowSize = "822; 555";
}
SplitterDistanceVertical = RegistryHandler.ReadFromRegistry("SplitterDistanceVertical");
if (SplitterDistanceVertical == "")
{
SplitterDistanceVertical = "216";
}
SplitterDistanceHorizontal = RegistryHandler.ReadFromRegistry("SplitterDistanceHorizontal");
if (SplitterDistanceHorizontal == "")
{
SplitterDistanceHorizontal = "200";
}
TextDataFontFamily = RegistryHandler.ReadFromRegistry("TextDataFontFamily");
if (TextDataFontFamily == "")
{
TextDataFontFamily = "Courier New";
}
TextDataFontSize = RegistryHandler.ReadFromRegistry("TextDataFontSize");
if (TextDataFontSize == "")
{
TextDataFontSize = "10";
}
DescriptionFontFamily = RegistryHandler.ReadFromRegistry("DescriptionFontFamily");
if (DescriptionFontFamily == "")
{
DescriptionFontFamily = "Courier New";
}
DescriptionFontSize = RegistryHandler.ReadFromRegistry("DescriptionFontSize");
if (DescriptionFontSize == "")
{
DescriptionFontSize = "10";
}
CheckForUpdatesOnStart = RegistryHandler.ReadFromRegistry("CheckForUpdatesOnStart");
if (CheckForUpdatesOnStart == "")
{
CheckForUpdatesOnStart = "True";
}
ShowDdlScript = RegistryHandler.ReadFromRegistry("ShowDdlScript");
if (ShowDdlScript == "")
{
ShowDdlScript = "True";
}
SchemaName = RegistryHandler.ReadFromRegistry("SchemaName");
if (SchemaName == "")
{
SchemaName = "dbo";
}
UpdateServiceUrl = RegistryHandler.ReadFromRegistry("UpdateServiceUrl");
if (UpdateServiceUrl == "")
{
UpdateServiceUrl = "http://virtcore.com/VirtcoreService.asmx";
RegistryHandler.SaveToRegistry("UpdateServiceUrl", UpdateServiceUrl);
}
}
private static string DecodeConnectionStringPassword(string encryptedPassword)
{
return(ConnectionStringSecurity.Decode(encryptedPassword));
}
public static void LoadConfig()
{
ConnectionString = ConnectionStringSecurity.DecodeConnectionString(RegistryHandler.ReadFromRegistry("ConnectionString"), "ConnectionString");
if (ConnectionString == "")
{
ConnectionString = @"Data Source=SQLServerName\SQLServerInstance;Initial Catalog=master;Integrated Security=True";
}
ConnectionStringToSave = ConnectionStringSecurity.DecodeConnectionString(RegistryHandler.ReadFromRegistry("ConnectionString"), "ConnectionString");
if (ConnectionStringToSave == "")
{
ConnectionStringToSave = @"Data Source=SQLServerName\SQLServerInstance;Initial Catalog=master;Integrated Security=True";
}
SaveConnectionString = RegistryHandler.ReadFromRegistry("SaveConnectionString");
if (SaveConnectionString == "")
{
SaveConnectionString = "True";
}
TextDataFontFamily = RegistryHandler.ReadFromRegistry("TextDataFontFamily");
if (TextDataFontFamily == "")
{
TextDataFontFamily = "Courier New";
}
TextDataFontSize = RegistryHandler.ReadFromRegistry("TextDataFontSize");
if (TextDataFontSize == "")
{
TextDataFontSize = "10";
}
EditorFontFamily = RegistryHandler.ReadFromRegistry("EditorFontFamily");
if (EditorFontFamily == "")
{
EditorFontFamily = "Courier New";
}
EditorFontSize = RegistryHandler.ReadFromRegistry("EditorFontSize");
if (EditorFontSize == "")
{
EditorFontSize = "10";
}
WindowSize = RegistryHandler.ReadFromRegistry("WindowSize");
if (WindowSize == "")
{
WindowSize = "900; 680";
}
SplitterDistance = RegistryHandler.ReadFromRegistry("SplitterDistance");
if (SplitterDistance == "")
{
SplitterDistance = "271";
}
ColumnEditorWindowSize = RegistryHandler.ReadFromRegistry("ColumnEditorWindowSize");
if (ColumnEditorWindowSize == "")
{
ColumnEditorWindowSize = "900; 680";
}
ColumnEditorSplitterDistance = RegistryHandler.ReadFromRegistry("ColumnEditorSplitterDistance");
if (ColumnEditorSplitterDistance == "")
{
ColumnEditorSplitterDistance = "271";
}
ColumnsWindowSize = RegistryHandler.ReadFromRegistry("ColumnsWindowSize");
if (ColumnsWindowSize == "")
{
ColumnsWindowSize = "900; 680";
}
ViewStatisticsWindowSize = RegistryHandler.ReadFromRegistry("ViewStatisticsWindowSize");
if (ViewStatisticsWindowSize == "")
{
ViewStatisticsWindowSize = "900; 680";
}
ViewRowWindowSize = RegistryHandler.ReadFromRegistry("ViewRowWindowSize");
if (ViewRowWindowSize == "")
{
ViewRowWindowSize = "900; 680";
}
TimelineWindowSize = RegistryHandler.ReadFromRegistry("TimelineWindowSize");
if (TimelineWindowSize == "")
{
TimelineWindowSize = "900; 680";
}
if (RegistryHandler.ReadFromRegistry("ItemsPerPage") == "")
{
ItemsPerPage = 50;
}
else
{
ItemsPerPage = Convert.ToInt32(RegistryHandler.ReadFromRegistry("ItemsPerPage"));
}
Language = RegistryHandler.ReadFromRegistry("Language");
if (Language == "")
{
Language = "english";
}
if (RegistryHandler.ReadFromRegistry("ShowHiddenColumns") == "")
{
ShowHiddenColumns = false;
}
else
{
ShowHiddenColumns = Convert.ToBoolean(RegistryHandler.ReadFromRegistry("ShowHiddenColumns"));
}
if (RecordTraceFileDir == null)
{
RecordTraceFileDir = "";
}
if (RegistryHandler.ReadFromRegistry("KeepSessionOnExit") == "")
{
KeepSessionOnExit = false;
}
else
{
KeepSessionOnExit = Convert.ToBoolean(RegistryHandler.ReadFromRegistry("KeepSessionOnExit"));
}
if (RegistryHandler.ReadFromRegistry("EnableFileNameAndType") == "")
{
EnableFileNameAndType = false;
}
else
{
EnableFileNameAndType = Convert.ToBoolean(RegistryHandler.ReadFromRegistry("EnableFileNameAndType"));
}
if (RegistryHandler.ReadFromRegistry("EnableQuickSearch") == "")
{
EnableQuickSearch = false;
}
else
{
EnableQuickSearch = Convert.ToBoolean(RegistryHandler.ReadFromRegistry("EnableQuickSearch"));
}
if (RegistryHandler.ReadFromRegistry("AutoPopulateFilter2") == "")
{
AutoPopulateFilter2 = false;
}
else
{
AutoPopulateFilter2 = Convert.ToBoolean(RegistryHandler.ReadFromRegistry("AutoPopulateFilter2"));
}
if (RegistryHandler.ReadFromRegistry("MaxGraphRows") == "")
{
MaxGraphRows = 1000;
}
else
{
MaxGraphRows = Convert.ToInt32(RegistryHandler.ReadFromRegistry("MaxGraphRows"));
}
UseExtendedEvents = RegistryHandler.ReadFromRegistry("UseExtendedEvents");
if (UseExtendedEvents == "")
{
UseExtendedEvents = "";
}
CheckForUpdatesOnStart = RegistryHandler.ReadFromRegistry("CheckForUpdatesOnStart");
if (CheckForUpdatesOnStart == "")
{
CheckForUpdatesOnStart = "True";
}
DatabaseName = RegistryHandler.ReadFromRegistry("DatabaseName");
if (DatabaseName == "")
{
DatabaseName = "SQLEventAnalyzer";
}
UpdateServiceUrl = RegistryHandler.ReadFromRegistry("UpdateServiceUrl");
if (UpdateServiceUrl == "")
{
UpdateServiceUrl = "http://virtcore.com/VirtcoreService.asmx";
if (RegistryModifyAccess)
{
RegistryHandler.SaveToRegistry("UpdateServiceUrl", UpdateServiceUrl);
}
}
}
