Displaying Message to user for Password Expire.( if the password Expired)

Question

0.00/5 (No votes)

See more:

Dear Friends,

Am working on Asp.net , c#, SQLSERVER 2005.

In my project, A message must be displayed to user if his password expires.

I have a Registration(Add new user) webform in my project. in that i have fields
Firstname, Lastname,DisplayName,Username,Password,IssueDate,ExpiryDate.

While creating New User, Administrator will enter all information of user FN,LN,DN,Username,Pwd,IssueDate,ExpDate.

Generally the issue date will be default like this 19/07/2012(System date) and the admin need to enter only Expiry year like this 2013.

Suppose, if the user passed the year 2013. a message must be displayed while login
"your Password has Expired, Please contact Administrator"

Please help me , how to solve this.

Thanks in ADVANCE.

Posted 18-Jul-12 21:30pm

Ranjith Reddy CSE

Add a Solution

3 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)

Sandeep Mewara · Answer 1 · 2012-07-18T22:32:00

Solution 2

Let's say for each user you have a expiry year defined.

You need to fetch the expiry year for a user and compare with today's date's year. If they match then the password has expired and you need to show the prompt.

SQL

SELECT UserID
FROM User
WHERE ExpiryYear >= DATEPART(year,GETDATE())
AND UserID = @currentLoggedInUser

If any data is returned from the query then that user password has expired.

Posted 18-Jul-12 22:32pm

Sandeep Mewara

Comments

sandeep nagabhairava 19-Jul-12 4:34am

good work sandeep my 5!

Sandeep Mewara 19-Jul-12 4:38am

Thanks.

sandeep nagabhairava 19-Jul-12 4:40am

hoo.. unfortunately i for got it... hold this...

Ghost Leader · Answer 2 · 2012-07-18T21:59:00

Solution 1

you will do a query like this

select 1 from your table where userid= <your userid=""> and getdate = <password expiry="" date="" field="">

if it satisfies 1 will be returned then pass word is expired.

Posted 18-Jul-12 21:59pm

Ghost Leader

Comments

Ranjith Reddy CSE 19-Jul-12 4:04am

am not clear, what is 1. Please explain me boss.
Explain me in detail

Thanks

Ranjith Reddy CSE 19-Jul-12 4:08am

Suppose if the Users Expiry date is less than todays date. It must display a message like this.

"Your Password has Expired,Please contact administrator"

Thanks , Please help me brothers.

sandeep nagabhairava · Answer 3 · 2012-07-18T22:33:00

hi ranjit

You try like this i am, showing in 2tier format for just understanding purpose,

bring Expiry date from Database
ex:

SQL

Select Max(ExpiryDate) from TABLE where Username='"+txtusername+"' and Password='"+txtpassword+"'

C#

cn.Open();
Datetime ExpDate;
              dr = cmd.ExecuteReader();

              if (dr.Read() == true)
              {

                ExpDate=convert.todatetime( dr[0].ToString());
              }
              cn.Close();
if(ExpDate<datetime.now.year)>
{
//Show your msg hear
}
else
{
//write yor code hear
}

i hope this will helps you

Thanks&&Regards
Sandeep