change password in asp.net using Entity Framework

C# Corner

21 Replies

Know the answer? Post it — somebody with the same question will find it here.

Varun Setia6y ago
Accepted answer
The solution will be something like this assuming username exists in session or you can change the value as per your needs.
var currPass = TxtCrntPswd.Text;
            var newPass = TxtNwPswd.Text;
            var rePass = TxtCnPswd.Text;
            var userName = Session["UserName"] //Assuming User from session

            var userEntity = (from user in .User
                             where user.Username.Equals(userName)
                             && user.Password.Equals(currPass)
                             select user).FirstOrDefault();

            if (userEntity!=null && newPass.Equals(rePass)) {
                userEntity.Password = newPass;
                .SaveChanges();
            }
            else
            {
                //Fail Logic..
            }
+1
Guest User6y ago
hi Varun..
protected void BtnPswd_Click(object sender, EventArgs e)
{
using (var context = new WallpaperEntities4())
{
var currPass = TxtCrntPswd.Text;
var newPass = TxtNwPswd.Text;
var rePass = TxtCnPswd.Text;
string UserName = Convert.ToString(Session["UserName"]);
User userEntity = (from x in context.Users
where x.UserName == UserName
&& x.Password == currPass
select x).FirstOrDefault();
if (userEntity != null )
{
userEntity.Password = TxtNwPswd.Text;

context.SaveChanges();
}
else
{
lbl_msg.Text = "username or pass is incorrxx";
//Fail Logic..
}

This thing is working...

Thanx a ton... fr helping me out
+2
Guest User6y ago
no. flow of if else condition is not working
+1
Varun Setia6y ago
Ok what is the execution flow, is it going inside if or else statement, you can check that while debugging
+1
Guest User6y ago
Yes...same in databse.
+1
Varun Setia6y ago
If userEntity is not empty, then it should update value in database on context.SaveChanges(). Is it same in database ?
+1
Guest User6y ago
Yes.
i am getting all the variables while i do debugging
+1
Varun Setia6y ago
Ok, please check while debugging that you are getting all the required values in variables that you are using. Please let me know so that we can proceed further.
+1
Guest User6y ago
hi
Varun Setia

protected void BtnPswd_Click(object sender, EventArgs e)
{
using (var context = new WallpaperEntities4())
{
var currPass = TxtCrntPswd.Text;
var newPass = TxtNwPswd.Text;
var rePass = TxtCnPswd.Text;
var userName = Session["UserName"].ToString();
var userEntity = (from x in context.Users
where x.UserName == userName
&& x.Password == currPass
select x).FirstOrDefault();
if (userEntity != null && newPass.Equals(rePass))
{
userEntity.Password = TxtCrntPswd.Text;

context.SaveChanges();
}
else
{
lbl_msg.Text = "username or pass is incorrxx";
//Fail Logic..
}

this is what i try to do..now its not showing any error and also not update new password. i also tryed break point so that show any error but seems nothing... can u help mme out
+2
Guest User6y ago
hi
Varun Setia..
so sorry my system crashed...now i fixed it...
+2
Varun Setia6y ago
Hi Nivi, is it resolved ? Should we look into it more ?
+1
Varun Setia6y ago
The issue might be with equality comparsion, try this too..

var userEntity = (from x in context.Users
where x.UserName==userName
&& x.Password==currPass
select x).FirstOrDefault();
+1
Varun Setia6y ago
Try this,

var userEntity = (from x in context.Users
where x.UserName.Equals(userName)
&& x.Password.Equals(currPass)
select x).FirstOrDefault();

Also, share your Users Entity, username and password fields
+1
Varun Setia6y ago
Please check the entity created for user details you will find the password field created with the name defined by you :)
+1
Guest User6y ago
hi Varun

in query it shows an exception.

"Unable to create a constant value of type 'System.Object'. Only primitive types or enumeration types are supported in this context."

var userEntity = (from x in context.Users
where x.UserName.Equals(userName)
&& x.Password.Equals(currPass)
select x.UserName).FirstOrDefault();
+1
Guest User6y ago
hi

Varun Setia

It shows me this error..

"'string' does not contain a definition for 'Password' and no extension method 'Password' accepting a first argument of type 'string' could be found (are you missing a using directive or an assembly reference?)"

At

if (userEntity != null && newPass.Equals(rePass))

{

userEntity.Password = newPass;

context.SaveChanges();

}

else

+1
Varun Setia6y ago
Use this inside BtnPswd_Click that must be present in code behind file
+1
Guest User6y ago
hi
Varun Setia

can i do this on Page load or button click
+1
Darshan Shah6y ago
You can do this by creating simple one stored procedure and add that stored procedure to Entity Framework using import function. So in single call you can perform 2 things. First check old password and if all goes well with the old password then update new password.
+1
Guest User6y ago
Yes...!
0
Varun Setia6y ago
Hi, are you storing password as plain text?
0