Form Authentication in mvc4 using c#

Question

hi i am doing my web project in mvc4 using c#. Now i am creating a login page. The folowing code i have used.User id and password is in sql database table

View

@using (Html.BeginForm())
{
    @Html.LabelFor(model => model.Mem_Email)

    @Html.EditorFor(model => model.Mem_Email)
    @Html.ValidationMessageFor(model => model.Mem_Email)

    @Html.LabelFor(model => model.Mem_PWD)

    @Html.EditorFor(model => model.Mem_PWD)
    @Html.ValidationMessageFor(model => model.Mem_PWD)

    <input type="submit" value="Log In" />
}

Controller

public ViewResult Login()
{
    return View();
}

[HttpPost]
public RedirectResult Login(FormCollection form)
{
    string uid = Request.Form["Log_email"];
    string pwd = Request.Form["Log_pwd"];
    bool IsUser=new Member().GetLogin(uid,pwd);
    if (IsUser == true)
    {
        System.Web.Security.FormsAuthentication.SetAuthCookie(uid, true);
        return Redirect("~/Member/MemberHome");
    }
    else 
        return Redirect("~/Member/Login");
}

model

 public bool GetLogin(string email,string pwd)
 {
     bool IsUser = false;
     using (SqlConnection con = new SqlConnection(Config.ConnectionString))
     {
         using (SqlCommand cmd = new SqlCommand(
             "SELECT COUNT (*) FROM Mem_Register WHERE Mem_Email='" + 
             email + "' AND Mem_PWD='" + pwd + "'", con))
         {
             con.Open();
             int count = (int)cmd.ExecuteScalar();
             if (count == 1)
             {   IsUser = true;   }
         }
     }
     return IsUser;      
 }

This is not working .the content in the form are not passed to controller. i dont know is this the right way to login a user. Please help me.

Erik Funkenbusch · Accepted Answer · 2013-08-28 07:27:22Z

2

First, you shouldn't be using a FormCollection. Since you are using a strongly typed model, you should be posting that model to your action.

Second, you are using the names Mem_Email and Mem_PWD in your view, but you are looking for FormCollection values of Log_email and Log_pwd, which you wouldn't find.

answered Aug 28, 2013 at 7:27

Erik Funkenbusch

93.7k29 gold badges201 silver badges292 bronze badges

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

Comments

Erik Funkenbusch · Accepted Answer · 2013-08-28 07:30:52Z

0

Use this code in View

@using (Html.BeginForm())
{
  <div>
    <fieldset>
        <legend>Login</legend>

            @Html.LabelFor(u => u.Email)

           @Html.TextBoxFor(u => u.Email)
            @Html.ValidationMessageFor(u => u.UserName)

            @Html.LabelFor(u => u.Password)

            @Html.PasswordFor(u => u.Password)
            @Html.ValidationMessageFor(u => u.Password)


        <input type="submit" value="Log In" />
    </fieldset>
  </div>
}

edited Aug 28, 2013 at 7:30

Erik Funkenbusch

93.7k29 gold badges201 silver badges292 bronze badges

answered Aug 28, 2013 at 6:54

Shyam sundar shah

2,5331 gold badge27 silver badges44 bronze badges

3 Comments

neel Over a year ago

i am using this. but got in controller uid and password are null

neel Over a year ago

i got it but one more doubt i have . i want redirect memberhome action alfter login. till the login how can i block the access of that page

Erik Funkenbusch Over a year ago

Your ValidationMessage is using the wrong name, it's also using the completely wrong property names, since they don't match his model.

Shiva Saurabh · Accepted Answer · 2014-02-04 08:06:56Z

0

the solution given by @Erik is right you are using different naming convention in the controller. you must use the same Form value that of in a view

[HttpPost]
public RedirectResult Login(FormCollection form)
{
string uid = Request.Form["Mem_Email"];
string pwd = Request.Form["Mem_Email"];
bool IsUser=new Member().GetLogin(uid,pwd);
if (IsUser == true)
{
    System.Web.Security.FormsAuthentication.SetAuthCookie(uid, true);
    return Redirect("~/Member/MemberHome");
}
else 
    return Redirect("~/Member/Login");
}

with the earlier one you used ie Log_email and Log_pwd you will get null values in the controller.

answered Feb 4, 2014 at 8:06

Shiva Saurabh

1,2892 gold badges26 silver badges47 bronze badges

Collectives™ on Stack Overflow

Form Authentication in mvc4 using c#

View

Controller

model

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

View

Controller

model

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related