protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2IJ_SIJ_1136 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
ORM_LOG_WRH_INJ_InventoryJob job = new ORM_LOG_WRH_INJ_InventoryJob();
if (Parameter.InventoryJobID == Guid.Empty)
{
job.LOG_WRH_INJ_InventoryJobID = Guid.NewGuid(); // new
job.InventoryJob_DisplayName = Parameter.InventoryJobName;
job.Creation_Timestamp = DateTime.Now;
job.Warehouse_RefID = Parameter.WarehouseID;
job.Tenant_RefID = securityTicket.TenantID;
}
else
{
job.Load(Connection, Transaction, Parameter.InventoryJobID); // edit
job.InventoryJob_DisplayName = Parameter.InventoryJobName;
job.Warehouse_RefID = Parameter.WarehouseID;
job.Tenant_RefID = securityTicket.TenantID;
}
job.Save(Connection, Transaction);
returnValue.Result = job.LOG_WRH_INJ_InventoryJobID;
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2IJ_DIJ_1626 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
ORM_LOG_WRH_INJ_InventoryJob job = new ORM_LOG_WRH_INJ_InventoryJob();
job.Load(Connection, Transaction, Parameter.InventoryJobID);
job.IsDeleted = true;
job.Save(Connection, Transaction);
returnValue.Result = job.LOG_WRH_INJ_InventoryJobID;
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5IN_DIJaIP_1153 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
ORM_LOG_WRH_INJ_InventoryJob job = new ORM_LOG_WRH_INJ_InventoryJob();
job.Load(Connection, Transaction, Parameter.InventoryJobID);
var allProcesses = CL1_LOG_WRH_INJ.ORM_LOG_WRH_INJ_InventoryJob_Process.Query.Search(Connection, Transaction,
new CL1_LOG_WRH_INJ.ORM_LOG_WRH_INJ_InventoryJob_Process.Query
{
LOG_WRH_INJ_InventoryJob_RefID = job.LOG_WRH_INJ_InventoryJobID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).ToList();
foreach (var process in allProcesses)
{
var processShelfs = ORM_LOG_WRH_INJ_InventoryJob_Process_Shelf.Query.SoftDelete(Connection, Transaction,
new ORM_LOG_WRH_INJ_InventoryJob_Process_Shelf.Query
{
LOG_WRH_INJ_InventoryJob_Process_RefID = process.LOG_WRH_INJ_InventoryJob_ProcessID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
});
process.IsDeleted = true;
process.Save(Connection, Transaction);
}
job.IsDeleted = true;
job.Save(Connection, Transaction);
returnValue.Result = job.LOG_WRH_INJ_InventoryJobID;
return(returnValue);
#endregion UserCode
}
