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