}//public void ButtonFileSaveRelease20050830_Click()
/// <summary>ButtonFileSave_Click()</summary>
public void ButtonFileSave_Click
(
Object sender,
EventArgs e
)
{
string exceptionMessage = null;
string filenameXml = null;
DataSet dataSet = null;
try
{
filenameXml = FilenameURI;
if ( string.IsNullOrEmpty( filenameXml ) )
{
return;
}
dataSet = ( DataSet ) ViewState["URIMaintenancePage_DataSet"];
if ( dataSet == null )
{
return;
}
UtilityXml.WriteXml
(
dataSet,
ref exceptionMessage,
ref filenameXml,
ref FilenameStylesheet
);
if ( exceptionMessage != null )
{
Feedback = exceptionMessage;
return;
}
}//try
catch ( Exception exception )
{
exceptionMessage = "Exception: " + exception.Message;
}
if ( exceptionMessage != null )
{
Feedback = exceptionMessage;
}
}//public void ButtonFileSave_Click()
/// <summary>ButtonInsert_Save().</summary>
public void ButtonSave_Click
(
Object sender,
EventArgs e
)
{
string exceptionMessage = null;
string filenameXml = null;
filenameXml = URIFile;
UtilityXml.WriteXml
(
DataSetDataGrid,
ref exceptionMessage,
ref filenameXml,
ref FilenameXmlStylesheet
);
if ( exceptionMessage != null )
{
Feedback = exceptionMessage;
}
}//public void ButtonSave_Click()
/// <summary>EternalXml</summary>
public static void EternalXml
(
ref EternalArgument eternalArgument,
ref string exceptionMessage
)
{
DataSet dataSet = null;
ArrayList databaseName = null;
ArrayList sqlStatementUnion = null;
ArrayList objectName = null;
ArrayList ownerName = null;
ArrayList unionIndex = null;
String filenameXml = null;
try
{
UtilityDatabase.DatabaseQuery
(
DatabaseConnectionString,
ref exceptionMessage,
ref dataSet,
eternalArgument.sqlQuery,
CommandType.Text
);
if (exceptionMessage != null)
{
return;
}
;
UtilityDatabase.SQLSelectParse
(
eternalArgument.sqlQuery,
ref unionIndex,
ref sqlStatementUnion,
ref databaseName,
ref ownerName,
ref objectName,
ref exceptionMessage
);
if (exceptionMessage != null)
{
return;
}
;
if (dataSet.Tables.Count < 1)
{
return;
}//if ( dataSet.Tables.Count < 1 )
dataSet.DataSetName = (String)databaseName[0];
for (int objectNameCount = 0; objectNameCount < objectName.Count; ++objectNameCount)
{
dataSet.Tables[objectNameCount].TableName = (String)objectName[objectNameCount];
}//for ( int objectNameCount = 0; objectNameCount < objectName.Count; ++objectNameCount )
ScriptureReference.ScriptureReferenceURI
(
DatabaseConnectionString,
FilenameConfigurationXml,
ref exceptionMessage,
ref dataSet
);
if (exceptionMessage != null)
{
return;
}
;
if (eternalArgument.date)
{
filenameXml = UtilityFile.DatePostfix(eternalArgument.filenameXml);
}
else
{
filenameXml = eternalArgument.filenameXml;
}
UtilityXml.WriteXml
(
dataSet,
ref exceptionMessage,
ref filenameXml,
ref eternalArgument.filenameStylesheet
);
if (exceptionMessage != null)
{
return;
}
;
}
catch (Exception exception) { UtilityException.ExceptionLog(exception, exception.GetType().Name, ref exceptionMessage); }
}
}//public void ButtonFileOpen_Click()
/// <summary>ButtonFileSaveRelease20050830_Click()</summary>
public void ButtonFileSaveRelease20050830_Click
(
Object sender,
EventArgs e
)
{
string exceptionMessage = null;
string filenameXml = null;
string typeDataSourceString = null;
object dataSource = null;
DataSet dataSet = null;
Type typeDataSource = null;
try
{
filenameXml = FilenameURI;
if ( string.IsNullOrEmpty( filenameXml ) )
{
return;
}
if ( string.IsNullOrEmpty( GridViewURI.DataSourceID ) )
{
dataSource = GridViewURI.DataSource;
if ( dataSource == null )
{
return;
}
typeDataSource = dataSource.GetType();
if ( typeDataSource == null )
{
return;
}
typeDataSourceString = typeDataSource.ToString();
if ( typeDataSourceString != "System.Data.DataSet")
{
return;
}
dataSet = dataSource as DataSet;
dataSet = ( DataSet ) dataSource;
if ( dataSet == null )
{
return;
}
UtilityXml.WriteXml
(
dataSet,
ref exceptionMessage,
ref filenameXml,
ref FilenameStylesheet
);
if ( exceptionMessage != null )
{
Feedback = exceptionMessage;
return;
}
}//if ( GridViewURI.DataSourceID == null && GridViewURI.DataSource != null )
}//try
catch ( Exception exception )
{
exceptionMessage = "Exception: " + exception.Message;
}
if ( exceptionMessage != null )
{
Feedback = exceptionMessage;
}
}//public void ButtonFileSaveRelease20050830_Click()
}//Main()
public static void TableProcessURI
(
ref OleDbConnection oleDbConnection,
String selectQuery,
String filenameHtml,
String filenameText,
String filenameXsd,
String filenameXml,
String filenameXml2,
String filenameStylesheet
)
{
DataColumn dataColumnDated = null;
DataColumn dataColumnKeyword = null;
DataColumn dataColumnTitle = null;
DataColumn dataColumnURI = null;
DataSet dataSet = null;
DataTable dataTable = null;
String exceptionMessage = null;
String keyword = null;
String title = null;
String uri = null;
String xmlProcessingInstructionText = null;
OleDbCommand oleDbCommand = null;
IDataAdapter oleDataAdapter = null;
IDataReader dataReader = null;
//System.IO.FileStream fileStream = null;
TextWriter objTextWriterHtml = null;
TextWriter objTextWriterText = null;
UniqueConstraint uniqueConstraint = null;
Uri objUri = null;
XmlNode xmlNodeDocumentType = null;
XmlNode xmlNodeRoot = null;
XmlDocument xmlDocument = null;
XmlProcessingInstruction xmlProcessingInstruction = null;
XmlTextWriter xmlTextWriter = null;
try
{
UtilityDatabase.DatabaseQuery
(
DatabaseConnectionString,
ref exceptionMessage,
ref dataSet,
selectQuery,
CommandType.Text
);
dataSet.DataSetName = "addresses";
dataSet.Tables[0].TableName = "address";
UtilityXml.WriteXml
(
dataSet,
ref exceptionMessage,
ref filenameXml,
ref filenameStylesheet
);
}//try
catch (XmlException exception)
{
System.Console.WriteLine("Uri: {0} | Exception: {1}", title, exception.Message);
}//catch
catch (Exception exception)
{
System.Console.WriteLine("Uri: {0} | Exception: {1}", title, exception.Message);
}//catch
finally
{
} //finally
} //TableProcessURI
}//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
