I am building an E-Commerce Application with Asp.net core MVC.
Order Model is build and when a user add an order it is created and saved in the DB.
But I want to add the following functionality that when a user places an order, the status is set to pending, and then after 2 days from placing the order, it changes to shipped, and after 4 days from placing the order it changes to be Delivered and then removed from the DB.
how can I implement this kind of action ?