Hey guys,

I've created an application using MVC Core 2.0 that allows users to sign up and create an account. The website is hosted by Azure and uses entity framework for the ORM.

 

When a user creates an account, they are assigned one random number per a week (10 weeks). The table for the numbers in the DB looks something like this:

(table below has had two users sign up, and only showing the first two weeks)

 

NumberToSend	week	User'sEmail	IsCompleted
123	1	user1@user1.com	0
170	1	user2@user2.com	0
135	2	user1@user1.com	0
183	2	user2@user2.com	0

 

I was wondering the best way to go about sending each user their number by a week by week case. I can use LINQ fine to get the numbers sorted, I need ideas on the best way to do it on the server side (actual sending of the emails), any help would be greatly appreciated.

I'm unsure if this is against the sub rules, but more than happy to donate money through PayPal for any help received.

 

Cheers!