public void EquipmentPropertyValues(EquipmentPropertyList data) { try { List <EquipmentProperty> equipmentProperties = _context.EquipmentProperties .Where(t => t.IsDeleted == false) .ToList(); Equipment newEquipment = _context.Equipment .OrderBy(t => t.EquipmentId) .Last(); string value = ""; foreach (var item in equipmentProperties) { value = ""; switch (item.EquipmentPropertyName) { case "brand": value = data.brand; break; case "model": value = data.model; break; case "patent": value = data.patent; break; case "owner": value = data.owner; break; case "doors": value = data.doors; break; } EquipmentPropertyValue equipmentPropertyValue = new EquipmentPropertyValue() { EquipmentId = newEquipment.EquipmentId, EquipmentPropertyId = item.EquipmentPropertyId, Value = value }; _context.EquipmentPropertyValues.Add(equipmentPropertyValue); } } catch (Exception e) { } }
public List <EquipmentPropertyList> EquipmentPropertyLists(List <Equipment> equipments) { try { List <EquipmentPropertyList> equipmentPropList = new List <EquipmentPropertyList>(); List <EquipmentProperty> equipProperties = _context.EquipmentProperties .Where(t => t.IsDeleted == false) .ToList(); foreach (var item in equipments) { string brand = ""; string model = ""; string patent = ""; string owner = ""; string doors = ""; foreach (var equipProperty in equipProperties) { EquipmentPropertyValue equipmentPropertyValue = _context.EquipmentPropertyValues .Where(t => t.EquipmentPropertyId == equipProperty.EquipmentPropertyId && t.EquipmentId == item.EquipmentId) .FirstOrDefault(); switch (equipmentPropertyValue.EquipmentProperty.EquipmentPropertyName) { case "brand": brand = equipmentPropertyValue.Value; break; case "model": model = equipmentPropertyValue.Value; break; case "patent": patent = equipmentPropertyValue.Value; break; case "owner": owner = equipmentPropertyValue.Value; break; case "doors": doors = equipmentPropertyValue.Value; break; } } EquipmentPropertyList equipmentPropertyListItem = new EquipmentPropertyList() { brand = brand, model = model, patent = patent, owner = owner, doors = doors }; equipmentPropList.Add(equipmentPropertyListItem); } return(equipmentPropList); } catch (Exception e) { return(null); } }