protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_CAS_CCtSE_1100 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); Thread.CurrentThread.CurrentCulture = CultureInfo.GetCultureInfo("de-DE"); Thread.CurrentThread.CurrentUICulture = CultureInfo.GetCultureInfo("de-DE"); //Get statuses from Resources var FS1 = Properties.Resources.FS1; var FS2 = Properties.Resources.FS2; var FS3 = Properties.Resources.FS3; var FS4 = Properties.Resources.FS4; var FS5 = Properties.Resources.FS5; var FS6 = Properties.Resources.FS6; var FS7 = Properties.Resources.FS7; var FS8 = Properties.Resources.FS8; var FS9 = Properties.Resources.FS9; var FS10 = Properties.Resources.FS10; var FS11 = Properties.Resources.FS11; Guid treatment_performed_action_type_id = Guid.Empty; var treatment_performed_action_type = ORM_HEC_ACT_ActionType.Query.Search(Connection, Transaction, new ORM_HEC_ACT_ActionType.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, GlobalPropertyMatchingID = "mm.docconect.doc.app.performed.action.treatment" }).SingleOrDefault(); if (treatment_performed_action_type == null) { treatment_performed_action_type = new ORM_HEC_ACT_ActionType(); treatment_performed_action_type.GlobalPropertyMatchingID = "mm.docconect.doc.app.performed.action.treatment"; treatment_performed_action_type.Creation_Timestamp = DateTime.Now; treatment_performed_action_type.Modification_Timestamp = DateTime.Now; treatment_performed_action_type.Tenant_RefID = securityTicket.TenantID; treatment_performed_action_type.Save(Connection, Transaction); treatment_performed_action_type_id = treatment_performed_action_type.HEC_ACT_ActionTypeID; } else { treatment_performed_action_type_id = treatment_performed_action_type.HEC_ACT_ActionTypeID; } List <Submitted_Case_Model> allCases = Get_All_Cases_With_Custom_Status.Get_All_Submited_Cases_With_Custom_Status("FS2", securityTicket); List <Submitted_Case_Model> allCases_FS11 = Get_All_Cases_With_Custom_Status.Get_All_Submited_Cases_With_Custom_Status("FS11", securityTicket); List <Submitted_Case_Model> newCaseList = new List <Submitted_Case_Model>(); List <Settlement_Model> settlements = new List <Settlement_Model>(); List <PatientDetailViewModel> patientDetailList = new List <PatientDetailViewModel>(); List <DateTime> OldTransmitionDateList = new List <DateTime>(); Dictionary <Guid, int> consentValidToCache = new Dictionary <Guid, int>(); //List<Guid> casesToChange = new List<Guid>(); //List<string> typeList = new List<string>(); List <NegativeResponseModel> NegativeResponseList = new List <NegativeResponseModel>(); var preexaminationsCache = cls_Get_Patient_Preexaminations_on_Tenant.Invoke(Connection, Transaction, securityTicket).Result.GroupBy(t => t.PatientID).ToDictionary(t => t.Key, t => t.GroupBy(c => c.Localization).ToDictionary(d => d.Key, d => d)); DateTime DateForElastic = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local); var casesForReport = cls_Get_Cases_For_Report.Invoke(Connection, Transaction, new P_CAS_GCFR_0910() { Status = 2 }, securityTicket).Result; var casesForReport_FS11 = cls_Get_Cases_For_Report.Invoke(Connection, Transaction, new P_CAS_GCFR_0910() { Status = 11 }, securityTicket).Result; Dictionary <string, string> serviceFeeValueCache = new Dictionary <string, string>(); List <CaseForReportModel> caseModelList = new List <CaseForReportModel>(); foreach (var item in Parameter.CasesToBeChanged) { try { var errorCase = casesForReport.SingleOrDefault(i => int.Parse(i.PositionNumber) == int.Parse(item.bill_number)); bool shouldChangeToFS8 = false; if (errorCase == null) { errorCase = casesForReport_FS11.SingleOrDefault(i => int.Parse(i.PositionNumber) == int.Parse(item.bill_number)); shouldChangeToFS8 = true; } var management_fee_value = "-"; if (!string.IsNullOrEmpty(errorCase.BillingCode)) { if (!serviceFeeValueCache.ContainsKey(errorCase.BillingCode)) { var service_fee_value = cls_Get_ServiceFeeValue_for_BillingCode.Invoke(Connection, Transaction, new P_CAS_GSFVfBC_1721() { BillingCode = errorCase.BillingCode }, securityTicket).Result; if (service_fee_value != null) { serviceFeeValueCache.Add(errorCase.BillingCode, service_fee_value.service_fee); } } management_fee_value = serviceFeeValueCache[errorCase.BillingCode]; } var negativeTransmitionQuery = new ORM_BIL_BillPosition_TransmitionStatus.Query(); negativeTransmitionQuery.Tenant_RefID = securityTicket.TenantID; negativeTransmitionQuery.IsDeleted = false; negativeTransmitionQuery.BillPosition_RefID = errorCase.StatusID; var negativeTransmition = ORM_BIL_BillPosition_TransmitionStatus.Query.Search(Connection, Transaction, negativeTransmitionQuery).ToList(); var caseStatusQuery = new ORM_BIL_BillPosition_TransmitionStatus.Query(); caseStatusQuery.Tenant_RefID = securityTicket.TenantID; caseStatusQuery.IsDeleted = false; caseStatusQuery.IsActive = true; caseStatusQuery.BIL_BillPosition_TransmitionStatusID = errorCase.StatusID; var caseStatusOld = ORM_BIL_BillPosition_TransmitionStatus.Query.Search(Connection, Transaction, caseStatusQuery).SingleOrDefault(); if (caseStatusOld == null) { throw new Exception("Transmition status not found for id: " + errorCase.StatusID); } OldTransmitionDateList.Add(caseStatusOld.TransmittedOnDate); caseStatusOld.IsActive = false; caseStatusOld.Save(Connection, Transaction); var caseStatus = new ORM_BIL_BillPosition_TransmitionStatus(); caseStatus.IsDeleted = false; caseStatus.Creation_Timestamp = DateTime.Now; caseStatus.Modification_Timestamp = DateTime.Now; caseStatus.Tenant_RefID = securityTicket.TenantID; caseStatus.IsActive = true; caseStatus.PrimaryComment = item.error_message; caseStatus.BIL_BillPosition_TransmitionStatusID = Guid.NewGuid(); caseStatus.BillPosition_RefID = caseStatusOld.BillPosition_RefID; caseStatus.TransmitionCode = 5; caseStatus.TransmittedOnDate = DateTime.Now;// should we use from edifact? caseStatus.TransmitionStatusKey = caseStatusOld.TransmitionStatusKey; caseStatus.Save(Connection, Transaction); if (shouldChangeToFS8) { caseStatus.IsActive = false; caseStatus.Save(Connection, Transaction); var caseStatus2 = new ORM_BIL_BillPosition_TransmitionStatus(); caseStatus2.IsDeleted = false; caseStatus2.Creation_Timestamp = DateTime.Now; caseStatus2.Modification_Timestamp = DateTime.Now; caseStatus2.Tenant_RefID = securityTicket.TenantID; caseStatus2.IsActive = true; caseStatus2.PrimaryComment = item.error_message; caseStatus2.BIL_BillPosition_TransmitionStatusID = Guid.NewGuid(); caseStatus2.BillPosition_RefID = caseStatusOld.BillPosition_RefID; caseStatus2.TransmitionCode = 8; caseStatus2.TransmittedOnDate = DateTime.Now;// should we use from edifact? caseStatus2.TransmitionStatusKey = caseStatusOld.TransmitionStatusKey; caseStatus2.Save(Connection, Transaction); } Guid caseID = errorCase.CaseID; NegativeResponseModel negativeResponse = new NegativeResponseModel(); negativeResponse.caseID = caseID; //casesToChange.Add(caseID); if (caseStatusOld.TransmitionStatusKey == "aftercare") { negativeResponse.plannedActionID = errorCase.IsAftercareID; negativeResponse.type = "ac"; } //typeList.Add("ac"); else if (caseStatusOld.TransmitionStatusKey == "treatment") { negativeResponse.plannedActionID = errorCase.IsTreatmentID; negativeResponse.type = "op"; } else { negativeResponse.plannedActionID = errorCase.IsTreatmentID; negativeResponse.type = caseStatusOld.TransmitionStatusKey; } //typeList.Add("op"); NegativeResponseList.Add(negativeResponse); P_PA_GPDfPID_1124 patientData = cls_Get_Patient_Details_for_PatientID.Invoke(Connection, Transaction, new P_P_PA_GPDfPID_1124() { PatientID = errorCase.Patient_RefID }, securityTicket).Result; #region Report data CaseForReportModel caseModel = new CaseForReportModel(); caseModel.HIP = patientData.health_insurance_provider; caseModel.ContractID = patientData.contractID; caseModel.HIP_IK = patientData.HealthInsurance_IKNumber; caseModel.PatientInsuranceNumber = patientData.insurance_id; caseModel.PatientGender = patientData.gender; caseModel.PatientStatusNumber = patientData.insurance_status; caseModel.PatientFirstName = patientData.patient_first_name; caseModel.PatientLastName = patientData.patient_last_name; caseModel.PatientBirthday = patientData.birthday; try { if (!consentValidToCache.ContainsKey(patientData.contractID)) { double DurationOfParticipationConsentinMonths = ORM_CMN_CTR_Contract_Parameter.Query.Search(Connection, Transaction, new ORM_CMN_CTR_Contract_Parameter.Query() { IsDeleted = false, Tenant_RefID = securityTicket.TenantID, ParameterName = "Duration of participation consent – Month", Contract_RefID = patientData.contractID }).SingleOrDefault().IfNumericValue_Value; consentValidToCache.Add(patientData.contractID, Convert.ToInt32(DurationOfParticipationConsentinMonths)); } DateTime participationConsentValidTo = patientData.ParticipationConsent.OrderBy(dt => dt.participation_consent_issue_date).FirstOrDefault().participation_consent_issue_date.AddMonths(consentValidToCache[patientData.contractID]); caseModel.PatientParticipationConsentValidUntil = participationConsentValidTo; } catch (Exception ex) { caseModel.PatientParticipationConsentValidUntil = DateTime.MinValue; } caseModel.CaseNumber = Convert.ToInt32(errorCase.CaseNumber); caseModel.CaseType = errorCase.CodeName; try { caseModel.Drug = cls_Get_Drug_Details_for_DrugID.Invoke(Connection, Transaction, new P_CAS_GDDfDID_1614() { DrugID = errorCase.DrugID }, securityTicket).Result.drug_name; } catch (Exception ex) { caseModel.Drug = "-"; } caseModel.Diagnose = errorCase.IM_PotentialDiagnosis_Name; caseModel.DiagnoseCode = errorCase.IM_PotentialDiagnosis_Code; caseModel.Localization = errorCase.IM_PotentialDiagnosisLocalization_Code; P_CAS_GTCfPIDaDIDaLC_1008 parameterDia = new P_CAS_GTCfPIDaDIDaLC_1008(); parameterDia.PatientID = errorCase.Patient_RefID; parameterDia.DiagnoseID = errorCase.CodeForType == "treatment" || errorCase.CodeForType == "preexamination" ? errorCase.TreatmentPerformedDiganoseID : errorCase.AftercasePerformedDiagnoseID; parameterDia.LocalizationCode = errorCase.IM_PotentialDiagnosisLocalization_Code; parameterDia.PerformedDate = errorCase.CodeForType == "treatment" || errorCase.CodeForType == "preexamination" ? errorCase.TreatmentDate : errorCase.AfterCareDate; parameterDia.ActionTypeID = treatment_performed_action_type_id; if (errorCase.CodeForType == "preexamination") { if (preexaminationsCache.ContainsKey(errorCase.Patient_RefID) && preexaminationsCache[errorCase.Patient_RefID].ContainsKey(errorCase.IM_PotentialDiagnosisLocalization_Code)) { caseModel.TreatmentCount = preexaminationsCache[errorCase.Patient_RefID][errorCase.IM_PotentialDiagnosisLocalization_Code].Count(c => c.PreexaminationDate.Date <= errorCase.TreatmentDate.Date); } } else { caseModel.TreatmentCount = cls_Get_Treatment_Count_for_PatientID_And_DiagnoseID_and_LocalizationCode.Invoke(Connection, Transaction, parameterDia, securityTicket).Result.treatment_count; } caseModel.GPOS = errorCase.BillingCode; caseModel.TreatmentDay = errorCase.CodeForType == "treatment" || errorCase.CodeForType == "preexamination" ? errorCase.TreatmentDate : errorCase.AfterCareDate; if (errorCase.CodeForType == "treatment") { caseModel.SurgeryDateForThisCase = errorCase.TreatmentDate; } else if (errorCase.CodeForType == "preexamination") { caseModel.SurgeryDateForThisCase = DateTime.MinValue; } else { CAS_GTdfA_0936 Trdate = cls_Get_Treatment_Date_for_Aftercare.Invoke(Connection, Transaction, new P_CAS_GTdfA_0936() { CaseID = errorCase.CaseID }, securityTicket).Result; if (Trdate != null) { caseModel.SurgeryDateForThisCase = Trdate.TreatmentDate; } } switch (patientData.gender) { case 0: caseModel.PatientSalutation = "Herr"; break; case 1: caseModel.PatientSalutation = "Frau"; break; default: caseModel.PatientSalutation = "-"; break; } if (!shouldChangeToFS8) { caseModel.CurrentStatus = FS5; } else { caseModel.CurrentStatus = FS8; } caseModel.DateOfCurrentStatus = DateTime.Now; if (!shouldChangeToFS8) { caseModel.PreCurrentStatus = FS2; } else { caseModel.PreCurrentStatus = FS11; } caseModel.DateOfPreCurrentStatus = caseStatusOld.TransmittedOnDate; caseModel.InvoiceNumberForTheHIP = Convert.ToInt32(errorCase.PositionNumber); caseModel.AmountForThisGPOS = errorCase.NumberForPayment; caseModel.NumberOfNegativeTry = negativeTransmition.Count.ToString(); caseModel.DateOfTheSubmissionToTheHIP = Parameter.transferToHIPDate; caseModel.FeedBackOfTheHIP = item.transmition_date; caseModel.PaymentDate = DateTime.MinValue; caseModel.DrugOrdered = (errorCase.orderId != Guid.Empty && int.Parse(errorCase.orderStatusCode) != 6) ? "Ja" : "Nein"; caseModel.NoFee = errorCase.IsPatientFeeWaived ? "Ja" : "Nein"; caseModel.InvoiceToPractice = errorCase.SendInvoiceToPractice ? "Ja" : "Nein"; caseModel.OnlyLabelRequired = errorCase.isLabelOnly ? "Ja" : "Nein"; var gposAssignmentCount = cls_Get_Gpos_AssignmentCount_for_GposID.Invoke(Connection, Transaction, new P_CAS_GGPOSACfGPOSID_1252() { GposID = errorCase.GposID }, securityTicket).Result; if (gposAssignmentCount.AssignmentCount != 0) { var is_management_fee_waived = cls_Get_Management_Fee_Property_Value_for_CaseID_and_GposID.Invoke(Connection, Transaction, new P_CAS_GMFPVfCIDaGPOSTID_1749() { CaseID = errorCase.CaseID, GposID = errorCase.GposID }, securityTicket).Result; caseModel.ManagementFee = is_management_fee_waived == null ? "-" : is_management_fee_waived.PropertyValue == "waived" ? "-" : management_fee_value; } else { caseModel.ManagementFee = "-"; } Guid DocID = errorCase.CodeForType == "treatment" || errorCase.CodeForType == "preexamination" ? errorCase.SurgeryDoctor : errorCase.AfterCareDoctor; DO_GDDfDID_0823 doctorData = cls_Get_Doctor_Details_for_DoctorID.Invoke(Connection, Transaction, new P_DO_GDDfDID_0823() { DoctorID = DocID }, securityTicket).Result.First(); caseModel.BSNR = doctorData.BSNR; caseModel.PracticeName = doctorData.practice; caseModel.DocName = doctorData.first_name + " " + doctorData.last_name; caseModel.LANR = doctorData.lanr; caseModel.BankAccountHolder = string.IsNullOrEmpty(doctorData.OwnerText) ? "-" : doctorData.OwnerText; caseModel.BankName = doctorData.BankName == null ? "-" : doctorData.BankName; caseModel.IBAN = doctorData.IBAN == null ? "-" : doctorData.IBAN; caseModel.BIC = doctorData.BICCode == null ? "-" : doctorData.BICCode; caseModelList.Add(caseModel); #endregion } catch (Exception ex) { LogUtils.Logger.LogInfo(new LogUtils.LogEntry(ex.StackTrace)); throw new Exception("Bill position: " + item.bill_number, ex); } } //Change in Elastic--------------------------------------------------------------------------------- for (int k = 0; k < NegativeResponseList.Count; k++) { var errorCase = allCases.SingleOrDefault(i => i.case_id == NegativeResponseList[k].caseID.ToString() && i.type == NegativeResponseList[k].type); if (errorCase == null) { errorCase = allCases_FS11.SingleOrDefault(i => i.case_id == NegativeResponseList[k].caseID.ToString() && i.type == NegativeResponseList[k].type); if (errorCase == null) { continue; } errorCase.status = "FS8"; //Change settlement from Stornierung anhängig to storniert Settlement_Model settlement = Get_Settlement.GetSettlementForID(NegativeResponseList[k].plannedActionID.ToString(), securityTicket); settlement.status = "FS8"; settlements.Add(settlement); PatientDetailViewModel patient_detail = Retrieve_Patients.Get_PatientDetaiForID(settlement.id, securityTicket); if (patient_detail != null) { patient_detail.status = "FS8"; patientDetailList.Add(patient_detail); } } else { errorCase.status = "FS5"; } errorCase.status_date = DateTime.Now; errorCase.status_date_string = DateTime.Now.ToString("dd.MM.yyyy"); newCaseList.Add(errorCase); } if (settlements.Count > 0) { Add_new_Settlement.Import_Settlement_to_ElasticDB(settlements, securityTicket.TenantID.ToString()); } if (patientDetailList.Count > 0) { Add_New_Patient.ImportPatientDetailsToElastic(patientDetailList, securityTicket.TenantID.ToString()); } if (newCaseList.Count > 0) { Add_New_Submitted_Case.Import_Submitted_Case_Data_to_ElasticDB(newCaseList, securityTicket.TenantID.ToString()); List <Documents> documentList = new List <Documents>(); string hipID = Parameter.hipId; var healthInsuranceCompanyQuery = new ORM_HEC_HIS_HealthInsurance_Company.Query(); healthInsuranceCompanyQuery.IsDeleted = false; healthInsuranceCompanyQuery.Tenant_RefID = securityTicket.TenantID; healthInsuranceCompanyQuery.HealthInsurance_IKNumber = hipID; var helathInsurance = ORM_HEC_HIS_HealthInsurance_Company.Query.Search(Connection, Transaction, healthInsuranceCompanyQuery).Single(); var businessParticipantQuery = new ORM_CMN_BPT_BusinessParticipant.Query(); businessParticipantQuery.CMN_BPT_BusinessParticipantID = helathInsurance.CMN_BPT_BusinessParticipant_RefID; businessParticipantQuery.IsDeleted = false; businessParticipantQuery.Tenant_RefID = securityTicket.TenantID; var businessParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, businessParticipantQuery).Single(); //Save Edifact string edi_path = System.IO.Path.GetTempPath() + Parameter.edi_name; System.IO.File.WriteAllText(edi_path, Parameter.edi_message); List <string> files = new List <string>(); files.Add(edi_path); string zipPath = System.IO.Path.GetTempPath() + Parameter.edi_name + ".zip"; ZipFIlesUtils.AddToArchive(zipPath, files); string earliestDate = OldTransmitionDateList.OrderBy(d => d).First().ToString("dd.MM.yyyy"); string lastDate = OldTransmitionDateList.OrderBy(d => d).Last().ToString("dd.MM.yyyy"); Documents documentEdifact = new Documents(); documentEdifact.documentName = "Import von " + earliestDate + " - " + lastDate; documentEdifact.documentOutputLocation = zipPath; documentEdifact.receiver = businessParticipant.DisplayName; documentEdifact.mimeType = "Application/Edifact_Error"; documentList.Add(documentEdifact); Documents documentExcel = new Documents(); documentExcel.documentName = "ExcelReport" + DateTime.Now.ToString("dd.MM.yyyy_HH.mm"); documentExcel.documentOutputLocation = GenerateReportCases.CreateCaseXlsReport(caseModelList, documentExcel.documentName); documentExcel.mimeType = UtilMethods.GetMimeType(documentExcel.documentOutputLocation); documentExcel.receiver = "MM"; documentList.Add(documentExcel); foreach (var item in documentList) { MemoryStream ms = new MemoryStream(File.ReadAllBytes(item.documentOutputLocation)); byte[] byteArrayFile = ms.ToArray(); var _providerFactory = ProviderFactory.Instance; var documentProvider = _providerFactory.CreateDocumentServiceProvider(); var uploadedFrom = HttpContext.Current.Request.UserHostAddress; Guid documentID = documentProvider.UploadDocument(byteArrayFile, item.documentOutputLocation, securityTicket.SessionTicket, uploadedFrom); string downloadURL = documentProvider.GenerateImageThumbnailLink(documentID, securityTicket.SessionTicket, false, 200); P_ARCH_UD_1326 parameterDoc = new P_ARCH_UD_1326(); parameterDoc.DocumentID = documentID; parameterDoc.Mime = item.mimeType; parameterDoc.DocumentName = item.documentName; parameterDoc.DocumentDate = DateForElastic; parameterDoc.Receiver = item.receiver; parameterDoc.ContractID = item.ContractID; if (parameterDoc.Mime == "Application/Edifact_Error") { parameterDoc.Description = parameterDoc.DocumentName; } else { parameterDoc.Description = "KV Fehler"; } cls_Upload_Report.Invoke(Connection, Transaction, parameterDoc, securityTicket); } } return(returnValue); #endregion UserCode }
protected static FR_CAS_CCS_1516 Execute(DbConnection Connection, DbTransaction Transaction, P_CAS_CCS_1516 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode #region Thread cultrue Thread.CurrentThread.CurrentCulture = CultureInfo.GetCultureInfo("de-DE"); Thread.CurrentThread.CurrentUICulture = CultureInfo.GetCultureInfo("de-DE"); var germanCulture = new CultureInfo("de-de"); #endregion #region Local variables var returnValue = new FR_CAS_CCS_1516(); returnValue.Result = new CAS_CCS_1516(); var settlements = new List <Settlement_Model>(); var patientDetailList = new List <PatientDetailViewModel>(); var cases_to_submit = new List <Submitted_Case_Model>(); var documents = new List <Documents>(); var statusChangedOnDate = Parameter.StatusChangedOnDate == DateTime.MinValue ? DateTime.Now : Parameter.StatusChangedOnDate; var DateForElastic = DateTime.Now; var cases = cls_Generate_Report.Invoke(Connection, Transaction, new P_CAS_GR_1608() { statuses = Parameter.StatusFrom == 2 ? new int[] { 2, 11 } : Parameter.StatusFrom == 4 ? new int[] { 4, 8, 10 } : new int[] { Convert.ToInt32(Parameter.StatusFrom) }, position_numbers = Parameter.PositionNumbers, updateCasesSubmittedBeforeDate = Parameter.UpdatedCasesSubmittedBeforeDate }, securityTicket).Result.cases; var earliestFsStatusDate = DateTime.MinValue; var latestFsStatusDate = DateTime.MinValue; #endregion #region Pre-fetched data // todo: write queries for ids! var activeFsStatuses = ORM_BIL_BillPosition_TransmitionStatus.Query.Search(Connection, Transaction, new ORM_BIL_BillPosition_TransmitionStatus.Query() { IsDeleted = false, IsActive = true, Tenant_RefID = securityTicket.TenantID, TransmitionCode = Convert.ToInt32(Parameter.StatusFrom) }).ToDictionary(t => t.BIL_BillPosition_TransmitionStatusID, t => t); var casesToUpdate = ORM_HEC_CAS_Case.Query.Search(Connection, Transaction, new ORM_HEC_CAS_Case.Query() { IsDeleted = false, Tenant_RefID = securityTicket.TenantID }).ToDictionary(t => t.HEC_CAS_CaseID, t => t); #endregion foreach (var reportCase in cases) { if (Parameter.StatusTo == 7 && (reportCase.CurrentFsStatusCode == 8 || reportCase.CurrentFsStatusCode == 11 || reportCase.CurrentFsStatusCode == 17)) { continue; } #region Patient age calculation DateTime today = DateTime.Today; int patientAge = today.Year - reportCase.PatientBirthday.Year; if (reportCase.PatientBirthday > today.AddYears(-patientAge)) { patientAge--; } #endregion #region FS status update var caseActiveFsStatus = activeFsStatuses.ContainsKey(reportCase.TransmitionStatusID) ? activeFsStatuses[reportCase.TransmitionStatusID] : ORM_BIL_BillPosition_TransmitionStatus.Query.Search(Connection, Transaction, new ORM_BIL_BillPosition_TransmitionStatus.Query() { BIL_BillPosition_TransmitionStatusID = reportCase.TransmitionStatusID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }).Single(); var responseFromHip = ""; if (Parameter.StatusTo == 5) { var edifact = new EDIFACT(); var edifactMessage = Parameter.EdifactMessage; var parser = new Parser(ref edifactMessage); EDIMessage.segmentArray = parser.GetSegments(); var parsedEdifact = EDIMessage.SegmentsToParsedEdifact(); var message = parsedEdifact.transmitionMessages.Single(t => Int32.Parse(t.Rgi.Segment5.Value.Split('K').Last()) == reportCase.InvoiceNumberForTheHIP); responseFromHip = String.Join("; ", message.Fhl.Select(t => t.Segment4.Value)); } if (!Parameter.AreCasesPaymentAndStatus) { if (caseActiveFsStatus.TransmittedOnDate.Date > latestFsStatusDate) { latestFsStatusDate = caseActiveFsStatus.TransmittedOnDate; } if (earliestFsStatusDate < caseActiveFsStatus.TransmittedOnDate.Date) { earliestFsStatusDate = caseActiveFsStatus.TransmittedOnDate; } caseActiveFsStatus.Modification_Timestamp = DateTime.Now; caseActiveFsStatus.IsActive = false; caseActiveFsStatus.Save(Connection, Transaction); var NewStatusForCase = new ORM_BIL_BillPosition_TransmitionStatus(); NewStatusForCase.Modification_Timestamp = DateTime.Now; NewStatusForCase.Tenant_RefID = securityTicket.TenantID; NewStatusForCase.BillPosition_RefID = caseActiveFsStatus.BillPosition_RefID; NewStatusForCase.TransmitionStatusKey = caseActiveFsStatus.TransmitionStatusKey; NewStatusForCase.TransmittedOnDate = statusChangedOnDate; NewStatusForCase.PrimaryComment = responseFromHip; NewStatusForCase.TransmitionCode = Convert.ToInt32(Parameter.StatusTo); NewStatusForCase.TransmissionDataXML = cls_Create_XML_for_Immutable_Fields.Invoke(Connection, Transaction, new P_CAS_CXFIF_0830() { DiagnosisCatalogCode = reportCase.DiagnoseCode, DiagnosisCatalogName = "ICD-10", IFPerformedMedicalPracticeName = reportCase.PracticeName, IFPerformedResponsibleBPFullName = reportCase.DocName, Localization = reportCase.Localization, PatientBirthDate = reportCase.PatientBirthday.ToString("dd.MM.yyyy"), PatientFirstName = reportCase.PatientFirstName, PatientGender = reportCase.PatientGender.ToString(), PatientAge = patientAge.ToString() }, securityTicket).Result.XmlFileString; if (caseActiveFsStatus.TransmitionCode == 11) { var cancellingStatus = new ORM_BIL_BillPosition_TransmitionStatus(); cancellingStatus.TransmitionCode = 8; cancellingStatus.BillPosition_RefID = caseActiveFsStatus.BillPosition_RefID; cancellingStatus.IsActive = true; cancellingStatus.Modification_Timestamp = DateTime.Now; cancellingStatus.Tenant_RefID = securityTicket.TenantID; cancellingStatus.TransmittedOnDate = statusChangedOnDate; cancellingStatus.TransmitionStatusKey = caseActiveFsStatus.TransmitionStatusKey; cancellingStatus.TransmissionDataXML = NewStatusForCase.TransmissionDataXML; cancellingStatus.Save(Connection, Transaction); } else { NewStatusForCase.IsActive = true; } NewStatusForCase.Save(Connection, Transaction); #region Elastic updates var elasticId = reportCase.UniqueID.ToString(); try { var submitted_case_model_elastic = Get_Submitted_Cases.GetSubmittedCaseforSubmittedCaseID(elasticId, securityTicket); var settlement = Get_Settlement.GetSettlementForID(elasticId, securityTicket); var patient_detail = Retrieve_Patients.Get_PatientDetaiForID(elasticId, securityTicket); var newStatus = ""; if (caseActiveFsStatus.TransmitionCode == 11) { newStatus = "FS8"; } else { newStatus = "FS" + Parameter.StatusTo; } submitted_case_model_elastic.status = newStatus; submitted_case_model_elastic.status_date = statusChangedOnDate; submitted_case_model_elastic.status_date_string = statusChangedOnDate.ToString("dd.MM.yyyy"); settlement.status = newStatus; settlement.status_date = statusChangedOnDate; patient_detail.status = newStatus; cases_to_submit.Add(submitted_case_model_elastic); settlements.Add(settlement); patientDetailList.Add(patient_detail); } catch { } #endregion } #endregion #region Immutable fields update var caseToUpdate = casesToUpdate[reportCase.CaseID]; caseToUpdate.Modification_Timestamp = DateTime.Now; caseToUpdate.Patient_BirthDate = reportCase.PatientBirthday; caseToUpdate.Patient_FirstName = reportCase.PatientFirstName; caseToUpdate.Patient_LastName = reportCase.PatientLastName; caseToUpdate.Patient_Gender = reportCase.PatientGender; caseToUpdate.Patient_Age = patientAge; caseToUpdate.Save(Connection, Transaction); #endregion } if (cases.Any()) { #region Edifact generation if (Parameter.StatusTo == 2) { var contracts = cases.GroupBy(i => i.ContractID).ToDictionary(t => t.Key, t => t.ToList()); var isTestData = false; try { isTestData = bool.Parse(WebConfigurationManager.AppSettings["edifact-generate-test-data"]); } catch { } var cmnContracts = ORM_CMN_CTR_Contract.Query.Search(Connection, Transaction, new ORM_CMN_CTR_Contract.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false }); foreach (var contract in contracts) { var contractID = contract.Key; var contractParameters = ORM_CMN_CTR_Contract_Parameter.Query.Search(Connection, Transaction, new ORM_CMN_CTR_Contract_Parameter.Query() { Contract_RefID = contractID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }); var contractCharacteristicIDParameter = contractParameters.SingleOrDefault(t => t.ParameterName == EContractParameter.CharacteristicID.Value()); var edifactType = contractParameters.SingleOrDefault(t => t.ParameterName == EContractParameter.EdifactType.Value()); var encryptEdifactParameter = contractParameters.SingleOrDefault(t => t.ParameterName == EContractParameter.EncryptEdifact.Value()); var nextEdifactNumberParameter = contractParameters.SingleOrDefault(t => t.ParameterName == EContractParameter.NextEdifactNumber.Value()); var contractType = contractParameters.SingleOrDefault(t => t.ParameterName == EContractParameter.ContractType.Value()); var messageType = contractParameters.SingleOrDefault(t => t.ParameterName == EContractParameter.MessageType.Value()); var mergeForAllHips = contractParameters.SingleOrDefault(t => t.ParameterName == EContractParameter.MergeForAllHips.Value()); var useKForCorrection = contractParameters.SingleOrDefault(t => t.ParameterName == EContractParameter.UseKForCorrection.Value()); var IKNumber = contractParameters.SingleOrDefault(t => t.ParameterName == EContractParameter.IKNumber.Value()); var IKNumberValue = IKNumber != null ? IKNumber.IfStringValue_Value : contract.Value.First() != null?contract.Value.First().HIP_IK : ""; var mergeForAllHipsValue = mergeForAllHips != null ? mergeForAllHips.IfBooleanValue_Value : false; var useKForVorrectionValue = useKForCorrection != null ? useKForCorrection.IfBooleanValue_Value : true; var contactTypeValue = contractType != null ? contractType.IfStringValue_Value : "7"; var hipNameForMergedEdifact = mergeForAllHipsValue ? cls_Get_HIP_Name_for_HIP_IK_Number.Invoke(Connection, Transaction, new P_CAS_GHIPIKfHIPIKN_1207 { HIPIKNumber = IKNumberValue }, securityTicket).Result.Name : ""; var encryptEdifact = false; if (encryptEdifactParameter != null) { encryptEdifact = encryptEdifactParameter.IfBooleanValue_Value; } var contractCharacteristicID = "000000"; if (contractCharacteristicIDParameter != null) { contractCharacteristicID = contractCharacteristicIDParameter.IfStringValue_Value; } var controldocumentExcel = cls_Get_Number_of_Edifacts.Invoke(Connection, Transaction, new P_ARCH_GNoE_0910 { ContractID = contractID.ToString() }, securityTicket).Result; uint controlReference = 1; if (controldocumentExcel != null && (uint)controldocumentExcel.numberOfEdifacts > 0 && nextEdifactNumberParameter != null && nextEdifactNumberParameter.IfNumericValue_Value > 0) { controlReference = nextEdifactNumberParameter != null?Convert.ToUInt32(nextEdifactNumberParameter.IfNumericValue_Value) : 1; } var casesINContract = contract.Value; var hips = mergeForAllHipsValue ? new Dictionary <string, List <CaseForReportModel> >() { { "", casesINContract } } : casesINContract.GroupBy(i => i.HIP_IK).ToDictionary(t => t.Key, t => t.ToList()); foreach (var hip in hips) { var casesWithHIP_IK = hip.Value; var baseHipData = casesWithHIP_IK.First(); var mmIkNumber = Resources.InterchangeSenderID; var minTreatmentDate = baseHipData.TreatmentDay; var maxTreatmentDate = baseHipData.TreatmentDay; var ikNumberForHIP = mergeForAllHipsValue ? IKNumberValue : baseHipData.HIP_IK; var edi = new EDIFACT(); edi.mmIkNumber = mmIkNumber; edi.hipIkNumber = ikNumberForHIP; foreach (var _case in casesWithHIP_IK) { if (_case.TreatmentDay != DateTime.MinValue && _case.TreatmentDay < minTreatmentDate) { minTreatmentDate = _case.TreatmentDay; } if (_case.TreatmentDay != DateTime.MaxValue && _case.TreatmentDay > maxTreatmentDate) { maxTreatmentDate = _case.TreatmentDay; } } edi.Una = "UNA:+,? '\n"; var edifactVersion = 3; if (edifactType != null && edifactType.IfStringValue_Value == "4") { edifactVersion = 4; } edi.FileName = String.Format("{0}DRC0{1}", isTestData ? "T" : "E", controlReference.ToString("D3")); #region UNB edi.Unb.Segment1 = "UNOC"; edi.Unb.Segment2 = "3"; edi.Unb.Segment3 = mmIkNumber; edi.Unb.Segment4 = ikNumberForHIP; // todo: check if this date is always subtracted edi.Unb.Segment5 = DateTime.Now.AddDays(-1).ToString("yyyyMMdd"); edi.Unb.Segment6 = DateTime.Now.ToString("HHmm"); edi.Unb.Segment7 = controlReference.ToString("D5"); edi.Unb.Segment8 = String.Format("{0}DRC0{1}{2}", isTestData ? "T" : "E", controlReference.ToString("D2"), DateTime.Now.ToString("yyMM")); if (isTestData && edifactVersion == 4) { edi.Unb.Segment9 = "1"; } #endregion var referenceNumber = 1; foreach (var caseModel in casesWithHIP_IK) { var hipIkNumber = mergeForAllHipsValue ? IKNumberValue : caseModel.HIP_IK; var message = new TransmitionMessage(); var gender = "0"; var currentMessageNumber = String.Format("99{0}", referenceNumber.ToString("D8")); #region Gender switch (caseModel.PatientGender) { case 0: gender = "2"; break; case 1: gender = "1"; break; case 2: gender = "3"; break; } #endregion #region Version independent #region UNH message.Unh.Segment1 = currentMessageNumber; message.Unh.Segment2 = messageType != null ? messageType.IfStringValue_Value : "DIR73C"; message.Unh.Segment3 = edifactVersion.ToString(); message.Unh.Segment4 = "0"; message.Unh.Segment5 = "DR"; #endregion #region IVK message.Ivk.Segment1 = useKForVorrectionValue ? "10" : Convert.ToInt32(caseModel.NumberOfNegativeTry) > 0 ? "30" : "10"; message.Ivk.Segment2 = "01"; message.Ivk.Segment3 = mmIkNumber; message.Ivk.Segment4 = hipIkNumber; #endregion #region IBH message.Ibh.Segment1 = caseModel.LANR; message.Ibh.Segment2 = caseModel.BSNR; #endregion #region INF message.Inf.Segment1 = contractCharacteristicID; message.Inf.Segment2 = ""; message.Inf.Segment3 = "0"; message.Inf.Segment4 = contactTypeValue; #endregion #region INV message.Inv.Segment4 = caseModel.PatientInsuranceNumber; message.Inv.Segment5 = hipIkNumber; message.Inv.Segment6 = caseModel.PatientLastName; message.Inv.Segment7 = caseModel.PatientFirstName; message.Inv.Segment8 = caseModel.PatientBirthday.ToString("yyyyMMdd"); message.Inv.Segment9 = gender; #endregion #region DIA message.Dia.Segment1 = caseModel.DiagnoseCode; message.Dia.Segment2 = "G"; message.Dia.Segment3 = caseModel.Localization; #endregion #region ABR message.Abr.Segment1 = ""; message.Abr.Segment2 = caseModel.GPOS; message.Abr.Segment3 = ""; message.Abr.Segment4 = ""; message.Abr.Segment5 = "1"; message.Abr.Segment6 = caseModel.AmountForThisGPOS.ToString("F", germanCulture); message.Abr.Segment7 = ""; message.Abr.Segment8 = ""; message.Abr.Segment9 = ""; message.Abr.Segment10 = ""; message.Abr.Segment11 = caseModel.TreatmentDay.ToString("yyyyMMdd"); #endregion #region FKI message.Fki.Segment1 = caseModel.AmountForThisGPOS.ToString("F", germanCulture); message.Fki.Segment2 = ""; message.Fki.Segment3 = ""; message.Fki.Segment4 = ""; message.Fki.Segment5 = ""; message.Fki.Segment6 = ""; message.Fki.Segment7 = caseModel.AmountForThisGPOS.ToString("F", germanCulture); #endregion #region RGI message.Rgi.Segment1 = minTreatmentDate.ToString("yyyyMMdd"); message.Rgi.Segment2 = maxTreatmentDate.ToString("yyyyMMdd"); message.Rgi.Segment3 = "1"; message.Rgi.Segment4 = mmIkNumber; message.Rgi.Segment5 = useKForVorrectionValue && Convert.ToInt32(caseModel.NumberOfNegativeTry) > 0 ? String.Format("{0}K{1}", caseModel.NumberOfNegativeTry, caseModel.InvoiceNumberForTheHIP.ToString()) : caseModel.InvoiceNumberForTheHIP.ToString(); message.Rgi.Segment6 = DateTime.Now.ToString("yyyyMMdd"); message.Rgi.Segment7 = ""; message.Rgi.Segment8 = Convert.ToUInt32(caseModel.NumberOfNegativeTry).ToString("D3"); #endregion #region UNT message.Unt.Segment1 = "10"; message.Unt.Segment2 = currentMessageNumber; #endregion #endregion #region Version specific var InvSegment1Value = caseModel.PatientStatusNumber.Replace(" ", string.Empty); switch (edifactVersion) { case 3: message.Inv.Segment1 = InvSegment1Value.Length < 5 ? InvSegment1Value.Substring(0, 1) + "0001" : InvSegment1Value; message.Ivk.Segment5 = caseModel.InvoiceNumberForTheHIP.ToString(); break; case 4: message.Inv.Segment1 = InvSegment1Value.Substring(0, 1); message.Inv.Segment2 = ""; message.Inv.Segment3 = ""; message.Ivk.Segment5 = "99999999999999"; message.Ivk.Segment6 = hipIkNumber; break; default: break; } #endregion edi.transmitionMessages.Add(message); referenceNumber++; } #region UNZ edi.Unz.Segment1 = edi.transmitionMessages.Count.ToString(); edi.Unz.Segment2 = controlReference.ToString("D5"); #endregion var edifact = edi.GetEdifact(); var edi_path = System.IO.Path.GetTempPath() + edifact.edifactName; var i = 1; while (File.Exists(edi_path)) { edifact.edifactName = string.Format("{0}({1})", edifact.edifactName, i++); edi_path = System.IO.Path.GetTempPath() + edifact.edifactName; } File.WriteAllText(edi_path, edifact.edifactFileOutput); var fi = new FileInfo(edi_path); edi.decryptedFileSize = fi.Length; edi.encryptedFileSize = fi.Length; var aufFile = edi.GetAufFile(); var path_auf = System.IO.Path.GetTempPath() + aufFile.aufName; File.WriteAllText(path_auf, aufFile.aufFileOutput); var files = new List <string>(); files.Add(edi_path); files.Add(path_auf); var zipPath = System.IO.Path.GetTempPath() + edifact.edifactName + ".zip"; ZipFIlesUtils.AddToArchive(zipPath, files); var documentEdifact = new Documents(); documentEdifact.documentName = "Export von " + minTreatmentDate.ToString("dd.MM.yyyy") + " - " + maxTreatmentDate.ToString("dd.MM.yyyy"); documentEdifact.documentOutputLocation = zipPath; documentEdifact.ContractID = contractID; documentEdifact.receiver = mergeForAllHipsValue ? hipNameForMergedEdifact : casesWithHIP_IK[0].HIP; documentEdifact.mimeType = "Application/Edifact"; documents.Add(documentEdifact); controlReference++; } #region Update parameters cls_Save_Contract_Parameter.Invoke(Connection, Transaction, new P_MD_SCP_1754() { Name = EContractParameter.NextEdifactNumber.Value(), ContractID = contractID, NumericValue = Convert.ToDouble(controlReference) }, securityTicket); #endregion } } #endregion #region Excel report generation Documents documentExcel = new Documents(); documentExcel.documentName = "ExcelReport" + DateTime.Now.ToString("dd.MM.yyyy_HH.mm"); documentExcel.documentOutputLocation = GenerateReportCases.CreateCaseXlsReport(cases.ToList(), documentExcel.documentName); documentExcel.mimeType = UtilMethods.GetMimeType(documentExcel.documentOutputLocation); documentExcel.receiver = "MM"; documents.Add(documentExcel); #endregion #region Negative feedback edifact if (Parameter.StatusTo == 5 && !String.IsNullOrEmpty(Parameter.HipIkNumber)) { var files = new List <string>(); var edi_path = Path.GetTempPath() + Parameter.EdifactFileName; File.WriteAllText(edi_path, Parameter.EdifactMessage); files.Add(edi_path); var zipPath = Path.GetTempPath() + Parameter.EdifactFileName + ".zip"; ZipFIlesUtils.AddToArchive(zipPath, files); var errorEdifact = new Documents(); errorEdifact.documentName = String.Format("Import von {0} - {1}", earliestFsStatusDate.ToString("dd.MM.yyyy"), latestFsStatusDate.ToString("dd.MM.yyyy")); errorEdifact.documentOutputLocation = zipPath; errorEdifact.receiver = cls_Get_HIP_Name_for_HIP_IK_Number.Invoke(Connection, Transaction, new P_CAS_GHIPIKfHIPIKN_1207() { HIPIKNumber = Parameter.HipIkNumber }, securityTicket).Result.Name; errorEdifact.mimeType = "Application/Edifact_Error"; documents.Add(errorEdifact); } #endregion #region Document upload foreach (var document in documents) { var ms = new MemoryStream(File.ReadAllBytes(document.documentOutputLocation)); var byteArrayFile = ms.ToArray(); var _providerFactory = ProviderFactory.Instance; var documentProvider = _providerFactory.CreateDocumentServiceProvider(); var uploadedFrom = HttpContext.Current.Request.UserHostAddress; var documentID = documentProvider.UploadDocument(byteArrayFile, document.documentOutputLocation, securityTicket.SessionTicket, uploadedFrom); var downloadURL = documentProvider.GenerateImageThumbnailLink(documentID, securityTicket.SessionTicket, false, 200); var parameterDoc = new P_ARCH_UD_1326(); parameterDoc.DocumentID = documentID; parameterDoc.Mime = document.mimeType; parameterDoc.DocumentName = document.documentName; parameterDoc.DocumentDate = DateForElastic; parameterDoc.Receiver = document.receiver; parameterDoc.ContractID = document.ContractID; if (!Parameter.AreCasesFiltered) { if (parameterDoc.Mime == "Application/Edifact") { parameterDoc.Description = parameterDoc.DocumentName; } else { if (Parameter.AreCasesPositive) { parameterDoc.Description = "DATEV"; } else { parameterDoc.Description = "EDIFACT"; } } } else { if (Parameter.StatusTo == 5) { if (parameterDoc.Mime == "Application/Edifact_Error") { parameterDoc.Description = parameterDoc.DocumentName; } else { parameterDoc.Description = "KV Fehler"; } } else { parameterDoc.Description = "KV Import"; } } cls_Upload_Report.Invoke(Connection, Transaction, parameterDoc, securityTicket); } #endregion } #region Receipt pdf generation var create_pdf_report = false; try { create_pdf_report = Boolean.Parse(WebConfigurationManager.AppSettings["generateReceiptPdf"]); } catch { } if (create_pdf_report && Parameter.StatusTo == 7) { cls_Create_Pdf_Report.Invoke(Connection, Transaction, new P_CAS_CPR_1050() { cases = cases }, securityTicket); } #endregion #region Elastic import if (cases_to_submit.Count != 0) { Add_New_Submitted_Case.Import_Submitted_Case_Data_to_ElasticDB(cases_to_submit, securityTicket.TenantID.ToString()); } if (settlements.Count != 0) { Add_new_Settlement.Import_Settlement_to_ElasticDB(settlements, securityTicket.TenantID.ToString()); } if (patientDetailList.Count != 0) { Add_New_Patient.ImportPatientDetailsToElastic(patientDetailList, securityTicket.TenantID.ToString()); } #endregion returnValue.Result.caseList = cases.Select(t => new CaseLogObject() { BillPositionNumber = t.InvoiceNumberForTheHIP.ToString(), BillPositionType = t.CaseType, CaseNumber = t.CaseNumber.ToString() }).ToArray(); return(returnValue); #endregion UserCode }