private static List <ORM_LOG_WRH_INJ_InventoryJob_Series> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_LOG_WRH_INJ_InventoryJob_Series> items;
try
{
managedConnection.set(connectionString, connection, transaction);
var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(managedConnection.getConnection(), managedConnection.getTransaction());
DbCommand command = managedConnection.manage(query.CreateSelectQuery(TableName));
query.SetParameters(command);
items = new List <ORM_LOG_WRH_INJ_InventoryJob_Series>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "LOG_WRH_INJ_InventoryJob_SeriesID", "InventoryJobSeries_DisplayName", "IsUsingNumberOfProductsSeriesType", "NumberOfProductsToSelect", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" });
while (reader.Read())
{
ORM_LOG_WRH_INJ_InventoryJob_Series item = new ORM_LOG_WRH_INJ_InventoryJob_Series();
//0:Parameter LOG_WRH_INJ_InventoryJob_SeriesID of type Guid
item.LOG_WRH_INJ_InventoryJob_SeriesID = reader.GetGuid(0);
//1:Parameter InventoryJobSeries_DisplayName of type String
item.InventoryJobSeries_DisplayName = reader.GetString(1);
//2:Parameter IsUsingNumberOfProductsSeriesType of type Boolean
item.IsUsingNumberOfProductsSeriesType = reader.GetBoolean(2);
//3:Parameter NumberOfProductsToSelect of type int
item.NumberOfProductsToSelect = reader.GetInteger(3);
//4:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(4);
//5:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(5);
//6:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(6);
item.Status_IsAlreadySaved = true;
item.Status_IsDirty = false;
items.Add(item);
}
reader.Close();
loader.Load();
managedConnection.commit();
}
catch (Exception ex)
{
managedConnection.rollback();
throw;
}
return(items);
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5IN_DIJS_1052 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
//load InvetoryJob
var inventoryJob = new CL1_LOG_WRH_INJ.ORM_LOG_WRH_INJ_InventoryJob_Series();
inventoryJob.Load(Connection, Transaction, Parameter.InventoryJobSeriesID);
//delete invetory Participating Shelves
var invetoryParticipatingShelves = CL1_LOG_WRH_INJ.ORM_LOG_WRH_INJ_InventoryJob_Series_ParticipatingShelf.Query.SoftDelete(
Connection,
Transaction,
new CL1_LOG_WRH_INJ.ORM_LOG_WRH_INJ_InventoryJob_Series_ParticipatingShelf.Query
{
LOG_WRH_INJ_InventoryJob_Series_RefID = inventoryJob.LOG_WRH_INJ_InventoryJob_SeriesID,
Tenant_RefID = securityTicket.TenantID
});
//delete inventoryJobSeriesRythms
var inventoryJobSeriesRythms = CL1_LOG_WRH_INJ.ORM_LOG_WRH_INJ_InventoryJob_Series_Rythm.Query.SoftDelete(
Connection,
Transaction,
new ORM_LOG_WRH_INJ_InventoryJob_Series_Rythm.Query
{
InventoryJob_Series_RefID = inventoryJob.LOG_WRH_INJ_InventoryJob_SeriesID,
Tenant_RefID = securityTicket.TenantID
});
//delete invetory job
inventoryJob.IsDeleted = true;
inventoryJob.Save(Connection, Transaction);
return(returnValue);
#endregion UserCode
}
