Ejemplo n.º 1
0
        public List <Order_Model_Extended> GetOrderListData(ElasticParameterObject sort_parameter, string connectionString, string sessionTicket, out TransactionalInformation transaction)
        {
            var method = MethodInfo.GetCurrentMethod();
            var ipInfo = Util.GetIPInfo(HttpContext.Current.Request);

            transaction = new TransactionalInformation();
            var OrderListData      = new List <Order_Model_Extended>();
            var userSecurityTicket = VerifySessionToken(sessionTicket);

            try
            {
                var results = Get_Orders.Get_All_Orders(sort_parameter, userSecurityTicket);
                OrderListData = results.Select(order =>
                {
                    var extended = new Order_Model_Extended();
                    extended.PopulateBase(order);
                    extended.delivery_date_string = extended.delivery_time_from.ToString("dd.MM.yyyy");
                    return(extended);
                }).ToList();
            }
            catch (Exception ex)
            {
                Logger.LogInfo(new LogEntry(ipInfo.address, ipInfo.agent, connectionString, method, userSecurityTicket, ex));

                transaction.ReturnMessage = new List <string>();
                string errorMessage = ex.Message;
                transaction.ReturnStatus = false;
                transaction.ReturnMessage.Add(errorMessage);
                transaction.IsAuthenicated = true;
                transaction.IsException    = true;
            }

            return(OrderListData);
        }
