public ComponentTestingPropertyDataAdapter(OleDbDataReader dr, IList<string> dynamicList, int startColumn) { ControlSystemName = ""; ComponentName = ""; ControlSystemName = dr.SafeString((int) TestingPropertyColumn.ControlSystemName).Trim(); ComponentName = dr.SafeString((int) TestingPropertyColumn.ComponentName).Trim(); DynamicProperties = new List<DynamicProperty>(); if (dynamicList != null && dynamicList.Any()) { for (var d = 0; d < dynamicList.Count(); d++) { var p = dynamicList[d]; var property = new DynamicProperty { PropertyName = p, PropertyValue = dr.SafeString(startColumn + d) }; DynamicProperties.Add(property); } } }
public ElectricalDataAdapter(OleDbDataReader dr, string workSheetName, int rowNumber, CommonUtils.ImportType importType) { RowNumber = rowNumber; WorkSheetName = workSheetName; Tag = dr.SafeString((int) EquipmentColumn.Tag).Trim(); EquipmentType = dr.SafeString((int) EquipmentColumn.Type).Trim(); Description = dr.SafeString((int) EquipmentColumn.Description).Trim(); Notes = dr.SafeString((int) EquipmentColumn.Notes); AreaNumber = dr.SafeString((int)EquipmentColumn.Area).Trim(); Specification = dr.SafeString((int)EquipmentColumn.Spec).Trim(); PandID = dr.SafeString((int)EquipmentColumn.PID).Trim(); MaintSysId = dr.SafeString((int)EquipmentColumn.MaintSysId); string classifiedString = dr.SafeString((int)EquipmentColumn.Classified); bool classified; if (bool.TryParse(classifiedString, out classified)) { Classified = classified; } string isActiveString = dr.SafeString((int)EquipmentColumn.IsActive); bool isActive; if (bool.TryParse(isActiveString, out isActive)) { IsActive = isActive; } Validate(importType==CommonUtils.ImportType.CreateElectrical); }
public EngineeringPropertyDataAdapter(OleDbDataReader dr, IList<string> dynamicList, int startColumn) { ControlSystemName = ""; ComponentName = ""; ControlSystemName = dr.SafeString((int)EngineeringPropertyColumn.ControlSystemName).Trim(); ComponentName = dr.SafeString((int)EngineeringPropertyColumn.ComponentName).Trim(); DynamicProperties = new List<DynamicProperty>(); if (dynamicList != null && dynamicList.Any()) { for (int d = 0; d < dynamicList.Count(); d++) { string p = dynamicList[d]; DynamicProperty property = new DynamicProperty(); property.PropertyName = p; property.PropertyValue = dr.SafeString(startColumn + d); DynamicProperties.Add(property); } } }
public VendorDataAdapter(OleDbDataReader dr, int rowNumber) { ErrorMessages = new List<string>(); //Name Name = dr.SafeString((int)VendorColumn.VendorName); if (String.IsNullOrEmpty(Name)) { ErrorMessages.Add(string.Format("{0} returned null, please check the format of this cell in Excel (set to Text). Row number '{1}'. Skipping ", VendorColumn.VendorName, rowNumber)); } //Number string numberString = string.Empty; numberString = dr.SafeString((int)VendorColumn.VendorNumber); int number; if (int.TryParse(numberString, out number)) { Number = number; } else { ErrorMessages.Add(string.Format("Could not convert {0} '{1}' to number. Rown number '{2}'. Skipping ", VendorColumn.VendorNumber, numberString, rowNumber)); } //City City = dr.SafeString((int)VendorColumn.VendorCity); if (String.IsNullOrEmpty(City)) { ErrorMessages.Add(string.Format("{0} returned null, please check the format of this cell in Excel (set to Text). Row number '{1}'. Skipping ", VendorColumn.VendorCity, rowNumber)); } }
public InterlockPropertyDataAdapter(OleDbDataReader dr) { ControlSystemName = string.Empty; InterlockTypeName = string.Empty; ControlSystemName = dr.SafeString((int)InterlockPropertyColumn.ControlSystemName).Trim(); InterlockTypeName = dr.SafeString((int)InterlockPropertyColumn.InterlockType).Trim(); }
public RelatedDocumentDataAdapter(OleDbDataReader dr) { EquipmentName = string.Empty; DocumentName = string.Empty; EquipmentName = dr.SafeString((int)CommonColumn.EquipmentName).Trim(); DocumentName = dr.SafeString((int)CommonColumn.DocumentName).Trim(); }
public DocumentLocationDataAdapter(OleDbDataReader dr, int rowNumber, IEnumerable<DocumentLocation> documentLocations, IEnumerable<CmsWebService.Document> documents) { DocumentName = string.Empty; LocationName = string.Empty; RowNumber = rowNumber; //DOCUMENT DocumentName = dr.SafeString((int)DocumentLocationColumn.DocumentName).Trim(); if (string.IsNullOrEmpty(DocumentName)) { ErrorMessages.Add(string.Format("The DocumentName column is empty in the excel document for Excel row {0}.", rowNumber)); return; } CmsWebService.Document document = (from x in documents where string.Compare(x.Name, DocumentName, true, CultureInfo.CurrentCulture) == 0 select x).FirstOrDefault(); if (document == null) { ErrorMessages.Add(string.Format("Excel Row {1}. Cannot find a Document with the Name {0} - skipping...", DocumentName, rowNumber)); return; } if (!document.IsActive) { ErrorMessages.Add(string.Format("Excel Row {1}. The Document {0} is not Active - skipping...", DocumentName, rowNumber)); return; } DocumentId = document.Id; //LOCATION LocationName = dr.SafeString((int)DocumentLocationColumn.LocationName).Trim(); if (string.IsNullOrEmpty(LocationName)) { ErrorMessages.Add(string.Format("The LocaitonName column is empty in the excel document for Excel row {0}.", rowNumber)); return; } DocumentLocation documentLocation = (from x in documentLocations where string.Compare(x.Name, LocationName, true, CultureInfo.CurrentCulture) == 0 select x).FirstOrDefault(); if (documentLocation == null) { ErrorMessages.Add(string.Format("Excel Row {1}. Cannot find an Document Location using Name {0}. - skipping...", LocationName, rowNumber)); return; } if (!documentLocation.IsActive) { ErrorMessages.Add(string.Format("Excel Row {1}. The DocumentLocation {0} is not Active - skipping...", LocationName, rowNumber)); return; } LocationId = documentLocation.Id; }
public AttachmentDataAdapter(OleDbDataReader dr, int rowNumber) { AttachmentDto = new BaseAttachmentDto(); AttachmentDto.Tag = dr.SafeString((int)AttachmentColumn.Tag).Trim(); AttachmentDto.Type = dr.SafeString((int)AttachmentColumn.Type).Trim(); AttachmentDto.AttachmentType = dr.SafeString((int)AttachmentColumn.AttachmentType).Trim(); AttachmentDto.Filename = dr.SafeString((int)AttachmentColumn.Filename).Trim(); AttachmentDto.Description = dr.SafeString((int)AttachmentColumn.Description).Trim(); CheckType(rowNumber); }
public DocumentEquipmentDataAdapter(OleDbDataReader dr, int rowNumber, CommonUtils.ImportType importType) { DocumentName = string.Empty; EquipmentTypeName = string.Empty; RowNumber = rowNumber; mImportType = importType; DocumentName = dr.SafeString((int)DocumentEquipmentColumn.DocumentName).Trim(); EquipmentTypeName = dr.SafeString((int)DocumentEquipmentColumn.EquipmentType).Trim(); Tag = dr.SafeString((int)DocumentEquipmentColumn.Tag).Trim(); this.Validate(rowNumber, importType == CommonUtils.ImportType.LinkRelatedEquipmentDocument); }
public InstrumentComponentDataAdapter(OleDbDataReader dr, List<InstrumentProperty> existingInstrumentProperties, IList<string> spreadSheetComponentPropertyNames, int rowNumber, bool canCreateProperties, CommonUtils.ImportType importType) { base.PopulateCommonProperties(dr); RowNumber = rowNumber; mImportType = importType; int k = 0; const int StartColumnIndex = (int)BaseComponentColumn.Model + 1; for (int i = StartColumnIndex; i < StartColumnIndex + spreadSheetComponentPropertyNames.Count; i++) { if (string.IsNullOrEmpty(dr.SafeString(i))) { continue; } string propertyName = spreadSheetComponentPropertyNames[k]; k++; InstrumentProperty property = (from x in existingInstrumentProperties where x.Name.ToLower() == propertyName.ToLower() select x).FirstOrDefault(); if (property != null) { PropertyValues.Add(property.Name, dr.SafeValueToString(i)); } else { if (canCreateProperties) { if (!PropertyValues.ContainsValue(dr.SafeString(i))) { PropertyValues.Add(propertyName, dr.SafeString(i)); } } else { ErrorMessages.Add(RaiseMissingPropertyMessage(ComponentName, rowNumber, propertyName)); break; } } } base.Validate(rowNumber, mImportType==CommonUtils.ImportType.CreateInstrumentComponent); }
public SystemReferenceDataAdapter(OleDbDataReader dr, string workSheetName, int rowNumber) { RowNumber = rowNumber; WorkSheetName = workSheetName; ProjectCode = dr.SafeString((int)ProjectWbsColumn.ProjectCode).Trim(); WbsElement = dr.SafeString((int)ProjectWbsColumn.WbsElement).Trim(); WbsElementDescription = dr.SafeString((int)ProjectWbsColumn.WbsElementDescription).Trim(); SpendClassification = dr.SafeString((int)ProjectWbsColumn.SpendClassification).Trim(); var statusString = dr.SafeString((int)ProjectWbsColumn.WbsStatus).Trim(); if (!String.IsNullOrEmpty(statusString)) { //Status in Excel will be Either Open (write 1 to table) or Closed (write 0 to table). Status = statusString.ToLower() == "open" ? true : false; } string actualsString = dr.SafeString((int)ProjectWbsColumn.Actuals).Trim(); if (String.IsNullOrEmpty(actualsString)) { Actuals = null; } else { decimal number; if (Decimal.TryParse(actualsString, NumberStyles.Any, null, out number)) { Actuals = number; } else { Errors.Add(String.Format("Could not parse Actual '{0}' on Line number {1} to decimal. Skipping...", actualsString, rowNumber)); } } string wbsBudgetString = dr.SafeString((int)ProjectWbsColumn.WbsBudget).Trim(); if (String.IsNullOrEmpty(wbsBudgetString)) { WbsBudget = null; } else { decimal number2; if (Decimal.TryParse(wbsBudgetString, NumberStyles.Any, null, out number2)) { WbsBudget = number2; } else { Errors.Add(String.Format("Could not parse Actual '{0}' on Line number {1} to decimal. Skipping...", actualsString, rowNumber)); } } }
public InterlockDataAdapter(OleDbDataReader dr ,IList<string> dynamicList, int startColumn) { ControlSystemName = string.Empty; InterlockTypeName = Number = string.Empty; Cause = string.Empty; Description = string.Empty; ControlSystemName = dr.SafeString((int)InterlockColumn.ControlSystemName).Trim(); InterlockTypeName = dr.SafeString((int)InterlockColumn.InterlockType).Trim(); Number = dr.SafeString((int)InterlockColumn.Number).Trim(); Cause = dr.SafeString((int)InterlockColumn.Cause).Trim(); Description = dr.SafeString((int)InterlockColumn.Description).Trim(); DynamicProperties = new List<DynamicProperty>(); if (dynamicList != null && dynamicList.Any()) { for (int d = 0; d < dynamicList.Count(); d++) { string p = dynamicList[d]; DynamicProperty property = new DynamicProperty(); property.PropertyName = p; property.PropertyValue = dr.SafeString(startColumn + d); DynamicProperties.Add(property); } } }
public MechanicalDataAdapter(OleDbDataReader dr, string workSheetName, int rowNumber) { RowNumber = rowNumber; WorkSheetName = workSheetName; Tag = dr.SafeString((int)EquipmentColumn.Tag); EquipmentType = dr.SafeString((int)EquipmentColumn.Type).Trim(); Description = dr.SafeString((int)EquipmentColumn.Description).Trim(); Notes = dr.SafeString((int)EquipmentColumn.Notes).Trim(); AreaNumber = dr.SafeString((int)EquipmentColumn.Area).Trim(); Specification = dr.SafeString((int)EquipmentColumn.Spec).Trim(); PandID = dr.SafeString((int)EquipmentColumn.PID).Trim(); MaintSysId = dr.SafeString((int)EquipmentColumn.MaintSysId); Classified = dr.SafeNullableBool((int)EquipmentColumn.Classified); IsActive = dr.SafeNullableBool((int)EquipmentColumn.IsActive); }
public ControlDataAdapter(OleDbDataReader dr) { ControlSystemName = string.Empty; ControlSytemTypeName = string.Empty; AreaNumber = string.Empty; GraphicName = string.Empty; Description = string.Empty; UpperEquipmentName = string.Empty; PIDName = string.Empty; SpecificationName = string.Empty; Notes = string.Empty; Classified = string.Empty; ControlSystemName = dr.SafeString((int)ControlColumn.ControlSystemName).Trim(); ControlSytemTypeName = dr.SafeString((int)ControlColumn.ControlSystemTypeName).Trim(); AreaNumber = dr.SafeString((int)ControlColumn.AreaNumber).Trim(); GraphicName = dr.SafeString((int)ControlColumn.GraphicName).Trim(); Description = dr.SafeString((int)ControlColumn.Description).Trim(); UpperEquipmentName = dr.SafeString((int)ControlColumn.UpperEquipmentName).Trim(); PIDName = dr.SafeString((int)ControlColumn.PIDName).Trim(); SpecificationName = dr.SafeString((int)ControlColumn.SpecificationName).Trim(); Notes = dr.SafeString((int)ControlColumn.Notes).Trim(); Classified = dr.SafeString((int)ControlColumn.Classified).Trim(); }
public InstrumentDataAdapter(OleDbDataReader dr, string workSheetName, int rowNumber, CommonUtils.ImportType importType) { RowNumber = rowNumber; WorkSheetName = workSheetName; ErrorMessages = new List<string>(); Tag = dr.SafeString((int)InstrumentColumn.Tag).Trim(); EquipmentType = dr.SafeString((int)InstrumentColumn.Type).Trim(); Description = dr.SafeString((int)InstrumentColumn.Description).Trim(); Notes = dr.SafeString((int)InstrumentColumn.Notes).Trim(); AreaNumber = dr.SafeString((int)InstrumentColumn.Area).Trim(); Specification = dr.SafeString((int)InstrumentColumn.Spec).Trim(); PandID = dr.SafeString((int)InstrumentColumn.PID).Trim(); MaintSysId = dr.SafeString((int)InstrumentColumn.MaintSysId); Classified = dr.SafeNullableBool((int) InstrumentColumn.Classified); VerificationFrequency = dr.SafeString((int)InstrumentColumn.VerificationFrequency); IsActive = dr.SafeNullableBool((int) InstrumentColumn.IsActive); Validate(importType==CommonUtils.ImportType.CreateInstrument); }
public MilestoneDataAdapter(OleDbDataReader dr) { IssueId = string.Empty; MilestoneType = string.Empty; Description = string.Empty; AssignedTo = string.Empty; PlannedStart = string.Empty; PlannedEnd = string.Empty; ActualStart = string.Empty; ActualEnd = string.Empty; IssueId = dr.SafeString((int) MilestoneColumn.IssueId).Trim(); MilestoneType = dr.SafeString((int) MilestoneColumn.MilestoneType).Trim(); Description = dr.SafeString((int) MilestoneColumn.Description).Trim(); AssignedTo = dr.SafeString((int) MilestoneColumn.AssignedTo).Trim(); PlannedStart = dr.SafeString((int) MilestoneColumn.PlannedStart).Trim(); PlannedEnd = dr.SafeString((int) MilestoneColumn.PlannedEnd).Trim(); ActualStart = dr.SafeString((int) MilestoneColumn.ActualStart).Trim(); ActualEnd = dr.SafeString((int) MilestoneColumn.ActualEnd).Trim(); }
public MobilePlantDataAdapter(OleDbDataReader dr, string workSheetName, int rowNumber, CommonUtils.ImportType importType) { RowNumber = rowNumber; WorkSheetName = workSheetName; Hirer = string.Empty; Owner = string.Empty; Registration = string.Empty; Tag = dr.SafeString((int)MobilePlantColumn.Tag).Trim(); EquipmentType = dr.SafeString((int)MobilePlantColumn.Type).Trim(); Description = dr.SafeString((int)MobilePlantColumn.Description).Trim(); Notes = dr.SafeString((int)MobilePlantColumn.Notes); Hirer = dr.SafeString((int)MobilePlantColumn.Hirer); Owner = dr.SafeString((int)MobilePlantColumn.Owner); AreaNumber = dr.SafeString((int)MobilePlantColumn.Area).Trim(); Registration = dr.SafeString((int)MobilePlantColumn.Registration).Trim(); Expiry = dr.SafeNullableDate((int)MobilePlantColumn.Expiry); Classified = dr.SafeNullableBool((int)MobilePlantColumn.Classified); MaintSysId = dr.SafeString((int)MobilePlantColumn.MaintSysId); IsActive = dr.SafeNullableBool((int)MobilePlantColumn.IsActive); Validate(importType == CommonUtils.ImportType.CreateMobilePlant); }
public ControlComponentDataAdapter(OleDbDataReader dr) { ControlSystemName = string.Empty; ComponentName = string.Empty; ComponentTypeName = string.Empty; Ordinal = string.Empty; Description = string.Empty; ModelName = string.Empty; ManufactuerName = string.Empty; ControlSystemName = dr.SafeString((int)ControlComponentColumn.ControlSystemName).Trim(); ComponentName = dr.SafeString((int)ControlComponentColumn.ComponentName).Trim(); ComponentTypeName = dr.SafeString((int)ControlComponentColumn.ComponentTypeName).Trim(); Ordinal = dr.SafeString((int)ControlComponentColumn.Ordinal).Trim(); Description = dr.SafeString((int)ControlComponentColumn.Description).Trim(); ModelName = dr.SafeString((int)ControlComponentColumn.ModelName).Trim(); ManufactuerName = dr.SafeString((int)ControlComponentColumn.ManufactuerName).Trim(); }
public IssueSystemReferencesDataAdapter(OleDbDataReader dr, int rowNumber) { IssueId = string.Empty; SystemReferenceType = string.Empty; Number = string.Empty; Description = string.Empty; EstValue = string.Empty; ActualValue = string.Empty; Funding = string.Empty; RowNumber = rowNumber; IssueId = dr.SafeString((int)IssueSystemReferencesColumn.IssueId).Trim(); SystemReferenceType = dr.SafeString((int)IssueSystemReferencesColumn.SystemReferenceType).Trim(); Number = dr.SafeString((int)IssueSystemReferencesColumn.Number).Trim(); Description = dr.SafeString((int)IssueSystemReferencesColumn.Description).Trim(); EstValue = dr.SafeString((int)IssueSystemReferencesColumn.EstValue).Trim(); ActualValue = dr.SafeString((int)IssueSystemReferencesColumn.ActualValue).Trim(); Funding = dr.SafeString((int)IssueSystemReferencesColumn.Funding).Trim(); }
public InterlockRiskDataAdapter(OleDbDataReader dr) { ControlSystemName = string.Empty; InterlockTypeName = string.Empty; RiskCategory = string.Empty; Consequence = string.Empty; Likelihood = string.Empty; Description = string.Empty; ControlSystemName = dr.SafeString((int)InterlockRiskColumn.ControlSystemName).Trim(); InterlockTypeName = dr.SafeString((int)InterlockRiskColumn.InterlockType).Trim(); RiskCategory = dr.SafeString((int)InterlockRiskColumn.RiskCategory).Trim(); Consequence = dr.SafeString((int)InterlockRiskColumn.Consequence).Trim(); Likelihood = dr.SafeString((int)InterlockRiskColumn.Likelihood).Trim(); Description = dr.SafeString((int)InterlockRiskColumn.Description).Trim(); }
public DocumentVersionDataAdapter(OleDbDataReader dr, int rowNumber, ImportFileMetaData metaData) { DocumentName = string.Empty; User = string.Empty; FileName = string.Empty; ApprovedBy = string.Empty; RowNumber = rowNumber; mMetaData = metaData; DocumentName = dr.SafeString((int)DocumentVersionColumn.DocumentName).Trim(); User = dr.SafeString((int)DocumentVersionColumn.User).Trim(); FileName = dr.SafeString((int)DocumentVersionColumn.FileName).Trim(); try { Version = dr.SafeDocumentVersionNumber((int)DocumentVersionColumn.Version); } catch (Exception ex) { ErrorMessages.Add(string.Format(ex.Message, DocumentName, rowNumber)); } Date = dr.SafeDate((int)DocumentVersionColumn.Date); Description = dr.SafeString((int)DocumentVersionColumn.Description).Trim(); if (string.IsNullOrEmpty(dr.SafeString((int)DocumentVersionColumn.Native))) { ErrorMessages.Add(string.Format("Document Name '{0}', row {1}. The Native column is empty.", DocumentName, rowNumber)); } else { string isActiveString = dr.SafeString((int)DocumentVersionColumn.Native).Trim().ToLower(); if (isActiveString == "true" || isActiveString == "native" || isActiveString == "t" || isActiveString == "1") { Native = true; } } Validate(rowNumber, true); }
public AlarmDataAdapter(OleDbDataReader dr, string workSheetName, int rowNumber, CommonUtils.ImportType importType) { RowNumber = rowNumber; WorkSheetName = workSheetName; ControlSystemName = dr.SafeString((int)AlarmColumn.ControlSystemName).Trim(); ComponentName = dr.SafeString((int)AlarmColumn.ComponentName).Trim(); AlarmPropertyName = dr.SafeString((int)AlarmColumn.AlarmPropertyName).Trim(); Enabled = dr.SafeNullableBool((int)AlarmColumn.Enabled); OnDelay = dr.SafeNullableInt((int)AlarmColumn.OnDelay); OffDelay = dr.SafeNullableInt((int)AlarmColumn.OffDelay); ActivationExpr = dr.SafeString((int)AlarmColumn.ActivationExpr).Trim(); MaskingExpr = dr.SafeString((int)AlarmColumn.MaskingExpr).Trim(); AlarmCalcExprEnabled = dr.SafeNullableBool((int)AlarmColumn.AlarmCalcExprEnabled); AlarmCalcExpr = dr.SafeString((int)AlarmColumn.AlarmCalcExpr).Trim(); Purpose = dr.SafeString((int)AlarmColumn.Purpose).Trim(); Consequence = dr.SafeString((int)AlarmColumn.Consequence).Trim(); Response = dr.SafeString((int)AlarmColumn.Response).Trim(); Notes = dr.SafeString((int)AlarmColumn.Notes).Trim(); Guidance = dr.SafeString((int)AlarmColumn.Guidance).Trim(); Tested = dr.SafeNullableBool((int)AlarmColumn.Tested); TestedDate = dr.SafeNullableDate((int)AlarmColumn.TestedDate); TestedUser = dr.SafeString((int)AlarmColumn.TestedUser).Trim(); Reviewed = dr.SafeNullableBool((int)AlarmColumn.Reviewed); ReviewedDate = dr.SafeNullableDate((int)AlarmColumn.ReviewedDate); ReviewedUser = dr.SafeString((int)AlarmColumn.ReviewedUser).Trim(); Reportable = dr.SafeNullableBool((int)AlarmColumn.Reportable); ReportableDate = dr.SafeNullableDate((int)AlarmColumn.ReportableDate); ReportableUser = dr.SafeString((int)AlarmColumn.ReportableUser).Trim(); PurposeIsIndendedNull = dr.IntendedNull((int)AlarmColumn.Purpose); ConsequenceIsIntendedNull = dr.IntendedNull((int)AlarmColumn.Consequence); ResponseTimeIsIndendedNull = dr.IntendedNull((int)AlarmColumn.Response); AlarmCalcExprIsIntendedNull = dr.IntendedNull((int)AlarmColumn.AlarmCalcExpr); ActivationExprIsIntendedNull = dr.IntendedNull((int)AlarmColumn.ActivationExpr); MaskingExprIsIntendedNull = dr.IntendedNull((int)AlarmColumn.MaskingExpr); GuidanceIsIntendedNull = dr.IntendedNull((int)AlarmColumn.Guidance); OnDelayIsIntendedNull = dr.IntendedNull((int)AlarmColumn.OnDelay); OffDelayIsIntendedNull = dr.IntendedNull((int)AlarmColumn.OffDelay); NotesIsIntendedNull = dr.IntendedNull((int)AlarmColumn.Notes); TestedDateIsIntendedNull = dr.IntendedNull((int)AlarmColumn.TestedDate); TestedUserIsIntendedNull = dr.IntendedNull((int)AlarmColumn.TestedUser); ReviewedIsIntendedNull = dr.IntendedNull((int)AlarmColumn.Reviewed); ReviewedDateIsIntendedNull = dr.IntendedNull((int)AlarmColumn.ReviewedDate); ReviewedUserIsIntendedNull = dr.IntendedNull((int)AlarmColumn.ReviewedUser); ReportabledIsIntendedNull = dr.IntendedNull((int)AlarmColumn.Reportable); ReportabledDateIsIntendedNull = dr.IntendedNull((int)AlarmColumn.ReportableDate); ReportableUserIsIntendedNull = dr.IntendedNull((int)AlarmColumn.ReportableUser); }
protected virtual void PopulateCommonProperties(OleDbDataReader dr) { Tag = string.Empty; ComponentName = string.Empty; ComponentType = string.Empty; ComponentDescription =string.Empty; Manufacturer = string.Empty; Model = string.Empty; Tag = dr.SafeString((int) BaseComponentColumn.Tag); ComponentName = dr.SafeString((int)BaseComponentColumn.ComponentName); ComponentType = dr.SafeString((int) BaseComponentColumn.ComponentType); ComponentDescription = dr.SafeString((int) BaseComponentColumn.ComponentDescription); Manufacturer = dr.SafeString((int)BaseComponentColumn.Manufacturer); Model = dr.SafeString((int)BaseComponentColumn.Model); }
public PipeComponentDataAdapter(OleDbDataReader dr, List<PipeProperty> existingPipeComponentProperties, IList<string> componentPropertyNames, int rowNumber, bool canCreateProperties) { string pipeName = dr.SafeString((int)PipeComponentColumn.Tag); if (!ParseTagNumberToProperties(pipeName, rowNumber)) { return; } RowNumber = rowNumber; Tag = dr.SafeString((int)PipeComponentColumn.Tag); PipeDataAdapter adpter = new PipeDataAdapter(Tag); if (adpter.HasValidParts) { this.PipeAdapter = adpter; } else { ErrorMessages.Add(string.Format("Tag '{0}', row {2}, Component Name '{1}'. Pipe Tag is not in a valid format.", Tag, ComponentName, rowNumber)); } ComponentType = dr.SafeString((int)PipeComponentColumn.ComponentType); ComponentAreaNumber = dr.SafeString((int)PipeComponentColumn.ComponentAreaNumber); ComponentSubArea = dr.SafeNullableInt((int)PipeComponentColumn.ComponentSubArea); ComponentNumber = dr.SafeNullableInt((int)PipeComponentColumn.ComponentNumber); Manufacturer = dr.SafeString((int)PipeComponentColumn.Manufacturer); Model = dr.SafeString((int)PipeComponentColumn.Model); if (!ComponentSubArea.HasValue) { ErrorMessages.Add(string.Format("Tag {0}, row {1}. The ComponentSubArea is blank.", Tag, rowNumber)); } if (!ComponentNumber.HasValue) { ErrorMessages.Add(string.Format("Tag {0}, row {1}. The ComponentNumber is blank.", Tag, rowNumber)); } if (string.IsNullOrEmpty(ComponentType)) { ErrorMessages.Add(string.Format("Tag {0}, row {1}. The ComponentType is blank.", Tag, rowNumber)); } ComponentDescription = dr.SafeString((int)PipeComponentColumn.ComponentDescription); int k = 0; const int StartColumnIndex = (int)PipeComponentColumn.Model + 1; for (int i = StartColumnIndex; i < StartColumnIndex + componentPropertyNames.Count; i++) { if (string.IsNullOrEmpty(dr.SafeString(i))) { continue; } string propertyName = componentPropertyNames[k]; k++; PipeProperty property = (from x in existingPipeComponentProperties where x.Name.ToLower() == propertyName.ToLower() select x).FirstOrDefault(); if (property != null) { //we can grab the value; PropertyValues.Add(property.Name, dr.SafeString(i)); } else { if (canCreateProperties) { if (!PropertyValues.ContainsValue(dr.SafeString(i))) { PropertyValues.Add(propertyName, dr.SafeString(i)); } } else { RaiseMissingPropertyMessage(PipeTag, rowNumber, propertyName); break; } } } }
protected void PopulateCommonProperties(OleDbDataReader dr) { Tag = dr.SafeString((int) CalibrationColumn.Tag); CalibrationType = dr.SafeString((int) CalibrationColumn.CalibrationType); CalibrationName = dr.SafeString((int) CalibrationColumn.CalibrationName); CalibrationDescription = dr.SafeString((int) CalibrationColumn.CalibrationDescription); Notes = dr.SafeString((int) CalibrationColumn.Notes); }
public PipeDataAdapter(OleDbDataReader dr, string workSheetName, int rowNumber) { //setting parts via a data reader ErrorMessages = new List<string>(); AreaNumber = string.Empty; SequenceNumber =string.Empty; Class = string.Empty; Size = string.Empty; FluidCode = string.Empty; SpecialFeature =string.Empty; PandID = string.Empty; From = string.Empty; To = string.Empty; Category = string.Empty; Description = string.Empty; mRowNumber = rowNumber; mWorkSheetName = workSheetName; AreaNumber = dr.SafeString((int)PipeColumn.Area); SequenceNumber = dr.SafeString((int)PipeColumn.Sequence); Class = dr.SafeString((int)PipeColumn.PipeClass); Size = dr.SafeString((int)PipeColumn.Size); FluidCode = dr.SafeString((int)PipeColumn.FluidCode); SpecialFeature = dr.SafeString((int)PipeColumn.SpecialFeature); PandID = dr.SafeString((int)PipeColumn.PID); From = dr.SafeString((int)PipeColumn.From); To = dr.SafeString((int)PipeColumn.To); Category = dr.SafeString((int)PipeColumn.Category); Description = dr.SafeString((int)PipeColumn.Description); IsActive = dr.SafeNullableBool((int) PipeColumn.IsActive); }
public FinancialActualsDataAdapter(OleDbDataReader dr, string workSheetName, int rowNumber) { RowNumber = rowNumber; WorkSheetName = workSheetName; ProjectCode = dr.SafeString((int)FinancialActualImportColumn.ProjectCode).Trim(); WbsElement = dr.SafeString((int)FinancialActualImportColumn.WbsElement).Trim(); string monthString = dr.SafeString((int)FinancialActualImportColumn.Month).Trim(); if (String.IsNullOrEmpty(monthString) || monthString.Length != 6) { Errors.Add(String.Format("Month '{0}' must be 6 characters long. Line number {1}. Skipping...", monthString, rowNumber)); } else { string year = monthString.Substring(0, 4); string month = monthString.Substring(4, 2).TrimStart('0'); int monthNumber; if (Int32.TryParse(month, NumberStyles.Any, null, out monthNumber)) { Month = monthNumber; } else { Errors.Add(String.Format("Could not parse Month '{0}' on Line number {1}. Skipping...", month, rowNumber)); } int yearNumber; if (Int32.TryParse(year, NumberStyles.Any, null, out yearNumber)) { Year = yearNumber; } else { Errors.Add(String.Format("Could not parse Year '{0}' on Line number {1}. Skipping...", year, rowNumber)); } } string actualsString = dr.SafeString((int)FinancialActualImportColumn.Actuals).Trim(); if (String.IsNullOrEmpty(actualsString)) { Actuals = null; } else { decimal number; if (Decimal.TryParse(actualsString, NumberStyles.Any, null, out number)) { Actuals = number; } else { Errors.Add(String.Format("Could not parse Actual '{0}' on Line number {1} to decimal. Skipping...", actualsString, rowNumber)); } } }
public CalibrationComponentDataAdapter(OleDbDataReader dr, List<CalibrationProperty> existingCalibrationProperties, IList<string> spreadSheetComponentPropertyNames, int rowNumber, bool canCreateProperties, CommonUtils.ImportType importType) { PropertyValues = new List<CalibrationPropertyDto>(); ErrorMessages = new List<string>(); PopulateCommonProperties(dr); int k = 0; const int StartColumnIndex = (int)CalibrationColumn.Notes + 1; for (int i = StartColumnIndex; i < StartColumnIndex + spreadSheetComponentPropertyNames.Count; i++) { if (string.IsNullOrEmpty(dr.SafeString(i))) { continue; } string propertyName = spreadSheetComponentPropertyNames[k]; string value = dr[i].ToString(); CalibrationPropertyDto dto = ParsePropertyStringToDto(propertyName, rowNumber); List<string> values = value.Split(',').ToList(); if (!values.Any() || values.Count != 2) { //none ErrorMessages.Add(string.Format("The Calibration Property values must contain two values seperated by a single comma. Row: '{0}', Property Name: '{1}', Excel value: '{2}'.", rowNumber, dto.PropertyName, value)); continue; } dto.AsFoundValue = values[0]; dto.AsLeftValue = values[1]; k++; CalibrationProperty property = (from x in existingCalibrationProperties where x.Name.ToLower() == dto.PropertyName.ToLower() select x).FirstOrDefault(); if (property != null) { //we can grab the value; PropertyValues.Add(dto); } else { if (canCreateProperties) { int match = (from x in PropertyValues where x.PropertyName.ToLower() == dr.SafeString(i).ToLower() select x).Count(); if (match == 0) { PropertyValues.Add(dto); } } else { ErrorMessages.Add(RaiseMissingPropertyMessage(CalibrationName, rowNumber, dto.PropertyName)); break; } } } Validate(rowNumber, importType == CommonUtils.ImportType.CreateCalibrationComponent); }
public IssueDataAdapter(OleDbDataReader dr, string workSheetName, int rowNumber) { RowNumber = rowNumber; WorkSheetName = workSheetName; ErrorMessages = new List<string>(); ID = string.Empty; Name = string.Empty; Description = string.Empty; Reason = string.Empty; SuggestedSolution = string.Empty; RequestedBy = string.Empty; InitiationDate = string.Empty; InitiatedBy = string.Empty; ProjectSupervisor = string.Empty; AssignedTo = string.Empty; KeyStakeholder = string.Empty; IssueType = string.Empty; IssueSubType = string.Empty; Classification = string.Empty; Categories = string.Empty; Priority = string.Empty; Status = string.Empty; AreaNumbers = string.Empty; Hazards = string.Empty; ControlMethod = string.Empty; Funding = string.Empty; Budgeted = string.Empty; EstimatedCost = string.Empty; Effort = string.Empty; Reward = string.Empty; ScopedDate = string.Empty; ScopeUser = string.Empty; TrainingDetails = string.Empty; TestingDetails = string.Empty; RevisionHistory = string.Empty; ID = dr.SafeString((int)IssueColumn.ID).Trim(); Name = dr.SafeString((int) IssueColumn.Name).Trim(); Description = dr.SafeString((int) IssueColumn.Description).Trim(); Reason = dr.SafeString((int) IssueColumn.Reason).Trim(); SuggestedSolution = dr.SafeString((int) IssueColumn.SuggestedSolution).Trim(); RequestedBy = dr.SafeString((int) IssueColumn.RequestedBy).Trim(); InitiationDate = dr.SafeString((int) IssueColumn.InitiationDate).Trim(); InitiatedBy = dr.SafeString((int) IssueColumn.InitiatedBy).Trim(); ProjectSupervisor = dr.SafeString((int)IssueColumn.ProjectSupervisor).Trim(); AssignedTo = dr.SafeString((int) IssueColumn.AssignedTo).Trim(); KeyStakeholder = dr.SafeString((int)IssueColumn.KeyStakeholder).Trim(); IssueType = dr.SafeString((int) IssueColumn.IssueType).Trim(); IssueSubType = dr.SafeString((int)IssueColumn.IssueSubType).Trim(); Classification = dr.SafeString((int) IssueColumn.Classification).Trim(); Categories = dr.SafeString((int) IssueColumn.Categories).Trim(); Priority = dr.SafeString((int) IssueColumn.Priority).Trim(); Status = dr.SafeString((int) IssueColumn.Status).Trim(); AreaNumbers = dr.SafeString((int) IssueColumn.Areas).Trim(); Hazards = dr.SafeString((int) IssueColumn.Hazards).Trim(); ControlMethod = dr.SafeString((int) IssueColumn.ControlMethod).Trim(); Funding = dr.SafeString((int) IssueColumn.Funding).Trim().ToUpper(); Budgeted = dr.SafeString((int) IssueColumn.Budgeted).Trim(); EstimatedCost = dr.SafeString((int) IssueColumn.EstimatedCost).Replace("$","").Trim(); Effort = dr.SafeString((int) IssueColumn.Effort).Trim(); Reward = dr.SafeString((int) IssueColumn.Reward).Trim(); ScopedDate = dr.SafeString((int) IssueColumn.ScopedDate).Trim(); ScopeUser = dr.SafeString((int)IssueColumn.ScopeUser).Trim(); TrainingDetails = dr.SafeString((int) IssueColumn.TrainingDetails).Trim(); TestingDetails = dr.SafeString((int) IssueColumn.TestingDetails).Trim(); RevisionHistory = dr.SafeString((int) IssueColumn.Response).Trim(); Validate(); }