}//Page_Load
/// <summary>ButtonQuery_Click</summary>
public void ButtonQuery_Click
(
Object sender,
EventArgs e
)
{
int[] alphabetSequence = new int[1];
string[] word = new string[1];
string scriptureReferenceAssociates = "Genesis 1";
ScriptureReferenceAlphabetSequence[] scriptureReferenceAlphabetSequence = new ScriptureReferenceAlphabetSequence[1];
word[0] = TextBoxWord.Text.Trim();
scriptureReferenceAssociates = TextBoxScriptureReferenceAssociates.Text.Trim();
try
{
AlphabetSequence.DatabaseQuery
(
ref databaseConnectionString,
ref exceptionMessage,
word,
scriptureReferenceAssociates,
ref alphabetSequence,
ref scriptureReferenceAlphabetSequence
);
if ( exceptionMessage != null )
{
LabelExceptionMessage.Text = "if ( exceptionMessage != null )";
Response.Write("if ( exceptionMessage != null )");
}//if ( exceptionMessage != null )
TextBoxAlphabetSequence.Text = Convert.ToString( alphabetSequence[0] );
TextBoxAlphabetSequence.Text = Convert.ToString( scriptureReferenceAlphabetSequence[0].AlphabetSequence );
TextBoxScriptureReference.Text = scriptureReferenceAlphabetSequence[0].ScriptureReferenceCurrent;
TextBoxVerseForward.Text = scriptureReferenceAlphabetSequence[0].VerseForward;
TextBoxChapterForward.Text = scriptureReferenceAlphabetSequence[0].ChapterForward;
TextBoxChapterBackward.Text = scriptureReferenceAlphabetSequence[0].ChapterBackward;
TextBoxVerseBackward.Text = scriptureReferenceAlphabetSequence[0].VerseBackward;
RepeaterAlphabetSequence.DataSource = scriptureReferenceAlphabetSequence;
RepeaterAlphabetSequence.DataBind();
}//try
catch (Exception exception)
{
LabelExceptionMessage.Text = exception.Message;
}//catch
finally
{
}//finally
}//ButtonQuery_Click
/// <summary>The entry point for the application.</summary>
/// <param name="argv">A list of arguments</param>
public static void Main(string[] argv)
{
int[] alphabetSequence = new int[argv.Length];
string exceptionMessage = null;
string scriptureReferenceAssociates = null;
ScriptureReferenceAlphabetSequence[] scriptureReferenceAlphabetSequence = new ScriptureReferenceAlphabetSequence [argv.Length];
try
{
if (argv.Length == 0)
{
for (char currentCharacter = 'A'; currentCharacter <= 'Z'; ++currentCharacter)
{
System.Console.WriteLine("{0} = {1}", currentCharacter, currentCharacter - 'A' + 1);
}
return;
}//if ( args.Length == 0 )
DatabaseQuery
(
ref DatabaseConnectionString,
ref exceptionMessage,
argv,
scriptureReferenceAssociates,
ref alphabetSequence,
ref scriptureReferenceAlphabetSequence
);
foreach (ScriptureReferenceAlphabetSequence scriptureReferenceAlphabetSequenceCurrent in scriptureReferenceAlphabetSequence)
{
System.Console.WriteLine(scriptureReferenceAlphabetSequenceCurrent);
} //foreach ( ScriptureReferenceAlphabetSequence scriptureReferenceAlphabetSequenceCurrent in scriptureReferenceAlphabetSequence )
} //try
catch (Exception exception)
{
System.Console.WriteLine("Exception: {0}", exception.Message);
} //catch( Exception exception)
} //public void Main( string[] args )
} //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()
}//public static void Main.
///<summary>ImportExport.</summary>
///<param name="filenameImport">The filename import.</param>
///<param name="filenameExport">The filename export.</param>
///<param name="scriptureReferenceAssociates">The alphabet sequence associates.</param>
public static void ImportExport
(
string filenameImport,
string filenameExport,
string scriptureReferenceAssociates
)
{
int[] alphabetSequenceIndex = null;
int dataRowIndex = -1;
string exceptionMessage = null;
string fileNameWithoutExtension = null;
string record = null;
string[] word = null;
System.Data.DataColumn dataColumn = null;
System.Data.DataColumn dataColumnForeignKey = null;
System.Data.DataColumn dataColumnPrimaryKey = null;
System.Data.DataRelation dataRelation = null;
System.Data.DataRow dataRow = null;
System.Data.DataSet dataSet = null;
System.Data.DataTable dataTableAlphabetSequence = null;
System.Data.DataTable dataTableTheWord = null;
StreamReader streamReader = null;
ScriptureReferenceAlphabetSequence[] scriptureReferenceAlphabetSequence = null;
StringBuilder sbTitle = null;
sbTitle = new StringBuilder();
try
{
if (!File.Exists(filenameImport))
{
System.Console.WriteLine("File not found: {0}", filenameImport);
return;
}
fileNameWithoutExtension = Path.GetFileNameWithoutExtension( filenameImport );
dataSet = new DataSet();
dataSet.DataSetName = TheWord.NodeRoot;
// Create an instance of StreamReader to read from a file.
// The using statement also closes the StreamReader.
streamReader = new StreamReader(filenameImport);
// Create a new DataTable.
dataTableTheWord = new DataTable(DataTableNameTheWord);
dataColumn = new DataColumn();
dataColumn.ColumnName = "SequenceOrderId";
dataColumn.DataType = System.Type.GetType("System.Int32");
dataColumn.DefaultValue = null;
dataTableTheWord.Columns.Add( dataColumn );
dataColumnPrimaryKey = dataTableTheWord.Columns["SequenceOrderId"];
dataColumn = new DataColumn();
dataColumn.ColumnName = "Dated";
dataColumn.DataType = System.Type.GetType("System.DateTime");
dataTableTheWord.Columns.Add( dataColumn );
dataColumn = new DataColumn();
dataColumn.ColumnName = "ScriptureReference";
dataColumn.DataType = System.Type.GetType("System.String");
dataTableTheWord.Columns.Add( dataColumn );
dataColumn = new DataColumn();
dataColumn.ColumnName = "Title";
dataColumn.DataType = System.Type.GetType("System.String");
dataTableTheWord.Columns.Add( dataColumn );
dataSet.Tables.Add( dataTableTheWord );
dataRow = dataTableTheWord.NewRow();
dataRow["Dated"] = System.DateTime.Today;
dataTableTheWord.Rows.Add( dataRow );
// Create a new DataTable.
dataTableAlphabetSequence = new DataTable(DataTableNameAlphabetSequence);
dataColumn = new DataColumn();
dataColumn.ColumnName = "TheWordId";
dataColumn.DataType = System.Type.GetType("System.Int32");
dataColumn.DefaultValue = null;
dataTableAlphabetSequence.Columns.Add( dataColumn );
dataColumnForeignKey = dataTableAlphabetSequence.Columns["TheWordId"];
dataColumn = new DataColumn();
dataColumn.ColumnName = "SequenceOrderId";
dataColumn.DataType = System.Type.GetType("System.Int32");
dataTableAlphabetSequence.Columns.Add( dataColumn );
dataColumn = new DataColumn();
dataColumn.ColumnName = "Word";
dataColumn.DataType = System.Type.GetType("System.String");
dataTableAlphabetSequence.Columns.Add( dataColumn );
dataColumn = new DataColumn();
dataColumn.ColumnName = "AlphabetSequenceIndex";
dataColumn.DataType = System.Type.GetType("System.Int32");
dataTableAlphabetSequence.Columns.Add( dataColumn );
dataColumn = new DataColumn();
dataColumn.ColumnName = "Commentary";
dataColumn.DataType = System.Type.GetType("System.String");
dataColumn.DefaultValue = null;
dataTableAlphabetSequence.Columns.Add( dataColumn );
dataColumn = new DataColumn();
dataColumn.ColumnName = "ScriptureReference";
dataColumn.DataType = System.Type.GetType("System.String");
dataTableAlphabetSequence.Columns.Add( dataColumn );
dataSet.Tables.Add( dataTableAlphabetSequence );
#if (DEBUG)
System.Console.WriteLine("Data Column Primary Key: {0}", dataColumnPrimaryKey);
System.Console.WriteLine("Data Column Foreign Key: {0}", dataColumnForeignKey);
#endif
dataRelation = new DataRelation
(
DataRelationNameAlphabetSequence,
dataColumnPrimaryKey,
dataColumnForeignKey
);
dataRelation.Nested = true;
dataSet.Relations.Add( dataRelation );
// Read and display lines from the file until the end of
// the file is reached.
while ( true )
{
record = streamReader.ReadLine();
if ( record == null )
{
break;
}
dataRow = dataTableAlphabetSequence.NewRow();
dataRow["Word"] = record;
sbTitle.Append( record );
sbTitle.Append( Environment.NewLine );
dataTableAlphabetSequence.Rows.Add( dataRow );
}//while ( true )
alphabetSequenceIndex = new int[dataTableAlphabetSequence.Rows.Count];
scriptureReferenceAlphabetSequence = new ScriptureReferenceAlphabetSequence[dataTableAlphabetSequence.Rows.Count];
word = new String[dataTableAlphabetSequence.Rows.Count];
dataRowIndex = 0;
foreach ( DataRow dataRowCurrent in dataTableAlphabetSequence.Rows )
{
word[dataRowIndex] = ( string ) dataRowCurrent["Word"];
System.Console.WriteLine( dataRowCurrent["Word"] );
++dataRowIndex;
}//foreach ( DataRow dataRowCurrent in dataTableAlphabetSequence.Rows )
UtilityDatabase.DataSetTableRowColumn
(
dataSet,
"TheWord",
0,
"Title",
sbTitle.ToString()
);
AlphabetSequence.AlphabetSequenceQuery
(
ref DatabaseConnectionString,
ref exceptionMessage,
ref word,
scriptureReferenceAssociates,
ref alphabetSequenceIndex,
ref scriptureReferenceAlphabetSequence
);
for ( dataRowIndex = 0; dataRowIndex < dataTableAlphabetSequence.Rows.Count; ++dataRowIndex )
{
UtilityDatabase.DataSetTableRowColumn
(
dataSet,
DataTableNameAlphabetSequence,
dataRowIndex,
"AlphabetSequenceIndex",
scriptureReferenceAlphabetSequence[ dataRowIndex ].AlphabetSequence
);
UtilityDatabase.DataSetTableRowColumn
(
dataSet,
DataTableNameAlphabetSequence,
dataRowIndex,
"ScriptureReference",
scriptureReferenceAlphabetSequence[ dataRowIndex ].ScriptureReferenceCurrent
);
UtilityDatabase.DataSetTableRowColumn
(
dataSet,
DataTableNameAlphabetSequence,
dataRowIndex,
"SequenceOrderId",
scriptureReferenceAlphabetSequence[ dataRowIndex ].SequenceOrderId
);
}//foreach ( DataRow dataRowCurrent in dataTableAlphabetSequence.Rows )
ScriptureReference.ScriptureReferenceURI
(
TheWord.DatabaseConnectionString,
TheWord.FilenameConfigurationXml,
ref exceptionMessage,
ref dataSet
);//ScriptureReference.ScriptureReferenceURI
UtilityXml.WriteXml
(
dataSet,
ref exceptionMessage,
ref filenameExport,
ref TheWord.FilenameXslt
);
}//try
catch (Exception exception)
{
System.Console.WriteLine("Exception: ", exception.Message);
}//catch (Exception exception)
finally
{
}//finally
}//public static void ImportExport
