protected static FR_L5SO_DSH_1440 Execute(DbConnection Connection, DbTransaction Transaction, P_L5SO_DSH_1440 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_L5SO_DSH_1440(); //Put your code here ORM_LOG_SHP_Shipment_Header shipmentHeaderToDelate = new ORM_LOG_SHP_Shipment_Header(); shipmentHeaderToDelate.Load(Connection, Transaction, Parameter.ShipmentHeaderID); shipmentHeaderToDelate.Remove(Connection, Transaction); returnValue.Result = new L5SO_DSH_1440(); returnValue.Result.DeletedHeader = Parameter.ShipmentHeaderID; return(returnValue); #endregion UserCode }
protected static FR_L5CO_ACOaCS_2108_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5CO_ACOaCS_2108[] Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L5CO_ACOaCS_2108_Array(); List <L5CO_ACOaCS_2108> confirmedProcurementOrders = new List <L5CO_ACOaCS_2108>(); foreach (var param in Parameter) { L5CO_ACOaCS_2108 procurementOrderITL = new L5CO_ACOaCS_2108(); var confirmedStatus = ORM_ORD_CUO_CustomerOrder_Status.Query.Search(Connection, Transaction, new ORM_ORD_CUO_CustomerOrder_Status.Query { GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(ECustomerOrderStatus.Confirmed), Tenant_RefID = securityTicket.TenantID, IsDeleted = false }).Single().ORD_CUO_CustomerOrder_StatusID; var customerOrder = new ORM_ORD_CUO_CustomerOrder_Header(); customerOrder.Load(Connection, Transaction, param.CustomerOrderHeaderID); customerOrder.Current_CustomerOrderStatus_RefID = confirmedStatus; customerOrder.IsCustomerOrderFinalized = true; customerOrder.Save(Connection, Transaction); ORM_USR_Account account = new ORM_USR_Account(); account.Load(Connection, Transaction, securityTicket.AccountID); ORM_ORD_CUO_CustomerOrder_StatusHistory newStatusInHistory = new ORM_ORD_CUO_CustomerOrder_StatusHistory(); newStatusInHistory.CustomerOrder_Header_RefID = customerOrder.ORD_CUO_CustomerOrder_HeaderID; newStatusInHistory.StatusHistoryComment = param.Message; newStatusInHistory.Tenant_RefID = securityTicket.TenantID; newStatusInHistory.CustomerOrder_Status_RefID = confirmedStatus; newStatusInHistory.PerformedBy_BusinessParticipant_RefID = account.BusinessParticipant_RefID; newStatusInHistory.Save(Connection, Transaction); procurementOrderITL.ProcurementOrderITL = customerOrder.ProcurementOrderITL; procurementOrderITL.ProcuringTenatID = customerOrder.OrderingCustomer_BusinessParticipant_RefID.ToString(); ORM_CMN_NumberRange_UsageArea numberRangeUsageArea = ORM_CMN_NumberRange_UsageArea.Query.Search(Connection, Transaction, new ORM_CMN_NumberRange_UsageArea.Query() { IsDeleted = false, Tenant_RefID = securityTicket.TenantID, GlobalStaticMatchingID = NumberRangeGlobalPropertyMatchingID }).FirstOrDefault(); if (numberRangeUsageArea == null) { throw new Exception(String.Format("Number range usage area with GPMID = {0} was not found.", NumberRangeGlobalPropertyMatchingID)); } ORM_CMN_NumberRange numberRange = ORM_CMN_NumberRange.Query.Search(Connection, Transaction, new ORM_CMN_NumberRange.Query() { IsDeleted = false, Tenant_RefID = securityTicket.TenantID, NumberRange_UsageArea_RefID = numberRangeUsageArea.CMN_NumberRange_UsageAreaID }).FirstOrDefault(); if (numberRange == null) { throw new Exception(String.Format("Number range for area with GPMID = {0} was not found.", NumberRangeGlobalPropertyMatchingID)); } numberRange.Value_Current++; numberRange.Save(Connection, Transaction); string shipmentNumber = numberRange.FixedPrefix + numberRange.Value_Current.ToString().PadLeft(numberRange.Formatting_NumberLength, numberRange.Formatting_LeadingFillCharacter[0]); ORM_LOG_SHP_Shipment_Header shipmentHeader = new ORM_LOG_SHP_Shipment_Header(); shipmentHeader.LOG_SHP_Shipment_HeaderID = Guid.NewGuid(); shipmentHeader.RecipientBusinessParticipant_RefID = customerOrder.OrderingCustomer_BusinessParticipant_RefID; shipmentHeader.ShipmentHeaderITL = shipmentHeader.LOG_SHP_Shipment_HeaderID.ToString(); shipmentHeader.ShipmentHeader_Number = shipmentNumber; shipmentHeader.Shippipng_AddressUCD_RefID = customerOrder.ShippingAddressUCD_RefID; shipmentHeader.ShipmentPriority = 0; shipmentHeader.ShipmentHeader_ValueWithoutTax = customerOrder.TotalValue_BeforeTax; shipmentHeader.ShipmentHeader_Currency_RefID = customerOrder.CustomerOrder_Currency_RefID; shipmentHeader.Tenant_RefID = securityTicket.TenantID; shipmentHeader.IsDeleted = false; shipmentHeader.Save(Connection, Transaction); var customerOrderPositions = ORM_ORD_CUO_CustomerOrder_Position.Query.Search(Connection, Transaction, new ORM_ORD_CUO_CustomerOrder_Position.Query() { CustomerOrder_Header_RefID = customerOrder.ORD_CUO_CustomerOrder_HeaderID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }); if (customerOrderPositions != null) { foreach (var customerOrderPosition in customerOrderPositions) { ORM_LOG_SHP_Shipment_Position shipmentPosition = new ORM_LOG_SHP_Shipment_Position(); shipmentPosition.LOG_SHP_Shipment_PositionID = Guid.NewGuid(); shipmentPosition.ShipmentPositionITL = shipmentPosition.LOG_SHP_Shipment_PositionID.ToString(); shipmentPosition.LOG_SHP_Shipment_Header_RefID = shipmentHeader.LOG_SHP_Shipment_HeaderID; shipmentPosition.CMN_PRO_Product_RefID = customerOrderPosition.CMN_PRO_Product_RefID; shipmentPosition.CMN_PRO_ProductVariant_RefID = customerOrderPosition.CMN_PRO_Product_Variant_RefID; shipmentPosition.CMN_PRO_ProductRelease_RefID = customerOrderPosition.CMN_PRO_Product_Release_RefID; shipmentPosition.QuantityToShip = customerOrderPosition.Position_Quantity; shipmentPosition.ShipmentPosition_PricePerUnitValueWithoutTax = customerOrderPosition.Position_ValuePerUnit; shipmentPosition.ShipmentPosition_ValueWithoutTax = customerOrderPosition.Position_ValueTotal; shipmentPosition.IsCancelled = false; shipmentPosition.Tenant_RefID = securityTicket.TenantID; shipmentPosition.IsDeleted = false; shipmentPosition.Save(Connection, Transaction); ORM_ORD_CUO_CustomerOrder_Position_2_ShipmentPosition customerOrderPositionToShipmentPosition = new ORM_ORD_CUO_CustomerOrder_Position_2_ShipmentPosition(); customerOrderPositionToShipmentPosition.AssignmentID = Guid.NewGuid(); customerOrderPositionToShipmentPosition.LOG_SHP_Shipment_Position_RefID = shipmentPosition.LOG_SHP_Shipment_PositionID; customerOrderPositionToShipmentPosition.ORD_CUO_CustomerOrder_Position_RefID = customerOrderPosition.ORD_CUO_CustomerOrder_PositionID; customerOrderPositionToShipmentPosition.Tenant_RefID = securityTicket.TenantID; customerOrderPositionToShipmentPosition.IsDeleted = false; customerOrderPositionToShipmentPosition.Save(Connection, Transaction); } } //TO DO: UNCOMMENT AFTER JANKO ADD STATUSES //var shipmentStatusHistoryStatusID = ORM_LOG_SHP_Shipment_Status.Query.Search(Connection, Transaction, new ORM_LOG_SHP_Shipment_Status.Query() //{ // GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EShipmentStatus.Created), // Tenant_RefID = securityTicket.TenantID, // IsDeleted = false //}).Single().LOG_SHP_Shipment_StatusID; //ORM_LOG_SHP_Shipment_StatusHistory shipmentStatusHistory = new ORM_LOG_SHP_Shipment_StatusHistory(); //shipmentStatusHistory.LOG_SHP_Shipment_StatusHistoryID = Guid.NewGuid(); //shipmentStatusHistory.LOG_SHP_Shipment_Header_RefID = shipmentHeader.LOG_SHP_Shipment_HeaderID; //shipmentStatusHistory.LOG_SHP_Shipment_Status_RefID = shipmentStatusHistoryStatusID; //shipmentStatusHistory.PerformedBy_BusinessParticipant_RefID = securityTicket.TenantID; //shipmentStatusHistory.Tenant_RefID = securityTicket.TenantID; //shipmentStatusHistory.IsDeleted = false; //shipmentStatusHistory.Save(Connection, Transaction); ORM_LOG_SHP_ShipmentHeader_2_CustomerOrderHeader shipmentToCustomerOrderHeader = new ORM_LOG_SHP_ShipmentHeader_2_CustomerOrderHeader(); shipmentToCustomerOrderHeader.AssignmentID = Guid.NewGuid(); shipmentToCustomerOrderHeader.LOG_SHP_Shipment_Header_RefID = shipmentHeader.LOG_SHP_Shipment_HeaderID; shipmentToCustomerOrderHeader.ORD_CUO_CustomerOrder_Header_RefID = customerOrder.ORD_CUO_CustomerOrder_HeaderID; shipmentToCustomerOrderHeader.Tenant_RefID = securityTicket.TenantID; shipmentToCustomerOrderHeader.IsDeleted = false; shipmentToCustomerOrderHeader.Save(Connection, Transaction); confirmedProcurementOrders.Add(procurementOrderITL); } returnValue.Result = confirmedProcurementOrders.ToArray(); return(returnValue); #endregion UserCode }
protected static FR_L5RS_CSaRSPfH_0449 Execute(DbConnection Connection, DbTransaction Transaction, P_L5RS_CSaRSPfH_0449 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L5RS_CSaRSPfH_0449(); returnValue.Result = new L5RS_CSaRSPfH_0449(); FR_Base resultHeader, resultPosition, resultReturnPosition; if (Parameter.Positions.Count() <= 0) { returnValue.Status = FR_Status.Success; returnValue.Result = null; return(returnValue); } #region Load Shipment Header and calculate Total Price decimal totalValueWithoutTax = 0; #region Load Shipment Header var shipmentHeader = new ORM_LOG_SHP_Shipment_Header(); var result = shipmentHeader.Load(Connection, Transaction, Parameter.Positions[0].ShipmentHeaderID); if (result.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; returnValue.Result = null; return(returnValue); } #endregion #region Load Shipment Header Positions And Calculate Total Value var shipmentPositions = ORM_LOG_SHP_Shipment_Position.Query.Search( Connection, Transaction, new ORM_LOG_SHP_Shipment_Position.Query() { LOG_SHP_Shipment_Header_RefID = shipmentHeader.LOG_SHP_Shipment_HeaderID, Tenant_RefID = securityTicket.TenantID }).ToList(); foreach (var position in shipmentPositions) { totalValueWithoutTax += position.ShipmentPosition_ValueWithoutTax; } #endregion shipmentHeader.ShipmentHeader_ValueWithoutTax = totalValueWithoutTax; #endregion var resultShipmentPositionsIDs = new List <Guid>(); var resultReturnShipmentPositionIDs = new List <Guid>(); foreach (P_L5RS_CSaRSPfH_0449a position in Parameter.Positions) { #region Create Shipment Position Object var newShipmentPositionObject = new ORM_LOG_SHP_Shipment_Position(); newShipmentPositionObject.CMN_PRO_Product_RefID = position.ProductId; newShipmentPositionObject.Creation_Timestamp = DateTime.Now; newShipmentPositionObject.LOG_SHP_Shipment_Header_RefID = position.ShipmentHeaderID; newShipmentPositionObject.LOG_SHP_Shipment_PositionID = Guid.NewGuid(); newShipmentPositionObject.QuantityToShip = position.Quantity; newShipmentPositionObject.ShipmentPosition_ValueWithoutTax = position.PricePerUnit * position.Quantity; newShipmentPositionObject.ShipmentPosition_PricePerUnitValueWithoutTax = position.PricePerUnit; newShipmentPositionObject.Tenant_RefID = securityTicket.TenantID; shipmentHeader.ShipmentHeader_ValueWithoutTax += newShipmentPositionObject.ShipmentPosition_ValueWithoutTax; #endregion #region Create ReturnShipment Position Object var newReturnShipmentPositionObject = new ORM_LOG_SHP_ReturnShipment_Position(); newReturnShipmentPositionObject.Creation_Timestamp = DateTime.Now; newReturnShipmentPositionObject.Ext_Shipment_Position_RefID = newShipmentPositionObject.LOG_SHP_Shipment_PositionID; newReturnShipmentPositionObject.LOG_SHP_ReturnShipment_PositionID = Guid.NewGuid(); newReturnShipmentPositionObject.ReturnPolicy_RefID = position.ReturnPolicyId; newReturnShipmentPositionObject.ReturnProductOriginatedFromReceiptPosition_RefID = position.ReceiptPositionId; newReturnShipmentPositionObject.ReturnShipment_Header_RefID = position.ReturnShipmentHeaderID; newReturnShipmentPositionObject.Tenant_RefID = securityTicket.TenantID; #endregion #region Save Position resultPosition = newShipmentPositionObject.Save(Connection, Transaction); resultReturnPosition = newReturnShipmentPositionObject.Save(Connection, Transaction); if (resultPosition.Status != FR_Status.Success || resultReturnPosition.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; returnValue.Result = null; return(returnValue); } resultShipmentPositionsIDs.Add(newShipmentPositionObject.LOG_SHP_Shipment_PositionID); resultReturnShipmentPositionIDs.Add(newReturnShipmentPositionObject.LOG_SHP_ReturnShipment_PositionID); #endregion } #region Update Shipment Header with Total Value resultHeader = shipmentHeader.Save(Connection, Transaction); if (resultHeader.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; returnValue.Result = null; return(returnValue); } #endregion #region Fetch ShipmentHeader SupplierName var supplierBusinessParticipant = new ORM_CMN_BPT_BusinessParticipant(); supplierBusinessParticipant.Load(Connection, Transaction, shipmentHeader.RecipientBusinessParticipant_RefID); #endregion returnValue.Status = FR_Status.Success; returnValue.Result.ShipmentPositionIDs = resultShipmentPositionsIDs.ToArray(); returnValue.Result.ReturnShipmentPositionIDs = resultReturnShipmentPositionIDs.ToArray(); returnValue.Result.ShipmentHeaderSupplierName = supplierBusinessParticipant == null ? string.Empty : supplierBusinessParticipant.DisplayName; returnValue.Result.ShipmentHeaderNumber = shipmentHeader.ShipmentHeader_Number; returnValue.Result.ShipmentHeaderTotalValue = shipmentHeader.ShipmentHeader_ValueWithoutTax; return(returnValue); #endregion UserCode }
protected static FR_L5RS_CSaRSH_0244 Execute(DbConnection Connection, DbTransaction Transaction, P_L5RS_CSaRSH_0244 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L5RS_CSaRSH_0244(); returnValue.Result = new L5RS_CSaRSH_0244(); #region New ShipmentHeader var newShipmentHeaderId = Guid.NewGuid(); #region Get Tenant Curency ID var defaultCurrency = cls_Get_DefaultCurrency_for_Tenant.Invoke(Connection, Transaction, securityTicket).Result; #endregion #region Create Shipment Status History #region Get 'Returned' Shipment status var returnedStatusId = ORM_LOG_SHP_Shipment_Status.Query.Search( Connection, Transaction, new ORM_LOG_SHP_Shipment_Status.Query() { GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EShipmentStatus.Returned), Tenant_RefID = securityTicket.TenantID }).FirstOrDefault().LOG_SHP_Shipment_StatusID; #endregion #region Fetch Status History 'performed by' User Account var performedByAccount = new ORM_USR_Account(); performedByAccount.Load(Connection, Transaction, securityTicket.AccountID); #endregion #region Get ShipmentHeader Number var shipmentHeaderNumber = cls_Get_and_Increase_IncreasingNumber_for_UsageArea.Invoke( Connection, Transaction, new P_L2NR_GaIINfUA_1454() { GlobalStaticMatchingID = EnumUtils.GetEnumDescription(ENumberRangeUsageAreaType.SupplierReturnShipmentNumber) }, securityTicket).Result.Current_IncreasingNumber; #endregion var newShipmentStatusHistory = new ORM_LOG_SHP_Shipment_StatusHistory(); newShipmentStatusHistory.Creation_Timestamp = DateTime.Now; newShipmentStatusHistory.IsDeleted = false; newShipmentStatusHistory.LOG_SHP_Shipment_Header_RefID = newShipmentHeaderId; newShipmentStatusHistory.LOG_SHP_Shipment_Status_RefID = returnedStatusId; newShipmentStatusHistory.LOG_SHP_Shipment_StatusHistoryID = Guid.NewGuid(); newShipmentStatusHistory.PerformedBy_BusinessParticipant_RefID = performedByAccount == null ? Guid.Empty : performedByAccount.BusinessParticipant_RefID; newShipmentStatusHistory.Tenant_RefID = securityTicket.TenantID; #endregion #region Create Shipment Header Object var newShipmentHeader = new ORM_LOG_SHP_Shipment_Header(); newShipmentHeader.Creation_Timestamp = DateTime.Now; newShipmentHeader.LOG_SHP_Shipment_HeaderID = newShipmentHeaderId; newShipmentHeader.RecipientBusinessParticipant_RefID = Parameter.SupplierID; newShipmentHeader.ShipmentHeader_Currency_RefID = defaultCurrency.CMN_CurrencyID; newShipmentHeader.ShipmentHeader_Number = shipmentHeaderNumber; newShipmentHeader.ShipmentHeader_ValueWithoutTax = 0; newShipmentHeader.ShipmentPriority = 0; newShipmentHeader.ShipmentType_RefID = newShipmentStatusHistory.LOG_SHP_Shipment_StatusHistoryID; newShipmentHeader.Tenant_RefID = securityTicket.TenantID; #endregion #endregion #region New ReturnShipment Header var newReturnShipmentHeaderId = Guid.NewGuid(); var newReturnShipmentHeader = new ORM_LOG_SHP_ReturnShipment_Header(); newReturnShipmentHeader.Creation_Timestamp = DateTime.Now; newReturnShipmentHeader.Ext_Shipment_Header_RefID = newShipmentHeaderId; newReturnShipmentHeader.LOG_SHP_ReturnShipment_HeaderID = newReturnShipmentHeaderId; newReturnShipmentHeader.Tenant_RefID = securityTicket.TenantID; #endregion #region Save var resultHistory = newShipmentStatusHistory.Save(Connection, Transaction); var resultHeader = newShipmentHeader.Save(Connection, Transaction); var resultShipmentHeader = newReturnShipmentHeader.Save(Connection, Transaction); if (resultHistory.Status != FR_Status.Success || resultHeader.Status != FR_Status.Success || resultShipmentHeader.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; returnValue.Result = null; } else { returnValue.Status = FR_Status.Success; returnValue.Result.ShipmentHeaderID = newShipmentHeaderId; returnValue.Result.ShipmentHeaderNumber = newShipmentHeader.ShipmentHeader_Number; returnValue.Result.ReturnShipmentHeaderID = newReturnShipmentHeaderId; } #endregion return(returnValue); #endregion UserCode }
protected static FR_L3SO_GAAfSHI_1612_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L3SO_GAAfSHI_1612 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L3SO_GAAfSHI_1612_Array(); //Put your code here var list = new List <L3SO_GAAfSHI_1612>(); #region Organization Addresses var param = new P_L3OS_GOAfSHI_1407 { ShipmentHeaderID = Parameter.ShipmentHeaderID }; var OrganizationAddress = cls_Get_OrganizationAddress_for_ShipmentHeaderID.Invoke(Connection, Transaction, param, securityTicket).Result; if (OrganizationAddress.Any()) { foreach (var address in OrganizationAddress) { L3SO_GAAfSHI_1612 item = new L3SO_GAAfSHI_1612(); item.AddressID = address.CMN_UniversalContactDetailID; item.Street_Name = address.Street_Name; item.Street_Number = address.Street_Number; item.IsDefault = address.IsPrimary; item.Town = address.Town; item.ZIP = address.ZIP; item.hasOrganizationUnit = true; item.IsCompany = address.IsCompany; list.Add(item); } } #endregion #region Customer Addresses var Shipment = new ORM_LOG_SHP_Shipment_Header(); Shipment.Load(Connection, Transaction, Parameter.ShipmentHeaderID); var Customer = CL1_CMN_BPT_CTM.ORM_CMN_BPT_CTM_Customer.Query.Search(Connection, Transaction, new CL1_CMN_BPT_CTM.ORM_CMN_BPT_CTM_Customer.Query { IsDeleted = false, Tenant_RefID = securityTicket.TenantID, Ext_BusinessParticipant_RefID = Shipment.RecipientBusinessParticipant_RefID }).SingleOrDefault(); List <L3ACAAD_GCAfT_1612> CustomerAddress = new List <L3ACAAD_GCAfT_1612>(); CustomerAddress = cls_Get_CustomerAddresses_for_CustomerID.Invoke(Connection, Transaction, new P_L3ACAAD_GCAfCID_1612 { CustomerID = Customer.CMN_BPT_CTM_CustomerID }, securityTicket).Result.ToList(); if (CustomerAddress.Any()) { foreach (var address in CustomerAddress) { if (!string.IsNullOrEmpty(address.Street_Name)) { L3SO_GAAfSHI_1612 item = new L3SO_GAAfSHI_1612(); item.AddressID = address.AddressID; item.Street_Name = address.Street_Name; item.Street_Number = address.Street_Number; item.IsDefault = address.IsDefault; item.IsBilling = address.IsBilling; item.IsShipping = address.IsShipping; item.IsContact = address.IsContact; item.IsCompany = address.IsCompany; item.Town = address.Town; item.ZIP = address.ZIP; item.hasOrganizationUnit = false; list.Add(item); } } } #endregion returnValue.Result = list.ToArray(); return(returnValue); #endregion UserCode }
protected static FR_L6CN_SCNaURS_0910 Execute(DbConnection Connection, DbTransaction Transaction, P_L6CN_SCNaURS_0910 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L6CN_SCNaURS_0910(); returnValue.Result = new L6CN_SCNaURS_0910(); var newShipmentHeaderGuids = new List <Guid>(); var shipmentPositionsToBeCredited = new List <Guid>(); var newShipmentPositions = new List <P_L5RS_CSaRSPfH_0449a>(); foreach (var header in Parameter.ShipmentHeaders) { var shipmentHeader = new ORM_LOG_SHP_Shipment_Header(); var shipmentHeaderPositions = new List <ORM_LOG_SHP_Shipment_Position>(); #region Load Shipment Header and Positions var result = shipmentHeader.Load(Connection, Transaction, header.ShipmentHeaderID); if (result.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; return(returnValue); } shipmentHeaderPositions = ORM_LOG_SHP_Shipment_Position.Query.Search( Connection, Transaction, new ORM_LOG_SHP_Shipment_Position.Query() { LOG_SHP_Shipment_Header_RefID = header.ShipmentHeaderID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }); #endregion L5RS_CSaRSH_0244 newHeader = null; decimal updatedHeaderTotalValue = 0; foreach (var position in shipmentHeaderPositions) { var positionToBeCredited = header.ShipmentPositions.FirstOrDefault(hsp => hsp.ShipmentPositionID == position.LOG_SHP_Shipment_PositionID); // Split Shipment in case that not all positions of one header are selected for crediting // or in case that selected positions quantities are edited. #region Create New Header and Position Object if position is not selected or dirty if (positionToBeCredited == null || positionToBeCredited.Quantity != positionToBeCredited.OriginalQuantity) { if (Parameter.ReturnToStock == false) { #region Create New Header if (newHeader == null) { var newHeaderParameter = new P_L5RS_CSaRSH_0244() { SupplierID = Parameter.SupplierId }; var createResult = cls_Create_Shipment_and_ReturnShipment_Header.Invoke(Connection, Transaction, newHeaderParameter, securityTicket); if (createResult.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; return(returnValue); } newHeader = createResult.Result; newShipmentHeaderGuids.Add(newHeader.ShipmentHeaderID); } #endregion #region Set New Position Object P_L5RS_CSaRSPfH_0449a newPosition; if (positionToBeCredited == null) { var productTrackingInstance = cls_Get_ProductTrackingInstance_for_StockReceiptPosition.Invoke( Connection, Transaction, new P_L5SR_GPTIfSRP_1322() { ReceiptPositionsID = header.ShipmentPositions[0].ReceiptPositionID }, securityTicket).Result; newPosition = new P_L5RS_CSaRSPfH_0449a() { Quantity = Convert.ToInt32(position.QuantityToShip), PricePerUnit = position.ShipmentPosition_PricePerUnitValueWithoutTax, ProductId = position.CMN_PRO_Product_RefID, ReceiptPositionId = header.ShipmentPositions[0].ReceiptPositionID, ReturnPolicyId = header.ShipmentPositions[0].ReturnPolicyID, ShipmentHeaderID = newHeader.ShipmentHeaderID, ReturnShipmentHeaderID = newHeader.ReturnShipmentHeaderID, ProductTrackingInstance = productTrackingInstance.LOG_ProductTrackingInstanceID, ShelfContentID = productTrackingInstance.LOG_WRH_Shelf_ContentID }; } else { var productTrackingInstance = cls_Get_ProductTrackingInstance_for_StockReceiptPosition.Invoke( Connection, Transaction, new P_L5SR_GPTIfSRP_1322() { ReceiptPositionsID = positionToBeCredited.ReceiptPositionID }, securityTicket).Result; newPosition = new P_L5RS_CSaRSPfH_0449a() { Quantity = positionToBeCredited.OriginalQuantity - positionToBeCredited.Quantity, PricePerUnit = positionToBeCredited.OriginalTotalValue / positionToBeCredited.OriginalQuantity, ProductId = positionToBeCredited.ProductId, ReceiptPositionId = positionToBeCredited.ReceiptPositionID, ReturnPolicyId = positionToBeCredited.ReturnPolicyID, ShipmentHeaderID = newHeader.ShipmentHeaderID, ReturnShipmentHeaderID = newHeader.ReturnShipmentHeaderID, ProductTrackingInstance = productTrackingInstance.LOG_ProductTrackingInstanceID, ShelfContentID = productTrackingInstance.LOG_WRH_Shelf_ContentID }; } newShipmentPositions.Add(newPosition); #endregion } else { #region Return to Stock //The difference in the credited quantity compared to the returned position is taken back to stock. if (positionToBeCredited == null) { var productTrackingInstance = cls_Get_ProductTrackingInstance_for_StockReceiptPosition.Invoke( Connection, Transaction, new P_L5SR_GPTIfSRP_1322() { ReceiptPositionsID = header.ShipmentPositions[0].ReceiptPositionID }, securityTicket).Result; CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content shelfContent = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content(); shelfContent.Load(Connection, Transaction, productTrackingInstance.LOG_WRH_Shelf_ContentID); shelfContent.Quantity_Current = Convert.ToInt32(position.QuantityToShip); shelfContent.Save(Connection, Transaction); CL1_LOG_WRH.ORM_LOG_WRH_Shelf_ContentAdjustment shelfContentAdjustment = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_ContentAdjustment(); shelfContentAdjustment.ShelfContent_RefID = shelfContent.Shelf_RefID; shelfContentAdjustment.QuantityChangedAmount = shelfContent.Quantity_Current; shelfContentAdjustment.QuantityChangedDate = DateTime.Now; shelfContentAdjustment.Creation_Timestamp = DateTime.Now; shelfContentAdjustment.Tenant_RefID = securityTicket.TenantID; shelfContentAdjustment.Save(Connection, Transaction); } else { var productTrackingInstance = cls_Get_ProductTrackingInstance_for_StockReceiptPosition.Invoke( Connection, Transaction, new P_L5SR_GPTIfSRP_1322() { ReceiptPositionsID = positionToBeCredited.ReceiptPositionID }, securityTicket).Result; CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content shelfContent = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content(); shelfContent.Load(Connection, Transaction, productTrackingInstance.LOG_WRH_Shelf_ContentID); shelfContent.Quantity_Current = positionToBeCredited.OriginalQuantity - positionToBeCredited.Quantity; shelfContent.Save(Connection, Transaction); CL1_LOG_WRH.ORM_LOG_WRH_Shelf_ContentAdjustment shelfContentAdjustment = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_ContentAdjustment(); shelfContentAdjustment.ShelfContent_RefID = shelfContent.Shelf_RefID; shelfContentAdjustment.QuantityChangedAmount = shelfContent.Quantity_Current; shelfContentAdjustment.QuantityChangedDate = DateTime.Now; shelfContentAdjustment.Creation_Timestamp = DateTime.Now; shelfContentAdjustment.Tenant_RefID = securityTicket.TenantID; shelfContentAdjustment.Save(Connection, Transaction); } #endregion } } #endregion if (positionToBeCredited == null) { #region Cancel Position #region Get Account var account = ORM_USR_Account.Query.Search(Connection, Transaction, new ORM_USR_Account.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, USR_AccountID = securityTicket.AccountID }).FirstOrDefault(); #endregion position.IsCancelled = true; position.CancelledOnDate = DateTime.Now; position.CancelledBy_BusinessParticipant_RefID = account.BusinessParticipant_RefID; var resultUpdate = position.Save(Connection, Transaction); if (resultUpdate.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; return(returnValue); } #endregion } else { shipmentPositionsToBeCredited.Add(positionToBeCredited.ReturnShipmentPositionID); updatedHeaderTotalValue += positionToBeCredited.TotalValue; #region Update Position if data is dirty if (positionToBeCredited.Quantity != positionToBeCredited.OriginalQuantity || positionToBeCredited.TotalValue != positionToBeCredited.OriginalTotalValue) { position.QuantityToShip = positionToBeCredited.Quantity; position.ShipmentPosition_ValueWithoutTax = positionToBeCredited.TotalValue; var resultUpdate = position.Save(Connection, Transaction); if (resultUpdate.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; return(returnValue); } } #endregion } } #region Update shipmentHeader #region Create Credited Status History // fetch 'credited' status id var returnedStatusId = ORM_LOG_SHP_Shipment_Status.Query.Search( Connection, Transaction, new ORM_LOG_SHP_Shipment_Status.Query() { GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EShipmentStatus.Credited), Tenant_RefID = securityTicket.TenantID }).FirstOrDefault().LOG_SHP_Shipment_StatusID; // fetch Status History 'credited by' User Account var performedByAccount = ORM_USR_Account.Query.Search( Connection, Transaction, new ORM_USR_Account.Query() { USR_AccountID = securityTicket.AccountID }) .FirstOrDefault(); // create status Shipment Status history entry var statusHistoryCredited = new ORM_LOG_SHP_Shipment_StatusHistory(); statusHistoryCredited.Creation_Timestamp = DateTime.Now; statusHistoryCredited.IsDeleted = false; statusHistoryCredited.LOG_SHP_Shipment_Header_RefID = shipmentHeader.LOG_SHP_Shipment_HeaderID; statusHistoryCredited.LOG_SHP_Shipment_Status_RefID = returnedStatusId; statusHistoryCredited.LOG_SHP_Shipment_StatusHistoryID = Guid.NewGuid(); statusHistoryCredited.PerformedBy_BusinessParticipant_RefID = performedByAccount == null ? Guid.Empty : performedByAccount.BusinessParticipant_RefID; statusHistoryCredited.Tenant_RefID = securityTicket.TenantID; var resultSave = statusHistoryCredited.Save(Connection, Transaction); if (resultSave.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; return(returnValue); } #endregion shipmentHeader.ShipmentType_RefID = statusHistoryCredited.LOG_SHP_Shipment_StatusHistoryID; shipmentHeader.ShipmentHeader_ValueWithoutTax = updatedHeaderTotalValue; resultSave = shipmentHeader.Save(Connection, Transaction); if (resultSave.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; return(returnValue); } #endregion } #region Create New Positions foreach (var shipmentHeaderId in newShipmentHeaderGuids) { var positions = new P_L5RS_CSaRSPfH_0449(); positions.Positions = newShipmentPositions.FindAll(nsp => nsp.ShipmentHeaderID == shipmentHeaderId).ToArray(); var returnShipment = new P_L5RS_SRSHaP_0807a() { CreateNewHeader = false, ShipmentHeader = null, ShipmentPositions = positions }; var savePositionsInputParameter = new P_L5RS_SRSHaP_0807() { ReturnShipments = new P_L5RS_SRSHaP_0807a[] { returnShipment } }; var resultCreate = cls_Save_ReturnShipment_Header_and_Position.Invoke(Connection, Transaction, savePositionsInputParameter, securityTicket); if (resultCreate.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; return(returnValue); } } #endregion #region Save CreditNote Header and Positions var inputParameter = new P_L5RS_CNfRS_1119() { headerId = Guid.Empty, headerNumber = Parameter.CreditNoteHeaderNumber, headerValue = Parameter.CreditNoteHeaderValue, currencyRef = Parameter.CreditNoteHeaderCurrencyId, creditNoteDate = Parameter.CreditNoteHeaderDate, returnShipmentPositions = shipmentPositionsToBeCredited.ToArray(), receiptPositions = null }; var resultCreditNote = cls_Save_CreditNote_for_ReturnShipment.Invoke(Connection, Transaction, inputParameter, securityTicket); if (resultCreditNote.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; return(returnValue); } #endregion returnValue.Status = FR_Status.Success; returnValue.Result.CreditNoteHeaderId = resultCreditNote.Result; return(returnValue); #endregion UserCode }
protected static FR_Bool Execute(DbConnection Connection, DbTransaction Transaction, P_L3SO_DARaUSHfPTIL_1159 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Bool(); var param = new P_L3SO_GSaUERfPTIL_1153() { ProductTrackingInstanceIDList = Parameter.TracknigInstances.Select(i => i.ProductTrackingInstanceID).ToArray() }; var shippingsAndActiveReservations = cls_Get_Shippings_and_ActiveReservations_for_ProductTrackingInstanceIDList.Invoke(Connection, Transaction, param, securityTicket).Result; var param2 = new P_L3SO_GARQfMCFPSH_1450() { ProductTrackingInstanceList = Parameter.TracknigInstances.Select(i => i.ProductTrackingInstanceID).ToArray() }; var activeAndStartedReservations = cls_Get_ActiveReservedQuantities_for_ManuallyClearedForPickingShippmentHeaders.Invoke(Connection, Transaction, param2, securityTicket).Result; foreach (var trackingInstance in shippingsAndActiveReservations) { var inParam = Parameter.TracknigInstances.SingleOrDefault(i => i.ProductTrackingInstanceID == trackingInstance.LOG_ProductTrackingInstance_RefID); var activeAndStartedReservation = activeAndStartedReservations.SingleOrDefault(i => i.LOG_ProductTrackingInstance_RefID == trackingInstance.LOG_ProductTrackingInstance_RefID); var activeAndStartedQuantities = (activeAndStartedReservation == null) ? 0 : activeAndStartedReservation.ReservedQuantityFromTrackingInstance; if (inParam != null && (inParam.CurrentQuantityOnTrackingInstance - activeAndStartedQuantities) < inParam.RemovedQuantityFromTrackingInstance) { throw new Exception("Reservation can't be deleted because picking has been started."); } foreach (var item in trackingInstance.Reservations) { #region ShipmentHeaders var shipmentHeader = new ORM_LOG_SHP_Shipment_Header(); shipmentHeader.Load(Connection, Transaction, item.LOG_SHP_Shipment_HeaderID); shipmentHeader.IsPartiallyReadyForPicking = false; shipmentHeader.IsReadyForPicking = false; shipmentHeader.IsManuallyCleared_ForPicking = false; shipmentHeader.HasPickingStarted = false; shipmentHeader.Save(Connection, Transaction); #endregion #region Reservation var reservation = new ORM_LOG_RSV_Reservation(); reservation.Load(Connection, Transaction, item.LOG_RSV_ReservationID); reservation.IsDeleted = true; reservation.Save(Connection, Transaction); #endregion #region Reservation Tracking Instance var reservationTrackingInstance = new ORM_LOG_RSV_Reservation_TrackingInstance(); reservationTrackingInstance.Load(Connection, Transaction, item.LOG_RSV_Reservation_TrackingInstanceID); reservationTrackingInstance.IsDeleted = true; reservationTrackingInstance.Save(Connection, Transaction); #endregion } } return(returnValue); #endregion UserCode }
protected static FR_Guids Execute(DbConnection Connection, DbTransaction Transaction, P_L5OS_ABL_1157 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Guids(); List <Guid> retVal = new List <Guid>(); Guid shippmentHeaderID = Guid.Empty; P_L5OS_GASFD_1234 param = new P_L5OS_GASFD_1234(); param.HEC_DoctorID = Parameter.HEC_Doctor_RefID; var dateNow = DateTime.Now; param.ToDate = new DateTime(dateNow.Year, dateNow.Month, dateNow.Day, 23, 59, 59, 999); param.FormDate = new DateTime(dateNow.Year, dateNow.Month, dateNow.Day, 0, 0, 0, 0); var res = cls_Get_ActiveShippmentForDoctorID.Invoke(Connection, Transaction, param, securityTicket).Result; if (res != null && res.Length > 0) { shippmentHeaderID = res[0].LOG_SHP_Shipment_HeaderID; } if (shippmentHeaderID == Guid.Empty) { ORM_LOG_SHP_Shipment_Header header = new ORM_LOG_SHP_Shipment_Header(); header.IsShipped = false; header.Tenant_RefID = securityTicket.TenantID; header.Save(Connection, Transaction); shippmentHeaderID = header.LOG_SHP_Shipment_HeaderID; } for (int i = 0; i < Parameter.Count; i++) { ORM_LOG_SHP_Shipment_Position logShippmentPosition = new ORM_LOG_SHP_Shipment_Position(); logShippmentPosition.CMN_PRO_Product_RefID = Parameter.CMN_PRO_ProductID; logShippmentPosition.LOG_SHP_Shipment_Header_RefID = shippmentHeaderID; logShippmentPosition.Save(Connection, Transaction); ORM_HEC_ShippingPosition_BarcodeLabel shippmentLabel = new ORM_HEC_ShippingPosition_BarcodeLabel(); shippmentLabel.Doctor_RefID = Parameter.HEC_Doctor_RefID; shippmentLabel.LOG_SHP_Shipment_Position_RefID = logShippmentPosition.LOG_SHP_Shipment_PositionID; shippmentLabel.R_IsSubmission_Complete = false; shippmentLabel.Tenant_RefID = securityTicket.TenantID; List <ORM_HEC_ShippingPosition_BarcodeLabel> positionLabels; String barcodeLabel = ""; do { barcodeLabel = RandomString.Generate(9); var positionLabelsQuery = new ORM_HEC_ShippingPosition_BarcodeLabel.Query(); positionLabelsQuery.ShippingPosition_BarcodeLabel = barcodeLabel; positionLabelsQuery.Tenant_RefID = securityTicket.TenantID; positionLabelsQuery.IsDeleted = false; positionLabels = ORM_HEC_ShippingPosition_BarcodeLabel.Query.Search(Connection, Transaction, positionLabelsQuery); } while (positionLabels != null && positionLabels.Count != 0); shippmentLabel.ShippingPosition_BarcodeLabel = barcodeLabel; shippmentLabel.Save(Connection, Transaction); retVal.Add(shippmentLabel.HEC_ShippingPosition_BarcodeLabelID); } returnValue.Result = retVal.ToArray(); return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5PP_CSHS_1305 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 if (Parameter.LOG_SHP_Shipment_HeaderID == null || Parameter.LOG_SHP_Shipment_HeaderID == Guid.Empty) { return(null); } ORM_LOG_SHP_Shipment_Header shipmentHeader = new ORM_LOG_SHP_Shipment_Header(); var shipmentHeaderResult = shipmentHeader.Load(Connection, Transaction, Parameter.LOG_SHP_Shipment_HeaderID); if (shipmentHeaderResult.Status != FR_Status.Success || shipmentHeader.LOG_SHP_Shipment_HeaderID == Guid.Empty) { return(null); } if (Parameter.IsReadyForPicking != null) { shipmentHeader.IsReadyForPicking = (Boolean)Parameter.IsReadyForPicking; var param = new P_L2SH_SSSH_1313(); param.ShipmentHeaderID = Parameter.LOG_SHP_Shipment_HeaderID; param.ShipmentHeaderStatus = EShipmentStatus.ReadyForPicking; cls_Save_ShipmentStatusHistory.Invoke(Connection, Transaction, param, securityTicket); } if (Parameter.IsPartiallyReadyForPicking != null) { shipmentHeader.IsPartiallyReadyForPicking = (Boolean)Parameter.IsPartiallyReadyForPicking; var param = new P_L2SH_SSSH_1313(); param.ShipmentHeaderID = Parameter.LOG_SHP_Shipment_HeaderID; param.ShipmentHeaderStatus = EShipmentStatus.PartiallyReadyForPicking; cls_Save_ShipmentStatusHistory.Invoke(Connection, Transaction, param, securityTicket); } if (Parameter.IsManuallyCleared_ForPicking != null) { shipmentHeader.IsManuallyCleared_ForPicking = (Boolean)Parameter.IsManuallyCleared_ForPicking; var param = new P_L2SH_SSSH_1313(); param.ShipmentHeaderID = Parameter.LOG_SHP_Shipment_HeaderID; param.ShipmentHeaderStatus = EShipmentStatus.ManuallyClearedForPicking; cls_Save_ShipmentStatusHistory.Invoke(Connection, Transaction, param, securityTicket); } if (Parameter.HasPickingStarted != null) { shipmentHeader.HasPickingStarted = (Boolean)Parameter.HasPickingStarted; var param = new P_L2SH_SSSH_1313(); param.ShipmentHeaderID = Parameter.LOG_SHP_Shipment_HeaderID; param.ShipmentHeaderStatus = EShipmentStatus.PickingStarted; cls_Save_ShipmentStatusHistory.Invoke(Connection, Transaction, param, securityTicket); } if (Parameter.HasPickingFinished != null) { shipmentHeader.HasPickingFinished = (Boolean)Parameter.HasPickingFinished; var param = new P_L2SH_SSSH_1313(); param.ShipmentHeaderID = Parameter.LOG_SHP_Shipment_HeaderID; param.ShipmentHeaderStatus = EShipmentStatus.PickingFinished; cls_Save_ShipmentStatusHistory.Invoke(Connection, Transaction, param, securityTicket); } if (Parameter.IsBilled != null) { shipmentHeader.IsBilled = (Boolean)Parameter.IsBilled; var param = new P_L2SH_SSSH_1313(); param.ShipmentHeaderID = Parameter.LOG_SHP_Shipment_HeaderID; param.ShipmentHeaderStatus = EShipmentStatus.Billed; cls_Save_ShipmentStatusHistory.Invoke(Connection, Transaction, param, securityTicket); } if (Parameter.IsShipped != null) { shipmentHeader.IsShipped = (Boolean)Parameter.IsShipped; var param = new P_L2SH_SSSH_1313(); param.ShipmentHeaderID = Parameter.LOG_SHP_Shipment_HeaderID; param.ShipmentHeaderStatus = EShipmentStatus.Shipped; cls_Save_ShipmentStatusHistory.Invoke(Connection, Transaction, param, securityTicket); } if (Parameter.IsDeleted != null) { var param = new P_L2SH_SSSH_1313(); param.ShipmentHeaderID = Parameter.LOG_SHP_Shipment_HeaderID; param.ShipmentHeaderStatus = EShipmentStatus.Deleted; cls_Save_ShipmentStatusHistory.Invoke(Connection, Transaction, param, securityTicket); } shipmentHeader.Save(Connection, Transaction); return(returnValue); #endregion UserCode }
protected static FR_Bool Execute(DbConnection Connection, DbTransaction Transaction, P_L3SO_USHSaDARfSH_1054 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Bool(); #region Reset Shipment Header var shipmentHeader = new ORM_LOG_SHP_Shipment_Header(); shipmentHeader.Load(Connection, Transaction, Parameter.ShipmentHeaderID); if (shipmentHeader.IsShipped) { returnValue.Result = false; return(returnValue); } shipmentHeader.IsPartiallyReadyForPicking = false; shipmentHeader.IsManuallyCleared_ForPicking = false; shipmentHeader.IsReadyForPicking = false; shipmentHeader.HasPickingStarted = false; shipmentHeader.Save(Connection, Transaction); #endregion #region Save EShipmentStatus.FlagsCleared var param = new P_L2SH_SSSH_1210(); param.ShipmentHeaderID = Parameter.ShipmentHeaderID; param.ShipmentHeaderStatus = EShipmentStatus.FlagsCleared; cls_Save_ShipmentStatusHistory.Invoke(Connection, Transaction, param, securityTicket); #endregion var positions = ORM_LOG_SHP_Shipment_Position.Query.Search(Connection, Transaction, new ORM_LOG_SHP_Shipment_Position.Query() { LOG_SHP_Shipment_Header_RefID = Parameter.ShipmentHeaderID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }); foreach (var position in positions) { var reservations = ORM_LOG_RSV_Reservation.Query.Search(Connection, Transaction, new ORM_LOG_RSV_Reservation.Query() { LOG_SHP_Shipment_Position_RefID = position.LOG_SHP_Shipment_PositionID, IsReservationExecuted = false, //this is impossible, but I still want to keep better trace if somehow happen @Pedja IsDeleted = false, Tenant_RefID = securityTicket.TenantID }); foreach (var reservation in reservations) { #region Delete Reservation reservation.IsDeleted = true; reservation.Save(Connection, Transaction); #endregion #region Delete Reservation TrackingInstance var reservationTrackingInstance = ORM_LOG_RSV_Reservation_TrackingInstance.Query.SoftDelete(Connection, Transaction, new ORM_LOG_RSV_Reservation_TrackingInstance.Query() { LOG_RSV_Reservation_RefID = reservation.LOG_RSV_ReservationID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }); #endregion } } returnValue.Result = true; return(returnValue); #endregion UserCode }