protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5SR_SRPaEDP_1406 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); var queryProcurement = new CL1_LOG_RCP.ORM_LOG_RCP_ReceiptHeader_2_ProcurementOrderHeader.Query() { LOG_RCP_Receipt_Header_RefID = Parameter.ReceiptHeaderID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }; var receiptToProcurementHeader = CL1_LOG_RCP.ORM_LOG_RCP_ReceiptHeader_2_ProcurementOrderHeader.Query.Search(Connection, Transaction, queryProcurement).Single(); Guid procurementHeaderID = receiptToProcurementHeader.ORD_PRO_ProcurementOrder_Header_RefID; #region Positions if (Parameter.StockPositions != null) { foreach (var item in Parameter.StockPositions) { #region Receipt Positions var receiptPosition = new CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position(); if (item.ReceiptPositionID == Guid.Empty) { // create new position receiptPosition.LOG_RCP_Receipt_PositionID = Guid.NewGuid(); receiptPosition.Creation_Timestamp = DateTime.Now; receiptPosition.Tenant_RefID = securityTicket.TenantID; receiptPosition.ReceiptPositionITL = receiptPosition.LOG_RCP_Receipt_PositionID.ToString(); receiptPosition.Receipt_Header_RefID = Parameter.ReceiptHeaderID; receiptPosition.ReceiptPosition_Product_RefID = item.ProductID; } else { // load and edit existing position receiptPosition.Load(Connection, Transaction, item.ReceiptPositionID); } receiptPosition.TotalQuantityFreeOfCharge = 0.0; receiptPosition.TotalQuantityTakenIntoStock = 0.0; receiptPosition.ExpectedPositionPrice = item.UnitPrice; receiptPosition.Save(Connection, Transaction); #endregion #region Procurement Order Positions var procurementPosition = new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Position(); var receiptToProcurementPosition = new CL1_LOG_RCP.ORM_LOG_RCP_ReceiptPosition_2_ProcurementOrderPosition(); if (item.ReceiptPositionID == Guid.Empty) { #region Create new var query2 = new CL1_CMN_PRO.ORM_CMN_PRO_Product.Query() { CMN_PRO_ProductID = item.ProductID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }; var product = CL1_CMN_PRO.ORM_CMN_PRO_Product.Query.Search(Connection, Transaction, query2).Single(); var query3 = new CL1_CMN_PRO_PAC.ORM_CMN_PRO_PAC_PackageInfo.Query() { CMN_PRO_PAC_PackageInfoID = product.PackageInfo_RefID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }; var packageInfo = CL1_CMN_PRO_PAC.ORM_CMN_PRO_PAC_PackageInfo.Query.Search(Connection, Transaction, query3).Single(); var unitID = packageInfo.PackageContent_MeasuredInUnit_RefID; // Create procurement order position for this position procurementPosition = new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Position() { ORD_PRC_ProcurementOrder_PositionID = Guid.NewGuid(), ProcurementOrder_Header_RefID = procurementHeaderID, Creation_Timestamp = DateTime.Now, Tenant_RefID = securityTicket.TenantID, CMN_PRO_Product_RefID = item.ProductID, Position_Unit_RefID = unitID, }; receiptToProcurementPosition = new CL1_LOG_RCP.ORM_LOG_RCP_ReceiptPosition_2_ProcurementOrderPosition() { AssignmentID = Guid.NewGuid(), Creation_Timestamp = DateTime.Now, Tenant_RefID = securityTicket.TenantID, ORD_PRO_ProcurementOrder_Position_RefID = procurementPosition.ORD_PRC_ProcurementOrder_PositionID, LOG_RCP_Receipt_Position_RefID = receiptPosition.LOG_RCP_Receipt_PositionID, }; #endregion } else { #region Load existing procurement order position var query = new CL1_LOG_RCP.ORM_LOG_RCP_ReceiptPosition_2_ProcurementOrderPosition.Query() { LOG_RCP_Receipt_Position_RefID = receiptPosition.LOG_RCP_Receipt_PositionID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }; receiptToProcurementPosition = CL1_LOG_RCP.ORM_LOG_RCP_ReceiptPosition_2_ProcurementOrderPosition.Query.Search(Connection, Transaction, query).Single(); var query2 = new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Position.Query() { ORD_PRC_ProcurementOrder_PositionID = receiptToProcurementPosition.ORD_PRO_ProcurementOrder_Position_RefID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }; procurementPosition = CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Position.Query.Search(Connection, Transaction, query2).Single(); #endregion } // save changed or newly created procurement position and assignment procurementPosition.Position_Quantity = item.OrderQuantity; procurementPosition.Position_ValuePerUnit = item.UnitPrice; procurementPosition.Position_ValueTotal = item.UnitPrice * (decimal)item.OrderQuantity; procurementPosition.Save(Connection, Transaction); receiptToProcurementPosition.ReceivedQuantityFromProcurementOrderPosition = item.OrderQuantity; receiptToProcurementPosition.Save(Connection, Transaction); #endregion #region Expected Delivery var expectedDeliveryPosition = new CL1_ORD_PRC.ORM_ORD_PRC_ExpectedDelivery_Position(); var expectedDeliveryToProcurementOrderPosition = new CL1_ORD_PRC.ORM_ORD_PRC_ExpectedDelivery_2_ProcurementOrderPosition(); if (item.ReceiptPositionID == Guid.Empty) { #region Create new // get expected delivery header assigned to receipt header of this position var query2 = new CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Header.Query { LOG_RCP_Receipt_HeaderID = receiptPosition.Receipt_Header_RefID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }; var receiptHeader = CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Header.Query.Search(Connection, Transaction, query2).Single(); expectedDeliveryPosition.ORD_PRC_ExpectedDelivery_PositionID = Guid.NewGuid(); expectedDeliveryPosition.Creation_Timestamp = DateTime.Now; expectedDeliveryPosition.Tenant_RefID = securityTicket.TenantID; expectedDeliveryPosition.ORD_PRC_ExpectedDelivery_RefID = receiptHeader.ExpectedDeliveryHeader_RefID; expectedDeliveryPosition.ExpectedDeliveryPositionITL = expectedDeliveryPosition.ORD_PRC_ExpectedDelivery_PositionID.ToString(); //expectedDeliveryPosition.AlreadyReceivedQuantityOfDelivery = ? expectedDeliveryToProcurementOrderPosition.AssignmentID = Guid.NewGuid(); expectedDeliveryToProcurementOrderPosition.ORD_PRC_ExpectedDelivery_Position_RefID = expectedDeliveryPosition.ORD_PRC_ExpectedDelivery_PositionID; expectedDeliveryToProcurementOrderPosition.ORD_PRC_ProcurementOrder_Position_RefID = procurementPosition.ORD_PRC_ProcurementOrder_PositionID; expectedDeliveryToProcurementOrderPosition.Creation_Timestamp = DateTime.Now; expectedDeliveryToProcurementOrderPosition.Tenant_RefID = securityTicket.TenantID; #endregion } else { #region Load existing var query = new CL1_ORD_PRC.ORM_ORD_PRC_ExpectedDelivery_2_ProcurementOrderPosition.Query() { ORD_PRC_ProcurementOrder_Position_RefID = procurementPosition.ORD_PRC_ProcurementOrder_PositionID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }; expectedDeliveryToProcurementOrderPosition = CL1_ORD_PRC.ORM_ORD_PRC_ExpectedDelivery_2_ProcurementOrderPosition.Query.Search(Connection, Transaction, query).Single(); var query2 = new CL1_ORD_PRC.ORM_ORD_PRC_ExpectedDelivery_Position.Query() { ORD_PRC_ExpectedDelivery_PositionID = expectedDeliveryToProcurementOrderPosition.ORD_PRC_ExpectedDelivery_Position_RefID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }; expectedDeliveryPosition = CL1_ORD_PRC.ORM_ORD_PRC_ExpectedDelivery_Position.Query.Search(Connection, Transaction, query2).Single(); #endregion } expectedDeliveryPosition.TotalExpectedQuantity = item.OrderQuantity; expectedDeliveryPosition.Save(Connection, Transaction); expectedDeliveryToProcurementOrderPosition.AssignedQuantityFromProcurementOrderPosition = procurementPosition.Position_Quantity; expectedDeliveryToProcurementOrderPosition.Save(Connection, Transaction); #endregion #region Quality Control Items var qualityControlItem = new CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position_QualityControlItem(); if (item.ReceiptPositionID == Guid.Empty) { qualityControlItem.LOG_RCP_Receipt_Position_QualityControlItem = Guid.NewGuid(); qualityControlItem.ReceiptPositionCountedItemITL = qualityControlItem.LOG_RCP_Receipt_Position_QualityControlItem.ToString(); qualityControlItem.Creation_Timestamp = DateTime.Now; qualityControlItem.Tenant_RefID = securityTicket.TenantID; qualityControlItem.Receipt_Position_RefID = receiptPosition.LOG_RCP_Receipt_PositionID; } else { var query = new CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position_QualityControlItem.Query() { Receipt_Position_RefID = receiptPosition.LOG_RCP_Receipt_PositionID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }; qualityControlItem = CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position_QualityControlItem.Query.Search(Connection, Transaction, query).Single(); } qualityControlItem.BatchNumber = item.BatchNumber; qualityControlItem.ExpiryDate = item.ExpiryDate; qualityControlItem.Quantity = procurementPosition.Position_Quantity; qualityControlItem.Save(Connection, Transaction); #endregion #region Forwarding Instruction var forwardingInstruction = new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Position_ForwardingInstruction(); if (item.ReceiptPositionID == Guid.Empty) { #region Create new var businessParticipant = CL1_CMN_BPT.ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new CL1_CMN_BPT.ORM_CMN_BPT_BusinessParticipant.Query() { IfTenant_Tenant_RefID = securityTicket.TenantID, IsDeleted = false }).Single(); forwardingInstruction.ORD_PRC_ProcurementOrder_Position_ForwardingInstructionID = Guid.NewGuid(); forwardingInstruction.Creation_Timestamp = DateTime.Now; forwardingInstruction.Tenant_RefID = securityTicket.TenantID; forwardingInstruction.ProcurementOrder_Position_RefID = procurementPosition.ORD_PRC_ProcurementOrder_PositionID; forwardingInstruction.ForwardTo_BusinessParticipant_RefID = businessParticipant.CMN_BPT_BusinessParticipantID; #endregion } else { #region Load Existing var query = new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Position_ForwardingInstruction.Query() { ProcurementOrder_Position_RefID = procurementPosition.ORD_PRC_ProcurementOrder_PositionID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }; forwardingInstruction = CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Position_ForwardingInstruction.Query.Search(Connection, Transaction, query).Single(); #endregion } forwardingInstruction.QuantityToForward = procurementPosition.Position_Quantity; forwardingInstruction.Save(Connection, Transaction); #endregion } } #endregion returnValue.Result = Parameter.ReceiptHeaderID; return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5ALSR_CSRC_1200 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); #region Receipt Position (Update) var receiptPosition = new CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position(); receiptPosition.Load(Connection, Transaction, Parameter.LOG_RCP_Receipt_PositionID); receiptPosition.TotalQuantityTakenIntoStock = Parameter.AlreadyReceivedQuantityOfDelivery; receiptPosition.Save(Connection, Transaction); #endregion #region ProcurementOrderPosition (Read) var query1 = new CL1_LOG_RCP.ORM_LOG_RCP_ReceiptPosition_2_ProcurementOrderPosition.Query() { LOG_RCP_Receipt_Position_RefID = receiptPosition.LOG_RCP_Receipt_PositionID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }; var receiptToProcurementPosition = CL1_LOG_RCP.ORM_LOG_RCP_ReceiptPosition_2_ProcurementOrderPosition.Query.Search(Connection, Transaction, query1).Single(); var query2 = new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Position.Query() { ORD_PRC_ProcurementOrder_PositionID = receiptToProcurementPosition.ORD_PRO_ProcurementOrder_Position_RefID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }; var procurementPosition = CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Position.Query.Search(Connection, Transaction, query2).Single(); #endregion #region Assingment Tables (Read) var assReceiptPos2ProcuPos = CL1_LOG_RCP.ORM_LOG_RCP_ReceiptPosition_2_ProcurementOrderPosition.Query.Search(Connection, Transaction, new CL1_LOG_RCP.ORM_LOG_RCP_ReceiptPosition_2_ProcurementOrderPosition.Query { LOG_RCP_Receipt_Position_RefID = receiptPosition.LOG_RCP_Receipt_PositionID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }).Single(); var procurementOrderPosition = new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Position(); procurementOrderPosition.Load(Connection, Transaction, assReceiptPos2ProcuPos.ORD_PRO_ProcurementOrder_Position_RefID); var assExpectedDlv2ProcurementOrderPos = CL1_ORD_PRC.ORM_ORD_PRC_ExpectedDelivery_2_ProcurementOrderPosition.Query.Search(Connection, Transaction, new CL1_ORD_PRC.ORM_ORD_PRC_ExpectedDelivery_2_ProcurementOrderPosition.Query { ORD_PRC_ProcurementOrder_Position_RefID = procurementOrderPosition.ORD_PRC_ProcurementOrder_PositionID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }).SingleOrDefault(); #endregion #region Expected Delivery Positions (Update) if (assExpectedDlv2ProcurementOrderPos != null) { var expectedDeliveryPosition = new CL1_ORD_PRC.ORM_ORD_PRC_ExpectedDelivery_Position(); expectedDeliveryPosition.Load(Connection, Transaction, assExpectedDlv2ProcurementOrderPos.ORD_PRC_ExpectedDelivery_Position_RefID); expectedDeliveryPosition.AlreadyReceivedQuantityOfDelivery = Parameter.AlreadyReceivedQuantityOfDelivery; expectedDeliveryPosition.Save(Connection, Transaction); } #endregion #region Receipt Position Quality Control Items { // Delete all Quality Control Items because they are dummy var qualityControlItems = CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position_QualityControlItem.Query.Search(Connection, Transaction, new CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position_QualityControlItem.Query { Receipt_Position_RefID = receiptPosition.LOG_RCP_Receipt_PositionID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }); qualityControlItems.ForEach(x => x.IsDeleted = true); qualityControlItems.ForEach(x => x.Save(Connection, Transaction)); // Add new Quality Control Items foreach (var sp in Parameter.StockPackets) { var qualityControlItem = new CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position_QualityControlItem(); qualityControlItem.Receipt_Position_RefID = receiptPosition.LOG_RCP_Receipt_PositionID; qualityControlItem.ReceiptPositionCountedItemITL = Guid.NewGuid().ToString(); qualityControlItem.Tenant_RefID = securityTicket.TenantID; qualityControlItem.BatchNumber = sp.SerialNumber; qualityControlItem.Quantity = sp.ProductQuantity; if (sp.ExpirationDate.HasValue) { qualityControlItem.ExpiryDate = sp.ExpirationDate.Value; } qualityControlItem.QualityControl_PerformedByBusinessParticipant_RefID = sp.QualityControl_PerformedByBusinessParticipant_RefID; qualityControlItem.QualityControl_PerformedAtDate = sp.QualityControl_PerformedAtDate; qualityControlItem.Save(Connection, Transaction); } } #endregion #region Request Quantity Forwarding foreach (var company in Parameter.Companies) { #region Forwarding Instruction var query = new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Position_ForwardingInstruction.Query() { ProcurementOrder_Position_RefID = procurementPosition.ORD_PRC_ProcurementOrder_PositionID, ForwardTo_BusinessParticipant_RefID = company.CompanyBusinessParticipantID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }; var forwardingInstruction = CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Position_ForwardingInstruction.Query.Search(Connection, Transaction, query).SingleOrDefault(); if (forwardingInstruction == null) { #region Create new var businessParticipant = CL1_CMN_BPT.ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new CL1_CMN_BPT.ORM_CMN_BPT_BusinessParticipant.Query() { IfTenant_Tenant_RefID = securityTicket.TenantID, IsDeleted = false }).Single(); forwardingInstruction.ORD_PRC_ProcurementOrder_Position_ForwardingInstructionID = Guid.NewGuid(); forwardingInstruction.Creation_Timestamp = DateTime.Now; forwardingInstruction.Tenant_RefID = securityTicket.TenantID; forwardingInstruction.ProcurementOrder_Position_RefID = procurementPosition.ORD_PRC_ProcurementOrder_PositionID; forwardingInstruction.ForwardTo_BusinessParticipant_RefID = businessParticipant.CMN_BPT_BusinessParticipantID; #endregion } forwardingInstruction.QuantityToForward = company.CompanyStockPackets.Sum(i => i.QuantityToTransfer); forwardingInstruction.Save(Connection, Transaction); #endregion var rqfHeader = new CL1_LOG_RCP_RQF.ORM_LOG_RCP_RQF_RequestQuantityForwarding_Header(); rqfHeader.Tenant_RefID = securityTicket.TenantID; rqfHeader.SplitFrom_ReceiptHeader_RefID = receiptPosition.Receipt_Header_RefID; rqfHeader.ExecutingBusinessParticipant_RefID = company.CompanyBusinessParticipantID; rqfHeader.Save(Connection, Transaction); var rqfPosition = new CL1_LOG_RCP_RQF.ORM_LOG_RCP_RQF_RequestQuantityForwarding_Position(); rqfPosition.Tenant_RefID = securityTicket.TenantID; rqfPosition.ReceivedQuantityForwarding_Header_RefID = rqfHeader.SplitFrom_ReceiptHeader_RefID; foreach (var rqfItem in company.CompanyStockPackets) { var rqfPositionItem = new CL1_LOG_RCP_RQF.ORM_LOG_RCP_RQF_Position_MemberItem(); rqfPositionItem.RequestQuantityForwarding_Position_RefID = rqfPosition.LOG_RCP_RQF_RequestQuantityForwarding_PositionID; rqfPositionItem.BatchNumber = rqfItem.SerialNumber; rqfPositionItem.Quantity = rqfItem.QuantityToTransfer; rqfPositionItem.Save(Connection, Transaction); } rqfPosition.TotalReceivedQuantity = company.CompanyStockPackets.Sum(x => x.QuantityToTransfer); rqfPosition.ExpectedQuantity = procurementPosition.Position_Quantity; rqfPosition.CreatedFrom_PositionForwardingInstruction_RefID = forwardingInstruction.ORD_PRC_ProcurementOrder_Position_ForwardingInstructionID; rqfPosition.Save(Connection, Transaction); } #endregion return(new FR_Guid(receiptPosition.LOG_RCP_Receipt_PositionID)); #endregion UserCode }