protected static FR_Guids Execute(DbConnection Connection, DbTransaction Transaction, P_L5DI_SFDS_1352 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guids(); foreach (var catalog in Parameter.SelfLearningData) { var potentialDiagnosisCatalogQuery = new ORM_HEC_DIA_PotentialDiagnosis_Catalog.Query(); potentialDiagnosisCatalogQuery.Tenant_RefID = securityTicket.TenantID; potentialDiagnosisCatalogQuery.IsDeleted = false; potentialDiagnosisCatalogQuery.HEC_DIA_PotentialDiagnosis_CatalogID = catalog.CatalogID; var potentialCatalog = ORM_HEC_DIA_PotentialDiagnosis_Catalog.Query.Search(Connection, Transaction, potentialDiagnosisCatalogQuery).Single(); if (catalog.isSelfLearning) { potentialCatalog.IsUsingSelfLearningPriorities = true; potentialCatalog.SelfLearningPriorities_InitializationTreshold = Int32.Parse(catalog.Initialization_Threshold); potentialCatalog.SelfLearningPriorities_NumberOfPastDaysTakenIntoAccount = Int32.Parse(catalog.FavouriteDiagnoseIntervalinDays); potentialCatalog.Save(Connection, Transaction); } else { potentialCatalog.IsUsingSelfLearningPriorities = false; potentialCatalog.SelfLearningPriorities_InitializationTreshold = 0; potentialCatalog.SelfLearningPriorities_NumberOfPastDaysTakenIntoAccount = 0; potentialCatalog.Save(Connection, Transaction); } } foreach (var diagnose in Parameter.Diagnoses) { var potentionalDiagnosePrioritySequenceQuery = new ORM_HEC_DIA_PotentialDiagnosis_PrioritySequence.Query(); potentionalDiagnosePrioritySequenceQuery.Tenant_RefID = securityTicket.TenantID; potentionalDiagnosePrioritySequenceQuery.IsDeleted = false; potentionalDiagnosePrioritySequenceQuery.HEC_DIA_PotentialDiagnosis_PrioritySequenceID = diagnose.PrioritySequenceID; var potentionalDiagnosePrioritySequence = ORM_HEC_DIA_PotentialDiagnosis_PrioritySequence.Query.Search(Connection, Transaction, potentionalDiagnosePrioritySequenceQuery).Single(); if (!Parameter.SelfLearningData.Where(i => i.CatalogID == potentionalDiagnosePrioritySequence.PotentialDiagnosis_Catalog_RefID).Single().isSelfLearning) { potentionalDiagnosePrioritySequence.PriorityNumber_Manual = Int32.Parse(diagnose.ManualScore); potentionalDiagnosePrioritySequence.PriorityNumber_Automatic = Int32.Parse(diagnose.CalculatedScore); potentionalDiagnosePrioritySequence.Save(Connection, Transaction); } } return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5DI_SDC_1032 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); //get languages for Tenant P_L2LN_GALFTID_1530 langParam = new P_L2LN_GALFTID_1530(); langParam.Tenant_RefID = securityTicket.TenantID; var DBLanguages = cls_Get_All_Languages_ForTenantID.Invoke(Connection, Transaction, langParam, securityTicket).Result; #region Save if (Parameter.CatalogID == Guid.Empty || Parameter.CatalogID == null) { ORM_HEC_DIA_PotentialDiagnosis_Catalog catalog = new ORM_HEC_DIA_PotentialDiagnosis_Catalog(); catalog.HEC_DIA_PotentialDiagnosis_CatalogID = Guid.NewGuid(); catalog.Creation_Timestamp = DateTime.Now; catalog.IsPrivateCatalog = Parameter.IsPrivateCatalog; catalog.Tenant_RefID = securityTicket.TenantID; catalog.GlobalPropertyMatchingID = Parameter.Catalog_Name; catalog.Catalog_DisplayName = Parameter.Catalog_Name; Dict Catalogname = new Dict("hec_dia_potentialdiagnosis_catalogs"); for (int i = 0; i < DBLanguages.Length; i++) { Catalogname.AddEntry(DBLanguages[i].CMN_LanguageID, Parameter.Catalog_Name); } catalog.Catalog_Name = Catalogname; catalog.Save(Connection, Transaction); } #endregion else { //Delete if (Parameter.isDeleted) { var catalogQuery = new ORM_HEC_DIA_PotentialDiagnosis_Catalog.Query(); catalogQuery.HEC_DIA_PotentialDiagnosis_CatalogID = Parameter.CatalogID; catalogQuery.IsDeleted = false; catalogQuery.Tenant_RefID = securityTicket.TenantID; var catalog = ORM_HEC_DIA_PotentialDiagnosis_Catalog.Query.Search(Connection, Transaction, catalogQuery).Single(); catalog.IsDeleted = true; catalog.Save(Connection, Transaction); //Delete catalog products table var catalogCodeQuery = new ORM_HEC_DIA_PotentialDiagnosis_CatalogCode.Query(); catalogCodeQuery.IsDeleted = false; catalogCodeQuery.PotentialDiagnosis_Catalog_RefID = catalog.HEC_DIA_PotentialDiagnosis_CatalogID; catalogCodeQuery.Tenant_RefID = securityTicket.TenantID; ORM_HEC_DIA_PotentialDiagnosis_CatalogCode.Query.SoftDelete(Connection, Transaction, catalogCodeQuery); } //Edit else { var catalogQuery = new ORM_HEC_DIA_PotentialDiagnosis_Catalog.Query(); catalogQuery.IsDeleted = false; catalogQuery.HEC_DIA_PotentialDiagnosis_CatalogID = Parameter.CatalogID; catalogQuery.Tenant_RefID = securityTicket.TenantID; var catalog = ORM_HEC_DIA_PotentialDiagnosis_Catalog.Query.Search(Connection, Transaction, catalogQuery).Single(); catalog.GlobalPropertyMatchingID = Parameter.Catalog_Name; catalog.Catalog_DisplayName = Parameter.Catalog_Name; catalog.IsPrivateCatalog = Parameter.IsPrivateCatalog; Dict Catalogname = new Dict("hec_dia_potentialdiagnosis_catalogs"); for (int i = 0; i < DBLanguages.Length; i++) { Catalogname.AddEntry(DBLanguages[i].CMN_LanguageID, Parameter.Catalog_Name); } catalog.Catalog_Name = Catalogname; catalog.Save(Connection, Transaction); } } return(returnValue); #endregion UserCode }