/// <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; AccountChartArgument accountChartArgument = null; accountChartArgument = new AccountChartArgument(); booleanParseCommandLineArguments = UtilityParseCommandLineArgument.ParseCommandLineArguments ( argv, accountChartArgument ); if (booleanParseCommandLineArguments == false) { // error encountered in arguments. Display usage message UtilityDebug.Write ( UtilityParseCommandLineArgument.CommandLineArgumentsUsage(typeof(AccountChartArgument)) ); return; }//if ( booleanParseCommandLineArguments == false ) if (accountChartArgument.DataFile != null && accountChartArgument.DataFile.Length != 0) { FileImport ( ref DatabaseConnectionString, ref accountChartArgument, ref exceptionMessage ); }//if ( accountChartArgument.DataFile != null && accountChartArgument.DataFile != String.Empty ) /* * Query * ( * ref DatabaseConnectionString, * ref exceptionMessage, * ref accountChartArgument, * ref internetDictionaryProjectIDPSQL, * ref internetDictionaryProjectIDPQuery, * ref iDataReader * ); */ }//main()
}//main() ///<summary>Stub.</summary> public static void FileImport ( ref String databaseConnectionString, ref AccountChartArgument accountChartArgument, ref String exceptionMessage ) { int dataFileIndex = 0; int sQLStatementAttributeIndex = -1; int sQLStatementAttributeIndexCurrent = -1; int streamRecordIndex = 0; String databaseStatementUpdate = null; String databaseStatementTruncate = null; String directoryNameRoot = null; String fileNameCurrent = null; String fileNamePattern = null; String streamColumn = null; String streamRecord = null; StringBuilder[] stringBuilderStreamColumn = null; ArrayList arrayListDirectoryName = null; ArrayList arrayListFileName = null; OleDbConnection oleDbConnection = null; stringBuilderStreamColumn = new StringBuilder[SQLStatementAttribute.Length]; oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize ( databaseConnectionString, ref exceptionMessage ); if (accountChartArgument.TableTruncate) { databaseStatementTruncate = String.Format ( SQLStatementTruncate, SQLStatementClass ); UtilityDebug.Write(databaseStatementTruncate); UtilityDatabase.DatabaseNonQuery ( oleDbConnection, ref exceptionMessage, databaseStatementTruncate ); }//if ( accountChartArgument.TableTruncate ) try { for (dataFileIndex = 0; dataFileIndex < accountChartArgument.dataFile.Length; ++dataFileIndex) { UtilityDirectory.Dir ( ref accountChartArgument.dataFile[dataFileIndex], ref directoryNameRoot, ref fileNamePattern, ref arrayListDirectoryName, ref arrayListFileName ); UtilityDebug.Write ( String.Format ( "accountChartArgument.dataFile[{0}]: {1}", dataFileIndex, accountChartArgument.dataFile[dataFileIndex] ) ); foreach (object fileNameObject in arrayListFileName) { fileNameCurrent = fileNameObject.ToString(); UtilityDebug.Write ( String.Format ( "fileNameCurrent: {0}", fileNameCurrent ) ); // 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 * ) * ); */ for ( sQLStatementAttributeIndex = 0; sQLStatementAttributeIndex < SQLStatementAttribute.Length; ++sQLStatementAttributeIndex ) { streamRecordIndex = streamRecord.IndexOf ( SQLStatementAttribute[sQLStatementAttributeIndex][SQLStatementAttributeRankName] ); if (streamRecordIndex == 0) { sQLStatementAttributeIndexCurrent = sQLStatementAttributeIndex; break; } //if ( streamRecordIndex == 0 ) } //for if (sQLStatementAttributeIndexCurrent == -1) { continue; }//if ( sQLStatementAttributeIndexCurrent == -1 ) streamRecord = streamRecord.Trim(); streamRecord = streamRecord.Replace("'", "''"); if (sQLStatementAttributeIndex < SQLStatementAttribute.Length) { streamColumn = streamRecord.Substring(SQLStatementAttribute[sQLStatementAttributeIndexCurrent][SQLStatementAttributeRankName].Length + 1); streamColumn = streamColumn.Trim(); stringBuilderStreamColumn[sQLStatementAttributeIndexCurrent] = new StringBuilder(streamColumn); } else { streamColumn = streamRecord.Trim(); stringBuilderStreamColumn[sQLStatementAttributeIndexCurrent].Append(streamColumn); } /* * UtilityDebug.Write * ( * String.Format * ( * "Name: {0} | Value: {1}", * SQLStatementAttribute[ sQLStatementAttributeIndexCurrent ][ SQLStatementAttributeRankName ], * stringBuilderStreamColumn[ sQLStatementAttributeIndexCurrent ] * ) * ); */ if (sQLStatementAttributeIndexCurrent != SQLStatementAttribute.Length - 1) { continue; }//if ( sQLStatementAttributeIndexCurrent < SQLStatementAttribute.Length - 1 ) databaseStatementUpdate = String.Format ( SQLStatementUpdate, SQLStatementClass, stringBuilderStreamColumn[SQLStatementAttributeIndexAccountNumber], SQLStatementAttribute[SQLStatementAttributeIndexAccountTitle][SQLStatementAttributeRankAlias], SQLStatementAttribute[SQLStatementAttributeIndexAccountNumber][SQLStatementAttributeRankAlias], SQLStatementAttribute[SQLStatementAttributeIndexNormalBalance][SQLStatementAttributeRankAlias], SQLStatementAttribute[SQLStatementAttributeIndexDefinition][SQLStatementAttributeRankAlias], stringBuilderStreamColumn[SQLStatementAttributeIndexAccountTitle], stringBuilderStreamColumn[SQLStatementAttributeIndexNormalBalance], stringBuilderStreamColumn[SQLStatementAttributeIndexDefinition] ); /* * UtilityDebug.Write( databaseStatementUpdate ); */ UtilityDatabase.DatabaseNonQuery ( oleDbConnection, ref exceptionMessage, databaseStatementUpdate ); if (exceptionMessage != null) { UtilityDebug.Write ( String.Format ( "databaseStatementUpdate: {0}", databaseStatementUpdate ) ); } } //while ( true ) } //using (StreamReader streamReader = new StreamReader(fileNameCurrent)) } //foreach ( object fileNameCurrent in arrayListFileName ) } //for ( dataFileIndex = 0; dataFileIndex < accountChartArgument.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()