Beispiel #1
0
        public PatientReferralOrder referralExist(string caseId, string referToId)
        {
            QueryExpression query = new QueryExpression(mzk_patientorder.EntityLogicalName);

            query.Criteria.AddCondition("mzk_type", ConditionOperator.Equal, (int)mzk_patientordermzk_Type.Referral);
            query.Criteria.AddCondition("mzk_orderstatus", ConditionOperator.Equal, (int)mzk_orderstatus.Ordered);
            query.Criteria.AddCondition("mzk_referralcategory", ConditionOperator.Equal, (int)mzk_patientordermzk_ReferralCategory.Internal);
            query.Criteria.AddCondition("mzk_referraltoid", ConditionOperator.Equal, new Guid(referToId));
            query.Criteria.AddCondition("mzk_caseid", ConditionOperator.Equal, new Guid(caseId));
            query.ColumnSet = new Microsoft.Xrm.Sdk.Query.ColumnSet("mzk_specialityid", "mzk_axcasetransrefrecid");

            SoapEntityRepository entityRepository = SoapEntityRepository.GetService();
            EntityCollection     entitycollection = entityRepository.GetEntityCollection(query);

            if (entitycollection != null && entitycollection.Entities != null && entitycollection.Entities.Count > 0)
            {
                PatientReferralOrder referral = new PatientReferralOrder();

                if (entitycollection.Entities[0].Attributes.Contains("mzk_specialityid"))
                {
                    referral.SpecialtyId = entitycollection.Entities[0].GetAttributeValue <EntityReference>("mzk_specialityid").Id.ToString();
                }

                if (entitycollection.Entities[0].Attributes.Contains("mzk_axcasetransrefrecid"))
                {
                    referral.CaseTransRecId = entitycollection.Entities[0].Attributes["mzk_axcasetransrefrecid"].ToString();
                }

                return(referral);
            }
            else
            {
                return(null);
            }
        }
