Simple Login Application using Sessions in ASP.NET MVC

Jaipal Reddy
1y
1.7m
0
41

100

Article

MvcLoginAppDemo.zip

Introduction

This article explains the following

How to create an ASP.NET MVC Project
How to Add ADO.NET Entity Data Model
How to Add a Controller
How to validate User Credentials
How to keep User Details in Sessions and display them in the User Dashboard

1. Design your Database

Create the UserProfile table using the following script.

CREATE TABLE UserProfile
(
    UserId INT PRIMARY KEY IDENTITY(1, 1),
    UserName VARCHAR(50),
    Password VARCHAR(50),
    IsActive BIT
);

Insert user records using the following script.

INSERT INTO UserProfile (UserName, Password, IsActive)
VALUES ('jaipal', 'jai1234', 1),
       ('praveen', 'praveen1234', 1),
       ('pruthvi', 'pruthvi1234', 1);

2. Create Project

Go to File, New, then click on Project.

create project

Select Visual C#, Web under Installed templates. After that, select ASP.NET MVC 4 Web Application, then mention the Application Name (MvcLoginAppDemo) and Solution Name as you wish, then click OK.

ASP.NET MVC 4 Web Application

Under Project template, select a template as Basic, then view the engine as Razor. Click OK.

select a template as Basic

3. Add Entity Data Model

Go to Solution Explorer, right-click on Project, Add, then select ADO.NET Entity Data Model.

select ADO.NET Entity Data Model

Give it a meaningful model name, and then click on Add.

sampleDataModel

Select Generate from the database and then click on Next.

Generate from database

Click on New Connection.

New Connection

After clicking on New Connection, we have to provide the following Connection Properties in the following wizard.

Provide the Server name.
Select the "Use SQL Server Authentication" radio button.
Enter the Username and Password in the password text box.
Check the "Save my password" checkbox.
Select the "Select or enter a database name:" radio button.
Select the database to which you want to set the connection.
Click on the "Test Connection" button to ensure the connection can be established.
Then click OK.

Test Connection

Select the radio button, and yes, include the sensitive data in the connection string.

Choose your data connection

Choose your database objects, as in the following image.

Choose your database objects

Click on Finish. At this point UserProfie entity will be created.

UserProfie

4. Add a Controller

Go to Solution Explorer, right-click on the Controller folder, Add, and then click on Controller.

( Or ) Simply use shortcut key Ctrl + M, Ctrl + C,

Add a Controller

Provide the Controller Name and Scaffolding template as Empty MVC Controller. Then click on Add.

Empty MVC Controller

Write the following code in HomeController.

using System.Linq;
using System.Web.Mvc;

namespace MvcLoginAppDemo.Controllers
{
    public class HomeController : Controller
    {
        public ActionResult Login()
        {
            return View();
        }

        [HttpPost]
        [ValidateAntiForgeryToken]
        public ActionResult Login(UserProfile objUser)
        {
            if (ModelState.IsValid)
            {
                using (DB_Entities db = new DB_Entities())
                {
                    var obj = db.UserProfiles.Where(a => a.UserName.Equals(objUser.UserName) && a.Password.Equals(objUser.Password)).FirstOrDefault();
                    if (obj != null)
                    {
                        Session["UserID"] = obj.UserId.ToString();
                        Session["UserName"] = obj.UserName.ToString();
                        return RedirectToAction("UserDashBoard");
                    }
                }
            }
            return View(objUser);
        }

        public ActionResult UserDashBoard()
        {
            if (Session["UserID"] != null)
            {
                return View();
            }
            else
            {
                return RedirectToAction("Login");
            }
        }
    }
}

5. Create Views

Create View for Login Action Method

Right-click on the Login Action method, then click on Add View, as in the following picture.

Create Views

Create a Strongly Typed View

View Name must be an action method name.
Select the view engine as Razor.
Select Create a strongly typed view CheckBox.
Select Model class as UserProfile (MvcLoginAppDemo)
Select the Scaffold template as Empty
Click on Add

add view

Write the following code in Login.cshtml (view).

@model MvcLoginAppDemo.UserProfile

@{
    ViewBag.Title = "Login";
}

@using (Html.BeginForm("Login", "Home", FormMethod.Post))
{
    <fieldset>
        <legend>Mvc Simple Login Application Demo</legend>

        @Html.AntiForgeryToken()
        @Html.ValidationSummary(true)

        @if (ViewBag.Message != null)
        {
            <p style="border: 1px solid red">
                @ViewBag.Message
            </p>
        }

        <table>
            <tr>
                <td>@Html.LabelFor(a => a.UserName)</td>
                <td>@Html.TextBoxFor(a => a.UserName)</td>
                <td>@Html.ValidationMessageFor(a => a.UserName)</td>
            </tr>
            <tr>
                <td>@Html.LabelFor(a => a.Password)</td>
                <td>@Html.PasswordFor(a => a.Password)</td>
                <td>@Html.ValidationMessageFor(a => a.Password)</td>
            </tr>
            <tr>
                <td></td>
                <td><input type="submit" value="Login" /></td>
                <td></td>
            </tr>
        </table>
    </fieldset>
}

Create View for UserDashBoard Action method same as login view. And write the following code in UserDashBoard.cshtml (View).

@{
    ViewBag.Title = "UserDashboard";
}

<fieldset>
    <legend>User Dashboard</legend>

    @if (Session["UserName"] != null)
    {
        <text>Welcome @Session["UserName"].ToString()</text>
    }
</fieldset>