protected static FR_L6DI_GDDfDID_1106 Execute(DbConnection Connection, DbTransaction Transaction, P_L6DI_GDDfDID_1106 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L6DI_GDDfDID_1106();
returnValue.Result = new L6DI_GDDfDID_1106();
L5DI_GDfDID_1102 diagnosisData = new L5DI_GDfDID_1102();
returnValue.Result.DiagnosesData = diagnosisData;
List <L6DI_GDDfDID_1106_CatalogData> catalogDataList = new List <L6DI_GDDfDID_1106_CatalogData>();
returnValue.Result.CatalogData = catalogDataList.ToArray();
List <L5DI_GLfDID_1731> localizationList = new List <L5DI_GLfDID_1731>();
returnValue.Result.Localization = localizationList.ToArray();
List <L5DI_GPOfDID_1216> observationList = new List <L5DI_GPOfDID_1216>();
returnValue.Result.Observation_for_DiagnoseID = observationList.ToArray();
List <L5DI_GPHRfDID_1139> hospitalReferalList = new List <L5DI_GPHRfDID_1139>();
returnValue.Result.HospitalReferral = hospitalReferalList.ToArray();
List <L5DI_GPPfDID_1239> procedureList = new List <L5DI_GPPfDID_1239>();
returnValue.Result.Procedures = procedureList.ToArray();
List <L5ME_GRPfPDID_1202> recommendedProductList = new List <L5ME_GRPfPDID_1202>();
returnValue.Result.RecommendedProduct = recommendedProductList.ToArray();
List <L5ME_GRSfPDID_1506> recommendedSubstancesList = new List <L5ME_GRSfPDID_1506>();
returnValue.Result.RecommendedSubstances = recommendedSubstancesList.ToArray();
/*@
*
* Get diagnosisData
* ************************************/
P_L5DI_GDfDID_1102 param = new P_L5DI_GDfDID_1102();
param.DiagnosisID = Parameter.DiagnosisID;
returnValue.Result.DiagnosesData = cls_Get_Diagnosis_for_DiagnosisID.Invoke(Connection, Transaction, param, securityTicket).Result;
/*@
*
* Get all catalogs
* ************************************/
var allCatalogs = cls_Get_DiagnosesCatalog_for_TenantID.Invoke(Connection, Transaction, securityTicket).Result.ToList();
/*@
*
* Get catalog Data for diagnose id
* ************************************/
P_L5DI_GCDfDID__1606 catalogParam = new P_L5DI_GCDfDID__1606();
catalogParam.DiagnoseID = Parameter.DiagnosisID;
var dataForCatalogsList = cls_Get_CatalogData_for_DiagnoseID.Invoke(Connection, Transaction, catalogParam, securityTicket).Result.ToList();
foreach (var catalog in allCatalogs)
{
L6DI_GDDfDID_1106_CatalogData catalogData = new L6DI_GDDfDID_1106_CatalogData();
catalogData.Catalog_Name = catalog.Catalog_DisplayName;
catalogData.HEC_DIA_PotentialDiagnosis_CatalogID = catalog.HEC_DIA_PotentialDiagnosis_CatalogID;
var neededData = dataForCatalogsList.Where(i => i.HEC_DIA_PotentialDiagnosis_CatalogID == catalog.HEC_DIA_PotentialDiagnosis_CatalogID).SingleOrDefault();
if (neededData != null)
{
catalogData.isDiagnoseAddedToCatalog = true;
//if (neededData.HEC_DIA_PotentialDiagnosis_PrioritySequenceID != null && neededData.HEC_DIA_PotentialDiagnosis_PrioritySequenceID != Guid.Empty)
// catalogData.isFavouriteStatus = true;
}
catalogDataList.Add(catalogData);
}
returnValue.Result.CatalogData = catalogDataList.ToArray();
/*@
*
* Get Localization for diagnose id
* ************************************/
P_L5DI_GLfDID_1731 localizationParam = new P_L5DI_GLfDID_1731();
localizationParam.DiagnosisID = Parameter.DiagnosisID;
returnValue.Result.Localization = cls_Get_Localization_for_DiagnosisID.Invoke(Connection, Transaction, localizationParam, securityTicket).Result;
/*@
*
* Get Observation for diagnose id
* ************************************/
P_L5DI_GPOfDID_1216 observationParam = new P_L5DI_GPOfDID_1216();
observationParam.DiagnosisID = Parameter.DiagnosisID;
returnValue.Result.Observation_for_DiagnoseID = cls_Get_PotentialObservation_for_DiagnosisID.Invoke(Connection, Transaction, observationParam, securityTicket).Result;
/*@
*
* Get HospitalReferral for diagnose id
* ************************************/
//P_L5DI_GPHRfDID_1139 hospitalReferalParam = new P_L5DI_GPHRfDID_1139();
//hospitalReferalParam.DiagnosisID = Parameter.DiagnosisID;
//returnValue.Result.HospitalReferral = cls_Get_PossibleHospitalReferral_for_DiagnosisID.Invoke(Connection, Transaction, hospitalReferalParam, securityTicket).Result;
/*@
*
* Get Procedures for diagnose id
* ************************************/
P_L5DI_GPPfDID_1239 procedureParam = new P_L5DI_GPPfDID_1239();
procedureParam.DiagnosisID = Parameter.DiagnosisID;
returnValue.Result.Procedures = cls_Get_PotentialProcedures_for_DiagnosisID.Invoke(Connection, Transaction, procedureParam, securityTicket).Result;
/*@
*
* Get RecommendedSubstances for diagnose id
* ************************************/
P_L5ME_GRSfPDID_1506 recommendedSubstancesParam = new P_L5ME_GRSfPDID_1506();
recommendedSubstancesParam.PotentialDiagnosisID = Parameter.DiagnosisID;
returnValue.Result.RecommendedSubstances = cls_Get_RecommendedSubstances_for_PotentialDiagnosisID.Invoke(Connection, Transaction, recommendedSubstancesParam, securityTicket).Result;
/*@
*
* Get RecommendedProduct for diagnose id
* ************************************/
P_L5ME_GRPfPDID_1202 recommendedProductParam = new P_L5ME_GRPfPDID_1202();
recommendedProductParam.DiagnosisID = Parameter.DiagnosisID;
returnValue.Result.RecommendedProduct = cls_Get_RecommendedProduct_for_PotentialDiagnosisID.Invoke(Connection, Transaction, recommendedProductParam, securityTicket).Result;
return(returnValue);
#endregion UserCode
}
///<summary>
/// Invokes the method for the given Connection, and Transaction, leaving them open/not commited if no exceptions occured
///<summary>
public static FR_L6DI_GDDfDID_1106 Invoke(DbConnection Connection, DbTransaction Transaction, P_L6DI_GDDfDID_1106 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
return(Invoke(Connection, Transaction, null, Parameter, securityTicket));
}
///<summary>
/// Method Invocation of wrapper classes
///<summary>
protected static FR_L6DI_GDDfDID_1106 Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_L6DI_GDDfDID_1106 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
bool cleanupConnection = Connection == null;
bool cleanupTransaction = Transaction == null;
FR_L6DI_GDDfDID_1106 functionReturn = new FR_L6DI_GDDfDID_1106();
try
{
if (cleanupConnection == true)
{
Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString);
Connection.Open();
}
if (cleanupTransaction == true)
{
Transaction = Connection.BeginTransaction();
}
functionReturn = Execute(Connection, Transaction, Parameter, securityTicket);
#region Cleanup Connection/Transaction
//Commit the transaction
if (cleanupTransaction == true)
{
Transaction.Commit();
}
//Close the connection
if (cleanupConnection == true)
{
Connection.Close();
}
#endregion
}
catch (Exception ex)
{
try
{
if (cleanupTransaction == true && Transaction != null)
{
Transaction.Rollback();
}
}
catch { }
try
{
if (cleanupConnection == true && Connection != null)
{
Connection.Close();
}
}
catch { }
throw new Exception("Exception occured in method cls_Get_DiagnosisData_for_DiagnosisID", ex);
}
return(functionReturn);
}
///<summary>
/// Opens the connection/transaction for the given connectionString, and closes them when complete
///<summary>
public static FR_L6DI_GDDfDID_1106 Invoke(string ConnectionString, P_L6DI_GDDfDID_1106 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
return(Invoke(null, null, ConnectionString, Parameter, securityTicket));
}
