Expiring User Accounts

Posted by Self-Innovator under ASP.NET on 12/7/2012 | Points: 10 | Views : 1565 | Status : [Member] | Replies : 5

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

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

0	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

0	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

0	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

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

Latest Posts