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 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 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 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 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); }