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