protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5EX_SPOaMOfEID_1558 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); //Put your code here var madeObservationsForExaminationID = ORM_HEC_ACT_PerformedAction_MadeObservation.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PerformedAction_MadeObservation.Query() { IsDeleted = false, Tenant_RefID = securityTicket.TenantID, HEC_ACT_PerformedAction_RefID = Parameter.ExaminationID }); foreach (var observation in Parameter.MadeObservationsToDelete) { var PerformedActionMadeObservations = madeObservationsForExaminationID.Where(obs => obs.PotentialObservation_RefID == observation.ObservationID); if (PerformedActionMadeObservations != null) { foreach (var perActMadeObs in PerformedActionMadeObservations) { perActMadeObs.IsDeleted = true; perActMadeObs.Modification_Timestamp = DateTime.Now; perActMadeObs.Save(Connection, Transaction); } } } foreach (var observation in Parameter.MadeObservationsToAdd) { //if potential observation does not exists, first create it Guid potentialObservationID = observation.ObservationID; if (observation.ObservationID == Guid.Empty) { ORM_HEC_PotentialObservation potObs = new ORM_HEC_PotentialObservation(); potObs.Observation_Text = observation.ObservationText; potObs.Tenant_RefID = securityTicket.TenantID; potObs.HEC_PotentialObservationID = Guid.NewGuid(); potObs.Modification_Timestamp = DateTime.Now; potObs.Save(Connection, Transaction); potentialObservationID = potObs.HEC_PotentialObservationID; } ORM_HEC_ACT_PerformedAction_MadeObservation madeObservation = new ORM_HEC_ACT_PerformedAction_MadeObservation(); madeObservation.HEC_ACT_PerformedAction_RefID = Parameter.ExaminationID; madeObservation.PotentialObservation_RefID = potentialObservationID; madeObservation.Comment = observation.ObservationText.Contents[0].Content; madeObservation.Tenant_RefID = securityTicket.TenantID; madeObservation.Modification_Timestamp = DateTime.Now; madeObservation.Save(Connection, Transaction); } return(returnValue); #endregion UserCode }
protected static FR_Guids Execute(DbConnection Connection, DbTransaction Transaction, P_L5DI_SPO_1452 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Guids(); //Put your code here List <Guid> resultID = new List <Guid>(); foreach (var observationParam in Parameter.PotentialObservation) { ORM_HEC_DIA_TypicalPotentialObservation typicalPotentialObservation = ORM_HEC_DIA_TypicalPotentialObservation.Query.Search(Connection, Transaction, new ORM_HEC_DIA_TypicalPotentialObservation.Query { HEC_DIA_TypicalPotentialObservationID = observationParam.TypicalPotentialObservationID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }).SingleOrDefault(); if (!observationParam.IsDeleted) { if (observationParam.NewPotentialObservation) { ORM_HEC_PotentialObservation potentialObservation = new ORM_HEC_PotentialObservation(); potentialObservation.HEC_PotentialObservationID = observationParam.PotentialObservationID; potentialObservation.Observation_Text = observationParam.Observation_Text; potentialObservation.IsDeleted = false; potentialObservation.Tenant_RefID = securityTicket.TenantID; potentialObservation.Save(Connection, Transaction); } if (typicalPotentialObservation == null) { typicalPotentialObservation = new ORM_HEC_DIA_TypicalPotentialObservation(); typicalPotentialObservation.HEC_DIA_TypicalPotentialObservationID = observationParam.TypicalPotentialObservationID; } typicalPotentialObservation.PotentialDiagnosis_RefID = observationParam.PotentialDiagnosis_RefID; typicalPotentialObservation.PotentialObservation_RefID = observationParam.PotentialObservationID; typicalPotentialObservation.IsDeleted = false; typicalPotentialObservation.Tenant_RefID = securityTicket.TenantID; typicalPotentialObservation.Save(Connection, Transaction); resultID.Add(typicalPotentialObservation.HEC_DIA_TypicalPotentialObservationID); } else if (typicalPotentialObservation != null && observationParam.IsDeleted) { typicalPotentialObservation.IsDeleted = true; typicalPotentialObservation.Save(Connection, Transaction); resultID.Add(typicalPotentialObservation.HEC_DIA_TypicalPotentialObservationID); } } returnValue.Result = resultID.ToArray(); return(returnValue); #endregion UserCode }