///<summary> /// Save Patient Parameter Types Group for current Tenant (from SessionSecurityTicket) ///<summary> private static Guid Save_PatientParameterTypeGroupForTenant(DbConnection Connection, DbTransaction Transaction, String groupType, SessionSecurityTicket securityTicket) { var allContactTypes = EnumUtils.GetAllEnumTypeDescriptionPairs <EPatientParameterTypeGroup>(); var enumType = allContactTypes[groupType]; string description = GetEnumDescription(enumType); ORM_HEC_Patient_ParameterType_Group ORMPatientParameterTypeGroup = new ORM_HEC_Patient_ParameterType_Group(); ORMPatientParameterTypeGroup.HEC_Patient_ParameterType_GroupID = Guid.NewGuid(); ORMPatientParameterTypeGroup.GlobalPropertyMatchingID = description; ORMPatientParameterTypeGroup.Creation_Timestamp = DateTime.Now; ORMPatientParameterTypeGroup.Tenant_RefID = securityTicket.TenantID; ORMPatientParameterTypeGroup.Save(Connection, Transaction); return(ORMPatientParameterTypeGroup.HEC_Patient_ParameterType_GroupID); }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5DI_SV_1333 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); //Put your code here var groupType = ORM_HEC_Patient_ParameterType_Group.Query.Search(Connection, Transaction, new ORM_HEC_Patient_ParameterType_Group.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, GlobalPropertyMatchingID = "myhealtclub.gpapp.group.custom" // promeniti }).SingleOrDefault(); if (groupType == null) { groupType = new ORM_HEC_Patient_ParameterType_Group() { GlobalPropertyMatchingID = "myhealtclub.gpapp.group.custom", HEC_Patient_ParameterType_GroupID = Guid.NewGuid(), Tenant_RefID = securityTicket.TenantID }; groupType.Save(Connection, Transaction); } ORM_HEC_Patient_Parameter vital; if (Parameter.HEC_Patient_ParameterID != Guid.Empty) { vital = ORM_HEC_Patient_Parameter.Query.Search(Connection, Transaction, new ORM_HEC_Patient_Parameter.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, HEC_Patient_ParameterID = Parameter.HEC_Patient_ParameterID }).Single(); returnValue.Result = vital.HEC_Patient_ParameterID; if (Parameter.IsDeleted) { vital.IsDeleted = true; vital.Save(Connection, Transaction); var avaUnitDel = ORM_HEC_Patient_ParameterType_AvailableUnit.Query.SoftDelete(Connection, Transaction, new ORM_HEC_Patient_ParameterType_AvailableUnit.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, Patient_ParameterType_RefID = vital.ParameterType_RefID }); var typeDel = ORM_HEC_Patient_ParameterType.Query.SoftDelete(Connection, Transaction, new ORM_HEC_Patient_ParameterType.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, HEC_Patient_ParameterTypeID = vital.ParameterType_RefID }); var t2gtDel = ORM_HEC_Patient_ParameterType_2_ParameterTypeGroup.Query.SoftDelete(Connection, Transaction, new ORM_HEC_Patient_ParameterType_2_ParameterTypeGroup.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, HEC_Patient_ParameterType_RefID = vital.ParameterType_RefID, HEC_Patient_ParameterType_Group_RefID = groupType.HEC_Patient_ParameterType_GroupID }); } else { var AvaUnit = ORM_HEC_Patient_ParameterType_AvailableUnit.Query.Search(Connection, Transaction, new ORM_HEC_Patient_ParameterType_AvailableUnit.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, Patient_ParameterType_RefID = vital.ParameterType_RefID }).Single(); AvaUnit.Unit_RefID = Parameter.Unit_RefID; AvaUnit.Save(Connection, Transaction); vital.Parameter_Name = Parameter.Parameter_Name; vital.IfFloat_MaxValue = Parameter.MaxValue; vital.IfFloat_MinValue = Parameter.MinValue; vital.Save(Connection, Transaction); } } else { vital = new ORM_HEC_Patient_Parameter() { Tenant_RefID = securityTicket.TenantID, IsVitalParameter = true, Parameter_Name = Parameter.Parameter_Name, HEC_Patient_ParameterID = Guid.NewGuid(), PatientParameterITL = Guid.NewGuid().ToString(), IsFloat = true }; returnValue.Result = vital.HEC_Patient_ParameterID; var type = new ORM_HEC_Patient_ParameterType() { Tenant_RefID = securityTicket.TenantID, HEC_Patient_ParameterTypeID = Guid.NewGuid(), }; type.Save(Connection, Transaction); vital.Parameter_Name = Parameter.Parameter_Name; vital.IfFloat_MaxValue = Parameter.MaxValue; vital.IfFloat_MinValue = Parameter.MinValue; vital.ParameterType_RefID = type.HEC_Patient_ParameterTypeID; vital.Save(Connection, Transaction); var t2gt = new ORM_HEC_Patient_ParameterType_2_ParameterTypeGroup() { Tenant_RefID = securityTicket.TenantID, AssignmentID = Guid.NewGuid(), HEC_Patient_ParameterType_Group_RefID = groupType.HEC_Patient_ParameterType_GroupID, HEC_Patient_ParameterType_RefID = type.HEC_Patient_ParameterTypeID }; t2gt.Save(Connection, Transaction); var AvaUnit = new ORM_HEC_Patient_ParameterType_AvailableUnit() { Tenant_RefID = securityTicket.TenantID, IsDefaultUnit = true, Patient_ParameterType_RefID = type.HEC_Patient_ParameterTypeID, HEC_Patient_ParameterType_AvailableUnitID = Guid.NewGuid(), Unit_RefID = Parameter.Unit_RefID }; AvaUnit.Save(Connection, Transaction); } return(returnValue); #endregion UserCode }