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); } }