public static Journey_Transaction GetTransactions(string JourneyId, string StageId, int id)
{
//List<Patient_Journey_Strategic_Moment> listStrategic = new List<Patient_Journey_Strategic_Moment>();
List <Journey_Transaction> listTransactions = new List <Journey_Transaction>();
Journey_Transaction patienttransaction = new Journey_Transaction();
patienttransaction.PatientStageId = Convert.ToInt32(StageId);
var transaction = dbPatientAdministration.GetTransactions(Convert.ToInt32(StageId));
//List<List<Patient_Journey_Transactions>> StrategicOutcome = dbPatientJourney.GetSMOMTransactions(Convert.ToInt32(StageId), Convert.ToInt32(JourneyId), out listStrategic);
List <Journey_Transaction_Details> listTransactionsDetails = new List <Journey_Transaction_Details>();
for (int i = 0; i < transaction.Count; i++)
{
List <ChartDetails> chartDetailsList = new List <ChartDetails>();
List <StrategicMomentAll> strategicMomentAll = new List <StrategicMomentAll>();
//StrategicMomentAll strategicdata = null;
Journey_Transaction_Details Journey_Transaction_Details = new Journey_Transaction_Details();
Journey_Transaction_Details.PatientJourneyTransactionId = transaction[i].Patient_Journey_Transactions_Id;
Journey_Transaction_Details.PatientStageId = Convert.ToInt32(transaction[i].Patient_Journey_Stages_Id);
Journey_Transaction_Details.PatientJourneyId = Convert.ToInt32(transaction[i].Patient_Journey_Id);
Journey_Transaction_Details.TransactionMasterId = Convert.ToInt32(transaction[i].Transaction_Master_Id);
Journey_Transaction_Details.ImageMasterId = dbPatientAdministration.GetImageMasterID(Journey_Transaction_Details.TransactionMasterId);
Journey_Transaction_Details.ImagePath = dbPatientAdministration.GetImagePath(Journey_Transaction_Details.ImageMasterId);
Journey_Transaction_Details.TransactionTitle = transaction[i].Transaction_Title;
Journey_Transaction_Details.LocationId = Convert.ToInt32(transaction[i].Transaction_Location_Master_Id);
Journey_Transaction_Details.LocationName = transaction[i].Transaction_Location_Title;
Journey_Transaction_Details.TransactionDescription = transaction[i].Description;
Journey_Transaction_Details.DisplayOrder = Convert.ToInt32(transaction[i].Transaction_Display_Order);
Journey_Transaction_Details.HCPDescription = transaction[i].HCP_Description;
Journey_Transaction_Details.HCPRating = transaction[i].HCP_Rating;
Journey_Transaction_Details.PatientDescription = transaction[i].Patient_Description;
Journey_Transaction_Details.PatientRating = transaction[i].Patient_Rating;
Journey_Transaction_Details.PayerDescription = transaction[i].Payer_Description;
Journey_Transaction_Details.PayerRating = transaction[i].Payer_Rating;
Journey_Transaction_Details.FeasibilityDescription = transaction[i].Feasibility_Description;
Journey_Transaction_Details.FeasibilityRating = transaction[i].Feasibility_Rating;
Journey_Transaction_Details.ViabilityDescription = transaction[i].Viability_Description;
Journey_Transaction_Details.ViabilityRating = transaction[i].Viability_Rating;
for (int k = 0; k < 10; k++)
{
ChartDetails _ChartDetails = new ChartDetails();
if (k == Journey_Transaction_Details.PatientRating)
{
_ChartDetails.DotColor = "#0019a2";
_ChartDetails.LineHeight = "15px";
_ChartDetails.MarginLeft = "12px";
_ChartDetails.FontSize = "40px";
chartDetailsList.Add(_ChartDetails);
}
else if (k == Journey_Transaction_Details.HCPRating)
{
_ChartDetails.DotColor = "#f44336";
_ChartDetails.LineHeight = "15px";
_ChartDetails.MarginLeft = "12px";
_ChartDetails.FontSize = "40px";
chartDetailsList.Add(_ChartDetails);
}
else if (k == Journey_Transaction_Details.PayerRating)
{
_ChartDetails.DotColor = "#4caf50";
_ChartDetails.LineHeight = "15px";
_ChartDetails.MarginLeft = "12px";
_ChartDetails.FontSize = "40px";
chartDetailsList.Add(_ChartDetails);
}
else
{
_ChartDetails.DotColor = "#ccc";
_ChartDetails.LineHeight = "15px";
_ChartDetails.MarginLeft = null;
_ChartDetails.FontSize = null;
chartDetailsList.Add(_ChartDetails);
}
}
Journey_Transaction_Details.ChartDetails = chartDetailsList;
//var stagesAll = dbPatientAdministration.GetPatientJourneyStages();
//var transactionAll = dbPatientAdministration.GetPatientJourneyTransactions();
//if (StrategicOutcome != null)
//{
// for (int j = 0; j < StrategicOutcome.Count; j++)
// {
// if (StrategicOutcome[j].Exists(x => x.Patient_Journey_Transactions_Id == transaction[i].Patient_Journey_Transactions_Id))
// {
// strategicdata = new StrategicMomentAll();
// strategicdata.IsStrategic = 1;
// strategicdata.SMOMDescription = listStrategic[j].Description;
// strategicdata.SMOMCategory = listStrategic[j].Category;
// if (listStrategic[j].Category == "HCP") { strategicdata.SMOMColor = "#ef8de3"; }
// else if (listStrategic[j].Category == "Patient") { strategicdata.SMOMColor = "#92dead"; }
// else if (listStrategic[j].Category == "Payer") { strategicdata.SMOMColor = "#d2cf70"; }
// strategicdata.StartStage = stagesAll.Where(x => x.Patient_Journey_Stages_Id == listStrategic[j].Patient_Journey_Start_Stage_Id).FirstOrDefault().Stage_Title;
// strategicdata.EndStage = stagesAll.Where(x => x.Patient_Journey_Stages_Id == listStrategic[j].Patient_Journey_End_Stage_Id).FirstOrDefault().Stage_Title;
// strategicdata.StartTransaction = transactionAll.Where(x => x.Patient_Journey_Transactions_Id == listStrategic[j].Patient_Journey_Start_Transaction_Id).FirstOrDefault().Transaction_Title;
// strategicdata.EndTransaction = transactionAll.Where(x => x.Patient_Journey_Transactions_Id == listStrategic[j].Patient_Journey_End_Transaction_Id).FirstOrDefault().Transaction_Title;
// strategicMomentAll.Add(strategicdata);
// }
// else
// {
// strategicdata = new StrategicMomentAll();
// strategicdata.SMOMColor = (id % 2 == 1) ? "rgba(204, 204, 204, 0)" : "rgba(158, 158, 158, 0)";
// strategicdata.IsStrategic = 0;
// strategicMomentAll.Add(strategicdata);
// }
// }
//}
//else
//{
// strategicdata = new StrategicMomentAll();
// strategicdata.SMOMColor = (id % 2 == 1) ? "rgba(204, 204, 204, 0)" : "rgba(158, 158, 158, 0)";
// strategicdata.IsStrategic = 0;
// strategicMomentAll.Add(strategicdata);
//}
//Journey_Transaction_Details.StrategicMomentAll = strategicMomentAll;
listTransactionsDetails.Add(Journey_Transaction_Details);
}
patienttransaction.TransactionsDetails = listTransactionsDetails;
return(patienttransaction);
}
public static FullJourneyTransaction GetAllTransactions(string JourneyId, List <JourneyStages> stages)
{
FullJourneyTransaction fullJourneyTransaction = new FullJourneyTransaction();
List <Journey_ClinicalInterventions> listClinicalIntervention = new List <Journey_ClinicalInterventions>();
Journey_ClinicalInterventions clinInter = null;
List <Journey_DesiredOutcomes> listDesiredOutcomes = new List <Journey_DesiredOutcomes>();
Journey_DesiredOutcomes desiredOutcomes = null;
List <Journey_AssociatedCosts> listAssociatedCosts = new List <Journey_AssociatedCosts>();
Journey_AssociatedCosts associatedCost = null;
#region Get Transaction
for (int i = 0; i < stages.Count; i++)
{
Journey_Transaction _journeyTransaction = new Journey_Transaction();
_journeyTransaction = bsPdfJourney.GetTransactions(JourneyId, stages[i].PatientStageId.ToString(), i);
_journeyTransaction.StageColor = (i % 2 == 1) ? "#fff" : "rgba(204, 204, 204, 0.48)";
_journeyTransaction.StageColorForLocation = (i % 2 == 1) ? "rgba(204, 204, 204, 0.48)" : "rgba(158, 158, 158, 0.48)";
fullJourneyTransaction.Transactions.Add(_journeyTransaction);
}
#endregion
if (fullJourneyTransaction.Transactions != null)
{
#region Get Clinical Intervention
for (int i = 0; i < fullJourneyTransaction.Transactions.Count; i++)
{
clinInter = new Journey_ClinicalInterventions();
clinInter.StageColor = (i % 2 == 1) ? "rgb(255, 255, 255)" : "rgba(204, 204, 204, 0.48)";
clinInter.StageColorForLocation = (i % 2 == 1) ? "rgba(204, 204, 204, 0.48)" : "rgba(158, 158, 158, 0.48)";
List <Journey_ClinicalInterventions_Details> ClinicalInterventionsDetails = new List <Journey_ClinicalInterventions_Details>();
for (int j = 0; j < fullJourneyTransaction.Transactions[i].TransactionsDetails.Count; j++)
{
clinInter.TransactionId = Convert.ToInt32(fullJourneyTransaction.Transactions[i].TransactionsDetails[j].PatientJourneyTransactionId);
var resultClinInt = dbPatientJourney.GetClinicalIntervention(fullJourneyTransaction.Transactions[i].TransactionsDetails[j].PatientJourneyTransactionId);
if (resultClinInt != null)
{
Journey_ClinicalInterventions_Details Journey_ClinicalInterventions_Details = new Journey_ClinicalInterventions_Details();
Journey_ClinicalInterventions_Details.ClinicalInterventionId = resultClinInt.Patient_Journey_Trans_Clin_Interventions_Id;
Journey_ClinicalInterventions_Details.ClinicalInterventionMasterId = resultClinInt.Clinical_Intervention_Master_Id;
if (Journey_ClinicalInterventions_Details.ClinicalInterventionMasterId != null)
{
var clinicalInterventionMasterDetails = dbPatientAdministration.GetClinicalInterventionDetails(Journey_ClinicalInterventions_Details.ClinicalInterventionMasterId);
Journey_ClinicalInterventions_Details.ClinicalInterventionTitle = clinicalInterventionMasterDetails.Select(x => x.Title).FirstOrDefault().ToString();
if (clinicalInterventionMasterDetails.Select(x => x.Image_Master_Id).FirstOrDefault() != null)
{
Journey_ClinicalInterventions_Details.ImageMasterId = (int)clinicalInterventionMasterDetails.Select(x => x.Image_Master_Id).FirstOrDefault();
Journey_ClinicalInterventions_Details.ImagePath = dbPatientAdministration.GetImagePath(Journey_ClinicalInterventions_Details.ImageMasterId);
}
}
Journey_ClinicalInterventions_Details.Description = resultClinInt.Description;
ClinicalInterventionsDetails.Add(Journey_ClinicalInterventions_Details);
}
else
{
Journey_ClinicalInterventions_Details Journey_ClinicalInterventions_Details = new Journey_ClinicalInterventions_Details();
ClinicalInterventionsDetails.Add(Journey_ClinicalInterventions_Details);
}
clinInter.ClinicalInterventionsDetails = ClinicalInterventionsDetails;
}
fullJourneyTransaction.ClinicalInterventions.Add(clinInter);
}
#endregion
#region Get Desired Outcomes
Journey_DesiredOutcomes_Details Journey_DesiredOutcomes_Details;
for (int i = 0; i < fullJourneyTransaction.Transactions.Count; i++)
{
desiredOutcomes = new Journey_DesiredOutcomes();
desiredOutcomes.StageColor = (i % 2 == 1) ? "rgb(255, 255, 255)" : "rgba(204, 204, 204, 0.48)";
desiredOutcomes.StageColorForLocation = (i % 2 == 1) ? "rgba(204, 204, 204, 0.48)" : "rgba(158, 158, 158, 0.48)";
List <Journey_DesiredOutcomes_Details> DesiredOutcomesDetails = new List <Journey_DesiredOutcomes_Details>();
for (int j = 0; j < fullJourneyTransaction.Transactions[i].TransactionsDetails.Count; j++)
{
desiredOutcomes.TransactionId = Convert.ToInt32(fullJourneyTransaction.Transactions[i].TransactionsDetails[j].PatientJourneyTransactionId);
var resultDesiredOutcomes = dbPatientJourney.GetDesiredOutcome(fullJourneyTransaction.Transactions[i].TransactionsDetails[j].PatientJourneyTransactionId);
if (resultDesiredOutcomes != null)
{
Journey_DesiredOutcomes_Details = new Journey_DesiredOutcomes_Details();
Journey_DesiredOutcomes_Details.DesiredOutcomeId = resultDesiredOutcomes.Patient_Journey_Transactions_DesiredOutcomes_Id;
Journey_DesiredOutcomes_Details.Description = resultDesiredOutcomes.Description;
DesiredOutcomesDetails.Add(Journey_DesiredOutcomes_Details);
}
else
{
Journey_DesiredOutcomes_Details = new Journey_DesiredOutcomes_Details();
DesiredOutcomesDetails.Add(Journey_DesiredOutcomes_Details);
}
desiredOutcomes.DesiredOutcomesDetails = DesiredOutcomesDetails;
}
fullJourneyTransaction.DesiredOutcomes.Add(desiredOutcomes);
}
#endregion
#region Get Associated Costs
for (int i = 0; i < fullJourneyTransaction.Transactions.Count; i++)
{
associatedCost = new Journey_AssociatedCosts();
associatedCost.StageColor = (i % 2 == 1) ? "rgb(255, 255, 255)" : "rgba(204, 204, 204, 0.48)";
associatedCost.StageColorForLocation = (i % 2 == 1) ? "rgba(204, 204, 204, 0.48)" : "rgba(158, 158, 158, 0.48)";
List <Journey_AssociatedCosts_Details> AssociatedCostDetails = new List <Journey_AssociatedCosts_Details>();
for (int j = 0; j < fullJourneyTransaction.Transactions[i].TransactionsDetails.Count; j++)
{
associatedCost.TransactionId = Convert.ToInt32(fullJourneyTransaction.Transactions[i].TransactionsDetails[j].PatientJourneyTransactionId);
var resultAssociatedCost = dbPatientJourney.GetAssociatedCost(fullJourneyTransaction.Transactions[i].TransactionsDetails[j].PatientJourneyTransactionId);
if (resultAssociatedCost != null)
{
Journey_AssociatedCosts_Details Journey_AssociatedCost_Details = new Journey_AssociatedCosts_Details();
Journey_AssociatedCost_Details.AssociatedCostId = resultAssociatedCost.Patient_Journey_Transactions_AssociatedCosts_Id;
Journey_AssociatedCost_Details.Description = resultAssociatedCost.Description;
AssociatedCostDetails.Add(Journey_AssociatedCost_Details);
}
else
{
Journey_AssociatedCosts_Details Journey_AssociatedCost_Details = new Journey_AssociatedCosts_Details();
AssociatedCostDetails.Add(Journey_AssociatedCost_Details);
}
associatedCost.AssociatedCostDetails = AssociatedCostDetails;
}
fullJourneyTransaction.AssociatedCosts.Add(associatedCost);
}
#endregion
}
FullJourneyTransaction fullTransaction = new FullJourneyTransaction();
fullTransaction.Transactions = fullJourneyTransaction.Transactions;
fullTransaction.ClinicalInterventions = fullJourneyTransaction.ClinicalInterventions;
fullTransaction.DesiredOutcomes = fullJourneyTransaction.DesiredOutcomes;
fullTransaction.AssociatedCosts = fullJourneyTransaction.AssociatedCosts;
return(fullTransaction);
}
