Expiring User Accounts

Posted by Self-Innovator under ASP.NET on 12/7/2012 | Points: 10 | Views : 734 | Status : [Member] | Replies : 5
Hi All,
I have a scenario in where i need to expire the users registered account after a specific amount of time(Ex: After 1 Month).
How to achieve this please reply.

Join Hands Change lives
Thanks & Regards
Straight Edge Society



Responses

Posted by: Pavanandey on: 12/7/2012 [Member] Bronze | Points: 25

Up
0
Down
if you have kept the user data in the database you can maintain a coloum with user status which can be used to make the user active\inactive based up on the date

Thanks
Pavan Kumar
Mark Answer if this fits the need

Self-Innovator, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Self-Innovator on: 12/7/2012 [Member] Bronze | Points: 25

Up
0
Down
hi pavan,
i'm maintaining all registered user acc in a DB. I need a logic to calculate calendar date's for the next 30 days (if the users is for 1 month plan) share me if u have the answers.I will make it as inactive after the specified amount gets elapsed.

Join Hands Change lives
Thanks & Regards
Straight Edge Society

Self-Innovator, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Pavanandey on: 12/7/2012 [Member] Bronze | Points: 25

Up
0
Down
SELECT DATEDIFF(day,'2008-12-05','2008-11-07') AS DiffDate

u can use the above query and find the no of days, from this you can acheive your goal.
since it has to be done automatically make a trigger on the same table

Thanks
Pavan Kumar
Mark Answer if this fits the need

Self-Innovator, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Pavanandey on: 12/7/2012 [Member] Bronze | Points: 25

Up
0
Down
Plz Mark the answer if it helps

Thanks
Pavan Kumar
Mark Answer if this fits the need

Self-Innovator, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sudeesh.Govind on: 12/7/2012 [Member] Starter | Points: 25

Up
0
Down

Put 2 field in the table int he user table. 1 for storing date and 1 for storing status.
when create the user account insert the date and status is true.
after some days- check todays date and date stored in the user table and if the diffrence is greater than a particular time period change the status false.

learn and earn

Self-Innovator, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response