change password in asp.net using Entity Framework

Question

Can someone help me... how do I implement change password firstly it checks old password matches and then update new password in database in asp.net Using entity Framework.. below is my design code.. class = "col-md-12 col-sm-12 col-xs-12 user-login-box" > class = "style1" > Current Password: "TxtCrntPswd" runat= "server" > New Password: "TxtNwPswd" runat= "server" > Confirm New Password: "TxtCnPswd" runat= "server" > "BtnPswd" runat= "server" Text= "Save" OnClick= "BtnPswd_Click" /> "lbl_msg" Font-Bold= "True" BackColor= "#FFFF66" ForeColor= "#FF3300" runat= "server" Text= "" > "HyperLink1" runat= "server" NavigateUrl= "~/Profile.aspx" >Login

Varun Setia · 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.. }

Guest User · Answer

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

Guest User · Answer

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

Guest User · Answer

hi Varun Setia.. so sorry my system crashed...now i fixed it...

Guest User · Answer

no. flow of if else condition is not working

Varun Setia · Answer

Ok what is the execution flow, is it going inside if or else statement, you can check that while debugging

Guest User · Answer

Yes...same in databse.

Varun Setia · Answer

If userEntity is not empty, then it should update value in database on context.SaveChanges(). Is it same in database ?

Guest User · Answer

Yes. i am getting all the variables while i do debugging

Varun Setia · Answer

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.

Varun Setia · Answer

Hi Nivi, is it resolved ? Should we look into it more ?

Varun Setia · Answer

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();

Varun Setia · Answer

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

Varun Setia · Answer

Please check the entity created for user details you will find the password field created with the name defined by you :)

Guest User · Answer

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();

Guest User · Answer

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

Varun Setia · Answer

Use this inside BtnPswd_Click that must be present in code behind file

Guest User · Answer

hi Varun Setia can i do this on Page load or button click

Darshan Shah · Answer

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.

Guest User · Answer

Yes...!

Varun Setia · Answer

Hi, are you storing password as plain text?