private static List <ORM_CMN_BPT_EMP_WorkplaceAssignments_WorkPattern> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_CMN_BPT_EMP_WorkplaceAssignments_WorkPattern> 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_EMP_WorkplaceAssignments_WorkPattern>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "CMN_BPT_EMP_WorkplaceAssignments_WorkPatternID", "IsWeek_Even", "IsWeek_Odd", "BoundTo_WorkplaceAssignment_RefID", "CMN_PPS_ShiftTemplate_RefID", "CMN_BPT_STA_AbsenceReason_RefID", "IsMonday", "IsTuesday", "IsWednesday", "IsThursday", "IsFriday", "IsSaturday", "IsSunday", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" });
while (reader.Read())
{
ORM_CMN_BPT_EMP_WorkplaceAssignments_WorkPattern item = new ORM_CMN_BPT_EMP_WorkplaceAssignments_WorkPattern();
//0:Parameter CMN_BPT_EMP_WorkplaceAssignments_WorkPatternID of type Guid
item.CMN_BPT_EMP_WorkplaceAssignments_WorkPatternID = reader.GetGuid(0);
//1:Parameter IsWeek_Even of type Boolean
item.IsWeek_Even = reader.GetBoolean(1);
//2:Parameter IsWeek_Odd of type Boolean
item.IsWeek_Odd = reader.GetBoolean(2);
//3:Parameter BoundTo_WorkplaceAssignment_RefID of type Guid
item.BoundTo_WorkplaceAssignment_RefID = reader.GetGuid(3);
//4:Parameter CMN_PPS_ShiftTemplate_RefID of type Guid
item.CMN_PPS_ShiftTemplate_RefID = reader.GetGuid(4);
//5:Parameter CMN_BPT_STA_AbsenceReason_RefID of type Guid
item.CMN_BPT_STA_AbsenceReason_RefID = reader.GetGuid(5);
//6:Parameter IsMonday of type Boolean
item.IsMonday = reader.GetBoolean(6);
//7:Parameter IsTuesday of type Boolean
item.IsTuesday = reader.GetBoolean(7);
//8:Parameter IsWednesday of type Boolean
item.IsWednesday = reader.GetBoolean(8);
//9:Parameter IsThursday of type Boolean
item.IsThursday = reader.GetBoolean(9);
//10:Parameter IsFriday of type Boolean
item.IsFriday = reader.GetBoolean(10);
//11:Parameter IsSaturday of type Boolean
item.IsSaturday = reader.GetBoolean(11);
//12:Parameter IsSunday of type Boolean
item.IsSunday = reader.GetBoolean(12);
//13:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(13);
//14:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(14);
//15:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(15);
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_RES_STR_Apartment_RequiredAction> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_RES_STR_Apartment_RequiredAction> 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_STR_Apartment_RequiredAction>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "RES_STR_Apartment_RequiredActionID", "ApartmentPropertyAssessment_RefID", "SelectedActionVersion_RefID", "EffectivePrice_RefID", "Comment", "Action_PricePerUnit_RefID", "Action_Unit_RefID", "Action_UnitAmount", "IsCustom", "IfCustom_Name", "IfCustom_Description", "Creation_Timestamp", "IsDeleted", "Tenant_RefID", "Action_Timeframe_RefID" });
while (reader.Read())
{
ORM_RES_STR_Apartment_RequiredAction item = new ORM_RES_STR_Apartment_RequiredAction();
//0:Parameter RES_STR_Apartment_RequiredActionID of type Guid
item.RES_STR_Apartment_RequiredActionID = reader.GetGuid(0);
//1:Parameter ApartmentPropertyAssessment_RefID of type Guid
item.ApartmentPropertyAssessment_RefID = reader.GetGuid(1);
//2:Parameter SelectedActionVersion_RefID of type Guid
item.SelectedActionVersion_RefID = reader.GetGuid(2);
//3:Parameter EffectivePrice_RefID of type Guid
item.EffectivePrice_RefID = reader.GetGuid(3);
//4:Parameter Comment of type String
item.Comment = reader.GetString(4);
//5:Parameter Action_PricePerUnit_RefID of type Guid
item.Action_PricePerUnit_RefID = reader.GetGuid(5);
//6:Parameter Action_Unit_RefID of type Guid
item.Action_Unit_RefID = reader.GetGuid(6);
//7:Parameter Action_UnitAmount of type Double
item.Action_UnitAmount = reader.GetDouble(7);
//8:Parameter IsCustom of type Boolean
item.IsCustom = reader.GetBoolean(8);
//9:Parameter IfCustom_Name of type String
item.IfCustom_Name = reader.GetString(9);
//10:Parameter IfCustom_Description of type String
item.IfCustom_Description = reader.GetString(10);
//11:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(11);
//12:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(12);
//13:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(13);
//14:Parameter Action_Timeframe_RefID of type Guid
item.Action_Timeframe_RefID = reader.GetGuid(14);
item.Status_IsAlreadySaved = true;
item.Status_IsDirty = false;
items.Add(item);
}
reader.Close();
loader.Load();
managedConnection.commit();
}
catch (Exception ex)
{
managedConnection.rollback();
throw;
}
return(items);
}
private static List <ORM_HEC_ACT_UsedProduct> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_HEC_ACT_UsedProduct> 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_UsedProduct>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "HEC_ACT_UsedProductID", "HEC_ACT_PerformedAction_RefID", "UsedIn_Procedure_RefID", "Relevant_PatientDiagnosis_RefID", "IsHealthcare", "IsHealthcareProduct", "HEC_Product_RefID", "IsSubstance", "IfSubstance_Strength", "IfSubstance_Unit_RefID", "IfSubstance_Substance_RefiD", "Quantity", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" });
while (reader.Read())
{
ORM_HEC_ACT_UsedProduct item = new ORM_HEC_ACT_UsedProduct();
//0:Parameter HEC_ACT_UsedProductID of type Guid
item.HEC_ACT_UsedProductID = reader.GetGuid(0);
//1:Parameter HEC_ACT_PerformedAction_RefID of type Guid
item.HEC_ACT_PerformedAction_RefID = reader.GetGuid(1);
//2:Parameter UsedIn_Procedure_RefID of type Guid
item.UsedIn_Procedure_RefID = reader.GetGuid(2);
//3:Parameter Relevant_PatientDiagnosis_RefID of type Guid
item.Relevant_PatientDiagnosis_RefID = reader.GetGuid(3);
//4:Parameter IsHealthcare of type String
item.IsHealthcare = reader.GetString(4);
//5:Parameter IsHealthcareProduct of type Boolean
item.IsHealthcareProduct = reader.GetBoolean(5);
//6:Parameter HEC_Product_RefID of type Guid
item.HEC_Product_RefID = reader.GetGuid(6);
//7:Parameter IsSubstance of type Boolean
item.IsSubstance = reader.GetBoolean(7);
//8:Parameter IfSubstance_Strength of type String
item.IfSubstance_Strength = reader.GetString(8);
//9:Parameter IfSubstance_Unit_RefID of type Guid
item.IfSubstance_Unit_RefID = reader.GetGuid(9);
//10:Parameter IfSubstance_Substance_RefiD of type Guid
item.IfSubstance_Substance_RefiD = reader.GetGuid(10);
//11:Parameter Quantity of type double
item.Quantity = reader.GetDouble(11);
//12:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(12);
//13:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(13);
//14:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(14);
//15:Parameter Modification_Timestamp of type DateTime
item.Modification_Timestamp = reader.GetDate(15);
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_Comment> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_TMS_PRO_Comment> 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_Comment>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "TMS_PRO_CommentID", "Comment_BoundTo_Project_RefID", "Comment_BoundTo_BusinessTask_RefID", "Comment_BoundTo_Feature_RefID", "Comment_BoundTo_DeveloperTask_RefID", "IsComment_BoundToBusinessTask", "IsComment_BoundToFeature", "IsComment_BoundToDeveloperTask", "Comment_Quoatation_RefID", "Comment_CreatedByAccount_RefID", "Comment_Quotation_Text", "Comment_TextContent", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" });
while (reader.Read())
{
ORM_TMS_PRO_Comment item = new ORM_TMS_PRO_Comment();
//0:Parameter TMS_PRO_CommentID of type Guid
item.TMS_PRO_CommentID = reader.GetGuid(0);
//1:Parameter Comment_BoundTo_Project_RefID of type Guid
item.Comment_BoundTo_Project_RefID = reader.GetGuid(1);
//2:Parameter Comment_BoundTo_BusinessTask_RefID of type Guid
item.Comment_BoundTo_BusinessTask_RefID = reader.GetGuid(2);
//3:Parameter Comment_BoundTo_Feature_RefID of type Guid
item.Comment_BoundTo_Feature_RefID = reader.GetGuid(3);
//4:Parameter Comment_BoundTo_DeveloperTask_RefID of type Guid
item.Comment_BoundTo_DeveloperTask_RefID = reader.GetGuid(4);
//5:Parameter IsComment_BoundToBusinessTask of type Boolean
item.IsComment_BoundToBusinessTask = reader.GetBoolean(5);
//6:Parameter IsComment_BoundToFeature of type Boolean
item.IsComment_BoundToFeature = reader.GetBoolean(6);
//7:Parameter IsComment_BoundToDeveloperTask of type Boolean
item.IsComment_BoundToDeveloperTask = reader.GetBoolean(7);
//8:Parameter Comment_Quoatation_RefID of type Guid
item.Comment_Quoatation_RefID = reader.GetGuid(8);
//9:Parameter Comment_CreatedByAccount_RefID of type Guid
item.Comment_CreatedByAccount_RefID = reader.GetGuid(9);
//10:Parameter Comment_Quotation_Text of type String
item.Comment_Quotation_Text = reader.GetString(10);
//11:Parameter Comment_TextContent of type String
item.Comment_TextContent = reader.GetString(11);
//12:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(12);
//13:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(13);
//14:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(14);
item.Status_IsAlreadySaved = true;
item.Status_IsDirty = false;
items.Add(item);
}
reader.Close();
loader.Load();
managedConnection.commit();
}
catch (Exception ex)
{
managedConnection.rollback();
throw ex;
}
return(items);
}
private static List <ORM_CMN_BPT_CTM_OrganizationalUnit> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_CMN_BPT_CTM_OrganizationalUnit> 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_OrganizationalUnit>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "CMN_BPT_CTM_OrganizationalUnitID", "CustomerTenant_OfficeITL", "InternalOrganizationalUnitNumber", "InternalOrganizationalUnitSimpleName", "ExternalOrganizationalUnitNumber", "Customer_RefID", "Parent_OrganizationalUnit_RefID", "OrganizationalUnit_SimpleName", "OrganizationalUnit_Name_DictID", "OrganizationalUnit_Description_DictID", "Default_PhoneNumber", "Default_FaxNumber", "DisplayImage_Document_RefID", "IsMedicalPractice", "IfMedicalPractise_HEC_MedicalPractice_RefID", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" });
while (reader.Read())
{
ORM_CMN_BPT_CTM_OrganizationalUnit item = new ORM_CMN_BPT_CTM_OrganizationalUnit();
//0:Parameter CMN_BPT_CTM_OrganizationalUnitID of type Guid
item.CMN_BPT_CTM_OrganizationalUnitID = reader.GetGuid(0);
//1:Parameter CustomerTenant_OfficeITL of type String
item.CustomerTenant_OfficeITL = reader.GetString(1);
//2:Parameter InternalOrganizationalUnitNumber of type String
item.InternalOrganizationalUnitNumber = reader.GetString(2);
//3:Parameter InternalOrganizationalUnitSimpleName of type String
item.InternalOrganizationalUnitSimpleName = reader.GetString(3);
//4:Parameter ExternalOrganizationalUnitNumber of type String
item.ExternalOrganizationalUnitNumber = reader.GetString(4);
//5:Parameter Customer_RefID of type Guid
item.Customer_RefID = reader.GetGuid(5);
//6:Parameter Parent_OrganizationalUnit_RefID of type Guid
item.Parent_OrganizationalUnit_RefID = reader.GetGuid(6);
//7:Parameter OrganizationalUnit_SimpleName of type String
item.OrganizationalUnit_SimpleName = reader.GetString(7);
//8:Parameter OrganizationalUnit_Name of type Dict
item.OrganizationalUnit_Name = reader.GetDictionary(8);
loader.Append(item.OrganizationalUnit_Name, TableName);
//9:Parameter OrganizationalUnit_Description of type Dict
item.OrganizationalUnit_Description = reader.GetDictionary(9);
loader.Append(item.OrganizationalUnit_Description, TableName);
//10:Parameter Default_PhoneNumber of type String
item.Default_PhoneNumber = reader.GetString(10);
//11:Parameter Default_FaxNumber of type String
item.Default_FaxNumber = reader.GetString(11);
//12:Parameter DisplayImage_Document_RefID of type Guid
item.DisplayImage_Document_RefID = reader.GetGuid(12);
//13:Parameter IsMedicalPractice of type Boolean
item.IsMedicalPractice = reader.GetBoolean(13);
//14:Parameter IfMedicalPractise_HEC_MedicalPractice_RefID of type Guid
item.IfMedicalPractise_HEC_MedicalPractice_RefID = reader.GetGuid(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);
//18:Parameter Modification_Timestamp of type DateTime
item.Modification_Timestamp = reader.GetDate(18);
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_STR_PPS_EffectiveWorkTime> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_CMN_STR_PPS_EffectiveWorkTime> 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_STR_PPS_EffectiveWorkTime>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "CMN_STR_PPS_EffectiveWorkTimeID", "CMN_BPT_EMP_Employe_RefID", "BoundTo_DailyWorkShedule_Detail_RefID", "Activity_RefID", "Workplace_RefID", "CMN_BPT_EMP_Employee_LeaveRequest_RefID", "WorkTime_StartTime", "WorkTime_Duration_in_sec", "SourceOfEntry", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" });
while (reader.Read())
{
ORM_CMN_STR_PPS_EffectiveWorkTime item = new ORM_CMN_STR_PPS_EffectiveWorkTime();
//0:Parameter CMN_STR_PPS_EffectiveWorkTimeID of type Guid
item.CMN_STR_PPS_EffectiveWorkTimeID = reader.GetGuid(0);
//1:Parameter CMN_BPT_EMP_Employe_RefID of type Guid
item.CMN_BPT_EMP_Employe_RefID = reader.GetGuid(1);
//2:Parameter BoundTo_DailyWorkShedule_Detail_RefID of type Guid
item.BoundTo_DailyWorkShedule_Detail_RefID = reader.GetGuid(2);
//3:Parameter Activity_RefID of type Guid
item.Activity_RefID = reader.GetGuid(3);
//4:Parameter Workplace_RefID of type Guid
item.Workplace_RefID = reader.GetGuid(4);
//5:Parameter CMN_BPT_EMP_Employee_LeaveRequest_RefID of type Guid
item.CMN_BPT_EMP_Employee_LeaveRequest_RefID = reader.GetGuid(5);
//6:Parameter WorkTime_StartTime of type DateTime
item.WorkTime_StartTime = reader.GetDate(6);
//7:Parameter WorkTime_Duration_in_sec of type int
item.WorkTime_Duration_in_sec = reader.GetInteger(7);
//8:Parameter SourceOfEntry of type int
item.SourceOfEntry = reader.GetInteger(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 ex;
}
return(items);
}
private static List <ORM_HEC_Patient_Medication> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_HEC_Patient_Medication> items;
try
{
managedConnection.set(connectionString, connection, transaction);
var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(managedConnection.getConnection(), managedConnection.getTransaction());
DbCommand command = managedConnection.manage(query.CreateSelectQuery(TableName));
query.SetParameters(command);
items = new List <ORM_HEC_Patient_Medication>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "HEC_Patient_MedicationID", "Patient_RefID", "R_IsActive", "R_ActiveUntill", "R_DateOfAdding", "R_DateOfRemoval", "R_IsHealthcareProduct", "R_HEC_Product_RefID", "R_IsSubstance", "R_IfSubstance_Strength", "R_IfSubstance_Unit_RefID", "R_IfSubstance_Substance_RefiD", "R_DosageText", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" });
while (reader.Read())
{
ORM_HEC_Patient_Medication item = new ORM_HEC_Patient_Medication();
//0:Parameter HEC_Patient_MedicationID of type Guid
item.HEC_Patient_MedicationID = reader.GetGuid(0);
//1:Parameter Patient_RefID of type Guid
item.Patient_RefID = reader.GetGuid(1);
//2:Parameter R_IsActive of type Boolean
item.R_IsActive = reader.GetBoolean(2);
//3:Parameter R_ActiveUntill of type DateTime
item.R_ActiveUntill = reader.GetDate(3);
//4:Parameter R_DateOfAdding of type DateTime
item.R_DateOfAdding = reader.GetDate(4);
//5:Parameter R_DateOfRemoval of type DateTime
item.R_DateOfRemoval = reader.GetDate(5);
//6:Parameter R_IsHealthcareProduct of type Boolean
item.R_IsHealthcareProduct = reader.GetBoolean(6);
//7:Parameter R_HEC_Product_RefID of type Guid
item.R_HEC_Product_RefID = reader.GetGuid(7);
//8:Parameter R_IsSubstance of type Boolean
item.R_IsSubstance = reader.GetBoolean(8);
//9:Parameter R_IfSubstance_Strength of type String
item.R_IfSubstance_Strength = reader.GetString(9);
//10:Parameter R_IfSubstance_Unit_RefID of type Guid
item.R_IfSubstance_Unit_RefID = reader.GetGuid(10);
//11:Parameter R_IfSubstance_Substance_RefiD of type Guid
item.R_IfSubstance_Substance_RefiD = reader.GetGuid(11);
//12:Parameter R_DosageText of type String
item.R_DosageText = reader.GetString(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_HEC_Patient_HealthInsurance> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_HEC_Patient_HealthInsurance> 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_HealthInsurance>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "HEC_Patient_HealthInsurancesID", "HealthInsurance_Number", "HealthInsurance_State_RefID", "Patient_RefID", "HIS_HealthInsurance_Company_RefID", "IsPrimary", "SequenceNumber", "InsuranceStateCode", "InsuranceValidFrom", "InsuranceValidThrough", "IsNotSelfInsured", "IsNotSelfInsured_InsuredPersonName", "IsNotSelfInsured_InsuredPersonBirthday", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" });
while (reader.Read())
{
ORM_HEC_Patient_HealthInsurance item = new ORM_HEC_Patient_HealthInsurance();
//0:Parameter HEC_Patient_HealthInsurancesID of type Guid
item.HEC_Patient_HealthInsurancesID = reader.GetGuid(0);
//1:Parameter HealthInsurance_Number of type String
item.HealthInsurance_Number = reader.GetString(1);
//2:Parameter HealthInsurance_State_RefID of type Guid
item.HealthInsurance_State_RefID = reader.GetGuid(2);
//3:Parameter Patient_RefID of type Guid
item.Patient_RefID = reader.GetGuid(3);
//4:Parameter HIS_HealthInsurance_Company_RefID of type Guid
item.HIS_HealthInsurance_Company_RefID = reader.GetGuid(4);
//5:Parameter IsPrimary of type Boolean
item.IsPrimary = reader.GetBoolean(5);
//6:Parameter SequenceNumber of type int
item.SequenceNumber = reader.GetInteger(6);
//7:Parameter InsuranceStateCode of type String
item.InsuranceStateCode = reader.GetString(7);
//8:Parameter InsuranceValidFrom of type DateTime
item.InsuranceValidFrom = reader.GetDate(8);
//9:Parameter InsuranceValidThrough of type DateTime
item.InsuranceValidThrough = reader.GetDate(9);
//10:Parameter IsNotSelfInsured of type Boolean
item.IsNotSelfInsured = reader.GetBoolean(10);
//11:Parameter IsNotSelfInsured_InsuredPersonName of type String
item.IsNotSelfInsured_InsuredPersonName = reader.GetString(11);
//12:Parameter IsNotSelfInsured_InsuredPersonBirthday of type DateTime
item.IsNotSelfInsured_InsuredPersonBirthday = reader.GetDate(12);
//13:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(13);
//14:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(14);
//15:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(15);
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_Tenant> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List<ORM_CMN_Tenant> 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_Tenant>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "CMN_TenantID","TenantITL","UniversalContactDetail_RefID","CMN_CAL_CalendarInstance_RefID","IsUsing_Offices","IsUsing_WorkAreas","IsUsing_Workplaces","IsUsing_CostCenters","CMN_BPT_STA_SettingProfile_RefID","DocumentServerRootURL","Customers_DefaultPricelist_RefID","Creation_Timestamp","Tenant_RefID","IsDeleted" });
while (reader.Read())
{
ORM_CMN_Tenant item = new ORM_CMN_Tenant();
//0:Parameter CMN_TenantID of type Guid
item.CMN_TenantID = reader.GetGuid(0);
//1:Parameter TenantITL of type String
item.TenantITL = reader.GetString(1);
//2:Parameter UniversalContactDetail_RefID of type Guid
item.UniversalContactDetail_RefID = reader.GetGuid(2);
//3:Parameter CMN_CAL_CalendarInstance_RefID of type Guid
item.CMN_CAL_CalendarInstance_RefID = reader.GetGuid(3);
//4:Parameter IsUsing_Offices of type Boolean
item.IsUsing_Offices = reader.GetBoolean(4);
//5:Parameter IsUsing_WorkAreas of type Boolean
item.IsUsing_WorkAreas = reader.GetBoolean(5);
//6:Parameter IsUsing_Workplaces of type Boolean
item.IsUsing_Workplaces = reader.GetBoolean(6);
//7:Parameter IsUsing_CostCenters of type Boolean
item.IsUsing_CostCenters = reader.GetBoolean(7);
//8:Parameter CMN_BPT_STA_SettingProfile_RefID of type Guid
item.CMN_BPT_STA_SettingProfile_RefID = reader.GetGuid(8);
//9:Parameter DocumentServerRootURL of type String
item.DocumentServerRootURL = reader.GetString(9);
//10:Parameter Customers_DefaultPricelist_RefID of type Guid
item.Customers_DefaultPricelist_RefID = reader.GetGuid(10);
//11:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(11);
//12:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(12);
//13:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(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_STA_AbsenceReason> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_CMN_BPT_STA_AbsenceReason> 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_STA_AbsenceReason>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "CMN_BPT_STA_AbsenceReasonID", "ShortName", "Name_DictID", "Description_DictID", "AbsenceReason_Type_RefID", "ColorCode", "Parent_RefID", "IsAuthorizationRequired", "IsIncludedInCapacityCalculation", "IsAllowedAbsence", "IsDeactivated", "IsCarryOverEnabled", "IsCaryOverLimited", "IfCarryOverLimited_MaximumAmount_Hrs", "IsLeaveTimeReducing_WorkingHours", "IsLeaveTimeReducing_OverHours", "IsLeaveTimeReducing_OverDays", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" });
while (reader.Read())
{
ORM_CMN_BPT_STA_AbsenceReason item = new ORM_CMN_BPT_STA_AbsenceReason();
//0:Parameter CMN_BPT_STA_AbsenceReasonID of type Guid
item.CMN_BPT_STA_AbsenceReasonID = reader.GetGuid(0);
//1:Parameter ShortName of type String
item.ShortName = reader.GetString(1);
//2:Parameter Name of type Dict
item.Name = reader.GetDictionary(2);
loader.Append(item.Name, TableName);
//3:Parameter Description of type Dict
item.Description = reader.GetDictionary(3);
loader.Append(item.Description, TableName);
//4:Parameter AbsenceReason_Type_RefID of type Guid
item.AbsenceReason_Type_RefID = reader.GetGuid(4);
//5:Parameter ColorCode of type String
item.ColorCode = reader.GetString(5);
//6:Parameter Parent_RefID of type Guid
item.Parent_RefID = reader.GetGuid(6);
//7:Parameter IsAuthorizationRequired of type Boolean
item.IsAuthorizationRequired = reader.GetBoolean(7);
//8:Parameter IsIncludedInCapacityCalculation of type Boolean
item.IsIncludedInCapacityCalculation = reader.GetBoolean(8);
//9:Parameter IsAllowedAbsence of type Boolean
item.IsAllowedAbsence = reader.GetBoolean(9);
//10:Parameter IsDeactivated of type Boolean
item.IsDeactivated = reader.GetBoolean(10);
//11:Parameter IsCarryOverEnabled of type Boolean
item.IsCarryOverEnabled = reader.GetBoolean(11);
//12:Parameter IsCaryOverLimited of type Boolean
item.IsCaryOverLimited = reader.GetBoolean(12);
//13:Parameter IfCarryOverLimited_MaximumAmount_Hrs of type Double
item.IfCarryOverLimited_MaximumAmount_Hrs = reader.GetDouble(13);
//14:Parameter IsLeaveTimeReducing_WorkingHours of type Boolean
item.IsLeaveTimeReducing_WorkingHours = reader.GetBoolean(14);
//15:Parameter IsLeaveTimeReducing_OverHours of type Boolean
item.IsLeaveTimeReducing_OverHours = reader.GetBoolean(15);
//16:Parameter IsLeaveTimeReducing_OverDays of type Boolean
item.IsLeaveTimeReducing_OverDays = reader.GetBoolean(16);
//17:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(17);
//18:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(18);
//19:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(19);
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_ACT_PerformedAction_Referral> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_HEC_ACT_PerformedAction_Referral> 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_Referral>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "HEC_ACT_PerformedAction_ReferralID", "HEC_ACT_PerformedAction_RefID", "IsReferral_ForFollowup", "ReferralTo_MedicalPracticeType_RefID", "ReferralTo_MedicalPractice_RefID", "ReferralTo_BusinessParticipant_RefID", "PatientEffectivelyWentTo_MedicalPractice_RefID", "ReferralComment", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" });
while (reader.Read())
{
ORM_HEC_ACT_PerformedAction_Referral item = new ORM_HEC_ACT_PerformedAction_Referral();
//0:Parameter HEC_ACT_PerformedAction_ReferralID of type Guid
item.HEC_ACT_PerformedAction_ReferralID = reader.GetGuid(0);
//1:Parameter HEC_ACT_PerformedAction_RefID of type Guid
item.HEC_ACT_PerformedAction_RefID = reader.GetGuid(1);
//2:Parameter IsReferral_ForFollowup of type Boolean
item.IsReferral_ForFollowup = reader.GetBoolean(2);
//3:Parameter ReferralTo_MedicalPracticeType_RefID of type Guid
item.ReferralTo_MedicalPracticeType_RefID = reader.GetGuid(3);
//4:Parameter ReferralTo_MedicalPractice_RefID of type Guid
item.ReferralTo_MedicalPractice_RefID = reader.GetGuid(4);
//5:Parameter ReferralTo_BusinessParticipant_RefID of type Guid
item.ReferralTo_BusinessParticipant_RefID = reader.GetGuid(5);
//6:Parameter PatientEffectivelyWentTo_MedicalPractice_RefID of type Guid
item.PatientEffectivelyWentTo_MedicalPractice_RefID = reader.GetGuid(6);
//7:Parameter ReferralComment of type String
item.ReferralComment = reader.GetString(7);
//8:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(8);
//9:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(9);
//10:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(10);
//11:Parameter Modification_Timestamp of type DateTime
item.Modification_Timestamp = reader.GetDate(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_CMN_STR_PPS_DailyWorkSchedule_Detail> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_CMN_STR_PPS_DailyWorkSchedule_Detail> 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_STR_PPS_DailyWorkSchedule_Detail>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "CMN_STR_PPS_DailyWorkSchedule_DetailID", "InstantiatedWithShiftTemplate_RefID", "CMN_CAL_Event_RefID", "DailyWorkSchedule_RefID", "AbsenceReason_RefID", "SheduleForWorkplace_RefID", "IsWorkBreak", "CMN_BPT_EMP_Employee_LeaveRequest_RefID", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" });
while (reader.Read())
{
ORM_CMN_STR_PPS_DailyWorkSchedule_Detail item = new ORM_CMN_STR_PPS_DailyWorkSchedule_Detail();
//0:Parameter CMN_STR_PPS_DailyWorkSchedule_DetailID of type Guid
item.CMN_STR_PPS_DailyWorkSchedule_DetailID = reader.GetGuid(0);
//1:Parameter InstantiatedWithShiftTemplate_RefID of type Guid
item.InstantiatedWithShiftTemplate_RefID = reader.GetGuid(1);
//2:Parameter CMN_CAL_Event_RefID of type Guid
item.CMN_CAL_Event_RefID = reader.GetGuid(2);
//3:Parameter DailyWorkSchedule_RefID of type Guid
item.DailyWorkSchedule_RefID = reader.GetGuid(3);
//4:Parameter AbsenceReason_RefID of type Guid
item.AbsenceReason_RefID = reader.GetGuid(4);
//5:Parameter SheduleForWorkplace_RefID of type Guid
item.SheduleForWorkplace_RefID = reader.GetGuid(5);
//6:Parameter IsWorkBreak of type Boolean
item.IsWorkBreak = reader.GetBoolean(6);
//7:Parameter CMN_BPT_EMP_Employee_LeaveRequest_RefID of type Guid
item.CMN_BPT_EMP_Employee_LeaveRequest_RefID = reader.GetGuid(7);
//8:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(8);
//9:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(9);
//10:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(10);
//11:Parameter Modification_Timestamp of type DateTime
item.Modification_Timestamp = reader.GetDate(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_QuickTask> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_TMS_QuickTask> 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_QuickTask>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "TMS_QuickTaskID", "IdentificationNumber", "IsManuallyEntered", "QuickTask_Title_DictID", "QuickTask_Description_DictID", "QuickTask_Type_RefID", "R_QuickTask_InvestedTime_min", "QuickTask_CreatedByAccount_RefID", "QuickTask_DocumentStructureHeader_RefID", "QuickTask_StartTime", "AssignedTo_Project_RefID", "AssignedTo_BusinessTask_RefID", "AssignedTo_Feature_RefID", "AssignedTo_DeveloperTask_RefID", "Tenant_RefID", "Creation_Timestamp", "IsDeleted" });
while (reader.Read())
{
ORM_TMS_QuickTask item = new ORM_TMS_QuickTask();
//0:Parameter TMS_QuickTaskID of type Guid
item.TMS_QuickTaskID = reader.GetGuid(0);
//1:Parameter IdentificationNumber of type String
item.IdentificationNumber = reader.GetString(1);
//2:Parameter IsManuallyEntered of type Boolean
item.IsManuallyEntered = reader.GetBoolean(2);
//3:Parameter QuickTask_Title of type Dict
item.QuickTask_Title = reader.GetDictionary(3);
loader.Append(item.QuickTask_Title, TableName);
//4:Parameter QuickTask_Description of type Dict
item.QuickTask_Description = reader.GetDictionary(4);
loader.Append(item.QuickTask_Description, TableName);
//5:Parameter QuickTask_Type_RefID of type Guid
item.QuickTask_Type_RefID = reader.GetGuid(5);
//6:Parameter R_QuickTask_InvestedTime_min of type Double
item.R_QuickTask_InvestedTime_min = reader.GetDouble(6);
//7:Parameter QuickTask_CreatedByAccount_RefID of type Guid
item.QuickTask_CreatedByAccount_RefID = reader.GetGuid(7);
//8:Parameter QuickTask_DocumentStructureHeader_RefID of type Guid
item.QuickTask_DocumentStructureHeader_RefID = reader.GetGuid(8);
//9:Parameter QuickTask_StartTime of type DateTime
item.QuickTask_StartTime = reader.GetDate(9);
//10:Parameter AssignedTo_Project_RefID of type Guid
item.AssignedTo_Project_RefID = reader.GetGuid(10);
//11:Parameter AssignedTo_BusinessTask_RefID of type Guid
item.AssignedTo_BusinessTask_RefID = reader.GetGuid(11);
//12:Parameter AssignedTo_Feature_RefID of type Guid
item.AssignedTo_Feature_RefID = reader.GetGuid(12);
//13:Parameter AssignedTo_DeveloperTask_RefID of type Guid
item.AssignedTo_DeveloperTask_RefID = reader.GetGuid(13);
//14:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(14);
//15:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(15);
//16:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(16);
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_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", "IsFinalized", "IM_IfPerformed_MedicalPractice_Name", "IM_IfPerformed_MedicalPracticeType_Name", "IM_IfPerformed_ResponsibleBP_FullName", "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 IsFinalized of type Boolean
item.IsFinalized = reader.GetBoolean(14);
//15:Parameter IM_IfPerformed_MedicalPractice_Name of type String
item.IM_IfPerformed_MedicalPractice_Name = reader.GetString(15);
//16:Parameter IM_IfPerformed_MedicalPracticeType_Name of type String
item.IM_IfPerformed_MedicalPracticeType_Name = reader.GetString(16);
//17:Parameter IM_IfPerformed_ResponsibleBP_FullName of type String
item.IM_IfPerformed_ResponsibleBP_FullName = reader.GetString(17);
//18:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(18);
//19:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(19);
//20:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(20);
//21:Parameter Modification_Timestamp of type DateTime
item.Modification_Timestamp = reader.GetDate(21);
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_STR_CostCenter> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_CMN_STR_CostCenter> 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_STR_CostCenter>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "CMN_STR_CostCenterID", "InternalID", "Name_DictID", "Description_DictID", "CostCenterType_RefID", "ResponsiblePerson_RefID", "Currency_RefID", "CostCenter_Parent_RefID", "R_CostCenter_HasChildren", "OpenForBooking", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" });
while (reader.Read())
{
ORM_CMN_STR_CostCenter item = new ORM_CMN_STR_CostCenter();
//0:Parameter CMN_STR_CostCenterID of type Guid
item.CMN_STR_CostCenterID = reader.GetGuid(0);
//1:Parameter InternalID of type String
item.InternalID = reader.GetString(1);
//2:Parameter Name of type Dict
item.Name = reader.GetDictionary(2);
loader.Append(item.Name, TableName);
//3:Parameter Description of type Dict
item.Description = reader.GetDictionary(3);
loader.Append(item.Description, TableName);
//4:Parameter CostCenterType_RefID of type Guid
item.CostCenterType_RefID = reader.GetGuid(4);
//5:Parameter ResponsiblePerson_RefID of type Guid
item.ResponsiblePerson_RefID = reader.GetGuid(5);
//6:Parameter Currency_RefID of type Guid
item.Currency_RefID = reader.GetGuid(6);
//7:Parameter CostCenter_Parent_RefID of type Guid
item.CostCenter_Parent_RefID = reader.GetGuid(7);
//8:Parameter R_CostCenter_HasChildren of type bool
item.R_CostCenter_HasChildren = reader.GetBoolean(8);
//9:Parameter OpenForBooking of type bool
item.OpenForBooking = reader.GetBoolean(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;
}
return(items);
}
private static List <ORM_CMN_CAL_WeeklyOfficeHours_Interval> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_CMN_CAL_WeeklyOfficeHours_Interval> 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_CAL_WeeklyOfficeHours_Interval>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "CMN_CAL_WeeklyOfficeHours_IntervalID", "WeeklyOfficeHours_Template_RefID", "IsWholeDay", "TimeFrom_InMinutes", "TimeTo_InMinutes", "IsMonday", "IsTuesday", "IsWednesday", "IsThursday", "IsFriday", "IsSaturday", "IsSunday", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" });
while (reader.Read())
{
ORM_CMN_CAL_WeeklyOfficeHours_Interval item = new ORM_CMN_CAL_WeeklyOfficeHours_Interval();
//0:Parameter CMN_CAL_WeeklyOfficeHours_IntervalID of type Guid
item.CMN_CAL_WeeklyOfficeHours_IntervalID = reader.GetGuid(0);
//1:Parameter WeeklyOfficeHours_Template_RefID of type Guid
item.WeeklyOfficeHours_Template_RefID = reader.GetGuid(1);
//2:Parameter IsWholeDay of type Boolean
item.IsWholeDay = reader.GetBoolean(2);
//3:Parameter TimeFrom_InMinutes of type long
item.TimeFrom_InMinutes = reader.GetLong(3);
//4:Parameter TimeTo_InMinutes of type long
item.TimeTo_InMinutes = reader.GetLong(4);
//5:Parameter IsMonday of type Boolean
item.IsMonday = reader.GetBoolean(5);
//6:Parameter IsTuesday of type Boolean
item.IsTuesday = reader.GetBoolean(6);
//7:Parameter IsWednesday of type Boolean
item.IsWednesday = reader.GetBoolean(7);
//8:Parameter IsThursday of type Boolean
item.IsThursday = reader.GetBoolean(8);
//9:Parameter IsFriday of type Boolean
item.IsFriday = reader.GetBoolean(9);
//10:Parameter IsSaturday of type Boolean
item.IsSaturday = reader.GetBoolean(10);
//11:Parameter IsSunday of type Boolean
item.IsSunday = reader.GetBoolean(11);
//12:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(12);
//13:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(13);
//14:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(14);
item.Status_IsAlreadySaved = true;
item.Status_IsDirty = false;
items.Add(item);
}
reader.Close();
loader.Load();
managedConnection.commit();
}
catch (Exception ex)
{
managedConnection.rollback();
throw ex;
}
return(items);
}
private static List <ORM_ACC_BOK_BookingAccounts_Purpose_BP_Assignment> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_ACC_BOK_BookingAccounts_Purpose_BP_Assignment> 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_BOK_BookingAccounts_Purpose_BP_Assignment>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "ACC_BOK_BookingAccounts_Purpose_BP_AssignmentID", "BusinessParticipant_RefID", "BookingAccount_RefID", "Is_L1_BalanceSheet_Account", "Is_L1_IncomeStatement_Account", "Is_L2_AssetAccount", "Is_L2_LiabilitiesAccount", "Is_L2_RevenuesOrIncomeAccount", "Is_L2_ExpensesOrLossesAccount", "If_L3_AssetAccount_BankAccount_RefID", "If_L3_AssetAccount_CashBox_RefID", "Is_L3_BankAccount", "Is_L3_CustomerAccount", "Is_L3_SupplierAccount", "Is_L3_VATAccount", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" });
while (reader.Read())
{
ORM_ACC_BOK_BookingAccounts_Purpose_BP_Assignment item = new ORM_ACC_BOK_BookingAccounts_Purpose_BP_Assignment();
//0:Parameter ACC_BOK_BookingAccounts_Purpose_BP_AssignmentID of type Guid
item.ACC_BOK_BookingAccounts_Purpose_BP_AssignmentID = reader.GetGuid(0);
//1:Parameter BusinessParticipant_RefID of type Guid
item.BusinessParticipant_RefID = reader.GetGuid(1);
//2:Parameter BookingAccount_RefID of type Guid
item.BookingAccount_RefID = reader.GetGuid(2);
//3:Parameter Is_L1_BalanceSheet_Account of type Boolean
item.Is_L1_BalanceSheet_Account = reader.GetBoolean(3);
//4:Parameter Is_L1_IncomeStatement_Account of type Boolean
item.Is_L1_IncomeStatement_Account = reader.GetBoolean(4);
//5:Parameter Is_L2_AssetAccount of type Boolean
item.Is_L2_AssetAccount = reader.GetBoolean(5);
//6:Parameter Is_L2_LiabilitiesAccount of type Boolean
item.Is_L2_LiabilitiesAccount = reader.GetBoolean(6);
//7:Parameter Is_L2_RevenuesOrIncomeAccount of type Boolean
item.Is_L2_RevenuesOrIncomeAccount = reader.GetBoolean(7);
//8:Parameter Is_L2_ExpensesOrLossesAccount of type Boolean
item.Is_L2_ExpensesOrLossesAccount = reader.GetBoolean(8);
//9:Parameter If_L3_AssetAccount_BankAccount_RefID of type Guid
item.If_L3_AssetAccount_BankAccount_RefID = reader.GetGuid(9);
//10:Parameter If_L3_AssetAccount_CashBox_RefID of type Guid
item.If_L3_AssetAccount_CashBox_RefID = reader.GetGuid(10);
//11:Parameter Is_L3_BankAccount of type Boolean
item.Is_L3_BankAccount = reader.GetBoolean(11);
//12:Parameter Is_L3_CustomerAccount of type Boolean
item.Is_L3_CustomerAccount = reader.GetBoolean(12);
//13:Parameter Is_L3_SupplierAccount of type Boolean
item.Is_L3_SupplierAccount = reader.GetBoolean(13);
//14:Parameter Is_L3_VATAccount of type Boolean
item.Is_L3_VATAccount = 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);
}
private static List <ORM_ORD_PRC_RFP_SupplierProposalResponse_Position> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_ORD_PRC_RFP_SupplierProposalResponse_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_SupplierProposalResponse_Position>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "ORD_PRC_RFP_SupplierProposalResponse_PositionID", "ProposalResponsePositionITPL", "SupplierProposalResponseHeader_RefID", "CMN_PRO_Product_RefID", "CMN_PRO_Product_Variant_RefID", "CMN_PRO_Product_Release_RefID", "CreatedFrom_RequestForProposal_Position_RefID", "Quantity", "TotalPrice_WithoutTax", "TotalPrice_IncludingTax", "PricePerUnit_WithoutTax", "PricePerUnit_IncludingTax", "IsReplacementProduct", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" });
while (reader.Read())
{
ORM_ORD_PRC_RFP_SupplierProposalResponse_Position item = new ORM_ORD_PRC_RFP_SupplierProposalResponse_Position();
//0:Parameter ORD_PRC_RFP_SupplierProposalResponse_PositionID of type Guid
item.ORD_PRC_RFP_SupplierProposalResponse_PositionID = reader.GetGuid(0);
//1:Parameter ProposalResponsePositionITPL of type String
item.ProposalResponsePositionITPL = reader.GetString(1);
//2:Parameter SupplierProposalResponseHeader_RefID of type Guid
item.SupplierProposalResponseHeader_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 CreatedFrom_RequestForProposal_Position_RefID of type Guid
item.CreatedFrom_RequestForProposal_Position_RefID = reader.GetGuid(6);
//7:Parameter Quantity of type double
item.Quantity = reader.GetDouble(7);
//8:Parameter TotalPrice_WithoutTax of type Decimal
item.TotalPrice_WithoutTax = reader.GetDecimal(8);
//9:Parameter TotalPrice_IncludingTax of type Decimal
item.TotalPrice_IncludingTax = reader.GetDecimal(9);
//10:Parameter PricePerUnit_WithoutTax of type Decimal
item.PricePerUnit_WithoutTax = reader.GetDecimal(10);
//11:Parameter PricePerUnit_IncludingTax of type Decimal
item.PricePerUnit_IncludingTax = reader.GetDecimal(11);
//12:Parameter IsReplacementProduct of type Boolean
item.IsReplacementProduct = reader.GetBoolean(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);
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_Treatment> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_HEC_Patient_Treatment> 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_Treatment>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "HEC_Patient_TreatmentID", "PotentialTreatment_RefID", "TreatmentITL", "IsTreatmentFollowup", "IfTreatmentFollowup_FromTreatment_RefID", "TreatmentPractice_RefID", "IsTreatmentPerformed", "IfTreatmentPerformed_ByDoctor_RefID", "IfTreatmentPerformed_Date", "IsScheduled", "IfSheduled_Date", "IfSheduled_ForDoctor_RefID", "IsTreatmentBilled", "IfTreatmentBilled_Date", "Treatment_Comment", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" });
while (reader.Read())
{
ORM_HEC_Patient_Treatment item = new ORM_HEC_Patient_Treatment();
//0:Parameter HEC_Patient_TreatmentID of type Guid
item.HEC_Patient_TreatmentID = reader.GetGuid(0);
//1:Parameter PotentialTreatment_RefID of type Guid
item.PotentialTreatment_RefID = reader.GetGuid(1);
//2:Parameter TreatmentITL of type String
item.TreatmentITL = reader.GetString(2);
//3:Parameter IsTreatmentFollowup of type Boolean
item.IsTreatmentFollowup = reader.GetBoolean(3);
//4:Parameter IfTreatmentFollowup_FromTreatment_RefID of type Guid
item.IfTreatmentFollowup_FromTreatment_RefID = reader.GetGuid(4);
//5:Parameter TreatmentPractice_RefID of type Guid
item.TreatmentPractice_RefID = reader.GetGuid(5);
//6:Parameter IsTreatmentPerformed of type Boolean
item.IsTreatmentPerformed = reader.GetBoolean(6);
//7:Parameter IfTreatmentPerformed_ByDoctor_RefID of type Guid
item.IfTreatmentPerformed_ByDoctor_RefID = reader.GetGuid(7);
//8:Parameter IfTreatmentPerformed_Date of type DateTime
item.IfTreatmentPerformed_Date = reader.GetDate(8);
//9:Parameter IsScheduled of type Boolean
item.IsScheduled = reader.GetBoolean(9);
//10:Parameter IfSheduled_Date of type DateTime
item.IfSheduled_Date = reader.GetDate(10);
//11:Parameter IfSheduled_ForDoctor_RefID of type Guid
item.IfSheduled_ForDoctor_RefID = reader.GetGuid(11);
//12:Parameter IsTreatmentBilled of type Boolean
item.IsTreatmentBilled = reader.GetBoolean(12);
//13:Parameter IfTreatmentBilled_Date of type DateTime
item.IfTreatmentBilled_Date = reader.GetDate(13);
//14:Parameter Treatment_Comment of type String
item.Treatment_Comment = reader.GetString(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);
//18:Parameter Modification_Timestamp of type DateTime
item.Modification_Timestamp = reader.GetDate(18);
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_PRC_ProcurementOrder_Position> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_ORD_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_ORD_PRC_ProcurementOrder_Position>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "ORD_PRC_ProcurementOrder_PositionID", "SupplierCustomerOrderPositionITL", "ProcurementOrder_Header_RefID", "Position_OrdinalNumber", "Position_Quantity", "Position_ValuePerUnit", "Position_ValueTotal", "Position_Comment", "Position_Unit_RefID", "Position_RequestedDateOfDelivery", "CMN_PRO_Product_RefID", "CMN_PRO_Product_Variant_RefID", "CMN_PRO_Product_Release_RefID", "IsProductReplacementAllowed", "IsBonusDelivery_WasNotOrdered", "RequestedDateOfDelivery_TimeFrame_From", "RequestedDateOfDelivery_TimeFrame_To", "BillTo_BusinessParticipant_RefID", "IsProFormaOrderPosition", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" });
while (reader.Read())
{
ORM_ORD_PRC_ProcurementOrder_Position item = new ORM_ORD_PRC_ProcurementOrder_Position();
//0:Parameter ORD_PRC_ProcurementOrder_PositionID of type Guid
item.ORD_PRC_ProcurementOrder_PositionID = reader.GetGuid(0);
//1:Parameter SupplierCustomerOrderPositionITL of type String
item.SupplierCustomerOrderPositionITL = reader.GetString(1);
//2:Parameter ProcurementOrder_Header_RefID of type Guid
item.ProcurementOrder_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_Unit_RefID of type Guid
item.Position_Unit_RefID = reader.GetGuid(8);
//9:Parameter Position_RequestedDateOfDelivery of type DateTime
item.Position_RequestedDateOfDelivery = reader.GetDate(9);
//10:Parameter CMN_PRO_Product_RefID of type Guid
item.CMN_PRO_Product_RefID = reader.GetGuid(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_Release_RefID of type Guid
item.CMN_PRO_Product_Release_RefID = reader.GetGuid(12);
//13:Parameter IsProductReplacementAllowed of type Boolean
item.IsProductReplacementAllowed = reader.GetBoolean(13);
//14:Parameter IsBonusDelivery_WasNotOrdered of type Boolean
item.IsBonusDelivery_WasNotOrdered = reader.GetBoolean(14);
//15:Parameter RequestedDateOfDelivery_TimeFrame_From of type DateTime
item.RequestedDateOfDelivery_TimeFrame_From = reader.GetDate(15);
//16:Parameter RequestedDateOfDelivery_TimeFrame_To of type DateTime
item.RequestedDateOfDelivery_TimeFrame_To = reader.GetDate(16);
//17:Parameter BillTo_BusinessParticipant_RefID of type Guid
item.BillTo_BusinessParticipant_RefID = reader.GetGuid(17);
//18:Parameter IsProFormaOrderPosition of type Boolean
item.IsProFormaOrderPosition = reader.GetBoolean(18);
//19:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(19);
//20:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(20);
//21:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(21);
//22:Parameter Modification_Timestamp of type DateTime
item.Modification_Timestamp = reader.GetDate(22);
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_PRC_ProcurementOrder_Position_History> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_ORD_PRC_ProcurementOrder_Position_History> 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_ProcurementOrder_Position_History>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "ORD_PRC_ProcurementOrder_Position_HistoryID", "ProcurementOrder_Position_RefID", "IsCreated", "IsModified", "IsRemoved", "TriggeredBy_BusinessParticipant_RefID", "Comment", "IsLivePriceRequestProcessTriggered", "TriggeredFor_Quantity", "IsLivePriceRequestProcessAnswered", "AnsweredWith_TotalPrice", "AnsweredWith_Currency_RefID", "AnsweredWith_DeliverableQuantity", "AnsweredWith_EarliestDeliveryDate", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" });
while (reader.Read())
{
ORM_ORD_PRC_ProcurementOrder_Position_History item = new ORM_ORD_PRC_ProcurementOrder_Position_History();
//0:Parameter ORD_PRC_ProcurementOrder_Position_HistoryID of type Guid
item.ORD_PRC_ProcurementOrder_Position_HistoryID = reader.GetGuid(0);
//1:Parameter ProcurementOrder_Position_RefID of type Guid
item.ProcurementOrder_Position_RefID = reader.GetGuid(1);
//2:Parameter IsCreated of type Boolean
item.IsCreated = reader.GetBoolean(2);
//3:Parameter IsModified of type Boolean
item.IsModified = reader.GetBoolean(3);
//4:Parameter IsRemoved of type Boolean
item.IsRemoved = reader.GetBoolean(4);
//5:Parameter TriggeredBy_BusinessParticipant_RefID of type Guid
item.TriggeredBy_BusinessParticipant_RefID = reader.GetGuid(5);
//6:Parameter Comment of type String
item.Comment = reader.GetString(6);
//7:Parameter IsLivePriceRequestProcessTriggered of type Boolean
item.IsLivePriceRequestProcessTriggered = reader.GetBoolean(7);
//8:Parameter TriggeredFor_Quantity of type double
item.TriggeredFor_Quantity = reader.GetDouble(8);
//9:Parameter IsLivePriceRequestProcessAnswered of type Boolean
item.IsLivePriceRequestProcessAnswered = reader.GetBoolean(9);
//10:Parameter AnsweredWith_TotalPrice of type Decimal
item.AnsweredWith_TotalPrice = reader.GetDecimal(10);
//11:Parameter AnsweredWith_Currency_RefID of type Guid
item.AnsweredWith_Currency_RefID = reader.GetGuid(11);
//12:Parameter AnsweredWith_DeliverableQuantity of type double
item.AnsweredWith_DeliverableQuantity = reader.GetDouble(12);
//13:Parameter AnsweredWith_EarliestDeliveryDate of type DateTime
item.AnsweredWith_EarliestDeliveryDate = reader.GetDate(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);
}
private static List <ORM_HEC_Patient_UniversalProperty> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_HEC_Patient_UniversalProperty> 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_UniversalProperty>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "HEC_Patient_UniversalPropertyID", "GlobalPropertyMatchingID", "PropertyName", "IsValue_String", "IfValue_String_DefaultValue", "IsValue_Number", "IfValue_Number_DefaultValue", "IsValue_Boolean", "IfValue_Boolean_DefaultValue", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" });
while (reader.Read())
{
ORM_HEC_Patient_UniversalProperty item = new ORM_HEC_Patient_UniversalProperty();
//0:Parameter HEC_Patient_UniversalPropertyID of type Guid
item.HEC_Patient_UniversalPropertyID = reader.GetGuid(0);
//1:Parameter GlobalPropertyMatchingID of type String
item.GlobalPropertyMatchingID = reader.GetString(1);
//2:Parameter PropertyName of type String
item.PropertyName = reader.GetString(2);
//3:Parameter IsValue_String of type Boolean
item.IsValue_String = reader.GetBoolean(3);
//4:Parameter IfValue_String_DefaultValue of type String
item.IfValue_String_DefaultValue = reader.GetString(4);
//5:Parameter IsValue_Number of type Boolean
item.IsValue_Number = reader.GetBoolean(5);
//6:Parameter IfValue_Number_DefaultValue of type double
item.IfValue_Number_DefaultValue = reader.GetDouble(6);
//7:Parameter IsValue_Boolean of type Boolean
item.IsValue_Boolean = reader.GetBoolean(7);
//8:Parameter IfValue_Boolean_DefaultValue of type Boolean
item.IfValue_Boolean_DefaultValue = 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 static List <ORM_HEC_DIA_STA_Diagnosis_ObservationUsageStatistic> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_HEC_DIA_STA_Diagnosis_ObservationUsageStatistic> 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_STA_Diagnosis_ObservationUsageStatistic>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "HEC_DIA_STA_Diagnosis_ObservationUsageStatisticsID", "PotentialObservation_RefID", "PotentialDiagnosis_RefID", "NumberOfOccurences", "IsStatistics_ForDoctor", "IfStatistics_ForDoctor_Doctor_RefID", "IsStatistics_ForHCG", "IfStatistics_ForHCG_HealthcareCommunityGroup_RefID", "StatisticsPeriod_From", "StatisticsPeriod_Through", "IsLatestStatisticsData", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" });
while (reader.Read())
{
ORM_HEC_DIA_STA_Diagnosis_ObservationUsageStatistic item = new ORM_HEC_DIA_STA_Diagnosis_ObservationUsageStatistic();
//0:Parameter HEC_DIA_STA_Diagnosis_ObservationUsageStatisticsID of type Guid
item.HEC_DIA_STA_Diagnosis_ObservationUsageStatisticsID = reader.GetGuid(0);
//1:Parameter PotentialObservation_RefID of type Guid
item.PotentialObservation_RefID = reader.GetGuid(1);
//2:Parameter PotentialDiagnosis_RefID of type Guid
item.PotentialDiagnosis_RefID = reader.GetGuid(2);
//3:Parameter NumberOfOccurences of type int
item.NumberOfOccurences = reader.GetInteger(3);
//4:Parameter IsStatistics_ForDoctor of type Boolean
item.IsStatistics_ForDoctor = reader.GetBoolean(4);
//5:Parameter IfStatistics_ForDoctor_Doctor_RefID of type Guid
item.IfStatistics_ForDoctor_Doctor_RefID = reader.GetGuid(5);
//6:Parameter IsStatistics_ForHCG of type Boolean
item.IsStatistics_ForHCG = reader.GetBoolean(6);
//7:Parameter IfStatistics_ForHCG_HealthcareCommunityGroup_RefID of type Guid
item.IfStatistics_ForHCG_HealthcareCommunityGroup_RefID = reader.GetGuid(7);
//8:Parameter StatisticsPeriod_From of type DateTime
item.StatisticsPeriod_From = reader.GetDate(8);
//9:Parameter StatisticsPeriod_Through of type DateTime
item.StatisticsPeriod_Through = reader.GetDate(9);
//10:Parameter IsLatestStatisticsData of type Boolean
item.IsLatestStatisticsData = reader.GetBoolean(10);
//11:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(11);
//12:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(12);
//13:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(13);
//14:Parameter Modification_Timestamp of type DateTime
item.Modification_Timestamp = reader.GetDate(14);
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_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);
}
private static List <ORM_RES_RealestateProperty> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_RES_RealestateProperty> 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_RealestateProperty>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "RES_RealestatePropertyID", "RealestateProperty_Title", "RealestateProperty_InternalID", "InformationSubmittedBy_Account_RefID", "RealestateProperty_Address_RefID", "RealestateProperty_Location_RefID", "RealestateProperty_GroundValuePrice_RefID", "RealestateProperty_AverageAreaRentPrice_RefID", "RealestateProperty_ConstructionDate", "RealestateProperty_RefurbishmentDate", "RealestateProperty_InformationDate", "RealestateProperty_LivingSpace_in_sqm", "RealestateProperty_NumberOfResidentialUnits", "RealestateProperty_GroundAreaSize_in_sqm", "Geolocation_Lattitude", "Geolocation_Longitude", "Creation_Timestamp", "IsLocked", "IsArchived", "IsDeleted", "Tenant_RefID" });
while (reader.Read())
{
ORM_RES_RealestateProperty item = new ORM_RES_RealestateProperty();
//0:Parameter RES_RealestatePropertyID of type Guid
item.RES_RealestatePropertyID = reader.GetGuid(0);
//1:Parameter RealestateProperty_Title of type String
item.RealestateProperty_Title = reader.GetString(1);
//2:Parameter RealestateProperty_InternalID of type String
item.RealestateProperty_InternalID = reader.GetString(2);
//3:Parameter InformationSubmittedBy_Account_RefID of type Guid
item.InformationSubmittedBy_Account_RefID = reader.GetGuid(3);
//4:Parameter RealestateProperty_Address_RefID of type Guid
item.RealestateProperty_Address_RefID = reader.GetGuid(4);
//5:Parameter RealestateProperty_Location_RefID of type Guid
item.RealestateProperty_Location_RefID = reader.GetGuid(5);
//6:Parameter RealestateProperty_GroundValuePrice_RefID of type Guid
item.RealestateProperty_GroundValuePrice_RefID = reader.GetGuid(6);
//7:Parameter RealestateProperty_AverageAreaRentPrice_RefID of type Guid
item.RealestateProperty_AverageAreaRentPrice_RefID = reader.GetGuid(7);
//8:Parameter RealestateProperty_ConstructionDate of type DateTime
item.RealestateProperty_ConstructionDate = reader.GetDate(8);
//9:Parameter RealestateProperty_RefurbishmentDate of type DateTime
item.RealestateProperty_RefurbishmentDate = reader.GetDate(9);
//10:Parameter RealestateProperty_InformationDate of type DateTime
item.RealestateProperty_InformationDate = reader.GetDate(10);
//11:Parameter RealestateProperty_LivingSpace_in_sqm of type double
item.RealestateProperty_LivingSpace_in_sqm = reader.GetDouble(11);
//12:Parameter RealestateProperty_NumberOfResidentialUnits of type int
item.RealestateProperty_NumberOfResidentialUnits = reader.GetInteger(12);
//13:Parameter RealestateProperty_GroundAreaSize_in_sqm of type double
item.RealestateProperty_GroundAreaSize_in_sqm = reader.GetDouble(13);
//14:Parameter Geolocation_Lattitude of type double
item.Geolocation_Lattitude = reader.GetDouble(14);
//15:Parameter Geolocation_Longitude of type double
item.Geolocation_Longitude = reader.GetDouble(15);
//16:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(16);
//17:Parameter IsLocked of type bool
item.IsLocked = reader.GetBoolean(17);
//18:Parameter IsArchived of type bool
item.IsArchived = reader.GetBoolean(18);
//19:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(19);
//20:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(20);
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> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_HEC_Patient> 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>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "HEC_PatientID", "CMN_BPT_BusinessParticipant_RefID", "HasSignedParticipationPolicyDocument", "PatientComment", "IsPatientParticipationPolicyValidated", "PatientParticipationPolicyValidatedBy_Account_RefID", "EmployerCompanyName", "PatientProfession", "IsTenant", "Current_EMRFile_ExternalURL", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" });
while (reader.Read())
{
ORM_HEC_Patient item = new ORM_HEC_Patient();
//0:Parameter HEC_PatientID of type Guid
item.HEC_PatientID = reader.GetGuid(0);
//1:Parameter CMN_BPT_BusinessParticipant_RefID of type Guid
item.CMN_BPT_BusinessParticipant_RefID = reader.GetGuid(1);
//2:Parameter HasSignedParticipationPolicyDocument of type Boolean
item.HasSignedParticipationPolicyDocument = reader.GetBoolean(2);
//3:Parameter PatientComment of type String
item.PatientComment = reader.GetString(3);
//4:Parameter IsPatientParticipationPolicyValidated of type Boolean
item.IsPatientParticipationPolicyValidated = reader.GetBoolean(4);
//5:Parameter PatientParticipationPolicyValidatedBy_Account_RefID of type Guid
item.PatientParticipationPolicyValidatedBy_Account_RefID = reader.GetGuid(5);
//6:Parameter EmployerCompanyName of type String
item.EmployerCompanyName = reader.GetString(6);
//7:Parameter PatientProfession of type String
item.PatientProfession = reader.GetString(7);
//8:Parameter IsTenant of type Boolean
item.IsTenant = reader.GetBoolean(8);
//9:Parameter Current_EMRFile_ExternalURL of type String
item.Current_EMRFile_ExternalURL = reader.GetString(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_CTM_CatalogProductExtensionRequests> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_CMN_BPT_CTM_CatalogProductExtensionRequests> 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_CatalogProductExtensionRequests>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "CMN_BPT_CTM_CatalogProductExtensionRequestID", "CatalogProductExtensionRequestITL", "RequestedBy_Customer_BusinessParticipant_RefID", "RequestedBy_Person_BusinessParticipant_RefID", "RequestedFor_Catalog_RefID", "Request_Question", "Request_Answer", "RequestCaseIdentifier", "IsAnswerSent", "IfAnswerSent_By_BusinessParticipant_RefID", "IfAnswerSent_Date", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" });
while (reader.Read())
{
ORM_CMN_BPT_CTM_CatalogProductExtensionRequests item = new ORM_CMN_BPT_CTM_CatalogProductExtensionRequests();
//0:Parameter CMN_BPT_CTM_CatalogProductExtensionRequestID of type Guid
item.CMN_BPT_CTM_CatalogProductExtensionRequestID = reader.GetGuid(0);
//1:Parameter CatalogProductExtensionRequestITL of type String
item.CatalogProductExtensionRequestITL = reader.GetString(1);
//2:Parameter RequestedBy_Customer_BusinessParticipant_RefID of type Guid
item.RequestedBy_Customer_BusinessParticipant_RefID = reader.GetGuid(2);
//3:Parameter RequestedBy_Person_BusinessParticipant_RefID of type Guid
item.RequestedBy_Person_BusinessParticipant_RefID = reader.GetGuid(3);
//4:Parameter RequestedFor_Catalog_RefID of type Guid
item.RequestedFor_Catalog_RefID = reader.GetGuid(4);
//5:Parameter Request_Question of type String
item.Request_Question = reader.GetString(5);
//6:Parameter Request_Answer of type String
item.Request_Answer = reader.GetString(6);
//7:Parameter RequestCaseIdentifier of type String
item.RequestCaseIdentifier = reader.GetString(7);
//8:Parameter IsAnswerSent of type Boolean
item.IsAnswerSent = reader.GetBoolean(8);
//9:Parameter IfAnswerSent_By_BusinessParticipant_RefID of type Guid
item.IfAnswerSent_By_BusinessParticipant_RefID = reader.GetGuid(9);
//10:Parameter IfAnswerSent_Date of type DateTime
item.IfAnswerSent_Date = reader.GetDate(10);
//11:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(11);
//12:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(12);
//13:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(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_USR_Device> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_USR_Device> 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>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "USR_DeviceID", "DeviceName", "MACAddress", "IMEI", "SerialNumber", "SecurityVerificationToken", "DeviceSecurityCode", "ExclusivelyUsableWith_Account_RefID", "IsBanned", "DeviceVendor", "DeviceOperatingSystem", "DeviceOperatingSystem_Version", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" });
while (reader.Read())
{
ORM_USR_Device item = new ORM_USR_Device();
//0:Parameter USR_DeviceID of type Guid
item.USR_DeviceID = reader.GetGuid(0);
//1:Parameter DeviceName of type String
item.DeviceName = reader.GetString(1);
//2:Parameter MACAddress of type String
item.MACAddress = reader.GetString(2);
//3:Parameter IMEI of type String
item.IMEI = reader.GetString(3);
//4:Parameter SerialNumber of type String
item.SerialNumber = reader.GetString(4);
//5:Parameter SecurityVerificationToken of type String
item.SecurityVerificationToken = reader.GetString(5);
//6:Parameter DeviceSecurityCode of type String
item.DeviceSecurityCode = reader.GetString(6);
//7:Parameter ExclusivelyUsableWith_Account_RefID of type Guid
item.ExclusivelyUsableWith_Account_RefID = reader.GetGuid(7);
//8:Parameter IsBanned of type Boolean
item.IsBanned = reader.GetBoolean(8);
//9:Parameter DeviceVendor of type String
item.DeviceVendor = reader.GetString(9);
//10:Parameter DeviceOperatingSystem of type String
item.DeviceOperatingSystem = reader.GetString(10);
//11:Parameter DeviceOperatingSystem_Version of type String
item.DeviceOperatingSystem_Version = reader.GetString(11);
//12:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(12);
//13:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(13);
//14:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(14);
//15:Parameter Modification_Timestamp of type DateTime
item.Modification_Timestamp = reader.GetDate(15);
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_ACT_PerformedAction_DiagnosisUpdate> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_HEC_ACT_PerformedAction_DiagnosisUpdate> 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_DiagnosisUpdate>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "HEC_ACT_PerformedAction_DiagnosisUpdateID", "HealthcarePerformedAction_DiagnosisITL", "HEC_ACT_PerformedAction_RefID", "HEC_Patient_Diagnosis_RefID", "PotentialDiagnosis_RefID", "DiagnosisState_RefID", "IsDiagnosisAssumed", "IsDiagnosisConfirmed", "IsDiagnosisNegated", "IsDiagnosisCreated", "IsDiagnosisModified", "IsDiagnosisDeactivated", "ScheduledExpiryDate", "Deactivated_OnDate", "DeactivatedBy_Doctor_RefID", "DiagnosisUpdateComment", "IM_PotentialDiagnosis_Name", "IM_PotentialDiagnosis_Code", "IM_PotentialDiagnosisCatalog_Name", "IM_PotentialDiagnosisState_Name", "IM_DeactivatingDoctor_FullName", "Creation_Timestamp", "Tenant_RefID", "IsDeleted", "Modification_Timestamp" });
while (reader.Read())
{
ORM_HEC_ACT_PerformedAction_DiagnosisUpdate item = new ORM_HEC_ACT_PerformedAction_DiagnosisUpdate();
//0:Parameter HEC_ACT_PerformedAction_DiagnosisUpdateID of type Guid
item.HEC_ACT_PerformedAction_DiagnosisUpdateID = reader.GetGuid(0);
//1:Parameter HealthcarePerformedAction_DiagnosisITL of type String
item.HealthcarePerformedAction_DiagnosisITL = reader.GetString(1);
//2:Parameter HEC_ACT_PerformedAction_RefID of type Guid
item.HEC_ACT_PerformedAction_RefID = reader.GetGuid(2);
//3:Parameter HEC_Patient_Diagnosis_RefID of type Guid
item.HEC_Patient_Diagnosis_RefID = reader.GetGuid(3);
//4:Parameter PotentialDiagnosis_RefID of type Guid
item.PotentialDiagnosis_RefID = reader.GetGuid(4);
//5:Parameter DiagnosisState_RefID of type Guid
item.DiagnosisState_RefID = reader.GetGuid(5);
//6:Parameter IsDiagnosisAssumed of type Boolean
item.IsDiagnosisAssumed = reader.GetBoolean(6);
//7:Parameter IsDiagnosisConfirmed of type Boolean
item.IsDiagnosisConfirmed = reader.GetBoolean(7);
//8:Parameter IsDiagnosisNegated of type Boolean
item.IsDiagnosisNegated = reader.GetBoolean(8);
//9:Parameter IsDiagnosisCreated of type Boolean
item.IsDiagnosisCreated = reader.GetBoolean(9);
//10:Parameter IsDiagnosisModified of type Boolean
item.IsDiagnosisModified = reader.GetBoolean(10);
//11:Parameter IsDiagnosisDeactivated of type Boolean
item.IsDiagnosisDeactivated = reader.GetBoolean(11);
//12:Parameter ScheduledExpiryDate of type DateTime
item.ScheduledExpiryDate = reader.GetDate(12);
//13:Parameter Deactivated_OnDate of type DateTime
item.Deactivated_OnDate = reader.GetDate(13);
//14:Parameter DeactivatedBy_Doctor_RefID of type Guid
item.DeactivatedBy_Doctor_RefID = reader.GetGuid(14);
//15:Parameter DiagnosisUpdateComment of type String
item.DiagnosisUpdateComment = reader.GetString(15);
//16:Parameter IM_PotentialDiagnosis_Name of type String
item.IM_PotentialDiagnosis_Name = reader.GetString(16);
//17:Parameter IM_PotentialDiagnosis_Code of type String
item.IM_PotentialDiagnosis_Code = reader.GetString(17);
//18:Parameter IM_PotentialDiagnosisCatalog_Name of type String
item.IM_PotentialDiagnosisCatalog_Name = reader.GetString(18);
//19:Parameter IM_PotentialDiagnosisState_Name of type String
item.IM_PotentialDiagnosisState_Name = reader.GetString(19);
//20:Parameter IM_DeactivatingDoctor_FullName of type String
item.IM_DeactivatingDoctor_FullName = reader.GetString(20);
//21:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(21);
//22:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(22);
//23:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(23);
//24:Parameter Modification_Timestamp of type DateTime
item.Modification_Timestamp = reader.GetDate(24);
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_SHP_Shipment_Note> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_LOG_SHP_Shipment_Note> 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_Note>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "LOG_SHP_Shipment_NoteID", "Shipment_Header_RefID", "Shipment_Position_RefID", "IsNotePrintedOnDeliveryPaper", "Title", "Comment", "NotePublishDate", "SequenceOrderNumber", "CreatedBy_BusinessParticipant_RefID", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" });
while (reader.Read())
{
ORM_LOG_SHP_Shipment_Note item = new ORM_LOG_SHP_Shipment_Note();
//0:Parameter LOG_SHP_Shipment_NoteID of type Guid
item.LOG_SHP_Shipment_NoteID = reader.GetGuid(0);
//1:Parameter Shipment_Header_RefID of type Guid
item.Shipment_Header_RefID = reader.GetGuid(1);
//2:Parameter Shipment_Position_RefID of type Guid
item.Shipment_Position_RefID = reader.GetGuid(2);
//3:Parameter IsNotePrintedOnDeliveryPaper of type Boolean
item.IsNotePrintedOnDeliveryPaper = reader.GetBoolean(3);
//4:Parameter Title of type String
item.Title = reader.GetString(4);
//5:Parameter Comment of type String
item.Comment = reader.GetString(5);
//6:Parameter NotePublishDate of type DateTime
item.NotePublishDate = reader.GetDate(6);
//7:Parameter SequenceOrderNumber of type int
item.SequenceOrderNumber = reader.GetInteger(7);
//8:Parameter CreatedBy_BusinessParticipant_RefID of type Guid
item.CreatedBy_BusinessParticipant_RefID = reader.GetGuid(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);
}