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_CGR_1400 Execute(DbConnection connection, DbTransaction transaction, P_CAS_CGR_1400 parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_CAS_CGR_1400();
returnValue.Result = new CAS_CGR_1400();
Thread.CurrentThread.CurrentCulture = CultureInfo.GetCultureInfo("de-DE");
Thread.CurrentThread.CurrentUICulture = CultureInfo.GetCultureInfo("de-DE");
string downloadURL = "";
Guid prev_case_id = Guid.Empty;
DateTime DateForElastic = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local);
var cases = cls_Generate_Report.Invoke(connection, transaction, new P_CAS_GR_1608()
{
}, securityTicket, parameter.ShowOnlyAok).Result.cases.ToList();
List <Documents> documentList = new List <Documents>();
if (cases.Count() > 0)
{
Documents documentExcel = new Documents();
// documentExcel.documentName = "ExcelReport" + DateTime.Now.ToString("dd.MM.yyyy_HH.mm");
if (parameter.ShowOnlyAok.HasValue)
{
if (parameter.ShowOnlyAok.Value == true)
{
documentExcel.documentName = "AokReport" + DateTime.Now.ToString("dd.MM.yyyy_HH.mm");
}
else
{
documentExcel.documentName = "!AokReport" + DateTime.Now.ToString("dd.MM.yyyy_HH.mm");
}
}
else
{
documentExcel.documentName = "ExcelReport" + DateTime.Now.ToString("dd.MM.yyyy_HH.mm");
}
documentExcel.documentOutputLocation = GenerateReportCases.CreateCaseXlsReport(cases, 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);
downloadURL = documentProvider.GenerateDownloadLink(documentID, securityTicket.SessionTicket, true, true);
P_ARCH_UD_1326 parameterDoc = new P_ARCH_UD_1326();
parameterDoc.DocumentID = documentID;
parameterDoc.Mime = UtilMethods.GetMimeType(item.documentName + ".xlsx");
parameterDoc.DocumentName = item.documentName;
parameterDoc.DocumentDate = DateForElastic;
parameterDoc.Receiver = "MM";
parameterDoc.Description = "Vollständiger Bericht";
cls_Upload_Report.Invoke(connection, transaction, parameterDoc, securityTicket);
}
}
returnValue.Result.DownloadURL = downloadURL;
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
}
