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