//common form processing routines private void SetHelpFile() { string executableFolder = new Uri(System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)).LocalPath; string helpFileName = AppConfig.GetStringValueFromConfigFile("HelpFileName", "InitWinFormsHelpFile.chm"); string helpFilePath = PFFile.FormatFilePath(executableFolder, helpFileName); this.appHelpProvider.HelpNamespace = helpFilePath; _helpFilePath = helpFilePath; }
//event handlers private void QueryBuilderForm_Load(object sender, EventArgs e) { string executableFolder = new Uri(System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)).LocalPath; string helpFileName = AppConfig.GetStringValueFromConfigFile("QBFHelpFileName", "QbfUsersGuide.chm"); //string helpFileName = AppConfig.GetStringValueFromConfigFile("HelpFileName", "InitWinFormsHelpFile.chm"); string helpFilePath = PFFile.FormatFilePath(executableFolder, helpFileName); this.qbfHelpProvider.HelpNamespace = helpFilePath; _helpFilePath = helpFilePath; }
internal void SetHelpFileValues() { string configValue = string.Empty; string executableFolder = new Uri(System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)).LocalPath; string helpFileName = AppConfig.GetStringValueFromConfigFile("HelpFileName", "pfFolderSize.chm"); string helpFilePath = PFFile.FormatFilePath(executableFolder, helpFileName); this.tableNamesHelpProvider.HelpNamespace = helpFilePath; _helpFilePath = helpFilePath; }
private void MainForm_Load(object sender, EventArgs e) { string configValue = string.Empty; try { //this.Text = AppInfo.AssemblyProduct; this.Text = StaticKeysSection.Settings.MainFormCaption; configValue = AppGlobals.AppConfig.GetConfigValue("SaveErrorMessagesToErrorLog"); if (configValue.ToUpper() == "TRUE") { _saveErrorMessagesToAppLog = true; } else { _saveErrorMessagesToAppLog = false; } _appLogFileName = AppGlobals.AppConfig.GetConfigValue("AppLogFileName"); if (_appLogFileName.Trim().Length > 0) { AppGlobals.AppMessages.AppLogFilename = _appLogFileName; } string executableFolder = new Uri(System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)).LocalPath; string helpFileName = AppConfig.GetStringValueFromConfigFile("HelpFileName", "InitWinFormsHelpFile.chm"); string helpFilePath = PFFile.FormatFilePath(executableFolder, helpFileName); this.appHelpProvider.HelpNamespace = helpFilePath; _helpFilePath = helpFilePath; this.chkEraseOutputBeforeEachTest.Checked = true; this.optUseXmlFiles.Checked = true; InitForm(); _mfp = new MainFormProcessor(this); configValue = AppGlobals.AppConfig.GetStringValueFromConfigFile("TaskDefsDbConnectionString", string.Empty); if (configValue.Length > 0) { _taskDefsDbConnectionString = configValue; } } catch (System.Exception ex) { _msg.Length = 0; _msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex)); Program._messageLog.WriteLine(_msg.ToString()); AppMessages.DisplayErrorMessage(_msg.ToString(), _saveErrorMessagesToAppLog); } }
private bool VerifyColumnValue(string currAppSetting, string currValue) { bool isValid = true; _verifyDataMessages.Length = 0; _verifyDataMessages.Append("Value for "); _verifyDataMessages.Append(currAppSetting); _verifyDataMessages.Append(" changed to "); _verifyDataMessages.Append(currValue); _verifyDataMessages.Append("."); switch (currAppSetting) { case "SaveErrorMessagesToErrorLog": if (IsValidBoolean(currValue) == false) { _verifyDataMessages.Length = 0; _verifyDataMessages.Append("Invalid value for "); _verifyDataMessages.Append(currAppSetting); _verifyDataMessages.Append(": "); _verifyDataMessages.Append(currValue); _verifyDataMessages.Append("."); isValid = false; } break; case "ApplicationLogFileName": if (PFFile.IsValidPath(currValue) == false) { _verifyDataMessages.Length = 0; _verifyDataMessages.Append("Invalid value for "); _verifyDataMessages.Append(currAppSetting); _verifyDataMessages.Append(": "); _verifyDataMessages.Append(currValue); _verifyDataMessages.Append("."); isValid = false; } break; default: break; } return(isValid); }
public static void CreateDatabaseTest(MainForm frm) { PFSQLAnywhereUL sqlu = new PFSQLAnywhereUL(); string connectionString = string.Empty; try { _msg.Length = 0; _msg.Append("CreateDatabaseTest started ...\r\n"); Program._messageLog.WriteLine(_msg.ToString()); if (frm.txtDatabaseFile.Text.Trim().Length == 0) { _msg.Length = 0; _msg.Append("You must specify a database file name for Create Database Test."); throw new DataException(_msg.ToString()); } sqlu.DatabasePath = frm.txtDatabaseFile.Text; sqlu.DatabaseName = frm.txtDatabaseName.Text; sqlu.Username = frm.txtUsername.Text; sqlu.Password = frm.txtPassword.Text; sqlu.DatabaseKey = frm.txtDatabaseKey.Text; connectionString = sqlu.ConnectionString; _msg.Length = 0; _msg.Append("Connection string is: \r\n"); _msg.Append(connectionString); Program._messageLog.WriteLine(_msg.ToString()); sqlu.OpenConnection(); if (File.Exists(@"c:\temp\newSQL.udb")) { PFFile.FileDelete(@"c:\temp\newSQL.udb"); } if (File.Exists(@"c:\temp\newSQLenc.udb")) { PFFile.FileDelete(@"c:\temp\newSQLenc.udb"); } sqlu.CreateDatabase(@"c:\temp\newSQL.udb", false, string.Empty); sqlu.CreateDatabase(@"c:\temp\newSQLenc.udb", true, "testkey"); } catch (System.Exception ex) { _msg.Length = 0; _msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex)); Program._messageLog.WriteLine(_msg.ToString()); AppMessages.DisplayErrorMessage(_msg.ToString(), _saveErrorMessagesToAppLog); } finally { if (sqlu != null) { if (sqlu.IsConnected) { sqlu.CloseConnection(); } } sqlu = null; _msg.Length = 0; _msg.Append("\r\n... CreateDatabaseTest finished."); Program._messageLog.WriteLine(_msg.ToString()); } }
private void MainForm_Load(object sender, EventArgs e) { string configValue = string.Empty; try { this.Text = AppInfo.AssemblyProduct; configValue = AppGlobals.AppConfig.GetConfigValue("SaveErrorMessagesToErrorLog"); if (configValue.ToUpper() == "TRUE") { _saveErrorMessagesToAppLog = true; } else { _saveErrorMessagesToAppLog = false; } _appLogFileName = AppGlobals.AppConfig.GetConfigValue("AppLogFileName"); if (_appLogFileName.Trim().Length > 0) { AppGlobals.AppMessages.AppLogFilename = _appLogFileName; } string executableFolder = new Uri(System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)).LocalPath; string helpFileName = AppConfig.GetStringValueFromConfigFile("HelpFileName", "InitWinFormsHelpFile.chm"); string helpFilePath = PFFile.FormatFilePath(executableFolder, helpFileName); this.appHelpProvider.HelpNamespace = helpFilePath; _helpFilePath = helpFilePath; this.chkEraseOutputBeforeEachTest.Checked = true; _saveMruListToRegistry = AppConfig.GetBooleanValueFromConfigFile("SaveMruListToRegistry", "True"); _mRUListSaveFileSubFolder = AppConfig.GetStringValueFromConfigFile("MRUListSaveFileSubFolder", @"PFApps\InitWinFormsAppWithToolbar\Mru\"); _mRUListSaveRegistryKey = AppConfig.GetStringValueFromConfigFile("MRUListSaveRegistryKey", @"SOFTWARE\PFApps\InitWinFormsAppWithToolbar"); _maxMruListEntries = AppConfig.GetIntValueFromConfigFile("MaxMruListEntries", (int)4); _useSubMenuForMruList = AppConfig.GetBooleanValueFromConfigFile("UseSubMenuForMruList", "true"); if (_saveMruListToRegistry) { if (_useSubMenuForMruList) { _msm = new MruStripMenu(mnuFileRecent, new MruStripMenu.ClickedHandler(OnMruFile), _mRUListSaveRegistryKey + "\\MRU", false, _maxMruListEntries); } else { //use inline _msm = new MruStripMenuInline(mnuFile, mnuFileRecent, new MruStripMenu.ClickedHandler(OnMruFile), _mRUListSaveRegistryKey + "\\MRU", _maxMruListEntries); } _msm.LoadFromRegistry(); } else { //load from and save to the file system if (_useSubMenuForMruList) { _msm = new MruStripMenu(mnuFileRecent, new MruStripMenu.ClickedHandler(OnMruFile), _maxMruListEntries); } else { //use inline _msm = new MruStripMenuInline(mnuFile, mnuFileRecent, new MruStripMenu.ClickedHandler(OnMruFile), _maxMruListEntries); } _msm.FileSystemMruPath = _mRUListSaveFileSubFolder; _msm.LoadFromFileSystem(); } } catch (System.Exception ex) { _msg.Length = 0; _msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex)); Program._messageLog.WriteLine(_msg.ToString()); AppMessages.DisplayErrorMessage(_msg.ToString(), _saveErrorMessagesToAppLog); } }
private void MainForm_Load(object sender, EventArgs e) { string configValue = string.Empty; try { this.Text = AppInfo.AssemblyProduct; configValue = AppGlobals.AppConfig.GetConfigValue("SaveErrorMessagesToErrorLog"); if (configValue.ToUpper() == "TRUE") { _saveErrorMessagesToAppLog = true; } else { _saveErrorMessagesToAppLog = false; } _appLogFileName = AppGlobals.AppConfig.GetConfigValue("AppLogFileName"); if (_appLogFileName.Trim().Length > 0) { AppGlobals.AppMessages.AppLogFilename = _appLogFileName; } string executableFolder = new Uri(System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)).LocalPath; string helpFileName = AppConfig.GetStringValueFromConfigFile("HelpFileName", "InitWinFormsHelpFile.chm"); string helpFilePath = PFFile.FormatFilePath(executableFolder, helpFileName); this.appHelpProvider.HelpNamespace = helpFilePath; _helpFilePath = helpFilePath; this.chkEraseOutputBeforeEachTest.Checked = true; this.chkShowStackTraceOnError.Checked = false; this.chkUseIntegratedSecurity.Checked = true; this.chkUseAsyncProcessing.Checked = false; this.chkIsStoredProcedure.Checked = false; this.txtServerName.Text = "PROFASTSV2"; this.txtDatabaseName.Text = "AdventureWorksDW2008R2"; //this.txtDatabaseName.Text = "Miketest"; this.txtApplicationName.Text = "TestprogSQL"; this.txtWorkstationId.Text = Environment.MachineName; this.txtUsername.Text = string.Empty; this.txtPassword.Text = string.Empty; this.txtTableName.Text = "TestTable01"; this.txtSchemaName.Text = "dbo"; //_str.Length = 0; //_str.Append("select top 25"); //_str.Append("\r\n"); //_str.Append(" cGroup, cNumLow, cNumHigh, cCount, cName"); //_str.Append("\r\n"); //_str.Append(" from Namelists.dbo.tblUS_LastNames"); //this.txtSQLQuery.Text = _str.ToString(); _str.Length = 0; _str.Append("select LocKey=g.GeographyKey\r\n"); _str.Append(" ,g.City\r\n"); _str.Append(" ,[State]=g.StateProvinceName\r\n"); _str.Append(" ,Country=g.EnglishCountryRegionName\r\n"); _str.Append(" ,g.PostalCode\r\n"); _str.Append(" ,st.SalesTerritoryRegion\r\n"); _str.Append(" ,st.SalesTerritoryCountry\r\n"); _str.Append(" ,st.SalesTerritoryGroup\r\n"); _str.Append(" from dbo.DimGeography g\r\n"); _str.Append(" join dbo.DimSalesTerritory st\r\n"); _str.Append(" on g.SalesTerritoryKey = st.SalesTerritoryKey\r\n"); _str.Append(";"); this.txtSQLQuery.Text = _str.ToString(); LoadAppConfigItems(); } catch (System.Exception ex) { _msg.Length = 0; _msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex)); Program._messageLog.WriteLine(_msg.ToString()); AppMessages.DisplayErrorMessage(_msg.ToString(), _saveErrorMessagesToAppLog); } }