Loading

enter data in sql by time duration

ajay chauhan

Hello to all,

I am beginner dotnet developer using c#.

i create a website in the i am getting issue.

question -

when user login there account, he/she can register 2 more user on portal with there reference id and main user get points for that but it should be add both in 12 hour. if he add only 1 user then no point in 12 hour and other user in 2nd 12 hours.

how can i do this in asp.net c#?

Please help & thanks in advance.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo6y ago
hi
1- In user table add a field usercount int type and createteddate datetime.
2-point table defined
2- A background process run that check every 5 second or 2 sec
i- retrive all users created before 12 hours in between current time and createddate
ii- check which user field usercount is 2 , this field updated when create the user at login time