protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5DG_SDfTIDA_10_32 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
var item = new ORM_HEC_DIA_PotentialDiagnosis();
if (Parameter.HEC_DIA_PotentialDiagnosisID != Guid.Empty)
{
var result = item.Load(Connection, Transaction, Parameter.HEC_DIA_PotentialDiagnosisID);
if (result.Status != FR_Status.Success || item.HEC_DIA_PotentialDiagnosisID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
else
{
item.HEC_DIA_PotentialDiagnosisID = Guid.NewGuid();
returnValue.Result = item.HEC_DIA_PotentialDiagnosisID;
}
if (Parameter.IsDeleted == true)
{
var query_DiagnosisStates_del = new ORM_HEC_DIA_Diagnosis_State.Query();
query_DiagnosisStates_del.Diagnose_RefID = Parameter.HEC_DIA_PotentialDiagnosisID;
var found_DiagnosisStates_del = ORM_HEC_DIA_Diagnosis_State.Query.Search(Connection, Transaction, query_DiagnosisStates_del);
var query_Localizations_del = new ORM_HEC_DIA_Diagnosis_Localization.Query();
query_Localizations_del.Diagnosis_RefID = Parameter.HEC_DIA_PotentialDiagnosisID;
var found_Localizations_del = ORM_HEC_DIA_Diagnosis_Localization.Query.Search(Connection, Transaction, query_Localizations_del);
foreach (var foundState in found_DiagnosisStates_del)
{
foundState.IsDeleted = true;
foundState.Save(Connection, Transaction);
}
foreach (var foundLocalization in found_Localizations_del)
{
foundLocalization.IsDeleted = true;
foundLocalization.Save(Connection, Transaction);
}
item.IsDeleted = true;
return(new FR_Guid(item.Save(Connection, Transaction), item.HEC_DIA_PotentialDiagnosisID));
}
//Save Diagnoses
Dict diagnosis_nameDict = new Dict("hec_dia_potentialdiagnoses");
diagnosis_nameDict = Parameter.PotentialDiagnosis_Name_DictID;
item.Tenant_RefID = securityTicket.TenantID;
item.Creation_Timestamp = DateTime.Now;
item.ICD10_Code = Parameter.ICD10_Code;
//item.PotentialDiagnosis_Name_DictID = diagnosis_nameDict;
item.PotentialDiagnosis_Description = Parameter.PotentialDiagnosis_Description;
item.Save(Connection, Transaction);
// save States
foreach (var stateParam in Parameter.DiagnosisStates)
{
Dict state_nameDict = new Dict("hec_dia_diagnosis_states");
state_nameDict = stateParam.DiagnosisState_Name;
var queryState = new ORM_HEC_DIA_Diagnosis_State.Query();
queryState.HEC_DIA_Diagnosis_StateID = stateParam.HEC_DIA_Diagnosis_StateID;
queryState.Diagnose_RefID = stateParam.Diagnose_RefID;
var stateResult = ORM_HEC_DIA_Diagnosis_State.Query.Search(Connection, Transaction, queryState);
//new State
if (stateResult.Count == 0)
{
var state = new ORM_HEC_DIA_Diagnosis_State();
state.HEC_DIA_Diagnosis_StateID = stateParam.HEC_DIA_Diagnosis_StateID;
Dict abbrev = new Dict();
state.DiagnosisState_Abbreviation = stateParam.DiagnosisState_Abbreviation;
state.DiagnosisState_Name = state_nameDict;
state.Diagnose_RefID = item.HEC_DIA_PotentialDiagnosisID;
state.Creation_Timestamp = DateTime.Now;
state.Tenant_RefID = securityTicket.TenantID;
state.IsDeleted = false;
state.Save(Connection, Transaction);
}
else//edit State
{
if (stateParam.IsDeleted == true)
{
stateResult[0].IsDeleted = true;
stateResult[0].Save(Connection, Transaction);
}
else
{
if (stateResult[0].DiagnosisState_Name != null || Parameter.IsDeleted == true)
{
foreach (var entry in state_nameDict.Contents)
{
stateResult[0].DiagnosisState_Name.UpdateEntry(entry.LanguageID, entry.Content);
}
}
stateResult[0].DiagnosisState_Abbreviation = stateParam.DiagnosisState_Abbreviation;
stateResult[0].Save(Connection, Transaction);
}
}
}
//Diagnosis Localization
foreach (var localizationParam in Parameter.DiagnosisLocalizations)
{
Dict localization_nameDict = new Dict("hec_dia_diagnosis_localizations");
localization_nameDict = localizationParam.DiagnosisLocalization_Name;
var queryLocalization = new ORM_HEC_DIA_Diagnosis_Localization.Query();
queryLocalization.HEC_DIA_Diagnosis_LocalizationID = localizationParam.HEC_DIA_Diagnosis_LocalizationID;
queryLocalization.Diagnosis_RefID = localizationParam.Diagnosis_RefID;
var localizationResult = ORM_HEC_DIA_Diagnosis_Localization.Query.Search(Connection, Transaction, queryLocalization);
if (localizationResult.Count == 0)
{
var localization = new ORM_HEC_DIA_Diagnosis_Localization();
localization.HEC_DIA_Diagnosis_LocalizationID = localizationParam.HEC_DIA_Diagnosis_LocalizationID;
localization.DiagnosisLocalization_Name = localization_nameDict;
localization.Creation_Timestamp = DateTime.Now;
localization.Tenant_RefID = securityTicket.TenantID;
localization.Diagnosis_RefID = item.HEC_DIA_PotentialDiagnosisID;
localization.IsDeleted = false;
localization.Save(Connection, Transaction);
}
else
{
if (localizationParam.IsDeleted == true || Parameter.IsDeleted == true)
{
localizationResult[0].IsDeleted = true;
localizationResult[0].Save(Connection, Transaction);
}
else
{
if (localizationResult[0].DiagnosisLocalization_Name != null)
{
foreach (var entry in localization_nameDict.Contents)
{
localizationResult[0].DiagnosisLocalization_Name.UpdateEntry(entry.LanguageID, entry.Content);
}
}
localizationResult[0].Save(Connection, Transaction);
}
}
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5ME_SL_1047 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#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;
foreach (var item in Parameter.Localization)
{
//Delete
if (item.IsDeleted)
{
var localizationQuery = new ORM_HEC_DIA_Diagnosis_Localization.Query();
localizationQuery.IsDeleted = false;
localizationQuery.HEC_DIA_Diagnosis_LocalizationID = item.LocalizationID;
localizationQuery.Diagnosis_RefID = Parameter.DiagnoseID;
var localization = ORM_HEC_DIA_Diagnosis_Localization.Query.Search(Connection, Transaction, localizationQuery).SingleOrDefault();
if (localization != null)
{
localization.IsDeleted = true;
localization.Save(Connection, Transaction);
}
}
else
{
var localizationQuery = new ORM_HEC_DIA_Diagnosis_Localization.Query();
localizationQuery.IsDeleted = false;
localizationQuery.HEC_DIA_Diagnosis_LocalizationID = item.LocalizationID;
localizationQuery.Diagnosis_RefID = Parameter.DiagnoseID;
var localization = ORM_HEC_DIA_Diagnosis_Localization.Query.Search(Connection, Transaction, localizationQuery).SingleOrDefault();
//Edit
if (localization != null)
{
Dict name = new Dict("hec_dia_diagnosis_localizations");
for (int i = 0; i < DBLanguages.Length; i++)
{
name.AddEntry(DBLanguages[i].CMN_LanguageID, item.LocalizationName);
}
localization.DiagnosisLocalization_Name = name;
localization.Save(Connection, Transaction);
}
else // New
{
ORM_HEC_DIA_Diagnosis_Localization localizationNew = new ORM_HEC_DIA_Diagnosis_Localization();
localizationNew.HEC_DIA_Diagnosis_LocalizationID = item.LocalizationID;
Dict name = new Dict("hec_dia_diagnosis_localizations");
for (int i = 0; i < DBLanguages.Length; i++)
{
name.AddEntry(DBLanguages[i].CMN_LanguageID, item.LocalizationName);
}
localizationNew.DiagnosisLocalization_Name = name;
localizationNew.Tenant_RefID = securityTicket.TenantID;
localizationNew.Creation_Timestamp = DateTime.Now;
localizationNew.Diagnosis_RefID = Parameter.DiagnoseID;
localizationNew.Save(Connection, Transaction);
}
}
}
return(returnValue);
#endregion UserCode
}