public async Task TesteImportacaoSpoolEJunta() { var application = new Application(false); IObjectSpaceProvider objectSpaceProvider = application.serverApplication.ObjectSpaceProvider; var objectSpace = objectSpaceProvider.CreateObjectSpace(); var parametros = objectSpace.CreateObject <ParametrosImportSpoolJuntaExcel>(); MemoryStream stream = new MemoryStream(); stream.Seek(0, SeekOrigin.Begin); var arquivo = parametros.Padrao; arquivo.SaveToStream(stream); stream.Seek(0, SeekOrigin.Begin); using (var excelReader = new Module.ExcelDataReaderHelper.Excel.Reader(stream)) { var dtcollectionImport = excelReader.CreateDataTableCollection(false); var itba = new ImportSpoolEJunta(objectSpace, parametros); var progress = new Progress <ImportProgressReport>(itba.LogTrace); await Observable.Start(() => itba.ImportarSpools(dtcollectionImport["SGS"], progress)); await Observable.Start(() => itba.ImportarJuntas(dtcollectionImport["SGJ"], progress)); objectSpace.CommitChanges(); } }
private async void DialogControllerImportarPlanilha_Accepting(object sender, DialogControllerAcceptingEventArgs e) { DataTableCollection dtcollectionImport = null; ((DialogController)sender).AcceptAction.Enabled["NoEnabled"] = false; //Necessário para não fechar a janela após a conclusão do processamento e.Cancel = true; e.AcceptActionArgs.Action.Caption = "Procesando"; var parametros = (ParametrosImportSpoolJuntaExcel)e.AcceptActionArgs.SelectedObjects[0]; MemoryStream stream = new MemoryStream(); stream.Seek(0, SeekOrigin.Begin); var arquivo = parametros.Padrao; arquivo.SaveToStream(stream); stream.Seek(0, SeekOrigin.Begin); using (var excelReader = new ExcelDataReaderHelper.Excel.Reader(stream)) { dtcollectionImport = excelReader.CreateDataTableCollection(false); } var import = new ImportSpoolEJunta(objectSpace, parametrosImportSpoolJuntaExcel); var progress = new Progress <ImportProgressReport>(import.LogTrace); await Observable.Start(() => import.ImportarSpools(dtcollectionImport["SGS"], progress)); await Observable.Start(() => import.ImportarJuntas(dtcollectionImport["SGJ"], progress)); objectSpace.CommitChanges(); e.AcceptActionArgs.Action.Caption = "Finalizado"; ((DialogController)sender).AcceptAction.Enabled["NoEnabled"] = true; }