- Details
- Written by: Stanko Milosev
- Category: C#
- Hits: 586
<ItemGroup> <PackageReference Include="IKVM.Maven.Sdk" Version="1.8.2"/> <MavenReference Include="net.sf.saxon:Saxon-HE" version="12.5"/> <PackageReference Include="SaxonHE12s9apiExtensions" Version="12.5.9.4"/> </ItemGroup>Use this method to return result as a string which later you can convert to XML as I already explained here:
using net.sf.saxon.s9api; using net.liberty_development.SaxonHE12s9apiExtensions; ... string ValidateXmlFile(string xmlFile, string xslFile) { Processor processor = new Processor(); DocumentBuilder builder = processor.newDocumentBuilder(); XsltTransformer xsltTransformer = processor.newXsltCompiler().Compile(new Uri(xslFile)).load(); var inputNode = builder.Build(new Uri(xmlFile)); xsltTransformer.setInitialContextNode(inputNode); using var stringWriter = new StringWriter(); Serializer serializer = processor.NewSerializer(stringWriter); xsltTransformer.setDestination(serializer); xsltTransformer.transform(); return stringWriter.ToString(); }Example download from here.
- Details
- Written by: Stanko Milosev
- Category: C#
- Hits: 613
private static string ValidateXmlFile(string inputFile, string transformFile) { try { if (string.IsNullOrWhiteSpace(inputFile)) { throw new FileNotFoundException("Filename is empty"); } inputFile = Path.GetFullPath(inputFile); if (!File.Exists(inputFile)) { throw new FileNotFoundException($"File: {inputFile} not found"); } transformFile = Path.GetFullPath(transformFile); if (!File.Exists(transformFile)) { throw new FileNotFoundException($"File: {transformFile} not found"); } Processor processor = new Processor(); DocumentBuilder builder = processor.NewDocumentBuilder(); builder.BaseUri = new Uri(inputFile); XdmNode inputNode; using (var inputStream = File.OpenRead(inputFile)) { inputNode = builder.Build(inputStream); } XsltCompiler compiler = processor.NewXsltCompiler(); XsltExecutable executable; using (var xsltStream = File.OpenRead(transformFile)) { executable = compiler.Compile(xsltStream); if (compiler.GetErrorList().Count != 0) throw new Exception("Exception loading xsl!"); } XsltTransformer transformer = executable.Load(); transformer.InitialContextNode = inputNode; Serializer serializer = processor.NewSerializer(); using (var stringWriter = new StringWriter()) { serializer.SetOutputWriter(stringWriter); transformer.Run(serializer); string result = stringWriter.ToString(); return result; } } catch (Exception e) { return e.Message; } }
Since validation result is XML, we can parse failed validations like:
IEnumerable<FailedAssert> failedAsserts = doc.Descendants(svrl + "failed-assert") .Select(fa => new FailedAssert { Flag = fa.Attribute("flag")?.Value, Id = fa.Attribute("id")?.Value, Test = fa.Attribute("test")?.Value, Location = fa.Attribute("location")?.Value, Text = fa.Element(svrl + "text")?.Value });SVRL is an abbreviation for 'Schematron Validation Report Language.' FailedAssert class looks like:
public class FailedAssert { public string Flag { get; set; } public string Id { get; set; } public string Test { get; set; } public string Location { get; set; } public string ExceptionMessage { get; set; } public string Text { get; set; } }Example download from here. For this example I used file 01.03a-INVOICE_uncefact.xml which I downloaded from here where I manipulated with DateTimeField. Instead of a date I wrote "test", in order to trigger a failed assertion. I also downloaded XSL file EN16931-CII-validation.xsl from "Koordinierungsstelle für IT-Standards" (KoSIT) GitHub repository.
- Details
- Written by: Stanko Milosev
- Category: C#
- Hits: 514
private DataTable CreateMasterDataTable() { DataTable dtMaster = new DataTable("Master"); dtMaster.Columns.Add("Id", typeof(int)); dtMaster.Columns.Add("SomeText", typeof(string)); dtMaster.PrimaryKey = [ dtMaster.Columns["Id"] ]; return dtMaster; }Now detail DataTable:
private DataTable CreateDetailDataTable() { DataTable dtDetail = new DataTable("Detail"); dtDetail.Columns.Add("Id", typeof(int)); dtDetail.Columns.Add("MasterId", typeof(int)); dtDetail.Columns.Add("SomeText", typeof(string)); dtDetail.PrimaryKey = [ dtDetail.Columns["Id"] , dtDetail.Columns["MasterId"] ]; return dtDetail; }DataSet:
DataSet dsMasterDetail = new DataSet("MasterDetail"); dsMasterDetail.Tables.Add(CreateMasterDataTable()); dsMasterDetail.Tables.Add(CreateDetailDataTable());Relation and add relation to DataSet:
DataRelation relMasterDetail = new DataRelation("MasterDetailRelation" , dsMasterDetail.Tables["Master"].Columns["Id"] , dsMasterDetail.Tables["Detail"].Columns["MasterId"] ); dsMasterDetail.Relations.Add(relMasterDetail);Now, lets create BindingSource and attach it to DataSource of DataGridView:
var dsMasterDetail = CreateMasterDetailDataSet(); BindingSource bsMaster = new BindingSource { DataSource = dsMasterDetail, DataMember = "Master" }; dgvMaster.DataSource = bsMaster; BindingSource bsDetail = new BindingSource { DataSource = bsMaster, DataMember = "MasterDetailRelation" }; dgvDetail.DataSource = bsDetail;Here notice that DataSource of detail BindingSource I have attached master BindingSource, as DataMember name of relation:
BindingSource bsDetail = new BindingSource { DataSource = bsMaster, DataMember = "MasterDetailRelation" };Example download from here.