public bool SavePipePropertyValues(List<PipePropertyValue> pipeComponentPropertyValues)
{
using (CmsEntities cee = new CmsEntities())
{
foreach (var pipeComponentPropertyValue in pipeComponentPropertyValues)
{
var q = (from x in cee.PipePropertyValues
where x.Id == pipeComponentPropertyValue.Id
select x).FirstOrDefault();
if (q == null)
{
q = new PipePropertyValue
{
ComponentId = pipeComponentPropertyValue.ComponentId,
PipePropertyId = pipeComponentPropertyValue.PipePropertyId,
Value = pipeComponentPropertyValue.Value
};
cee.PipePropertyValues.Add(q);
//cee.AddToPipePropertyValues(q);
}
else
{
q.PipePropertyId = pipeComponentPropertyValue.PipePropertyId;
q.ComponentId = pipeComponentPropertyValue.ComponentId;
q.Value = pipeComponentPropertyValue.Value;
}
cee.SaveChanges();
}
}
return true;
}
private void BuildPropertyValues(PipeComponent componentIn, PipeComponentDataAdapter adapter, int index)
{
foreach (var pair in adapter.PropertyValues)
{
//DOES PROPERTY EXIST?
PipeProperty property = (from x in mExistingComponentProperties where x.Name.ToLower() == pair.Key.ToLower() select x).FirstOrDefault();
if (property == null)
{
if (CanCreateProperties)
{
property = new PipeProperty {Name = pair.Key, DefaultValue = pair.Value, Description = " (created by importer)."};
mExistingComponentProperties.Add(property); //update cache
}
else
{
//ERROR!
RaiseMessage(CommonUtils.MessageType.Error, string.Format("WorkSheet '{0}' Line '{1} Tag {2} Component Name {3}' : The property does not exist.", WorkSheetName, index, adapter.Tag, adapter.ComponentName));
continue;
}
}
//CHECK PipeEquipmentComponentTypeProperty Exists
PipeComponentTypeProperty equipmentComponentTypeProperty = null;
if (mExistingEquipmentComponentTypeProperty.Any())
{
equipmentComponentTypeProperty =
(from x in mExistingEquipmentComponentTypeProperty
where x.PipeComponentType.Name.ToLower() == componentIn.PipeComponentType.Name.ToLower()
&& x.PipeProperty.Name.ToLower() == property.Name.ToLower()
select x).FirstOrDefault();
}
if (equipmentComponentTypeProperty == null)
{
if (CanCreateProperties)
{
//CREATE JOIN ROW
equipmentComponentTypeProperty = new PipeComponentTypeProperty();
equipmentComponentTypeProperty.PipeComponentType = componentIn.PipeComponentType; //note: set the object!
equipmentComponentTypeProperty.PipeProperty = property; //not set the object!
mExistingEquipmentComponentTypeProperty.Add(equipmentComponentTypeProperty); //update cache
}
else
{
//ERROR!
RaiseMessage(CommonUtils.MessageType.Warning, string.Format("WorkSheet '{0}' Row '{1} Tag {2} Component Type {3}' : The property {4} does not belong to the Component Type.",
WorkSheetName, adapter.RowNumber, adapter.Tag, componentIn.PipeComponentType.Name, property.Name));
continue;
}
}
property.PipeComponentTypeProperties.Add(equipmentComponentTypeProperty);
//CHECK PROPERTYVALUE EXISTS
PipePropertyValue propertyValue = null;
if (mExistingPropertyValues.Any())
{
propertyValue = (from x in mExistingPropertyValues
where x.PipeComponent.Name.ToLower() == componentIn.Name.ToLower()
&& x.PipeProperty.Name.ToLower() == property.Name.ToLower()
select x).FirstOrDefault();
}
if (propertyValue == null)
{
propertyValue = new PipePropertyValue();
propertyValue.PipeComponent = componentIn;
propertyValue.PipeProperty = property;
mExistingPropertyValues.Add(propertyValue); //update cache
}
//set value
if (!string.IsNullOrEmpty(pair.Value))
{
propertyValue.Value = pair.Value.ChangeNullToEmptyString();
}
componentIn.PipePropertyValues.Add(propertyValue);
}
}
private PipePropertyValue GetPropertyValue(PipeComponent controlSystemComponent,
PipeComponentTypeProperty controlSystemComponentProperty)
{
var propertyValue = (from x in controlSystemComponent.PipePropertyValues
where x.PipePropertyId == controlSystemComponentProperty.PipePropertyId &&
x.ComponentId == controlSystemComponent.Id
select x).FirstOrDefault();
if (propertyValue == null)
{
propertyValue = new PipePropertyValue
{
ComponentId = controlSystemComponent.Id,
PipePropertyId = controlSystemComponentProperty.PipePropertyId,
Value = controlSystemComponentProperty.PipeProperty.DefaultValue
};
controlSystemComponent.PipePropertyValues.Add(propertyValue);
}
return propertyValue;
}
public PipeComponentPropertyValueViewModel(PipePropertyValue pcpv)
{
mPipeComponentPropertyValue = pcpv;
}
