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
}
