public async Task <List <EducationalResource> > getAllEducationalResource(string filter) { try { List <EducationalResource> EducationalResource = new List <EducationalResource>(); QueryExpression query = new QueryExpression("mzk_educationalresource"); query.ColumnSet = new ColumnSet("mzk_name", "mzk_educationalresourceid"); query.Criteria.AddCondition("mzk_name", ConditionOperator.Like, "%" + filter + "%"); LinkEntity notes = new LinkEntity("mzk_educationalresource", "annotation", "mzk_educationalresourceid", "objectid", JoinOperator.LeftOuter); notes.Columns = new ColumnSet("mimetype", "filename"); notes.LinkCriteria.AddCondition("isdocument", ConditionOperator.Equal, true); notes.LinkCriteria.AddCondition("objecttypecode", ConditionOperator.Equal, "mzk_educationalresource"); notes.EntityAlias = "notes"; query.LinkEntities.Add(notes); SoapEntityRepository entityRepository = SoapEntityRepository.GetService(); EntityCollection entityCollection = entityRepository.GetEntityCollection(query); foreach (Entity entity in entityCollection.Entities) { EducationalResource model = new EducationalResource(); mzk_educationalresource mzk_educationalresource = (mzk_educationalresource)entity; if (entity.Attributes.Contains("mzk_educationalresourceid")) { model.educationalResourceId = mzk_educationalresource.mzk_educationalresourceId.ToString(); } if (entity.Attributes.Contains("mzk_name")) { model.name = mzk_educationalresource.mzk_name; } Notes resourceNotes = new Notes(); if (entity != null) { resourceNotes.Id = entity.Attributes.Contains("notes.annotationid") ? (entity.Attributes["notes.annotationid"] as AliasedValue).Value.ToString() : string.Empty; resourceNotes.fileName = entity.Attributes.Contains("notes.filename") ? (entity.Attributes["notes.filename"] as AliasedValue).Value.ToString() : string.Empty; resourceNotes.mimeType = entity.Attributes.Contains("notes.mimetype") ? (entity.Attributes["notes.mimetype"] as AliasedValue).Value.ToString() : string.Empty; } model.note = resourceNotes; EducationalResource.Add(model); } return(EducationalResource); } catch (Exception ex) { throw ex; } }
public async Task <List <EducationalResource> > getPatientEncounterEducationalResource(string encounterGuid, string patientGuid) { try { List <EducationalResource> EducationalResource = new List <EducationalResource>(); QueryExpression query = new QueryExpression("mzk_patientencountereducationalresource"); query.ColumnSet = new ColumnSet("mzk_patientencountereducationalresourceid", "mzk_name", "mzk_customer", "mzk_patientencounter", "mzk_educationalresource"); if (!string.IsNullOrEmpty(encounterGuid)) { query.Criteria.AddCondition("mzk_patientencounter", ConditionOperator.Equal, new Guid(encounterGuid)); } if (!string.IsNullOrEmpty(patientGuid)) { query.Criteria.AddCondition("mzk_customer", ConditionOperator.Equal, new Guid(patientGuid)); } LinkEntity educationalResourceQuery = new LinkEntity("mzk_patientencountereducationalresource", "mzk_educationalresource", "mzk_educationalresource", "mzk_educationalresourceid", JoinOperator.LeftOuter); educationalResourceQuery.Columns = new ColumnSet("mzk_educationalresourceid", "mzk_name"); query.LinkEntities.Add(educationalResourceQuery); LinkEntity patientEncounterEducationalResourceNotes = new LinkEntity("mzk_patientencountereducationalresource", "annotation", "mzk_patientencountereducationalresourceid", "objectid", JoinOperator.LeftOuter); patientEncounterEducationalResourceNotes.Columns = new ColumnSet("annotationid", "mimetype", "filename"); patientEncounterEducationalResourceNotes.LinkCriteria.AddCondition("isdocument", ConditionOperator.Equal, true); patientEncounterEducationalResourceNotes.LinkCriteria.AddCondition("objecttypecode", ConditionOperator.Equal, "mzk_patientencountereducationalresource"); patientEncounterEducationalResourceNotes.EntityAlias = "patientEncounterEducationalResourceNotes"; query.LinkEntities.Add(patientEncounterEducationalResourceNotes); LinkEntity educationalResourceNotes = new LinkEntity("mzk_educationalresource", "annotation", "mzk_educationalresourceid", "objectid", JoinOperator.LeftOuter); educationalResourceNotes.Columns = new ColumnSet("annotationid", "mimetype", "filename"); educationalResourceNotes.LinkCriteria.AddCondition("isdocument", ConditionOperator.Equal, true); educationalResourceNotes.LinkCriteria.AddCondition("objecttypecode", ConditionOperator.Equal, "mzk_educationalresource"); educationalResourceNotes.EntityAlias = "educationalResourceNotes"; educationalResourceQuery.LinkEntities.Add(educationalResourceNotes); SoapEntityRepository entityRepository = SoapEntityRepository.GetService(); EntityCollection entityCollection = entityRepository.GetEntityCollection(query); foreach (Entity entity in entityCollection.Entities) { EducationalResource model = new EducationalResource(); mzk_patientencountereducationalresource mzk_patientencountereducationalresource = (mzk_patientencountereducationalresource)entity; if (entity.Attributes.Contains("mzk_patientencountereducationalresourceid")) { model.patientEncounterEducationalResourceId = mzk_patientencountereducationalresource.mzk_patientencountereducationalresourceId.ToString(); } if (entity.Attributes.Contains("mzk_patientencounter")) { model.patientEncounterId = mzk_patientencountereducationalresource.mzk_patientencounter.Id.ToString(); } if (entity.Attributes.Contains("mzk_customer")) { model.patientId = mzk_patientencountereducationalresource.mzk_customer.Id.ToString(); } if (entity.Attributes.Contains("mzk_educationalresource")) { Notes resourceNotes = new Notes(); if (entity != null) { resourceNotes.Id = entity.Attributes.Contains("educationalResourceNotes.annotationid") ? (entity.Attributes["educationalResourceNotes.annotationid"] as AliasedValue).Value.ToString() : string.Empty; resourceNotes.fileName = entity.Attributes.Contains("educationalResourceNotes.filename") ? (entity.Attributes["educationalResourceNotes.filename"] as AliasedValue).Value.ToString() : string.Empty; resourceNotes.mimeType = entity.Attributes.Contains("educationalResourceNotes.mimetype") ? (entity.Attributes["educationalResourceNotes.mimetype"] as AliasedValue).Value.ToString() : string.Empty; } model.note = resourceNotes; } else { Notes resourceNotes = new Notes(); if (entity != null) { resourceNotes.Id = entity.Attributes.Contains("patientEncounterEducationalResourceNotes.annotationid") ? (entity.Attributes["patientEncounterEducationalResourceNotes.annotationid"] as AliasedValue).Value.ToString() : string.Empty; resourceNotes.fileName = entity.Attributes.Contains("patientEncounterEducationalResourceNotes.filename") ? (entity.Attributes["patientEncounterEducationalResourceNotes.filename"] as AliasedValue).Value.ToString() : string.Empty; resourceNotes.mimeType = entity.Attributes.Contains("patientEncounterEducationalResourceNotes.mimetype") ? (entity.Attributes["patientEncounterEducationalResourceNotes.mimetype"] as AliasedValue).Value.ToString() : string.Empty; } model.note = resourceNotes; } EducationalResource.Add(model); } return(EducationalResource); } catch (Exception ex) { throw ex; } }