public ActionResult GetObjectFieldsByObjectId(int objectId)
{
// Find Dto use many query
var objectFields = context.ObjectFields.ToList();
var obj = context.Objects.Where(w => w.Id == objectId.ToString()).FirstOrDefault();
if (!objectFields.Any())
{
return(NoContent());
}
var fields = new List <Fields>();
foreach (var objectField in objectFields)
{
var field = context.Fields.Where(w => w.Id == objectField.FieldId).FirstOrDefault();
fields.Add(field);
}
var objectFieldDto = new ObjectFieldDto
{
Object = obj,
Fields = fields
};
return(Ok(objectFieldDto));
}
public ActionResult Get()
{
var objectFieldsDto = new List <ObjectFieldDto>();
var objects = context.Objects.Where(w => w.IsDeleted == 0).ToList();
if (objects == null)
{
return(NotFound());
}
if (!objects.Any())
{
return(NoContent());
}
foreach (var obj in objects)
{
var objectFields = context.ObjectFields.Where(w => w.ObjectId == obj.Id).ToList();
var fields = new List <Fields>();
foreach (var objectField in objectFields)
{
var field = context.Fields.Where(w => w.Id == objectField.FieldId).FirstOrDefault();
fields.Add(field);
}
var objectFieldDto = new ObjectFieldDto
{
Object = obj,
Fields = fields
};
objectFieldsDto.Add(objectFieldDto);
}
if (!objectFieldsDto.Any())
{
return(NoContent());
}
return(Ok(objectFieldsDto));
}
