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 Int32?AddClinicalInterventionToTemp(Patient_Journey_Trans_Clin_Interventions_Temp clinicalIntervention, int[] lstSubClinical) { try { using (PJEntities entity = new PJEntities()) { entity.Patient_Journey_Trans_Clin_Interventions_Temp.Add(clinicalIntervention); Patient_Journey_Trans_SubClin_Interventions_Temp subClinical = null; if (lstSubClinical != null) { for (int i = 0; i < lstSubClinical.Length; i++) { subClinical = new Patient_Journey_Trans_SubClin_Interventions_Temp(); subClinical.Patient_Journey_Trans_Clin_Interventions_Temp_Id = clinicalIntervention.Patient_Journey_Trans_Clin_Interventions_Temp_Id; subClinical.SubClinical_Intervention_Master_Id = lstSubClinical[i]; subClinical.Created_By = clinicalIntervention.Created_By; subClinical.Created_Date = clinicalIntervention.Created_Date; subClinical.Modified_By = clinicalIntervention.Modified_By; subClinical.Modified_Date = clinicalIntervention.Modified_Date; entity.Patient_Journey_Trans_SubClin_Interventions_Temp.Add(subClinical); } } entity.SaveChanges(); return(clinicalIntervention.Patient_Journey_Trans_Clin_Interventions_Temp_Id); } } catch (Exception) { return(0); } }
public static Patient_Journey_Trans_Clin_Interventions_Temp GetClinicalInterventionFromTemp(int TransactionId) { Patient_Journey_Trans_Clin_Interventions_Temp clinInt = new Patient_Journey_Trans_Clin_Interventions_Temp(); using (PJEntities entity = new PJEntities()) { clinInt = entity.Patient_Journey_Trans_Clin_Interventions_Temp.Where(x => x.Patient_Journey_Transactions_Temp_Id == TransactionId).FirstOrDefault(); return(clinInt); } }
public static Int32?UpdateClinicalInterventionToTemp(Patient_Journey_Trans_Clin_Interventions_Temp clinicalIntervention, int[] lstSubClinical) { try { using (PJEntities entity = new PJEntities()) { var currentclinical = entity.Patient_Journey_Trans_Clin_Interventions_Temp.Where(s => s.Patient_Journey_Trans_Clin_Interventions_Temp_Id == clinicalIntervention.Patient_Journey_Trans_Clin_Interventions_Temp_Id).FirstOrDefault(); var existingSubClinical = entity.Patient_Journey_Trans_SubClin_Interventions_Temp.Where(s => s.Patient_Journey_Trans_Clin_Interventions_Temp_Id == clinicalIntervention.Patient_Journey_Trans_Clin_Interventions_Temp_Id).ToList(); for (int i = 0; i < existingSubClinical.Count; i++) { entity.Patient_Journey_Trans_SubClin_Interventions_Temp.Remove(existingSubClinical[i]); } if (currentclinical != null) { currentclinical.Clinical_Intervention_Master_Id = clinicalIntervention.Clinical_Intervention_Master_Id; currentclinical.Description = clinicalIntervention.Description; currentclinical.Evidence = clinicalIntervention.Evidence; currentclinical.Modified_By = clinicalIntervention.Modified_By; currentclinical.Modified_Date = clinicalIntervention.Modified_Date; Patient_Journey_Trans_SubClin_Interventions_Temp subClinical = null; if (lstSubClinical != null) { for (int i = 0; i < lstSubClinical.Length; i++) { subClinical = new Patient_Journey_Trans_SubClin_Interventions_Temp(); subClinical.Patient_Journey_Trans_Clin_Interventions_Temp_Id = clinicalIntervention.Patient_Journey_Trans_Clin_Interventions_Temp_Id; subClinical.SubClinical_Intervention_Master_Id = lstSubClinical[i]; subClinical.Created_By = clinicalIntervention.Created_By; subClinical.Created_Date = DateTime.Now; subClinical.Modified_By = clinicalIntervention.Modified_By; subClinical.Modified_Date = clinicalIntervention.Modified_Date; entity.Patient_Journey_Trans_SubClin_Interventions_Temp.Add(subClinical); } } } entity.SaveChanges(); return(currentclinical.Patient_Journey_Trans_Clin_Interventions_Temp_Id); } } catch (Exception) { return(0); } }