public static IEnumerable <Settlement_Model> GetAllSettlementsWithNonDownloadedSubmissionReport(Guid practiceId, string index, string doctorId = null) { var serializer = new JsonNetSerializer(); var connection = Elastic_Utils.ElsaticConnection(); if (Elastic_Utils.IfIndexOrTypeExists(index, connection) && Elastic_Utils.IfIndexOrTypeExists(index + "/" + elasticType, connection)) { var query = QueryBuilderSettlement.BuildGetAllSettlementsWithNonDownloadedSubmissionReport(practiceId, doctorId); var result = connection.Post(Commands.Search(index, elasticType).Pretty(), query); return(serializer.ToSearchResult <Settlement_Model>(result).Documents); } return(Enumerable.Empty <Settlement_Model>()); }
public static IEnumerable <Settlement_Model> GetAllSettlementsEligibleForSubmissionReport(Guid practice_id, SessionSecurityTicket securityTicket, string[] case_ids = null) { var TenantID = securityTicket.TenantID.ToString(); var serializer = new JsonNetSerializer(); var connection = Elastic_Utils.ElsaticConnection(); string queryS = string.Empty; if (Elastic_Utils.IfIndexOrTypeExists(TenantID, connection) && Elastic_Utils.IfIndexOrTypeExists(TenantID + "/" + elasticType, connection)) { queryS = QueryBuilderSettlement.BuildGetSettlementEligibleForSubmissionReport(practice_id, case_ids); string result = connection.Post(Commands.Search(TenantID, elasticType).Pretty(), queryS); return(serializer.ToSearchResult <Settlement_Model>(result).Documents); } return(new List <Settlement_Model>()); }
public static Settlement_Model GetSettelementWhereStatus(string patient_id, string localization, string status_code, string case_type, string index_name) { var serializer = new JsonNetSerializer(); var connection = Elastic_Utils.ElsaticConnection(); var query = QueryBuilderSettlement.BuildGetSettlementWhereStatus(patient_id.ToLower(), localization.ToLower(), status_code.ToLower(), case_type); if (Elastic_Utils.IfIndexOrTypeExists(index_name, connection) && Elastic_Utils.IfIndexOrTypeExists(index_name + "/" + elasticType, connection)) { string searchCommand = Commands.Search(index_name, elasticType).Pretty(); string result = connection.Post(searchCommand, query); return(serializer.ToSearchResult <Settlement_Model>(result).Documents.SingleOrDefault()); } return(null); }
public static IEnumerable <Settlement_Model> GetCasesWhereIDPresent(string id, string ordinal, string tenant_id, string case_type = null) { var serializer = new JsonNetSerializer(); var connection = Elastic_Utils.ElsaticConnection(); string query = string.Empty; if (Elastic_Utils.IfIndexOrTypeExists(tenant_id, connection) && Elastic_Utils.IfIndexOrTypeExists(tenant_id + "/" + elasticType, connection)) { query = QueryBuilderSettlement.BuildGetSettlementInErrorCorrectionAndWhereIDPresentQuery(id, ordinal, case_type); string searchCommand_Cases = Commands.Search(tenant_id, elasticType).Pretty(); string result = connection.Post(searchCommand_Cases, query); return(serializer.ToSearchResult <Settlement_Model>(result).Documents); } return(new List <Settlement_Model>()); }
public static IEnumerable <Settlement_Model> Get_Settlement_items(ElasticParameterObject sort_parameter, string practice_id, SessionSecurityTicket securityTicket, List <AftercareHipParameter> rangeParameters = null) { var TenantID = securityTicket.TenantID.ToString(); var serializer = new JsonNetSerializer(); var connection = Elastic_Utils.ElsaticConnection(); if (Elastic_Utils.IfIndexOrTypeExists(TenantID, connection) && Elastic_Utils.IfIndexOrTypeExists(TenantID + "/" + elasticType, connection)) { var sort_by_second_key = ""; var sort_by_third_key = ""; var sort_by_fourth_key = "first_name.lower_case_sort"; var sort_first = ""; switch (sort_parameter.sort_by) { case "surgery_date": sort_by_second_key = "last_name.lower_case_sort"; sort_by_third_key = "first_name.lower_case_sort"; break; case "patient_name": sort_first = "last_name.lower_case_sort"; sort_by_second_key = "first_name.lower_case_sort"; sort_by_third_key = "birthday"; sort_by_fourth_key = "surgery_date"; break; default: sort_by_second_key = "surgery_date"; sort_by_third_key = "last_name.lower_case_sort"; break; } if (sort_parameter.sort_by == "status") { sort_parameter.sort_by = "status.lower_case_sort"; } var queryS = QueryBuilderSettlement.BuildGetSettlementQuery( start_row_index: sort_parameter.start_row_index, page_size: sort_parameter.page_size, sort_by: !String.IsNullOrEmpty(sort_first) ? sort_first : sort_parameter.sort_by, search_params: sort_parameter.search_params, isAsc: sort_parameter.isAsc, practice_id: practice_id, sort_by_second_key: sort_by_second_key, sort_by_third_key: sort_by_third_key, sort_by_fourth_key: sort_by_fourth_key, filter_by: sort_parameter.filter_by, deselected_ids: sort_parameter.deselected_ids != null && sort_parameter.deselected_ids.Any() ? Array.ConvertAll(sort_parameter.deselected_ids.ToArray(), t => t.ToString()) : null, rangeParameters: rangeParameters, hip_name: sort_parameter.hip_name); string searchCommand_Settlement = Commands.Search(TenantID, elasticType).Pretty(); string result = connection.Post(searchCommand_Settlement, queryS); var foundResults_Settlement = serializer.ToSearchResult <Settlement_Model>(result); return(foundResults_Settlement.Documents.Select(item => { switch (sort_parameter.sort_by) { case "surgery_date": item.group_name = item.surgery_date.ToString("MMMM yyyy", new System.Globalization.CultureInfo("de", true)).ToUpper(); break; case "patient_name": item.group_name = item.last_name.Substring(0, 1).ToUpper(); break; case "case_type": item.group_name = item.case_type; break; case "diagnose": item.group_name = item.diagnose; break; case "localization": item.group_name = item.localization; break; case "doctor": item.group_name = item.doctor; break; case "status.lower_case_sort": item.group_name = item.status; break; default: item.group_name = item.surgery_date.ToString("MMMM yyyy", new System.Globalization.CultureInfo("de", true)).ToUpper(); break; } item.is_submit_button_visible = item.status == "FS6"; item.is_cancel_button_visible = item.status != "FS8"; item.surgery_date_string = item.surgery_date.ToString("dd.MM.yyyy"); return item; })); } return(new List <Settlement_Model>()); }
public static long GetNumberOfFSCasesInDoctorsPractice(string practice_id, string status, SessionSecurityTicket securityTicket) { var serializer = new JsonNetSerializer(); var connection = Elastic_Utils.ElsaticConnection(); if (Elastic_Utils.IfIndexOrTypeExists(securityTicket.TenantID.ToString(), connection) && Elastic_Utils.IfIndexOrTypeExists(securityTicket.TenantID.ToString() + "/" + elasticType, connection)) { string result = connection.Post(Commands.Count(securityTicket.TenantID.ToString(), elasticType), QueryBuilderSettlement.BuildGetNumberOfFSCasesInDoctorsPractice(practice_id, status)); return(serializer.ToCountResult(result).count); } return(0); }