protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5SR_CEDfUP_1438 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); #region Save Header #region Expected Delivery Header var incrNumberParam = new P_L2NR_GaIINfUA_1454() { GlobalStaticMatchingID = EnumUtils.GetEnumDescription(ENumberRangeUsageAreaType.ExpectedDeliveryNumber) }; var expectedDeliveryNumber = cls_Get_and_Increase_IncreasingNumber_for_UsageArea.Invoke(Connection, Transaction, incrNumberParam, securityTicket).Result.Current_IncreasingNumber; var expectedDeliveryHeader = new CL1_ORD_PRC.ORM_ORD_PRC_ExpectedDelivery_Header(); expectedDeliveryHeader.ORD_PRC_ExpectedDelivery_HeaderID = Guid.NewGuid(); expectedDeliveryHeader.ExpectedDeliveryNumber = expectedDeliveryNumber; expectedDeliveryHeader.IsDeliveryOpen = true; expectedDeliveryHeader.IsDeliveryClosed = false; expectedDeliveryHeader.ExpectedDeliveryHeaderITL = expectedDeliveryHeader.ORD_PRC_ExpectedDelivery_HeaderID.ToString(); expectedDeliveryHeader.ExpectedDeliveryDate = Parameter.ExpectedDeliveryDate; expectedDeliveryHeader.Tenant_RefID = securityTicket.TenantID; expectedDeliveryHeader.Creation_Timestamp = DateTime.Now; expectedDeliveryHeader.Save(Connection, Transaction); #endregion #region Receipt Header var oldReceiptHeader = new ORM_LOG_RCP_Receipt_Header(); oldReceiptHeader.Load(Connection, Transaction, Parameter.ReceiptHeaderID); incrNumberParam = new P_L2NR_GaIINfUA_1454() { GlobalStaticMatchingID = EnumUtils.GetEnumDescription(ENumberRangeUsageAreaType.StockReceiptNumber) }; var receiptNumber = cls_Get_and_Increase_IncreasingNumber_for_UsageArea.Invoke(Connection, Transaction, incrNumberParam, securityTicket).Result.Current_IncreasingNumber; var receiptHeader = new CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Header(); receiptHeader.ReceiptNumber = receiptNumber; receiptHeader.LOG_RCP_Receipt_HeaderID = Guid.NewGuid(); receiptHeader.Creation_Timestamp = DateTime.Now; receiptHeader.Tenant_RefID = securityTicket.TenantID; receiptHeader.ReceiptHeaderITL = receiptHeader.LOG_RCP_Receipt_HeaderID.ToString(); receiptHeader.IsTakenIntoStock = false; receiptHeader.ProvidingSupplier_RefID = oldReceiptHeader.ProvidingSupplier_RefID; receiptHeader.ExpectedDeliveryHeader_RefID = expectedDeliveryHeader.ORD_PRC_ExpectedDelivery_HeaderID; receiptHeader.Save(Connection, Transaction); #endregion Receipt Header #region Procurement Order var oldReceiptToProcurement = ORM_LOG_RCP_ReceiptHeader_2_ProcurementOrderHeader.Query.Search(Connection, Transaction, new ORM_LOG_RCP_ReceiptHeader_2_ProcurementOrderHeader.Query() { LOG_RCP_Receipt_Header_RefID = Parameter.ReceiptHeaderID, IsDeleted = false }).First(); var receiptToProcurement = new CL1_LOG_RCP.ORM_LOG_RCP_ReceiptHeader_2_ProcurementOrderHeader(); receiptToProcurement.AssignmentID = Guid.NewGuid(); receiptToProcurement.Creation_Timestamp = DateTime.Now; receiptToProcurement.Tenant_RefID = securityTicket.TenantID; receiptToProcurement.LOG_RCP_Receipt_Header_RefID = receiptHeader.LOG_RCP_Receipt_HeaderID; receiptToProcurement.ORD_PRO_ProcurementOrder_Header_RefID = oldReceiptToProcurement.ORD_PRO_ProcurementOrder_Header_RefID; receiptToProcurement.Save(Connection, Transaction); #endregion #endregion #region Save Positions P_L5SR_GSRPfH_1544 param = new P_L5SR_GSRPfH_1544(); param.ReceiptHeaderID = Parameter.ReceiptHeaderID; var stockReceiptsPositions = cls_Get_StockReceiptsPositions_for_ReceiptHeaderID.Invoke(Connection, Transaction, param, securityTicket).Result; foreach (var positionParam in Parameter.ReceiptPositions) { var item = stockReceiptsPositions.Single(i => i.OrderPosition.LOG_RCP_Receipt_PositionID == positionParam.ReceipPositionID); #region Receipt Position var receiptPosition = new CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position(); receiptPosition.LOG_RCP_Receipt_PositionID = Guid.NewGuid(); receiptPosition.Receipt_Header_RefID = receiptHeader.LOG_RCP_Receipt_HeaderID; receiptPosition.ReceiptPosition_Product_RefID = item.OrderPosition.ReceiptPosition_Product_RefID; receiptPosition.TotalQuantityFreeOfCharge = 0.0; receiptPosition.TotalQuantityTakenIntoStock = 0.0; receiptPosition.ExpectedPositionPrice = item.OrderPosition.Receipt_ExpectedPositionPrice; receiptPosition.Creation_Timestamp = DateTime.Now; receiptPosition.Tenant_RefID = securityTicket.TenantID; receiptPosition.Save(Connection, Transaction); #endregion #region ReceiptPosition to ProcurementOrderPosition var receiptToProcurementPosition = new CL1_LOG_RCP.ORM_LOG_RCP_ReceiptPosition_2_ProcurementOrderPosition(); receiptToProcurementPosition.AssignmentID = Guid.NewGuid(); receiptToProcurementPosition.ORD_PRO_ProcurementOrder_Position_RefID = item.OrderPosition.ORD_PRC_ProcurementOrder_PositionID; receiptToProcurementPosition.LOG_RCP_Receipt_Position_RefID = receiptPosition.LOG_RCP_Receipt_PositionID; receiptToProcurementPosition.ReceivedQuantityFromProcurementOrderPosition = positionParam.ExpectedQuantity; receiptToProcurementPosition.Creation_Timestamp = DateTime.Now; receiptToProcurementPosition.Tenant_RefID = securityTicket.TenantID; receiptToProcurementPosition.Save(Connection, Transaction); #endregion #region Expected Delivery var expectedDeliveryPosition = new CL1_ORD_PRC.ORM_ORD_PRC_ExpectedDelivery_Position(); expectedDeliveryPosition.ORD_PRC_ExpectedDelivery_PositionID = Guid.NewGuid(); expectedDeliveryPosition.ORD_PRC_ExpectedDelivery_RefID = receiptHeader.ExpectedDeliveryHeader_RefID; expectedDeliveryPosition.TotalExpectedQuantity = positionParam.ExpectedQuantity; expectedDeliveryPosition.Creation_Timestamp = DateTime.Now; expectedDeliveryPosition.Tenant_RefID = securityTicket.TenantID; expectedDeliveryPosition.Save(Connection, Transaction); var expectedDeliveryToProcurementOrderPosition = new CL1_ORD_PRC.ORM_ORD_PRC_ExpectedDelivery_2_ProcurementOrderPosition(); expectedDeliveryToProcurementOrderPosition.AssignmentID = Guid.NewGuid(); expectedDeliveryToProcurementOrderPosition.ORD_PRC_ExpectedDelivery_Position_RefID = expectedDeliveryPosition.ORD_PRC_ExpectedDelivery_PositionID; expectedDeliveryToProcurementOrderPosition.ORD_PRC_ProcurementOrder_Position_RefID = item.OrderPosition.ORD_PRC_ProcurementOrder_PositionID; expectedDeliveryToProcurementOrderPosition.AssignedQuantityFromProcurementOrderPosition = positionParam.ExpectedQuantity; expectedDeliveryToProcurementOrderPosition.Creation_Timestamp = DateTime.Now; expectedDeliveryToProcurementOrderPosition.Tenant_RefID = securityTicket.TenantID; expectedDeliveryToProcurementOrderPosition.Save(Connection, Transaction); #endregion #region Quality Control Items var oldQualityControlItem = ORM_LOG_RCP_Receipt_Position_QualityControlItem.Query.Search(Connection, Transaction, new ORM_LOG_RCP_Receipt_Position_QualityControlItem.Query() { Receipt_Position_RefID = item.OrderPosition.LOG_RCP_Receipt_PositionID, IsDeleted = false }).First(); var qualityControlItem = new CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position_QualityControlItem(); qualityControlItem.LOG_RCP_Receipt_Position_QualityControlItem = Guid.NewGuid(); qualityControlItem.ReceiptPositionCountedItemITL = qualityControlItem.LOG_RCP_Receipt_Position_QualityControlItem.ToString(); qualityControlItem.Receipt_Position_RefID = receiptPosition.LOG_RCP_Receipt_PositionID; qualityControlItem.BatchNumber = oldQualityControlItem.BatchNumber; qualityControlItem.ExpiryDate = oldQualityControlItem.ExpiryDate; qualityControlItem.Quantity = positionParam.ExpectedQuantity; qualityControlItem.Creation_Timestamp = DateTime.Now; qualityControlItem.Tenant_RefID = securityTicket.TenantID; qualityControlItem.Save(Connection, Transaction); #endregion #region Forwarding Instruction var oldForwardingInstruction = ORM_ORD_PRC_ProcurementOrder_Position_ForwardingInstruction.Query.Search(Connection, Transaction, new ORM_ORD_PRC_ProcurementOrder_Position_ForwardingInstruction.Query() { ProcurementOrder_Position_RefID = item.OrderPosition.ORD_PRC_ProcurementOrder_PositionID, IsDeleted = false }).First(); var forwardingInstruction = new CL1_ORD_PRC.ORM_ORD_PRC_ProcurementOrder_Position_ForwardingInstruction(); forwardingInstruction.ORD_PRC_ProcurementOrder_Position_ForwardingInstructionID = Guid.NewGuid(); forwardingInstruction.ProcurementOrder_Position_RefID = item.OrderPosition.ORD_PRC_ProcurementOrder_PositionID; forwardingInstruction.ForwardTo_BusinessParticipant_RefID = oldForwardingInstruction.ForwardTo_BusinessParticipant_RefID; forwardingInstruction.QuantityToForward = positionParam.ExpectedQuantity; forwardingInstruction.Creation_Timestamp = DateTime.Now; forwardingInstruction.Tenant_RefID = securityTicket.TenantID; forwardingInstruction.Save(Connection, Transaction); #endregion } #endregion return(returnValue); #endregion UserCode }
private static List <ORM_LOG_RCP_Receipt_Position> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction) { CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection(); List <ORM_LOG_RCP_Receipt_Position> 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_RCP_Receipt_Position>(); var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader()); reader.SetOrdinals(new string[] { "LOG_RCP_Receipt_PositionID", "ReceiptPositionITL", "Receipt_Header_RefID", "TotalQuantityTakenIntoStock", "TotalQuantityFreeOfCharge", "ExpectedPositionPrice", "PriceOnSupplierBill", "ReceiptPosition_Product_RefID", "ReceiptPosition_ProductVariant_RefID", "ReceiptPosition_ProductRelease_RefID", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" }); while (reader.Read()) { ORM_LOG_RCP_Receipt_Position item = new ORM_LOG_RCP_Receipt_Position(); //0:Parameter LOG_RCP_Receipt_PositionID of type Guid item.LOG_RCP_Receipt_PositionID = reader.GetGuid(0); //1:Parameter ReceiptPositionITL of type String item.ReceiptPositionITL = reader.GetString(1); //2:Parameter Receipt_Header_RefID of type Guid item.Receipt_Header_RefID = reader.GetGuid(2); //3:Parameter TotalQuantityTakenIntoStock of type Double item.TotalQuantityTakenIntoStock = reader.GetDouble(3); //4:Parameter TotalQuantityFreeOfCharge of type Double item.TotalQuantityFreeOfCharge = reader.GetDouble(4); //5:Parameter ExpectedPositionPrice of type Decimal item.ExpectedPositionPrice = reader.GetDecimal(5); //6:Parameter PriceOnSupplierBill of type Decimal item.PriceOnSupplierBill = reader.GetDecimal(6); //7:Parameter ReceiptPosition_Product_RefID of type Guid item.ReceiptPosition_Product_RefID = reader.GetGuid(7); //8:Parameter ReceiptPosition_ProductVariant_RefID of type Guid item.ReceiptPosition_ProductVariant_RefID = reader.GetGuid(8); //9:Parameter ReceiptPosition_ProductRelease_RefID of type Guid item.ReceiptPosition_ProductRelease_RefID = reader.GetGuid(9); //10:Parameter Creation_Timestamp of type DateTime item.Creation_Timestamp = reader.GetDate(10); //11:Parameter Tenant_RefID of type Guid item.Tenant_RefID = reader.GetGuid(11); //12:Parameter IsDeleted of type Boolean item.IsDeleted = reader.GetBoolean(12); 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_L5SR_SRP_1141 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); List <Guid> positionIDs = new List <Guid>(); var positionToEdit = new CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position(); positionToEdit.Load(Connection, Transaction, Parameter.PositionID); positionToEdit.PriceOnSupplierBill = Convert.ToDecimal(Parameter.PositionValue); positionToEdit.Save(Connection, Transaction); if (Parameter.PositionDiscounts != null) { if (Parameter.SaveNaturalRabatForAllPos) { var headerID = positionToEdit.Receipt_Header_RefID; var headerPositions = ORM_LOG_RCP_Receipt_Position.Query.Search(Connection, Transaction, new ORM_LOG_RCP_Receipt_Position.Query { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, Receipt_Header_RefID = headerID }).ToList(); positionIDs.AddRange(headerPositions.Select(x => x.LOG_RCP_Receipt_PositionID)); } #region Load position discounts var positionDiscountAmounts = ORM_LOG_RCP_Receipt_Position_DiscountAmount.Query.Search(Connection, Transaction, new ORM_LOG_RCP_Receipt_Position_DiscountAmount.Query { LOG_RCP_Receipt_Position_RefID = Parameter.PositionID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }).ToArray(); #endregion #region Preload discount types and choose those that are applying to stock reciept positions var discountTypesParam = new P_L2DT_GDTfGPMIL_1546(); discountTypesParam.GlobalPropertyMatchingID_List = new string[] { EnumUtils.GetEnumDescription(EDiscountType.MainDiscount), EnumUtils.GetEnumDescription(EDiscountType.Discount2), EnumUtils.GetEnumDescription(EDiscountType.Discount3), EnumUtils.GetEnumDescription(EDiscountType.NaturalDiscount) }; var discountTypes = cls_Get_DiscountTypes_for_GlobalPropertyMatchingID_List.Invoke(Connection, Transaction, discountTypesParam, securityTicket).Result; #endregion ORM_LOG_RCP_Receipt_Position_DiscountAmount discountAmount = null; foreach (var item in discountTypes) { var paramDiscount = Parameter.PositionDiscounts.SingleOrDefault(x => x.DiscountTypeID == item.ORD_PRC_DiscountTypeID); if (paramDiscount == null) { // if no discount type is in the parameters continue; } discountAmount = positionDiscountAmounts.SingleOrDefault(x => x.ORD_PRC_DiscountType_RefID == item.ORD_PRC_DiscountTypeID); if (discountAmount == null) { // create new position discount amount discountAmount = new ORM_LOG_RCP_Receipt_Position_DiscountAmount { LOG_RCP_Receipt_Position_DiscountAmountID = Guid.NewGuid(), LOG_RCP_Receipt_Position_RefID = Parameter.PositionID, ORD_PRC_DiscountType_RefID = item.ORD_PRC_DiscountTypeID, Tenant_RefID = securityTicket.TenantID }; } discountAmount.PositionDiscountValue = paramDiscount.Amount; discountAmount.Save(Connection, Transaction); } } if (Parameter.SaveNaturalRabatForAllPos) { foreach (var currentPosID in positionIDs) { if (currentPosID != Parameter.PositionID) { var posDiscounts = ORM_LOG_RCP_Receipt_Position_DiscountAmount.Query.Search(Connection, Transaction, new ORM_LOG_RCP_Receipt_Position_DiscountAmount.Query { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, LOG_RCP_Receipt_Position_RefID = currentPosID } ).ToArray(); //Preload discount types and choose those that are applying to stock reciept positions var discountTypesPar = new P_L2DT_GDTfGPMIL_1546(); discountTypesPar.GlobalPropertyMatchingID_List = new string[] { EnumUtils.GetEnumDescription(EDiscountType.NaturalDiscount) }; var discNaturalType = cls_Get_DiscountTypes_for_GlobalPropertyMatchingID_List.Invoke(Connection, Transaction, discountTypesPar, securityTicket).Result; ORM_LOG_RCP_Receipt_Position_DiscountAmount discountNatural = null; foreach (var item in discNaturalType) { var paramDiscount = Parameter.PositionDiscounts.SingleOrDefault(x => x.DiscountTypeID == discNaturalType.First().ORD_PRC_DiscountTypeID); if (paramDiscount == null) { continue; } discountNatural = posDiscounts.SingleOrDefault(x => x.ORD_PRC_DiscountType_RefID == discNaturalType.First().ORD_PRC_DiscountTypeID); if (discountNatural == null) { discountNatural = new ORM_LOG_RCP_Receipt_Position_DiscountAmount { LOG_RCP_Receipt_Position_DiscountAmountID = Guid.NewGuid(), ORD_PRC_DiscountType_RefID = item.ORD_PRC_DiscountTypeID, LOG_RCP_Receipt_Position_RefID = currentPosID, Tenant_RefID = securityTicket.TenantID, Creation_Timestamp = DateTime.Now, IsDeleted = false }; } discountNatural.PositionDiscountValue = paramDiscount.Amount; discountNatural.Save(Connection, Transaction); } } } } //just forwarding the input value returnValue.Result = Parameter.PositionID; return(returnValue); #endregion UserCode }