public void StructuredFileWriterXMLEncodeTest()
{
var writeFile = new StructuredFile
{
ID = "Write",
FileName = Path.Combine(m_ApplicationDirectory, "StructuredFileOutputXML.txt"),
SqlStatement = "Read",
InOverview = true,
JSONEncode = false
};
var cols = DetermineColumnFormat.GetWriterSourceColumns(writeFile, CancellationToken.None);
var sb = new StringBuilder();
sb.AppendLine("<?xml version=\"1.0\"?>\n");
sb.AppendLine("<rowset>");
writeFile.Header = sb.ToString();
sb.Clear();
sb.AppendLine(" <row>");
foreach (var col in cols)
{
sb.AppendFormat(" <{0}>{1}</{0}>\n", HTMLStyle.XmlElementName(col.Header),
string.Format(System.Globalization.CultureInfo.InvariantCulture, StructuredFileWriter.cFieldPlaceholderByName, col.Header));
}
sb.AppendLine(" </row>");
writeFile.Row = sb.ToString();
writeFile.Footer = "</rowset>";
var writer = new StructuredFileWriter(writeFile, CancellationToken.None);
_ = writer.Write();
}
public void StructuredFileWriterJSONEncodeTest()
{
var writeFile = new StructuredFile
{
ID = "Write",
FileName = Path.Combine(m_ApplicationDirectory, "StructuredFileOutputJSON.txt"),
SqlStatement = "Read",
InOverview = true,
JSONEncode = true
};
var cols = DetermineColumnFormat.GetWriterSourceColumns(writeFile, CancellationToken.None);
writeFile.Header = "{\"rowset\":[\n";
var sb = new StringBuilder("{");
// { "firstName":"John", "lastName":"Doe"},
foreach (var col in cols)
{
sb.AppendFormat("\"{0}\":\"{1}\", ", HTMLStyle.JsonElementName(col.Header),
string.Format(System.Globalization.CultureInfo.InvariantCulture, StructuredFileWriter.cFieldPlaceholderByName, col.Header));
}
if (sb.Length > 1)
{
sb.Length -= 2;
}
sb.AppendLine("},");
writeFile.Row = sb.ToString();
var writer = new StructuredFileWriter(writeFile, CancellationToken.None);
_ = writer.Write();
}