protected static FR_L3_PTfT_1429_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L3_PTfT_1429 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L3_PTfT_1429_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CLE_L3_PatientParameters.Atomic.Retrieval.SQL.cls_ParameterTypes_for_Tenant.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Tenant", Parameter.Tenant); List <L3_PTfT_1429> results = new List <L3_PTfT_1429>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "HEC_Patient_ParameterID", "PatientParameterITL", "GlobalPropertyMatchingID", "Parameter_Name_DictID", "IsFloat", "IsFloat_ApplicableUnit_RefID", "IsString", "IsVitalParameter", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "HasHighRelevance", "Modification_Timestamp", "ParameterType_RefID", "HEC_Patient_ParameterTypeID", "GlobalPropertyMatchingIDParameterTypes", "Name_DictID", "Creation_TimestampParameterTypes", "IsDeletedParameterTypes", "Modification_TimestampParameterTypes", "IfFloat_MinValue", "IfFloat_MaxValue" }); while (reader.Read()) { L3_PTfT_1429 resultItem = new L3_PTfT_1429(); //0:Parameter HEC_Patient_ParameterID of type Guid resultItem.HEC_Patient_ParameterID = reader.GetGuid(0); //1:Parameter PatientParameterITL of type String resultItem.PatientParameterITL = reader.GetString(1); //2:Parameter GlobalPropertyMatchingID of type String resultItem.GlobalPropertyMatchingID = reader.GetString(2); //3:Parameter Parameter_Name of type Dict resultItem.Parameter_Name = reader.GetDictionary(3); resultItem.Parameter_Name.SourceTable = "hec_patient_parameters"; loader.Append(resultItem.Parameter_Name); //4:Parameter IsFloat of type bool resultItem.IsFloat = reader.GetBoolean(4); //5:Parameter IsFloat_ApplicableUnit_RefID of type Guid resultItem.IsFloat_ApplicableUnit_RefID = reader.GetGuid(5); //6:Parameter IsString of type bool resultItem.IsString = reader.GetBoolean(6); //7:Parameter IsVitalParameter of type bool resultItem.IsVitalParameter = reader.GetBoolean(7); //8:Parameter Creation_Timestamp of type DateTime resultItem.Creation_Timestamp = reader.GetDate(8); //9:Parameter Tenant_RefID of type Guid resultItem.Tenant_RefID = reader.GetGuid(9); //10:Parameter IsDeleted of type bool resultItem.IsDeleted = reader.GetBoolean(10); //11:Parameter HasHighRelevance of type bool resultItem.HasHighRelevance = reader.GetBoolean(11); //12:Parameter Modification_Timestamp of type DateTime resultItem.Modification_Timestamp = reader.GetDate(12); //13:Parameter ParameterType_RefID of type Guid resultItem.ParameterType_RefID = reader.GetGuid(13); //14:Parameter HEC_Patient_ParameterTypeID of type Guid resultItem.HEC_Patient_ParameterTypeID = reader.GetGuid(14); //15:Parameter GlobalPropertyMatchingIDParameterTypes of type String resultItem.GlobalPropertyMatchingIDParameterTypes = reader.GetString(15); //16:Parameter Name of type Dict resultItem.Name = reader.GetDictionary(16); resultItem.Name.SourceTable = "hec_patient_parametertypes"; loader.Append(resultItem.Name); //17:Parameter Creation_TimestampParameterTypes of type DateTime resultItem.Creation_TimestampParameterTypes = reader.GetDate(17); //18:Parameter IsDeletedParameterTypes of type bool resultItem.IsDeletedParameterTypes = reader.GetBoolean(18); //19:Parameter Modification_TimestampParameterTypes of type DateTime resultItem.Modification_TimestampParameterTypes = reader.GetDate(19); //20:Parameter IfFloat_MinValue of type double resultItem.IfFloat_MinValue = reader.GetDouble(20); //21:Parameter IfFloat_MaxValue of type double resultItem.IfFloat_MaxValue = reader.GetDouble(21); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_ParameterTypes_for_Tenant", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.ToArray(); return(returnStatus); }
protected FR_Base Save(DbConnection Connection, DbTransaction Transaction, string ConnectionString) { //Standard return type FR_Base retStatus = new FR_Base(); bool cleanupConnection = false; bool cleanupTransaction = false; try { bool saveDictionary = false; bool saveORMClass = !Status_IsAlreadySaved || Status_IsDirty; //If Status Is Dirty (Meaning the data has been changed) or Status_IsAlreadySaved (Meaning the data is in the database, when loaded) just return if (saveORMClass == false && saveDictionary == false) { return(FR_Base.Status_OK); } #region Verify/Create Connections //Create Connection if Connection is null if (Connection == null) { cleanupConnection = true; Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString); Connection.Open(); } //Create Transaction if null if (Transaction == null) { cleanupTransaction = true; Transaction = Connection.BeginTransaction(); } #endregion #region Dictionary Management //Save dictionary management if (saveDictionary == true) { var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); //Save the dictionary or update based on if it has already been saved to the database if (Status_IsAlreadySaved) { loader.Update(); } else { loader.Save(); } } #endregion #region Command Execution if (saveORMClass == true) { //Retrieve Querry string Query = ""; if (Status_IsAlreadySaved == true) { Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_RES_BLD.RES_BLD_Building.SQL.Update.sql")).ReadToEnd(); } else { Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_RES_BLD.RES_BLD_Building.SQL.Insert.sql")).ReadToEnd(); } DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; command.CommandText = Query; command.CommandTimeout = QueryTimeout; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "RES_BLD_BuildingID", _RES_BLD_BuildingID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_CurrentAverageRentPrice_per_sqm_RefID", _Building_CurrentAverageRentPrice_per_sqm_RefID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "BuildingRevisionHeader_RefID", _BuildingRevisionHeader_RefID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_BalconyPortionPercent", _Building_BalconyPortionPercent); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_Name", _Building_Name); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_DocumentationStructure_RefID", _Building_DocumentationStructure_RefID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsContaminationSuspected", _IsContaminationSuspected); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_NumberOfFloors", _Building_NumberOfFloors); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_ElevatorCoveragePercent", _Building_ElevatorCoveragePercent); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_NumberOfAppartments", _Building_NumberOfAppartments); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_NumberOfOccupiedAppartments", _Building_NumberOfOccupiedAppartments); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_NumberOfOffices", _Building_NumberOfOffices); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_NumberOfRetailUnits", _Building_NumberOfRetailUnits); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_NumberOfProductionUnits", _Building_NumberOfProductionUnits); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_NumberOfOtherUnits", _Building_NumberOfOtherUnits); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Creation_Timestamp", _Creation_Timestamp); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsDeleted", _IsDeleted); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Tenant_RefID", _Tenant_RefID); try { var dbChangeCount = command.ExecuteNonQuery(); Status_IsAlreadySaved = true; Status_IsDirty = false; } catch (Exception ex) { throw ex; } #endregion #region Cleanup Transaction/Connection //If we started the transaction, we will commit it if (cleanupTransaction && Transaction != null) { Transaction.Commit(); } //If we opened the connection we will close it if (cleanupConnection && Connection != null) { 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 ex; } return(retStatus); }
private static List <ORM_RES_BLD_Building> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction) { CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection(); List <ORM_RES_BLD_Building> items; try { managedConnection.set(connectionString, connection, transaction); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(managedConnection.getConnection(), managedConnection.getTransaction()); DbCommand command = managedConnection.manage(query.CreateSelectQuery(TableName)); query.SetParameters(command); items = new List <ORM_RES_BLD_Building>(); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "RES_BLD_BuildingID", "Building_CurrentAverageRentPrice_per_sqm_RefID", "BuildingRevisionHeader_RefID", "Building_BalconyPortionPercent", "Building_Name", "Building_DocumentationStructure_RefID", "IsContaminationSuspected", "Building_NumberOfFloors", "Building_ElevatorCoveragePercent", "Building_NumberOfAppartments", "Building_NumberOfOccupiedAppartments", "Building_NumberOfOffices", "Building_NumberOfRetailUnits", "Building_NumberOfProductionUnits", "Building_NumberOfOtherUnits", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" }); while (reader.Read()) { ORM_RES_BLD_Building item = new ORM_RES_BLD_Building(); //0:Parameter RES_BLD_BuildingID of type Guid item.RES_BLD_BuildingID = reader.GetGuid(0); //1:Parameter Building_CurrentAverageRentPrice_per_sqm_RefID of type Guid item.Building_CurrentAverageRentPrice_per_sqm_RefID = reader.GetGuid(1); //2:Parameter BuildingRevisionHeader_RefID of type Guid item.BuildingRevisionHeader_RefID = reader.GetGuid(2); //3:Parameter Building_BalconyPortionPercent of type double item.Building_BalconyPortionPercent = reader.GetDouble(3); //4:Parameter Building_Name of type String item.Building_Name = reader.GetString(4); //5:Parameter Building_DocumentationStructure_RefID of type Guid item.Building_DocumentationStructure_RefID = reader.GetGuid(5); //6:Parameter IsContaminationSuspected of type Boolean item.IsContaminationSuspected = reader.GetBoolean(6); //7:Parameter Building_NumberOfFloors of type int item.Building_NumberOfFloors = reader.GetInteger(7); //8:Parameter Building_ElevatorCoveragePercent of type double item.Building_ElevatorCoveragePercent = reader.GetDouble(8); //9:Parameter Building_NumberOfAppartments of type int item.Building_NumberOfAppartments = reader.GetInteger(9); //10:Parameter Building_NumberOfOccupiedAppartments of type int item.Building_NumberOfOccupiedAppartments = reader.GetInteger(10); //11:Parameter Building_NumberOfOffices of type int item.Building_NumberOfOffices = reader.GetInteger(11); //12:Parameter Building_NumberOfRetailUnits of type int item.Building_NumberOfRetailUnits = reader.GetInteger(12); //13:Parameter Building_NumberOfProductionUnits of type int item.Building_NumberOfProductionUnits = reader.GetInteger(13); //14:Parameter Building_NumberOfOtherUnits of type int item.Building_NumberOfOtherUnits = reader.GetInteger(14); //15:Parameter Creation_Timestamp of type DateTime item.Creation_Timestamp = reader.GetDate(15); //16:Parameter IsDeleted of type Boolean item.IsDeleted = reader.GetBoolean(16); //17:Parameter Tenant_RefID of type Guid item.Tenant_RefID = reader.GetGuid(17); item.Status_IsAlreadySaved = true; item.Status_IsDirty = false; items.Add(item); } reader.Close(); loader.Load(); managedConnection.commit(); } catch (Exception ex) { managedConnection.rollback(); throw ex; } return(items); }
protected FR_Base Save(DbConnection Connection, DbTransaction Transaction, string ConnectionString) { //Standard return type FR_Base retStatus = new FR_Base(); bool cleanupConnection = false; bool cleanupTransaction = false; try { bool saveDictionary = false; bool saveORMClass = !Status_IsAlreadySaved || Status_IsDirty; //If Status Is Dirty (Meaning the data has been changed) or Status_IsAlreadySaved (Meaning the data is in the database, when loaded) just return if (saveORMClass == false && saveDictionary == false) { return(FR_Base.Status_OK); } #region Verify/Create Connections //Create Connection if Connection is null if (Connection == null) { cleanupConnection = true; Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString); Connection.Open(); } //Create Transaction if null if (Transaction == null) { cleanupTransaction = true; Transaction = Connection.BeginTransaction(); } #endregion #region Dictionary Management //Save dictionary management if (saveDictionary == true) { var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); //Save the dictionary or update based on if it has already been saved to the database if (Status_IsAlreadySaved) { loader.Update(); } else { loader.Save(); } } #endregion #region Command Execution if (saveORMClass == true) { //Retrieve Querry string Query = ""; if (Status_IsAlreadySaved == true) { Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_DOC.DOC_DocumentTemplate_2_BusinessParticipant.SQL.Update.sql")).ReadToEnd(); } else { Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_DOC.DOC_DocumentTemplate_2_BusinessParticipant.SQL.Insert.sql")).ReadToEnd(); } DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; command.CommandText = Query; command.CommandTimeout = QueryTimeout; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "AssignmentID", _AssignmentID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "DOC_DocumentTemplate_Instance_RefID", _DOC_DocumentTemplate_Instance_RefID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CMN_BPT_BusinessParticipant_RefID", _CMN_BPT_BusinessParticipant_RefID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Creation_Timestamp", _Creation_Timestamp); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Tenant_RefID", _Tenant_RefID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsDeleted", _IsDeleted); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Modification_Timestamp", _Modification_Timestamp); try { var dbChangeCount = command.ExecuteNonQuery(); Status_IsAlreadySaved = true; Status_IsDirty = false; } catch (Exception ex) { throw; } #endregion #region Cleanup Transaction/Connection //If we started the transaction, we will commit it if (cleanupTransaction && Transaction != null) { Transaction.Commit(); } //If we opened the connection we will close it if (cleanupConnection && Connection != null) { 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; } return(retStatus); }
protected static FR_L5AI_GPOHfA_1434_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5AI_GPOHfA_1434 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5AI_GPOHfA_1434_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_APOAdmin_ArticlesInfo.Atomic.Retrieval.SQL.cls_Get_ProcurementOrder_History_for_ArticleID.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ArticleID", Parameter.ArticleID); List <L5AI_GPOHfA_1434> results = new List <L5AI_GPOHfA_1434>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "ProcurementOrder_Number", "Position_ValuePerUnit", "Position_Quantity", "Supplier", "Creator", "Position_RequestedDateOfDelivery", "ExpectedDeliveryDate", "TakenIntoStock_AtDate", "IsTakenIntoStock" }); while (reader.Read()) { L5AI_GPOHfA_1434 resultItem = new L5AI_GPOHfA_1434(); //0:Parameter ProcurementOrder_Number of type String resultItem.ProcurementOrder_Number = reader.GetString(0); //1:Parameter Position_ValuePerUnit of type decimal resultItem.Position_ValuePerUnit = reader.GetDecimal(1); //2:Parameter Position_Quantity of type String resultItem.Position_Quantity = reader.GetString(2); //3:Parameter Supplier of type String resultItem.Supplier = reader.GetString(3); //4:Parameter Creator of type String resultItem.Creator = reader.GetString(4); //5:Parameter Position_RequestedDateOfDelivery of type DateTime resultItem.Position_RequestedDateOfDelivery = reader.GetDate(5); //6:Parameter ExpectedDeliveryDate of type DateTime resultItem.ExpectedDeliveryDate = reader.GetDate(6); //7:Parameter TakenIntoStock_AtDate of type DateTime resultItem.TakenIntoStock_AtDate = reader.GetDate(7); //8:Parameter IsTakenIntoStock of type bool resultItem.IsTakenIntoStock = reader.GetBoolean(8); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_ProcurementOrder_History_for_ArticleID", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.ToArray(); return(returnStatus); }
protected static FR_L3DAC_RACDfT_1423_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L3DAC_RACDfT_1423_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL3_DeviceAccountCodes.Atomic.Retrieval.SQL.cls_Retrive_Account_Code_Details_forTenant.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; List <L3DAC_RACDfT_1423> results = new List <L3DAC_RACDfT_1423>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "Account_RefID", "USR_Device_AccountCodeID", "AccountCode_Value", "AccountCode_ValidFrom", "AccountCode_ValidTo", "IsAccountCode_Expirable", "AccountCode_CurrentStatus_RefID", "AccountCode_NumberOfAccesses_MaximumValue", "AccountCode_NumberOfAccesses_CurrentValue", "Tenant_RefID", "BusinessParticipant_RefID" }); while (reader.Read()) { L3DAC_RACDfT_1423 resultItem = new L3DAC_RACDfT_1423(); //0:Parameter Account_RefID of type Guid resultItem.Account_RefID = reader.GetGuid(0); //1:Parameter USR_Device_AccountCodeID of type Guid resultItem.USR_Device_AccountCodeID = reader.GetGuid(1); //2:Parameter AccountCode_Value of type String resultItem.AccountCode_Value = reader.GetString(2); //3:Parameter AccountCode_ValidFrom of type DateTime resultItem.AccountCode_ValidFrom = reader.GetDate(3); //4:Parameter AccountCode_ValidTo of type DateTime resultItem.AccountCode_ValidTo = reader.GetDate(4); //5:Parameter IsAccountCode_Expirable of type bool resultItem.IsAccountCode_Expirable = reader.GetBoolean(5); //6:Parameter AccountCode_CurrentStatus_RefID of type Guid resultItem.AccountCode_CurrentStatus_RefID = reader.GetGuid(6); //7:Parameter AccountCode_NumberOfAccesses_MaximumValue of type String resultItem.AccountCode_NumberOfAccesses_MaximumValue = reader.GetString(7); //8:Parameter AccountCode_NumberOfAccesses_CurrentValue of type String resultItem.AccountCode_NumberOfAccesses_CurrentValue = reader.GetString(8); //9:Parameter Tenant_RefID of type Guid resultItem.Tenant_RefID = reader.GetGuid(9); //10:Parameter BusinessParticipant_RefID of type Guid resultItem.BusinessParticipant_RefID = reader.GetGuid(10); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Retrive_Account_Code_Details_forTenant", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.ToArray(); return(returnStatus); }
private static List <ORM_HEC_Patient_Prescription_Transaction> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction) { CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection(); List <ORM_HEC_Patient_Prescription_Transaction> items; try { managedConnection.set(connectionString, connection, transaction); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(managedConnection.getConnection(), managedConnection.getTransaction()); DbCommand command = managedConnection.manage(query.CreateSelectQuery(TableName)); query.SetParameters(command); items = new List <ORM_HEC_Patient_Prescription_Transaction>(); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "HEC_Patient_Prescription_TransactionID", "PerscriptionTransaction_DeliveryAddress_RefID", "PrescriptionTransaction_Patient_RefID", "PrescriptionTransaction_InternalNubmer", "PrescriptionTransaction_IsComplete", "PrescriptionTransaction_RequestedDateOfDeliveryFrom", "PrescriptionTransaction_RequestedDateOfDeliveryTo", "PrescriptionTransaction_CreatedByBusinessParticpant_RefID", "PrescriptionTransaction_Comment", "PrescriptionTransaction_UsePatientAddress", "PrescriptionTransaction_UseReceiptAddress", "PrescriptionTransaction_UseParticipationPolicyAddress", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" }); while (reader.Read()) { ORM_HEC_Patient_Prescription_Transaction item = new ORM_HEC_Patient_Prescription_Transaction(); //0:Parameter HEC_Patient_Prescription_TransactionID of type Guid item.HEC_Patient_Prescription_TransactionID = reader.GetGuid(0); //1:Parameter PerscriptionTransaction_DeliveryAddress_RefID of type Guid item.PerscriptionTransaction_DeliveryAddress_RefID = reader.GetGuid(1); //2:Parameter PrescriptionTransaction_Patient_RefID of type Guid item.PrescriptionTransaction_Patient_RefID = reader.GetGuid(2); //3:Parameter PrescriptionTransaction_InternalNubmer of type String item.PrescriptionTransaction_InternalNubmer = reader.GetString(3); //4:Parameter PrescriptionTransaction_IsComplete of type Boolean item.PrescriptionTransaction_IsComplete = reader.GetBoolean(4); //5:Parameter PrescriptionTransaction_RequestedDateOfDeliveryFrom of type DateTime item.PrescriptionTransaction_RequestedDateOfDeliveryFrom = reader.GetDate(5); //6:Parameter PrescriptionTransaction_RequestedDateOfDeliveryTo of type DateTime item.PrescriptionTransaction_RequestedDateOfDeliveryTo = reader.GetDate(6); //7:Parameter PrescriptionTransaction_CreatedByBusinessParticpant_RefID of type Guid item.PrescriptionTransaction_CreatedByBusinessParticpant_RefID = reader.GetGuid(7); //8:Parameter PrescriptionTransaction_Comment of type String item.PrescriptionTransaction_Comment = reader.GetString(8); //9:Parameter PrescriptionTransaction_UsePatientAddress of type Boolean item.PrescriptionTransaction_UsePatientAddress = reader.GetBoolean(9); //10:Parameter PrescriptionTransaction_UseReceiptAddress of type Boolean item.PrescriptionTransaction_UseReceiptAddress = reader.GetBoolean(10); //11:Parameter PrescriptionTransaction_UseParticipationPolicyAddress of type Boolean item.PrescriptionTransaction_UseParticipationPolicyAddress = reader.GetBoolean(11); //12:Parameter Creation_Timestamp of type DateTime item.Creation_Timestamp = reader.GetDate(12); //13:Parameter IsDeleted of type Boolean item.IsDeleted = reader.GetBoolean(13); //14:Parameter Tenant_RefID of type Guid item.Tenant_RefID = reader.GetGuid(14); item.Status_IsAlreadySaved = true; item.Status_IsDirty = false; items.Add(item); } reader.Close(); loader.Load(); managedConnection.commit(); } catch (Exception ex) { managedConnection.rollback(); throw ex; } return(items); }
protected static FR_L3CA_GPfPG_0958_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L3CA_GPfPG_0958 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L3CA_GPfPG_0958_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL3_APOCatalog.Atomic.Retrieval.SQL.cls_Get_Products_for_ProductGroup.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ProductGroupID", Parameter.ProductGroupID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CatalogRevisionID", Parameter.CatalogRevisionID); List <L3CA_GPfPG_0958> results = new List <L3CA_GPfPG_0958>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "CMN_PRO_Catalog_ProductGroup_RefID", "IsDeleted", "Tenant_RefID", "IsDeleted1", "CMN_PRO_Catalog_ProductID", "CMN_PRO_Product_RefID", "Product_Name_DictID", "PackageContent_Amount", "PackageContent_DisplayLabel", "Product_Number", "Label_DictID", "Abbreviation_DictID", "ISOCode", "DosageForm_Name_DictID", "DosageForm_Description_DictID", "GlobalPropertyMatchingID" }); while (reader.Read()) { L3CA_GPfPG_0958 resultItem = new L3CA_GPfPG_0958(); //0:Parameter CMN_PRO_Catalog_ProductGroup_RefID of type Guid resultItem.CMN_PRO_Catalog_ProductGroup_RefID = reader.GetGuid(0); //1:Parameter IsDeleted of type bool resultItem.IsDeleted = reader.GetBoolean(1); //2:Parameter Tenant_RefID of type Guid resultItem.Tenant_RefID = reader.GetGuid(2); //3:Parameter IsDeleted1 of type bool resultItem.IsDeleted1 = reader.GetBoolean(3); //4:Parameter CMN_PRO_Catalog_ProductID of type Guid resultItem.CMN_PRO_Catalog_ProductID = reader.GetGuid(4); //5:Parameter CMN_PRO_Product_RefID of type Guid resultItem.CMN_PRO_Product_RefID = reader.GetGuid(5); //6:Parameter Product_Name of type Dict resultItem.Product_Name = reader.GetDictionary(6); resultItem.Product_Name.SourceTable = "cmn_pro_products"; loader.Append(resultItem.Product_Name); //7:Parameter PackageContent_Amount of type Decimal resultItem.PackageContent_Amount = reader.GetDecimal(7); //8:Parameter PackageContent_DisplayLabel of type String resultItem.PackageContent_DisplayLabel = reader.GetString(8); //9:Parameter Product_Number of type String resultItem.Product_Number = reader.GetString(9); //10:Parameter Label_DictID of type Dict resultItem.Label_DictID = reader.GetDictionary(10); resultItem.Label_DictID.SourceTable = "cmn_units"; loader.Append(resultItem.Label_DictID); //11:Parameter Abbreviation_DictID of type Dict resultItem.Abbreviation_DictID = reader.GetDictionary(11); resultItem.Abbreviation_DictID.SourceTable = "cmn_units"; loader.Append(resultItem.Abbreviation_DictID); //12:Parameter ISOCode of type String resultItem.ISOCode = reader.GetString(12); //13:Parameter DosageForm_Name_DictID of type Dict resultItem.DosageForm_Name_DictID = reader.GetDictionary(13); resultItem.DosageForm_Name_DictID.SourceTable = "hec_product_dosageforms"; loader.Append(resultItem.DosageForm_Name_DictID); //14:Parameter DosageForm_Description_DictID of type Dict resultItem.DosageForm_Description_DictID = reader.GetDictionary(14); resultItem.DosageForm_Description_DictID.SourceTable = "hec_product_dosageforms"; loader.Append(resultItem.DosageForm_Description_DictID); //15:Parameter GlobalPropertyMatchingID of type String resultItem.GlobalPropertyMatchingID = reader.GetString(15); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_Products_for_ProductGroup", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.ToArray(); return(returnStatus); }
protected static FR_L5BTS_GWSBD_fPTTR_1641_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5BTS_GWSBD_fPTTR_1641 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5BTS_GWSBD_fPTTR_1641_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_MyHealthClub_BookableTimeSlot.Atomic.Retrieval.SQL.cls_Get_WebSlotsBD_for_PracticeID_and_TypeID_in_TimeRange.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "OfficeID", Parameter.OfficeID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "TypeID", Parameter.TypeID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "FromDate", Parameter.FromDate); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ToDate", Parameter.ToDate); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "AvaTypeMachingID", Parameter.AvaTypeMachingID); List <L5BTS_GWSBD_fPTTR_1641> results = new List <L5BTS_GWSBD_fPTTR_1641>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "PPS_TSK_BOK_BookableTimeSlotID", "TaskTemplate_RefID", "FreeSlotsForTaskTemplateITPL", "FreeInterval_End", "FreeInterval_Start" }); while (reader.Read()) { L5BTS_GWSBD_fPTTR_1641 resultItem = new L5BTS_GWSBD_fPTTR_1641(); //0:Parameter PPS_TSK_BOK_BookableTimeSlotID of type Guid resultItem.PPS_TSK_BOK_BookableTimeSlotID = reader.GetGuid(0); //1:Parameter TaskTemplate_RefID of type Guid resultItem.TaskTemplate_RefID = reader.GetGuid(1); //2:Parameter FreeSlotsForTaskTemplateITPL of type string resultItem.FreeSlotsForTaskTemplateITPL = reader.GetString(2); //3:Parameter FreeInterval_End of type DateTime resultItem.FreeInterval_End = reader.GetDate(3); //4:Parameter FreeInterval_Start of type DateTime resultItem.FreeInterval_Start = reader.GetDate(4); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_WebSlotsBD_for_PracticeID_and_TypeID_in_TimeRange", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.ToArray(); return(returnStatus); }
protected static FR_L5AF_GAAD_1607_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5AF_GAAD_1607 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5AF_GAAD_1607_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_Lucentis_Aftercare.Atomic.Retrieval.SQL.cls_Get_AftercareAllData.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "OrderBy", Parameter.OrderBy); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "S_Practice", Parameter.S_Practice); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "s_Patient", Parameter.s_Patient); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "s_HealthInsurance", Parameter.s_HealthInsurance); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "OrderValue", Parameter.OrderValue); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "StartIndex", Parameter.StartIndex); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "NumberOfElements", Parameter.NumberOfElements); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "statusParameters", Parameter.statusParameters); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "s_doctorParam", Parameter.s_doctorParam); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "s_scheduled_doctorParam", Parameter.s_scheduled_doctorParam); /***For Order**/ if (Parameter.OrderValue != "") { string newText = command.CommandText.Replace("@OrderValue", Parameter.OrderValue); command.CommandText = newText; } /***Search parameters**/ if (Parameter.S_Practice != "") { string newText = command.CommandText.Replace("@S_Practice", Parameter.S_Practice); command.CommandText = newText; } if (Parameter.s_doctorParam != "") { string newText = command.CommandText.Replace("@s_doctorParam", Parameter.s_doctorParam); command.CommandText = newText; } if (Parameter.s_Patient != "") { string newText = command.CommandText.Replace("@s_Patient", Parameter.s_Patient); command.CommandText = newText; } if (Parameter.s_scheduled_doctorParam != "") { string newText = command.CommandText.Replace("@s_scheduled_doctorParam", Parameter.s_scheduled_doctorParam); command.CommandText = newText; } if (Parameter.s_HealthInsurance != "") { string newText = command.CommandText.Replace("@s_HealthInsurance", Parameter.s_HealthInsurance); command.CommandText = newText; } /***status parameters**/ if (Parameter.statusParameters != "") { string newText = command.CommandText.Replace("@statusParameters", Parameter.statusParameters); command.CommandText = newText; } List <L5AF_GAAD_1607> results = new List <L5AF_GAAD_1607>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "FollowupID", "Practice", "IsScheduled", "IsTreatmentBilled", "IsTreatmentPerformed", "FolllowupDate", "TreatmentDate", "PerformedDoctorTitle", "PerformedDoctorFirstName", "PerformedDoctorLastName", "SheduledDoctorTitle", "SheduledDoctorFirstName", "SheduledDoctorLastName", "PatientFirstName", "PatientLastName", "HealthInsurance" }); while (reader.Read()) { L5AF_GAAD_1607 resultItem = new L5AF_GAAD_1607(); //0:Parameter FollowupID of type Guid resultItem.FollowupID = reader.GetGuid(0); //1:Parameter Practice of type String resultItem.Practice = reader.GetString(1); //2:Parameter IsScheduled of type bool resultItem.IsScheduled = reader.GetBoolean(2); //3:Parameter IsTreatmentBilled of type bool resultItem.IsTreatmentBilled = reader.GetBoolean(3); //4:Parameter IsTreatmentPerformed of type bool resultItem.IsTreatmentPerformed = reader.GetBoolean(4); //5:Parameter FolllowupDate of type DateTime resultItem.FolllowupDate = reader.GetDate(5); //6:Parameter TreatmentDate of type DateTime resultItem.TreatmentDate = reader.GetDate(6); //7:Parameter PerformedDoctorTitle of type String resultItem.PerformedDoctorTitle = reader.GetString(7); //8:Parameter PerformedDoctorFirstName of type String resultItem.PerformedDoctorFirstName = reader.GetString(8); //9:Parameter PerformedDoctorLastName of type String resultItem.PerformedDoctorLastName = reader.GetString(9); //10:Parameter SheduledDoctorTitle of type String resultItem.SheduledDoctorTitle = reader.GetString(10); //11:Parameter SheduledDoctorFirstName of type String resultItem.SheduledDoctorFirstName = reader.GetString(11); //12:Parameter SheduledDoctorLastName of type String resultItem.SheduledDoctorLastName = reader.GetString(12); //13:Parameter PatientFirstName of type String resultItem.PatientFirstName = reader.GetString(13); //14:Parameter PatientLastName of type String resultItem.PatientLastName = reader.GetString(14); //15:Parameter HealthInsurance of type String resultItem.HealthInsurance = reader.GetString(15); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_AftercareAllData", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.ToArray(); return(returnStatus); }
protected static FR_L5EM_GAERCTFFE_1405 Execute(DbConnection Connection, DbTransaction Transaction, P_L5EM_GAERCTFFE_1405 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5EM_GAERCTFFE_1405(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_VacationPlanner_Employees.Atomic.Retrieval.SQL.cls_Get_Active_EmployeeRelationshipTimeFrame_For_EmployeeID.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "EmployeeID", Parameter.EmployeeID); List <L5EM_GAERCTFFE_1405> results = new List <L5EM_GAERCTFFE_1405>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "CMN_BPT_EMP_EmployeeID", "BusinessParticipant_RefID", "Staff_Number", "StandardFunction", "EmployeeDocument_Structure_RefID", "InstanceOf_EmploymentRelationships_Template_RefID", "IsLockedFor_TemplateUpdates", "Work_EndDate", "Work_StartDate", "HasWorkRelationEnded", "CMN_BPT_EMP_EmploymentRelationshipID", "CMN_BPT_EMP_EmploymentRelationship_TimeframeID", "CMN_CAL_CalculationTimeframeID", "CalculationTimeframe_StartDate", "CalculationTimefrate_EndDate", "CalculationTimeframe_EstimatedEndDate", "IsCalculationTimeframe_Active" }); while (reader.Read()) { L5EM_GAERCTFFE_1405 resultItem = new L5EM_GAERCTFFE_1405(); //0:Parameter CMN_BPT_EMP_EmployeeID of type Guid resultItem.CMN_BPT_EMP_EmployeeID = reader.GetGuid(0); //1:Parameter BusinessParticipant_RefID of type Guid resultItem.BusinessParticipant_RefID = reader.GetGuid(1); //2:Parameter Staff_Number of type String resultItem.Staff_Number = reader.GetString(2); //3:Parameter StandardFunction of type String resultItem.StandardFunction = reader.GetString(3); //4:Parameter EmployeeDocument_Structure_RefID of type Guid resultItem.EmployeeDocument_Structure_RefID = reader.GetGuid(4); //5:Parameter InstanceOf_EmploymentRelationships_Template_RefID of type Guid resultItem.InstanceOf_EmploymentRelationships_Template_RefID = reader.GetGuid(5); //6:Parameter IsLockedFor_TemplateUpdates of type bool resultItem.IsLockedFor_TemplateUpdates = reader.GetBoolean(6); //7:Parameter Work_EndDate of type DateTime resultItem.Work_EndDate = reader.GetDate(7); //8:Parameter Work_StartDate of type DateTime resultItem.Work_StartDate = reader.GetDate(8); //9:Parameter HasWorkRelationEnded of type bool resultItem.HasWorkRelationEnded = reader.GetBoolean(9); //10:Parameter CMN_BPT_EMP_EmploymentRelationshipID of type Guid resultItem.CMN_BPT_EMP_EmploymentRelationshipID = reader.GetGuid(10); //11:Parameter CMN_BPT_EMP_EmploymentRelationship_TimeframeID of type Guid resultItem.CMN_BPT_EMP_EmploymentRelationship_TimeframeID = reader.GetGuid(11); //12:Parameter CMN_CAL_CalculationTimeframeID of type Guid resultItem.CMN_CAL_CalculationTimeframeID = reader.GetGuid(12); //13:Parameter CalculationTimeframe_StartDate of type DateTime resultItem.CalculationTimeframe_StartDate = reader.GetDate(13); //14:Parameter CalculationTimefrate_EndDate of type DateTime resultItem.CalculationTimefrate_EndDate = reader.GetDate(14); //15:Parameter CalculationTimeframe_EstimatedEndDate of type DateTime resultItem.CalculationTimeframe_EstimatedEndDate = reader.GetDate(15); //16:Parameter IsCalculationTimeframe_Active of type bool resultItem.IsCalculationTimeframe_Active = reader.GetBoolean(16); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_Active_EmployeeRelationshipTimeFrame_For_EmployeeID", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.FirstOrDefault(); return(returnStatus); }
protected static FR_L5ME_GMSfPAID_1329_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5ME_GMSfPAID_1329 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5ME_GMSfPAID_1329_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_MyHealthClub_EMR.Atomic.Retrieval.SQL.cls_Get_MedicationSubstance_for_PerformedActionID.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "PerformedActionID", Parameter.PerformedActionID); List <L5ME_GMSfPAID_1329_raw> results = new List <L5ME_GMSfPAID_1329_raw>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "HEC_ACT_PerformedAction_MedicationUpdateID", "DosageText", "MedicationUpdateComment", "ISOCode", "IsActiveComponent", "IfSubstance_Strength", "HEC_Patient_MedicationID", "HEC_SUB_SubstanceID", "Relevant_PatientDiagnosis_RefID", "IntendedApplicationDuration_in_days", "GlobalPropertyMatchingID" }); while (reader.Read()) { L5ME_GMSfPAID_1329_raw resultItem = new L5ME_GMSfPAID_1329_raw(); //0:Parameter HEC_ACT_PerformedAction_MedicationUpdateID of type Guid resultItem.HEC_ACT_PerformedAction_MedicationUpdateID = reader.GetGuid(0); //1:Parameter DosageText of type String resultItem.DosageText = reader.GetString(1); //2:Parameter MedicationUpdateComment of type String resultItem.MedicationUpdateComment = reader.GetString(2); //3:Parameter ISOCode of type String resultItem.ISOCode = reader.GetString(3); //4:Parameter IsActiveComponent of type bool resultItem.IsActiveComponent = reader.GetBoolean(4); //5:Parameter IfSubstance_Strength of type String resultItem.IfSubstance_Strength = reader.GetString(5); //6:Parameter HEC_Patient_MedicationID of type Guid resultItem.HEC_Patient_MedicationID = reader.GetGuid(6); //7:Parameter HEC_SUB_SubstanceID of type Guid resultItem.HEC_SUB_SubstanceID = reader.GetGuid(7); //8:Parameter Relevant_PatientDiagnosis_RefID of type Guid resultItem.Relevant_PatientDiagnosis_RefID = reader.GetGuid(8); //9:Parameter IntendedApplicationDuration_in_days of type int resultItem.IntendedApplicationDuration_in_days = reader.GetInteger(9); //10:Parameter GlobalPropertyMatchingID of type string resultItem.GlobalPropertyMatchingID = reader.GetString(10); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_MedicationSubstance_for_PerformedActionID", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = L5ME_GMSfPAID_1329_raw.Convert(results).ToArray(); return(returnStatus); }
protected static FR_OR_GOFSR_1055_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_OR_GOFSR_1055_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "MMDocConnectDBMethods.Order.Atomic.Retrieval.SQL.cls_Get_Orders_For_Steribase_Report.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; List <OR_GOFSR_1055> results = new List <OR_GOFSR_1055>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "Patient_RefID", "StatusCode", "CaseID", "StatusID", "BusinesParticipantWhoCreatedOrder", "OrderID", "OrderNumber", "CaseNumber", "DrugName", "PZN", "DeliveryDate", "DeliveryTimeFrom", "DeliveryTimeTo", "OnlyLabel", "ChargesFee", "SendInvoiceToPractice", "TreatmentDate", "DoctorID", "OrderCreationTimestamp", "CaseCreationDate", "OrderComment", "HeaderComment", "IsDeleted", "PharmacyName", "PharmacyID" }); while (reader.Read()) { OR_GOFSR_1055 resultItem = new OR_GOFSR_1055(); //0:Parameter Patient_RefID of type Guid resultItem.Patient_RefID = reader.GetGuid(0); //1:Parameter StatusCode of type Double resultItem.StatusCode = reader.GetDouble(1); //2:Parameter CaseID of type Guid resultItem.CaseID = reader.GetGuid(2); //3:Parameter StatusID of type Guid resultItem.StatusID = reader.GetGuid(3); //4:Parameter BusinesParticipantWhoCreatedOrder of type Guid resultItem.BusinesParticipantWhoCreatedOrder = reader.GetGuid(4); //5:Parameter OrderID of type Guid resultItem.OrderID = reader.GetGuid(5); //6:Parameter OrderNumber of type String resultItem.OrderNumber = reader.GetString(6); //7:Parameter CaseNumber of type String resultItem.CaseNumber = reader.GetString(7); //8:Parameter DrugName of type String resultItem.DrugName = reader.GetString(8); //9:Parameter PZN of type String resultItem.PZN = reader.GetString(9); //10:Parameter DeliveryDate of type DateTime resultItem.DeliveryDate = reader.GetDate(10); //11:Parameter DeliveryTimeFrom of type DateTime resultItem.DeliveryTimeFrom = reader.GetDate(11); //12:Parameter DeliveryTimeTo of type DateTime resultItem.DeliveryTimeTo = reader.GetDate(12); //13:Parameter OnlyLabel of type Boolean resultItem.OnlyLabel = reader.GetBoolean(13); //14:Parameter ChargesFee of type Boolean resultItem.ChargesFee = reader.GetBoolean(14); //15:Parameter SendInvoiceToPractice of type Boolean resultItem.SendInvoiceToPractice = reader.GetBoolean(15); //16:Parameter TreatmentDate of type DateTime resultItem.TreatmentDate = reader.GetDate(16); //17:Parameter DoctorID of type Guid resultItem.DoctorID = reader.GetGuid(17); //18:Parameter OrderCreationTimestamp of type DateTime resultItem.OrderCreationTimestamp = reader.GetDate(18); //19:Parameter CaseCreationDate of type DateTime resultItem.CaseCreationDate = reader.GetDate(19); //20:Parameter OrderComment of type String resultItem.OrderComment = reader.GetString(20); //21:Parameter HeaderComment of type String resultItem.HeaderComment = reader.GetString(21); //22:Parameter IsDeleted of type Boolean resultItem.IsDeleted = reader.GetBoolean(22); //23:Parameter PharmacyName of type String resultItem.PharmacyName = reader.GetString(23); //24:Parameter PharmacyID of type Guid resultItem.PharmacyID = reader.GetGuid(24); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_Orders_For_Steribase_Report", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.ToArray(); return(returnStatus); }
protected static FR_L5ME_GRfPAID_1557_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5ME_GRfPAID_1557 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5ME_GRfPAID_1557_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_MyHealthClub_EMR.Atomic.Retrieval.SQL.cls_Get_Referrals_for_PerformedActionID.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "PerformedActionID", Parameter.PerformedActionID); List <L5ME_GRfPAID_1557_raw> results = new List <L5ME_GRfPAID_1557_raw>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "HEC_ACT_PerformedAction_ReferralID", "ReferralComment", "HEC_MedicalPractice_TypeID", "MedicalPracticeType_Name_DictID", "HEC_MedicalPractiseID", "OrganizationalUnit_Name_DictID", "HEC_ACT_PerformedAction_Referral_RequestedPotentialProcedureID", "HEC_TRE_PotentialProcedureID", "ProposedDate", "PotentialProcedure_Name_DictID" }); while (reader.Read()) { L5ME_GRfPAID_1557_raw resultItem = new L5ME_GRfPAID_1557_raw(); //0:Parameter HEC_ACT_PerformedAction_ReferralID of type Guid resultItem.HEC_ACT_PerformedAction_ReferralID = reader.GetGuid(0); //1:Parameter ReferralComment of type String resultItem.ReferralComment = reader.GetString(1); //2:Parameter HEC_MedicalPractice_TypeID of type Guid resultItem.HEC_MedicalPractice_TypeID = reader.GetGuid(2); //3:Parameter MedicalPracticeType_Name of type Dict resultItem.MedicalPracticeType_Name = reader.GetDictionary(3); resultItem.MedicalPracticeType_Name.SourceTable = "hec_medicalpractice_types"; loader.Append(resultItem.MedicalPracticeType_Name); //4:Parameter HEC_MedicalPractiseID of type Guid resultItem.HEC_MedicalPractiseID = reader.GetGuid(4); //5:Parameter OrganizationalUnit_Name of type Dict resultItem.OrganizationalUnit_Name = reader.GetDictionary(5); resultItem.OrganizationalUnit_Name.SourceTable = "cmn_bpt_ctm_organizationalunits"; loader.Append(resultItem.OrganizationalUnit_Name); //6:Parameter HEC_ACT_PerformedAction_Referral_RequestedPotentialProcedureID of type Guid resultItem.HEC_ACT_PerformedAction_Referral_RequestedPotentialProcedureID = reader.GetGuid(6); //7:Parameter HEC_TRE_PotentialProcedureID of type Guid resultItem.HEC_TRE_PotentialProcedureID = reader.GetGuid(7); //8:Parameter ProposedDate of type DateTime resultItem.ProposedDate = reader.GetDate(8); //9:Parameter PotentialProcedure_Name of type Dict resultItem.PotentialProcedure_Name = reader.GetDictionary(9); resultItem.PotentialProcedure_Name.SourceTable = "hec_tre_potentialprocedures"; loader.Append(resultItem.PotentialProcedure_Name); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_Referrals_for_PerformedActionID", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = L5ME_GRfPAID_1557_raw.Convert(results).ToArray(); return(returnStatus); }
protected static FR_L6TR_GTaRDfBIbT_1204_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L6TR_GTaRDfBIbT_1204 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L6TR_GTaRDfBIbT_1204_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL6_Lucenits_Treatments.Atomic.Retrieval.SQL.cls_Get_Treatment_and_RelevantDiagnosis_for_BillInfo_by_TreatmentID.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; command.CommandText = System.Text.RegularExpressions.Regex.Replace(command.CommandText, "=[ \t]*@TreatmentID", " IN $$TreatmentID$$"); CSV2Core_MySQL.Support.DBSQLSupport.AppendINStatement(command, "$TreatmentID$", Parameter.TreatmentID); List <L6TR_GTaRDfBIbT_1204_raw> results = new List <L6TR_GTaRDfBIbT_1204_raw>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "HEC_Patient_TreatmentID", "TreatmentPractice_RefID", "IsTreatmentPerformed", "IfTreatmentPerformed_ByDoctor_RefID", "IfTreatmentPerformed_Date", "IsTreatmentFollowup", "IfTreatmentFollowup_FromTreatment_RefID", "IsScheduled", "IfSheduled_Date", "IsTreatmentBilled", "IfTreatmentBilled_Date", "Treatment_Comment", "IsTreatmentOfLeftEye", "IsTreatmentOfRightEye", "HEC_Patient_Treatment_RelevantDiagnosisID", "HEC_DIA_Diagnosis_StateID", "HEC_DIA_PotentialDiagnosisID", "Doctor_RefID", "ICD10_Code", "DiagnosisState_Name_DictID", "DiagnosisState_Abbreviation", "Creation_Date", "DiagnosedOnDate", "PotentialDiagnosis_Name_DictID", "CMN_PRO_ProductID", "Product_Number", "Quantity", "Product_Name_DictID" }); while (reader.Read()) { L6TR_GTaRDfBIbT_1204_raw resultItem = new L6TR_GTaRDfBIbT_1204_raw(); //0:Parameter HEC_Patient_TreatmentID of type Guid resultItem.HEC_Patient_TreatmentID = reader.GetGuid(0); //1:Parameter TreatmentPractice_RefID of type Guid resultItem.TreatmentPractice_RefID = reader.GetGuid(1); //2:Parameter IsTreatmentPerformed of type bool resultItem.IsTreatmentPerformed = reader.GetBoolean(2); //3:Parameter IfTreatmentPerformed_ByDoctor_RefID of type Guid resultItem.IfTreatmentPerformed_ByDoctor_RefID = reader.GetGuid(3); //4:Parameter IfTreatmentPerformed_Date of type DateTime resultItem.IfTreatmentPerformed_Date = reader.GetDate(4); //5:Parameter IsTreatmentFollowup of type bool resultItem.IsTreatmentFollowup = reader.GetBoolean(5); //6:Parameter IfTreatmentFollowup_FromTreatment_RefID of type Guid resultItem.IfTreatmentFollowup_FromTreatment_RefID = reader.GetGuid(6); //7:Parameter IsScheduled of type bool resultItem.IsScheduled = reader.GetBoolean(7); //8:Parameter IfSheduled_Date of type DateTime resultItem.IfSheduled_Date = reader.GetDate(8); //9:Parameter IsTreatmentBilled of type bool resultItem.IsTreatmentBilled = reader.GetBoolean(9); //10:Parameter IfTreatmentBilled_Date of type DateTime resultItem.IfTreatmentBilled_Date = reader.GetDate(10); //11:Parameter Treatment_Comment of type String resultItem.Treatment_Comment = reader.GetString(11); //12:Parameter IsTreatmentOfLeftEye of type bool resultItem.IsTreatmentOfLeftEye = reader.GetBoolean(12); //13:Parameter IsTreatmentOfRightEye of type bool resultItem.IsTreatmentOfRightEye = reader.GetBoolean(13); //14:Parameter HEC_Patient_Treatment_RelevantDiagnosisID of type Guid resultItem.HEC_Patient_Treatment_RelevantDiagnosisID = reader.GetGuid(14); //15:Parameter HEC_DIA_Diagnosis_StateID of type Guid resultItem.HEC_DIA_Diagnosis_StateID = reader.GetGuid(15); //16:Parameter HEC_DIA_PotentialDiagnosisID of type Guid resultItem.HEC_DIA_PotentialDiagnosisID = reader.GetGuid(16); //17:Parameter Doctor_RefID of type Guid resultItem.Doctor_RefID = reader.GetGuid(17); //18:Parameter ICD10_Code of type String resultItem.ICD10_Code = reader.GetString(18); //19:Parameter DiagnosisState_Name of type Dict resultItem.DiagnosisState_Name = reader.GetDictionary(19); resultItem.DiagnosisState_Name.SourceTable = "hec_dia_diagnosis_states"; loader.Append(resultItem.DiagnosisState_Name); //20:Parameter DiagnosisState_Abbreviation of type String resultItem.DiagnosisState_Abbreviation = reader.GetString(20); //21:Parameter Creation_Date of type DateTime resultItem.Creation_Date = reader.GetDate(21); //22:Parameter DiagnosedOnDate of type DateTime resultItem.DiagnosedOnDate = reader.GetDate(22); //23:Parameter PotentialDiagnosis_Name_DictID of type Dict resultItem.PotentialDiagnosis_Name_DictID = reader.GetDictionary(23); resultItem.PotentialDiagnosis_Name_DictID.SourceTable = "hec_dia_potentialdiagnoses"; loader.Append(resultItem.PotentialDiagnosis_Name_DictID); //24:Parameter CMN_PRO_ProductID of type Guid resultItem.CMN_PRO_ProductID = reader.GetGuid(24); //25:Parameter Product_Number of type string resultItem.Product_Number = reader.GetString(25); //26:Parameter Quantity of type double resultItem.Quantity = reader.GetDouble(26); //27:Parameter Product_Name of type Dict resultItem.Product_Name = reader.GetDictionary(27); resultItem.Product_Name.SourceTable = "cmn_pro_products"; loader.Append(resultItem.Product_Name); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_Treatment_and_RelevantDiagnosis_for_BillInfo_by_TreatmentID", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = L6TR_GTaRDfBIbT_1204_raw.Convert(results).ToArray(); return(returnStatus); }
protected static FR_L3_CObAC_1533_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L3_CObAC_1533 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L3_CObAC_1533_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL3_MeasuringPoints.Atomic.Retrieval.SQL.cls_CustomerOwnership_by_AccountCode.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "AccountCode", Parameter.AccountCode); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "DownloadCode", Parameter.DownloadCode); List <L3_CObAC_1533> results = new List <L3_CObAC_1533>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "MRS_MPT_CustomerOwnershipID", "MeasuringPoint_RefID", "Customer_RefID", "ContractNubmer", "ValidFrom", "ValidThrough", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" }); while (reader.Read()) { L3_CObAC_1533 resultItem = new L3_CObAC_1533(); //0:Parameter MRS_MPT_CustomerOwnershipID of type Guid resultItem.MRS_MPT_CustomerOwnershipID = reader.GetGuid(0); //1:Parameter MeasuringPoint_RefID of type Guid resultItem.MeasuringPoint_RefID = reader.GetGuid(1); //2:Parameter Customer_RefID of type Guid resultItem.Customer_RefID = reader.GetGuid(2); //3:Parameter ContractNubmer of type String resultItem.ContractNubmer = reader.GetString(3); //4:Parameter ValidFrom of type DateTime resultItem.ValidFrom = reader.GetDate(4); //5:Parameter ValidThrough of type DateTime resultItem.ValidThrough = reader.GetDate(5); //6:Parameter Creation_Timestamp of type DateTime resultItem.Creation_Timestamp = reader.GetDate(6); //7:Parameter Tenant_RefID of type Guid resultItem.Tenant_RefID = reader.GetGuid(7); //8:Parameter IsDeleted of type bool resultItem.IsDeleted = reader.GetBoolean(8); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_CustomerOwnership_by_AccountCode", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.ToArray(); return(returnStatus); }
protected static FR_L5TR_GTfPID_1045_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5TR_GTfPID_1045 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5TR_GTfPID_1045_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_Lucentis_Treatments.Complex.Retrieval.SQL.cls_Get_Treatment_for_PatientID.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "PatientID", Parameter.PatientID); List <L5TR_GTfPID_1045_raw> results = new List <L5TR_GTfPID_1045_raw>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "IsTreatmentPerformed", "IfTreatmentPerformed_Date", "IsTreatmentFollowup", "IsScheduled", "IfSheduled_Date", "IsTreatmentBilled", "IfTreatmentBilled_Date", "HEC_Patient_TreatmentID", "IsTreatmentOfLeftEye", "IsTreatmentOfRightEye", "Treatment_PracticeID", "Treatment_Performed_by_DoctorID", "CMN_PRO_ProductID", "Product_Number", "Quantity", "Product_Name_DictID", "Status_Name_DictID", "ArticleDate", "ExpectedDateOfDelivery", "HEC_Patient_Treatment_RequiredProductID", "BoundTo_CustomerOrderPosition_RefID", "PharmacyID", "FollowUp_ID", "IsFollowUPPerformed", "IfFollowUpPerformed_Date", "IfFollowUpSheduled_Date", "Followup_PracticeID", "Followup_Performed_by_DoctorID", "Followup_Scheduled_for_DoctorID" }); while (reader.Read()) { L5TR_GTfPID_1045_raw resultItem = new L5TR_GTfPID_1045_raw(); //0:Parameter IsTreatmentPerformed of type bool resultItem.IsTreatmentPerformed = reader.GetBoolean(0); //1:Parameter IfTreatmentPerformed_Date of type DateTime resultItem.IfTreatmentPerformed_Date = reader.GetDate(1); //2:Parameter IsTreatmentFollowup of type bool resultItem.IsTreatmentFollowup = reader.GetBoolean(2); //3:Parameter IsScheduled of type bool resultItem.IsScheduled = reader.GetBoolean(3); //4:Parameter IfSheduled_Date of type DateTime resultItem.IfSheduled_Date = reader.GetDate(4); //5:Parameter IsTreatmentBilled of type bool resultItem.IsTreatmentBilled = reader.GetBoolean(5); //6:Parameter IfTreatmentBilled_Date of type DateTime resultItem.IfTreatmentBilled_Date = reader.GetDate(6); //7:Parameter HEC_Patient_TreatmentID of type Guid resultItem.HEC_Patient_TreatmentID = reader.GetGuid(7); //8:Parameter IsTreatmentOfLeftEye of type bool resultItem.IsTreatmentOfLeftEye = reader.GetBoolean(8); //9:Parameter IsTreatmentOfRightEye of type bool resultItem.IsTreatmentOfRightEye = reader.GetBoolean(9); //10:Parameter Treatment_PracticeID of type Guid resultItem.Treatment_PracticeID = reader.GetGuid(10); //11:Parameter Treatment_Performed_by_DoctorID of type Guid resultItem.Treatment_Performed_by_DoctorID = reader.GetGuid(11); //12:Parameter CMN_PRO_ProductID of type Guid resultItem.CMN_PRO_ProductID = reader.GetGuid(12); //13:Parameter Product_Number of type string resultItem.Product_Number = reader.GetString(13); //14:Parameter Quantity of type double resultItem.Quantity = reader.GetDouble(14); //15:Parameter Product_Name of type Dict resultItem.Product_Name = reader.GetDictionary(15); resultItem.Product_Name.SourceTable = "cmn_pro_products"; loader.Append(resultItem.Product_Name); //16:Parameter Status_Name_DictID of type Dict resultItem.Status_Name_DictID = reader.GetDictionary(16); resultItem.Status_Name_DictID.SourceTable = "ord_cuo_customerorder_statuses"; loader.Append(resultItem.Status_Name_DictID); //17:Parameter ArticleDate of type DateTime resultItem.ArticleDate = reader.GetDate(17); //18:Parameter ExpectedDateOfDelivery of type DateTime resultItem.ExpectedDateOfDelivery = reader.GetDate(18); //19:Parameter HEC_Patient_Treatment_RequiredProductID of type Guid resultItem.HEC_Patient_Treatment_RequiredProductID = reader.GetGuid(19); //20:Parameter BoundTo_CustomerOrderPosition_RefID of type Guid resultItem.BoundTo_CustomerOrderPosition_RefID = reader.GetGuid(20); //21:Parameter PharmacyID of type Guid resultItem.PharmacyID = reader.GetGuid(21); //22:Parameter FollowUp_ID of type Guid resultItem.FollowUp_ID = reader.GetGuid(22); //23:Parameter IsFollowUPPerformed of type bool resultItem.IsFollowUPPerformed = reader.GetBoolean(23); //24:Parameter IfFollowUpPerformed_Date of type DateTime resultItem.IfFollowUpPerformed_Date = reader.GetDate(24); //25:Parameter IfFollowUpSheduled_Date of type DateTime resultItem.IfFollowUpSheduled_Date = reader.GetDate(25); //26:Parameter Followup_PracticeID of type Guid resultItem.Followup_PracticeID = reader.GetGuid(26); //27:Parameter Followup_Performed_by_DoctorID of type Guid resultItem.Followup_Performed_by_DoctorID = reader.GetGuid(27); //28:Parameter Followup_Scheduled_for_DoctorID of type Guid resultItem.Followup_Scheduled_for_DoctorID = reader.GetGuid(28); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_Treatment_for_PatientID", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = L5TR_GTfPID_1045_raw.Convert(results).ToArray(); return(returnStatus); }
protected static FR_L5WS_GAfHAfT_1521_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5WS_GAfHAfT_1521 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5WS_GAfHAfT_1521_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_Lucentis_WebShop.Atomic.Retrieval.SQL.cls_Get_Articles_from_HouseList_for_TennantID.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ProductGroupMatchingID", Parameter.ProductGroupMatchingID); List <L5WS_GAfHAfT_1521> results = new List <L5WS_GAfHAfT_1521>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "CMN_PRO_ProductID", "Product_Name_DictID", "Product_Description_DictID", "Product_Number", "HEC_Product_DosageFormID", "DosageForm_Name_DictID", "CMN_UnitID", "Label_DictID", "Price", "CurrencyISO", "TaxRate" }); while (reader.Read()) { L5WS_GAfHAfT_1521 resultItem = new L5WS_GAfHAfT_1521(); //0:Parameter CMN_PRO_ProductID of type Guid resultItem.CMN_PRO_ProductID = reader.GetGuid(0); //1:Parameter Product_Name of type Dict resultItem.Product_Name = reader.GetDictionary(1); resultItem.Product_Name.SourceTable = "cmn_pro_products"; loader.Append(resultItem.Product_Name); //2:Parameter Product_Description of type Dict resultItem.Product_Description = reader.GetDictionary(2); resultItem.Product_Description.SourceTable = "cmn_pro_products"; loader.Append(resultItem.Product_Description); //3:Parameter Product_Number of type String resultItem.Product_Number = reader.GetString(3); //4:Parameter HEC_Product_DosageFormID of type Guid resultItem.HEC_Product_DosageFormID = reader.GetGuid(4); //5:Parameter DosageForm_Name of type Dict resultItem.DosageForm_Name = reader.GetDictionary(5); resultItem.DosageForm_Name.SourceTable = "hec_product_dosageforms"; loader.Append(resultItem.DosageForm_Name); //6:Parameter CMN_UnitID of type Guid resultItem.CMN_UnitID = reader.GetGuid(6); //7:Parameter Unit_Label of type Dict resultItem.Unit_Label = reader.GetDictionary(7); resultItem.Unit_Label.SourceTable = "cmn_units"; loader.Append(resultItem.Unit_Label); //8:Parameter Price of type double resultItem.Price = reader.GetDouble(8); //9:Parameter CurrencyISO of type String resultItem.CurrencyISO = reader.GetString(9); //10:Parameter TaxRate of type double resultItem.TaxRate = reader.GetDouble(10); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_Articles_from_HouseList_for_TennantID", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.ToArray(); return(returnStatus); }
private FR_Base Load(DbConnection Connection, DbTransaction Transaction, Guid ObjectID, string ConnectionString) { //Standard return type FR_Base retStatus = new FR_Base(); bool cleanupConnection = false; bool cleanupTransaction = false; try { #region VerifySessionToken/Create Connections //Create connection if Connection is null if (Connection == null) { cleanupConnection = true; Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString); Connection.Open(); } //If transaction is not open/not valid if (Transaction == null) { cleanupTransaction = true; Transaction = Connection.BeginTransaction(); } #endregion //Get the SelectQuerry string SelectQuery = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_HEC.HEC_Patient_Prescription_Transaction.SQL.Select.sql")).ReadToEnd(); DbCommand command = Connection.CreateCommand(); //Set Connection/Transaction command.Connection = Connection; command.Transaction = Transaction; //Set Query/Timeout command.CommandText = SelectQuery; command.CommandTimeout = QueryTimeout; //Firstly, before loading, set the GUID to empty //So the entity does not exist, it will have a GUID set to empty _HEC_Patient_Prescription_TransactionID = Guid.Empty; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "HEC_Patient_Prescription_TransactionID", ObjectID); #region Command Execution try { var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "HEC_Patient_Prescription_TransactionID", "PerscriptionTransaction_DeliveryAddress_RefID", "PrescriptionTransaction_Patient_RefID", "PrescriptionTransaction_InternalNubmer", "PrescriptionTransaction_IsComplete", "PrescriptionTransaction_RequestedDateOfDeliveryFrom", "PrescriptionTransaction_RequestedDateOfDeliveryTo", "PrescriptionTransaction_CreatedByBusinessParticpant_RefID", "PrescriptionTransaction_Comment", "PrescriptionTransaction_UsePatientAddress", "PrescriptionTransaction_UseReceiptAddress", "PrescriptionTransaction_UseParticipationPolicyAddress", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" }); if (reader.HasRows == true) { reader.Read(); //Single result only //0:Parameter HEC_Patient_Prescription_TransactionID of type Guid _HEC_Patient_Prescription_TransactionID = reader.GetGuid(0); //1:Parameter PerscriptionTransaction_DeliveryAddress_RefID of type Guid _PerscriptionTransaction_DeliveryAddress_RefID = reader.GetGuid(1); //2:Parameter PrescriptionTransaction_Patient_RefID of type Guid _PrescriptionTransaction_Patient_RefID = reader.GetGuid(2); //3:Parameter PrescriptionTransaction_InternalNubmer of type String _PrescriptionTransaction_InternalNubmer = reader.GetString(3); //4:Parameter PrescriptionTransaction_IsComplete of type Boolean _PrescriptionTransaction_IsComplete = reader.GetBoolean(4); //5:Parameter PrescriptionTransaction_RequestedDateOfDeliveryFrom of type DateTime _PrescriptionTransaction_RequestedDateOfDeliveryFrom = reader.GetDate(5); //6:Parameter PrescriptionTransaction_RequestedDateOfDeliveryTo of type DateTime _PrescriptionTransaction_RequestedDateOfDeliveryTo = reader.GetDate(6); //7:Parameter PrescriptionTransaction_CreatedByBusinessParticpant_RefID of type Guid _PrescriptionTransaction_CreatedByBusinessParticpant_RefID = reader.GetGuid(7); //8:Parameter PrescriptionTransaction_Comment of type String _PrescriptionTransaction_Comment = reader.GetString(8); //9:Parameter PrescriptionTransaction_UsePatientAddress of type Boolean _PrescriptionTransaction_UsePatientAddress = reader.GetBoolean(9); //10:Parameter PrescriptionTransaction_UseReceiptAddress of type Boolean _PrescriptionTransaction_UseReceiptAddress = reader.GetBoolean(10); //11:Parameter PrescriptionTransaction_UseParticipationPolicyAddress of type Boolean _PrescriptionTransaction_UseParticipationPolicyAddress = reader.GetBoolean(11); //12:Parameter Creation_Timestamp of type DateTime _Creation_Timestamp = reader.GetDate(12); //13:Parameter IsDeleted of type Boolean _IsDeleted = reader.GetBoolean(13); //14:Parameter Tenant_RefID of type Guid _Tenant_RefID = reader.GetGuid(14); } //Close the reader so other connections can use it reader.Close(); loader.Load(); if (_HEC_Patient_Prescription_TransactionID != Guid.Empty) { //Successfully loaded Status_IsAlreadySaved = true; Status_IsDirty = false; } else { //Fault in loading due to invalid UUID (Guid) Status_IsAlreadySaved = false; Status_IsDirty = false; } } catch (Exception ex) { throw ex; } #endregion #region Cleanup Transaction/Connection //If we started the transaction, we will commit it if (cleanupTransaction && Transaction != null) { Transaction.Commit(); } //If we opened the connection we will close it if (cleanupConnection && Connection != null) { 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 ex; } return(retStatus); }
protected FR_Base Save(DbConnection Connection, DbTransaction Transaction, string ConnectionString) { //Standard return type FR_Base retStatus = new FR_Base(); bool cleanupConnection = false; bool cleanupTransaction = false; try { bool saveDictionary = !Status_IsAlreadySaved || Component_Name.IsDirty || Component_Description.IsDirty; bool saveORMClass = !Status_IsAlreadySaved || Status_IsDirty; //If Status Is Dirty (Meaning the data has been changed) or Status_IsAlreadySaved (Meaning the data is in the database, when loaded) just return if (saveORMClass == false && saveDictionary == false) { return(FR_Base.Status_OK); } #region Verify/Create Connections //Create Connection if Connection is null if (Connection == null) { cleanupConnection = true; Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString); Connection.Open(); } //Create Transaction if null if (Transaction == null) { cleanupTransaction = true; Transaction = Connection.BeginTransaction(); } #endregion #region Dictionary Management //Save dictionary management if (saveDictionary == true) { var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); loader.Append(Component_Name, TableName); loader.Append(Component_Description, TableName); //Save the dictionary or update based on if it has already been saved to the database if (Status_IsAlreadySaved) { loader.Update(); } else { loader.Save(); } } #endregion #region Command Execution if (saveORMClass == true) { //Retrieve Querry string Query = ""; if (Status_IsAlreadySaved == true) { Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_HEC_PRO.HEC_PRO_Component.SQL.Update.sql")).ReadToEnd(); } else { Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_HEC_PRO.HEC_PRO_Component.SQL.Insert.sql")).ReadToEnd(); } DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; command.CommandText = Query; command.CommandTimeout = QueryTimeout; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "HEC_PRO_ComponentID", _HEC_PRO_ComponentID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "GlobalPropertyMatchingID", _GlobalPropertyMatchingID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ComponentMatterState", _ComponentMatterState); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "AbsoluteCompositionValue_Unit_RefID", _AbsoluteCompositionValue_Unit_RefID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "AbsoluteCompositionValue", _AbsoluteCompositionValue); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "RelativeCompositionValue_Unit_RefID", _RelativeCompositionValue_Unit_RefID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "RelativeCompositionValue", _RelativeCompositionValue); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "BreadUnitContainedAmount", _BreadUnitContainedAmount); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "EthanolContained_VolumePercentage", _EthanolContained_VolumePercentage); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ComponentEneryValue_in_kJ", _ComponentEneryValue_in_kJ); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Component_SimpleName", _Component_SimpleName); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Component_Name", _Component_Name.DictionaryID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Component_Description", _Component_Description.DictionaryID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ComponentDisposalSpeedStatus", _ComponentDisposalSpeedStatus); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "GalenicalTypeInsidePackageStatus", _GalenicalTypeInsidePackageStatus); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ComponentExcipientStatus", _ComponentExcipientStatus); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "GalenicalType_RelativeComposition", _GalenicalType_RelativeComposition); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Creation_Timestamp", _Creation_Timestamp); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Tenant_RefID", _Tenant_RefID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsDeleted", _IsDeleted); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Modification_Timestamp", _Modification_Timestamp); try { var dbChangeCount = command.ExecuteNonQuery(); Status_IsAlreadySaved = true; Status_IsDirty = false; } catch (Exception ex) { throw ex; } #endregion #region Cleanup Transaction/Connection //If we started the transaction, we will commit it if (cleanupTransaction && Transaction != null) { Transaction.Commit(); } //If we opened the connection we will close it if (cleanupConnection && Connection != null) { 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 ex; } return(retStatus); }
protected static FR_L5A_GAATfAID_1530 Execute(DbConnection Connection, DbTransaction Transaction, P_L5A_GAATfAID_1530 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5A_GAATfAID_1530(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_MyHealthClub_TaskTemplate.Atomic.Retrieval.SQL.cls_Get_AllAppointment_Task_for_AppointmentID.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "AppointmentID", Parameter.AppointmentID); List <L5A_GAATfAID_1530_raw> results = new List <L5A_GAATfAID_1530_raw>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "PPS_TSK_TaskID", "InstantiatedFrom_TaskTemplate_RefID", "DisplayName", "PlannedStartDate", "PlannedDuration_in_sec", "PPS_TSK_Task_StaffBookingsID", "PPS_TSK_Task_RefID", "CMN_BPT_EMP_Employee_RefID", "CreatedFrom_TaskTemplate_RequiredStaff_RefID", "PPS_TSK_Task_OfficeBookingID", "PPS_TSK_Task_RefID_Office", "CMN_STR_Office_RefID", "PPS_TSK_Task_DeviceBookingID", "PPS_TSK_Task_RefID_Device", "PPS_DEV_Device_Instance_RefID", "HEC_APP_AppointmentID", "Ext_PPS_TSK_Task_RefID", "HEC_ACT_PlannedActionID", "Patient_RefID" }); while (reader.Read()) { L5A_GAATfAID_1530_raw resultItem = new L5A_GAATfAID_1530_raw(); //0:Parameter PPS_TSK_TaskID of type Guid resultItem.PPS_TSK_TaskID = reader.GetGuid(0); //1:Parameter InstantiatedFrom_TaskTemplate_RefID of type Guid resultItem.InstantiatedFrom_TaskTemplate_RefID = reader.GetGuid(1); //2:Parameter DisplayName of type String resultItem.DisplayName = reader.GetString(2); //3:Parameter PlannedStartDate of type DateTime resultItem.PlannedStartDate = reader.GetDate(3); //4:Parameter PlannedDuration_in_sec of type String resultItem.PlannedDuration_in_sec = reader.GetString(4); //5:Parameter PPS_TSK_Task_StaffBookingsID of type Guid resultItem.PPS_TSK_Task_StaffBookingsID = reader.GetGuid(5); //6:Parameter PPS_TSK_Task_RefID of type Guid resultItem.PPS_TSK_Task_RefID = reader.GetGuid(6); //7:Parameter CMN_BPT_EMP_Employee_RefID of type Guid resultItem.CMN_BPT_EMP_Employee_RefID = reader.GetGuid(7); //8:Parameter CreatedFrom_TaskTemplate_RequiredStaff_RefID of type Guid resultItem.CreatedFrom_TaskTemplate_RequiredStaff_RefID = reader.GetGuid(8); //9:Parameter PPS_TSK_Task_OfficeBookingID of type Guid resultItem.PPS_TSK_Task_OfficeBookingID = reader.GetGuid(9); //10:Parameter PPS_TSK_Task_RefID_Office of type Guid resultItem.PPS_TSK_Task_RefID_Office = reader.GetGuid(10); //11:Parameter CMN_STR_Office_RefID of type Guid resultItem.CMN_STR_Office_RefID = reader.GetGuid(11); //12:Parameter PPS_TSK_Task_DeviceBookingID of type Guid resultItem.PPS_TSK_Task_DeviceBookingID = reader.GetGuid(12); //13:Parameter PPS_TSK_Task_RefID_Device of type Guid resultItem.PPS_TSK_Task_RefID_Device = reader.GetGuid(13); //14:Parameter PPS_DEV_Device_Instance_RefID of type Guid resultItem.PPS_DEV_Device_Instance_RefID = reader.GetGuid(14); //15:Parameter HEC_APP_AppointmentID of type Guid resultItem.HEC_APP_AppointmentID = reader.GetGuid(15); //16:Parameter Ext_PPS_TSK_Task_RefID of type Guid resultItem.Ext_PPS_TSK_Task_RefID = reader.GetGuid(16); //17:Parameter HEC_ACT_PlannedActionID of type Guid resultItem.HEC_ACT_PlannedActionID = reader.GetGuid(17); //18:Parameter Patient_RefID of type Guid resultItem.Patient_RefID = reader.GetGuid(18); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_AllAppointment_Task_for_AppointmentID", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = L5A_GAATfAID_1530_raw.Convert(results).FirstOrDefault(); return(returnStatus); }
private FR_Base Load(DbConnection Connection, DbTransaction Transaction, Guid ObjectID, string ConnectionString) { //Standard return type FR_Base retStatus = new FR_Base(); bool cleanupConnection = false; bool cleanupTransaction = false; try { #region Verify/Create Connections //Create connection if Connection is null if (Connection == null) { cleanupConnection = true; Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString); Connection.Open(); } //If transaction is not open/not valid if (Transaction == null) { cleanupTransaction = true; Transaction = Connection.BeginTransaction(); } #endregion //Get the SelectQuerry string SelectQuery = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_HEC_PRO.HEC_PRO_Component.SQL.Select.sql")).ReadToEnd(); DbCommand command = Connection.CreateCommand(); //Set Connection/Transaction command.Connection = Connection; command.Transaction = Transaction; //Set Query/Timeout command.CommandText = SelectQuery; command.CommandTimeout = QueryTimeout; //Firstly, before loading, set the GUID to empty //So the entity does not exist, it will have a GUID set to empty _HEC_PRO_ComponentID = Guid.Empty; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "HEC_PRO_ComponentID", ObjectID); #region Command Execution try { var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "HEC_PRO_ComponentID", "GlobalPropertyMatchingID", "ComponentMatterState", "AbsoluteCompositionValue_Unit_RefID", "AbsoluteCompositionValue", "RelativeCompositionValue_Unit_RefID", "RelativeCompositionValue", "BreadUnitContainedAmount", "EthanolContained_VolumePercentage", "ComponentEneryValue_in_kJ", "Component_SimpleName", "Component_Name_DictID", "Component_Description_DictID", "ComponentDisposalSpeedStatus", "GalenicalTypeInsidePackageStatus", "ComponentExcipientStatus", "GalenicalType_RelativeComposition", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" }); if (reader.HasRows == true) { reader.Read(); //Single result only //0:Parameter HEC_PRO_ComponentID of type Guid _HEC_PRO_ComponentID = reader.GetGuid(0); //1:Parameter GlobalPropertyMatchingID of type String _GlobalPropertyMatchingID = reader.GetString(1); //2:Parameter ComponentMatterState of type int _ComponentMatterState = reader.GetInteger(2); //3:Parameter AbsoluteCompositionValue_Unit_RefID of type Guid _AbsoluteCompositionValue_Unit_RefID = reader.GetGuid(3); //4:Parameter AbsoluteCompositionValue of type Double _AbsoluteCompositionValue = reader.GetDouble(4); //5:Parameter RelativeCompositionValue_Unit_RefID of type Guid _RelativeCompositionValue_Unit_RefID = reader.GetGuid(5); //6:Parameter RelativeCompositionValue of type Double _RelativeCompositionValue = reader.GetDouble(6); //7:Parameter BreadUnitContainedAmount of type Double _BreadUnitContainedAmount = reader.GetDouble(7); //8:Parameter EthanolContained_VolumePercentage of type Double _EthanolContained_VolumePercentage = reader.GetDouble(8); //9:Parameter ComponentEneryValue_in_kJ of type Double _ComponentEneryValue_in_kJ = reader.GetDouble(9); //10:Parameter Component_SimpleName of type String _Component_SimpleName = reader.GetString(10); //11:Parameter Component_Name of type Dict _Component_Name = reader.GetDictionary(11); loader.Append(_Component_Name, TableName); //12:Parameter Component_Description of type Dict _Component_Description = reader.GetDictionary(12); loader.Append(_Component_Description, TableName); //13:Parameter ComponentDisposalSpeedStatus of type int _ComponentDisposalSpeedStatus = reader.GetInteger(13); //14:Parameter GalenicalTypeInsidePackageStatus of type int _GalenicalTypeInsidePackageStatus = reader.GetInteger(14); //15:Parameter ComponentExcipientStatus of type int _ComponentExcipientStatus = reader.GetInteger(15); //16:Parameter GalenicalType_RelativeComposition of type String _GalenicalType_RelativeComposition = reader.GetString(16); //17:Parameter Creation_Timestamp of type DateTime _Creation_Timestamp = reader.GetDate(17); //18:Parameter Tenant_RefID of type Guid _Tenant_RefID = reader.GetGuid(18); //19:Parameter IsDeleted of type Boolean _IsDeleted = reader.GetBoolean(19); //20:Parameter Modification_Timestamp of type DateTime _Modification_Timestamp = reader.GetDate(20); } //Close the reader so other connections can use it reader.Close(); loader.Load(); if (_HEC_PRO_ComponentID != Guid.Empty) { //Successfully loaded Status_IsAlreadySaved = true; Status_IsDirty = false; } else { //Fault in loading due to invalid UUID (Guid) Status_IsAlreadySaved = false; Status_IsDirty = false; } } catch (Exception ex) { throw ex; } #endregion #region Cleanup Transaction/Connection //If we started the transaction, we will commit it if (cleanupTransaction && Transaction != null) { Transaction.Commit(); } //If we opened the connection we will close it if (cleanupConnection && Connection != null) { 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 ex; } return(retStatus); }
private FR_Base Load(DbConnection Connection, DbTransaction Transaction, Guid ObjectID, string ConnectionString) { //Standard return type FR_Base retStatus = new FR_Base(); bool cleanupConnection = false; bool cleanupTransaction = false; try { #region Verify/Create Connections //Create connection if Connection is null if (Connection == null) { cleanupConnection = true; Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString); Connection.Open(); } //If transaction is not open/not valid if (Transaction == null) { cleanupTransaction = true; Transaction = Connection.BeginTransaction(); } #endregion //Get the SelectQuerry string SelectQuery = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_DOC.DOC_DocumentTemplate_2_BusinessParticipant.SQL.Select.sql")).ReadToEnd(); DbCommand command = Connection.CreateCommand(); //Set Connection/Transaction command.Connection = Connection; command.Transaction = Transaction; //Set Query/Timeout command.CommandText = SelectQuery; command.CommandTimeout = QueryTimeout; //Firstly, before loading, set the GUID to empty //So the entity does not exist, it will have a GUID set to empty _AssignmentID = Guid.Empty; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "AssignmentID", ObjectID); #region Command Execution try { var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "AssignmentID", "DOC_DocumentTemplate_Instance_RefID", "CMN_BPT_BusinessParticipant_RefID", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" }); if (reader.HasRows == true) { reader.Read(); //Single result only //0:Parameter AssignmentID of type Guid _AssignmentID = reader.GetGuid(0); //1:Parameter DOC_DocumentTemplate_Instance_RefID of type Guid _DOC_DocumentTemplate_Instance_RefID = reader.GetGuid(1); //2:Parameter CMN_BPT_BusinessParticipant_RefID of type Guid _CMN_BPT_BusinessParticipant_RefID = reader.GetGuid(2); //3:Parameter Creation_Timestamp of type DateTime _Creation_Timestamp = reader.GetDate(3); //4:Parameter Tenant_RefID of type Guid _Tenant_RefID = reader.GetGuid(4); //5:Parameter IsDeleted of type Boolean _IsDeleted = reader.GetBoolean(5); //6:Parameter Modification_Timestamp of type DateTime _Modification_Timestamp = reader.GetDate(6); } //Close the reader so other connections can use it reader.Close(); loader.Load(); if (_AssignmentID != Guid.Empty) { //Successfully loaded Status_IsAlreadySaved = true; Status_IsDirty = false; } else { //Fault in loading due to invalid UUID (Guid) Status_IsAlreadySaved = false; Status_IsDirty = false; } } catch (Exception ex) { throw; } #endregion #region Cleanup Transaction/Connection //If we started the transaction, we will commit it if (cleanupTransaction && Transaction != null) { Transaction.Commit(); } //If we opened the connection we will close it if (cleanupConnection && Connection != null) { 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; } return(retStatus); }
private static List <ORM_HEC_PRO_Component> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction) { CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection(); List <ORM_HEC_PRO_Component> items; try { managedConnection.set(connectionString, connection, transaction); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(managedConnection.getConnection(), managedConnection.getTransaction()); DbCommand command = managedConnection.manage(query.CreateSelectQuery(TableName)); query.SetParameters(command); items = new List <ORM_HEC_PRO_Component>(); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "HEC_PRO_ComponentID", "GlobalPropertyMatchingID", "ComponentMatterState", "AbsoluteCompositionValue_Unit_RefID", "AbsoluteCompositionValue", "RelativeCompositionValue_Unit_RefID", "RelativeCompositionValue", "BreadUnitContainedAmount", "EthanolContained_VolumePercentage", "ComponentEneryValue_in_kJ", "Component_SimpleName", "Component_Name_DictID", "Component_Description_DictID", "ComponentDisposalSpeedStatus", "GalenicalTypeInsidePackageStatus", "ComponentExcipientStatus", "GalenicalType_RelativeComposition", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" }); while (reader.Read()) { ORM_HEC_PRO_Component item = new ORM_HEC_PRO_Component(); //0:Parameter HEC_PRO_ComponentID of type Guid item.HEC_PRO_ComponentID = reader.GetGuid(0); //1:Parameter GlobalPropertyMatchingID of type String item.GlobalPropertyMatchingID = reader.GetString(1); //2:Parameter ComponentMatterState of type int item.ComponentMatterState = reader.GetInteger(2); //3:Parameter AbsoluteCompositionValue_Unit_RefID of type Guid item.AbsoluteCompositionValue_Unit_RefID = reader.GetGuid(3); //4:Parameter AbsoluteCompositionValue of type Double item.AbsoluteCompositionValue = reader.GetDouble(4); //5:Parameter RelativeCompositionValue_Unit_RefID of type Guid item.RelativeCompositionValue_Unit_RefID = reader.GetGuid(5); //6:Parameter RelativeCompositionValue of type Double item.RelativeCompositionValue = reader.GetDouble(6); //7:Parameter BreadUnitContainedAmount of type Double item.BreadUnitContainedAmount = reader.GetDouble(7); //8:Parameter EthanolContained_VolumePercentage of type Double item.EthanolContained_VolumePercentage = reader.GetDouble(8); //9:Parameter ComponentEneryValue_in_kJ of type Double item.ComponentEneryValue_in_kJ = reader.GetDouble(9); //10:Parameter Component_SimpleName of type String item.Component_SimpleName = reader.GetString(10); //11:Parameter Component_Name of type Dict item.Component_Name = reader.GetDictionary(11); loader.Append(item.Component_Name, TableName); //12:Parameter Component_Description of type Dict item.Component_Description = reader.GetDictionary(12); loader.Append(item.Component_Description, TableName); //13:Parameter ComponentDisposalSpeedStatus of type int item.ComponentDisposalSpeedStatus = reader.GetInteger(13); //14:Parameter GalenicalTypeInsidePackageStatus of type int item.GalenicalTypeInsidePackageStatus = reader.GetInteger(14); //15:Parameter ComponentExcipientStatus of type int item.ComponentExcipientStatus = reader.GetInteger(15); //16:Parameter GalenicalType_RelativeComposition of type String item.GalenicalType_RelativeComposition = reader.GetString(16); //17:Parameter Creation_Timestamp of type DateTime item.Creation_Timestamp = reader.GetDate(17); //18:Parameter Tenant_RefID of type Guid item.Tenant_RefID = reader.GetGuid(18); //19:Parameter IsDeleted of type Boolean item.IsDeleted = reader.GetBoolean(19); //20:Parameter Modification_Timestamp of type DateTime item.Modification_Timestamp = reader.GetDate(20); item.Status_IsAlreadySaved = true; item.Status_IsDirty = false; items.Add(item); } reader.Close(); loader.Load(); managedConnection.commit(); } catch (Exception ex) { managedConnection.rollback(); throw ex; } return(items); }
protected static FR_L5OU_GOUDEUID_1502 Execute(DbConnection Connection, DbTransaction Transaction, P_L5OU_GOUDEUID_1502 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5OU_GOUDEUID_1502(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_MyHealthClub_OrgUnits.Atomic.Retrieval.SQL.cls_Get_OrgUnitData_Edit_for_UnitID.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "OfficeID", Parameter.OfficeID); List <L5OU_GOUDEUID_1502_raw> results = new List <L5OU_GOUDEUID_1502_raw>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "CMN_STR_OfficeID", "Parent_RefID", "DisplayImage_Document_RefID", "Office_Name_DictID", "PhoneNumber", "Default_Email", "Default_Website", "Comment", "ContactPersonFirstName", "ContactPersonLastName", "ContactPersonTitle", "ParentNameDict", "CMN_AddressID", "IsDefaultAddress", "IsSpecialAddress", "IsBillingAddress", "IsShippingAddress", "Street_Name", "Street_Number", "City_Name", "ZIP", "Longitude", "Lattitude", "Country_ISOCode", "Country_Name", "PPS_TSK_Task_Template_RefID", "HEC_MedicalPractice_TypeID", "MedicalPracticeType_Name_DictID", "CMN_LanguageID", "IsDeleted", "Name_DictID" }); while (reader.Read()) { L5OU_GOUDEUID_1502_raw resultItem = new L5OU_GOUDEUID_1502_raw(); //0:Parameter CMN_STR_OfficeID of type Guid resultItem.CMN_STR_OfficeID = reader.GetGuid(0); //1:Parameter Parent_RefID of type Guid resultItem.Parent_RefID = reader.GetGuid(1); //2:Parameter DisplayImage_Document_RefID of type Guid resultItem.DisplayImage_Document_RefID = reader.GetGuid(2); //3:Parameter Office_Name of type Dict resultItem.Office_Name = reader.GetDictionary(3); resultItem.Office_Name.SourceTable = "cmn_str_offices"; loader.Append(resultItem.Office_Name); //4:Parameter PhoneNumber of type String resultItem.PhoneNumber = reader.GetString(4); //5:Parameter Default_Email of type String resultItem.Default_Email = reader.GetString(5); //6:Parameter Default_Website of type String resultItem.Default_Website = reader.GetString(6); //7:Parameter Comment of type String resultItem.Comment = reader.GetString(7); //8:Parameter ContactPersonFirstName of type String resultItem.ContactPersonFirstName = reader.GetString(8); //9:Parameter ContactPersonLastName of type String resultItem.ContactPersonLastName = reader.GetString(9); //10:Parameter ContactPersonTitle of type String resultItem.ContactPersonTitle = reader.GetString(10); //11:Parameter ParentNameDict of type Dict resultItem.ParentNameDict = reader.GetDictionary(11); resultItem.ParentNameDict.SourceTable = "cmn_str_offices"; loader.Append(resultItem.ParentNameDict); //12:Parameter CMN_AddressID of type Guid resultItem.CMN_AddressID = reader.GetGuid(12); //13:Parameter IsDefaultAddress of type bool resultItem.IsDefaultAddress = reader.GetBoolean(13); //14:Parameter IsSpecialAddress of type bool resultItem.IsSpecialAddress = reader.GetBoolean(14); //15:Parameter IsBillingAddress of type bool resultItem.IsBillingAddress = reader.GetBoolean(15); //16:Parameter IsShippingAddress of type bool resultItem.IsShippingAddress = reader.GetBoolean(16); //17:Parameter Street_Name of type String resultItem.Street_Name = reader.GetString(17); //18:Parameter Street_Number of type String resultItem.Street_Number = reader.GetString(18); //19:Parameter City_Name of type String resultItem.City_Name = reader.GetString(19); //20:Parameter ZIP of type String resultItem.ZIP = reader.GetString(20); //21:Parameter Longitude of type double resultItem.Longitude = reader.GetDouble(21); //22:Parameter Lattitude of type double resultItem.Lattitude = reader.GetDouble(22); //23:Parameter Country_ISOCode of type String resultItem.Country_ISOCode = reader.GetString(23); //24:Parameter Country_Name of type String resultItem.Country_Name = reader.GetString(24); //25:Parameter PPS_TSK_Task_Template_RefID of type Guid resultItem.PPS_TSK_Task_Template_RefID = reader.GetGuid(25); //26:Parameter HEC_MedicalPractice_TypeID of type Guid resultItem.HEC_MedicalPractice_TypeID = reader.GetGuid(26); //27:Parameter Medical_Practice_Type_Name of type Dict resultItem.Medical_Practice_Type_Name = reader.GetDictionary(27); resultItem.Medical_Practice_Type_Name.SourceTable = "hec_medicalpractice_types"; loader.Append(resultItem.Medical_Practice_Type_Name); //28:Parameter CMN_LanguageID of type Guid resultItem.CMN_LanguageID = reader.GetGuid(28); //29:Parameter IsDeleted of type bool resultItem.IsDeleted = reader.GetBoolean(29); //30:Parameter Name of type Dict resultItem.Name = reader.GetDictionary(30); resultItem.Name.SourceTable = "cmn_languages"; loader.Append(resultItem.Name); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_OrgUnitData_Edit_for_UnitID", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = L5OU_GOUDEUID_1502_raw.Convert(results).FirstOrDefault(); return(returnStatus); }
protected static FR_L3US_GUIfAID_1514 Execute(DbConnection Connection, DbTransaction Transaction, P_L3US_GUIfAID_1514 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L3US_GUIfAID_1514(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL3_User.Atomic.Retrieval.SQL.cls_Get_UserInformation_for_AccountID.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "UserAccountID", Parameter.UserAccountID); List <L3US_GUIfAID_1514> results = new List <L3US_GUIfAID_1514>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "Username", "DefaultLanguage_RefID", "CMN_PER_PersonInfoID", "FirstName", "LastName", "PrimaryEmail", "Title", "ProfileImage_Document_RefID", "USR_Account_RefID", "File_ServerLocation", "File_SourceLocation" }); while (reader.Read()) { L3US_GUIfAID_1514 resultItem = new L3US_GUIfAID_1514(); //0:Parameter Username of type String resultItem.Username = reader.GetString(0); //1:Parameter DefaultLanguage_RefID of type Guid resultItem.DefaultLanguage_RefID = reader.GetGuid(1); //2:Parameter CMN_PER_PersonInfoID of type Guid resultItem.CMN_PER_PersonInfoID = reader.GetGuid(2); //3:Parameter FirstName of type String resultItem.FirstName = reader.GetString(3); //4:Parameter LastName of type String resultItem.LastName = reader.GetString(4); //5:Parameter PrimaryEmail of type String resultItem.PrimaryEmail = reader.GetString(5); //6:Parameter Title of type String resultItem.Title = reader.GetString(6); //7:Parameter ProfileImage_Document_RefID of type Guid resultItem.ProfileImage_Document_RefID = reader.GetGuid(7); //8:Parameter USR_Account_RefID of type Guid resultItem.USR_Account_RefID = reader.GetGuid(8); //9:Parameter File_ServerLocation of type String resultItem.File_ServerLocation = reader.GetString(9); //10:Parameter File_SourceLocation of type String resultItem.File_SourceLocation = reader.GetString(10); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_UserInformation_for_AccountID", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.FirstOrDefault(); return(returnStatus); }
private FR_Base Load(DbConnection Connection, DbTransaction Transaction, Guid ObjectID, string ConnectionString) { //Standard return type FR_Base retStatus = new FR_Base(); bool cleanupConnection = false; bool cleanupTransaction = false; try { #region Verify/Create Connections //Create connection if Connection is null if (Connection == null) { cleanupConnection = true; Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString); Connection.Open(); } //If transaction is not open/not valid if (Transaction == null) { cleanupTransaction = true; Transaction = Connection.BeginTransaction(); } #endregion //Get the SelectQuerry string SelectQuery = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_RES_BLD.RES_BLD_Building.SQL.Select.sql")).ReadToEnd(); DbCommand command = Connection.CreateCommand(); //Set Connection/Transaction command.Connection = Connection; command.Transaction = Transaction; //Set Query/Timeout command.CommandText = SelectQuery; command.CommandTimeout = QueryTimeout; //Firstly, before loading, set the GUID to empty //So the entity does not exist, it will have a GUID set to empty _RES_BLD_BuildingID = Guid.Empty; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "RES_BLD_BuildingID", ObjectID); #region Command Execution try { var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "RES_BLD_BuildingID", "Building_CurrentAverageRentPrice_per_sqm_RefID", "BuildingRevisionHeader_RefID", "Building_BalconyPortionPercent", "Building_Name", "Building_DocumentationStructure_RefID", "IsContaminationSuspected", "Building_NumberOfFloors", "Building_ElevatorCoveragePercent", "Building_NumberOfAppartments", "Building_NumberOfOccupiedAppartments", "Building_NumberOfOffices", "Building_NumberOfRetailUnits", "Building_NumberOfProductionUnits", "Building_NumberOfOtherUnits", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" }); if (reader.HasRows == true) { reader.Read(); //Single result only //0:Parameter RES_BLD_BuildingID of type Guid _RES_BLD_BuildingID = reader.GetGuid(0); //1:Parameter Building_CurrentAverageRentPrice_per_sqm_RefID of type Guid _Building_CurrentAverageRentPrice_per_sqm_RefID = reader.GetGuid(1); //2:Parameter BuildingRevisionHeader_RefID of type Guid _BuildingRevisionHeader_RefID = reader.GetGuid(2); //3:Parameter Building_BalconyPortionPercent of type double _Building_BalconyPortionPercent = reader.GetDouble(3); //4:Parameter Building_Name of type String _Building_Name = reader.GetString(4); //5:Parameter Building_DocumentationStructure_RefID of type Guid _Building_DocumentationStructure_RefID = reader.GetGuid(5); //6:Parameter IsContaminationSuspected of type Boolean _IsContaminationSuspected = reader.GetBoolean(6); //7:Parameter Building_NumberOfFloors of type int _Building_NumberOfFloors = reader.GetInteger(7); //8:Parameter Building_ElevatorCoveragePercent of type double _Building_ElevatorCoveragePercent = reader.GetDouble(8); //9:Parameter Building_NumberOfAppartments of type int _Building_NumberOfAppartments = reader.GetInteger(9); //10:Parameter Building_NumberOfOccupiedAppartments of type int _Building_NumberOfOccupiedAppartments = reader.GetInteger(10); //11:Parameter Building_NumberOfOffices of type int _Building_NumberOfOffices = reader.GetInteger(11); //12:Parameter Building_NumberOfRetailUnits of type int _Building_NumberOfRetailUnits = reader.GetInteger(12); //13:Parameter Building_NumberOfProductionUnits of type int _Building_NumberOfProductionUnits = reader.GetInteger(13); //14:Parameter Building_NumberOfOtherUnits of type int _Building_NumberOfOtherUnits = reader.GetInteger(14); //15:Parameter Creation_Timestamp of type DateTime _Creation_Timestamp = reader.GetDate(15); //16:Parameter IsDeleted of type Boolean _IsDeleted = reader.GetBoolean(16); //17:Parameter Tenant_RefID of type Guid _Tenant_RefID = reader.GetGuid(17); } //Close the reader so other connections can use it reader.Close(); loader.Load(); if (_RES_BLD_BuildingID != Guid.Empty) { //Successfully loaded Status_IsAlreadySaved = true; Status_IsDirty = false; } else { //Fault in loading due to invalid UUID (Guid) Status_IsAlreadySaved = false; Status_IsDirty = false; } } catch (Exception ex) { throw ex; } #endregion #region Cleanup Transaction/Connection //If we started the transaction, we will commit it if (cleanupTransaction && Transaction != null) { Transaction.Commit(); } //If we opened the connection we will close it if (cleanupConnection && Connection != null) { 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 ex; } return(retStatus); }
protected static FR_L5AWSSC_GASC_1413_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5AWSSC_GASC_1413 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5AWSSC_GASC_1413_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_APOWebShop_ShoppingCart.Atomic.Retrieval.SQL.cls_Get_All_ShoppingCarts.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "NumberOfLastDays", Parameter.NumberOfLastDays); command.CommandText = System.Text.RegularExpressions.Regex.Replace(command.CommandText, "=[ \t]*@Status_GlobalPropertyMatchingID_List", " IN $$Status_GlobalPropertyMatchingID_List$$"); CSV2Core_MySQL.Support.DBSQLSupport.AppendINStatement(command, "$Status_GlobalPropertyMatchingID_List$", Parameter.Status_GlobalPropertyMatchingID_List); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ProductNameContains", Parameter.ProductNameContains); List <L5AWSSC_GASC_1413> results = new List <L5AWSSC_GASC_1413>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "ORD_PRC_ShoppingCartID", "IsProcurementOrderCreated", "InternalIdentifier", "ShoppingCart_CreationDate", "CMN_STR_OfficeID", "Office_Name_DictID", "Office_InternalName", "ProcurementOrder_Date", "ProcurementOrderStatus", "Status_GlobalPropertyMatchingID" }); while (reader.Read()) { L5AWSSC_GASC_1413 resultItem = new L5AWSSC_GASC_1413(); //0:Parameter ORD_PRC_ShoppingCartID of type Guid resultItem.ORD_PRC_ShoppingCartID = reader.GetGuid(0); //1:Parameter IsProcurementOrderCreated of type bool resultItem.IsProcurementOrderCreated = reader.GetBoolean(1); //2:Parameter InternalIdentifier of type String resultItem.InternalIdentifier = reader.GetString(2); //3:Parameter ShoppingCart_CreationDate of type DateTime resultItem.ShoppingCart_CreationDate = reader.GetDate(3); //4:Parameter CMN_STR_OfficeID of type Guid resultItem.CMN_STR_OfficeID = reader.GetGuid(4); //5:Parameter Office_Name of type Dict resultItem.Office_Name = reader.GetDictionary(5); resultItem.Office_Name.SourceTable = "cmn_str_offices"; loader.Append(resultItem.Office_Name); //6:Parameter Office_InternalName of type String resultItem.Office_InternalName = reader.GetString(6); //7:Parameter ProcurementOrder_Date of type DateTime resultItem.ProcurementOrder_Date = reader.GetDate(7); //8:Parameter ProcurementOrderStatus of type String resultItem.ProcurementOrderStatus = reader.GetString(8); //9:Parameter Status_GlobalPropertyMatchingID of type String resultItem.Status_GlobalPropertyMatchingID = reader.GetString(9); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_All_ShoppingCarts", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.ToArray(); return(returnStatus); }
protected static FR_L5CO_GCOHwPnCI_0820_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5CO_GCOHwPnCI_0820_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_APOBackoffice_CustomerOrder.Atomic.Retrieval.SQL.cls_Get_CustomerOrderHeaders_with_Positions_notRelatedTo_CustomerInteractions.sql"; command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd(); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket); command.CommandTimeout = QueryTimeout; List <L5CO_GCOHwPnCI_0820_raw> results = new List <L5CO_GCOHwPnCI_0820_raw>(); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); try { reader.SetOrdinals(new string[] { "ORD_CUO_CustomerOrder_HeaderID", "IfCompany_CMN_COM_CompanyInfo_RefID", "CustomerOrder_Number", "OrderedByCompanyName", "OrderedByEmail", "CustomerOrder_Date", "TotalValue_BeforeTax", "Status_Code", "Status_Name_DictID", "GlobalPropertyMatchingID", "OrderCreatedBy", "IsCustomerOrderFinalized", "ConfirmedBy_DisplayName", "Product_Name_DictID", "Product_Number", "CustomerOrder_Header_RefID", "PackageContent_Amount", "PackageContent_MeasuredInUnit_RefID", "DosageForm_Name_DictID", "Abbreviation_DictID", "Label_DictID", "ORD_CUO_CustomerOrder_PositionID", "Position_Quantity", "Position_ValuePerUnit", "Position_ValueTotal", "TaxRate", "TaxName_DictID", "EconomicRegion_RefID", "ApplicableSalesTax_RefID" }); while (reader.Read()) { L5CO_GCOHwPnCI_0820_raw resultItem = new L5CO_GCOHwPnCI_0820_raw(); //0:Parameter ORD_CUO_CustomerOrder_HeaderID of type Guid resultItem.ORD_CUO_CustomerOrder_HeaderID = reader.GetGuid(0); //1:Parameter IfCompany_CMN_COM_CompanyInfo_RefID of type Guid resultItem.IfCompany_CMN_COM_CompanyInfo_RefID = reader.GetGuid(1); //2:Parameter CustomerOrder_Number of type String resultItem.CustomerOrder_Number = reader.GetString(2); //3:Parameter OrderedByCompanyName of type String resultItem.OrderedByCompanyName = reader.GetString(3); //4:Parameter OrderedByEmail of type String resultItem.OrderedByEmail = reader.GetString(4); //5:Parameter CustomerOrder_Date of type DateTime resultItem.CustomerOrder_Date = reader.GetDate(5); //6:Parameter TotalValue_BeforeTax of type Decimal resultItem.TotalValue_BeforeTax = reader.GetDecimal(6); //7:Parameter Status_Code of type String resultItem.Status_Code = reader.GetString(7); //8:Parameter Status_Name of type Dict resultItem.Status_Name = reader.GetDictionary(8); resultItem.Status_Name.SourceTable = "ord_cuo_customerorder_statuses"; loader.Append(resultItem.Status_Name); //9:Parameter GlobalPropertyMatchingID of type String resultItem.GlobalPropertyMatchingID = reader.GetString(9); //10:Parameter OrderCreatedBy of type String resultItem.OrderCreatedBy = reader.GetString(10); //11:Parameter IsCustomerOrderFinalized of type Boolean resultItem.IsCustomerOrderFinalized = reader.GetBoolean(11); //12:Parameter ConfirmedBy_DisplayName of type String resultItem.ConfirmedBy_DisplayName = reader.GetString(12); //13:Parameter Product_Name of type Dict resultItem.Product_Name = reader.GetDictionary(13); resultItem.Product_Name.SourceTable = "cmn_pro_products"; loader.Append(resultItem.Product_Name); //14:Parameter Product_Number of type String resultItem.Product_Number = reader.GetString(14); //15:Parameter CustomerOrder_Header_RefID of type Guid resultItem.CustomerOrder_Header_RefID = reader.GetGuid(15); //16:Parameter PackageContent_Amount of type String resultItem.PackageContent_Amount = reader.GetString(16); //17:Parameter PackageContent_MeasuredInUnit_RefID of type Guid resultItem.PackageContent_MeasuredInUnit_RefID = reader.GetGuid(17); //18:Parameter DosageForm_Name of type Dict resultItem.DosageForm_Name = reader.GetDictionary(18); resultItem.DosageForm_Name.SourceTable = "hec_product_dosageforms"; loader.Append(resultItem.DosageForm_Name); //19:Parameter Abbreviation of type Dict resultItem.Abbreviation = reader.GetDictionary(19); resultItem.Abbreviation.SourceTable = "cmn_units"; loader.Append(resultItem.Abbreviation); //20:Parameter Label of type Dict resultItem.Label = reader.GetDictionary(20); resultItem.Label.SourceTable = "cmn_units"; loader.Append(resultItem.Label); //21:Parameter ORD_CUO_CustomerOrder_PositionID of type Guid resultItem.ORD_CUO_CustomerOrder_PositionID = reader.GetGuid(21); //22:Parameter Position_Quantity of type double resultItem.Position_Quantity = reader.GetDouble(22); //23:Parameter Position_ValuePerUnit of type Decimal resultItem.Position_ValuePerUnit = reader.GetDecimal(23); //24:Parameter Position_ValueTotal of type Decimal resultItem.Position_ValueTotal = reader.GetDecimal(24); //25:Parameter TaxRate of type double resultItem.TaxRate = reader.GetDouble(25); //26:Parameter TaxName_DictID of type Dict resultItem.TaxName_DictID = reader.GetDictionary(26); resultItem.TaxName_DictID.SourceTable = "acc_tax_taxes"; loader.Append(resultItem.TaxName_DictID); //27:Parameter EconomicRegion_RefID of type Guid resultItem.EconomicRegion_RefID = reader.GetGuid(27); //28:Parameter ApplicableSalesTax_RefID of type Guid resultItem.ApplicableSalesTax_RefID = reader.GetGuid(28); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_CustomerOrderHeaders_with_Positions_notRelatedTo_CustomerInteractions", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = L5CO_GCOHwPnCI_0820_raw.Convert(results).ToArray(); return(returnStatus); }
private static List <ORM_HEC_CMT_OPT_UploadedDiagnosis_Medication> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction) { CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection(); List <ORM_HEC_CMT_OPT_UploadedDiagnosis_Medication> items; try { managedConnection.set(connectionString, connection, transaction); var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(managedConnection.getConnection(), managedConnection.getTransaction()); DbCommand command = managedConnection.manage(query.CreateSelectQuery(TableName)); query.SetParameters(command); items = new List <ORM_HEC_CMT_OPT_UploadedDiagnosis_Medication>(); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "HEC_CMT_OPT_UploadedDiagnosis_MedicationID", "UploadedDiagnosis_RefID", "IsProduct", "IfProduct_UploadedProductITL", "IsSubstance", "IfSubstance_Unit_ISOCode", "IfSubstance_UploadedSubstanceITL", "IfSubstance_Strength", "DosageText", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" }); while (reader.Read()) { ORM_HEC_CMT_OPT_UploadedDiagnosis_Medication item = new ORM_HEC_CMT_OPT_UploadedDiagnosis_Medication(); //0:Parameter HEC_CMT_OPT_UploadedDiagnosis_MedicationID of type Guid item.HEC_CMT_OPT_UploadedDiagnosis_MedicationID = reader.GetGuid(0); //1:Parameter UploadedDiagnosis_RefID of type Guid item.UploadedDiagnosis_RefID = reader.GetGuid(1); //2:Parameter IsProduct of type Boolean item.IsProduct = reader.GetBoolean(2); //3:Parameter IfProduct_UploadedProductITL of type String item.IfProduct_UploadedProductITL = reader.GetString(3); //4:Parameter IsSubstance of type Boolean item.IsSubstance = reader.GetBoolean(4); //5:Parameter IfSubstance_Unit_ISOCode of type String item.IfSubstance_Unit_ISOCode = reader.GetString(5); //6:Parameter IfSubstance_UploadedSubstanceITL of type String item.IfSubstance_UploadedSubstanceITL = reader.GetString(6); //7:Parameter IfSubstance_Strength of type String item.IfSubstance_Strength = reader.GetString(7); //8:Parameter DosageText of type String item.DosageText = reader.GetString(8); //9:Parameter Creation_Timestamp of type DateTime item.Creation_Timestamp = reader.GetDate(9); //10:Parameter Tenant_RefID of type Guid item.Tenant_RefID = reader.GetGuid(10); //11:Parameter IsDeleted of type Boolean item.IsDeleted = reader.GetBoolean(11); //12:Parameter Modification_Timestamp of type DateTime item.Modification_Timestamp = reader.GetDate(12); item.Status_IsAlreadySaved = true; item.Status_IsDirty = false; items.Add(item); } reader.Close(); loader.Load(); managedConnection.commit(); } catch (Exception ex) { managedConnection.rollback(); throw; } return(items); }