protected static FR_L2ER_GERfT_1643_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L2ER_GERfT_1643_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL2_EconomicRegion.Atomic.Retrieval.SQL.cls_Get_EconomicRegion_for_TenantID.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 <L2ER_GERfT_1643> results = new List <L2ER_GERfT_1643>(); 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_EconomicRegionID", "ParentEconomicRegion_RefID", "EconomicRegion_Name_DictID", "EconomicRegion_Description_DictID", "IsEconomicRegionCountry", "Creation_Timestamp", "IsDeleted", "Tenant_RefID", "Modification_Timestamp" }); while (reader.Read()) { L2ER_GERfT_1643 resultItem = new L2ER_GERfT_1643(); //0:Parameter CMN_EconomicRegionID of type Guid resultItem.CMN_EconomicRegionID = reader.GetGuid(0); //1:Parameter ParentEconomicRegion_RefID of type Guid resultItem.ParentEconomicRegion_RefID = reader.GetGuid(1); //2:Parameter EconomicRegion_Name of type Dict resultItem.EconomicRegion_Name = reader.GetDictionary(2); resultItem.EconomicRegion_Name.SourceTable = "cmn_economicregion"; loader.Append(resultItem.EconomicRegion_Name); //3:Parameter EconomicRegion_Description of type Dict resultItem.EconomicRegion_Description = reader.GetDictionary(3); resultItem.EconomicRegion_Description.SourceTable = "cmn_economicregion"; loader.Append(resultItem.EconomicRegion_Description); //4:Parameter IsEconomicRegionCountry of type bool resultItem.IsEconomicRegionCountry = reader.GetBoolean(4); //5:Parameter Creation_Timestamp of type DateTime resultItem.Creation_Timestamp = reader.GetDate(5); //6:Parameter IsDeleted of type bool resultItem.IsDeleted = reader.GetBoolean(6); //7:Parameter Tenant_RefID of type Guid resultItem.Tenant_RefID = reader.GetGuid(7); //8:Parameter Modification_Timestamp of type DateTime resultItem.Modification_Timestamp = reader.GetDate(8); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_EconomicRegion_for_TenantID", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.ToArray(); return(returnStatus); }
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_Catalog.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", "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 String resultItem.PackageContent_Amount = reader.GetString(7); //8:Parameter Product_Number of type String resultItem.Product_Number = reader.GetString(8); //9:Parameter Label_DictID of type Dict resultItem.Label_DictID = reader.GetDictionary(9); resultItem.Label_DictID.SourceTable = "cmn_units"; loader.Append(resultItem.Label_DictID); //10:Parameter Abbreviation_DictID of type Dict resultItem.Abbreviation_DictID = reader.GetDictionary(10); resultItem.Abbreviation_DictID.SourceTable = "cmn_units"; loader.Append(resultItem.Abbreviation_DictID); //11:Parameter ISOCode of type String resultItem.ISOCode = reader.GetString(11); //12:Parameter DosageForm_Name_DictID of type Dict resultItem.DosageForm_Name_DictID = reader.GetDictionary(12); resultItem.DosageForm_Name_DictID.SourceTable = "hec_product_dosageforms"; loader.Append(resultItem.DosageForm_Name_DictID); //13:Parameter DosageForm_Description_DictID of type Dict resultItem.DosageForm_Description_DictID = reader.GetDictionary(13); resultItem.DosageForm_Description_DictID.SourceTable = "hec_product_dosageforms"; loader.Append(resultItem.DosageForm_Description_DictID); //14:Parameter GlobalPropertyMatchingID of type String resultItem.GlobalPropertyMatchingID = reader.GetString(14); 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_L2_DT_GDTSfTaA_1337_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L2_DT_GDTSfTaA_1337_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL2_DeveloperTask.Atomic.Retrieval.SQL.cls_Get_DeveloperTask_Priorities_for_Tenant_and_Acount.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 <L2_DT_GDTSfTaA_1337> results = new List <L2_DT_GDTSfTaA_1337>(); 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[] { "TMS_PRO_DeveloperTask_PriorityID", "Label_DictID", "Description_DictID", "IconLocationURL", "Groups", "PriorityLevel", "IsPersistent", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Priority_Colour", "GlobalPropertyMatchingID" }); while (reader.Read()) { L2_DT_GDTSfTaA_1337 resultItem = new L2_DT_GDTSfTaA_1337(); //0:Parameter TMS_PRO_DeveloperTask_PriorityID of type Guid resultItem.TMS_PRO_DeveloperTask_PriorityID = reader.GetGuid(0); //1:Parameter Label of type Dict resultItem.Label = reader.GetDictionary(1); resultItem.Label.SourceTable = "tms_pro_developertask_priorities"; loader.Append(resultItem.Label); //2:Parameter Description of type Dict resultItem.Description = reader.GetDictionary(2); resultItem.Description.SourceTable = "tms_pro_developertask_priorities"; loader.Append(resultItem.Description); //3:Parameter IconLocationURL of type String resultItem.IconLocationURL = reader.GetString(3); //4:Parameter Groups of type String resultItem.Groups = reader.GetString(4); //5:Parameter PriorityLevel of type String resultItem.PriorityLevel = reader.GetString(5); //6:Parameter IsPersistent of type bool resultItem.IsPersistent = reader.GetBoolean(6); //7:Parameter Creation_Timestamp of type DateTime resultItem.Creation_Timestamp = reader.GetDate(7); //8:Parameter Tenant_RefID of type Guid resultItem.Tenant_RefID = reader.GetGuid(8); //9:Parameter IsDeleted of type bool resultItem.IsDeleted = reader.GetBoolean(9); //10:Parameter Priority_Colour of type String resultItem.Priority_Colour = reader.GetString(10); //11:Parameter GlobalPropertyMatchingID of type String resultItem.GlobalPropertyMatchingID = reader.GetString(11); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_DeveloperTask_Priorities_for_Tenant_and_Acount", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.ToArray(); return(returnStatus); }
private static List <ORM_CMN_PRO_Product_Variant> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction) { CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection(); List <ORM_CMN_PRO_Product_Variant> 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_CMN_PRO_Product_Variant>(); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "CMN_PRO_Product_VariantID", "ProductVariantITL", "VariantName_DictID", "CMN_PRO_Product_RefID", "ProductVariant_DocumentationStructure_RefID", "IsStandardProductVariant", "IsImportedFromExternalCatalog", "IsProductAvailableForOrdering", "IsObsolete", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" }); while (reader.Read()) { ORM_CMN_PRO_Product_Variant item = new ORM_CMN_PRO_Product_Variant(); //0:Parameter CMN_PRO_Product_VariantID of type Guid item.CMN_PRO_Product_VariantID = reader.GetGuid(0); //1:Parameter ProductVariantITL of type String item.ProductVariantITL = reader.GetString(1); //2:Parameter VariantName of type Dict item.VariantName = reader.GetDictionary(2); loader.Append(item.VariantName, TableName); //3:Parameter CMN_PRO_Product_RefID of type Guid item.CMN_PRO_Product_RefID = reader.GetGuid(3); //4:Parameter ProductVariant_DocumentationStructure_RefID of type Guid item.ProductVariant_DocumentationStructure_RefID = reader.GetGuid(4); //5:Parameter IsStandardProductVariant of type Boolean item.IsStandardProductVariant = reader.GetBoolean(5); //6:Parameter IsImportedFromExternalCatalog of type Boolean item.IsImportedFromExternalCatalog = reader.GetBoolean(6); //7:Parameter IsProductAvailableForOrdering of type Boolean item.IsProductAvailableForOrdering = reader.GetBoolean(7); //8:Parameter IsObsolete of type Boolean item.IsObsolete = reader.GetBoolean(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); }
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_ORD_CUO.ORD_CUO_CustomerOrder_Position.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 _ORD_CUO_CustomerOrder_PositionID = Guid.Empty; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ORD_CUO_CustomerOrder_PositionID", 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[] { "ORD_CUO_CustomerOrder_PositionID", "CustomerProcurementOrderPositionITL", "CustomerOrder_Header_RefID", "Position_OrdinalNumber", "Position_Quantity", "Position_ValuePerUnit", "Position_ValueTotal", "Position_Comment", "Position_Description", "Position_Unit_RefID", "Position_RequestedDateOfDelivery", "CMN_PRO_Product_Variant_RefID", "CMN_PRO_Product_RefID", "CMN_PRO_Product_Release_RefID", "IsProductReplacementAllowed", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" }); if (reader.HasRows == true) { reader.Read(); //Single result only //0:Parameter ORD_CUO_CustomerOrder_PositionID of type Guid _ORD_CUO_CustomerOrder_PositionID = reader.GetGuid(0); //1:Parameter CustomerProcurementOrderPositionITL of type String _CustomerProcurementOrderPositionITL = reader.GetString(1); //2:Parameter CustomerOrder_Header_RefID of type Guid _CustomerOrder_Header_RefID = reader.GetGuid(2); //3:Parameter Position_OrdinalNumber of type int _Position_OrdinalNumber = reader.GetInteger(3); //4:Parameter Position_Quantity of type Double _Position_Quantity = reader.GetDouble(4); //5:Parameter Position_ValuePerUnit of type Decimal _Position_ValuePerUnit = reader.GetDecimal(5); //6:Parameter Position_ValueTotal of type Decimal _Position_ValueTotal = reader.GetDecimal(6); //7:Parameter Position_Comment of type String _Position_Comment = reader.GetString(7); //8:Parameter Position_Description of type String _Position_Description = reader.GetString(8); //9:Parameter Position_Unit_RefID of type Guid _Position_Unit_RefID = reader.GetGuid(9); //10:Parameter Position_RequestedDateOfDelivery of type DateTime _Position_RequestedDateOfDelivery = reader.GetDate(10); //11:Parameter CMN_PRO_Product_Variant_RefID of type Guid _CMN_PRO_Product_Variant_RefID = reader.GetGuid(11); //12:Parameter CMN_PRO_Product_RefID of type Guid _CMN_PRO_Product_RefID = reader.GetGuid(12); //13:Parameter CMN_PRO_Product_Release_RefID of type Guid _CMN_PRO_Product_Release_RefID = reader.GetGuid(13); //14:Parameter IsProductReplacementAllowed of type Boolean _IsProductReplacementAllowed = reader.GetBoolean(14); //15:Parameter Creation_Timestamp of type DateTime _Creation_Timestamp = reader.GetDate(15); //16:Parameter Tenant_RefID of type Guid _Tenant_RefID = reader.GetGuid(16); //17:Parameter IsDeleted of type Boolean _IsDeleted = reader.GetBoolean(17); } //Close the reader so other connections can use it reader.Close(); loader.Load(); if (_ORD_CUO_CustomerOrder_PositionID != 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); }
protected static FR_L5EM_GEPN_1235 Execute(DbConnection Connection, DbTransaction Transaction, P_L5EM_GEPN_1235 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5EM_GEPN_1235(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_VacationPlanner_Employees.Atomic.Retrieval.SQL.cls_Get_EmployeePhoneNumbers.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_GEPN_1235_raw> results = new List <L5EM_GEPN_1235_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_BPT_EMP_EmployeeID", "FirstName", "LastName", "PrimaryEmail", "Title", "BirthDate", "Address_RefID", "ProfileImage_Document_RefID", "Creation_Timestamp", "CMN_BPT_BusinessParticipantID", "CMN_PER_PersonInfoID", "CMN_PER_CommunicationContactID", "CMN_PER_CommunicationContact_TypeID", "Content", "Type" }); while (reader.Read()) { L5EM_GEPN_1235_raw resultItem = new L5EM_GEPN_1235_raw(); //0:Parameter CMN_BPT_EMP_EmployeeID of type Guid resultItem.CMN_BPT_EMP_EmployeeID = reader.GetGuid(0); //1:Parameter FirstName of type String resultItem.FirstName = reader.GetString(1); //2:Parameter LastName of type String resultItem.LastName = reader.GetString(2); //3:Parameter PrimaryEmail of type String resultItem.PrimaryEmail = reader.GetString(3); //4:Parameter Title of type String resultItem.Title = reader.GetString(4); //5:Parameter BirthDate of type DateTime resultItem.BirthDate = reader.GetDate(5); //6:Parameter Address_RefID of type Guid resultItem.Address_RefID = reader.GetGuid(6); //7:Parameter ProfileImage_Document_RefID of type Guid resultItem.ProfileImage_Document_RefID = reader.GetGuid(7); //8:Parameter Creation_Timestamp of type DateTime resultItem.Creation_Timestamp = reader.GetDate(8); //9:Parameter CMN_BPT_BusinessParticipantID of type Guid resultItem.CMN_BPT_BusinessParticipantID = reader.GetGuid(9); //10:Parameter CMN_PER_PersonInfoID of type Guid resultItem.CMN_PER_PersonInfoID = reader.GetGuid(10); //11:Parameter CMN_PER_CommunicationContactID of type Guid resultItem.CMN_PER_CommunicationContactID = reader.GetGuid(11); //12:Parameter CMN_PER_CommunicationContact_TypeID of type Guid resultItem.CMN_PER_CommunicationContact_TypeID = reader.GetGuid(12); //13:Parameter Content of type String resultItem.Content = reader.GetString(13); //14:Parameter Type of type String resultItem.Type = reader.GetString(14); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw ex; } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = L5EM_GEPN_1235_raw.Convert(results).FirstOrDefault(); return(returnStatus); }
private static List <ORM_ORD_PRC_SPB_SupplierBill_Header> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction) { CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection(); List <ORM_ORD_PRC_SPB_SupplierBill_Header> 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_ORD_PRC_SPB_SupplierBill_Header>(); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "ORD_PRC_SPB_SupplierBill_HeaderID", "Supplier_RefID", "Currency_RefID", "SupplierBillNumber", "DateOnBill", "TotalValue_BeforeTax", "TotalValue_IncludingTax", "BillComment", "PaymentTargetDate", "CashDiscountInPercent", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" }); while (reader.Read()) { ORM_ORD_PRC_SPB_SupplierBill_Header item = new ORM_ORD_PRC_SPB_SupplierBill_Header(); //0:Parameter ORD_PRC_SPB_SupplierBill_HeaderID of type Guid item.ORD_PRC_SPB_SupplierBill_HeaderID = reader.GetGuid(0); //1:Parameter Supplier_RefID of type Guid item.Supplier_RefID = reader.GetGuid(1); //2:Parameter Currency_RefID of type Guid item.Currency_RefID = reader.GetGuid(2); //3:Parameter SupplierBillNumber of type String item.SupplierBillNumber = reader.GetString(3); //4:Parameter DateOnBill of type DateTime item.DateOnBill = reader.GetDate(4); //5:Parameter TotalValue_BeforeTax of type Decimal item.TotalValue_BeforeTax = reader.GetDecimal(5); //6:Parameter TotalValue_IncludingTax of type Decimal item.TotalValue_IncludingTax = reader.GetDecimal(6); //7:Parameter BillComment of type String item.BillComment = reader.GetString(7); //8:Parameter PaymentTargetDate of type DateTime item.PaymentTargetDate = reader.GetDate(8); //9:Parameter CashDiscountInPercent of type Double item.CashDiscountInPercent = reader.GetDouble(9); //10:Parameter Creation_Timestamp of type DateTime item.Creation_Timestamp = reader.GetDate(10); //11:Parameter Tenant_RefID of type Guid item.Tenant_RefID = reader.GetGuid(11); //12:Parameter IsDeleted of type Boolean item.IsDeleted = reader.GetBoolean(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); }
protected static FR_L5AR_GASfA_1520_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5AR_GASfA_1520 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5AR_GASfA_1520_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_APOAdmin_Articles.Atomic.Retrieval.SQL.cls_Get_ArticleStorages_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 <L5AR_GASfA_1520> results = new List <L5AR_GASfA_1520>(); 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[] { "LOG_WRH_QuantityLevelID", "Quantity_Minimum", "Quantity_RecommendedMinimumCalculation", "Quantity_Maximum", "ArticleID", "AreaID", "RackID", "QLAreaID", "QLRackID", "QLShelfID", "AreaCode", "RackCode", "ShelfCode", "IsPointOfSalesArea", "IsLongTermStorageArea", "LocationPriority", "PredefinedProductLocationID" }); while (reader.Read()) { L5AR_GASfA_1520 resultItem = new L5AR_GASfA_1520(); //0:Parameter LOG_WRH_QuantityLevelID of type Guid resultItem.LOG_WRH_QuantityLevelID = reader.GetGuid(0); //1:Parameter Quantity_Minimum of type Double resultItem.Quantity_Minimum = reader.GetDouble(1); //2:Parameter Quantity_RecommendedMinimumCalculation of type Double resultItem.Quantity_RecommendedMinimumCalculation = reader.GetDouble(2); //3:Parameter Quantity_Maximum of type Double resultItem.Quantity_Maximum = reader.GetDouble(3); //4:Parameter ArticleID of type Guid resultItem.ArticleID = reader.GetGuid(4); //5:Parameter AreaID of type Guid resultItem.AreaID = reader.GetGuid(5); //6:Parameter RackID of type Guid resultItem.RackID = reader.GetGuid(6); //7:Parameter QLAreaID of type Guid resultItem.QLAreaID = reader.GetGuid(7); //8:Parameter QLRackID of type Guid resultItem.QLRackID = reader.GetGuid(8); //9:Parameter QLShelfID of type Guid resultItem.QLShelfID = reader.GetGuid(9); //10:Parameter AreaCode of type string resultItem.AreaCode = reader.GetString(10); //11:Parameter RackCode of type string resultItem.RackCode = reader.GetString(11); //12:Parameter ShelfCode of type string resultItem.ShelfCode = reader.GetString(12); //13:Parameter IsPointOfSalesArea of type Boolean resultItem.IsPointOfSalesArea = reader.GetBoolean(13); //14:Parameter IsLongTermStorageArea of type Boolean resultItem.IsLongTermStorageArea = reader.GetBoolean(14); //15:Parameter LocationPriority of type int resultItem.LocationPriority = reader.GetInteger(15); //16:Parameter PredefinedProductLocationID of type Guid resultItem.PredefinedProductLocationID = reader.GetGuid(16); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_ArticleStorages_for_ArticleID", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.ToArray(); return(returnStatus); }
private static List <ORM_HEC_PRC_ProcurementOrder_Position> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction) { CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection(); List <ORM_HEC_PRC_ProcurementOrder_Position> 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_PRC_ProcurementOrder_Position>(); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "HEC_PRC_ProcurementOrder_PositionID", "Ext_ORD_PRC_ProcurementOrder_Position_RefID", "Clearing_Doctor_RefID", "ClearingDoctor_DisplayName", "OrderedFor_Patient_RefID", "OrderedForPatient_DisplayName", "OrderedFor_Doctor_RefID", "OrderedForDoctor_DisplayName", "IsOrderForPatient_PatientFeeWaived", "IfProFormaOrderPosition_PrintLabelOnly", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" }); while (reader.Read()) { ORM_HEC_PRC_ProcurementOrder_Position item = new ORM_HEC_PRC_ProcurementOrder_Position(); //0:Parameter HEC_PRC_ProcurementOrder_PositionID of type Guid item.HEC_PRC_ProcurementOrder_PositionID = reader.GetGuid(0); //1:Parameter Ext_ORD_PRC_ProcurementOrder_Position_RefID of type Guid item.Ext_ORD_PRC_ProcurementOrder_Position_RefID = reader.GetGuid(1); //2:Parameter Clearing_Doctor_RefID of type Guid item.Clearing_Doctor_RefID = reader.GetGuid(2); //3:Parameter ClearingDoctor_DisplayName of type String item.ClearingDoctor_DisplayName = reader.GetString(3); //4:Parameter OrderedFor_Patient_RefID of type Guid item.OrderedFor_Patient_RefID = reader.GetGuid(4); //5:Parameter OrderedForPatient_DisplayName of type String item.OrderedForPatient_DisplayName = reader.GetString(5); //6:Parameter OrderedFor_Doctor_RefID of type Guid item.OrderedFor_Doctor_RefID = reader.GetGuid(6); //7:Parameter OrderedForDoctor_DisplayName of type String item.OrderedForDoctor_DisplayName = reader.GetString(7); //8:Parameter IsOrderForPatient_PatientFeeWaived of type Boolean item.IsOrderForPatient_PatientFeeWaived = reader.GetBoolean(8); //9:Parameter IfProFormaOrderPosition_PrintLabelOnly of type Boolean item.IfProFormaOrderPosition_PrintLabelOnly = reader.GetBoolean(9); //10:Parameter Creation_Timestamp of type DateTime item.Creation_Timestamp = reader.GetDate(10); //11:Parameter Tenant_RefID of type Guid item.Tenant_RefID = reader.GetGuid(11); //12:Parameter IsDeleted of type Boolean item.IsDeleted = reader.GetBoolean(12); //13:Parameter Modification_Timestamp of type DateTime item.Modification_Timestamp = reader.GetDate(13); 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); }
private static List <ORM_CMN_BPT_STR_Office_SettingsProfile> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction) { CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection(); List <ORM_CMN_BPT_STR_Office_SettingsProfile> 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_CMN_BPT_STR_Office_SettingsProfile>(); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "CMN_BPT_STR_Office_SettingsProfileID", "Office_RefID", "AdulthoodAge", "RestWarningThreshold_Adults_in_mins", "RestWarningThreshold_NonAdults_in_mins", "RestMinimumThresholdl_Adults_in_mins", "RestMinimumThresholdl_NonAdults_in_mins", "WorkTimeWarningTreshold_Adults_in_mins", "WorkTimeWarningTreshold_NonAdults_in_mins", "WorkTimeMaximumTreshold_Adults_in_mins", "WorkTimeMaximumTreshold_NonAdults_in_mins", "WorkStartTimeWarning_NonAdults_in_mins", "WorkStartTimeMinimum_NonAdults_in_mins", "WorkEndTimeWarning_NonAdults_in_mins", "WorkEndTimeMaximum_NonAdults_in_mins", "WorktimeBalancePeriod_in_months", "WorkdayStart_in_mins", "RoosterGridMinimumPlanningUnit_in_mins", "MaximumPreWork_Period_in_mins", "MaximumPostWork_Period_in_mins", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" }); while (reader.Read()) { ORM_CMN_BPT_STR_Office_SettingsProfile item = new ORM_CMN_BPT_STR_Office_SettingsProfile(); //0:Parameter CMN_BPT_STR_Office_SettingsProfileID of type Guid item.CMN_BPT_STR_Office_SettingsProfileID = reader.GetGuid(0); //1:Parameter Office_RefID of type Guid item.Office_RefID = reader.GetGuid(1); //2:Parameter AdulthoodAge of type int item.AdulthoodAge = reader.GetInteger(2); //3:Parameter RestWarningThreshold_Adults_in_mins of type int item.RestWarningThreshold_Adults_in_mins = reader.GetInteger(3); //4:Parameter RestWarningThreshold_NonAdults_in_mins of type int item.RestWarningThreshold_NonAdults_in_mins = reader.GetInteger(4); //5:Parameter RestMinimumThresholdl_Adults_in_mins of type int item.RestMinimumThresholdl_Adults_in_mins = reader.GetInteger(5); //6:Parameter RestMinimumThresholdl_NonAdults_in_mins of type int item.RestMinimumThresholdl_NonAdults_in_mins = reader.GetInteger(6); //7:Parameter WorkTimeWarningTreshold_Adults_in_mins of type int item.WorkTimeWarningTreshold_Adults_in_mins = reader.GetInteger(7); //8:Parameter WorkTimeWarningTreshold_NonAdults_in_mins of type int item.WorkTimeWarningTreshold_NonAdults_in_mins = reader.GetInteger(8); //9:Parameter WorkTimeMaximumTreshold_Adults_in_mins of type int item.WorkTimeMaximumTreshold_Adults_in_mins = reader.GetInteger(9); //10:Parameter WorkTimeMaximumTreshold_NonAdults_in_mins of type int item.WorkTimeMaximumTreshold_NonAdults_in_mins = reader.GetInteger(10); //11:Parameter WorkStartTimeWarning_NonAdults_in_mins of type int item.WorkStartTimeWarning_NonAdults_in_mins = reader.GetInteger(11); //12:Parameter WorkStartTimeMinimum_NonAdults_in_mins of type int item.WorkStartTimeMinimum_NonAdults_in_mins = reader.GetInteger(12); //13:Parameter WorkEndTimeWarning_NonAdults_in_mins of type int item.WorkEndTimeWarning_NonAdults_in_mins = reader.GetInteger(13); //14:Parameter WorkEndTimeMaximum_NonAdults_in_mins of type int item.WorkEndTimeMaximum_NonAdults_in_mins = reader.GetInteger(14); //15:Parameter WorktimeBalancePeriod_in_months of type int item.WorktimeBalancePeriod_in_months = reader.GetInteger(15); //16:Parameter WorkdayStart_in_mins of type int item.WorkdayStart_in_mins = reader.GetInteger(16); //17:Parameter RoosterGridMinimumPlanningUnit_in_mins of type int item.RoosterGridMinimumPlanningUnit_in_mins = reader.GetInteger(17); //18:Parameter MaximumPreWork_Period_in_mins of type int item.MaximumPreWork_Period_in_mins = reader.GetInteger(18); //19:Parameter MaximumPostWork_Period_in_mins of type int item.MaximumPostWork_Period_in_mins = reader.GetInteger(19); //20:Parameter Creation_Timestamp of type DateTime item.Creation_Timestamp = reader.GetDate(20); //21:Parameter Tenant_RefID of type Guid item.Tenant_RefID = reader.GetGuid(21); //22:Parameter IsDeleted of type Boolean item.IsDeleted = reader.GetBoolean(22); 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_L3_PIfT_1237_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L3_PIfT_1237 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L3_PIfT_1237_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CLE_L3_Patients.Atomic.Retrieval.SQL.cls_PatientInfos_for_Tennant.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_PIfT_1237_raw> results = new List <L3_PIfT_1237_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_PER_PersonInfoID", "FirstName", "LastName", "PrimaryEmail", "BirthDate", "HEC_PatientID", "CMN_BPT_BusinessParticipant_RefID", "Creation_Timestamp", "IsDeleted", "Tenant_RefID", "Gender", "AgeCalculation_YearOfBirth", "DefaultLanguage_RefID", "Modification_TimestampBP", "Modification_TimestampPatient", "Modification_TimestampPersoInfo", "Modification_TimestampCommunicationContact", "Modification_TimestampContactType", "CMN_PER_CommunicationContactID", "Contact_Type", "Content", "IsDefaultForContactType" }); while (reader.Read()) { L3_PIfT_1237_raw resultItem = new L3_PIfT_1237_raw(); //0:Parameter CMN_PER_PersonInfoID of type Guid resultItem.CMN_PER_PersonInfoID = reader.GetGuid(0); //1:Parameter FirstName of type String resultItem.FirstName = reader.GetString(1); //2:Parameter LastName of type String resultItem.LastName = reader.GetString(2); //3:Parameter PrimaryEmail of type String resultItem.PrimaryEmail = reader.GetString(3); //4:Parameter BirthDate of type DateTime resultItem.BirthDate = reader.GetDate(4); //5:Parameter HEC_PatientID of type Guid resultItem.HEC_PatientID = reader.GetGuid(5); //6:Parameter CMN_BPT_BusinessParticipant_RefID of type Guid resultItem.CMN_BPT_BusinessParticipant_RefID = reader.GetGuid(6); //7:Parameter Creation_Timestamp of type DateTime resultItem.Creation_Timestamp = reader.GetDate(7); //8:Parameter IsDeleted of type bool resultItem.IsDeleted = reader.GetBoolean(8); //9:Parameter Tenant_RefID of type Guid resultItem.Tenant_RefID = reader.GetGuid(9); //10:Parameter Gender of type int resultItem.Gender = reader.GetInteger(10); //11:Parameter AgeCalculation_YearOfBirth of type int resultItem.AgeCalculation_YearOfBirth = reader.GetInteger(11); //12:Parameter DefaultLanguage_RefID of type Guid resultItem.DefaultLanguage_RefID = reader.GetGuid(12); //13:Parameter Modification_TimestampBP of type DateTime resultItem.Modification_TimestampBP = reader.GetDate(13); //14:Parameter Modification_TimestampPatient of type DateTime resultItem.Modification_TimestampPatient = reader.GetDate(14); //15:Parameter Modification_TimestampPersoInfo of type DateTime resultItem.Modification_TimestampPersoInfo = reader.GetDate(15); //16:Parameter Modification_TimestampCommunicationContact of type DateTime resultItem.Modification_TimestampCommunicationContact = reader.GetDate(16); //17:Parameter Modification_TimestampContactType of type DateTime resultItem.Modification_TimestampContactType = reader.GetDate(17); //18:Parameter CMN_PER_CommunicationContactID of type Guid resultItem.CMN_PER_CommunicationContactID = reader.GetGuid(18); //19:Parameter Contact_Type of type Guid resultItem.Contact_Type = reader.GetGuid(19); //20:Parameter Content of type String resultItem.Content = reader.GetString(20); //21:Parameter IsDefaultForContactType of type bool resultItem.IsDefaultForContactType = reader.GetBoolean(21); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_PatientInfos_for_Tennant", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = L3_PIfT_1237_raw.Convert(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 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_CMN_BPT_STR.CMN_BPT_STR_Office_SettingsProfile.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 _CMN_BPT_STR_Office_SettingsProfileID = Guid.Empty; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CMN_BPT_STR_Office_SettingsProfileID", 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[] { "CMN_BPT_STR_Office_SettingsProfileID", "Office_RefID", "AdulthoodAge", "RestWarningThreshold_Adults_in_mins", "RestWarningThreshold_NonAdults_in_mins", "RestMinimumThresholdl_Adults_in_mins", "RestMinimumThresholdl_NonAdults_in_mins", "WorkTimeWarningTreshold_Adults_in_mins", "WorkTimeWarningTreshold_NonAdults_in_mins", "WorkTimeMaximumTreshold_Adults_in_mins", "WorkTimeMaximumTreshold_NonAdults_in_mins", "WorkStartTimeWarning_NonAdults_in_mins", "WorkStartTimeMinimum_NonAdults_in_mins", "WorkEndTimeWarning_NonAdults_in_mins", "WorkEndTimeMaximum_NonAdults_in_mins", "WorktimeBalancePeriod_in_months", "WorkdayStart_in_mins", "RoosterGridMinimumPlanningUnit_in_mins", "MaximumPreWork_Period_in_mins", "MaximumPostWork_Period_in_mins", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" }); if (reader.HasRows == true) { reader.Read(); //Single result only //0:Parameter CMN_BPT_STR_Office_SettingsProfileID of type Guid _CMN_BPT_STR_Office_SettingsProfileID = reader.GetGuid(0); //1:Parameter Office_RefID of type Guid _Office_RefID = reader.GetGuid(1); //2:Parameter AdulthoodAge of type int _AdulthoodAge = reader.GetInteger(2); //3:Parameter RestWarningThreshold_Adults_in_mins of type int _RestWarningThreshold_Adults_in_mins = reader.GetInteger(3); //4:Parameter RestWarningThreshold_NonAdults_in_mins of type int _RestWarningThreshold_NonAdults_in_mins = reader.GetInteger(4); //5:Parameter RestMinimumThresholdl_Adults_in_mins of type int _RestMinimumThresholdl_Adults_in_mins = reader.GetInteger(5); //6:Parameter RestMinimumThresholdl_NonAdults_in_mins of type int _RestMinimumThresholdl_NonAdults_in_mins = reader.GetInteger(6); //7:Parameter WorkTimeWarningTreshold_Adults_in_mins of type int _WorkTimeWarningTreshold_Adults_in_mins = reader.GetInteger(7); //8:Parameter WorkTimeWarningTreshold_NonAdults_in_mins of type int _WorkTimeWarningTreshold_NonAdults_in_mins = reader.GetInteger(8); //9:Parameter WorkTimeMaximumTreshold_Adults_in_mins of type int _WorkTimeMaximumTreshold_Adults_in_mins = reader.GetInteger(9); //10:Parameter WorkTimeMaximumTreshold_NonAdults_in_mins of type int _WorkTimeMaximumTreshold_NonAdults_in_mins = reader.GetInteger(10); //11:Parameter WorkStartTimeWarning_NonAdults_in_mins of type int _WorkStartTimeWarning_NonAdults_in_mins = reader.GetInteger(11); //12:Parameter WorkStartTimeMinimum_NonAdults_in_mins of type int _WorkStartTimeMinimum_NonAdults_in_mins = reader.GetInteger(12); //13:Parameter WorkEndTimeWarning_NonAdults_in_mins of type int _WorkEndTimeWarning_NonAdults_in_mins = reader.GetInteger(13); //14:Parameter WorkEndTimeMaximum_NonAdults_in_mins of type int _WorkEndTimeMaximum_NonAdults_in_mins = reader.GetInteger(14); //15:Parameter WorktimeBalancePeriod_in_months of type int _WorktimeBalancePeriod_in_months = reader.GetInteger(15); //16:Parameter WorkdayStart_in_mins of type int _WorkdayStart_in_mins = reader.GetInteger(16); //17:Parameter RoosterGridMinimumPlanningUnit_in_mins of type int _RoosterGridMinimumPlanningUnit_in_mins = reader.GetInteger(17); //18:Parameter MaximumPreWork_Period_in_mins of type int _MaximumPreWork_Period_in_mins = reader.GetInteger(18); //19:Parameter MaximumPostWork_Period_in_mins of type int _MaximumPostWork_Period_in_mins = reader.GetInteger(19); //20:Parameter Creation_Timestamp of type DateTime _Creation_Timestamp = reader.GetDate(20); //21:Parameter Tenant_RefID of type Guid _Tenant_RefID = reader.GetGuid(21); //22:Parameter IsDeleted of type Boolean _IsDeleted = reader.GetBoolean(22); } //Close the reader so other connections can use it reader.Close(); loader.Load(); if (_CMN_BPT_STR_Office_SettingsProfileID != 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_CAS_GCBDoT_1048_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_CAS_GCBDoT_1048_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "MMDocConnectDBMethods.Case.Atomic.Retrieval.SQL.cls_Get_Case_BillingData_on_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; List <CAS_GCBDoT_1048> results = new List <CAS_GCBDoT_1048>(); 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[] { "case_id", "case_number", "bill_position_id", "gpos_id", "fs_status_key", "fs_status_code", "bill_position_number", "gpos_code", "gpos_price", "gpos_type", "hec_bill_position_id", "fs_status_id" }); while (reader.Read()) { CAS_GCBDoT_1048 resultItem = new CAS_GCBDoT_1048(); //0:Parameter case_id of type Guid resultItem.case_id = reader.GetGuid(0); //1:Parameter case_number of type String resultItem.case_number = reader.GetString(1); //2:Parameter bill_position_id of type Guid resultItem.bill_position_id = reader.GetGuid(2); //3:Parameter gpos_id of type Guid resultItem.gpos_id = reader.GetGuid(3); //4:Parameter fs_status_key of type String resultItem.fs_status_key = reader.GetString(4); //5:Parameter fs_status_code of type int resultItem.fs_status_code = reader.GetInteger(5); //6:Parameter bill_position_number of type String resultItem.bill_position_number = reader.GetString(6); //7:Parameter gpos_code of type String resultItem.gpos_code = reader.GetString(7); //8:Parameter gpos_price of type double resultItem.gpos_price = reader.GetDouble(8); //9:Parameter gpos_type of type String resultItem.gpos_type = reader.GetString(9); //10:Parameter hec_bill_position_id of type Guid resultItem.hec_bill_position_id = reader.GetGuid(10); //11:Parameter fs_status_id of type Guid resultItem.fs_status_id = reader.GetGuid(11); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_Case_BillingData_on_Tenant", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.ToArray(); return(returnStatus); }
private static List <ORM_HEC_PAT_Ki67_SpecimenAnalysis> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction) { CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection(); List <ORM_HEC_PAT_Ki67_SpecimenAnalysis> 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_PAT_Ki67_SpecimenAnalysis>(); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "HEC_PAT_Ki67_SpecimenAnalysisID", "Analysis_Name", "AnalysisPersistedBy_Account_RefID", "Specimen_RefID", "AnalysisResults", "CellMap_Document_RefID", "MarkupNoFill_Document_RefID", "MarkupFill_Document_RefID", "IsReportCreated", "IfReportCreated_Report_Document_RefID", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" }); while (reader.Read()) { ORM_HEC_PAT_Ki67_SpecimenAnalysis item = new ORM_HEC_PAT_Ki67_SpecimenAnalysis(); //0:Parameter HEC_PAT_Ki67_SpecimenAnalysisID of type Guid item.HEC_PAT_Ki67_SpecimenAnalysisID = reader.GetGuid(0); //1:Parameter Analysis_Name of type String item.Analysis_Name = reader.GetString(1); //2:Parameter AnalysisPersistedBy_Account_RefID of type Guid item.AnalysisPersistedBy_Account_RefID = reader.GetGuid(2); //3:Parameter Specimen_RefID of type Guid item.Specimen_RefID = reader.GetGuid(3); //4:Parameter AnalysisResults of type String item.AnalysisResults = reader.GetString(4); //5:Parameter CellMap_Document_RefID of type Guid item.CellMap_Document_RefID = reader.GetGuid(5); //6:Parameter MarkupNoFill_Document_RefID of type Guid item.MarkupNoFill_Document_RefID = reader.GetGuid(6); //7:Parameter MarkupFill_Document_RefID of type Guid item.MarkupFill_Document_RefID = reader.GetGuid(7); //8:Parameter IsReportCreated of type Boolean item.IsReportCreated = reader.GetBoolean(8); //9:Parameter IfReportCreated_Report_Document_RefID of type Guid item.IfReportCreated_Report_Document_RefID = reader.GetGuid(9); //10:Parameter Creation_Timestamp of type DateTime item.Creation_Timestamp = reader.GetDate(10); //11:Parameter IsDeleted of type Boolean item.IsDeleted = reader.GetBoolean(11); //12:Parameter Tenant_RefID of type Guid item.Tenant_RefID = reader.GetGuid(12); 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_L5PP_GSHDwPfS_1428_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5PP_GSHDaDOwPfS_1428 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5PP_GSHDwPfS_1428_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_Zugseil_PickingPreparation.Atomic.Retrieval.SQL.cls_Get_ShippmentHeaderDetails_and_DistributionOrder_with_Positions_for_ShipmentID.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, "ShipmentHeaderID", Parameter.ShipmentHeaderID); List <L5PP_GSHDaDOwPfS_1428> results = new List <L5PP_GSHDaDOwPfS_1428>(); 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[] { "LOG_SHP_Shipment_HeaderID", "ShipmentHeader_Number", "LOG_SHP_Shipment_PositionID", "CMN_PRO_ProductID", "Product_Name_DictID", "Product_Number", "CMN_PRO_Product_VariantID", "VariantName_DictID", "Quantity", "ORD_DIS_DistributionOrder_PositionID", "DistributionOrder_Header_RefID", "ORD_DIS_DistributionOrder_HeaderID", "DistributionOrderDate", "DistributionOrderNumber", "CMN_STR_CostCenterID", "Name_DictID", "CMN_STR_OfficeID", "Office_Name_DictID", "Office_InternalName", "IsShippingAddress", "IsBillingAddress", "IsSpecialAddress", "IsDefault", "CMN_AddressID", "Street_Name", "Street_Number", "City_Name", "City_PostalCode", "Country_Name", "Country_ISOCode", "ShipmentCreationDate" }); while (reader.Read()) { L5PP_GSHDaDOwPfS_1428 resultItem = new L5PP_GSHDaDOwPfS_1428(); //0:Parameter LOG_SHP_Shipment_HeaderID of type Guid resultItem.LOG_SHP_Shipment_HeaderID = reader.GetGuid(0); //1:Parameter ShipmentHeader_Number of type String resultItem.ShipmentHeader_Number = reader.GetString(1); //2:Parameter LOG_SHP_Shipment_PositionID of type Guid resultItem.LOG_SHP_Shipment_PositionID = reader.GetGuid(2); //3:Parameter CMN_PRO_ProductID of type Guid resultItem.CMN_PRO_ProductID = reader.GetGuid(3); //4:Parameter Product_Name of type Dict resultItem.Product_Name = reader.GetDictionary(4); resultItem.Product_Name.SourceTable = "cmn_pro_products"; loader.Append(resultItem.Product_Name); //5:Parameter Product_Number of type String resultItem.Product_Number = reader.GetString(5); //6:Parameter CMN_PRO_Product_VariantID of type Guid resultItem.CMN_PRO_Product_VariantID = reader.GetGuid(6); //7:Parameter VariantName of type Dict resultItem.VariantName = reader.GetDictionary(7); resultItem.VariantName.SourceTable = "cmn_pro_product_variants"; loader.Append(resultItem.VariantName); //8:Parameter Quantity of type String resultItem.Quantity = reader.GetString(8); //9:Parameter ORD_DIS_DistributionOrder_PositionID of type Guid resultItem.ORD_DIS_DistributionOrder_PositionID = reader.GetGuid(9); //10:Parameter DistributionOrder_Header_RefID of type Guid resultItem.DistributionOrder_Header_RefID = reader.GetGuid(10); //11:Parameter ORD_DIS_DistributionOrder_HeaderID of type Guid resultItem.ORD_DIS_DistributionOrder_HeaderID = reader.GetGuid(11); //12:Parameter DistributionOrderDate of type DateTime resultItem.DistributionOrderDate = reader.GetDate(12); //13:Parameter DistributionOrderNumber of type String resultItem.DistributionOrderNumber = reader.GetString(13); //14:Parameter CMN_STR_CostCenterID of type Guid resultItem.CMN_STR_CostCenterID = reader.GetGuid(14); //15:Parameter Name of type Dict resultItem.Name = reader.GetDictionary(15); resultItem.Name.SourceTable = "cmn_str_costcenters"; loader.Append(resultItem.Name); //16:Parameter CMN_STR_OfficeID of type Guid resultItem.CMN_STR_OfficeID = reader.GetGuid(16); //17:Parameter Office_Name of type Dict resultItem.Office_Name = reader.GetDictionary(17); resultItem.Office_Name.SourceTable = "cmn_str_offices"; loader.Append(resultItem.Office_Name); //18:Parameter Office_InternalName of type String resultItem.Office_InternalName = reader.GetString(18); //19:Parameter IsShippingAddress of type bool resultItem.IsShippingAddress = reader.GetBoolean(19); //20:Parameter IsBillingAddress of type bool resultItem.IsBillingAddress = reader.GetBoolean(20); //21:Parameter IsSpecialAddress of type bool resultItem.IsSpecialAddress = reader.GetBoolean(21); //22:Parameter IsDefault of type bool resultItem.IsDefault = reader.GetBoolean(22); //23:Parameter CMN_AddressID of type Guid resultItem.CMN_AddressID = reader.GetGuid(23); //24:Parameter Street_Name of type String resultItem.Street_Name = reader.GetString(24); //25:Parameter Street_Number of type String resultItem.Street_Number = reader.GetString(25); //26:Parameter City_Name of type String resultItem.City_Name = reader.GetString(26); //27:Parameter City_PostalCode of type String resultItem.City_PostalCode = reader.GetString(27); //28:Parameter Country_Name of type String resultItem.Country_Name = reader.GetString(28); //29:Parameter Country_ISOCode of type String resultItem.Country_ISOCode = reader.GetString(29); //30:Parameter ShipmentCreationDate of type DateTime resultItem.ShipmentCreationDate = reader.GetDate(30); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_ShippmentHeaderDetails_and_DistributionOrder_with_Positions_for_ShipmentID", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.ToArray(); return(returnStatus); }
private static List <ORM_HEC_Patient_Finding> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction) { CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection(); List <ORM_HEC_Patient_Finding> 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_Finding>(); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "HEC_Patient_FindingID", "Patient_RefID", "DateOfFindings", "MedicalPractice_RefID", "MedicalPracticeType_RefID", "UndersigningDoctor_RefID", "IsFindingFromReferral", "IfFindingFromReferral_Referral_RefID", "IsFindingFromProcedure", "IfFindingFromProcedure_ActionProcedure_RefID", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" }); while (reader.Read()) { ORM_HEC_Patient_Finding item = new ORM_HEC_Patient_Finding(); //0:Parameter HEC_Patient_FindingID of type Guid item.HEC_Patient_FindingID = reader.GetGuid(0); //1:Parameter Patient_RefID of type Guid item.Patient_RefID = reader.GetGuid(1); //2:Parameter DateOfFindings of type DateTime item.DateOfFindings = reader.GetDate(2); //3:Parameter MedicalPractice_RefID of type Guid item.MedicalPractice_RefID = reader.GetGuid(3); //4:Parameter MedicalPracticeType_RefID of type Guid item.MedicalPracticeType_RefID = reader.GetGuid(4); //5:Parameter UndersigningDoctor_RefID of type Guid item.UndersigningDoctor_RefID = reader.GetGuid(5); //6:Parameter IsFindingFromReferral of type Boolean item.IsFindingFromReferral = reader.GetBoolean(6); //7:Parameter IfFindingFromReferral_Referral_RefID of type Guid item.IfFindingFromReferral_Referral_RefID = reader.GetGuid(7); //8:Parameter IsFindingFromProcedure of type Boolean item.IsFindingFromProcedure = reader.GetBoolean(8); //9:Parameter IfFindingFromProcedure_ActionProcedure_RefID of type Guid item.IfFindingFromProcedure_ActionProcedure_RefID = reader.GetGuid(9); //10:Parameter Creation_Timestamp of type DateTime item.Creation_Timestamp = reader.GetDate(10); //11:Parameter Tenant_RefID of type Guid item.Tenant_RefID = reader.GetGuid(11); //12:Parameter IsDeleted of type Boolean item.IsDeleted = reader.GetBoolean(12); //13:Parameter Modification_Timestamp of type DateTime item.Modification_Timestamp = reader.GetDate(13); 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); }
protected static FR_L5EM_GERTFFETF_1129 Execute(DbConnection Connection, DbTransaction Transaction, P_L5EM_GERTFFETF_1129 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5EM_GERTFFETF_1129(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_VacationPlanner_Employees.Atomic.Retrieval.SQL.cls_Get_EmploymentRelationshipTimeFrame_For_Employee_And_TimeFrame.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, "CalculationTimeframeID", Parameter.CalculationTimeframeID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "EmployeeID", Parameter.EmployeeID); List <L5EM_GERTFFETF_1129> results = new List <L5EM_GERTFFETF_1129>(); 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_CAL_CalculationTimeframeID", "CalculationTimeframe_StartDate", "CalculationTimefrate_EndDate", "CalculationTimeframe_EstimatedEndDate", "IsCalculationTimeframe_Active", "CMN_BPT_EMP_EmploymentRelationship_TimeframeID", "CalculationTimeframe_RefID", "CMN_BPT_EMP_EmploymentRelationshipID", "HasWorkRelationEnded", "Work_StartDate", "Work_EndDate", "IsLockedFor_TemplateUpdates", "InstanceOf_EmploymentRelationships_Template_RefID", "CMN_BPT_EMP_EmployeeID", "BusinessParticipant_RefID", "Staff_Number", "StandardFunction", "EmployeeDocument_Structure_RefID" }); while (reader.Read()) { L5EM_GERTFFETF_1129 resultItem = new L5EM_GERTFFETF_1129(); //0:Parameter CMN_CAL_CalculationTimeframeID of type Guid resultItem.CMN_CAL_CalculationTimeframeID = reader.GetGuid(0); //1:Parameter CalculationTimeframe_StartDate of type DateTime resultItem.CalculationTimeframe_StartDate = reader.GetDate(1); //2:Parameter CalculationTimefrate_EndDate of type DateTime resultItem.CalculationTimefrate_EndDate = reader.GetDate(2); //3:Parameter CalculationTimeframe_EstimatedEndDate of type DateTime resultItem.CalculationTimeframe_EstimatedEndDate = reader.GetDate(3); //4:Parameter IsCalculationTimeframe_Active of type bool resultItem.IsCalculationTimeframe_Active = reader.GetBoolean(4); //5:Parameter CMN_BPT_EMP_EmploymentRelationship_TimeframeID of type Guid resultItem.CMN_BPT_EMP_EmploymentRelationship_TimeframeID = reader.GetGuid(5); //6:Parameter CalculationTimeframe_RefID of type Guid resultItem.CalculationTimeframe_RefID = reader.GetGuid(6); //7:Parameter CMN_BPT_EMP_EmploymentRelationshipID of type Guid resultItem.CMN_BPT_EMP_EmploymentRelationshipID = reader.GetGuid(7); //8:Parameter HasWorkRelationEnded of type bool resultItem.HasWorkRelationEnded = reader.GetBoolean(8); //9:Parameter Work_StartDate of type DateTime resultItem.Work_StartDate = reader.GetDate(9); //10:Parameter Work_EndDate of type DateTime resultItem.Work_EndDate = reader.GetDate(10); //11:Parameter IsLockedFor_TemplateUpdates of type bool resultItem.IsLockedFor_TemplateUpdates = reader.GetBoolean(11); //12:Parameter InstanceOf_EmploymentRelationships_Template_RefID of type Guid resultItem.InstanceOf_EmploymentRelationships_Template_RefID = reader.GetGuid(12); //13:Parameter CMN_BPT_EMP_EmployeeID of type Guid resultItem.CMN_BPT_EMP_EmployeeID = reader.GetGuid(13); //14:Parameter BusinessParticipant_RefID of type Guid resultItem.BusinessParticipant_RefID = reader.GetGuid(14); //15:Parameter Staff_Number of type String resultItem.Staff_Number = reader.GetString(15); //16:Parameter StandardFunction of type String resultItem.StandardFunction = reader.GetString(16); //17:Parameter EmployeeDocument_Structure_RefID of type Guid resultItem.EmployeeDocument_Structure_RefID = reader.GetGuid(17); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_EmploymentRelationshipTimeFrame_For_Employee_And_TimeFrame", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.FirstOrDefault(); return(returnStatus); }
private static List <ORM_CMN_SLS_Pricelist_Discount> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction) { CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection(); List <ORM_CMN_SLS_Pricelist_Discount> 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_CMN_SLS_Pricelist_Discount>(); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "CMN_SLS_Pricelist_DiscountID", "PricelistVersion_RefID", "ProductGroup_RefID", "Product_RefID", "Product_Variant_RefID", "Product_Release_RefID", "DiscountPercentAmount", "DiscountValid_From", "DiscountValid_To", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" }); while (reader.Read()) { ORM_CMN_SLS_Pricelist_Discount item = new ORM_CMN_SLS_Pricelist_Discount(); //0:Parameter CMN_SLS_Pricelist_DiscountID of type Guid item.CMN_SLS_Pricelist_DiscountID = reader.GetGuid(0); //1:Parameter PricelistVersion_RefID of type Guid item.PricelistVersion_RefID = reader.GetGuid(1); //2:Parameter ProductGroup_RefID of type Guid item.ProductGroup_RefID = reader.GetGuid(2); //3:Parameter Product_RefID of type Guid item.Product_RefID = reader.GetGuid(3); //4:Parameter Product_Variant_RefID of type Guid item.Product_Variant_RefID = reader.GetGuid(4); //5:Parameter Product_Release_RefID of type Guid item.Product_Release_RefID = reader.GetGuid(5); //6:Parameter DiscountPercentAmount of type Decimal item.DiscountPercentAmount = reader.GetDecimal(6); //7:Parameter DiscountValid_From of type DateTime item.DiscountValid_From = reader.GetDate(7); //8:Parameter DiscountValid_To of type DateTime item.DiscountValid_To = reader.GetDate(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); 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); }
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_ORD_PRC.ORD_PRC_SPB_SupplierBill_Header.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 _ORD_PRC_SPB_SupplierBill_HeaderID = Guid.Empty; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ORD_PRC_SPB_SupplierBill_HeaderID", 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[] { "ORD_PRC_SPB_SupplierBill_HeaderID", "Supplier_RefID", "Currency_RefID", "SupplierBillNumber", "DateOnBill", "TotalValue_BeforeTax", "TotalValue_IncludingTax", "BillComment", "PaymentTargetDate", "CashDiscountInPercent", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" }); if (reader.HasRows == true) { reader.Read(); //Single result only //0:Parameter ORD_PRC_SPB_SupplierBill_HeaderID of type Guid _ORD_PRC_SPB_SupplierBill_HeaderID = reader.GetGuid(0); //1:Parameter Supplier_RefID of type Guid _Supplier_RefID = reader.GetGuid(1); //2:Parameter Currency_RefID of type Guid _Currency_RefID = reader.GetGuid(2); //3:Parameter SupplierBillNumber of type String _SupplierBillNumber = reader.GetString(3); //4:Parameter DateOnBill of type DateTime _DateOnBill = reader.GetDate(4); //5:Parameter TotalValue_BeforeTax of type Decimal _TotalValue_BeforeTax = reader.GetDecimal(5); //6:Parameter TotalValue_IncludingTax of type Decimal _TotalValue_IncludingTax = reader.GetDecimal(6); //7:Parameter BillComment of type String _BillComment = reader.GetString(7); //8:Parameter PaymentTargetDate of type DateTime _PaymentTargetDate = reader.GetDate(8); //9:Parameter CashDiscountInPercent of type Double _CashDiscountInPercent = reader.GetDouble(9); //10:Parameter Creation_Timestamp of type DateTime _Creation_Timestamp = reader.GetDate(10); //11:Parameter Tenant_RefID of type Guid _Tenant_RefID = reader.GetGuid(11); //12:Parameter IsDeleted of type Boolean _IsDeleted = reader.GetBoolean(12); } //Close the reader so other connections can use it reader.Close(); loader.Load(); if (_ORD_PRC_SPB_SupplierBill_HeaderID != 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_CMN_CTR_Contract_Parameter> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction) { CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection(); List <ORM_CMN_CTR_Contract_Parameter> 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_CMN_CTR_Contract_Parameter>(); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "CMN_CTR_Contract_ParameterID", "Contract_DefaultParameter_RefID", "Contract_RefID", "ParameterName", "IsStringValue", "IfStringValue_Value", "IsNumericValue", "IfNumericValue_Value", "IsBooleanValue", "IfBooleanValue_Value", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" }); while (reader.Read()) { ORM_CMN_CTR_Contract_Parameter item = new ORM_CMN_CTR_Contract_Parameter(); //0:Parameter CMN_CTR_Contract_ParameterID of type Guid item.CMN_CTR_Contract_ParameterID = reader.GetGuid(0); //1:Parameter Contract_DefaultParameter_RefID of type Guid item.Contract_DefaultParameter_RefID = reader.GetGuid(1); //2:Parameter Contract_RefID of type Guid item.Contract_RefID = reader.GetGuid(2); //3:Parameter ParameterName of type String item.ParameterName = reader.GetString(3); //4:Parameter IsStringValue of type Boolean item.IsStringValue = reader.GetBoolean(4); //5:Parameter IfStringValue_Value of type String item.IfStringValue_Value = reader.GetString(5); //6:Parameter IsNumericValue of type Boolean item.IsNumericValue = reader.GetBoolean(6); //7:Parameter IfNumericValue_Value of type double item.IfNumericValue_Value = reader.GetDouble(7); //8:Parameter IsBooleanValue of type Boolean item.IsBooleanValue = reader.GetBoolean(8); //9:Parameter IfBooleanValue_Value of type Boolean item.IfBooleanValue_Value = reader.GetBoolean(9); //10:Parameter Creation_Timestamp of type DateTime item.Creation_Timestamp = reader.GetDate(10); //11:Parameter Tenant_RefID of type Guid item.Tenant_RefID = reader.GetGuid(11); //12:Parameter IsDeleted of type Boolean item.IsDeleted = reader.GetBoolean(12); //13:Parameter Modification_Timestamp of type DateTime item.Modification_Timestamp = reader.GetDate(13); 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); }
protected static FR_L5AR_GART_1118_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5AR_GART_1118_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_VacationPlanner_Absence.Atomic.Retrieval.SQL.cls_Get_AbsenceReasons_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; List <L5AR_GART_1118> results = new List <L5AR_GART_1118>(); 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_STA_AbsenceReasonID", "Parent_RefID", "ShortName", "ColorCode", "IsIncludedInCapacityCalculation", "IsAuthorizationRequired", "IsAllowedAbsence", "IsCarryOverEnabled", "IsDeactivated", "Creation_Timestamp", "Name_DictID", "Description_DictID", "IsLeaveTimeReducing_WorkingHours", "IsLeaveTimeReducingOverTime" }); while (reader.Read()) { L5AR_GART_1118 resultItem = new L5AR_GART_1118(); //0:Parameter CMN_BPT_STA_AbsenceReasonID of type Guid resultItem.CMN_BPT_STA_AbsenceReasonID = reader.GetGuid(0); //1:Parameter Parent_RefID of type Guid resultItem.Parent_RefID = reader.GetGuid(1); //2:Parameter ShortName of type String resultItem.ShortName = reader.GetString(2); //3:Parameter ColorCode of type String resultItem.ColorCode = reader.GetString(3); //4:Parameter IsIncludedInCapacityCalculation of type bool resultItem.IsIncludedInCapacityCalculation = reader.GetBoolean(4); //5:Parameter IsAuthorizationRequired of type bool resultItem.IsAuthorizationRequired = reader.GetBoolean(5); //6:Parameter IsAllowedAbsence of type bool resultItem.IsAllowedAbsence = reader.GetBoolean(6); //7:Parameter IsCarryOverEnabled of type Boolean resultItem.IsCarryOverEnabled = reader.GetBoolean(7); //8:Parameter IsDeactivated of type Boolean resultItem.IsDeactivated = reader.GetBoolean(8); //9:Parameter Creation_Timestamp of type DateTime resultItem.Creation_Timestamp = reader.GetDate(9); //10:Parameter ReasonName of type Dict resultItem.ReasonName = reader.GetDictionary(10); resultItem.ReasonName.SourceTable = "cmn_bpt_sta_absencereasons"; loader.Append(resultItem.ReasonName); //11:Parameter ReasonDescription of type Dict resultItem.ReasonDescription = reader.GetDictionary(11); resultItem.ReasonDescription.SourceTable = "cmn_bpt_sta_absencereasons"; loader.Append(resultItem.ReasonDescription); //12:Parameter IsLeaveTimeReducing_WorkingHours of type bool resultItem.IsLeaveTimeReducing_WorkingHours = reader.GetBoolean(12); //13:Parameter IsLeaveTimeReducingOverTime of type bool resultItem.IsLeaveTimeReducingOverTime = reader.GetBoolean(13); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw ex; } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.ToArray(); return(returnStatus); }
protected static FR_L5BH_GBFDfR_1443_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5BH_GBFDfR_1443 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5BH_GBFDfR_1443_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_Lucentis_BillingHistory.Atomic.Retrieval.SQL.cls_Get_BilledFollowupData_for_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; command.CommandText = System.Text.RegularExpressions.Regex.Replace(command.CommandText, "=[ \t]*@FollowUpID", " IN $$FollowUpID$$"); CSV2Core_MySQL.Support.DBSQLSupport.AppendINStatement(command, "$FollowUpID$", Parameter.FollowUpID); List <L5BH_GBFDfR_1443_raw> results = new List <L5BH_GBFDfR_1443_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[] { "VorgangsNumber", "FollowupDate", "GPOS", "FirstName", "LastName", "PositionValue_IncludingTax", "BIL_BillPositionID", "BirthDate", "FollowupPracticeID", "External_PositionType", "TCode", "CMN_PRO_ProductID", "Product_Name_DictID" }); while (reader.Read()) { L5BH_GBFDfR_1443_raw resultItem = new L5BH_GBFDfR_1443_raw(); //0:Parameter VorgangsNumber of type String resultItem.VorgangsNumber = reader.GetString(0); //1:Parameter FollowupDate of type DateTime resultItem.FollowupDate = reader.GetDate(1); //2:Parameter GPOS of type String resultItem.GPOS = reader.GetString(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 PositionValue_IncludingTax of type String resultItem.PositionValue_IncludingTax = reader.GetString(5); //6:Parameter BIL_BillPositionID of type Guid resultItem.BIL_BillPositionID = reader.GetGuid(6); //7:Parameter BirthDate of type DateTime resultItem.BirthDate = reader.GetDate(7); //8:Parameter FollowupPracticeID of type Guid resultItem.FollowupPracticeID = reader.GetGuid(8); //9:Parameter External_PositionType of type String resultItem.External_PositionType = reader.GetString(9); //10:Parameter TCode of type String resultItem.TCode = reader.GetString(10); //11:Parameter CMN_PRO_ProductID of type Guid resultItem.CMN_PRO_ProductID = reader.GetGuid(11); //12:Parameter Product_Name of type Dict resultItem.Product_Name = reader.GetDictionary(12); 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_BilledFollowupData_for_Report", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = L5BH_GBFDfR_1443_raw.Convert(results).ToArray(); return(returnStatus); }
protected static FR_L3AR_GAfT_0942_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L3AR_GAfT_0942 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L3AR_GAfT_0942_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL3_Articles.Atomic.Retrieval.SQL.cls_Get_Articles_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, "LanguageID", Parameter.LanguageID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ProductNameStartWith", Parameter.ProductNameStartWith); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ProducerName", Parameter.ProducerName); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "GeneralQuery", Parameter.GeneralQuery); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "DosageFormQuery", Parameter.DosageFormQuery); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "UnitQuery", Parameter.UnitQuery); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "PZNQuery", Parameter.PZNQuery); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CustomArticlesGroupGlobalPropertyID", Parameter.CustomArticlesGroupGlobalPropertyID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ActiveComponent", Parameter.ActiveComponent); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ActiveComponentStartWith", Parameter.ActiveComponentStartWith); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsAvailableForOrdering", Parameter.IsAvailableForOrdering); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ProductID", Parameter.ProductID); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsDefaultStock", Parameter.IsDefaultStock); List <L3AR_GAfT_0942_raw> results = new List <L3AR_GAfT_0942_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[] { "ProductName", "Product_Number", "ProductGroup", "CMN_PRO_ProductID", "PackageInfo_RefID", "ProductDistributionStatus", "ProductType_Name_DictID", "Product_Description_DictID", "Abbreviation_DictID", "Label_DictID", "IsPlaceholderArticle", "ProductITL", "UnitAmount", "UnitAmount_DisplayLabel", "UnitIsoCode", "DossageFormName", "ProducerName", "IfImportedFromExternalCatalog_CatalogSubscription_RefID", "IsProductPartOfDefaultStock", "HEC_PRO_ComponentID", "Component_Name_DictID", "Component_SimpleName", "IsActiveComponent", "HEC_SUB_SubstanceID", "SubstanceName", "ACC_TAX_TaxeID", "EconomicRegion_RefID", "TaxRate", "TaxName_DictID" }); while (reader.Read()) { L3AR_GAfT_0942_raw resultItem = new L3AR_GAfT_0942_raw(); //0:Parameter ProductName of type String resultItem.ProductName = reader.GetString(0); //1:Parameter Product_Number of type String resultItem.Product_Number = reader.GetString(1); //2:Parameter ProductGroup of type String resultItem.ProductGroup = reader.GetString(2); //3:Parameter CMN_PRO_ProductID of type Guid resultItem.CMN_PRO_ProductID = reader.GetGuid(3); //4:Parameter PackageInfo_RefID of type Guid resultItem.PackageInfo_RefID = reader.GetGuid(4); //5:Parameter ProductDistributionStatus of type int resultItem.ProductDistributionStatus = reader.GetInteger(5); //6:Parameter ProductType_Name of type Dict resultItem.ProductType_Name = reader.GetDictionary(6); resultItem.ProductType_Name.SourceTable = "cmn_pro_product_types"; loader.Append(resultItem.ProductType_Name); //7:Parameter Product_Description of type Dict resultItem.Product_Description = reader.GetDictionary(7); resultItem.Product_Description.SourceTable = "cmn_pro_products"; loader.Append(resultItem.Product_Description); //8:Parameter Abbreviation of type Dict resultItem.Abbreviation = reader.GetDictionary(8); resultItem.Abbreviation.SourceTable = "cmn_units"; loader.Append(resultItem.Abbreviation); //9:Parameter Label of type Dict resultItem.Label = reader.GetDictionary(9); resultItem.Label.SourceTable = "cmn_units"; loader.Append(resultItem.Label); //10:Parameter IsPlaceholderArticle of type bool resultItem.IsPlaceholderArticle = reader.GetBoolean(10); //11:Parameter ProductITL of type String resultItem.ProductITL = reader.GetString(11); //12:Parameter UnitAmount of type double resultItem.UnitAmount = reader.GetDouble(12); //13:Parameter UnitAmount_DisplayLabel of type String resultItem.UnitAmount_DisplayLabel = reader.GetString(13); //14:Parameter UnitIsoCode of type String resultItem.UnitIsoCode = reader.GetString(14); //15:Parameter DossageFormName of type string resultItem.DossageFormName = reader.GetString(15); //16:Parameter ProducerName of type string resultItem.ProducerName = reader.GetString(16); //17:Parameter IfImportedFromExternalCatalog_CatalogSubscription_RefID of type Guid resultItem.IfImportedFromExternalCatalog_CatalogSubscription_RefID = reader.GetGuid(17); //18:Parameter IsProductPartOfDefaultStock of type bool resultItem.IsProductPartOfDefaultStock = reader.GetBoolean(18); //19:Parameter HEC_PRO_ComponentID of type Guid resultItem.HEC_PRO_ComponentID = reader.GetGuid(19); //20:Parameter Component_Name of type Dict resultItem.Component_Name = reader.GetDictionary(20); resultItem.Component_Name.SourceTable = "hec_pro_components"; loader.Append(resultItem.Component_Name); //21:Parameter Component_SimpleName of type String resultItem.Component_SimpleName = reader.GetString(21); //22:Parameter IsActiveComponent of type bool resultItem.IsActiveComponent = reader.GetBoolean(22); //23:Parameter HEC_SUB_SubstanceID of type Guid resultItem.HEC_SUB_SubstanceID = reader.GetGuid(23); //24:Parameter SubstanceName of type String resultItem.SubstanceName = reader.GetString(24); //25:Parameter ACC_TAX_TaxeID of type Guid resultItem.ACC_TAX_TaxeID = reader.GetGuid(25); //26:Parameter EconomicRegion_RefID of type Guid resultItem.EconomicRegion_RefID = reader.GetGuid(26); //27:Parameter TaxRate of type double resultItem.TaxRate = reader.GetDouble(27); //28:Parameter TaxName_DictID of type Dict resultItem.TaxName_DictID = reader.GetDictionary(28); resultItem.TaxName_DictID.SourceTable = "acc_tax_taxes"; loader.Append(resultItem.TaxName_DictID); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_Articles_for_Tenant", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = L3AR_GAfT_0942_raw.Convert(results).ToArray(); return(returnStatus); }
private static List <ORM_USR_Device_AccountCode_StatusHistory> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction) { CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection(); List <ORM_USR_Device_AccountCode_StatusHistory> 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_USR_Device_AccountCode_StatusHistory>(); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "USR_Device_AccountCode_StatusHistoryID", "Device_AccountCode_RefID", "IsAccountCode_Active", "IsAccountCode_Revoked", "IsAccountCode_Banned", "IsAccountCode_Disabled", "IsAccountCode_Expired", "IsAccountCode_UsageLimitReached", "AccountCode_StatusComment", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" }); while (reader.Read()) { ORM_USR_Device_AccountCode_StatusHistory item = new ORM_USR_Device_AccountCode_StatusHistory(); //0:Parameter USR_Device_AccountCode_StatusHistoryID of type Guid item.USR_Device_AccountCode_StatusHistoryID = reader.GetGuid(0); //1:Parameter Device_AccountCode_RefID of type Guid item.Device_AccountCode_RefID = reader.GetGuid(1); //2:Parameter IsAccountCode_Active of type Boolean item.IsAccountCode_Active = reader.GetBoolean(2); //3:Parameter IsAccountCode_Revoked of type Boolean item.IsAccountCode_Revoked = reader.GetBoolean(3); //4:Parameter IsAccountCode_Banned of type Boolean item.IsAccountCode_Banned = reader.GetBoolean(4); //5:Parameter IsAccountCode_Disabled of type Boolean item.IsAccountCode_Disabled = reader.GetBoolean(5); //6:Parameter IsAccountCode_Expired of type Boolean item.IsAccountCode_Expired = reader.GetBoolean(6); //7:Parameter IsAccountCode_UsageLimitReached of type Boolean item.IsAccountCode_UsageLimitReached = reader.GetBoolean(7); //8:Parameter AccountCode_StatusComment of type String item.AccountCode_StatusComment = reader.GetString(8); //9:Parameter Creation_Timestamp of type DateTime item.Creation_Timestamp = reader.GetDate(9); //10:Parameter IsDeleted of type Boolean item.IsDeleted = reader.GetBoolean(10); //11:Parameter Tenant_RefID of type Guid item.Tenant_RefID = reader.GetGuid(11); 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); }
private static List <ORM_ORD_CUO_CustomerOrder_Position> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction) { CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection(); List <ORM_ORD_CUO_CustomerOrder_Position> 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_ORD_CUO_CustomerOrder_Position>(); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "ORD_CUO_CustomerOrder_PositionID", "CustomerProcurementOrderPositionITL", "CustomerOrder_Header_RefID", "Position_OrdinalNumber", "Position_Quantity", "Position_ValuePerUnit", "Position_ValueTotal", "Position_Comment", "Position_Description", "Position_Unit_RefID", "Position_RequestedDateOfDelivery", "CMN_PRO_Product_Variant_RefID", "CMN_PRO_Product_RefID", "CMN_PRO_Product_Release_RefID", "IsProductReplacementAllowed", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" }); while (reader.Read()) { ORM_ORD_CUO_CustomerOrder_Position item = new ORM_ORD_CUO_CustomerOrder_Position(); //0:Parameter ORD_CUO_CustomerOrder_PositionID of type Guid item.ORD_CUO_CustomerOrder_PositionID = reader.GetGuid(0); //1:Parameter CustomerProcurementOrderPositionITL of type String item.CustomerProcurementOrderPositionITL = reader.GetString(1); //2:Parameter CustomerOrder_Header_RefID of type Guid item.CustomerOrder_Header_RefID = reader.GetGuid(2); //3:Parameter Position_OrdinalNumber of type int item.Position_OrdinalNumber = reader.GetInteger(3); //4:Parameter Position_Quantity of type Double item.Position_Quantity = reader.GetDouble(4); //5:Parameter Position_ValuePerUnit of type Decimal item.Position_ValuePerUnit = reader.GetDecimal(5); //6:Parameter Position_ValueTotal of type Decimal item.Position_ValueTotal = reader.GetDecimal(6); //7:Parameter Position_Comment of type String item.Position_Comment = reader.GetString(7); //8:Parameter Position_Description of type String item.Position_Description = reader.GetString(8); //9:Parameter Position_Unit_RefID of type Guid item.Position_Unit_RefID = reader.GetGuid(9); //10:Parameter Position_RequestedDateOfDelivery of type DateTime item.Position_RequestedDateOfDelivery = reader.GetDate(10); //11:Parameter CMN_PRO_Product_Variant_RefID of type Guid item.CMN_PRO_Product_Variant_RefID = reader.GetGuid(11); //12:Parameter CMN_PRO_Product_RefID of type Guid item.CMN_PRO_Product_RefID = reader.GetGuid(12); //13:Parameter CMN_PRO_Product_Release_RefID of type Guid item.CMN_PRO_Product_Release_RefID = reader.GetGuid(13); //14:Parameter IsProductReplacementAllowed of type Boolean item.IsProductReplacementAllowed = reader.GetBoolean(14); //15:Parameter Creation_Timestamp of type DateTime item.Creation_Timestamp = reader.GetDate(15); //16:Parameter Tenant_RefID of type Guid item.Tenant_RefID = reader.GetGuid(16); //17:Parameter IsDeleted of type Boolean item.IsDeleted = reader.GetBoolean(17); 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); }
protected static FR_L5AC_GDSfDID_1214_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5AC_GDSfDID_1214 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5AC_GDSfDID_1214_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_MyHealthClub_Actions.Atomic.Retrieval.SQL.cls_Get_DiagnosesStatistics_for_DoctorID.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]*@ListDoctorID", " IN $$ListDoctorID$$"); CSV2Core_MySQL.Support.DBSQLSupport.AppendINStatement(command, "$ListDoctorID$", Parameter.ListDoctorID); List <L5AC_GDSfDID_1214> results = new List <L5AC_GDSfDID_1214>(); 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[] { "PotentialDiagnosis_Name_DictID", "IfPerfomed_DateOfAction", "Office_Name_DictID", "HEC_DIA_PotentialDiagnosisID", "CMN_STR_OfficeID", "HEC_Doctor_RefID", "HEC_ACT_PerformedActionID", "IsDiagnosisNegated", "DoctorTitle", "DoctorFirstName", "DoctorLastName", "ICD10_Code" }); while (reader.Read()) { L5AC_GDSfDID_1214 resultItem = new L5AC_GDSfDID_1214(); //0:Parameter PotentialDiagnosis_Name of type Dict resultItem.PotentialDiagnosis_Name = reader.GetDictionary(0); resultItem.PotentialDiagnosis_Name.SourceTable = "hec_dia_potentialdiagnoses"; loader.Append(resultItem.PotentialDiagnosis_Name); //1:Parameter IfPerfomed_DateOfAction of type DateTime resultItem.IfPerfomed_DateOfAction = reader.GetDate(1); //2:Parameter Office_Name of type Dict resultItem.Office_Name = reader.GetDictionary(2); resultItem.Office_Name.SourceTable = "cmn_str_offices"; loader.Append(resultItem.Office_Name); //3:Parameter HEC_DIA_PotentialDiagnosisID of type Guid resultItem.HEC_DIA_PotentialDiagnosisID = reader.GetGuid(3); //4:Parameter CMN_STR_OfficeID of type Guid resultItem.CMN_STR_OfficeID = reader.GetGuid(4); //5:Parameter HEC_Doctor_RefID of type Guid resultItem.HEC_Doctor_RefID = reader.GetGuid(5); //6:Parameter HEC_ACT_PerformedActionID of type Guid resultItem.HEC_ACT_PerformedActionID = reader.GetGuid(6); //7:Parameter IsDiagnosisNegated of type bool resultItem.IsDiagnosisNegated = reader.GetBoolean(7); //8:Parameter DoctorTitle of type String resultItem.DoctorTitle = reader.GetString(8); //9:Parameter DoctorFirstName of type String resultItem.DoctorFirstName = reader.GetString(9); //10:Parameter DoctorLastName of type String resultItem.DoctorLastName = reader.GetString(10); //11:Parameter ICD10_Code of type String resultItem.ICD10_Code = reader.GetString(11); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_DiagnosesStatistics_for_DoctorID", 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 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_CMN_BPT_EMP.CMN_BPT_EMP_SalaryType.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 _CMN_BPT_EMP_SalaryTypeID = Guid.Empty; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CMN_BPT_EMP_SalaryTypeID", 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[] { "CMN_BPT_EMP_SalaryTypeID", "GlobalPropertyMatchingID", "SalaryType_Code", "SalaryType_Name_DictID", "SalaryTypeStatus", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" }); if (reader.HasRows == true) { reader.Read(); //Single result only //0:Parameter CMN_BPT_EMP_SalaryTypeID of type Guid _CMN_BPT_EMP_SalaryTypeID = reader.GetGuid(0); //1:Parameter GlobalPropertyMatchingID of type String _GlobalPropertyMatchingID = reader.GetString(1); //2:Parameter SalaryType_Code of type String _SalaryType_Code = reader.GetString(2); //3:Parameter SalaryType_Name of type Dict _SalaryType_Name = reader.GetDictionary(3); loader.Append(_SalaryType_Name, TableName); //4:Parameter SalaryTypeStatus of type int _SalaryTypeStatus = reader.GetInteger(4); //5:Parameter Creation_Timestamp of type DateTime _Creation_Timestamp = reader.GetDate(5); //6:Parameter Tenant_RefID of type Guid _Tenant_RefID = reader.GetGuid(6); //7:Parameter IsDeleted of type Boolean _IsDeleted = reader.GetBoolean(7); } //Close the reader so other connections can use it reader.Close(); loader.Load(); if (_CMN_BPT_EMP_SalaryTypeID != 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 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.HEC_PotentialMedication.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_PotentialMedicationID = Guid.Empty; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "HEC_PotentialMedicationID", 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_PotentialMedicationID", "IsHealthcareProduct", "HEC_Product_RefID", "IsSubstance", "IfSubstance_Strength", "IfSubstance_Unit_RefID", "HEC_SUB_Substance_RefiD", "RecommendedDosage", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" }); if (reader.HasRows == true) { reader.Read(); //Single result only //0:Parameter HEC_PotentialMedicationID of type Guid _HEC_PotentialMedicationID = reader.GetGuid(0); //1:Parameter IsHealthcareProduct of type Boolean _IsHealthcareProduct = reader.GetBoolean(1); //2:Parameter HEC_Product_RefID of type Guid _HEC_Product_RefID = reader.GetGuid(2); //3:Parameter IsSubstance of type Boolean _IsSubstance = reader.GetBoolean(3); //4:Parameter IfSubstance_Strength of type double _IfSubstance_Strength = reader.GetDouble(4); //5:Parameter IfSubstance_Unit_RefID of type Guid _IfSubstance_Unit_RefID = reader.GetGuid(5); //6:Parameter HEC_SUB_Substance_RefiD of type Guid _HEC_SUB_Substance_RefiD = reader.GetGuid(6); //7:Parameter RecommendedDosage of type String _RecommendedDosage = reader.GetString(7); //8:Parameter Creation_Timestamp of type DateTime _Creation_Timestamp = reader.GetDate(8); //9:Parameter Tenant_RefID of type Guid _Tenant_RefID = reader.GetGuid(9); //10:Parameter IsDeleted of type Boolean _IsDeleted = reader.GetBoolean(10); } //Close the reader so other connections can use it reader.Close(); loader.Load(); if (_HEC_PotentialMedicationID != 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 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_ACC_DUN.ACC_DUN_DunningProcess.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 _ACC_DUN_DunningProcessID = Guid.Empty; CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ACC_DUN_DunningProcessID", 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[] { "ACC_DUN_DunningProcessID", "DunnedCustomer_RefID", "DunningModel_RefID", "Currency_RefID", "Current_DunningLevel_RefID", "DunnedAmount_Total", "ReachesNextDunningLevelAtDate", "IsDunningProcessClosed", "DunningProcessClosedAt_Date", "DunningProcessClosedBy_BusinessParticipnant_RefID", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" }); if (reader.HasRows == true) { reader.Read(); //Single result only //0:Parameter ACC_DUN_DunningProcessID of type Guid _ACC_DUN_DunningProcessID = reader.GetGuid(0); //1:Parameter DunnedCustomer_RefID of type Guid _DunnedCustomer_RefID = reader.GetGuid(1); //2:Parameter DunningModel_RefID of type Guid _DunningModel_RefID = reader.GetGuid(2); //3:Parameter Currency_RefID of type Guid _Currency_RefID = reader.GetGuid(3); //4:Parameter Current_DunningLevel_RefID of type Guid _Current_DunningLevel_RefID = reader.GetGuid(4); //5:Parameter DunnedAmount_Total of type Decimal _DunnedAmount_Total = reader.GetDecimal(5); //6:Parameter ReachesNextDunningLevelAtDate of type DateTime _ReachesNextDunningLevelAtDate = reader.GetDate(6); //7:Parameter IsDunningProcessClosed of type Boolean _IsDunningProcessClosed = reader.GetBoolean(7); //8:Parameter DunningProcessClosedAt_Date of type DateTime _DunningProcessClosedAt_Date = reader.GetDate(8); //9:Parameter DunningProcessClosedBy_BusinessParticipnant_RefID of type Guid _DunningProcessClosedBy_BusinessParticipnant_RefID = reader.GetGuid(9); //10:Parameter Creation_Timestamp of type DateTime _Creation_Timestamp = reader.GetDate(10); //11:Parameter Tenant_RefID of type Guid _Tenant_RefID = reader.GetGuid(11); //12:Parameter IsDeleted of type Boolean _IsDeleted = reader.GetBoolean(12); } //Close the reader so other connections can use it reader.Close(); loader.Load(); if (_ACC_DUN_DunningProcessID != 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); }
protected static FR_L5AR_GPaPfAaCID_1020_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5AR_GPaPfAaCID_1020 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnStatus = new FR_L5AR_GPaPfAaCID_1020_Array(); DbCommand command = Connection.CreateCommand(); command.Connection = Connection; command.Transaction = Transaction; var commandLocation = "CL5_APOAdmin_Articles.Atomic.Retrieval.SQL.cls_Get_Pricelists_and_Prices_for_Article_and_Currency_ID.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); CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CurrencyID", Parameter.CurrencyID); List <L5AR_GPaPfAaCID_1020> results = new List <L5AR_GPaPfAaCID_1020>(); 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[] { "Pricelist_Name_DictID", "CMN_SLS_PricelistID", "CMN_SLS_PriceID", "GlobalPropertyMatchingID", "PriceAmount", "Release_Version", "CMN_SLS_Pricelist_ReleaseID", "CMN_PRO_Product_RefID", "CMN_Currency_RefID", "IsDynamicPricingUsed", "DynamicPricingFormula_Type_RefID", "DynamicPricingFormula" }); while (reader.Read()) { L5AR_GPaPfAaCID_1020 resultItem = new L5AR_GPaPfAaCID_1020(); //0:Parameter Pricelist_Name of type Dict resultItem.Pricelist_Name = reader.GetDictionary(0); resultItem.Pricelist_Name.SourceTable = "cmn_sls_pricelist"; loader.Append(resultItem.Pricelist_Name); //1:Parameter CMN_SLS_PricelistID of type Guid resultItem.CMN_SLS_PricelistID = reader.GetGuid(1); //2:Parameter CMN_SLS_PriceID of type Guid resultItem.CMN_SLS_PriceID = reader.GetGuid(2); //3:Parameter GlobalPropertyMatchingID of type String resultItem.GlobalPropertyMatchingID = reader.GetString(3); //4:Parameter PriceAmount of type decimal resultItem.PriceAmount = reader.GetDecimal(4); //5:Parameter Release_Version of type String resultItem.Release_Version = reader.GetString(5); //6:Parameter CMN_SLS_Pricelist_ReleaseID of type Guid resultItem.CMN_SLS_Pricelist_ReleaseID = reader.GetGuid(6); //7:Parameter CMN_PRO_Product_RefID of type Guid resultItem.CMN_PRO_Product_RefID = reader.GetGuid(7); //8:Parameter CMN_Currency_RefID of type Guid resultItem.CMN_Currency_RefID = reader.GetGuid(8); //9:Parameter IsDynamicPricingUsed of type bool resultItem.IsDynamicPricingUsed = reader.GetBoolean(9); //10:Parameter DynamicPricingFormula_Type_RefID of type Guid resultItem.DynamicPricingFormula_Type_RefID = reader.GetGuid(10); //11:Parameter DynamicPricingFormula of type String resultItem.DynamicPricingFormula = reader.GetString(11); results.Add(resultItem); } } catch (Exception ex) { reader.Close(); throw new Exception("Exception occured durng data retrieval in method cls_Get_Pricelists_and_Prices_for_Article_and_Currency_ID", ex); } reader.Close(); //Load all the dictionaries from the datatables loader.Load(); returnStatus.Result = results.ToArray(); return(returnStatus); }