public Format_Detail GetById(int id)
{
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
var L2Enty = from c in dbEntity.UserRole.AsNoTracking()
where c.Id == id
select c;
Format_Detail returnData = L2Enty.Select(s => new Format_Detail()
{
Id = s.Id,
Name = s.Name
}).SingleOrDefault <Format_Detail>();
if (returnData == null)
{
throw new CDSException(12103);
}
UserRolePermissionModel model = new UserRolePermissionModel();
returnData.PermissionCatalogList = model.GetAllByUserRoleId(id);
return(returnData);
}
}
public Format_Detail GetById(int id, bool metaData)
{
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
Equipment existingData = (from c in dbEntity.Equipment.AsNoTracking()
where c.Id == id
select c).SingleOrDefault();
if (existingData == null)
{
throw new CDSException(10501);
}
Format_Detail returnData = new Format_Detail()
{
Id = existingData.Id,
EquipmentId = existingData.EquipmentId,
Name = existingData.Name,
EquipmentClassId = existingData.EquipmentClassId,
FactoryId = existingData.FactoryId,
IoTDeviceId = existingData.IoTDeviceID,
Latitude = (existingData.Latitude == null) ? "" : existingData.Latitude.ToString(),
Longitude = (existingData.Longitude == null) ? "" : existingData.Longitude.ToString(),
MaxIdleInSec = existingData.MaxIdleInSec,
PhotoURL = existingData.PhotoURL
};
if (metaData)
{
returnData.MetaData = (from c in dbEntity.MetaDataDefination
where c.CompanyId == existingData.CompanyID && c.EntityType == Global.MetaDataEntityType.Equipment
select c).Select(s => new Format_MetaDataDetail()
{
DefinationId = s.Id,
DefinationName = s.ObjectName,
ObjectValue = ""
}).ToList();
if (returnData.MetaData.Count > 0)
{
List <int> definationIdList = returnData.MetaData.Select(s => s.DefinationId).ToList();
//<definationId, ObjectValue>
Dictionary <int, string> dictonary_metaDataValue = (from c in dbEntity.MetaDataValue.AsNoTracking()
where c.ReferenceId == id && definationIdList.Contains(c.MetaDataDefinationId)
select c).ToDictionary(s => s.MetaDataDefinationId, s => s.ObjectValue);
for (int i = 0; i < returnData.MetaData.Count; i++)
{
int definationId = returnData.MetaData[i].DefinationId;
returnData.MetaData[i].ObjectValue = dictonary_metaDataValue.ContainsKey(definationId) ? dictonary_metaDataValue[definationId] : "";
}
}
}
return(returnData);
}
}
