expire User in c# in 7 days

Question

5.00/5 (1 vote)

See more:

How I do this , I want to expire User that have joining date If he not visited our company in 7 days then he will be expired.....
PLZ tell me .... thanks in advance

C#

public bool CheckExpireUser(int UserId)
{
DateTime joingDte= MRB.get_JoingDate(UserId);
DateTime expireUsr = joingDte.AddDays(7);

if (expireUsr<=DateTime.Now)
{
    return true;
}
else
{
    MRB.Expire_Reg_Code(UserId); //EXPIRE USER ID CODE
    return false;

}

Posted 19-Nov-13 23:28pm

kashifjaat

Updated 19-Nov-13 23:32pm

Tom Marvolo Riddle

v2

Add a Solution

Comments

adityasahver 20-Nov-13 5:33am

what is meant by expire over here.. are you deleting the user from the database, or setting some Expire flag to True or something?

kashifjaat 20-Nov-13 5:44am

No, Just want to Expire his status

3 solutions

Solution 1

Here at CodeProject you may find many articles on making 'trial version'[^] of your software.

Posted 19-Nov-13 23:35pm

CPallini

Solution 3

Exactly, as Nicholas has already suggested.
Create a new column, say UserLastLogin, and every time the user logs in Update that column's value.
And then you can create a batch job where you will be checking the UserLastLogin with the current date, if the difference is more then 7 days(in this case) we can delete the UserRecord from the table or set the Expire flag as True.

Posted 19-Nov-13 23:43pm

adityasahver

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)

Nicholas Marty · Accepted Answer · 2013-11-19T23:38:00

Solution 2

It's unlikely that you want to check for the "joiningDate" as this is a value that should probably never change.

I'd probably add another field in the database like "lastVisitDate" and update this field each time the user loggs in. You can then modify that piece of code to check if the lastVisitDate is older than 1 week ago.

Posted 19-Nov-13 23:38pm

Nicholas Marty

Comments

kashifjaat 20-Nov-13 5:46am

I don't want to change the value of joining date I want jo add 7 days in joing days in local variable and if return false then change his status

kashifjaat 20-Nov-13 5:49am

and I don't want create New field in DB.

Nicholas Marty 20-Nov-13 5:57am

I'm not sure if I understand correctly. You want every user to expire after 7 days? If so where are you experiencing any issues? (I was probably more focussed on the "If he not visited our company in 7 days" part. you need to store when his last visit was otherwise it will be a bit difficult to know when his last visit was ;) )