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_RES_BLD_OutdoorFacility_AccessRoadType> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_RES_BLD_OutdoorFacility_AccessRoadType> items;
try
{
managedConnection.set(connectionString, connection, transaction);
var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(managedConnection.getConnection(), managedConnection.getTransaction());
DbCommand command = managedConnection.manage(query.CreateSelectQuery(TableName));
query.SetParameters(command);
items = new List <ORM_RES_BLD_OutdoorFacility_AccessRoadType>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "RES_BLD_OutdoorFacility_AccessRoadTypeID", "GlobalPropertyMatchingID", "AccessRoadType_Name_DictID", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" });
while (reader.Read())
{
ORM_RES_BLD_OutdoorFacility_AccessRoadType item = new ORM_RES_BLD_OutdoorFacility_AccessRoadType();
//0:Parameter RES_BLD_OutdoorFacility_AccessRoadTypeID of type Guid
item.RES_BLD_OutdoorFacility_AccessRoadTypeID = reader.GetGuid(0);
//1:Parameter GlobalPropertyMatchingID of type String
item.GlobalPropertyMatchingID = reader.GetString(1);
//2:Parameter AccessRoadType_Name of type Dict
item.AccessRoadType_Name = reader.GetDictionary(2);
loader.Append(item.AccessRoadType_Name, TableName);
//3:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(3);
//4:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(4);
//5:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(5);
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);
}
private static List <ORM_HEC_DIA_Diagnosis_Localization> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_HEC_DIA_Diagnosis_Localization> 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_DIA_Diagnosis_Localization>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "HEC_DIA_Diagnosis_LocalizationID", "Diagnosis_RefID", "LocalizationCode", "DiagnosisLocalization_Name_DictID", "DiagnosisLocalization_Description_DictID", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" });
while (reader.Read())
{
ORM_HEC_DIA_Diagnosis_Localization item = new ORM_HEC_DIA_Diagnosis_Localization();
//0:Parameter HEC_DIA_Diagnosis_LocalizationID of type Guid
item.HEC_DIA_Diagnosis_LocalizationID = reader.GetGuid(0);
//1:Parameter Diagnosis_RefID of type Guid
item.Diagnosis_RefID = reader.GetGuid(1);
//2:Parameter LocalizationCode of type String
item.LocalizationCode = reader.GetString(2);
//3:Parameter DiagnosisLocalization_Name of type Dict
item.DiagnosisLocalization_Name = reader.GetDictionary(3);
loader.Append(item.DiagnosisLocalization_Name, TableName);
//4:Parameter DiagnosisLocalization_Description of type Dict
item.DiagnosisLocalization_Description = reader.GetDictionary(4);
loader.Append(item.DiagnosisLocalization_Description, TableName);
//5:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(5);
//6:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(6);
//7:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(7);
//8:Parameter Modification_Timestamp of type DateTime
item.Modification_Timestamp = reader.GetDate(8);
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);
}
private static List <ORM_IMO_QuestionnaireStatus_2_QuestionnaireAction> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_IMO_QuestionnaireStatus_2_QuestionnaireAction> 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_IMO_QuestionnaireStatus_2_QuestionnaireAction>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "AssignmentID", "QuestionnaireAction_RefID", "QuestionnaireStatus_RefID", "Default_Timeframe_RefID", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" });
while (reader.Read())
{
ORM_IMO_QuestionnaireStatus_2_QuestionnaireAction item = new ORM_IMO_QuestionnaireStatus_2_QuestionnaireAction();
//0:Parameter AssignmentID of type Guid
item.AssignmentID = reader.GetGuid(0);
//1:Parameter QuestionnaireAction_RefID of type Guid
item.QuestionnaireAction_RefID = reader.GetGuid(1);
//2:Parameter QuestionnaireStatus_RefID of type Guid
item.QuestionnaireStatus_RefID = reader.GetGuid(2);
//3:Parameter Default_Timeframe_RefID of type Guid
item.Default_Timeframe_RefID = reader.GetGuid(3);
//4:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(4);
//5:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(5);
//6:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(6);
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);
}
private static List <ORM_ORD_PRC_RFP_RequestForProposal_Position> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_ORD_PRC_RFP_RequestForProposal_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_PRC_RFP_RequestForProposal_Position>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "ORD_PRC_RFP_RequestForProposal_PositionID", "RequestForProposalPositionITPL", "RequestForProposal_Header_RefID", "CMN_PRO_Product_RefID", "CMN_PRO_Product_Variant_RefID", "CMN_PRO_Product_Release_RefID", "Quantity", "IsReplacementPermitted", "OrderSequence", "DeliveryUntillDate", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" });
while (reader.Read())
{
ORM_ORD_PRC_RFP_RequestForProposal_Position item = new ORM_ORD_PRC_RFP_RequestForProposal_Position();
//0:Parameter ORD_PRC_RFP_RequestForProposal_PositionID of type Guid
item.ORD_PRC_RFP_RequestForProposal_PositionID = reader.GetGuid(0);
//1:Parameter RequestForProposalPositionITPL of type String
item.RequestForProposalPositionITPL = reader.GetString(1);
//2:Parameter RequestForProposal_Header_RefID of type Guid
item.RequestForProposal_Header_RefID = reader.GetGuid(2);
//3:Parameter CMN_PRO_Product_RefID of type Guid
item.CMN_PRO_Product_RefID = reader.GetGuid(3);
//4:Parameter CMN_PRO_Product_Variant_RefID of type Guid
item.CMN_PRO_Product_Variant_RefID = reader.GetGuid(4);
//5:Parameter CMN_PRO_Product_Release_RefID of type Guid
item.CMN_PRO_Product_Release_RefID = reader.GetGuid(5);
//6:Parameter Quantity of type double
item.Quantity = reader.GetDouble(6);
//7:Parameter IsReplacementPermitted of type Boolean
item.IsReplacementPermitted = reader.GetBoolean(7);
//8:Parameter OrderSequence of type int
item.OrderSequence = reader.GetInteger(8);
//9:Parameter DeliveryUntillDate of type DateTime
item.DeliveryUntillDate = reader.GetDate(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);
}
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);
}
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 static List <ORM_TMS_PRO_BusinessTask_Status> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_TMS_PRO_BusinessTask_Status> 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_TMS_PRO_BusinessTask_Status>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "TMS_PRO_BusinessTask_StatusID", "GlobalPropertyMatchingID", "Label_DictID", "Description_DictID", "IsPersistent", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" });
while (reader.Read())
{
ORM_TMS_PRO_BusinessTask_Status item = new ORM_TMS_PRO_BusinessTask_Status();
//0:Parameter TMS_PRO_BusinessTask_StatusID of type Guid
item.TMS_PRO_BusinessTask_StatusID = reader.GetGuid(0);
//1:Parameter GlobalPropertyMatchingID of type String
item.GlobalPropertyMatchingID = reader.GetString(1);
//2:Parameter Label of type Dict
item.Label = reader.GetDictionary(2);
loader.Append(item.Label, TableName);
//3:Parameter Description of type Dict
item.Description = reader.GetDictionary(3);
loader.Append(item.Description, TableName);
//4:Parameter IsPersistent of type Boolean
item.IsPersistent = reader.GetBoolean(4);
//5:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(5);
//6:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(6);
//7:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(7);
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);
}
private static List <ORM_LOG_SHP_Shipment_Position> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_LOG_SHP_Shipment_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_LOG_SHP_Shipment_Position>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "LOG_SHP_Shipment_PositionID", "ShipmentPositionITL", "LOG_SHP_Shipment_Header_RefID", "CMN_PRO_Product_RefID", "CMN_PRO_ProductVariant_RefID", "CMN_PRO_ProductRelease_RefID", "TrackingInstance_ToShip_RefID", "QuantityToShip", "ShipmentPosition_ValueWithoutTax", "ShipmentPosition_PricePerUnitValueWithoutTax", "IsCancelled", "CancelledBy_BusinessParticipant_RefID", "CancelledOnDate", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" });
while (reader.Read())
{
ORM_LOG_SHP_Shipment_Position item = new ORM_LOG_SHP_Shipment_Position();
//0:Parameter LOG_SHP_Shipment_PositionID of type Guid
item.LOG_SHP_Shipment_PositionID = reader.GetGuid(0);
//1:Parameter ShipmentPositionITL of type String
item.ShipmentPositionITL = reader.GetString(1);
//2:Parameter LOG_SHP_Shipment_Header_RefID of type Guid
item.LOG_SHP_Shipment_Header_RefID = reader.GetGuid(2);
//3:Parameter CMN_PRO_Product_RefID of type Guid
item.CMN_PRO_Product_RefID = reader.GetGuid(3);
//4:Parameter CMN_PRO_ProductVariant_RefID of type Guid
item.CMN_PRO_ProductVariant_RefID = reader.GetGuid(4);
//5:Parameter CMN_PRO_ProductRelease_RefID of type Guid
item.CMN_PRO_ProductRelease_RefID = reader.GetGuid(5);
//6:Parameter TrackingInstance_ToShip_RefID of type Guid
item.TrackingInstance_ToShip_RefID = reader.GetGuid(6);
//7:Parameter QuantityToShip of type double
item.QuantityToShip = reader.GetDouble(7);
//8:Parameter ShipmentPosition_ValueWithoutTax of type Decimal
item.ShipmentPosition_ValueWithoutTax = reader.GetDecimal(8);
//9:Parameter ShipmentPosition_PricePerUnitValueWithoutTax of type Decimal
item.ShipmentPosition_PricePerUnitValueWithoutTax = reader.GetDecimal(9);
//10:Parameter IsCancelled of type Boolean
item.IsCancelled = reader.GetBoolean(10);
//11:Parameter CancelledBy_BusinessParticipant_RefID of type Guid
item.CancelledBy_BusinessParticipant_RefID = reader.GetGuid(11);
//12:Parameter CancelledOnDate of type DateTime
item.CancelledOnDate = reader.GetDate(12);
//13:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(13);
//14:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(14);
//15:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(15);
//16:Parameter Modification_Timestamp of type DateTime
item.Modification_Timestamp = reader.GetDate(16);
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_Supplier_DiscountValue> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_CMN_BPT_Supplier_DiscountValue> 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_Supplier_DiscountValue>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "CMN_BPT_Supplier_DiscountValueID", "Supplier_RefID", "ORD_PRC_DiscountType_RefID", "DiscountValue_in_percent", "IsDefaultSupplierDiscountValue", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" });
while (reader.Read())
{
ORM_CMN_BPT_Supplier_DiscountValue item = new ORM_CMN_BPT_Supplier_DiscountValue();
//0:Parameter CMN_BPT_Supplier_DiscountValueID of type Guid
item.CMN_BPT_Supplier_DiscountValueID = reader.GetGuid(0);
//1:Parameter Supplier_RefID of type Guid
item.Supplier_RefID = reader.GetGuid(1);
//2:Parameter ORD_PRC_DiscountType_RefID of type Guid
item.ORD_PRC_DiscountType_RefID = reader.GetGuid(2);
//3:Parameter DiscountValue_in_percent of type Double
item.DiscountValue_in_percent = reader.GetDouble(3);
//4:Parameter IsDefaultSupplierDiscountValue of type Boolean
item.IsDefaultSupplierDiscountValue = reader.GetBoolean(4);
//5:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(5);
//6:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(6);
//7:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(7);
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_CTM_CatalogProductExtensionRequest_Product> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_CMN_BPT_CTM_CatalogProductExtensionRequest_Product> 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_CTM_CatalogProductExtensionRequest_Product>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "CMN_BPT_CTM_CatalogProductExtensionRequest_ProductID", "CMN_PRO_Product_RefID", "CMN_PRO_Product_Variant_RefID", "CMN_PRO_Product_Release_RefID", "CatalogProductExtensionRequest_RefID", "Comment", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" });
while (reader.Read())
{
ORM_CMN_BPT_CTM_CatalogProductExtensionRequest_Product item = new ORM_CMN_BPT_CTM_CatalogProductExtensionRequest_Product();
//0:Parameter CMN_BPT_CTM_CatalogProductExtensionRequest_ProductID of type Guid
item.CMN_BPT_CTM_CatalogProductExtensionRequest_ProductID = reader.GetGuid(0);
//1:Parameter CMN_PRO_Product_RefID of type Guid
item.CMN_PRO_Product_RefID = reader.GetGuid(1);
//2:Parameter CMN_PRO_Product_Variant_RefID of type Guid
item.CMN_PRO_Product_Variant_RefID = reader.GetGuid(2);
//3:Parameter CMN_PRO_Product_Release_RefID of type Guid
item.CMN_PRO_Product_Release_RefID = reader.GetGuid(3);
//4:Parameter CatalogProductExtensionRequest_RefID of type Guid
item.CatalogProductExtensionRequest_RefID = reader.GetGuid(4);
//5:Parameter Comment of type String
item.Comment = reader.GetString(5);
//6:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(6);
//7:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(7);
//8:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(8);
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_USR_NOT_Notification_Type> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_USR_NOT_Notification_Type> 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_NOT_Notification_Type>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "USR_NOT_Notification_TypeID", "NotificationType_Label", "NotificationType_Key", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" });
while (reader.Read())
{
ORM_USR_NOT_Notification_Type item = new ORM_USR_NOT_Notification_Type();
//0:Parameter USR_NOT_Notification_TypeID of type Guid
item.USR_NOT_Notification_TypeID = reader.GetGuid(0);
//1:Parameter NotificationType_Label of type String
item.NotificationType_Label = reader.GetString(1);
//2:Parameter NotificationType_Key of type String
item.NotificationType_Key = reader.GetString(2);
//3:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(3);
//4:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(4);
//5:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(5);
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_SLS_Price_RoundingLevel> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_CMN_SLS_Price_RoundingLevel> 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_Price_RoundingLevel>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "CMN_SLS_Price_RoundingLevelID", "Rounding_RefID", "RoundingAmount", "SequenceNumber", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" });
while (reader.Read())
{
ORM_CMN_SLS_Price_RoundingLevel item = new ORM_CMN_SLS_Price_RoundingLevel();
//0:Parameter CMN_SLS_Price_RoundingLevelID of type Guid
item.CMN_SLS_Price_RoundingLevelID = reader.GetGuid(0);
//1:Parameter Rounding_RefID of type Guid
item.Rounding_RefID = reader.GetGuid(1);
//2:Parameter RoundingAmount of type double
item.RoundingAmount = reader.GetDouble(2);
//3:Parameter SequenceNumber of type int
item.SequenceNumber = reader.GetInteger(3);
//4:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(4);
//5:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(5);
//6:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(6);
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_AvailableShipmentType> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_CMN_BPT_AvailableShipmentType> 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_AvailableShipmentType>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "CMN_BPT_AvailableShipmentTypeID", "CMN_BPT_BusinessParticipant_RefID", "LOG_SHP_Shipment_Type_RefID", "IsPrimaryShipmentType", "SequenceNumber", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" });
while (reader.Read())
{
ORM_CMN_BPT_AvailableShipmentType item = new ORM_CMN_BPT_AvailableShipmentType();
//0:Parameter CMN_BPT_AvailableShipmentTypeID of type Guid
item.CMN_BPT_AvailableShipmentTypeID = reader.GetGuid(0);
//1:Parameter CMN_BPT_BusinessParticipant_RefID of type Guid
item.CMN_BPT_BusinessParticipant_RefID = reader.GetGuid(1);
//2:Parameter LOG_SHP_Shipment_Type_RefID of type Guid
item.LOG_SHP_Shipment_Type_RefID = reader.GetGuid(2);
//3:Parameter IsPrimaryShipmentType of type Boolean
item.IsPrimaryShipmentType = reader.GetBoolean(3);
//4:Parameter SequenceNumber of type int
item.SequenceNumber = reader.GetInteger(4);
//5:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(5);
//6:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(6);
//7:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(7);
//8:Parameter Modification_Timestamp of type DateTime
item.Modification_Timestamp = reader.GetDate(8);
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_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);
}
private static List <ORM_HEC_CMT_Membership_PotentialProcedureCatalogSubscription> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_HEC_CMT_Membership_PotentialProcedureCatalogSubscription> items;
try
{
managedConnection.set(connectionString, connection, transaction);
var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(managedConnection.getConnection(), managedConnection.getTransaction());
DbCommand command = managedConnection.manage(query.CreateSelectQuery(TableName));
query.SetParameters(command);
items = new List <ORM_HEC_CMT_Membership_PotentialProcedureCatalogSubscription>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "HEC_CMT_Membership_PotentialProcedureCatalogSubscriptionID", "Membership_RefID", "PotentialProcedureCatalogITL", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" });
while (reader.Read())
{
ORM_HEC_CMT_Membership_PotentialProcedureCatalogSubscription item = new ORM_HEC_CMT_Membership_PotentialProcedureCatalogSubscription();
//0:Parameter HEC_CMT_Membership_PotentialProcedureCatalogSubscriptionID of type Guid
item.HEC_CMT_Membership_PotentialProcedureCatalogSubscriptionID = reader.GetGuid(0);
//1:Parameter Membership_RefID of type Guid
item.Membership_RefID = reader.GetGuid(1);
//2:Parameter PotentialProcedureCatalogITL of type String
item.PotentialProcedureCatalogITL = reader.GetString(2);
//3:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(3);
//4:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(4);
//5:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(5);
//6:Parameter Modification_Timestamp of type DateTime
item.Modification_Timestamp = reader.GetDate(6);
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_LOG_WRH_INJ_InventoryJob_Series> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_LOG_WRH_INJ_InventoryJob_Series> 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_LOG_WRH_INJ_InventoryJob_Series>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "LOG_WRH_INJ_InventoryJob_SeriesID", "InventoryJobSeries_DisplayName", "IsUsingNumberOfProductsSeriesType", "NumberOfProductsToSelect", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" });
while (reader.Read())
{
ORM_LOG_WRH_INJ_InventoryJob_Series item = new ORM_LOG_WRH_INJ_InventoryJob_Series();
//0:Parameter LOG_WRH_INJ_InventoryJob_SeriesID of type Guid
item.LOG_WRH_INJ_InventoryJob_SeriesID = reader.GetGuid(0);
//1:Parameter InventoryJobSeries_DisplayName of type String
item.InventoryJobSeries_DisplayName = reader.GetString(1);
//2:Parameter IsUsingNumberOfProductsSeriesType of type Boolean
item.IsUsingNumberOfProductsSeriesType = reader.GetBoolean(2);
//3:Parameter NumberOfProductsToSelect of type int
item.NumberOfProductsToSelect = reader.GetInteger(3);
//4:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(4);
//5:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(5);
//6:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(6);
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_TMS_PRO_BusinessTaskPackage> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_TMS_PRO_BusinessTaskPackage> 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_TMS_PRO_BusinessTaskPackage>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "TMS_PRO_BusinessTaskPackageID", "Parent_RefID", "Project_RefID", "OrderSequence", "Label", "CreatedByAccount_RefID", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" });
while (reader.Read())
{
ORM_TMS_PRO_BusinessTaskPackage item = new ORM_TMS_PRO_BusinessTaskPackage();
//0:Parameter TMS_PRO_BusinessTaskPackageID of type Guid
item.TMS_PRO_BusinessTaskPackageID = reader.GetGuid(0);
//1:Parameter Parent_RefID of type Guid
item.Parent_RefID = reader.GetGuid(1);
//2:Parameter Project_RefID of type Guid
item.Project_RefID = reader.GetGuid(2);
//3:Parameter OrderSequence of type int
item.OrderSequence = reader.GetInteger(3);
//4:Parameter Label of type String
item.Label = reader.GetString(4);
//5:Parameter CreatedByAccount_RefID of type Guid
item.CreatedByAccount_RefID = reader.GetGuid(5);
//6:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(6);
//7:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(7);
//8:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(8);
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);
}
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);
}
private static List <ORM_ACC_CRN_GrantedCreditNote> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_ACC_CRN_GrantedCreditNote> 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_ACC_CRN_GrantedCreditNote>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "ACC_CRN_GrantedCreditNoteID", "CreditNoteITPL", "CreditNote_Currency_RefID", "CreditNote_Value", "CreditNote_Number", "DateOnCreditNote", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" });
while (reader.Read())
{
ORM_ACC_CRN_GrantedCreditNote item = new ORM_ACC_CRN_GrantedCreditNote();
//0:Parameter ACC_CRN_GrantedCreditNoteID of type Guid
item.ACC_CRN_GrantedCreditNoteID = reader.GetGuid(0);
//1:Parameter CreditNoteITPL of type String
item.CreditNoteITPL = reader.GetString(1);
//2:Parameter CreditNote_Currency_RefID of type Guid
item.CreditNote_Currency_RefID = reader.GetGuid(2);
//3:Parameter CreditNote_Value of type Decimal
item.CreditNote_Value = reader.GetDecimal(3);
//4:Parameter CreditNote_Number of type String
item.CreditNote_Number = reader.GetString(4);
//5:Parameter DateOnCreditNote of type DateTime
item.DateOnCreditNote = reader.GetDate(5);
//6:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(6);
//7:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(7);
//8:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(8);
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);
}