Log in process using entity framework asp.net mvc

Question

I want to have log in password verification in my project.when user clicks on the log in button compiler goes to this method

public ActionResult VerifyPassword(User user)
{
    var givenPassword =user.Password;
    var givenUserName=user.UserName;
//now i need compare password 
    var myUser=db.User.Find(somevalue)//find user from database,
    But how can i do this????Because somevalue needs to be a Primary Key

}

If i am doing something wrong.Please point me into right direction I searched a lot on the Web.But no tutorial was found to accomplish this using entity framework.

What are you trying to do? Is this for changing a user's password? — WannaCSharp
– WannaCSharp, Commented Sep 1, 2013 at 7:14
You should probably just use the built-in membership system, since it's almost guaranteed you will do this in an insecure manner (even people who should know better typically do it insecurely). — Erik Funkenbusch
– Erik Funkenbusch, Commented Sep 1, 2013 at 7:29

keeehlan · Accepted Answer · 2013-09-02 03:39:52Z

12

You actually don't need a primary key to match a user in your database.

You can use their username (which should be unique) to locate their record in the database.

Try something like this:

public ActionResult VerifyPassword(User user)
{
    //The ".FirstOrDefault()" method will return either the first matched
    //result or null
    var myUser = db.Users
        .FirstOrDefault(u => u.Username == user.Username 
                     && u.Password == user.Password);

    if(myUser != null)    //User was found
    {
        //Proceed with your login process...
    }
    else    //User was not found
    {
        //Do something to let them know that their credentials were not valid
    }
}

Also consider doing a bit of research on Model validation, looking into ModelState.IsValid is a great start.

edited Sep 2, 2013 at 3:39

answered Sep 1, 2013 at 7:21

keeehlan

8,06416 gold badges61 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Thilina H · Accepted Answer · 2013-09-01 10:18:02Z

0

It should be modified like this...

public ActionResult VerifyPassword(User user)
        {
            //The ".FirstOrDefault()" method will return either the first matched
            //result or null
            User myUser = dbContext.Users.FirstOrDefault
                (u => u.Username.Equals(user.Username) && u.Password.Equals(user.Password));

            if (myUser != null)   
            {
                //User was found
                //Proceed with your login process...
            }
            else    //User was not found
            {
                //Do something to let them know that their credentials were not valid
            }
        }

answered Sep 1, 2013 at 10:18

Thilina H

5,8267 gold badges28 silver badges56 bronze badges

1 Comment

Thilina H Over a year ago

you should compare with with retrieved user object weather it is null or not. So use myUser instead of using user in if clause

Sanyog Keshri · Accepted Answer · 2015-06-25 04:56:32Z

    public ActionResult Login(StudentLogin sl)
    {
        if (sl.Email != null)
        {

            if (ModelState.IsValid) // this is check validity
            {
                StudentEntities1 se = new StudentEntities1();
                var v = se.StudentLogins.Where(a => a.Email.Equals(sl.Email) && a.Password.Equals(sl.Password)).FirstOrDefault();

                if (v != null)
                {
                    Session["LogedUserID"] = v.Id.ToString();
                    //Session["LogedUserFullname"] = v.FullName.ToString();
                    return RedirectToAction("Success", "Student");
                }

            }
            return View(sl);
        }
        else
        {
            return View();
        }
    }

vishnu · Accepted Answer · 2022-07-23 04:10:03Z

0

public ActionResult Login(Login_T l)
    {
        using (AppHREntities db = new AppHREntities())
        {
            var obj = db.Login_T.Where(a => a.UserName.Equals(l.UserName) && a.Password.Equals(l.Password) && l.Type.Equals("HR")).Count();
            var obj1 = db.Login_T.Where(a => a.UserName.Equals(l.UserName) && a.Password.Equals(l.Password) && l.Type.Equals("USER")).Count();
            if (obj > 0)
            {
                MessageBox.Show("SUCESSFULLY LOGGED IN.");
                return RedirectToAction("../Home/HR_Dashboard");
            }
            else if(obj1 > 0)
            {
                MessageBox.Show("SUCESSFULLY LOGGED IN.");
                return RedirectToAction("../Home/Emp_Dashboard");
            }
            else
            {
                MessageBox.Show("WRONG PASSWORD.");
                return RedirectToAction("Index");
            }
        }
    }

answered Jul 23, 2022 at 4:10

vishnu

1

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Log in process using entity framework asp.net mvc

4 Answers 4

Comments

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related