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