public static void Main(string[] args)
{
int argumentCount = args.Length;
String exceptionMessage = null;
OleDbConnection oleDbConnection = null;
//Open the database connection.
oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize(DatabaseConnectionString, ref exceptionMessage);
TableProcessURI
(
ref oleDbConnection,
selectQueryUriChrist,
filenameUriHtmlChrist,
filenameUriTextChrist,
filenameUriXsdChrist,
filenameUriXmlChrist,
filenameUriXmlChrist2,
filenameUriXsltChrist
);
TableProcessURI
(
ref oleDbConnection,
selectQueryUriWordEngineering,
filenameUriHtmlWordEngineering,
filenameUriTextWordEngineering,
filenameUriXsdWordEngineering,
filenameUriXmlWordEngineering,
filenameUriXmlWordEngineering2,
filenameUriXsltWordEngineering
);
//Close the database connection.
UtilityDatabase.DatabaseConnectionHouseKeeping(oleDbConnection, ref exceptionMessage);
}//Main()
}//ConfigurationXml
/// <summary>Scripture Reference URI.</summary>
/// <param name="databaseConnectionString">The database connection string.</param>
/// <param name="filenameConfigurationXml">The filename configuration Xml.</param>
/// <param name="exceptionMessage">The exception message.</param>
/// <param name="dataSet">The dataset.</param>
public static void ScriptureReferenceURI
(
string databaseConnectionString,
string filenameConfigurationXml,
ref string exceptionMessage,
ref DataSet dataSet
)
{
bool boolView = false;
int columnIndexScriptureReference = -1;
string dataColumnName = null;
string scriptureReferenceColumnValue = null;
string scriptureReferenceColumnName = null;
string scriptureReferenceColumnNameURI = null;
string scriptureReferenceURI = null;
string[][] scriptureReferenceArray = null;
string columnNamePrimary = null;
string columnValuePrimary = null;
string tableName = null;
ArrayList scriptureReferenceSet = null;
ArrayList scriptureReferenceURISet = null;
ScriptureReferenceBookChapterVersePrePost[] scriptureReferenceBookChapterVersePrePost = null;
StringBuilder columnSet = null;
StringBuilder uriCrosswalkXml = null;
StringBuilder uriCrosswalkHtml = null;
StringBuilder SQLStatement = null;
OleDbConnection oleDbConnection = null;
XmlNodeList scriptureReferenceColumnSet = null;
scriptureReferenceColumnSet = UtilityXml.SelectNodes
(
filenameConfigurationXml,
ref exceptionMessage,
XPathColumnScriptureReference
);
try
{
oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize
(
databaseConnectionString,
ref exceptionMessage
);
foreach ( DataTable dataTable in dataSet.Tables )
{
columnIndexScriptureReference = UtilityDatabase.DataTableColumnIndex
(
dataTable,
"ScriptureReference"
);
if ( columnIndexScriptureReference < 0 )
{
continue;
}
tableName = dataTable.TableName;
scriptureReferenceSet = new ArrayList();
scriptureReferenceURISet = new ArrayList();
SQLStatement = new StringBuilder();
if ( tableName.IndexOf("View" ) < 0 )
{
boolView = false;
SQLStatement.AppendFormat
(
InformationSchemaColumnNamePrimaryColumnSQL,
tableName
);
}
else
{
boolView = true;
SQLStatement.AppendFormat
(
InformationSchemaColumnNamePrimaryColumnSQL,
tableName.Substring(4)
);
}
#if (DEBUG)
System.Console.WriteLine("SQLStatement: {0}", SQLStatement);
#endif
columnNamePrimary = (string) UtilityDatabase.DatabaseQuery
(
databaseConnectionString,
ref exceptionMessage,
SQLStatement.ToString(),
CommandType.Text
);
if ( boolView == true )
{
columnNamePrimary = String.Concat( tableName.Substring(4), columnNamePrimary );
}
#if (DEBUG)
System.Console.WriteLine("ColumnNamePrimary: {0}", columnNamePrimary);
#endif
foreach ( DataColumn dataColumn in dataTable.Columns )
{
dataColumnName = dataColumn.ColumnName.Trim();
/*
#if (DEBUG)
System.Console.WriteLine("Table Name: {0} | ColumnName: {1}", tableName, dataColumnName);
#endif
*/
if ( dataColumnName.IndexOf( ScriptureReferenceURIColumnNamePostfix ) >= 0 )
{
continue;
}
if ( dataColumnName.IndexOf( ScriptureReferenceColumnNamePostfix ) >= 0 )
{
scriptureReferenceSet.Add( dataColumnName );
scriptureReferenceColumnName = dataColumnName;
scriptureReferenceColumnNameURI = scriptureReferenceColumnName + "URI";
if ( dataTable.Columns.Contains( scriptureReferenceColumnNameURI ) == false )
{
/*
#if (DEBUG)
System.Console.WriteLine("Table Name: {0} | ColumnName: {1}", tableName, scriptureReferenceColumnNameURI);
#endif
*/
scriptureReferenceURISet.Add( scriptureReferenceColumnNameURI );
}//if dataTable.Columns.Contains( scriptureReferenceColumnNameURI ) == false )
}//if ( dataColumnName.IndexOf( ScriptureReferenceColumnNamePostfix ) >= 0 )
}//foreach ( DataColumn dataColumn in dataTable.Columns )
foreach ( object columnName in scriptureReferenceURISet )
{
scriptureReferenceColumnNameURI = columnName.ToString().Trim();
dataTable.Columns.Add( scriptureReferenceColumnNameURI );
}
foreach ( DataColumn dataColumn in dataTable.Columns )
{
dataColumnName = dataColumn.ColumnName.Trim();
/*
#if (DEBUG)
System.Console.WriteLine("Table Name: {0} | ColumnName: {1}", tableName, dataColumnName);
#endif
*/
}//foreach ( DataColumn dataColumn in dataTable.Columns )
foreach ( DataRow dataRow in dataTable.Rows )
{
columnValuePrimary = dataRow[columnNamePrimary].ToString().Trim();
columnSet = new StringBuilder();
/*
#if (DEBUG)
System.Console.WriteLine("ColumnValuePrimary: {0}", columnValuePrimary);
#endif
*/
foreach ( object columnName in scriptureReferenceSet )
{
#if (DEBUG)
System.Console.WriteLine("ColumnName: {0}", columnName);
#endif
scriptureReferenceColumnName = columnName.ToString().Trim();
scriptureReferenceColumnValue = dataRow[scriptureReferenceColumnName].ToString().Trim();
#if (DEBUG)
System.Console.WriteLine
(
"Scripture Reference Column Name: {0} | Value: {1}",
scriptureReferenceColumnName,
scriptureReferenceColumnValue
);
#endif
scriptureReferenceColumnNameURI = scriptureReferenceColumnName + "URI";
if ( scriptureReferenceColumnValue != null && scriptureReferenceColumnValue != string.Empty )
{
ScriptureReference.ScriptureReferenceParser
(
new string[] { scriptureReferenceColumnValue },
databaseConnectionString,
ref exceptionMessage,
ref scriptureReferenceBookChapterVersePrePost,
ref scriptureReferenceArray,
ref uriCrosswalkHtml,
ref uriCrosswalkXml
);//ScriptureReference.ScriptureReferenceParser()
scriptureReferenceURI = uriCrosswalkHtml.ToString();
if ( UtilityDatabase.DataSetTableColumnContains( dataSet, tableName, scriptureReferenceColumnNameURI ) == false )
{
UtilityDatabase.DataSetTableColumnAdd( dataSet, tableName, scriptureReferenceColumnNameURI );
dataRow[scriptureReferenceColumnNameURI] = scriptureReferenceURI;
continue;
}//if ( DataSetTableColumnContains( dataSet, dataTable, scriptureReferenceColumnNameURI ) )
dataRow[scriptureReferenceColumnNameURI] = scriptureReferenceURI;
if ( scriptureReferenceURISet.IndexOf( scriptureReferenceColumnNameURI ) >= 0 )
{
continue;
}
if ( columnSet.Length != 0 )
{
columnSet.Append(',');
}
columnSet.AppendFormat
(
UtilityDatabase.DatabaseTemplateSQLSet,
scriptureReferenceColumnNameURI,
scriptureReferenceURI
);
/*
#if (DEBUG)
System.Console.WriteLine("columnSet: {0}", columnSet);
#endif
*/
SQLStatement = new StringBuilder();
SQLStatement.AppendFormat
(
UtilityDatabase.DatabaseTemplateSQLUpdateScriptureReferenceURISet,
tableName,
columnSet,
columnNamePrimary,
columnValuePrimary
);
#if (DEBUG)
System.Console.WriteLine("SQL Statement: {0}", SQLStatement.ToString() );
#endif
UtilityDatabase.DatabaseNonQuery
(
oleDbConnection,
ref exceptionMessage,
SQLStatement.ToString()
);
}//if ( scriptureReferenceColumnValue != null && scriptureReferenceColumnValue != string.Empty )
}//foreach ( object columnName in dataTableColumnName )
}//foreach ( DataRow dataRow in dataTable )
}//foreach ( DataTable dataTable in dataSet )
UtilityDatabase.DatabaseConnectionHouseKeeping
(
oleDbConnection,
ref exceptionMessage
);
}//try
catch (OleDbException exception)
{
//exceptionMessage = exception.Message;
exceptionMessage = UtilityEventLog.WriteEntryOleDbErrorCollection( exception );
System.Console.WriteLine("OleDbException: {0}", exceptionMessage);
}//catch (OleDbException exception)
catch (SecurityException exception)
{
exceptionMessage = exception.Message;
System.Console.WriteLine( "SecurityException: {0}", exception.Message );
}//catch (SecurityException exception)
catch (SystemException exception)
{
exceptionMessage = exception.Message;
System.Console.WriteLine( "SystemException: {0}", exception.Message );
}//catch (SystemException exception)
catch (Exception exception)
{
exceptionMessage = exception.Message;
System.Console.WriteLine( "Exception: {0}", exception.Message );
}//catch (Exception exception)
}//public static void ScriptureReferenceURI()
}//public static void UtilityContact.ContactDetailSave()
///<summary>ContactImageUpdate</summary>
public static void ContactImageUpdate
(
ref string databaseConnectionString,
ref string exceptionMessage,
ref int sequenceOrderId,
ref DateTime dated,
ref int contactId,
ref byte[] imageContent,
ref FileUpload imageSource,
ref string imageType
)
{
int databaseNumberOfRowsAffected = -1;
string imageSourcePath = null;
OleDbCommand oleDbCommand = null;
OleDbConnection oleDbConnection = null;
OleDbParameter oleDbParameter = null;
try
{
if ( imageSource.HasFile == false ) { return; }
imageSourcePath = imageSource.PostedFile.FileName;
UtilityImage.FileUploadByte
(
ref imageSource,
ref imageContent,
ref exceptionMessage
);
if ( exceptionMessage != null ) { return; }
oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize
(
databaseConnectionString,
ref exceptionMessage
);
if ( exceptionMessage != null ) { return; }
oleDbCommand = new OleDbCommand( "uspContactImageUpdate", oleDbConnection );
if ( oleDbCommand == null ) { return; }
oleDbCommand.CommandType = CommandType.StoredProcedure;
oleDbParameter = new OleDbParameter( "@sequenceOrderId", OleDbType.Integer );
if ( sequenceOrderId > 0 )
{
oleDbParameter.Value = sequenceOrderId;
}
else
{
oleDbParameter.Value = DBNull.Value;
}
oleDbCommand.Parameters.Add( oleDbParameter );
oleDbParameter = new OleDbParameter( "@dated", OleDbType.Date );
if ( dated > DateTime.MinValue )
{
oleDbParameter.Value = dated;
}
else
{
oleDbParameter.Value = DBNull.Value;
}
oleDbCommand.Parameters.Add( oleDbParameter );
oleDbParameter = new OleDbParameter( "@contactId", OleDbType.Integer );
if ( contactId > 0 )
{
oleDbParameter.Value = contactId;
}
else
{
oleDbParameter.Value = DBNull.Value;
}
oleDbCommand.Parameters.Add( oleDbParameter );
oleDbParameter = new OleDbParameter( "@imageContent", OleDbType.Binary );
oleDbParameter.Value = imageContent;
oleDbCommand.Parameters.Add( oleDbParameter );
oleDbParameter = new OleDbParameter( "@ImageSource", OleDbType.VarChar, 255 );
oleDbParameter.Value = imageSourcePath;
oleDbCommand.Parameters.Add( oleDbParameter );
oleDbParameter = new OleDbParameter( "@imageType", OleDbType.VarChar, 255 );
oleDbParameter.Value = imageType;
oleDbCommand.Parameters.Add( oleDbParameter );
databaseNumberOfRowsAffected = oleDbCommand.ExecuteNonQuery();
}//try
catch ( Exception exception ) { UtilityException.ExceptionLog( exception, exception.GetType().Name, ref exceptionMessage ); }
}
} //AlphabetSequenceDatabaseQuery()
/// <summary>The database query.</summary>
/// <param name="databaseConnectionString">The database connection string.</param>
/// <param name="exceptionMessage">The exception message.</param>
/// <param name="wordQuery">The word.</param>
/// <param name="scriptureReferenceAssociates">The scripture reference associates.</param>
/// <param name="alphabetSequenceIndex">The alphabet sequence index.</param>
/// <param name="scriptureReferenceAlphabetSequence">The scripture reference alphabet sequence.</param>
public static void AlphabetSequenceQuery
(
ref String databaseConnectionString,
ref String exceptionMessage,
ref String[] wordQuery,
String scriptureReferenceAssociates,
ref int[] alphabetSequenceIndex,
ref ScriptureReferenceAlphabetSequence[] scriptureReferenceAlphabetSequence
)
{
int sequenceOrderId = -1;
int theWordId = -1;
int wordQueryTotal = wordQuery.Length;
string chapterForward = null;
string chapterBackward = null;
//string commentary = null;
string scriptureReference = null;
string scriptureReferenceChapterBackward = null;
string scriptureReferenceChapterForward = null;
string scriptureReferenceVerseBackward = null;
string scriptureReferenceVerseForward = null;
string verseForward = null;
string verseBackward = null;
OleDbConnection oleDbConnection = null;
OleDbCommand oleDbCommand = null;
OleDbDataReader oleDbDataReader = null;
OleDbParameter oleDbParameterWord = null;
OleDbParameter oleDbParameterScriptureReferenceAssociates = null;
OleDbParameter oleDbParameterAlphabetSequence = null;
OleDbParameter oleDbParameterScriptureReferenceVerseForward = null;
OleDbParameter oleDbParameterScriptureReferenceChapterForward = null;
OleDbParameter oleDbParameterScriptureReferenceChapterBackward = null;
OleDbParameter oleDbParameterScriptureReferenceVerseBackward = null;
OleDbParameter oleDbParameterScriptureReference = null;
OleDbParameter oleDbParameterSequenceOrderId = null;
OleDbParameter oleDbParameterVerseForward = null;
OleDbParameter oleDbParameterChapterForward = null;
OleDbParameter oleDbParameterChapterBackward = null;
OleDbParameter oleDbParameterVerseBackward = null;
OleDbParameter oleDbParameterCommentary = null;
OleDbParameter oleDbParameterTheWordId = null;
AlphabetSequenceIndexCalculate
(
ref wordQuery,
ref alphabetSequenceIndex
);
try
{
if
(
databaseConnectionString == null ||
databaseConnectionString.IndexOf("Bible") < 0
)
{
databaseConnectionString = DatabaseConnectionString;
}//if ( databaseConnectionString == null )
oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize
(
databaseConnectionString,
ref exceptionMessage
);
if (oleDbConnection == null || exceptionMessage != null)
{
return;
}//if ( oleDbConnection == null || exceptionMessage != null )
oleDbCommand = new OleDbCommand(SQLSelectAlphabetSequence, oleDbConnection);
oleDbCommand.CommandType = CommandType.StoredProcedure;
oleDbParameterWord = new OleDbParameter(ParameterWord, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReferenceAssociates = new OleDbParameter(ParameterWord, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterAlphabetSequence = new OleDbParameter(ParameterAlphabetSequence, OleDbType.Integer);
oleDbParameterScriptureReferenceVerseForward = new OleDbParameter(ParameterScriptureReferenceVerseForward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReferenceChapterForward = new OleDbParameter(ParameterScriptureReferenceChapterForward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReferenceChapterBackward = new OleDbParameter(ParameterScriptureReferenceChapterBackward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReferenceVerseBackward = new OleDbParameter(ParameterScriptureReferenceVerseBackward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReference = new OleDbParameter(ParameterScriptureReference, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterVerseForward = new OleDbParameter(ParameterVerseForward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterChapterForward = new OleDbParameter(ParameterChapterForward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterChapterBackward = new OleDbParameter(ParameterChapterBackward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterVerseBackward = new OleDbParameter(ParameterVerseBackward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterSequenceOrderId = new OleDbParameter(ParameterSequenceOrderId, OleDbType.Integer);
oleDbParameterCommentary = new OleDbParameter(ParameterCommentary, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterTheWordId = new OleDbParameter(ParameterTheWordId, OleDbType.Integer);
oleDbParameterSequenceOrderId = new OleDbParameter(ParameterSequenceOrderId, OleDbType.Integer);
/*
* @word VARCHAR(600) = NULL OUTPUT,
* @scriptureReferenceAssociates VARCHAR(600) = NULL OUTPUT,
* @alphabetSequence INT = -1 OUTPUT,
* @scriptureReferenceVerseForward VARCHAR(600) = NULL OUTPUT,
* @scriptureReferenceChapterForward VARCHAR(600) = NULL OUTPUT,
* @scriptureReferenceChapterBackward VARCHAR(600) = NULL OUTPUT,
* @scriptureReferenceVerseBackward VARCHAR(600) = NULL OUTPUT,
* @scriptureReference VARCHAR(600) = NULL OUTPUT,
* @verseForward VARCHAR(600) = NULL OUTPUT,
* @chapterForward VARCHAR(600) = NULL OUTPUT,
* @chapterBackward VARCHAR(600) = NULL OUTPUT,
* @verseBackward VARCHAR(600) = NULL OUTPUT,
* @sequenceOrderId INT = -1 OUTPUT
*/
oleDbCommand.Parameters.Add(oleDbParameterWord);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceAssociates);
oleDbCommand.Parameters.Add(oleDbParameterAlphabetSequence);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceVerseForward);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceChapterForward);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceChapterBackward);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceVerseBackward);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReference);
oleDbCommand.Parameters.Add(oleDbParameterVerseForward);
oleDbCommand.Parameters.Add(oleDbParameterChapterForward);
oleDbCommand.Parameters.Add(oleDbParameterChapterBackward);
oleDbCommand.Parameters.Add(oleDbParameterVerseBackward);
/*
* oleDbCommand.Parameters.Add(oleDbParameterCommentary);
* oleDbCommand.Parameters.Add(oleDbParameterTheWordId);
*/
oleDbCommand.Parameters.Add(oleDbParameterSequenceOrderId);
oleDbParameterWord.Direction = ParameterDirection.InputOutput;
oleDbParameterScriptureReferenceAssociates.Direction = ParameterDirection.InputOutput;
oleDbParameterAlphabetSequence.Direction = ParameterDirection.InputOutput;
oleDbParameterScriptureReferenceVerseForward.Direction = ParameterDirection.Output;
oleDbParameterScriptureReferenceChapterForward.Direction = ParameterDirection.Output;
oleDbParameterScriptureReferenceChapterBackward.Direction = ParameterDirection.Output;
oleDbParameterScriptureReferenceVerseBackward.Direction = ParameterDirection.Output;
oleDbParameterScriptureReference.Direction = ParameterDirection.Output;
oleDbParameterVerseForward.Direction = ParameterDirection.Output;
oleDbParameterChapterForward.Direction = ParameterDirection.Output;
oleDbParameterChapterBackward.Direction = ParameterDirection.Output;
oleDbParameterVerseBackward.Direction = ParameterDirection.Output;
/*
* oleDbParameterCommentary.Direction = ParameterDirection.InputOutput;
* oleDbParameterTheWordId.Direction = ParameterDirection.InputOutput;
*/
oleDbParameterSequenceOrderId.Direction = ParameterDirection.InputOutput;
for (int wordQueryIndex = 0; wordQueryIndex < wordQuery.Length; ++wordQueryIndex)
{
oleDbParameterAlphabetSequence.Value = alphabetSequenceIndex[wordQueryIndex];
oleDbParameterScriptureReferenceAssociates.Value = scriptureReferenceAssociates;
oleDbParameterSequenceOrderId.Value = -1;
oleDbParameterTheWordId.Value = null;
oleDbParameterWord.Value = wordQuery[wordQueryIndex];
oleDbCommand.ExecuteScalar();
scriptureReferenceVerseForward = (oleDbParameterScriptureReferenceVerseForward.Value).ToString();
scriptureReferenceChapterForward = (oleDbParameterScriptureReferenceChapterForward.Value).ToString();
scriptureReferenceChapterBackward = (oleDbParameterScriptureReferenceChapterBackward.Value).ToString();
scriptureReferenceVerseBackward = (oleDbParameterScriptureReferenceVerseBackward.Value).ToString();
scriptureReference = (oleDbParameterScriptureReference.Value).ToString();
verseForward = (oleDbParameterVerseForward.Value).ToString();
chapterForward = (oleDbParameterChapterForward.Value).ToString();
chapterBackward = (oleDbParameterChapterBackward.Value).ToString();
verseBackward = (oleDbParameterVerseBackward.Value).ToString();
sequenceOrderId = Int32.Parse(oleDbParameterSequenceOrderId.Value.ToString());
/*
* theWordId = Int32.Parse ( oleDbParameterTheWordId.Value.ToString() );
*/
scriptureReferenceAlphabetSequence[wordQueryIndex] = new ScriptureReferenceAlphabetSequence
(
wordQuery[wordQueryIndex],
scriptureReferenceAssociates,
alphabetSequenceIndex[wordQueryIndex],
scriptureReferenceVerseForward,
scriptureReferenceChapterForward,
scriptureReferenceChapterBackward,
scriptureReferenceVerseBackward,
scriptureReference,
verseForward,
chapterForward,
chapterBackward,
verseBackward,
sequenceOrderId
);
#if (DEBUG)
System.Console.WriteLine("SequenceOrderId: {0}", sequenceOrderId);
System.Console.WriteLine("TheWordId: {0}", theWordId);
#endif
} //for ( int wordQueryIndex = 0; wordQueryIndex < wordQueryTotal; ++wordQueryIndex )
} //try
catch (OleDbException exception)
{
exceptionMessage = UtilityDatabase.DisplayOleDbErrorCollection(exception);
System.Console.WriteLine("OleDbException: {0}", exceptionMessage);
System.Console.WriteLine("OleDbException: {0}", oleDbParameterAlphabetSequence.Value);
return;
}//catch (OleDbException exception)
catch (Exception exception)
{
exceptionMessage = exception.Message;
System.Console.WriteLine("Exception: {0}", exception.Message);
return;
}//catch (Exception exception)
finally
{
if (oleDbDataReader != null)
{
oleDbDataReader.Close();
}
UtilityDatabase.DatabaseConnectionHouseKeeping
(
oleDbConnection,
ref exceptionMessage
);
} //finally
return;
} //AlphabetSequenceQuery()
}//public static void DatabaseQuery()
/// <summary>The database query.</summary>
/// <param name="databaseConnectionString">The database connection string.</param>
/// <param name="exceptionMessage">The exception message.</param>
/// <param name="word">The word.</param>
/// <param name="scriptureReferenceAssociates">The scripture reference associates.</param>
/// <param name="alphabetSequence">The alphabet sequence.</param>
/// <param name="scriptureReferenceAlphabetSequence">The scripture reference alphabet sequence.</param>
public static void DatabaseQuery
(
ref string databaseConnectionString,
ref string exceptionMessage,
string[] word,
string scriptureReferenceAssociates,
ref int[] alphabetSequence,
ref ScriptureReferenceAlphabetSequence[] scriptureReferenceAlphabetSequence
)
{
int wordTotal = word.Length;
string chapterForward = null;
string chapterBackward = null;
string scriptureReference = null;
string scriptureReferenceChapterBackward = null;
string scriptureReferenceChapterForward = null;
string scriptureReferenceVerseBackward = null;
string scriptureReferenceVerseForward = null;
string verseForward = null;
string verseBackward = null;
OleDbConnection oleDbConnection = null;
OleDbCommand oleDbCommand = null;
OleDbDataReader oleDbDataReader = null;
OleDbParameter oleDbParameterWord = null;
OleDbParameter oleDbParameterScriptureReferenceAssociates = null;
OleDbParameter oleDbParameterAlphabetSequence = null;
OleDbParameter oleDbParameterScriptureReferenceVerseForward = null;
OleDbParameter oleDbParameterScriptureReferenceChapterForward = null;
OleDbParameter oleDbParameterScriptureReferenceChapterBackward = null;
OleDbParameter oleDbParameterScriptureReferenceVerseBackward = null;
OleDbParameter oleDbParameterScriptureReference = null;
OleDbParameter oleDbParameterVerseForward = null;
OleDbParameter oleDbParameterChapterForward = null;
OleDbParameter oleDbParameterChapterBackward = null;
OleDbParameter oleDbParameterVerseBackward = null;
AlphabetSequenceIndexCalculate
(
ref word,
ref alphabetSequence
);
try
{
if (databaseConnectionString == null)
{
databaseConnectionString = DatabaseConnectionString;
}//if ( databaseConnectionString == null )
oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize
(
databaseConnectionString,
ref exceptionMessage
);
if (oleDbConnection == null || exceptionMessage != null)
{
return;
}//if ( oleDbConnection == null || exceptionMessage != null )
oleDbCommand = new OleDbCommand(SQLSelectAlphabetSequence, oleDbConnection);
oleDbCommand.CommandType = CommandType.StoredProcedure;
oleDbParameterWord = new OleDbParameter(ParameterWord, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReferenceAssociates = new OleDbParameter(ParameterWord, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterAlphabetSequence = new OleDbParameter(ParameterAlphabetSequence, OleDbType.Integer);
oleDbParameterScriptureReferenceVerseForward = new OleDbParameter(ParameterScriptureReferenceVerseForward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReferenceChapterForward = new OleDbParameter(ParameterScriptureReferenceChapterForward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReferenceChapterBackward = new OleDbParameter(ParameterScriptureReferenceChapterBackward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReferenceVerseBackward = new OleDbParameter(ParameterScriptureReferenceVerseBackward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReference = new OleDbParameter(ParameterScriptureReference, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterVerseForward = new OleDbParameter(ParameterVerseForward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterChapterForward = new OleDbParameter(ParameterChapterForward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterChapterBackward = new OleDbParameter(ParameterChapterBackward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterVerseBackward = new OleDbParameter(ParameterVerseBackward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbCommand.Parameters.Add(oleDbParameterWord);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceAssociates);
oleDbCommand.Parameters.Add(oleDbParameterAlphabetSequence);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceVerseForward);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceChapterForward);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceChapterBackward);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceVerseBackward);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReference);
oleDbCommand.Parameters.Add(oleDbParameterVerseForward);
oleDbCommand.Parameters.Add(oleDbParameterChapterForward);
oleDbCommand.Parameters.Add(oleDbParameterChapterBackward);
oleDbCommand.Parameters.Add(oleDbParameterVerseBackward);
oleDbParameterWord.Direction = ParameterDirection.InputOutput;
oleDbParameterScriptureReferenceAssociates.Direction = ParameterDirection.InputOutput;
oleDbParameterAlphabetSequence.Direction = ParameterDirection.InputOutput;
oleDbParameterScriptureReferenceVerseForward.Direction = ParameterDirection.Output;
oleDbParameterScriptureReferenceChapterForward.Direction = ParameterDirection.Output;
oleDbParameterScriptureReferenceChapterBackward.Direction = ParameterDirection.Output;
oleDbParameterScriptureReferenceVerseBackward.Direction = ParameterDirection.Output;
oleDbParameterScriptureReference.Direction = ParameterDirection.Output;
oleDbParameterVerseForward.Direction = ParameterDirection.Output;
oleDbParameterChapterForward.Direction = ParameterDirection.Output;
oleDbParameterChapterBackward.Direction = ParameterDirection.Output;
oleDbParameterVerseBackward.Direction = ParameterDirection.Output;
for (int wordCount = 0; wordCount < wordTotal; ++wordCount)
{
oleDbParameterWord.Value = word[wordCount];
oleDbParameterScriptureReferenceAssociates.Value = scriptureReferenceAssociates;
oleDbParameterAlphabetSequence.Value = alphabetSequence[wordCount];
oleDbCommand.ExecuteScalar();
scriptureReferenceVerseForward = (oleDbParameterScriptureReferenceVerseForward.Value).ToString();
scriptureReferenceChapterForward = (oleDbParameterScriptureReferenceChapterForward.Value).ToString();
scriptureReferenceChapterBackward = (oleDbParameterScriptureReferenceChapterBackward.Value).ToString();
scriptureReferenceVerseBackward = (oleDbParameterScriptureReferenceVerseBackward.Value).ToString();
scriptureReference = (oleDbParameterScriptureReference.Value).ToString();
verseForward = (oleDbParameterVerseForward.Value).ToString();
chapterForward = (oleDbParameterChapterForward.Value).ToString();
chapterBackward = (oleDbParameterChapterBackward.Value).ToString();
verseBackward = (oleDbParameterVerseBackward.Value).ToString();
scriptureReferenceAlphabetSequence[wordCount] = new ScriptureReferenceAlphabetSequence
(
word[wordCount],
scriptureReferenceAssociates,
alphabetSequence[wordCount],
scriptureReferenceVerseForward,
scriptureReferenceChapterForward,
scriptureReferenceChapterBackward,
scriptureReferenceVerseBackward,
scriptureReference,
verseForward,
chapterForward,
chapterBackward,
verseBackward
);
return;
} //for ( int wordCount = 0; wordCount < word.Length; ++wordCount )
} //try
catch (OleDbException exception)
{
exceptionMessage = UtilityDatabase.DisplayOleDbErrorCollection(exception);
System.Console.WriteLine("OleDbException: {0}", exceptionMessage);
System.Console.WriteLine("OleDbException: {0}", oleDbParameterAlphabetSequence.Value);
return;
}//catch (OleDbException exception)
catch (Exception exception)
{
exceptionMessage = exception.Message;
System.Console.WriteLine("Exception: {0}", exception.Message);
return;
}//catch (Exception exception)
finally
{
if (oleDbDataReader != null)
{
oleDbDataReader.Close();
}
UtilityDatabase.DatabaseConnectionHouseKeeping
(
oleDbConnection,
ref exceptionMessage
);
} //finally
return;
} //AlphabetSequenceDatabaseQuery()
}//static void Main( string[] argv )
///<summary>XmlParse()</summary>
static void XmlParse
(
string databaseConnectionString,
ref string exceptionMessage,
string[] xmlDocumentFilenames
)
{
int childrenCount = 0;
int childrenTotal = 0;
int elementConfigurationCount = 0;
int elementConfigurationIndex = 0;
int elementConfigurationTotal = ElementConfiguration.Length;
int grandChildrenCount = 0;
int grandChildrenTotal = 0;
int grandChildrenValueLength = 0;
int oleDbParameterCollectionCount = 0;
int oleDbParameterCollectionIndex = 0;
int oleDbParameterCollectionTotal = 0;
string[][] children = null;
string[][] grandChildren = null;
DateTime dateTime = new DateTime();
OleDbConnection oleDbConnection = null;
OleDbCommand oleDbCommand = null;
OleDbParameterCollection oleDbParameterCollection = null;
XPathDocument xPathDocument = null;
XPathNavigator xPathNavigatorChildren = null;
XPathNavigator xPathNavigatorGrandChildren = null;
XPathNavigator xPathNavigatorParent = null;
XPathNodeIterator xPathNodeIteratorChildren = null;
XPathNodeIterator xPathNodeIteratorGrandChildren = null;
XPathNodeIterator xPathNodeIteratorParent = null;
//Open the database connection.
oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize( databaseConnectionString, ref exceptionMessage );
foreach ( string xmlDocumentFilename in xmlDocumentFilenames )
{
if ( !File.Exists( xmlDocumentFilename ) )
{
System.Console.WriteLine("File Not Found: {0}", xmlDocumentFilename );
continue;
}//if ( !File.Exists( xmlDocumentFilename ) )
#if ( DEBUG )
System.Console.WriteLine("XML Document Filename: {0}", xmlDocumentFilename);
#endif
try
{
//Create an XML document instance, and load XML data.
xPathDocument = new XPathDocument( xmlDocumentFilename );
xPathNavigatorParent = xPathDocument.CreateNavigator();
xPathNodeIteratorParent = xPathNavigatorParent.SelectChildren( XPathNodeType.Element );
xPathNodeIteratorParent.MoveNext();
xPathNavigatorChildren = xPathNodeIteratorParent.Current;
xPathNodeIteratorChildren = xPathNavigatorChildren.SelectChildren( XPathNodeType.Element );
childrenCount = -1;
childrenTotal = xPathNodeIteratorChildren.Count;
children = new string[childrenTotal][];
while ( xPathNodeIteratorChildren.MoveNext() )
{
++childrenCount;
children[childrenCount] = new string[2];
children[childrenCount][NodeRankName] = xPathNodeIteratorChildren.Current.Name.Trim();
children[childrenCount][NodeRankValue] = xPathNodeIteratorChildren.Current.ToString().Trim();
/*
#if ( DEBUG )
System.Console.WriteLine
(
"Children Name: {0} | Value: {1}",
children[childrenCount][NodeRankName],
children[childrenCount][NodeRankValue]
);
#endif
*/
for
(
elementConfigurationCount = 0, elementConfigurationIndex = -1;
elementConfigurationCount < elementConfigurationTotal;
++elementConfigurationCount
)
{
if ( ElementConfiguration[elementConfigurationCount][ElementRankName] == children[childrenCount][NodeRankName] )
{
elementConfigurationIndex = elementConfigurationCount;
}//if ( ElementConfiguration[elementConfigurationCount][ElementRankName] == children[childrenCount][NodeRankName] )
}//for ( elementConfigurationCount = 0, elementConfigurationIndex = -1; elementConfigurationCount < elementConfigurationTotal; ++elementConfigurationCount )
//Element not found; therefore, do not process.
if ( elementConfigurationIndex == -1 )
{
continue;
}//if ( elementConfigurationIndex == -1 )
oleDbCommand = new OleDbCommand
(
ElementConfiguration[elementConfigurationIndex][ElementRankStoredProcedure],
oleDbConnection
);
oleDbCommand.CommandType = CommandType.StoredProcedure;
OleDbCommandBuilder.DeriveParameters( oleDbCommand );
oleDbParameterCollection = oleDbCommand.Parameters;
oleDbParameterCollectionTotal = oleDbParameterCollection.Count;
xPathNavigatorGrandChildren = xPathNodeIteratorChildren.Current;
xPathNodeIteratorGrandChildren = xPathNavigatorGrandChildren.SelectChildren( XPathNodeType.Element );
grandChildrenCount = -1;
grandChildrenTotal = xPathNodeIteratorGrandChildren.Count;
grandChildren = new string[grandChildrenTotal][];
while ( xPathNodeIteratorGrandChildren.MoveNext() )
{
++grandChildrenCount;
grandChildren[grandChildrenCount] = new string[2];
grandChildren[grandChildrenCount][NodeRankName] = xPathNodeIteratorGrandChildren.Current.Name.Trim();
grandChildren[grandChildrenCount][NodeRankValue] = xPathNodeIteratorGrandChildren.Current.ToString().Trim();
grandChildrenValueLength = grandChildren[grandChildrenCount][NodeRankValue].Length;
for
(
oleDbParameterCollectionCount = 0, oleDbParameterCollectionIndex = -1;
oleDbParameterCollectionCount < oleDbParameterCollectionTotal;
++oleDbParameterCollectionCount
)
{
if ( string.Compare ( grandChildren[grandChildrenCount][NodeRankName], oleDbParameterCollection[oleDbParameterCollectionCount].ParameterName, true ) == 0 )
{
oleDbParameterCollectionIndex = oleDbParameterCollectionCount;
switch ( oleDbParameterCollection[oleDbParameterCollectionCount].OleDbType )
{
case OleDbType.DBTimeStamp:
if ( grandChildrenValueLength == 12 || grandChildrenValueLength == 14 )
{
dateTime = UtilityDateTimeParse.DateTimeParse( grandChildren[grandChildrenCount][NodeRankValue] );
}//if ( grandChildrenValueLength == 12 || grandChildrenValueLength == 14 )
else if ( grandChildrenValueLength == 33 )
{
dateTime = XmlConvert.ToDateTime( grandChildren[grandChildrenCount][NodeRankValue] );
}//else if ( grandChildren[grandChildrenCount][NodeRankValue].Length == 33 )
oleDbParameterCollection[oleDbParameterCollectionCount].Value = dateTime;
break;
default:
oleDbParameterCollection[oleDbParameterCollectionCount].Value = grandChildren[grandChildrenCount][NodeRankValue];
break;
}//switch ( oleDbParameterCollection[oleDbParameterCollectionCount].OleDbType )
break;
}//if ( string.Compare ( grandChildren[grandChildrenCount][NodeRankName], oleDbParameterCollection[oleDbParameterCollectionCount].ParameterName, true ) == 0 )
}//foreach ( OleDbParameter oleDbParameter in oleDbParameters )
#if ( DEBUG )
if ( oleDbParameterCollectionIndex > -1 ) //Database Parameter Found.
{
System.Console.WriteLine
(
"OleDbParameter Name: {0} | Type: {1} | Value: {2}",
oleDbParameterCollection[oleDbParameterCollectionIndex].ParameterName,
oleDbParameterCollection[oleDbParameterCollectionIndex].OleDbType,
oleDbParameterCollection[oleDbParameterCollectionIndex].Value
);
}//Database Parameter Found.
else
{
System.Console.WriteLine
(
"GrandChildren Name: {0} | Value: {1}",
grandChildren[grandChildrenCount][NodeRankName],
grandChildren[grandChildrenCount][NodeRankValue]
);
}//Database Parameter Not Found.
#endif
}//while ( xPathNodeIteratorGrandChildren.MoveNext() )
for
(
oleDbParameterCollectionCount = 0;
oleDbParameterCollectionCount < oleDbParameterCollectionTotal;
++oleDbParameterCollectionCount
)
{
switch ( oleDbParameterCollection[oleDbParameterCollectionCount].OleDbType )
{
case OleDbType.Guid:
if ( oleDbParameterCollection[oleDbParameterCollectionCount].Value == null )
{
oleDbParameterCollection[oleDbParameterCollectionCount].Value = System.Guid.NewGuid();
}
break;
}//switch ( oleDbParameterCollection[oleDbParameterCollectionCount].OleDbType )
}//for ( oleDbParameterCollectionCount = 0; oleDbParameterCollectionCount < oleDbParameterCollectionTotal; ++oleDbParameterCollectionCount )
oleDbCommand.ExecuteNonQuery();
}//while ( xPathNodeIteratorChildren.MoveNext() )
}//try
catch( OleDbException oleDbException )
{
exceptionMessage = UtilityEventLog.WriteEntryOleDbErrorCollection( oleDbException );
System.Console.WriteLine("OleDbException: {0}", exceptionMessage);
}//catch( OleDbException oleDbException )
catch( IOException ioException )
{
System.Console.WriteLine("IOException: {0}", ioException.Message);
}//catch( OleDbException oleDbException )
catch( XPathException xPathException )
{
System.Console.WriteLine("XPathException: {0}", xPathException.Message );
}//catch( XPathException xPathException )
catch( XmlException xmlException )
{
System.Console.WriteLine("XmlException: {0}", xmlException.Message);
}//catch(XmlException xmlEx)
catch( Exception exception )
{
System.Console.WriteLine( "Exception: {0}", exception.Message );
}//catch(Exception ex)
}//foreach ( string xmlDocumentFilename in xmlDocumentFilenames )
//Close the database connection.
UtilityDatabase.DatabaseConnectionHouseKeeping( oleDbConnection, ref exceptionMessage );
}//static void XmlParse( string[] xmlDocumentFilenames )
}//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()
}//Main()
///<summary>The Import File.</summary>
///<param name="databaseConnectionString">The database connection string.</param>
///<param name="uriImportFileName">The file names to import.</param>
public static void URIImportFile
(
string databaseConnectionString,
string[] uriImportFileName
)
{
int importConfigurationCount = -1;
int importConfigurationTotal = -1;
int importType = -1;
int status = -1;
string exceptionMessage = null;
/*
string navigatorLocalName = null;
string navigatorValue = null;
*/
string nodeName = null;
string nodeValue = null;
DateTime dated = DateTime.Now;
Guid uriStatusGuid = new Guid();
String jehovah = null;
String keyword = null;
String title = null;
String uri = null;
OleDbCommand oleDbCommandJehovah = null;
OleDbCommand oleDbCommandURI = null;
OleDbCommand oleDbCommandURIStatus = null;
OleDbConnection oleDbConnection = null;
OleDbParameter oleDbParameterJehovahDated = null;
OleDbParameter oleDbParameterJehovahJehovah = null;
OleDbParameter oleDbParameterJehovahURI = null;
OleDbParameter oleDbParameterURIDated = null;
OleDbParameter oleDbParameterURIKeyword = null;
OleDbParameter oleDbParameterURITitle = null;
OleDbParameter oleDbParameterURIURI = null;
OleDbParameter oleDbParameterURIStatusDated = null;
OleDbParameter oleDbParameterURIStatusGuid = null;
OleDbParameter oleDbParameterURIStatusURI = null;
OleDbParameter oleDbParameterURIStatusStatus = null;
OleDbParameterCollection oleDbParameterCollectionURI = null;
XmlDocument xmlDocument = null;
XmlElement xmlElementRoot = null;
XmlNodeList xmlNodeListAddress = null;
try
{
//Open the database connection.
oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize( databaseConnectionString, ref exceptionMessage );
importConfigurationTotal = ImportConfiguration.Length;
foreach ( String uriImportFileNameCurrent in uriImportFileName )
{
//Determine the content of the import file based on the filename pattern for example URIChrist or URIWordEngineering
importType = -1;
for ( importConfigurationCount = 0; importConfigurationCount < importConfigurationTotal; ++importConfigurationCount )
{
if ( uriImportFileNameCurrent.IndexOf( ImportConfiguration[importConfigurationCount][ImportConfigurationFileNamePattern] ) > 0 )
{
importType = importConfigurationCount;
break;
}
}
if ( importType < 0 )
{
System.Console.WriteLine("{0} file name pattern.", uriImportFileNameCurrent);
continue;
}
if ( !File.Exists(uriImportFileNameCurrent) )
{
System.Console.WriteLine("{0} Not Found.", uriImportFileNameCurrent);
continue;
}
oleDbCommandJehovah = new OleDbCommand( DatabaseStoredProcedureNameJehovah, oleDbConnection );
oleDbCommandURI = new OleDbCommand( ImportConfiguration[importType][ImportConfigurationStoredProcedureName], oleDbConnection );
oleDbCommandURIStatus = new OleDbCommand( DatabaseStoredProcedureNameURIStatus, oleDbConnection );
oleDbCommandJehovah.CommandType = CommandType.StoredProcedure;
oleDbCommandURI.CommandType = CommandType.StoredProcedure;
oleDbCommandURIStatus.CommandType = CommandType.StoredProcedure;
oleDbParameterJehovahDated = oleDbCommandJehovah.Parameters.Add(ParameterDated, OleDbType.Date);
oleDbParameterJehovahJehovah = oleDbCommandJehovah.Parameters.Add(ParameterJehovah, OleDbType.VarChar, SizeJehovah);
oleDbParameterJehovahURI = oleDbCommandJehovah.Parameters.Add(ParameterURI, OleDbType.VarChar, SizeURI);
oleDbParameterURIDated = oleDbCommandURI.Parameters.Add(ParameterDated, OleDbType.Date);
oleDbParameterURIKeyword = oleDbCommandURI.Parameters.Add(ParameterKeyword, OleDbType.VarChar, SizeKeyword);
oleDbParameterURITitle = oleDbCommandURI.Parameters.Add(ParameterTitle, OleDbType.VarChar, SizeTitle);
oleDbParameterURIURI = oleDbCommandURI.Parameters.Add(ParameterURI, OleDbType.VarChar, SizeURI);
oleDbParameterURIStatusURI = oleDbCommandURIStatus.Parameters.Add(ParameterURI, OleDbType.VarChar, SizeURI);
oleDbParameterURIStatusDated = oleDbCommandURIStatus.Parameters.Add(ParameterDated, OleDbType.Date);
oleDbParameterURIStatusStatus = oleDbCommandURIStatus.Parameters.Add(ParameterStatus, OleDbType.Integer);
oleDbParameterURIStatusGuid = oleDbCommandURIStatus.Parameters.Add(ParameterGuid, OleDbType.Guid);
oleDbParameterURIStatusGuid.Direction = ParameterDirection.Output;
oleDbParameterCollectionURI = oleDbCommandURI.Parameters;
xmlDocument = new XmlDocument();
xmlDocument.PreserveWhitespace = false;
xmlDocument.Load( uriImportFileNameCurrent );
xmlElementRoot = xmlDocument.DocumentElement;
xmlNodeListAddress = xmlElementRoot.SelectNodes( XPathExpressionAddress );
foreach ( XmlNode xmlNodeAddress in xmlNodeListAddress )
{
//Initialize the default values.
dated = DateTime.Now;
keyword = null;
status = URIStatusHTTP404FileNotFound;
title = null;
uri = AboutBlank;
foreach (XmlNode xmlNodeAddressElement in xmlNodeAddress )
{
nodeName = xmlNodeAddressElement.Name;
nodeValue = xmlNodeAddressElement.InnerText.Trim();
switch (nodeName)
{
case NameDated:
if ( nodeValue != string.Empty )
{
dated = XmlConvert.ToDateTime( nodeValue );
}
oleDbParameterJehovahDated.Value = dated;
oleDbParameterURIDated.Value = dated;
oleDbParameterURIStatusDated.Value = dated;
break;
case NameJehovah:
jehovah = nodeValue;
System.Console.WriteLine("URI: {0} | Jehovah: {1}", uri, jehovah);
oleDbParameterJehovahJehovah.Value = jehovah;
oleDbCommandJehovah.ExecuteNonQuery();
break;
case NameStatus:
if ( nodeValue != string.Empty )
{
status = XmlConvert.ToInt16( nodeValue );
}
oleDbParameterURIStatusStatus.Value = status;
oleDbCommandURIStatus.ExecuteNonQuery();
uriStatusGuid = new Guid( (oleDbParameterURIStatusGuid.Value).ToString() );
System.Console.WriteLine
(
"URI: {0} | Dated: {1} | Status: {2} | Guid: {3}",
uri,
dated,
status,
uriStatusGuid
);
uri = AboutBlank;
break;
case NameKeyword:
keyword = nodeValue;
oleDbParameterURIKeyword.Value = keyword;
break;
case NameTitle:
title = nodeValue;
oleDbParameterURITitle.Value = title;
break;
case NameURI:
if ( nodeValue != string.Empty )
{
uri = nodeValue;
}
oleDbParameterJehovahURI.Value = uri;
oleDbParameterURIURI.Value = uri;
oleDbParameterURIStatusURI.Value = uri;
break;
}//switch (nodeName)
}//foreach (XmlNode xmlNodeAddressElement in xmlNodeAddress )
if ( uri == AboutBlank ) { continue; }
foreach ( OleDbParameter oleDbParameter in oleDbParameterCollectionURI )
{
System.Console.Write("{0}: {1}|", oleDbParameter, oleDbParameter.Value );
}//foreach ( OleDbParameter oleDbParameter in oleDbParameterCollectionURI )
System.Console.WriteLine();
oleDbCommandURI.ExecuteNonQuery();
}//foreach ( XmlNode xmlNodeAddress in xmlNodeListAddress )
}//for ( String URIImportFileNameCurrent in URIImportFileName )
//Close the database connection.
UtilityDatabase.DatabaseConnectionHouseKeeping( oleDbConnection, ref exceptionMessage );
}//try
catch( OleDbException oleDbException )
{
exceptionMessage = UtilityEventLog.WriteEntryOleDbErrorCollection( oleDbException );
System.Console.WriteLine("OleDbException: {0}", exceptionMessage);
}//catch( OleDbException oleDbException )
catch( IOException ioException )
{
System.Console.WriteLine("IOException: {0}", ioException.Message);
}//catch( OleDbException oleDbException )
catch( XPathException xPathException )
{
System.Console.WriteLine("XPathException: {0}", xPathException.Message );
}//catch( XPathException xPathException )
catch( XmlException xmlException )
{
System.Console.WriteLine("XMLException: {0}", xmlException.Message );
}//catch( XmlException xmlException )
catch( Exception exception )
{
System.Console.WriteLine("Exception: {0}", exception.Message );
}//catch( Exception exception )
}//URIImportFileName
}//DictionaryTextFile()
///<summary>Search: Display the number of results.</summary>
///<param name="dictionaryWord">The dictionary word.</param>
///<param name="exceptionMessage">The exception message.</param>
///<param name="sbResultElement">The result element.</param>
public static void Search
(
String dictionaryWord,
ref String exceptionMessage,
ref StringBuilder sbResultElement
)
{
DataSet dataSet = null;
HttpContext httpContext = HttpContext.Current;
OleDbConnection oleDbConnection = null;
StringBuilder SQLStatement = null;
sbResultElement = new StringBuilder();
oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize
(
DatabaseConnectionString,
ref exceptionMessage
);
SQLStatement = new StringBuilder();
SQLStatement.AppendFormat
(
SQLStatementDictionarySelect,
dictionaryWord
);
#if (DEBUG)
System.Console.WriteLine("SQL Statement: {0}", SQLStatement.ToString());
#endif
UtilityDatabase.DatabaseQuery
(
DatabaseConnectionString,
ref exceptionMessage,
ref dataSet,
SQLStatement.ToString(),
CommandType.Text
);
if (httpContext != null && exceptionMessage != null)
{
httpContext.Response.Write(exceptionMessage);
}//if ( httpContext != null )
foreach (DataTable dataTable in dataSet.Tables)
{
sbResultElement.Append("<TABLE align='center'>");
foreach (DataRow dataRow in dataTable.Rows)
{
sbResultElement.Append("<TR>");
/*
* foreach (DataColumn dataColumn in dataTable.Columns)
* {
* sbResultElement.AppendFormat
* (
* HTMLTableColumn,
* dataRow[dataColumn]
* );
* }//foreach (DataColumn dataColumn in dataTable.Columns)
*/
sbResultElement.AppendFormat
(
HTMLTableColumn,
dataRow["Commentary"]
);
sbResultElement.Append("</TR>");
} //foreach(DataRow dataRow in dataTable.Rows)
sbResultElement.Append("</TABLE>");
} //foreach(DataTable dataTable in dataSet.Tables)
#if (DEBUG)
System.Console.WriteLine("{0}", sbResultElement);
#endif
}//Search()
}//main()
/// <summary>The dictionary text file.</summary>
/// <param name="directorynameSource">The directory name, source, for example, ..\\ProjectGutenberg.</param>
/// <param name="fileSearchPattern">The file search pattern, for example. *.txt.</param>
public static void DictionaryTextFile
(
String directorynameSource,
String fileSearchPattern
)
{
int lineMaximumEnglish = -1;
int lineNumber = 0;
int sequenceOrderId = 0;
String filenameDictionary = null;
String exceptionMessage = null;
String line = null;
StringBuilder sbDictionary = null;
StringBuilder SQLStatement = null;
ArrayList arrayListDirectoryname = null;
ArrayList arrayListFilename = null;
System.Collections.IEnumerator enumeratorFilename = null;
OleDbConnection oleDbConnection = null;
oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize
(
DatabaseConnectionString,
ref exceptionMessage
);
UtilityDatabase.DatabaseNonQuery
(
oleDbConnection,
ref exceptionMessage,
SQLStatementDictionaryTruncate
);
UtilityDirectory.Dir
(
ref DirectorynameSource,
ref fileSearchPattern,
ref arrayListDirectoryname,
ref arrayListFilename
);//UtilityDirectory.Dir
enumeratorFilename = arrayListFilename.GetEnumerator();
while (enumeratorFilename.MoveNext())
{
filenameDictionary = (String)enumeratorFilename.Current;
System.Console.WriteLine("{0}", filenameDictionary);
sbDictionary = new StringBuilder();
try
{
// Create an instance of StreamReader to read from a file.
// The using statement also closes the StreamReader.
using (StreamReader sr = new StreamReader(filenameDictionary))
{
bool nonEnglish = false;
bool wordTranslate = false;
int indexEnglishAlphabet = -1;
int lineLength = -1;
int linePosition = -1;
String charCurrent = null;
StringBuilder wordEnglish = null;
StringBuilder wordKorean = null;
UnicodeCategory unicodeCategoryCurrent;
// Read and display lines from the file until the end of
// the file is reached.
while ((line = sr.ReadLine()) != null)
{
++lineNumber;
/*
#if (DEBUG)
* System.Console.WriteLine
* (
* "Line #: {0} | {1}",
* lineNumber,
* line
* );
#endif
*/
line = line.Trim();
lineLength = line.Length;
if (lineLength == 0)
{
continue;
}
if (Array.IndexOf(PunctuationSymbolAnyOf, line[0]) >= 0)
{
continue;
}
else if (line[0] == ' ')
{
continue;
}
else if (Char.IsLetter(line[0]))
{
continue;
}
else if (line[1] == '.' || line[2] == '.')
{
continue;
}
#if (DEBUG)
System.Console.WriteLine
(
"Char.IsLetterOrDigit\nLine #: {0} | {1}",
lineNumber,
line
);
#endif
indexEnglishAlphabet = line.IndexOfAny(EnglishAlphabetAnyOf);
if (indexEnglishAlphabet < 1)
{
continue;
}
#if (DEBUG)
System.Console.WriteLine("indexEnglishAlphabet: {0}", indexEnglishAlphabet);
#endif
if (indexEnglishAlphabet < 1)
{
continue;
}
nonEnglish = false;
unicodeCategoryCurrent = Char.GetUnicodeCategory(line, 0);
switch (unicodeCategoryCurrent)
{
case UnicodeCategory.DecimalDigitNumber:
break;
case UnicodeCategory.LowercaseLetter:
break;
case UnicodeCategory.UppercaseLetter:
break;
default:
nonEnglish = true;
break;
}
#if (DEBUG)
System.Console.WriteLine("if ( nonEnglish == false )");
#endif
if (nonEnglish == false)
{
continue;
}
wordEnglish = new StringBuilder();
wordKorean = new StringBuilder();
wordKorean.Append(line.Substring(0, indexEnglishAlphabet - 1));
wordEnglish.Append(line.Substring(indexEnglishAlphabet));
wordEnglish = wordEnglish.Replace("'", "''");
if (wordEnglish.Length > lineMaximumEnglish)
{
lineMaximumEnglish = lineLength;
}
/*
* wordEnglish = new StringBuilder();
* wordKorean = new StringBuilder();
* wordTranslate = false;
*
* for ( linePosition = 0; linePosition < lineLength; ++linePosition )
* {
* charCurrent = line.Substring( linePosition, 1 );
*
* if ( KoreanConsonant.Contains( line.Substring( linePosition, 2 ) )
* {
++linePosition;
* }
*
* unicodeCategoryCurrent = Char.GetUnicodeCategory(line, linePosition);
*
* switch ( unicodeCategoryCurrent )
* {
* case UnicodeCategory.DecimalDigitNumber:
* wordTranslate = true;
* break;
*
* case UnicodeCategory.LowercaseLetter:
* wordTranslate = true;
* break;
*
* case UnicodeCategory.UppercaseLetter:
* wordTranslate = true;
* break;
* }
*
* if ( wordTranslate == false )
* {
* wordKorean.Append( charCurrent );
* }
* else
* {
* wordEnglish.Append( charCurrent );
* }
*
* }//for ( linePosition = 0; linePosition < lineLength; ++linePosition )
*/
if (wordKorean.Length == 0 || wordEnglish.Length == 0)
{
continue;
}
++sequenceOrderId;
#if (DEBUG)
System.Console.WriteLine
(
"SequenceOrderId: {0} | Korean: {1} | English: {2}",
sequenceOrderId,
wordKorean,
wordEnglish
);
#endif
SQLStatement = new StringBuilder();
SQLStatement.AppendFormat
(
SQLStatementDictionaryInsert,
sequenceOrderId,
wordKorean,
wordEnglish
);
/*
#if (DEBUG)
* System.Console.WriteLine("SQL Statement: {0}", SQLStatement.ToString() );
#endif
*/
UtilityDatabase.DatabaseNonQuery
(
oleDbConnection,
ref exceptionMessage,
SQLStatement.ToString()
);
} //while ((line = sr.ReadLine()) != null)
} //using (StreamReader sr = new StreamReader("TestFile.txt"))
} //try
catch (Exception e)
{
System.Console.WriteLine
(
"Line #:{0} | Line: {1} | Exception: {2}",
lineNumber,
line,
e.Message
);
} //catch (Exception e)
} //while ( enumeratorFilename.MoveNext() )
UtilityDatabase.DatabaseConnectionHouseKeeping
(
oleDbConnection,
ref exceptionMessage
);
#if (DEBUG)
System.Console.WriteLine
(
"Line Maximum: {0}",
lineMaximumEnglish
);
#endif
}//DictionaryTextFile()
}//DictionaryTextFile()
///<summary>Search: Display the number of results.</summary>
///<param name="dictionaryWord">The dictionary word.</param>
///<param name="exceptionMessage">The exception message.</param>
///<param name="sbResultElement">The result element.</param>
public static void Search
(
string dictionaryWord,
ref string exceptionMessage,
ref StringBuilder sbResultElement
)
{
int dictionaryIdFirst = -1;
int dictionaryIdFirstCurrent = -1;
DataSet dataSet = null;
HttpContext httpContext = HttpContext.Current;
OleDbConnection oleDbConnection = null;
string dictionaryWordFirst = null;
string dictionaryWordSecond = null;
StringBuilder sbSynonym = null;
StringBuilder SQLStatement = null;
sbResultElement = new StringBuilder();
oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize
(
DatabaseConnectionString,
ref exceptionMessage
);
SQLStatement = new StringBuilder();
SQLStatement.AppendFormat
(
SQLStatementDictionarySelect,
dictionaryWord
);
#if (DEBUG)
System.Console.WriteLine("SQL Statement: {0}", SQLStatement.ToString());
#endif
UtilityDatabase.DatabaseQuery
(
DatabaseConnectionString,
ref exceptionMessage,
ref dataSet,
SQLStatement.ToString(),
CommandType.Text
);
if (httpContext != null && exceptionMessage != null)
{
httpContext.Response.Write(exceptionMessage);
}//if ( httpContext != null )
foreach (DataTable dataTable in dataSet.Tables)
{
/*
* dictionaryIdFirstCurrent = (int) UtilityDatabase.DataSetTableRowColumn
* (
* dataSet,
* dataTable.TableName,
* 0,
* DatabaseColumnSelect[DatabaseColumnRankDictionaryIdFirst]
* );
*/
sbSynonym = new StringBuilder();
foreach (DataRow dataRow in dataTable.Rows)
{
dictionaryIdFirst = (int)dataRow[DatabaseColumnSelect[DatabaseColumnRankDictionaryIdFirst]];
dictionaryWordFirst = (string)dataRow[DatabaseColumnSelect[DatabaseColumnRankDictionaryWordFirst]];
dictionaryWordSecond = (string)dataRow[DatabaseColumnSelect[DatabaseColumnRankDictionaryWordSecond]];
if (dictionaryIdFirst != dictionaryIdFirstCurrent)
{
dictionaryIdFirstCurrent = dictionaryIdFirst;
sbResultElement.AppendFormat
(
FormatDictionaryWord,
dictionaryWordFirst
);
sbResultElement.AppendFormat
(
FormatDictionarySynonym,
dictionaryWordSecond
);
}//if ( dictionaryIdFirst != dictionaryIdFirstCurrent )
else
{
sbResultElement.Append(", " + dictionaryWordSecond);
}
} //foreach(DataRow dataRow in dataTable.Rows)
} //foreach(DataTable dataTable in dataSet.Tables)
#if (DEBUG)
System.Console.WriteLine("{0}", sbResultElement);
#endif
}//Search()
}//main()
/// <summary>The dictionary text file.</summary>
/// <param name="directorynameSource">The directory name, source, for example, ..\\ProjectGutenberg.</param>
/// <param name="fileSearchPattern">The file search pattern, for example. *.txt.</param>
public static void DictionaryTextFile
(
string directorynameSource,
string fileSearchPattern
)
{
Boolean dictionaryBeginFlag = false;
Boolean dictionaryEndFlag = false;
int dictionaryId = 0;
int indexDigit = -1;
int referenceId = -1;
int thesaurusId = -1;
double referenceDouble = 0;
object commandReturn = null;
string dictionaryWord = null;
string exceptionMessage = null;
string filenameDictionary = null;
string referenceWord = null;
string[] thesaurusWord = null;
string thesaurusWordCombination = null;
string thesaurusWordCurrentTrim = null;
StringBuilder sbDictionary = null;
StringBuilder SQLStatement = null;
ArrayList arrayListDirectoryname = null;
ArrayList arrayListFilename = null;
System.Collections.IEnumerator enumeratorFilename = null;
OleDbConnection oleDbConnection = null;
oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize
(
DatabaseConnectionString,
ref exceptionMessage
);
UtilityDatabase.DatabaseNonQuery
(
oleDbConnection,
ref exceptionMessage,
SQLStatementDictionaryTruncate
);
UtilityDirectory.Dir
(
ref DirectorynameSource,
ref fileSearchPattern,
ref arrayListDirectoryname,
ref arrayListFilename
);//UtilityDirectory.Dir
enumeratorFilename = arrayListFilename.GetEnumerator();
while (enumeratorFilename.MoveNext())
{
filenameDictionary = (string)enumeratorFilename.Current;
System.Console.WriteLine("{0}", filenameDictionary);
sbDictionary = new StringBuilder();
try
{
// Create an instance of StreamReader to read from a file.
// The using statement also closes the StreamReader.
using (StreamReader sr = new StreamReader(filenameDictionary))
{
String line;
// Read and display lines from the file until the end of
// the file is reached.
while ((line = sr.ReadLine()) != null)
{
if (line.Trim().Length == 0)
{
continue;
}
if (dictionaryBeginFlag == false)
{
if (String.Compare(line.Trim(), DictionaryBegin) == 0)
{
dictionaryBeginFlag = true;
}
continue;
}
else if (dictionaryBeginFlag == true && String.Compare(line.Trim(), DictionaryEnd) == 0)
{
dictionaryEndFlag = true;
break;
}
if (line[0] != ' ')
{
dictionaryWord = line.Trim();
dictionaryWord = dictionaryWord.Replace("'", "''");
SQLStatement = new StringBuilder();
SQLStatement.AppendFormat
(
SQLStatementDictionaryInsertWord,
dictionaryWord
);
#if (DEBUG)
System.Console.WriteLine("SQL Statement: {0}", SQLStatement.ToString());
#endif
commandReturn = UtilityDatabase.DatabaseQuery
(
oleDbConnection,
ref exceptionMessage,
SQLStatement.ToString(),
CommandType.Text
);
if (commandReturn == DBNull.Value)
{
dictionaryId = -1;
}//if ( commandReturn == DBNull.Value )
else
{
dictionaryId = System.Convert.ToInt32(commandReturn);
} //else if ( commandReturn != DBNull.Value )
} //if ( line[0] != ' ' )
else
{
line = line.Trim();
indexDigit = line.IndexOfAny(DigitsAnyOf);
if (indexDigit < 0)
{
continue;
}
referenceWord = line.Substring(indexDigit);
referenceDouble = System.Convert.ToDouble(referenceWord);
referenceId = System.Convert.ToInt32(referenceDouble);
thesaurusWordCombination = line.Substring(0, indexDigit - 1);
thesaurusWordCombination = thesaurusWordCombination.Trim();
thesaurusWord = thesaurusWordCombination.Split(ThesaurusCombinationDelimiterArray);
foreach (String thesaurusWordCurrent in thesaurusWord)
{
thesaurusWordCurrentTrim = thesaurusWordCurrent.Trim();
SQLStatement = new StringBuilder();
SQLStatement.AppendFormat
(
SQLStatementDictionaryInsertWord,
thesaurusWordCurrent.Trim()
);
#if (DEBUG)
System.Console.WriteLine("SQL Statement: {0}", SQLStatement.ToString());
#endif
commandReturn = UtilityDatabase.DatabaseQuery
(
oleDbConnection,
ref exceptionMessage,
SQLStatement.ToString(),
CommandType.Text
);
if (commandReturn == DBNull.Value)
{
thesaurusId = -1;
}//if ( commandReturn == DBNull.Value )
else
{
thesaurusId = System.Convert.ToInt32(commandReturn);
}//else if ( commandReturn != DBNull.Value )
SQLStatement = new StringBuilder();
SQLStatement.AppendFormat
(
SQLStatementDictionaryInsertReference,
dictionaryId,
thesaurusId,
referenceId
);
#if (DEBUG)
System.Console.WriteLine("SQL Statement: {0}", SQLStatement.ToString());
#endif
UtilityDatabase.DatabaseNonQuery
(
oleDbConnection,
ref exceptionMessage,
SQLStatement.ToString()
);
} //foreach ( String thesaurusWordCurrent in thesaurusWord )
} //else
} //while ((line = sr.ReadLine()) != null)
} //using (StreamReader sr = new StreamReader("filenameDictionary"))
} //try
catch (Exception e)
{
System.Console.WriteLine(e.Message);
} //catch (Exception e)
} //while ( enumeratorFilename.MoveNext() )
UtilityDatabase.DatabaseConnectionHouseKeeping
(
oleDbConnection,
ref exceptionMessage
);
}//DictionaryTextFile()
}//public static void DatabaseSelect()
/// <summary>DatabaseUpdate</summary>
public static void DatabaseUpdate
(
ref string databaseConnectionString,
ref UtilityImageArgument utilityImageArgument,
ref string exceptionMessage,
ref HtmlInputFile htmlInputFileSource
)
{
HttpContext httpContext = HttpContext.Current;
int databaseNumberOfRowsAffected = 0;
int sourceContentLength = 0;
int sourceContentRead = 0;
byte[] byteSource = null;
string filenameSource = null;
string sourceContentType = null;
OleDbCommand oleDbCommand = null;
OleDbConnection oleDbConnection = null;
OleDbParameter oleDbParameter = null;
Stream streamSource = null;
try
{
streamSource = htmlInputFileSource.PostedFile.InputStream;
sourceContentLength = htmlInputFileSource.PostedFile.ContentLength;
sourceContentType = htmlInputFileSource.PostedFile.ContentType;
filenameSource = htmlInputFileSource.Value;
byteSource = new byte[ sourceContentLength ];
/*
TypeCode typeCode = Type.GetTypeCode( byteSource.GetType() );
httpContext.Response.Write( typeCode.ToString() );
*/
sourceContentRead = streamSource.Read( byteSource, 0, sourceContentLength );
oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize
(
databaseConnectionString,
ref exceptionMessage
);
oleDbCommand = new OleDbCommand
(
"usp_ImageCarbonFormUpdate",
oleDbConnection
);
oleDbCommand.CommandType = CommandType.StoredProcedure;
oleDbParameter = new OleDbParameter( "@URIImage", OleDbType.VarChar, 255 );
oleDbParameter.Value = filenameSource;
oleDbCommand.Parameters.Add( oleDbParameter );
oleDbParameter = new OleDbParameter( "@ImageType", OleDbType.VarChar, 255 );
oleDbParameter.Value = sourceContentType;
oleDbCommand.Parameters.Add( oleDbParameter );
oleDbParameter = new OleDbParameter( "@ImageCarbonFormMatch", OleDbType.Binary );
oleDbParameter.Value = byteSource;
oleDbCommand.Parameters.Add( oleDbParameter );
databaseNumberOfRowsAffected = oleDbCommand.ExecuteNonQuery();
}//try
catch ( Exception exception )
{
exceptionMessage = "Exception: " + exception.Message;
}//catch ( Exception exception )
finally
{
if ( oleDbConnection != null )
{
oleDbConnection.Close();
}//if ( oleDbConnection != null )
}//finally
if ( exceptionMessage != null )
{
if ( httpContext == null )
{
System.Console.WriteLine( exceptionMessage );
}//if ( httpContext == null )
else
{
//httpContext.Response.Write( exceptionMessage );
}//else
}//if ( exceptionMessage != null )
}//public static void DatabaseUpdate()
}//RegularExpressionPattern
///<summary>RegularExpressionInsert</summary>
public static void RegularExpressionInsert
(
ref string databaseConnectionString,
ref int sequenceOrderId,
ref string input,
ref string pattern,
ref string replace,
ref string title,
ref string uri,
ref DateTime dated,
ref string exceptionMessage
)
{
HttpContext httpContext = HttpContext.Current;
int executeNonQuery = -1;
OleDbCommand oleDbCommand = null;
OleDbConnection oleDbConnection = null;
try
{
oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize( databaseConnectionString, ref exceptionMessage );
if ( exceptionMessage != null || oleDbConnection == null )
{
return;
}//if ( exceptionMessage != null || oleDbConnection == null )
oleDbCommand = new OleDbCommand( DatabaseStoredProcedureInsert, oleDbConnection );
oleDbCommand.CommandType = CommandType.StoredProcedure;
if ( sequenceOrderId > 0 )
{
oleDbCommand.Parameters.AddWithValue( "@sequenceOrderId", sequenceOrderId );
}
else
{
oleDbCommand.Parameters.AddWithValue( "@sequenceOrderId", DBNull.Value );
}
if ( !dated.Equals( DateTime.MinValue ) )
{
oleDbCommand.Parameters.AddWithValue( "@dated", dated );
}
else
{
oleDbCommand.Parameters.AddWithValue( "@dated", DBNull.Value );
}
oleDbCommand.Parameters.AddWithValue( "@input", @input );
oleDbCommand.Parameters.AddWithValue( "@pattern", @pattern );
oleDbCommand.Parameters.AddWithValue( "@replace", @replace );
oleDbCommand.Parameters.AddWithValue( "@title", @title );
oleDbCommand.Parameters.AddWithValue( "@uri", @uri );
executeNonQuery = oleDbCommand.ExecuteNonQuery();
}//try
catch ( System.Exception exception )
{
exceptionMessage = "System.Exception: " + exception.Message;
}//catch ( System.Exception exception )
if ( exceptionMessage != null || executeNonQuery < 1 )
{
System.Console.WriteLine( exceptionMessage );
return;
}//if ( exceptionMessage != null || executeNonQuery < 1 )
UtilityDatabase.DatabaseConnectionHouseKeeping( oleDbConnection, ref exceptionMessage );
if ( exceptionMessage != null || oleDbConnection != null )
{
return;
}//if ( exceptionMessage != null || oleDbConnection != null )
}//public static void RegularExpressionInsert()
}//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()
}//main()
/// <summary>The dictionary text file.</summary>
/// <param name="directorynameSource">The directory name, source, for example, ..\\ProjectGutenberg.</param>
/// <param name="fileSearchPattern">The file search pattern, for example. *.txt.</param>
public static void DictionaryTextFile
(
string directorynameSource,
string fileSearchPattern
)
{
int indexEntryStart = -1;
int indexEntryEnd = -1;
int indexParagraphPage = -1;
int indexPoint26 = -1;
int indexWordEnd = -1;
string filenameDictionary = null;
string dictionaryFile = null;
string exceptionMessage = null;
string indexEntry = null;
string indexWord = null;
StringBuilder sbDictionary = null;
StringBuilder SQLStatement = null;
ArrayList arrayListDirectoryname = null;
ArrayList arrayListFilename = null;
System.Collections.IEnumerator enumeratorFilename = null;
OleDbConnection oleDbConnection = null;
oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize
(
DatabaseConnectionString,
ref exceptionMessage
);
UtilityDatabase.DatabaseNonQuery
(
oleDbConnection,
ref exceptionMessage,
SQLStatementDictionaryTruncate
);
UtilityDirectory.Dir
(
ref DirectorynameSource,
ref fileSearchPattern,
ref arrayListDirectoryname,
ref arrayListFilename
);//UtilityDirectory.Dir
enumeratorFilename = arrayListFilename.GetEnumerator();
while (enumeratorFilename.MoveNext())
{
filenameDictionary = (string)enumeratorFilename.Current;
System.Console.WriteLine("{0}", filenameDictionary);
sbDictionary = new StringBuilder();
try
{
// Create an instance of StreamReader to read from a file.
// The using statement also closes the StreamReader.
using (StreamReader sr = new StreamReader(filenameDictionary))
{
String line;
// Read and display lines from the file until the end of
// the file is reached.
while ((line = sr.ReadLine()) != null)
{
sbDictionary.Append(line);
//System.Console.WriteLine(line);
} //while ((line = sr.ReadLine()) != null)
} //using (StreamReader sr = new StreamReader("TestFile.txt"))
dictionaryFile = sbDictionary.ToString();
indexPoint26 = dictionaryFile.IndexOf(ParagraphPoint26);
#if (DEBUG)
System.Console.WriteLine("ParagraphPoint26: {0}", indexPoint26);
#endif
indexEntryStart = dictionaryFile.IndexOf(ParagraphHW, indexPoint26);
while (indexEntryStart > 0)
{
indexEntryEnd = dictionaryFile.IndexOf(ParagraphHW, indexEntryStart + 1);
if (indexEntryEnd > 0)
{
indexEntry = dictionaryFile.Substring(indexEntryStart, indexEntryEnd - indexEntryStart);
}
else
{
indexEntry = dictionaryFile.Substring(indexEntryStart);
indexParagraphPage = indexEntry.LastIndexOf(ParagraphPage);
if (indexParagraphPage >= 0)
{
indexEntry = indexEntry.Substring(indexEntry.Length - indexParagraphPage);
}
break;
}//if ( indexEntryEnd <= 0 )
indexWordEnd = indexEntry.IndexOf(AnchorEndHW);
if (indexWordEnd < 0)
{
indexEntryStart = indexEntryEnd;
continue;
}
indexWord = indexEntry.Substring(IndexHWWordStart, indexWordEnd - IndexHWWordStart);
for (int indexReplace = 0; indexReplace < DictionaryWordReplace.Length; ++indexReplace)
{
indexWord = indexWord.Replace
(
DictionaryWordReplace[indexReplace][0],
DictionaryWordReplace[indexReplace][1]
);
indexEntry = indexEntry.Replace
(
DictionaryWordReplace[indexReplace][0],
DictionaryWordReplace[indexReplace][1]
);
}
#if (DEBUG)
System.Console.WriteLine
(
"Index Entry Start: {0} | End: {1} | Word: {2} | Entry: {3}",
indexEntryStart,
indexEntryEnd,
indexWord,
indexEntry
);
#endif
SQLStatement = new StringBuilder();
SQLStatement.AppendFormat
(
SQLStatementDictionaryInsert,
indexWord,
indexEntry
);
#if (DEBUG)
System.Console.WriteLine("SQL Statement: {0}", SQLStatement.ToString());
#endif
UtilityDatabase.DatabaseNonQuery
(
oleDbConnection,
ref exceptionMessage,
SQLStatement.ToString()
);
indexEntryStart = indexEntryEnd;
} //while ( indexEntryStart > 0 )
} //try
catch (Exception e)
{
System.Console.WriteLine(e.Message);
}
}//while ( enumeratorFilename.MoveNext() )
UtilityDatabase.DatabaseConnectionHouseKeeping
(
oleDbConnection,
ref exceptionMessage
);
}//DictionaryTextFile()