public MechanicalEquipmentProperty SaveMechanicalEquipmentProperty(MechanicalEquipmentProperty controlSystemProperty) { using (CmsEntities cee = new CmsEntities()) { MechanicalEquipmentProperty original = (from x in cee.MechanicalEquipmentProperties where x.Id == controlSystemProperty.Id select x).FirstOrDefault(); if (original == null) { cee.MechanicalEquipmentProperties.Add(controlSystemProperty); } else { cee.Entry(original).CurrentValues.SetValues(controlSystemProperty); } cee.SaveChanges(); } return controlSystemProperty; }
private void BuildPropertyValues(MechanicalEquipmentComponent componentIn, MechanicalComponentDataAdapter adapter) { foreach (var pair in adapter.PropertyValues) { //DOES PROPERTY EXIST? MechanicalEquipmentProperty property = (from x in mExistingEquipmentProperties where x.Name.ToLower() == pair.Key.ToLower() select x).FirstOrDefault(); if (property == null) { if (CanCreateProperties) { property = new MechanicalEquipmentProperty {Name = pair.Key, DefaultValue = pair.Value, Description = " (created by importer)."}; mExistingEquipmentProperties.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, adapter.RowNumber, adapter.Tag, adapter.ComponentName)); continue; } } //CHECK MechanicalEquipmentComponentTypeProperty Exists MechanicalEquipmentComponentTypeProperty equipmentComponentTypeProperty = null; if (mExistingEquipmentComponentTypeProperty.Any()) { equipmentComponentTypeProperty = (from x in mExistingEquipmentComponentTypeProperty where x.MechanicalEquipmentComponentType.Name.ToLower() == componentIn.MechanicalEquipmentComponentType.Name.ToLower() && x.MechanicalEquipmentProperty.Name.ToLower() == property.Name.ToLower() select x).FirstOrDefault(); } if (equipmentComponentTypeProperty == null) { if (CanCreateProperties) { //CREATE JOIN ROW equipmentComponentTypeProperty = new MechanicalEquipmentComponentTypeProperty(); equipmentComponentTypeProperty.MechanicalEquipmentComponentType = componentIn.MechanicalEquipmentComponentType; //note: set the object! equipmentComponentTypeProperty.MechanicalEquipmentProperty = 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.MechanicalEquipmentComponentType.Name, property.Name)); continue; } } property.MechanicalEquipmentComponentTypeProperties.Add(equipmentComponentTypeProperty); //CHECK PROPERTYVALUE EXISTS MechanicalPropertyValue propertyValue = null; if (mExistingPropertyValues.Any()) { propertyValue = (from x in mExistingPropertyValues where x.MechanicalEquipmentComponent.Name.ToLower() == componentIn.Name.ToLower() && x.MechanicalEquipmentProperty.Name.ToLower() == property.Name.ToLower() select x).FirstOrDefault(); } if (propertyValue == null) { propertyValue = new MechanicalPropertyValue(); propertyValue.MechanicalEquipmentComponent = componentIn; propertyValue.MechanicalEquipmentProperty = property; mExistingPropertyValues.Add(propertyValue); //update cache } //set value if (!string.IsNullOrEmpty(pair.Value)) { propertyValue.Value = pair.Value.ChangeNullToEmptyString(); } componentIn.MechanicalPropertyValues.Add(propertyValue); } }