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