public DbConnectionHandler(uint id, string name, CommunicationInterfaceHandler communicationInterfaceHandler, DbConnectionHandlerFile dbConnectionHandlerFile, DbConnectionHandlerInterfaceAssignmentFile dbConnectionHandlerInterfaceAssignmentFile)
: base(id, name, communicationInterfaceHandler)
{
DbConnectionHandlerFile = dbConnectionHandlerFile;
DbConnectionHandlerInterfaceAssignmentFile = dbConnectionHandlerInterfaceAssignmentFile;
StoredProcedures = new DbStoredProcedureList(this);
if (dbConnectionHandlerInterfaceAssignmentFile.Assignment == null) dbConnectionHandlerInterfaceAssignmentFile.Assignment = new string[9][];
Assignment = dbConnectionHandlerInterfaceAssignmentFile.Assignment[Header.Id];
CreateInterfaceAssignment();
}
public void CreateOutput(string fileName, DbStoredProcedureList storedProcedures)
{
var settings = new XmlWriterSettings { Indent = true, IndentChars = "\t" };
using (var writer = XmlWriter.Create(fileName, settings))
{
writer.WriteStartDocument();
writer.WriteStartElement("StoredProcedures");
foreach (var sp in storedProcedures.Items)
{
writer.WriteStartElement("Procedure");
writer.WriteAttributeString("Name", sp.SpName);
writer.WriteAttributeString("Command", sp.SpCommand.ToString(CultureInfo.InvariantCulture));
foreach (var parameter in sp.SpParameters)
{
writer.WriteStartElement("Parameter");
writer.WriteAttributeString("Name", parameter.Name);
writer.WriteAttributeString("Component", parameter.Component.Name);
var id = 0;
var parent = parameter.Component.GetOwner() as CommunicationInterfaceHandler;
if (parent != null) id = (int)parent.Header.Id;
writer.WriteAttributeString("InterfaceId", id.ToString(CultureInfo.InvariantCulture));
writer.WriteAttributeString("InterfaceType", parameter.Component.TypeOfInterface.ToString());
writer.WriteEndElement();
}
writer.WriteEndElement();
}
writer.WriteEndElement();
writer.WriteEndDocument();
}
Logger.Log(fileName + " output file created");
}
