public static Int32?AddSubClinicalInterventionToTemp(List <Patient_Journey_Trans_SubClin_Interventions_Temp> subclinicalIntervention)
{
try
{
using (PJEntities entity = new PJEntities())
{
Patient_Journey_Trans_SubClin_Interventions_Temp subClinical = null;
if (subclinicalIntervention != null)
{
for (int i = 0; i < subclinicalIntervention.Count; i++)
{
subClinical = new Patient_Journey_Trans_SubClin_Interventions_Temp();
subClinical.Patient_Journey_Trans_Clin_Interventions_Temp_Id = subclinicalIntervention[i].Patient_Journey_Trans_Clin_Interventions_Temp_Id;
subClinical.SubClinical_Intervention_Master_Id = subclinicalIntervention[i].SubClinical_Intervention_Master_Id;
subClinical.Created_By = subclinicalIntervention[i].Created_By;
subClinical.Created_Date = subclinicalIntervention[i].Created_Date;
subClinical.Modified_By = subclinicalIntervention[i].Modified_By;
subClinical.Modified_Date = subclinicalIntervention[i].Modified_Date;
entity.Patient_Journey_Trans_SubClin_Interventions_Temp.Add(subClinical);
entity.SaveChanges();
}
return(1);
}
else
{
return(0);
}
}
}
catch (Exception)
{
return(0);
}
}
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 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);
}
}
