public static List <StrategicMomentModel> GetStrategicMoment(string JourneyId)
{
List <StrategicMomentModel> listStrategicMoment = new List <StrategicMomentModel>();
PJEntities entity = new PJEntities();
var momentList = dbStrategicMoment.GetStrategicMoment(Convert.ToInt32(JourneyId));
var stagesMasterList = dbStrategicMoment.GetStages();
var transactionMasterList = dbStrategicMoment.GetTransactions();
var journeyStagesList = dbStrategicMoment.GetJourneyStages();
var journeyTransactionsList = dbStrategicMoment.GetJourneyTransactions();
for (int i = 0; i < momentList.Count; i++)
{
StrategicMomentModel strategicMoment = new StrategicMomentModel();
strategicMoment.Id = i + 1;
strategicMoment.Title = momentList[i].Title;
strategicMoment.StrategicMomentId = Convert.ToInt32(momentList[i].Patient_Journey_Strategic_Moment_Id);
strategicMoment.StrategicMomentTempId = Convert.ToInt32(momentList[i].Patient_Journey_Strategic_Moment_Temp_Id);
strategicMoment.StartStageId = Convert.ToInt32(momentList[i].Patient_Journey_Start_Stage_Id);
strategicMoment.StartStageMasterId = journeyStagesList.Where(x => x.Patient_Journey_Stages_Id == strategicMoment.StartStageId).Select(x => x.Stage_Master_Id).FirstOrDefault();
strategicMoment.StartStage = stagesMasterList.Where(x => x.Stage_Master_Id == strategicMoment.StartStageMasterId).Select(x => x.Stage_Name).FirstOrDefault().ToString();
strategicMoment.EndStageId = Convert.ToInt32(momentList[i].Patient_Journey_End_Stage_Id);
strategicMoment.EndStageMasterId = journeyStagesList.Where(x => x.Patient_Journey_Stages_Id == strategicMoment.EndStageId).Select(x => x.Stage_Master_Id).FirstOrDefault();
strategicMoment.EndStage = stagesMasterList.Where(x => x.Stage_Master_Id == strategicMoment.EndStageMasterId).Select(x => x.Stage_Name).FirstOrDefault().ToString();;
strategicMoment.Description = momentList[i].Description;
strategicMoment.Category = momentList[i].Category;
strategicMoment.StartTransactionId = momentList[i].Patient_Journey_Start_Transaction_Id;
strategicMoment.EndTransactionId = momentList[i].Patient_Journey_End_Transaction_Id;
strategicMoment.StartTransactionMasterId = journeyTransactionsList.Where(x => x.Patient_Journey_Transactions_Id == strategicMoment.StartTransactionId).Select(x => x.Transaction_Master_Id).FirstOrDefault();
strategicMoment.EndTransactionMasterId = journeyTransactionsList.Where(x => x.Patient_Journey_Transactions_Id == strategicMoment.EndTransactionId).Select(x => x.Transaction_Master_Id).FirstOrDefault();
strategicMoment.StartTransaction = transactionMasterList.Where(x => x.Transaction_Master_Id == strategicMoment.StartTransactionMasterId).Select(x => x.Transaction_Name).FirstOrDefault().ToString();
strategicMoment.EndTransaction = transactionMasterList.Where(x => x.Transaction_Master_Id == strategicMoment.EndTransactionMasterId).Select(x => x.Transaction_Name).FirstOrDefault().ToString();
listStrategicMoment.Add(strategicMoment);
}
return(listStrategicMoment);
}
public static Int32?UpdateStrategicMoment(StrategicMomentModel strategicMoment, string User511)
{
var patientJourneyTemp = dbStrategicMoment.GetPatientJourneyTemp();
var patientJourneyStagesTemp = dbStrategicMoment.GetPatientJourneyStagesTemp();
var patientJourneyTransactionTemp = dbStrategicMoment.GetPatientJourneyTransactionTemp();
Patient_Journey_Strategic_Moment_Temp strategicMomentsTemp = new Patient_Journey_Strategic_Moment_Temp();
strategicMomentsTemp.Title = strategicMoment.Title;
strategicMomentsTemp.Patient_Journey_Strategic_Moment_Temp_Id = strategicMoment.StrategicMomentTempId;
strategicMomentsTemp.Patient_Journey_Temp_Id = patientJourneyTemp.Where(x => x.Patient_Journey_Id == strategicMoment.JourneyId).Select(x => x.Patient_Journey_Temp_Id).FirstOrDefault();
strategicMomentsTemp.Patient_Journey_Start_Stage_Temp_Id = patientJourneyStagesTemp.Where(x => x.Patient_Journey_Stages_Id == strategicMoment.StartStageId).Select(x => x.Patient_Journey_Stages_Temp_Id).FirstOrDefault();
strategicMomentsTemp.Patient_Journey_End_Stage_Temp_Id = patientJourneyStagesTemp.Where(x => x.Patient_Journey_Stages_Id == strategicMoment.EndStageId).Select(x => x.Patient_Journey_Stages_Temp_Id).FirstOrDefault();
strategicMomentsTemp.Patient_Journey_Start_Transaction_Temp_Id = patientJourneyTransactionTemp.Where(x => x.Patient_Journey_Transactions_Id == strategicMoment.StartTransactionId).Select(x => x.Patient_Journey_Transactions_Temp_Id).FirstOrDefault();
strategicMomentsTemp.Patient_Journey_End_Transaction_Temp_Id = patientJourneyTransactionTemp.Where(x => x.Patient_Journey_Transactions_Id == strategicMoment.EndTransactionId).Select(x => x.Patient_Journey_Transactions_Temp_Id).FirstOrDefault();
strategicMomentsTemp.Category = strategicMoment.Category;
strategicMomentsTemp.Description = strategicMoment.Description;
strategicMomentsTemp.Created_By = User511;
strategicMomentsTemp.Created_Date = DateTime.Now;
strategicMomentsTemp.Modified_By = User511;
strategicMomentsTemp.Modified_Date = DateTime.Now;
var responseTemp = dbStrategicMoment.UpdateStrategicMomentTemp(strategicMomentsTemp);
if (responseTemp == 1)
{
Patient_Journey_Strategic_Moment strategicMoments = new Patient_Journey_Strategic_Moment();
strategicMoments.Title = strategicMoment.Title;
strategicMoments.Patient_Journey_Strategic_Moment_Id = strategicMoment.StrategicMomentId;
strategicMoments.Patient_Journey_Id = strategicMoment.JourneyId;
strategicMoments.Patient_Journey_Start_Stage_Id = strategicMoment.StartStageId;
strategicMoments.Patient_Journey_End_Stage_Id = strategicMoment.EndStageId;
strategicMoments.Patient_Journey_Start_Transaction_Id = strategicMoment.StartTransactionId;
strategicMoments.Patient_Journey_End_Transaction_Id = strategicMoment.EndTransactionId;
strategicMoments.Category = strategicMoment.Category;
strategicMoments.Description = strategicMoment.Description;
strategicMoments.Created_By = User511;
strategicMoments.Created_Date = DateTime.Now;
strategicMoments.Modified_By = User511;
strategicMoments.Modified_Date = DateTime.Now;
var response = dbStrategicMoment.UpdateStrategicMoment(strategicMoments);
return(response);
}
else
{
return(0);
}
}
