private void SetupDefinitionList()
{
if (DefinitionFileList.SelectedIndex > 0)
{
DefinitionFileNameTextBox.Text = ((ListBoxPair)DefinitionFileList.SelectedItem).Value;
// load from file
DefinitionFields = new ObservableCollection <MiddlewareField>(CSVConvertorFileManagement.ReadDefinitionFile(DefinitionFileNameTextBox.Text, CSVAppFolderOptions, ".xml"));
}
else
{
DefinitionFileNameTextBox.Text = string.Empty;
DefinitionFields = new ObservableCollection <MiddlewareField>();
}
definitionListBox.ItemsSource = DefinitionFields;
definitionListBox.DisplayMemberPath = "Description";
definitionListBox.SelectedValuePath = "MiddlewareFieldID";
// if clicked then either new or already loaded
// so enable edit panels
FieldListPanel.IsEnabled = true;
FieldListButtonsPanel.IsEnabled = true;
SetEditButtonsToDefaultState();
}
private void LoadMiddlewareDefinition(string definitionFile)
{
List <MiddlewareField> middlewareFields = CSVConvertorFileManagement.ReadDefinitionFile(definitionFile, CSVAppFolderMapping, ".xml");
DefinitionFields = new ObservableCollection <ListBoxPair>(middlewareFields.Select(x => new ListBoxPair {
Key = x.MiddlewareFieldIdentifier, Value = x.Description
}));
}
private int ConvertCSVFile(string csvFileName, bool firstRowHasHeaders)
{
// initialise
DefinitionFields = CSVConvertorFileManagement.ReadDefinitionFile(CurrentMappingDefinition.DefinitionFile, CSVAppFolder, ".xml");
MappingFilters = CurrentMappingDefinition.MappingFilters;
// load CSV file
if (!LoadCSVPayrollFile(csvFileName, firstRowHasHeaders))
{
return(-1);
}
CSVDataOut = new List <List <string> >();
MakeHeaderRow();
string excludeField = Properties.Settings.Default.Level2ExcludeField;
MakeCSVBody(excludeField);
return(WriteCSVFile());
}