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 }
protected static FR_Guids Execute(DbConnection Connection, DbTransaction Transaction, P_MD_SNDaRNIDs_1412[] Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guids(); var allLanguages = cls_Get_All_Languages.Invoke(Connection, Transaction, securityTicket).Result.ToList(); returnValue.Result = Parameter.Select(diag => { var diagnose = cls_Get_DiagnoseID_for_ICD10_and_DiagnoseName.Invoke(Connection, Transaction, new P_MD_GDIDfDN_1408() { DiagnoseICD10 = diag.DiagnoseICD10, DiagnoseNameWithoutSpaces = diag.DiagnoseName.Replace(((char)32).ToString(), string.Empty).Replace(((char)160).ToString(), string.Empty) }, securityTicket).Result; if (diagnose != null) { return(diagnose.DiagnoseID); } else { Dict DiagnoseName = new Dict(ORM_HEC_DIA_PotentialDiagnosis.TableName); for (int i = 0; i < allLanguages.Count; i++) { DiagnoseName.AddEntry(allLanguages[i].CMN_LanguageID, diag.DiagnoseName); } Dict CatalogName = new Dict(ORM_HEC_DIA_PotentialDiagnosis_Catalog.TableName); for (int i = 0; i < allLanguages.Count; i++) { CatalogName.AddEntry(allLanguages[i].CMN_LanguageID, "ICD-10"); } var newDiagnose = new ORM_HEC_DIA_PotentialDiagnosis(); newDiagnose.PotentialDiagnosis_Name = DiagnoseName; newDiagnose.IsDeleted = false; newDiagnose.Tenant_RefID = securityTicket.TenantID; newDiagnose.Creation_Timestamp = DateTime.Now; newDiagnose.Modification_Timestamp = DateTime.Now; newDiagnose.HEC_DIA_PotentialDiagnosisID = Guid.NewGuid(); newDiagnose.Save(Connection, Transaction); var newDiagnoseCatalog = new ORM_HEC_DIA_PotentialDiagnosis_Catalog(); newDiagnoseCatalog.IsDeleted = false; newDiagnoseCatalog.Catalog_DisplayName = "ICD-10"; newDiagnoseCatalog.Tenant_RefID = securityTicket.TenantID; newDiagnoseCatalog.Creation_Timestamp = DateTime.Now; newDiagnoseCatalog.Modification_Timestamp = DateTime.Now; newDiagnoseCatalog.HEC_DIA_PotentialDiagnosis_CatalogID = Guid.NewGuid(); newDiagnoseCatalog.Catalog_Name = CatalogName; newDiagnoseCatalog.Save(Connection, Transaction); var newDiagnose2CatalogCode = new ORM_HEC_DIA_PotentialDiagnosis_CatalogCode(); newDiagnose2CatalogCode.IsDeleted = false; newDiagnose2CatalogCode.Tenant_RefID = securityTicket.TenantID; newDiagnose2CatalogCode.Creation_Timestamp = DateTime.Now; newDiagnose2CatalogCode.Modification_Timestamp = DateTime.Now; newDiagnose2CatalogCode.PotentialDiagnosis_RefID = newDiagnose.HEC_DIA_PotentialDiagnosisID; newDiagnose2CatalogCode.PotentialDiagnosis_Catalog_RefID = newDiagnoseCatalog.HEC_DIA_PotentialDiagnosis_CatalogID; newDiagnose2CatalogCode.Code = diag.DiagnoseICD10; newDiagnose2CatalogCode.Save(Connection, Transaction); return(newDiagnose.HEC_DIA_PotentialDiagnosisID); } }).ToArray(); return(returnValue); #endregion UserCode }