Ejemplo n.º 2
0
        public static IEnumerable <IEnumerable <IElasticMapper> > GetUpdatedData(string index_name, string id, string type, string[] values)
        {
            var planning_cases  = new List <Case_Model>();
            var open_aftercares = new List <Aftercare_Model>();
            var error_correction_settlements = new List <Settlement_Model>();
            var error_correction_treatments  = new List <Submitted_Case_Model>();
            var patients        = new List <Patient_Model>();
            var patient_details = new List <PatientDetailViewModel>();
            var orders          = new List <Order_Model>();
            var octs            = new List <Oct_Model>();

            switch (type)
            {
            case "doctor":

                #region UPDATE PLANNING CASES
                var cases_from_elastic = Get_Cases.GetCasesWhereIDPresent <Case_Model>(id, "treatment_doctor_id", index_name, "case");
                if (cases_from_elastic.Any())
                {
                    planning_cases = cases_from_elastic.Select(cas =>
                    {
                        cas.treatment_doctor_name = values[0];
                        cas.treatment_doctor_lanr = values[1];

                        return(cas);
                    }).ToList();
                }

                cases_from_elastic = Get_Cases.GetCasesWhereIDPresent <Case_Model>(id, "aftercare_doctor_practice_id", index_name, "case");
                if (cases_from_elastic.Any())
                {
                    planning_cases.AddRange(cases_from_elastic.Select(cas =>
                    {
                        planning_cases.RemoveAll(pc => pc.id == cas.id);

                        cas.treatment_doctor_name = values[0];
                        cas.treatment_doctor_lanr = values[1];


                        cas.aftercare_name        = values[0];
                        cas.aftercare_doctor_lanr = values[1];

                        return(cas);
                    }).ToList());
                }
                #endregion

                #region UPDATE AFTERCARES
                var aftercares_from_elastic = Get_Cases.GetCasesWhereIDPresent <Aftercare_Model>(id, "treatment_doctor_id", index_name, "aftercare");
                if (aftercares_from_elastic.Any())
                {
                    open_aftercares = aftercares_from_elastic.Select(ac =>
                    {
                        ac.treatment_doctor_name = values[0];
                        ac.op_lanr = values[1];

                        return(ac);
                    }).ToList();
                }

                aftercares_from_elastic = Get_Cases.GetCasesWhereIDPresent <Aftercare_Model>(id, "aftercare_doctor_practice_id", index_name, "aftercare");
                if (aftercares_from_elastic.Any())
                {
                    open_aftercares.AddRange(aftercares_from_elastic.Select(ac =>
                    {
                        open_aftercares.RemoveAll(oac => oac.id == ac.id);

                        ac.treatment_doctor_name = values[0];
                        ac.ac_lanr = values[1];


                        ac.aftercare_doctor_name = values[0];

                        return(ac);
                    }).ToList());
                }
                #endregion

                #region UPDATE SETTLEMENTS IN ERROR CORRECTION
                var settlements_from_elastic = Get_Settlement.GetCasesWhereIDPresent(id, "treatment_doctor_id", index_name, "op");
                if (settlements_from_elastic.Any())
                {
                    error_correction_settlements = settlements_from_elastic.Select(cas =>
                    {
                        cas.doctor = values[0];
                        cas.lanr   = values[1];

                        return(cas);
                    }).ToList();
                }

                settlements_from_elastic = Get_Settlement.GetCasesWhereIDPresent(id, "aftercare_doctor_practice_id", index_name, "ac");
                if (settlements_from_elastic.Any())
                {
                    error_correction_settlements.AddRange(settlements_from_elastic.Select(cas =>
                    {
                        error_correction_settlements.RemoveAll(ecs => ecs.id == cas.id);

                        cas.doctor = values[0];
                        cas.lanr   = values[1];


                        cas.doctor = values[0];
                        cas.lanr   = values[1];

                        return(cas);
                    }).ToList());
                }
                #endregion

                #region UPDATE MM TREATMENTS IN ERROR CORRECTION
                var treatments_from_elastic = Get_Cases.GetSubmittedCasesInErrorCorrectionAndWhereIDPresent(id, "doctor_id", index_name, "op");
                if (treatments_from_elastic.Any())
                {
                    error_correction_treatments = treatments_from_elastic.Select(cas =>
                    {
                        cas.doctor_name = values[0];
                        cas.doctor_lanr = values[1];

                        return(cas);
                    }).ToList();
                }

                treatments_from_elastic = Get_Cases.GetSubmittedCasesInErrorCorrectionAndWhereIDPresent(id, "doctor_id", index_name, "ac");
                if (treatments_from_elastic.Any())
                {
                    error_correction_treatments.AddRange(treatments_from_elastic.Select(cas =>
                    {
                        error_correction_treatments.RemoveAll(ect => ect.id == cas.id);

                        cas.doctor_name = values[0];
                        cas.doctor_lanr = values[1];


                        cas.doctor_name = values[0];
                        cas.doctor_lanr = values[1];

                        return(cas);
                    }).ToList());
                }
                #endregion

                #region UPDATE ORDERS
                var orders_from_elastic = Get_Orders.GetOrdersWhereForIdAndOrdinal(id, "doctor_id", index_name);
                if (orders_from_elastic.Any())
                {
                    orders = orders_from_elastic.Select(ord =>
                    {
                        ord.treatment_doctor_name = values[0];
                        ord.lanr = values[1];

                        return(ord);
                    }).ToList();
                }
                #endregion

                #region UPDATE PATIENTS
                var patients_from_elastic = Retrieve_Patients.GetPatientsWhereIDPresent(id, "op_doctor_id", index_name);
                if (patients_from_elastic.Any())
                {
                    patients = patients_from_elastic.Select(patient =>
                    {
                        patient.last_first_op_doctor_name = values[0];
                        patient.op_doctor_lanr            = values[1];

                        return(patient);
                    }).ToList();
                }

                patients_from_elastic = Retrieve_Patients.GetPatientsWhereIDPresent(id, "ac_doctor_id", index_name);
                if (patients_from_elastic.Any())
                {
                    patients.AddRange(patients_from_elastic.Select(patient =>
                    {
                        patients.RemoveAll(pat => pat.id == patient.id);

                        patient.last_first_op_doctor_name = values[0];
                        patient.op_doctor_lanr            = values[1];
                        patient.last_first_ac_doctor_name = values[0];
                        patient.ac_doctor_lanr            = values[1];

                        return(patient);
                    }).ToList());
                }
                #endregion

                #region UPDATE PATIENT DETAILS
                var patients_details_from_elastic = Retrieve_Patients.GetPatientDetailsForIdAndOrdinal(id, "treatment_doctor_id", index_name);
                if (patients_details_from_elastic.Any())
                {
                    patient_details = patients_details_from_elastic.Select(patient =>
                    {
                        patient.doctor = values[0];

                        return(patient);
                    }).ToList();
                }

                patients_details_from_elastic = Retrieve_Patients.GetPatientDetailsForIdAndOrdinal(id, "aftercare_doctor_practice_id", index_name);
                if (patients_details_from_elastic.Any())
                {
                    patient_details.AddRange(patients_details_from_elastic.Select(patient =>
                    {
                        patient.doctor = values[0];

                        return(patient);
                    }).ToList());
                }
                #endregion

                #region UPDATE OCT

                octs.AddRange(Retrieve_Octs.GetOctsWhereFieldsHaveValues(new List <FieldValueParameter>()
                {
                    new FieldValueParameter()
                    {
                        FieldName = "oct_doctor_id", FieldValue = id
                    },
                    new FieldValueParameter()
                    {
                        FieldName = "treatment_doctor_id", FieldValue = id, Negation = true
                    }
                }, null, index_name)
                              .Select(t =>
                {
                    t.oct_doctor_name = values[0];

                    return(t);
                }).ToList());

                octs.AddRange(Retrieve_Octs.GetOctsWhereFieldsHaveValues(new List <FieldValueParameter>()
                {
                    new FieldValueParameter()
                    {
                        FieldName = "treatment_doctor_id", FieldValue = id
                    },
                    new FieldValueParameter()
                    {
                        FieldName = "oct_doctor_id", FieldValue = id, Negation = true
                    }
                }, null, index_name)
                              .Select(t =>
                {
                    t.treatment_doctor_name = values[0];

                    return(t);
                }).ToList());

                octs.AddRange(Retrieve_Octs.GetOctsWhereFieldsHaveValues(new List <FieldValueParameter>()
                {
                    new FieldValueParameter()
                    {
                        FieldName = "treatment_doctor_id", FieldValue = id
                    },
                    new FieldValueParameter()
                    {
                        FieldName = "oct_doctor_id", FieldValue = id
                    }
                }, null, index_name)
                              .Select(t =>
                {
                    t.oct_doctor_name       = values[0];
                    t.treatment_doctor_name = values[0];

                    return(t);
                }).ToList());

                #endregion

                #region UPDATE AC DOCTORS
                var types = Elastic_Utils.GetAllTypes(index_name);

                HashSet <string> last_used_types = new HashSet <string>();

                var     newTypes     = types.Replace(index_name, "allData");
                dynamic data         = JObject.Parse(newTypes);
                var     mappings     = data.allData.mappings;
                var     neededLength = Guid.Empty.ToString().Length + 5;
                var     elasticType  = "user_";

                foreach (var acType in mappings)
                {
                    if (acType.Name.Contains(elasticType) && acType.Name.Length == neededLength)
                    {
                        var dataForType = Get_Practices_and_Doctors.GetACDoctorsWhereIDPresent(id, "id", index_name, acType.Name);

                        foreach (var acDoc in dataForType)
                        {
                            acDoc.display_name = String.Format("{0} ({1})", values[0], values[1]);
                        }

                        var accountID = acType.Name.Split(new string[] { elasticType }, StringSplitOptions.None)[1];
                        UpdateAftercareDoctor(dataForType, index_name, accountID, elasticType);
                    }
                }
                ;
                #endregion

                break;

            case "practice":

                #region UPDATE PLANNING CASES
                var practice_cases_from_elastic = Get_Cases.GetCasesWhereIDPresent <Case_Model>(id, "aftercare_doctors_practice_id", index_name, "case");
                if (practice_cases_from_elastic.Any())
                {
                    planning_cases = practice_cases_from_elastic.Select(cas =>
                    {
                        cas.aftercare_doctors_practice_name = values[0];
                        cas.aftercare_practice_bsnr         = values[1];

                        return(cas);
                    }).ToList();
                }

                practice_cases_from_elastic = Get_Cases.GetCasesWhereIDPresent <Case_Model>(id, "aftercare_doctor_practice_id", index_name, "case");
                if (practice_cases_from_elastic.Any())
                {
                    planning_cases.AddRange(practice_cases_from_elastic.Select(cas =>
                    {
                        planning_cases.RemoveAll(pc => pc.id == cas.id);

                        cas.aftercare_doctors_practice_name = values[0];
                        cas.aftercare_practice_bsnr         = values[1];


                        cas.aftercare_name          = values[0];
                        cas.aftercare_practice_bsnr = values[1];

                        return(cas);
                    }).ToList());
                }
                #endregion

                #region UPDATE AFTERCARES
                var practice_aftercares_from_elastic = Get_Cases.GetCasesWhereIDPresent <Aftercare_Model>(id, "treatment_doctors_practice_id", index_name, "aftercare");
                if (practice_aftercares_from_elastic.Any())
                {
                    open_aftercares = practice_aftercares_from_elastic.Select(ac =>
                    {
                        ac.treatment_doctor_practice_name = values[0];
                        ac.bsnr = values[1];

                        return(ac);
                    }).ToList();
                }
                #endregion

                #region UPDATE MM TREATMENTS IN ERROR CORRECTION
                var practice_treatments_from_elastic = Get_Cases.GetSubmittedCasesInErrorCorrectionAndWhereIDPresent(id, "practice_id", index_name);
                if (practice_treatments_from_elastic.Any())
                {
                    error_correction_treatments = practice_treatments_from_elastic.Select(cas =>
                    {
                        cas.practice_name = values[0];
                        cas.practice_bsnr = values[1];

                        return(cas);
                    }).ToList();
                }
                #endregion

                #region UPDATE ORDERS
                var practice_orders_from_elastic = Get_Orders.GetOrdersWhereIDPresent(id, "practice_id", index_name);
                if (practice_orders_from_elastic.Any())
                {
                    orders = practice_orders_from_elastic.Select(ord =>
                    {
                        ord.treatment_doctor_practice_name = values[0];
                        ord.bsnr = values[1];

                        return(ord);
                    }).ToList();
                }
                #endregion

                #region UPDATE PATIENTS
                var pratice_patients_from_elastic = Retrieve_Patients.GetPatientsWhereIDPresent(id, "practice_id", index_name);
                if (pratice_patients_from_elastic.Any())
                {
                    patients = pratice_patients_from_elastic.Select(patient =>
                    {
                        patient.practice      = values[0];
                        patient.practice_bsnr = values[1];

                        return(patient);
                    }).ToList();
                }

                pratice_patients_from_elastic = Retrieve_Patients.GetPatientsWhereIDPresent(id, "ac_practice_id", index_name);
                if (pratice_patients_from_elastic.Any())
                {
                    patients.AddRange(pratice_patients_from_elastic.Select(patient =>
                    {
                        patients.RemoveAll(pat => pat.id == patient.id);

                        patient.practice      = values[0];
                        patient.practice_bsnr = values[1];


                        patient.ac_practice      = values[0];
                        patient.ac_practice_bsnr = values[1];

                        return(patient);
                    }).ToList());
                }
                #endregion

                break;

            case "patient":
                IFormatProvider culture = new System.Globalization.CultureInfo("de", true);

                #region UPDATE PLANNING CASES
                var patient_cases_from_elastic = Get_Cases.GetCasesWhereIDPresent <Case_Model>(id, "patient_id", index_name, "case");
                if (patient_cases_from_elastic.Any())
                {
                    planning_cases = patient_cases_from_elastic.Select(cas =>
                    {
                        cas.patient_name             = values[0];
                        cas.patient_insurance_number = values[1];
                        cas.patient_birthdate        = DateTime.Parse(values[2], culture, System.Globalization.DateTimeStyles.AssumeLocal);
                        cas.patient_birthdate_string = values[2];

                        return(cas);
                    }).ToList();
                }
                #endregion

                #region UPDATE AFTERCARES
                var patient_aftercares_from_elastic = Get_Cases.GetCasesWhereIDPresent <Aftercare_Model>(id, "patient_id", index_name, "aftercare");
                if (patient_aftercares_from_elastic.Any())
                {
                    open_aftercares = patient_aftercares_from_elastic.Select(ac =>
                    {
                        ac.patient_name             = values[0];
                        ac.patient_insurance_number = values[1];
                        ac.patient_birthdate        = DateTime.Parse(values[2], culture, System.Globalization.DateTimeStyles.AssumeLocal);
                        ac.patient_birthdate_string = values[2];

                        return(ac);
                    }).ToList();
                }
                #endregion

                #region UPDATE SETTLEMENTS IN ERROR CORRECTION
                var patient_settlements_from_elastic = Get_Settlement.GetCasesWhereIDPresent(id, "patient_id", index_name);
                if (patient_settlements_from_elastic.Any())
                {
                    error_correction_settlements = patient_settlements_from_elastic.Select(cas =>
                    {
                        cas.patient_full_name        = values[0];
                        cas.patient_insurance_number = values[1];
                        cas.birthday = values[2];

                        return(cas);
                    }).ToList();
                }
                #endregion

                #region UPDATE MM TREATMENTS IN ERROR CORRECTION
                var patient_treatments_from_elastic = Get_Cases.GetSubmittedCasesInErrorCorrectionAndWhereIDPresent(id, "patient_id", index_name);
                if (patient_treatments_from_elastic.Any())
                {
                    error_correction_treatments = patient_treatments_from_elastic.Select(cas =>
                    {
                        cas.patient_name             = values[0];
                        cas.patient_insurance_number = values[1];
                        cas.patient_birthdate        = DateTime.Parse(values[2], culture, System.Globalization.DateTimeStyles.AssumeLocal);
                        cas.patient_birthdate_string = values[2];

                        return(cas);
                    }).ToList();
                }
                #endregion

                #region UPDATE ORDERS
                var patient_orders_from_elastic = Get_Orders.GetOrdersWhereIDPresent(id, "patient_id", index_name);
                if (patient_orders_from_elastic.Any())
                {
                    orders = patient_orders_from_elastic.Select(ord =>
                    {
                        ord.patient_name             = values[0];
                        ord.patient_insurance_number = values[1];
                        ord.patient_birthdate        = DateTime.Parse(values[2], culture, System.Globalization.DateTimeStyles.AssumeLocal);
                        ord.patient_birthdate_string = values[2];

                        return(ord);
                    }).ToList();
                }
                #endregion

                #region UPDATE OCT
                octs = Retrieve_Octs.GetOctsWhereFieldsHaveValues(new List <FieldValueParameter>()
                {
                    new FieldValueParameter()
                    {
                        FieldName = "patient_id", FieldValue = id
                    },
                    new FieldValueParameter()
                    {
                        FieldName = "status.lower_case_sort", FieldValue = "oct1"
                    },
                }, null, index_name)
                       .Select(t =>
                {
                    t.patient_name             = values[0];
                    t.patient_insurance_number = values[1];
                    t.patient_birthdate        = DateTime.Parse(values[2], culture, System.Globalization.DateTimeStyles.AssumeLocal);

                    return(t);
                }).ToList();
                #endregion

                break;

            case "drug":

                #region UPDATE PLANNING CASES
                var drug_cases_from_elastic = Get_Cases.GetCasesWhereIDPresent <Case_Model>(id, "drug_id", index_name, "case");
                if (drug_cases_from_elastic.Any())
                {
                    planning_cases = drug_cases_from_elastic.Select(cas =>
                    {
                        cas.drug = values[0];

                        return(cas);
                    }).ToList();
                }
                #endregion

                #region UPDATE SETTLEMENTS IN ERROR CORRECTION
                var drug_settlements_from_elastic = Get_Settlement.GetCasesWhereIDPresent(id, "drug_id", index_name);
                if (drug_settlements_from_elastic.Any())
                {
                    error_correction_settlements = drug_settlements_from_elastic.Select(cas =>
                    {
                        cas.drug = values[0];

                        return(cas);
                    }).ToList();
                }
                #endregion

                #region UPDATE MM TREATMENTS IN ERROR CORRECTION
                var drug_treatments_from_elastic = Get_Cases.GetSubmittedCasesInErrorCorrectionAndWhereIDPresent(id, "drug_id", index_name);
                if (drug_treatments_from_elastic.Any())
                {
                    error_correction_treatments = drug_treatments_from_elastic.Select(cas =>
                    {
                        cas.drug = values[0];

                        return(cas);
                    }).ToList();
                }
                #endregion

                #region UPDATE ORDERS
                var drug_orders_from_elastic = Get_Orders.GetOrdersWhereIDPresent(id, "drug_id", index_name);
                if (drug_orders_from_elastic.Any())
                {
                    orders = drug_orders_from_elastic.Select(ord =>
                    {
                        ord.drug = values[0];

                        return(ord);
                    }).ToList();
                }
                #endregion

                #region UPDATE PATIENT DETAILS
                var drug_patients_details_from_elastic = Retrieve_Patients.GetPatientDetailsWhereIDPresent(id, "drug_id", index_name);
                if (drug_patients_details_from_elastic.Any())
                {
                    patient_details = drug_patients_details_from_elastic.Select(patient =>
                    {
                        patient.drug = values[0];
                        if (patient.detail_type == "order")
                        {
                            patient.diagnose_or_medication = values[0];
                        }

                        return(patient);
                    }).ToList();
                }
                #endregion

                break;

            case "diagnose":

                #region UPDATE PLANNING CASES
                var diagnose_cases_from_elastic = Get_Cases.GetCasesWhereIDPresent <Case_Model>(id, "diagnose_id", index_name, "case");
                if (diagnose_cases_from_elastic.Any())
                {
                    planning_cases = diagnose_cases_from_elastic.Select(cas =>
                    {
                        cas.diagnose = values[0];

                        return(cas);
                    }).ToList();
                }
                #endregion

                #region UPDATE SETTLEMENTS IN ERROR CORRECTION
                var diagnose_settlements_from_elastic = Get_Settlement.GetCasesWhereIDPresent(id, "diagnose_id", index_name);
                if (diagnose_settlements_from_elastic.Any())
                {
                    error_correction_settlements = diagnose_settlements_from_elastic.Select(cas =>
                    {
                        cas.diagnose = values[0];

                        return(cas);
                    }).ToList();
                }
                #endregion

                #region UPDATE MM TREATMENTS IN ERROR CORRECTION
                var diagnose_treatments_from_elastic = Get_Cases.GetSubmittedCasesInErrorCorrectionAndWhereIDPresent(id, "diagnose_id", index_name);
                if (diagnose_treatments_from_elastic.Any())
                {
                    error_correction_treatments = diagnose_treatments_from_elastic.Select(cas =>
                    {
                        cas.diagnose = values[0];

                        return(cas);
                    }).ToList();
                }
                #endregion

                #region UPDATE ORDERS
                var diagnose_orders_from_elastic = Get_Orders.GetOrdersWhereIDPresent(id, "diagnose_id", index_name);
                if (diagnose_orders_from_elastic.Any())
                {
                    orders = diagnose_orders_from_elastic.Select(ord =>
                    {
                        ord.diagnose = values[0];

                        return(ord);
                    }).ToList();
                }
                #endregion

                #region UPDATE PATIENT DETAILS
                var diagnose_patients_details_from_elastic = Retrieve_Patients.GetPatientDetailsWhereIDPresent(id, "diagnose_id", index_name);
                if (diagnose_patients_details_from_elastic.Any())
                {
                    patient_details = diagnose_patients_details_from_elastic.Select(patient =>
                    {
                        if (patient.detail_type == "op" || patient.detail_type == "ac")
                        {
                            patient.diagnose_or_medication = values[0];
                        }

                        return(patient);
                    }).ToList();
                }
                #endregion

                break;

            default:
                break;
            }

            return(new List <IEnumerable <IElasticMapper> >()
            {
                planning_cases,
                open_aftercares,
                error_correction_settlements,
                error_correction_treatments,
                orders,
                patients,
                patient_details,
                octs
            });
        }
