/// <summary>
/// This method reads the given XML string and stores each time series that is defined in the
/// XML file to a new TSImport object that is added to the given List of TSImport objects.
/// </summary>
/// <param name="xmlString">the string containing XML that defines one or more time series to import</param>
/// <param name="tsImportList">A List of TSImport objects that the method adds to. One item is added to the List
/// for each time series that is processed in the XML string. The List must already be instantiated before calling
/// this method. The method does not change any items that are already in the List.</param>
/// <returns>The number of time series records that were successfully read and added to tsImportList</returns>
public int XmlImportFromString(String xmlString, List <TSImport> tsImportList)
{
// Construct new TSXml object without SqlConnection object and table name
TSXml tsXml = new TSXml();
// Method in the TSXml object does all the work
return(tsXml.ReadAndStore(null, xmlString, tsImportList, false, true));
}
/// <summary>
/// This method reads the given XML file and stores any time series that are defined in the
/// XML file to the database using the given database connection number and database table name.
/// For each time series that the method adds to the database, it adds a TSImport object to the
/// given List of TSImport objects. Each TSImport object records fields that were read from the
/// XML file, but which TSLibrary does not process.
/// </summary>
/// <param name="connectionNumber">The serial number of the connection that is used to write to the database</param>
/// <param name="paramTableName">The name of the database table that time series will be written to</param>
/// <param name="traceTableName">The name of the database table that stores the BLOB for a single trace</param>
/// <param name="xmlFileName">The file name (with path) of an XML file that defines one or more time series to import</param>
/// <param name="tsImportList">A List of TSImport objects that the method adds to--one item for each time series
/// that is saved to the database. The List must already be instantiated before calling this method.
/// The method does not change any items that are already in the List.</param>
/// <returns>The number of time series records that were successfully stored</returns>
//[ComVisible(true)]
// TODO: this is not COM friendly due to the List<> object
public int XmlImportWithList(int connectionNumber, String paramTableName, String traceTableName, String xmlFileName,
List <TSImport> tsImportList)
{
// Get the connection that we'll pass along.
var connx = TSLib.GetConnectionContainerFromId(connectionNumber);
// Construct new TSXml object with SqlConnection object and table name
TSXml tsXml = new TSXml(connx, paramTableName, traceTableName);
return(tsXml.ReadAndStore(xmlFileName, null, tsImportList, true, false));
}
/// <summary>
/// This method reads the given XML file and stores any time series that are defined in the
/// XML file to the database using the given database connection number and database table name.
/// Each time series is also stored in a new TSImport object that is addded to the given List
/// of TSImport objects.
/// </summary>
/// <param name="connectionNumber">The serial number of the connection that is used to write to the database</param>
/// <param name="tableName">The name of the database table that time series will be written to</param>
/// <param name="traceTableName">The name of the database table that stores the BLOB for a single trace</param>
/// <param name="xmlFileName">The file name (with path) of an XML file that defines one or more time series to import</param>
/// <param name="tsImportList">A List of TSImport objects that the method adds to. One item is added to the List
/// for each time series that is processed in the XML file. The List must already be instantiated before calling
/// this method. The method does not change any items that are already in the List.</param>
/// <returns>The number of time series records that were successfully stored</returns>
public int XmlImportAndSaveToDB(int connectionNumber, String tableName, String traceTableName,
String xmlFileName, List <TSImport> tsImportList)
{
// Get the connection that we'll pass along.
var connx = GetConnectionContainerFromId(connectionNumber);
// Construct new TSXml object with SqlConnection object and table name
TSXml tsXml = new TSXml(connx, tableName, traceTableName);
// Method in the TSXml object does all the work
return(tsXml.ReadAndStore(xmlFileName, null, tsImportList, true, true));
}
