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