Beispiel #2
0
        public async Task <List <ConsultationSummary> > getCarePLan(string caseId)
        {
            try
            {
                List <ConsultationSummary> ConsultationSummary = new List <ConsultationSummary>();
                ConsultationSummary        model      = new ConsultationSummary();
                PatientMedication          medication = new PatientMedication();
                PatientRadiologyOrder      radiology  = new PatientRadiologyOrder();
                PatientLabOrder            lab        = new PatientLabOrder();
                PatientSpecialTest         st         = new PatientSpecialTest();
                PatientTherapy             pt         = new PatientTherapy();
                PatientReferralOrder       pr         = new PatientReferralOrder();
                PatientProcedure           pp         = new PatientProcedure();

                PatientEncounter encounter = new PatientEncounter();
                encounter.CaseId                = caseId;
                model.listPatientMedication     = medication.getPatientOrder(null, null, null, null, DateTime.MinValue, DateTime.MinValue, false, null, caseId).Result.ToList();
                model.listPatientRadiologyOrder = radiology.getPatientOrder(null, null, null, null, DateTime.MinValue, DateTime.MinValue, false, null, caseId).Result.ToList();
                model.listPatientLabOrder       = lab.getPatientOrder(null, null, null, null, DateTime.MinValue, DateTime.MinValue, false, null, caseId).Result.ToList();
                model.listPatientSpecialTest    = st.getPatientOrder(null, null, null, null, DateTime.MinValue, DateTime.MinValue, false, "", caseId).Result.ToList();
                model.listPatientTherapy        = pt.getPatientOrder(null, null, null, null, DateTime.MinValue, DateTime.MinValue, false, null, caseId).Result.ToList();
                model.listPatientReferral       = pr.getPatientOrder(null, null, null, null, DateTime.MinValue, DateTime.MinValue, false, null, caseId).Result.ToList();
                model.listPatientProcedure      = pp.getPatientOrder(null, null, null, null, DateTime.MinValue, DateTime.MinValue, false, null, caseId).Result.ToList();
                ConsultationSummary.Add(model);

                return(ConsultationSummary);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #3
0
        public async Task <List <PatientReferralOrder> > getPatientOrder(List <Entity> patientOrders)
        {
            List <PatientReferralOrder> PatientReferral = new List <PatientReferralOrder>();

            foreach (Entity entity in patientOrders)
            {
                PatientReferralOrder model = new PatientReferralOrder();

                if (entity.Attributes.Contains("mzk_speciality.name"))
                {
                    model.SpecialtyName = ((AliasedValue)entity.Attributes["mzk_speciality.name"]).Value.ToString();
                }

                if (entity.Attributes.Contains("mzk_comments"))
                {
                    model.ReferralComment = entity["mzk_comments"].ToString();
                }

                if (entity.Id != null)
                {
                    model.Id = entity.Id.ToString();
                }

                if (entity.Attributes.Contains("mzk_referralcategory"))
                {
                    model.Category     = ((OptionSetValue)entity["mzk_referralcategory"]).Value;
                    model.CategoryName = entity.FormattedValues["mzk_referralcategory"].ToString();

                    if (((OptionSetValue)entity["mzk_referralcategory"]).Value == Convert.ToInt32(mzk_patientordermzk_ReferralCategory.Internal))
                    {
                        if (entity.Attributes.Contains("mzk_referraltoid"))
                        {
                            model.Referralto = ((EntityReference)entity["mzk_referraltoid"]).Name;
                        }
                    }
                    else
                    {
                        if (((OptionSetValue)entity["mzk_referralcategory"]).Value == Convert.ToInt32(mzk_patientordermzk_ReferralCategory.External))
                        {
                            if (entity.Attributes.Contains("ReferringPhysician.mzk_name"))
                            {
                                model.Referralto = ((AliasedValue)entity["ReferringPhysician.mzk_name"]).Value.ToString();
                            }
                        }
                    }
                }

                PatientReferral.Add(model);
            }

            return(PatientReferral);
        }
Beispiel #4
0
        public async Task <List <PatientReferralOrder> > getReferral(PatientReferralOrder referral)
        {
            List <PatientReferralOrder> PatientReferral = new List <PatientReferralOrder>();
            List <Speciality>           speciality      = new Speciality().getSpecialityList(null, referral.CategoryName == mzk_patientordermzk_ReferralCategory.External.ToString() ? mzk_locationtype.External : mzk_locationtype.Internal).ToList <Speciality>();

            foreach (Speciality ss in speciality)
            {
                PatientReferralOrder model = new PatientReferralOrder();
                if (referral.CategoryName == mzk_patientordermzk_ReferralCategory.External.ToString())
                {
                    model.SpecialtyName          = ss.Description;
                    model.SpecialtyId            = ss.SpecialityId;
                    model.referringPhysicianList = new ReferringPhysician().getReferringPhysician(ss.SpecialityId);
                    model.Category = (int)mzk_patientordermzk_ReferralCategory.External;
                }
                else
                {
                    if (referral.CategoryName == mzk_patientordermzk_ReferralCategory.Internal.ToString())
                    {
                        model.SpecialtyName = ss.Description;
                        model.SpecialtyId   = ss.SpecialityId;

                        if (!string.IsNullOrEmpty(referral.UserId))
                        {
                            model.usersList = new User().getUsers(ss.SpecialityRefRecId, true, referral.UserId, ss.SpecialityId);
                        }
                        else
                        {
                            model.usersList = new User().getUsers(ss.SpecialityRefRecId, true, string.Empty, ss.SpecialityId);
                        }

                        model.Category = (int)mzk_patientordermzk_ReferralCategory.Internal;
                    }
                }
                PatientReferral.Add(model);
            }

            //QueryExpression query;
            //#region Search User Query
            //if (referral.CategoryName == mzk_patientordermzk_ReferralCategory.Internal.ToString())
            //{
            //    query = new QueryExpression("systemuser");
            //    FilterExpression childFilter = query.Criteria.AddFilter(LogicalOperator.And);
            //    childFilter.AddCondition("fullname", ConditionOperator.Like, "%" + referral.Referralto + "%");
            //    query.ColumnSet = new Microsoft.Xrm.Sdk.Query.ColumnSet("fullname", "address1_composite", "mzk_type", "mzk_axresourcerefrecid");
            //}
            //else
            //{
            //    query = new QueryExpression("mzk_referringphysician");
            //    FilterExpression childFilter = query.Criteria.AddFilter(LogicalOperator.And);
            //    childFilter.AddCondition("mzk_name", ConditionOperator.Like, "%" + referral.Referralto + "%");
            //    query.ColumnSet = new Microsoft.Xrm.Sdk.Query.ColumnSet("mzk_name", "mzk_contactid", "mzk_specialityid", "mzk_type");

            //    LinkEntity linkContact = new LinkEntity("mzk_referringphysician", "contact", "mzk_contactid", "contactid", JoinOperator.LeftOuter);
            //    linkContact.Columns = new Microsoft.Xrm.Sdk.Query.ColumnSet("address1_composite");

            //    LinkEntity linkSpeciality = new LinkEntity("mzk_referringphysician", "mzk_speciality", "mzk_specialityid", "mzk_specialityid", JoinOperator.LeftOuter);
            //    linkSpeciality.Columns = new Microsoft.Xrm.Sdk.Query.ColumnSet("mzk_description");
            //    query.LinkEntities.Add(linkContact);
            //    query.LinkEntities.Add(linkSpeciality);
            //}
            //#endregion
            //SoapEntityRepository entityRepository = SoapEntityRepository.GetService();
            //EntityCollection entitycollection = entityRepository.GetEntityCollection(query);

            //User user = new User();
            //foreach (Entity entity in entitycollection.Entities)
            //{
            //    PatientReferral model = new PatientReferral();

            //    if (referral.CategoryName == mzk_patientordermzk_ReferralCategory.Internal.ToString())
            //    {
            //        if (entity.Attributes.Contains("fullname"))
            //            model.Referralto = entity.Attributes["fullname"].ToString();

            //        if (entity.Attributes.Contains("address1_composite"))
            //            model.Address = entity.Attributes["address1_composite"].ToString();

            //        if (entity.Attributes.Contains("mzk_axresourcerefrecid"))
            //        {
            //            if (user.getSpecialities(Convert.ToInt64(entity.Attributes["mzk_axresourcerefrecid"])).Count > 0)
            //            {
            //                model.SpecialtyId = new User().getSpecialities(Convert.ToInt64(entity.Attributes["mzk_axresourcerefrecid"])).First<Speciality>().SpecialityId;
            //                model.SpecialtyName = new User().getSpecialities(Convert.ToInt64(entity.Attributes["mzk_axresourcerefrecid"])).First<Speciality>().Description;
            //            }
            //        }
            //        model.ReferralId = entity.Id.ToString();
            //    }
            //    else
            //    {
            //        if (referral.CategoryName == mzk_patientordermzk_ReferralCategory.External.ToString())
            //        {
            //            if (entity.Attributes.Contains("mzk_name"))
            //                model.Referralto = entity.Attributes["mzk_name"].ToString();

            //            if (entity.Attributes.Contains("contact1.address1_composite"))
            //                model.Address = (entity.Attributes["contact1.address1_composite"] as AliasedValue).Value.ToString();

            //            if (entity.Attributes.Contains("mzk_speciality2.mzk_description"))
            //            {
            //                model.SpecialtyName = (entity.Attributes["mzk_speciality2.mzk_description"] as AliasedValue).Value.ToString();
            //            }
            //            if (entity.Attributes.Contains("mzk_specialityid"))
            //            {
            //                model.SpecialtyId = ((EntityReference)entity.Attributes["mzk_specialityid"]).Id.ToString();
            //            }
            //            model.ReferralId = entity.Id.ToString();
            //        }
            //    }

            //    PatientReferral.Add(model);
            //}
            return(PatientReferral);
        }
Beispiel #5
0
        public async Task <bool> updatePatientOrder(PatientReferralOrder patientReferral)
        {
            try
            {
                SoapEntityRepository entityRepository = SoapEntityRepository.GetService();
                Entity referralEntity = entityRepository.GetEntity(mzk_patientorder.EntityLogicalName, new Guid(patientReferral.Id)
                {
                },
                                                                   new Microsoft.Xrm.Sdk.Query.ColumnSet("mzk_customer",
                                                                                                         "mzk_appointmentrecommendation",
                                                                                                         "mzk_associateddiagnosisid",
                                                                                                         "mzk_patientaware",
                                                                                                         "mzk_comments",
                                                                                                         "mzk_orderstatus",
                                                                                                         "mzk_referraltoid",
                                                                                                         "mzk_referraltype",
                                                                                                         "mzk_specialityid",
                                                                                                         "ownerid",
                                                                                                         "mzk_patientordernumber",
                                                                                                         "createdon",
                                                                                                         "mzk_referralcategory",
                                                                                                         "mzk_referraltoexternalid"));

                if (!string.IsNullOrEmpty(patientReferral.PatientId))
                {
                    referralEntity.Attributes["mzk_customer"] = new EntityReference("contact", new Guid(patientReferral.PatientId));
                }

                if (!string.IsNullOrEmpty(patientReferral.Diagnosis))
                {
                    referralEntity.Attributes["mzk_associateddiagnosisid"] = new EntityReference("mzk_concept", new Guid(patientReferral.Diagnosis));
                }

                if (!string.IsNullOrEmpty(patientReferral.ReferralComment))
                {
                    referralEntity.Attributes["mzk_comments"] = patientReferral.ReferralComment;
                }

                if (patientReferral.PatientAware.ToString() != "1")
                {
                    referralEntity.Attributes["mzk_patientaware"] = true;
                }
                else
                {
                    referralEntity.Attributes["mzk_patientaware"] = false;
                }

                if (patientReferral.Apptrecommendation != 0)
                {
                    referralEntity.Attributes["mzk_appointmentrecommendation"] = new OptionSetValue(patientReferral.Apptrecommendation);
                }

                //for ReferralType Consultation, Consultation & Treatment and Transfer of Care
                if (patientReferral.ReferralType != 0)
                {
                    referralEntity.Attributes["mzk_referraltype"] = new OptionSetValue(patientReferral.ReferralType);
                }

                //for Category Internal /External
                if (patientReferral.Category != 0 && patientReferral.Category == Convert.ToInt32(mzk_patientordermzk_ReferralCategory.Internal))
                {
                    referralEntity.Attributes["mzk_referralcategory"] = new OptionSetValue(Convert.ToInt32(patientReferral.Category));

                    if (!string.IsNullOrEmpty(patientReferral.ReferralId))
                    {
                        referralEntity.Attributes["mzk_referraltoid"] = new EntityReference("systemuser", new Guid(patientReferral.ReferralId));
                    }
                }
                else
                {
                    if (patientReferral.Category != 0 && patientReferral.Category == Convert.ToInt32(mzk_patientordermzk_ReferralCategory.External))
                    {
                        referralEntity.Attributes["mzk_referralcategory"] = new OptionSetValue(Convert.ToInt32(patientReferral.Category));

                        if (!string.IsNullOrEmpty(patientReferral.ReferralId))
                        {
                            referralEntity.Attributes["mzk_referraltoexternalid"] = new EntityReference("mzk_referringphysician", new Guid(patientReferral.ReferralId));
                        }
                    }
                }
                if (!string.IsNullOrEmpty(patientReferral.SpecialtyId))
                {
                    referralEntity.Attributes["mzk_specialityid"] = new EntityReference("characteristic", new Guid(patientReferral.SpecialtyId));

                    var specialityNameList = new List <string> {
                        patientReferral.SpecialtyId
                    };

                    Speciality speciality = new Speciality();

                    referralEntity.Attributes["mzk_specialtyname"] = speciality.getSpecialityList(specialityNameList).First <Speciality>().Description;
                }

                if (!string.IsNullOrEmpty(patientReferral.HospitalId))
                {
                    referralEntity.Attributes["mzk_hospitalid"] = new EntityReference("mzk_hospital", new Guid(patientReferral.HospitalId));
                }

                entityRepository.UpdateEntity(referralEntity);
                return(true);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #6
0
        public async Task <string> addPatientOrder(PatientReferralOrder _patientReferral)
        {
            SoapEntityRepository entityRepository = SoapEntityRepository.GetService();
            mzk_patientorder     referralEntity   = new mzk_patientorder();

            try
            {
                referralEntity.mzk_appointable = true;

                if (!string.IsNullOrEmpty(_patientReferral.appointmentId))
                {
                    referralEntity.mzk_orderingappointment    = new EntityReference("mzk_patientorder", new Guid(_patientReferral.appointmentId));
                    referralEntity.mzk_fulfillmentappointment = new EntityReference("mzk_patientorder", new Guid(_patientReferral.appointmentId));
                }

                if (!string.IsNullOrEmpty(_patientReferral.PatientId))
                {
                    referralEntity.Attributes["mzk_customer"] = new EntityReference("contact", new Guid(_patientReferral.PatientId));
                }

                if (!string.IsNullOrEmpty(_patientReferral.EncounterId))
                {
                    referralEntity.Attributes["mzk_patientencounterid"] = new EntityReference("mzk_patientencounter", new Guid(_patientReferral.EncounterId));
                    PatientEncounter encounter = new PatientEncounter();
                    encounter.EncounterId = _patientReferral.EncounterId;
                    //PatientId = new PatientCase().getCaseDetails(encounter.encounterDetails(encounter).Result.ToList().First<PatientEncounter>().CaseId).Result.PatientId;
                    PatientId = encounter.getEncounterDetails(encounter).Result.ToList().First <PatientEncounter>().PatientId;
                    referralEntity.Attributes["mzk_customer"] = new EntityReference("contact", new Guid(PatientId));
                }

                if (!string.IsNullOrEmpty(_patientReferral.Diagnosis))
                {
                    referralEntity.Attributes["mzk_associateddiagnosisid"] = new EntityReference("mzk_concept", new Guid(_patientReferral.Diagnosis));
                }

                if (_patientReferral.clinicRecId > 0)
                {
                    referralEntity.Attributes["mzk_axclinicrefrecid"] = Convert.ToDecimal(_patientReferral.clinicRecId);
                }

                if (!string.IsNullOrEmpty(_patientReferral.orderingLocationId))
                {
                    referralEntity.Attributes["mzk_orderinglocation"] = new EntityReference("mzk_organizationalunit", new Guid(_patientReferral.orderingLocationId));
                }

                if (!string.IsNullOrEmpty(_patientReferral.ReferralComment))
                {
                    referralEntity.Attributes["mzk_comments"] = _patientReferral.ReferralComment;
                }

                if (_patientReferral.PatientAware.ToString() != "1")
                {
                    referralEntity.Attributes["mzk_patientaware"] = true;
                }
                else
                {
                    referralEntity.Attributes["mzk_patientaware"] = false;
                }

                if (_patientReferral.Apptrecommendation != 0)
                {
                    referralEntity.Attributes["mzk_appointmentrecommendation"] = new OptionSetValue(_patientReferral.Apptrecommendation);
                }

                //for ReferralType Consultation, Consultation & Treatment and Transfer of Care
                if (_patientReferral.ReferralType != 0)
                {
                    referralEntity.Attributes["mzk_referraltype"] = new OptionSetValue(_patientReferral.ReferralType);
                }


                //for Category Internal /External
                if (_patientReferral.Category != 0 && _patientReferral.Category == Convert.ToInt32(mzk_patientordermzk_ReferralCategory.Internal))
                {
                    referralEntity.Attributes["mzk_referralcategory"] = new OptionSetValue(Convert.ToInt32(_patientReferral.Category));

                    if (!string.IsNullOrEmpty(_patientReferral.ReferralId))
                    {
                        referralEntity.Attributes["mzk_referraltoid"] = new EntityReference("systemuser", new Guid(_patientReferral.ReferralId));
                    }
                }
                else
                {
                    if (_patientReferral.Category != 0 && _patientReferral.Category == Convert.ToInt32(mzk_patientordermzk_ReferralCategory.External))
                    {
                        referralEntity.Attributes["mzk_referralcategory"] = new OptionSetValue(Convert.ToInt32(_patientReferral.Category));

                        if (!string.IsNullOrEmpty(_patientReferral.ReferralId))
                        {
                            referralEntity.Attributes["mzk_referraltoexternalid"] = new EntityReference("mzk_referringphysician", new Guid(_patientReferral.ReferralId));
                        }
                    }
                }

                if (!string.IsNullOrEmpty(_patientReferral.SpecialtyId))
                {
                    referralEntity.Attributes["mzk_specialityid"] = new EntityReference("characteristic", new Guid(_patientReferral.SpecialtyId));

                    var specialityNameList = new List <string> {
                        _patientReferral.SpecialtyId
                    };

                    Speciality speciality = new Speciality();

                    referralEntity.Attributes["mzk_specialtyname"] = speciality.getSpecialityList(specialityNameList).First <Speciality>().Description;
                }

                if (!string.IsNullOrEmpty(_patientReferral.HospitalId) && _patientReferral.HospitalId != "0")
                {
                    referralEntity.Attributes["mzk_hospitalid"] = new EntityReference("mzk_hospital", new Guid(_patientReferral.HospitalId));
                }

                referralEntity.Attributes["mzk_type"]        = new OptionSetValue(Convert.ToInt32(mzk_patientordermzk_Type.Referral));
                referralEntity.Attributes["mzk_orderstatus"] = new OptionSetValue((int)mzk_orderstatus.Ordered);

                referralEntity.Attributes["mzk_orderdate"]       = DateTime.Now.Date;
                referralEntity.Attributes["mzk_fulfillmentdate"] = referralEntity.Attributes["mzk_orderdate"];


                Id = Convert.ToString(entityRepository.CreateEntity(referralEntity));

                if (!string.IsNullOrEmpty(_patientReferral.EncounterId) && !string.IsNullOrEmpty(_patientReferral.SpecialtyId))
                {
                    mzk_casetype caseType = PatientCase.getCaseType(_patientReferral.EncounterId);

                    if (caseType == mzk_casetype.Emergency && _patientReferral.Category == Convert.ToInt32(mzk_patientordermzk_ReferralCategory.Internal))
                    {
                        List <string> specialtyIdList = new List <string>();
                        specialtyIdList.Add(_patientReferral.SpecialtyId);

                        Speciality sp = new Speciality().getSpecialityList(specialtyIdList).FirstOrDefault();

                        if (AppSettings.GetByKey("OperationsIntegration").ToLower() == true.ToString().ToLower())
                        {
                            if (sp != null && sp.SpecialityRefRecId > 0)
                            {
                                await this.createCaseTrans(_patientReferral.EncounterId, Id, "", mzk_orderstatus.Ordered, 1, "", HMUrgency.None, "", "", "", sp.SpecialityRefRecId);
                            }
                        }
                    }
                }

                return(Id.ToString());
            }
            catch (Exception ex)
            {
                if (!string.IsNullOrEmpty(Id))
                {
                    entityRepository.DeleteEntity(mzk_patientorder.EntityLogicalName, new Guid(Id));
                }

                throw ex;
            }
        }
Beispiel #7
0
        public async Task <List <PatientReferralOrder> > getPatientOrder(string patientguid, string patientEncounter, string SearchFilters, string searchOrder, DateTime startDate, DateTime endDate, bool forFulfillment, string orderId, string caseId = null, int pageNumber = 0, string fulfillmentAppointmentId = null, string orderingAppointmentId = null)
        {
            try
            {
                List <PatientReferralOrder> PatientReferral = new List <PatientReferralOrder>();
                #region Patient Referral Query
                QueryExpression  query       = new QueryExpression(mzk_patientorder.EntityLogicalName);
                FilterExpression childFilter = query.Criteria.AddFilter(LogicalOperator.And);

                if (SearchFilters != mzk_orderstatus.Cancelled.ToString())
                {
                    childFilter.AddCondition("mzk_orderstatus", ConditionOperator.NotEqual, (int)mzk_orderstatus.Cancelled);
                }
                if (!string.IsNullOrEmpty(orderId))
                {
                    childFilter.AddCondition("mzk_patientorderid", ConditionOperator.Equal, new Guid(orderId));
                }
                if (!string.IsNullOrEmpty(fulfillmentAppointmentId))
                {
                    childFilter.AddCondition("mzk_fulfillmentappointment", ConditionOperator.Equal, new Guid(fulfillmentAppointmentId));
                }
                if (!string.IsNullOrEmpty(orderingAppointmentId))
                {
                    childFilter.AddCondition("mzk_orderingappointment", ConditionOperator.Equal, new Guid(orderingAppointmentId));
                }
                if (!string.IsNullOrEmpty(caseId))
                {
                    childFilter.AddCondition("mzk_caseid", ConditionOperator.Equal, new Guid(caseId));
                }
                if (!string.IsNullOrEmpty(patientguid))
                {
                    childFilter.AddCondition("mzk_customer", ConditionOperator.Equal, new Guid(patientguid));
                }
                else
                {
                    if (!string.IsNullOrEmpty(patientEncounter))
                    {
                        childFilter.AddCondition("mzk_patientencounterid", ConditionOperator.Equal, new Guid(patientEncounter));
                    }
                }

                //Search Filter
                if (!string.IsNullOrEmpty(SearchFilters))
                {
                    if (SearchFilters == Convert.ToString(mzk_referralfilter.Consultation))
                    {
                        childFilter.AddCondition("mzk_referraltype", ConditionOperator.Equal, Convert.ToInt32(mzk_patientordermzk_ReferralType.Consultation));
                    }
                    if (SearchFilters == "Consultation & Treatment")
                    {
                        childFilter.AddCondition("mzk_referraltype", ConditionOperator.Equal, Convert.ToInt32(mzk_patientordermzk_ReferralType.ConsultationTreatment));
                    }
                    if (SearchFilters == "Transfer of Care")
                    {
                        childFilter.AddCondition("mzk_referraltype", ConditionOperator.Equal, Convert.ToInt32(mzk_patientordermzk_ReferralType.TransferofCare));
                    }
                }

                //Search Date
                if (startDate != DateTime.MinValue && endDate != DateTime.MinValue)
                {
                    childFilter.AddCondition("createdon", ConditionOperator.Between, new Object[] { startDate, endDate.AddHours(12) });
                }

                query.ColumnSet = new Microsoft.Xrm.Sdk.Query.ColumnSet("mzk_caseid",
                                                                        "mzk_fulfillmentappointment",
                                                                        "mzk_orderingappointment",
                                                                        "mzk_fulfillmentappointment",
                                                                        "mzk_customer",
                                                                        "mzk_appointmentrecommendation",
                                                                        "mzk_associateddiagnosisid",
                                                                        "mzk_patientaware",
                                                                        "mzk_comments",
                                                                        "mzk_patientencounterid",
                                                                        "mzk_orderstatus",
                                                                        "mzk_referraltoid",
                                                                        "mzk_referraltype",
                                                                        "mzk_specialityid",
                                                                        "ownerid",
                                                                        "mzk_patientordernumber",
                                                                        "createdon",
                                                                        "mzk_referralcategory",
                                                                        "mzk_referraltoexternalid",
                                                                        "mzk_hospitalid",
                                                                        "mzk_treatmentlocation", "mzk_orderinglocation");

                LinkEntity EntitySpecialty = new LinkEntity("mzk_patientorder", "characteristic", "mzk_specialityid", "characteristicid", JoinOperator.Inner);
                EntitySpecialty.Columns     = new Microsoft.Xrm.Sdk.Query.ColumnSet(true);
                EntitySpecialty.EntityAlias = "mzk_speciality";

                LinkEntity EntityDiagnosis = new LinkEntity("mzk_patientorder", "mzk_concept", "mzk_associateddiagnosisid", "mzk_conceptid", JoinOperator.LeftOuter);
                EntityDiagnosis.Columns     = new Microsoft.Xrm.Sdk.Query.ColumnSet("mzk_conceptname", "mzk_icdcodeid");
                EntityDiagnosis.EntityAlias = "mzk_conceptDiagnosis";

                LinkEntity EntityReferringPhysician = new LinkEntity("mzk_patientorder", "mzk_referringphysician", "mzk_referraltoexternalid", "mzk_referringphysicianid", JoinOperator.LeftOuter);
                EntityReferringPhysician.Columns     = new Microsoft.Xrm.Sdk.Query.ColumnSet(true);
                EntityReferringPhysician.EntityAlias = "ReferringPhysician";

                LinkEntity EntityInternalPhysician = new LinkEntity("mzk_patientorder", "systemuser", "mzk_referraltoid", "systemuserid", JoinOperator.LeftOuter);
                EntityInternalPhysician.Columns     = new Microsoft.Xrm.Sdk.Query.ColumnSet("mzk_axresourcerefrecid");
                EntityInternalPhysician.EntityAlias = "InternalPhysician";

                LinkEntity EntityOrderingPhysician = new LinkEntity("mzk_patientorder", "systemuser", "createdby", "systemuserid", JoinOperator.LeftOuter);
                EntityOrderingPhysician.Columns     = new Microsoft.Xrm.Sdk.Query.ColumnSet("mzk_axresourcerefrecid");
                EntityOrderingPhysician.EntityAlias = "OrderingPhysician";

                if (!string.IsNullOrEmpty(searchOrder))
                {
                    FilterExpression filter1 = EntityReferringPhysician.LinkCriteria.AddFilter(LogicalOperator.And);
                    filter1.AddCondition("mzk_name", ConditionOperator.Like, ("%" + searchOrder + "%"));
                    EntityReferringPhysician.LinkCriteria.AddFilter(filter1);
                }

                OrderExpression orderby = new OrderExpression();
                orderby.AttributeName = "createdon";
                orderby.OrderType     = OrderType.Descending;
                query.Orders.Add(orderby);

                query.LinkEntities.Add(EntitySpecialty);
                query.LinkEntities.Add(EntityOrderingPhysician);
                query.LinkEntities.Add(EntityDiagnosis);
                query.LinkEntities.Add(EntityReferringPhysician);
                query.LinkEntities.Add(EntityInternalPhysician);

                if (!forFulfillment && pageNumber > 0)
                {
                    query.PageInfo                        = new Microsoft.Xrm.Sdk.Query.PagingInfo();
                    query.PageInfo.Count                  = Convert.ToInt32(AppSettings.GetByKey("PageSize"));
                    query.PageInfo.PageNumber             = pageNumber;
                    query.PageInfo.PagingCookie           = null;
                    query.PageInfo.ReturnTotalRecordCount = true;
                }

                #endregion

                SoapEntityRepository entityRepository = SoapEntityRepository.GetService();
                EntityCollection     entitycollection = entityRepository.GetEntityCollection(query);
                string Name = string.Empty;
                foreach (Entity entity in entitycollection.Entities)
                {
                    if (entity.Contains("mzk_referraltoid"))
                    {
                        Name = ((EntityReference)entity["mzk_referraltoid"]).Name;
                    }
                    else
                    if (entity.Contains("ReferringPhysician.mzk_name"))
                    {
                        Name = ((AliasedValue)entity["ReferringPhysician.mzk_name"]).Value.ToString();
                    }

                    if (!string.IsNullOrEmpty(searchOrder))
                    {
                        if (Name.ToLower().Contains(searchOrder.ToLower()))
                        {
                            PatientReferralOrder model = new PatientReferralOrder();

                            if (!this.getPatientOrder(model, entity, forFulfillment, orderId, mzk_entitytype.ReferralOrder))
                            {
                                continue;
                            }

                            if (entity.Attributes.Contains("mzk_specialityid"))
                            {
                                model.SpecialtyId   = ((EntityReference)entity["mzk_specialityid"]).Id.ToString();
                                model.SpecialtyName = ((EntityReference)entity["mzk_specialityid"]).Name;
                            }

                            if (entity.Attributes.Contains("ownerid"))
                            {
                                model.RefPhysician = ((EntityReference)entity["ownerid"]).Name;
                            }

                            if (entity.Attributes.Contains("createdon"))
                            {
                                model.ReferralDate = Convert.ToDateTime(entity.Attributes["createdon"]);
                            }
                            if (entity.Attributes.Contains("mzk_comments"))
                            {
                                model.ReferralComment = entity["mzk_comments"].ToString();
                            }
                            if (entity.Attributes.Contains("mzk_patientaware") && Convert.ToBoolean(entity["mzk_patientaware"]) == true)
                            {
                                model.PatientAware = "1";
                            }
                            else
                            {
                                model.PatientAware = "0";
                            }

                            if (entity.Attributes.Contains("mzk_appointmentrecommendation"))
                            {
                                model.Apptrecommendation     = ((OptionSetValue)entity.Attributes["mzk_appointmentrecommendation"]).Value;
                                model.ApptrecommendationName = entity.FormattedValues["mzk_appointmentrecommendation"].ToString();
                            }

                            if (entity.Attributes.Contains("mzk_referraltype"))
                            {
                                model.ReferralType     = ((OptionSetValue)entity["mzk_referraltype"]).Value;
                                model.ReferralTypeName = entity.FormattedValues["mzk_referraltype"].ToString();
                            }

                            if (entity.Attributes.Contains("mzk_referralcategory"))
                            {
                                model.Category     = ((OptionSetValue)entity["mzk_referralcategory"]).Value;
                                model.CategoryName = entity.FormattedValues["mzk_referralcategory"].ToString();

                                if (((OptionSetValue)entity["mzk_referralcategory"]).Value == Convert.ToInt32(mzk_patientordermzk_ReferralCategory.Internal))
                                {
                                    if (entity.Attributes.Contains("mzk_referraltoid"))
                                    {
                                        model.Referralto = ((EntityReference)entity["mzk_referraltoid"]).Name;
                                    }
                                }
                                else
                                {
                                    if (((OptionSetValue)entity["mzk_referralcategory"]).Value == Convert.ToInt32(mzk_patientordermzk_ReferralCategory.External))
                                    {
                                        if (entity.Attributes.Contains("ReferringPhysician.mzk_name"))
                                        {
                                            model.Referralto = ((AliasedValue)entity["ReferringPhysician.mzk_name"]).Value.ToString();
                                        }
                                    }
                                }
                            }

                            if (entity.Attributes.Contains("mzk_associateddiagnosisid"))
                            {
                                model.Diagnosis = ((EntityReference)entity.Attributes["mzk_associateddiagnosisid"]).Id.ToString();
                            }

                            if (entity.Attributes.Contains("mzk_hospitalid"))
                            {
                                model.HospitalId   = ((EntityReference)entity.Attributes["mzk_hospitalid"]).Id.ToString();
                                model.HospitalName = ((EntityReference)entity.Attributes["mzk_hospitalid"]).Name.ToString();
                            }

                            if (entity.Attributes.Contains("mzk_conceptDiagnosis.mzk_conceptname"))
                            {
                                model.DiagnosisName = ((AliasedValue)entity.Attributes["mzk_conceptDiagnosis.mzk_conceptname"]).Value.ToString();
                            }

                            if (entity.Attributes.Contains("mzk_conceptDiagnosis.mzk_icdcodeid"))
                            {
                                model.ICDCode = ((EntityReference)((AliasedValue)entity.Attributes["mzk_conceptDiagnosis.mzk_icdcodeid"]).Value).Name;
                            }

                            PatientReferral.Add(model);
                        }
                    }
                    else
                    {
                        PatientReferralOrder model = new PatientReferralOrder();

                        if (!this.getPatientOrder(model, entity, forFulfillment, orderId, mzk_entitytype.ReferralOrder))
                        {
                            continue;
                        }

                        if (entity.Attributes.Contains("mzk_specialityid"))
                        {
                            model.SpecialtyId   = ((EntityReference)entity["mzk_specialityid"]).Id.ToString();
                            model.SpecialtyName = ((EntityReference)entity["mzk_specialityid"]).Name;
                        }

                        if (entity.Attributes.Contains("ownerid"))
                        {
                            model.RefPhysician = ((EntityReference)entity["ownerid"]).Name;
                        }

                        if (entity.Attributes.Contains("OrderingPhysician.mzk_axresourcerefrecid"))
                        {
                            model.RefPhysicianResourceId = ((AliasedValue)entity.Attributes["OrderingPhysician.mzk_axresourcerefrecid"]).Value.ToString();
                        }

                        if (entity.Attributes.Contains("createdon"))
                        {
                            model.ReferralDate = Convert.ToDateTime(entity.Attributes["createdon"]);
                        }
                        if (entity.Attributes.Contains("mzk_comments"))
                        {
                            model.ReferralComment = entity["mzk_comments"].ToString();
                        }
                        if (entity.Attributes.Contains("mzk_patientaware") && Convert.ToBoolean(entity["mzk_patientaware"]) == true)
                        {
                            model.PatientAware = "1";
                        }
                        else
                        {
                            model.PatientAware = "0";
                        }

                        if (entity.Attributes.Contains("mzk_appointmentrecommendation"))
                        {
                            model.Apptrecommendation     = ((OptionSetValue)entity.Attributes["mzk_appointmentrecommendation"]).Value;
                            model.ApptrecommendationName = entity.FormattedValues["mzk_appointmentrecommendation"].ToString();
                        }

                        if (entity.Attributes.Contains("mzk_referraltype"))
                        {
                            model.ReferralType     = ((OptionSetValue)entity["mzk_referraltype"]).Value;
                            model.ReferralTypeName = entity.FormattedValues["mzk_referraltype"].ToString();
                        }

                        if (entity.Attributes.Contains("mzk_referralcategory"))
                        {
                            model.Category     = ((OptionSetValue)entity["mzk_referralcategory"]).Value;
                            model.CategoryName = entity.FormattedValues["mzk_referralcategory"].ToString();

                            if (((OptionSetValue)entity["mzk_referralcategory"]).Value == Convert.ToInt32(mzk_patientordermzk_ReferralCategory.Internal))
                            {
                                if (entity.Attributes.Contains("mzk_referraltoid"))
                                {
                                    model.Referralto = ((EntityReference)entity["mzk_referraltoid"]).Name;
                                }

                                if (entity.Attributes.Contains("InternalPhysician.mzk_axresourcerefrecid"))
                                {
                                    model.ResourceRecId = ((AliasedValue)entity["InternalPhysician.mzk_axresourcerefrecid"]).Value.ToString();
                                }
                            }
                            else
                            {
                                if (((OptionSetValue)entity["mzk_referralcategory"]).Value == Convert.ToInt32(mzk_patientordermzk_ReferralCategory.External))
                                {
                                    if (entity.Attributes.Contains("ReferringPhysician.mzk_name"))
                                    {
                                        model.Referralto = ((AliasedValue)entity["ReferringPhysician.mzk_name"]).Value.ToString();
                                    }
                                }
                            }
                        }

                        if (entity.Attributes.Contains("mzk_hospitalid"))
                        {
                            model.HospitalId   = ((EntityReference)entity.Attributes["mzk_hospitalid"]).Id.ToString();
                            model.HospitalName = ((EntityReference)entity.Attributes["mzk_hospitalid"]).Name.ToString();
                        }

                        if (entity.Attributes.Contains("mzk_associateddiagnosisid"))
                        {
                            model.Diagnosis = ((EntityReference)entity.Attributes["mzk_associateddiagnosisid"]).Id.ToString();
                        }

                        if (entity.Attributes.Contains("mzk_conceptDiagnosis.mzk_conceptname"))
                        {
                            model.DiagnosisName = ((AliasedValue)entity.Attributes["mzk_conceptDiagnosis.mzk_conceptname"]).Value.ToString();
                        }


                        if (entity.Attributes.Contains("mzk_conceptDiagnosis.mzk_icdcodeid"))
                        {
                            model.ICDCode = ((EntityReference)((AliasedValue)entity.Attributes["mzk_conceptDiagnosis.mzk_icdcodeid"]).Value).Name;
                        }


                        PatientReferral.Add(model);
                    }
                }

                if (pageNumber > 0 && entitycollection != null)
                {
                    Pagination.totalCount = entitycollection.TotalRecordCount;
                }

                return(PatientReferral);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }