public static Int32?UpdateStrategicMomentTemp(Patient_Journey_Strategic_Moment_Temp strategicMomentsTemp) { try { using (PJEntities entity = new PJEntities()) { var currentStrategic = entity.Patient_Journey_Strategic_Moment_Temp.Where(s => s.Patient_Journey_Strategic_Moment_Temp_Id == strategicMomentsTemp.Patient_Journey_Strategic_Moment_Temp_Id).FirstOrDefault(); if (currentStrategic != null) { currentStrategic.Title = strategicMomentsTemp.Title; currentStrategic.Patient_Journey_Temp_Id = strategicMomentsTemp.Patient_Journey_Temp_Id; currentStrategic.Patient_Journey_Start_Stage_Temp_Id = strategicMomentsTemp.Patient_Journey_Start_Stage_Temp_Id; currentStrategic.Patient_Journey_End_Stage_Temp_Id = strategicMomentsTemp.Patient_Journey_End_Stage_Temp_Id; currentStrategic.Patient_Journey_Start_Transaction_Temp_Id = strategicMomentsTemp.Patient_Journey_Start_Transaction_Temp_Id; currentStrategic.Patient_Journey_End_Transaction_Temp_Id = strategicMomentsTemp.Patient_Journey_End_Transaction_Temp_Id; currentStrategic.Description = strategicMomentsTemp.Description; currentStrategic.Category = strategicMomentsTemp.Category; currentStrategic.Modified_By = strategicMomentsTemp.Modified_By; currentStrategic.Modified_Date = strategicMomentsTemp.Modified_Date; } entity.SaveChanges(); return(1); } } catch (Exception) { return(0); } }
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); } }
public static Int32?AddStrategicMomentTemp(Patient_Journey_Strategic_Moment_Temp strategicMomentsTemp) { try { using (PJEntities entity = new PJEntities()) { entity.Patient_Journey_Strategic_Moment_Temp.Add(strategicMomentsTemp); entity.SaveChanges(); entity.Entry(strategicMomentsTemp).GetDatabaseValues(); int id = strategicMomentsTemp.Patient_Journey_Strategic_Moment_Temp_Id; return(id); } } catch (Exception) { return(0); } }