//private readonly CmsEntities mCee; public Cji5Importer(ImportFileMetaData metadata) { MetaData = metadata; WorkSheetName = ImportWorkSheetName.Financial.ToString(); Cee = new CmsEntities(5000); Cee.Configuration.LazyLoadingEnabled = false; }
public TuningPropertiesImporter(ImportFileMetaData metadata) { MetaData = metadata; WorkSheetName = ImportWorkSheetName.TuningProperties.ToString(); Cee = new CmsEntities(5000); Cee.Configuration.LazyLoadingEnabled = false; }
public MobilePlantComponentImporter(ImportFileMetaData metadata) { MetaData = metadata; WorkSheetName = ImportWorkSheetName.Components.ToString(); Cee = new CmsEntities(5000); Cee.Configuration.LazyLoadingEnabled = false; }
public ElectricalImporter(ImportFileMetaData metadata) { MetaData = metadata; WorkSheetName = ImportWorkSheetName.ElectricalEquipments.ToString(); Cee = new CmsEntities(5000); Cee.Configuration.LazyLoadingEnabled = false; }
public InterlockRiskImporter(ImportFileMetaData metadata) { MetaData = metadata; WorkSheetName = ImportWorkSheetName.InterlockRisks.ToString(); Cee = new CmsEntities(5000); Cee.Configuration.LazyLoadingEnabled = false; }
public IssueSystemReferencesImporter(ImportFileMetaData metadata) { MetaData = metadata; WorkSheetName = ImportWorkSheetName.SystemReferences.ToString(); Cee = new CmsEntities(5000); Cee.Configuration.LazyLoadingEnabled = false; }
public PipeComponentImporter(ImportFileMetaData metadata) { MetaData = metadata; WorkSheetName = ImportWorkSheetName.Components.ToString(); Cee = new CmsEntities(); //mCee.CommandTimeout = 5000; Cee.Configuration.LazyLoadingEnabled = false; }
public PipeImporter(ImportFileMetaData metadata) { MetaData = metadata; WorkSheetName = ImportWorkSheetName.Pipes.ToString(); Cee = new CmsEntities(); Cee.Configuration.LazyLoadingEnabled = false; }
//private readonly CmsEntities mCee; public DocumentEquipmentImporter(ImportFileMetaData metadata) { MetaData = metadata; WorkSheetName = ImportWorkSheetName.RelatedEquipment.ToString(); //mCee = new CmsEntities(5000); Cee = new CmsEntities(); //mCee.CommandTimeout = 5000; Cee.Configuration.LazyLoadingEnabled = false; }
private readonly List<DocumentAssignedLocation> mSavedResults = new List<DocumentAssignedLocation>(); //just used for keep a count and displaying what was saved. #endregion Fields #region Constructors public DocumentLocationImporter(ImportFileMetaData metadata) { MetaData = metadata; WorkSheetName = ImportWorkSheetName.DocumentLocations.ToString(); }
public InstrumentImporter(ImportFileMetaData metadata) { MetaData = metadata; Cee = new CmsEntities(5000); Cee.Configuration.LazyLoadingEnabled = false; }
private void TransferGeneralExcelFiles(ImportFileMetaData metaData, FileInfo fileInfo) { try { Stream stream = fileInfo.OpenRead(); long sentFileSize = fileInfo.Length; long writtenFileSize = 0; int transferChunkSize = Utils.GetTransferChunkSize(stream); if (stream.Position > -1 && stream.Position < stream.Length) { int chunkSize = Utils.GetCurrentChunkSize(stream, transferChunkSize); byte[] fileBytes = new byte[chunkSize]; stream.Read(fileBytes, 0, chunkSize); CmsWebServiceClient cmsWebServiceClient = new CmsWebServiceClient(Utils.WcfBinding, Utils.WcfEndPoint); cmsWebServiceClient.UploadGenericImportExcelFileCompleted += (s1, e1) => { if (e1.Result.ErrorMessages.Any()) { ExcelTransferFailed(e1.Result); stream.Close(); return; } if (stream.Position > -1 && stream.Position < stream.Length) { //STILL GOING chunkSize = Utils.GetCurrentChunkSize(stream, transferChunkSize); fileBytes = new byte[chunkSize]; stream.Read(fileBytes, 0, chunkSize); writtenFileSize += e1.Result.WrittenByteArraySize; cmsWebServiceClient.UploadGenericImportExcelFileAsync(metaData, fileBytes, GetCanCreateProperties()); } else { writtenFileSize += e1.Result.WrittenByteArraySize; //Transfer complete stream.Close(); if (writtenFileSize < sentFileSize) { DbImportResult r = new DbImportResult(); r.ErrorMessages = new List<string>(); r.ErrorMessages.Add("There was a loss of information while attempting to transfer the Excel file. Please try again. "); ExcelTransferFailed(r); } else { ExcelTransferSucceeded(e1.Result); busyIndicator.IsBusy = false; } } }; cmsWebServiceClient.UploadGenericImportExcelFileAsync(mMetaData, fileBytes, GetCanCreateProperties()); } } catch (IOException) { ResultsRadTabControl.SelectedIndex = (int)ResultTab.Errors; ErrorsTextBox.Text = "Could not open the file - perhaps it is already open in another window? If so close it and try again. "; errorTabBlock.Text = string.Format("{0} ({1})", ERRORS, 1); ImportButton.IsEnabled = true; busyIndicator.IsBusy = false; } catch (Exception ex) { ResultsRadTabControl.SelectedIndex = (int)ResultTab.Errors; ErrorsTextBox.Text = ex.ToString(); ImportButton.IsEnabled = true; busyIndicator.IsBusy = false; } }
public DbImportResult ImportDocumentVersions(ImportFileMetaData metaData, byte[] content, bool append) { try { //EXCEL DOC string targetFolder = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "temp_imports"); if (!Directory.Exists(targetFolder)) { Directory.CreateDirectory(targetFolder); } WriteFileToDisk(metaData.FileName, content, targetFolder, false, targetFolder); //we now have the file saved on the server's disk so we can process safely... string fullPath = Path.Combine(targetFolder, targetFolder, metaData.FileName); metaData.FullFileName = fullPath; IImporter importer = ImporterFactory.CreateImporter(metaData); DbImportResult dbImportResult = new DbImportResult(); importer.MessageRaised += (m, s) => { switch (m) { case CommonUtils.MessageType.Error: dbImportResult.ErrorMessages.Add(s); break; case CommonUtils.MessageType.Warning: dbImportResult.WarningMessages.Add(s); break; case CommonUtils.MessageType.AlreadyExists: Logger.Info(string.Format("added filename '{0}' to AlreadyExistsFileNames list.", s)); dbImportResult.AlreadyExistsFileNames.Add(s); break; case CommonUtils.MessageType.Added: case CommonUtils.MessageType.Info: dbImportResult.InformationMessages.Add(s); break; } }; DbImportResult finalResult = new DbImportResult(); finalResult = importer.Import(false); // set this property last as we may have had a new result object newed up inside an importer. if (dbImportResult.ErrorMessages != null && dbImportResult.ErrorMessages.Any()) { finalResult.ErrorMessages.AddRange(dbImportResult.ErrorMessages); } if (dbImportResult.WarningMessages != null && dbImportResult.WarningMessages.Any()) { finalResult.WarningMessages.AddRange(dbImportResult.WarningMessages); } finalResult.WrittenByteArraySize = GetFileSizeWritten(fullPath); return finalResult; } catch (Exception ex) { Logger.Error("", ex, "CMS.Boddington.ImporterPlugin.PluginImport"); DbImportResult errorResult = new DbImportResult(); errorResult.ErrorMessages.Add("Unhandled Exceptions have occured as follows:"); errorResult.ErrorMessages.Add("Message : " + ex.Message); errorResult.ErrorMessages.Add("Stack : " + ex); if (ex.InnerException != null) { errorResult.ErrorMessages.Add("Message : " + ex.InnerException.Message); errorResult.ErrorMessages.Add("Stack : " + ex.InnerException); } return errorResult; } }
internal static IImporter CreateImporter(ImportFileMetaData metaData, DocumentVersion documentVersion = null, BaseAttachmentDto attachmentDto = null) { switch (metaData.ImportType) { case CommonUtils.ImportType.CreateRelatedDocuments: return new RelatedDocumentImporter(metaData); case CommonUtils.ImportType.CreateIssue: case CommonUtils.ImportType.UpdateIssue: return new IssueImporter(metaData); case CommonUtils.ImportType.CreateMilestones: return new MilestoneImporter(metaData); case CommonUtils.ImportType.CreateUpdateFinancial: return new FinancialImporter(metaData); case CommonUtils.ImportType.CreateIssueReferences: case CommonUtils.ImportType.UpdateIssueReferences: return new IssueSystemReferencesImporter(metaData); case CommonUtils.ImportType.Cji3: return new Cji3Importer(metaData); case CommonUtils.ImportType.Cji5: return new Cji5Importer(metaData); case CommonUtils.ImportType.CreatePipe: case CommonUtils.ImportType.UpdatePipe: return new PipeImporter(metaData); case CommonUtils.ImportType.CreatePipeComponent: case CommonUtils.ImportType.UpdatePipeComponent: return new PipeComponentImporter(metaData); case CommonUtils.ImportType.CreateMechanical: case CommonUtils.ImportType.UpdateMechanical: return new MechanicalImporter(metaData); case CommonUtils.ImportType.CreateMechanicalComponent: case CommonUtils.ImportType.UpdateMechanicalComponent: return new MechanicalComponentImporter(metaData); case CommonUtils.ImportType.CreateElectrical: case CommonUtils.ImportType.UpdateElectrical: return new ElectricalImporter(metaData); case CommonUtils.ImportType.CreateElectricalComponent: case CommonUtils.ImportType.UpdateElectricalComponent: return new ElectricalComponentImporter(metaData); case CommonUtils.ImportType.CreateInstrument: case CommonUtils.ImportType.UpdateInstrument: return new InstrumentImporter(metaData); case CommonUtils.ImportType.CreateInstrumentComponent: case CommonUtils.ImportType.UpdateInstrumentComponent: return new InstrumentComponentImporter(metaData); case CommonUtils.ImportType.CreateCalibrationComponent: case CommonUtils.ImportType.UpdateCalibrationComponent: return new CalibrationComponentImporter(metaData); case CommonUtils.ImportType.CreateMobilePlant: case CommonUtils.ImportType.UpdateMobilePlant: return new MobilePlantImporter(metaData); case CommonUtils.ImportType.CreateMobilePlantComponent: case CommonUtils.ImportType.UpdateMobilePlantComponent: return new MobilePlantComponentImporter(metaData); case CommonUtils.ImportType.CreateDocument: case CommonUtils.ImportType.UpdateDocument: return new DocumentImporter(metaData); case CommonUtils.ImportType.CreateDocumentVersionStep1: case CommonUtils.ImportType.UpdateDocumentVersion: //we don't need the file return new DocumentVersionImporter(metaData); case CommonUtils.ImportType.CreateDocumentLocations: return new DocumentLocationImporter(metaData); case CommonUtils.ImportType.CreateAttachmentDtoStep1: case CommonUtils.ImportType.UpdateAttachment: //we don't need the file return new AttachmentImporter(metaData); case CommonUtils.ImportType.LinkRelatedEquipmentDocument: return new DocumentEquipmentImporter(metaData); //CONTROL SYSTEM case CommonUtils.ImportType.CreateControlsSystems: case CommonUtils.ImportType.UpdateControlSystems: return new ControlSystemImporter(metaData); case CommonUtils.ImportType.CreateControlComponents: case CommonUtils.ImportType.UpdateControlComponents: return new ControlComponentImporter(metaData); case CommonUtils.ImportType.CreateEngineeringProperties: case CommonUtils.ImportType.UpdateEngineeringProperties: return new EngineeringPropertiesImporter(metaData); case CommonUtils.ImportType.CreateTuningProperties: case CommonUtils.ImportType.UpdateTuningProperties: return new TuningPropertiesImporter(metaData); case CommonUtils.ImportType.CreateInterlocks: case CommonUtils.ImportType.UpdateInterlocks: return new InterlockImporter(metaData); case CommonUtils.ImportType.CreateInterlockRisks: case CommonUtils.ImportType.UpdateInterlockRisks: return new InterlockRiskImporter(metaData); //ALARMS case CommonUtils.ImportType.CreateAlarms: case CommonUtils.ImportType.UpdateAlarms: return new AlarmImporter(metaData); //Testing case CommonUtils.ImportType.CreateComponentTestingProperties: case CommonUtils.ImportType.UpdateComponentTestingProperties: return new ComponentTestingPropertiesImporter(metaData); } return null; }
public DbImportResult PluginImport(ImportFileMetaData metaData, byte[] content, bool canCreateProperties) { string targetFolder = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "temp_imports"); if (!Directory.Exists(targetFolder)) { Directory.CreateDirectory(targetFolder); } string path = Guid.NewGuid().ToString(); try { WriteFileToDisk(metaData.FileName, content, path, false, targetFolder); //we now have the file saved on the server's disk so we can process safely... string fullPath = Path.Combine(targetFolder, path, metaData.FileName); metaData.FullFileName = fullPath; IImporter importer = ImporterFactory.CreateImporter(metaData); DbImportResult raisedMessages = new DbImportResult(); importer.MessageRaised += (m, s) => { switch (m) { case CommonUtils.MessageType.Error: raisedMessages.ErrorMessages.Add(s); break; case CommonUtils.MessageType.Warning: raisedMessages.WarningMessages.Add(s); break; case CommonUtils.MessageType.AlreadyExists: Logger.Info(string.Format("added filename '{0}' to AlreadyExistsFileNames list.", s)); raisedMessages.AlreadyExistsFileNames.Add(s); break; case CommonUtils.MessageType.Added: case CommonUtils.MessageType.Info: raisedMessages.InformationMessages.Add(s); break; } }; //IMPORT STARTS HERE---------------------------- DbImportResult dbImportResult = importer.Import(canCreateProperties); //---------------------------------------------- if (raisedMessages.WarningMessages.Count > 0) { dbImportResult.WarningMessages.InsertRange(0, raisedMessages.WarningMessages); } if (raisedMessages.InformationMessages.Count > 0) { dbImportResult.InformationMessages.InsertRange(0, raisedMessages.InformationMessages); } if (raisedMessages.ErrorMessages.Count > 0) { dbImportResult.ErrorMessages.InsertRange(0, raisedMessages.ErrorMessages); } if (raisedMessages.AlreadyExistsFileNames.Count > 0) { Logger.Info(string.Format("Adding {0} AlreadyExistsFileNames", raisedMessages.AlreadyExistsFileNames.Count)); dbImportResult.AlreadyExistsFileNames.InsertRange(0, raisedMessages.AlreadyExistsFileNames); } dbImportResult.WrittenByteArraySize = GetFileSizeWritten(fullPath); return dbImportResult; } catch (Exception ex) { Logger.Error("", ex, "CMS.Boddington.ImporterPlugin.PluginImport"); DbImportResult errorResult = new DbImportResult(); errorResult.ErrorMessages.Add("Unhandled Exceptions have occured as follows:"); errorResult.ErrorMessages.Add("Message : " + ex.Message); errorResult.ErrorMessages.Add("Stack : " + ex); if (ex.InnerException != null) { errorResult.ErrorMessages.Add("Message : " + ex.InnerException.Message); errorResult.ErrorMessages.Add("Stack : " + ex.InnerException); } return errorResult; } finally { //we can clean-up if (Directory.Exists(Path.Combine(targetFolder, path))) { Directory.Delete(Path.Combine(targetFolder, path), true); } } }
public AttachmentImporter(ImportFileMetaData metaData, BaseAttachmentDto baseAttachmentDto = null) { MetaData = metaData; WorkSheetName = ImportWorkSheetName.Attachments.ToString(); }