public static Int32?UpdateClinicalInterventionToTemp(ClinicalIntervention clinicalIntervention, string User511, int JourneyId) { Patient_Journey_Trans_Clin_Interventions_Temp clinicalInt = new Patient_Journey_Trans_Clin_Interventions_Temp(); clinicalInt.Patient_Journey_Trans_Clin_Interventions_Temp_Id = clinicalIntervention.ClinicalInterventionId; clinicalInt.Clinical_Intervention_Master_Id = clinicalIntervention.ClinicalInterventionMasterId == 0 ? null : clinicalIntervention.ClinicalInterventionMasterId; clinicalInt.Description = clinicalIntervention.Description; clinicalInt.Evidence = clinicalIntervention.Evidence; clinicalInt.Modified_By = User511; clinicalInt.Modified_Date = DateTime.Now; var response = dbPatientJourney.UpdateClinicalInterventionToTemp(clinicalInt, clinicalIntervention.SubClinicalId); if (response != null) { var toBeApproved = dbPatientAdministration.ToBeApprovedJourney(JourneyId); Patient_Journey_VersionDetails_Temp versionDetails = new Patient_Journey_VersionDetails_Temp(); versionDetails.Patient_Journey_Temp_Id = Convert.ToInt32(JourneyId); versionDetails.Version_Comments = GlobalConstants.VersionCommentsConstants.ClinIntUpdated; versionDetails.Version_Title = GlobalConstants.VersionTitleConstants.ClinIntUpdated; versionDetails.Created_By = User511; versionDetails.Created_Date = DateTime.Now; versionDetails.Modified_By = User511; versionDetails.Modified_Date = DateTime.Now; versionDetails.IsApproved = false; var version = dbPatientAdministration.AddVersionDetailsToTemp(versionDetails); } return(response); }
public static FullPatientTransaction GetFullTransactionDetails(string StageId, string JourneyId) { List <Transaction> listTransactions = bsPatientAdministration.GetTransactions(StageId); List <AssociatedCost> listAssociatedCost = new List <AssociatedCost>(); List <DesiredOutcome> listDesiredOutcome = new List <DesiredOutcome>(); List <ClinicalIntervention> listClinicalIntervention = new List <ClinicalIntervention>(); List <Patient_Journey_Strategic_Moment> listStrategic = new List <Patient_Journey_Strategic_Moment>(); AssociatedCost assCost = null; DesiredOutcome desOutcome = null; ClinicalIntervention clinInter = null; if (listTransactions != null) { List <List <Patient_Journey_Transactions> > StrategicOutcome = dbPatientJourney.GetSMOMTransactions(Convert.ToInt32(StageId), Convert.ToInt32(JourneyId), out listStrategic); for (int i = 0; i < listTransactions.Count; i++) { StrategicMomentDetails strategicdata = null; if (StrategicOutcome != null) { listTransactions[i].StrategicMoment = new List <StrategicMomentDetails>(); for (int j = 0; j < StrategicOutcome.Count; j++) { if (StrategicOutcome[j].Exists(x => x.Patient_Journey_Transactions_Id == listTransactions[i].PatientJourneyTransactionId)) { strategicdata = new StrategicMomentDetails(); strategicdata.IsStrategic = 1; strategicdata.SMOMDescription = listStrategic[j].Description; strategicdata.SMOMTitle = listStrategic[j].Title; strategicdata.SMOMCategory = listStrategic[j].Category; strategicdata.StartStage = dbPatientJourney.GetStageName(listStrategic[j].Patient_Journey_Start_Stage_Id); strategicdata.EndStage = dbPatientJourney.GetStageName(listStrategic[j].Patient_Journey_End_Stage_Id); strategicdata.StartTransaction = dbPatientJourney.GetTransactionName(listStrategic[j].Patient_Journey_Start_Transaction_Id); strategicdata.EndTransaction = dbPatientJourney.GetTransactionName(listStrategic[j].Patient_Journey_End_Transaction_Id); listTransactions[i].StrategicMoment.Add(strategicdata); } else { strategicdata = new StrategicMomentDetails(); strategicdata.IsStrategic = 0; listTransactions[i].StrategicMoment.Add(strategicdata); } } } else { strategicdata = new StrategicMomentDetails(); strategicdata.IsStrategic = 0; listTransactions[i].StrategicMoment.Add(strategicdata); } assCost = new AssociatedCost(); var resultAsscost = dbPatientJourney.GetAssociatedCost(listTransactions[i].PatientJourneyTransactionId); if (resultAsscost != null) { assCost.AssociatedCostId = resultAsscost.Patient_Journey_Transactions_AssociatedCosts_Id; assCost.AssociatedCosts = resultAsscost.AssociatedCosts; assCost.Evidence = resultAsscost.Evidence; assCost.Description = resultAsscost.Description; } assCost.TransactionId = Convert.ToInt32(listTransactions[i].PatientJourneyTransactionId); listAssociatedCost.Add(assCost); desOutcome = new DesiredOutcome(); var resultdesOutcome = dbPatientJourney.GetDesiredOutcome(listTransactions[i].PatientJourneyTransactionId); if (resultdesOutcome != null) { desOutcome.DesiredOutcomeId = resultdesOutcome.Patient_Journey_Transactions_DesiredOutcomes_Id; desOutcome.DesiredOutcomes = resultdesOutcome.DesiredOutcomes; desOutcome.Evidence = resultdesOutcome.Evidence; desOutcome.Description = resultdesOutcome.Description; } desOutcome.TransactionId = Convert.ToInt32(listTransactions[i].PatientJourneyTransactionId); listDesiredOutcome.Add(desOutcome); clinInter = new ClinicalIntervention(); var resultClinInt = dbPatientJourney.GetClinicalIntervention(listTransactions[i].PatientJourneyTransactionId); if (resultClinInt != null) { clinInter.ClinicalInterventionId = resultClinInt.Patient_Journey_Trans_Clin_Interventions_Id; clinInter.ClinicalInterventionMasterId = resultClinInt.Clinical_Intervention_Master_Id; if (clinInter.ClinicalInterventionMasterId != null) { var clinicalInterventionMasterDetails = dbPatientAdministration.GetClinicalInterventionDetails(clinInter.ClinicalInterventionMasterId); clinInter.ClinicalInterventionTitle = clinicalInterventionMasterDetails.Select(x => x.Title).FirstOrDefault().ToString(); if (clinicalInterventionMasterDetails.Select(x => x.Image_Master_Id).FirstOrDefault() != null) { clinInter.ImageMasterId = (int)clinicalInterventionMasterDetails.Select(x => x.Image_Master_Id).FirstOrDefault(); clinInter.ImagePath = dbPatientAdministration.GetImagePath(clinInter.ImageMasterId); } } clinInter.Evidence = resultClinInt.Evidence; clinInter.Description = resultClinInt.Description; List <Patient_Journey_Trans_SubClin_Interventions> lstSubClinicalId = dbPatientJourney.GetSubClinicalIntervention(resultClinInt.Patient_Journey_Trans_Clin_Interventions_Id); if (lstSubClinicalId.Count > 0) { clinInter.SubClinicalId = new int[lstSubClinicalId.Count]; clinInter.SubClinicalImage = new string[lstSubClinicalId.Count]; clinInter.SubClinicalTitle = new string[lstSubClinicalId.Count]; for (int j = 0; j < lstSubClinicalId.Count; j++) { clinInter.SubClinicalId[j] = lstSubClinicalId[j].SubClinical_Intervention_Master_Id; clinInter.SubClinicalImage[j] = dbPatientAdministration.GetImagePath(lstSubClinicalId[j].SubClinical_Intervention_Master_Id); var subclinMaster = DefaultListBSForPJ.GetSubClinicalMasterData(); clinInter.SubClinicalTitle[j] = subclinMaster.Where(x => x.SubClinicalMasterId == lstSubClinicalId[j].SubClinical_Intervention_Master_Id).FirstOrDefault().SubClinicalName; } } } clinInter.TransactionId = Convert.ToInt32(listTransactions[i].PatientJourneyTransactionId); listClinicalIntervention.Add(clinInter); } } FullPatientTransaction fullTransaction = new FullPatientTransaction(); fullTransaction.Transactions = listTransactions; fullTransaction.AssociatedCosts = listAssociatedCost; fullTransaction.DesiredOutcomes = listDesiredOutcome; fullTransaction.ClinicalInterventions = listClinicalIntervention; return(fullTransaction); }