protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6DI_SDD_1202 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); var potentialDiagnoseQuery = new ORM_HEC_DIA_PotentialDiagnosis.Query(); potentialDiagnoseQuery.IsDeleted = false; potentialDiagnoseQuery.Tenant_RefID = securityTicket.TenantID; potentialDiagnoseQuery.HEC_DIA_PotentialDiagnosisID = Parameter.DiagnoseID; var potentialDiagnose = ORM_HEC_DIA_PotentialDiagnosis.Query.Search(Connection, Transaction, potentialDiagnoseQuery).Single(); #region Deactivation in days potentialDiagnose.DefaultTimeUntillDeactivation_InDays = Parameter.Deactivation_inDays; potentialDiagnose.Save(Connection, Transaction); #endregion #region Save Localization List <P_L5ME_SL_1047_Localization> LocalizationList = new List <P_L5ME_SL_1047_Localization>(); foreach (var item in Parameter.Localization) { P_L5ME_SL_1047_Localization param = new P_L5ME_SL_1047_Localization(); param.IsDeleted = item.IsDeleted; param.LocalizationID = item.LocalizationID; param.LocalizationName = item.LocalizationName; LocalizationList.Add(param); } P_L5ME_SL_1047 par = new P_L5ME_SL_1047(); par.DiagnoseID = Parameter.DiagnoseID; par.Localization = LocalizationList.ToArray(); cls_Save_Localization.Invoke(Connection, Transaction, par, securityTicket); #endregion #region Save catalog - diagnose details foreach (var item in Parameter.CatalogDiagnoseData) { var catalogCodeQuery = new ORM_HEC_DIA_PotentialDiagnosis_CatalogCode.Query(); catalogCodeQuery.Tenant_RefID = securityTicket.TenantID; catalogCodeQuery.IsDeleted = false; catalogCodeQuery.PotentialDiagnosis_Catalog_RefID = item.HEC_DIA_PotentialDiagnosis_CatalogID; catalogCodeQuery.PotentialDiagnosis_RefID = Parameter.DiagnoseID; var catalogCode = ORM_HEC_DIA_PotentialDiagnosis_CatalogCode.Query.Search(Connection, Transaction, catalogCodeQuery).SingleOrDefault(); if (item.isDiagnoseAddedToCatalog) { if (catalogCode == null) { catalogCode = new ORM_HEC_DIA_PotentialDiagnosis_CatalogCode(); catalogCode.HEC_DIA_PotentialDiagnosis_CatalogCodeID = Guid.NewGuid(); catalogCode.Tenant_RefID = securityTicket.TenantID; catalogCode.Creation_Timestamp = DateTime.Now; catalogCode.PotentialDiagnosis_Catalog_RefID = item.HEC_DIA_PotentialDiagnosis_CatalogID; catalogCode.PotentialDiagnosis_RefID = Parameter.DiagnoseID; catalogCode.Code = potentialDiagnose.ICD10_Code; catalogCode.Save(Connection, Transaction); //if (item.isFavouriteStatus) //{ // var prioritySequence = new ORM_HEC_DIA_PotentialDiagnosis_PrioritySequence(); // prioritySequence.HEC_DIA_PotentialDiagnosis_PrioritySequenceID = Guid.NewGuid(); // prioritySequence.PotentialDiagnosis_RefID = Parameter.DiagnoseID; // prioritySequence.PotentialDiagnosis_Catalog_RefID = item.HEC_DIA_PotentialDiagnosis_CatalogID; // prioritySequence.Tenant_RefID = securityTicket.TenantID; // prioritySequence.Creation_Timestamp = DateTime.Now; // prioritySequence.Save(Connection, Transaction); //} } //else //{ // var prioritySequenceQuery = new ORM_HEC_DIA_PotentialDiagnosis_PrioritySequence.Query(); // prioritySequenceQuery.IsDeleted = false; // prioritySequenceQuery.Tenant_RefID = securityTicket.TenantID; // prioritySequenceQuery.PotentialDiagnosis_RefID = Parameter.DiagnoseID; // prioritySequenceQuery.PotentialDiagnosis_Catalog_RefID = item.HEC_DIA_PotentialDiagnosis_CatalogID; // var prioritySequence = ORM_HEC_DIA_PotentialDiagnosis_PrioritySequence.Query.Search(Connection, Transaction, prioritySequenceQuery).SingleOrDefault(); // if (item.isFavouriteStatus) // { // if (prioritySequence == null) // { // prioritySequence = new ORM_HEC_DIA_PotentialDiagnosis_PrioritySequence(); // prioritySequence.HEC_DIA_PotentialDiagnosis_PrioritySequenceID = Guid.NewGuid(); // prioritySequence.PotentialDiagnosis_RefID = Parameter.DiagnoseID; // prioritySequence.PotentialDiagnosis_Catalog_RefID = item.HEC_DIA_PotentialDiagnosis_CatalogID; // prioritySequence.Tenant_RefID = securityTicket.TenantID; // prioritySequence.Creation_Timestamp = DateTime.Now; // prioritySequence.Save(Connection, Transaction); // } // } // else // { // if (prioritySequence != null) // { // prioritySequence.IsDeleted = true; // prioritySequence.Save(Connection, Transaction); // } // } //} } else { if (catalogCode != null) { catalogCode.IsDeleted = true; catalogCode.Save(Connection, Transaction); //var prioritySequenceQuery = new ORM_HEC_DIA_PotentialDiagnosis_PrioritySequence.Query(); //prioritySequenceQuery.IsDeleted = false; //prioritySequenceQuery.Tenant_RefID = securityTicket.TenantID; //prioritySequenceQuery.PotentialDiagnosis_RefID = Parameter.DiagnoseID; //prioritySequenceQuery.PotentialDiagnosis_Catalog_RefID = item.HEC_DIA_PotentialDiagnosis_CatalogID; //var prioritySequence = ORM_HEC_DIA_PotentialDiagnosis_PrioritySequence.Query.Search(Connection, Transaction, prioritySequenceQuery).SingleOrDefault(); //if (prioritySequence != null) //{ // prioritySequence.IsDeleted = true; // prioritySequence.Save(Connection, Transaction); //} } } } #endregion #region Save Observation List <P_L5DI_SPO_1452_PotentialObservation> ObservationList = new List <P_L5DI_SPO_1452_PotentialObservation>(); foreach (var item in Parameter.PotentialObservation) { P_L5DI_SPO_1452_PotentialObservation observation = new P_L5DI_SPO_1452_PotentialObservation(); observation.IsDeleted = item.IsDeleted; observation.NewPotentialObservation = item.NewPotentialObservation; observation.Observation_Text = item.Observation_Text; observation.PotentialDiagnosis_RefID = item.PotentialDiagnosis_RefID; observation.PotentialObservationID = item.PotentialObservationID; observation.TypicalPotentialObservationID = item.TypicalPotentialObservationID; ObservationList.Add(observation); } P_L5DI_SPO_1452 observationParam = new P_L5DI_SPO_1452(); observationParam.PotentialObservation = ObservationList.ToArray(); cls_Save_PotentialObservation.Invoke(Connection, Transaction, observationParam, securityTicket); #endregion #region Hospital Referral //List<P_L5DI_SPHR_1208_PossibleHospitalReferral> PossibleReferralList = new List<P_L5DI_SPHR_1208_PossibleHospitalReferral>(); //foreach (var item in Parameter.PossibleHospitalReferral) //{ // P_L5DI_SPHR_1208_PossibleHospitalReferral param = new P_L5DI_SPHR_1208_PossibleHospitalReferral(); // param.HEC_DIA_FrequentPotentialDiagnosisID = item.HEC_DIA_FrequentPotentialDiagnosisID; // param.IsDeleted = item.IsDeleted; // param.MedicalPractice_RefID = item.MedicalPractice_RefID; // param.PotentialDiagnosis_RefID = item.PotentialDiagnosis_RefID; // PossibleReferralList.Add(param); //} //P_L5DI_SPHR_1208 posibleRefealParam = new P_L5DI_SPHR_1208(); //posibleRefealParam.PossibleHospitalReferral = PossibleReferralList.ToArray(); //cls_Save_PossibleHospitalReferral.Invoke(Connection, Transaction, posibleRefealParam, securityTicket); #endregion #region Save Procedure List <P_L5DI_SPP_1242_PotentialProcedures> procedureList = new List <P_L5DI_SPP_1242_PotentialProcedures>(); foreach (var item in Parameter.PotentialProcedures) { P_L5DI_SPP_1242_PotentialProcedures procedure = new P_L5DI_SPP_1242_PotentialProcedures(); procedure.HEC_DIA_TypicalPotentialProcedureID = item.HEC_DIA_TypicalPotentialProcedureID; procedure.IsDeleted = item.IsDeleted; procedure.PotentialDiagnosis_RefID = item.PotentialDiagnosis_RefID; procedure.PotentialProcedure_RefID = item.PotentialProcedure_RefID; procedureList.Add(procedure); } P_L5DI_SPP_1242 procedureParam = new P_L5DI_SPP_1242(); procedureParam.PotentialProcedures = procedureList.ToArray(); cls_Save_PotentialProcedures.Invoke(Connection, Transaction, procedureParam, securityTicket); #endregion #region Save RecommendedSubstance List <P_L5ME_SRS_1512_RecommendedSubstance> RecommendedSubstanceList = new List <P_L5ME_SRS_1512_RecommendedSubstance>(); foreach (var item in Parameter.RecommendedSubstance) { P_L5ME_SRS_1512_RecommendedSubstance substance = new P_L5ME_SRS_1512_RecommendedSubstance(); substance.IsDeleted = item.IsDeleted; substance.DiagnoseID = item.DiagnoseID; substance.SubstanceID = item.SubstanceID; substance.Substance_Unit_RefID = item.Substance_Unit_RefID; substance.SubstanceStrength = item.SubstanceStrength; substance.HEC_DIA_RecommendedSubstanceID = item.HEC_DIA_RecommendedSubstanceID; List <P_L5ME_SRS_1512_DosageList> dosageList = new List <P_L5ME_SRS_1512_DosageList>(); foreach (var subitem in item.SubstanceDosageList) { P_L5ME_SRS_1512_DosageList dosage = new P_L5ME_SRS_1512_DosageList(); dosage.Dosage_RefID = subitem.Dosage_RefID; dosage.HEC_DIA_RecommendedSubstance_DosageID = subitem.HEC_DIA_RecommendedSubstance_DosageID; dosage.IsDefault = subitem.IsDefault; dosage.IsDeleted = subitem.IsDeleted; dosageList.Add(dosage); } substance.DosageList = dosageList.ToArray(); RecommendedSubstanceList.Add(substance); } P_L5ME_SRS_1512 substanceParam = new P_L5ME_SRS_1512(); substanceParam.RecommendedSubstance = RecommendedSubstanceList.ToArray(); cls_Save_RecommendedSubstance.Invoke(Connection, Transaction, substanceParam, securityTicket); #endregion #region Save RecommendedProduct List <P_L5ME_SRP_1317_RecommendedProduct> RecommendedProductList = new List <P_L5ME_SRP_1317_RecommendedProduct>(); foreach (var item in Parameter.RecommendedProduct) { P_L5ME_SRP_1317_RecommendedProduct product = new P_L5ME_SRP_1317_RecommendedProduct(); product.IsDeleted = item.IsDeleted; product.DiagnoseID = item.DiagnoseID; product.ProductID = item.ProductID; product.HEC_DIA_RecommendedProductID = item.HEC_DIA_RecommendedProductID; List <P_L5ME_SRP_1317_DosageList> dosageList = new List <P_L5ME_SRP_1317_DosageList>(); foreach (var subitem in item.ProductDosageList) { P_L5ME_SRP_1317_DosageList dosageParam = new P_L5ME_SRP_1317_DosageList(); dosageParam.Dosage_RefID = subitem.Dosage_RefID; dosageParam.HEC_DIA_RecommendedProduct_DosageID = subitem.HEC_DIA_RecommendedProduct_DosageID; dosageParam.IsDefault = subitem.IsDefault; dosageParam.IsDeleted = subitem.IsDeleted; dosageList.Add(dosageParam); } product.DosageList = dosageList.ToArray(); RecommendedProductList.Add(product); } P_L5ME_SRP_1317 productParam = new P_L5ME_SRP_1317(); productParam.RecommendedProduct = RecommendedProductList.ToArray(); cls_Save_RecommendedProduct.Invoke(Connection, Transaction, productParam, securityTicket); #endregion return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5DI_SD_1633 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); returnValue.Result = Guid.Empty; 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.DiagnoseID == Guid.Empty) { var potentialDiagnosis = new ORM_HEC_DIA_PotentialDiagnosis(); potentialDiagnosis.HEC_DIA_PotentialDiagnosisID = Guid.NewGuid(); potentialDiagnosis.ICD10_Code = Parameter.DiagnoseICD10; Dict name = new Dict("hec_dia_potentialdiagnoses"); for (int i = 0; i < DBLanguages.Length; i++) { name.AddEntry(DBLanguages[i].CMN_LanguageID, Parameter.Name); } potentialDiagnosis.PotentialDiagnosis_Name = name; Dict description = new Dict("hec_dia_potentialdiagnoses"); for (int i = 0; i < DBLanguages.Length; i++) { description.AddEntry(DBLanguages[i].CMN_LanguageID, Parameter.Description); } potentialDiagnosis.PotentialDiagnosis_Description = description; potentialDiagnosis.Tenant_RefID = securityTicket.TenantID; potentialDiagnosis.Creation_Timestamp = DateTime.Now; potentialDiagnosis.Modification_Timestamp = DateTime.Now; potentialDiagnosis.Save(Connection, Transaction); ORM_HEC_DIA_PotentialDiagnosis_CatalogCode catalogCode = new ORM_HEC_DIA_PotentialDiagnosis_CatalogCode(); catalogCode.HEC_DIA_PotentialDiagnosis_CatalogCodeID = Guid.NewGuid(); catalogCode.Code = Parameter.DiagnoseICD10; catalogCode.PotentialDiagnosis_RefID = potentialDiagnosis.HEC_DIA_PotentialDiagnosisID; catalogCode.PotentialDiagnosis_Catalog_RefID = Parameter.PotentialDiagnosis_CatalogID; catalogCode.Tenant_RefID = securityTicket.TenantID; catalogCode.Save(Connection, Transaction); returnValue.Result = potentialDiagnosis.HEC_DIA_PotentialDiagnosisID; } #endregion else { var potentialDiagnosisQuery = new ORM_HEC_DIA_PotentialDiagnosis.Query(); potentialDiagnosisQuery.IsDeleted = false; potentialDiagnosisQuery.HEC_DIA_PotentialDiagnosisID = Parameter.DiagnoseID; var potentialDiagnosis = ORM_HEC_DIA_PotentialDiagnosis.Query.Search(Connection, Transaction, potentialDiagnosisQuery).Single(); #region Delete if (Parameter.IsDeleted) { ORM_HEC_DIA_PotentialDiagnosis_CatalogCode catalogCode = ORM_HEC_DIA_PotentialDiagnosis_CatalogCode.Query.Search(Connection, Transaction, new ORM_HEC_DIA_PotentialDiagnosis_CatalogCode.Query { PotentialDiagnosis_RefID = potentialDiagnosis.HEC_DIA_PotentialDiagnosisID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }).Single(); catalogCode.IsDeleted = false; catalogCode.Save(Connection, Transaction); potentialDiagnosis.IsDeleted = true; potentialDiagnosis.Save(Connection, Transaction); } #endregion #region Edit else { potentialDiagnosis.ICD10_Code = Parameter.DiagnoseICD10; Dict name = new Dict("hec_dia_potentialdiagnoses"); for (int i = 0; i < DBLanguages.Length; i++) { name.AddEntry(DBLanguages[i].CMN_LanguageID, Parameter.Name); } potentialDiagnosis.PotentialDiagnosis_Name = name; Dict description = new Dict("hec_dia_potentialdiagnoses"); for (int i = 0; i < DBLanguages.Length; i++) { description.AddEntry(DBLanguages[i].CMN_LanguageID, Parameter.Description); } potentialDiagnosis.PotentialDiagnosis_Description = description; potentialDiagnosis.Modification_Timestamp = DateTime.Now; potentialDiagnosis.Save(Connection, Transaction); } returnValue.Result = potentialDiagnosis.HEC_DIA_PotentialDiagnosisID; #endregion } 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 }