{
"$type": "Foundation.Commerce.PaymentsDataTest.Engine.Policies.OrderNumberPolicy, Foundation.Commerce.PaymentsData.Engine",
"TestStoredProcedureName": "[dbo].[Test_GetNextOrderNumber]",
"TestOrderNumberPrefix": "W",
"TestDisableReGenerateOrderNumber": true
},
public class OrderNumberPolicy : Policy
{
///
/// Stored procedure Inserting OrderNumber
///
public string TestStoredProcedureName { get; set; }
///
/// Prefix for Order Number
///
public string TestOrderNumberPrefix { get; set; }
///
/// Gets or sets a value indicating whether [disable re generate order number].
///
///
/// true if [disable re generate order number]; otherwise, false .
///
public bool TestDisableReGenerateOrderNumber { get; set; }
}
public override async TaskRun(Cart cart, CommercePipelineExecutionContext context) { try { TestOrderNumberPolicy ObjorderNumberPolicy = context.GetPolicy (); TestorderNumberComponent.OrderNumber = _customComponent.GetNextOrderNumber(context.CommerceContext, orderNumberPolicy.TestStoredProcedureName, orderNumberPolicy.TestOrderNumberPrefix); } catch (Exception e) { } return cart; }
USE [Test.Website.CustomDetails]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Test.OrderNumberSequencer](
[Id] [bigint] IDENTITY(10000000,1) NOT NULL,
CONSTRAINT [PK_Test_Sequence_OrderNumber] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
USE [Test.Website.CustomDetails]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Test.OrderNumberSequencer](
[Id] [bigint] IDENTITY(10000000,1) NOT NULL,
CONSTRAINT [PK_Test_Sequence_OrderNumber] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
G
Steps 1 – exec [dbo].[Test.OrderNumberSequencer] to check the current number
Step 2 – Run this script to update the sequence
SET IDENTITY_INSERT dbo.Test.OrderNumberSequencer ON
GO
-- Insert the record which you want to update with new value in identity column
INSERT INTO Test.OrderNumberSequencerId (Id) VALUES(300000)
GO
--Now set the idenetity_insert OFF to back to prevoius track
SET IDENTITY_INSERT Test.OrderNumberSequencerId OFF
Steps 3 Run this sp to see the current number - exec [dbo].[Test.OrderNumberSequencer] - Please take a note of that number
Recently, I was adding a check for order by and found this issue.
It was because of I put the order by field as Item["FieldName"] it should be on value like Item["FieldName"].value
