/// <summary>The entry point for the application.</summary> /// <param name="argv">A list of arguments</param> public static void Main(String[] argv) { Boolean booleanParseCommandLineArguments = false; String exceptionMessage = null; StringBuilder internetDictionaryProjectIDPSQL = null; StringBuilder internetDictionaryProjectIDPQuery = null; IDataReader iDataReader = null; InternetDictionaryProjectIDPArgument internetDictionaryProjectIDPArgument = null; internetDictionaryProjectIDPArgument = new InternetDictionaryProjectIDPArgument(); booleanParseCommandLineArguments = UtilityParseCommandLineArgument.ParseCommandLineArguments ( argv, internetDictionaryProjectIDPArgument ); if (booleanParseCommandLineArguments == false) { // error encountered in arguments. Display usage message UtilityDebug.Write ( UtilityParseCommandLineArgument.CommandLineArgumentsUsage(typeof(InternetDictionaryProjectIDPArgument)) ); return; }//if ( booleanParseCommandLineArguments == false ) if (internetDictionaryProjectIDPArgument.DataFile != null && internetDictionaryProjectIDPArgument.DataFile.Length != 0) { FileImport ( ref DatabaseConnectionString, ref internetDictionaryProjectIDPArgument, ref exceptionMessage ); }//if ( internetDictionaryProjectIDPArgument.DataFile != null && internetDictionaryProjectIDPArgument.DataFile != String.Empty ) Query ( ref DatabaseConnectionString, ref exceptionMessage, ref internetDictionaryProjectIDPArgument, ref internetDictionaryProjectIDPSQL, ref internetDictionaryProjectIDPQuery, ref iDataReader ); }//main()
}//public String SpanishCommentary /// <summary>ButtonSubmit_Click().</summary> public void ButtonSubmit_Click ( Object sender, EventArgs e ) { String exceptionMessage = null; StringBuilder internetDictionaryProjectIDPSQL = null; StringBuilder internetDictionaryProjectIDPQuery = null; IDataReader iDataReader = null; InternetDictionaryProjectIDPArgument internetDictionaryProjectIDPArgument = null; internetDictionaryProjectIDPArgument = new InternetDictionaryProjectIDPArgument ( EnglishWord, FrenchCommentary, GermanCommentary, ItalianCommentary, LatinCommentary, PortugueseCommentary, SpanishCommentary ); InternetDictionaryProjectIDP.ConfigurationXml ( ref FilenameConfigurationXml, ref exceptionMessage, ref DatabaseConnectionString, ref DatabaseFile ); if ( exceptionMessage != null ) { Feedback = exceptionMessage; return; }//if ( exceptionMessage != null ) InternetDictionaryProjectIDP.Query ( ref DatabaseConnectionString, ref exceptionMessage, ref internetDictionaryProjectIDPArgument, ref internetDictionaryProjectIDPSQL, ref internetDictionaryProjectIDPQuery, ref iDataReader ); if ( exceptionMessage != null || iDataReader == null ) { Feedback = exceptionMessage; return; }//if ( exceptionMessage != null || iDataReader == null ) RepeaterInternetDictionaryProjectIDP.DataSource = iDataReader; RepeaterInternetDictionaryProjectIDP.DataBind(); }//public void ButtonSubmit_Click()
}//public static void FileImport() /// <summary>Query.</summary> public static void Query ( ref String databaseConnectionString, ref String exceptionMessage, ref InternetDictionaryProjectIDPArgument internetDictionaryProjectIDPArgument, ref StringBuilder internetDictionaryProjectIDPSQL, ref StringBuilder internetDictionaryProjectIDPQuery, ref IDataReader iDataReader ) { String internetDictionaryProjectIDPResult = null; Type typeInternetDictionaryProjectIDPArgument = internetDictionaryProjectIDPArgument.GetType(); UtilityProperty.TypeInformation ( internetDictionaryProjectIDPArgument, ref typeInternetDictionaryProjectIDPArgument, ref internetDictionaryProjectIDPQuery, ref DictionaryLanguageSQLQuery ); internetDictionaryProjectIDPSQL = new StringBuilder(SQLStatementDictionarySelect); internetDictionaryProjectIDPSQL.Append(SQLStatementDictionaryFrom); if (internetDictionaryProjectIDPQuery != null) { internetDictionaryProjectIDPSQL.Append(SQLStatementDictionaryWhere); internetDictionaryProjectIDPSQL.Append(internetDictionaryProjectIDPQuery); }//if ( internetDictionaryProjectIDPQuery != null ) internetDictionaryProjectIDPSQL.Append(SQLStatementDictionaryOrder); UtilityDebug.Write(internetDictionaryProjectIDPSQL); try { UtilityDatabase.DatabaseQuery ( databaseConnectionString, ref exceptionMessage, ref iDataReader, internetDictionaryProjectIDPSQL.ToString(), CommandType.Text ); #if (DEBUG) while (iDataReader.Read()) { internetDictionaryProjectIDPResult = String.Format ( SQLStatementDictionaryFormat, iDataReader.GetValue(0), iDataReader.GetValue(1), iDataReader.GetValue(2), iDataReader.GetValue(3), iDataReader.GetValue(4), iDataReader.GetValue(5), iDataReader.GetValue(6) ); UtilityDebug.Write(internetDictionaryProjectIDPResult); } //while( iDataReader.Read() ) #endif } //try catch (Exception exception) { System.Console.WriteLine("Exception: {0}", exception.Message); } //catch (Exception exception) } //public static void Query()
}//main() ///<summary>Stub.</summary> public static void FileImport ( ref String databaseConnectionString, ref InternetDictionaryProjectIDPArgument internetDictionaryProjectIDPArgument, ref String exceptionMessage ) { bool[] databaseTruncate = null; int dataFileIndex = 0; int dictionaryCommentaryIndex = -1; int dictionaryLanguageIndex = -1; int dictionaryLanguageIndexFirst = -1; int dictionaryLanguageIndexSecond = -1; int dictionaryLanguageIndexPosition = -1; int dictionaryLanguageIndexPositionFirst = -1; int dictionaryLanguageIndexPositionSecond = -1; String databaseStatementUpdate = null; String databaseStatementTruncate = null; String dictionaryWord = null; String dictionaryCommentary = null; String directoryNameRoot = null; String fileNameCurrent = null; String fileNamePattern = null; String streamRecord = null; ArrayList arrayListDirectoryName = null; ArrayList arrayListFileName = null; OleDbConnection oleDbConnection = null; databaseTruncate = new bool[DictionaryLanguage.Length]; oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize ( databaseConnectionString, ref exceptionMessage ); try { for (dataFileIndex = 0; dataFileIndex < internetDictionaryProjectIDPArgument.dataFile.Length; ++dataFileIndex) { UtilityDirectory.Dir ( ref internetDictionaryProjectIDPArgument.dataFile[dataFileIndex], ref directoryNameRoot, ref fileNamePattern, ref arrayListDirectoryName, ref arrayListFileName ); foreach (object fileNameObject in arrayListFileName) { fileNameCurrent = fileNameObject.ToString(); dictionaryLanguageIndexFirst = -1; dictionaryLanguageIndexPositionFirst = 0; dictionaryLanguageIndexSecond = -1; dictionaryLanguageIndexPositionSecond = 0; for (dictionaryLanguageIndex = 0; dictionaryLanguageIndex < DictionaryLanguage.Length; ++dictionaryLanguageIndex) { dictionaryLanguageIndexPosition = fileNameCurrent.IndexOf(DictionaryLanguage[dictionaryLanguageIndex]); if (dictionaryLanguageIndexPosition < 0) { continue; }//if ( dictionaryLanguageIndexPosition < 0 ) else if (dictionaryLanguageIndexFirst <= -1) { dictionaryLanguageIndexPositionFirst = dictionaryLanguageIndexPosition; dictionaryLanguageIndexFirst = dictionaryLanguageIndex; }//else if ( dictionaryLanguageIndexFirst <= -1 ) else if (dictionaryLanguageIndexPosition < dictionaryLanguageIndexPositionFirst) { dictionaryLanguageIndexPositionSecond = dictionaryLanguageIndexPositionFirst; dictionaryLanguageIndexPositionFirst = dictionaryLanguageIndexPosition; dictionaryLanguageIndexSecond = dictionaryLanguageIndexFirst; dictionaryLanguageIndexFirst = dictionaryLanguageIndex; }//else if ( dictionaryLanguageIndexPositionFirst < 0 ) else { dictionaryLanguageIndexPositionSecond = dictionaryLanguageIndexPosition; dictionaryLanguageIndexSecond = dictionaryLanguageIndex; } //else } //for ( dictionaryLanguageIndex = 0; dictionaryLanguageIndex <= DictionaryLanguage.Length; ++dictionaryLanguageIndex ) /* * UtilityDebug.Write * ( * String.Format * ( * "Language First: {0} | Second: {1} | First Position: {2} | Second Position: {3}", * DictionaryLanguage[dictionaryLanguageIndexFirst], * DictionaryLanguage[dictionaryLanguageIndexSecond], * dictionaryLanguageIndexPositionFirst, * dictionaryLanguageIndexPositionSecond * ) * ); */ if (internetDictionaryProjectIDPArgument.TableTruncate && databaseTruncate[dictionaryLanguageIndexFirst] == false) { databaseTruncate[dictionaryLanguageIndexFirst] = true; databaseStatementTruncate = String.Format ( SQLStatementDictionaryTruncate, DictionaryLanguage[dictionaryLanguageIndexFirst] + "Dictionary" ); UtilityDebug.Write(databaseStatementTruncate); UtilityDatabase.DatabaseNonQuery ( oleDbConnection, ref exceptionMessage, databaseStatementTruncate ); } ;//if ( internetDictionaryProjectIDPArgument.TableTruncate ) // Create an instance of StreamReader to read from a file. // The using statement also closes the StreamReader. using (StreamReader streamReader = new StreamReader(fileNameCurrent)) { while (true) { //Read and display lines from the file until the end of the file is reached. streamRecord = streamReader.ReadLine(); if (streamRecord == null) { break; }//if ( streamRecord == null ) UtilityDebug.Write ( String.Format ( "streamRecord: {0}", streamRecord ) ); if (streamRecord[0] == '#') { continue; }//if ( streamRecord[0] == '#' ) dictionaryCommentaryIndex = streamRecord.IndexOf('\t'); if (dictionaryCommentaryIndex <= -1) { continue; }//if ( dictionaryCommentaryIndex <= -1 ) dictionaryWord = streamRecord.Substring(0, dictionaryCommentaryIndex); dictionaryCommentary = (streamRecord.Substring(dictionaryCommentaryIndex)).Trim(); databaseStatementUpdate = String.Format ( SQLStatementDictionaryUpdate, DictionaryLanguage[dictionaryLanguageIndexFirst] + "Word", DictionaryLanguage[dictionaryLanguageIndexFirst] + "Dictionary", dictionaryWord, DictionaryLanguage[dictionaryLanguageIndexSecond] + "Commentary", dictionaryCommentary ); UtilityDebug.Write(databaseStatementUpdate); UtilityDatabase.DatabaseNonQuery ( oleDbConnection, ref exceptionMessage, databaseStatementUpdate ); } //while ( true ) } //using (StreamReader streamReader = new StreamReader(fileNameCurrent)) } //foreach ( object fileNameCurrent in arrayListFileName ) } //for ( dataFileIndex = 0; dataFileIndex < internetDictionaryProjectIDPArgument.dataFile.Length; ++dataFileIndex ) } //try catch (Exception exception) { UtilityDebug.Write ( String.Format ( "Exception: {0}", exception.Message ) ); }//catch ( Exception exception ) UtilityDatabase.DatabaseConnectionHouseKeeping ( oleDbConnection, ref exceptionMessage ); }//public static void FileImport()