private static List <ORM_HEC_ACT_PerformedAction> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_HEC_ACT_PerformedAction> 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_ACT_PerformedAction>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "HEC_ACT_PerformedActionID", "HealthcarePerformedActionITL", "Patient_RefID", "IsPerformed_Internally", "IfPerformedInternaly_ResponsibleBusinessParticipant_RefID", "IsPerformed_Externally", "IsPerformed_MedicalPractice_RefID", "IfPerformed_MedicalPracticeType_RefID", "IfPerformed_DateOfAction_Year", "IfPerformed_DateOfAction_Month", "IfPerformed_DateOfAction_Day", "IfPerfomed_DateOfAction", "IsFollowupPerformedAction", "IsFollowupPerformed_PreviousPerformedAction_RefID", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" });
while (reader.Read())
{
ORM_HEC_ACT_PerformedAction item = new ORM_HEC_ACT_PerformedAction();
//0:Parameter HEC_ACT_PerformedActionID of type Guid
item.HEC_ACT_PerformedActionID = reader.GetGuid(0);
//1:Parameter HealthcarePerformedActionITL of type String
item.HealthcarePerformedActionITL = reader.GetString(1);
//2:Parameter Patient_RefID of type Guid
item.Patient_RefID = reader.GetGuid(2);
//3:Parameter IsPerformed_Internally of type Boolean
item.IsPerformed_Internally = reader.GetBoolean(3);
//4:Parameter IfPerformedInternaly_ResponsibleBusinessParticipant_RefID of type Guid
item.IfPerformedInternaly_ResponsibleBusinessParticipant_RefID = reader.GetGuid(4);
//5:Parameter IsPerformed_Externally of type Boolean
item.IsPerformed_Externally = reader.GetBoolean(5);
//6:Parameter IsPerformed_MedicalPractice_RefID of type Guid
item.IsPerformed_MedicalPractice_RefID = reader.GetGuid(6);
//7:Parameter IfPerformed_MedicalPracticeType_RefID of type Guid
item.IfPerformed_MedicalPracticeType_RefID = reader.GetGuid(7);
//8:Parameter IfPerformed_DateOfAction_Year of type int
item.IfPerformed_DateOfAction_Year = reader.GetInteger(8);
//9:Parameter IfPerformed_DateOfAction_Month of type int
item.IfPerformed_DateOfAction_Month = reader.GetInteger(9);
//10:Parameter IfPerformed_DateOfAction_Day of type int
item.IfPerformed_DateOfAction_Day = reader.GetInteger(10);
//11:Parameter IfPerfomed_DateOfAction of type DateTime
item.IfPerfomed_DateOfAction = reader.GetDate(11);
//12:Parameter IsFollowupPerformedAction of type Boolean
item.IsFollowupPerformedAction = reader.GetBoolean(12);
//13:Parameter IsFollowupPerformed_PreviousPerformedAction_RefID of type Guid
item.IsFollowupPerformed_PreviousPerformedAction_RefID = reader.GetGuid(13);
//14:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(14);
//15:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(15);
//16:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(16);
//17:Parameter Modification_Timestamp of type DateTime
item.Modification_Timestamp = reader.GetDate(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);
}
