How to deactivate the user account

Question

5.00/5 (1 vote)

See more:

SQL

Hi,
In my project i need to inactive the users when their subscription plan gets expired. How can I achieve this? Any idea on this?
For Example User 1's  Plan is for 6 months Started from Started on:6/6/2012 after 6 months 6/12/2012 i need to[B] inactive [/B] this user.

Posted 10-Dec-12 18:10pm

sahmed4

Updated 10-Dec-12 19:27pm

AnkitGoel.com

v2

Add a Solution

6 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

nagalkumar · Answer 1 · 2012-12-10T18:35:00

Hi,

You can use the following code to know whether the user's account has expired or not?

DateTime createddate = Convert.ToDateTime(createddate);
            DateTime currenctdate = DateTime.Now;
            TimeSpan t = currenctdate.Subtract(createddate);
            int numberofdays = Convert.ToInt32(t.TotalDays);
            if (numberofdays <= howmanydays(month store at days))
            {
            }

sahmed4 · Answer 2 · 2012-12-10T20:09:00

Hi i have created my Trigger in this way...now how can i able to view my results by running application...
[CODE]create trigger tr_InactiveUsers
on aspnet_membership
for insert
as
begin
update asp_mem
set
IsApproved='0'
from
aspnet_membership asp_mem
join
planmapping pm
on
pm.accountexpiry=getdate()
end[/CODE]

Is this Correct? if not please help it...accordingly..
I have aspnetmembership one table and planmapping another table base on the value of acccountexpiry on planmapping table i need to update IsApproved='1' in aspnet_membership table...
I hope it clears...

nagalkumar · Answer 3 · 2012-12-10T18:16:00

Solution 1

Hi,
Each and every login check the subscription plan with created date & current date

subtract the created date with current date and check the month

Posted 10-Dec-12 18:16pm

nagalkumar

sahmed4 · Answer 4 · 2012-12-10T18:27:00

Solution 2

it would be better if u give me with soln...

Posted 10-Dec-12 18:27pm

sahmed4

sahmed4 · Answer 5 · 2012-12-10T19:24:00

Hi nagalkumar,
I have a table with field of Started Date and Expiration date of user plan's in Months.
If user has started a plan for 2 months...
Started Date:1/10/2012
Expiration Date :30/11/2012
here i need to change the status of ISAPPROVED column of the specific user on the expiration days gets elapsed
here i need to implement a trigger like SQL jobs to inactive the user..Please i need a code i am new to this concept...

nagalkumar · Answer 6 · 2012-12-10T19:37:00

Solution 5

Hi sahmed

Add the following query to your trigger or sql job to update ISAPPROVED column.

update table_name set ISAPPROVED='N' where Expiration_Date=getdate()

Posted 10-Dec-12 19:37pm

nagalkumar

Comments

Erik Rude 11-Dec-12 5:35am

In principle a good ide, but the implementation means that the user will be allowed if the trigger is not run on the day when the software expires. Better to say in Expiration <= the current date.