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 }