Ejemplo n.º 3
0
        protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_OR_COS_0840 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
        {
            #region UserCode
            var returnValue = new FR_Guid();
            List <Case_Model>             cases             = new List <Case_Model>();
            List <PatientDetailViewModel> patientDetailList = new List <PatientDetailViewModel>();
            List <Order_Model>            OrderModelL       = new List <Order_Model>();
            //Put your code here
            foreach (var ParameterInstance in Parameter.ParameterArray)
            {
                var procurmentHeader = ORM_ORD_PRC_ProcurementOrder_Header.Query.Search(Connection, Transaction, new ORM_ORD_PRC_ProcurementOrder_Header.Query()
                {
                    IsDeleted    = false,
                    Tenant_RefID = securityTicket.TenantID,
                    ORD_PRC_ProcurementOrder_HeaderID = ParameterInstance.Order_ID
                }).Single();


                var newOrderStatus = new ORM_ORD_PRC_ProcurementOrder_Status();
                newOrderStatus.Tenant_RefID           = securityTicket.TenantID;
                newOrderStatus.Status_Code            = ParameterInstance.Status_To;
                newOrderStatus.Modification_Timestamp = DateTime.Now;
                newOrderStatus.Save(Connection, Transaction);

                var newOrderStatusHistory = new ORM_ORD_PRC_ProcurementOrder_StatusHistory();
                newOrderStatusHistory.Tenant_RefID = securityTicket.TenantID;
                newOrderStatusHistory.ProcurementOrder_Status_RefID = newOrderStatus.ORD_PRC_ProcurementOrder_StatusID;
                newOrderStatusHistory.IsStatus_RejectedBySupplier   = true;
                newOrderStatusHistory.ProcurementOrder_Header_RefID = procurmentHeader.ORD_PRC_ProcurementOrder_HeaderID;
                newOrderStatusHistory.Save(Connection, Transaction);

                procurmentHeader.Current_ProcurementOrderStatus_RefID = newOrderStatus.ORD_PRC_ProcurementOrder_StatusID;
                procurmentHeader.Save(Connection, Transaction);

                #region Update Case Elastic
                var caseForUpdate = cls_Get_Case_Details_for_CaseID.Invoke(Connection, Transaction, new P_CAS_GCDfCID_1435()
                {
                    CaseID = ParameterInstance.CaseID
                }, securityTicket).Result;
                var patient_details = cls_Get_Patient_Details_for_PatientID.Invoke(Connection, Transaction, new P_P_PA_GPDfPID_1124()
                {
                    PatientID = caseForUpdate.patient_id
                }, securityTicket).Result;
                var diagnose_details = cls_Get_Diagnose_Details_for_DiagnoseID.Invoke(Connection, Transaction, new P_CAS_GDDfDID_1608()
                {
                    DiagnoseID = caseForUpdate.diagnose_id
                }, securityTicket).Result;
                var drug_details = cls_Get_Drug_Details_for_DrugID.Invoke(Connection, Transaction, new P_CAS_GDDfDID_1614()
                {
                    DrugID = caseForUpdate.drug_id
                }, securityTicket).Result;
                var treatment_doctor_details = cls_Get_Doctor_Details_for_DoctorID.Invoke(Connection, Transaction, new P_DO_GDDfDID_0823()
                {
                    DoctorID = caseForUpdate.op_doctor_id
                }, securityTicket).Result.SingleOrDefault();
                var case_status = cls_Check_Case_Status.Invoke(Connection, Transaction, new P_CAS_CCS_1639()
                {
                    CaseID = ParameterInstance.CaseID
                }, securityTicket).Result;
                if (case_status == null)
                {
                    var case_model_elastic = Get_Cases.GetCaseforCaseID(caseForUpdate.case_id.ToString(), securityTicket);
                    if (case_model_elastic != null)
                    {
                        case_model_elastic.status_drug_order                   = ParameterInstance.Status_To_Str;
                        case_model_elastic.order_modification_timestamp        = caseForUpdate.order_modification_timestamp;
                        case_model_elastic.order_modification_timestamp_string = caseForUpdate.order_modification_timestamp.ToString("dd.MM.yyyy");

                        cases.Add(case_model_elastic);
                    }
                }
                #endregion

                var orderM = Get_Orders.GetOrderforOrderID(procurmentHeader.ORD_PRC_ProcurementOrder_HeaderID.ToString(), securityTicket);
                if (orderM != null)
                {
                    orderM.status_drug_order                   = ParameterInstance.Status_To_Str;
                    orderM.order_modification_timestamp        = DateTime.Now;
                    orderM.order_modification_timestamp_string = DateTime.Now.ToString("dd.MM.yyyy");

                    OrderModelL.Add(orderM);

                    var patientDetalTreatmentWithOrder = Retrieve_Patients.Get_PatientDetaiForIDandOrderID(orderM.id, securityTicket).Where(i => i.detail_type == "op").SingleOrDefault();


                    if (patientDetalTreatmentWithOrder == null)
                    {
                        PatientDetailViewModel patient_detail = new PatientDetailViewModel();
                        patient_detail.case_id                = orderM.case_id;
                        patient_detail.date                   = orderM.treatment_date;
                        patient_detail.date_string            = patient_detail.date.ToString("dd.MM.");
                        patient_detail.detail_type            = "order";
                        patient_detail.diagnose_or_medication = orderM.drug;
                        patient_detail.practice_id            = orderM.practice_id;
                        patient_detail.id           = orderM.id;
                        patient_detail.order_id     = orderM.id;
                        patient_detail.case_id      = orderM.case_id;
                        patient_detail.order_status = orderM.status_drug_order;
                        patient_detail.patient_id   = patient_details.id.ToString();
                        patient_detail.drug_id      = orderM.drug_id;

                        patientDetailList.Add(patient_detail);
                    }
                    else
                    {
                        patientDetalTreatmentWithOrder.date         = orderM.treatment_date;
                        patientDetalTreatmentWithOrder.date_string  = patientDetalTreatmentWithOrder.date.ToString("dd.MM.");
                        patientDetalTreatmentWithOrder.case_id      = orderM.case_id;
                        patientDetalTreatmentWithOrder.order_id     = orderM.id;
                        patientDetalTreatmentWithOrder.practice_id  = orderM.practice_id;
                        patientDetalTreatmentWithOrder.drug         = orderM.drug;
                        patientDetalTreatmentWithOrder.drug_id      = orderM.drug_id;
                        patientDetalTreatmentWithOrder.order_status = orderM.status_drug_order;
                        patientDetalTreatmentWithOrder.patient_id   = patient_details.id.ToString();

                        patientDetailList.Add(patientDetalTreatmentWithOrder);
                    }
                }
            }

            if (patientDetailList.Count != 0)
            {
                Add_New_Patient.ImportPatientDetailsToElastic(patientDetailList, securityTicket.TenantID.ToString());
            }

            if (OrderModelL.Count != 0)
            {
                Add_New_Order.Import_Order_Data_to_ElasticDB(OrderModelL, securityTicket.TenantID.ToString());
            }

            if (cases.Count != 0)
            {
                Add_New_Case.Import_Case_Data_to_ElasticDB(cases, securityTicket.TenantID.ToString());
            }

            return(returnValue);

            #endregion UserCode
        }