public Visualiser()
{
InitializeComponent();
//sourceFile = "../../Resources/salestable.xml";
//tvvm = new TreeViewViewModel(sourceFile);
//ModelTreeView.DataContext = tvvm;
myToolbox = new Toolbox();
//string elementsFile = DirectoryHelper.getFilePath("Resources\\ToolBoxItems.xml");
//loadToolboxes(elementsFile);
suggestions = new ObservableCollection<Suggestion>();
suggestionsListBox.ItemsSource = suggestions;
//initiate the scheduling canvas
initiateSchedulingCanvas();
prettyPrinter = new XmlPrettyPrinter();
ShowSample = false;//set popup for sample to false
popupTimer = new System.Windows.Threading.DispatcherTimer();
popupTimer.Tick += new EventHandler(dispatcherTimer_Tick);
popupTimer.Interval = new TimeSpan(0, 0, 2);
logger = new Logger("VisualiserLogger");
logsTab.Content = logger;
}
public void ConvertToXML(string CSVFile, string XMLoutputFile)
{
//Read CSV file
using (CsvReader csvReader = new CsvReader(new StreamReader(CSVFile), true))
{
int fieldCount = csvReader.FieldCount;
//MessageBox.Show("Field count : " + fieldCount.ToString());
//read headers
string[] headers = csvReader.GetFieldHeaders();
XmlWriter writer = XmlWriter.Create(XMLoutputFile);
try
{
using (writer)
{
writer.WriteStartDocument();
writer.WriteStartElement("Root");
//read the rest of the file
while (csvReader.ReadNextRecord())
{
//create data element
writer.WriteStartElement("Data");
//reade each row
for (int i = 0; i < fieldCount; i++)
{
//check the value for illigal XML characters
StringBuilder buffer = new StringBuilder(csvReader[i].Length);
foreach (char c in csvReader[i])
{
if (IsLegalXmlChar(c))
{
buffer.Append(c);
}
}
writer.WriteElementString(headers[i], buffer.ToString());
}
//write end data element
writer.WriteEndElement();
}
//write end root element
writer.WriteEndElement();
//write end document
writer.WriteEndDocument();
}
}
finally
{
if (writer != null)
{
writer.Close();
XmlPrettyPrinter printer = new XmlPrettyPrinter();
printer.PrintXmlFile(XMLoutputFile);
}
}
}
//return csvDoc;
}