Example #1
0
        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;
            }
        }
Example #2
0
        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;
            }
        }