public BomLoad(ConfigurationElementBom bomConfig, BomInput input, BomOutput output)
{
_bomConfig = bomConfig;
_outputType = bomConfig.OutputType;
_input = input;
_output = output;
ValidateInput();
LoadInput();
}
public BomOutput(Excel.Application excelInstance, BomInput bomInput, ConfigurationElementBom bomElement, IFormatterConfiguration formatterConfiguration)
{
_excelAppInstance = excelInstance;
_formatterConfiguration = formatterConfiguration;
_bomInput = bomInput;
_bomConfig = bomElement;
foreach (ConfigurationElementColumn column in bomElement.ColumnCollection)
{
_bomDataTable.AddColumn(new BomDataColumn(column));
}
TemplateRow = new BomDataRowHolder(_bomDataTable);
}
public void FormatBom()
{
string outputFilePath = Path.Combine(_formatterConfiguration.OutputFolderPath, _productNumberModel.ProductNumber + "-output");
outputFilePath = Path.GetFullPath(Path.ChangeExtension(outputFilePath, Properties.Resources.OUTPUTFILE_EXTENTION));
ConfigurationElementBom selectedBomConfig = _formatterConfiguration.BomConfiguration.BomCollection[_selectedBom];
string inputFilePath = Path.Combine(_formatterConfiguration.InputFolderPath, _productNumberModel.ProductNumber);
inputFilePath = Path.GetFullPath(Path.ChangeExtension(inputFilePath, selectedBomConfig.InputFileExtention));
if (!File.Exists(inputFilePath))
{
throw new FileNotFoundException("File not found: " + inputFilePath + "\nMake sure the directory configurations are correct and that the files are named correctly and located in the right directory.");
}
try {
File.OpenWrite(outputFilePath).Close();
} catch (Exception) {
throw new FileNotFoundException("Unable to open file: " + outputFilePath + "\nCheck to see if you have it open.");
}
Stopwatch s = new Stopwatch();
s.Start();
while (Bootstrapper.GetExcelInstance() == null && s.ElapsedMilliseconds < 10000)
{
;
}
s.Stop();
if (Bootstrapper.GetExcelInstance() == null)
{
throw new ArgumentNullException("Unable to open instance of excel.");
}
Bootstrapper.ClearOpenWorkbooks();
BomInput bomInput = new BomInput(_productNumberModel, _formatterConfiguration.InputFolderPath, selectedBomConfig.InputFileExtention, selectedBomConfig);
BomOutput bomOutput = new BomOutput(Bootstrapper.GetExcelInstance(), bomInput, selectedBomConfig, _formatterConfiguration);
new BomLoad(selectedBomConfig, bomInput, bomOutput);
BomPopulations bomPopulations = new BomPopulations(bomOutput, selectedBomConfig);
BomCleanup bomCleanup = new BomCleanup(selectedBomConfig, bomPopulations);
bomOutput.CopyDataToExcel();
WindowManager windowManager = new WindowManager();
Collection <TreeViewItem> items = bomCleanup.OutputResults();
dynamic settings = new ExpandoObject();
settings.WindowStyle = WindowStyle.None;
settings.ShowInTaskbar = false;
settings.Title = "Cleanup Results";
bomOutput.SaveWorkbook();
BomFormatCleanUpReportPopUpViewModel cleanupViewModel = new BomFormatCleanUpReportPopUpViewModel(items);
windowManager.ShowDialog(new PopUpViewModel(cleanupViewModel), null, settings);
Bootstrapper.GetExcelInstance().Visible = true;
}
