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